Renaming IFS files using SQL [email protected] (Simon Hutchinson)

​[[{“value”:”In the past if I needed to rename files in the IFS I would either use the Rename Object command, RNM, or used the ‘Integrated File System’ tool in ACS.
The latest round of Technology Refreshes, IBM i 7.5 TR3 and 7.4 TR9, brings us a Db2 for i, or SQL, scalar function that allows me to rename files in the IFS, IFS_RENAME. The scalar function has three parameters:

FROM_OBJECT:  The path of the file to be renamed.
TO_OBJECT:  The path of what the file will be called.
REPLACE:  If there is a file with the To Object name should it be replaced? ‘YES’ and ‘NO’ are the allowed values. If none is given the default is ‘NO’.

Read more »”}]] Read More 

Verified by MonsterInsights