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
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: [UV] Problem reactivating select list
Hi John, I think the problem you are seeing is a result of the EXECUTE command being executed in a separate shell or workspace. It can't see your select list. There are a couple of ways around this, use the PASSLIST keyword in the EXECUTE command (that is for ideal flavour, your mileage may vary according to your own flavour. It is all documented in the manual 8-)) or use a SAVE-LIST and then use the DATA statement to stack a GET-LIST command before you execute your ED statement. 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 [EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [UV] Problem reactivating select list Other things to consider: 1. What happens if someone uses XEQ within ED to edit another record. 2. What about people using UPDATE.RECORD 3. And what about REVISE (ENTRO/MODIFY) There are many different ways to get around audit trails if people want to. AdrianW -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 05:22 To: U2 Users Discussion List Subject: [UV] Problem reactivating select list I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. All seemed fine until one of my coworkers informed me he could no longer use X to drop back to TCL after editing from a select list. This was due to the fact that I was processing the select list in the wrapper program and just executing ED once for each record. For X to work as it used to, I need to write out all the selected records at the beginning, let ED process the select list, then go back through the list again for comparison. snip Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- 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: UV: How do I determine whether a file is using 64 bit or 32 bit addressing
Hi Steve, Use the filepeek verb, it is in the Universe bin directory (I presume this is unix as filepeek does not exist on windows (AFAIK)). Run this and look at the header information, it will tell you either 32 or 64 bit file. I also have a magic file (thanks to Glenn Herbert) that tells me from the files command at the unix prompt. I will publish this if you need it. 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 [EMAIL PROTECTED] Sent: Monday, 5 April 2004 7:27 PM To: U2 Users Discussion List Subject: Memo: Re: UV: How do I determine whether a file is using 64 bit or 32 bit addressing Hi Steve, there are two ways that I know of : 1. Try to use the verb uvfixfile -f filename from Unix. It will complain that the file is 64 bit. 2. Use the STATUS statement in Basic. Note - this is not the same as the STATUS() function. This is the way that I do it. Write a little program that reads next from a list of file names, opens each file in turn and then use the status statement to return a dynamic array of info about the file. If attribute 32 is 5, the file is 64 bit. Do a HELP BASIC STATUS to get the full syntax. hth, asvin. Steve Lisa [EMAIL PROTECTED] on 04 Apr 2004 15:22 Please respond to U2 Users Discussion List [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:UV: How do I determine whether a file is using 64 bit or 32 bit addressing HI All, We have several files that are right at the 2 Gig limit. We are pretty sure that we have resized them using the 64 bit option. However, just to make sure, how may we determine if the file is indeed using 64 bit addressing. Thanks, Steve Ferries -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ** This message originated from the Internet. Its originator may or may not be who they claim to be and the information contained in the message and any attachments may or may not be accurate. ** HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. -- 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 (TESTING)
Hi Joe, I must admit to being completely baffled as to your point. Are you 1) Trying to prove you know something about MS SQL? 2) Trying to prove you know something about Oracle? 3) Trying to prove you know nothing about Universe? 4) Trying to prove you haven't been to any course on the presentation of test results? 5) Trying to prove you are stubborn and not willing to listen to others who may know better? 6) Trying to prove you are willing to show how you can compare apples with pears? 7) Trying to prove to others who know otherwise that UV doesn't work and not succeeding? 8) Trying to prove you can become irrational and angry when people question your work? I think you have succeeded in all of the above objectives admirably. Congratulations on a fine job 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 Joe Eugene Sent: Tuesday, 6 April 2004 8:40 AM To: U2 Users Discussion List Subject: RE: Modern Universe (TESTING) Will, Joe I think Zero is an exagerration. This is NOT an Exaggeration, these are TEST Results from well maintained SQL Tables. SQL: select count(*) from TableName Or select count(@IdentityField) from TableName (This is Faster than the above) The above 2 ran against MS-SQLServer instant. Here is the code, if you would like to test. declare @stime dateTime; set @stime = getDate(); select count(*) from CustomerMaster print dateDiff(ms,@stime,getDate()) Joe Eugene -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 05, 2004 1:16 PM To: U2 Users Discussion List Subject: Re: Modern Universe (TESTING) In a message dated 4/4/2004 11:28:33 PM Eastern Standard Time, [EMAIL PROTECTED] writes: The other day.. i was inspecting a UV File with a UV Developer, he ran a COUNT FILENAME on our Customer Master... (BTW Quad CPU 4GHZ)... It took 12-15 Minutes to get a result back from UV. The file only had 800,000 Records. This kind of Operation normally takes ZERO Milliseconds in any Enterprise RDBMS. I had nothing to say but LAUGH!. Joe Eugene Joe I think Zero is an exagerration. However, if this file had an INDEX on it, you could get a COUNT by merely doing a LIST-INDEX filename indexname someoptions One of the output is the number of items indexed for each index entry, the total is identical to the number of records in the file. 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: Re: UV: How do I determine whether a file is using 64 bitor 32 bit addressing
object (unix:class1) 3 byte0 rev %x 2 byte0 %x 8 byte0 (No args) 8 byte1 (1 arg) 8 byte1 (%i args) # # Describe object code - class 2 # note that there is a ctrl-h character preceeding the %x # at position 0, i.e. ctrl-h%x # 2 short 0xe0ac BASIC PROG pcode object (unix:class2) 0 short 0 rev %x 2 short 0xe1ac BASIC SUBR pcode object (unix:class2) 1 byte0 rev %x 0 byte0 %x 6 byte0 (No args) 6 byte1 (1 arg) 6 byte1 (%i args) # # # Describe Transaction Log file - class 8 # 0 short 0xaccc uniVerse Transaction Data File (class8) 3 byte0 rev %x # # Describe Transaction Log file - class 1 # 0 short 0xccac uniVerse Transaction Data File (class1) 2 byte0 rev %x # # Describe Transaction Log file - class 2 # 2 short 0xccac uniVerse Transaction Data File (class2) 0 byte0 rev %x # # Describe uvbackup images # note that there is a ctrl-h character preceeding the %c # at positions 18 to 40, i.e. ctrl-h%c # 0 string uvback00uniVerse backup UNIX image 0 string uvback01uniVerse backup NTimage 9 char0 rev %c 17char0 from %c 18char0 %c 19char0 %c 20char0 %c 21char0 %c 22char0 %c 23char0 %c 24char0 %c 25char0 %c 26char0 %c 27char0 %c 28char0 %c 29char0 %c 30char0 %c 31char0 %c 32char0 %c 33char0 %c 34char0 %c 35char0 %c 36char0 %c 37char0 %c 38char0 %c 39char0 %c 40char0 %c end of magic file=== 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 Clifton Oliver Sent: Tuesday, 6 April 2004 1:34 AM To: U2 Users Discussion List Subject: Re: Memo: Re: UV: How do I determine whether a file is using 64 bitor 32 bit addressing I would like a copy of the unix magic file, David. Would you mind posting it as text? Otherwise, you can send a copy as an attachment to [EMAIL PROTECTED] and I'll get it to the list. -- Regards, Clif On Apr 5, 2004, at 3:46 AM, Logan, David (SST - Adelaide) wrote: file. I also have a magic file (thanks to Glenn Herbert) that tells me from the files command at the unix prompt. I will publish this if you need it. -- 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
Hi Joe, Perhaps you could share your actual searches, code and database structure? Were you searching 20 million records in a single column table? Multiple fields (or columns if you insist) in the Universe database? What is this PICK you keep talking about? Universe doesn't have a component named PICK, there is certainly a flavour. That is your choice to use it, you are not compelled to. How do we know you are comparing apples with apples? How were your indexes structured? I haven't seen Universe Standards for indexing. Please elucidate on this as I am obviously ignorant in this area. Unfortunately your claims are now starting to fluctuate between the fantastic and the ludicrous. How can you expect to be taken seriously when you don't provide a sound basis for your argument? I presume you meant the first database to be Universe? Obviously it must be as it was the fast one 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 Joe Eugene Sent: Tuesday, 30 March 2004 11:17 AM To: U2 Users Discussion List Subject: RE: Modern Universe - was: The lists are closing Charles, Our Customer Information is stored in UV and accessed via PICK. This FILE (as UV ppl call it) contains around 500,000 Records in it. Everything is INDEXED Per UV Standards. Here is simple WILD CARD Search Test. RESULTS Machine: 950 MHZ Athlon Database: MSSQL SERVER 2K Records: 20 Million Indexes: NO Search Time: 2 Seconds -- Machine: QUAD Processor Box (4 GHZ) Database: MSSQL SERVER 2K Records: 500,000 Indexes: YES Search Time: 15 - 20 Seconds I had to Increase the Time out on application servers to support MR.SLOW UV! How do you think I am supposed to believe UV Performs Well. Thanks, Joe Eugene -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Monday, March 29, 2004 8:06 PM To: U2 Users Discussion List Subject: Re: Modern Universe - was: The lists are closing Joe, Here's a few things to consider. MV environments (including UniVerse), allow for small teams to develop and adjust business rules more quickly than you can you can in Oracle, Sybase, or Informix. Published statistics show that MV environments are roughly twice as efficient in disk usage (smaller footprint means faster searches - forget the 'who cares, disk is cheap' argument, search speed is always a premium issue). MV environments are typically three times as efficient on CPU and memory usage. That means that a given system running an MV environment is triple the speed of a Big Three database even when you ignore search speed. Also, since Datastage is one of the best data warehousing systems in the world (and it has a common ancestry to the U2 technology), you can be assured that MV environments make excellent data marts, data warehouses, and data repositories. Informix bought the U2 technology just to get Datastage. -- Sincerely, Charles Barouch www.KeyAlly.com [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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Modern Universe - was: The lists are closing
Hi Will, troll( P ) Pronunciation Key (trl) v. trolled, troll*ing, trolls v. tr. 1. 1. To fish for by trailing a baited line from behind a slowly moving boat. 2. To fish in by trailing a baited line: troll the lake for bass. 3. To trail (a baited line) in fishing Say no more 8-) Joe has a little spare time and enjoys fishing. 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 [EMAIL PROTECTED] Sent: Tuesday, 30 March 2004 2:01 PM To: U2 Users Discussion List Subject: Re: Modern Universe - was: The lists are closing Joe why are you on this list? What is the point of hanging around haranging (sp?) us if you are not interested in learning anything as you put it? Why not just leave. Will In a message dated 3/29/2004 9:30:00 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Our UV Developers here have over 25 years of Experience doing the stuff the do... I personally am not interested in learning the details of UV since nobody really uses this kinda stuff at Corporate Level. I am simply surprised why UV is still used by a few Loyal Folk... when people with 25 years of experience simply cannot make it perform well. -- 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
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
RE: UNCLASSIFIED RE: UV - Database backup
Works for me 8-) sudo /usr/opt/uv/bin/uv -admin uv [ -admin option] -c{learshm} clear BASIC catalog bit. -start start uniVerse. -stop shutdown uniVerse. -L{ock} Suspend file I/O. -R{eport} Current suspension status. -U{nlock} Unsuspend file I/O. sudo /usr/opt/uv/bin/uv -version UniVerse 10.0.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 HENDERSON MICHAEL MR Sent: Tuesday, 9 March 2004 7:25 AM To: 'U2 Users Discussion List' Subject: RE: UNCLASSIFIED RE: UV - Database backup Afraid not, Glenn - E:\IBM\UV\binuv -admin E:\IBM\UV\bin - Nothing at all, I'm afraid :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, 9 March 2004 9:45 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: UV - Database backup I believe (since I wrote all that stuff) that issuing uv -admin will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: Tim -Original Message- Are there any other really useful uv -admin ... subcommands like -L and -U that you can share with us? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender 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: [UD] 8 Bite Integers
Hi Fawaz, It really shouldn't matter. You should be able to write the data out to the flatfile and have it appear 100.00 or -100.00 and the load programs (onpload, High Performance Loader etc.) will just convert according to the schema that you have defined for that table. Can you give an example of a problem field? 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: Fawaz Ashraff [mailto:[EMAIL PROTECTED] Sent: Friday, 5 March 2004 6:13 AM To: U2 Users Discussion List Cc: Logan, David (SST - Adelaide) Subject: RE: [UD] 8 Bite Integers Hi David, Thanks for the info. May be I didn't explain my problem correctly. I have a Unidata numeric field (Amount- 100.00 or -100.00) and I need to convert it to a 8 Bite integer so that Informix will recognise it. Cheers Fawaz --- Logan, David (SST - Adelaide) wrote: Hi Fawaz, Is this what you are looking for? SEQ function Syntax SEQ (expression) Description Use the SEQ function to convert an ASCII character to its numeric string equivalent. Expression evaluates to the ASCII character to be converted. If expression evaluates to the null value, null is returned. The SEQ function is the inverse of the CHAR function. In NLS mode, use the UNISEQ function to return Unicode values in the range x0080 through x00F8. Using the SEQ function to convert a character outside its range results in a run-time message, and the return of an empty string. For more information about these ranges, see the UniVerse NLS Guide. PICK, IN2, and REALITY Flavors In PICK, IN2, and REALITY flavors SEQ( ) is 255 instead of 0. In IDEAL and INFORMATION flavor accounts, use the SEQ.255 option of the $OPTIONS statement to cause SEQ( ) to be interpreted as 255. Example G=T A=SEQ(G) PRINT A, A+1 PRINT SEQ(G) 11-632 UniVerse BASIC /productinfo/alldoc/UNIVERSE10/basic/Ch11 1/9/02 This is the program output: 84 85 71 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 Fawaz Ashraff Sent: Friday, 5 March 2004 5:34 AM To: U2 Users Discussion List Subject: [UD] 8 Bite Integers Good Afternoon. We are moving part of our application to Informix(From Unidata). I need to convert some of the data Fields to 8 bite Integers through a UniBasic program and write it to a flat file. Having problem converting data to 8 Bite Integers. Any suggestions would be highly appreciated. Cheers Fawaz __ Do you Yahoo!? Yahoo! Search - Find what you're looking for faster http://search.yahoo.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 __ Do you Yahoo!? Yahoo! Search - Find what you're looking for faster http://search.yahoo.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Two ways to acquire the U2 Tech Support Survival Kit CD
Hi Wally, What about us down here? Is it available outside the US? Thanks 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 Wally Terhune Sent: Wednesday, 3 March 2004 6:38 AM To: [EMAIL PROTECTED] Subject: Two ways to acquire the U2 Tech Support Survival Kit CD Limited supplies will be available at the IBM booth at two upcoming conferences: Spectrum Datatel Users Group (U2 partner) Both conferences are the week of March 14. I know many of you plan to attend Spectrum. There are also a number of Datatel clients who post to this list, as well. Drop by the IBM booth! ps - I will also be speaking at the Datatel Users Group conference on Sunday March 14 - 10:00am - 12:15 pm. Then lounging around until a 4:30 round table session. Stop by and say hello... Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- 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: telnet
Hi Greg, Check to see the original telnet daemon hasn't started (should be in services). Universe uses the same port and if it is already being used, you will not be able to start the universe daemon. 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 Greg York Sent: Monday, 1 March 2004 8:51 AM To: U2-Users Subject: telnet A small system running Universe PE 10 on WinXP Pro, am no longer able to telnet to the host, the telnet service and the rexec service will not start. Does anybody have any clues -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: telnet
Hi Greg, I'm out of ideas, give me unix anyday, at least I understand most of that 8-). The only thing I would thinkg of to check is the event log to see if this is giving you any idea and also do a netstat -a to check nothing else is sitting on port 23. 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 Greg York Sent: Monday, 1 March 2004 9:13 AM To: 'U2 Users Discussion List' Subject: RE: telnet Hi tony, No, there is no other telnet service running. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Wood Sent: Monday, March 01, 2004 9:34 AM To: U2 Users Discussion List Subject: Re: telnet Hi Greg, Is there another telnet service already running? UniVerse's telnet service can not run if another program is listening on port 23. Regards, T. - Original Message - From: Greg York [EMAIL PROTECTED] To: U2-Users [EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:20 AM Subject: telnet A small system running Universe PE 10 on WinXP Pro, am no longer able to telnet to the host, the telnet service and the rexec service will not start. Does anybody have any clues -- 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: UV on SCO Unix
I can only agree to placing option 7 where it is, I would seriously look at an X86 server running a couple of Xeon processors at 2.4Ghz or quicker. If you have good Unix skills, take a long look at Linux, the price is right and there haven't been too many complaints on the list about the Universe product on Linux. 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 Robert Colquhoun Sent: Thursday, 12 February 2004 9:13 AM To: U2 Users Discussion List Subject: Re: UV on SCO Unix At 04:34 AM 12/02/2004, Brutzman, Bill wrote: We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. I believe i read recently you can now transfer U2 between platforms without paying the 15% transfer fee(Yay!). So the transfer fee is just for your ERP vendor only? While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. Yikes! an E45 goes a way back: http://www.openpa.net/systems/e-class.html processor 100mhz, roughly equivalent to a mid range pentium. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? I would say you could easily spend a large part of the $7000 in savings transferring to another platform with various porting issues that always seem to come up. Perhaps there is another Unix besides SCO... Solaris x86 in linux compatibility mode if you are desperate ;-) This is what i would try in order: 1) Talk to ERP sales rep to get them to clarify unix as including linux(maybe offer a separate payment for this service). 1a) If above does not work complain to sales rep boss + all of your management about situation. 2) 2nd hand hpux server ie on ebay today( rp5400 dual 440mhz 2.5G ram 72G hd for $3750) 3) Reconditioned solaris or ibm 4) Linux 5) Windows 6) Update resume and quit 7) Consider SCO If using a reconditioned unit might also need to spend some getting it back under maintenance. - 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: Universe/RedBack on Linux
There are a few modules on Apache that run the asp code. I've tried the ASP Version 2.53 but haven't worked it particularly hard, it works but would need a bit more testing to try redback. Would be most interesting and save having to use IIS with the attendant security issues. 8=) Apache runs very well on XP etc. but if you wish to continue to use *nix then IMHO Apache is the way to go. http://modules.apache.org and search for asp Apache::ASP Version 2.53 for Apache 1.3, 2.x License: GPL Last Updated June 14th, 2003Author Josh Chamas Active Server Pages with perl scripting. Advanced extensions include extra events, XSLT rendering, output caching, and more. More info ... Chili!Soft ASP Version 3.04 for Apache 1.3.xLicense: Commercial Software Last Updated May 15th, 2000 Author Dave Weaver Active Server Pages for Apache More info ... ModVB Version alpha for Apache 1.3 License: GPL/LGPL Last Updated June 12th, 2003Author Trinity Bays ASP/VBScript/JScript for Apache More info ... mod_monoVersion 0.3.5 for Apache 2.x License: Apache License Last Updated June 13th, 2003Author Daniel Lopez Runs ASP.NET pages on Unix with Apache and Mono More info ... OpenASP Module Version 0.1 for Apache 1.3.xLicense: Apache License Last Updated September 01st, 1998 Author Nathan Woods Open Source implementation of Active Server Pages (ASP) More info ... 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 D Averch Sent: Thursday, 12 February 2004 1:55 PM To: [EMAIL PROTECTED] Subject: Re: Universe/RedBack on Linux We learned the hard way that you must have Windows IIS front end for Redback to run the ASP code. We are currently converting many green screen programs to Redback for a client running on Linux using our tool XLr8. Response time for this 4 processor system is very good. - Original Message - From: Baruch Salamander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:01 PM Subject: Universe/RedBack on Linux Is anyone out there using Universe and RedBack on Linux? If so, how's the performance? For those who are not on Linux, are you considering Linux as an option for the future? -- 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: 2 gig limits
It would have to be a 64bit file, there are no exceptions as this is a limitation brought on by the size of a number. (I think a couple of earlier posters had the numbers involved) therefore you literally cannot create a file larger than 2Gb with 32 bit addressing. We have a substantial number of files over 2Gb and haven't had any issue with converting to or using 64bit files. If you expect a file to be 2Gb then just CREATE.FILE FILE.NAME type modulo separation OTHER.PARAMS 64BIT or if it is an existing file RESIZE FILE.NAME new.type new.module new.separation 64BIT will convert it in a trice (or two). 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 Jason Theis Sent: Wednesday, 11 February 2004 7:12 AM To: 'U2 Users Discussion List' Subject: RE: 2 gig limits The 2GB file size limit is a traditional Unix-based operating system limit. The 2GB file limit appies to *all* files, UniVerse or not. Then maybe I missed something in an earlier post. What is a general suggestion if we expect any sort of file to be larger than 2 gigs? Thanks, JT -- 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: 2 gig limits
Hi Dan, We can use filepeek quite happily on our 64bit files. Do you mean uvfixfile? I know that has restrictions and cannot be used on 64bit files. The parameter in the uvconfig file is 64BIT. If this is set to 1, all files are created by default as 64bit files. 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 Dan Fitzgerald Sent: Wednesday, 11 February 2004 7:42 AM To: [EMAIL PROTECTED] Subject: RE: 2 gig limits The limit is an old one from Unix having 32-bit addressing. On a system with 32-bit addressing, the limit applied to all files, including backup images (at least to disk - I'm not certain about on tape drives, although I'd assume so). Now, we have 64-bit addressing, so the upper limit is in the pentabyte range. UniVerse and Unidata still have a default configuration parameter of 32-bit addressing. This parameter is easily changed to 64. Currently, the cost associated with going to 64-bit addressing for UniVerse Unidata is the loss of a particular tool which is useful in repairing file corruption, filepeek. File corruption is pretty rare, but not unheard of, especially as hardware fails. By going to a scheme like RAID0+1 with transaction logging, you probably won't miss (watch the thread this starts...) filepeek. As an aside, reducing the amount of data in overflow reduces the risk of corruption, by minimizing the number of links, which are failure points. So you can enable U2 64-bit addressing in the (udt/uv)config file, which will then make the limit a historical curiosity. Or you can use dynamic files (although at the most - with a lot of luck - this gives you 4Gb), or in UniVerse you can use distributed files, which imho are a better choice anyway, making the size of a file limited only by your disk drive budget. 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: Jason Theis [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Subject: RE: 2 gig limits Date: Tue, 10 Feb 2004 12:40:15 -0700 We are looking to move to Universe. Does a 2 gig limit apply to Universe as well? Does it only apply to the backup or live data? JT -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ Optimize your Internet experience to the max with the new MSN Premium Internet Software. http://click.atdmt.com/AVE/go/onm00200359ave/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: [UD] Determining if list exists
Title: Message Hi Chris, Why not just use the 'REQUIRE.SELECT' or 'SELECT.ONLY' keywords in your query? This will then only run if there is a select list present. The Uniquery manual documents this quite well. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATEREQUIRE.SELECT LPTR P 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 [EMAIL PROTECTED]Sent: Thursday, 5 February 2004 8:26 AMTo: U2 Users Discussion ListSubject: Re: [UD] Determining if list existsIf you really need to save the list; HDELETE-LIST ARLIST PH HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON HSAVE-LIST ARLIST PH IF # S G ERROR ROUTINE LABEL HGET-LIST ARLIST STON HLIST AR PAYMENT.DATE LPTR PH If you don't want an error routine, leave out the if # s. Bruce M NeylonHealth Care Management Group "Chris Bugosh" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/03/2004 08:51 AM Please respond to U2 Users Discussion List To: [EMAIL PROTECTED] cc: Subject:[UD] Determining if list existsIs there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ___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] Problem with GET(ARG.,1)
Hi Barry, Probably is documented but a ? at the end of a command line at TCL will not execute the line and just store it on the command stack. I am surprised your program is executing at all. 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 Barry Brevik Sent: Thursday, 5 February 2004 1:31 PM To: U2 list (E-mail) Subject: [UV] Problem with GET(ARG.,1) If the command line contains a trailing '?' character, it appears that GET(ARG.,1)FILTER ...returns an empty string. This is probably documented somewhere, right g? -- 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: UCI Error
Title: Message Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2 lines long. : P0001: unirpc: No Connection0002:Bottom at line 2.: EX Hope this helps 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 David SidhuSent: Tuesday, 3 February 2004 9:23 AMTo: 'U2 Users Discussion List'Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statementand the ID both are correct. Just after afour thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUPFROM MEM.REG.HIST AWHERE A.MEM.ID = 'X*01'; Where the X'sis the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Hi David, I would be checking the timeout value (field 6) in the unirpcservices file. I have cut and pasted the appropriate bits out of the manual. This is available at http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_100.ht ml the manual that you need is the Administrative Supplement for Client APIs Hope this is of assistance. Regards About the unirpcservices File Each process that uses the UniRPC automatically configures the unirpcservices file when it first starts up. If no unirpcservices file exists, it is created in the unishared directory. On UNIX systems the default location of this file is /usr/ibm/unishared/unirpc. On Windows NT systems the default location is drive:\ibm\unishared\unirpc. To determine the location of the unirpcservices file on your system, do the following: On UNIX systems, execute the command: $ cat /.unishared On Windows NT systems, find the registry entry under the subkey \HKEY_LOCAL_MACHINE\SOFTWARE\ibm\unishared. When a client system requests a connection to a service on a server system, the UniRPC daemon (unirpcd) on the server uses the unirpcservices file to verify that the client system can start the requested service. The UniRPC software uses field 3 of the unirpcservices file to verify that a machine making a request for a service is allowed to do so. The following table lists the fields in the unirpcservices file: UniVerse Systems On UniVerse systems the unirpcservices file might contain entries such as the following: uvnet /usr/ibm/uv/bin/uvnetd host1,host2,host3 TCP/IP 3 3600 uvdrsrv /usr/ibm/uv/bin/uvdrsrvd * TCP/IP 0 3600 uvcs /usr/ibm/uv/bin/uvapi_server * TCP/IP 0 3600 uvfilefix /usr/ibm/uv/bin/uvfilefix_server * TCP/IP 0 3600 uvserver /usr/ibm/uv/bin/uvsrvd * TCP/IP 0 3600 The version of uv.rc shipped with UniVerse systems (/usr/ibm/uv/sample/uv.rc) contains commands that: Check for the existence of the unirpcservices file Verify that services are defined in it Start the UniRPC daemon if the file contains services The UniRPC daemon is executed as part of the UniVerse reboot procedure Field Contents 1 The name of the UniRPC service (for example, uvserver). 2 The full pathname of the service engine executed by the UniRPC daemon. 3 The names of nodes allowed to execute this service. This field is multivalued, with values separated by commas (no spaces). If the field contains * (asterisk), all hosts defined in /etc/hosts can execute this service 4 The network transport mechanism for the service (TCP/IP). 5 Reserved for future use. 6 The value (in tenths of a second) specifying how long an open connection can be idle before automatic closure from the remote connection. The default is 3600, or 6 minutes. 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 David Sidhu Sent: Tuesday, 3 February 2004 9:41 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps 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 David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The result of VARIABLE[1,3] + 0
Title: Message Hi Marco, Universe doesn't use the + for concatenation, it uses the : (colon) symbol eg. '123':'456' will result in '123456'. Both these examples come up with the expected results (1 and 579) on version 10.0.2 (UV personal edition, Linux) and also on 10.0.8 on Tru64. 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 Marco ManyevereSent: Monday, 2 February 2004 2:44 PMTo: [EMAIL PROTECTED]Subject: The result of VARIABLE[1,3] + 0 Hi All, What is the correct interpratation of A = '001' B = A[1,3] + 0 PRINT B On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical explanation of this. Does UV use '+' for string concatenation as well? Then why doesnt '123' + '456' result in '123456' (I get a runtime error)? Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Distributed multipart files [as RE: [UV] Resize - Dynamicor64 bit?]
Title: Message AFAIK it is handled by Universe (not too sure about Unidata). The System Description manual describes it well. 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 Mark JohnsonSent: Friday, 30 January 2004 10:10 AMTo: U2 Users Discussion ListSubject: Re: Distributed multipart files [as RE: [UV] Resize - Dynamicor64 bit?] Just curious. Are Distributed files handled by the OS or the programmer. One client of mine had 12 monthly files (2-3 million records each) and the software combined the data into work files for cross-month queries. thanks. - Original Message - From: Logan, David (SST - Adelaide) To: U2 Users Discussion List Sent: Thursday, January 29, 2004 5:53 PM Subject: RE: Distributed multipart files [as RE: [UV] Resize - Dynamic or64 bit?] Hi Stuart, One large advantage (from my perspective) is the ability to address the file as one large file or as an single part individually. The open statement in the program is the same, only the name changes. The ability to put the parts on different file systems, balancing the load is another that springs to mind. The ability to split a file into manageable chunks is another. Some of our tables are starting to stretch toward the 20Gb mark and to split these into manageable chunks makes for reasonable resizing times etc. The individual parts can be resized at different times. The ability to split your data according to your own algorithm is especially useful. With multi-data part files, I don't believe you could address the complete file as one, other than that, the other points I have made are still applicable. I suppose distributed files are easier to deal with from the application point of view. If your distribution algorithm is reasonably well balanced the records will be placed evenly over the individual parts. Even if they are not, eg. you use say, a branch code as thekey, you don't have to worry about opening up the correct multi-part, the system will automatically do that for you. 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 Stuart BoydellSent: Friday, 30 January 2004 8:57 AMTo: U2 Users Discussion ListSubject: Distributed multipart files [as RE: [UV] Resize - Dynamic or 64 bit?] I have never come across distributed files in a system and they sound a lot like multiple part files (like SYS.HELP,XXX). What is the difference / advantages / disadvantages between usingdistributed files andmultiple data-part files? Can a distributed file also be a multiple part file? Cheers, Stuart -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of David T. MeeksSent: Friday, 30 January 2004 07:50To: U2 Users Discussion ListSubject: RE: UNCLASSIFIED RE: [UV] Resize - Dynamic or 64 bit? Actually, a DISTRIBUTED file is largely a logical construct. It is a collection of normal files under the umbrella of a master logical file.The components of the DISTRIBUTED file (also called a PART file) can beany hashed file type.The file type that has DATA.30 and OVER.30 is a DYNAMIC file. Dave**This email message and any files transmitted with it are confidentialand 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 scannedfor the presence of computer viruses.** ___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