Using Teradata SQL in 2.0

Tools & Utilities

Using Teradata SQL in 2.0

I am trying to code in but am having problems getting "select where" statements and "update" statements to work.

For Update, I get the following Error:

Exception Details: System.Data.Odbc.OdbcException: ERROR [22018] [NCR][ODBC Teradata Driver][Teradata RDBMS] Cannot use value (or macro parameter) to match 'Region'.

For Select Statements, I am getting an invalid number or type of parameters error.

I think both errors are generated because I am using control paramaters or Labels in and the data is not coming through as the correct data types for Teradata.

ANy ideas on how to troubleshoot this?