INGRES_COMMIT(3) 1 INGRES_COMMIT(3)ingres_commit - Commit a transactionSYNOPSIS
bool ingres_commit (resource $link)
DESCRIPTION ingres_commit(3) commits the currently open transaction, making all changes made to the database permanent.
This closes the transaction. A new transaction can be opened by sending a query with ingres_query(3).
You can also have the server commit automatically after every query by calling ingres_autocommit(3) before opening the transaction.
By default Ingres will roll back any uncommitted transactions at the end of a request. Use this function or ingres_autocommit(3) to ensure
your that 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_query(3), ingres_rollback(3), ingres_autocommit(3).
PHP Documentation Group INGRES_COMMIT(3)
Check Out this Related Man Page
IBASE_TRANS(3) 1 IBASE_TRANS(3)ibase_trans - Begin a transactionSYNOPSIS
resource ibase_trans ([int $trans_args], [resource $link_identifier])
DESCRIPTION
resource ibase_trans ([resource $link_identifier], [int $trans_args])
Begins a transaction.
Note
The first call to ibase_trans(3) will not return the default transaction of a connection. All transactions started by
ibase_trans(3) will be rolled back at the end of the script if they were not committed or rolled back by either ibase_commit(3) or
ibase_rollback(3).
Note
This function will accept multiple $trans_args and $link_identifier arguments. This allows transactions over multiple database con-
nections, which are committed using a 2-phase commit algorithm. This means you can rely on the updates to either succeed in every
database, or fail in every database. It does NOT mean you can use tables from different databases in the same query!
If you use transactions over multiple databases, you will have to specify both the $link_id and $transaction_id in calls to
ibase_query(3) and ibase_prepare(3).
PARAMETERS
o $trans_args
-$trans_args can be a combination of IBASE_READ, IBASE_WRITE, IBASE_COMMITTED, IBASE_CONSISTENCY, IBASE_CONCURRENCY,
IBASE_REC_VERSION, IBASE_REC_NO_VERSION, IBASE_WAIT and IBASE_NOWAIT.
o $link_identifier
- An InterBase link identifier. If omitted, the last opened link is assumed.
RETURN VALUES
Returns a transaction handle, or FALSE on error.
PHP Documentation Group IBASE_TRANS(3)
Hi,
I am using few ISQL statements to update and delete from a few tables in sybase, now i want to roll back the transaction when any of the statements fail.How i can i capture these errors in the shell scripts.Please advise.
Thanks,
Gopi (4 Replies)
I have an Ingres database logfile that grows constantly, iircp.log. It is always "attached" to the Ingres process that uses it, and I do not want to screw up the data. I have been copying it to another directory and then using vi on the original to reduce the size 34000 lines at a time. What I want... (1 Reply)
Hi
I am new to this forum.I need a help in the following:
We receve pipe delimited file with
transaction ID,tran_date,Quest_cd,Ans_cd,ans_value.
Same transaction ID can be repeated with different quest_cd and ans_cd.
Basically I need to check if a perticular pair of quest_cd and ans_cd (say... (13 Replies)
As much as I love unix, in particular it's derivatives linux and mac, I must say it's a b*** to code software for. I used to maintain a PHP project back in the early 2000s, which I won't link to as I no longer maintain it, and anyway, basically it was a PHP based personal organiser. It worked and... (2 Replies)
Hi guys, I'm hoping you can help me here. I've knocked up a script that looks at a (huge) log file, and pulls from each line the hour of each transaction and how long each transaction took.
The data is stored sequentially as:
07:01 blah blah blah 12456 blah
07:03 blah blah blah 234 blah... (4 Replies)
HI Guys
whenever i post a transaction , abcd.in file is stored in the temp and vanishes when the transaction is compleated . the abcd.in file stays for 1 sec in temp is der any solution to capture the abcd.in file to another directory
cp -r /tmp/abcd.in /tmp/smith.in
when i used the... (1 Reply)
Wondering if someone can help with my task of identifying missing detail lines in transactions.
I have a flat file that contains transaction header, transaction detail, and transaction trailer lines. These lines are identified with a 5-character line identifier "THEAD", "TDETL", and "TTAIL" at... (2 Replies)
We are getting below error when processing a transaction through ESB.
I work for SOA admin and checked the JCA connection is working fine also code also working fine in other envs.
An unhandled exception has been thrown in the ESB system. The exception reported is:... (1 Reply)
Hi guys, I was wondering if someone can give me a hand in helping me append transaction header line in a file at the end of the transaction detail lines.
Basically, I have a file that looks like this:
FHEAD File1
THEAD TRANS1-blah
TDETL HI1
TDETL HI2
TDETL HI3
TTAIL TRANS1-blah
THEAD... (3 Replies)
I have a query regard the opening of the file. Suppose I have opened the file
Let's say view filename
And then I found that I have to do some changes in that, but I do not want to close the file
Then how I can change the permission of the file from read mode to write mode
Regards
Adi (6 Replies)
Hi,
I have an issue where i need to lookup in a given transaction file and if the same transaction is found in another file, then i need to replace a few columns with some other value.
Finally, the changed and unchanged lines must be printed and stored in the same source file.
for example... (5 Replies)
Hi All,
I have transaction in one file.I want to match that to another file and find the number of time the transaction is available on the other file.I need to take each record from TRANSFILE and match that with SPEND FILE and find the number of counts of the transaction
TRANSFILE:
... (4 Replies)