All forum activity

#DateUserForumTypeThreadPost
5873225 Jul 2016 @ 09:11 PDTmm185159ToolsReplyTPT 15.10 ODBC Operator : Bundled DataDirect Drivers !Yah, well, it sucks becasue you have to purchase a DataDirect license in order to use the 64-bit drivers.
5873125 Jul 2016 @ 08:31 PDTmc200018Teradata Database on VMWareReply"How to download TTU for fixing the bteq issue on mac"This problem can be happen when uncompatible TTU components co-exist on client laptop. Even if TeraGSS client package version 15.10.01 or higher is installed on a client, BTEQ version 15.10.00 ...
5873025 Jul 2016 @ 06:46 PDTzakywAnalyticsReplyQUERY IN ASTER Hi saeed  thanks for answer , before, what is the difference of create table by me with create table by you  ?  and do you have example query with the function LIKE in Aster saeed ...
5872925 Jul 2016 @ 05:46 PDTbranko.pAsterReplyAster database/schema/table space managementHi Saeed,  You mentioned it can be managed using options in AMC, where exactly in AMC do you do this as I've looked and cannot seem to find it. 
5872825 Jul 2016 @ 03:10 PDTtxrob74GeneralTopicHow to search multiple columns for specific textHello,  I have a table with multiple columns that display similar information and am trying to query multiple columns for a specific value.  for example the columns ID1, ID2 ID3 id1 ...
5872725 Jul 2016 @ 02:46 PDTrakaDatabaseTopicCASE statement vs UDFHi, I'm a java developer and new to TD and looking for some input/advice. We have a query where we are using "CASE". After rough profilling found this "CASE" part is takin...
5872625 Jul 2016 @ 02:16 PDTZackHoweDatabaseReplyUDF Default DatabaseI am looking for the exact same thing.  We have a library of functions that we want to be able to use without having to qualify them.  I was hoping there was a way to add my own database ...
5872525 Jul 2016 @ 02:13 PDTfeinholzToolsReplyCtrl-A delimiter with TPT Export.There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex. Set that to '0A' and the DC operator should write out that character as the field...
5872425 Jul 2016 @ 12:32 PDTtranlmDatabaseTopicpartition by a superset of multiple columnsHi guys,   Hoping a knowledgeable pro can help me with a problem I'm stuck on. I have a table with multiple columns for different values, with an example given bel...
5872325 Jul 2016 @ 11:27 PDTsrivigneshknToolsTopicCtrl-A delimiter with TPT Export.Hi,  I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script. Thanks & Regards, Srivignesh KN
5872225 Jul 2016 @ 10:27 PDTFredToolsReplyUpload files .dat in Teradata They are separate batch-oriented client utilities, unrelated to SQL Assistant.
5872125 Jul 2016 @ 10:16 PDTNavicDatabaseReplyData migration between 2 different BoxesThanks Carlos, Teradata Versions are smillar, but Number of AMP's are not same.
5872025 Jul 2016 @ 09:46 PDTtjmunsonConnectivityReplyConnectivity issues for SQL Assistant 15For whats its worth, I had the same issue when installing 15.10 and had uninstalled TTU 14 before the 15 install.  After reading this entry, I removed the 15.10 TTU and installed TTU 14.&...
5871925 Jul 2016 @ 09:24 PDTValeriaToolsReplyUpload files .dat in Teradata Hello Fred, a question concerning this topic. Teradata Parallel Transporter, BTEQ, FastLoad, MultiLoad are programs thatI have to download to be used with SQL Assistant or are kind of SQLs that al...
5871825 Jul 2016 @ 09:06 PDTCarlosALDatabaseReplyData migration between 2 different BoxesHi. arcmain dump + arcmain restore / copy should work, but you must take care of things such as if the systems are same version, number of AMPs, etc... You should review the documentation before ...
5871725 Jul 2016 @ 08:43 PDTCarlosALDatabaseReplyMerge into operationHi. Teradata MERGE INTO DOES NOT require a primary key. It requires that the target  table PRIMARY INDEX columns (and partitioning columns if PPI) are present in the match condition (equality...
5871625 Jul 2016 @ 07:10 PDTM.Saeed KhurramDatabaseReplyFastloadIt is the target table that gets locked, error tables are available to analyse the issues. Can you share the falstload job logs to understand the issue properly.  
5871525 Jul 2016 @ 06:51 PDTabhishank18DatabaseReplyFastloadBut again fastload script can only run if there is no issue in the data and if that is resolved error tables are dropped. For instance, if data has a UPI voilation then this row will go into the er...
5871425 Jul 2016 @ 06:37 PDTM.Saeed KhurramDatabaseReplyFastloadThese error tables are dropped by default if there are no error records in these error tables.  The tables are retained only when the there are rows in error tables. Duplicate records are si...
5871325 Jul 2016 @ 06:27 PDTM.Saeed KhurramDatabaseReplyMerge into operationMerge Statement requires Primary Key in its condition regardless of Index. If it is not possible to define a primary key for the table, you can not use merge syntax. you can try Upsert syntax ins...
5871225 Jul 2016 @ 06:20 PDTabhishank18DatabaseReplyFastloadBut after resolving the issue in the script or in the data , once the script runs fine these error tables will be dropped. So when can we actually utilize these error tables ?
5871125 Jul 2016 @ 06:14 PDTM.Saeed KhurramDatabaseReplyFastloadYou can see the entries in error tables, but right now you have issue in your script, that's why error tables are not accessible. You can use these queries to see the data in error tables: se...
5871025 Jul 2016 @ 06:08 PDTabhishank18DatabaseReplyFastloadSo there is no way using which we can directly see the entries made in the error tables ?
5870925 Jul 2016 @ 06:02 PDTM.Saeed KhurramDatabaseReplyFastloadThe load is paused when there is some issue in the script. Error tables only capture the issues in data. To rectify the issue, go through the Fastload script log. You can create the loag file as f...
5870825 Jul 2016 @ 05:57 PDTM.Saeed KhurramDatabaseReplyHelp needed for understanding of space default behavior and limitations or rulesQ1- If you do not specify spool and temp space, it will inherit the spool and temp space of parent that is A1 so the spool and temp space for A11 will be: Spool = 100 GB Temp = 100 GB Q2- This w...

Pages