Robot | Inside the Integrated File System (IFS) Fortra

​Before AS/400 fans ever even heard the term “iSeries”, IBM had already rolled out the integrated file system (IFS) to give IBM i users the ability to run applications that don’t follow the traditional library structure, which resulted in UNIX- and Windows-based support within the operating system.
Even the Windows IT team needs to access the IFS on IBM i for file exchanges! Read More 

Convert character to hexadecimal with SQL Simon Hutchinson

​A couple of weeks ago I wrote about using Machine Instruction, MI, procedures in RPG to convert a character string to hexadecimal, and then convert it back again to character. Several people sent me examples of converting character to hexadecimal using a SQL statement, but no-one sent me the statement to convert the hexadecimal to character.
I decided to give an example of how I would do what I did last week in SQL. I embedded the SQL statements into a RPG program as this would be the way I would likely use it.
Below is my example program:
Read more » Read More 

Verified by MonsterInsights