If i run below vbs code (current date - 10 days) i get the output in M/D/YYYY format .
How do i get the output in YYYY-MM-DD format ?
Any way to adjust ODBC timeout in linked table properties? I am trying to link a table from Teradata into an Access 97 Database. However, the table is receiving "ODBC call failed Timeout Err...
I'm creating a stored procedure that checks the quality of the data loaded into our data warehouse on a daily basis. Most of the table checks in the stored procedure run on a daily basis. Ho...
I'd like to use an already created report that returns the values i need from Teradata. This Crystal 10 report holds several Formula Fields that run with no errors.
The SQL statement that r...
When I try to install ODBC Driver for Teradata it is saying "The Wizard was interrupted before ODBC driver could be completely installed ". When i run the installation wizard again it says "Re...
I'm trying to connect MS Access with Teradata using VBA and ADODB connection - I think I need to install a teradata driver first so I'm trying to figure out which if any teradata driver I need...
I was working on a Oracle database related project where the firm decided to shift from Oracle To Teradata.
What i know of teradata is a database software that can process extremely large a...
I want to scan the string from right to left and fetch the string that is before the last delimiter.
Consider the strings
1482~0022~000~4346~1
1700~3421~000~7811~8
I need to fetch 4346 a...
I have some lengthy SQL scripts that I wish to run in BTEQ, and I wish to automate the process as much as possible. I would prefer to have a login screen that logs me in and then automaticall...
Hi Experts,
I am Teradata power user since past two years and has only access to write queries and create macros. I am running ad-hoc, daily, monthly and customer related queries. These qu...
