Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ingres_field_type(3) [php man page]

INGRES_FIELD_TYPE(3)							 1						      INGRES_FIELD_TYPE(3)

ingres_field_type - Get the type of a field in a query result

SYNOPSIS
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 field

SYNOPSIS
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)
Man Page

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

copy, clear and keep to new data only

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)
Discussion started by: sarge
1 Replies

2. 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

3. UNIX for Dummies Questions & Answers

newbie to ingres 2.6

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)
Discussion started by: akimeu
0 Replies

4. Shell Programming and Scripting

pad db2 query result to 8 bits

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)
Discussion started by: lifzgud
1 Replies

5. 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

6. Programming

SQL: copying data down

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)
Discussion started by: figaro
8 Replies

7. Shell Programming and Scripting

Get index value by awk

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)
Discussion started by: mimilaw
8 Replies