I have " .ixf" file which was extracetd from the database. how can i read that file in ASCII format.
Thanks in advance
yogeeswar
Last Activity: May 24 '07, 09:28 AM
Joined: Feb 20 '07
Location:
-
How to read ixf file in ascii format
-
Rollback with atomic block
Hi All
I wrote SP with number of delete commands in an atomic block.And there is a possibility of deleting records from parent table before child table so I wrote a handler to handle the exception.in that handler I am using the ROLLBACK to rollback all the records which were deleted if any exception occurs.
THE PROBLEM IS: It is working fine, if the deleting records size is small.but if i tried to delete thousands... -
How to handle Exception
HI ALL
I need to write a SP having a set of deletion queries and any one of query fails then all the previously deleted records need to be rollback. And there is a possibility of deleting a record from parent table before deletiing from child table so the exception may occur. is it possible handle the exception to rollback the records
Thanks in Advance -
How to stop execution(infinite loop) of SP
HI ALL
I wrote a SP having loop, and unfortunatly I forget to write exit of loop.
And then I executed the SP but the processing is going on infinitly and it is not coming out of the loop. Also I tried to delete the tables on which I wrote the loop commands, but the tables were not deleted is there any way to stop that infinite execution -
Command to retrieve all SP names fro mCLLP
HI All
I want to retrieve the all the Stored Procedures names from CLP is there any command for it? -
need urgent info regarding rollback
I need to write a SP to decommission one of the value from all tables.but all the deletions need to be made at a time, if problems occurs at any delete statement all the previously deleted rows need to be ROLLBACK. Is there any way fro this.
Thanks in advance -
Need Urgent Info Regarding Retreiving Values From Child Table
HI ALL
I AM USING DB2 8.1 AND I HAVE TWO TABLES
PARENT TABLE
1)CODE IS PRIMARY KEY
CODE CODE_DESC CATEGORY
----------- ---------------------------------------- ---------- ------------
1 SelectByPlan A
2 SPT A
3 SP ... -
HI GURU
Can you tell me the syntax of this command... -
Any command for renaming a Stored Procedure?
Hi
I am working on DB2 8.2 version and I have only rights to access through Command Line Processor. I want to change the name of the one of the Stored Procedure through CLP is there any command for this( Re naming storedprocedure ).
No activity results to display
Leave a comment: