LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hello all,

I am looking to be able to use Lavastorm to run a program in dise and i wondered if this is possible and if so how also which nodes can we use to do this?

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Hi Keith,

You can call a Program being using an sqlnonselect and using the QCMDEXEC function. I take it you want to call an I-Series program correct?

Regards
Wayne

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hi Wayne,

Yes thank you I do want to call an I-Series program however i am unsure as to which node i should be using for this.

We have JDBC connections into our I-Series but the JDBC execute node does not allow brain script so i can not use the sqlnonselect function.
Do you know which node should be used?

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Just to follow on from this thread. You can achieve this with the correct i-series authority.

You will need service authority at least.

In a JDBC Execute node you do the following:

sqlNonSelect("CALL QSYS.QCMDEXEC('SBMJOB CMD(DLYJOB DLY5)', 0000000023.00000)")
You need to ensure you call the CALL QSYS.QCMDEXEC allow you to call commands like SBMJOB.

You will need to measure the character length in the brakets for the SBMJOB command to get length of the command - Sorry i-Series is a pain like this.
The character length needs to be treated as a 10 digit number e.g. 23 = 0000000023