Search Results

That worked just fine!

Thanks :b:

---------- Post updated at 04:11 PM ---------- Previous update was at 04:10 PM ----------



That also worked just fine!

Thanks :b:

Yeah, it works, thanks! :b:

I noticed that some of my files have owner prefix for tables like this:


-- Configure test table connections ---
table10 owner.table_name_10 table10...

Here are the contents of my file:

cat -vet temp.lst


-- Configure test table connections ---$
$
table10 table_name_10 table10 table_name_10$
table20 table_name_20 table20 table_name_20$...

Thanks, same issue. It replaces all words in the last columns on all lines (irrespective of whether there is the word "table_name" in those lines).

---------- Post updated at 02:28 PM ----------...

It replaces all words in the last columns of all lines when there is no word "table_name" in those lines.

I tried something like '%s/\(.*[ ]\)\(.*\)/\1test_\2/'

It doesn't work.

That will replace first occurrences of "table_name". I don't want to touch the second column (first occurrence). Only change the values in the last column (second occurrence).

---------- Post...

I have lines like:

table10 table_name_10 table10 table_name_10
table20 table_name_20 table20 table_name_20
table30 table_name_30 table30 table_name_30


I want to change the second...

Figured it out, added a redirect at the end and it works just fine now!.

Thanks once again Scrutinizer, appreciate the prompt responses.

Thanks, almost there ... it lists the files on screen. I need them saved to a file, so that they can be executed as a script.

Something like:

ls create_*.txt > create_master.txt

Works beautifully well !... :b: Thanks, Scrutinizer.

How can I get all the new files created (create_*.txt) in a list?

Thanks, Scrutinizer. But I am getting this error when running it:

awk: syntax error near line 6
awk: illegal statement near line 6
awk: syntax error near line 14
awk: illegal statement near...

Hi,

I have 2 input files:

File 1:

echo Name > create_Name.txt
echo Group /dir/group, Name >> create_Name.txt

File 2:

Name AAA BBB CCC
group A B C
dir A1 B1 C1...

T1 is a sub branch of T4 just like T3. So it needs to appear along with T3. So final sort has to be this way:


T5 | 1
T4 | 2
T1 | 3
T3 ...

Not sure, this is what I am getting:


!. srt1.sh
T1 | 1
T5 | 1
T4 | 2
T1 | 3
T3 | 3
T4 | ...

Thanks, it works, but it prints this way :

T1 | 3
T2 | 1
T3 | 3
T4 | 2
T5 | 1

Can we print it without altering the original sort order?

Also, the first column, with values greater...

I have a test file with the following 2 columns:

Col 1 | Col 2
T1 | 1 <= remove
T5 | 1
T4 | 2
T1 | 3
T3 ...

Yeah Chubler, something in our envirorment does behave weird. If I replace "ps -ef" with "jobs" it just doesn't go beyond the first 6 sqls. Anyways, "ps -ef" works fine for me, occasional bad number...

Oh ok, got it about || ... forgot about it ... :)

For me "ps -ef|grep "sqlplus -s"|grep -v grep|wc -l" is showing the number of sessions running correctly. It shows 6 processes or less when the...

@Chubler, you are right, I was trying to find the number of sql processes running and assigning that to cnt variable. Here's the code:

while read sql
do

stuff "sqlplus"

let...

@chubler, is there a quick way to trap "ksh: cnt=: bad number" errors?

My code is working just fine, just a couple of places it throws this bad number error, I need to see what value is being...

Thanks Chubler for the code. I ran it a couple of times and I got the same issue. Hits a long running sql script and ignores the others.

This is the output I was getting:

NUM= 0
[1] ...

methyl, you are absolutely wrong about this: "A sequence of commands written in sqlplus is called a program."

There were always sql scripts and always will be. A set of sql commands run through...

Wow, that was a super fast response! thank you ...

System is SunOS 5.10 Generic_144488-06, shell is ksh.

Yeah, I tried with "wait" before but I found that since "wait" waits for the...

I need to process 50 sqlplus scripts which are listed in a text file. I need to develop a shell script that'll read this file and run these sqlplus scripts. At any point of time, the number of...