IBM Mainframe Forum

HI, I need to code the following SQL in a COBOL program. But the insert from subselect from a remote alias is not valid in DB2 V9. Can someone advise possible options to over come the issue please . I thought to write to a temporary dataset first and then inserting from that. Is this the way forward or is there a better option ?
EXEC SQL INSERT
INTO creator1.table_A
( SELECT COLUMN_1
FROM creator_remote_alias.TABLE_B
WHERE COLUMN_2 = : ws-var1 )

creator_remote_alias.TABLE_B is a alias pointing to another DB2 subsystem(remote alias).

in your cobol program :


ideally use "multi-row" fetch and insert

Thanks for th advice .

Hi GuyC,

The initial SQL(below) fail due to multiple record insert or even for a single record insert will it fail ? I 'm trying to understand weather db2 allows this SQL insert for single row or not ?

INTO creator1.table_A
( SELECT COLUMN_1
FROM creator_remote_alias.TABLE_B
WHERE COLUMN_2 = : ws-var1 )

Hello,

Please post the link where you found this documented in a DB2 manual. . .

You MUST use valid syntax provided by the product - not make some up to fit your need.

Thanks Dick,
What you are saying is the above syntax is not valid at all even for a single record insert ?

Hello,

Yes, the syntax is incorrect. . .

Thanks Dick, What's the best material to learn more about this ?

Hello,

Probably the SQL Reference and the SQL Programmng Guide for your release of db2.

These are available for download free from IBM.