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 (3 Replies)
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 Replies)
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.... (1 Reply)
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... (15 Replies)
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... (2 Replies)
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... (1 Reply)
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"
... (2 Replies)
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 Replies)
Hi,
I have a file pk.txt which has table related data in following format
TableName | PK
Employee | id
Contact|name,phone,country
I have another file desc.txt which lists datatype of each field like this:
Table|Field|Type
Employee|id|int
Contact|name|string
Contact|country|string... (7 Replies)
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... (4 Replies)
Discussion started by: metallica1973
4 Replies
LEARN ABOUT DEBIAN
sql::statement::termfactory
SQL::Statement::TermFactory(3pm) User Contributed Perl Documentation SQL::Statement::TermFactory(3pm)NAME
SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances
SYNOPSIS
my $termFactory = SQL::Statement::TermFactory->new($stmt);
my $whereTerms = $termFactory->buildCondition( $stmt->{where_clause} );
my $col = $termFactory->buildCondition( $stmt->{col_obj}->{$name}->{content} );
DESCRIPTION
This package implements a factory to create type and operation based terms. Those terms are used to access data from the table(s) - either
when evaluating the where clause or returning column data.
The concept of a factory can be studied in Design Patterns by the Gang of Four. The concept of using polymorphism instead of conditions is
suggested by Martin Fowler in his book Refactoring.
METHODS
buildCondition
Builds a condition object from a given (part of a) where clause. This method calls itself recursively for predicates.
AUTHOR AND COPYRIGHT
Copyright (c) 2001,2005 by Jeff Zucker: jzuckerATcpan.org Copyright (c) 2008-2010 by Jens Rehsack: rehsackATcpan.org
Portions Copyright (C) 1998 by Jochen Wiedmann: jwiedATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.10.1 2011-02-01 SQL::Statement::TermFactory(3pm)