saravanakumar
Member
Hi Everybody,
Am not sure if it is a strange behavior of XREF when temp-table & buffers are used. Below is a sample code snippet with its xref details.
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 COMPILE "C:\saravanakumarb\bufferTest.p"
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 CPINTERNAL ISO8859-1
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 CPSTREAM ISO8859-1
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ttminstore" 10 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "CS-ID" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "CD-ID" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-amount" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-autobill" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-levelind" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-trcndate" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-trcntime" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-userid" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "dv-id" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-mintype" 10 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "cEr-id" 6 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "iBillcode" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "cStatus" 7 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 REFERENCE master.minstore
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 8 STRING "bfttminstore" 12 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_prim_uniq" 13 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_sort" 8 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_prim_uniq" 13 NONE UNTRANSLATABLE
Note:
Xref Details are different for temp tables (& its buffer) depending on where its buffer was defined
1. Program level Buffer & program level Query -> No Xref Info on Temp table and buffer
2. Program level buffer & procedure level Query -> Xref Info Returned for both temp table and buffer
3. Procedure level buffer and Procedure level query -> No Xref Info for Buffers
Thanks in advance..!
Am not sure if it is a strange behavior of XREF when temp-table & buffers are used. Below is a sample code snippet with its xref details.
XREF Details:DEFINE TEMP-TABLE ttminstore NO-UNDO LIKE minstore
FIELD cEr-id AS CHARACTER
FIELD iBillcode AS INTEGER
FIELD cStatus AS CHARACTER
INDEX idx_prim_uniq IS PRIMARY UNIQUE cs-id dv-id cd-id ms-mintype
INDEX idx_sort cStatus cEr-id iBillcode.
DEFINE BUFFER bfttminstore FOR ttminstore.
FOR EACH ttminstore BREAK BY ttminstore.cs-id
BY ttminstore.dv-id
BY ttminstore.cd-id:
END.
FOR FIRST bfttminstore NO-LOCK WHERE bfttminstore.cs-id = ttminstore.cs-id
AND bfttminstore.ms-mintype = ttminstore.ms-mintype
AND bfttminstore.ms-levelind = ttminstore.ms-levelind
AND bfttminstore.ms-amount <> ttminstore.ms-amount
:
END.
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 COMPILE "C:\saravanakumarb\bufferTest.p"
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 CPINTERNAL ISO8859-1
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 CPSTREAM ISO8859-1
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ttminstore" 10 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "CS-ID" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "CD-ID" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-amount" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-autobill" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-levelind" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-trcndate" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-trcntime" 11 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-userid" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "dv-id" 5 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "ms-mintype" 10 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "cEr-id" 6 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "iBillcode" 9 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 STRING "cStatus" 7 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 1 REFERENCE master.minstore
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 8 STRING "bfttminstore" 12 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_prim_uniq" 13 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_sort" 8 NONE UNTRANSLATABLE
"C:\saravanakumarb\bufferTest.p" "C:\saravanakumarb\bufferTest.p" 21 STRING "idx_prim_uniq" 13 NONE UNTRANSLATABLE
Note:
Xref Details are different for temp tables (& its buffer) depending on where its buffer was defined
1. Program level Buffer & program level Query -> No Xref Info on Temp table and buffer
2. Program level buffer & procedure level Query -> Xref Info Returned for both temp table and buffer
3. Procedure level buffer and Procedure level query -> No Xref Info for Buffers
Thanks in advance..!