DSXchange

User Defined SQL is disable if we use ODBC Connector as Output.

I guess the user is trying to use Update statement and as per documentation, only 1 update statement can be executed

Please clarify

Where are you specifying these update statements? Is it Before/After SQL?. As per documentation, we can execute multiple statements After SQL If you set the Before/After SQL property to Yes and specify an SQL statement in the After SQL property, the connector runs the statement. If you specify multi...

Filtering Date with Quotes (Just like SQL Where Clause) is not giving any Issue: Example: date_1 <> '1900-01-01' (Filtering without Quotes thinks its a Condition and expecting operators)

Did you move or Removed the derivation of if-then-else logic that was coded in Transformer?

Check below link and confirm

Error compiling Infosphere DataStage jobs with transformer stage

http://www-01.ibm.com/support/docview.w ... wg21414560

Thanks chulett. I am contacting the Datastage Admins. Is the Error message something to do with Datastage or with Java Drivers?.

I am using the jdbc connector stage for the First Time. Established the isjdbc.config and the Tested the Connection Successfully using the URL and Id and password. Wrote a simple query to fetch the SELECT COUNT(*) from the Table to check the Query if its running fine. Defined the Count as Integer in...