Re: Using SQL CONNECT problem to MS SQL database

Dieter

I hear what you say about the incompatibility of the different databases.

Using :somelt is not valid.

If I am not wrong, it seems the only solution would be to open the file and
read each until I find the record I need to validate.

This is not elegant but may be the only solution.

The error reported is it does not like the colon (:) in 'select count(*)
into :someIt where some Column = ?

I am going to try it the long way. I'll let you know the results.

Thanks
Darryl

On Fri, Aug 26, 2016 at 12:28 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

<Dave>
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 ?;

Sincerely,

Dave Clark
</Dave>

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.
A simple

exec sql select count(*) from whatever
into :someint
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
list.

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,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.