INGRES_FIELD_SCALE(3) 1 INGRES_FIELD_SCALE(3)ingres_field_scale - Get the scale of a fieldSYNOPSIS
int ingres_field_scale (resource $result, int $index)
DESCRIPTION ingres_field_scale(3) returns the scale of a field. This value is used only for the decimal SQL data type. For detailed information, see
the Ingres OpenAPI User Guide, Appendix "Data Types" in the Ingres documentation.
Note
Related Configurations
See ingres.array_index_start in Runtime Configuration
PARAMETERS
o $result
- The query result identifier
o $index
-$index is the field whose scale will be retrieved. The possible values of $index depend upon the value of
ingres.array_index_start. If ingres.array_index_start is 1 (the default) then $index must be between 1 and the value returned by
ingres_num_fields(3). If ingres.array_index_start is 0 then $index must be between 0 and ingres_num_fields(3)
- 1.
RETURN VALUES
Returns the scale of the field, as an integer
SEE ALSO ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3).
PHP Documentation Group INGRES_FIELD_SCALE(3)
Check Out this Related Man Page
INGRES_FETCH_ASSOC(3) 1 INGRES_FETCH_ASSOC(3)ingres_fetch_assoc - Fetch a row of result into an associative arraySYNOPSIS
array ingres_fetch_assoc (resource $result)
DESCRIPTION
This function is stores the data fetched from a query executed using ingres_query(3) in an associative array, using the field names as
keys.
With regard to speed, the function is identical to ingres_fetch_object(3), and almost as quick as ingres_fetch_row(3) (the difference is
insignificant).
By default, arrays created by ingres_fetch_assoc(3) start from position 1 and not 0 as with other DBMS extensions. The starting position
can be adjusted to 0 using the configuration parameter ingres.array_index_start.
Note
Related Configurations
See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $result
- The query result identifier
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows
EXAMPLES
Example #1
Fetch a row into an associative array
<?php
$link = ingres_connect($database, $user, $password);
$result = ingres_query($link,"select * from table");
while ($row = ingres_fetch_assoc($result)) {
echo $row["user_id"]; // using associative array
echo $row["fullname"];
}
?>
SEE ALSO ingres_query(3), ingres_num_fields(3), ingres_field_name(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).
PHP Documentation Group INGRES_FETCH_ASSOC(3)
Hi ,
this is the first time i use bc to calculate and i would have decimal result , i use the following :
toto=400;scale=1 echo $toto / 1000|bc
scale to adjust the numbers after the command would have in this case 0.4 as result and i wonder why i have always 0 as result.
Somebody can... (2 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)
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)
Hear how the changing needs of massive scale-out computing is driving a transfomation in technology and learn how HP is supporting this new evolution of the web.
More... (1 Reply)
http://c.fsdn.com/fm/screenshots/69890_thumb.png Dapper, or "Distributed and Parallel Program Execution Runtime", is a tool for taming the complexities of developing for large-scale cloud and grid computing, enabling the user to create distributed computations from the essentials: the code that... (0 Replies)
http://c.fsdn.com/fm/screenshots/69890_thumb.png Dapper, or "Distributed and Parallel Program Execution Runtime", is a tool for taming the complexities of developing for large-scale cloud and grid computing, enabling the user to create distributed computations from the essentials: the code that... (0 Replies)
Ok, so I inherited a system with Ingres 2.6 - which they will migrate to SQL Server soon... But until then, we still need to make sure the database is recoverable in case we need to. The issue is that the backup script is failing on rollforwarddb as you can see below. Where the heck do I start... (0 Replies)
Hi All,
I am using ingres in perl
select count(*) rec from user_tables where table_name = 'abc';
I want to use the alias variable 'rec' and check the value if >0 insert values else create table.
How can I do this without using hash variables in perl.
Kindly help me in this regard.
Much... (1 Reply)
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)
I have a series of observations of which one column is sometimes missing (zero):
date temp delta
1977 284.54 29.84
1978 149.82 0
1979 320.71 28.45
1980 176.76 0
1981 854.65 0
1984 817.65 0
1985 990.58 27.98
1986 410.21 0
1987 405.93 0
1988 482.9 0
What I would like to achieve is a... (8 Replies)
Can someone explain to me please why the scale=3 fails to give me an answer to 3 decimal places in the first example of calling bc below but succeeds in the second?
I know I can use a printf modifier to get the answer to 3 decimal places but I'd like to understand what's going on with bc.
... (8 Replies)