Re: [sqr-users] Change in sql-status values

["Prasanna Menta" <pmenta@umuc.edu>]

I got the following from sqrug, see if this helps

0 = Normal
 1 = Error occurred while program is running
 2 = Problem processing the message file (sqrerr.dat) or specified
     via the -ZMF command line option.
 3 = Problem processing the command line
 4 = Could not create the .SQT file
 5 = Could not compile the program
 6 = Problem processing the source file (.sqr/.sqt)
 7 = Problem with the listing file (.lis or -f{file})
 8 = Problem with the error file (.err or -e{file})
 9 = Problem with the log file (sqr.log, .log, -o{file})
10 = Problem with the 'postscri.str' file
     (SQRDIR/postscri.str or Startup-File=)
11 = Cannot call SQR recursively
12 = Problem creating the WINDOWS environment
13 = An internal error occurred
14 = Problem with SQRW.DLL

Bink Montgomery wrote:
> 
> Hello,
> 
> We're in the process of upgrading our Student Administration System from
> PeopleSoft 7.6 to 8.1. Our customized SQR programs currently run under
> version 4.3.4/Oracle 7.3.4, and contain code to check for duplicates
> when inserting rows by checking the SQR variable sql-status for a value
> of -9. This check fails when run under SQR for PS 8.18/Oracle 8.0.6. The
> value must be changed to -1 in PS8. Some of the PS delivered programs
> have checks for other specific values, so I don't know if this is an
> issue or not. Has anyone experienced this problem or can tell me where I
> can get documentation on the values returned for both releases?
> 
> Thanks in advance,
> 
> Bink
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users