How to grep the where clause of a SQL? Post: 302454575

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

if clause

hi, pls could you help me with one program in KSH ( i have sunOS). I need to create an If clause, that prints an error message and filenames, when in a directory are found some files of null size (find . -type f -size 0 ). thanks

2. UNIX for Dummies Questions & Answers

if clause with grep and word count

I've got following script that I thought would only email me when the if clause finds the grep. But it emails me anyway (with an empty file) even if the grep doesn't return anything. What should the line be? if then grep -l 'unique constraint' $LOGDIR/archive_active* >...

3. Shell Programming and Scripting

Dynamic SQL for where clause

Hi, I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4 Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value. eg. where Field1=AAA eg. where Field1=AAA and Field2=BBB eg....

4. Shell Programming and Scripting

How to extract WHERE clause from a SQL using UNIX???

Hi, I need to know how to extract entire WHERE clause from a SQL statement using UNIX command. For example: If following is the SQL then how to extract entire WHERE clause: UPDATE <TABLE_NAME_1> SET <FIELD_NAME> = VALUE WHERE CONDITION_1 AND CONDITION_2 = (SELECT FIELD_NAME FROM...

5. Programming

[ask]SQL command act like sort and grep

for example, I have a text file in random content inside, maybe something like this. 234234 54654 123134 467456 24234234 7867867 23424 568567if I run this command cat "filename.txt" | sort -n | grep "^467456$" -A 1 -B 1the result is 234234 467456 568567is it possible to do this command...

6. Shell Programming and Scripting

If clause in perl

HI friends , I am very new to perl .please dont mind if i ask silly questions. I seee below code in one sript if ( exists $ENV{FMTWRP_TMP_DIR} and $ENV{FMTWRP_TMP_DIR} ) { $tdir = $ENV{FMTWRP_TMP_DIR}; } whats does this mean . I am very confused about the if clauses in...

7. UNIX for Dummies Questions & Answers

Grep SQL output file for greater than number.

Hi, This is my first post. I have a korn shell script which outputs a select statment to a file. There is only one column and one row which contains a record count of the select statement. The select statement looks something like this: SELECT COUNT(some_field) AS "count_value" ...

8. Shell Programming and Scripting

If clause query

Hi, i need to add a condition in my IF clause where i need to check if the file exists in a folder and return true out of it. but in my directory i have multiple files with same name but datestamp append on it for e.g. export f1 = filename export f2=filename1 if ] then echo "No...

9. Shell Programming and Scripting

Using awk and grep for sql generation

10. UNIX for Beginners Questions & Answers

Finding The Complete SQL statement Using PDFGREP Or Grep

Linux Gods, I am simply attempting to parse SQL statements from a PDF doc in creating a base SQL script at a later time but for the life of me, am having a tough time extracting this data.This exact string worked perfectly a couple of months ago and now it doesnt. Below is an example of the data...

LEARN ABOUT DEBIAN

class::dbi::plugin::abstractcount

AbstractCount(3pm)					User Contributed Perl Documentation					AbstractCount(3pm)

NAME

       Class::DBI::Plugin::AbstractCount - get COUNT(*) results with abstract SQL

SYNOPSIS

	 use base 'Class::DBI';
	 use Class::DBI::Plugin::AbstractCount;

	 my $count = Music::Vinyl->count_search_where(
	   { artist   => 'Frank Zappa'
	   , title    => { like    => '%Shut Up 'n Play Yer Guitar%' }
	   , released => { between => [ 1980, 1982 ] }
	   });

DESCRIPTION

       This Class::DBI plugin combines the functionality from Class::DBI::Plugin::CountSearch (counting objects without having to use an array or
       an iterator), and Class::DBI::AbstractSearch, which allows complex where-clauses a la SQL::Abstract.

METHODS

   count_search_where
       Takes a hashref with the abstract where-clause. An additional attribute hashref can be passed to influence the default behaviour: arrayrefs
       are OR'ed, hashrefs are AND'ed.

TODO

       More tests, more doc.

SEE ALSO

       SQL::Abstract for details about the where-clause and the attributes.
       Class::DBI::AbstractSearch
       Class::DBI::Plugin::CountSearch

AUTHOR

       Jean-Christophe Zeus, <mail@jczeus.com> with some help from Tatsuhiko Myagawa and Todd Holbrook.

COPYRIGHT AND LICENSE

       Copyright (C) 2004 by Jean-Christophe Zeus

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.0							    2009-07-01							AbstractCount(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

if clause

Discussion started by: palmer18

2. UNIX for Dummies Questions & Answers

if clause with grep and word count

Discussion started by: Meert

3. Shell Programming and Scripting

Dynamic SQL for where clause

Discussion started by: TeSP

4. Shell Programming and Scripting

How to extract WHERE clause from a SQL using UNIX???

Discussion started by: ustechie