#DateForumTypeThreadPost
910 Oct 2014 @ 10:06 PDTGeneralReplyusing a calculation done in the previous row in this row's calculationThanks raja..Its pefect :) :)
809 Oct 2014 @ 04:02 PDTGeneralReplyusing a calculation done in the previous row in this row's calculation Hi Dieter,   I am trying to calculate the count of difference for the current and previous week like below.     YEAR    MONTH  WEEK   COUNT...
705 Jun 2014 @ 08:15 PDTDatabaseReplyStoring result set as a variable in a procedure Can you help me to store the list of column name in a variable (as tablename will be parameterized) and use it later in Stored procedure in the insert and select statement? Is it ...
603 Jun 2014 @ 08:47 PDTDatabaseReplyCursors in stored proceduresHi,   I need to parameterize the table name and get the all the column list from dbc table and use it for insert. Is it that possible without using dynamic SQL? Because we cant use select in...
528 May 2014 @ 03:19 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseMy core dump issue got resolved. I am using DataDirect 7.0 Oracle Wire Protocol driver and my OS is "SunOS 5.10 Generic_141444-09 sun4v sparc SUNW,SPARC-Enterprise-T5220". When I execute the script...
420 May 2014 @ 03:32 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseCorrect. If you look at the below TPT script, it has only DSNName, Username and Password. Still I am facing issue due to ODBC setup has not done properly. So I am trying to use ConnectString to byp...
319 May 2014 @ 03:54 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseHi Fienholz, The above values are just for sample . But in the script I have mentioned the valid Connect string/User Name and pwd. Also SelectStmt  contains proper SQL  li...
215 May 2014 @ 03:52 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseHi Feinholz,   I am trying to load data from Oracle to Teradata using ODBC operator but its failing with the below error.   If the below format is wrong. Can you please give me the sa...
118 Apr 2014 @ 12:53 PDTUDAReplyETL CLOB from Oracle to TeradataCan anyone tell me how to load CLOB/BLOB data from Oracle to Teradata table using TPT? I am able to load CLOB data when I declare it as VARCHAR in teradata but it fails If I declare it CLOB or...