Does anyone knows about a tool to download Oracle data (SQL queries) to files with COBOL record definition format (including COMP-3 packed-decimal formats)?
If you use CoSORT's new FAst extraCT (FACT) unload to a flat file, you can simultaneoulsly create the metadata for that file in CoSORT sort control language (sortcl) - transform program. And then in a sortcl transform script, you can declare the output fields in various different data type formats, like MF_COMP3. Please see: ftp://ftp8.cosort.com/FACT_Overview.doc
and starting page 12 in the: ftp://ftp8.cosort.com/CoSORTv8_overview.pdf
where it describes the sortcl program and shows job specification file examples, including scripts where data types get changed from input to output. Let me know what you think,
David Friedland (firstname.lastname@example.org)
Tel. 1.321.777.8889, x238