All forum activity

#DateUserForumTypeThreadPost
5786618 Jun 2016 @ 04:53 PDTklaementToolsReplyNeed Help regarding TPT ODBC OperatorHi, I work now with a Teradata client which would like to use the ODBC_operator in a TPT on AIX to connect to Oracle Base. This client uses TD14.10 version of the base and has TD14.10 versio...
5786517 Jun 2016 @ 02:43 PDTdnoethDatabaseReplyInteger to date conversionNo, PasswordDate seems to be the number of days since a start date and this start date is 307 days before Teradata's minimum date 0001-01-01.  You could also use an adjusted state date li...
5786417 Jun 2016 @ 02:29 PDTdnoethDatabaseReplyDegraded Query performance while performing insertionFirst you should check the actual runtime/resource usage for each step using QryLogStepsV. The UPI on call_hist cannot be used for the join, what are the demographics for accs_meth_id, i...
5786317 Jun 2016 @ 12:37 PDTdejo316DatabaseReplyDegraded Query performance while performing insertionYour table is defined as a SET table, has a UPI defined on it. Maybe it is doing a full row dupe check for each insert? Can you try creating a copy of this table as a MULTISET table and do the inse...
5786217 Jun 2016 @ 12:21 PDTToddAWalterDatabaseReplyRecursive Query Vs UNIONNot sure what "roll it up" means since the result doesn't obviously include an aggregate of any of the columns. The previous answer is the beginning but becomes a subquery: SELECT t1...
5786117 Jun 2016 @ 12:13 PDTNiteshMDatabaseReplyRecursive Query Vs UNIONHi Tod, Actually i want to exclude all those values from colum a where values in column D is less than 0 and then roll it up at week level based on my second table which us B the final data set s...
5786017 Jun 2016 @ 12:05 PDTToddAWalterDatabaseReplyRecursive Query Vs UNIONIm not totally clear on wht you want but I think it is a list of unique table1.a values where any of the table1.d values is less than zero...   SELECT a FROM table1 GROUP BY a...
5785917 Jun 2016 @ 11:58 PDTteradatauser2DatabaseReplyInteger to date conversionHi Dieter, Thanks, this converts the interger date to DATE. What are the figures, 0001-01-01 amd 307 ? Do i need to change it according to my environment ? --samir
5785817 Jun 2016 @ 10:36 PDTzszmigieroAsterReplyHow to get info from system tables using pyodbc?The ODBC driver provides possibility to use SQL without cursor and works ok in this case, but pyodbc and Teradata JDBC driver base on cursors only what leads to meaningful limitations of these acce...
5785717 Jun 2016 @ 10:11 PDTfeinholzToolsReplyUsage of GetRow method in TPT API for exporting table data into csvTPTAPI does not write out to a file. That is up to your application. Thus, if your file is empty, you will have to debug your application.   The data that will be provided from a call to Ge...
5785617 Jun 2016 @ 10:11 PDTzszmigieroAsterReplyHow to get info from system tables using pyodbc?This same problem with jdbc driver - SELECT  is internally conversed to cursor and access to system tables is forbidden. Does it mean that ASTER do not provide programatic interface to manage ...
5785517 Jun 2016 @ 09:59 PDTfeinholzToolsReplyTDCH-TPT InterfaceTPT is a client application and we have no control over AMP CPU usage. I would not be able to help there.  
5785417 Jun 2016 @ 09:43 PDTh.r.thejas@gmail.comToolsReplyTDCH-TPT InterfaceThe main goal is to reduce AMP CPU Seconds while exporting the data, if you can point me to some performace tuning parameters of TPT that would be great help for me.
5785317 Jun 2016 @ 09:27 PDTfeinholzToolsReplyTDCH-TPT InterfaceI am glad you were able to get the HDFS method working. As to which method to use, that would be up to you. We do not run performance comparison tests. The method that performs the best for you ...
5785217 Jun 2016 @ 09:20 PDTzszmigieroAsterTopicHow to get info from system tables using pyodbc?I tried to get data from nc_all_users using pyodbc where only cursors are available for tetch data. Unfortunatelly AsterDB returned error: ('HY000', '[HY000] [AsterData][nCluster] (34)...
5785117 Jun 2016 @ 09:10 PDTNiteshMDatabaseTopicRecursive Query Vs UNIONHi Experts, I have below tables  Column A Column B Column C Column D 123 001 1/1/2016 60 123 002 1/1/2016 -10 126 003 1/1/2016 -10 124...
5785017 Jun 2016 @ 07:53 PDTdnoethDatabaseReplyError handling from DBC.SysExecSQL in my own procedureThis should work (at least with the SQLEXCEPTION hadnler), can you show the actual source code? Of course it will only drop the db, but not re-create it.   If you want to drop the database ...
5784917 Jun 2016 @ 07:20 PDThferro@gmail.comDatabaseReply'arcmain' utility for Archiving and BackupDieter, thank you so much for the clarification! I will try to find the resource I am looking for (arcmain) in the installation media you mentioned and post the results here. Again, thank you for ...
5784817 Jun 2016 @ 06:56 PDTrododendronToolsReplyProblems with multibyte tdload / TPT19134 !ERROR! UTF-8 (hex) 0xF0 0x9F 0x91 0x8D (f09f918d) UTF-8 (binary) 11110000:10011111:10010001:10001101 It was the character above, also called "thumbs up". Just google for "unicode char...
5784717 Jun 2016 @ 06:54 PDTsk8s3iDatabaseReplyTransposing Rows to ColumnsThank you Dieter! This query is really helpful.
5784617 Jun 2016 @ 06:36 PDTarchana_2016ToolsTopicUsage of GetRow method in TPT API for exporting table data into csvHi By using Getrow method to export data into a file, resulted in no data in the csv file even though ther is data in the table. Is there any issue in the format that has to be mentioned while ex...
5784517 Jun 2016 @ 03:14 PDTh.r.thejas@gmail.comToolsReplyTDCH-TPT InterfaceHey I was able to make TPT-HDFS Api work there was some issue with my classpath, but i somehow feel tpt-tdch interface is  much faster when compared with TPT-HDFS becuase parllelism will be be...
5784417 Jun 2016 @ 01:52 PDTaklopisDatabaseReplyError handling from DBC.SysExecSQL in my own procedureI've also tried using  DECLARE EXIT HANDLER FOR SQLSTATE 'T5612' or DECLARE EXIT HANDLER FOR SQLEXCEPTION But it doesn't work.
5784317 Jun 2016 @ 01:46 PDTaklopisDatabaseTopicError handling from DBC.SysExecSQL in my own procedureHi! I've got issue with error handling in my procedure Here's some of my code: DECLARE EXIT HANDLER FOR SQLSTATE '52004' BEGIN drop database TDADMIN_MV_SPC END; SET L_SQL_...
5784217 Jun 2016 @ 12:48 PDTisaac0007DatabaseReplypassing parameter to mload script and loading into target tablelooks like you have used val4 in the insert statement instead of var4 in the script.

Pages