#DateForumTypeThreadPost
517 Dec 2014 @ 04:15 PSTDatabaseReplyDynamic Date Range in where clause Hi Vinaynaran,   Hope the below query helps you.   SELECT  CURRENT_DATE AS YOUR_CALENDAR_DATE , CASE WHEN DAY_OF_WEEK = 2 THEN YOUR_CALENDAR_DATE -...
417 Dec 2014 @ 03:31 PSTDatabaseReplyMigration of Oracle UDF to TeradataHi Vinaywani, While migrating Oracle to TD we converted UDF's to store procs in Teradata. There may not be same functions available but ya the same logic as far I could see in your function co...
317 Dec 2014 @ 02:56 PSTDatabaseReplyRow Counts of all Tables in a databaseHi Abhijit, I have modified Raja's query a little. SELECT     'SELECT CAST(' || '''' || TRIM(DATABASENAME) || '.' || TRIM(TABLENAME) || '&...
217 Dec 2014 @ 02:44 PSTDatabaseReplyCant make this Teradata Create procedure work Hi RodRicardIII,   There were just some minor changes   CREATE PROCEDURE StateAirportInventory ( IN Parm1 VARCHAR(12) ) DYNAMIC RESULT SETS 1 BEGIN ...
117 Dec 2014 @ 02:20 PSTDatabaseReplySQL to TERADATA MigrationHi Sherin, Any TD keyword could be used as an attribute/columnname/variable only if the the variable is between " and ". Example: SELECT 'VALUE' AS "VARCHAR" ...

Pages