#DateForumTypeThreadPost
2423 Aug 2016 @ 06:23 PDTToolsReplyZero records are fetching when using where statement in TPTHi Steve, PFB the details. Code in the script where select statement is being assigned. $parms{SelectStmt}="SELECT * FROM ${srcdb}.${srctblnm} WHERE STATUS=''A&...
2320 Aug 2016 @ 04:01 PDTToolsReplyZero records are fetching when using where statement in TPTHi Steve,   We tried many ways by putting select statement in the script but still no luck. It would be very helpful if you could please provide one simple sample example.   Thanks &...
2226 Jul 2016 @ 01:27 PDTDatabaseTopicHow to get column data type and formatI am working on one automation process where data will be fetched from a table based on qualifying key passed as parameter. That qualifying key can be of type date/timestamp. I need to handle all f...
2125 Jul 2016 @ 04:27 PDTDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousThank you very much Carlos. Its working :) Thank you Shardful for elaborating my requirement.
2021 Jul 2016 @ 03:55 PDTToolsReplyZero records are fetching when using where statement in TPTCurrently also I am creating job variable file in perl script and then in the same script calling the tdload. Still issue exists. It would be very helpful if you could please elaborate/give me sam...
1920 Jul 2016 @ 01:42 PDTToolsReplyZero records are fetching when using where statement in TPTAny way to make sure single-quotes present in the SELECT statement that is sent to Teradata and overcome this issue?   Thanks, Hanu
1819 Jul 2016 @ 11:18 PDTToolsReplyZero records are fetching when using where statement in TPTHi Steve,   I am facing issue while uploading complete .out file. Please let me know if the above information is enough for furthur analysis before my attempt to upload the file is successf...
1719 Jul 2016 @ 10:38 PDTToolsReplyZero records are fetching when using where statement in TPTHi Steve, PFB the select statement from the .out file. Single quote before & after the date value is missing and that is why it is fetching 0 records. k   ==========...
1618 Jul 2016 @ 09:19 PDTToolsReplyZero records are fetching when using where statement in TPTGetting the below error when ExportSelectStmt variable is used in the job variable file. Teradata Load Utility Version 15.10.00.03 64-Bit TDLOAD: TPT05528: Error: No data source is not specified...
1516 Jul 2016 @ 01:54 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tableyes Khurram.Noticed the same while creating the table. Thank you.
1416 Jul 2016 @ 01:52 PDTDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi Carlos,   I am not familiar with PERIOD & NORMALIZE clause, Could you please elaborate and give sample query.   Thanks, Hanu
1316 Jul 2016 @ 01:49 PDTToolsReplyZero records are fetching when using where statement in TPTHi Steve, I ran the same select query using bteq and it fetched 126332 records as expected. SELECT * FROM UDWBASEVIEW1.MBR WHERE SRC_ROW_EFF_DT >='2016-07-10' AND SRC_ROW_EFF_D...
1215 Jul 2016 @ 11:32 PDTToolsReplyZero 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...
1115 Jul 2016 @ 08:36 PDTToolsTopicZero 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...
1015 Jul 2016 @ 08:30 PDTDatabaseReplyHow 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
915 Jul 2016 @ 08:28 PDTDatabaseReplyHow 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...
815 Jul 2016 @ 06:26 PDTDatabaseReplyHow to CREATE TABLE(copy) without any index and parititions present on source tablethank you very much Khurram. Its working.
715 Jul 2016 @ 05:36 PDTDatabaseReplyHow 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
615 Jul 2016 @ 04:38 PDTDatabaseTopicHow 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...
515 Jul 2016 @ 04:29 PDTDatabaseReplyhow 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'...
414 Jul 2016 @ 11:27 PDTToolsReplyTeradata 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 ...
314 Jul 2016 @ 08:51 PDTDatabaseTopicHow to calculate minimum & maximum values based on a column only if the records are continuousHi, I have data as below col1 col2 begindate enddate A  100  '2016-01-01' '2016-02-18' A   100 '2016-03-01' '2016-04-07' A   101 &...
214 Jul 2016 @ 04:40 PDTToolsReplyTeradata 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 table us...
114 Jul 2016 @ 01:31 PDTToolsReplyTPT deadlock Issue. Hi All, I am also facing deadlock issue when i am trying to load the target table using tdload. The target table is a temporary table created by the script before running tdload. So, there won&#...