Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script using loop
Top Forums Shell Programming and Scripting Shell script using loop Post 302436114 by aigles on Friday 9th of July 2010 08:29:25 AM
Old 07-09-2010
Have you tried to use /usr/xpg4/bin/awk or gawk ?

A commented and revised version of the script :
Code:
awk '

#
# Input file #2
#

NR==FNR {                               # Select records from input file #1
   tbl[$1]++;                           #   Memorize table in in array tbl
   next;                                #   Proceed next record
}

#
# Input file #2
#

/ALTER TABLE/ {                         # Select ALTER TABLE records
   tbl_name = $3;                       #   Table name
   getcols = (tbl_name in tbl ? 1 : 0); #   Set getcols flag if table
                                        #   + found in array tbl
   next;                                #   Proceed next record
}

! getcols {                             # Select record if getcols flag not
                                        # + set to 1
   next ;                               #   Proceed next record
}

/^ADD/,/;[[:space:]]*$/ {               # Select ADD records (from ADD to
                                        # + record endig with ";"
   f = ($1 ~ /^ADD/ ? 3 : 1);           #   IF ADD record, column name is field 3
                                        #   + otherwise field 1;
                                        #   + column format is field f+1
   sub(/).*/, ")", $(f+1));             #   Remove chars after ) ending column def
   printf "%-12s %-12s %s\n", tbl_name, $f, $(f+1); #  Output table name,
                                                    #  + column name and format
}

' alisha.nam alisha.tmp

"name" file (alisha.nam):
Code:
tbla
tblc

"temp" file (alisha.tmp) :
Code:
ALTER TABLE tbla
ADD  ( cola1  VARCHAR2(11),
       cola2  VARCHAR2(12)  );

ALTER TABLE tblb
ADD  ( colb1  VARCHAR2(21),
       colb2  VARCHAR2(22)  );

ALTER TABLE tblc
ADD  ( colc1  VARCHAR2(31),
       colc2  VARCHAR2(32),
       colc3  VARCHAR2(32)  );

Output:
Code:
tbla         cola1        VARCHAR2(11)
tbla         cola2        VARCHAR2(12)
tblc         colc1        VARCHAR2(31)
tblc         colc2        VARCHAR2(32)
tblc         colc3        VARCHAR2(32)

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

If then else loop in Shell script

Hi Following is the code . When I give input as Bangalore,its dospalying Welcome to Hitech City. But say , if I select Delhi or US, its not displaying the corresponding message. Its still says Welcome to Hitech City. Seems that it not entering in the elif part. Please suggest. #!... (4 Replies)
Discussion started by: pankajkrmishra
4 Replies

2. Shell Programming and Scripting

Help with loop in a shell script

I just want to write a little script, that reads the lines from a file, echos somthing in a new tmp.file and then do some commands whith the tmp.files. while read -r line do echo "TEST=" > tmp.$$ echo "$line" >> tmp.$$ any_command < tmp.$$ done < $INPUTFILE But I think I have to... (2 Replies)
Discussion started by: elifchen
2 Replies

3. Shell Programming and Scripting

Loop in shell script

Dear experts, i am quite new to shell script please any one can help me in this regard i would like write a script which takes input in the form >./Test.sh a,10,b,20,c,30... in this way i can give input in any number which is not constant in the end through loop i want to... (3 Replies)
Discussion started by: vin_pll
3 Replies

4. Shell Programming and Scripting

while loop problem in c shell script

