I am trying to run the following db2 command through the python pyodbc module
IBM DB2 Command : "DB2 export to C:\file.ixf of ixf select * from emp_hc"
i am successfully connected to the DSN using the pyodbc module in python and works fine for select statement
but when i try to execute the following command from the Python IDLE 3.3.2
cursor.execute(" export to ? of ixf select * from emp_hc",r"C:\file.ixf") pyodbc.ProgrammingError: ('42601', ' [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "db2 export to ? of" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "". SQLSTATE=42601\r\n (-104) (SQLExecDirectW)')
or cursor.execute(" export to C:\file.ixf of ixf select * from emp_hc")
Traceback (most recent call last): File "", line 1, in cursor.execute("export to C:\myfile.ixf of ixf select * from emp_hc") pyodbc.ProgrammingError: ('42601', ' [IBM][CLI Driver][DB2/LINUXX8664] SQL0007N The character "\" following "export to C:" is not valid. SQLSTATE=42601\r\n (-7) (SQLExecDirectW)')
am i doing something wrong ? any help will be greatly appreciated.
From what i came to know db2 export is a command run in shell, not through SQL via odbc.
can you please give me some more information on how to run the command in the shell i am confused and what does that mean ? any guide or small quick tutorial will be great