[ADMIN] The lists now have their new home
Dear Friends, The lists now are up and running at their new home under the auspices of the new U2 Users Group. Since all addresses were passed along to Larry, all of you should have already received the welcome message and new list server instructions, so I will not repeat them here. I am setting the full moderation bit on for the old lists so that if you post to the old addresses, you will get an auto response reminding you of the new list addresses. I want to thank everyone for making my time as the host of the lists so enjoyable and educational. As mentioned in my reminder postings, I intend to continue participating in the lists with something other than CyberSpankings grin. And I will be using the rest of the new-found time working on the new newsletter ([EMAIL PROTECTED]) and book. I will see you all over at the new home. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
Gordon J. Glorfield wrote: In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. Gordon, you should now better! ;^) sql SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no . dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] 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? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNIX tune for UV 300 users
Hello Everyone! I am going to install uniVerse 300 users on customer Siemens RM machine If somebody inform which UNIX Kernel parameters is critical for this quantity users? I now only that SHMMNU must be more that number of users. Any recomendation about memeory ussage and other system requirments will be usefull. Thank in advance! Ilya Shabaev === ARK - Ilya Shabaev email [EMAIL PROTECTED] Tel./Fax +095 129-0635 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
Indeed. One of the great things about UniVerse and UniData is that you can use SQL against your files. SQL is a great way to do quick updates too (carefull, it is a very sharp knife). If you don't have a good SQL book, get one. I have the advantage of being required to support a couple of Micro$oft SQL servers along with the UniVerse machines. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Saturday, May 01, 2004 3:15 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query Gordon J. Glorfield wrote: In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. Gordon, you should now better! ;^) sql SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT sql NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no . dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] 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? -- 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
I will be the first to admit that I know next to nothing about SQL in the UV/UD world. Can you use the output of the SQL SELECT in UV/UD? Thanks. Steve At 05:14 PM 5/1/04 +1000, you wrote: Gordon J. Glorfield wrote: In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. Gordon, you should now better! ;^) sql SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no . dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] 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? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Union Query
No, and Yes. Just doing a SELECT in SQL style on UV gives you a crt display of the result set. But if you use the SLIST extension, you can then access the select list (see System Description manual) as normal for the UV environment. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On May 1, 2004, at 18:01, Steven M Wagner wrote: I will be the first to admit that I know next to nothing about SQL in the UV/UD world. Can you use the output of the SQL SELECT in UV/UD? Thanks. Steve At 05:14 PM 5/1/04 +1000, you wrote: Gordon J. Glorfield wrote: In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. Gordon, you should now better! ;^) sql SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no . dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] 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? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- 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] 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
RE: UniVerse Personal Edition Telnet Service
Glenn wrote: Thanks for your help. Cool product... But confirmed my fear. Nothing had port 23. As I was working on this, I also found a slew of other serious problems regarding my network config... IE. Spooler not functioning, network browsing not functioning, mapped drives not functioning, other port assignments failing... Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. C:\errmsg 10038 WIN32 API Error (10038) - 'An operation was attempted on something that is not a socket.' Sounds like something is screwed. Cheers, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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
Re: Input weirdo...
The Advanced Pick manual illustrates most all of the SYSTEM() references. It's one of my favorite manuals as it's chapterized like all the others but the index is pure as it contains everything. I don't like the UD/UV manuals as you need to know which index in which book to look up your topic. If you're looking up U50BB, is it in the ECL book, the UniProc book or the UniBasic book?. Not that helpful. Please no flames about books on CD's. Not always helpful either. my 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 8: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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
Here's another solution: LOOP INPUT VAR,-1 IF VAR THEN INPUT TOUCH,1 IF TOUCH = 'X' THEN EXIT END REPEAT - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:41 PM Subject: Re: Input weirdo... I have a new client that i've yet to be able to break key with over the modem. So if I'm running a program (readnext etc) but i want to break, I include this INCLUDE. IF SYSTEM(14) # 0 THEN INPUT A IF A=Q THEN CLEARSELECT (sic) ; STOP IF A=D THEN DEBUG END SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. My 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:54 AM Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- 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: UniVerse Personal Edition Telnet Service
Feel like at any moment, I'll see... WIN32 Toolbox Error (3/8) - 'Socket error on bolt. Possible socket size mismatch. Try 7/16. See unavailable help file for more information.' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, April 29, 2004 2:27 AM To: 'U2 Users Discussion List' Subject: RE: UniVerse Personal Edition Telnet Service Glenn wrote: Thanks for your help. Cool product... But confirmed my fear. Nothing had port 23. As I was working on this, I also found a slew of other serious problems regarding my network config... IE. Spooler not functioning, network browsing not functioning, mapped drives not functioning, other port assignments failing... Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. C:\errmsg 10038 WIN32 API Error (10038) - 'An operation was attempted on something that is not a socket.' Sounds like something is screwed. Cheers, Ken -- 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: UniVerse Personal Edition Telnet Service
WIN32 Metrics Error - See European standards for more information. Could it be that we have taken this too far? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, April 29, 2004 10:16 AM To: U2 Users Discussion List Subject: RE: UniVerse Personal Edition Telnet Service But what if it's a metric error? George -Original Message- From: Glenn W. Paschal [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 11:08 AM To: 'U2 Users Discussion List' Subject: RE: UniVerse Personal Edition Telnet Service Feel like at any moment, I'll see... WIN32 Toolbox Error (3/8) - 'Socket error on bolt. Possible socket size mismatch. Try 7/16. See unavailable help file for more information.' -- 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
[ADMIN] [AD] Passing the Baton (Repeat)
A repeat for those who may have missed it, and for our new subscribers. This weekend is the switch to the new host at listserver.u2ug.org. -- Regards, Clif Dear Friends, As previously announced, after about nine years of hosting what has become the u2-users list, I have decided to pass the baton to a new host. I plan to use the time to pursue some other writing projects. One of these is to resume writing my column previously published in Infocus Magazine as Clif Notes. I will be choosing a different title and will be including it as part of a professional Information Management newsletter. If you would be interested in receiving this newsletter at no charge, just pop an e-mail to [EMAIL PROTECTED] and I will add you to the list. The U2 User Group (u2ug.org) has offered to assume the duties of host and moderator(s). They are in the process of testing their list server and setup now. We expect to be able to move the u2-user and u2-community lists to the new home May 1st. I will provide them a copy of the subscriber addresses as of April 30th. If for some reason you do not want to follow the lists to their new homes, you can unsubscribe before that time. Since we are getting new subscribers on an almost daily basis, I will be posting this message each day until the move. I apologize for the inbox clutter this causes you. I'll chat with you again before the move. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [ADMIN] [AD] Passing the Baton (Repeat)
I will be out of the office April 29, 2004 If this is an urgent matter you can call the helpdesk at ext 361. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
Another thought from left field. I wonder whether the rotating file pool may be implicated? There was a brief time when, for a single Dynamic file, opening OVER.30 rotated DATA.30 out and vice versa (!). VOC is supposed to be exempt from rotating (it and its dictionary are two of the reserved eight file units for sizing MFILES), but it might be worth checking with support about your particular exact release - explicitly request that they check the source code. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: AE_DOCS
I just wanted to let you folks know, that I did find our version of AE_DOC on our system. Apparently, my predecessor move it to a different location that where I expected it to be. (Plus, it helps if you look on the correct drive!) Thanks for your help everyone! Sincerely, 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 1:10 PM To: [EMAIL PROTECTED] Subject: RE: AE_DOCS Wow. Mines 352 kb. I don't know if IBM will send it to you. You could download the PE version and pull it from there. I don't think it's changed a whole lot. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:18 AM To: [EMAIL PROTECTED] Subject: AE_DOCS Hello Group! Can anyone tell me where I can obtain a copy of AE_DOC? My predecessor removed the file(s) to save space on our server some time ago. (We are using UniData 5.1 on an NT 4.0 operating system.) Any help will be appreciated! Sincerely, Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] -- 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: VOC corruption
hmm... another idea just occurred to me. I forget the environment for this problem, but a lot of places have some variant of a script running to query shared memory for nattch=0, then removing those that aren't phantoms. Unfortunately, at AIX 5.2, ipcs reports nattches of 0 for all memory segments. So if you have a script running that you think is removing locks held by defunct process, you may be removing valid, active locks, opening the door to file corruption. Still, probably not the case here, as the VOC shouldn't be seeing much of the I side of I/O. Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: Ray Wurlod [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: RE: VOC corruption Date: Fri, 30 Apr 2004 06:36:30 +1000 Another thought from left field. I wonder whether the rotating file pool may be implicated? There was a brief time when, for a single Dynamic file, opening OVER.30 rotated DATA.30 out and vice versa (!). VOC is supposed to be exempt from rotating (it and its dictionary are two of the reserved eight file units for sizing MFILES), but it might be worth checking with support about your particular exact release - explicitly request that they check the source code. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ Test your Travel Quotient and get the chance to win your dream trip! http://travel.msn.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Input weirdo...
Goo'day, At 22:10 29/04/04, you wrote: snip Speaking of these SYSTEM thangs - is there anywhere I can get a list of all the settings / variables included in SYSTEM(x)? IIRC, somebody did just that some months/years ago For UV at least Check the archives HTH -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.230 / Virus Database: 262.9.10 - Release Date: 28/04/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.230 / Virus Database: 262.9.10 - Release Date: 28/04/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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
RE: VOC corruption
Check if any of the following apply to your site (I think we had this problem, on a old release of UV): a) the VOC was 'accidentally' resized to a dynamic file (which isn't recommended) b) the VOC was very badly sized (the VOC contained a LOT of unused and unused/redundant records) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Wednesday, April 28, 2004 12:05 PM To: U2 List Subject: VOC corruption Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML and U2
Havving played with XML (and not very deeply) I got the impression that one can join FILEs to give you effective sub-sub-sub style nesting . However, seeing as my testing was limited to exporting a nearly-flat file into MS's Infopath, I didnt' try digging very deeply. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 27 April 2004 23:08 To: 'Ronald Bourret' Cc: [EMAIL PROTECTED] Subject: RE: XML and U2 You are correct that the built-in XML -- U2 utilities go to sub-values and I think it makes sense to ignore the text values information at this point. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: Ronald Bourret [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML and U2 Thanks. That clarifies things and I'll modify the entry for UniVerse to account for this. You do raise a new question when you say: The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Does this mean that you can have sub-sub-values, sub-sub-sub-values, and so on, ad infinitum? If so, do the XML tools handle this, adding more sub-elements as needed? The XML = DB mapping languages for UniData and UniVerse don't seem to handle this, except that the documentation for UniData seems to allow one level beneath sub-values, saying something about adding another sub-element in the case of text marks. (I dutifully ignored this, having spent too much time on the entries already :) -- Ron Dawn M. Wolthuis wrote: Hi Rob -- It is the rare table, indeed, that is created with a sql CREATE TABLE statement in a U2 database. U2 has SQL as a second language. It is not really an RDBMS, but uses a data model very similar to the one used by XML (a tree or di-graph structure). With the CREATE-FILE command a file gets created and then when a dictionary is populated, it is descriptive of the data (so not quite the same as an RDBMS that way) and can include sub-fields. The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Let me know if that doesn't quite answer the question. Thanks. --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 Jerry Banker Sent: Tuesday, April 27, 2004 11:30 AM To: U2-Users Subject: Fw: XML and U2 I finally got an answer back from Ron Bourret and he has added the U2 products to his XML enabled list of databases. Anybody want to answer his question? I could do it but I'm kind of busy right now. Jerry - Original Message - From: Ronald Bourret [EMAIL PROTECTED] To: Jerry Banker [EMAIL PROTECTED] Sent: Monday, April 26, 2004 6:32 PM Subject: Re: XML and U2 This is to let you know that I've finally added UniVerse and UniData to the list. You can see the entries at: http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe Comments / corrections welcome. (One question I had was whether UniVerse supports multi-subvalued columns as well as multi-valued columns. There are a number of references to subvalues in the documents, but the UniVerse CREATE TABLE command does not seem to support them...) Thanks for you patience, -- Ron Jerry Banker wrote: Ronald Bourret, Looking over your list of XML enabled databases I was impressed however I noticed that you included IBM's DB2 product but excluded IBM's most XML like databases referred to as their U2 product line (uniVerse and Unidata). Both U2 products are post-relational and use a nested file architecture very much similar to XML design and do have XML transformation tools (uniVerse more so than Unidata at the latest revision). XML documents can be output through their query language and imported into the database through simple commands. Another advantage is that the database can be accessed through it's native query language or with SQL. You should look into these products if you have not already. http://www-3.ibm.com/software/data/u2/ Jerry Banker Member U2UG -- 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 transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy
RE: How far can U2 scale?
In reply to what Steve wrote re: app level problems with scability: In a way you're right, in that an app written for small scale systems cannot easily be scaled upward to infinity without having serious bottleneck issues. No matter what tool (read language/RAD/whatever) is used, if the design has built in toe-jammers, it simply aint gonna work. However, if the designers knew upfront what scale to aim at, it's easy. Keys are prefixed with some kind of sub-structure label to break-down the scale to managable levels, eg branch, warehouse, or if requiring specifically numeric, ranges of number are set for each sub-structure, eg 100,000 - 200,000 for New Jersey, with scalability built in with the same number range for each million increase, eg 1,100,000 - 1,200,000, 2,100,000 - 2,200,000, etc (many ways to skin said cat) The thing about bad design is that its faults exponentially increase by number of users. Bigger hardware doesn't help. Developers with tunnel vision don't help. Most of all, patch jobs don't help. Then again, if weren't for all these, we wouldn't have jobs. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: .net provider from Raining Data
Tony, the problem is that there is very little activty in that forum and there has been no answer from Raining Data support either. /Björn Eklund -Ursprungligt meddelande- Från: Tony Gravagno [mailto:[EMAIL PROTECTED] Skickat: den 28 april 2004 00:02 Till: 'U2 Users Discussion List' Ämne: RE: .net provider from Raining Data Björn, I recommend bringing your PDP.NET questions on proper usage to the Raining Data Web Forum, and bugs to Raining Data Support. They should answer questions like this quickly. I'm concerned that your students have found problems and then worked around them rather than reporting them. Problems should be reported to the vendor or they will never be fixed and people will forever be talking about that damned bug that never got fixed. This goes for all products including the DBMS software we use. Students should learn that this is the way things are supposed to work rather than trying to prove how smart they are by coming up with workarounds. In the long run a workaround costs money and is more difficult to maintain in the future. When problems aren't fixed they cost ALL users of the product time and money, and prompts discussions of migration, which drives up costs for everyone and drives our market into the ground even further. Take advantage of your support contract, get bugs fixed, we all benefit. http://forums.rainingdata.com/ Good Luck, Tony Nebula RD we have students working for us on a project evaluating Raining Data's .net provider. They have had a lot of problems and some of them we have found workarounds for. Now they try to update a file but it doesen't seem to work. Anyone with knowledge of this product who could help us with this issue? -- 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: FATAL : Cannot create transaction cache file
Is this UniVerse or UniData? My guess is either that you've hit some limit (disk full?, max number of transaction cache files?), or that there's a permissions issue in the directory where the transaction cache file needs to be created. - Original Message - From: Ang Suan Yong [EMAIL PROTECTED] Date: Wed, 28 Apr 2004 10:33:56 +0800 To: U2-users [EMAIL PROTECTED] Subject: FATAL : Cannot create transaction cache file Dear All, Do any one having facing the below problem before where the program run half way it prompt Cannot create transaction cache file . When such a problem occur, what we do is just rerun the program and is working well. Is it possible that this is due to hitting the maximun record lock ? Program UPD.SUB: Line 45, FATAL: Cannot create transactio n cache file. Rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. -- 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: VOC corruption
Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: NT files on Unidata
Eugene Perry wrote: How does one open files in the NT file system on Unidata? Carefully? ;^) Seriously though: if you simply want to look at flat text files in a windows folder then you can set up a DIR pointer in the VOC which references the path to the folder and then just OPEN that VOC pointer and READ/WRITE the text files as though they were records in the file. Or you can OPENSEQ a particular text file within that VOC pointer and READSEQ/WRITESEQ to/from the text file. Alternatively you can simply OSREAD and OSWRITE files based on raw paths, or OSOPEN a path and then OSBREAD/OSBWRITE blocks of raw data. There are probably other options too, but I can't think of them right now. Cheers, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Flushing memory
I am currently evaluating different platforms and have been lurking here for a bit. Very lively and informative! We currently use D3 on Windows. I had to integrate SYNC from Sysinternals to flush memory since Windows (or D3) does not seem do it right. We've had problems in the past where customers could loose hours worth of data if there was a system halt! So, would I have to do the same thing with Unidata or did Unidata do it right and provide for safe delivery of the data to the harddrive and then if so is it configurable? Thanks, Steve -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
Hi Ray, I have just switched it on now. I didn't realise you could turn it on and off like that. Thanks David The file is sized pretty well and is a type 11 Thanks Wol, I have had engineers go through all the hardware logs to no avail. There was a couple of small glitches during the last episode but the recommendations of the engineers re: replacement of hardware were heeded and the appropriate replacements were done. Problem has re-occurred since then I'll keep a close eye on the error logs from Universe to see if they can help. In the meantime, I have saved the VOC away each hour and hopefully this will allow a quick recovery if it happens again. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Wednesday, 28 April 2004 7:07 PM To: U2 Users Discussion List Subject: RE: VOC corruption Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- 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: VOC corruption
Is there a particular time of day, day of the week, or system loading consistency in when this corruption of the VOC happens? Any processes writing to the VOC for any reasons? How many users in the particular ACCOUNT where this particular VOC gets corrupted? How do the users access the ACCOUNT where this happens? Are these users physical dispersed throughout a region, country, or the world? Could you please re-post platform particulars? System details - OS, # Processors, Disk configuration, memory configuration, any SAN, any multiple network connections, OS Version and patch levels, U2 product version numbers, etc? Any routine BATCH jobs or PHANTOM processes scheduled to run regularly in this ACCOUNT? What type of application, and explain the typical processing schedule that occurs within this ACCOUNT where VOC gets corrupted. Any significant changes in anything for a month prior to when this problem surfaced, (and I do mean anything). Daylight Savings time kicked in during first weekend of April. When did this problem start? Just trying to brain-storm ideas that may come into play here. Regards, Scott Richardson Senior Systems Engineer / Consultant Marlborough, MA 01752 Email: [EMAIL PROTECTED] Web: http://home.comcast.net/~CheetahFTL/CC/CheetahFTL_1.htm eFax: 208-445-1259 - Original Message - From: Logan, David (SST - Adelaide) [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 8:09 AM Subject: RE: VOC corruption Hi Ray, I have just switched it on now. I didn't realise you could turn it on and off like that. Thanks David The file is sized pretty well and is a type 11 Thanks Wol, I have had engineers go through all the hardware logs to no avail. There was a couple of small glitches during the last episode but the recommendations of the engineers re: replacement of hardware were heeded and the appropriate replacements were done. Problem has re-occurred since then I'll keep a close eye on the error logs from Universe to see if they can help. In the meantime, I have saved the VOC away each hour and hopefully this will allow a quick recovery if it happens again. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Wednesday, 28 April 2004 7:07 PM To: U2 Users Discussion List Subject: RE: VOC corruption Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- 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: Timestamp
Hi Ken, At 07:56 PM 28/04/2004, Ken Wallis wrote: Of course one could easily write a FUNCTION that concatenated DATE() and TIME() and used named common to keep track of the last value it gave out to decide if it needed to add an alpha character and if so, which one, but that What about SYSTEM(12) instead of TIME() ? would only be unique inside the user's session, not system wide. If you wanted something that was unique system wide, you might need to go slightly further than one alpha character and you'd need to involve writing something away to a file (or at least locking something) to get coordination between sessions, and there'd be an overhead associated with that of course. Would be much better to have a record in a control file that is regularly incremented. ie in pseudo code: READU COUNTER FROM CONTROL, COUNTERNAME; COUNTER +=1; WRITE COUNTER TO CONTROL,COUNTERNAME ...use COUNTER as you unique id It would also be quite trivial to knock up a CALLC function that obtained the value returned by the time() C runtime function which gives the number of seconds since somewhere in 1970. Computationally that would be the most efficient, but again, it wouldn't be unique system wide. You should have Use CALLC to solve your problem in your sig to save typing it every day. ;-) - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
Bill H. wrote on 04/28/2004 12:27:30 AM: SYSTEM(19) on D3: Returns a unique item-id consisting of the current system date in internal format, followed immediately by the current system time in seconds. If more than one item-id is generated in a second, an alpha character is appended to the item-id. The best way to simulate this - on UniData, UniVerse, or indeed on D3 - is to roll your own solution that doesn't involve contention. When I was working on a Sequoia Pick system we used SYSTEM(19) rather extensively. It was an easy way for multiple processes to generate unique keys to a file. We thought it was a great way to avoid the bottleneck created by a next key record in a control file. We knew that having multiple processes banging against a single locked record was a bottleneck and we pounced upon this wonderful thing called SYSTEM(19). What a wonderful way to avoid bottlenecks. I was young - well younger - then, and didn't understand the way UNIX worked. There was just this magical facility available, so it was used with abandon. It seemed to be the answer to our problems. Then we saw that the system started crawling and, after much work, came to the conclusion that the processes using SYSTEM(19) were the cause. That's when I started learning UNIX terms like semaphore. In other words, when you're guaranteeing uniqueness system-wide, you're going to have to bind on something. That was lesson #1. Lesson 2 reared its ugly head when we were suddenly missing records during a batch update process. After tearing the application apart, and scrutinizing everything including the IDs of the records in a transaction file, we finally discovered that we were over-writing records. As Bill H. mentioned, the date and time was suffixed with a single character. If I recall correctly, they started with the letter A, then incrimented from there. I think when they got to Z they started with numerals. They might have also included some non-alpha-numeric characters. But with 1200 users on a 16-CPU system, there were times when we used all of the available characters in a second, and it started back at the beginning. We were just blindly writing records with SYSTEM(19) as the key, so earlier records within a second were being overwritten by later records within the same second. Clearly, SYSTEM(19) wasn't the best approach. Since we didn't care about the contents of the ID - only system-wide uniqueness - we started using something like this: date*time*port*seqno where date and time represented the beginning of the current process and seqno was a number incremented within the program. This was guaranteed to be unique system-wide. To our great surprise and pleasure, performance also went through the roof, since there was no longer any chance for a bottleneck. So, as a long answer to Eugene's short question - with some old codger reminiscence mixed in - no, SYSTEM(19) isn't available on UniData. Rejoice! Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VOC corruption
I can relay one UV customer's experience. After months of sporadic file corruption episodes, they finally had their hardware folks come out and check over the system (one of the first things our support group had suggested, of course). They had memory boards seated in improper slots. Once they correctly re-seated the memory boards - all file corruption issues ceased. Even though the hardware diagnostic programs for this platform reported no errors - it is always prudent to check hardware. Anything that interrupts a clean movement of a block of data from memory to the physical disk platters could result in database file corruption. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Logan, David (SST - Adelaide) [EMAIL PROTECTED] To om U2 List [EMAIL PROTECTED] Sent by: cc u2-users-bounces@ oliver.comSubject VOC corruption 04/27/2004 08:05 PM Please respond to U2 Users Discussion List Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- 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
Input weirdo...
We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Input weirdo...
USE INPUTCLEAR not CLEARINPUT 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 28 April 2004 04:55 To: 'U2 Users Discussion List' Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- 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: Input weirdo...
Also, in place of the INPUT OPT.OUT,1 read to drain, you could use INPUTCLEAR to do the same thing without actually reading anything. At 10:54 AM 4/28/2004, you wrote: We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- 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: Redback SOAP requests from .NET
We've turned back on full logging, and have found an existing SOAP request the new .NET SOAP request. Apart from some (hopefully) superficial differences, the main problem seems to be that the body of the request (ie. the SOAP envelope) doesn't appear in the log at all, followed by 'Content-Length = 0' 'No Content data found (ErrorCode=997 Overlapped I/O operation is in progress.)' messages. This is the code we've got so far:- Dim objWebRequest As Net.HttpWebRequest Dim objMyStream As System.IO.Stream Dim objWebResponse As Net.HttpWebResponse Dim objReader As System.IO.StreamReader Dim objResponseStream As System.IO.Stream Dim strData As String Dim i As Long Dim objXMLDoc As New XmlDocument() Dim soapEnvelope As String soapEnvelope = SOAP:Envelope xmlns:SOAP='urn:schemas-xmlsoap-org:soap.v1' soapEnvelope = SOAP:Body soapEnvelope = m:Create xmlns:m='TDCASH:TEST' soapEnvelope = /m:Create soapEnvelope = /SOAP:Body soapEnvelope = /SOAP:Envelope objXMLDoc.LoadXml(soapEnvelope) strData = objXMLDoc.OuterXml objWebRequest = Net.WebRequest.Create(http://it2:8353;) objWebRequest.ContentType = text/xml objWebRequest.Method = M-POST objWebRequest.ContentLength = strData.Length objWebRequest.UserAgent = RBO objWebRequest.KeepAlive = True objWebRequest.Headers.Add(SOAPMethodName, TDCASH:TEST#Create) Dim arrData As Byte() = System.Text.Encoding.ASCII.GetBytes(strData) objMyStream = objWebRequest.GetRequestStream() objMyStream.Write(arrData, 0, strData.Length) objMyStream.Flush() objWebResponse = objWebRequest.GetResponse() objResponseStream = objWebResponse.GetResponseStream() objReader = New System.IO.StreamReader(objResponseStream) Dim strReturn As String strReturn = objReader.ReadToEnd() MsgBox(strReturn) MsgBox(objWebResponse.Server) MsgBox(objWebResponse.Headers.ToString()) objMyStream.Close() Malcolm Kay Development Team Leader IS Unit Tel: 44 (0) 1823 356396 Web: http://www.tauntondeane.gov.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cameron Booth Sent: 28 April 2004 00:45 To: U2 Users Discussion List Subject: RE: Redback SOAP requests from .NET Redback should respond to a request even if it is to report that the request is malformed. The rgw.log file should show some activity of what's going on if the log levels in rgwresp.ini are turned on high enough. Cheers, Cam Booth Analyst Programmer Ultradata - Vision to Reality www.ultradata.com.au -Original Message- From: Kay, Malcolm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 6:29 PM To: U2 Users Discussion List Subject: Redback SOAP requests from .NET We've been trying to create Redback SOAP requests from VB .NET, but the requests always timeout. We think it must be a malformed request. Has anyone else tried this? And do you have a successful example of some code please? Malcolm Kay Development Team Leader IS Unit Tel: 44 (0) 1823 356396 Web: http://www.tauntondeane.gov.uk IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately on +61 3 9291 1600. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL
HTML to Universe conversion codes
Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
The numeric after the % is the hex representation of the ascii code for the character: = hex 26 = decimal 38 -Original Message- From: Lee Messenger [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 9:11 AM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- 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: HTML to Universe conversion codes
These are the ones I have for D3, should be the same in universe I would
think:
%60 `
%7E ~
%21 !
%40 @
%23 #
%24 $
%25 %
%5E ^
%26
%2A *
%28 (
%29 )
%3D =
%2B +
%5B [
%7B {
%5D ]
%7D }
%5C \
%7C |
%3B ;
%3A :
%27 '
%22
%2C ,
%3C
%3E
%3F ?
%20
%0D%0A @am
Hope that helps.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Lee Messenger
Sent: April 28, 2004 12:11 PM
To: [EMAIL PROTECTED] Com
Subject: HTML to Universe conversion codes
Does anyone have a complete list of the unique HTML conversions 'codes'
and
their Universe equivalents when passing data from an html page to
Universe
using the form 'post' method. For example the string
'%26' is '' in Universe.
Would you share this list with me?
Thank you in advance.
Lee J Messenger
Sr VP Operations
[EMAIL PROTECTED]
DLT Transportation Services, Inc.
Phone :(816) 242-4505
Fax :(816) 483-7222
--
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: AE_DOCS
Wow. Mines 352 kb. I don't know if IBM will send it to you. You could download the PE version and pull it from there. I don't think it's changed a whole lot. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:18 AM To: [EMAIL PROTECTED] Subject: AE_DOCS Hello Group! Can anyone tell me where I can obtain a copy of AE_DOC? My predecessor removed the file(s) to save space on our server some time ago. (We are using UniData 5.1 on an NT 4.0 operating system.) Any help will be appreciated! Sincerely, Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
Thank you Michael and Jeff for your timely responses.
Lee J Messenger
Sr VP Operations
[EMAIL PROTECTED]
DLT Transportation Services, Inc.
Phone :(816) 242-4505
Fax :(816) 483-7222
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Spencer
Sent: Wednesday, April 28, 2004 11:25 AM
To: U2 Users Discussion List
Subject: RE: HTML to Universe conversion codes
These are the ones I have for D3, should be the same in universe I would
think:
%60 `
%7E ~
%21 !
%40 @
%23 #
%24 $
%25 %
%5E ^
%26
%2A *
%28 (
%29 )
%3D =
%2B +
%5B [
%7B {
%5D ]
%7D }
%5C \
%7C |
%3B ;
%3A :
%27 '
%22
%2C ,
%3C
%3E
%3F ?
%20
%0D%0A @am
Hope that helps.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Lee Messenger
Sent: April 28, 2004 12:11 PM
To: [EMAIL PROTECTED] Com
Subject: HTML to Universe conversion codes
Does anyone have a complete list of the unique HTML conversions 'codes'
and
their Universe equivalents when passing data from an html page to
Universe
using the form 'post' method. For example the string
'%26' is '' in Universe.
Would you share this list with me?
Thank you in advance.
Lee J Messenger
Sr VP Operations
[EMAIL PROTECTED]
DLT Transportation Services, Inc.
Phone :(816) 242-4505
Fax :(816) 483-7222
--
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: HTML to Universe conversion codes
It should be standard URL encoding, which works as follows: Spaces are converted to + Characters below 0x20 or above 0x7F, along with the characters %+=:# are converted to a % followed by their hexadecimal equivalent [ OCONV(SEQ(VAR),'MX') ] Note that spaces are not converted to a +, then the + converted to %2B. Any existing + characters in the string would be converted to %2B, THEN any spaces would be converted to +. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger Sent: Wednesday, April 28, 2004 9:11 AM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- 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
ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Flushing memory
Steven R. Shourds wrote: I am currently evaluating different platforms and have been lurking here for a bit. Very lively and informative! We currently use D3 on Windows. I had to integrate SYNC from Sysinternals to flush memory since Windows (or D3) does not seem do it right. We've had problems in the past where customers could loose hours worth of data if there was a system halt! So, would I have to do the same thing with Unidata or did Unidata do it right and provide for safe delivery of the data to the harddrive and then if so is it configurable? Thanks, Steve I can't speak for Unidata or Windows, but UniVerse on unix handles syncs correctly in the default configuration. This is the default setting from the uvconfig file along with comments: # UVSYNC - This boolean if set will change the # behavior of UniVerse calling the UNIX sync() # call on exit the environment. A non-zero value # will mean UniVerse will do a UNIX sync() if a job # leading UniVerse process exits. This value should # only be modified if you know exactly what you are # doing. Data loss may occur if UNIX sync is not # executed frequently enough. UVSYNC 1 I'm assuming the default for Unidata is the same. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
All, How about the following (86400 * DATE()) + TIME()):.:GETPID()?. You could use common to check that (86400 * DATE()) + TIME()) is unique within the process, and should probably check that the date has not changed between calling DATE and TIME. This would be unique system wide I believe. Regards, Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Colquhoun Sent: Thursday, April 29, 2004 1:23 AM To: U2 Users Discussion List Subject: RE: Timestamp Hi Ken, At 07:56 PM 28/04/2004, Ken Wallis wrote: Of course one could easily write a FUNCTION that concatenated DATE() and TIME() and used named common to keep track of the last value it gave out to decide if it needed to add an alpha character and if so, which one, but that What about SYSTEM(12) instead of TIME() ? would only be unique inside the user's session, not system wide. If you wanted something that was unique system wide, you might need to go slightly further than one alpha character and you'd need to involve writing something away to a file (or at least locking something) to get coordination between sessions, and there'd be an overhead associated with that of course. Would be much better to have a record in a control file that is regularly incremented. ie in pseudo code: READU COUNTER FROM CONTROL, COUNTERNAME; COUNTER +=1; WRITE COUNTER TO CONTROL,COUNTERNAME ...use COUNTER as you unique id It would also be quite trivial to knock up a CALLC function that obtained the value returned by the time() C runtime function which gives the number of seconds since somewhere in 1970. Computationally that would be the most efficient, but again, it wouldn't be unique system wide. You should have Use CALLC to solve your problem in your sig to save typing it every day. ;-) - Robert -- 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: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
seconds past midnight GMT, Jan 1, 1970. Is there a conversion code yeah .. something like: pick DATE() = INT(unixtime/86400)+732 pick TIME() = MOD(unixtime,86400) which makes: unixtime = (pick DATE() - 732) * 86400 + pick TIME() and PICK time is always local time, not GMT -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:0001/01/1970)
Sorry, no cigar. That's not a conversion code that you can stick in 3 of a dictionary D-item, or 7 of an A-item. Or as second argument of either, nay, both ICONV() OCONV(). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi Sent: Wednesday, April 28, 2004 12:43 PM To: U2 Users Discussion List Subject: RE: ICONV/OCONV for unix internal timestamp (secs past 00:0001/01/1970) seconds past midnight GMT, Jan 1, 1970. Is there a conversion code yeah .. something like: pick DATE() = INT(unixtime/86400)+732 pick TIME() = MOD(unixtime,86400) which makes: unixtime = (pick DATE() - 732) * 86400 + pick TIME() and PICK time is always local time, not GMT -- 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: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
Are you asking about the 'MTHS' conversion code? - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 1:47 PM Subject: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970) unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson -- 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
UniVerse Personal Edition Telnet Service
I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Any help would be GREATLY appreciated. Tried re-installing the UV engine... didn't help, nor did I really think it would... just seemed to be a shot in the dark. Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
The problem (or not problem) with RAISE, is that it will also change all other marks at the same time. If you have a|b|c}d|e|f, and want a}b}c}d}e}f, you have to use CONVERT. RAISE will give you a}b}c^d}e}f *note ^ = fm, } = vm, | = svm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Tuesday, April 27, 2004 12:18 PM To: 'U2 Users Discussion List' Subject: RE: Help on uv syntax, please To do what you are saying I would use the RAISE function. NEWARRAY = RAISE(OLDARRAY) This would change all @SVM to @VM. Of course you would have to be kind of careful with it as it would also change all @VM to @AM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse Personal Edition Telnet Service
Check to see if the Microsoft Telnet service is running. If so, stop the service and set its start property to disable or manual. Then stop the UniVerse services and restart them and you should have telnet. An alternative is to use UniAdmin to change the port UniVerse uses for telnet so the two do not conflict. That is what I have done and it works well. If this is not a MS installnever mind! :-) Ron White - Original Message - From: Glenn W. Paschal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 4:35 PM Subject: UniVerse Personal Edition Telnet Service I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Any help would be GREATLY appreciated. Tried re-installing the UV engine... didn't help, nor did I really think it would... just seemed to be a shot in the dark. Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
David I've seen this where a GCI/CALLC routine was linked into a UniData kernel and it reused the stderr file handle. The result was the stderr data stream overwrote the file which currently was allocated to that handle (whoch UniData was using for the VOC). The giveaway was to perform an od -c of the VOC - many application error messages overwrote the file header. Hope this helps...not sure off the top of my head whether UniVerse usage of handles is similar - but worth a check. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 28 April 2004 03:05 To: U2 List Subject: VOC corruption Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- 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: VOC corruption
Thanks Wally, I will pass this on but we have had some hardware replaced between episodes but will ask to check again. Thanks John, We don't have any GCI or C programs using UCI accessing any of our live databases. Good thought though. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Wednesday, 28 April 2004 10:59 PM To: U2 Users Discussion List Subject: Re: VOC corruption I can relay one UV customer's experience. After months of sporadic file corruption episodes, they finally had their hardware folks come out and check over the system (one of the first things our support group had suggested, of course). They had memory boards seated in improper slots. Once they correctly re-seated the memory boards - all file corruption issues ceased. Even though the hardware diagnostic programs for this platform reported no errors - it is always prudent to check hardware. Anything that interrupts a clean movement of a block of data from memory to the physical disk platters could result in database file corruption. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Logan, David (SST - Adelaide) [EMAIL PROTECTED] To om U2 List [EMAIL PROTECTED] Sent by: cc u2-users-bounces@ oliver.com Subject VOC corruption 04/27/2004 08:05 PM Please respond to U2 Users Discussion List Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- 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: UniVerse Personal Edition Telnet Service
Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Go to www.sysinternals.com and download tcpview.exe. This tool will show you in real(ish) time what netstat shows you whenever you run it, except it also shows the name of the executable associated with each connection. Cheers, Ken PS. Sorry Robert, I couldn't think of a CALLC that would help Glenn on this! ;^) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
I have a new client that i've yet to be able to break key with over the modem. So if I'm running a program (readnext etc) but i want to break, I include this INCLUDE. IF SYSTEM(14) # 0 THEN INPUT A IF A=Q THEN CLEARSELECT (sic) ; STOP IF A=D THEN DEBUG END SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. My 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:54 AM Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- 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
Accuterm like Wintegrate
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
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
Chuck, you need to worry about time zone when rendering the unix epoch time as it is UTC (aka GMT) based. A simple conversion of the unix epoch time to U2 date/time will be incorrect unless you are in Britain in the winter - and who'd be there then ;-) Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. This function could be used as a conversion by wrapping it and globally cataloguing it as $ParseEpochTime OCONV(intTimeStamp,'UParseEpochTime') Cheers, Stuart -Original Message- Behalf Of Stevenson, Charles unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. Now that's rich. There's a lot there. Looks like maybe good to piggyback on it. thanks, cds -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secspast00:0001/01/1970)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Why not write a user conversion code that does this calculation as a Uname conversion? That's what I was asking, if anyone already did it. I'd prefer it to be flexible enough to allow various oconv formats and to iconv various strings. For example, what if you just have date don't care about time, etc. Plus it ought to have the property analogous to that of D conversions where: ICONV( OCONV( idate, 'D' ), 'D' ) = idate (What's the set theory word for that property, where each member of a set can be transformed to a corresponding member of another set, and the inverse transformation will always get you back to your starting point? Reflexive? That doesn't sound right. It's late, gimme a break.) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse Personal Edition Telnet Service
Thanks for your help. Cool product... But confirmed my fear. Nothing had port 23. As I was working on this, I also found a slew of other serious problems regarding my network config... IE. Spooler not functioning, network browsing not functioning, mapped drives not functioning, other port assignments failing... Could it be time to backup, fdisk, and start over? Hmm I am thinking yes. (oh the pain of a re-load...) Thanks again, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Wednesday, April 28, 2004 7:35 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse Personal Edition Telnet Service Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Go to www.sysinternals.com and download tcpview.exe. This tool will show you in real(ish) time what netstat shows you whenever you run it, except it also shows the name of the executable associated with each connection. Cheers, Ken PS. Sorry Robert, I couldn't think of a CALLC that would help Glenn on this! ;^) -- 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
