Re: running sql from a cl to update

The variable name is case-sensitive.  If the variable name in the SQL
statement is lower case, as in your example, you must specify the variable
name in lower case on the STRQMQRY command (e.g., ...SETVAR(('frdte'
&FRDTE)...).

HTH

Brian Johnson
brian.johnson@helpsystems.com
Help/Systems, Inc.
ROBOT Automated Operations Solution
www.helpsystems.com






Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Brian Johnson/HelpSystems)

Subject:  running sql from a cl to update




I am trying to delete records from a file using an sql statement that I
send
parms to.  I get the following message when I run the CL:
"Type a value for variable "frdte" and press Enter"

The variable should be the parm I am sending in.  I have included my code,
If someone could point me in the right direction I would appreciate it!!!

SQL:
delete from library/file where field1 >= &frdte and field1 <= &todte

..




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---