INGRES_FIELD_TYPE(3) 1 INGRES_FIELD_TYPE(3)ingres_field_type - Get the type of a field in a query resultSYNOPSIS
string ingres_field_type (resource $result, int $index)
DESCRIPTION
Get the type of a field in a query result.
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 type 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_type(3) returns the type of a field in a query result or FALSE on failure. Examples of types returned are IIAPI_BYTE_TYPE,
IIAPI_CHA_TYPE, IIAPI_DTE_TYPE, IIAPI_FLT_TYPE, IIAPI_INT_TYPE, IIAPI_VCH_TYPE. Some of these types can map to more than one SQL type
depending on the length of the field (see ingres_field_length(3)). For example IIAPI_FLT_TYPE can be a float4 or a float8. For detailed
information, see the Ingres OpenAPI User Guide, Appendix "Data Types" in the Ingres documentation.
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_TYPE(3)
Check Out this Related Man Page
INGRES_FIELD_LENGTH(3) 1 INGRES_FIELD_LENGTH(3)ingres_field_length - Get the length of a fieldSYNOPSIS
int ingres_field_length (resource $result, int $index)
DESCRIPTION ingres_field_length(3) returns the length of a field. This is the number of bytes the server uses to store the field. For detailed informa-
tion, 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 column number whose length 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 length of a field.
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_LENGTH(3)
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)
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 ,
I am using a db2 query to get the maximum sequence number from a field.Now this value is taking up only 2 places.(i.e its less than 100).It can grow up to 3 places later but me requirement is that when i write it in a text file, it should be padded upto 8 places.
Please help (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)
HI All,
I would like to pass a integer and get all values under this index the by using awk. Could anyone help?
Thanks :>
input:
1,2,3,4,5,6,7
1,2,3,48,5,6,7
1,2,3,4,5,6,7
e.g. i pass 4 to awk command
output:
4
48
4
Video tutorial on how to use code tags in The UNIX and Linux... (8 Replies)