Re: Calling a SQL script with parameters from CL program

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Dina
this "home grown" command might be of interest to you
http://www.mcpressonline.com/programming/sql/using-dynamic-sql-in-cl-part-1running-action-queries.html



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


                                                                       
             dina ramzy                                                
             <dina.ramzy@live.                                         
             com>                                                       To
             Sent by:                  <midrange-l@xxxxxxxxxxxx>       
             midrange-l-bounce                                          cc
             s@xxxxxxxxxxxx                                            
                                                                   Subject
                                       Calling a SQL script with       
             03/02/2010 08:11          parameters from CL program      
             AM                                                        
                                                                       
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       





Dear All



I have a small question...



I have some SQL statements that I will put in a SQL Script, and I will run
these script from CL program (using RUNSQLSTM command) ...



If I have something like this:

SELECT FLD1,FLD2,FLD3,FLD4

FROM MYFILE

WHERE FLD1 = '20080228';



Can I pass parameters from my CL program to a script in order to avoid hard
coding the date '20100228' ?



If yes, how can I do this in both CL & script ?



Thanks in advance for your help



Dina







_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.