I have tried it on an example and works well
And I am getting
I want to have a value, example 12.5 and want to add this value to the value that occurs at that position.
Hello all!
Is there a way or a utility to trace any kind of file changes in a particular directory on any UNIX machine?
The purpose is that in Unix, there are multiple ways of opening and making changes to a file. But internally, there must be something common (a single pipe, etc.) that is... (3 Replies)
Good Afternoon Guys:
we can use ls -l to find out the files and their modification time. however, how to list the files say which are modified 15 minutes before. we have find command which uses -mtime and -atime for modification and access timing. However, if we just be restricted to the current... (2 Replies)
hi guys
Need some help on my below script
#!/bin/sh
if
then
echo "~~:S:wait:/sbin/sulogin" >> /root/joy/inittab
else
echo "/root/joy/inittab does not exist"
fi
now the problem is that when i run the above script it runs successfully
but when i run it repeatedly the word echo... (2 Replies)
In folder A i have a file "a' and text file named infile00.I would like to do redirection :a<infile01.
There is a code to do this
#get a file "a" in /home/A
for file in /home/A/*
do
if $file ]
then
#printing out if file is an execute file
echo $file "is an... (2 Replies)
Hi,
During an installation process in a bash script I need to do 2 things with 2 XML files. Does the use of sed affect in any way the XML file ?
1.Add to a section in <ServerListeners> section
<ServerListener>
<BaseClass>myapp.module.WowConfigurator</BaseClass>
</ServerListener>
The... (2 Replies)
Hi,
I do not have a clue how to do this nor can I find information on it but I have a file that looks like this (basically 3 columns and tab delimited). I need this in a particular format in order for a program to actually read it.
chr1 2 4
chr1 2 5
chr1 3 6
chr2 1 4
chr2 2 5
... (2 Replies)
Hello,
I found this Perl Script on the EuroParl website which does Sentence Splitting.
#!/usr/bin/perl -w
# Based on Preprocessor written by Philipp Koehn
binmode(STDIN, ":utf8");
binmode(STDOUT, ":utf8");
binmode(STDERR, ":utf8");
use FindBin qw($Bin);
use strict;
my $mydir =... (0 Replies)
Discussion started by: gimley
0 Replies
LEARN ABOUT PHP
db2_statistics
DB2_STATISTICS(3) 1 DB2_STATISTICS(3)db2_statistics - Returns a result set listing the index and statistics for a tableSYNOPSIS
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)