58442 | 14 Jul 2016 @ 08:51 PDT | venkata_k01 | Database | Topic | How to calculate minimum & maximum values based on a column only if the records are continuous | Hi,
I have data as below
col1 col2 begindate enddate
A 100 '2016-01-01' '2016-02-18'
A 100 '2016-03-01' '2016-04-07'
A 101 &... |
58441 | 14 Jul 2016 @ 08:29 PDT | dnoeth | Database | Reply | how to make Stored Procedure with dynamic SQL to display the records? | You forgot to add WITH RETURN ONLY to the cursor definition:
DECLARE cur1 CURSOR WITH RETURN ONLY FOR S1;
|
58440 | 14 Jul 2016 @ 07:55 PDT | Arpan.Roy | Tools | Reply | Need Help regarding TPT ODBC Operator |
Hi Steve,
Using TPT ODBC Operator and DATA CONNECTOR Operator we are trying to fetch data from Oracle table. But the performance is not that much exciting it seems. In the existin... |
58439 | 14 Jul 2016 @ 07:52 PDT | dnoeth | Database | Reply | date variable not parsing proerly in Stored Procedure | This is the resulting string:
SELECT '2016-02-01' AS max_avail_date,
'create multiset volatile table ttt as (select '||cast(max_avail_date as date format 'yyyy-mm-dd')... |
58438 | 14 Jul 2016 @ 07:29 PDT | HanC | Database | Topic | date variable not parsing proerly in Stored Procedure | Hi, can anyone please help? I'm expecting to get the same date '2016-02-01' displaying with below code, instead I got number 2013. so, it's doing the math: 2013 = 2016-2-1
By ... |
58437 | 14 Jul 2016 @ 07:14 PDT | HanC | Database | Topic | how to make Stored Procedure with dynamic SQL to display the records? |
Can anyone please help? Below code can finish running with no error, but how to make it to display the records, just so I know I'm getting what I want. Thanks!
replace PROCEDU... |
58436 | 14 Jul 2016 @ 07:07 PDT | M.Saeed Khurram | Database | Reply | Advice on ELT process please | Hi,
If you already have SQL scripts prepared, the best & quick way is to use BTEQ scripts. You can simply embed the existing SQL scripts in BTEQ, use BTEQ Conditional logic & error handlin... |
58435 | 14 Jul 2016 @ 06:42 PDT | Kbos | Teradata Studio | Reply | Unable to connect to the database using Teradata Studio Express. | Hi,
The way how it worked for me:
1. Run your VM.
2. Click on Computer (look at the low corner left)
3. Click on Network Wired
4. Choose Traditional Method with ifup
5. Verify the opt... |
58434 | 14 Jul 2016 @ 06:17 PDT | ToddAWalter | Database | Reply | Avoid all-row scan in driving table using NUSI | It is not ever possible to test NUSI usage on small data. If the data is only a block or two on each AMP, it is always cheaper to read the data blocks directly than to read the index structure... |
58433 | 14 Jul 2016 @ 05:16 PDT | Pinky_Jain | General | Topic | Converting Time stamp in UTC including Day light Saving | Hi All,
Please can anybody help me out with below query.
We are receving timestamp values from our server which is located in UK right now.We need to convert all the timestamp values in U... |
58432 | 14 Jul 2016 @ 04:40 PDT | venkata_k01 | Tools | Reply | Teradata tpt | Hi,
I am giving the below select statement in job variable file but eventhough there are around 2K records present in the source table, when i am doing the data copy from source to target table us... |
58431 | 14 Jul 2016 @ 02:23 PDT | indra91 | Tools | Topic | Teradata Tool and Utilities package for Linux | I wanted to install Teradata Tool and Utilities for Red-Hat Linux from the teradata site https://downloads.teradata.com
Although I could find the binary for Teradata Tools and Utilites-Windo... |
58430 | 14 Jul 2016 @ 02:13 PDT | M.Saeed Khurram | Tools | Reply | Teradata SQL Assistnat 15.10.1.4: Tab colors | Thank you for sharing the workaround.
|
58429 | 14 Jul 2016 @ 02:02 PDT | M.Saeed Khurram | Database | Reply | NOT IN and nested query | Try this:
Sel distinct col1
from table1
where col1 NOT IN
(Sel col11 from table11 where col11 is not null group by 1);
|
58428 | 14 Jul 2016 @ 01:58 PDT | M.Saeed Khurram | Database | Reply | Need to generate a row number like column |
SELECT
LOCATION,
ORDER_ID,
CLASS,
DATE,
ROW_NUMBER() OVER (PARTITION BY LOCATION, ORDER_ID ORDER BY DATE) AS RANK
FROM
TABLE_NAME
|
58427 | 14 Jul 2016 @ 01:55 PDT | M.Saeed Khurram | Database | Reply | ALTER_PPI | Hi Katei,
Just create a new table with new partition layout, and do insert select into new table. It will not take much time.
Khurram
|
58426 | 14 Jul 2016 @ 01:52 PDT | M.Saeed Khurram | Database | Reply | Avoid all-row scan in driving table using NUSI | Hi,
To use NUSI, the indexed column should be used in WHERE condistion.
Since you have placed no restrcition on any of the tables, it will obviously go for full table scan.
Khurram
|
58425 | 14 Jul 2016 @ 01:31 PDT | venkata_k01 | Tools | Reply | TPT deadlock Issue. |
Hi All,
I am also facing deadlock issue when i am trying to load the target table using tdload. The target table is a temporary table created by the script before running tdload. So, there won... |
58424 | 14 Jul 2016 @ 01:25 PDT | RonaldBrayan | Database | Reply | ALTER_PPI | No, you are trying to modify the PPI of a populated table. Rows are already distributed in this case and you can not redistribute.
|
58423 | 14 Jul 2016 @ 01:19 PDT | RonaldBrayan | Database | Reply | Avoid all-row scan in driving table using NUSI | Its the Optimizer to choose the best cost effective plan. However, there are maultiple conditions underwhich SI will not be used. You may need to read more of USI/NUSI selection criteria.
|
58422 | 14 Jul 2016 @ 01:18 PDT | sharonn | Connectivity | Reply | Can not connect from host to TDE 14 40G - IP address is not set. | I found out was actually using TDE 15 40G, so i downloaded the 14 40G and everything is OK.
but i still cant connect using 15 40G.
any idea?
thanks...
|
58421 | 14 Jul 2016 @ 01:12 PDT | RonaldBrayan | Database | Reply | Regarding Teradata Migration | Kaushik,
From your post I understand that, you are migrating from 15.00 to 15.10(the versions for source and target Tearadata is close), then it would be a minor upgrade. It may be a patch u... |
58420 | 14 Jul 2016 @ 12:37 PDT | yuvaevergreen | Database | Reply | Need to generate a row number like column | Can you post the expected result?
|
58419 | 14 Jul 2016 @ 12:15 PDT | CarlosAL | Database | Reply | NOT IN and nested query | Hi.
If you get NULLs from table11.col11 the NOT IN will not work.
You can try NOT EXISTS instead or filter the NULLs in the subquery.
BTW: the DISTINCT is irrelevant for the subquery.
HTH.
Che... |
58418 | 14 Jul 2016 @ 12:03 PDT | Martijn | Tools | Reply | Fastload - Error on piom GET ROW: 64 | Hi,
Thanks for the quick response!
The version of the Teradata Data Connector is 15.00.00.01. I will get the latest version and retry. Thanks!
|