SQR Frequently Asked Questions

• General SQR Questions:
  
• SQR3 Questions:
  
• Easy SQR Questions:
  
• Oracle Specific SQR Questions:
  

---

General SQR Questions
Provided by the MITI Technical Support Group
Revised on March 8, 1995. These questions pertain to SQR Version 2.5

• I am getting 'out of memory' error using an array in my SQR on a PC. Why?
• Can I read and write null values from and to an ASCII file?
• How can I suppress display of the SQR banner line when running SQR?
• How can I prevent the printing of the empty page at the end of every .LIS file?
• How can I bold portions of a background document?
• How to use CALL SYSTEM USING on PC, Windows?
• What is the value used with -C flag of BEGIN-SELECT?
• What is the limit for SQR command line length on PC/Windows?
• Can I set the current page number in an SQR program?
• Can a .sqt file be "de-compiled" into the original SQR code?
• Can I use 'dynamic column names' in Begin-Select (versions prior to v3.0)?
• Do SQR programs require a .sqr extension? Do SQR runtime files require a .sqt extension?
• What determines the file permissions for files that SQR creates?
• How do I reference SQR global variables inside of a local procedure?
• My printer is splitting output from SQR that contains graphics into two pages. Is there anything I can do about it?
• How can I run SQR so that the database username/password does not show up in the Process Status (ps) listing on a unix machine (like an HP).
• How can I insert a null value into a numeric field in the database? I tried not giving a #variable a value but that did not work, 0 was inserted.
• In BEGIN-SELECT do the FROM and WHERE clause have to be aligned to the left margin?
• If I get a duplicate key warning message when SQR loads a lookup table, will the lookup table still work correctly.
• Can I write a matrix report in SQR?
• What is the maximum value for -M file parameters?
• My ON-BREAK is not working as I am expecting it to work. Why?
• How can I get page 'x of y' on my output (versions prior to v3.0.x)?
• How can I change to the lower paper tray on an HPLaserJet or Postscript printer?
• Can I incorporate a logo into my SQR output (versions prior to v3.0.x)?
• Do I have to relink SQR after installing it?
• How can I find out if rows are selected by a BEGIN-SELECT paragraph? Can I use the SQR variable #sql-count?
• How do I print subscript and superscript characters for chemical equations and footnote indicators?
• How can I get the system date into SQR when not running the report against a database?
• How can I read in variable length delimited fields from a sequential file? An example format would look like this:
• Are SQR commands and variables case sensitive?

---

SQR3 Questions
Provided by the MITI Technical Support Group
Revised on March 8, 1995. These questions pertain to SQR Version 3.0.

• Do I have to have the DECLARE-LAYOUT before a DECLARE-REPORT that uses it?
• Does DECLARE-PRINTER by itself do anything?
• How many DECLARE-PRINTER commands can a program have?
• How to use the -F command line flag for multiple reports?
• In the above example, what would be the names of the SPF files if we use a -keep command line flag?
• How do I have different reports generate output for different printers in the same program?
• I ran a program with SQR Version 3 and did not specify either -keep or -nolis. During the running of my program a file with the extension .s01 was present, after the report finished it was gone. Why was this file created.
• What's the effect of the -PRINTER command line flag in a multiple report program?
• Is a name required in a DECLARE-PRINTER commands? Where is the name used in the program?
• How can I print the output file from inside my SQR program on DOS, Windows, Unix, and VMS platforms?

---

Easy SQR Questions

• I added a new column to a table and then loaded a stored session (.ESQ) file. The new column is not present in the list of accessible columns.

---

Oracle Specific SQR Questions

• Why does Easy SQR hang at database access?
• What causes the "Fetch out of Sequence" error?
• How to call SQR from SQL*Forms 3.0 on a UNIX platform (SQR v2.5.x/3.0.x - Oracle v6/7)
• How to call SQR from SQL*Forms 3.0 on a VMS or OpenVMS platform (SQR v2.5.x /3.0.x - Oracle v6/7)
• Does SQR support the use of optimizer hints for the ORACLE database?
• How do I resolve undefined, unresolved symbols that sometimes occur during linking of SQR on unix paltforms?
• Are ORACLE OPS$ accounts supported in a connect string for SQR?
• Does SQR support use of ORACLE PL/SQL blocks and stored functions and procedures?

---