Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with loop in ksh script
Top Forums Shell Programming and Scripting Help with loop in ksh script Post 302919367 by varun2327 on Tuesday 30th of September 2014 07:58:32 PM
Old 09-30-2014
Here is the code

Code:
#!/bin/ksh

while IFS= read -r line
do


export create_txt="CREATE TABLE";
export END_TXT=");";
export OUTPUT_TXT=output.txt;
rm -f output.txt;
while read line
do

temp1=`echo $line | cut -d" " -f1,2`;
TBL_NM=`echo $line | cut -d" " -f3`;

if [[ $temp1 == $create_txt ]]
then
  echo "CREATE TABLE ${TBL_NM}" >> ${OUTPUT_TXT};
  else if [[ $line == $END_TXT ]]
  then
    echo ") INDEX " >> ${OUTPUT_TXT};
awk '/CREATE UNIQUE INDEX/,/)/ {
 if(/CREATE UNIQUE INDEX|\(/) {
  next
 }
 if (!/\)/){
  A=A $NF
 }
 else{
  X=$NF
  gsub(/TABLE_|;/,"",X)
  print "" X "_PI"
 }
}' input_text.txt >> ${OUTPUT_TXT};
awk '/CREATE UNIQUE INDEX/,/)/ {
 if(/CREATE UNIQUE INDEX|\(/) {
  next
 }
 if (!/\)/){
  A=A $NF
 }
 else{
  X=$NF
  gsub(/TABLE_|;/,"",X)
  print "(" A "); \n \n"
 }
}' input_text.txt >> ${OUTPUT_TXT};


awk -v '/CREATE UNIQUE INDEX/,/)/ {
 if(/CREATE UNIQUE INDEX|\(/) {
  next
 }
 if (!/\)/){
  A=A $NF
 }
 else{
  X=$NF
  sub(/;/,"",X)
  print "COMMENT ON TABLE " X " AS \047PK=," A "; \047; \n \n"
 }
}' input_text.txt >> ${OUTPUT_TXT};


done < input_text.txt

break;

done < input_text.txt

---------- Post updated at 07:58 PM ---------- Previous update was at 07:55 PM ----------

Aia,
Sorry, it was a typo...I used "while" in small letters and also used space between '=' and 'read'.

Thanks,
V
This User Gave Thanks to varun2327 For This Post:
Corona688
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh "while" loop within a csh script

I'm no unix pro for sure, but I have programmed enough other languages to usually get the job done in unix when I have to. I'm currently trying to automate a manual diagnostic process. One of the steps in the manual process generates a file of text output. The next step is running a small... (4 Replies)
Discussion started by: bschnair
4 Replies

2. Shell Programming and Scripting

ksh while loop

hi all, got this silly problem and i just can't seem to make sense of the error message its is saying 1400: cannot open. its my first time at writing a while loop but tried all sorts to get it working without success. #!usr/bin/ksh integer max=1400 set file="afilename" integer i=1 ... (3 Replies)
Discussion started by: scriptingmani
3 Replies

3. Shell Programming and Scripting

import var and function from ksh script to another ksh script

Ih all, i have multiples ksh scripts for crontab's unix jobs they all have same variables declarations and some similar functions i would have a only single script file to declare my variables, like: var1= "aaa" var2= "bbb" var3= "ccc" ... function ab { ...} function bc { ... }... (2 Replies)
Discussion started by: wolfhurt
2 Replies

4. Shell Programming and Scripting

For loop in ksh..Please help..

Hi ALL, I need to take some command line arguments for my script and then want to run a function for each argument.I thought of using for loop as below, but its not working , can some one please help... #!/bin/ksh lpar1=$1 lpar2=$2 lpar3=$3 lpar4=$4 lpar5=$5 echo "$lpar1" >>lpar.txt echo... (4 Replies)
Discussion started by: prashant43
4 Replies

5. Shell Programming and Scripting

KSH Script -- loop and data copy question

I am trying to write a script that will allow me to train others with commands that I run manually by only allowing the exact command before continuing onto the next set of commands. Here is where I come into an issue. I have changed the directories for this post. Software we run creates files... (2 Replies)
Discussion started by: hurtzdonut
2 Replies

6. Shell Programming and Scripting

for loop in awk script using ksh

Guys, I am new in awk , I face problem while i try to use for loop in awk, I am using ksh, i am trying to set a for loop which runs as man times as the records in a file , the for loop like for(a=1;a<=5;a++) is working in my awk script but the one i need is not working :wall: for example ... (8 Replies)
Discussion started by: djahmed
8 Replies

7. Shell Programming and Scripting

Setting a variable in a while loop (.ksh script)

Hello Everyone, I'm still trying to grasp many concepts in .ksh scripting, one of them being variables inside loops. My problem is the following: * I'm trying to set a variable inside a while read loop to reuse it outside of said loop. My lines are the following :... (13 Replies)
Discussion started by: jimmy75_13
13 Replies

8. Shell Programming and Scripting

explain while loop in ksh shell script

#!/bin/ksh log=ABCl log=EFG log=HIJ i=0 while <------ what is the meaning of ($i - lt 3) do print ${log} (( i=i+1 )) done (1 Reply)
Discussion started by: Bperl1967
1 Replies

9. Shell Programming and Scripting

Aix .ksh for loop script.

Hi, I'm trying to write a for loop to run through a list of servers and for each server copy a file to a backup file. But I can't seem to get it to run through my server list. It work for individual servers, please see below. #!/bin/ksh SSH_USERID=khcuser webservers="server1 server2" ... (2 Replies)
Discussion started by: elmesy
2 Replies

10. Shell Programming and Scripting

ksh for loop

Any reason why this thing doesn't works in Korn Shell for (( expr1; expr2; expr3 )) do ..... ... repeat all statements between do and done until expr2 is TRUE Done Rgds, TS (4 Replies)
Discussion started by: targetshell
4 Replies

LEARN ABOUT OSX

create_tablespace

CREATE 
TABLESPACE(7)						   SQL Commands 					      CREATE TABLESPACE(7)

NAME

       CREATE TABLESPACE - define a new tablespace

SYNOPSIS

       CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'

DESCRIPTION

       CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in
       the database cluster.

       A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects  (such
       as tables and indexes) can reside.

       A  user	with  appropriate  privileges can pass tablespacename to CREATE DATABASE, CREATE TABLE, CREATE INDEX or ADD CONSTRAINT to have the
       data files for these objects stored within the specified tablespace.

PARAMETERS

       tablespacename
	      The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces.

       username
	      The name of the user who will own the tablespace. If omitted, defaults to the user executing the command. Only superusers can create
	      tablespaces, but they can assign ownership of tablespaces to non-superusers.

       directory
	      The directory that will be used for the tablespace. The directory must be empty and must be owned by the PostgreSQL system user. The
	      directory must be specified by an absolute path name.

NOTES

       Tablespaces are only supported on systems that support symbolic links.

       CREATE TABLESPACE cannot be executed inside a transaction block.

EXAMPLES

       Create a tablespace dbspace at /data/dbs:

       CREATE TABLESPACE dbspace LOCATION '/data/dbs';

       Create a tablespace indexspace at /data/indexes owned by user genevieve:

       CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';

COMPATIBILITY

       CREATE TABLESPACE is a PostgreSQL extension.

SEE ALSO

       CREATE DATABASE [create_database(7)], CREATE TABLE [create_table(7)], CREATE INDEX [create_index(7)], DROP TABLESPACE [drop_tablespace(7)],
       ALTER TABLESPACE [alter_tablespace(7)]

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