#DateForumTypeThreadPost
1707 Jan 2013 @ 07:54 PSTDatabaseReplyTeradata Lock in Insert StatementHi Dieter,        Is it possible to Lock a particular Table for Complete Session?   Thanks and Regards, Prabhu
1618 Dec 2012 @ 05:02 PSTDatabaseReplySkew Factor of Input and Output Tables of a QueryHope only the skewfactor of target tables needs to be considered, bcoz it is where the data distribution is going to happen.  cardinality of the source data for target table primary index...
1517 Dec 2012 @ 07:07 PSTDatabaseReplyHow to lock set of tables used by Particular Session (Session Level Integrity)Is it possible to lock the tables used in the session with below statements for reading and writing and maintain integrity at session level?   LOCK Table table1 for WRITE; LOCK Table&n...
1428 Nov 2012 @ 01:55 PSTDatabaseReplyHow to lock set of tables used by Particular Session (Session Level Integrity)Thanks a lot Harpreet and Jim
1327 Nov 2012 @ 04:47 PSTDatabaseTopicHow to lock set of tables used by Particular Session (Session Level Integrity)Hi,            I have a bteq script, which insert and update data in 5 table (table1,table2,table3,table4,table5) and same bteq is called by diffe...
1212 Sep 2012 @ 09:36 PDTGeneralTopicPI Hash Value Generation for Same Value and Different Data Type Hi,       I have a general question, For the Same Value but with different data type, How the Hash value will be generated? Same or Different?   For EG:...
1110 Sep 2012 @ 02:52 PDTDatabaseTopicReplace Function Hi,           Need Help on Replace Function   Senario: There is column with Value:  Text1 , Text2 , Text3; ...
1010 Sep 2012 @ 02:36 PDTDatabaseReply2616: Numeric overflow occurred During computation Hi Juan,           This error will occur in Numerical data types(BYTEINT,SMALLINT,INT,BIGINT,DECIMAL(T,D)), So please check you numeric data...
915 Jul 2012 @ 09:32 PDTDatabaseReplyInsert statement in stored procedure Thanks a lot WAQ and QAKiani
812 Jul 2012 @ 08:07 PDTDatabaseTopicInsert statement in stored procedure Hi,       Is is possible to use below insert statement in teradata   Insert (col1,col2,col3) select :Variable1 as col1, table1.column1 as co...
712 Jul 2012 @ 08:03 PDTGeneralTopicDeclaring Variable in Teradata Stored procedure Is it possible to declare variable in the following way in Teradata SP   SET Variable_name = select column_detail from table where some condition   Here the select will...
611 Jul 2012 @ 09:24 PDTGeneralReplyCast in teradata userdefined function Hi,   Teradata version:12 UDF using C      For EG, the senario is like for 3 values(a,b,c) will be peforming some calculation and the end output d (...
511 Jul 2012 @ 09:19 PDTDatabaseReplySQL user defined function in Teradata Thanks a lot Dieter, Please help me with the post http://forums.teradata.com/forum/general/how-to-execute-macro-and-stored-procedure-in-xml   Thanks Prabhu
411 Jul 2012 @ 04:55 PDTDatabaseReplySQL user defined function in Teradata Hi Dieter,   Teradata Version: 12        Oracle function is taking the input value (parm1 and parm2) and returning 3 values a,b,c ...
311 Jul 2012 @ 03:12 PDTDatabaseTopicSQL user defined function in Teradata Hi,          Am having a oracle sql with oracle UDF function in it.. the udl function is getting input value and performing some manipulation based on...
211 Jul 2012 @ 03:03 PDTGeneralTopicHow to execute macro and stored procedure in XML How to execute teradata macro and stored procedure in XML?   Please let me know if the below statement are correct in terms of macro and SP execution inside XML <Query&g...
110 Jul 2012 @ 08:31 PDTGeneralTopicCast in teradata userdefined function How to do casting in Userdefined function?