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
 
use of host variables while preparing dynamic sqls in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
kulkarni_alok

New User


Joined: 07 Jul 2005
Posts: 4
PostPosted: Thu Jul 07, 2005 7:43 pm    Post subject: use of host variables while preparing dynamic sqls in DB2
 Reply with quote
Hi,

Can any one guide me on how we can use the Host variables while preparing dynamic sqls or can we do the following

String " where my_name = :name"
delimited by size into stmt.

exec sql
prepare s from : stmt
end exec.
Back to top
View user's profile Send private message
References
kulkarni_alok

New User


Joined: 07 Jul 2005
Posts: 4
PostPosted: Thu Jul 07, 2005 7:44 pm    Post subject: Re: use of host variables while preparing dynamic sqls in DB
 Reply with quote
kulkarni_alok wrote:
Hi,

Can any one guide me on how we can use the Host variables while preparing dynamic sqls or can we do the following

String " where my_name = :name"
delimited by size into stmt.

exec sql
prepare s from : stmt
end exec.


do we really have to use parameter markers before preparing the sqls
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1