HI team,
Is there a way to determine the data type of the Table column by looking at OGG Trail file content using LOGDUMP.
I used the following LOGDUMP commands.
GHDR ON
DETAIL ON
DETAIL DATA
FILTER INC <tablename>
I see the following output. Is there a way to interpret the Data type by looking at below LOGDUMP output.
=======================================================================
Name: TDV.OUTBOUND
*
1)Name 2)Data Type 3)External Length 4)Fetch Offset 5)Scale 6)Level
7)Null 8)Bump if Odd 9)Internal Length 10)Binary Length 11)Table Length 12)Most Sig DT
13)Least Sig DT 14)High Precision 15)Low Precision 16)Elementary Item 17)Occurs 18)Key Column
19)Sub DataType 20)Native DataType 21)Character Set 22)Character Length 23)LOB Type 24)Partial Type
*
TDR version: 11
Definition for table TDV.OUTBOUND
Record Length: 7480
Columns: 25
ID 134 8 176 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0
FIRST_NAME 64 1016 214 0 0 1 0 1016 1016 0 0 0 0 0 1 0 0 0 1 -1 1016 0 0