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)
Check Out this Related Man Page
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)
Here is my bench result. I also have a suspect file-copy result (giving me an index of 0.0) which would significantly drop the overall average.
Anyway, if someone comes up with a reason as to why this may be, please let me know.
Notes
... (0 Replies)
Can any one help me how to pass the value of result of one query to another query.
I to pass the value of result of 'select max(id) from a' into another query
like
update table
set col =<value from last query>
where ....;
updatestaging()
{
xx=`$ORACLE_HOME/bin/sqlplus -s... (1 Reply)
Hallo All, this is my code below. The problem happens under section A because field $9 sometimes does not contain a number it contains a (:) and a number is contained in field $10 as result under sectionC we get a syntax error @
echo "scale=1; $aa+$ee+$ff"|bc > /tmp/pax/c3.txt
So i need to... (5 Replies)
Hey guys, I was given a task that involved parcing a large file that looked somthing like this...
A1-0999999,SMITH,.25
A1-0999999,JOHN,.75
A1-0999999,HELMET,.1.25
A1-0999999,HOOP,.10.25
D1-1212121,SMITH,4.00
D1-1212121,TH,9.00
D1-1212121,MITCH,10.20
D1-1212121,RETAL,3.00
A1-9909555,,3.00... (2 Replies)
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)
Hello Guys,
Well, using shell script, I'm doing loop on DB query as below:
isql -Usa -Ptest -I /opt/sybase/interfaces << EOF
use testdb
go
declare @i int
select @i = 1
while(@i <= 5)
begin
Insert into TEST values (@i,"Test","TestDesc")
select @i = @i + 1
end
go
EOF
The Issue... (2 Replies)
Hi Folks!!
I would like to convert each and every output of my query to the excel column wise. Let me give you an example
The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a... (4 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)
I have a line "My name is Deepak"
How can i search a string Deepak in the line and find out its index position.
Here in this case the result should be 12. (3 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)
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)
Hello Group,
What I have is a database with about a dozen fields and one being "City".
What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
I am trying to create an output file new that contains only the S5-00580 lines from list that are not in analysis_log. My attempt to do this is below.
The new file would be used in the aria2c command to download only new folders. The aria2c command works to download all the files in list, but... (7 Replies)