The SQR command supports several flags. Each flag begins with a dash (-). Flags with arguments must be followed directly by the argument with no intervening space.

SQR Command-Line Flags :Flag Description :

• A Causes the report output to be appended to an existing file of the user name
• Bnn (Oracle,SYBASE CT-Lib) indicates how many rows to buffer each time data is retrieved from the database. The DEFAULT is 10 rows.
• C Specifies that the cancel dialog box appear while the program.
• CB (Callable SQR) forces the communication box to be used.
• DEBUG (xxx) (Sybase) Causes lines preceded by #DEBUG to be compared. Without this flag, these lines are ignored.
• E(file) Causes error messages to be directed to the named file, or to the default file report errs. If no errors OCCUR, no file is created.
• F (file) (Directory) overrides the default output file name program .lis
• KEEP In addition to .LIS files, creates an .SPF file for each report that your program generates.
• LOCK(RR]CS]RO]RL]XX] (SQL Base) Defines the types of locking (isolation level for the session.
• NR (SQL Base) specifies that the No Recovery mode is used when connecting to the database.
• XCB Do not USE the communication box.
• XL Prevents SQR from logging on to the database. Programs run in this mode cannot contain any SQL statements.
• XMB Disables the error message display so that a program can be run without interruption by error message boxes.
• XP (SYBASE DB-Lib) Prevents SQR from creating temporary stored pro-cedures.
• XTB Preserves the trailing blanks in an LIS file.
• ZIV Invokes the SPF viewer after generating program .spf file. Using this flag implicitly invokes the –KEEP flag to create program .spf file. 
• ZMF(File) specifies the full path and name of the SQR Error Message file. The Sqr err.dat located in the directory indicated by the SQR DIR environment Variable is the default.

The SQR command supports several flags. Each flag begins with a dash (-). Flags with arguments must be followed directly by the argument with no intervening space.

SQR Command-Line Flags :Flag Description :