Defaults for Adabas Native SQL

The Modify Adabas Native SQL Defaults screen is called with code A in the Defaults menu or with the command DEFAULT SQL.

    13:37:23             *****  P R E D I C T  *****                     2007-05-31
                        -Modify Adabas Native SQL Defaults -
                                                          Added 2006-01-31 at 10:23
                                                       Modified 2006-01-31 at 13:19
    Adabas Native SQL defaults
      Non-descriptor search allowed .... Y (Y,N)
      Use of soft-coupling allowed ..... Y (Y,N)
   
    Adabas Version 5 open options
      ISN held incore .................. 
      Max. number of held ISNs .........
      Nonactivity time limit (TNAE) ....
      Transaction time limit (TT) ......
      Maximum time for an Sx command ...
      Maximum active command ids .......
   
    Used global format ID counter ...... 
   
    Database number of FDIC ............ 180
    File number of FDIC ................ 220
Parameters
Adabas Native SQL defaults
Non-descriptor search allowed

Determines whether the Adabas non-descriptor search used by Adabas Native SQL is allowed.

  • Y
    The ADASQL NONDE clause can be specified as Y or D.

  • N
    The NONDE clause can only be set to N.

The parameter NONDE controls the use of a non-descriptor field in the WHERE clause of the SELECT statement. NONDE=Y implies that at least one of the fields contained in the WHERE-clause is a descriptor.

Use of soft-coupling allowed

Determines whether the Adabas soft-coupling facility used by Adabas Native SQL is allowed.

  • Y
    The ADASQL SOFT clause can be set to Y.

  • N
    The ADASQL SOFT clause can only be set to N.

The parameter SOFT controls the use of the soft-coupling facility between two different files in the WHERE clause of the SELECT statement.

Adabas Version 5 open options These values are the upper limits for the corresponding parameters of the Adabas CONNECT statement and are described in the section Adabas Native SQL Statements (Statement CONNECT) in the Adabas Native SQL Reference documentation.
Used global format ID counter Used to form the global format ID. See description of options parameter GFORMAT in the section "Global parameters" in the "Adabas Native SQL Reference documentation".
Database/File number of FDIC See description of the parameter SYSFILE in the section Global Parameters in the Adabas Native SQL Reference documentation.