SQR Command-Line Arguments

The following table describes the SQR command-line arguments:

Argument Description

program

Name of the text file containing the source code. The default file type or extension is .sqr. If you enter this value as a question mark (?) or omit it, SQR for PeopleSoft prompts you for the report program name. On UNIX/Linux-based systems, if your shell uses the question mark as a wildcard character, you must precede it with a backslash (\).

connectivity

Information that SQR for PeopleSoft needs to connect to the database. If you enter this value as a question mark (?) or omit it, SQR for PeopleSoft prompts you for the information.

IBM DB2: Subsystem name and Structured Query Language (SQL) authorization ID.


                           Ssname/SQLid

Microsoft Windows or IBM DB2: The name of the database, your username, and the password for the database.

[Database] / [Username] / [Password]

Open Database Connectivity (ODBC): The name that you give to the ODBC driver when you set up the driver, and your username and password for the database. This port has been certified against IBM DB2 and Microsoft SQL Server.


                           Data_Source_Name/[Username]/[Password⇒
] 

Oracle: Your username and password for the database, and an optional connection string for the database (for example, @sales.2cme.com).

[Username]/[Password[@Database]] 

flags

See SQR Command-Line Flags.

args...

Arguments that SQR for PeopleSoft uses while the program is running. The ASK and INPUT commands use these arguments rather than prompting the user. You must enter arguments on the command line in the sequence that the program expects—first all ASK arguments, in order, followed by INPUT arguments.

@file...

File containing program arguments—one argument per line. Arguments that are listed in the file are processed one at a time: first all ASK arguments, in order, followed by INPUT arguments. You can specify the command-line arguments (program, connectivity, and args) in this file for non-Microsoft Windows platforms.