topic Re: How do I execute this command in Talend? in Talend Studio

How do I execute this command in Talend?

isma123i — Mon, 17 Mar 2025 13:53:13 GMT

I need to execute this command:

QUOTE RCMD SBMJOB CMD(CALL PGM(EUROBJ97/J667508) PARM('parameter1' 'parameter2')) JOBQ(ECOREDD)

I am using a tSystem component, but I am not sure how do I have to authenticate to the AS400 machine. Could anyone help me?

Re: How do I execute this command in Talend?

quentin-vigne — Mon, 17 Mar 2025 14:07:23 GMT

Hi @isma123i

If you want to use tSystem you could set the Command as :

ssh USER@AS400_HOST "QUOTE RCMD SBMJOB CMD(CALL PGM(EUROBJ97/J667508) PARM('parameter1' 'parameter2')) JOBQ(ECOREDD)"

Alternatively, you could also use tAS400Row to execute stored procedure without the need to go through system commands.

Let me know if you still need help

- Quentin

Re: How do I execute this command in Talend?

isma123i — Mon, 17 Mar 2025 15:02:03 GMT

I have tried your solution, but I can not figure it out to make it work. I guess that you provided a ssh command, so I have to use tSSH component. However, when I put the command in there it does not work. Could you please me show a screenshot of the component filled with the command?

Thank you in advance

Re: How do I execute this command in Talend?

quentin-vigne — Mon, 17 Mar 2025 15:11:51 GMT

The solution I gave you was for a tSystem component.

Inside it there is a section called "Command", type the command

use "ssh USER@AS400_HOST" to connect to your AS400 server, replace USER and @AS400_HOST to your username and host. If your server doesn't allow SSH connection you will have to use tAS400 components

Re: How do I execute this command in Talend?

isma123i — Mon, 17 Mar 2025 15:56:18 GMT

Thanks again, but I still have the same error:

tSystem_2 Cannot run program "ssh": CreateProcess error=2, The system cannot find the file specified
java.io.IOException: Cannot run program "ssh": CreateProcess error=2, The system cannot find the file specified

I am going to give a try to the tAS400row component, but as far as I know this component will ask me for a sql query instead of a command, right?

Re: How do I execute this command in Talend?

quentin-vigne — Mon, 17 Mar 2025 16:27:22 GMT

Maybe you need to add SSH to Path so that Talend know where to look for (since you have a new computer maybe it's not in Path). Press Win + R, type sysdm.cpl, and press Enter. Go to advanced and environment variables and edit Path to check if SSH is in your path. If not, add it and try again

Also if the user doesnt have access you might want to use su username -c to use the correct user.

"su <<username>> -c 'ssh USER@AS400_HOST "QUOTE RCMD SBMJOB CMD(CALL PGM(EUROBJ97/J667508) PARM('parameter1' 'parameter2')) JOBQ(ECOREDD)'"

Alternatively yes you can use tSSH component if you don't want to type the ssh like this by setting up the tSSH component like this :

for tAS400Row, yes it's going to ask for a SQL Query, but if I remember well you can call SBMJOB from the query tab with the CALL QSYS function.

CALL QSYS.QCMDEXC('SBMJOB CMD(CALL PGM(EUROBJ97/J667508) PARM(''parameter1'' ''parameter2'')) JOBQ(ECOREDD)', 0000000100.00000)

You need to provide the length, I used this website to help me : https://www.rpgpgm.com/2017/02/why-i-should-be-using-qcmdexc-sql.html

- Quentin

Re: How do I execute this command in Talend?

isma123i — Tue, 18 Mar 2025 11:57:48 GMT

My ssh path exists, but it does not work anyways. I also tried the tAS400row, just like this:

But I get this error

Error

2025-03-18 11:44:13:584tDBRow_2 - [CPF0006] Errors occurred in command.

Re: How do I execute this command in Talend?

quentin-vigne — Tue, 18 Mar 2025 13:34:12 GMT

@isma123i Have you tried the tSSH component ?

Maybe try with QSYS2 alternative ? Please copy and paste the solution since we are using doubled single quotes and not double quotes.

"CALL QSYS2.QCMDEX('SBMJOB CMD(CALL PGM(EUROBJ94/J557408B) PARM(''P557408'',''EUR0001'')) JOBQ(ECOREDD)')"

Re: How do I execute this command in Talend?

isma123i — Tue, 18 Mar 2025 15:02:12 GMT

Yes, I tried the tSSH component

Now I get this error when I run your last solution with QSYS2 alternative:

2025-03-18 15:59:22:242tDBRow_2 - [SQL0204] QCMDEX in QSYS2 type *N not found.

Re: How do I execute this command in Talend?

quentin-vigne — Wed, 19 Mar 2025 08:17:09 GMT

Do you know what IBM version you use ? If it's 7.1 or lower QSYS2 doesn't exist and we have to use QSYS (which need cmd lenght) can you try copy and pasting this ? I can't see a reason it won't work

"CALL QSYS.QCMDEXC('SBMJOB CMD(CALL PGM(EUROBJ94/J557408B) PARM(''P557408'',''EUR0001'')) JOBQ(ECOREDD)', 0000000088.00000)"

The second parameter is the number of characters, including spaces between the single quotes in the SBMJOB command, which in this case is 88. If you need to change something in your command, please recount the character or it will not work.

Note: The second parameter must contain exactly 15 digits: ten to the left of the decimal and five to the right.

- Quentin