[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?
- Subject: Syntax question - how do you continue to the next line on a load lookup where clause?
- From: Debra Benton <debra.benton@NPAC.COM>
- Date: Thu, 8 Jul 1999 12:44:28 -0500
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'''