DSXchange

Yes, I configured field and record delimiter to use it.

field Delimiter string = \xDC\x20
Record Delimter String = \xD1\x20\x0A

The frustrating thing is each time if the column contains \x0A, it will not continue to read characters after \x0A.

Thanks

How can I read a sequential file with columns contain new line characters ?

The file use another special character as field delimiter and record delimiter. And each time, DS read the column with "New line characters", it will stop reading characters after "new line characters".

what directory is the orchadmin tools ?

I encountered the error a few times in our projects. When I created a dataset in my job, it is OK without any warning. Sometimes after the job finished, I just want to view the dataset by Data set management tools in Designer. Sometimes, I got a pop up error message "Unknown error". And it...

In URL property, put
ftp://ftphostname[:port]/URIpath

In connection part, you can use username and password property to input username and password, and I will work.

In Enterprise stage, it is called open command , close command, while in other teradata stage, it is before and after sql.

I tried that, and it looks like that DS couldn't recognize these commands.

thanks

I encountered a situation that each time I run my job. From designer interface, it looks like that the whole records go through. but from director log, we found that the job was stuck by . "main_program: Requesting delayed metadata." "Requesting delayed metadata." What does reque...

For some purpose, I need to run below three commands in Datastage aftere a job for Teradata data loading . collect stats on Schema.Table1 column column1; collect stats on Schema.Table2 column column2; collect stats on Schema.Table3 column column3; Apart from put them into a command file, and run it ...

Thanks for your input, I will test it and let you know the output.

What does "delete data file" option really do ? Assume it was set up as YES.

It will delete the source input file or whatever files regarding the job ?

Thanks

Both two datastage developers use the same standard Teradata login.

Actually, if I specify a detailed location and data file for teradata, and change the file permission, it works. But I think assign a detailed data file is not a good option.

I try to load a seqential file to Teradata, creating a table as well. The issue is if developerA first run the job and create the table, then developerB re-run the job again, developerB will encounter couldn't write tableName.dat file issue. developerA and developerB are in the same Unix group. Anyo...

I need to transfer string to Decimal from sequencial file to Oracle. I don't know why in oracle, when I select the decimal column ( Number in Oracle ), It looks like 00000000, 00000000 By the way, I also need to transfer from string to timestamp, based on a source string like 2007-05-27 12:35:35:123...

The detailed error message is like Teradata_Enterprise_122,78: TeraSync:DB Call Failure(success check) Info = 0, Code = 2631, Message = Transaction ABORTed due to Deadlock.error code = 1 TeraSync:DB Call Failure(success check) Info = 0, Code = 2631, Message = Transaction ABORTed due to Deadlock. err...

In teradata stage, Can we enable the whole job as a transaction ? if any row was rejected when loaded into teradata, the whole job will rollback to original status.

Thanks

I try to use Teradata Enterprise Stage to write data back to Teradata. It is a simple job. And if I set Teradata Enterprise Stage as sequencial mode, it works well. And if I make it as parallel mode, always get deadlock error ? I leave the partition option as auto. Why ? or I need to explicit set up...