Specifying File Key Lists in I/O Commands

Many of the LANSA database I/O commands allow the specification of a file key. In all cases the method and logic used to set up the file key is identical.

The following points should be noted about specifying file keys:

       If, however, the command is specified as then LANSA will attempt to fetch the first record in file ORDLIN with an order number = 1 and a line number = 123456:

     FETCH   FROM_FILE(ORDLIN) WITH_KEY(#LINENO #ORDNUM)

       This is because the actual file keys are "order number" followed by "line number". LANSA processes the key fields nominated, by matching their position with the actual file keys, not by their names.

        but, it is not possible to specify:

     -----  -----  KEY03

     or -----  KEY02  KEY03

     or KEY01  -----  KEY03

Further Information

I/O Command Return Codes Table

I/O Status Record Locked