I have a query that returns 465K records. I need to export the results as tab delimited, but the records need to be imported to a mainframe, with a miximum transaction limit of 90,000 per batch.
Is it possible to have query :qry_test output the following fields as tab delimited, and create as many text files as required? so, 465,000/90,000 = 6 text files, output_1.txt, output_2.txt, etc, etc/
qry_test consists of 2 fields: