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: The lists are closing
David, As the list is closing this is probably not off topic - so I will comment. I believe PICK has been around since the mid to late 1960's, whereas Oracle and the SQL relation model has been around only since the mid to late 1970's early 1980's if you are talking about Oracle etc. I may be wrong. 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 Logan, David (SST - Adelaide) Sent: Monday, March 29, 2004 12:36 PM To: U2 Users Discussion List Subject: RE: The lists are closing Best of luck Jeff, however I will point out the obvious, what is your definition of modern? I would have thought the good old relational databases have been around since before pick anyway? 8-) Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Ritchie Sent: Monday, 29 March 2004 8:03 AM To: U2 Users Discussion List Subject: RE: The lists are closing Thanks for the memories Cliff :) Sorry to hear the lists are closing, but what the heck time and tide, work committments etc. As some one who is shortly to be ex mv, and moving into the more modern technologies l will decline the offer to join, but wish the site all the best. Cheers, Jeff -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: Saturday, 27 March 2004 7:14 PM To: U2 Users Discussion List; [EMAIL PROTECTED] Subject: The lists are closing Dear Friends: After 10+ years of either hosting or supporting the info-prime, info-unidata, info-vmark, info-informix, and u2-users etc lists, I have decided to shut down the list server. u2-users and u2-community will cease to exist as of 1 April 2004. IBM is officially supporting the efforts of the new U2UG.org group. (Yes. I am a member of the establishing Board of that group. So this is not a coup or Sour Grapes!) If you check out the forums that have been set up, I think you will will see that they cover everything anyone has asked for over the years in this group. I *really* want to encourage ALL of you to come over the the www.u2ug.org site and support this effort. This is *exactly* what many of you on this list have wanted over the years. If Not Now, When? Almost ten years on my Watch. How many years before that on Mike O'Rear's Watch? In the Net World, this has been a Hell of a good run. (I just couldn't resist tripping the Net Nanny filters one last time very evil grin) I'll see all of you on the other media, ok? -- 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 -- 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: The lists are closing
Clif, Ditto my comments on the DataStage list. It will be interesting to see if your efforts can be emulated on these other vehicles. Phil 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 Moderator Sent: Saturday, March 27, 2004 8:14 PM To: U2 Users Discussion List; [EMAIL PROTECTED] Subject: The lists are closing Dear Friends: After 10+ years of either hosting or supporting the info-prime, info-unidata, info-vmark, info-informix, and u2-users etc lists, I have decided to shut down the list server. u2-users and u2-community will cease to exist as of 1 April 2004. IBM is officially supporting the efforts of the new U2UG.org group. (Yes. I am a member of the establishing Board of that group. So this is not a coup or Sour Grapes!) If you check out the forums that have been set up, I think you will will see that they cover everything anyone has asked for over the years in this group. I *really* want to encourage ALL of you to come over the the www.u2ug.org site and support this effort. This is *exactly* what many of you on this list have wanted over the years. If Not Now, When? Almost ten years on my Watch. How many years before that on Mike O'Rear's Watch? In the Net World, this has been a Hell of a good run. (I just couldn't resist tripping the Net Nanny filters one last time very evil grin) I'll see all of you on the other media, ok? -- 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV 10.1.0 on Linux
David, We have been running UV9.6 and UV 10.0 for a while on a non-Redhat distribution of Linux with at hardened kernel and have had no known problems ;-). But we are in the process of planning for an upgrade to 10.1.0 (although I see 10.1.1 is now out) and I am wondering what we should do. I doubt UV takes advantage of any Redhat specific features but you never know. Cheers, 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 Logan, David (SST - Adelaide) Sent: Monday, March 15, 2004 3:50 PM To: U2 Users Discussion List Subject: RE: UV 10.1.0 on Linux Hi Phil, I am not too sure about the UV certication but for Informix IBM certify to a certain release of glibc etc. so it doesn't matter which release you wish to use just make sure your libraries are the correct level. I would presume UV will be pretty similar, perhaps Leroy or Wally could shed some light as to what libraries and what release levels it requires? Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: Monday, 15 March 2004 1:16 PM To: U2 Users Discussion List Subject: UV 10.1.0 on Linux All, I know this question has been asked before, but is UniVerse supported on versions of Linux other than Redhat, such as Debian, SUSE etc? I imagine it is not hard to get working, but would IBM then regard it as being certified? 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 -- 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: EVAL
I seem to remember, and I must stress vaguely, that in SQL it depended on the justification of the left hand operand. 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 Ray Wurlod Sent: Friday, March 12, 2004 9:58 PM To: U2 Users Discussion List Subject: RE: EVAL The result of every EVAL is (deemed to be) a string. Try using both FMT and CONV field qualifiers. FMT for the right justification and CONV to try to convince the query engine that it's dealing with numbers - either the MD or the MR conversion should do it. LIST file EVAL expression CONV MD0 FMT 10R -- 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
Two ways to acquire the U2 Tech Support Survival Kit CD
Could you post the link to the list? Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Wood Sent: Wednesday, March 03, 2004 11:34 AM To: U2 Users Discussion List Subject: Re: Two ways to acquire the U2 Tech Support Survival Kit CD Hi David, In the latest IBM U2 Newsletter they have an email address with instructions to get the CD sent to you. I got mine yesterday so about two to three working days. What about us down here? Is it available outside the US? Yes it is available outside the US (I'm in Melbourne). Regards, T. -- 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: UniCommand via UniObjects (Java)
I think it would be better to put it into a paragraph so that you can handle errors from individual commands anyway. Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:30 AM To: [EMAIL PROTECTED] Subject: RE: UniCommand via UniObjects (Java) Sorry, I haven't tried this with Uniobjects, perhaps it's stripping the @FM somehow?? You could always put the commands into a paragraph and run that - or write a program that executes all of the commands that it is sent... good luck -- 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: Donald Kibbey [mailto:[EMAIL PROTECTED] I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 On this system, doing this results in a very quick selection of a couple hundred records out of the AR.TR file. But, the docs for UniObjects say only one command at a time. Does this mean that sticking a couple commands together like this is just not possible? I've tried it and it looks like the QSELECT is being attempted with all parts of the command string. If it won't work, I suppose I'll be reduced to writing up a stub of a program to do the same thing and just call it from the UniObjects side of things. But, if there's a better way, I'm all ears. Thanks, -- 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