How to write output of stored proc in a file using Fast Export

Tools
Enthusiast

How to write output of stored proc in a file using Fast Export

hi all,

i am using:

.logtable

.BEGIN EXPORT

 SESSIONS 20;

.EXPORT OUTFILE cntrl_id.txt

MODE RECORD FORMAT TEXT;

call DTZV02.GetNextLoadID(nextid (title ''))                            

;

.END EXPORT;

but it is giving me error that it is not the correct SELECT statement.

Please help.

Thanks,

Terankit

2 REPLIES
Enthusiast

Re: How to write output of stored proc in a file using Fast Export

I have to use this Stored Proc. Its a kind of urgent, any help will be highly appriciated.

Thanks,

Terankit

Enthusiast

Re: How to write output of stored proc in a file using Fast Export

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.