Table null is empty Post: 302309063

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_primary_keys

DB2_PRIMARY_KEYS(3)							 1						       DB2_PRIMARY_KEYS(3)

db2_primary_keys - Returns a result set listing primary keys for a table

SYNOPSIS

       resource db2_primary_keys (resource  $connection, string  $qualifier, string  $schema, string  $table-name)

DESCRIPTION

	Returns a result set listing the primary keys 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. If $schema is NULL, db2_primary_keys(3) matches the schema for the current connection.

	      o $table-name
		- The name of the table.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the primary keys for the specified table. The result set is com-
       posed of the following columns:

       +------------+---------------------------------------------------+
       |Column name |							|
       |	    |							|
       |	    |			 Description			|
       |	    |							|
       +------------+---------------------------------------------------+
       | TABLE_CAT  |							|
       |	    |							|
       |	    |  Name of the catalog for the table containing the |
       |	    | primary key. The value is NULL if this table does |
       |	    | not have catalogs.				|
       |	    |							|
       |TABLE_SCHEM |							|
       |	    |							|
       |	    |  Name of the schema for the table containing  the |
       |	    | primary key.					|
       |	    |							|
       |TABLE_NAME  |							|
       |	    |							|
       |	    |	Name of the table containing the primary key.	|
       |	    |							|
       |COLUMN_NAME |							|
       |	    |							|
       |	    |  Name of the column containing the primary key.	|
       |	    |							|
       |  KEY_SEQ   |							|
       |	    |							|
       |	    |	1-indexed position of the column in the key.	|
       |	    |							|
       |  PK_NAME   |							|
       |	    |							|
       |	    |		The name of the primary key.		|
       |	    |							|
       +------------+---------------------------------------------------+
SEE ALSO

       db2_column_privileges(3),   db2_columns(3),   db2_foreign_keys(3),   db2_procedure_columns(3),  db2_procedures(3),  db2_special_columns(3),
       db2_statistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 												       DB2_PRIMARY_KEYS(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