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)
Check Out this Related Man Page
INGRES_FIELD_NAME(3) 1 INGRES_FIELD_NAME(3)ingres_field_name - Get the name of a field in a query resultSYNOPSIS
string ingres_field_name (resource $result, int $index)
DESCRIPTION ingres_field_name(3) returns the name 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 name 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 name of a field in a query result or FALSE on failure
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_NAME(3)
I need to get all the rows in a file, for which length of field at column 6 is greater than 11.
I tried
awk '{ if ($#1 >11) print $1}' filename
But Iam getting some errors
I tried different combinations like
awk '{ if (${#$1} >11) print $1}' filename
awk '{ if (${#1} >11) print... (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)
Ok here's my pickle. I have a file in which every line must be the same length. Each field within the line is a certain length. None of these can be changed. What I need to do is look at a specific field within this file, let's say it starts with character 30 and ends with 50. If this field is... (3 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)
Hello Everyone,
I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table.
Input Data-
------ ------------------------ ---- -----------------
WFI001 Xxxxxx Control Work Item A Number of Records
------ ------------------------... (5 Replies)
Hi all,
I have a requirement to replace a field with a character as per the length of the field.
Suppose i have a file where second field is of 20 character length. I want to replace second field with 20 stars (*). like ********************
As the field is not a fixed one, i want to do the... (2 Replies)