We keep having a problem with our B-TREE INDEX that says
ERROR IN B-TREE INDEX
Can anybody help me out.
Windows 2000, Universe 10.0
Regards
Björn Behr
Programmer
HYFLO Southern Africa (Pty) Ltd
Tel : +27 11 386 5800
Fax :
Hey,
Can someone please answer some questions as i am unsure on some database
types.
Whats the difference between DB2 and UniVerse/UniData?
Are they the same sort of structure?
Can you do a DB2 course and be qualified enough to use UniVerse?
Any other information or websites on this sort of
You could add gethostbyname() as a GCI subroutine. Take a look at getpid() as a
template (in the UV account, LIST GCI).
- Original Message -
From: Craig Bennett [EMAIL PROTECTED]
Date: Fri, 30 Apr 2004 15:34:06 +1000
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Name
Ah, the well-known helpful error message. Not.
What happens when you use these commands?
LIST.INDEX filename
LIST.INDEX filename STATS
LIST.INDEX filename DETAIL
Can you examine the INDEX.000 file (assuming it's that one) with uvfixfile or blook?
- Original Message -
From: Björn Behr
DB2 is the original, proprietary IBM first normal form database product. IBM now
prefers to call it DB2 UDB, where the UDB stands for universal database.
Since acquiring all of the databases, including UniVerse and UniData, from Informix in
2001, IBM have also used the term DB2 to refer
Will be watching you all on the other side
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Malcolm Bull has provided a chart on his web site of the
codes for multiple multivalue databases. Have a look at
http://members.aol.com/mbtexts/93.html
Ron White
- Original Message -
From: Dennis Bartlett [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Sent:
Good Morning All,
We currently have UniData 5.13.. and use UniODBC. We
are planing to move on to UniData 6.0 on UNIX and
would like to know whether it comes with JDBC? If so,
does it work with any earlier version than UniData
6.0?
Thanks
Fawaz
I understand how Unibasic could handle a list that has been merged, but how
would you do a Uniquery statement?
for example:
SELECT ORDER.FILE WITH DATE 1/1/2004
SAVE-LIST LIST1
SELECT ORDER.FILE.OTHER WITH DATE 1/1/2004
SAVE-LIST LIST2
GET-LIST LIST1 TO 1
GET-LIST LIST2 TO 2
MERGE.LIST 1
My suggestion is to create a V type dictionary item(s) that with point to your other
file.
For example, if you want to look at the city name in your file, ORDER.FILE.OTHER,
create the following:
001: V
002: TRANS('ORDER.FILE.OTHER', @ID, location of city in ORDER.FILE.OTHER', 'X')
@ID in this case points to the filename mentioned in my statement:
LIST ORDER.FILE
the @ID's from ORDER.FILE.OTHER are showing up as non-existent:
(My merged list contains 10 items from ORDER.FILE and 10 items from
ORDER.FILE.OTHER)
ORDER.FILE NAME.
UV 10.0.17, Windows 2003
The other day I had occasion to increase the value of the T30FILE parameter
from the default of 200 (to 300) for the first time in the several years
I've been using Universe. Unfortunately, the documentation is not very
clear (at least to me) regarding interdependencies
In that case, I'm sorry to say, there is no way to logically do what you're
asking with UD. You could physically do it by creating a temp file and copy
all records from both files to it. But that would be a great deal of
overhead for a query.
Gordon J. Glorfield
Sr. Applications Developer
MAMSI
If you really must use TCL (as opposed to writing some code) you could copy
the data from both files to a single temp file and report from it.
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 8:24 AM
To: 'U2 Users Discussion List'
Subject:
Yes, JDBC does come with 6.0. I don't recall if 6.0 is the first version
that includes jdbc or just the first version that I would be willing to use
jdbc with UniData, but there is a switch in my brain (once upon a time the
detail would be there too) that says that UniData 6.0 is the first
Hi,
I was looking for any information about what may cause an RD Group Lock
without a record lock. I am currently experiencing a problem where a
basic program is trying to perform a write to a file, but the file has a
current RD lock. The user no. with the RD lock is the same as the user
who is
R. Bruce,
Could you give an example? I'm having trouble envisioning this.
Let's say I have these keys in a list:
LOCAL.1
LOCAL.2
LOCAL.3
OTHER.1
OTHER.2
OTHER.3
The first 3 live in FILEA and the last 3 live in FILEB
If I go a GET-LIST, then enter:
LIST FILEA NAME
What would the NAME
From: Burwell, Edward [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Sent: Friday, April 30, 2004 1:41 PM
Subject: RE: Memo: RE: [UD] Union Query
R. Bruce,
Could you give an example? I'm having trouble envisioning this.
Let's say I have these keys in a list:
Does that work for you? It doesn't work for me.
ORDER.FILE NAME.
114061 C.M.O.S. INC. *ASC*
114062 AMERICAN PERFIT XSTAL
18 TIMELAND COMPANY
19 MCCANN ELECTRONICS *STR*
130395 TERMINAL TECH SERVICE
138562 TOWN VISION ELECTRONICS
154897
Hello.
Unidata 6.0.8
AIX 5.1
One of our programmers asked this question:
If I have this:
COMMAND = 'PROGRAM.A'
EXECUTE COMMAND CAPTRURING OUTPUT
Is there any way for 'PROGRAM.A' to sense that it is in capturing output
and stop the capture?
What we have is a case where an open file error may
In a message dated 4/30/2004 2:07:27 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
What we have is a case where an open file error may occur and we need to
have the user go back into a menu, but we do not want them to see the
error. Problem is that the error is waiting for user input
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
I have 2 files in separate accounts that are structured the same. I want to
do something like:
SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE
01/01/2004 NAME ADDRESS
CITY STATE ZIP
Is there any
What is a Distributed File?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 2:35 PM
To: [EMAIL PROTECTED]
Subject: Re: [UD] Union Query
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
I have 2
From: Burwell, Edward [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Memo: RE: [UD] Union Query
Does that work for you? It doesn't work for me.
ORDER.FILE NAME.
114061 C.M.O.S. INC. *ASC*
114062
Mark,
Our IT support staff uses AccuTerm 2K2. It has a file transfer feature
available. Search the on-line help document for FT or FTBP. The client
can transfer files, databases, or data records. Nearly everything in a
session is programmable with a scripting language similar to Visual
I believe you are talking about the discussion on
scheduling programs.
ED VOC SCHEDULE-THIS
0001: PA
0001: LOOP (If you want this to repeat each day)
0002: SLEEP XX:XX (Time you want process to run)
0003: TCL COMMAND
0004: TCL COMMAND
0005: TCL COMMAND
0005: REPEAT (If you want this to repeat
Can you say what's the query like? and if you are
using a schema or just a plain file, and the dicts?
Sometimes it has to do with the imposibility to
convert data using the conversion codes.
HP
--- [EMAIL PROTECTED] escribió: We're looking for some
help with a UniOLEDB problem.
I'm hoping
I've seen that in older versions of ODBC and OleDB
clients, I suggest you to update to the latest one.
--- Bob Gerrish [EMAIL PROTECTED] escribió:
I have a client running AIX, UniVerse 9.5.1.1 and
UVODBC 3.7 which they are
connecting to via .NET / OleDB. They see occasional
hangs from
You have a semaphore lock that is not being released. You do not have to reboot the
system to correct this problem. Simply run UNLOCK GROUPLOCK. This will release all
of the grouplocks and complain about the semaphores that cannot be released. Then
issue UNLOCK GROUPLOCK SEMAPHORE ##. You
In the dict of FILE.A create a dict called: NAME.LO that has:
TRANS(LOCAL,ID,1,X):TRANS(OTHER,ID,1,X)
What you get is a boolean result by sticking the two TRANS against each
other.
Let's look an example. Assume that the 6 records have the following names:
LOCAL.1 = Smith
LOCAL.2 = Jones
Yes, the archives will be continue past the cutover.
David: Try the archive search beginning Monday (EDT) for those recent
items.
Lee
On Fri, 30 Apr 2004, Scott Richardson wrote:
You should be able to search the archives as well, as George's reposting
part of that thread, David.
Will the
Are you on Universe or Unidata? I'm on Unidata 5.2 - BASICTYPE 'p', ECLTYPE
'p'.
This is not working for me. When I get a list (6 items let's say) and type
LIST SOME.FILE NAME.LO
It seems that Unidata is taking the 6 items in the list and trying to find
them in SOME.FILE first - *THEN* runs
Hey,
I would like to know what programming languages would be best to program a
frontend to a UniVerse 10 database? Database on AIX5 P Series. I have done a
frontend to a SQL Database using VS .NET before but nothing from a UNIX
database?
The frontend end would run on WinXP Machines and need
Trevor
You have access to a variety of clients including java, .Net, VB, etc.
Access can be through ODBC OLE DB, but also through a UniObjects which
is a class that drops into java or a com object that drops into VB
.Net. This is more efficient than the ODBC environment. (a .Net
interface is
Trevor,
Welcome to the lists! To answer your question, DB2 is a marketing term
within IBM which denotes a family of databases (which includes DB2
itself, UniVerse, UniData, and others). Therefore, a course in DB2 (the
database) does not qualify you for other databases within DB2 (the
Trevor,
[AD] You could push the data out using Zeus Data Integration and SAMBA.
[/AD]
There are a lot of ways, both programmable and buyable. If you check the
archives of this list, you'll see a lot of discussion on pushing data to
Crystal Reports in the last few months.
--
- Charles
My answer to questions like this is always that you can get into these MV
systems in so many different ways that it's now irrelevant which tools or
languages you use. Pick one that you're comfortable with and you'll find
ways to use your tools to get into the back-end and interface with
Open mouth, ... insert foot. Or whatever :)
I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I
would copy all the ID's to a work file and then TRANS-ing the NAME.LO, to
ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in
both files you have to
My 2 cents on this topic and maybe it'll trigger a UD/UV response.
D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your
next process.
Could this work for this person by pre-qualifying the 2 separate SELECT
statements into 2 lists, blah. blah, blah.
I'm interested to know
In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
001: I
002:
TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,)
003:
004: NAME
005: 25L
006: S
But could'nt you do something like
IF TRANS(ORDER.FILE,@ID,3,) = THEN
40 matches
Mail list logo
