|
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?
|