#DateForumTypeThreadPost
1026 Mar 2009 @ 02:06 PDTToolsReplyCollect Statistics on Empty tableHi Smarty,You should collect statistics using the Optimizer form on newly created data tables while theyare still empty. An empty collection defines the columns, indexes, and synoptic data structur...
929 Oct 2008 @ 01:22 PDTTrainingReplyTeradata Basic Certification HelpCongrats Rajneesh ..All the Best
801 Oct 2008 @ 11:29 PDTTrainingReplyTeradata Basic Certification HelpHi all ,The best place to find all the Teradata related PDFs is -http://www.teradataforum.com/ncr_pdf.htmhttp://www.teradata.com/resources/drivers-udfs-and-toolboxhttp://www.info.teradata.com/comin...
721 Apr 2008 @ 05:20 PDTToolsReplysample FLOAD,MLOAD and FAST EXPORT scriptsDear Reddy,Fast Export Script:.logtable DXWX_P57_DLWORK_DB01.logtable_EMP;.logon tdp8/ADMIN_DXWX_P57,apple;.begin export sessions 2;.export outfile D:\IDQ\Outputs\emp FORMAT TEXT;select *from DXW...
608 Feb 2008 @ 06:32 PSTToolsReplyCOMP causing Mload faliureHi Fred Pluebell,Thanks for you reply.As you said i gave .FIELD BALANCEIN * BIGINT in the Layout.and in the DML gave as CAST(:BALANCEIN AS DECIMAL(17,2))/100. then changes DDL as the Column BALANCE...
505 Feb 2008 @ 02:58 PSTToolsReplyCOMP causing Mload faliure[font=Tahoma][/font]Hi shaik.feroz, Thanks for your responce. i tried in 2ways. Way1-In the Layout i mentioned BALANCE FIELD decimal(25,2) and didnt change the table which has BALANCE DECIMAL(13,2)...
429 Jan 2008 @ 04:36 PSTToolsTopicCOMP causing Mload faliureHi Gurus,As we know we have different ways to Compress the Decimal data Like COMP-3,COMP-4,COMP-5 and COMPFor example if we have COLUMN given as SALARY S9(13)V99 Comp-3 , we create Teradata table...
329 Jan 2008 @ 04:35 PSTToolsReplyCasting Zoned decimal into readable decimalHi Gurus,As we know we have different ways to Compress the Decimal data Like COMP-3,COMP-4,COMP-5 and COMPFor example if we have COLUMN given as SALARY S9(13)V99 Comp-3 , we create Teradata table...
207 Jan 2008 @ 03:05 PSTToolsTopicDecimal error in Mload JCLHI Folks,This Query is about TeraData Mainframe error:I have Target table for which we are preparing Mload JCL & the Source is Mainframe Flat file.I have few columns like CHARGES DECIMAL(1...
129 Nov 2006 @ 01:33 PSTToolsReplyfexp data doubtyap.. Nishi.Open the exported file in Text pad and delte the first Junk..it will work fineregardsSatya