Teradata question

#1

I am trying to issue an INSERT statement from within DTS to Teradata. I want
to use "Parameters" as value in the statement. While doing this in Oracle it
was easy, I was passing question mark "?" in the VALUES.

Don't know how to do that with Teradata. Please help.

#2

"Umar" <Umar (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am trying to issue an INSERT statement from within DTS to Teradata. I
want
to use "Parameters" as value in the statement. While doing this in Oracle
it
was easy, I was passing question mark "?" in the VALUES.

Don't know how to do that with Teradata. Please help.

Are you using the Teradata ODBC driver? If so, parametereized queries don't
work on ODBC. There is a Teradata OLEDB driver and you could try that (no
guarantees).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Teradata question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Teradata question - 09-11-2006 , 03:26 PM

Re: Teradata question - 09-29-2006 , 08:15 PM