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 COMP Variables Mismatch gayu7 COBOL Programming 5 Wed Dec 20, 2017 5:06 pm
No new posts Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 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 unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm

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