How is this schema getting into this automatically

[thamark]

I have job, which is reading from Teradata database and passes it to Peek stage.

Here is DDL for table

CREATE SET TABLE TEST_DB.test1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
col1 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
col2 CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC)
UNIQUE PRIMARY INDEX ( col1 ,col2 );

I have used Teradata Enterprise stage to read this table.

I have defined metadata as follows in Teradata Enterprise stage

Col1 Varchar(20)
Col2 Char(4)

Note: without any extended (unicode) property.

I expect the schemas to be string types, but i see ustring in the schema defination.

Is there any reason why it converts automatically to ustring from string?

Code: Select all

main_program: Schemas:
Data set "tdentTest1:distinctTest1CurrentData.v": 
record
( col1: nullable ustring[max=20];
  col2: nullable ustring[4];
)
Data set "tdentTest1:distinctTest1CurrentData_Head.v": 
record
( col1: nullable ustring[max=20];
  col2: nullable ustring[4];
)
Data set "tdentTest1:distinctTest1CurrentData_Head_Peek.v": 
record
( col1: nullable ustring[max=20];
  col2: nullable ustring[4];
)
Operator "tdentTest1": 
output 0 interface: 
record
( col1: nullable string[max=20];
  col2: nullable string[4];
)
Operator "Peek_137.distinctTest1CurrentData_Head": 
input 0 interface: 
record
( inrec: *;
)
output 0 interface: 
record
( outrec: *;
)
Operator "Peek_137.distinctTest1CurrentData_Peek": 
input 0 interface: 
record
( col1: nullable ustring[max=20];
  col2: nullable ustring[4];
  inRec: *;
)
output 0 interface: 
record
( outRec: *;
)
Operator "Peek_137": 
input 0 interface: 
record
( col1: nullable ustring[max=20];
  col2: nullable ustring[4];
  inRec: *;
)