asked
Need to output a flat fixed-length file (some fields are COMP and COMP-3 format) with MS SQL 2008 TSQL for loading into mainframe
Need to output a flat fixed-length file (some fields are COMP and COMP-3 format) with MS SQL 2008 TSQL for loading into mainframe. How do convert the data from ASCII to COMP, COMP-3, EBCDIC format. The mainframe utilizes COBOL programs and the vendor cannot modify; so I need to meet their file format requirements.
The best way to achieve this is probably going to be by knocking up a C# app to query the database and write the data to the file as you want. However, existing code wise, it seems most people go the other way - i.e. from legacy formats to new - so you might have to write some encoder code yourself...
output it to a text file and ask vendor to write a separate cobol proggram to convert it to the required format on the mainframe
