RE: [U2] OPEN fname ... ELSE STOP 3000, fname
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 special subroutine to log the error and abort gracefully.. Speaking of that, the original URICA library system, used extensively in the UK and a couple in SA, was written in PROC... And used this ERRMSG idea in it too -Original Message- On Jul 31, 2008, at 12:20 PM, Stevenson, Charles wrote: I've got old, old code riddled with STOP 3000, filename. ERRMSG 3000 does not exist on UV 10.2.6. Did it ever exist on UV? What version of Pick did this come from. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData PROC tip: DB command
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 the day. Unfortunately there is no clear simple replacement and/or 'replacement over time' that occurs when replacing F corelatives with A's or retiring Batch processes. Mark Johnson - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 01, 2008 12:05 AM Subject: Re: [U2] UniData PROC tip: DB command Just as a point of history, EXECUTE was invented by the Devcom team who wrote what became Prime INFORMATION. Our in-house motto was PROCs are Crocks. Regards, Clif On Jul 31, 2008, at 8:22 PM, MAJ Programming wrote: Microdata advanced PQ proc to PQN while regular Pick was advancing with EXECUTE. IMHO, EXECUTE won and Microdata faded into the sunset. (They had a few other programming shortcomings that are clearly deficient by comparison today). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Available printer memory exceeded
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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData PROC tip: DB command
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 A correlatives to I-descriptors. But pity the wretch that is assigned the task of writing the tool to convert F correlatives. We'll sooner inhabit Uranus. -Baker /snip I have been often labeled a PROCtologist by accidentally becoming very good with Procs back in the day. Unfortunately there is no clear simple replacement and/or 'replacement over time' that occurs when replacing F corelatives with A's or retiring Batch processes. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Available printer memory exceeded
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-users@listserver.u2ug.org Subject: [U2] Available printer memory exceeded 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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)
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 different, unrelated sub-systems (no common tables are accessed by both). Of course, we first suspected locking issues, but we have not been able to find any evidence that this is the case. In most cases, only one process seems to be accessing the table(s) in question at the time of the problem. Any ideas on how to go about diagnosing this? Or thoughts as to what might be the problem? It would be awfully nice to have a log of all of the queries being executed and how long they took, such as you can easily get from other databases, like mysql, or PostGresql. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Wondering why select is not working
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 005: 10L 006: M Bottom. Example record -- 063: sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed830a}th u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a}mon9 30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a}thu1 0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a}sat10 30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat330p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun630p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p}thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}sun8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu830p} fri830p}sat830p Bottom. Can anyone tell us why - SELECT B10.COMMONAPP WITH AVAILABILITY LIKE ...8a... Produces- No data retrieved from current (S)SELECT statement. Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData PROC tip: DB command
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 was working on the development of PI/open, I had a go at this. It is not difficult to produce Basic code that does the same job as the Proc but producing good code rather than a simple step by step interpretation of the Proc is difficult. Also, there are some strange interactions between Procs and the underlying command environment that are different from how Basic programs work so you can never get a true replacement. Same goes for a tool to convert A correlatives to I-descriptors. This is relatively easy. If you think there is a market, we might even do it. We looked at this as part of the migration process for users moving to OpenQM but we chose to implement correlatives instead as it was easy. Ours are compiled (like an I-type) rather than interpretive for best performance so actually the task of writing the convertor is probably little more than ripping apart our existing correlative compiler. But pity the wretch that is assigned the task of writing the tool to convert F correlatives. This is probably easier than A correlatives. Again, if there is a real market that would pay a sensible price for it, we might do it. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData PROC tip: DB command
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, or am asked 'to what MVdb can we move our app ...?' -Baker /snip Back in the days when I was working on the development of PI/open, I had a go at this. It is not difficult to produce Basic code that does the same job as the Proc but producing good code rather than a simple step by step interpretation of the Proc is difficult. Also, there are some strange interactions between Procs and the underlying command environment that are different from how Basic programs work so you can never get a true replacement. Same goes for a tool to convert A correlatives to I-descriptors. This is relatively easy. If you think there is a market, we might even do it. We looked at this as part of the migration process for users moving to OpenQM but we chose to implement correlatives instead as it was easy. Ours are compiled (like an I-type) rather than interpretive for best performance so actually the task of writing the convertor is probably little more than ripping apart our existing correlative compiler. But pity the wretch that is assigned the task of writing the tool to convert F correlatives. This is probably easier than A correlatives. Again, if there is a real market that would pay a sensible price for it, we might do it. Martin Phillips --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)
We recently had an issue on a Window 2003 server that would seem to hang just on one secession, but not always the same secession. It was not on any specific program, file, subsystem, just completely random. What we, think, we found is that it had recently been added to an additional domain and it seemed that the excess time was being taken by authenticating over the internet to that new domain. When we took it off of that domain the hangs stopped. Our hangs were more like 15,30, 60 second hangs, not minutes that I am aware of. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Friday, August 01, 2008 11:34 AM To: U2 Users List Subject: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11) 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 different, unrelated sub-systems (no common tables are accessed by both). Of course, we first suspected locking issues, but we have not been able to find any evidence that this is the case. In most cases, only one process seems to be accessing the table(s) in question at the time of the problem. Any ideas on how to go about diagnosing this? Or thoughts as to what might be the problem? It would be awfully nice to have a log of all of the queries being executed and how long they took, such as you can easily get from other databases, like mysql, or PostGresql. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-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-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Available printer memory exceeded
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 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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Available printer memory exceeded
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 Sent: Friday, August 01, 2008 1:32 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Available printer memory exceeded 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-users@listserver.u2ug.org Subject: [U2] Available printer memory exceeded 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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC Error: State = S1000 Error = [Ardent][Unidata ODBC Driver][IBM][SQL Client][Unidata]Unidata lower level function error with fetch
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 tested the ODBC connection successfully with Excel (on that machine), this error pops up when trying to get WS to retrieve info from Unidata. I've put in a call to support, but while I'm waiting I figured someone here might have some ideas? -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wondering why select is not working
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: Friday, August 01, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Wondering why select is not working 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 005: 10L 006: M Bottom. Example record -- 063: sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed830a}th u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a}mon9 30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a}thu1 0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a}sat10 30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat330p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun630p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p}thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}sun8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu830p} fri830p}sat830p Bottom. Can anyone tell us why - SELECT B10.COMMONAPP WITH AVAILABILITY LIKE ...8a... Produces- No data retrieved from current (S)SELECT statement. Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Available printer memory exceeded
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] Available printer memory exceeded 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 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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Wondering why select is not working
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 lines, 24 characters. *--: P 001: D 002: 63 003: 004: AVAILABILITY 005: 10L 006: M Bottom. Example record -- 063: sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed830a}th u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a}mon9 30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a}thu1 0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a}sat10 30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat330p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun630p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p}thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}sun8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu830p} fri830p}sat830p Bottom. Can anyone tell us why - SELECT B10.COMMONAPP WITH AVAILABILITY LIKE ...8a... Produces- No data retrieved from current (S)SELECT statement. Thanks, The SELECT isn't doing what you think ... What you need is SELECT B10.COMMONAPP WITH AVAILABILITY LIKE ...'8a'... Note the single quotes around the '8a' What you've actually asked for is any AVAILABITY that contains an 8-alpha string. I got bitten by that *many* years ago ... I've always remembered it ... Cheers, Wp; -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Available Printer Memory Exceeded
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 memory exceeded 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 Sent: Friday, August 01, 2008 1:32 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Available printer memory exceeded 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-users@listserver.u2ug.org Subject: [U2] Available printer memory exceeded 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 doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/