467,877 Members | 1,021 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

Data change table references and SQLCODE -20165

I am trying to insert the same set of data into two tables with the
same schema. One table is used for processing, the other for audit
purposes. I thought that I could use the data change table reference
FINAL TABLE to accomplish this, but I am getting a -20165 SQLCODE in
the bind step of compilation (DB2 v8 + COBOL on z/OS). Basically, the
statement looks like this:

INSERT INTO AUDIT_TABLE
SELECT * FROM FINAL TABLE (
INSERT INTO PROCESSING_TABLE
VALUE1, VALUE2, VALUE3
)

Is this simply too deeply nested?

Sep 6 '07 #1
  • viewed: 1156
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by efiryago | last post: by
1 post views Thread by Ravi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.