Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ingres_commit(3) [php man page]

INGRES_COMMIT(3)							 1							  INGRES_COMMIT(3)

ingres_commit - Commit a transaction

SYNOPSIS
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 transaction

SYNOPSIS
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)
Man Page

12 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Error Handling in Korn Shell scripts

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)
Discussion started by: bhgopi
4 Replies

2. UNIX for Dummies Questions & Answers

copy, clear and keep to new data only

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)
Discussion started by: sarge
1 Replies

3. UNIX for Dummies Questions & Answers

Need help in Unix shell script

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)
Discussion started by: srichakra
13 Replies

4. UNIX for Advanced & Expert Users

Why?

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)
Discussion started by: *nixloverman123
2 Replies

5. Shell Programming and Scripting

Speeding up processing a file

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)
Discussion started by: dlam
4 Replies

6. UNIX for Dummies Questions & Answers

Script to copy file small interval file

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)
Discussion started by: kalyankalyan
1 Replies

7. Shell Programming and Scripting

Help identifying transactions with no detail lines

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)
Discussion started by: rookie12
2 Replies

8. UNIX and Linux Applications

Got Errors while sending a transaction through ESB

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)
Discussion started by: KuldeepSinghTCS
1 Replies

9. Shell Programming and Scripting

Append transaction header lines to same transaction's detail lines

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)
Discussion started by: rookie12
3 Replies

10. Shell Programming and Scripting

Query about opening the file

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)
Discussion started by: adisky123
6 Replies

11. Shell Programming and Scripting

Lookup in another file and conditionally modify it inline

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)
Discussion started by: mansoorcfc
5 Replies

12. UNIX for Beginners Questions & Answers

Match file and find count

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)
Discussion started by: arunkumar_mca
4 Replies