All forum activity

#DateUserForumTypeThreadPost
1780902 Dec 2010 @ 11:07 PSTJim ChapmanGeneralReplyTDPUSERPUBLIC 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.
1780802 Dec 2010 @ 10:23 PSTjoe.mingmoangDatabaseTopicConvert string into DateHi 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"?...
1780702 Dec 2010 @ 09:53 PSTMysticalDatabaseTopicCount and Sum by MonthI 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...
1780602 Dec 2010 @ 07:56 PSTTinkuGeneralReplyTDPUSERThanks Jim. That really helped. Can you also provide reason why PUBLIC, tdwm and tdwstage are used. Thanks
1780502 Dec 2010 @ 07:49 PSTteradaterDatabaseReplyTranspose IIHere 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(...
1780401 Dec 2010 @ 11:29 PSTalexmax021GeneralReplyWelcome 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 __________________ http://moviesonlinefree.biz
1780301 Dec 2010 @ 11:18 PSTsekharsreeGeneralReplyWelcome 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...
1780201 Dec 2010 @ 04:17 PSTKaramDatabaseReplyCreate 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;
1780101 Dec 2010 @ 02:17 PSTdnoethDatabaseReplyExecute 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. Dieter
1780001 Dec 2010 @ 12:53 PSTjkwightDatabaseTopicExecute 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. ...
1779901 Dec 2010 @ 12:11 PSTJim ChapmanToolsReplyTpump and LoadingTpump 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...
1779801 Dec 2010 @ 09:08 PSTJimmDatabaseReplyCreate 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) ; Ins...
1779701 Dec 2010 @ 07:19 PSTAnand PJobsTopicTeradata DBALocation: New Jersey Duration: 6 months + Responsibilities: The Teradata Database Administrator (DBA) will be responsible for the day-to-day administration of the Teradata environment. ...
1779601 Dec 2010 @ 04:12 PSTMarcus ConnollyDatabaseTopicCreate 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...
1779501 Dec 2010 @ 02:06 PSTWAQDatabaseReplyTranspose IISee the following thread, it might help you. http://forums.teradata.com/forum/analytics/transposing-data
1779430 Nov 2010 @ 08:53 PSTHenshin1ToolsTopicTpump and LoadingHi 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...
1779330 Nov 2010 @ 05:22 PSTJim ChapmanGeneralReplyTDPUSERTDPUSER is created automatically during system installation. It may be used by the TDP on channel-attached systems to create sessions for internal administratiive purposes.
1779230 Nov 2010 @ 04:46 PSTJimmDatabaseReplyError while Executing FASTLOAD ScriptThe 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;...
1779130 Nov 2010 @ 04:43 PSTVenkatesh_gubbaToolsReplytranspose dataHi, when i clicked, the above link is not displaying any message... can you guys please post the answer for me. Thanks, Venkatesh venkatesh.gubba@gmail.com
1779030 Nov 2010 @ 04:15 PSTVenkatesh_gubbaDatabaseReplyTranspose III am updating ur question Please help me in sql i have data id col1 1 a 1 b 1 c 1 d i wish to convert into 1 a b c d is this fine?
1778930 Nov 2010 @ 04:14 PSTVenkatesh_gubbaDatabaseReplyTranspose IIplz let me know if you got the answer for this... Thanks & Regards, Venkatesh venkatesh.gubba@gmail.com
1778830 Nov 2010 @ 01:35 PSTVenkatesh_gubbaAnalyticsReplyTransposing Datahi PCPaul, can you post the code using the case statement. Thanks & Regards, Venkatesh
1778730 Nov 2010 @ 12:29 PSTJim ChapmanConnectivityReplyMainframe to Teradata Express (winodws) connectivityNo, that is not possible. Teradata Express supports network-attached clients only.
1778630 Nov 2010 @ 12:03 PSTTinkuGeneralTopicTDPUSERI'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. Thanks
1778530 Nov 2010 @ 11:06 PSTrayedmondConnectivityReplyODBC driver (32-bit) installation on 64-bit machineI 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 ...

Pages