Send Command over FTP

[dhoechst]

Is there any way to send a custom command over FTP? I'm trying to do an integration where after moving data to our AS400, I need to run a program. The AS400 FTP server allows me to run a program by sending the command: QUOTE RCMD SBMJOB...

Can execute this type of command in an FTP connection?

[emanuel]

No, sending ftp quote commands is not possible.

/Cheers
Emanuel

[dhoechst]

I was able to call a program using DbExecute, but not execute a command. Since I couldn't directly execute a command, I ended up writing a CL program that can be called by a DbExecute from Jitterbit that then runs the commands I need on our AS400.

[emanuel]

Ok, you could presumably also do it in a plugin, but your solution may be just as easy.

/Emanuel

[MikeyS]

Hello,
I'm attempting to call a CL program on the iseries.
Does anyone have an example of DBexecute and iSeries calling a program?

Thank you.
M

[dhoechst]

Sure, I just created a Script in Jitterbit that I add to the end of my operation

DbExecute("<TAG>Database</TAG>",'Call LIB.PGM')

Note that I'm using the "." instead of standard iSeries "/".

The CL can do what ever you need it to.

[MikeyS]

Thanks. I did get it working so here is an example with Parms
DbExecute("<TAG>iseries DB driver connection</TAG>", "CALL Lib.pgm ('N', '2', '20110826', '1415')")

I would like to know if it's possible to pass parameters into the DBexecute on the Call from another process. Has anyone done this?
DbExecute("<TAG>iseries DB driver connection</TAG>", "CALL Lib.pgm ('N', 'parm1', 'parm2', '1415')")
any help would be appreciated.

[dhoechst]

I think you could put it into a variable and then include the variable in your DbExecute. Use the $ symbol to identify variables in scripts.

Assign values to your variables like this in your transformation. (You would use values from your transformation instead of hard coded.)
$parm1 = "2";
$parm2 = "20110826";

You'd then build your command:
DbExecute("<TAG>iseries DB driver connection</TAG>", "CALL Lib.pgm ('N','" + $parm1 + "','" + $parm2 + "', '1415')")