#DateForumTypeThreadPost
7720 Aug 2014 @ 08:24 PDTDatabaseReplyHow to pass special characters as parameter in Stored ProcedureHi,   Actually the brackets within double quotes and w/o that also  worked :-) (which I mentioned to give example above). The issue is, I need to pass around 4000 char of i/p parameter ...
7620 Aug 2014 @ 07:42 PDTDatabaseTopicHow to pass special characters as parameter in Stored ProcedureHi,   How can I pass special characters as input parameters to Stored Procedures. As of now I am particularly looking for brackets "(" , ")" and Single quote. What ...
7504 Jul 2014 @ 06:01 PDTDatabaseTopichow to select non 0 and numeric values from Varchar fieldHi,   We have an ID field in a table. Currently this contains values such as: ???? xxxx 0 00 0000 123 0123   I want to select only 123, 0123. Currently I am doing sel * from ta...
7412 Feb 2014 @ 06:13 PSTToolsReplyCan I perform Delete and Insert in the same triggerThanks Dnoeth. I was just thinking if we can have it in one trigger.   Thanks.
7311 Feb 2014 @ 02:35 PSTToolsTopicCan I perform Delete and Insert in the same triggerHi,   I have to create a trigger on table A so that whenever there is any insert or delete in table A, there should be same insert and Delete in Table B. Please let me know if it is possibl...
7229 Aug 2013 @ 09:34 PDTDatabaseTopicInvalid session mode error for Store ProcedureHi,   Need an urgent help. I am trying to create a SP in Tera mode but it is giving Invalid Session mode error. When I am creating the SP with ANSI mode it is getting created, but while exec...
7116 Jul 2013 @ 08:59 PDTDatabaseReplyFetch address from two different tables where fetch NOT NUll data from table 1 and then from B which is null in 2Hello,   any suggestions???A bit urgent. Thanks a lot.   Terankit
7016 Jul 2013 @ 03:51 PDTDatabaseTopicFetch address from two different tables where fetch NOT NUll data from table 1 and then from B which is null in 2Hi dnoeth,   need a help from you. We are inserting rows(address details) in table A by Inner joining this table with B, C and D. D is having address and we are taking address which is NOT N...
6902 Dec 2012 @ 02:48 PSTDatabaseReplyUsing .HANG command with DROP statement in the same line is not workingHi,   Any comment, anybody???
6830 Nov 2012 @ 02:10 PSTDatabaseTopicUsing .HANG command with DROP statement in the same line is not workingHi Ulrich/Dnoeth, Somehow I am not able to commenton my post related to this issue.So, I created a new topic. Dnoeth suggested me to use "Data file with Record mode off and foldline ...
6729 Nov 2012 @ 10:22 PSTDatabaseReplyUsing .HANG command with DROP statement in the same line is not workingHi dnoeth,   please help as it is not working at the end time of my request.thanks in advance. Terankit
6629 Nov 2012 @ 08:16 PSTDatabaseReplyUsing .HANG command with DROP statement in the same line is not workingI have tried ".RECORDMODE OFF .FOLDLINE ALL " also but then I am getting my query written in the file as well with the page numbers.   Terankit
6529 Nov 2012 @ 08:07 PSTDatabaseTopicUsing .HANG command with DROP statement in the same line is not workingHi Ulrich/Dieter, I am using the below query to create DROP statement and HANG statement after every 25 DROP statements. SELECT DISTINCT 'DROP TABLE DB.' || TABLENAME || ' ;' ...
6429 Nov 2012 @ 07:50 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthHi Ulrich,   I have used this query to add ".HANG10" after every 25 statements. But, when I executed this query using BTEQ it is not processing ".HANG10" command with the...
6329 Nov 2012 @ 02:08 PSTDatabaseTopicHow to use Errorlevel and Activity count in Fast Export like in BTEQ?Hi All,   Is there a way we can use Errorlevel and Activity Count to set the Return code in Fast Export? I want to set the return code to 8 when there is any error, set RC 4 when Activity co...
6209 Nov 2012 @ 01:57 PSTDatabaseReplySelect Tables created in a previous months onlyThanks Ulrich. I have made a query as given below: SELECT DBNAME,                     &nbs...
6108 Nov 2012 @ 11:19 PSTDatabaseTopicSelect Tables created in a previous months onlyHi All,   I need to get the list of the tables which were created in the last month only. Ex. If I run this query on 3rd November'12, it should give me the list of the tables created du...
6006 Nov 2012 @ 01:24 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthThanks a lot Ulrich and Waq. That query gave me the desired output perfectly. Thanks again. Terankit
5905 Nov 2012 @ 07:18 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthHi Waq, Can you please explain a bit? I am not aware of this.Thanks.
5805 Nov 2012 @ 05:59 PSTDatabaseTopicPurge the work tables cretaed a month before and create report with the list of work tables created last month Hi All,   I need to purge work tables which were created a month before. I am using the below query to extract the list of all such tables: SELECT DISTINCT 'DROP TABLE DB1.' |...
5718 Oct 2012 @ 11:59 PDTDatabaseReplyPlease tune this quey as it is taking terabytes spool space Here Table A and Table B are the same table. The requirement was: Update Status in Z if data from A loaded to C and D. To check that data from A loaded to C and D we are matching the column ...
5618 Oct 2012 @ 11:46 PDTDatabaseTopicPlease tune this quey as it is taking terabytes spool spaceHi All, I have a query which was working fine till the time we were having small volume data in table A. It started taking terabytes of spool space when there was Million rows in Table A. Can some...
5528 Aug 2012 @ 12:20 PDTGeneralReplyPoints to take care for Automated Purge Process Hi Dnoeth, Please help. Thanks in advance.
5422 Aug 2012 @ 06:31 PDTGeneralReplyPoints to take care for Automated Purge Process Hi Guys,   Please let me know as it is something important and urgent for me. Thanks.
5321 Aug 2012 @ 07:51 PDTGeneralTopicPoints to take care for Automated Purge Process Hi All, Some time back a development team put a new system working on Teradata. They have designed a backup process which is having space issue now.Now we come up with Automated Purge proces...

Pages