58467 | 15 Jul 2016 @ 12:40 PDT | AtardecerR0j0 | Database | Reply | Viewing Generated Dynamic SQL Query | You can use DYNAMIC RESULT SETS .
Then you have to create a cursor using then string variable where you storage the dynamic sql statement, for instance:
DECLARE cursor_1 CURSOR WITH RETURN... |
58466 | 14 Jul 2016 @ 11:47 PDT | drmkd17 | Database | Topic | Teradata DBA documents | Hi People,
I need some Teradata DBA docuemnts that would gear me up for a Teradata DBA Role. Can anybody help me out here.
Thansk,
Katie
|
58465 | 14 Jul 2016 @ 07:12 PDT | sallad | Database | Reply | TD 14 - Data Storage Questions | Thanks Khurram, I have done the introduction to Teradata 1 day training course and the 4 day basic SQL course, but it was a while ago and I hadn't used SQL / Teradata for a few months so I forg... |
58464 | 14 Jul 2016 @ 02:52 PDT | premkishore83 | Third Party Software | Topic | 'enabled' column | Hi All,
We are in the process of moving from Greenplum to Teradata, When i try to insert into one of the teradata tables, I'm getting the following error,
Error:
RDBMS code 3... |
58463 | 14 Jul 2016 @ 02:48 PDT | mhussey | Aster | Reply | Aster Visualization Spacing | The image upload isn't working, so here is a link to the example picture. Because of sensitive data, I cropped it, but the verticle amount of information is all that I can see on my browser, wi... |
58462 | 14 Jul 2016 @ 02:44 PDT | mhussey | Aster | Topic | Aster Visualization Spacing | I've started building some visualizations in Teradata App Center using Aster, and I'm running into an issue. The viz type I'm using in this example is a Sankey diagram. The visualizatio... |
58461 | 14 Jul 2016 @ 01:58 PDT | beargiles | Tools | Reply | Error creating .genuine_TTU file on Ubuntu system | I may have found it.
1. Create /opt/teradata/client/ttu_bash.env file and add one line: NLSPATH=/opt/teradata/client/15.10/lib
2. install and run bteq
I don't know if the key was the .env fi... |
58460 | 14 Jul 2016 @ 01:16 PDT | teradatatester | Database | Topic | Median function - Fails on view when trying to cast as decimal | I have a database table which has four columns and two of the columns are INT. The two INT columns' rows are sometimes empty.
When I try to cast them as DECIMAL(18,3) and then use the Median f... |
58459 | 14 Jul 2016 @ 12:55 PDT | feinholz | Tools | Reply | TPT deadlock Issue. | I see that you are using the Inserter operator.
Are you using multiple instances?
Multiple sessions?
In order to cut down on the deadlocks on the target table, you will need to restrict your Ins... |
58458 | 14 Jul 2016 @ 12:12 PDT | feinholz | Tools | Reply | Teradata Tool and Utilities package for Linux | FastExport is not a free utility.
It requires a license (part of the Basic or Enterprise license for TTU).
|
58457 | 14 Jul 2016 @ 12:09 PDT | beargiles | Tools | Topic | Error creating .genuine_TTU file on Ubuntu system | I'm trying to install the (Redhat) RPM files on my Ubuntu system. I tried using 'alien' to convert the .rpm to .deb files but, inexplicably, it refuses to convert a i386 package on a x6... |
58456 | 14 Jul 2016 @ 11:57 PDT | feinholz | Tools | Reply | Encryted Password File for FastExport | Check out the .RUN FILE command in the documentation.
You cannot encrypt the contents, but you can restrict its usage through access rights settings.
DataEncryption is for the data going across t... |
58455 | 14 Jul 2016 @ 11:33 PDT | indra91 | Tools | Reply | Teradata Tool and Utilities package for Linux | I am new to Teradata and unaware whether FastExport utility is among the drivers available for free download from Teradata site or would need to be obtained via Teradata or from your Tera... |
58454 | 14 Jul 2016 @ 11:27 PDT | venkata_k01 | Tools | Reply | Teradata tpt |
$EXPORT: TPT10508: RDBMS error 3706: Syntax error: expected something between the 'DATE' keyword and the integer '2016'.
Hi Fred,
Format is YYYY-MM-DD.
I tried by puting the ... |
58453 | 14 Jul 2016 @ 11:14 PDT | indra91 | Tools | Topic | Encryted Password File for FastExport | I wanted to know if there is a way to store the .logon username/Password in a separate File and include it while calling the Fastexport script.Also is there any option to encrypt the password... |
58452 | 14 Jul 2016 @ 11:02 PDT | indra91 | Tools | Reply | Teradata Tool and Utilities package for Linux | Thanks a lot for the info.But the drivers available for download on the does'nt include the Fastexport utility so I need to obtain it from Teradata.Is this understanding correct?
|
58451 | 14 Jul 2016 @ 10:30 PDT | HanC | Database | Reply | how to make Stored Procedure with dynamic SQL to display the records? | thanks a lot Dieter!!!
|
58450 | 14 Jul 2016 @ 10:26 PDT | kamKAM | Analytics | Reply | Coverting Char to Date |
BONJOUR
SVP, DE L'AIDE
JE CHERECHE COMMENT UN CHAMP SI TOUT SES CARACTeRS SE TROUVENT DANS UNE LISTE DE VALEURS!
PAR EXEMPLE: LA LISTE DE VALEUR EST '0987654321... |
58449 | 14 Jul 2016 @ 10:10 PDT | Fred | Tools | Reply | Teradata Tool and Utilities package for Linux | The drivers and Teradata Studio downloads for Linux are on that site. But the full TPT suite for Linux would need to be obtained via Teradata @ Your Service or from your Teradata representativ... |
58448 | 14 Jul 2016 @ 09:39 PDT | AROLD001 | Database | Reply | NOT IN and nested query | Thanks that clears the air!
|
58447 | 14 Jul 2016 @ 09:36 PDT | Fred | Tools | Reply | Teradata tpt | What is data type / format for ROW_EFF_DT (for implicit data type conversion)? If it is a DATE column, better to explicitly use DATE constant - keyword DATE in front of opening (double) single quot... |
58446 | 14 Jul 2016 @ 09:23 PDT | Hart3945 | Database | Topic | Viewing Generated Dynamic SQL Query | We recently converted many of our static stored procedures to dynamic sql to reduce the amount of duplicated code. Does Teradata have a function or process that would allow the users to view ... |
58445 | 14 Jul 2016 @ 09:14 PDT | Hustler | Database | Reply | Formatting CURRENT_TIMESTAMP | how to find different timezone from one time zone?
|
58444 | 14 Jul 2016 @ 09:00 PDT | suhailmemon84 | Tools | Reply | TPT deadlock Issue. | Thanks Johannes. We are in the process of familiarizing ourselves with the new features of 15.10. You're right. The PI changes could help. Hopefully the deadlocks reduce a bit after the upgrade... |
58443 | 14 Jul 2016 @ 08:59 PDT | david.craig | General | Reply | Converting Time stamp in UTC including Day light Saving | The query is not attached. In any case, it sounds like Teradata support needs to assist in the timezone rules configuation settings in DBSControl, tdlocaledef and the gettimezonedisplacement UDF.
... |