#DateForumTypeThreadPost
2905 Aug 2016 @ 02:07 PDTDatabaseTopicUNABLE TO CONNECT TERADATA STORED PROCEDURE FROM TABLEAUI would need to pass value in the form of a Tableau Parameter to a Teradata Stored Procedure. On doing this I am getting an error "The stored procedure "[DATABASE].[PROCEDURE_NAME]" ...
2825 Feb 2016 @ 02:20 PSTGeneralReply.COMPILE throws error 7947 in spite of having only one Replace Procedure Statement in BTEQTHanks Fred. Finally, I sorted out the issue. The SQL file that I was using was saved using notepad. While saving it was encoded as UTF. I just changed the encoding to ANSI saved it again and tried...
2725 Jan 2016 @ 12:53 PSTGeneralTopic.COMPILE throws error 7947 in spite of having only one Replace Procedure Statement in BTEQI have a 430 Lines of Stored procedure in a SQL file. When i compile it using .COMPILE FILE <Filename> command in BTEQ, i get ERROR 7947:Only create/replace procedure allowed. My file co...
2614 May 2015 @ 06:54 PDTDatabaseTopicJAVA BASED SCHEDULER FOR TERADATA SCRIPTSHi All            I would like to use a Open source Java scheduler using which i can schedule Teradata BTEQ, Fast export scripts etc. and create d...
2513 Feb 2015 @ 04:15 PSTGeneralTopicDECLARING VARIABLES INSIDE A STORED PROCEDURE LOOPHi    Is there a way by which we can declare variables in a loop dynamically. I would like to create a vaiables like Var1,Var2,Var3....as and when a new loop begins. If the loop executed...
2429 Jan 2015 @ 05:31 PSTGeneralTopicSCHEDULING Teradata SQL QUERIESHi     How can i schedule Teradata SQL queries. I need to run particular set of queries at a scheduled time. I am not allowed to use Teradata Query Scheduler. Apart from t...
2330 Oct 2014 @ 06:29 PDTGeneralTopicCOLLECT STATS ACCESS Hi      When i try to execute the below statement inside a Stored Procedure as below i get an error as stated: CALL DBC.SYSEXECSQL ('COLLECT STATISTICS ON DBNAME.Table_Na...
2228 Oct 2014 @ 08:10 PDTDatabaseTopicCURRENT PERM AND PEAK PERM IN DBC.TABLESIZEHi    When i use a proper index in the user defined table, i see values in the same range in CURRENT PERM column where as PEAK PERM is 0 for all vProc in TABLESIZE as shown in the b...
2128 Oct 2014 @ 07:14 PDTToolsReplyCode = 2644 No more room in databaseHere, Wasted time space will be released or permanently occupied?
2028 Oct 2014 @ 03:41 PDTDatabaseReplyAVG() FUNCTION RETURNING DIFFERENT VALUES FOR SAME INPUTThanks. The data type of base column is DECIMAL(38,8) and the resulting data type is also same.
1928 Oct 2014 @ 12:55 PDTDatabaseTopicAVG() FUNCTION RETURNING DIFFERENT VALUES FOR SAME INPUTHI    I am using the average function to find the average of column having many rows. Each time i execute the query i get different result sets. The change is very small in precision. Ex...
1803 Oct 2014 @ 05:56 PDTGeneralTopicSubstracting two TIME(6) datatype valuesHI     I have two columns Start_Time and End_Date in a table with data type TIME(6) and i want to substract the two values in a stored Procedure.   Format:HTML Format Version...
1730 Sep 2014 @ 10:33 PDTGeneralReplyAPPENDING A DYNAMIC VALUE ON A TABLE IN INSERT STATEMENT IN STORED PROCEDUREHi     Thanks for the reply. But when i am able to append the dynamic value without DBC.SYSEXECSQL in Operation 1 as above why is it not possible to achieve the same in Operation 2....
1630 Sep 2014 @ 07:52 PDTGeneralTopicAPPENDING A DYNAMIC VALUE ON A TABLE IN INSERT STATEMENT IN STORED PROCEDUREREPLACE Sample_Proc (   PRODUCT_NAME VARCHAR(20)   ) BEGIN DECLARE vVar1 INTEGER; /*OPERATION1*/ SET vVar1= 'VARIABLE'||PRODUCT_NAME /*OPERATION 2*/ INSERT INTO LOG_Tabl...
1522 Sep 2014 @ 03:04 PDTGeneralTopicQUERY INVALID ERRORFormat:HTML Format Version:1.0 StartHTML: 165 EndHTML: 710 StartFragment: 314 EndFragment: 678 StartSelection: 314 EndSelection: 314 /***query1 */ SELECT CURRENT_DATE ; HI    whil...
1418 Sep 2014 @ 06:53 PDTGeneralTopicHandling SQL Exceptions using SQLCODE rather than SQLSTATEHi    We know, SQL exceptions can be handled using CONTINUE handlers based on the SQLSTATE. But can we handle the exceptions based on SQLCODE(errorCodes). I see SQLSTATE is common f...
1318 Sep 2014 @ 05:32 PDTGeneralTopicCAPTURING ERRORS IN STORED PROCEDUREFormat:HTML Format Version:1.0 StartHTML: 165 EndHTML: 13031 StartFragment: 314 EndFragment: 12999 StartSelection: 314 EndSelection: 314 REPLACE PROCEDURE DBNAME.PROC( IN PROD_NAME VARCHAR(50...
1218 Sep 2014 @ 02:31 PDTGeneralReplyWhat is the purpose of using DBC.SYSEXECSQL?IF we have only SQL Queries to be executed for which i have to pass values dynamically, can it be done with using DBC.SYSEXECSQL? Does usign this have any performance edge or bottleneck?
1118 Sep 2014 @ 02:24 PDTGeneralReplyTeradata Procedure IssueHI Mithun By default only the creator has access to procedure. However the user can give access to other user (username) or PUBLIC which will give the access to everyone. GRANT EXECUTE PROCEDUR...
1015 Sep 2014 @ 11:56 PDTGeneralTopicWhat is the purpose of using DBC.SYSEXECSQL?Hi      What is the point in using DBC.SYSEXECSQL('<SQL Query>') when we can execute SQL queries with out using it in STORED PROCEDURE. Does using SYSEXECSQL...
915 Sep 2014 @ 11:47 PDTGeneralReplyUSING DDMMYYYY INSIDE DBC.SYSEXECSQL() in Stored ProcedureThanks a lot Dieter.. It solved the issue.
815 Sep 2014 @ 11:45 PDTGeneralReplyEXECUTING PROCEDURE BY a USER OTHER THAN THE CREATORPerfect!! THanks a lot...
715 Sep 2014 @ 06:36 PDTDatabaseReplyExecute access for Procedure?How to grant this permission to all users? PLease help.
615 Sep 2014 @ 06:36 PDTGeneralReplyEXECUTING PROCEDURE BY a USER OTHER THAN THE CREATORYes Raja, I am able to GRANT permission to a particular user. IS there any option where i can grant the permission to ALL? Please help.
515 Sep 2014 @ 06:22 PDTGeneralReplyEXECUTING PROCEDURE BY a USER OTHER THAN THE CREATORThanks a lot Raja. But can a normal user grant this permission or this can be given only by the ADMIN? Please clarify.

Pages