DB2_FIELD_DISPLAY_SIZE(3) 1 DB2_FIELD_DISPLAY_SIZE(3)db2_field_display_size - Returns the maximum number of bytes required to display a columnSYNOPSIS
int db2_field_display_size (resource $stmt, mixed $column)
DESCRIPTION
Returns the maximum number of bytes required to display a 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 value with the maximum number of bytes required to display the specified column. If the column does not exist in the
result set, db2_field_display_size(3) returns FALSE.
SEE ALSO db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_DISPLAY_SIZE(3)
I am trying to validate the third column in a pipe delimited file.
The column must be 10 char long and all digits 0-9.
I am writing out two new files from the existing file, if it would be quicker, I could leave the bad rows in the file and ignore them in the next process.
What I have is... (12 Replies)
Dear All,
I have a file name pointer.unl. It's contains the information below:
O|A|4560333089|PBS|AU1|01/04/2003|30/04/2006|D|IGCD|
O|A|4562222089|PBN|AU1|01/02/2006|31/01/2008|D|04065432|
O|A|3454d00089|PKR|AU1|01/03/2008||R|sdcdc|
I only need to extract first... (11 Replies)
Hi ,
I want to find out max of columns.
a.txt
10|20|xxxxx|yyy|c
20|30|xxxxxxxxx|yyyyyyyyyyyy|z
40|50|xxxxxxxxxxxxxxxx|yyy|C
cat a.txt |awk -F "|" '{print length($1),length($2), length($3),length($4)}'
2 2 5 3
2 2 9 12
2 2 16 3
Above one give the length of columns ,I want pick... (13 Replies)
Dear guru's,
I am learning shellscripting and now I 'm struggeling with this problem:
When the number in the left column is equal or higer then 200, I want to send an email to "postmaster" @ the corresponding domain in the right column.
220 shoes.com
217 dishwashers.net
209 ... (11 Replies)
I have a text file names test2 with 3 columns as below . We have to retrieve the distinct values (not duplicate) from 2nd column and display. I have used the below command but giving some error.
NS3303 NS CRAFT LTD
NS3303 NS CHIRON VACCINES LTD
NS3303 NS ALLIED MEDICARE LTD
NS3303 NS... (16 Replies)
Hi all,
I need to convert this file having just one column into two column file
current file:
a
15
b
21
c
34
d
48
e
10
wanted:
a 15
b 21
c 34 (15 Replies)
Hi everyone,
i am new to perl programming, i have a problem in extracting single column from csv file. the column is the 20th column,
please help me..
at present i use this code
#!C:/perl/bin
use warnings;
use strict;
my $file1 = $ARGV;
open FILE1, "<$file1"
or die "Can't... (13 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 !
If there is only one single value in a column (e.g. column 1 below), then return this value in the same output column.
If there are several values in the same column (e.g. column 2 below), then return the different values separated by "," in the output.
pipe-separated input:
... (11 Replies)
In following attached 748phy.xls file, fifth column is ST_Date, which contains time and dates in this format
22-11-2012 7:54:54 PM in single column
I want it to split in this format either 1st column 22/11/2012 and in second column 7:54:54 PM
Or like this in separate... (13 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)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 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)
Gents
Is it possible to update the code to get the desired output files from the input list. I called variable to the first column.
I need to consider the first column as key to grep the values in the second column according to the desired request.
input list
(attached )
output1
... (12 Replies)