Hi, does somebody know is it possible to execute unload command in sp? Because, I have an error - 201: a syntax error on the such row. If it is not, please advice me how to solve the problem. The idea of the sp is to make a text file unloaded from one db table. The criteria for uploading are founded in other db table.
Thanks in advance

Hi,

SPL not support unload data, then created a SPL and command execute system("script").
Where script it can be:

dbaccess databasename 2>errorfile <<EOF
unload to filename.unl
select condition.....
EOF

or

dbaccess databasename 1>>filename.unl 2>errorfile <<EOF
select condition.........
EOF

Gustavo.