Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need a help in shell script
Top Forums Shell Programming and Scripting Need a help in shell script Post 302820221 by ranga27 on Wednesday 12th of June 2013 11:09:20 AM
Old 06-12-2013
Quote:
Originally Posted by Yoda
Ok, check if this modified code helps:
Code:
awk '
        /export/ {
                c += 1
                sub ( /;/, X, $2 )
                T[c] = $2
        }
        /where/ {
                q = $0
                sub ( /.*where /, X, q )
                Q[c] = q
        }
        !/export/ && !/where/ {
                q = $0
                sub ( /.*where/, X, q )
                Q[c] = Q[c] ? Q[c] " " q : q
        }
        END {
                printf "%s=", "Tables"
                for ( i = 1; i <= c; i++ )
                {
                        printf "%s", ( i == c ? T[i] RS : T[i] OFS )
                }
                for ( i = 1; i <= c; i++ )
                {
                        if ( Q[i] )
                        {
                                printf "%s=%s:\"where %s\"\n", "Query", T[i], Q[i]
                        }
                }
        }
' OFS=, file


I executed the script and it worked fine , only one modification needed..

It prints :

Code:
Query=SYS.TesT8:"where not ( ( OUY LIKE 'H%') or (OUY LIKE 'A%') or (OUY LIKE 'Z%') or  (OUY LIKE 'OP%') or (OUY LIKE 'JJ%'); "

i dont need the ";" at the end...

Output:

Code:
Query=SYS.TesT8:"where not ( ( OUY LIKE 'H%') or (OUY LIKE 'A%') or (OUY LIKE 'Z%') or  (OUY LIKE 'OP%') or (OUY LIKE 'JJ%')"

Thanks
Last edited by Scott; 06-12-2013 at 01:16 PM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Run a shell script from Perl script in Parent shell?

Hi Perl/UNIX experts, I have a problem in running a shell script from my perl script (auto.pl). I run the perl script using perl auto.pl from the shell prompt The shell script picks the files in "input" folder and procesess it. The shell script blue.sh has this code. export... (16 Replies)
Discussion started by: hifake
16 Replies

2. Shell Programming and Scripting

invoking a shell script inside cgi shell script

Hi, I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input. I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies

3. Shell Programming and Scripting

How to use ssh execute other shell script on other host (shell script include nohup)?

i want use ssh on the host01 to execute autoexec.sh on the host02 like following : host01> ssh host02 autoexec.sh autoexec.sh include nohup command like follwing : nohup /home/jack/deletedata.sh & after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Discussion started by: orablue
1 Replies

4. Shell Programming and Scripting

call another shell script and pass parameters to that shell script

Hi, I basically have 2 shell scripts. One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system. Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn. ... (2 Replies)
Discussion started by: sunrexstar
2 Replies

5. Shell Programming and Scripting

Correct shell script to Call One shell script from another shell script

Hi All, I have new for shell scripting. Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat. I need to call this script at server2(my working server) and execute at server2 . Please let me know how to build the... (5 Replies)
Discussion started by: Vineeta Nigam
5 Replies

6. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies

7. UNIX for Dummies Questions & Answers

How to write Config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

8. Shell Programming and Scripting

How to write config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

9. Shell Programming and Scripting

Pass C shell array to another C shell script(csh) and shell(sh)

Dear Friends, Please help me on this my script name is send.csh In this i have written the statement like this set args = ( city state country price ) I want to pass this array to another c shell called receiver.csh. and i want to use it in this c shell or how to pass to... (2 Replies)
Discussion started by: SA_Palani
2 Replies

10. UNIX for Beginners Questions & Answers

Shell script newbie- how to generate service log from shell script

Hi, I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service) lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Discussion started by: xiaogeji
3 Replies

LEARN ABOUT OPENSOLARIS

unshare_nfs

unshare_nfs(1M) 					  System Administration Commands					   unshare_nfs(1M)

NAME

       unshare_nfs - make local NFS file systems unavailable for mounting by remote systems

SYNOPSIS

       unshare [-F nfs] pathname

DESCRIPTION

       The  unshare  command makes local file systems unavailable for mounting by remote systems. The shared file system must correspond to a line
       with NFS as the FSType in the file /etc/dfs/sharetab.

OPTIONS

       The following options are supported:

       -F    This option may be omitted if NFS is the first file system type listed in the file /etc/dfs/fstypes.

FILES

       /etc/dfs/fstypes

       /etc/dfs/sharetab

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWnfssu 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nfsd(1M), share(1M), attributes(5)

NOTES

       If the file system being unshared is a symbolic link to a valid pathname, the canonical path (the path which  the  symbolic  link  follows)
       will be unshared.

       For  example,  if  /export/foo is a symbolic link to /export/bar (/export/foo -> /export/bar), the following unshare command will result in
       /export/bar as the unshared pathname (and not /export/foo):

	 example#  unshare -F nfs /export/foo

       For file systems that are accessed by NFS Version 4 clients, once the unshare is complete, all NFS Version 4 state  (open  files  and  file
       locks)  are  released and unrecoverable by the clients. If the intent is to share the file system after some administrative action, the NFS
       daemon (nfsd) should first be stopped and then the file system unshared. After the administrative action is complete, the file system would
       then be shared and the NFS daemon restarted. See nfsd(1M)

SunOS 5.11							    6 May 2003							   unshare_nfs(1M)
All times are GMT -4. The time now is 01:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy