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

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

make_socksfc

MAKE_SOCKSFC(8) 					      System Manager's Manual						   MAKE_SOCKSFC(8)

NAME

       make_socksfc -  Generates frozen configuratyion file for SOCKS clients

SYNOPSIS

       make_socksfc [infile [outfile] ]

DESCRIPTION

       make_socksfc reads in a plain-text configuration file for the SOCKS clients and produces a frozen configuration file as the output.

       Both  arguments	are  optional. The default for infile is /etc/socks.conf; the default for outfile is /etc/socks.fc. You may specify infile
       while omitting outfile, but you cannot specify outfile without also speficying infile.

       The contents of the frozen configuration file is essentially the memory image of the parsed input file. Using the frozen configuration file
       can reduce the start-up delay of the SOCKS client programs since they no longer have to parse the file contents.

       When  the  SOCKS  client starts, it always looks for the frozen configuration file /etc/socks.fc first . If that file is not found, it then
       tries to use the plain-text configuration file /etc/socks.conf. If you use frozen configuration, you  must  remember  to  run  make_socksfc
       every time after you modify the plain-text file or the SOCKS clients will continue to use the frozen file of a previous configuration.

       To find out the contents of a frozen configuration file, use dump_socksfc.

FILES

       /etc/socks.fc, /etc/socks.conf

SEE ALSO

       dump_socksfc(8), socks.conf(5), socks.fc(5)

AUTHOR

       Ying-Da Lee, yingda@esd.sgi.com or yingda@best.com

								    May 6, 1996 						   MAKE_SOCKSFC(8)

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