DSXchange

Hi, I am trying to FTP a file to local directory file using FTP stage and then Sequential file Stage. After running the job i am getting the following error : "FFL..Transformer_9: Unbalanced or unescaped quote character At row 4871". In this record's(4871) column i found " abcd&bc...

Hi, I am trying to ftp a file to flat file using ftp stage to sequential file stage. After runnning the job i am getting the following error: FTP2REBATE_FFL..Transformer_1: Internal error: function 'buffer_to_row' failed. FTP2REBATE_FFL..Transformer_1: Column value must be non NULL At row 63382, lin...

Hi,
I am trying to load data from ftp server to flatfile and after running the job i get the following error:

FFL..Sequential_File_8.IDENT1: Internal error: function 'buffer_to_row' failed.

Any suggestion guys,

Thanks.

Hi,
I think you can write a Btek script for joining tables with differnt key columns or even you can write a user defined sql to join tables.

Hi guys, I am trying to update a table using the following SQL in multiload custom script. When i try the same SQL in Teradata Assistant it is working well but when i use the same in Datastage Multiload stage, i am getting an error "08:47:43 UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE State...

Hi,
I am using teradata api instead of fast export and it is working now.
Thanks.

Hi,
Thanks guys, it finally worked.

Hi, I have to load data from table A to table B based on a condition in teradata. So i used fast export as source and multiload as target stages. But when i run the job i am getting error that either .logtable command is invaliedly used or int file is not found. But i am sure i am doing right. Can a...

Hi, I am trying to concatenate three columns of same data type (3,3,4) into one column of same data type (12) by giving the following statement, but i am getting an error. Select (PHONE.area_code || PHONE.prefix || PHONE.number) as Ph_nbr AS CHAR(12) from abc; Please guide me where i am going wrong.

Hi,
Its working now.
Thanks guys.

Then just add a Trim... Fmt(Trim(SourceData.Col,".", "T"),"4'0'R") :wink: (The 'T' will remove trailling '.') Hi, I tried this but i get an error : Area_test..Transformer_2: At row 1, link "DSLink3", while processing column "Ph_cd" Value "0920&...

Hi Burney,
Can you please explain me how to write this in a routine.
Thanks in advance.

Actually sometimes "." gets added to the target column value. So, i am using this sql.

Thanks for advices

Hi, my source system is db2 and target system is teradata. In my source i have a column of numeric data type and in my target db it is charecter data type. But when i run the job i find incomplete data in few records of this column. For Example When a number like 0677 is passed to Teradata it is goi...

Hi,
you can see the modified time of the job in Manager when you save the job even though you dont compile it.