1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
/* Affichage de postes de journal */
CL: DSPJRN JRN(monschema/TSTJRN) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(qtemp/dspjrn);
/* Requete de base */
SELECT * FROM qtemp.dspjrn;
/* Avec Noms des colonnes */
SELECT
JOENTL as Length_of_entry ,
JOSEQN as Sequence_number ,
JOCODE as Journal_Code ,
JOENTT as Entry_Type ,
JOTSTP as Timestamp_of_Entry ,
JOJOB as Name_of_Job ,
JOUSER as Name_of_User ,
JONBR as Number_of_Job ,
JOPGM as Name_of_Program ,
JOOBJ as Name_of_Object ,
JOLIB as Objects_Library ,
JOMBR as Name_of_Member ,
JOCTRR as Count_or_rrn ,
JOFLAG as Flag ,
JOCCID as Commit_cycle_id ,
JOUSPF as User_Profile ,
JOSYNM as System_Name ,
JOJID as Journal_Id ,
JORCST as Referential_Constraint ,
JOTGR as Trigger ,
JOINCDAT as Incomplete_Data_1_or_0 ,
JORES as Reserved ,
JONVI as Null_Value_Indicators_Variab ,
JOESD as Entry_Specific_Data_Variable
FROM qtemp.dspjrn; |
Partager