DB2_FIELD_PRECISION(3) 1 DB2_FIELD_PRECISION(3)db2_field_precision - Returns the precision of the indicated column in a result setSYNOPSIS
int db2_field_precision (resource $stmt, mixed $column)
DESCRIPTION
Returns the precision of the indicated column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer containing the precision of the specified column. If the specified column does not exist in the result set,
db2_field_precision(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_PRECISION(3)
Check Out this Related Man Page
DB2_FIELD_WIDTH(3) 1 DB2_FIELD_WIDTH(3)db2_field_width - Returns the width of the current value of the indicated column in a result setSYNOPSIS
int db2_field_width (resource $stmt, mixed $column)
DESCRIPTION
Returns the width of the current value of the indicated column in a result set. This is the maximum width of the column for a fixed-length
data type, or the actual width of the column for a variable-length data type.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer containing the width of the specified character or binary data type column in a result set. If the specified column
does not exist in the result set, db2_field_width(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3).
PHP Documentation Group DB2_FIELD_WIDTH(3)
Hi I was hoping that maybe someone could help me with a small piece of C code. I have a number of files, which are all of similar layout ie. three lines of text and 5-6 columns of numerical data. I need to add each of the elements of the second column in one file to their counterparts in the second... (17 Replies)
Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column
ID001
value 1
value 2
value....n
ID002
value 1
value 2
value... n
I want to be able to calculate the average for values for each ID from the... (18 Replies)
Hi All,
My requisite is to search for the string "0108"(which is the year and has come in the wrong year format) in a particular column say 4th column in a tab delimited file and then replace it with 2008(the correct year format) in the same position where 0108 was found in the same file..The... (27 Replies)
I have this command like that has %s in it, I know %s calls a column, but I am not sure I understand which column (I mean for my case I can check the input file, but I want to know how is this %s used, how comes tha same symbo; gives different columns in one command line:
{printf "grep %s... (22 Replies)
I have a file that has 5 cloumns. I want to write a script that would read each line (row), go to columns 3 (1er) and 5 (ens); whenever there is a match between the two columns i.e their values, the script with output the corresponding value in colums 1 and 2. If someone could help me, I would... (15 Replies)
Hi All,
I have a sync report file in the following format:
root@####: updating host ####
root@####: /opt/dba/bin/removedbaccount.sh: need to update
root@####: /opt/sysadm/bin/sync###dirs.sh: need to update
root@####: /opt/sysadm/bin/nbu_unassign_media.sh: need to install
root@####:... (17 Replies)
Hi!
Is there an easy way (maybe using awk??) to divide the values of one column of the file by it's first entry..
If I have a column:
3
4
5
6
7
I would like to divide it by 3.
I want to do this for more than 100 files, so it wouldn't be practical to open file by file and... (26 Replies)
Hi
Iam trying to do a similar functionality as vlookup in excel between two files, but my problem is that its not a column to column in match its a text within a column:
File 1:
1 yanki disable xyz123 link=xyz123
2 bravo enable asd123 link=asd123
File 2:
1 sample total lab_xyz123... (17 Replies)
Hi all,
I have an input file like this
Now
I have to remove duplicates only in first column and nothing has to be changed in second and third column. so that output would be
Please let me know scripting regarding this (20 Replies)
Hi All,
I have two files having oracle query result. I want to merge to files line by line and also with column
File1
23577|SYNC TYPE
23578|Order Number|ConnectionState
23585|Service State|Service NameFile2
23577|AR Alarm Sync
23578|A5499|9
23585|7|test_nov7Result... (18 Replies)
Hi All, i believe this is not very efficient. another method would be appreciated for these. basically i read a file with tab delimited column and pass the column to another perl script.
while read line
do
timestamp=`echo "$line"|awk -F"\t" '{print $1}'`
severity=`echo... (15 Replies)
I have some files that look as follows. I need to add a character 'C' in the fifth column if that column is blank. I prefer in-place editing.
1 1 B M 0 0 203 0, 0.0 0, 0.0 0, 0.0 0, 0.0 0.000 360.0 360.0 360.0 141.9 15.4 28.8 66.1
2 2 B A ... (21 Replies)
Hi All,
I want to find the difference between two files, by checking only the headers (column names) and report if any new column is added in the latest file.
For Ex: If the file "declartion.txt has these columns
url;image;id;showcase_id;showcase_name
and the actual file "feed.txt" has... (34 Replies)
I have two input file.:
File 1 is a large reference sequence (A large Fasta sequence);
File 1 (is a file which first line is the header description and line other ">" is its corresponding word and counting from 1 till end of file);
>Data_1
ASWDADAQTWQQGSAAAAASDAFAFA
.
.
File 2 is... (31 Replies)
Hi,
I want to replace the value in more than one column.
For one column ,following command is working -
sed 's/./$value_to_replace/$column number' file_name
e.g. suppose this is input 1111000000
command - sed 's/./M/5'
output= 1111M000000
For two column also command is like -
cat... (22 Replies)