Search Results

Appreciate the responses, as I am new to KSH .. its helping me learn a lot.
So here is what I modified it.
#!/bin/ksh

while read line
do
echo $line | awk '{
if($1=="ALTER" &&...

Thanks Guru,
just another change needed.

var1, var2, var3 are the variables i need to set from within the awk and use them outside the awk, How can I do that?

I was thinking if AWK can do this. Please suggest.

ALTER TABLE <tab_nm> ADD <col_nm > <col_type>;

From the statement about can I extract content in < > into a variable, like:

var1=tab_nm...

I was thinking if AWK can do this. Please suggest.

ALTER TABLE < > ADD < > < >;

Can I search for this pattern and extract content between the < > into a variable, like:

var1=tab_nm...

Thanks Agama, I can build other conditions using this template.
Could you please share the database_connect function too?

Agama, I have updated the other thread(Pass a DDL statement to a KSH script) with some more details.
Appreciate if you could help me to get this working.

Thanks for replying.

Let me try to be more specific.

Here is the Scenario / requirement
When we submit the DDL to the DBA, DBA implement those DDLs to the database.
=> We need to automate...

I need to pass a DDL statement into a ksh script & parse the statement.

What is the best way to pass a DDL statement into a KSH script.

---------- Post updated at 09:28 AM ---------- Previous...

How can I extract table name from the different DDL statement like
ALTER TABLE
CREATE TABLE etc
Basically I have to parse thr the any of the DDL statement and verify if that DDL statement is...