RE: [ot] Peoplesoft migrates to Ascential
Title: Message No. Peoplesoft used Informatica to import/export and move data around within their product suite, now they use DataStage, NOT Universe. The data is stored in Oracle or other RDBMS – DataStage with its underlying engine based on UniVerse of 1-2 years ago processes the data and that is all. Phil Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Glenn W. Paschal Sent: Friday, January 30, 2004 8:45 AM To: 'U2 Users Discussion List' Subject: RE: [ot] Peoplesoft migrates to Ascential So, in simplest terms, Peoplesoft is now an MV/UniVerse like product? (forgive my ignorance, as I have never worked with Peoplesoft.) --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David T. Meeks Sent: Thursday, January 29, 2004 8:55 AM To: U2 Users Discussion List Subject: RE: [ot] Peoplesoft migrates to Ascential Ascential is basically VMark/Ardent. Almost all of the engineering, sales, support staff that were responsible for Universe up until UV Rel 9.6 work for Ascential (myself and Glenn being two you've come to know over the years) When the split occurred, IBM retained the rights to sell/develop the UniVerse product, as well as the former UniData engineers who were trained on the internals of UnIverse. They now are responsible for UV releases, with UV Rel 10 being the first release to come from there. Ascential also kept the rights to the source code. Internal to the DataStage product set (specifically what is known as DataStage Server, not to be confused with DataStage PX, TX, or 390) is the UniVerse engine, re-branded the DataStage Engine. It is only available as part of the DS Server package. So no, Ascential is not a Universe customer. However, IBM is an Ascential customer and reseller. They resell the DataStage product suite. It does increase the footprint of enterprises around the world that have one of those MV engines running at their site, though. Dave At 08:30 AM 1/29/2004 -0600, you wrote: Thanks for passing that along. Is Ascential a Universe customer of IBM's or did they end up taking Universe and changing it so that they are yet another flavor of 'PICK' (not yet on my MultiValue Family Tree diagram)? If so, is it now called something other than Universe? Thanks. --dawn David T. Meeks || "All my life I'm taken by surprise Architect, Technology Office || I'm someone's waste of time Ascential Software || Now I walk a balanced line [EMAIL PROTECTED] || and step into tomorrow" - IQ ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] TAB characters in ED
Modify ED.B do get it to do what you want if it cannot. It is only BASIC source code which I had the unfortunate task of porting from PI/OPEN. Cheers, 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 Hona, David S Sent: Friday, January 30, 2004 2:48 PM To: 'U2 Users Discussion List' Subject: RE: [UV] TAB characters in ED Craig, I believe this is a function of your terminal emulator. Some emulators let you set the tab character spacing, etc. Checkout the source code to UV line editor in the UV account, in the BP file - ED.B. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Bennett Sent: Friday, January 30, 2004 11:21 AM To: U2 Users Discussion List Subject: [UV] TAB characters in ED Hi All, does anyone know if you can adjust how ED displays TAB characters? Specifically if I can adjust the display width of the tab character? thanks, Craig Bennett ___ 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
RE: UniCommand via UniObjects (Java)
I believe he can just call a paragraph such PARAGRAPH 12345 Where PARAGRAPH is the following VOC entry PA * <> QSELECT CLIENT.XREF "<>" SSELECT AR.TR BY MATTER WITH INVOICE = "<>" 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 Dawn M. Wolthuis Sent: Wednesday, February 25, 2004 10:16 AM To: 'U2 Users Discussion List' Subject: RE: UniCommand via UniObjects (Java) I think you can put the commands in a single paragraph and run that from UniObjects. You'll have to pass in the DATA to the paragraph (since I figure that 12345 is the value of a variable) and I haven't tried that with UOJ, but I suspect others have. Good luck. --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 Donald Kibbey Sent: Tuesday, February 24, 2004 1:55 PM To: [EMAIL PROTECTED] Subject: UniCommand via UniObjects (Java) 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 -- 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
Formating Negative Numbers
Does anyone have a quick way to format a negative number in a field filled with zeros such that the '-' sign appears at the front replacing the 1st zero. For example -2 using 'R%6' becomes -2 2 using 'R%6' becomes 02 But I would like -2 to become -2 and 2 to remain 02. I know I could write code to do this, but I was wondering if you can do it just using the fmt syntax. 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
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
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
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: 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 ) 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: 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 ) 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: Modern Universe - was: The lists are closing
Way to go Trevor. All right a flame war before this list disappears ;-). Maybe in this war the ANZACS will stick together unlike Herr Clarke and her band of lefties. I agree with Trevor. I have seen a number of companies spend tens of millions of dollars moving from a legacy system on UV to systems such as JDE on oracle, SAP on oracle, and the business was no better off. In one case they never even went live with the other system. Oxford Health in the US was another case but I do not know the details of it. My 2 cents worth... 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 Trevor Ockenden Sent: Monday, March 29, 2004 4:22 PM To: U2 Users Discussion List Subject: Re: Modern Universe - was: The lists are closing Joe One bigot to another. Horses for courses - of course! You'll never catch me alive messing with "mainstream" databases. Our users have baulked at the price tag on 'mainstream' database solutions for decades. If the MV databases are so 'behind the times' then how come they were the first in Australia to go live with ATM banking then Internet Banking. 'Mainstream' is not always best. I say 'viva la difference' (French spelling?). Cheers Trevor Ockenden OSP - Original Message - From: "Joe Eugene" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Monday, March 29, 2004 1:24 PM Subject: RE: Modern Universe - was: The lists are closing PICK is LEGACY Technology and does NOT Support alot of advanced level computing we have today. I belive PICK is Similiar to Legacy DB2 that used ISAM type of DataBases Access. Even IBM has moved DB2 (Now UDB) to a completly relational architecture. I belive some of the below are good reasons to Migrate to MainStream (Top 3 - DB2/Oracle/MSSQL etc) Databases. 1. UV has Little/NO support for Emerging Technologies(XML/XQuery/XSLT/WML etc) 2. UV is Not supported in Most Integration Enterprise Software (SAP/PeopleSoft) 3. UV is Not efficient compared to highly evolved databases(DB2/Oracle) 4. UV Folks seem to use PICK, which is Not Compatible with many of of the Current Advanced Technologies and Techniques. 5. UV is very SLOW, TOO Procedural and Not the right tool for an OLTP Environment. It would be nice if IBM provided a Package to convert all UV Stuff to IBM DB2 and perhaps provide some kinda code converter to convert all pick stuff to DB2 Stored Procs or Java Native Compiled Procedures. I belive this would be ideal and would help corportations intergrate systems easily. Joe Eugene From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Sun 3/28/2004 7:59 PM To: U2 Users Discussion List Subject: 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 4
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