Focal Point
[CLOSED] How to get data in EBCDIC sort

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/311109145

October 06, 2010, 02:29 PM
Sayed
[CLOSED] How to get data in EBCDIC sort
Hello,

Is there a way to get data in EBCDIC sort?

Thanks,
Sayed

This message has been edited. Last edited by: Kerry,


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
October 06, 2010, 04:12 PM
GamP
If you're on MainFrame - then sure, that's standard.
Otherwise, please elaborate a bit on what it is exactly what you want/need.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
October 07, 2010, 01:13 PM
Sayed
Yes, I am getting the result in AS400 in EBCDIC. But, now I am trying to compare that result with AIX using diff utility. I am wondering if there is an utility or function to convert EBCDIC sort. Otherwise, I will have to write a report to compare the two files.

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
October 07, 2010, 02:03 PM
Francis Mariani
I would

- Download both results to my Windows PC
- Sort the files in a text editor
- Run the diff utility there.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 07, 2010, 03:17 PM
GamP
Transporting the AS400 file to AIX should automatically take care of converting from ebcdic to ascii.
After that comparing the files should also be no problem.
You might even be successful in writing an ftp script that would/could do this.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
October 11, 2010, 02:37 PM
Sayed
Francis,

I've been using that method but very time consuming when I have long list of data and have to compare many files.



GamP,

The file itself is not in EBCIDIC format. I am outputting the file "FORMAT ALPHA", but the sort is EBCIDIC in AS400.
Cannot use diff utility if the data is sorted differently (EBCDIC in AS400 and ASCII in AIX or WIN).


Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE