update trigger

Special Forums UNIX and Linux Applications update trigger

09-17-2010

Registered User

1, 0

Join Date: Sep 2010

Last Activity: 17 September 2010, 10:03 AM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

update trigger

hi all,

i hope i am posting this /beginner) question in the right forum:
i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted to update this field to Y, the trigger should rollback the transaction.

thanks for every hint or advise in advance!
k

---------- Post updated at 09:03 AM ---------- Previous update was at 08:23 AM ----------

I was able to help myself

kalinkula

View Public Profile for kalinkula

Find all posts by kalinkula

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To trigger script on particular instance

Hi Guys, I have a main_script.sh which runs every day and scheduled in crontab. in the main script i read data from config file test.config apple mango orange main_script.sh for i in `cat test.config` do if then echo 'Apple'

2. Shell Programming and Scripting

Help not trigger the trap

mainpid=$$ (trap "echo timeout" SIGTERM SIGKILL SIGINT; sleep 5; kill $mainpid) & watchdogpid=$! sleep 10 #do something kill $watchdogpid I design a timeout function script I don't see the echo "timeout" is on the screen

3. Programming

MYSQL - trigger update on record insert or update

Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works: UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` ); So now I want this...

4. OS X (Apple)

AC to DC trigger pulse for AudioScope.sh.

Hi all... Has _below_ ever been done in UNIX shell scripting before? (I have done this easily in Python but this is using purely the shell.) The DEMO version IS built and has been tested. Pre-amble... I now need at least one control pulse for the AudioScope.sh when in PURELY audio I/O mode,...

5. Programming

MYSQL - trigger to track changes to fields on update

So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big...

6. Shell Programming and Scripting

Trigger functionality in Unix

Hi, I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening., Below is...

7. Shell Programming and Scripting

Update trigger for unix file (solaris)

Hello, from log error file of process that i's updating in append mode, i need to capture the new entries for every day. How i can know and save only the new errors? This it's a sample of error log file (oas report server engine) thanks and regards Fran

8. HP-UX

Control-M Job trigger

Hi, I'm totally new in Control-M and I really need some help. Here's my problem. I need to make job X from a server trigger job Y from a different server where job X must receive a confirmation first before execution. :confused: I really have no idea on how to do that so can you please give...

9. Shell Programming and Scripting

Trigger with condition

If test.ksh is successful then I have a sequence of script which needs to execute automatically. Is it possible to capture the return code to execute the next script automatically? what is better way of doing this.

10. Shell Programming and Scripting

Trigger Enter

Hello, I need to trigger every time enter has been clicked while some one on terminal i tried to googleit but with out result any idea ?? thanks in advance

LEARN ABOUT PHP

cubrid_get_db_parameter

CUBRID_GET_DB_PARAMETER(3)						 1						CUBRID_GET_DB_PARAMETER(3)

cubrid_get_db_parameter - Returns the CUBRID database parameters

SYNOPSIS

       array cubrid_get_db_parameter (resource	$conn_identifier)

DESCRIPTION

	This  function	returns the CUBRID database parameters or it returns FALSE on failure. It returns an associative array with the values for
       the following parameters:

	      o PARAM_ISOLATION_LEVEL

	      o PARAM_LOCK_TIMEOUT

	      o PARAM_MAX_STRING_LENGTH

	      o PARAM_AUTO_COMMIT

       Database parameters

       +----------------------+---------------------------------------------------+
       |      Parameter       | 						  |
       |		      | 						  |
       |		      | 		   Description			  |
       |		      | 						  |
       +----------------------+---------------------------------------------------+
       |PARAM_ISOLATION_LEVEL | 						  |
       |		      | 						  |
       |		      | 	The transaction isolation level.	  |
       |		      | 						  |
       |    LOCK_TIMEOUT      | 						  |
       |		      | 						  |
       |		      | CUBRID provides the lock timeout  feature,  which |
       |		      | sets  the  waiting time (in seconds) for the lock |
       |		      | until the transaction lock  setting  is  allowed. |
       |		      | The  default  value  of  the lock_timeout_in_secs |
       |		      | parameter is  -1,  which  means  the  application |
       |		      | client	will wait indefinitely until the transac- |
       |		      | tion lock is allowed.				  |
       |		      | 						  |
       |  PARAM_AUTO_COMMIT   | 						  |
       |		      | 						  |
       |		      | In CUBRID PHP, auto-commit mode  is  disabled  by |
       |		      | default for transaction management. It can be set |
       |		      | by using cubrid_set_autocommit(3).		  |
       |		      | 						  |
       +----------------------+---------------------------------------------------+
	The following table shows the isolation levels from 1 to 6. It consists of table schema (row) and isolation level:

       Levels of Isolation Supported by CUBRID

       +--------------------------------------------------+---------------------------------------------------+
       |		      Name			  |						      |
       |						  |						      |
       |						  |		       Description		      |
       |						  |						      |
       +--------------------------------------------------+---------------------------------------------------+
       |		SERIALIZABLE (6)		  |						      |
       |						  |						      |
       |						  | In this isolation level, problems concerning con- |
       |						  | currency  (e.g.  dirty read, non-repeatable read, |
       |						  | phantom read, etc.) do not occur.		      |
       |						  |						      |
       |REPEATABLE  READ  CLASS  with	REPEATABLE   READ |						      |
       |INSTANCES (5)					  |						      |
       |						  |						      |
       |						  | Another  transaction  T2 cannot update the schema |
       |						  | of table A while transaction T1 is viewing	table |
       |						  | A. Transaction T1 may experience phantom read for |
       |						  | the record R that was inserted by another  trans- |
       |						  | action T2 when it is repeatedly retrieving a spe- |
       |						  | cific record.				      |
       |						  |						      |
       |REPEATABLE  READ  CLASS   with	 READ	COMMITTED |						      |
       |INSTANCES (or CURSOR STABILITY) (4)		  |						      |
       |						  |						      |
       |						  | Another  transaction  T2 cannot update the schema |
       |						  | of table A while transaction T1 is viewing	table |
       |						  | A.	Transaction  T1  may  experience R read (non- |
       |						  | repeatable read) that was updated  and  committed |
       |						  | by	another  transaction T2 when it is repeatedly |
       |						  | retrieving the record R.			      |
       |						  |						      |
       |REPEATABLE  READ  CLASS  with  READ   UNCOMMITTED |						      |
       |INSTANCES (3)					  |						      |
       |						  |						      |
       |						  | Default  isolation	level. Another transaction T2 |
       |						  | cannot update the schema of table A while  trans- |
       |						  | action  T1 is viewing table A. Transaction T1 may |
       |						  | experience R' read (dirty read)  for  the  record |
       |						  | that  was  updated	but  not committed by another |
       |						  | transaction T2.				      |
       |						  |						      |
       |READ  COMMITTED   CLASS   with	 READ	COMMITTED |						      |
       |INSTANCES (2)					  |						      |
       |						  |						      |
       |						  | Transaction  T1  may  experience  A'  read	(non- |
       |						  | repeatable read) for the table that  was  updated |
       |						  | and  committed by another transaction T2 while it |
       |						  | is viewing table A repeatedly. Transaction T1 may |
       |						  | experience	R' read (non-repeatable read) for the |
       |						  | record that was updated and committed by  another |
       |						  | transaction  T2 while it is retrieving the record |
       |						  | R repeatedly.				      |
       |						  |						      |
       |READ  COMMITTED  CLASS	with   READ   UNCOMMITTED |						      |
       |INSTANCES (1)					  |						      |
       |						  |						      |
       |						  | Transaction  T1  may  experience  A'  read	(non- |
       |						  | repeatable read) for the table that  was  updated |
       |						  | and  committed by another transaction T2 while it |
       |						  | is repeatedly viewing table A. Transaction T1 may |
       |						  | experience	R'  read  (dirty read) for the record |
       |						  | that was updated but  not  committed  by  another |
       |						  | transaction T2.				      |
       |						  |						      |
       +--------------------------------------------------+---------------------------------------------------+
PARAMETERS

	      o $conn_identifier
		- The CUBRID connection. If the connection identifier is not specified, the last link opened by cubrid_connect(3) is assumed.

RETURN VALUES

	An associative array with CUBRID database parameters; on success.

       FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 8.4.0	|						    |
       |	|						    |
       |	|  Change  LOCK_TIMEOUT  to PARAM_LOCK_TIMEOUT, and |
       |	| MAX_STRING_LENGTH to	PARAM_MAX_STRING_LENGTH  in |
       |	| result.					    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      cubrid_get_db_parameter(3) example

	      <?php
	      printf("%-30s %s
", "CUBRID PHP Version:", cubrid_version());

	      printf("
");

	      $conn = cubrid_connect("localhost", 33088, "demodb");

	      if (!$conn) {
		  die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg());
	      }

	      $db_params = cubrid_get_db_parameter($conn);

	      while (list($param_name, $param_value) = each($db_params)) {
		  printf("%-30s %s
", $param_name, $param_value);
	      }

	      printf("
");

	      $server_info = cubrid_get_server_info($conn);
	      $client_info = cubrid_get_client_info();

	      printf("%-30s %s
", "Server Info:", $server_info);
	      printf("%-30s %s
", "Client Info:", $client_info);

	      printf("
");

	      $charset = cubrid_get_charset($conn);

	      printf("%-30s %s
", "CUBRID Charset:", $charset);

	      cubrid_disconnect($conn);

	      ?>

	      The above example will output:

	      CUBRID PHP Version:	     9.1.0.0001

	      PARAM_ISOLATION_LEVEL	     3
	      LOCK_TIMEOUT		     -1
	      MAX_STRING_LENGTH 	     1073741823
	      PARAM_AUTO_COMMIT 	     1

	      Server Info:		     9.1.0.0212
	      Client Info:		     9.1.0

	      CUBRID Charset:		     iso8859-1

SEE ALSO

       cubrid_set_db_parameter(3), cubrid_get_autocommit(3).

PHP Documentation Group 												CUBRID_GET_DB_PARAMETER(3)

UNIX and Linux Applications