Any Sample ksh script to validate all the database objects Post: 302787199

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sample of script that control a daemon

Hi everybody, Does somebody has a sample of script that control a daemon? for example use loop until the daemon is on and if is not on do something else? Thanks Pier

2. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal.

3. Shell Programming and Scripting

count multiple objects in shell script

Hi all: Trying to count the number of oracle instances on HPUX 11.23 - using ksh. I have multiple instances running and I would like to have a count for how many processes for each instance. Example, run the 'ps -efu oracle' command and for each instance increment a counter. So I am looking for...

4. Shell Programming and Scripting

Validate xml agaist xsd is ksh

how do i validate xml agaist xsd is ksh?

5. Shell Programming and Scripting

How to validate Database password in ksh?

Hi All, I want to validate the Production Database password at the time of login through script. If incorrect password entererd by the user, the script will ask again for the password. Below is the sample of my script... ######################### # Unix Code Starts here #...

6. Shell Programming and Scripting

Typo in sample script from book?

Hello, I'm new to this forum, and I apologize in advance if I did something wrong here. I am pretty stumped here as I am still getting the error message, "./comc1.sh: test: argument expected." after executing the script itself. Here's the script file I modified: I tried executing line 4...

7. Shell Programming and Scripting

A script that processes a sample of a file

hi all, I need some help in regards of how to process just a sample from a large .txt file I have a large file from many new lines (say above 200.000 new lines), I need a script that process just a sample of it, say 10.000 bur a random sample (taking rows from top top to the the bottom) ...

8. Shell Programming and Scripting

Sample Script

Below is the code. Its the 1st line of a file. How can I remove the bracket and display like below. 123 web int 1 09:30:45 2013 I dont want to use AWK or SED or PERL. I need to use only the bash shell scripting commands to do it.

9. UNIX for Beginners Questions & Answers

Sample shell script to add a user

Sample shell script to add a user: Today i learn how to add a user to linux server with a password. #!/bin/bash # Script to add a user to Linux system if ; then read -p "Enter username : " username read -s -p "Enter password : " password egrep "^$username" /etc/passwd >/dev/null if ;...

LEARN ABOUT PHP

db2_table_privileges

DB2_TABLE_PRIVILEGES(3) 						 1						   DB2_TABLE_PRIVILEGES(3)

db2_table_privileges - Returns a result set listing the tables and associated privileges in a database

SYNOPSIS

       resource db2_table_privileges (resource	$connection, [string  $qualifier], [string  $schema], [string  $table_name])

DESCRIPTION

	Returns a result set listing the tables and associated privileges in a database.

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. This parameter accepts a search pattern containing _ and % as wildcards.

	      o $table_name
		- The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.

RETURN VALUES

	Returns  a  statement resource with a result set containing rows describing the privileges for the tables that match the specified parame-
       ters. 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.		 |
       |	     |							 |
       |  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 that has been granted. This can be |
       |	     | one of ALTER,  CONTROL,	DELETE,  INDEX,  INSERT, |
       |	     | REFERENCES, SELECT, or UPDATE.			 |
       |	     |							 |
       |IS_GRANTABLE |							 |
       |	     |							 |
       |	     |	A  string  value  of  "YES"  or  "NO" indicating |
       |	     | whether the grantee can grant  the  privilege  to |
       |	     | other users.					 |
       |	     |							 |
       +-------------+---------------------------------------------------+
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_statistics(3), db2_tables(3).

PHP Documentation Group 												   DB2_TABLE_PRIVILEGES(3)