#DateForumTypeThreadPost
1907 Nov 2008 @ 11:39 PSTDatabaseReplyself learning -teradataHi,if you are looking for software, you can order cd (free) or download Teradata Express Edition 12.0 for windows from:http://www.teradata.com/expressIt's a free developer version and comes with Us...
1807 Nov 2008 @ 11:31 PSTDatabaseTopicReset identity column counterHi, one of our table column is defined as:INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647NO CYCLE)The table is loaded full-refresh, be...
1707 Nov 2008 @ 10:04 PSTDatabaseReplydifference between version V2R6 and V2R12Hi, the link in the first post doesn't work, here's how to get to the release notes.You can also check for 1098.pdf in your documentation folder.http://www.info.teradata.com/Click General Search. I...
1603 Nov 2008 @ 09:34 PSTDatabaseReplyT7658 errorYeah, 1) is a valid error, when calling from another stored procedure, it has to be a host variable to store the out resultfor 2) it works ok on TD12 express edition on my windows XP.However the sa...
1503 Nov 2008 @ 03:43 PSTDatabaseTopicT7658 errorHi,consider this stored procedure:create PROCEDURE sp_b(INOUT io_retcd INTEGER)BEGIN SET io_retcd=-70;END;From sql assistant,call sp_b(30) --returns '-70' in the output and is good1. The followin...
1424 Oct 2008 @ 10:36 PDTDatabaseReplyHow to capture procedure out parameter value into unix variable?Thanks Joe, will do that.-srinivas
1323 Oct 2008 @ 11:57 PDTDatabaseTopicHow to capture procedure out parameter value into unix variable?Hi,the following is my stored procedure:sp_getstatus(OUT o_status varchar(10), INOUT io_msg varchar(300))I am calling the above stored procedure in unix via bteq as follows:bteq &1 ${LOGON} ; ...
1223 Oct 2008 @ 12:51 PDTDatabaseReplyIssue with stored procedure INOUT parameterThanks Joe, that worked !-srinivas
1122 Oct 2008 @ 09:02 PDTDatabaseReplyHow to Wait, Pause or SleepThanks to all for your suggestions on timestamp.I have two timestamps (start and end) and i have to increment both to avoid duplicate values and this canbe too much of man-handling the timestamps.I...
1022 Oct 2008 @ 08:51 PDTDatabaseTopicIssue with stored procedure INOUT parameterHi, i am calling a stored procedurea)sp_getval(INOUT io_msg varchar(300));Inside the stored procedure i am:SET io_msg='123456789';Now when i call sp_getval('abc'), in the sql assistant it only disp...
922 Oct 2008 @ 12:18 PDTDatabaseReplyHow to Wait, Pause or SleepHi,i am calling the SP from bteq. This shouldn't matter much, as i am only interested in keeping different timestamps in the debug table for sp calls that run linearly.No UDFs have ever been writte...
821 Oct 2008 @ 11:33 PDTDatabaseReplyHow to Wait, Pause or SleepMy stored procedure is a recursive one, and it inserts the current timestamp for every call.The procedure runs so fast that the timestamp is the same for two consecutive calls upto precision of 6se...
721 Oct 2008 @ 08:47 PDTDatabaseTopicHow to Wait, Pause or SleepHi,in my stored procedure i want to wait/pause/sleep for few milliseconds.I am not waiting for any action to complete, i just have to pause for a while.How can i do this?Thanks,-srinivas yelamanchili
616 Oct 2008 @ 04:40 PDTDatabaseTopicString function to reverse searchHi,Without using UDFs and without using lookup join,1. is there an easier way to find the position of the last occurrence of a character (say '_') in a string?2. how to find the nth occurrence of a...
514 Oct 2008 @ 12:42 PDTDatabaseReplyevaluate expressionRight now i am using case statement.The expression is part of stored procedure, but not part of any SQL,so not sure how to use dynamic sql here.Thanks,-srinivas
413 Oct 2008 @ 11:40 PDTDatabaseTopicevaluate expressionHi,i want to do the following in a stored procedureif (a v_op b) then...end if;where v_op is a variable (can have values like '>=', '<', .....)Again, for expressions likeSET d = a v_op bwhere...
313 Oct 2008 @ 10:22 PDTDatabaseReplyHow to exit stored procedureThanks Jim,i used another BEGIN/END with label and used LEAVE on this lable.It worked.Thanks again,-srinivas
213 Oct 2008 @ 04:01 PDTDatabaseTopicHow to exit stored procedureHi,in my TD stored procedure i want to exit the stored procedure when certain if condition is met.There are a lot of statements after the if the clause and i don't want to go ahead with those.if ...
112 Apr 2007 @ 12:52 PDTDatabaseReplyReverse string search (right to left)?Is there an easier way to find the position of the last occurence of a character (say '_') in a string?Without having to do a lookup join?

Pages