RE: DSPOBJD with SQLRPGLE module.

["Emmanuel Zannis" <emmanuel.zannis@xxxxxxxxxxxxxxxx>]

David,

You can use the DspMod command. It would give the source file (provided you are 
using pdm). If you keep rolling up to the DB2/400 page you get all the sql info 
you require. If don't know the modules but know the program use the dsppgm 
command to give you the module that forms the program.

Hope that would help.

Emmanuel

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of David Foxwell
Sent: 03 May 2007 10:42 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: DSPOBJD with SQLRPGLE module.


Hallo,

We have only recently started programming with imbedded SQL. We were not 
expecting that the DSPOBJD command would no longer return the original source 
member of a SQLRPGLE module. The application that uses this command receives 
the information QTEMP/QSQLPRE which is useless.

Does anyone know a way around this problem? 

Thanks in advance.