Sample Traces

This topic contains a sample trace for each trace level. Creating File Descriptions With AUTOIDMS, contains a sample session that demonstrates how to create the EMPFILE Master and Access Files used in the examples.


Top of page

Example: IDMSR Level 1 Trace

The following example allocates the trace a sequential file, turns on the level 1 trace, and runs a request:

DYNAM ALLOC DD FSTRACE  DA PMSSAE.FSTRACE SHR REU                
SET TRACEON = IDMSR/1/FSTRACE
TABLE FILE EMPFILE
PRINT EMP_LAST_NAME AS 'LAST NAME'
EMP_FIRST_NAME AS 'FIRST NAME'
DEPT_NAME AS 'DEPARTMENT'
IF EMP_LAST_NAME EQ 'CLOTH'
IF EMP_FIRST_NAME EQ 'TERRY'
END

The following trace results are stored in the file. The level 1 trace shows each call to IDMS and the index or key values passed and retrieved:

  *******************************************
********* BIND RUN-UNIT *******************
*******************************************

*******************************************
********* CALL COMPLETED ******************
*******************************************


*******************************************
********* BIND RECORD *********************
*******************************************
>>>>> EMPLOYEE

*******************************************
********* CALL COMPLETED ******************
*******************************************

  *******************************************
********* BIND RECORD *********************
*******************************************
>>>>> DEPARTMENT

*******************************************
********* CALL COMPLETED ******************
*******************************************


*******************************************
********* READY ***************************
*******************************************

>>>>> EMP-DEMO-REGION

*******************************************
********* CALL COMPLETED ******************
*******************************************


*******************************************
********* READY ***************************
*******************************************
>>>>> ORG-DEMO-REGION

*******************************************
********* CALL COMPLETED ******************
*******************************************

_______________________________________________________________________
INDEX VALUE:
C5D90D8EDE70404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY
INDEX LIMIT:
C5D90D8932B0404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY


*******************************************
********* OBTAIN WITHIN SET USING VALUE ***
*******************************************
>>>>> EMPLOYEE

*******************************************
********* CALL COMPLETED ******************
*******************************************

INDEX RETRIEVED:
C5D90D8EDD70404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY
  *******************************************
********* IF MEMBER ***********************
*******************************************
>>>>> DEPT-EMPLOYEE

*******************************************
********* CALL COMPLETED ******************
*******************************************


*******************************************
********* OBTAIN OWNER ********************
*******************************************
>>>>> DEPT-EMPLOYEE

*******************************************
********* CALL COMPLETED ******************
*******************************************


*******************************************
********* OBTAIN NEXT MEMBER **************
*******************************************
>>>>> EMPLOYEE

*******************************************
********* CALL COMPLETED ******************
*******************************************

INDEX RETRIEVED:
C5E30D8EDD70404C3D3D6E4C440404040404040404040C2 *CLOUD BETH
_______________________________________________________________________


*******************************************
********* FINISH **************************
*******************************************

*******************************************
********* CALL COMPLETED ******************
*******************************************

The output of the request is:

LAST NAME        FIRST NAME  DEPARTMENT      
--------- ---------- ----------
CLOTH TERRY THERMOREGULATION

Top of page

Example: IDMSR Level 2 Trace

The following example allocates the trace a sequential file, turns on the level 2 trace, and runs a request:

DYNAM ALLOC DD FSTRACEP  DA PMSSAE.FSTRACEP SHR REU                
SET TRACEON = IDMSR/2/FSTRACEP
TABLE FILE EMPFILE
PRINT EMP_LAST_NAME AS 'LAST NAME'
EMP_FIRST_NAME AS 'FIRST NAME'
DEPT_NAME AS 'DEPARTMENT'
IF EMP_LAST_NAME EQ 'CLOTH'
IF EMP_FIRST_NAME EQ 'TERRY'
END

The following trace results are stored in the file. The level 2 trace shows each call to IDMS and the control blocks, parameters and key or index values passed and retrieved:

  *******************************************
