command to check value of autocommit and isolation level Post: 302549564

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

process nice level command line vs cron

Under, Solaris 10 I have the following problem: A script executed at command line runs with nice level 0, as expected. Same script started under (user) crontab runs with nice level 2. I would prefer it run at 0. Is this possible? If so, how? Thanks.

2. Infrastructure Monitoring

Firewall / Network isolation inquiry

Good morning folks, A good friend of mine has a network where every host has two paths to the file servers (two NICs & two networks for all hosts). Normally speaking, one network will be used for regular application traffic - license servers, itunes library, collaboration tools - while the...

3. AIX

how to set AUTOCOMMIT option in AIX

Hi, Can anybody tell,how to set the auto commit option in AIX,i have tried with environmental variables option like 'export db2option=-c +a'. But its not working in my environment. is there any other option?

4. Linux

OS Patch level command

Hi Do let me know how to find OS Patch 's installed on Linux server ? Thanks ~ SPai

5. Solaris

Difference between run level & init level

what are the major Difference Between run level & init level

6. Web Development

[Solved] Disable mySQL autocommit

Hi. Does anyone know how I can disable auto-commit in mySQL? I've been Googling it for ages, and one suggestion that always comes up is adding this to /etc/my.cnf: ... init_connect='SET autocommit=0' But that didn't work. I then read that this wouldn't work anyway for a...

7. UNIX and Linux Applications

how to change isolation level to READ COMMITTED

Hi, I am using perl DBI and mysql-5.0.26 on unix. Could you please let me know or point to source on how to set isolation level to READ COMMITTED . ~Thanks

8. Red Hat

SSL certificate generation on OS level or application level

We have a RHEL 5.8 server at the production level and we have a Java application on this server. I know of the SSL certificate generation at the OS (RHEL) level but it is implemented on the Java application by our development team using the Java keytool. My doubt is that is the SSL generation can...

9. Shell Programming and Scripting

Command to check only Autosys running jobs with autorep like command

Hi, Is there any specific command to use to check only say Running jobs via autorep or similar command for Autosys?

LEARN ABOUT PHP

ingres_autocommit

INGRES_AUTOCOMMIT(3)							 1						      INGRES_AUTOCOMMIT(3)

ingres_autocommit - Switch autocommit on or off

SYNOPSIS

       bool ingres_autocommit (resource  $link)

DESCRIPTION

       ingres_autocommit(3)  is called before opening a transaction (before the first call to ingres_query(3) or just after a call to ingres_roll-
       back(3) or ingres_commit(3)) to switch the autocommit mode of the server on or off (when the script begins the autocommit mode is off).

	When autocommit mode is on, every query is automatically committed by the server, as if ingres_commit(3) was called after  every  call	to
       ingres_query(3). To see if autocommit is enabled use, ingres_autocommit_state(3).

	By default Ingres will rollback any uncommitted transactions at the end of a request. Use this function or ingres_commit(3) to ensure your
       data is committed to the database.

PARAMETERS

	      o $link
		- The connection link identifier

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO

       ingres_autocommit_state(3), ingres_query(3), ingres_rollback(3), ingres_commit(3).

PHP Documentation Group 												      INGRES_AUTOCOMMIT(3)