Still no luck, it thorw's the same output as the source file.
I will explain my requirement once again,
I have report which contains report from my backup server it has six columns and more then 1000 rows.If the 6th column is empty then i need to sum all the values in 6th column starting from very next row, put the result in that empty place.
I have attached a jpeg which can explain more clearly i guess..
Hi guys,
Please help me if u have some solution.
I have a file with three columns separated by ':' -
INPUT_FILE
C416722_2 : calin Dirigent : Dirigent
AC4174_6 : Jac : cal_co
TC4260_5 : [no : lin kite
BC426302_1 : [no : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin
TC428_3 : no7... (4 Replies)
So I have this input
1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI
1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI
1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI
1 10583 rs58108140 G A ... (3 Replies)
Hola,
How can I add a column to a existing file??
PS: The column which should be added need to be the first column and it will be a parameter from the script.
Example:
1 name1
2 name2
3 name3
4 name3
Need to add parameter $file as a first column. $file is a file name with time... (6 Replies)
Hi, long time reader, first time poster.
I've done some searching so please if this is a repeated post excuse the duplicate, but what I have are two files roughly like so:
File 1:
A W
B X
C Y
D Z
File 2:
A 1
C 2
D 3
And what I would like to get out is... (4 Replies)
Dear all,
Lets say, I've a file a.txt containing two columns, like
a1 b1
.. ..
.. ..
and another file b.txt containg two columns, like
a1 c1
.. ..
.. ..
I need to put c1 column from b.txt file to the a.txt file. So, the output should be
a1 b1 c1
.. .. ..
.. ... (4 Replies)
I have file like this
b,c
10,20
30,40
50,60
Now I want to add a new column a with fixed values for all the rows
a,b,c
60,10,20
60,30,40
60,50,60
Please let me know how can we do this in unix. (4 Replies)
Hi,
I have this data file that contains:
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
I want the results to be:
1 A A
2 B A
3 C A
4 D A
5 E A
6 F A
7 G A
8 H A (8 Replies)
Hi Team
I have file as below
empno,ename,sal
123,smith,1000
124,adams,2000
Required output: Using AWK
empno,ename,sal,deptno
123,smith,1000
124,adams,2000
Thanks,
Murali (5 Replies)
Hi,
I have 2 files.
file1 contains by lines: hash:salt:id
file2 contains by lines: username:hash:salt
I would like to add a new coloumn (id) form file1 to file2.
The new file should contains: username:hash:salt:id
Note: file1 contains less rows than file2.
I tried
paste -d':' file1... (12 Replies)
Discussion started by: freeroute
12 Replies
LEARN ABOUT PHP
db2_column_privileges
DB2_COLUMN_PRIVILEGES(3) 1 DB2_COLUMN_PRIVILEGES(3)db2_column_privileges - Returns a result set listing the columns and associated privileges for a tableSYNOPSIS
resource db2_column_privileges (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $column-
name])
DESCRIPTION
Returns a result set listing the columns and associated privileges 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 which contains the tables. To match all schemas, pass NULL or an empty string.
o $table-name
- The name of the table or view. To match all tables in the database, pass NULL or an empty string.
o $column-name
- The name of the column. To match all columns in the table, pass NULL or an empty string.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the column privileges for columns matching the specified parame-
ters. The rows are composed of the following columns:
+-------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+-------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | Name of the catalog. The value is NULL if this |
| | table does not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema. |
| | |
| TABLE_NAME | |
| | |
| | Name of the table or view. |
| | |
|COLUMN_NAME | |
| | |
| | Name of the column. |
| | |
| GRANTOR | |
| | |
| | Authorization ID of the user who granted the |
| | privilege. |
| | |
| GRANTEE | |
| | |
| | Authorization ID of the user to whom the privi- |
| | lege was granted. |
| | |
| PRIVILEGE | |
| | |
| | The privilege for the column. |
| | |
|IS_GRANTABLE | |
| | |
| | Whether the GRANTEE is permitted to grant this |
| | privilege to other users. |
| | |
+-------------+---------------------------------------------------+
SEE ALSO db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3), db2_statis-
tics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_COLUMN_PRIVILEGES(3)