********* BIND RUN-UNIT *******************
*******************************************

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F1F4F0F000000000 *FOCUS 1400....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040404040404040404040404040 * ETH
C5E30D889D7840440404040404040404040404040404040 * ETH
C5E30D889D8840440404040404040404040404040404040 * ETH
C5E30D889D9840440404040000000004040404040404000 * .... .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH
  IDBMSCOM PARAMETER:
C5E30D889D7240440404040000000000000000000000000 * ETH

REC:
C5E30D889CD8404C6D6C3E4E2404040F1F4F0F000000000 *FOCUS 1400....ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************
  *********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH


*******************************************
********* BIND RECORD *********************
*******************************************
>>>>> EMPLOYEE

*********************************
***** PARAMETERS TO IDMS: *******
*********************************
  SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

IDBMSCOM PARAMETER:
C5E30D889D6740440404040000000000000000000000000 * ETH

REC:
C5E30D80CA3A404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

*******************************************
********* BIND RECORD *********************
*******************************************
>>>>> DEPARTMENT

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

IDBMSCOM PARAMETER:
C5E30D889D6740440404040000000000000000000000000 * ETH

REC:
C5E30D80CB16404C4C5D7C1D9E3D4C5D5E3404040404040 *DEPARTMENT ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH


*******************************************
********* READY ***************************
*******************************************
>>>>> EMP-DEMO-REGION

*********************************
***** PARAMETERS TO IDMS: *******
*********************************
  SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF840440404040404040404040404040404040 * ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

IDBMSCOM PARAMETER:
C5E30D889D5C40440404040000000000000000000000000 * ETH
  REC:
C5E30D80C340404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH


*******************************************
********* READY ***************************
*******************************************
>>>>> ORG-DEMO-REGION
*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

IDBMSCOM PARAMETER:
C5E30D889D5C40440404040000000000000000000000000 * ETH

REC:
C5E30D80C368404D6D9C760C4C5D4D660D9C5C7C9D6D540 *ORG.DEMO.REGION ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

_______________________________________________________________________
INDEX VALUE:
C5D90D8E3E70404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY
INDEX LIMIT:
C5D90D889078404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY


*******************************************
********* OBTAIN WITHIN SET USING VALUE ***
*******************************************
>>>>> EMPLOYEE

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F00000FF08 *FOCUS 0000....ERRY
C5D90D889CE840440404040404040404040404040404040 * ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

IDBMSCOM PARAMETER:
C5D90D889D5840440404040000000000000000000000000 * ERRY

REC:
C5D90D80CA3A404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************
  SUBSCHEMA STATUS:
C5D90D889CE0404F0F0F0F0000000000000000000000000 *0000 ERRY

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F001250701 *FOCUS 0000....ERRY
C5D90D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

INDEX RETRIEVED:
C5D90D8E3D70404C3D3D6E3C840404040404040404040E3 *CLOTH TERRY
_______________________________________________________________________


*******************************************
********* IF MEMBER ***********************
*******************************************
>>>>> DEPT-EMPLOYEE

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F001250701 *FOCUS 0000....ERRY
C5D90D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

IDBMSCOM PARAMETER:
C5D90D889D7340440404040000000000000000000000000 * ERRY
  REC:
C5D90D80CB6E404C4C5D7E360C5D4D7D3D6E8C5C5404040 *DEPT.EMPLOYEE ERRY

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5D90D889CE0404F0F0F0F0000000000000000000000000 *0000 ERRY

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F001250701 *FOCUS 0000....ERRY
C5D90D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY


*******************************************
********* OBTAIN OWNER ********************
*******************************************
>>>>> DEPT-EMPLOYEE

*********************************
***** PARAMETERS TO IDMS: *******
*********************************
  SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F001250701 *FOCUS 0000....ERRY
C5D90D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

IDBMSCOM PARAMETER:
C5D90D889D5640440404040000000000000000000000000 * ERRY

SET:
C5D90D80CB6E404C4C5D7E360C5D4D7D3D6E8C5C5404040 *DEPT.EMPLOYEE ERRY

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5D90D889CE0404F0F0F0F0000000000000000000000000 *0000 ERRY

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F00125A501 *FOCUS 0000..v.ERRY
C5D90D889CE8404C4C5D7C1D9E3D4C5D5E3404040404040 *DEPARTMENT ERRY
C5D90D889CF8404D6D9C760C4C5D4D660D9C5C7C9D6D540 *ORG.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

  *******************************************
