UPDDTA FILE(RJSIMAGE/DOCLS00)
For example: CUSNUM >= 300000 and CUSNUM <= 399999
For example: QIWS/QCUSTCDT
For example (a character field): LSTNAM
For example (an expression):'Timesheet for ' concat strip(init) concat ' ' concat strip(lstnam)
For example (a numeric field displayed as a character field): CHAR(CUSNUM)
For example (a character field): LSTNAM
For example (an expression):'Timesheet for ' concat strip(init) concat ' ' concat strip(lstnam)
For example (a numeric field displayed as a character field): CHAR(CUSNUM)
Note: You must have a value for at least one of LSLOOKUP1 or LSLOOKUP2.
Note: You must have a value in at least one of LSLOOKUP1 and LSLOOKUP2 for the columns to display.
The following example creates a look-up using the document title when all Document Types are selected. This look-up accesses the QCUSTCDT customer sample file in library QIWS, selects customer numbers 1 through 999999, and only allows the user to select the customer number.
LSDOCTYPE:
LSKEYVAL: TITLE
LSSQLSTM: CUSNUM >= 1 AND CUSNUM <= 999999
LSTABLE: QIWS/QCUSTCDT
LSLOOKUP1: CHAR(CUSNUM)
LSLOOKUP2: LSTNAM
LSLOOKTYP1:
LSLOOKTYP2: N
A list of customer selections displays for custom information.
Still have questions? We can help. Submit a case to Technical Support.