DS warnings related to CASE expression

tulasi · Post by **tulasi** » Fri Feb 27, 2009 4:18 am

hi all,
i am getting the below fatal error while running the DS job:
Caught parsing exception during wrapDescribeOperator(): Expected identifier, got: <CASE expression>

Job detaisl:loading from TD connector stage to flat file.
TD connector contains complex SQL quey which contains CASE expressions.

please help me on the above issue:

thanks,
tulasi.

richdhan · Post by **richdhan** » Fri Feb 27, 2009 4:29 am

Hi,

Try to run your Teradata SQL in SQL Assistant. Once it goes through use it in TD Connector. There seems to be a problem with your SQL.

HTH
--Rich

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Feb 27, 2009 4:31 am

Does the SQL run successfully outside DS ?

tulasi · Post by **tulasi** » Fri Feb 27, 2009 5:19 am

i ran this query successfully in teradata SQL assistant. it ran fine.but in datastage it is giving the above problem.

please suggest me

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Feb 27, 2009 5:23 am

Do you have any parameter near the case structure?

ray.wurlod · Post by **ray.wurlod** » Fri Feb 27, 2009 1:19 pm

Can you (or your DBA) monitor the Teradata session to establish exactly what SQL is being received from the connector? It may not, for example, be the CASE that is the problem - it may be that some prior quotes are being stripped out of the query.