iSeries / AS400 FAQ : (Category) General : Where is the interactive SQL command history stored?
In Interactive SQL, there is a history of commands. How can I access that saved session history? The solutions is a little involved. Follow the directions exactly. You can get the list of sessions from: DMPSYSOBJ ISQLENyouruserid* QRECOVERY 19 EE My user profile name is CRP. Output sample for me with one session: DMPSYSOBJ PARAMETERS OBJ- ISQLENCRP* CONTEXT- QRECOVERY TYPE- 19 SUBTYPE-EE OBJECT TYPE- SPACE *MSCSP NAME- ISQLENCRP QPADEV00790000 TYPE- 19 SUBTYPE- EE LIBRARY- QRECOVERY TYPE- 04 SUBTYPE- 01 CREATION- 04/28/96 12:53:09 SIZE- 0000003400 OWNER- CRP TYPE- 08 SUBTYPE- 01 For multiples you will have multiple “NAME-” in the spooled output QPSRVDMP. The “NAME-” is positionally in bytes: 01-06 :: ISQLEN 07-16 :: User profile starting the session. 17-26 :: Workstation device name for session selection 27-30 :: Session number for that workstation ID <0000 is first> Courtesy Dave Mahadevan The session information is stored in a number of spaces (type 19, subtype EE) in QRECOVERY. Ther
