Search Results

Here is the 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
...

I used the below loop condition

WHILE IFS=read -r line
do

#Complete Code for one instance as explained above

done < input.txt

When I executed the above, it kept on running by overwriting...

Hi, I am new to UNIX. I am working on a script where it takes the input and produces a desired output and it works fine for one instance.

Input(One Instance):
CREATE TABLE TAB1
(
COL1,
COL2...

Hello Disedorgue,
In the similar case above, I need to write the output differently if I find a combination of columns. If the input table has a combination of columns(foo & boo), then the output...

Thank you so much disedorgue.

Hello Disedorgue,
I am getting the following error while I run the above statements

awk: cmd. line:2: switch ($0) {
awk: cmd. line:2: ^ syntax error
awk: cmd. line:4: case...

Hello Disedorgue, I tried the similar approach for one other script and couldn't able to get the desired result. Could you please check this.

Input:
CREATE TABLE TBL_NM
(

COL1 ...

Hello disedorgue, one last question...

For the same input, if I want multiple comments one with (COL1, COL2) and also the same comment for individual columns, how can I do it.

For example, for...

Thank you so much. You rock!!

Thank you disedorgue. It worked the way I wanted.

But one last question. How can I pass a variable for DB_NM instead of hard coding every time?

I tried to set something like this before awk and...

Don,
Please find my answers here, I could have been more specific earlier. I am working on automating few scripts and as part of that, I need to have this.

1. No there could be less or more...

Hi, I am new to UNIX and need your help in formatting the below input command to the desire output

Input:
CREATE UNIQUE INDEX XPKTABLE1
(
COL1,
...