#DateForumTypeThreadPost
1021 Mar 2012 @ 05:16 PDTDatabaseTopicIs there an out of the box equivalent to Sybase or SQL Server @@servername A script needs to determine if it is being run in production or non production region and take the approrpiate actions. Assume database names are the same in all regions. User Id won't h...
902 Mar 2012 @ 03:49 PSTDatabaseTopicIf @@error in MS SQL. What is teradata equivalent/workaround. Any assistance would be greatly appreciated. I looked at Teradata document on error handling and had no insights, that I could see, on how to trap the error. Thank You.
802 Mar 2012 @ 08:43 PSTDatabaseReplyAPI for DBC.SysExecSQL There is not any material that covers setting / retrieving parameters in indicated manual. There is only one example - very minimal documentation.
701 Mar 2012 @ 10:46 PSTDatabaseReplyWhy is a missing zero in the date's month a format problem in Teradata Thank you.
601 Mar 2012 @ 10:42 PSTDatabaseTopicAPI for DBC.SysExecSQL Where do I find documentation on parameters to set before invoking the above routine. Where do I find documentation on what parameters are available to be retrieved? I would like  t...
529 Feb 2012 @ 10:19 PSTDatabaseReplyCreate temporary table For others who are used to using temp tables at the session level only , I have added the missing qualifier. CREATE Volatile TABLE tempTable AS (select top 10 * FROM sourceTable) WITH d...
424 Feb 2012 @ 10:20 PSTDatabaseTopicWhy is a missing zero in the date's month a format problem in Teradata -- valid SELECT cast('2012/02/29' AS DATE ); -- invalid SELECT cast('2012/2/29' AS DATE ); invalid SELECT cast('2012/2/29' AS DATE FORMAT 'YYYY/MM/DD' )...
324 Feb 2012 @ 09:33 PSTDatabaseReplyConvert string 13/10/1974 into 13-10-1974 format Using syntax from manual does not fix my date conversion issue. Source data - 2/29/2012 Source column field type is varchar(10) Target column field type is date Action needed ...
223 Feb 2012 @ 03:19 PSTDatabaseReplyInserting values to a created table - syntax help INSERT INTO DATA_QUALITY.DQ_control SELECT stg.JobStream FROM (SELECT JobStream FROM Data_Quality.HLTH_RI_Orphan_Parent_Staging WHERE MigrationInd = 'Y' ) as ...
114 Feb 2012 @ 11:20 PSTDatabaseTopicReturning to setting variables. snippet from previous discussion does not work on current teradata platform. Create volatile Table TEMP As ( Select '1060401' (int) startdate, '1060431' (int) enddate ) ;   When executed get error 'Something expected ...