blpraveen123 Currently Banned New User
Joined: 26 Apr 2007 Posts: 12 Location: Mysore
|
|
|
|
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.
|
|
|