#DateForumTypeThreadPost
49412 Jul 2016 @ 12:41 PDTToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsHi, 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...
49312 Jul 2016 @ 12:27 PDTDatabaseReplyStoring History DAta into tablesHi, 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...
49212 Jul 2016 @ 12:24 PDTDatabaseReplyTD 14 - Data Storage QuestionsHi 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.
49112 Jul 2016 @ 12:20 PDTDatabaseReplyFaster way to delete and rebuild a tableHi, Even if you skip all the steps and do only step 7, the result will be same.
49011 Jul 2016 @ 12:29 PDTAsterReplyAutomating grants in AsterHi, You can use executables option in AMC, build your script and schedule it as per your requirement. Br, Khurram
48911 Jul 2016 @ 12:23 PDTAsterReplyLoading JSON to ASTERHi, Have you tried AFS connecter?  
48804 Jul 2016 @ 11:51 PDTGeneralReplyUpdate statment is getting failedThank you Dieter. It is an addition to my knowledge as well :)
48704 Jul 2016 @ 11:00 PDTGeneralReplyUpdate statment is getting failedHi,   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...
48630 Jun 2016 @ 03:50 PDTExtensibilityReplyurgent : xml conversionHi, 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...
48530 Jun 2016 @ 03:35 PDTToolsReply2554 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
48429 Jun 2016 @ 04:08 PDTExtensibilityReplyurgent : xml conversionHi, 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...
48328 Jun 2016 @ 11:03 PDTToolsReplyLook up in TPTNO. 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  ...
48228 Jun 2016 @ 10:20 PDTDatabaseReplyTransaction control in BTEQ scriptIs there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?
48128 Jun 2016 @ 10:17 PDTAsterReplyusing Teradata Stored Procedures to pull data into AsterOne 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.  
48028 Jun 2016 @ 01:10 PDTAsterReplyusing Teradata Stored Procedures to pull data into AsterHi, 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...
47928 Jun 2016 @ 01:08 PDTGeneralReplysteps to install td-ttu-15.10.05_for_WindowsHi 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
47826 Jun 2016 @ 12:58 PDTGeneralReplysteps to install td-ttu-15.10.05_for_WindowsHi, 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...
47726 Jun 2016 @ 12:35 PDTAsterReplyINSERT undocumented syntaxHi, This is already documented in the Aster_Database_User_Guide. You can either use Values or query. Br, Khurram
47622 Jun 2016 @ 11:40 PDTAsterReplyHow 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
47522 Jun 2016 @ 01:24 PDTToolsReplyTPT 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...
47416 Jun 2016 @ 03:50 PDTDatabaseReplyFastload not picking decimal valueHi, 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...
47316 Jun 2016 @ 03:21 PDTToolsReplyDownloading Previous versions of Teradata StudioHi, 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...
47215 Jun 2016 @ 01:57 PDTGeneralReplyto remove duplicatesWorkaround: 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
47115 Jun 2016 @ 01:34 PDTAsterReplyFailed to start cluster activationHi, 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...
47013 Jun 2016 @ 04:25 PDTDatabaseReplyCurrent date as column name in select queryHi, 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

Pages