All forum activity

#DateUserForumTypeThreadPost
5849215 Jul 2016 @ 11:32 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPT 2016-07-13 09:44:16 Connecting to Teradata Database Teradata Load Utility Version 15.10.00.03 64-Bit Teradata Parallel Transporter Version 15.10.00.03 64-Bit Job log: /opt/teradata/client/15.1...
5849115 Jul 2016 @ 09:55 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTThank you for providing the TPT version information! Have you tried the exact same query using BTEQ to see if there is a result set? I am assuming from the information you provided that the job d...
5849015 Jul 2016 @ 09:49 PDTfeinholzToolsReplyTPT Export vs Fast ExportWell, not exactly. Yes, TPT is the product that everyone should be using going forward. We are not adding any features to FastExport, and that utility will also most likely not support new DBS fe...
5848915 Jul 2016 @ 09:01 PDTmhusseyAsterReplyAster Visualization SpacingIs there a way to sort the order of the boxes in a Sankey diagram? As of now, I can tell it is just using an ascending alphabetical sorting on the first letter of the nPath results. It would be rea...
5848815 Jul 2016 @ 08:39 PDTJohannes VinkToolsReplyTPT Export vs Fast ExportThey are the same except Fast Export is legacy and TPT is the future.
5848715 Jul 2016 @ 08:38 PDTJohannes VinkDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS ( SELECT * FROM UDWETLSANDBOX.ADJD_MCE_TST ) WITH NO DATA WITH PRIMARY INDEX (FIELD1, FIELD2);   This should work
5848615 Jul 2016 @ 08:36 PDTvenkata_k01ToolsTopicZero records are fetching when using where statement in TPTHi,  I am giving the below select statement in job variable file but eventhough there are around 2K records present in the source table, when i am doing the data copy from source to target t...
5848515 Jul 2016 @ 08:30 PDTvenkata_k01DatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table I changed the above create statement as above but its not working. Small correction to the above post
5848415 Jul 2016 @ 08:28 PDTvenkata_k01DatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table CREATE TABLE UDWETLWORK_D5.MBR_COV_TST_tmp AS ( SELECT * FROM UDWETLSANDBOX.ADJD_MCE_TST ) WITH NO DATA WITH PRIMARY INDEX; Yes i am also feeling the same to maintain PI from the source tabl...
5848315 Jul 2016 @ 07:17 PDTHanCDatabaseReplydate variable not parsing proerly in Stored ProcedureThank you Dieter! It's working like a charm.
5848215 Jul 2016 @ 07:17 PDTVandeBergBDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableyou'll need to add the on commit preserve rows if you want your data to stick around, and depending upon the number of rows in the volatile table, you may have introduced some significant spool...
5848115 Jul 2016 @ 07:01 PDTmhusseyAsterReplyAster Visualization SpacingThanks Khurram! I was looking for settings for vertical spacing in the logic section of building the app and had failed to see the settings gear in the top left. I have it resolved now.
5848015 Jul 2016 @ 06:26 PDTvenkata_k01DatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tablethank you very much Khurram. Its working.
5847915 Jul 2016 @ 05:53 PDTM.Saeed KhurramDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source table CREATE VOLATILE TABLE TABLE_NAME AS ( SELECT * FROM EXISTING_TABLE ) WITH NO DATA NO PRIMARY INDEX;  
5847815 Jul 2016 @ 05:36 PDTvenkata_k01DatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableHi Khurram, I am trying to create temporary table without using DDL of the source table.In the above statement, I think i need to mention complete DDL.   Thanks, Hanu
5847715 Jul 2016 @ 05:21 PDTM.Saeed KhurramDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableHi, You can create a NOPI Global temporary or volatile table in your script. Create Volatile Table TableName (......) NO PRIMARY INDEX Khurram
5847615 Jul 2016 @ 05:05 PDTM.Saeed KhurramToolsReplyEncryted Password File for FastExportHere is an example you can follow: https://forums.teradata.com/forum/tools/teradata-wallet-0   Khurram
5847515 Jul 2016 @ 04:38 PDTvenkata_k01DatabaseTopicHow to CREATE TABLE(copy) without any index and parititions present on source tableHi, I am working on one automation process and in the middle of the process  i need to create a temporary table with same column structure as source table but any index or partitions dec...
5847415 Jul 2016 @ 04:29 PDTvenkata_k01DatabaseReplyhow to make Stored Procedure with dynamic SQL to display the records?Hi Dieter,  I have data in one of the table as below  col1 col2   begindate     enddate  A     100  '2016-01-01'...
5847315 Jul 2016 @ 03:18 PDTindra91ToolsTopicTPT Export vs Fast ExportI need to ingest huge volume of data from Teradata systems to flat files in Unix System.I would to know if TPT would provide better performance over Fast Export utility and also whether TPT Export ...
5847215 Jul 2016 @ 03:17 PDTPinky_JainGeneralReplyConverting Time stamp in UTC including Day light SavingWe have not yet generated the query since we are not able to convert the UK BST time in UTC?
5847115 Jul 2016 @ 03:12 PDTindra91ToolsReplyEncryted Password File for FastExportBut if I use Teradata Wallet will it be possible to call it from the FastExport Script?I mean in Fast Export we provide in username and password in the .LOGON command as .LOGON IP/USERNM,PASSWORD. ...
5847015 Jul 2016 @ 02:43 PDTM.Saeed KhurramAsterReplyAster Visualization SpacingHi, Apparently, it seems to be an issue of your broswer as the visualiation is working fine in IE. You can also try the same in FireFox. Otherwise, in visuliation settings you will look for the p...
5846915 Jul 2016 @ 02:33 PDTM.Saeed KhurramToolsReplyEncryted Password File for FastExportYou can use teradata Wallet if it is available. It stores encrypted password, and you will not write the password directly in script. Khurram
5846815 Jul 2016 @ 02:26 PDTM.Saeed KhurramAnalyticsReplyCoverting Char to DateBonjour, Ceci est déjà répondu à https://forums.teradata.com/forum/enterprise/to-check-is-a-string-is-numeric-or-not Khurram  

Pages