DTRHELP.HLB  —  Functions  FN$DBKEY_LENGTH, Example
       It is useful for example as an argument to the FN$STR_EXTRACT
       function, which extracts a substring from the input character
       string using a default edit string of 30 characters. In the
       following example FN$STR_EXTRACT extracts a substring from the
       100-character long field D. D is the variable, 1 is the starting
       character, and FN$DBKEY_LENGTH is the length of the desired
       substring:

       DTR> DECLARE D PIC X(100).;
       DTR> VAR = 1234567890
       DTR> PRINT FN$DBKEY_LENGTH("NULLS_1")

        FN$DBKEY
         LENGTH

                8

       DTR> PRINT FN$STR_EXTRACT (D,1,FN$DBKEY_LENGTH("NULLS_1"))

                  FN$STR
                  EXTRACT

       12345678
Close Help