Re: Syntax question - how do you continue to the next line on a l oad lookup where clause?

[Debra Benton <debra.benton@NPAC.COM>]

Thank you for the suggestion.  Unfortunately, I still receive the following
errors:
 
Error in include file "C:\debbie\invoices\bifulp03.sqc" on line 2757:
   (SQR 3501) Did not find end of literal.
'EFFDT = (SELECT MAX(A_ED.EFFDT) -
 
Error in include file "C:\debbie\invoices\bifulp03.sqc" on line 2758:
   (SQR 4115) Unknown command or extra parameters found (missing quotes?).
    FROM PS_BI_TYPE A_ED WHERE SETID = A_ED.SETID AND BILL_TYPE_ID =
A_ED.BILL_TYPE_ID AND A_ED.EFFDT <= SYSDATE) AND SETID = ''CIS00'''
 
Errors were found in the program file.
 
SQR: Program Aborting.
 
Thanks again,
Debbie
 

 

-----Original Message-----
From: Pankaj Bedekar [mailto:BedekarP@ALCONEMARKETING.COM]
Sent: Thursday, July 08, 1999 2:31 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Syntax question - how do you continue to the next line on a l
oad lookup where clause?



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
<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'''