|17809||02 Dec 2010 @ 11:07 PST||Jim Chapman||General||Reply||TDPUSER||PUBLIC is not a real user. It serves as a dummy key for public rights in DBC.AccessRights.
TDWM and TDWSTAGE must be for the Teradata Workload Manager, but I don't know how they are used. |
|17808||02 Dec 2010 @ 10:23 PST||joe.mingmoang||Database||Topic||Convert string into Date||Hi all,
I'm after some help with converting strings in to dates
For example, when i tried to convert '01.12.2010' in to date format '2010-12-01'. I keep getting error "Invalid date supplied"?... |
|17807||02 Dec 2010 @ 09:53 PST||Mystical||Database||Topic||Count and Sum by Month||I need to summarise some records for this year, by the number of entries and their value.Split by month. The issue i have is that each entry is listed by date and not by month. Could somebody pleas... |
|17806||02 Dec 2010 @ 07:56 PST||Tinku||General||Reply||TDPUSER||Thanks Jim. That really helped.
Can you also provide reason why PUBLIC, tdwm and tdwstage are used.
|17805||02 Dec 2010 @ 07:49 PST||teradater||Database||Reply||Transpose II||Here is an example, how to do this, but the restriction is that you'll need a field, which describe link between row order and column, where you want place this.
--drop table t;
create table t(... |
|17804||01 Dec 2010 @ 11:29 PST||alexmax021||General||Reply||Welcome to the Teradata Developer Exchange discussion forums!||
Hi, I am Alex from USA just join this community need your welcome hope that i ll gain so much from here
|17803||01 Dec 2010 @ 11:18 PST||sekharsree||General||Reply||Welcome to the Teradata Developer Exchange discussion forums!||hi all
in my quary having bottelnek problem ? but i hav collect the statistics and i give PI ,SI @ whtevr need to rectify this problem i did all but problem is not resolve wht i do @ how t... |
|17802||01 Dec 2010 @ 04:17 PST||Karam||Database||Reply||Create table as..with data...with compression?||Though a bit sideline observation but stats do carry over with CREATE TABLE.
CT DATABASE_A.TABLE_A AS DATABASE_B.TABLE_B WITH DATA AND STATS; |
|17801||01 Dec 2010 @ 02:17 PST||dnoeth||Database||Reply||Execute Macro from Stored Procedure???||Hi JK,
the DECLARE CURSOR(MACRO) is only for Embedded SQL, but not SPs.
You can call an SP from a macro, but not vice versa.
|17800||01 Dec 2010 @ 12:53 PST||jkwight||Database||Topic||Execute Macro from Stored Procedure???||
i know you can execute MAcros from within a Stored procedure. Looking in the SPL manual it says you can't execute the macro with EXECURE ...(); There is reference to DECLARE CURSOR (MACRO) form. ... |
|17799||01 Dec 2010 @ 12:11 PST||Jim Chapman||Tools||Reply||Tpump and Loading||Tpump and other load utilities have various restart options. If you specify the ROBUST option with Tpump, it will do fine-grained checkpointing and be fully restartable with either set or multiset... |
|17798||01 Dec 2010 @ 09:08 PST||Jimm||Database||Reply||Create table as..with data...with compression?||I ran the following on TD12; it has been around for a while though.
Create Table CT1
(PK Smallint Not Null
, VC Varchar(12)
, SI Smallint
, CF Char(3) )
Unique Primary Index (PK)
|17797||01 Dec 2010 @ 07:19 PST||Anand P||Jobs||Topic||Teradata DBA||Location: New Jersey
Duration: 6 months +
The Teradata Database Administrator (DBA) will be responsible for the day-to-day administration of the Teradata environment.
|17796||01 Dec 2010 @ 04:12 PST||Marcus Connolly||Database||Topic||Create table as..with data...with compression?||Hi there,
I'm just wondering if this feature exists? Am looking at running 'Create table As....' script and would come in handy if I could specify some compression values in the process to save sp... |
|17795||01 Dec 2010 @ 02:06 PST||WAQ||Database||Reply||Transpose II||See the following thread, it might help you.
|17794||30 Nov 2010 @ 08:53 PST||Henshin1||Tools||Topic||Tpump and Loading||Hi all,
I wanted to ask a question regarding Tpump loading into a Set table.
If the load fails, can it pick up again and continue from where it failed? Or does there have to be some form of cle... |
|17793||30 Nov 2010 @ 05:22 PST||Jim Chapman||General||Reply||TDPUSER||TDPUSER is created automatically during system installation. It may be used by the TDP on channel-attached systems to create sessions for internal administratiive purposes. |
|17792||30 Nov 2010 @ 04:46 PST||Jimm||Database||Reply||Error while Executing FASTLOAD Script||The default format for a bteq export is report format. You cannot have varchar output on a report - it is converted to char. The bteq export then becomes:
.set width 2000;
.set titledashes off;... |
|17791||30 Nov 2010 @ 04:43 PST||Venkatesh_gubba||Tools||Reply||transpose data||Hi,
when i clicked, the above link is not displaying any message...
can you guys please post the answer for me.
|17790||30 Nov 2010 @ 04:15 PST||Venkatesh_gubba||Database||Reply||Transpose II||I am updating ur question
Please help me in sql
i have data
i wish to convert into
1 a b c d
is this fine?
|17789||30 Nov 2010 @ 04:14 PST||Venkatesh_gubba||Database||Reply||Transpose II||plz let me know if you got the answer for this...
Thanks & Regards,
|17788||30 Nov 2010 @ 01:35 PST||Venkatesh_gubba||Analytics||Reply||Transposing Data||hi PCPaul, can you post the code using the case statement.
Thanks & Regards,
|17787||30 Nov 2010 @ 12:29 PST||Jim Chapman||Connectivity||Reply||Mainframe to Teradata Express (winodws) connectivity||No, that is not possible. Teradata Express supports network-attached clients only. |
|17786||30 Nov 2010 @ 12:03 PST||Tinku||General||Topic||TDPUSER||I'm seeing a user TDPUSER under DBC. Does anyone have any idea of what the user is why this user is created in Teradata.
Any help is appreciated.
|17785||30 Nov 2010 @ 11:06 PST||rayedmond||Connectivity||Reply||ODBC driver (32-bit) installation on 64-bit machine||I ran into a similar problem. Trying to get Visio 2007 to connect to Teradata VM13 on the same Win 7, 64-bit OS. I had installed the 64-bit ODBC drivers and Visio would not connect because it only ... |