IFX_GETSQLCA(3) 1 IFX_GETSQLCA(3)ifx_getsqlca - Get the contents of sqlca.sqlerrd[0..5] after a query
SYNOPSIS
array ifx_getsqlca (resource $result_id)
DESCRIPTION
Returns a pseudo-row with sqlca.sqlerrd[0] ... sqlca.sqlerrd[5] after the query associated with $result_id.
For inserts, updates and deletes the values returned are those as set by the server after executing the query. This gives access to the
number of affected rows and the serial insert value. For SELECTs the values are those saved after the PREPARE statement. This gives access
to the *estimated* number of affected rows. The use of this function saves the overhead of executing a SELECT dbinfo('sqlca.sqlerrdx')
query, as it retrieves the values that were saved by the ifx driver at the appropriate moment.
PARAMETERS
o $result_id
-$result_id is a valid result id returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
RETURN VALUES
Returns an associative array with the following entries: sqlerrd0, sqlerrd1, sqlerrd2, sqlerrd3, sqlerrd4 and sqlerrd5.
EXAMPLES
Example #1
Retrieve Informix sqlca.sqlerrd[x] values
<?php
/* assume the first column of 'sometable' is a serial */
$qid = ifx_query("insert into sometable
values (0, '2nd column', 'another column') ", $connid);
if (!$qid) {
/* ... error ... */
}
$sqlca = ifx_getsqlca($qid);
$serial_value = $sqlca["sqlerrd1"];
echo "The serial value of the inserted row is : $serial_value<br />
";
?>
PHP Documentation Group IFX_GETSQLCA(3)
Check Out this Related Man Page
IFX_AFFECTED_ROWS(3) 1 IFX_AFFECTED_ROWS(3)ifx_affected_rows - Get number of rows affected by a querySYNOPSIS
int ifx_affected_rows (resource $result_id)
DESCRIPTION
Returns the number of rows affected by a query associated with $result_id.
For inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]).
Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not even
begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).
Useful after ifx_prepare(3) to limit queries to reasonable result sets.
PARAMETERS
o $result_id
- A valid result id returned by ifx_query(3) or ifx_prepare(3).
RETURN VALUES
Returns the number of rows as an integer.
EXAMPLES
Example #1
Informix affected rows
<?php
$rid = ifx_prepare("select * from emp
where name like " . $name, $connid);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
?>
SEE ALSO ifx_num_rows(3).
PHP Documentation Group IFX_AFFECTED_ROWS(3)
Hi Guys,
Thank you all for helping me with my different queries and I continue to get better at scripting because of help from all of you!
I have a file that would look something like -
ID SUB ID VALUE
1 10 5
2 18 7
1 ... (1 Reply)
Hi,
So far i've made a script that takes two argument, 1st is the contents and the 2nd is the named file. At the moment i've managed to insert new contents as a new line at the top, but i want to ask how can you insert contents in the middle of the file?
Source Code
#!/bin/bash
#Write... (3 Replies)
I am working on a file, I need add a column with serial # in a file, the column will be the first column. and the serial # will be decide by each raw, say if I have 6 raws, I need serial # from 1 to 6 in the first column. Anyone know how to add that. I really appreciate. Thanks (2 Replies)
Hi all,
I want to extract rows with the pattern ALPHANUMERIC/ALPHANUMNERIC in the 2nd column.
I dont wan rows with more than 1 slash or without any slash in 2nd column.
a a/b
b a/b/c
c a/b//c
d t/y
e r
f /f
I came up with the regex
grep '\/$' file
a a/b
b a/b/c
d t/y (3 Replies)