10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell script and im trying to call a .sql file. The sql file has a simple Anonymous block.
The code is
shell script
db2 -tvf query.sql
the sql file contains
SET SERVEROUTPUT ON;
BEGIN
call dbms_output.put_line( 'Hello' );
END;
I get the following error
BEGIN... (1 Reply)
Discussion started by: sup
1 Replies
2. Solaris
Hi,
I have a server with Solaris 11 with a zpool raid to serve as a NAS. Every day in the morning I do an incremental snapshot of the zpool and send it to another local disk as a backup.
I would now like to build another small server to hold backups in a different place to prevent data loss... (0 Replies)
Discussion started by: RychnD
0 Replies
3. Solaris
Got a strange problem.
I have 4 Solaris servers all configured the same, Solaris 10 x86 update 10.
When I try to ssh from one Solaris 10 server to another server ssh hangs.
I have an identical server and when I try this everything works fine.
The weird thing is if I am root on the server... (1 Reply)
Discussion started by: ccj4467
1 Replies
4. Shell Programming and Scripting
I'm brand new to awk and need your help.
I want to be able to shut down my workstations when they become to hot (because we've lost our cooling). I found a really neat way to monitor the temperature of the system and a short, simple awk scipt to use with it:
/usr/sbin/prtpicl -v -c... (2 Replies)
Discussion started by: natural
2 Replies
5. Shell Programming and Scripting
Is there a way to call a shell script via db2 trigger?
I want to wake up a shell script to perform some action if there is a insert action on a db2 table. (1 Reply)
Discussion started by: prasperl
1 Replies
6. Solaris
Hi,
I am unable to login into my terminal hosting Solaris 10 and get the below error message
"Server refused to allocate pty
ld.so.1: sh: fatal: libc.so.1: open failed: No such file or directory "
Is there anyways i can get into my machine and what kind of changes are required to be... (7 Replies)
Discussion started by: sankasu
7 Replies
7. Shell Programming and Scripting
I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Discussion started by: tjhanso
1 Replies
8. IP Networking
This is probably really basic compared to what you guys are usually talking about here, but I have a problem and I have no idea what to do about it. I try to RSH to my Ubuntu computer from my Solaris one and run into a dead end:
>> rsh 192.168.1.103
::ffff:192.168.1.103: Connection timed out... (4 Replies)
Discussion started by: Bradj47
4 Replies
9. Solaris
hi,
I have some windows client machines which require a signal to be sent by a Solaris machine( SunOS 5.6) when ever a particular event occurs on that Solaris machine. What are possible communication mechanisms by which i can do this.
the constraints are
> the windows machines have to... (7 Replies)
Discussion started by: Krsh
7 Replies
10. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
DB2_COLUMN_PRIVILEGES(3) 1 DB2_COLUMN_PRIVILEGES(3)
db2_column_privileges - Returns a result set listing the columns and associated privileges for a table
SYNOPSIS
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)