AnsweredAssumed Answered

Listing DBKEY of Member Records in CULPRIT Report

Question asked by kryptster on Nov 1, 2016
Latest reply on Nov 9, 2016 by kryptster

Hi, Is there a way to list the DBKEY of Member Records in CULPRIT Report?.

I needed to list the DBKEY for Internal Report Purpose, but when we tried in execution, all we could get was the DBKEY of 1st Record of the PATH(Root Owner).

Kindly suggest me a way to solve this issue.

 

Below is the Culprit Code Executed:

 DATABASE  DICTNAME=DICTCA  DBNAME=CFSTST             
 PRO RELEASE=6  TS=Y,Y,Y  USER=GPS       PW=CFSADM
 IN 10000 DB(D) SS=ACFSUTG                         
 PATHAA R1001-MAINUNIT R1002-REFERENCE  R1005-RELATION
*       R1006-MEMBER                              
 PATHBB R1001-MAINUNIT R1002-REFERENCE  R1005-RELATION
 01OUT 133 PS
01$        
 013 CUSTOMER ENTRY SECTION
01$        
 010  COUNT  1          
 010  SUM-CST           
 010  WS-DB-KEY         
 010  DATE-FORM         
 01$                                                   
 01510003 CUSTOMER-ID-1001          HH 'CUST' '----'  
 01510010 DBKEY                 HH 'DBKEY  ------'     
$01510010 WS-DB-KEY             HH 'DBKEY  ------'     
$01510010 KEY-R1002-REFERENCE        HH 'R1002-REF ---'  
$01510030 DBKEY-LINE            HH 'DBKEY-LINE-'       
$01510050 DBKEY-PAGE     F0                            
$        HH  'DBKEY  PAGE--'                           
$01510070 DBKEY-ALPHA           HH 'DBKEY  ALPHA-'     
$01510090 LINK-ID-1005  F0     HH 'LINK-ID'          
 01610010 '   '                                        
 01$                                                   
 017      MOVE DBKEY FROM R1002-REFERENCE   TO WS-DB-KEY 
 01$                                                   
**************************** Bottom of Data ************

When This code is executed, the expected result was the DBkey of both R1001 & R1002 Records been listed, but I got error saying "FROM R1002-REFERENCE  " not recognized.

Is it possible to get the DBKeys of the member Records in Culprit?

Outcomes