#DateForumTypeThreadPost
1520 Jul 2012 @ 04:34 PDTPrivate Forum
1410 Jul 2012 @ 09:46 PDTPrivate Forum
1327 Jun 2012 @ 07:33 PDTPrivate Forum
1222 Jun 2012 @ 09:46 PDTPrivate Forum
1126 Apr 2010 @ 07:28 PDTDatabaseReplyWhen does outer join become inner?Thanks Fred, that was helpful!
1022 Apr 2010 @ 07:22 PDTDatabaseTopicWhen does outer join become inner?can anyone please explain the scenarios where an outer join becomes an inner join..
921 Apr 2010 @ 02:56 PDTDatabaseReplyJoin On String Ignore CaseCS stands for 'Case Specific'
820 Apr 2010 @ 09:13 PDTDatabaseReplyJoin On String Ignore CaseHi, Teradata default mode for character comparison is non case specific and the storage will be done as entered. If Case specific comparison is needed join on a.str_col(CS) = b.str_col(CS) ...
718 Apr 2010 @ 01:20 PDTDatabaseReplyJunk Characters in FASTEXPORTED Flat file..Jimm,If the query is cast to char(31400) will it not have too many spaces at the end of each record?
615 Apr 2010 @ 09:12 PDTDatabaseReplyJunk Characters in FASTEXPORTED Flat file..When TEXT format is used to export from fexp, each record will have arbitrary number of bytes, followed by an end-of-record marker, which is a: • Line feed (X'0A') on UNIX platforms • Carria...
514 Apr 2010 @ 08:32 PDTDatabaseReplyJunk Characters in FASTEXPORTED Flat file..Hi, Try with this query... SELECT cast(ProcID AS CHAR(5))||'|'|| cast(CollectTimeStamp AS CHAR(19))||'|'|| cast(QueryID AS CHAR(18))||'|' || cast(ExpRowNo AS CHAR(4))||'|' || cast(Explain...
413 Apr 2010 @ 11:43 PDTDatabaseReplyAggregation is so slow..can anyone help me what i have to do?you may try this.. Insert all the dates which satisfy the following condition from IECMD table to another table with two columns - valid_from and valid_to dates. IECMD.DATE_FLD >= DS.VALID_FROM...
307 Apr 2010 @ 11:48 PDTGeneralReply2683 Numeric Overflow occurred during computation-MultiLoad999999.99 is the maximum number held by decimal (8,2). Please check if the result of your comptation is exceeding.
217 Mar 2010 @ 07:26 PDTGeneralReply3800: Datatype Mismatch in THEN/ELSE expression. Try this... Select Employee_ID, CASE WHEN Joining_DT IS NULL THEN cast( '~' as char(8)) ELSE cast (Joining_DT as Char(8)) END from Employee;
116 Mar 2010 @ 07:29 PDTGeneralReplyMultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.Hi, Please check the database spaces where the UV and ET tables are created.Also, check if the default database of the user id logged in has sufficient space left or not. If need be increase th...