05-30-2008
Sorry I forgot to post sh -x part of the code .
#sh -x add_VW_grants.shl
+ [[ -n 1 ]]
+ return
+ cat dim_provider.sql
+ grep -i create view
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_MBR_PRI
+ cut -d . -f2
new_vw=PROVIDER_MBR_PRI
+ echo PROVIDER_MBR_PRI
PROVIDER_MBR_PRI
+ cat dim_provider.sql
+ grep -i GRANT
+ grep -i PROVIDER_MBR_PRI
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_MBR_PRI/VW_PROVIDER_MBR_PRI/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_REF
+ cut -d . -f2
new_vw=PROVIDER_REF
+ echo PROVIDER_REF
PROVIDER_REF
+ cat dim_provider.sql
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ grep -i GRANT
+ grep -i PROVIDER_REF
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_REF/VW_PROVIDER_REF/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ + echo OPSDM002.PROVIDER_SRVC
+ cut -d . -f2
new_vw=PROVIDER_SRVC
+ echo PROVIDER_SRVC
PROVIDER_SRVC
+ cat dim_provider.sql
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ grep -i GRANT
+ grep -i PROVIDER_SRVC
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ sed -e s/PROVIDER_SRVC/VW_PROVIDER_SRVC/g dim_provider.sql
+ 1> dim_provider.sql1
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
+ read f1 f2 f3 f4 f5 f6 f7 f8 f9
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
There is a requirement that i need to replaced a pattern by another pattern in all the files in my entire file system. there are 1000s of file in the system. let the pattern is "calcuta". i have to replace this pattern by "kolkata" in all those files which contain "calcuta".
I am only able to... (12 Replies)
Discussion started by: palash2k
12 Replies
2. Shell Programming and Scripting
Hi,
I have file 1.txt with following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433
**
**
**
In file 2.txt I have the following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies
3. Shell Programming and Scripting
Hi all,
I'm looking for some help. I have a file (very long) that is organized like below:
>Cluster 0
0 283nt, >01_FRYJ6ZM12HMXZS... at +/99%
1 279nt, >01_FRYJ6ZM12HN12A... at +/99%
2 281nt, >01_FRYJ6ZM12HM4TS... at +/99%
3 283nt, >01_FRYJ6ZM12HM946... at +/99%
4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies
4. UNIX for Dummies Questions & Answers
Hi I'm a newbie in unix and I'm having trouble in creating a script. I want to search for a pattern '_good' and insert new lines that contains '_bad', '_med', '_fail' while also ensure that the line contains _good is removed
here some of the data
UPDATE SCHOOL SET GRADE =... (1 Reply)
Discussion started by: sexyTrojan
1 Replies
5. Shell Programming and Scripting
Hi
I am having a code snippet
grant permission to all user
sts|ln|uSe|PSG
sajncht|se|Use|PPSPSG
psg|ln|use|TSPSG
sts_user.Me revoke
I need to change all occurance of use (uSe,Use,use) with USE. I am using the following sed command for this
sed 's//USE/g' s_sample.txt
Output: (7 Replies)
Discussion started by: sudeep.id
7 Replies
6. Shell Programming and Scripting
'Hi
I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match.
Which option is to be used to exclude the line containing the pattern?
sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies
7. Shell Programming and Scripting
The sample file:
dept1: user1,user2,user3
dept2: user4,user5,user6
dept3: user7,user8,user9
I want to match by '/^dept2.*/' but don't want to have substring 'dept2:' in output. How to compose such regex? (8 Replies)
Discussion started by: urello
8 Replies
8. Shell Programming and Scripting
Hello Everybody,
I need a help in the below pattern matching and replacement issue
I have a file : emp.txt
21356 suresh 12/12/2012
23511 ramesh 11/06/2011
31456 biswajit 09/08/2013
53134 archan 06/02/2009
first field:- employee id, 2nd field is name and third field is date of joining
... (10 Replies)
Discussion started by: shellscripting
10 Replies
9. Shell Programming and Scripting
Hi Techies,
I need a help in finding junk characters and remove them from a Datafile.
we have a file and it had crores of records like below
SGSN_MCC_MNC=01150
but sometime due to the issue with sending server we are getting some junk characters in the middle of data like below
... (6 Replies)
Discussion started by: mahi_mayu069
6 Replies
10. UNIX for Dummies Questions & Answers
Hi all!
Thanks for taking the time to view this!
I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern.
Example:
Drink a soda
Eat a banana
Eat multiple bananas
Drink an apple juice
Eat an apple
Eat multiple apples
I... (8 Replies)
Discussion started by: demmel
8 Replies
LEARN ABOUT DEBIAN
cvm-mysql
cvm-mysql(8) System Manager's Manual cvm-mysql(8)
NAME
cvm-mysql - MySQL module
SYNOPSIS
cvm-mysql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE
The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the
MySQL default).
CVM_MYSQL_DEFAULT_GROUP
If set, the module will read connection default options from the named group in the defaults file as above
CVM_MYSQL_HOST
The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed.
CVM_MYSQL_USER
The MySQL login ID to connect as. If not set, the invoking user is assumed.
CVM_MYSQL_PASS
The password for the above user.
CVM_MYSQL_DB
The database name, must be set.
CVM_MYSQL_PORT
The port number for the TCP/IP connection (only used if the server is not local).
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_MYSQL_PWCMP (optional)
The password comparison module to use.
CVM_MYSQL_SOCKET
The path to the socket that should be used for connections to a local server.
CVM_MYSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).
SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-mysql(8)