Seems like something that could be a performce problem if it forces dynamic SQL and access path creation at runtime. Better to call SP or static SQL if you're talking a lot of data to go through. Dave
david@xxxxxxxxxxxx 8/1/2006 14:29:37 >>>
Forgive my ignorance... but what's the point of PCML? Why not
call an RPG service program as a native method? Or use SQL and make
a UDF? Or a stored procedure?
It let's you call programs (at least when using java) without regard to where caller is running. Calling a RPG program as a native method, when you're running on a PC, doesn't work well. Using SQL UDF's or stored procedures requires a lot of extra work ahead of time. Using PCML is all done at runtime. david