2878 | 10 Jul 2014 @ 02:02 PDT | Database | Reply | Mapping Values from many to one relationship to a one to one relationship | Hi 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... |
2877 | 10 Jul 2014 @ 01:43 PDT | Connectivity | Reply | Regarding installation of teradata tool in a personnel computer | Hi 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... |
2876 | 10 Jul 2014 @ 12:27 PDT | Database | Reply | Creating a Total | Hi 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.
|
2875 | 10 Jul 2014 @ 12:21 PDT | Tools | Reply | Speed up imports in BTEQ or SQL Assistant | PACK 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... |
2874 | 10 Jul 2014 @ 12:11 PDT | Database | Reply | Constraints in Teradata | Hi 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)
|
2873 | 10 Jul 2014 @ 12:06 PDT | Database | Reply | SELECT failed 7453 : interval field overflow | There 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... |
2872 | 05 Jul 2014 @ 10:43 PDT | General | Reply | I 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
|
2871 | 05 Jul 2014 @ 10:41 PDT | General | Reply | x.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
|
2870 | 05 Jul 2014 @ 09:08 PDT | General | Reply | x.x.TDC.x.R.x in VMware Suse teradata | Teradata uses a modified SLES kernel, e.g. version 2.6.16.60 and this is Teradata's release number.
|
2869 | 05 Jul 2014 @ 09:04 PDT | Database | Reply | Need help to write Recursive Query with Unknown Depth level | If 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.
|
2868 | 05 Jul 2014 @ 08:59 PDT | Database | Reply | Failure due to Loader Slots Unavailability | You 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... |
2867 | 05 Jul 2014 @ 07:54 PDT | General | Reply | A sımple questıon | No, 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.
|
2866 | 05 Jul 2014 @ 05:44 PDT | General | Reply | A sımple questıon | Simply 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... |
2865 | 05 Jul 2014 @ 01:42 PDT | Database | Reply | Counts 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... |
2864 | 04 Jul 2014 @ 07:19 PDT | Database | Reply | how to select non 0 and numeric values from Varchar field | If 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,... |
2863 | 04 Jul 2014 @ 06:45 PDT | General | Reply | Timestamp with time zone | Hi 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... |
2862 | 04 Jul 2014 @ 05:06 PDT | Database | Reply | NOT 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... |
2861 | 04 Jul 2014 @ 12:27 PDT | General | Reply | Timestamp with time zone | Hi 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... |
2860 | 03 Jul 2014 @ 02:55 PDT | Database | Reply | Multiple select in Tearadata sub query | Hi 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... |
2859 | 03 Jul 2014 @ 10:22 PDT | Database | Reply | How to identify the most recent Oct 1st date or the Jan 1st based on the date condition given as a dymanic value | You 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... |
2858 | 03 Jul 2014 @ 08:35 PDT | Database | Reply | Sum 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
... |
2857 | 03 Jul 2014 @ 01:44 PDT | General | Reply | Teradata SQL to transpose columns to rows | This 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, ... |
2856 | 02 Jul 2014 @ 11:06 PDT | Database | Reply | execute immediate with sting in sql statement in teradata | Hi 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 ... |
2855 | 02 Jul 2014 @ 02:14 PDT | General | Reply | 3707 error expecting something like')' between a string or a unicode charecter literal and ; | There's a semicolon before the final ")", simply remove it
|
2854 | 02 Jul 2014 @ 02:48 PDT | Database | Reply | Enabling Permanent Journal Feature | There's no DBS Control parameter for that.
You can only set a default PJ on a database level.
|