Hi,

Info: WinNT 4.0, MS SQL 2000 + SP3, NCR ODBC driver

I've set up a Teradata connection using the Teradata ODBC. I've set up a
transform task to query the Teradata db and insert the results into a SQL
2000 db. When I perform simple queries, there's no problem.

When I try to use a much longer query the DTS task (transform task ->
preview)
throws an unspecified error. If I turn on tracing on the ODBC administrator,
the
error given by the ODBC driver is thus -

DIAG [37000] [NCR][Teradata RDBMS] '' ('0A'X) is not a valid Teradata SQL
Token (-3704)

It could be a herring but the previous SQL trace message shows the query,
but it isn't
complete. I don't know whether the trace facility has truncate the query, or
whether it
is actually already truncated (hence why it fails to run).

I don't have at hand access to Teradata manuals (the server is offsite also)
and have not been
able to find a similar message on the net. Looking at the NCR website, there
are downloads for
message documentation, but 9mb is a little too much over my 33.6kbps
connection

Incidently, if I run the same query (exact same, ie paste same text) into a
SQL Query tool
called CustomView, using the same ODBC driver, the SQL executes correctly
and returns
the expected results.

Regards

Nick

"Nick Djurovich" <Nick_Djurovich (AT) NOSPAMaimtechnology (DOT) com> wrote







Hi,

With a little further investigation I foun the error message
explanation. Basically it doesn't like the control character
0x0A, which is by all accounts a line feed. I parsed the
script in file, and there is only the usually 0x0D 0x0A at the
end of every line

Plus this script does run in Query tool no problem.

I decided to take out all the CR LFs out, leaving the SQL as
one long line (not pretty) and then put it into the Data
Transform Task Query. It comes back with a different error,
complaining about the columns i have in the group/order
statement.

Perhaps i shouldn't have put Teradata in the thread title
as i feel this will be one of those lonely posts that only i
respond to :/

Regards

Nick