| 57641 | 09 Jun 2016 @ 03:05 PDT | fgrimmer | Teradata Studio | Reply | Is there a way to modify Connection Properties of DB Connections through some external Windows config file? | 1) One option is to distribute an .xml file that contains the connection profile with the new server name in the profile definition and users would import it into their Studio or Studio Express. Du... |
| 57640 | 09 Jun 2016 @ 02:35 PDT | Fred | Database | Reply | Unable to release locks | Either re-run and complete the restore or drop the tables.
|
| 57639 | 09 Jun 2016 @ 02:24 PDT | Fred | Database | Reply | Seeing Junk character when inserting hyphen (-) | That combination of characters is the 3-byte UTF-8 representation of EN DASH U+2013, misinterpreted as Windows-1252.
In short, you are loading UTF-8 data using ASCII as the session character set. ... |
| 57638 | 09 Jun 2016 @ 01:53 PDT | Roopalini | Tools | Reply | TPT Wizard | It was an installatin issue. I uninstalled and resinstalled the TPT tool and that fixed it.
|
| 57637 | 09 Jun 2016 @ 12:49 PDT | itdude369 | Database | Topic | Seeing Junk character when inserting hyphen (-) | Hi,
I am trying to insert a string containing hyphen (-) into a column defined as CHARACTER SET LATIN. But when I select, I see some junk character instead of '-'. Pls let me know ... |
| 57636 | 09 Jun 2016 @ 11:51 PDT | feinholz | Tools | Reply | TPT attributes SkipRows and SkipRowsEveryFile | The DataConnector operator is able to read from multiple files at one time.
The nature of parallelism implies that order is not important.
If order is important, you cannot read multiple files in... |
| 57635 | 09 Jun 2016 @ 10:46 PDT | pks_nikunj | Database | Reply | How to declear Macro Variable? | I want to create a global variable date and simply pass that date in another tables. What code should be used to create such a variable? I havent got any examples where we can create such a variable
|
| 57634 | 09 Jun 2016 @ 10:25 PDT | tsalonia | Teradata Studio | Topic | Is there a way to modify Connection Properties of DB Connections through some external Windows config file? | We are in the process of migrating our systems to a new environment, with new server names, and, as such, need to modify all users' connection properties within Studio. Is there a way to ... |
| 57633 | 09 Jun 2016 @ 10:04 PDT | Roopalini | Tools | Topic | TPT Wizard | Forum -
I installed TPT wizard 15.00 version recently and any job that I try to run is giving me the below error.
Completed with unexpected status from tbuild (-1,073,741,515). Could ... |
| 57632 | 09 Jun 2016 @ 09:29 PDT | anurag2117 | Database | Reply | Date format automatically changed | Thank you so much.
It worked like charm :) |
| 57631 | 09 Jun 2016 @ 09:03 PDT | wer61537 | Connectivity | Reply | python / odbc connection to TD | Is Driver={Teradata} the correct name for the Teradata driver? I get "no default driver specified".
|
| 57630 | 09 Jun 2016 @ 07:36 PDT | alihammad | Database | Reply | Get database hierarchy to create similar directory structure on filesystem | @CarlosAL Thanks mate. Looks like that's exactly what I want. Let me decipher it as I'm not used to recursion.
Cheers
|
| 57629 | 09 Jun 2016 @ 06:51 PDT | JustMe | Database | Topic | Unable to release locks | We are using DSA as our Backup and Restore option.
Lately, we have had issues with the Restore portion on our DRT system.
We had a restore job that ran for several hours but seemed to make ... |
| 57628 | 09 Jun 2016 @ 06:39 PDT | sneha.g | Tools | Reply | TPT attributes SkipRows and SkipRowsEveryFile | Also, what is the default value of SkipRowsEveryFile?
|
| 57627 | 09 Jun 2016 @ 06:37 PDT | CarlosAL | Database | Reply | Get database hierarchy to create similar directory structure on filesystem | Hi.
WITH RECURSIVE JER (LEVEL, DATABASENAME, OWNERNAME, ROUTE)
AS
(
SELECT 1 LEVEL,
DATABASENAME,
OWNERNAME,
CAST('/'||TRIM(DATABASENAME) AS VARCHAR(128)) ROUT... |
| 57626 | 09 Jun 2016 @ 05:42 PDT | alihammad | Database | Topic | Get database hierarchy to create similar directory structure on filesystem | I'm struggling with a query to fetch entire database hierarchy and calculating path of each node from root. I need to create same directory structure on the file system whereby each directory r... |
| 57625 | 09 Jun 2016 @ 04:33 PDT | sneha.g | Tools | Topic | TPT attributes SkipRows and SkipRowsEveryFile | If TPT Attributes INTEGER SkipRows = 1 and Varchar SkipRowsEveryFile = 'N' (There are more than 1 file), how will the loader know, for which file the row is to be skipped? How wil... |
| 57624 | 09 Jun 2016 @ 04:31 PDT | priyankbansal | Database | Reply | When a new node is added in teradata then the how the remapping will take place? | Thanks Walter for answer...I think I need to read this concept (Hash Bucket) in deep to understand.
|
| 57623 | 09 Jun 2016 @ 02:36 PDT | rajezkumar11511 | Database | Reply | Find which logon id locked the user | Thank you.. Really helps much :)
|
| 57622 | 09 Jun 2016 @ 12:56 PDT | M.Saeed Khurram | Database | Reply | Teradata demo version 13.1 | Hi,
If you are looking for a free Teradata version for practice, you can download the VmWare edition from the below link:
http://downloads.teradata.com/download/database/teradata-express-for-vmwa... |
| 57621 | 09 Jun 2016 @ 12:11 PDT | Kishore_1 | Database | Topic | Stats Histogram Accuracy (USING MAXVALUELENGTH) |
How to identify which values contained in the histogram for statistics for column(s) that
are occupying more than 25 bytes, as per Teradata 14.10 .
Do I need to check the sum... |
| 57620 | 08 Jun 2016 @ 11:12 PDT | Johannes Vink | Database | Reply | Multi-level partition or differently partitioned JI? | Hi Dieter,
The reporting guys are complaining that it is "difficult" for them to present a year-week number in the report, and in the SQL select on the date... So changing the SQL from t... |
| 57619 | 08 Jun 2016 @ 10:52 PDT | Johannes Vink | Tools | Reply | What are the new features and major bug fixes in TTU 15.10? (in comparison with TTU15.00) | Hi upriser,
In TAYS the release notes are included.
Please don't forget to check the compatability list of TTU with the database and the tools that use TTU. I.e. Powercenter 9.6.1 is only cer... |
| 57618 | 08 Jun 2016 @ 10:32 PDT | niranjan_nr000 | General | Topic | Passing Parameters to Bteq in Mainframes | Hi,
I am working with maniframe / teradata ..
Consider 2 databases "A" and "B".. I need to load table existing in database A using tables present in database B.
I want ... |
| 57617 | 08 Jun 2016 @ 10:18 PDT | upriser7 | Tools | Topic | What are the new features and major bug fixes in TTU 15.10? (in comparison with TTU15.00) | We are planning to upgrade from TTU 15.00 to TTU 15.10 but before doing so , I wanted to know whether there any major bug fixes and any new features in TTU 15.10 release when compared to 15.00 rele... |
