Can we export the output of multiple select statements specified with in .begin export and .end export to multiple outfiles ?
If we create multiple .begin export and .end export blocks with in a single fast export job, are they executed in parallel or sequencially ?
Not with FastExport.
But you can do this with TPT.
Multiple .begin export/.end export are executed sequentially.
I tried it using tpt script with Max sessions as 5. It created 5 files but only one file had all the data and all other remaining files were empty.
Can you please let me know if I need to take care of anything else in the script to make it extract parallely?
USING CHARACTER SET ASCII
I do not see -C at all as an option. Is it because of the version?
With lower case it did not export data into multiple files. Is it because of I had less data. I had only 25,000 rows.
The lowercase -c is not what you think it is. :)
What version of TPT are you using?
The only reason why rows were distributed when exporting 13.3 million is because there was enough work to spread to other file writer instances (but it was not round-robin).
The -C (uppercase) will round-robin the data.
(It might be missing from the usage notes, and I will have to look into that.)
I do not remember when we put -C into the code, but I think it was at least 14.0.