********* OBTAIN NEXT MEMBER **************
*******************************************
>>>>> EMPLOYEE

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F00125A501 *FOCUS 0000..v.ERRY
C5D90D889CE8404C4C5D7C1D9E3D4C5D5E3404040404040 *DEPARTMENT ERRY
C5D90D889CF8404D6D9C760C4C5D4D660D9C5C7C9D6D540 *ORG.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

IDBMSCOM PARAMETER:
C5D90D889D4140440404040000000000000000000000000 * ERRY

REC:
C5D90D80CA3A404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY

SET:
C5D90D889B10404C5D4D760D5C1D4C560D5C4E740404040 *EMP.NAME.NDX ERRY

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5D90D889CE0404F0F0F0F0000000000000000000000000 *0000 ERRY
  SUBSCHEMA CONTROL BLOCK:
C5D90D889CD8404C6D6C3E4E2404040F0F0F0F001250101 *FOCUS 0000....ERRY
C5D90D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ERRY
C5D90D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ERRY
C5D90D889D0840440404040404040404040404040404040 * ERRY
C5D90D889D1840440404040404040404040404040404040 * ERRY
C5D90D889D2840440404040404040404040404040404040 * ERRY
C5D90D889D3840440404040404040404040404040404040 * ERRY
C5D90D889D4840440404040404040404040404040404040 * ERRY
C5D90D889D5840440404040404040404040404040404040 * ERRY
C5D90D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ERRY
C5D90D889D78404404040404040404040404040E2E2C3C1 * SSCAERRY
C5D90D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAERRY
C5D90D889D98404FFFFFFFF000000004040404040404000 *........ .ERRY
C5D90D889DA840400000000000000000000000000000000 *.. ERRY

INDEX RETRIEVED:
C5E30D8E3D70404C3D3D6E4C440404040404040404040C2 *CLOUD BETH
_______________________________________________________________________


*******************************************
********* FINISH **************************
*******************************************

*********************************
***** PARAMETERS TO IDMS: *******
*********************************

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F001250101 *FOCUS 0000....ETH
C5E30D889CE8404C5D4D7D3D6E8C5C54040404040404040 *EMPLOYEE ETH
C5E30D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D884040D9160084040404040404040E5C9C2C1 *.j.. VIBAETH
C5E30D889D98404FFFFFFFF000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

IDBMSCOM PARAMETER:
C5E30D889D3940440404040000000000000000000000000 * ETH

REC:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F001250101 *FOCUS 0000....ETH

*******************************************
********* CALL COMPLETED ******************
*******************************************

*********************************
***** PARAMETERS FROM IDMS: *****
*********************************

SUBSCHEMA STATUS:
C5E30D889CE0404F0F0F0F0000000000000000000000000 *0000 ETH

SUBSCHEMA CONTROL BLOCK:
C5E30D889CD8404C6D6C3E4E2404040F0F0F0F001250101 *FOCUS 0000....ETH
C5E30D889CE840440404040404040404040404040404040 * ETH
C5E30D889CF8404C5D4D760C4C5D4D660D9C5C7C9D6D540 *EMP.DEMO.REGION ETH
C5E30D889D0840440404040404040404040404040404040 * ETH
C5E30D889D1840440404040404040404040404040404040 * ETH
C5E30D889D2840440404040404040404040404040404040 * ETH
C5E30D889D3840440404040404040404040404040404040 * ETH
C5E30D889D4840440404040404040404040404040404040 * ETH
C5E30D889D5840440404040404040404040404040404040 * ETH
C5E30D889D6840440404040000CF000D9D7C24040404040 * ..0.RPB ETH
C5E30D889D78404404040404040404040404040E2E2C3C1 * SSCAETH
C5E30D889D8840400000000404040404040404000000000 *.... ....ETH
C5E30D889D9840400000000000000004040404040404000 *........ .ETH
C5E30D889DA840400000000000000000000000000000000 *.. ETH

The output of the request is:

LAST NAME        FIRST NAME  DEPARTMENT      
--------- ---------- ----------
CLOTH TERRY THERMOREGULATION

Information Builders