From: Brent S. E. <we...@ai...> - 2009-04-03 15:57:50
|
Can pydb2 handle an export command in an execute statement? When I use the execute statement on an export command I get the following error: Error('42601', -104, '[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "EXPORT TO /home/brente/supply_load/MDCP_TES" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<space>". SQLSTATE=42601\n') Here is the sql statement I am trying to execute: EXPORT TO /home/brente/supply_load/MDCP_TEST/ALLOC.PREV.3 OF DEL SELECT * FROM ATPGUI.WORK_ALLOC_TAB WHERE WORKING = 'PREVIOUS' FOR READ ONLY If I run the export statement directly in db2 from the command line it works. I have no problems with select statements in the execute command. I thought execute was supposed to execute any valid sql. Any ideas? |