Linux and UNIX Man Pages

Test Your Knowledge in Computers #440
Difficulty: Medium
The term "GPU" was coined by Nvidia in 1994.
True or False?
Linux & Unix Commands - Search Man Pages

ingres_field_length(3) [php 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)

Check Out this Related Man Page

INGRES_FIELD_SCALE(3)							 1						     INGRES_FIELD_SCALE(3)

ingres_field_scale - Get the scale of a field

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

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

length of data greater than 11

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)
Discussion started by: thanuman
2 Replies

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

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

4. Shell Programming and Scripting

replacing a nul field with text

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)
Discussion started by: DarkHound
3 Replies

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

6. UNIX for Dummies Questions & Answers

Perl Experts - Need your help

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

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

8. Shell Programming and Scripting

Flat file-make field length equal to header length

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)
Discussion started by: sonali.s.more
5 Replies

9. Shell Programming and Scripting

Replace a field with a character as per the field length

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)
Discussion started by: gani_85
2 Replies

Featured Tech Videos