DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Joined: 16 Oct 2013
Posts: 7
Location: Sydney
Points: 83

Post Posted: Thu Oct 17, 2013 10:09 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Can Teradata 13 be used for the QualityStage Match Designer database?

It tests successfully when configuring the Test Environment in Match Designer, but throws syntax errors when attempting to test a match pass.
##E IIS-DSEE-TDOD-00007 15:03:54(002) <main_program> [IBM(DataDirect OEM)][ODBC Teradata Client driver][Teradata]Syntax error, expected something like a 'CHECK' keyword between ',' and the 'Value' keyword.
##E IIS-DSEE-TDOD-00062 15:03:54(003) <MWI_Odbc_Write> Table create failed: {0}

So it would appear to me that whatever SQL is generated to create tables is not compatible with whatever Teradata expects. This would make my client really sad were it the case.

Kevin K Tashadow

Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Fri Oct 18, 2013 10:34 am Reply with quote    Back to top    

Hi Kevin,

Teradata is not supported as the Match Designer Database. Only DB2, Oracle, and SQL Server.

No need to be sad, though! One of those three is already being used for the repository, so it can be used the the Match Designer Database, too!

Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours