Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ingres_execute(3) [php man page]

INGRES_EXECUTE(3)							 1							 INGRES_EXECUTE(3)

ingres_execute - Execute a prepared query

SYNOPSIS
bool ingres_execute (resource $result, [array $params], [string $types]) DESCRIPTION
Execute a query prepared using ingres_prepare(3). Note Related Configurations See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration. PARAMETERS
o $result - The result query identifier o $params - An array of parameter values to be used with the query o $types - A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list of type codes. RETURN VALUES
Returns TRUE on success or FALSE on failure. SEE ALSO
ingres_unbuffered_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_rollback(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3). PHP Documentation Group INGRES_EXECUTE(3)

Check Out this Related Man Page

INGRES_PREPARE(3)							 1							 INGRES_PREPARE(3)

ingres_prepare - Prepare a query for later execution

SYNOPSIS
mixed ingres_prepare (resource $link, string $query) DESCRIPTION
Prepares a query for execution by ingres_execute(3). The query becomes part of the currently open transaction. If there is no open transaction, ingres_query(3) opens a new transaction. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use ingres_autocom- mit(3) before opening a new transaction to have every SQL query immediately committed. Note Related Configurations See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration. PARAMETERS
o $link - The connection link identifier o $query - A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3) for a list of SQL statements which cannot be executed using ingres_prepare(3) RETURN VALUES
ingres_prepare(3) returns a query result identifier that is used with ingres_execute(3) to execute the query. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsqlstate(3). SEE ALSO
ingres_unbuffered_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_rollback(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3). PHP Documentation Group INGRES_PREPARE(3)
Man Page

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script Advice please?

Ok. I want to parse a log file and search only for denied traffic for the previous hour. The log looks like this: Jun 18 17:47:56 routername 36806: Jun 18 17:53:01.088: %SEC-6-IPACCESSLOG: list ingress-filter denied tcp 1.2.3.4(1234) -> 6.7.8.9(53), 4 packets I only really care about the... (12 Replies)
Discussion started by: earnstaf
12 Replies

2. SCO

Ingres dbms on sco unix

Hi everybody. I'm going to install ingres on sco unix 5.0.7. A client version may be usefull. I want to know how can I get appropriate version and how to install ingres on sco unix. thanks. (1 Reply)
Discussion started by: javad1_maroofi
1 Replies

3. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ... (2 Replies)
Discussion started by: hanul
2 Replies

4. Red Hat

Values in array are not able to be used one by one

hey,i stored the value of an sql query in an array and then tried to use that value in while loop. actually my array will have two or more values, then according to the values i have to display result. #!/bin/bash -xv val_1=$( sqlplus -s rte/rted1@rel75d1 << EOF set heading off select... (1 Reply)
Discussion started by: ramsavi
1 Replies

5. Shell Programming and Scripting

How to pass parameter to bteq?

I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as below code but not working. bteq < /download/viv/dev/ops/Scripts/ter.sh FLTORGTKR_ORG_etc.. ... (1 Reply)
Discussion started by: katakamvivek
1 Replies