The DSPSQLINF (Display SQL Information) command will show the structured query language attributes of the selected program.
This works for ILE objects and will show embedded SQL information for any modules within those ILE programs.
DSPSQLINF OBJ(PGMNAME)
The SQL program will be interrogated all the SQL information contained within that object will be displayed.
For example, looking at the SQL Process that purges data as part of the Data Obfuscation Tool (PRGDTA) would show you this:
DSPSQLINF OBJ(PRGDTA) OBJTYPE(*PGM)
