Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
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

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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 8 Wed Jan 25, 2017 8:24 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 0 Wed Jan 25, 2017 8:23 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 0 Wed Jan 25, 2017 8:21 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us