All Shell method (using a disc workfile).
Adjust $max for the number of tables per copy statement. Assumes that your list of tables contains an exact multiple of $max lines.
Note that the script does not contain any "for x in ..." statements because the example in post #1 is liable to break with 100,000 arguments!
Code:
input=files.txt
output=output.txt
>output.txt
workfile=workfile.$$
touch "${workfile}"
max=5 # Tables per copy statement
counter=0
node=0
cat ${input} |while read line
do
#
node=$((${node} + 1))
if [ $node -gt 3 ]
then
node=1
fi
#
counter=$((${counter} + 1))
if [ ${counter} -gt $max ]
then
if [ -s "${workfile}" ]
then
cat ${workfile} >> ${output}
> ${workfile}
fi
counter=1
fi
if [ $counter -eq 1 ]
then
echo "copy table_name from path $line on node${node}," >>${workfile}
continue
fi
if [ $counter -eq $max ]
then
echo " $line on node${node} delimiter '|';" >> ${workfile}
continue
fi
echo " $line on node${node}," >> ${workfile}
done
if [ -s "${workfile}" ]
then
cat ${workfile} >> ${output}
fi
rm ${workfile}
./scriptname
copy table_name from path abc.uml on node1,
abd.uml on node2,
xxx.uml on node3,
yyy.uml on node1,
ccc.uml on node2 delimiter '|';
copy table_name from path fff.uml on node3,
ggg.uml on node1,
eee.uml on node2,
lll.uml on node3,
kkk.uml on node1 delimiter '|';
copy table_name from path dbd.uml on node2,
ltm.uml on node3,
opo.uml on node1,
ikj.uml on node2,
plp.uml on node3 delimiter '|';
Last edited by methyl; 04-30-2012 at 10:44 AM..
Reason: paste issues
I'm new to utilities like socat and netcat and I'm not clear if they will do what I need.
I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes.
I'm using Cygwin bash on Windows 10.
My... (3 Replies)
Hello all,
I am facing a weird issue while executing a code below -
#!/bin/bash
cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset
sh UKBA_publish.sh UKBA 28082015 3
if
then
echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below.
#masterscript.sh
./callingscript.sh
echo $fileExist
#callingscript.sh
echo "The script is called"... (2 Replies)
I am using blow script :--
#!/bin/bash
FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not
if
then
# echo "process found"
exit 0;
else
echo "process not found"
exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table... (0 Replies)
04-28-2012
