#DateForumTypeThreadPost
4415 Sep 2013 @ 06:53 PDTToolsReplyInstalling the TTU 14.10 on windowsoops, I am sorry for the misunderstanding. Well, it is very simple. You need to add ODBC connection to connect the VM. Perform the following steps and you can access the Teradata installed on VM. ...
4315 Sep 2013 @ 02:58 PDTGeneralReplySQL query optimization techniquesThere are lot of SQL optimization techniques and a lot of help is available online. Some of the useful links are as follows, you can explore on internet for others: http://www.teradata-sql.com/20...
4215 Sep 2013 @ 02:53 PDTToolsReplyInstalling the TTU 14.10 on windowsTTU_Base.exe is the main setup file that you need to run and then you will choose the products you want to install.  TTU_DBM.exe will install the database administration utilties. if you need...
4114 Sep 2013 @ 12:41 PDTDatabaseReplyUpdate for Derive TablesHi, I have checked you statement with a sample scenario and it is working fine. The following query should work for you. I have made just a little change, you were refering the COL55 by qualifyin...
4014 Sep 2013 @ 12:10 PDTGeneralReplyCASE STATEMENT TO VALIDATE VALID DATE DATATYPE FOR COLUMN ?The first thing is if the column definition is BUS_DT date format 'yy/mm/dd' then it will not allow invalid date during insertion.  Invalid values  are possible in case the colum...
3914 Sep 2013 @ 12:00 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADI agree with pruit that you must learn TPT instead of Legacy utilities. But the legacy utilities are often used in projects and their basic understanding helps a lot. For a sample MLOAD script you...
3814 Sep 2013 @ 02:17 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADBTEQ is a teradata tool based on Command prompt, and it work in all kind of plateforms(e.g. Windows, Linux, Unix). BTEQWIN is a GUI based version of BTEQ for Microsoft Windows. It works the same w...
3714 Sep 2013 @ 12:01 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADMy bad, Yes ofcourse ou can use VARCHAR datatype for that.  
3613 Sep 2013 @ 08:38 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOAD Yes the DEFINE part contains all the definitions of columns coming from file, and are VARCHAR.   DEFINE NAME (VARCHAR(20)), DOB (varchar(20))   In the insert pa...
3513 Sep 2013 @ 12:08 PDTGeneralReplyCombine two queries into singleHi, Below is one of the way you can combine the output of these two queries: SELECT ROW_COUNTS, SUM(CURRENTPERM) FROM DBC.TABLESIZE, ( SELECT COUNT(*) AS ROW_COUNTS FROM Employee ) DRV_EMP ...
3413 Sep 2013 @ 12:01 PDTDatabaseReplyBulk LoadingYou can use the following code to genrate ID column. Although the use of CSUM function is discouraged now. INSERT INTO Target_Table_name ( INDEX_COLUMN --Other_Column_list ) SELECT ,Sys...
3312 Sep 2013 @ 10:45 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADHi, I was trying to paste a sample fastload script but unable to post it. anyway you can consult the following URL for a quick start: http://teradataexample.blogspot.com/2012/07/how-to-write-samp...
3212 Sep 2013 @ 10:30 PDTGeneralReplyCan we get date format as MMM'YYDieter, Thank you very much for such a valueable information.  
3112 Sep 2013 @ 10:25 PDTGeneralReplyProblem with procedure compilingWell, You are using union all, and for union all (Set operators)  we have to meet the following conditions for union compatibility: Number of column should be equal in all select ...
3012 Sep 2013 @ 10:35 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keysTry the following query: SELECT * FROM TableName WHERE (col1,col2,col3) IN (SELECT col1,col2,col3 FROM TABLENAME GROUP BY 1,2,3 ...
2912 Sep 2013 @ 10:13 PDTGeneralReplyCan we get date format as MMM'YYYou can use th following query. SELECT SUBSTRING(MDate FROM 4 FOR 3) || '''' ||SUBSTRING(MDate FROM 1 FOR 2) FROM ( SELECT (YOUR_DATE_COLUMN (FORMAT 'YY-MMM-DD')) (CH...
2812 Sep 2013 @ 08:05 PDTDatabaseReplyCondition for generating NULLWhat I think is that IS NULL is just being checked against the function output, whether it is an error code or a true value.  If you check the same against the NOT NULL, then it gives the cor...
2712 Sep 2013 @ 02:33 PDTDatabaseReplySpecial Characters in TeradataThere is a function in Teradata named REGEX_SIMILAR that can detect the presence of special characters according to a regular expression. I have tried to find help about didn't find much. Die...
2612 Sep 2013 @ 12:18 PDTDatabaseReplyFiscal vs. Calendar Issue - Adjusting SYS_CALENDAR to Begin MondayYou can use Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE OR for ISO Business Calender Sys_Calendar.ISOBCal  
2512 Sep 2013 @ 12:07 PDTToolsReplyCan we load the same table concurrently using TPT Update operator by setting seperate checkpoint filesAs you know that Update Operator uses table level locks, it is not possible for an update operator to load the same table concurrently.  further when the apply statement starts the both updat...
2411 Sep 2013 @ 11:19 PDTDatabaseReplyHow to get data from Excel to Teradata table without using teradata olap connectorIf you are thinking about a way we used to do in Oracle to directly copy and paste the excel data into table using PL_SQL developer, I doubt the SQL Assistant do not provide any such facilty yet. ...
2311 Sep 2013 @ 11:09 PDTDatabaseReplyCondition for generating NULLwhen you run the above query, the when condition is checked and as the argument is invalid, the condition becomes false and it goes to the else part.  SELECT CASE WHEN (ACOS(2.3) IS NULL) THE...
2211 Sep 2013 @ 09:32 PDTToolsReplySilent installation TTU 14.10The following URL contains a detailed information related to silent installation of Teradata tools and utilities:   http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_...
2111 Sep 2013 @ 09:30 PDTUDAReplycreating stored proceduresYou need to install the C/C++ compiler. you can get help about these from the following link: http://developer.teradata.com/doc/tools/ttu/install/index.jsp?topic=%2F14_00_HelpIBMAIXDVD%2FInstallin...
2011 Sep 2013 @ 01:07 PDTDatabaseReplyImporting the large flat files failingWell, I am not sure if you are still thinking to solve the problem with SQL Assistant OR you are making your mind to use some other utilities(TPT, Fastload, Multiload).    If you want t...

Pages