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_FIELD_NULLABLE(3) 1 INGRES_FIELD_NULLABLE(3)ingres_field_nullable - Test if a field is nullableSYNOPSIS
bool ingres_field_nullable (resource $result, int $index)
DESCRIPTION
Test if a field is nullable.
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 nullability 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 ingres_field_nullable(3) returns TRUE if the field can be set to the NULL value and FALSE if it cannot
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_NULLABLE(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)