10-01-2007
Oh... Sorry. I should've mentioned that. nc is netcat. And AS is just a number associated with an IP address. It tells if the IP address belongs to a particular ISP or not...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to have an if statement in a script to run if there are certain processes running. Easiest way I can see to do this is to run a ps and grep the results based on what I am looking for:
$ ps -ef | grep wtrs
---
webtrend 5046 1 0 May 12 ? 0:28 /webtrends/versions/6.1/wtrs_ui... (6 Replies)
Discussion started by: LordJezo
6 Replies
2. Shell Programming and Scripting
Hi
I have a text file , contents are
Line1:field1,field2,field3,field4,field5,field6.......field20
Line2:field1,field2,field3,field4,field5,field6.......field20
Line3:field1,field2,field3,field4,field5,field6.......field20
....and so on...
I want to read this file and insert the data into... (4 Replies)
Discussion started by: Amruta Pitkar
4 Replies
3. Shell Programming and Scripting
ls -ld /path/to/dir1 path/to/dir2 | awk '{print $8}'
how to execute above script in IF ELSE Statement.
Pls iam new to Unix (1 Reply)
Discussion started by: laknar
1 Replies
4. Shell Programming and Scripting
In my ksh script, if the conditions of a if statement are true, then do nothing; otherwise, execute some commands.
How do I write the "do nothing" statement in the following example?
Example:
if (( "$x"="1" && "$y"="a" && "$z"="happy" ))
then
do nothing
else
command
command
fi... (3 Replies)
Discussion started by: april
3 Replies
5. Shell Programming and Scripting
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies
6. AIX
Hi All
I have a script which runs a piece of JOB. The jobs are in sequence and if it fails at a particular job I wanted it to be started from the point where it failed.
What I did I prepared two properties file one which contains the entire List of the JOBS which are to be executed and the... (5 Replies)
Discussion started by: Prashantckc
5 Replies
7. Shell Programming and Scripting
Hello All,
I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming.
I want to loop through multiple values in an array and for each value, I
want to select a row from the database.
following is the code written for it.
output="loop.csv" ... (8 Replies)
Discussion started by: arundhati_s
8 Replies
8. Shell Programming and Scripting
Hi friends,
I would like to get some help on the following requirement. I have a SQL file with following things,
select 1 from dual;
select user from dual;
select sysdate
from
dual;
BEGIN
PL/SQL Code
END;
/
This file will be saved as sql file. When I run my expected shell script,... (1 Reply)
Discussion started by: ssnair
1 Replies
9. Shell Programming and Scripting
Hi,
I am new to Shell Scripting, and I need to create nicknames for 600 tables in db2. I have the file names in a text file and i have to pass these table names to a shell script create nicknames in db2. Can some one please help me in this regard. (1 Reply)
Discussion started by: kamalanaatha
1 Replies
10. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT PHP
sql_regcase
SQL_REGCASE(3) 1 SQL_REGCASE(3)
sql_regcase - Make regular expression for case insensitive match
SYNOPSIS
string sql_regcase (string $string)
DESCRIPTION
Creates a regular expression for a case insensitive match.
Warning
This function has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged.
PARAMETERS
o $string
- The input string.
RETURN VALUES
Returns a valid regular expression which will match $string, ignoring case. This expression is $string with each alphabetic character con-
verted to a bracket expression; this bracket expression contains that character's uppercase and lowercase form. Other characters remain
unchanged.
EXAMPLES
Example #1
sql_regcase(3) example
<?php
echo sql_regcase("Foo - bar.");
?>
The above example will output:
[Ff][Oo][Oo] - [Bb][Aa][Rr].
This can be used to achieve case insensitive pattern matching in products which support only case sensitive regular expressions.
NOTES
Note
As of PHP 5.3.0, the regex extension is deprecated in favor of the PCRE extension. Calling this function will issue an E_DEPRECATED
notice. See the list of differences for help on converting to PCRE.
PHP Documentation Group SQL_REGCASE(3)