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
 
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
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 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
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

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