Can anyone tell me if there is a relatively straight forward way of stripping out EBCDIC from a mainframe dataset?
The background.....am exporting a varchar field containing a SQL string from a teradata table to a mainframe dataset using BTEQ (report mode). An example of the SQL field would be:
SET FINALSQL = 'CREATE TABLE '
|| MYCURSOR2.DB_NAME || '.'
|| ' AS '
|| MYCURSOR2.DB_NAME || '.' || MYCURSOR2.TABLE_NAME_TXT
|| ' WITH DATA;';
The problem is any new line in the FINALSQL field is written to the dataset as EBCDIC char X'25'. Is there any way to prevent this? (I realise the easiest way would probably be to rewrite the FINALSQL field to elimante the new line, but that will likely result in another set of problems!)