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.
asked Oct 01 '10 at 07:51 PM in Default
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...
answered Oct 02 '10 at 12:56 AM
Matt Whitfield ♦♦