Accessing JD Edwards Data on iSeries or AS/400 from a ASP.NET
Facing problem, while retrieving field data from JD Edwards to SQL (SSRS Reporting), giving Error or Special unicode characters,
because, the returning data was a stream that needs to be converted into ASCII (ebcdic37String) using Cp037 Encoding.
public static String convertEBCDIC37ToUnicode(String ebcdic37String)
{
String encoding = "Cp037";
byte[] ebcdic;
String converted = null;
try
{
ebcdic = ebcdic37String.getBytes();
converted = new String( ebcdic, encoding );
}
catch (Exception e)
{
//Handle it
}
return converted;
}