All forum activity

#DateUserForumTypeThreadPost
1447522 Jan 2010 @ 02:29 PSTNetFxConnectivityReplythe data is screwed when returning special characters in teradata client 13.0Post additional information; for example a) Teradata 13 Driver: Do you mean ODBC Driver? b) Session Character Set: Are you using ASCII session character set or a Unicode (UTF8, UTF16) session ch...
1447422 Jan 2010 @ 01:29 PSTdnoethAnalyticsReplyHow to identify PPI columnsdbc.indexconstraints contains a CHECK with the partition expression.Dieter
1447322 Jan 2010 @ 12:17 PSTNK-8995DatabaseTopicCollect Statistics on TableWhat is the Usefulness of Collect Statistics Statement on Table Columns or Index?In what senario it should be used?
1447222 Jan 2010 @ 08:58 PSTJimmDatabaseReplyComples Sql querySelectTwoSeq1.Item_Id, TwoSeq1.Manager_Id As Seq1_Mgr, DiffSeq.Manager_Id As NxtSeq_MgrFrom(Select Item_Id, Manager_IdFrom TblWhere Seq_No = 1Group By 1Having Count(*) > 1) AS TwoSeq1Inner Join(...
1447122 Jan 2010 @ 08:55 PSTVadorDatabaseReplyTD 12 Timestamp Partitioning... what about MLPPI?As far as I know by doing an internal converision to DATE , its working: CREATE SET TABLE sysdba.FOO ( C1 DATE FORMAT 'yyyy-mm-dd', C2 DECIMAL(15,0), C3 TIMESTAMP(2), C4 CHAR(1) ) PRIMAR...
1447022 Jan 2010 @ 08:33 PSTpawan0608DatabaseTopicComples Sql queryThere us a table having 3 columns Item_id, Manager_id, Seq_NoWe need to find out all items having same manager at seq_no=1 but different manager at other seq_no. There is a possibility where one It...
1446922 Jan 2010 @ 05:09 PSTmanumanishkConnectivityTopicthe data is screwed when returning special characters in teradata client 13.0i have windows server 2008 64 bit version and there i have installed teradata 13 driver. when I run select query the special characters is convert to some junk character but in other machine it wor...
1446822 Jan 2010 @ 03:53 PSTCarlosALAnalyticsReplyHow to identify PPI columnsShow table?HTH.Cheers.Carlos.
1446722 Jan 2010 @ 01:17 PSTLeeDatabaseReplyInsert in CLOBMany thanks for that, I will investigate.
1446621 Jan 2010 @ 06:50 PSTBedrosDatabaseTopicCustomer having trouble installing Teradata Express on Window 2003 ServerHere is the log of his attempts to install Teradata Express on various Windows servers. These are 2003 Windows Intel servers. Would appreciate insight into why our customer is having these issues. ...
1446521 Jan 2010 @ 06:24 PSTshaik.feroz@aaa-calif.comToolsTopicDatastage 8.0 on Z-linuxHello Friends,we are planning to purchase Datastage 8.0 and install on Z-linux.I have a few questions, and I appreciate if some one can provide some info:1) Can we connect to Teradata V2R5 using Da...
1446421 Jan 2010 @ 03:53 PSTJim ChapmanDatabaseReplyMERGE INTOThe full ANSI/ISO SQL standard MERGE statement was not supported until Teradata version 12.0.
1446321 Jan 2010 @ 01:06 PSTVadorToolsReplyNotePad++, a GPL replacement to UltraEdit and TextPaddid you consider GVim ? It has a very good integration with win32 OLE, has a lot af helpers and extenders and extend the old vi capacity. By using perl DBI and a SQL extention, I even succeed to ...
1446221 Jan 2010 @ 12:59 PSTVadorDatabaseReplyInsert in CLOBBy using the import feature of SQL-Assistant, you are able to load clobs or blobs, SQLA has parameter markers for blobs and clobs: Insert Into Foo Values ( 'bar', ?B, ?C) The ?B is a placehol...
1446121 Jan 2010 @ 11:43 PSTSuperflashAnalyticsReplyHow to identify PPI columnsThat helps a bit yes -I see the distinction So.... is there any way you know of to get the partion xpression from the dictionary :-) RegardsSF
1446021 Jan 2010 @ 08:40 PSTThiruToolsReplydelete & insert vs update"1.- It depends on many things..." point is very truei upgraded my POC records to 7.5 million and tested :)..but in case of multistatement request (delete;insert) its taking more time comparing to ...
1445921 Jan 2010 @ 05:37 PSTScottishJimDatabaseReplyMERGE INTOThanks for replying,Unfortunately, that code still doesnt work and Im getting that familiar error message:5760: The SELECT subquery from the table reference must fully specify either a UPI value or...
1445821 Jan 2010 @ 02:24 PSTHariBharadwajDatabaseTopicSave BLOB content as a File... BTEQ / SPA BLOB column has a xyx.ZIP file. I need a BTEQ to pull out ALL these files from the BLOB column and SAVE them as '.ZIP' FILES at 'SPECIFIED PATH'.".EXPORT" doest not work on LOBs. Also, Would ...
1445720 Jan 2010 @ 03:43 PSTJay EngstenbergJobsTopicUrgent Teradata DBA Position in NYCMy client needs a Teradata DBA ASAP. Please contact me at jay@ctsit.com
1445620 Jan 2010 @ 02:29 PSTindrajit_tdDatabaseReplyhow to search text like ' "suffer patron"%'Use:Select * from where = '"suffer patron"' ;
1445520 Jan 2010 @ 01:57 PSTvldbfanaticDatabaseTopicCannot install Teradata Express 13 under Windows XPI have just downloaded Teradata Express 13 but I am unable to install it. I downloaded Teradata_Express_130.exe. When I click it then it starts to unzip. It finishes successfully. When it is unzipp...
1445420 Jan 2010 @ 01:44 PSTJim ChapmanDatabaseReplyMERGE INTOWhich Teradata version are you using? When I tried your SQL on my version 13.0 system, I got a syntax error, " Failure 3810 Column/Parameter 'JBC.t1.t1' does not exist."It seems the Teradata synta...
1445320 Jan 2010 @ 12:21 PSTScottishJimDatabaseTopicMERGE INTOHi all,My current employer is using an Oracle database, but is migrating to Teradata.I've been experimenting with converting Oracle SQL queries to Teradata SQL and failing miserably.Can anyone prod...
1445220 Jan 2010 @ 11:25 PSTas185188ToolsReplyNotePad++, a GPL replacement to UltraEdit and TextPadPdruley, My favorite editor is UltraEdit, although it is a bit expensive. The feature that I find most useful with UltraEdit is the ability to open from/save to SFTP or FTP locations, so I can w...
1445120 Jan 2010 @ 10:32 PSTCarlosALToolsReplydelete & insert vs updateYou 'small' POC is a VERY SMALL POC and not accurate at all:Here is a counterexample: BTEQ -- Enter your DBC/SQL request or BTEQ command:CREATE SET TABLE MY_DB.PRUEBA01, NO JOURNAL, NO ...

Pages