SQR

SQR SQL Trace

To trace the status of cursors being executed, append the -S flag to your parameter list. You can...

Stringing Text in SQR

You can use the commands string, by, and into in SQR to string together text by a particular char...

SQR CreateProcess Failed

When trying to run an SQR on an NT process scheduler, I received the following error: Error! SQR...

SQR Trace

One of the first things you used to learn as a PeopleSoft developer is to add debug flags in an S...

Page Breaking In SQR

The page breaking functionality in SQR is really one of the most useful features in the language....

Dates in SQR

There are two main ways to store and use dates in SQR: Store them as a character string in a st...

Output to the Report Repository

If you are developing a new SQR that creates files that need to be posted from the process schedu...

Error Code 2904

(SQR 2904) File number already opened. This indicates that the file number you used for refere...

Error Code 3719

(SQR 3719) Columns names and expressions must be unique or be given unique pseudonyms (&name)...

Error Code 4713

(SQR 4713) Cannot open the #INCLUDE file: 'setenv.sqc' (2): No such file or directory SQR for...

Error Code 5400

(SQR 5400) Second page write attempted while writing current page. Check BEFORE-PAGE, AFTER-PAGE...

Error Code 5528

(SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 11: ORA-00933: SQL command not properly en...