Enterprise Communication Interface (ECI)

eci_epq_trc

Description

ECI function for activating the EPQ trace.

ECI input parameters cpStatement/CpValue are only needed for cpWhat = set.

To receive the current setting, just call cpWhat=set with empty cpStatement (eci_add_par(&tpFunPar, "")).

 

Input parameter

cpWhat

string

{set|reset|get}

  • set: set epqtrace on/off
  • reset: set all epqstatements to notrace
  • get: get SQL-trace

cpStatement

stringlist names of epqstatements {mv | epqtrans | epqdel | epqins | epqupd | epqsel | epqfet | epq_sg l fet_num | epqcrt | epqctt | epqdrp | epqrdf | log}.

cpValue

stringlist values of epqstatements {on|off} for each epqstatement in cpStatement

cpReadNum

string

if (cpWhat == get):

  • number of max
  • lines to read (0 = all)

 

Output parameter

cpFileName

string name of file containing SQL-Trace

additional for cpWhat={set|reset}:

cpaRetNam

stringlist epqstatements

additional for cpWhat={set|reset}:

cpaRetVal

stringlist current values of epqstatements

 

Example

To trace "epqsel" and "epqcre":

eci_add_par(&tpFunPar, "set");
eci_end_par(&tpFunPar);
eci_add_par(&tpFunPar, "epqsel");
eci_add_par(&tpFunPar, "epqcre");
eci_end_par(&tpFunPar);
eci_add_par(&tpFunPar, "on");
eci_add_par(&tpFunPar, "on");
eci_end_par(&tpFunPar);

To reset trace again (exactly for epqsel/epqcre):

eci_add_par(&tpFunPar, "set");
eci_end_par(&tpFunPar);
eci_add_par(&tpFunPar, "epqsel");
eci_add_par(&tpFunPar, "epqcre");
eci_end_par(&tpFunPar);
eci_add_par(&tpFunPar, "off");
eci_add_par(&tpFunPar, "off");
eci_end_par(&tpFunPar);

OR

eci_add_par(&tpFunPar, "reset");
eci_end_par(&tpFunPar);