Load client from ... (for exception)..SQL3015N -206

mail4mz · #1 (**permalink**) 03-23-11, 22:53

Hi All,

I am running UDB 8.2 on Sun solaris, need load data from UDB client to UDB server. When I use script to run "load client from..." on the client, it works fine without "'for exception" clause; however it has following error when I add the "for exception" clause:

SQL3015N An SQL error -206 occurred during processing.

BTW, I tried the same script on server, it works fine.

Any idea on this issue?

Thanks,

Mike

db2girl · #2 (**permalink**) 03-24-11, 19:22

Are there any errors logged in the db2diag.log?

mail4mz · #3 (**permalink**) 04-10-11, 16:21

Problem solved. IBM UDB client 9.5 does not work with UDB Server 8.2.

db2girl · #4 (**permalink**) 04-10-11, 22:09

"IBM® Data Server Client, IBM Data Server Runtime Client, IBM Data Server Driver Package, and IBM Data Server Driver for ODBC and CLIVersion 9.5 can access DB2 Version 9.1 and DB2 UDB Version 8 servers. However, new DB2 Version 9.5 functionality is not available."

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

The "for exception" parameter is not new in v9.5

Internet Services

Web Development

Digital Marketing

Consumer Tech