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
( SELECT COLUMN_1
WHERE COLUMN_2 = : ws-var1 )
creator_remote_alias.TABLE_B is a alias pointing to another DB2 subsystem(remote alias).