|16374||14 Jul 2010 @ 01:02 PDT||dbkcis||Tools||Topic||SQL Assist 13, clipboard broken||Hi,
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... |
|16373||14 Jul 2010 @ 12:45 PDT||rverma||Database||Reply||Union All problem||Instead 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 |
|16372||14 Jul 2010 @ 12:23 PDT||Tnewbee||Database||Reply||Join 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. |
|16371||14 Jul 2010 @ 12:07 PDT||robpaller||Database||Reply||Join where second table has dupes!||Try this:
INSERT INTO STORY_OUT_TMP
FROM STORY_OUT O
ON C.Cust_ID = O.Cust_Id
AND C.Cust_Typ = O.Cust_Typ
AND C.Field_Nm = 'PARTY_NAME'; |
|16370||14 Jul 2010 @ 11:14 PDT||Bodhi.Sattva||General||Reply||Question 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 -
|16369||14 Jul 2010 @ 11:02 PDT||Tnewbee||Database||Topic||Join where second table has dupes!||Now here are my 2 tables :
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:
|16368||14 Jul 2010 @ 08:30 PDT||cbsmith||Tools||Reply||Fast Export producing unreadable text file||I 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... |
|16367||14 Jul 2010 @ 07:02 PDT||CarlosAL||Tools||Reply||Fast 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... |
|16366||14 Jul 2010 @ 06:39 PDT||cbsmith||Tools||Reply||Fast Export producing unreadable text file||I 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... |
|16365||14 Jul 2010 @ 06:25 PDT||harimon||Tools||Reply||mloading of single table with multiple file||Carlos and robpaller
|16364||14 Jul 2010 @ 05:50 PDT||CarlosAL||Tools||Reply||Fast Export producing unreadable text file||You 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 ;
|16363||14 Jul 2010 @ 03:25 PDT||cbsmith||Tools||Reply||Fast Export producing unreadable text file||Tried 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... |
|16362||14 Jul 2010 @ 02:07 PDT||teradata_techie||Tools||Reply||Fast Export producing unreadable text file||Hi
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... |
|16361||14 Jul 2010 @ 01:27 PDT||cbsmith||Tools||Topic||Fast Export producing unreadable text file||I am using Fast export to copy a Teradata table to a flat file on a windows server.
.begin export sessions 2;
|16360||13 Jul 2010 @ 11:54 PDT||Jimm||Tools||Reply||fastload 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.
|16359||13 Jul 2010 @ 07:41 PDT||goldminer||Database||Topic||Recollect stats by database after patch upgrade rollback||Does 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... |
|16358||13 Jul 2010 @ 03:49 PDT||stever||Viewpoint||Reply||Error in installing PDK 13.02||Viewpoint is supported on Postgres 8.1.5 and 8.3.9. |
|16357||13 Jul 2010 @ 03:11 PDT||feinholz||Tools||Reply||fastload 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... |
|16356||13 Jul 2010 @ 03:08 PDT||feinholz||Tools||Reply||TPT-Data Synch using Teradata Parallel Transporter||Teradata Data Mover is a separate product offering and is not part of TTU. It has special requirements (it requires Teradata Managed Servers running Linux). |
|16355||13 Jul 2010 @ 01:39 PDT||khachla||Viewpoint||Reply||Error in installing PDK 13.02||I used PostgreSQL 8.2 and everything OK. So it seems that PostgreSQL 8.4 does not work with the old syntax of itself. |
|16354||13 Jul 2010 @ 11:59 PDT||robpaller||Database||Reply||Reg Database view||At 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 .... ;
|16353||13 Jul 2010 @ 11:16 PDT||khachla||Viewpoint||Reply||Error in installing PDK 13.02||I already done step 2.2 and got the information that "Language »plpgsql« is already installed in »template1« database" |
|16352||13 Jul 2010 @ 11:08 PDT||robpaller||Database||Reply||Index Privilege on DBC tables||Not 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. ... |
|16351||13 Jul 2010 @ 10:47 PDT||robpaller||Tools||Reply||mloading of single table with multiple file||Good to know Carlos. Thanks! |
|16350||13 Jul 2010 @ 09:57 PDT||dfu||Viewpoint||Reply||Error in installing PDK 13.02||Make sure you have performed Step 2.2 correctly of the setup guide. |