Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Using indexed variables in EZPLUS SRIDEVI TANTRY CA Products 1 Thu Feb 01, 2018 12:15 pm
No new posts Enterprise PL/I - dynamic allocation ... prino PL/I & Assembler 0 Mon Jan 29, 2018 10:17 pm
No new posts COMP Variables Mismatch gayu7 COBOL Programming 5 Wed Dec 20, 2017 5:06 pm
This topic is locked: you cannot edit posts or make replies. Need help how to pass the ESP variabl... Venkichaitu JCL & VSAM 12 Thu Nov 02, 2017 3:53 am
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us