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
 

 

SQLDA can have both Host variables and columns

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
blpraveen123
Currently Banned

New User


Joined: 26 Apr 2007
Posts: 12
Location: Mysore

PostPosted: Tue Jun 19, 2007 2:27 pm    Post subject: SQLDA can have both Host variables and columns
Reply with quote

Hi all,

Can it be possible to use the same SQLDA for the holding the Columns
details and the Host variables.

Code:


SQL Code in WS-SQL-STATEMENT ....................
EXEC SQL
       SELECT  CAST(? AS CHAR(10)), CAST(? AS INTEGER)
       FROM    TABLE1
       WHERE  EMP-NO = ?
END-EXEC

EXEC SQL
       PREPARE  SQLQERY INTO:SQLDA FROM  :WS-SQL-STATMENT
END-EXEC


EXEC SQL
       EXECUTE  SQLQERY USING :SQLDA
END-EXEC


Can the SQLVAR contain the Column Description as well as Host variables
description to be passed to the SQL Statement.

Back to top
View user's profile Send private message

Suryanarayana.tadala

New User


Joined: 03 Nov 2005
Posts: 43
Location: St.Louis

PostPosted: Sat Jun 23, 2007 1:44 am    Post subject:
Reply with quote

Yes
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
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts Protection Exception while move 0 to ... Kevin Vaz CICS 10 Tue Oct 18, 2016 4:19 pm
No new posts Is it possible to pass variables of s... Csongor CLIST & REXX 2 Fri Jun 10, 2016 7:33 pm
No new posts PC to Host for unicode file Tom Steiner TSO/ISPF 5 Mon May 16, 2016 10:38 pm


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