How to Make a Report from a Table › Creating Your Report From an SQL Table › Step 1— Select the type of table

Step 1— Select the type of table

When you sign on to CA OLQ, select the Session Options screen:

   V12 ENTER NEXT TASK CODE:
     olq menu options

For this example, select Y to access SQL tables:

     CA OLQ Release nn.n                          *** Session Options ***
 ->                                                       Page     1 of     2
107017 CA OLQ Release 16.0
107019 Copyright(C) 2003 CA,Inc.
    Current interrupt count:     100        Current underline character: -
    Access IDMS SQL tables:    Y (Y/N)      Current SQL NULL data value: .

    User options:               Page Columns Spread:    (L-Left,E-Even,M-Max,nn)
                  Change
        Help      Option        Current option    Alternate option

                                -> Report Processing Options <-

        _           _             NOFiller          FILler
        _           _             FULl              SPArse
        _           _             HEAder            NOHeader

                                -> Column Processing Options <-

        _           _             OLQheader         NOOlqheader
        _           _             PICture           NOPIcture
        _           _             CODetable         NOCODetable

 1=HELP           3=QUIT           4=MESSAGE           6=MENU           8=FWD

For more information about the access switch, refer to the CA OLQ Reference Guide.