[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Syntax question - how do you continue to the next line on a load lookup where clause?



Hopefully this is an easy syntax question:

My load-lookup has a lengthy where clause that I would like to put on
several lines to make it easier to read in the future.  How can I continue
on the next line?  I've tried the underscore at the end of the line with no
success.

Thanks,
Debbie

load-lookup
  name=RGN-DESCR
    table=PS_SUBCUST_Q1_TBL
    key=SUBCUST_QUAL1
    return_value=DESCR
    where='EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_SUBCUST_Q1_TBL A_ED WHERE
SETID = A_ED.SETID AND SUBCUST_QUAL1 = A_ED.SUBCUST_QUAL1 AND A_ED.EFFDT <=
SYSDATE) AND SETID = ''CIS00'''