All forum activity

#DateUserForumTypeThreadPost
5191129 Aug 2015 @ 11:46 PDTfayaz87GeneralTopicto know the stats defined for the tableHi dude's, I need to know the stats table to check when that column has introduced in the table.
5191029 Aug 2015 @ 11:15 PDTSantanu84DatabaseReplyTeradata Stored Procedure GOTOHi Fred, Sorry for the delay in response. Thanks a lot for your help. I finally managed it using While loop and If Then Else option. Thanking You Santanu
5190929 Aug 2015 @ 11:13 PDTSantanu84DatabaseReplyRow Allocation to NOPI Table using FastLoadOh just to add one more thing, the data volume is really high say 20 million or more. Thanking You Santanu
5190829 Aug 2015 @ 10:57 PDTSantanu84DatabaseTopicRow Allocation to NOPI Table using FastLoadHi All I need help to clear my understanding on few points as mentioned below. 1. One way of loading data into NOPI table is using Fast Load. There TD uses configuration map and list downs ...
5190729 Aug 2015 @ 10:54 PDTanjalirama7ToolsReplyTeradata Sql Assistant: 10060 WSA E TimedOut: No Response received when attempting to connect to Teradata Server Dear Teradata Users,   10060 WSA E Timeout:No Response received when attempting to connect to the Teradata Server.   One way to resolve the timeout issue is to increase...
5190629 Aug 2015 @ 10:51 PDTanjalirama7DatabaseReply10065 WSA E HostUnreachDear Teradata Users, 10060 WSA E Timeout:No Response received when attempting to connect to the Teradata Server. One way to resolve the timeout issue is to increase the Connection Timeout paramet...
5190529 Aug 2015 @ 09:32 PDTdnoethGeneralReplyHow to create a dynamic concatenationThere's an LPAD function: cast(LPAD(BR_NO || ACCT_NO, 12, '0') as char(12)) || 'TDA'  
5190429 Aug 2015 @ 09:25 PDTdnoethDatabaseReplyTRIM Leading letters then Leading 0The easiest way to get what you want is probably a regular expression, find the first digit which is not a zero: regexp_substr(col, '([1-9].*)')  
5190329 Aug 2015 @ 08:58 PDTAlsallamGeneralReplyHow to create a dynamic concatenationSorry, here is a sample data again: Concatenate the yellow columns to look like the green column. number of leading zeros will change because the Br_No is not fixed:  
5190229 Aug 2015 @ 08:28 PDTdnoethGeneralReplyerror: expecting ON keyword between sgsg_ck and where. please help meSimply remove the parens around the join condition: INNER JOIN ( SELECT SGSG_CK, SGSG_ID FROM ODS_PRD_STG_VW.CMC_SGSG_SUB_GROUP_STG WHERE SGSG_ID ='H001' ) SSG ON MPE.SGSG_C...
5190129 Aug 2015 @ 06:49 PDTsanthosh4b9GeneralTopicerror: expecting ON keyword between sgsg_ck and where. please help me INNER  JOIN  ( SELECT  SGSG_CK, SGSG_ID FROM ODS_PRD_STG_VW.CMC_SGSG_SUB_GROUP_STG WHERE SGSG_ID ='H001' )  SSG ON MPE.SGSG_CK=SSG.SGSG_CK...
5190028 Aug 2015 @ 04:22 PDTRanganathan_SriramanDatabaseReplyStored procedures problemBest way to debug these dynamic sql's would be to move them to an Output variable before calling the DBC.SysExecSQL statement. Anyways, coming to this query, looks like the issue is with the s...
5189928 Aug 2015 @ 04:00 PDTradsubraGeneralTopicSpoil Table information in Data DictionaryWhat is the meaning of Spoil Table information in Data Dictionary . Will this affect performance?   Iam getting this while executing as one of the query in the explain plan --steps SPLTBL
5189828 Aug 2015 @ 03:57 PDTRanganathan_SriramanDatabaseReplyMethod to find number of occurence of specific character in a stringHi, You can try the below: Sel character_length('Teradata is Relational Database') - character_length(Oreplace('Teradata is Relational Database','a','')); -- will...
5189728 Aug 2015 @ 03:00 PDTradsubraGeneralTopictuning queryBelow query is taking a long time to execute.Any suggestions would help   SELECT    PM_VSMSMT7O3EIKY6L6SY2ZNDUT2UQ.TRX_SC_ID , PM_VSMSMT7O3EIKY6L6SY2ZNDUT2UQ.SALES_ORDER_LINE_...
5189628 Aug 2015 @ 02:25 PDTPrivate Forum
5189528 Aug 2015 @ 02:16 PDTPrivate Forum
5189428 Aug 2015 @ 01:39 PDTAlsallamGeneralTopicHow to create a dynamic concatenationI am trying to concatenate 2 fields ACCT_NO and BR_NO where both fields should add up to 12 character and if not I should add leading zeros. concatenation must have a suffix of TDA. For example: 0...
5189328 Aug 2015 @ 01:34 PDTPrivate Forum
5189228 Aug 2015 @ 01:18 PDTkirthiDatabaseReplyNeed to re-write delete statement DELETE AA FROM IMPORT_REFER_F AA, IMPORT_REFER_S BB, IMPORT_REFS_F_GT CC WHERE  AA.JOB_ID = BB.JOB_ID AND AA.JOB_HEADER_ID = BB.JOB_HEADER_ID AND AA.JOB_LINE_NUM = BB.JOB_LINE_NUM A...
5189128 Aug 2015 @ 01:02 PDTPrivate Forum
5189028 Aug 2015 @ 01:01 PDTChris_1776GeneralTopicTeradata Express tbuild Error Hi everyone. Thank you for the effort you put into the Teradata message forums, it is greatly appreciated. While I know Teradata express is not supported, I have ran into an obstacle and thought...
5188928 Aug 2015 @ 12:53 PDTap90792DatabaseTopicNeed to re-write delete statement Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.   DELETE  FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID,  AA.JOB_HEADER_...
5188828 Aug 2015 @ 12:48 PDTToddAWalterGeneralReply1 MB data block size in 14.10It will NOT increase spool size. We always qualify from the source table before writing to spool so the block size of the table does not affect the size of the spool. It is correct that if a query ...
5188728 Aug 2015 @ 12:22 PDTkrishaneeshDatabaseReplyhow to find the unique column(s) in a tableif they are views withing views, the actual table may not show up. in such case do a "show select * from databasename.viewname". This gives the definitions of all underlying views and tab...

Pages