| 44 | 15 Sep 2013 @ 06:53 PDT | Tools | Reply | Installing the TTU 14.10 on windows | oops, 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.
... |
| 43 | 15 Sep 2013 @ 02:58 PDT | General | Reply | SQL query optimization techniques | There 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... |
| 42 | 15 Sep 2013 @ 02:53 PDT | Tools | Reply | Installing the TTU 14.10 on windows | TTU_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... |
| 41 | 14 Sep 2013 @ 12:41 PDT | Database | Reply | Update for Derive Tables | Hi,
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... |
| 40 | 14 Sep 2013 @ 12:10 PDT | General | Reply | CASE 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... |
| 39 | 14 Sep 2013 @ 12:00 PDT | Tools | Reply | import huge data very quickly -- Fastload/Tpump/MLOAD | I 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... |
| 38 | 14 Sep 2013 @ 02:17 PDT | Tools | Reply | import huge data very quickly -- Fastload/Tpump/MLOAD | BTEQ 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... |
| 37 | 14 Sep 2013 @ 12:01 PDT | Tools | Reply | import huge data very quickly -- Fastload/Tpump/MLOAD | My bad, Yes ofcourse ou can use VARCHAR datatype for that.
|
| 36 | 13 Sep 2013 @ 08:38 PDT | Tools | Reply | import 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... |
| 35 | 13 Sep 2013 @ 12:08 PDT | General | Reply | Combine two queries into single | Hi,
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
... |
| 34 | 13 Sep 2013 @ 12:01 PDT | Database | Reply | Bulk Loading | You 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... |
| 33 | 12 Sep 2013 @ 10:45 PDT | Tools | Reply | import huge data very quickly -- Fastload/Tpump/MLOAD | Hi,
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... |
| 32 | 12 Sep 2013 @ 10:30 PDT | General | Reply | Can we get date format as MMM'YY | Dieter,
Thank you very much for such a valueable information.
|
| 31 | 12 Sep 2013 @ 10:25 PDT | General | Reply | Problem with procedure compiling | Well, 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 ... |
| 30 | 12 Sep 2013 @ 10:35 PDT | Database | Reply | Selecting duplicate records from a table - Complete record and not just the duplicate keys | Try the following query:
SELECT *
FROM TableName
WHERE (col1,col2,col3) IN (SELECT col1,col2,col3
FROM TABLENAME
GROUP BY 1,2,3
... |
| 29 | 12 Sep 2013 @ 10:13 PDT | General | Reply | Can we get date format as MMM'YY | You 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... |
| 28 | 12 Sep 2013 @ 08:05 PDT | Database | Reply | Condition for generating NULL | What 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... |
| 27 | 12 Sep 2013 @ 02:33 PDT | Database | Reply | Special Characters in Teradata | There 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... |
| 26 | 12 Sep 2013 @ 12:18 PDT | Database | Reply | Fiscal vs. Calendar Issue - Adjusting SYS_CALENDAR to Begin Monday | You can use
Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE
OR
for ISO Business Calender
Sys_Calendar.ISOBCal
|
| 25 | 12 Sep 2013 @ 12:07 PDT | Tools | Reply | Can we load the same table concurrently using TPT Update operator by setting seperate checkpoint files | As 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... |
| 24 | 11 Sep 2013 @ 11:19 PDT | Database | Reply | How to get data from Excel to Teradata table without using teradata olap connector | If 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. ... |
| 23 | 11 Sep 2013 @ 11:09 PDT | Database | Reply | Condition for generating NULL | when 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... |
| 22 | 11 Sep 2013 @ 09:32 PDT | Tools | Reply | Silent installation TTU 14.10 | The 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_... |
| 21 | 11 Sep 2013 @ 09:30 PDT | UDA | Reply | creating stored procedures | You 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... |
| 20 | 11 Sep 2013 @ 01:07 PDT | Database | Reply | Importing the large flat files failing | Well, 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... |