All forum activity

#DateUserForumTypeThreadPost
1637414 Jul 2010 @ 01:02 PDTdbkcisToolsTopicSQL Assist 13, clipboard brokenHi, I just installed version 13 and found that I can copy the answerset and paste into a text file, but once I hover over an Excel file the clipboard reverts to the previous contents. Has anyone...
1637314 Jul 2010 @ 12:45 PDTrvermaDatabaseReplyUnion All problemInstead of changing the select sequence, you can also cast the first literal with max character you need. This will provied the complete result set and literal will not be truncated
1637214 Jul 2010 @ 12:23 PDTTnewbeeDatabaseReplyJoin where second table has dupes!I cannot specify the Field_NM because the field_nm willl be dofferent for each recoord like party name, reason, transaction amount etc.
1637114 Jul 2010 @ 12:07 PDTrobpallerDatabaseReplyJoin where second table has dupes!Try this: INSERT INTO STORY_OUT_TMP SELECT FROM STORY_OUT O INNER JOIN CSA C ON C.Cust_ID = O.Cust_Id AND C.Cust_Typ = O.Cust_Typ AND C.Field_Nm = 'PARTY_NAME';
1637014 Jul 2010 @ 11:14 PDTBodhi.SattvaGeneralReplyQuestion on Partitioning:: Full table lock or only Partition Lock?All, Have got a reply in an anlternative forum post by Carrie. If you wish to know the answer, please read on - http://developer.teradata.com/blog/carrie/2009/11/collecting-stats-on-partit...
1636914 Jul 2010 @ 11:02 PDTTnewbeeDatabaseTopicJoin where second table has dupes!Now here are my 2 tables : STORY_OUT CUST_ID CUST_TYP MSG_ID MSG_TX 123 EVT 234 THIS EVT IS CASE FOR This will find 2 matches in CSA table as below: CSA CUST_I...
1636814 Jul 2010 @ 08:30 PDTcbsmithToolsReplyFast Export producing unreadable text fileI should have said the table has hundreds of columns rather than rows. And there will be many more tables (with millions of rows) like this. I would need to write a SAS program to generate Fa...
1636714 Jul 2010 @ 07:02 PDTCarlosALToolsReplyFast Export producing unreadable text file"I was hoping for something simpler." Simpler than what? Your question was "Any idea what I am missing here?" Here you have the answer. You don't like it? Then go ahead with a SELECT * FRO...
1636614 Jul 2010 @ 06:39 PDTcbsmithToolsReplyFast Export producing unreadable text fileI was hoping for something simpler. The table has hundreds of rows. Not only do I have to cast each column individually depending upon it's type and desired format, but I also have to include co...
1636514 Jul 2010 @ 06:25 PDTharimonToolsReplymloading of single table with multiple fileCarlos and robpaller THANKS
1636414 Jul 2010 @ 05:50 PDTCarlosALToolsReplyFast Export producing unreadable text fileYou must cast the entire resultset as a unique column with type CHAR(N) with MODE RECORD FORMAT TEXT: ... .EXPORT OUTFILE blah/blah/blah/file MODE RECORD FORMAT TEXT ; SELECT CAST( ...
1636314 Jul 2010 @ 03:25 PDTcbsmithToolsReplyFast Export producing unreadable text fileTried different combinations but received error messages every time; 0004 .export outfile my_file.txt mlscript mload.txt MODE RECORD FORMAT varTEXT; **** 11:00:24 UTY1600 Internal error in 'EXP...
1636214 Jul 2010 @ 02:07 PDTteradata_techieToolsReplyFast Export producing unreadable text fileHi In FORMAT TEXT, it will produce an arbitrary number of bytes followed by an end-of-record marker, either X ‘0A’ or X ‘0D0A’ for Windows systems. So can you try with VARTEXT or UNF...
1636114 Jul 2010 @ 01:27 PDTcbsmithToolsTopicFast Export producing unreadable text fileI am using Fast export to copy a Teradata table to a flat file on a windows server. .logtable database.logtable_tablename; .logon terdata_box/user_id,password; .begin export sessions 2; ....
1636013 Jul 2010 @ 11:54 PDTJimmToolsReplyfastload insertion I agree with Steve. You can use Rob's Insert in Multiload, or put the "raw" columns from the file in a work table and calculate the derived columns on the move to the target table. Alternatively,...
1635913 Jul 2010 @ 07:41 PDTgoldminerDatabaseTopicRecollect stats by database after patch upgrade rollbackDoes anyone out there have some dynamic sql that will script stats collection from a PROD database to be applied to a TEST database? We had to rollback a patch upgrade and I lost all my stats in t...
1635813 Jul 2010 @ 03:49 PDTsteverViewpointReplyError in installing PDK 13.02Viewpoint is supported on Postgres 8.1.5 and 8.3.9.
1635713 Jul 2010 @ 03:11 PDTfeinholzToolsReplyfastload insertion I am not quite sure that the DBS FastLoad protocol will allow CASE logic in an INSERT statement. The use of the INSERT statement with FastLoad is very restrictive (DBS restriction, not client restr...
1635613 Jul 2010 @ 03:08 PDTfeinholzToolsReplyTPT-Data Synch using Teradata Parallel TransporterTeradata Data Mover is a separate product offering and is not part of TTU. It has special requirements (it requires Teradata Managed Servers running Linux).
1635513 Jul 2010 @ 01:39 PDTkhachlaViewpointReplyError in installing PDK 13.02I used PostgreSQL 8.2 and everything OK. So it seems that PostgreSQL 8.4 does not work with the old syntax of itself.
1635413 Jul 2010 @ 11:59 PDTrobpallerDatabaseReplyReg Database viewAt a very high level: (1) A view database can be created with no (or very little) perm space. (e.g. MyViewDB) (2) Create your views as REPLACE VIEW MyViewDB.View1 AS SELECT ... FROM .... ; (3)...
1635313 Jul 2010 @ 11:16 PDTkhachlaViewpointReplyError in installing PDK 13.02I already done step 2.2 and got the information that "Language »plpgsql« is already installed in »template1« database"
1635213 Jul 2010 @ 11:08 PDTrobpallerDatabaseReplyIndex Privilege on DBC tablesNot permissible with DBC.Accessrights without likely involving GSC. DBC does not have the necessary permissions to grant itself the rights needed to perform the GRANT to the role in questions. ...
1635113 Jul 2010 @ 10:47 PDTrobpallerToolsReplymloading of single table with multiple fileGood to know Carlos. Thanks!
1635013 Jul 2010 @ 09:57 PDTdfuViewpointReplyError in installing PDK 13.02Make sure you have performed Step 2.2 correctly of the setup guide.

Pages