Help on RPG-JAVA

[Warnie]

Hi,

I am doing a migration from RPG to JAVA. I need to know how can I migrate my BINARY data in RPG to JAVA. Does JAVA support BINARY data? Any pointers will be worth it.

Thanks,
Warnie

 

[cfsalmeida]

What kind of binary data ? if is EBCDIC files you can first convert ebcdic data to ascii with "dd" command using option conv=ascii, and then load ascii data into your java application.

Hope it helps,

Regards,

Carlos Almeida,

 

[Warnie]

Thanks for the reply Carlos. I will explain the situation to you. I have a data file in AS400/RPG which gives the data for the data structure described in the physical file.
Now, I am migrating this to a MS Access database. Since I am doing this in a Windows environment, I am unable to see the Binary data. I am running FORTE for JAVA. My problem is with migrating this Binary data to MS Access. For eg., one of the sample data I have is as follows:

000010300010C
rj
rj €¬
rj
rj"   †” ¯   

Though I am able to make out the first few columns, after that the data is unreadable. How do I retrieve this data and port it to MS Access which will be accessed by my JAVA application?

Thanks,
Warnie

 

[cfsalmeida]

Well it seams to be a EBCDIC data file, the fields of data unreadable should be packed numeric data, so "dd" will do the trick, transfer the data file to Unix system and run "dd" with conv=ascii, to transfer all packed numeric to ascii data, you will need also the RPG data definition to known where the fields start and end, to them load ascii data correctly into your java application.

Regards,

Carlos Almeida,