MQSeries.net :: View topic

mmarq · Posted: Fri Oct 04, 2002 3:48 am Post subject:

I've got the following SQL to get through a passthru statement:

DECLARE c1 CURSOR WITH HOLD FOR
SELECT seed_value
FROM sequence_table
WHERE client_column_name = 'abp_unq_id'
FOR UPDATE OF seed_value;

OPEN c1;
FETCH c1 INTO v_seed_value;
UPDATE sequence_table
SET seed_value = (v_seed_value + 1)
WHERE client_column_name = 'abp_unq_id';
CLOSE c1;

I've placed the first part (first ; ends the first part) into a passthru statement and I get the following in the exception list:

IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token
"DECLARE c1 CURSOR WITH HOLD FOR" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include: "<space>". SQLSTATE=42601

Can anyone think of a way for me to run this SQL?

Thanks,
M
_________________
M Marquis