[UV] B-TREE INDEX
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 : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea. - Douglas Noel Adams (b. 1952), British author -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Differences
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 thing (Newbie questions:) ) would be much appreciated. Thanks Trev _ Find love today with ninemsn personals. Click here: http://ninemsn.match.com?referrer=hotmailtagline -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Name Resolution
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 Resolution Hi All, does anyone currently do name resolution from within UV? I have a need to determine the dns name corresponding to an IP address under UV 10.0 on AIX, Linux and NT. I would prefer not execute an external utility and cannot use GCI. My current thoughts are to create a sockets client to query a DNS server, but I did wonder if there was a better way to do this. ICONV(203.42.18.135, DNSPTR) ;) thanks, Craig -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] B-TREE INDEX
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 [EMAIL PROTECTED] Date: Fri, 30 Apr 2004 11:01:13 +0200 To: U2 User Group [EMAIL PROTECTED] Subject: [UV] B-TREE INDEX 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 : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea. - Douglas Noel Adams (b. 1952), British author -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Differences
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 generically to all its database products, no doubt to confuse the world into believing that DB2 is the only database (personal opinion). UniVerse and UniData are very similar (to end users), non first normal form database products, based on a model that pre-dates SQL. While each supports SQL, it is not currently the principal query language used. The data model, while relational, incorporates nesting, which DB2 UDB does not. That is, conceptually, a cell (row/column intersection) can have a data type of table. IBM acquired these, along with six other database products, from Informix. Administration of UniVerse is radically different from UniData, and both even more radically different from DB2 UDB. Further, there is no such thing as a course. There's one for the query language, one for the programmer, one (or more) for the administrator in each case. Try linking to IBM's web site, going to www-306.ibm.com/software/data/u2 as your start point. You can get to the library (manuals, tech bulletins, etc.) and training and certification from this page. Sometimes you will end up on a DB2 page while following these links. The U2 (UniVerse/UniData) information is usually in tiny print at the bottom or somewhere else obscure on these pages. Good luck! - Original Message - From: Trevor McNamara [EMAIL PROTECTED] Date: Fri, 30 Apr 2004 20:26:15 +1000 To: [EMAIL PROTECTED] Subject: Differences 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 thing (Newbie questions:) ) would be much appreciated. Thanks Trev _ Find love today with ninemsn personals. Click here: http://ninemsn.match.com?referrer=hotmailtagline -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
The other side
Will be watching you all on the other side -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
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: Thursday, April 29, 2004 7:10 AM Subject: RE: Input weirdo... Thanks Mark! Bjorn managed to find his reply (in an Advanced Pick manual) just after I'd sent the request, which kinda worked, but not exactly, but your length of inputbuffer works a charm. Speaking of these SYSTEM thangs - is there anywhere I can get a list of all the settings / variables included in SYSTEM(x)? -Original Message- [snip] SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- [ Eckel certifies this E-mail to be virus free. ] --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniData JDBC
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 __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION query (really a LIST or SORT) on 2 or more different UniData files? 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 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web:www.bench.com http://www.bench.com -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION query (really a LIST or SORT) on 2 or more different UniData files? 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 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
@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. Name.OTHER.. 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 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:18 AM To: [EMAIL PROTECTED] Subject: RE: [UD] Union Query 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') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web:www.bench.com http://www.bench.com -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION query (really a LIST or SORT) on 2 or more different UniData files? 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 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] uvconfig parameters - T30FILE, MFILES, etc.
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 between the various parameters in uvconfig. So far, the change I made don't seem to have had any negative effect, but I'm wondering if something is waiting in the weeds getting ready to bite me? Are there any other parameters I need to adjust when I change T30FILE? In particular, do I need to increase MFILES correspondingly? TIA for any advice. Thanks Clif. David Scoggins IT Analyst CornerStone Propane mailto:[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Friday, April 30, 2004 11:24 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query No, a record ID in one file will not exist in the other file. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:14 AM To: U2 Users Discussion List Subject: RE: [UD] Union Query TCL (or whatever your flavor calls the queery language) is a single file oriented language. No joins. You would need to create TRANS items in the dictionary of one of the files pointing to the other. Are the record ID's in both files the same for a given record that you would want to relate? -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 8:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION query (really a LIST or SORT) on 2 or more different UniData files? 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 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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: RE: [UD] Union Query No, a record ID in one file will not exist in the other file. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniData JDBC
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 version to use with jdbc. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fawaz Ashraff Sent: Friday, April 30, 2004 9:37 AM To: U2 Users Discussion List Subject: UniData JDBC 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 __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Causes of a RD Group Lock - Universe 9.6 and AIX
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 running the process. There are no READU or WRITEU statements in the process. Since it is a nightly routine that is run, I am phantoming off a small log process to capture ps, list_readu, and port.status. Before the program is run, there is no group lock on the file. Even better, this only occurs a few times a week. The rest of the time, the program runs just fine. Does anyone have any ideas? Jeffrey Lawson Technical Support Engineer Columbia Ultimate Business Systems (800)488-4420 x276 [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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: 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 dictionary look like? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query What I have done in the past is concatenate the 2 translates together. One trans being blank and the other having valid data. You need to make a whole set of dicts that do the double-reads in one file-dict or the other. Then, use it as your primary file for the listing. The only problem is when the data exists in both files. But at least then you will get twice the data. It stands out pretty well if you want to spot problems. HTH R. Bruce Lunt 408.832.1900 cell From: [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 16:49:46 +0100 Hi Ed, You could test for the record existing in one file and if it does use the dict for that file otherwise use the dict for the other file: TRANS(FILE.A,ID,1,X); IF @1 '' THEN FILEA.NAME ELSE FILEB.NAME where FILEA.NAME returns the name from FILE.A and FILEB.NAME returns the name for FILE.B this is all off the top of my head, but it should work. hth asvin Burwell, Edward [EMAIL PROTECTED] on 30 Apr 2004 16:33 Please respond to U2 Users Discussion List [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:'U2 Users Discussion List' [EMAIL PROTECTED] cc: bcc: Subject:RE: [UD] Union Query @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. Name.OTHER.. 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 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:18 AM To: [EMAIL PROTECTED] Subject: RE: [UD] Union Query 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') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web:www.bench.com http://www.bench.com -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello,
Re: Memo: RE: [UD] Union Query
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: 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 dictionary look like? Based on what he said, I'd guess something like this: 0 NAME 1 I 2 TRANS(FILEA, @ID, NAME, ): TRANS(FILEB, @ID, NAME, ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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 AMERICAN PERFIT XSTAL 18 TIMELAND COMPANY 19 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Here is the dict: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S -Original Message- From: Allen Egerton [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 1:47 PM To: U2 Users Discussion List Subject: Re: Memo: RE: [UD] Union Query 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: 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 dictionary look like? Based on what he said, I'd guess something like this: 0 NAME 1 I 2 TRANS(FILEA, @ID, NAME, ): TRANS(FILEB, @ID, NAME, ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
EXECUTE COMMAND CAPTURING OUTPUT
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 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 to continue and user thinks the session is hung up or locked, or they start hitting returns and log themselves off. If we can tell we are in capturing output, we can force the session to end the capture and return to a menu. Thanks! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: EXECUTE COMMAND CAPTURING OUTPUT
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 to continue and user thinks the session is hung up or locked, or they start hitting returns and log themselves off. If we can tell we are in capturing output, we can force the session to end the capture and return to a menu. Isn't one of the SYSTEM() values the number of nested execute levels? If so, you could check if the level is higher then zero and if so, within the target program, you could have it act differently. For example doing a STOP or ABORT instead of an INPUT. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Union Query
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 logic in why an id would be in ORDER.FILE versus ORDER.FILE.OTHER ? If so, maybe you could setup a distributed file so that it points at both of these files? I thought I had read of someone doing something like that. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 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 logic in why an id would be in ORDER.FILE versus ORDER.FILE.OTHER ? If so, maybe you could setup a distributed file so that it points at both of these files? I thought I had read of someone doing something like that. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 AMERICAN PERFIT XSTAL 18 TIMELAND COMPANY 19 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Here is the dict: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S I can't test it right now, I don't have access to a Universe machine until tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't in ORDER.FILE. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Accuterm like Wintegrate
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 Basic. At 07:51 PM 4/28/2004, you wrote: I use wintegrate a lot as an emulator, file transfer and running PC-based programs. 2 new clients both have accuterm and I'm wondering if their file transfer (import/export) facilities are programmable or are manually managed. Also, is there the equivilent of WIN.PCRUN. I can always install wintegrate but I may not want to rock the boat. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Phantom trail
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 each day) PHANTOM SCHEDULE-THIS LO Was this it? George -Original Message- From: david yu [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 2:54 PM To: [EMAIL PROTECTED] Subject: Phantom trail Hello Everyone! There was a trail last week discussion about PHANTOM, unfortunately I deleted my email, I am wondering if anyone has any copy of the trail of discussion. Would appreciate a copy of it specially the one where there was a small PH process. TIA! David Yu __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: OLEDB problem with UniData
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 someone can provide some input on the error. We are currently developing a web application that uses UniOLEDB to execute SQL statements in UniData. Our code is in C# and is running as a service (single threaded). We have test case of 12 or so SQL statements that execute one after the other for a defined number of times. In otherwords the 12 statements are execute over and over for 20 times. Note the 12 statements are not dynamic so they are the same exact query each time, with no variations in data possible. What we are experiencing is a random points in the test we receive an E_FAIL condition. Sometimes it is on iteration 3 and sometimes it is on iteration 19 and sometimes somewhere else. As seen in the DRITrace log segements below there seems to be a pattern in the log of a thread change. When the problem occurs it is preceded by a change in the pattern. Also it looks as if UniData executes the query fine the error is when the data is coming back up the pipe. Check the log segments below. Finally we are using a UniOLEDB version just delivered by IBM, but prior versions also had the problem. The current version we are using is 1.4.5. The UniData version is 6.0.12. Normal set of thread changes occur and there is no error condition around this change. Note there is a change after uci::SQLFreeStmt entries. The next change occurs shortly after after a CAr, CDR log entry combination. uci::SQLFreeStmt(4100808) 00093900 uci::SQLFreeStmt(4100808) 00093901 uci::SQLFreeStmt(4100808) 00093902 THREAD CHANGED: New thread ID=5676(162c) 00093902 CArCommand(120200068)::~CArCommand() 00093903 CDRImCommandUCI::~CDRImCommandUCI 00093904 THREAD CHANGED: New thread ID=1832(728) 00093904 IDBPropertiesImpl(121732620)::GetProperties 00093905 DBPROP_CONNECTIONSTATUS 00093906 DBPROP_CONNECTIONSTATUS: Again we get a thread change in the same pattern as the last one. Everything looks good. uci::SQLFreeStmt(4100808) 00097605 uci::SQLFreeStmt(4100808) 00097606 uci::SQLFreeStmt(4100808) 00097607 THREAD CHANGED: New thread ID=5676(162c) 00097607 CArCommand(120200068)::~CArCommand() 00097608 CDRImCommandUCI::~CDRImCommandUCI 00097609 CArCommand(120197764)::~CArCommand() 00097610 CDRImCommandUCI::~CDRImCommandUCI 00097611 CArCommand(120202380)::~CArCommand() 00097612 CDRImCommandUCI::~CDRImCommandUCI 00097613 CArCommand(120204684)::~CArCommand() 00097614 CDRImCommandUCI::~CDRImCommandUCI 00097615 THREAD CHANGED: New thread ID=1832(728) 00097615 IDBPropertiesImpl(121732620)::GetProperties 00097616 DBPROP_CONNECTIONSTATUS 00097617 DBPROP_CONNECTIONSTATUS: Again we get a thread change in the same pattern as the last one. Everything looks good. uci::SQLFreeStmt(4100808) 00099443 uci::SQLFreeStmt(4100808) 00099444 uci::SQLFreeStmt(4100808) 00099445 THREAD CHANGED: New thread ID=5676(162c) 00099445 CArCommand(120204684)::~CArCommand() 00099446 CDRImCommandUCI::~CDRImCommandUCI 00099447 CArCommand(120202380)::~CArCommand() 00099448 CDRImCommandUCI::~CDRImCommandUCI 00099449 CArCommand(120197764)::~CArCommand() 00099450 CDRImCommandUCI::~CDRImCommandUCI 00099451 THREAD CHANGED: New thread ID=1832(728) 00099451 IDBPropertiesImpl(121732620)::GetProperties 00099452 DBPROP_CONNECTIONSTATUS 00099453 DBPROP_CONNECTIONSTATUS: The patterns above keep occuring for a period of time. This seems to be a good pattern when everything is working correctly. BUT then the next section of logs display thread changes, but they do not follow the patterns above and wam! the error occurs. 00134309 uci::SQLFetch(4100808) 00134310 CArIRowsetImpl::GetNextRows(Got:1) 00134311 CArIRowsetImpl(121726428)::GetData(121725064, 121747320, 2065392) 00134312 CDRImAdmin::ClearError 00134313 CArCommand(120217196)::GetColumnInfo() 00134314 CArCommand(120217196)::GetColumnInfo() 00134315 THREAD CHANGED: New thread ID=5676(162c) 00134315 CArCommand(120196428)::~CArCommand() 00134316 CDRImCommandUCI::~CDRImCommandUCI 00134317 CDRImUCIHSTMT::Close 00134318 Closing UCI HSTMT 4100808 00134319 uci::SQLFreeStmt(4100808) 00134320 uci::SQLFreeStmt(4100808) 00134321 uci::SQLFreeStmt(4100808) 00134322 CArCommand(120197764)::~CArCommand() 00134323 CDRImCommandUCI::~CDRImCommandUCI 00134324 CArCommand(120204684)::~CArCommand() 00134325 CDRImCommandUCI::~CDRImCommandUCI 00134326 CArCommand(120202380)::~CArCommand() 00134327 CDRImCommandUCI::~CDRImCommandUCI 00134328 CArCommand(120214732)::~CArCommand() 00134329 CDRImCommandUCI::~CDRImCommandUCI 00134330 CArCommand(120216652)::~CArCommand()
Re: UVODBC/OleDB job Randomly hang
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 their DataReader and consequently, kill their process and reissue a query. Now we are seeing some hangs on the UniVerse side such that UniVerse performance is greatly degraded and interactive users cannot log in. When this happens, they have been forced to restart UniVerse. They have a uvodbc user set up that is called via the .NET calls. Most of the processes are owned by the user uvodbc, however, the common thread is that there are a number that are owned by root. They are the processes that tend to be the ones that hang about especially when the system slows down. Has anyone seen this sort of behavior, any suggestions? Thanks, Bob Gerrish - [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UVODBC/OleDB job Randomly hang
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 will need to do this for each semaphore that won't release, usually there is only one. Unfortunately, I do not have an answer on how to prevent the hung processes. -Original Message- From: Horacio Pellegrino [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 3:36 PM To: U2 Users Discussion List Subject: Re: UVODBC/OleDB job Randomly hang 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 their DataReader and consequently, kill their process and reissue a query. Now we are seeing some hangs on the UniVerse side such that UniVerse performance is greatly degraded and interactive users cannot log in. When this happens, they have been forced to restart UniVerse. They have a uvodbc user set up that is called via the .NET calls. Most of the processes are owned by the user uvodbc, however, the common thread is that there are a number that are owned by root. They are the processes that tend to be the ones that hang about especially when the system slows down. Has anyone seen this sort of behavior, any suggestions? Thanks, Bob Gerrish - [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ***THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible fordelivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: RE: [UD] Union Query
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 LOCAL.3 = Barney OTHER.1= Green OTHER.2= Brown OTHER.3= Jones If you LIST LOCAL NAME NAME.LO you should see the following: FILE.A... NAME... NAME.LO. LOCAL.1 Smith Smith LOCAL.2 Jones Jones LOCAL.3 BarneyBarney OTHER.1 Green OTHER.2 Brown OTHER.3 Jones This is because the NAME.LO dict doesn't care where it is residing. It just gets the direction to retrieve the contents of attribute 1 from the LOCAL and OTHER files. In fact, to keep the confusion (and clutter) to a minimum you could put the dict into a work file dictionary and do: LIST FILE.A USING DICT WORK NAME.LO When I mentioned the data being in both files I meant having the same key. e.g. LOCAL.3 existing in both LOCAL and OTHER files. Does that make sense? R. Bruce Lunt 408.832.1900 cell From: Burwell, Edward [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 13:41:26 -0400 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 dictionary look like? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query What I have done in the past is concatenate the 2 translates together. One trans being blank and the other having valid data. You need to make a whole set of dicts that do the double-reads in one file-dict or the other. Then, use it as your primary file for the listing. The only problem is when the data exists in both files. But at least then you will get twice the data. It stands out pretty well if you want to spot problems. HTH R. Bruce Lunt 408.832.1900 cell From: [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 16:49:46 +0100 Hi Ed, You could test for the record existing in one file and if it does use the dict for that file otherwise use the dict for the other file: TRANS(FILE.A,ID,1,X); IF @1 '' THEN FILEA.NAME ELSE FILEB.NAME where FILEA.NAME returns the name from FILE.A and FILEB.NAME returns the name for FILE.B this is all off the top of my head, but it should work. hth asvin Burwell, Edward [EMAIL PROTECTED] on 30 Apr 2004 16:33 Please respond to U2 Users Discussion List [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:'U2 Users Discussion List' [EMAIL PROTECTED] cc: bcc: Subject:RE: [UD] Union Query @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. Name.OTHER.. 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 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:18 AM To: [EMAIL PROTECTED] Subject: RE: [UD] Union Query 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') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web:www.bench.com http://www.bench.com -Original Message- From: Burwell, Edward [mailto:[EMAIL
Re: Phantom trail
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 archives also continue to be online as the cutover to U2U happens? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: RE: [UD] Union Query
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 the NAME.LO dictionary. It looks to me that your example works because your system is running the NAME.LO dictionary *BEFORE* it tries to resolve the key in the list to a record in SOME.FILE. Therefore, you should be able to to something like this: SELECT SOME.FILE SAMPLE 6 SAVE-LIST SOME.LIST GET-LIST SOME.LIST LIST TOTALLY.DIFFERENT.FILE NAME.LO if the NAME.LO dict did a TRANS to SOME.FILE, then the above would work just fine - even though every key in the SOME.LIST did NOT EXIST in TOTALLY.DIFFERENT.FILE. I appreciate your help on this. Thanks. :-) Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 3:59 PM To: [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query 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 LOCAL.3 = Barney OTHER.1= Green OTHER.2= Brown OTHER.3= Jones If you LIST LOCAL NAME NAME.LO you should see the following: FILE.A... NAME... NAME.LO. LOCAL.1 Smith Smith LOCAL.2 Jones Jones LOCAL.3 BarneyBarney OTHER.1 Green OTHER.2 Brown OTHER.3 Jones This is because the NAME.LO dict doesn't care where it is residing. It just gets the direction to retrieve the contents of attribute 1 from the LOCAL and OTHER files. In fact, to keep the confusion (and clutter) to a minimum you could put the dict into a work file dictionary and do: LIST FILE.A USING DICT WORK NAME.LO When I mentioned the data being in both files I meant having the same key. e.g. LOCAL.3 existing in both LOCAL and OTHER files. Does that make sense? R. Bruce Lunt 408.832.1900 cell From: Burwell, Edward [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 13:41:26 -0400 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 dictionary look like? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: RE: Memo: RE: [UD] Union Query What I have done in the past is concatenate the 2 translates together. One trans being blank and the other having valid data. You need to make a whole set of dicts that do the double-reads in one file-dict or the other. Then, use it as your primary file for the listing. The only problem is when the data exists in both files. But at least then you will get twice the data. It stands out pretty well if you want to spot problems. HTH R. Bruce Lunt 408.832.1900 cell From: [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 16:49:46 +0100 Hi Ed, You could test for the record existing in one file and if it does use the dict for that file otherwise use the dict for the other file: TRANS(FILE.A,ID,1,X); IF @1 '' THEN FILEA.NAME ELSE FILEB.NAME where FILEA.NAME returns the name from FILE.A and FILEB.NAME returns the name for FILE.B this is all off the top of my head, but it should work. hth asvin Burwell, Edward [EMAIL PROTECTED] on 30 Apr 2004 16:33 Please respond to U2 Users Discussion List [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:'U2 Users Discussion List' [EMAIL PROTECTED] cc: bcc: Subject:RE: [UD] Union Query @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. Name.OTHER.. 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 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC
Frontend to UniVerse?
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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev _ Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to http://join.msn.com/?pgmarket=en-aupage=hotmail/es2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Frontend to UniVerse?
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 on its way, but this is not necessary for .Net development just an upgrade of the COM object) If you require more of the Internet style application, then you should also look at the Redback product which handles all the Web requirements. You also are able to integrate with Web Services, xml, etc. Additionally there are a host of development tools and reports tools available for the Universe environment that allow rapid development. Universe sites are using Chrystal reports, so that should not be a problem. When developing in Universe, this is an opportunity to think outside the square, for though Universe can handle many of things DB2 does it also does a lot of things that DB2 cannot do. Universe has a very sophisticated Programming Language built into the database that can be used to build complex procedure calls way beyond the tradional SQL Programming Languages. Universe also is capable of handling multidimensional tables which DB2 does not handle. If there is something you are trying to do a certain way, I am sure you will find someone on this list that has tackled this problem. With an open mind, I am sure you will find Universe a very powerful development environment, but don't get caught into the trap that the RDBMS way of doing things is necessarily the best way of doing things as there are sometimes easier and quicker ways of doing things from a different perspective Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor McNamara Sent: Saturday, 1 May 2004 8:40 AM To: [EMAIL PROTECTED] Subject: Frontend to UniVerse? 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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev _ Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to http://join.msn.com/?pgmarket=en-aupage=hotmail/es2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Differences
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 *marketing* term). UniVerse and UniData are siblings. As a result, they share a lot of traits but have certain points where they are fiercely different. This list is an excellent source for getting to know these two databases. -- - Charles Barouch [EMAIL PROTECTED] - Zeus Data Integration [EMAIL PROTECTED]- Consulting services (718) 762-3884 x 1 - Key Ally Voice mail Mount Olympus, Home of Zeus Data Integration Trevor McNamara wrote: 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 thing (Newbie questions:) ) would be much appreciated. Thanks Trev -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Frontend to UniVerse?
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 Barouch [EMAIL PROTECTED] - Zeus Data Integration [EMAIL PROTECTED]- Consulting services (718) 762-3884 x 1 - Key Ally Voice mail Mount Olympus, Home of Zeus Data Integration Trevor McNamara wrote: 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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Frontend to UniVerse?
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 applications. As examples: Java, VB6, VB.NET, C#, Perl, ASP.NET, ADO.NET, ODBC, HTTP, RPC, sockets, Nucleus, Visage, DesignBAIS, RedBack, WebWizard, UniObjects/UOJ, Intercall, Coyote(?), PDP.NET, mvInternet, AccuTerm, wIntegrate (yes these can be used as pure connectivity components) Excel, Outlook, Project, Word, Crystal Reports, FRx, ... Quick Books, Great Plains, Turbo Tax, ... (omission of a product name is only a sign of failing memory) There is no best language, development tool, or connectivity method - IMHO. It comes down to your comfort zone, your price range, your favorite technologies, your company politics, your confidence in the long-term viability of tools, and other semi-intangibles. If your question is more specific like how do I get into Universe from a .NET middle tier, then people can provide a more specific answer. For ideas about how to use MV apps with Web Services, for example, see my article on Web Services and .NET in the March/April and prior issues of Spectrum Magazine, where I mention a number of these technologies: http://www.intl-spectrum.com/SPECTRUMMAG.HTML (4.5MB PDF) I'll be happy to provide free advice, offical consultation, education, and development services using most of the technologies mentioned here. Feel free to ask. Tony, Nebula RD [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor McNamara Sent: Friday, April 30, 2004 3:40 PM To: [EMAIL PROTECTED] Subject: Frontend to UniVerse? 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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev _ Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to http://join.msn.com/?pgmarket=en-aupage=hotmail/es2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 decide what do to do with that. Again, sorry for not testing out my solution before I offered it. Regards, Bruce From: Allen Egerton [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Re: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 14:41:17 -0400 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 AMERICAN PERFIT XSTAL 18 TIMELAND COMPANY 19 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Here is the dict: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S I can't test it right now, I don't have access to a Universe machine until tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't in ORDER.FILE. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ MSN Toolbar provides one-click access to Hotmail from any Web page FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 as well. Thanks. - Original Message - From: Bruce Lunt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:11 PM Subject: Re: Memo: RE: [UD] Union Query 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 decide what do to do with that. Again, sorry for not testing out my solution before I offered it. Regards, Bruce From: Allen Egerton [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Re: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 14:41:17 -0400 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 AMERICAN PERFIT XSTAL 18 TIMELAND COMPANY 19 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Here is the dict: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S I can't test it right now, I don't have access to a Universe machine until tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't in ORDER.FILE. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ MSN Toolbar provides one-click access to Hotmail from any Web page - FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 TRANS(ORDER.FILE.CAN,@ID,3,) or something of that nature? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users