494 | 12 Jul 2016 @ 12:41 PDT | Tools | Reply | Teradata SQL Assistnat 15.10.1.4: Tab colors | Hi,
This is not an issue. The color settings are for code editor and not for tabs. so when you execute a query select statement the color of the running query changes to pink and once done, the co... |
493 | 12 Jul 2016 @ 12:27 PDT | Database | Reply | Storing History DAta into tables | Hi,
The table is already partitioned so performance should not be an issue.
Can you please paste the DDL so that the table structure can be understood?
Also, Have you considered the stats collec... |
492 | 12 Jul 2016 @ 12:24 PDT | Database | Reply | TD 14 - Data Storage Questions | Hi sallad,
If you are new to Teradata, I would suggest to read Teradata SQL Bascis guide. It will help you to answer all these and many more questions.
|
491 | 12 Jul 2016 @ 12:20 PDT | Database | Reply | Faster way to delete and rebuild a table | Hi,
Even if you skip all the steps and do only step 7, the result will be same.
|
490 | 11 Jul 2016 @ 12:29 PDT | Aster | Reply | Automating grants in Aster | Hi,
You can use executables option in AMC, build your script and schedule it as per your requirement.
Br,
Khurram
|
489 | 11 Jul 2016 @ 12:23 PDT | Aster | Reply | Loading JSON to ASTER | Hi,
Have you tried AFS connecter?
|
488 | 04 Jul 2016 @ 11:51 PDT | General | Reply | Update statment is getting failed | Thank you Dieter. It is an addition to my knowledge as well :)
|
487 | 04 Jul 2016 @ 11:00 PDT | General | Reply | Update statment is getting failed | Hi,
It is very clear message, SAMPLE is not allowed in subquries. remove this sample caluse:
UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04' WHERE EFF_END_DT = '9999-12-31... |
486 | 30 Jun 2016 @ 03:50 PDT | Extensibility | Reply | urgent : xml conversion | Hi,
This issue has been resolved. The issue ocurred due to a tag in annotatedschema definition.
There is a tag <defaultDatabase>Databasename</defaultDatabase>.
Update this tag w... |
485 | 30 Jun 2016 @ 03:35 PDT | Tools | Reply | 2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD- | Hi,
Do the following:
execute the following statment:
release mload tablename;
delete the log table. and restart the job.
Br,
Khurram
|
484 | 29 Jun 2016 @ 04:08 PDT | Extensibility | Reply | urgent : xml conversion | Hi,
This is a very strange issue. I tried to multiple solutions but this problem is something need to be reported to CS. I was able to get only the folowing information from TD docs.
7504 in U... |
483 | 28 Jun 2016 @ 11:03 PDT | Tools | Reply | Look up in TPT | NO. As you will be using two separate operators: FileReader to read the file and export to select data from table.
Why dont you load the file in step-1 into a temp table, and use that table ... |
482 | 28 Jun 2016 @ 10:20 PDT | Database | Reply | Transaction control in BTEQ script | Is there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?
|
481 | 28 Jun 2016 @ 10:17 PDT | Aster | Reply | using Teradata Stored Procedures to pull data into Aster | One possible option is to execute the procedure on Teradata and store the results in a table, then use that table as source in load_from_teradata MR function.
|
480 | 28 Jun 2016 @ 01:10 PDT | Aster | Reply | using Teradata Stored Procedures to pull data into Aster | Hi,
load_from_Teradata is an MR function that can only be called inside a SELECT statement. But you can call this select query inside Procedure and use the resultset in your procedure.
Please let... |
479 | 28 Jun 2016 @ 01:08 PDT | General | Reply | steps to install td-ttu-15.10.05_for_Windows | Hi Michael,
Which CPU do you have? Teradata VM is supported on almost all of the CPUs.
If you are trying to learn Teradata on your own, VM-Ware is the only option.
Br,
Khurram
|
478 | 26 Jun 2016 @ 12:58 PDT | General | Reply | steps to install td-ttu-15.10.05_for_Windows | Hi,
Installation of TTU on windows is very straight forward. Just click on TTU_Base.exe and follow the step on screen. No special configuration required. It will install all the basic utilite... |
477 | 26 Jun 2016 @ 12:35 PDT | Aster | Reply | INSERT undocumented syntax | Hi,
This is already documented in the Aster_Database_User_Guide.
You can either use Values or query.
Br,
Khurram
|
476 | 22 Jun 2016 @ 11:40 PDT | Aster | Reply | How to list all seqeunces? | Hi,
One possible way is to list down all the columns with serial data type from nc_all_columns.
Br,
Khurram
|
475 | 22 Jun 2016 @ 01:24 PDT | Tools | Reply | TPT Work/error Tables always protected (FALLBACK) ? | Hi,
I think you need to contact Customer Support, there is a global paramter for tables to be fallback or not fallback. But you will have to consider lot of things before disabling this option.
B... |
474 | 16 Jun 2016 @ 03:50 PDT | Database | Reply | Fastload not picking decimal value | Hi,
In fact when you load a Decimal value to VARCHAR, it is truncated after the decimal point.
Can you try with DECIMAL datatype in staging, e.g. DECIMAL(18,2). It will fix the issue.
Br,
Khurr... |
473 | 16 Jun 2016 @ 03:21 PDT | Tools | Reply | Downloading Previous versions of Teradata Studio | Hi,
You must an account on Teradata Tays, from there you can get ay version of Teradata utilities.
If you are on a customer site, then you can ask the customer to provide Tays account.
Br,
Khur... |
472 | 15 Jun 2016 @ 01:57 PDT | General | Reply | to remove duplicates | Workaround:
Create a new table with same structure:
INSERT INTO NEWTABLE
SELECT * FROM OLDTABLE
QUALIFY ROW_NUMBER() OVER(PARTITION BY OBJECTTABLENAME ORDER BY OBJECTTYPE) = 1;
Br,
Khurram
|
471 | 15 Jun 2016 @ 01:34 PDT | Aster | Reply | Failed to start cluster activation | Hi,
When you login to AMC, can you see the Worker node in Prepared state? If so, only then you can activate the cluster.
Otherwise, I would suggest to note donw the IP of worker, remove the worke... |
470 | 13 Jun 2016 @ 04:25 PDT | Database | Reply | Current date as column name in select query | Hi,
This is standard in teradata to eclose key words in double qoutes if you want to use them as Alias. I have tested and it works fine on SQLA.
Which query tool are you using?
Br,
Khurram
|