RE: [U2] OPEN fname ... ELSE STOP 3000, fname

2008-08-01 Thread Dennis Bartlett
We did it on a library system for having multiple language support, that way the user login loaded the ERRMSG file and all errors were in the local taal (language) Since the legacy app is used even today, on both D3 and UV, it still works off an ERRMSG file, only the access method now is via a

Re: [U2] UniData PROC tip: DB command

2008-08-01 Thread MAJ Programming
I first ran into Execute on an Ultimate. If I recall correctly, it may have been 1983? I agree that Proc is dead and should be retired/replaced. But since it's still there, it can't fully disappear. I have been often labeled a PROCtologist by accidentally becoming very good with Procs back in

[U2] Available printer memory exceeded

2008-08-01 Thread jpb-u2ug
Last night during our month end batch process it aborted the proc when we got Available printer memory exceeded during one of the programs. I ran the program this morning and it ran without getting the error, same program, same data files. Can anyone tell me where I could look to keep it from

RE: [U2] UniData PROC tip: DB command

2008-08-01 Thread Baker Hughes
The man (person) who writes a PROC interpreter/conversion utility that can take a PROC and turn it into either Basic, or a PAragraph, will have a product to sell... esp. if it can decipher all the PROC nuances and tricks that have been introduced over the years. Same goes for a tool to convert

RE: [U2] Available printer memory exceeded

2008-08-01 Thread Brutzman, Bill
1. What kind of printer is it? 2. Is there a JetDirect or some other print server involved? 3. What OS is it running on? 4. Is it UniData or UniVerse? --B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of jpb-u2ug Sent: Friday, August 01, 2008 12:54 PM To:

[U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)

2008-08-01 Thread Geoffrey Mitchell
We are experiencing periodic hangs (up to 5 minutes in duration) accessing the UV database. These hangs are manifesting when accessing the database through JDBC, sometimes when calling a stored procedure, sometimes when running queries directly through JDBC. The problem has appeared in two

[U2] Wondering why select is not working

2008-08-01 Thread Jon Wells
Hi all, We have a file (Unidata 7.1) called B10.COMMONAPP where a MV'd attribute called AVAILABILITY contains values representing a day and time. AE DICT B10.COMMONAPP AVAILABILITY Top of AVAILABILITY in DICT B10.COMMONAPP, 6 lines, 24 characters. *--: P 001: D 002: 63 003: 004: AVAILABILITY

Re: [U2] UniData PROC tip: DB command

2008-08-01 Thread Martin Phillips
Hi, The man (person) who writes a PROC interpreter/conversion utility that can take a PROC and turn it into either Basic, or a PAragraph, will have a product to sell... esp. if it can decipher all the PROC nuances and tricks that have been introduced over the years. Back in the days when I

RE: [U2] UniData PROC tip: DB command

2008-08-01 Thread Baker Hughes
Martin, After I wrote this, I said to myself, if anyone would/could do this it would be someone close to the Development of one of the Mv systems. I thought Northgate, but I'm not surprised that you've done it. I'll know where to go when I get a contract converting a reality or R83 to OpenQM,

RE: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)

2008-08-01 Thread Tom Dodds
-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3317 (20080801) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2

Re: [U2] Available printer memory exceeded

2008-08-01 Thread iggchamp
We used to get this all the time until we changed uvtemp to a place where it had lots of room to play -- Original message -- From: jpb-u2ug [EMAIL PROTECTED] Last night during our month end batch process it aborted the proc when we got Available printer memory

RE: [U2] Available printer memory exceeded

2008-08-01 Thread jpb-u2ug
1. It's not a printer, it's a program run from a proc. 2. see 1 3. Red Hat Linux AS3 4. Universe release 10.1.12 It seems that all memory errors are printer memory errors on Universe. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill

[U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch

2008-08-01 Thread Kevin King
Any ideas what this message means? ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch I'm assisting with connecting Unidata to UPS WorldShip and while the configuration in Worldship looks spot on, and we've

RE: [U2] Wondering why select is not working

2008-08-01 Thread Larry Hiscock
Because 8a is a pattern that matches 8 consecutive alpha characters. Try this instead: SELECT B10.COMMONAPP WITH ANY AVAILABILITY LIKE '...8a...' Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent:

RE: [U2] Available printer memory exceeded

2008-08-01 Thread Brenda Price
Since we have 300 gigabytes available for uvtemp, we don't think that is it. Our whole database is about 17 gigabytes I am told. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2008 3:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]

Re: [U2] Wondering why select is not working

2008-08-01 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], Jon Wells [EMAIL PROTECTED] writes Hi all, We have a file (Unidata 7.1) called B10.COMMONAPP where a MV'd attribute called AVAILABILITY contains values representing a day and time. AE DICT B10.COMMONAPP AVAILABILITY Top of AVAILABILITY in DICT B10.COMMONAPP, 6

RE: [U2] Available Printer Memory Exceeded

2008-08-01 Thread Brutzman, Bill
Is there programatic command in the PROC related to printing or the UV print spooler? --B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of jpb-u2ug Sent: Friday, August 01, 2008 5:08 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Available printer