10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a table with this structure:
cola colb colc
1 19 lemon
20 31 lemon
32 100 lemon
159 205 cherries
210 500 cherries
and need to parse it into this format:
cola colb colc
1 100 lemon
159 500 cherries
So I need the first row of cola and the last row of colb if colc has the... (3 Replies)
Discussion started by: coppuca
3 Replies
2. Shell Programming and Scripting
Dear folks
I have 300 files which one of them are looking like:
1.SNP
0
0
1
0
I am looking for desire output:
1.SNP 0 0 1 0
I used this below command to run all of the 300 file at the same time
for file in *.SNP; do awk '{printf( "%s ", $1 );} END {printf("\n");}' $file >... (1 Reply)
Discussion started by: sajmar
1 Replies
3. Shell Programming and Scripting
Dear All,
I have input :
SEG901 5173 9005 5740
SEG902 5227 5284
SEG903 5284 5346
SEG904 5346 9010
SEG905 5400 5456
SEG906 5456 5511
SEG907 5511 9011
SEG908 5572 9015
SEG909 5622 9020
SEG910 5678 5739
SEG911 5739 5796
SEG912 5796 9025 ... (3 Replies)
Discussion started by: attila
3 Replies
4. UNIX for Dummies Questions & Answers
file with this content
awk 'NR==1 {print $4} && NR==2 {print $5}' file
The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies
5. Shell Programming and Scripting
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies
6. Shell Programming and Scripting
Hi all,
I am pretty new at this so be gentle. Also, if there is any chance you could explain what the code you use is actually doing, that would really help me out, Im learning after all :)
So I am trying to convert a selected column of numbers from input file1 into a row in output file2
... (3 Replies)
Discussion started by: StudentServitor
3 Replies
7. Shell Programming and Scripting
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies
8. Shell Programming and Scripting
Hi All,
I needd to convert values in a row to a column.
eg: Input is as: value1,value2,value3,value4,.........,value N
Required Output:
Value1
Value2
Value3
.
.
.
Value N
Please help.... (3 Replies)
Discussion started by: sambaman
3 Replies
9. Shell Programming and Scripting
I have a requirement in which i have to read a file which has multiple columns seperated by a pipe "|" from this i have to read each column values seperately and create a comma seperated row for the column and write to another file.
eg:
Input file:
ColA ColB
1 2
2 x
3 y... (5 Replies)
Discussion started by: nvuradi
5 Replies
10. Shell Programming and Scripting
Hi,
I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value .
For Eg .
if the input file has a row :
abc xyz lmn 89 lm nk o p
I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
DB2_STATISTICS(3) 1 DB2_STATISTICS(3)
db2_statistics - Returns a result set listing the index and statistics for a table
SYNOPSIS
resource db2_statistics (resource $connection, string $qualifier, string $schema, string $table-name, bool $unique)
DESCRIPTION
Returns a result set listing the index and statistics for a table.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema that contains the targeted table. If this parameter is NULL, the statistics and indexes are returned for the schema
of the current user.
o $table_name
- The name of the table.
o $unique
- An integer value representing the type of index information to return.
o $0
- Return only the information for unique indexes on the table.
o $1
- Return the information for all indexes on the table.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the statistics and indexes for the base tables matching the
specified parameters. The rows are composed of the following columns:
+--------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+--------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | The catalog that contains the table. The value is |
| | NULL if this table does not have catalogs. |
| | |
| TABLE_SCHEM | |
| | |
| | Name of the schema that contains the table. |
| | |
| TABLE_NAME | |
| | |
| | Name of the table. |
| | |
| NON_UNIQUE | |
| | |
| | An integer value representing whether the index |
| | prohibits unique values, or whether the row rep- |
| | resents statistics on the table itself: |
| | |
| | box, tab (|); c | c | . T{ Return value |
| | |
| | Parameter type |
| | |
+--------------+---------------------------------------------------+
|0 (SQL_FALSE) | |
| | |
| | The index allows duplicate values. |
| | |
|1 (SQL_TRUE) | |
| | |
| | The index values must be unique. |
| | |
| | |
| NULL | |
| | |
| | This row is statistics information for the table |
| | itself. |
| | |
+--------------+---------------------------------------------------+
T} T{ INDEX_QUALIFIER
T} |T{ A string value representing the qualifier that would have to be prepended to INDEX_NAME to fully qualify the index.
T} T{ INDEX_NAME
T} |T{ A string representing the name of the index.
T} T{ TYPE
T} |T{
An integer value representing the type of information contained in this row of the result set:
+------------------------+---------------------------------------------------+
| Return value | |
| | |
| | Parameter type |
| | |
+------------------------+---------------------------------------------------+
| 0 (SQL_TABLE_STAT) | |
| | |
| | The row contains statistics about the table |
| | itself. |
| | |
|1 (SQL_INDEX_CLUSTERED) | |
| | |
| | The row contains information about a clustered |
| | index. |
| | |
| 2 (SQL_INDEX_HASH) | |
| | |
| | The row contains information about a hashed |
| | index. |
| | |
| 3 (SQL_INDEX_OTHER) | |
| | |
| | The row contains information about a type of |
| | index that is neither clustered nor hashed. |
| | |
+------------------------+---------------------------------------------------+
T} T{ ORDINAL_POSITION
T} |T{ The 1-indexed position of the column in the index. NULL if the row contains statistics information about the table itself.
T} T{ COLUMN_NAME
T} |T{ The name of the column in the index. NULL if the row contains statistics information about the table itself.
T} T{ ASC_OR_DESC
T} |T{
A if the column is sorted in ascending order, D if the column is sorted in descending order, NULL if the row contains statistics informa-
tion about the table itself.
T} T{ CARDINALITY
T} |T{
If the row contains information about an index, this column contains an integer value representing the number of unique values in the
index. If the row contains information about the table itself, this column contains an integer value representing the number of rows in
the table.
T} T{ PAGES
T} |T{
If the row contains information about an index, this column contains an integer value representing the number of pages used to store the
index. If the row contains information about the table itself, this column contains an integer value representing the number of pages used
to store the table.
T} T{ FILTER_CONDITION
T} |T{ Always returns NULL.
T}
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe-
cial_columns(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_STATISTICS(3)