DEFINE SCHEMA test
DESCRIPTION 'this defines the structure of the source'
dateofbirth VARDATE(15) FORMATIN('DDMMMYYYY') FORMATOUT('YYYY-MM-DD'),
DEFINE OPERATOR FILE_READER
TYPE DATACONNECTOR PRODUCER
VARCHAR PrivateLogName = 'dataconn_log',
VARCHAR DirectoryPath = @SourceDir,
VARCHAR FileName = @SourceFile,
VARCHAR Format = 'Delimited',
VARCHAR OpenMode = 'Read',
VARCHAR TextDelimiter = '|'
Row: 1, ColCount=5
Col Offset Length Ind Contents
1 0 5 0 '12345'
2 6 0 1 ''
3 7 9 0 '10JUL1949'
4 17 2 0 '10'
Target buffer OUT>
Hexadecimal formatted display from address 003E8E90 for 19 bytes.
0000 31 32 33 34.35 7C 7C 31.30 4A 55 4C.31 39 34 39 *12345||10JUL1949*
0010 7C 31 30 *|10 *
WARNING! TPT10675: pxdatetime reformatting error.
pmTrace entry <<<<
Saving error record in error record file.
pmWrite entry <<<<
Thank you for the information.
Yes, we recognized that we had a bug when the provided data was NULL.
The original implementation did not account for the data being NULL.
Are you sure about 15.00.00.17?
I do not think we have that many patches for 15.0.
The client is 15.00.00.00 actually, here is more of the log information:
Ok, thanks for the info.
The only version number that is important here is the operator version. 15.00.00.00.
This issue was fixed in 15.00.00.01.
Please upgrade to the latest patch (efix).
I have Source coulmn as varchar 20 and destination column is date format 'yyyy-mm-dd'
sql query has cast(substr(r_date,1,10) as date format ''mm.dd/yyyy')
the job error on invalid date please help on the same as i have gone thorugh many blogs still didt got an answer
If your destination date format is 'yyyy-mm-dd' then that is the format in which the data must be sent to Teradata. Your SQL is cast-ing as mm.dd/yyyy (unless you meant mm/dd/yyyy, but even that would still be incorrect).