Setting SQL SELECT and Call options

To set SQL SELECT and Call options

1. From the Primary Menu panel, an object list panel, or a utility panel, on the Command line, type OPTIONS (OPT) and press Enter.
   The Options panel is displayed.

2. In the SQL Select and Call options field, type Y and press Enter.The SQL Select and Call panel is displayed below:

                                SQL Select and Call                     1 to 8 of 8
    Command ===>                                                  Scroll ===> PAGE
                                                                                  
    Browse SQL output dataset. . . . Y         Y/N Y-Automatically browse dataset  
                                                                                  
    Maximum output line length . . . 256       1-4092 (Select only)                
    Maximum numeric field width. . . 10                                            
    Maximum char field width . . . . 64                                            
    Maximum varchar field width. . . 64                                            
                                                                                  
    Output format. . . . . . . . . . C         C/R C-Column format, R-Row format   
                                                                                   
3. In the Browse SQL output dataset field, type Y or N to specify whether to automatically browse the SQL output data set after executing SQL.
4. In the Maximum output line length field, type the maximum number of characters in a single line of output. Valid values are 1 through 4092. The value that you specify must be smaller than the LRECL of the BMCCAT.SQL data set.
5. In the Maximum numeric field width field, type the maximum number of digits in a numeric field.
6. In the Maximum char field width field, type the maximum number of characters in a character field.
7. In the Maximum varchar field width field, type the maximum number of characters in a VARCHAR field.

8. In the Output format field, type one of the following values to select the default order in which the results of stored procedures or SQL SELECTS are written to the SQL output data set:

   Value	Description
   C	Column format writes all data for a row on a single line with headings above each column of data
   R	Row format writes each column of data on a new line with headings to the left of the data

   Warning

   Note

   All stored procedure parameters are written in row format regardless of the output format selected.

9. Press END to return to the Options panel.