All forum activity

#DateUserForumTypeThreadPost
5689805 May 2016 @ 01:26 PDTrubenjdcDatabaseReplyTips to convert data on TPTHi 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 '...
5689705 May 2016 @ 01:14 PDTKhurramInayatDatabaseReplyExecution modes in teradataHi, 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...
5689605 May 2016 @ 12:40 PDTCarlosALDatabaseReplyTips to convert data on TPTHi 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. HTH. Cheers. Carlos.
5689505 May 2016 @ 12:37 PDTCarlosALDatabaseReplyEXECUTE 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. HTH. Cheers. Carlos.
5689405 May 2016 @ 12:34 PDTDiraDatabaseTopicHow to identify Expired Partitions in Teradata v14.0HI 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.  ...
5689304 May 2016 @ 08:54 PDTSeitarinGeneralReplyLooking for help with regards to nested aggregatesHmm 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 ...
5689204 May 2016 @ 08:20 PDTRoopa singuDatabaseReplyAccess Right Abbreviationswhat does EX means?
5689104 May 2016 @ 03:27 PDTgboundyTeradata StudioReplyTDStudio stopped working after Java updateThanks Francine, that worked amazingly well once I had a 64 bit version of the JRE.   
5689004 May 2016 @ 01:57 PDTdnoethDatabaseReplySecondary Index Concept1) There's only one PI per table, but sometimes you want/need to index more than one column :) 2) All AMPs + FTS
5688904 May 2016 @ 01:55 PDTdnoethGeneralReplyLooking for help with regards to nested aggregatesSo this is the base data, no pre-calculation, yet? You need another Derived Table to combine the times for enter and exit: SELECT AVG(maxdiff) FROM ( SELECT B_DT, MAX(diff) AS maxdiff ...
5688804 May 2016 @ 12:22 PDTsuhailmemon84ToolsReplyTPT 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'...
5688704 May 2016 @ 12:05 PDTfeinholzToolsReplyTPT 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.  
5688604 May 2016 @ 12:03 PDTsuhailmemon84ToolsReplyTPT deadlock Issue.Hi Steve, Once we upgrade to the latest patch of 15.00, do you think these deadlocks will go away? -Suhail
5688504 May 2016 @ 11:55 PDTdineshksTeradata ApplicationsTopicBTEQ - DELIMITERHow to give  '10'xc (hexadecimal 10) as delimiter in BTEQ script.in Unix it should be represented as ^p ?    
5688404 May 2016 @ 11:42 PDTIvyuanToolsReplyIssues in Multiload, Insert and Update for Multiple tablesHi, 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? Thanks!
5688304 May 2016 @ 11:42 PDTau185006Cloud ComputingReplyTeradata 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...
5688204 May 2016 @ 11:41 PDTfeinholzToolsReplyError while loading DATE column using TPTThe 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.   ...
5688104 May 2016 @ 11:37 PDTfeinholzToolsReplyTPT deadlock Issue.Please upgrade to the latest patch of 15.00, at least 15.00.00.08.
5688004 May 2016 @ 11:30 PDTfgrimmerTeradata StudioReplyUnable to launch Teradata Studio ExpressJohn 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 ...
5687904 May 2016 @ 10:58 PDTcharleshugoDatabaseTopicEXECUTE 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...
5687804 May 2016 @ 10:42 PDTEUshaToolsTopicError while loading DATE column using TPTHi, 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...
5687704 May 2016 @ 10:17 PDTsuhailmemon84ToolsReplyTPT 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...
5687604 May 2016 @ 09:29 PDTfgrimmerTeradata StudioReply0 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...
5687504 May 2016 @ 09:12 PDTfgrimmerTeradata StudioReplyTDStudio stopped working after Java updateGraham, You need to install the 64-bit JRE.
5687404 May 2016 @ 09:04 PDTlgscheurichDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertAfter 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...

Pages