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 REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts Protection Exception while move 0 to ... Kevin Vaz CICS 10 Tue Oct 18, 2016 4:19 pm
No new posts Creating a dynamic sort card in JCL u... ChitraChhabra DFSORT/ICETOOL 4 Wed Aug 03, 2016 6:15 pm
No new posts Need help on SQL Dynamic WHERE Clause subratarec DB2 12 Sat Jul 16, 2016 3:11 pm
No new posts Is it possible to pass variables of s... Csongor CLIST & REXX 2 Fri Jun 10, 2016 7:33 pm


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