Sponsored Content
Full Discussion: Roll back problem
Top Forums Shell Programming and Scripting Roll back problem Post 75078 by tmarikle on Wednesday 15th of June 2005 10:22:14 AM
Old 06-15-2005
...or you could use something like a semaphore. Keep a status flag in an OS table for all of your processes to check. When one updates this to say that a failure occurred, start rolling back.

If you are periodically committing records, then use some kind of common batch update identifier in your table. This will help you delete all records common to the batch. If you can't add columns to the table that you are loading, create a new table that keeps key values of records that you are working with.

Thomas
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

back up problem

Hi all I am facing some problem taking INCREMENTAL Back up of file systems...........Actually i have mounted the file system of one server in another server..as i don't have tape drive in both servers...............i am using HPUX(L class and C class)servers.. can any one help me ... (1 Reply)
Discussion started by: Prafulla
1 Replies

2. UNIX for Dummies Questions & Answers

automated back up problem

Hi.. I am using HP UX 11.0 i want to make automated back up from SAM back up tool.... so i mentioned the file systems and back up device /dev/rmt/0m and time 0:00 and days of the week........ but it was not successful.....the back up job was not started on specified time..... i am in... (7 Replies)
Discussion started by: Prafulla
7 Replies

3. UNIX for Advanced & Expert Users

problem while getting the response back..plz help

Hi ALL: I am not able to get the response back from weblogic in the shell script. The weblogic server in different account. I am able to login to that account and bring the server up but while doing a ping, the script is failing. While the same script is running fine if I run it on the account... (1 Reply)
Discussion started by: splax
1 Replies

4. UNIX for Advanced & Expert Users

p570 - Problem bringing it back up

I have a p570 server with 2 LPARs on it. One of my colleagues did a firmware upgrade on it over the weekend but I have not been able to bring it back online since. I go to activate the partition from the HMC and it gets stuck on the C20082FF operator panel and just freezes from there. Does... (2 Replies)
Discussion started by: KeesH
2 Replies

5. Shell Programming and Scripting

Puzzling Problem: Going back to the previous directory

Hi, I am trying to figure out if there is a way to make linux take me back to the previous directory I was working in. For instance, I am in /home/username/directory1 Then if I cd into /home/username/directory1/temp1/temp2/temp3 I would like to immediately go back to the previous... (2 Replies)
Discussion started by: Legend986
2 Replies

6. Solaris

Patching Roll-back

What is the easiest or preferred way to roll back the solaris cluster patches? My guess is to do a flash archive pre-patch and then install off of that if it doesn't work. Any other ideas? (4 Replies)
Discussion started by: adelsin
4 Replies

7. Solaris

Roll back latest Solaris Patches

Is there an easy way to roll back or uninstall the latest Solaris patch cluster? I'm hoping I don't have to go into each patch that was applied and uninstall them one-by-one. Thanks! (0 Replies)
Discussion started by: bluescreen
0 Replies

8. Red Hat

Roll back patches for RHEL 5

Hi, I want to roll back the packages that are installed during the patch installation of RHEL 5 server. There are in all 110 packages including the kernel package... kernel-2.6.18-274.el5.x86_64.rpm kernel-headers-2.6.18-274.el5.x86_64.rpm How should I proceed ? I don't want to run rpm... (4 Replies)
Discussion started by: aksijain
4 Replies

9. Shell Programming and Scripting

Roll back the code

Hi is there any shell script to roll back the code when the code is deployed in a wrong way in production servers (3 Replies)
Discussion started by: Purushotham
3 Replies

10. Homework & Coursework Questions

Back quote problem

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Print out problem with line follow: echo There are '$cat $fname | wc -l' contacts in database how do I replace... (2 Replies)
Discussion started by: scopiop
2 Replies
ODBC_FOREIGNKEYS(3)							 1						       ODBC_FOREIGNKEYS(3)

odbc_foreignkeys - Retrieves a list of foreign keys

SYNOPSIS
resource odbc_foreignkeys (resource $connection_id, string $pk_qualifier, string $pk_owner, string $pk_table, string $fk_qualifier, string $fk_owner, string $fk_table) DESCRIPTION
Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the specified table PARAMETERS
o $connection_id -The ODBC connection identifier, see odbc_connect(3) for details. o $pk_qualifier - The primary key qualifier. o $pk_owner - The primary key owner. o $pk_table - The primary key table. o $fk_qualifier - The foreign key qualifier. o $fk_owner - The foreign key owner. o $fk_table - The foreign key table. RETURN VALUES
Returns an ODBC result identifier or FALSE on failure. The result set has the following columns: oPKTABLE_QUALIFIER oPKTABLE_OWNER oPKTABLE_NAME oPKCOLUMN_NAME oFKTABLE_QUALIFIER oFKTABLE_OWNER oFKTABLE_NAME oFKCOLUMN_NAME oKEY_SEQ oUPDATE_RULE oDELETE_RULE oFK_NAME oPK_NAME If $pk_table contains a table name, odbc_foreignkeys(3) returns a result set containing the primary key of the specified table and all of the foreign keys that refer to it. If $fk_table contains a table name, odbc_foreignkeys(3) returns a result set containing all of the foreign keys in the specified table and the primary keys (in other tables) to which they refer. If both $pk_table and $fk_table contain table names, odbc_foreignkeys(3) returns the foreign keys in the table specified in $fk_table that refer to the primary key of the table specified in $pk_table. This should be one key at most. PHP Documentation Group ODBC_FOREIGNKEYS(3)
All times are GMT -4. The time now is 11:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy