Discussion :

[mgas1]

Bonjour,

Je recherche la cachette des requetes SQL crées par STRSQL en interactif (sans demande de sauvegarde) par les différents utilisateurs (lié à la session).

Merci de votre aide.

[K2R400]

Réponse provenant d'un autre forum :

System will save your session in a Permanent Miscellaneous Space MI Object in the QRECOVERY library (type 19 subtype EE). This is not a file and is not designed to be accessed by end-user (i.e. you). If you have programmers in house that are proficient in MI (Machine Interface) coding, they may attempt to dabble with this type of coding and hence accomplish what you're after (i.e. only preserve frequently saved statements in it).
One easy way for regular iSeries users to see what's stored in this space object is to do the following:

DMPSYSOBJ OBJ(ISQLST*) CONTEXT( QRECOVERY) TYPE(19) SUBTYPE(EE)

If your user profile name is NERGISH, you would replace with NERGISH (i.e. ISQLSTNERGISH*). This will create a spooled file QPSRVDMP in your library. If you search this spooled file on term "NAME-" you may get multiple hits. This will occur if you ever work in interactive SQL on more than one AS400 workstation device. What this means is that you'll have multiple space objects in the QRECOVERY library.
Naming convention IBM follows for these internal space object based on byte positions is:
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>