DSXchange

Thanks everyone.

Hi All, was wondering the impact of using a lower Variant in the Teradata Connector? For example I've noticed developers using Variant 8.1 rather than 12. We are currently on version 13 of Teradata TTUs.



Thanks in advance.

Hey Craig. I tried to escape it without any luck. I might open a ticket with IBM. Thanks for your help.

Craig, unfortnately the semi-colon is part of the source data.

Works fine in Teradata Assistant. I only get the error in DataStage.

If I remove the ; from the string it works fine.

Sorry, forgot to mention it's in the After SQL of the teradata Connector.

Also I missed the the closing braket in my previous post.

INSERT INTO TABLEA (Col1) VALUES('This ; is a test') ;

Hi All, trying to pass a SQL statement to DataStage job to execute: INSERT INTO TABLEA (Col1) VALUES('This ; is a test' ; Doesn't like the semi colon in the string teraTargetTable: RDBMS code 3707: Syntax error, expected something like ',' or ')' between a string or a Unicode character literal and t...

Worked perfectly using Generic Stage. Thanks!

Hi All, I have a process that reads a sequential file using RCP and a schema file. The rows are then sent to Teradata to do an upsert. The issue is that the Teradata stage does not know what the Key is when doing an update. I researched to determine if I can set a column in a schema file as the key ...

Hi All, I've noticed that when trying to import a Teradata table definition without a primary index the table does not display on the import screen. I'm using plugin/teradata when importing. Is this a bug ?

Hi All, which Database Stage would give the best performance when using DB2 for I?

DB2 API ? ODBC? DRS?

Thanks in advance

Hi All, we have been told that we need to upgrade to version 8.5 of DataStage as Teradata will be upgraded to version 13. Does anyone know if 7.5.3 will have issues running Ver 13 Teradata utilities (Mload, fastexp etc...) ?

Hi All, my client is installing DataStage version 8.5 and is looling at CVS as a source control tool. Has anyone had any experience using CVS with 8.5? If so how easy was it to implement?

I believe with 8.5, DataStage has a direct plugin to CVS

Hi All, issue has been solved. Changed column extended Property to Unicode for both links and it worked fine!

Hope this helps others who might run in to this in the future.