Ah, hah! I missed it before. The above statement is not allowed
in dynamic SQL. You should code it as follows.
zSqlCmd = 'Values (Select count(*) from AXTRN01..UNITOFMEASURE +
where Symbol = ' + Q + %trim(pUOM) + Q +
') into ?;
values into is not standard SQL and won't work with diffrent databases.
The one and only problem is sitting in front of the Workstation.
exec sql select count(*) from whatever
where someColumn = :someColumn;
will do it (as stated in the included examples)
there is no need for dynamic sql - if I would absolutely use prepare:
you would prepare 'select count(*) into :someIt where some Column = ?'
and provide :someColumn with execute using.
The other way with a cursor and fetch into, I've posted pefore to this
Once again - and hopefully last time -
Darryl, folllow the examples, I've included with the distribution.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxx for any subscription related