Now able to 3 part name table functions [email protected] (Simon Hutchinson)
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
COMMON India: Modern Application Development on IBM i COMMON
Speaker: Dawn May, COMMON President & Ian Cartwright, COMMON Education Manage Read More
Newsletter technique n°3 Bruno Taverne
L’article Newsletter technique n°3 est apparu en premier sur M81. Read More
CSM Automation for VMware and IBM i with QRoC integration -Full Andrew Greenfield
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
