I have a file in my Unix ( SOLARIS ) with EBCDIC format...I want this file to read in ASCII OR unicode...Is it possible with UNIX to convert this file on ASCII OR UNICODE format from EBCDIC format?
I was searching through web and found only conversion table
Sorry for the late reply....Thanks much for all your help
I tried dd comand as well and it did convert the data but it seems it did not converted correctly.
My basic requirement is....I am converting abinitio graph to informatica.... The source in INFA is EBCDIC which I need to convert to ASCII in order to use it in INFA, any help is highly appreciated ...below is DDL from abinition:
OK. So your data is NOT EBCDIC; it is some kind of "abinition" or "abinitio graph" (whatever they are) record format. Presumably the string fields were correctly converted by the dd command, but the date and decimal fields were not. I have no idea how "abinition" or "abinitio" encode data stored in date or decimal fields, but from your very poor description of what dd did, we have to assume that they are not encoded as EBCDIC strings.
Without a clear description of the format of your input file, it will be difficult to convert your data to ASCII. Furthermore, shell scripts are not generally well suited to performing conversions on arbitrary binary data intermixed with character data.
16499373+1 records in
16499373+1 records out
8447679135 bytes (8.4 GB) copied, 286.2 seconds, 29.5 MB/s
Why I was saying it is ebcdic as it was there in DML of the source in abinition ( abinitio is a ETL tool like INFORMATICA )...DML is basically the definition of source with what format and filed etc....
---------- Post updated at 06:01 AM ---------- Previous update was at 05:46 AM ----------
Below is the output from dd:
16499373+1 records in
16499373+1 records out
8447679135 bytes (8.4 GB) copied, 286.2 seconds, 29.5 MB/s
Why I was asking it is EBCDID as it is mentioned in the DML of ABINITIO source (DML in my last reply)... ABINITIO is a ETL tool as INFORMATICA and source DML describes the source functionalists like number of columns, format etc...
---------- Post updated at 06:02 AM ---------- Previous update was at 06:01 AM ----------
Below is the output from dd
16499373+1 records in
16499373+1 records out
8447679135 bytes (8.4 GB) copied, 286.2 seconds, 29.5 MB/s
Why I was saying it is ebcdic as it was there in DML of the source in abinition ( abinitio is a ETL tool like INFORMATICA )...DML is basically the definition of source with what format and filed etc....
---------- Post updated at 06:01 AM ---------- Previous update was at 05:46 AM ----------
Below is the output from dd:
16499373+1 records in
16499373+1 records out
8447679135 bytes (8.4 GB) copied, 286.2 seconds, 29.5 MB/s
Why I was asking it is EBCDID as it is mentioned in the DML of ABINITIO source (DML in my last reply)... ABINITIO is a ETL tool as INFORMATICA and source DML describes the source functionalists like number of columns, format etc...
Experts, need your help. I have a file which is in ebcdic binary (cp 1047). I tried dd if=so_tran05.dat_bkp conv=ascii. This command converts everything except packed decimal amount fields and date/timestamp fields. What is the workaround?
When starting a new question, please start your own thread instead of starting a second discussion in an existing thread!
However, in this case, you are just rephrasing the same issue that started this thread. Your question has already been answered by the comments given to joshilalit2004 who started this thread.