how about using - at end of line and starting at next line ...
'-' is use as continuation
-----Original Message-----
From: Debra Benton [mailto:debra.benton@NPAC.COM]
Sent: Thursday, July 08, 1999 10:44 AM
To: Multiple recipients of list SQR-USERS
Subject: 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'''