|19393||13 May 2011 @ 11:19 PDT||RandomGuy234||Database||Reply||Empty 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... |
|19392||13 May 2011 @ 11:13 PDT||Jim Chapman||Database||Reply||Empty 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... |
|19391||13 May 2011 @ 10:40 PDT||dnoeth||Database||Reply||Empty 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.
|19390||13 May 2011 @ 10:37 PDT||dnoeth||Database||Reply||pivoting data from an existing table data please assist||SELECT
WHEN test1 >= test2 AND test1 >= test3 THEN 'test1'
WHEN test2 >= test3 THEN 'test2'
WHEN test1 >= test2 AND test1 >= tes... |
|19389||13 May 2011 @ 10:32 PDT||dnoeth||Database||Reply||RUN SQL QUERY||Hi 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
|19388||13 May 2011 @ 09:25 PDT||RandomGuy234||Database||Topic||Empty 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... |
|19387||13 May 2011 @ 08:48 PDT||devilhead||Database||Topic||TeraData SP returning back closed record set||Hi,
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.
|19386||13 May 2011 @ 06:23 PDT||lopesl||Tools||Reply||Using name of Flat File in TPT Load ||Hi,
When I tried to do this:
DEFINE SCHEMA Auxiliar
METACOL1 VARCHAR(40) METADATA(FileName)
this is the error:
Teradata Parallel Transporte... |
|19385||13 May 2011 @ 05:55 PDT||Jimm||Tools||Reply||Record count from worktable in mload||Multiload 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;
|19384||13 May 2011 @ 05:42 PDT||CarlosAL||Database||Reply||Creating a view that uses "WITH RECURSIVE" getting error 6926||Teradata 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...
|19383||13 May 2011 @ 05:42 PDT||Jimm||Database||Reply||Update Set by Subquery||Use 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
a.Cust_num = u_ukul_martdb.LB_M... |
|19382||13 May 2011 @ 05:01 PDT||Mystical||Database||Topic||Update Set by Subquery||I 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... |
|19381||13 May 2011 @ 03:06 PDT||chanchalpreetsingh||Database||Reply||pivoting data from an existing table data please assist||create volatile table
( id integer,
on commit preserve rows
insert into cps values
(1 , 32, 15,12)
insert into cps values
(2 , 1, 3,5... |
|19380||13 May 2011 @ 02:40 PDT||vamsi_142||UDA||Topic||what 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... |
|19379||13 May 2011 @ 02:00 PDT||SAROOP||Database||Topic||RUN SQL QUERY||Hi 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... |
|19378||13 May 2011 @ 12:12 PDT||CarlosAL||Cloud Computing||Reply||Teradata Express for VMware Player - Growing Pains and Version Refresh||Jim:
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... |
|19377||12 May 2011 @ 07:45 PDT||heidiiwee||Tools||Reply||Where 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?
|19376||12 May 2011 @ 06:11 PDT||QAtester||General||Reply||Welcome 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... |
|19375||12 May 2011 @ 05:27 PDT||feinholz||Tools||Reply||TPT_ISSUE||By "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 ... |
|19374||12 May 2011 @ 04:24 PDT||feinholz||Tools||Reply||Using 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... |
|19373||12 May 2011 @ 02:57 PDT||Jimm||Tools||Reply||How to load formatted file ( with indicator bits) using bteq||Import 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
|19372||12 May 2011 @ 02:53 PDTfirstname.lastname@example.org||Database||Reply||Prepare statement in a stored procedure||Thanks for the tip. I have made a lot of progress |
|19371||12 May 2011 @ 02:25 PDT||PRADKUMA||Tools||Topic||TPT with mainframe Varible block file||Has 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... |
|19370||12 May 2011 @ 02:09 PDT||Jimm||Database||Reply||Building heirarchal answerset from single table||You 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... |
|19369||12 May 2011 @ 01:55 PDT||Jim Chapman||Cloud Computing||Reply||Teradata Express for VMware Player - Growing Pains and Version Refresh||Carlos, 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... |