05-13-2011
Hey kumaran,
Thx for quick response.
now I want to call sqlplus in script and drop those tables.
Actually I'm using Netezza which is similar to oracle. Below is the code i'm trying but its not working.
NZCommand="nzsql -host <HOST> -db <DB_NM> -u <USER> -pw <PWD> -A"
$NZComamnd<<EOF
drop table ABC_"$x"_TBL
EOF
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi frind,
i="1"
while
do
echo "i is $i"
data_file=$HYP_ROOT/import/efcextr$i.txt
echo "$data_file"
i=`expr $i + 1`
done
This is woring finly in ksh but not in ksh.
in ksh it showing error
i=1: Command not found
i: Undefined variable
Kindly help me ...why it is showing the error... (1 Reply)
Discussion started by: deep_kol
1 Replies
2. Programming
i have created a script to insert 100K rows into mysql db.
But the forst line where i declare the variable is giving error. I am new to mysql. Can anyone help me in this?
the script is
======================================
DECLARE
c INT(10) := 54;
BEGIN
WHILE c <... (4 Replies)
Discussion started by: amitranjansahu
4 Replies
3. Shell Programming and Scripting
I recently installed Cygwin on my windows vista to practice on Linux\unix commands.
I am unable to do a simple task of declaring variables on the command prompt
I am trying:
$ vech=Bus
$ echo $vech
bash: vech : command not found
What am I missing? Do i need to add something to .bashrc?
... (1 Reply)
Discussion started by: erora
1 Replies
4. UNIX for Dummies Questions & Answers
hi to all,
i am trying to declare a variable as an integer in unix shell script. i search the web for a way to do it but it doesnt work.
i tried "define -i" and "declare" but that doesnt work.
if somebody knows another way to declare a variable as integer please help me.
thank you (2 Replies)
Discussion started by: omonoiatis9
2 Replies
5. Shell Programming and Scripting
Hi
I've few shell scripts which are responsible for triggering the continuous builds for a specific module. Each shell script is for a Module. Shell script has some module specific settings in the beginning and then it triggers the builds (which are nothing but some combination of Java programs... (2 Replies)
Discussion started by: kgsrinivas
2 Replies
6. Shell Programming and Scripting
I am trying to declare a variable like this
#!/bin/csh -f
set c_arg = $a $b $c
However, since i need it to declare before declaring $a ,$b or $c.
As of now i am getting an error which says $a not defined.
Is it possible to define a variable c_arg w/o interpreting the values $a $b $c (2 Replies)
Discussion started by: animesharma
2 Replies
7. Shell Programming and Scripting
how can i declare variable in perl.
for BLOCK in /sys/block/emcpow* (3 Replies)
Discussion started by: learnbash
3 Replies
8. Shell Programming and Scripting
Hi,
Here is the script i try to perform arithmetic operation in two variables .
git branch -r | while read brname ; do
REV_COMMITS=`git rev-list --count $brname`
echo "$brname has $REV_COMMITS"
(( TOTAL = TOTAL + REV_COMMITS ))
echo "in loop" $TOTAL
done
echo "total is " $TOTAL
... (3 Replies)
Discussion started by: greet_sed
3 Replies
9. Shell Programming and Scripting
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies
10. Shell Programming and Scripting
If I am running a bash command, and some awk getting the ethernet adapter on the local machine. It works fine. But if I will run it from the remote, it is EMPTY on echo and throwing error in grep.
Thank you
This work perfectly fine
$ f=`/sbin/ip a|grep 127.127 | awk '{print $NF }' ` ; ip... (2 Replies)
Discussion started by: kenshinhimura
2 Replies
SPLIT(1) FSF SPLIT(1)
NAME
split - split a file into pieces
SYNOPSIS
split [OPTION] [INPUT [PREFIX]]
DESCRIPTION
Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, ...; default PREFIX is `x'. With no INPUT, or when INPUT is -, read standard
input.
Mandatory arguments to long options are mandatory for short options too.
-a, --suffix-length=N
use suffixes of length N (default 2)
-b, --bytes=SIZE
put SIZE bytes per output file
-C, --line-bytes=SIZE
put at most SIZE bytes of lines per output file
-l, --lines=NUMBER
put NUMBER lines per output file
--verbose
print a diagnostic to standard error just before each output file is opened
--help display this help and exit
--version
output version information and exit
SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg.
AUTHOR
Written by Torbjorn Granlund and Richard M. Stallman.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for split is maintained as a Texinfo manual. If the info and split programs are properly installed at your site,
the command
info split
should give you access to the complete manual.
split (coreutils) 4.5.3 February 2003 SPLIT(1)