Re: [PyDB2-discuss] execute fails on export

[<len...@la...>]

> So how do I use the admin_cmd procedure from pydb2?

Never tried it myself so I made up a rather silly example. Note how one
have to quote string literals inside the sql string sent to admin_cmd:

[db2inst1@wbv9 ~]$ rm -f /tmp/TT.ixf
[db2inst1@wbv9 ~]$ cat admin_cmd_example.py
#!/usr/bin/python

import DB2
import sys

dbname = sys.argv[1]
username = sys.argv[2]
passwd   = sys.argv[3]

conn = DB2.connect(dsn=dbname, uid=username, pwd=passwd)

c1 = conn.cursor()
c1.execute("call sysproc.admin_cmd('export to /tmp/TT.ixf of ixf select x
from lateral(values (''a'')) T (x)')")
for row in c1.fetchall():
    print row


[db2inst1@wbv9 ~]$ ./admin_cmd_example.py <yourdb> <youruser> <yourpasswd>
(1L, None, None)
[db2inst1@wbv9 ~]$ ls -l /tmp/TT.ixf
-rw-r--r--  1 db2fenc1 db2fadm1 2768 Apr  6 16:57 /tmp/TT.ixf


HTH
/Lennart