Forum Stats

  • 3,760,125 Users
  • 2,251,647 Discussions
  • 7,870,989 Comments

Discussions

Data type of Table column from Trail file using LOGDUMP

User_3SC3G
User_3SC3G Member Posts: 2 Green Ribbon

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

Tagged:

Answers