Cannot fetch SQL in Teradata
I'm trying to retrieve a SELECT command against Teradata's data ware house tool which table name was defined in the format <schema>.<table name> and the table was defined in lowercase. This occurs when moving the result set form embedded MS Query in QTP to the Database Checkpoint table. I could solve this by associating the <schema>.<table name> to an alias but if so, I have to prefix each column with it. The same behavior occurs by using VB Script with ADODB.
However, if I try another SQL editor (i.e. Teradata SQL Assistant), it works fine without aliases. Further, I have many tables in the same format that does not need any workarounds like that.
Do you happen to know how to solve this or have experienced something like this in any other databases?
Please, let me know your thoughts.
Thanks in advance, Fernando.
Re: Cannot fetch SQL in Teradata
Can you post one of your queries? And some details on the type and # of columns. Also the error message that you are getting