#DateForumTypeThreadPost
1021 Aug 2009 @ 02:33 PDTToolsTopicUse of Delimiter in FastloadI've data which has delimiter as comma(,) and each record is enclosed by double quotes " " as below format (2 rows given)"000002BF1A4ED13C6D2AC92F55A251A1","13 ","~DV ","01/01/111...
904 Aug 2009 @ 02:20 PDTAnalyticsTopicRelease Lock from a TableI'm selecting rows from a table and then Inserting a row to that table.But after selecting - the table get locked - I don't know what kind of lock!And the Insert got hanged - neither failing nor sh...
803 Aug 2009 @ 04:37 PDTDatabaseReplyImport Problem - Date fieldThrough Fastload/Multiload/Queryman - you can able to import any format of date.Just specify the format in the layout in case of loader utilities - or through queryman just change the date format ...
703 Aug 2009 @ 04:34 PDTDatabaseReplyteradata varcharYou want to mean VARCHAR Datatype huh!!!!Space can be inserted in VARCHAR(N) datatype...
603 Aug 2009 @ 04:28 PDTDatabaseReplyTab in columnThe CHR(9) represents character.And CHR(9) is working fine in Teradata V2R6.I've checked through my Queryman (v 7.2.0.03) - it's perfectly giving character!!!
503 Aug 2009 @ 03:04 PDTToolsTopicHow to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!I need to COLLECT STATS after an Update Statement.BT; Update Table ; COLLECT STATS ; Delete;ET;I've to use BT; ET; as a Multi-statement request in my BTEQ scripts.But I'm getting Error - as DDL...
410 Jul 2009 @ 09:43 PDTDatabaseReplyPPITry this!!!!!CREATE TABLE TABLE_NAME(PTY_KEY INTEGER,FILL_DT DATE FORMAT 'YYYY-MM-DD') PRIMARY INDEX CLM_NUPI_KEY (PTY_KEY) PARTITION BY RANGE_N(FILL_DT BETWEEN '2001-01-01'(DATE) AND '2009-12-31...
309 Jul 2009 @ 05:38 PDTAnalyticsTopicWill MLOAD able to Insert data into Global Temporary Tables !!!Is Teradata Utilities like allows to /update/delete the data into !I need to insert huge volume of data to a GTT through MLOAD via 1 session! Is that possible via single session! It seems MLOAD wi...
216 Jun 2009 @ 07:08 PDTAnalyticsTopicLevenstein Distance AlgorithmLevenstein Distance Algorithm is a famous algorithm used for measuring the amount of difference between two sequences (i.e., the so called edit distance).The Levenshtein distance between two string...
105 Jun 2009 @ 01:02 PDTAnalyticsReplyRemove '-' from a column/* UNDERSTAND THE STORED PROCEDURE & WRITE YOUR OWN *//* Create Procedure to Replace unwanted Characters from a Field */REPLACE PROCEDURE ETLPROC_DEV.NAD_REPLACE(IN in_VAR1 VARCHAR(20),OUT out_VAR2...

Pages