|56898||05 May 2016 @ 01:26 PDT||rubenjdc||Database||Reply||Tips to convert data on TPT||Hi Carlos thanks for your help
I didnt use before vardate to insert data, i need a formatout clause
I was using this to insert my timestamp data on Apply zone:
:DATE(TIMESTAMP(0),FORMAT '... |
|56897||05 May 2016 @ 01:14 PDT||KhurramInayat||Database||Reply||Execution modes in teradata||Hi,
I have some functions with DBC.FunctionsV.ExecProtectionMode = 'S' and I can't find any information about this.
Does anyone know what 'S' represents in perspective of prot... |
|56896||05 May 2016 @ 12:40 PDT||CarlosAL||Database||Reply||Tips to convert data on TPT||Hi
You can do it easily using FORMATIN clause for VARDATE type in the schema definition.
FORMATIN ('DD/MM/YYYYbhh:mi') will accept the one digit hours.
|56895||05 May 2016 @ 12:37 PDT||CarlosAL||Database||Reply||EXECUTE PROCEDURE access ||Hi.
The INVOKER rights are rights related to the objects accessed by the Store Procedure code.
The EXECUTE PROCEDURE is the right to execute the procedure itself.
|56894||05 May 2016 @ 12:34 PDT||Dira||Database||Topic||How to identify Expired Partitions in Teradata v14.0||HI Folks,
We have requirement to identify Expired/About to expire Partitions [PPI] On Teradata V14.0 to prevent our batch jobs from failing.
So please help me out to figure out this issue.
|56893||04 May 2016 @ 08:54 PDT||Seitarin||General||Reply||Looking for help with regards to nested aggregates||Hmm just curious, why the need to insert the UNION ALL command? Having this command would stack the out_ and in_ data into a single table? Would it be easier if both datasets were separated into 2 ... |
|56892||04 May 2016 @ 08:20 PDT||Roopa singu||Database||Reply||Access Right Abbreviations||what does EX means?
|56891||04 May 2016 @ 03:27 PDT||gboundy||Teradata Studio||Reply||TDStudio stopped working after Java update||Thanks Francine, that worked amazingly well once I had a 64 bit version of the JRE.
|56890||04 May 2016 @ 01:57 PDT||dnoeth||Database||Reply||Secondary Index Concept||1) There's only one PI per table, but sometimes you want/need to index more than one column :)
2) All AMPs + FTS
|56889||04 May 2016 @ 01:55 PDT||dnoeth||General||Reply||Looking for help with regards to nested aggregates||So this is the base data, no pre-calculation, yet?
You need another Derived Table to combine the times for enter and exit:
SELECT B_DT, MAX(diff) AS maxdiff
|56888||04 May 2016 @ 12:22 PDT||suhailmemon84||Tools||Reply||TPT deadlock Issue.||Thank you so much for your inputs Steve. We will work on upgrading to the latest patch.
Just curious, can you advise on how the latest patch of TPT handles deadlocks better than the version we'... |
|56887||04 May 2016 @ 12:05 PDT||feinholz||Tools||Reply||TPT deadlock Issue.||Deadlocks cannot ever go away. If you have enough jobs running on the system, there are bound to be deadlocks.
The "fix" is that we will handle it better.
|56886||04 May 2016 @ 12:03 PDT||suhailmemon84||Tools||Reply||TPT deadlock Issue.||Hi Steve,
Once we upgrade to the latest patch of 15.00, do you think these deadlocks will go away?
|56885||04 May 2016 @ 11:55 PDT||dineshks||Teradata Applications||Topic||BTEQ - DELIMITER||How to give '10'xc (hexadecimal 10) as delimiter in BTEQ script.in Unix it should be represented as ^p ?
|56884||04 May 2016 @ 11:42 PDT||Ivyuan||Tools||Reply||Issues in Multiload, Insert and Update for Multiple tables||Hi,
Can you please provide the MultiLoad job output?
If possible, can you share with me your target table definiation and the MultiLoad script/data file?
|56883||04 May 2016 @ 11:42 PDT||au185006||Cloud Computing||Reply||Teradata VM Options - Community Edition||
It can be configured at the time of deployment in the deploy.properties File in the DBS configuration section
Total number of data disks and size of each data disk. Th... |
|56882||04 May 2016 @ 11:41 PDT||feinholz||Tools||Reply||Error while loading DATE column using TPT||The FastLoad protocol (which is used by the TPT Load operator) is very restrictive in the syntax of the INSERT statement.
The DBS is complaining about the CAST syntax.
It is not allowed.
|56881||04 May 2016 @ 11:37 PDT||feinholz||Tools||Reply||TPT deadlock Issue.||Please upgrade to the latest patch of 15.00, at least 15.00.00.08.
|56880||04 May 2016 @ 11:30 PDT||fgrimmer||Teradata Studio||Reply||Unable to launch Teradata Studio Express||John Carlo, Do you have a Teradata Database server called testServer? The error exception says unknown host: "java.net.UnknownHostException: testServer". If you don't have a Teradata ... |
|56879||04 May 2016 @ 10:58 PDT||charleshugo||Database||Topic||EXECUTE PROCEDURE access ||Hi,
1. I created a procedure in database dba
2. I set security of the stored procedure as "SQL SECURITY INVOKER"
3. user dbc is a memeber of role R_DBA
4. R_DBA holds execute procedur... |
|56878||04 May 2016 @ 10:42 PDT||EUsha||Tools||Topic||Error while loading DATE column using TPT||Hi,
I am new to TPT (Version 14.10.00.04). I have a csv file from which i am trying to load data using TPT. Data in csv file has date defined in 'DD/MM/YYYY' format. The table has a DATE c... |
|56877||04 May 2016 @ 10:17 PDT||suhailmemon84||Tools||Reply||TPT deadlock Issue.||At line#147 in the tpt log I posted above, it does say it is retrying the request after receiving the initial deadlock error.
Does it retry only once?
Is there any setting (in DBS?) to specify ho... |
|56876||04 May 2016 @ 09:29 PDT||fgrimmer||Teradata Studio||Reply||0 CAST AS DECIMAL(22,7) showing as 0E-7 in Result Set||@EB180000, The data is displayed as it is returned from the database. If you enable the 1000's separator preference for the Result Set Viewer, it will format the result and display 0.0000000. W... |
|56875||04 May 2016 @ 09:12 PDT||fgrimmer||Teradata Studio||Reply||TDStudio stopped working after Java update||Graham, You need to install the 64-bit JRE.
|56874||04 May 2016 @ 09:04 PDT||lgscheurich||Database||Reply||Performance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insert||After working with Wherescape, we discovered the problem was in the priocedure. The first step inserts one row, and then it runs an insert of close to 500 million rows. It looks lik e l... |