|58732||25 Jul 2016 @ 09:11 PDT||mm185159||Tools||Reply||TPT 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.
|58731||25 Jul 2016 @ 08:31 PDT||mc200018||Teradata Database on VMWare||Reply||"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 ... |
|58730||25 Jul 2016 @ 06:46 PDT||zakyw||Analytics||Reply||QUERY 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 ... |
|58729||25 Jul 2016 @ 05:46 PDT||branko.p||Aster||Reply||Aster database/schema/table space management||Hi 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.
|58728||25 Jul 2016 @ 03:10 PDT||txrob74||General||Topic||How to search multiple columns for specific text||Hello, 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 ... |
|58727||25 Jul 2016 @ 02:46 PDT||raka||Database||Topic||CASE statement vs UDF||Hi,
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... |
|58726||25 Jul 2016 @ 02:16 PDT||ZackHowe||Database||Reply||UDF Default Database||I 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 ... |
|58725||25 Jul 2016 @ 02:13 PDT||feinholz||Tools||Reply||Ctrl-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... |
|58724||25 Jul 2016 @ 12:32 PDT||tranlm||Database||Topic||partition by a superset of multiple columns||Hi 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... |
|58723||25 Jul 2016 @ 11:27 PDT||srivigneshkn||Tools||Topic||Ctrl-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,
|58722||25 Jul 2016 @ 10:27 PDT||Fred||Tools||Reply||Upload files .dat in Teradata ||They are separate batch-oriented client utilities, unrelated to SQL Assistant.
|58721||25 Jul 2016 @ 10:16 PDT||Navic||Database||Reply||Data migration between 2 different Boxes||Thanks Carlos,
Teradata Versions are smillar, but Number of AMP's are not same.
|58720||25 Jul 2016 @ 09:46 PDT||tjmunson||Connectivity||Reply||Connectivity issues for SQL Assistant 15||For 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.&... |
|58719||25 Jul 2016 @ 09:24 PDT||Valeria||Tools||Reply||Upload 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... |
|58718||25 Jul 2016 @ 09:06 PDT||CarlosAL||Database||Reply||Data migration between 2 different Boxes||Hi.
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 ... |
|58717||25 Jul 2016 @ 08:43 PDT||CarlosAL||Database||Reply||Merge into operation||Hi.
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... |
|58716||25 Jul 2016 @ 07:10 PDT||M.Saeed Khurram||Database||Reply||Fastload||It 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.
|58715||25 Jul 2016 @ 06:51 PDT||abhishank18||Database||Reply||Fastload||But 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... |
|58714||25 Jul 2016 @ 06:37 PDT||M.Saeed Khurram||Database||Reply||Fastload||These 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... |
|58713||25 Jul 2016 @ 06:27 PDT||M.Saeed Khurram||Database||Reply||Merge into operation||Merge 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... |
|58712||25 Jul 2016 @ 06:20 PDT||abhishank18||Database||Reply||Fastload||But 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 ?
|58711||25 Jul 2016 @ 06:14 PDT||M.Saeed Khurram||Database||Reply||Fastload||You 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:
|58710||25 Jul 2016 @ 06:08 PDT||abhishank18||Database||Reply||Fastload||So there is no way using which we can directly see the entries made in the error tables ?
|58709||25 Jul 2016 @ 06:02 PDT||M.Saeed Khurram||Database||Reply||Fastload||The 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... |
|58708||25 Jul 2016 @ 05:57 PDT||M.Saeed Khurram||Database||Reply||Help needed for understanding of space default behavior and limitations or rules||Q1- 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... |