#DateForumTypeThreadPost
824 Jan 2012 @ 11:28 PSTDatabaseTopicCalling External Stored Procedure from EXIT Handler Problem statement:   We want to set custom SQLSTATE in Teradata stored procedures. The only way to set custom SQLSTATE value is through external stored procedure.   To ...
706 Jan 2012 @ 03:46 PSTDatabaseReplyCreation of External Stored Procedure using JAVA; NoSuchMethodException Solution: SQL definition for External Stored Procedure was wrong. I needed to include the parameters for procedure ext_p.GetWebData() The correct syntax is: DATABASE EXT_P; REPLACE P...
606 Jan 2012 @ 02:57 PSTDatabaseReplyCreation of External Stored Procedure using JAVA; NoSuchMethodException Sorry, jar file creation statement is: jar -cf web.jar Region.class
506 Jan 2012 @ 02:55 PSTDatabaseTopicCreation of External Stored Procedure using JAVA; NoSuchMethodException Dear All, I am trying to create an external stored procedure using JAVA but keept getting NoSuchMethodException. I am using windows 7 to compile and create the JAR file (client) My t...
428 Dec 2011 @ 09:45 PSTDatabaseTopicSession CHARACTER SET and Variable CHARACTER SET difference Hi, If the session character set used is ASCII and a variable in a stored procedure is assigned a UNICODE caharacter set, how will the code behave?   Thanks  
328 Dec 2011 @ 09:39 PSTDatabaseTopicLength of Variable in Stored Procedure using DEFAULT Hi,   I wanted to ask how the 'DEFAULT' keyword affects the length of variable declared in stored procedue. Here is a sample code:   REPLACE PROCEDURE database.s...
215 Dec 2011 @ 02:14 PSTDatabaseReplyTeradata Stored Procedures & User Defined Exceptions Hi Andrew,   I am facing the same problem you mentioned above. Were you able to sort the issue out? If yes, please help.   Thanks, Umar
116 Nov 2011 @ 11:18 PSTConnectivityReplyTeradata JDBC Exception Any solution found for this problem? Or maybe the reason it happens for?   Thanks