i am using:
.EXPORT OUTFILE cntrl_id.txt
MODE RECORD FORMAT TEXT;
call DTZV02.GetNextLoadID(nextid (title ''))
but it is giving me error that it is not the correct SELECT statement.
I have to use this Stored Proc. Its a kind of urgent, any help will be highly appriciated.
You will have to check manuals to see if fast export actually suports procedural calls. I would not think so .
If there is a simple select in procedure ( unlikely ) include it in the fast export script .
Or change your code to call the procedure which outputs a SQL in a file which can then be leveraged in fastexport script.