• February 22, 2020

iCluster Support for SQL Functions and Procedures

As part of iCluster 7.1 Interim Fix 3 (IF3) and also included with iCluster 7.1 TR1, support was provided for SQL Functions and Procedures. The primary purpose for this support was for integration between iCluster and Rocket Aldon LifeCycle Manager for i or LM(i), but any shop can also replicate SQL Functions and Procedures including any changes to these objects if you use the correct object specifiers.

With IF3 and TR1 we introduced two new object specifiers – *SQLFUNC and *SQLPROC. Use the good old DMSELOBJ command to add these object specifiers to a replication group. It’s important to note that *ALL as object type on DMSELOBJ DOES NOT INCLUDE SQL functions or procedures, in others words you need to specifically add these new object specifiers to a group to pick up these object types.

If you need to do a DMSETPOS on a group that includes SQL functions or procedures, remember that you need to do the set position on the QSQJRN journal in QSYS2. Also remember you should not replicate the QSQJRN journal, just like database journals or the system audit journal, iCluster just reads these journals and does not need to replicate the journal object.

Avatar

iCluster Tech Tuesday 115 Posts

iCluster TechTuesday is a set of posts covering technical tips and techniques to help get the most out of your Rocket iCluster installation.

2 Comments

  • iCluster 7.1 TR1 Currency Enhancements - XML Field Types Reply

    November 19, 2013 at 7:34 am

    […] SQL procedures and functions were covered in a previous Tech Tuesday post, so let’s cover XML fields briefly. If you are running earlier releases of iCluster but are also on i7.1 of IBM i, you may be seeing objects suspended with a reason code of NSO. NSO stands for Non-Supported Object, and the help text states: A physical file has fields of unsupported type (datalink, or  LOB fields with MINENTDTA). […]

  • Replicating External Stored Procedures in iClusterRocket Software Reply

    June 17, 2014 at 7:30 am

    […] in iCluster 7.1 TR1 IF3 we introduced support for replicating SQL Stored procedures and functions. What some customers may not know is that this also works for External Stored procedures that do […]

Leave a Comment

Your email address will not be published. Required fields are marked *