All forum activity

#DateUserForumTypeThreadPost
1939313 May 2011 @ 11:19 PDTRandomGuy234DatabaseReplyEmpty rows...Thank you both! I found another thread with the same suggestion before I saw this, and with a little tweaking I managed to get it. I was coming back to delete this thread when I saw these two s...
1939213 May 2011 @ 11:13 PDTJim ChapmanDatabaseReplyEmpty rows...EXPAND ON operates on columns of PERIOD type. An outer join using a calendar table may still be the best solution with the traditional date type. Here is a simple example: create table sales...
1939113 May 2011 @ 10:40 PDTdnoethDatabaseReplyEmpty rows...In TD13.10 there's a new EXPAND ON query clause which is exactly what you need. Whithout this feature is a typical solution based on a LEFT OUTER JOIN to a calendar table. Dieter
1939013 May 2011 @ 10:37 PDTdnoethDatabaseReplypivoting data from an existing table data please assistSELECT person, CASE WHEN test1 >= test2 AND test1 >= test3 THEN 'test1' WHEN test2 >= test3 THEN 'test2' ELSE 'test3' END, CASE WHEN test1 >= test2 AND test1 >= tes...
1938913 May 2011 @ 10:32 PDTdnoethDatabaseReplyRUN SQL QUERYHi Saroop, you need to name the Derived Table/Inline View, only Oracle allows to omit the name in some cases :-) AND bnft_typ_cd = 'FMIA') AS x Dieter
1938813 May 2011 @ 09:25 PDTRandomGuy234DatabaseTopicEmpty rows...So this may seem like a silly question, but I am attempting to show data for certain periods of time for each fiscal year. However, some of the fiscal years do not have data for some of those perio...
1938713 May 2011 @ 08:48 PDTdevilheadDatabaseTopicTeraData SP returning back closed record setHi, I am trying to execute a Teradata SP which returns back a record set. BTEQ shows that the result Result Set correctly. I am trying to emulate the same using MS ADO Command Object. I...
1938613 May 2011 @ 06:23 PDTlopeslToolsReplyUsing name of Flat File in TPT Load Hi, When I tried to do this: DEFINE SCHEMA Auxiliar ( COL2 VARCHAR(7), COL3 VARCHAR(15), METACOL1 VARCHAR(40) METADATA(FileName) ); this is the error: Teradata Parallel Transporte...
1938513 May 2011 @ 05:55 PDTJimmToolsReplyRecord count from worktable in mloadMultiload locks the work table for Write. If you want to look at it during the load, use an Access Lock. Locking wt_tabl1 For Access select Count(*) from wt_tabl1; :-)
1938413 May 2011 @ 05:42 PDTCarlosALDatabaseReplyCreating a view that uses "WITH RECURSIVE" getting error 6926Teradata uses specific syntax for RECURSIVE VIEWS: "CREATE RECURSIVE VIEW rec_view (col1,col2…) AS..." You cannot simply wrap the WITH RECURSIVE query inside the CREATE/REPLACE VIEW AS... HTH....
1938313 May 2011 @ 05:42 PDTJimmDatabaseReplyUpdate Set by SubqueryUse a standard ANSI update :- UPDATE u_ukul_martdb.LB_MORE_BL_Price_Incentive a SET Date_Accnt_Closed = u_ukul_martdb.LB_MORE_BL_accepts.rejection_date Where a.Cust_num = u_ukul_martdb.LB_M...
1938213 May 2011 @ 05:01 PDTMysticalDatabaseTopicUpdate Set by SubqueryI am very new to SQL and hope somebody can be of assistance. I have tried doing a search on the Forum for “Update Set by Subquery” but the results I found were too difficult for me to follow. H...
1938113 May 2011 @ 03:06 PDTchanchalpreetsinghDatabaseReplypivoting data from an existing table data please assistcreate volatile table cps ( id integer, test1 integer, test2 integer, test3 integer) on commit preserve rows insert into cps values (1 , 32, 15,12) insert into cps values (2 , 1, 3,5...
1938013 May 2011 @ 02:40 PDTvamsi_142UDATopicwhat happens?Hi all, I am new to teradata. can anybody explain me what happens(like hashing,subtable,row distribution etc) in the PE,AMP and other componants when we are (1)inserting a row (2)retrieving a r...
1937913 May 2011 @ 02:00 PDTSAROOPDatabaseTopicRUN SQL QUERYHi all i am new to TERADATA....I have an issue here.....Unable to run the following query. Giving error : Expected some thing like a name or a unicode delimited identifier of an UDFCALLNAME keyw...
1937813 May 2011 @ 12:12 PDTCarlosALCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshJim: Agreed. Besides, if you want/need to configure the network, you'll surely need to use "vmnetcfg.exe" which is hidden inside “network.cab” in the VMWare Player installation file (at l...
1937712 May 2011 @ 07:45 PDTheidiiweeToolsReplyWhere I can find the install download for Teradata Tools and Utilities (urgent!)what if i am using the trial version? will they send me the CDs as well?
1937612 May 2011 @ 06:11 PDTQAtesterGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!hello friends, Can anyone help me out with the terradata DCM module as we are replacing it with our legacy DCM system... my first question would be while testing the screens in it which scre...
1937512 May 2011 @ 05:27 PDTfeinholzToolsReplyTPT_ISSUEBy "DataConnector code" I hope you meant the script. We are not sharing any software. The DataConnector error is self-explanatory. The file you specified in the script is not found. As far as ...
1937412 May 2011 @ 04:24 PDTfeinholzToolsReplyUsing name of Flat File in TPT Load Yes, we do support this. In the schema object in the script, we support this syntax: DEFINE SCHEMA T2_SOURCE_SCHEMA DESCRIPTION 'T2 SCHEMA' ( METACOL1 VARCHAR(40) METADATA(Fi...
1937312 May 2011 @ 02:57 PDTJimmToolsReplyHow to load formatted file ( with indicator bits) using bteqImport Indicdata will do it. I would normally specify the Not Null against appropriate columns, but it looks like you can get away without it. .import indicdata file= d:bteqtestorg.txt .Repe...
1937212 May 2011 @ 02:53 PDTperrelli_c@yahoo.comDatabaseReplyPrepare statement in a stored procedureThanks for the tip. I have made a lot of progress
1937112 May 2011 @ 02:25 PDTPRADKUMAToolsTopicTPT with mainframe Varible block fileHas anyone use TPT with variabl block(VB) file on the mainframe. I am getting an error wherein it says expected 1000 received 25. I understand this is due to a short record in the file. I have give...
1937012 May 2011 @ 02:09 PDTJimmDatabaseReplyBuilding heirarchal answerset from single tableYou do not need a recursive query for this - just use a Join. Create Table OrgHier (User_Id Smallint Not Null , First_Name Varchar(20) Not Null , Last_Name Varchar(30) Not Null , Super...
1936912 May 2011 @ 01:55 PDTJim ChapmanCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshCarlos, thanks for the correction. However, it is still quite unnecessary to build a Teradata VM from scratch since the Teradata Express Edition for VMWare provides a complete pre-built VM image w...

Pages