Category: Feedly

​IMHO this is a big deal, I can now use the SQL three part name to retrieve data from Db2 for i SQL Table functions on other partitions. The three part name is where I give the “database” name along with the schema and object name. In the IBM i world I can translate that to:

partition.library.object

The dot (otherwise known as: period or full stop ( . )) must be used as the separator, rather than the slash ( / ).
For example if I want to retrieve a list of objects of the files in my library on another partition, I will be calling the other partition OTHERSYS. I can use the following statement to retrieve data from the other partition using the three part name with the, for example the SYSFILE View:
Read more » Read More 

​Speaker: Dawn May, COMMON President & Ian Cartwright, COMMON Education Manage Read More 

​L’article Newsletter technique n°3 est apparu en premier sur M81. Read More 

​This deeply technical video done by Tom Zito with Randy Blea, Demonstrates Copy Services Manager with IBM CyberVault protection and Recovery of VMware guests, using QRadar. It was a custom solution implemented for a client by IBM Expert Labs, using IBM FlashSystem Storage Arrays. Read More 

​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