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

RE: VOC corruption

- 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

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

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

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

RE: Memo: Re: UV: How do I determine whether a file is using 64 bitor 32 bit addressing

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

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

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

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

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.

RE: [UD] 8 Bite Integers

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

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

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

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

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

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

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

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

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

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

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

RE: UCI Error

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

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.

RE: Distributed multipart files [as RE: [UV] Resize - Dynamicor64 bit?]

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