Hi all, i write a script c shell set i = 1 while ( $i <= $#array ) echo "$array" @ i++ end i want to set it to i = i +2 in that statement . Can anybody help me? ---------- Post updated at 02:46 PM ---------- Previous update was at 02:35 PM ---------- anybody not how to solve it??? (2 Replies)
Discussion started by: proghack
2 Replies

5. Shell Programming and Scripting

Help with IF statement with loop Shell Script

Hello I am very new to shell and I bought some books and trying to learn it. I started trying to write a script that will take a number and count it down to 1 with commas in between. This number can only be one argument. If lower than one or higher than one argument it sends an error message. ... (4 Replies)
Discussion started by: zero3ree
4 Replies

6. Shell Programming and Scripting

Avoiding For Loop in Shell Script

I am looking to a solution to the following problem. I have a very large file that looks something like this: Each group of three numbers on each line are three probabilities that sum to one. I want to output the maximum for each group of three. So desired output would be: or... (6 Replies)
Discussion started by: hydrabane
6 Replies

7. Shell Programming and Scripting

Help with the For loop shell script

Hi, I have multiple files in a directory. Each file will have a header.I have to check if any of the files has 0 rows other than the header then I have to delete the files. Here “ Empty file” in my case means a file has header information but no data. I have to delete such files. If the file... (2 Replies)
Discussion started by: ganesnar
2 Replies

8. Shell Programming and Scripting

Loop in shell script

Hi Friends, I have a file. the content is as below: file1: /A/B/C/abc.txt 2013-07-28 13:50:00,2013-07-31 01:00:00,5,710 /A/B/C/xyz.txt 2011-09-21 18:30:00,2013-07-30 06:15:00,15,65135 2009-11-09 18:00:00,2011-09-02 09:00:00,5,12345 2013-07-28 13:50:00,2013-07-31 01:00:00,5,710 ... (2 Replies)
Discussion started by: vsachan
2 Replies

9. Shell Programming and Scripting

Speed up the loop in shell script

Hi I have written a shell script which will test 300 to 500 IPs to find which are pinging and which are not pinging. the script which give output as 10.x.x.x is pining 10.x.x.x. is not pining - - - 10.x.x.x is pining like above. But, this script is taking... (6 Replies)
Discussion started by: kumar85shiv
6 Replies

10. Shell Programming and Scripting

Shell script use two variable in for loop

I want to create a shell script to add a user and modify its comment field mentioned in a file. 1. File value:- username comment field value xyz123 xyztesting abc123 abctesting def123 deftesting 2. i am using below loop to create user... (2 Replies)
Discussion started by: Anil
2 Replies

LEARN ABOUT SUSE

alter_group

ALTER 
GROUP(7)							   SQL Commands 						    ALTER GROUP(7)

NAME

       ALTER GROUP - change role name or membership

SYNOPSIS

       ALTER GROUP groupname ADD USER username [, ... ]
       ALTER GROUP groupname DROP USER username [, ... ]

       ALTER GROUP groupname RENAME TO newname

DESCRIPTION

       ALTER  GROUP  changes  the  attributes  of  a  user group.  This is an obsolete command, though still accepted for backwards compatibility,
       because groups (and users too) have been superseded by the more general concept of roles.

       The first two variants add users to a group or remove them from a group.  (Any role can play the part of either a ``user'' or  a  ``group''
       for  this purpose.) These variants are effectively equivalent to granting or revoking membership in the role named as the ``group''; so the
       preferred way to do this is to use GRANT [grant(7)] or REVOKE [revoke(7)].

       The third variant changes the name of the group. This is exactly equivalent to renaming the role with ALTER ROLE [alter_role(7)].

PARAMETERS

       groupname
	      The name of the group (role) to modify.

       username
	      Users (roles) that are to be added to or removed from the group.	The users must already exist; ALTER GROUP does not create or  drop
	      users.

       newname
	      The new name of the group.

EXAMPLES

       Add users to a group:

       ALTER GROUP staff ADD USER karl, john;

       Remove a user from a group:

       ALTER GROUP workers DROP USER beth;

COMPATIBILITY

       There is no ALTER GROUP statement in the SQL standard.

SEE ALSO

       GRANT [grant(7)], REVOKE [revoke(7)], ALTER ROLE [alter_role(7)]

SQL - Language Statements					    2010-05-14							    ALTER GROUP(7)
All times are GMT -4. The time now is 02:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy