Table null is empty Post: 302309102

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check for null or empty string

Hi, I need to check for value not equal (<>) to 21 and not equal empty or null values. Please modify this script if then echo "$VALUE,$BSC_NAME,$BSC_ID" > $OUT_FILE/power_up.out end if TQ

2. UNIX for Dummies Questions & Answers

how to find empty folders without using -empty

hi all: my solaris FIND does not support find myFolder -type d -empty how can i find the empty folders? thanks!

3. UNIX for Dummies Questions & Answers

Getting same exit status for empty and non empty file

Hi All, I am checking for a empty input file to do some further action , but I am getting exit status 0 in both the cases , for empty and non empty file both. The value of $? is coming 0 in if part also and else part too. #!/bin/ksh if ]; then echo "data" # exit 0 echo "$?" else...

4. Shell Programming and Scripting

PHP: how can I delete empty/NULL elements from a multi-dimensional array.

Hi all I have a file that i'm running and exec(cat ./dat) against..and putting its contents into any array, then doing an exploding the array into a multi-dimension array... The 15 multi-dimensional arrays have elements that are null/empty, I would like to remove/unset these elements and then...

5. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is...

6. Shell Programming and Scripting

Insert string 'NULL' where there is a null value

I have an input file having 7 fields delimited by , eg : 1,ABC,hg,1,2,34,3 2,hj,YU,2,3,4, 3,JU,kl,4,5,7, 4,JK,KJ,3,56,4,5 The seventh field here in some lines is empty, whereas the other lines there is a value. How do I insert string NULL at this location (7th loc) for these lines where...

7. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing...

8. Shell Programming and Scripting

Identify empty file with null record

Hi Team, I have a file abc.dat which is a empty file. But it has null record in first line. I need to identify this unique file and handle it separately. scenario 1: abc/dw> wc abc.dat 1 0 1 abc.dat abc/dw> cat abc.dat abc/dw> scenario 2: abc/dw> wc pqr.dat 0 0 0 pqr.dat...

9. UNIX for Beginners Questions & Answers

Parsing null or empty output

I am working an some if then statements for a script. I want to be able to check for alpha characters or empty out put then exit out. if ]]; echo "Serial Number Invaild" then exit 3; How do I account if the output is empty or null in this in this statement. Many thanks

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,...

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 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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check for null or empty string

Discussion started by: doer

2. UNIX for Dummies Questions & Answers

how to find empty folders without using -empty

Discussion started by: lasse

3. UNIX for Dummies Questions & Answers

Getting same exit status for empty and non empty file

Discussion started by: mavesum

4. Shell Programming and Scripting

PHP: how can I delete empty/NULL elements from a multi-dimensional array.

Discussion started by: zeekblack