No. of parms limit for distributed program call via OLE DB ?

[Guest.Visitor]

I am getting the following error on the AS/400 when calling a program on the AS/400 via a PC application written in PowerBuilder which makes use of the IBMDA400 (OLE DB) object: Pointer not set for location referenced. I have used this facility numerous times without any problems - the only difference is that I am passing 40 parameters to/from the AS/400 program. Is there a limit on the number of parameters you can pass to a remote program via OLE DB (i.e. is it a maximum of 35) ? The error occurs on the 36th parameter (it's not a data problem because I've switched various parameters around to test for this). I hope someone can help! Andrew

[Guest.Visitor]

Hi Andrew, The maximum number of parameters that can be passed by the CALL command is 40. I guess the OLE DB uses a call to its own program that passes the additional 4-5 parameters. At the end, you get more then 40 parameters passed. Try to merge few parameters into one to decrease the total number of parameters. Arbel

[Guest.Visitor]

Thanks for that Arbel. Is this a limitation of the AS/400 / RPG as opposed to OLE DB then ?