#DateForumTypeThreadPost
622 Nov 2008 @ 03:14 PSTUDAReplyIs INSTR type function available in Teradata...Adeel, I appreciate your prompt & useful information. Thanks & Best Regards.
518 Nov 2008 @ 06:30 PSTUDAReplyIs INSTR type function available in Teradata...Thanks Adeel.I have downloaded the functions to create the UDF but I could not compile them bcoz of below error."ODBC HY000: User Defined Function source on the client is not supported by the drive...
418 Nov 2008 @ 03:32 PSTUDATopicIs INSTR type function available in Teradata...Hi,I want to get some part of data from a string column which has..."1234567890""abcd#efgh#ijkl#mnop#qrst#uvwx#yz#0000""abcd#efgh#ijkl#mnop#qrst#1234#yz#0123""abcd#efgh#ijkl#mnop#qrst#aaaa#yz#0111"...
315 Jul 2008 @ 02:35 PDTDatabaseReplyChar to DateTry this...SELECT CAST(CAST( '11-JULY-2008' AS DATE FORMAT 'DD-M4-YYYY') AS DATE FORMAT 'YYYY-MM-DD')
212 Jan 2008 @ 02:38 PSTUDAReplyDifference and concepts of ETL.FastExport is the Utility to perform the Extraction Process and this may extract data from any system and creates the flatfiles may be temporary and MLOAD is the Utility to perform the Loading of t...
107 Jan 2008 @ 03:55 PSTDatabaseReplyHow do we generate surrogate keys in teradata ?CREATE TABLE TESTDB.TEST1 ( EMPNO NUMERIC(10) GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), ENAME VARCHAR(50)) ;ORUse CSUM functioncumulative (or running) sum of a colu...