Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
send SQL statment as a parameter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe COBOL
Author Message
hkalhor

New User


Joined: 20 May 2007
Posts: 29
Location: iran
PostPosted: Sat Oct 11, 2008 1:51 pm    Post subject: send SQL statment as a parameter
 Reply with quote
how can I send the SQL statement as a parameter ?
Back to top
View user's profile Send private message
References
PeD

Senior Member


Joined: 26 Nov 2005
Posts: 354
Location: Belgium
PostPosted: Sat Oct 11, 2008 2:50 pm    Post subject:
Reply with quote
Put in File, and read the input file. ???
Back to top
View user's profile Send private message
hkalhor

New User


Joined: 20 May 2007
Posts: 29
Location: iran
PostPosted: Sat Oct 11, 2008 4:28 pm    Post subject:
Reply with quote
Yes right but during declare a cursor after select where clause need to be
dynamic. but when I put " WHERE VAR1" that VAR1 is a variable contain condition it's not worked. would you please tell me what should i do.
Back to top
View user's profile Send private message
nitin_d

New User


Joined: 27 Oct 2005
Posts: 15
Location: Pune
PostPosted: Sat Oct 11, 2008 6:05 pm    Post subject:
Reply with quote
I would suggest using a dynamic SQL
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe COBOL All times are GMT + 6 Hours
Page 1 of 1