How-to, tips, code
and discussion

Databases

Reference

Publications

Tools

Getting started
with SQR

Consultants
and integrators

Contracting
and employment

Home

Are you an
independent contractor?
(Or need one?)

Tap into our network.

Protallian, the Professional Talent Alliance, is a self-referred network of independent contract consultants and engineers. We are in beta and currently inviting independent contractors specializing in SQR and/or PeopleSoft to join the network.

Member site: www.protallian.net
Client site: www.protallian.com
#RETURN-STATUS reserved SQR variable*    [Q&A, SQRUG, 2004]
$CURRENT-DATE, formatting*    [Q&A, SQRUG, 2003]
-DEBUG and -S flags, specifying for Process Scheduler, release 8 (PeopleSoft)    [Tip, PeopleSoft, ]
-DEBUG flag, specifying for Process Scheduler, releases before 8x (PeopleSoft)    [Tip, PeopleSoft, ]
-F parameter*    [Q&A, SQRUG, 2004]
.NET integration*    [Q&A, SQRUG, 2005]
Adding days to a date value    [Q&A, PSFans, 2002]
Aggregate functions, performance issue, SQL Server*    [Q&A, SQRUG, 2004]
AIX, running SQR on*    [Q&A, SQRUG, 2004]
ALLMAXES.MAX not found (PeopleSoft)    [Q&A, PSFans, 2005]
Alphanumeric string, validating (removing special characters)*    [Q&A, SQRUG, 2004]
Application Engine (PeopleSoft): Passing parameters to SQR*    [Q&A, SQRUG, 2003]
Application Engine vs. SQR (PeopleSoft)    [Q&A, PSFans, 2005]
Application Engine vs. SQR, part 1 (PeopleSoft)    [Blog, SparkPath, 2005]
Application Engine vs. SQR, part 2 (PeopleSoft)    [Blog, SparkPath, 2005]
Application Engine, calling SQR from (PeopleSoft)    [Q&A, PSFans, 2006]
Array index is always 0*    [Q&A, SQRUG, 2004]
Arrays, dynamic sizing using ASK, EXTENT*    [Q&A, SQRUG, 2005]
Arrays, size declaration    [Q&A, PSFans, 2003]
Arrays, size declaration*    [Q&A, SQRUG, 2005]
Arrays, sorting and grouping*    [Q&A, SQRUG, 2004]
Arrays: Introduction    [Blog, SparkPath, 2005]
AS <column name> in SQR BEGIN-SELECT*    [Q&A, SQRUG, 2004]
BEGIN-HEADER displays information for wrong page*    [Q&A, SQRUG, 2004]
Buy SQR independent of PeopleSoft installation*    [Q&A, SQRUG, 2004]
CALL SYSTEM error codes (Windows)*    [Q&A, SQRUG, 2004]
CALL SYSTEM on Unix    [Q&A, PSFans, 2003]
CALL SYSTEM problem (environment variables not inherited)*    [Q&A, SQRUG, 2004]
CALL SYSTEM returns status 2 for all DOS commands    [Q&A, PSFans, 2004]
CALL SYSTEM to call a batch file on Windows*    [Q&A, SQRUG, 2004]
CALL SYSTEM to call SQR from within SQR    [Q&A, ERPCommunity, 2005]
Carriage control characters, removing from huge .LIS file*    [Q&A, SQRUG, 2004]
Check signature fonts; converting BMP to HPGL*    [Q&A, SQRUG, 2004]
CLOB columns, retrieving (Oracle)*    [Q&A, SQRUG, 2004]
Coding standards    [Blog, SparkPath, 2005]
Coding standards*    [Q&A, SQRUG, 2005]
Column headings, multiple-line, in CSV files*    [Q&A, SQRUG, 2005]
Columns, maximum on a report*    [Q&A, SQRUG, 2005]
Command-line flags    [Tip, PeopleSoft, ]
Command-line parameters, referencing*    [Q&A, SQRUG, 2004]
COMMIT within a BEGIN-SELECT loop*    [Q&A, SQRUG, 2004]
COMMIT within a BEGIN-SELECT loop*    [Q&A, SQRUG, 2004]
Compiled version of SQR program: Creating and running    [Tip, ERPCommunity, 2004]
Compiling SQR programs    [Blog, SparkPath, 2005]
Configuration for custom SQR: Folders, naming, modifying vs. cloning    [Blog, SparkPath, 2004]
Connecting to another database via Oracle DB link    [Tip, ERPCommunity, 2004]
Crystal Reports vs. SQR    [Q&A, PSFans, 2004]
CSV and HTML output, creating, PeopleSoft 8.1x    [Tip, PeopleSoft, ]
CSV and XLS file formats*    [Q&A, SQRUG, 2004]
CSV and XLS file formats    [Blog, SparkPath, 2005]
CSV and XLS files for Excel 2000*    [Q&A, SQRUG, 2004]
CSV file empty even when other output produced    [Q&A, PSFans, 2004]
CSV file missing comma delimiters    [Q&A, PSFans, 2004]
CSV files, avoiding embedded delimiters    [Q&A, ERPCommunity, 2006]
CSV files, headings in*    [Q&A, SQRUG, 2004]
CSV, HTML output works on some machines but not others*    [Q&A, SQRUG, 2004]
Current date/time using DATENOW()    [Tip, ERPCommunity, 2004]
Database links*    [Q&A, SQRUG, 2004]
Database name, retrieving (Oracle)*    [Q&A, SQRUG, 2004]
Database name, retrieving (Oracle, PeopleSoft)    [Tip, ERPCommunity, 2004]
Date comparisons (Oracle)*    [Q&A, SQRUG, 2005]
Date fields, inserting empty (null) values    [Q&A, PSFans, 2004]
Date format conversions*    [Q&A, SQRUG, 2005]
Date format conversions using SQL*    [Q&A, SQRUG, 2005]
Date value, creating from string*    [Q&A, SQRUG, 2003]
Date values, adding days to date, DB2*    [Q&A, SQRUG, 2003]
Date values, comparing*    [Q&A, SQRUG, 2004]
Date values, comparing    [Blog, SparkPath, 2005]
Date values, formatting*    [Q&A, SQRUG, 2005]
Date values, reformatting    [Q&A, PSFans, 2005]
Date values, validating*    [Q&A, SQRUG, 2004]
Datetime values, removing time from*    [Q&A, SQRUG, 2004]
Datetime values, removing time from*    [Q&A, SQRUG, 2005]
Days of week within a date range    [Q&A, PSFans, 2004]
Debugging SQR programs    [WhitePaper, SparkPath, 2005]
Debugging SQR programs: SP Debugger tips    [Blog, SparkPath, 2006]
Decimal places*    [Q&A, SQRUG, 2005]
Decimal places in SHOW*    [Q&A, SQRUG, 2004]
Deleting files through SQR*    [Q&A, SQRUG, 2004]
Derived records (PeopleSoft)*    [Q&A, SQRUG, 2003]
Detail lines, suppressing in a report*    [Q&A, SQRUG, 2005]
DISPLAY and MOVE: Recommendations    [Blog, SparkPath, 2004]
DOS SORT, using for complex sorts*    [Q&A, SQRUG, 2003]
Doubling double-quote characters*    [Q&A, SQRUG, 2003]
Duplicate rows, avoiding during SQL INSERT*    [Q&A, SQRUG, 2005]
Dynamic clause in subselect causes SQL compile error*    [Q&A, SQRUG, 2005]
Dynamic column headings*    [Q&A, SQRUG, 2004]
Dynamic optional table name in SELECT*    [Q&A, SQRUG, 2003]
Dynamic SELECT columns*    [Q&A, SQRUG, 2005]
Dynamic SELECT columns: Supplying type*    [Q&A, SQRUG, 2003]
Dynamic SQL clauses: FROM    [Tip, ERPCommunity, 2004]
Dynamic SQL clauses: WHERE    [Tip, ERPCommunity, 2004]
Dynamic SQL performance*    [Q&A, SQRUG, 2005]
Dynamic SQL: Column names    [Q&A, PSFans, 2004]
Dynamic SQL: Database links*    [Q&A, SQRUG, 2005]
Dynamic SQL: Introduction    [Blog, SparkPath, 2005]
Edit mask syntax, negative numbers    [Q&A, PSFans, 2003]
EDIT mask syntax: "Edit requires character argument"    [Q&A, PSFans, 2003]
Editors for SQR development    [Q&A, PSFans, 2005]
Email attachment on Unix, specifying "from"*    [Q&A, SQRUG, 2004]
Email, generating*    [Q&A, SQRUG, 2003]
Email, generating*    [Q&A, SQRUG, 2003]
Email, generating*    [Q&A, SQRUG, 2003]
Email, generating*    [Q&A, SQRUG, 2004]
Email, sending from SQR using mailx*    [Q&A, SQRUG, 2004]
Email, Unix: Various troubleshooting suggestions*    [Q&A, SQRUG, 2005]
Emailing a file from SQR*    [Q&A, SQRUG, 2003]
Emailing attachments    [Q&A, PSFans, 2005]
Emailing SQR's current report*    [Q&A, SQRUG, 2005]
Empty lines in output file*    [Q&A, SQRUG, 2004]
ENCODE ASCII values*    [Q&A, SQRUG, 2004]
Encrypting SQR output*    [Q&A, SQRUG, 2004]
End-of-run message, screen scroll after*    [Q&A, SQRUG, 2004]
Error "Parameter list cannot be greater than 255 characters" (PeopleSoft)    [Q&A, ESC, 2001]
Error "The required environment variable SQRDIR has not been defined"    [Blog, SparkPath, 2005]
Error (Excel) "Cannot read record __"*    [Q&A, SQRUG, 2005]
Error 10083: "Memory fault (coredump)"*    [Q&A, SQRUG, 2004]
Error 1302: "SQL buffer too small"*    [Q&A, SQRUG, 2005]
Error 1302: "SQL buffer too small"*    [Q&A, SQRUG, 2005]
Error 1303: "Error in SQL (perhaps missing &name after expression)"*    [Q&A, SQRUG, 2005]
Error 1305: "CMPSQL : Unknown data type in database: 187"*    [Q&A, SQRUG, 2005]
Error 1308: "Could not bind column <n>"*    [Q&A, SQRUG, 2004]
Error 1400: "Only numerics allowed for arithmetic"*    [Q&A, SQRUG, 2004]
Error 3601: "Out of substitution or #DEFINE variables"*    [Q&A, SQRUG, 2005]
Error 3719: "Columns names and expressions must be unique..."*    [Q&A, SQRUG, 2004]
Error 3719: "Columns names and expressions must be unique..."*    [Q&A, SQRUG, 2004]
Error 4407: "Referenced variables not defined"*    [Q&A, SQRUG, 2004]
Error 4603: "GRAPHIC VERT-LINE out of bounds"*    [Q&A, SQRUG, 2005]
Error 4604: "GRAPHIC HORZ-LINE out of bounds"*    [Q&A, SQRUG, 2005]
Error 4705: "Program line too long; maximum is 511"*    [Q&A, SQRUG, 2005]
Error 4713: "Cannot open the #INCLUDE file"    [Q&A, PSFans, 2004]
Error 4735: "Unknown variable type encountered in run-time file"*    [Q&A, SQRUG, 2004]
Error 4747: "The SQT file is corrupted and cannot be processed"*    [Q&A, SQRUG, 2004]
Error 5400: "Second page write attempted while writing current page"*    [Q&A, SQRUG, 2004]
Error 5400: "Second page write attempted while writing current page"*    [Q&A, SQRUG, 2003]
Error 5400: "Second page write attempted while writing current page"*    [Q&A, SQRUG, 2004]
Error 5403: "Error writing the output file"*    [Q&A, SQRUG, 2004]
Error 5528: "...Formal parameter '@Pnn' ..."*    [Q&A, SQRUG, 2004]
Error 5528: "ORACLE OCIServerAttach error 12154 in cursor 0..."*    [Q&A, SQRUG, 2006]
Error 6806: "String2Em: String to Decimal Object Conversion Error"*    [Q&A, SQRUG, 2003]
Error 6806: "String2Em: String to Decimal Object Conversion Error"*    [Q&A, SQRUG, 2004]
Error 7715: "Failed to start the Java Virtual Machine (JVM)"*    [Q&A, SQRUG, 2004]
Error 7715: "Failed to start the Java Virtual Machine (JVM)"*    [Q&A, SQRUG, 2004]
Error ORA-01002: "Fetch out of sequence"*    [Q&A, SQRUG, 2004]
Error ORA-01406: "Fetched column value was truncated"*    [Q&A, SQRUG, 2003]
Error ORA-01458: "invalid length inside variable character string"*    [Q&A, SQRUG, 2006]
Error ORA-01652: "Unable to extend temp segment"*    [Q&A, SQRUG, 2004]
Error ORA-03113: "End-of-file on communication channel"*    [Q&A, SQRUG, 2005]
Error PLS-00306: "Wrong number or types of arguments in call"*    [Q&A, SQRUG, 2003]
EVALUATE: Empty WHEN above WHEN-OTHER*    [Q&A, SQRUG, 2005]
Excel .CSV files, parsing    [Tool, ERPCommunity, 2004]
Excel file output, creating formulas in*    [Q&A, SQRUG, 2005]
Excel numeric values, formatting*    [Q&A, SQRUG, 2004]
Excel output files, controlling text characteristics with SYLK*    [Q&A, SQRUG, 2004]
Excel output files, methods for creating    [Blog, SparkPath, 2005]
Excel output files, types and name extensions    [Blog, SparkPath, 2005]
Excel printing properties*    [Q&A, SQRUG, 2005]
Excel reformats CSV output*    [Q&A, SQRUG, 2004]
Exclamation point (!) in strings*    [Q&A, SQRUG, 2005]
Extra pages print on HP printer*    [Q&A, SQRUG, 2003]
File path, variable based on environment*    [Q&A, SQRUG, 2004]
File system functions in SQR*    [Q&A, SQRUG, 2003]
First n rows, selecting*    [Q&A, SQRUG, 2004]
Flat files, creating with WRITE vs. PRINT*    [Q&A, SQRUG, 2005]
Font size*    [Q&A, SQRUG, 2006]
Font size, specifying*    [Q&A, SQRUG, 2004]
Font size, specifying*    [Q&A, SQRUG, 2004]
Font, selecting*    [Q&A, SQRUG, 2004]
Font, selecting    [Q&A, PSFans, 2005]
Foreign characters and ENCODING-DATABASE setting    [Q&A, PSFans, 2003]
Foreign characters, converting to ASCII (Oracle Unicode)    [Q&A, PSFans, 2004]
Foreign/accented characters display incorrectly*    [Q&A, SQRUG, 2004]
Foreign/accented characters do not print*    [Q&A, SQRUG, 2004]
Foreign/accented characters do not print    [Q&A, PeopleSoft, ]
Foreign/accented characters not handled correctly*    [Q&A, SQRUG, 2005]
Foreign/accented characters, sorting*    [Q&A, SQRUG, 2004]
FTP from Unix: Generating shell script in SQR*    [Q&A, SQRUG, 2005]
FTP from within SQR    [Q&A, PSFans, 2004]
FTP using CALL SYSTEM*    [Q&A, SQRUG, 2004]
FTP, closing report before*    [Q&A, SQRUG, 2004]
Global and local variables    [Blog, SparkPath, 2004]
Global and local variables*    [Q&A, SQRUG, 2004]
Global vs. local variables: Accessing; pros and cons*    [Q&A, SQRUG, 2004]
Header record, skipping in input file*    [Q&A, SQRUG, 2004]
HEADING-SIZE*    [Q&A, SQRUG, 2005]
Headings and footings, different sizes, dynamic*    [Q&A, SQRUG, 2003]
Hints (Oracle) in SELECT*    [Q&A, SQRUG, 2003]
Hints (Oracle) in SELECT*    [Q&A, SQRUG, 2004]
Hints in BEGIN-SELECT (Oracle)*    [Q&A, SQRUG, 2006]
History of SQR*    [Misc, SQRUG, 2003]
HTML link in PDF file, creating*    [Q&A, SQRUG, 2005]
HTML tables in output    [Q&A, ERPCommunity, 2005]
HTML, creating and rendering in SQR*    [Q&A, SQRUG, 2004]
Images, printing    [Q&A, PSFans, 2005]
Images, printing, path and file format    [Q&A, PSFans, 2003]
Images, printing, specifying path    [Q&A, PSFans, 2003]
Index, hint to use, Oracle*    [Q&A, SQRUG, 2004]
Input file data truncated*    [Q&A, SQRUG, 2004]
Input file, comparing with previous version to eliminate duplicate processing*    [Q&A, SQRUG, 2003]
Input files, multiple, identifying    [Q&A, PSFans, 2005]
Input parameters: Several methods (1)*    [Q&A, SQRUG, 2003]
Input parameters: Several methods (2)*    [Q&A, SQRUG, 2003]
INSERT error, detecting*    [Q&A, SQRUG, 2004]
INSERT errors (duplicates), checking for using ON-ERROR*    [Q&A, SQRUG, 2004]
Integer values*    [Q&A, SQRUG, 2004]
ISBLANK()*    [Tip, SQRUG, 2006]
Italic font*    [Q&A, SQRUG, 2005]
Last n characters of string    [Q&A, ERPCommunity, 2005]
Last occurrence of a substring*    [Q&A, SQRUG, 2006]
Leading zeros in CSV files, preserving*    [Q&A, SQRUG, 2005]
Leading zeros suppressed by Excel*    [Q&A, SQRUG, 2004]
Line delimiters in text files*    [Q&A, SQRUG, 2006]
Line height, changing on the fly*    [Q&A, SQRUG, 2003]
Linked tables (MS Access, Oracle)*    [Q&A, SQRUG, 2004]
Linux, installing SQR on*    [Q&A, SQRUG, 2004]
LIS file unreadable (PCL-format output)*    [Q&A, SQRUG, 2005]
Log file, opening during SQR execution*    [Q&A, SQRUG, 2004]
Logos/images, printing    [Q&A, PSFans, 2005]
Long descriptions on same row of report: Wrapping text*    [Q&A, SQRUG, 2003]
Long file names not created*    [Q&A, SQRUG, 2005]
LONG RAW and CLOB column values (Oracle)*    [Q&A, SQRUG, 2004]
Lookup table, listing contents of*    [Q&A, SQRUG, 2005]
Mainframe files (from COBOL), processing with SQR*    [Q&A, SQRUG, 2005]
Maximum n values*    [Q&A, SQRUG, 2004]
Menus and screen positioning functions*    [Q&A, SQRUG, 2004]
MICR font*    [Q&A, SQRUG, 2005]
MOVE vs. LET: Performance*    [Q&A, SQRUG, 2004]
Multiple reports in PeopleSoft Process Scheduler    [Q&A, PSFans, 2004]
Multiple reports in PeopleSoft Process Scheduler    [Q&A, ERPCommunity, 2005]
Multiple reports, one to printer, one to file*    [Q&A, SQRUG, 2004]
Multiple reports, specifying file names of*    [Q&A, SQRUG, 2004]
Multiple reports, viewing online (PeopleSoft)    [Q&A, PSFans, 2005]
Negative line positioning*    [Q&A, SQRUG, 2004]
Nested BEGIN-SELECTs: Order of execution*    [Q&A, SQRUG, 2004]
Null vs. blank values in strings    [Q&A, PSFans, 2005]
NULL vs. empty string, distinguishing between*    [Q&A, SQRUG, 2004]
Numbers converted to words    [Q&A, PSFans, 2005]
Numeric #variables, writing to output file*    [Q&A, SQRUG, 2005]
Numeric comparisons and rounding errors*    [Q&A, SQRUG, 2003]
Numerics in strings, validating*    [Q&A, SQRUG, 2004]
ON-BREAK BEFORE= parameter, behavior*    [Q&A, SQRUG, 2003]
ON-BREAK for part of a value*    [Q&A, SQRUG, 2004]
ON-BREAK generates blank lines*    [Q&A, SQRUG, 2004]
OPRID and RUN_CNTL_ID values (PeopleSoft)*    [Q&A, SQRUG, 2005]
Optimization level, setting (DB2)*    [Q&A, SQRUG, 2004]
ORDER BY variable within SELECT*    [Q&A, SQRUG, 2004]
Output directory, determining (PeopleSoft)*    [Q&A, SQRUG, 2004]
Output file names, dynamic*    [Q&A, SQRUG, 2004]
Output files become corrupted when processed or emailed*    [Q&A, SQRUG, 2004]
Output files, size limitations on Unix*    [Q&A, SQRUG, 2004]
Output in both PDF and CSV formats*    [Q&A, SQRUG, 2004]
Page heading (or file) does not match page data*    [Q&A, SQRUG, 2005]
Page heading (or file) does not match page data    [Q&A, PSFans, 2005]
Parameters from a file: Several methods*    [Q&A, SQRUG, 2004]
Password and user ID, hiding on command line*    [Q&A, SQRUG, 2004]
Password, hiding on SQR command line, Unix*    [Tip, SQRUG, 2004]
PDF file name, controlling when multiple reports produced*    [Q&A, SQRUG, 2003]
PDF output file, extra pages at end*    [Q&A, SQRUG, 2004]
PDF output in Brio Portal*    [Q&A, SQRUG, 2004]
PDF, generating directly from SQR*    [Q&A, SQRUG, 2005]
Performance tuning*    [Q&A, SQRUG, 2003]
Performance tuning*    [Q&A, SQRUG, 2004]
Performance tuning    [Q&A, PSFans, 2005]
PL/SQL procedure, Oracle, executing from SQR*    [Q&A, SQRUG, 2005]
PRINT relative offset of 0 (+0)*    [Q&A, SQRUG, 2005]
PRINT-IMAGE file types*    [Q&A, SQRUG, 2004]
PRINT-IMAGE produces shaded box    [Q&A, PSFans, 2004]
PRINT-IMAGE, EPS files*    [Q&A, SQRUG, 2003]
Printed elements, precise positioning of    [Blog, SparkPath, 2004]
Printer-specific characters in report file*    [Q&A, SQRUG, 2005]
Printing .LIS file*    [Q&A, SQRUG, 2006]
Printing directly to client printer*    [Q&A, SQRUG, 2004]
Printing tips and techniques    [Tip, PeopleSoft, ]
Printing to LPT1 through the PeopleSoft Process Scheduler    [Tip, PeopleSoft, ]
Prior month, determining*    [Q&A, SQRUG, 2004]
Process Monitor status, updating (PeopleSoft)    [Tip, PeopleSoft, ]
Process request (PeopleSoft), creating from SQR    [Q&A, PSFans, 2003]
Process Scheduler (PeopleSoft) status: API    [Q&A, PSFans, 2004]
Process Scheduler (PeopleSoft), running SQR through    [Q&A, ERPCommunity, 2004]
Proportional fonts, computing size of strings*    [Q&A, SQRUG, 2004]
Proportional-font text, determining length of*    [Q&A, SQRUG, 2005]
Pushbutton, running SQR from (PeopleSoft)    [Q&A, PSFans, 2003]
Quote character in a string*    [Q&A, SQRUG, 2006]
Quotes, single, in SQL strings*    [Q&A, SQRUG, 2005]
Re-linking SQR and Oracle on Unix    [Tip, PeopleSoft, ]
READ, maximum length of data string*    [Q&A, SQRUG, 2005]
Reading a file with no carriage returns*    [Q&A, SQRUG, 2005]
Reading/writing flat files: Basic loop structure*    [Q&A, SQRUG, 2003]
Recursion in SQR    [Blog, SparkPath, 2004]
Recursion in SQR*    [Q&A, SQRUG, 2004]
Removing characters from a string    [Q&A, ERPCommunity, 2005]
Removing special characters from a string*    [Q&A, SQRUG, 2004]
RENAME() fails*    [Q&A, SQRUG, 2004]
Restartability, implementing in SQR    [Q&A, PSFans, 2002]
Right-justifying text within a field    [Q&A, ERPCommunity, 2006]
Rotated text printing*    [Q&A, SQRUG, 2005]
Rounding to multiples of 10*    [Q&A, SQRUG, 2006]
Rounding up*    [Q&A, SQRUG, 2006]
Rounding using PS_SQR_ROUND (PeopleSoft)    [Q&A, PSFans, 2005]
RTRIM or LTRIM do not remove a substring from a string*    [Q&A, SQRUG, 2004]
RTRIM or LTRIM do not remove a substring from a string*    [Q&A, SQRUG, 2004]
Run control in SQR (PeopleSoft)    [Blog, SparkPath, 2004]
Running SQR using third-party tools    [Q&A, ERPCommunity, 2006]
Servlet, calling from SQR*    [Q&A, SQRUG, 2004]
Set processing in SQR    [Q&A, PSFans, 2005]
SET-COLOR*    [Q&A, SQRUG, 2005]
SET-DELAY-PRINT*    [Q&A, SQRUG, 2003]
SET-GENERATIONS, SET-LEVELS, SET-MEMBERS*    [Q&A, SQRUG, 2004]
Simplify SQR code    [Blog, SparkPath, 2004]
Skipping rows in SELECT*    [Q&A, SQRUG, 2003]
Sorting array values    [Q&A, PSFans, 2003]
SPF file name, controlling when multiple reports declared*    [Q&A, SQRUG, 2003]
SPF file produced instead of LIS*    [Q&A, SQRUG, 2003]
SPF files: Contents; viewing*    [Q&A, SQRUG, 2004]
SPF files: overview*    [Q&A, SQRUG, 2005]
SQL text, viewing ($SQL-TEXT variable)*    [Q&A, SQRUG, 2004]
SQR Process vs. SQR Report (PeopleSoft)*    [Q&A, SQRUG, 2004]
SQRDIR not defined    [Q&A, PSFans, 2003]
SQRP, calling from SQR to reformat output*    [Q&A, SQRUG, 2004]
SQRW not responding*    [Q&A, SQRUG, 2003]
SQRW, configuring (PeopleSoft)    [Q&A, ERPCommunity, 2005]
SQRW, running SQR programs under    [Tip, PeopleSoft, ]
Stored procedure output parameters*    [Q&A, SQRUG, 2005]
Stored procedure, calling from SQR    [Q&A, PSFans, 2003]
Stored procedure, calling from SQR*    [Q&A, SQRUG, 2005]
Stored procedure, calling from SQR    [Q&A, PSFans, 2005]
Stored procedure, executing from within SQR (Oracle)*    [Q&A, SQRUG, 2005]
Stored procedure, MS SQL Server, calling*    [Q&A, SQRUG, 2004]
Strike-through*    [Q&A, SQRUG, 2003]
String compare fails (extra spaces, displaying)*    [Q&A, SQRUG, 2004]
Subselects, wrapping within SQR BEGIN-SELECT*    [Q&A, SQRUG, 2005]
Substitution variables: Introduction    [Blog, SparkPath, 2004]
Substitution variables: Uses    [Blog, SparkPath, 2004]
Sybase compatibility issues*    [Q&A, SQRUG, 2005]
SYLK format files, creating*    [Tip, SQRUG, 2004]
Temporary table, creating in SQR (Oracle)*    [Q&A, SQRUG, 2004]
Temporary tables in BEGIN-SETUP section*    [Q&A, SQRUG, 2005]
Temporary tables, dropping (Sybase)*    [Q&A, SQRUG, 2004]
Timestamp of a file*    [Q&A, SQRUG, 2004]
TOP <n> rows*    [Q&A, SQRUG, 2005]
TOP in BEGIN-SELECT (MS SQL Server)*    [Q&A, SQRUG, 2005]
TOP-MARGIN ignored*    [Q&A, SQRUG, 2003]
Totals, printing on first line*    [Q&A, SQRUG, 2005]
Training courses*    [Q&A, SQRUG, 2004]
Trees, navigating with SQR (PeopleSoft)*    [Q&A, SQRUG, 2005]
Troubleshooting SQR errors: General techniques    [Tip, PeopleSoft, ]
Unicode in SQR, frequently asked questions    [Tip, PeopleSoft, ]
Unicode, disabling in SQR*    [Q&A, SQRUG, 2003]
UNION in SQR    [Q&A, PSFans, 2004]
Unix and Windows execution, determining environment (PeopleSoft)    [Q&A, PSFans, 2003]
Unix shell script, executing SQR from*    [Q&A, SQRUG, 2004]
UNSTRING examples*    [Q&A, SQRUG, 2002]
UNSTRING on a record with a variable number of fields*    [Q&A, SQRUG, 2005]
Variable name containing hyphen (#COUNT-1)*    [Q&A, SQRUG, 2003]
Variable names containing special characters    [Blog, SparkPath, 2005]
Vertical printing*    [Q&A, SQRUG, 2004]
Vertical printing*    [Q&A, SQRUG, 2004]
Warning 7501: "Using YY edit mask from (DD-MON-YY)" (1)*    [Q&A, SQRUG, 2003]
Warning 7501: "Using YY edit mask from (DD-MON-YY)" (2)*    [Q&A, SQRUG, 2003]
WHERE IN(), dynamic, generating*    [Q&A, SQRUG, 2004]
Word format, creating SQR output in*    [Q&A, SQRUG, 2005]
WRAP allocates extra blank line*    [Q&A, SQRUG, 2003]
Wrapping text*    [Q&A, SQRUG, 2004]
{ and } characters misinterpreted as substitution variable*    [Q&A, SQRUG, 2004]