#DateForumTypeThreadPost
287810 Jul 2014 @ 02:02 PDTDatabaseReplyMapping Values from many to one relationship to a one to one relationshipHi Justin, it's easier to answer when you provide additional info: what's your TD release? How big is your table? Is there a known maximum number of desriptions per corp? Do you need a...
287710 Jul 2014 @ 01:43 PDTConnectivityReplyRegarding installation of teradata tool in a personnel computerHi Manoj, did you try to connect to TD from within the VM or from your OS? TD might not be started, run pdestate -a from a terminal window within the VM, if it's down run /etc/init.d/tpa star...
287610 Jul 2014 @ 12:27 PDTDatabaseReplyCreating a TotalHi Bill, did you try SUM((char_length(serial_number) - char_length(apputil_user.oreplace(serial_number, ','))) + 1) If this is not what you want you need to add more details.
287510 Jul 2014 @ 12:21 PDTToolsReplySpeed up imports in BTEQ or SQL AssistantPACK is not the same as SERIALIZE in TPump, it's the same as PACK in TPump, simply defining how many rows are send to the DBMS in one request. Unless there's an IMPORT both multiple sessio...
287410 Jul 2014 @ 12:11 PDTDatabaseReplyConstraints in TeradataHi Raghu, you can't do that with a constraint in Teradata. Should be done during load (or in a trigger, but performance might be horrible)  
287310 Jul 2014 @ 12:06 PDTDatabaseReplySELECT failed 7453 : interval field overflowThere were queries running longer than 9999 seconds = 02h 46m 39s, so simply increase the interval.  When you check the source for dbc.qryLogV you will notice a column named ElapsedTime which...
287205 Jul 2014 @ 10:43 PDTGeneralReplyI have a country table with country_name column.Hi Purushotham, you need a CASE: order by case when country_name = 'India' then 0 else 1 end, country_name desc  
287105 Jul 2014 @ 10:41 PDTGeneralReplyx.x.TDC.x.R.x in VMware Suse teradata-) 11 is the Suse version -) 2.6.32.54 is the kernel version -) 0.23.TDC.1.R.2 is Teradata's release number
287005 Jul 2014 @ 09:08 PDTGeneralReplyx.x.TDC.x.R.x in VMware Suse teradataTeradata uses a modified SLES kernel, e.g. version 2.6.16.60 and this is Teradata's release number.
286905 Jul 2014 @ 09:04 PDTDatabaseReplyNeed help to write Recursive Query with Unknown Depth levelIf you know there are no loops in your data you can simply remove it. But I would never trust my data quality, so better increase it to a very high number you'll never reach, e.g. 10000.
286805 Jul 2014 @ 08:59 PDTDatabaseReplyFailure due to Loader Slots UnavailabilityYou don't have to care about the number of sessions, but the number of jobs. And if you got a table with 24 rows, one for each hour, you can simply join to it: select hours.hr, cou...
286705 Jul 2014 @ 07:54 PDTGeneralReplyA sımple questıonNo, you can't do that. But why do you think you need it? Within a recursive query you can simply apply the new name and still have the output name as defined.
286605 Jul 2014 @ 05:44 PDTGeneralReplyA sımple questıonSimply name it differently. When there's a column and an alias with the same name the parser assumes the query it's referencing the column and not the alias. SEL SUBSTR(K,1,3) newK , LE...
286505 Jul 2014 @ 01:42 PDTDatabaseReplyCounts and total count in one query ?Why don't you create a new topic instead of adding it to a totally unrelated thread. And why do you want to split the data in three sets? Trying to make your BTEQ export faster? Did you check...
286404 Jul 2014 @ 07:19 PDTDatabaseReplyhow to select non 0 and numeric values from Varchar fieldIf you're on TD14 you might use a Regular Expression. This is exactly hat you're doing right now, "check if there's any digit between 1 and 9": where regexp_similar(id,...
286304 Jul 2014 @ 06:45 PDTGeneralReplyTimestamp with time zoneHi Murigesh, afaik you can't do that. The time zones in tdlocaledef are only used for casting strings to a timestamp and not vice versa. There's a one-to-many relation between time zone n...
286204 Jul 2014 @ 05:06 PDTDatabaseReplyNOT FOUND handler problem (and empty sets)Are you running the SP in SQL Assistant in an ODBC session? According to SQLA's help there's a known limitation in ODBC: "If a macro (or execute parallel) returns zero rows from a...
286104 Jul 2014 @ 12:27 PDTGeneralReplyTimestamp with time zoneHi Murugesh, you probably use an ODBC connection. There are some known limitations in ODBC regarding TIME, "Time fields do not display fractional seconds or Time Zone information.", pro...
286003 Jul 2014 @ 02:55 PDTDatabaseReplyMultiple select in Tearadata sub queryHi Rakesh, there's no IF in Teradata SQL and a subquery can never return more than 1 value. This will get the same result: Select Employee Id, Department, Division , Address1, Address2, C...
285903 Jul 2014 @ 10:22 PDTDatabaseReplyHow to identify the most recent Oct 1st date or the Jan 1st based on the date condition given as a dymanic valueYou can calculate the most recent 01-Jan or 01-Oct like this: cast(case when yourdate >= date '2015-01-01' then (extract(year from yourdate) -1900) * 10...
285803 Jul 2014 @ 08:35 PDTDatabaseReplySum of totals with last location:You need a Windowed Aggregate Function: select customer, sum(charge_amt) -- total amout over (partition by customer), location from tab qualify row_number() -- latest row ...
285703 Jul 2014 @ 01:44 PDTGeneralReplyTeradata SQL to transpose columns to rowsThis has been answered multiple times... select id, date, d1 from tab where d1 is not null union all select id, date, d2 from tab where d2 is not null union all select id, date, ...
285602 Jul 2014 @ 11:06 PDTDatabaseReplyexecute immediate with sting in sql statement in teradataHi Frank, this is strange as it should work with linebreaks, too. In fact I prefer it over concatenating as the SQL code is more readable and you don't have to check for a leading or trailing ...
285502 Jul 2014 @ 02:14 PDTGeneralReply3707 error expecting something like')' between a string or a unicode charecter literal and ;There's a semicolon before the final ")", simply remove it
285402 Jul 2014 @ 02:48 PDTDatabaseReplyEnabling Permanent Journal FeatureThere's no DBS Control parameter for that. You can only set a default PJ on a database level.

Pages