Loading XML file into empty terdata table using TPT

Tools
N/A

Loading XML file into empty terdata table using TPT

Hi,

I am getting this error (TPT19350 I/O error on file) while i am loading xml data file into empty teradata table. Could someone please help me.

Here is the TPT script.

DEFINE JOB LOB_FILE_LOAD

DESCRIPTION 'Load a large objects from a file to a table'

(

DEFINE SCHEMA LOB_TABLE_SCHEMA

DESCRIPTION 'PRODUCT INFORMATION SCHEMA'

(

COL1 varchar(100)

);

DEFINE OPERATOR FILE_READER

TYPE DATACONNECTOR PRODUCER

SCHEMA LOB_TABLE_SCHEMA

ATTRIBUTES

(

VARCHAR PrivateLogName = 'dataconnector_log',

VARCHAR DirectoryPath = 'C:\TPT\LargeXMLShredding',

VARCHAR FileName = 'vzsample.xml',

VARCHAR Format = 'Unformatted',

VARCHAR OpenMode = 'Read'

);

DEFINE OPERATOR SQL_INSERTER

TYPE INSERTER

SCHEMA *

ATTRIBUTES

(

VARCHAR PrivateLogName = 'inserter_log',

VARCHAR TdpId = '138.83.86.91',

VARCHAR UserName = 'z526579',

VARCHAR UserPassword = 'vAqc7GFt'

);

STEP Loading_LOB_Data

(

APPLY

('INSERT INTO edw_stg.test values (

:COL1')

TO OPERATOR (SQL_INSERTER)

SELECT * FROM OPERATOR (FILE_READER[2]);

);

);

3 REPLIES
Teradata Employee

Re: Loading XML file into empty terdata table using TPT

Please show me what your data looks like.

Your schema has a "varchar(100)".

Are you sure that your field is preceded by the required 2-byte field length?

-- SteveF

Re: Loading XML file into empty terdata table using TPT

can you please help me in loading XML file. Please share steps for loading the same.

Teradata Employee

Re: Loading XML file into empty terdata table using TPT

XML is not supported in TPT until TTU14.10.

And we will treat XML the same as we treat LOBs.

-- SteveF