Table null is empty Post: 302309069

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 DEBIAN

dbs_dumptabstruct

DBS_DUMPTABSTRUCT(1p)					User Contributed Perl Documentation				     DBS_DUMPTABSTRUCT(1p)

NAME

       dbs_dumptabstruct - Creates file set with SQL table schemas

DESCRIPTION

       dbs_dumptabstruct is an utility to create a file set with SQL table schemas.  For each table in the database dbs_dumptabstruct calls the
       appropriate dumper utility with the output directed to a file named table.sql in the current directory. dbs_dumptabstruct asks for a pass-
       word if necessary.

COMMAND LINE PARAMETERS

       Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the database name. The third parameter is
       optionally and specifies the database user and/or the host where the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").

COMMAND LINE OPTIONS

       -d=OPTIONS, -o=OPTIONS, --dump-options=OPTIONS

       Pass options to the dumper utility, e.g. "--compatible=mysql40".

       -p, --pipe

       Prints the table dumps to standard output.

       -t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...]

       Comma-separated list of tables to dump.

       --exclude-matching-tables=REGEXP

       Excludes any table matching the regular expression REGEXP from dumping.

BUGS

       Only mysql and Pg drivers are supported.

AUTHOR

       Stefan Hornburg (Racke), racke@linuxia.de

VERSION

       0.17

SEE ALSO

       perl(1), DBIx::Easy(3)

perl v5.8.8							    2007-02-01						     DBS_DUMPTABSTRUCT(1p)

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