#DateForumTypeThreadPost
1220 Jul 2009 @ 03:34 PDTUDAReplywhich delimiter should i use1F is a hex value which is defined as unit separator:http://en.wikipedia.org/wiki/C0_and_C1_control_codes
1115 Jul 2009 @ 02:56 PDTUDAReplywhich delimiter should i useThere is quite some discussion in the following thread. I'm pointing directly to the simple solution but there is still some risk that your separator will fail:http://www.teradataforum.com/teradata...
1005 Jun 2009 @ 02:36 PDTAnalyticsReplyRemove '-' from a columnIf you've got the free Oracle UDFs (http://www.teradata.com/DownloadCenter/Download.aspx?ForumID=137&TopicID=9228) installed on your system you can use udf.oreplace():select '123-456-789' as col1,...
904 Jun 2009 @ 02:55 PDTToolsReplyextract ddlselect databasename, tablename, tablekind, requesttextfrom dbc.tableswhere databasename = 'your_db'order by 1,2;You can use The export function of SQL Assistant to export this into html format.Rega...
802 Jun 2009 @ 05:00 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewI think your requirement is not so simple and I doubt any other db can offer this out of the box.Your example is quite simplistic but views can be much more complex and consist of nested views with...
729 May 2009 @ 11:19 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewYou could try to parse the output of:show select * from view1;Also check http://www.teradataforum.com/teradata/20040102_143148.htm
607 May 2009 @ 12:46 PDTUDAReplyTransform data setIf you are on windows or if you'd like to be platform independet you can download perl from www.activeperl.com and run a perl script to do the job:#!/usr/bin/perl -wuse strict;my ($col_value, @row,...
521 Apr 2009 @ 01:47 PDTUDAReplyUpdate Strategy with TeradataTeradata stores a primary key as unique primary index (UPI).Probably Informatica can deal with that.ct test_db.test1 (col1 integer not null,col2 char(1) not null,col3 varchar(255) not null)unique p...
420 Apr 2009 @ 03:51 PDTConnectivityTopicperl DBI driver for Teradata DBD::TeradataI just wanted to let you know that there is the enhanced perl modul DBD::Teradata v12.001 available under GNU GPL sinc Dec. 2008.Up to now an ancient version with reduced functionality has been ava...
329 Aug 2006 @ 11:14 PDTToolsReplySQL Qery Performance Problem... and if it is OLAP processing. Try WHERE EXISTS instead ...SELECTQ.CNTCT_ID,Q.INSTNC_ID,Q.CMPGN_RUN_DT,Q.CMPGN_RUN_TM,Q.CMPGN_RUN_DATE,Q.TRKING_ID,Q. USER_ID,Q.ITEM_ID,Q.CONV_TYPE_ID,Q. ACTIVITY...
210 Apr 2006 @ 12:06 PDTToolsReplyTpump - Is blocking normal?If the table write lock is the only problem remaining you may want to rearrange your batch window. If you have to load and query at the same time. You can give users access to that table via views ...
131 Mar 2006 @ 04:25 PSTToolsReplyTpump - Is blocking normal?alternative way to load the data:1. fastload file into empty staging table2. insert select via btequse the same PI for staging and destination table