Base64 in IFS to Database file

[ksaranamca]

Hello All,

I have requirement where I need to send a Base64 string to customer in a csv file.

Currently I have the base64 string in a IFS file.

csv file will have other columns as well. So I need to merge this base64 onto the csv file as the last column before sending to the customer.

csv file columns are populated with values from as400 database file. Only this base64 is outside of as400 database in IFS.

Is there a way I can copy base64 on to as400 database so that I can then use it while generating my csv file?

Please help.

Thanks in advance.

[JonBoy]

There is no need to copy the base64 string into an IBM i table. You can simply read the data from the IFS.

If you are familiar with SQL you may find the new SQL facilities for reading IFS files the easiest option. Alternatively, simply use the system API's for opening and reading IFS data.

Both topics have been covered extensively in various articles - just google for something like READ IFS DATA WITH RPG - I just tried that and got a number of useful hits at the top of the list.

[ksaranamca]

Thank you. I will give it to go.