#DateForumTypeThreadPost
5426 Apr 2012 @ 07:53 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? Thanks for responding feinholz, I Agree. Hence please note: ref_2445.pdf_p438_V13.10 of the documentation includes the code snippet above which, I think we both agree, is not legal code...
5321 Apr 2012 @ 04:45 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? Addendum, to check myself I rewrote the example code for my system and got the following log error: D:\Users\d355869\Documents\tpt>tbuild -v MyAttrs.tpt -f test7.tpt Teradata Parallel Tra...
5221 Apr 2012 @ 03:11 PDTToolsTopicTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? In the example code for the dataconnector producer, I noticed you can have a schema that is 'delimited' and send it to a table that is formatted to non VARCHAR values: /* Appendix A:...
5120 Apr 2012 @ 07:34 PDTConnectivityReplyTDLOAD Error 8017: The UserId, Password or Account is invalid. Seems like "tdload" does not support any kind of target "LogonMech" other than the default td2. Hence your ldap database access can't be used. IE Only a full tpt scri...
5016 Apr 2012 @ 03:42 PDTDatabaseReplyUnderstanding Spool Space dbc.UsersV will give you your spool space adjusted for your profile (if you have one, likely you will). This is your limit of spool (and temp) space.
4915 Apr 2012 @ 02:56 PDTViewpointReplyTeradata Express 13.10 VmWare - How do navigate to viewpoint? Am I missing some required information to help you answer my post guys? 
4821 Mar 2012 @ 03:25 PDTViewpointTopicTeradata Express 13.10 VmWare - How do navigate to viewpoint? I've run:/var/opt/teradata/viewpoint-13.10.00.02/bin/viewpoint start and successfully started viewpoint, but for some reason I don't have "localhost" nor do I have the deve...
4701 Feb 2012 @ 05:01 PSTDatabaseReplyselect first N records   Pierre, I'm looking at that issue too. It seems unfortunate that TD13.0 can't just create one spool and steam it direct to the user? 2+ spools seems to be redundant work. ...
4627 Nov 2011 @ 12:14 PSTDatabaseTopicGLOBAL TEMPORARY TABLES and STATISTICS for BASE GTT and MATERIALISED GTT instance. Given statistics can be held on both: the materialised instance and the base schema in the data dictionary A) When does the base GTT acquire derived, sample and full sta...
4526 Nov 2011 @ 10:16 PSTDatabaseTopicWhy does Teradata limit "SELECT AND CONSUME TOP n" to n = 1 only? It would make sense to also allow "SELECT AND CONSUME TOP 10..." also would it not? Any thoughts why the limitation?
4426 Nov 2011 @ 05:09 PSTDatabaseReplyQueue Tables / SELECT AND CONSUME TOP N See "Performance Issues for Queue Tables" in pdf: "SQL Data Definition Language" for the database version you are looking at. Some statements re performance state:  ...
4310 Nov 2011 @ 02:57 PSTToolsTopicDisplay Mode Preferences in Teradata Plug-in for Eclipse Version: 13.01.0.200912171024 for Express vmware x64 4GB I'm using SUSE Linux Enterprise Server 10 (x86_64) guest OS with the above version of SQL Assistant Java Edition. When I do a show table - I need Text Mode answerset When I do select...
4230 Oct 2011 @ 02:13 PDTUDAReplyEXISTS vs. IN I also read a good explaination on the following site. Noting this is an Oracle site I believe logically teradata adhears to this method however functionally it will "create joins" lik...
4110 Oct 2011 @ 08:39 PDTDatabaseTopicSQL Assistant Import with embedded carriage returns Hello guys can you suggest a neat way to use the import tool on teradata sql assistant to pull in a txt file that contains carriage returns within the text columns? I'm getting stung at ...
4010 Oct 2011 @ 08:33 PDTDatabaseReplyError while Importing data from flat file to table thru sql assistant It is generally one of two things, either the table you've created does not match the insert into table (?,?,?); statement or the insert into statement does not have the same number of varia...
3921 Sep 2011 @ 08:30 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 That's incredibly help full, thankyou, as I've not found anything in the documentation (yet) that states that fact clearly. After running some tests:   CREATE JOIN IND...
3819 Sep 2011 @ 11:47 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 Also the following code successfully demonstrates NUSI's on both parts of the JOIN INDEX's PPI, being the hashed column and the ordered value column:  CREATE SET TABLE db.table ...
3718 Sep 2011 @ 04:37 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 Agreed: Therefore the following pages in the above document seems incorrectly worded... P611:"Designing for Range Queries: Guidelines for Choosing Between a PPI and a Value-Ordered...
3612 Sep 2011 @ 06:01 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 Addendum: The statements also exist in the TD12.00 Documentation "Database Design" 1094.pdf
3512 Sep 2011 @ 05:51 PDTDatabaseTopicVALUE ORDERED PRIMARY INDEX TD13.10 I'm a little confused by some of your documentation. Note here my system is actually 13.00 and I'm reading 13.10 notes but Database Desgn 1094.pdf mentions frequently the consept of a va...
3412 Sep 2011 @ 05:43 PDTDatabaseReplyLIKE Operator Consider a SINGLE TABLE JOIN INDEX of CREATE JOIN INDEX jidx_p AS SELECT product_id ,product_name ,Location ,country ,coalesce('0'||ph_num) as Contact_num FROM product PRIM...
3311 Sep 2011 @ 06:00 PDTDatabaseReplyPermSpace of a Secondary Index Best I could do:     COLLECT DEMOGRAPHICS FOR database.table INTO qcd ALL; SELECT i.IndexName , i.IndexNumber , i.SubTableId , i.IndexType , i.IndexT...
3211 Sep 2011 @ 12:27 PDTDatabaseReplyPermSpace of a Secondary Index Thanks for this.   In addition, as anybody discovered how to join DataDemographicsView.SubTableID back onto DBC.Indices, to get a bit more summary info (assuming you don't name ...
3129 May 2011 @ 09:00 PDTDatabaseReplyFULL OUTER JOIN syntax and problems with correct outputAddendum: 1) Restrict inner table within the ON condition 2) Restrict outer table within the WHERE condition A full outer join without derived tables needs to be treated as a Hybrid, a.ab and...
3029 May 2011 @ 06:13 PDTDatabaseReplyFULL OUTER JOIN syntax and problems with correct outputThanks so much for the article reference. It brings up two points I came across: 1) If a search condition on the inner table is placed in the WHERE clause, the JOIN is logically equivalent to an...

Pages