Loading data from SQL server to DB2

ckintner · #1 (**permalink**) 06-23-04, 11:16

I'm trying to send data from a table on Microsoft SQL server to a DB2 table on the Main Frame and I get this error. Any ideas?

[IBM][CLI Driver][DB2]SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "UPDATABLE WORKFILE", type of resource: "100", and resource name: "TEMP DATABASE". SQLSTATE=57011

J Petruk · #2 (**permalink**) 06-24-04, 09:01

Quote:

Originally Posted by ckintner

I'm trying to send data from a table on Microsoft SQL server to a DB2 table on the Main Frame and I get this error. Any ideas?

[IBM][CLI Driver][DB2]SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "UPDATABLE WORKFILE", type of resource: "100", and resource name: "TEMP DATABASE". SQLSTATE=57011

Your DBA will know.

That error's coming back from the Mainframe.

Internet Services

Web Development

Digital Marketing

Consumer Tech