05-20-2008
missing in script
Hi ,
I am trying to make this change work in my script but its not working.The idea is to grep for "CREATE VIEW" and then change view name from orig to VW_orig. but the problem comes when there is no schema prefix to the view name . the code I am using is
#!/bin/ksh
#####################################################
# use cut and awk to refine the view name
######################################################
if grep "CREATE VIEW" dim_copy.20080516.sql
then
sed -e '/^CREATE VIEW/s/\(.*\.\)\(.*\)/\1VW_\2/' dim_copy.20080516.sql > dim_copy.20080516.sql1
cat dim_copy.20080516.sql1 > dim_copy.20080516.sql
elif grep "CREATE VIEW" dim_copy.20080516.sql | grep -v OPSDM002
then
cat dim_copy.20080516.sql | grep -i "CREATE VIEW" | grep -v OPSDM002 | awk '{print "OPSDM002."$3 }' > dim_copy.20080516.sql1
sed -e '/^CREATE VIEW/s/\(.*\.\)\(.*\)/\1VW_\2/' dim_copy.20080516.sql1 > dim_copy.20080516.sql
else
echo "file does not have view in it "
fi
I have sample file like this
#grep -i view dim_copy.20080516.sql
CREATE VIEW MOUSE_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR FROM DIM_COPY;
CREATE VIEW OPSDM002.TABLE_UHC AS SELECT DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR,LOAD_DT,WEEK_NBR_YR,SEQ_NBR
After i run that script my result comes like this
#grep -i view dim_copy.20080516.sql
CREATE VIEW MOUSE_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR FROM DIM_COPY;
CREATE VIEW OPSDM002.VW_TABLE_UHC AS SELECT DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR,LOAD_DT,WEEK_NBR_YR,SEQ_NBR
But I want result like follow :
CREATE VIEW OPSDM002.VW_MOUSE_UHC AS SELECT DT_SYS_ID ,DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR FROM DIM_COPY;
CREATE VIEW OPSDM002.VW_TABLE_UHC AS SELECT DAY_ABBR_CD,LST_DAY_MO_IND,MONTH_NBR,FULL_DT,DAY_NBR,LOAD_DT,WEEK_NBR_YR,SEQ_NBR
So the first view name is not changed ......
Any help ........
10 More Discussions You Might Find Interesting
1. Red Hat
I use CenOS Enterprise 5. I've removed existing apache2 then installed the latest apache2. Everything is fine except the original /etc/rc.d/init.d/httpd is now missing. Without this file I can't add httpd to service (commands like "service httpd start" does not work). I have tried to link... (2 Replies)
Discussion started by: aixlover
2 Replies
2. Shell Programming and Scripting
The below script gives error: Missing ]
#!/bin/csh
set MAX=15
set PATTERN='dtsession'
set NUM=`ps -eaf | grep -c $PATTERN`
echo "No of dtsession = "$NUM
if
then
echo 'Quota exceeded permissible limit'
echo 'sending mail...............'
mail hiten.r.chauhan@gmail.com<<EOF
... (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies
3. Shell Programming and Scripting
I just put together a script for work that will essentially automate the migration of our Windows fileserver to my newly created Debian based SAMBA server.
My script will create the necessary directories then copy the data over to my new server, after that it will set the ACL's by using... (3 Replies)
Discussion started by: binary-ninja
3 Replies
4. Shell Programming and Scripting
If file exists then do stuff else do nothing...
#! /bin/sh
if
then
rm /home/dudemgnt/public_html/fileserver/Checks/Daily/RefundChecksDaily.csv
cat /home/dudemgnt/public_html/fileserver/Checks/Daily/RefundChecksDaily*.txt|sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' >... (4 Replies)
Discussion started by: Astrocloud
4 Replies
5. Shell Programming and Scripting
I want to use case statement to find the range of missing sequence in my directory which it has some few ( dat & DAT ) files
my directory /home/arm/my_folder/20130428 contains :
f01_201304280000.DAT
f01_201304280001.DAT
f01_201304280003.DAT
f02_201304280000.dat
f02_201304280002.dat... (2 Replies)
Discussion started by: arm
2 Replies
6. SuSE
Hello,
This is a programming question as well as a suse question, so let me know if you think I should post this in programming.
I have an application that I compiled under opensuse 12.2 using g77-3.3/g++3.3. The program compiles and runs just fine. I gave the application to a colleague who... (2 Replies)
Discussion started by: LMHmedchem
2 Replies
7. Shell Programming and Scripting
Hello to all,
I have show below a file separated by commas. In first column has numbers where the last number is 13.
1,4
2,6
3,7
5,2
6,5
7,5
8,65
9,10
11,78
13,2
What I want to know is which numbers are missing from 1 to 13 (in this case 13 is last number in column 1). My real... (17 Replies)
Discussion started by: Ophiuchus
17 Replies
8. Red Hat
I am trying to install VirtualBox on RHEL 5 but I need the 32 bit version for 32 bit Windows. When I run yum I get the following:
sudo yum localinstall /auto/spvtg-it/spvss-migration/Software/VirtualBox-4.3-4.3.2_90405_el6-1.i686.rpm
Loaded plugins: fastestmirror
Setting up Local Package... (13 Replies)
Discussion started by: gw1500se
13 Replies
9. Shell Programming and Scripting
Gents,
Can you please help me to fix the following script in order to get complete data as desired. I am missing some data in output.
the complete input file is attached.
The script I am using is
awk '{\
status=substr($0,91,2)\
ind=substr($0,26,1);\
... (10 Replies)
Discussion started by: jiam912
10 Replies
10. UNIX for Beginners Questions & Answers
I have no idea how to write ksh script, but i'm really in need of help with this. I using fedora 30 and in attempt of runnig attached script i getting those errors, i solved first error by removing excess bracket, but i do not know what should i do with other. Pls sorry for trash post. (8 Replies)
Discussion started by: NullPtr
8 Replies