Re: PCML

[Barbara Morris <bmorris@xxxxxxxxxx>]

SRamanujan@xxxxxxxxxxxxxxxxxx wrote:
> 
> Hi all,
> I am back with my problems. Since I found it difficult passing array
> type of inputs to stored proc, I wanted to try PCML.  The document says,
> I would need to enter the PCMINFO as PCML & INFOSTMF as the path where
> the pcd is created. My code is sqlrpgle and to create a module I do
> crtsqlrpgi with *module but don't find these parameters in the command.
> I find example for retrieving data in Java but nothing on RPG end to
> code or compile. Would you know where I could find an example to work on
> or some more document on SQLRPGLE as well?

Sudha, you will have to do a two-stage compile.  First do CRTSQLRPGI
with OPTION(*NOGEN), and then compile the resulting RPGLE source file
(TOSRCFILE parameter of CRTSQLRPGI) using CRTRPGMOD.