I am trying to run a SQL Server IS package with a lot of variables from the iSeries via RUNRMTCMD and it is over 1000 characters in length and seems to truncate. It says it can handle 2000 characters so what do I need to do to get this working? I am using V5R4 iSeries Access.
RUNRMTCMD is the AS400 implementation of REXEC client and it supports 2000 characters. However, I think the other side is the REXEC daemon from iSeries Access only supports up to 1000 characters. If you need to use remote commands in Windows environment, we recommend using a different REXEC daemon on the Wndows server. For example use the one from www.denicomp.com, it has much more options including security (Note: This is not freeware).
This was first published in May 2008