Search Results

Thank you RudiC. I am an amateur with awk and had no real idea where to start from. Your solution worked and I am trying to understand the logic behind it now. Thank you for your time

Hi,

We have a file that has a structure like this:

H10 1 2 3
D10 1
D20 1 2 3
D20 3 4 5
D20 4 5 6
D10 2
D20 1 2 3
D20 3 4 5
D20 4 5 6
S10 10
H10 1 2 3
D10 1
D20 1 2 3
D20 3 4 5
D20...

I definitely check for $?. My conundrum was more on the lines of capturing why the error occurred. :)

My issue pertains to earlier posts like
exit unix script after sqlerror in procedure - dBforums (http://www.dbforums.com/oracle/1098501-exit-unix-script-after-sqlerror-procedure.html)
SQLPLUS Error...

It was that easy!? Thanks a ton!:b:

Hi,

We have created a script that would accept the an indicator as a parameter and archive files present in a directory. The indicator would drive what the name pattern of the files to be archived...

Hi All,

We have a table that has to store around 80-100 million records. The table is partitioned by a column called Market Code. There are 30 partitions each corresponding to one MRKT_CD.

The...

Awesome! Thanks:)

just did this


$n=`grep -n "Version=" filename | cut -d ":" -f1`
$echo $n
10681
$awk 'NR>$n' filename
awk: 0602-562 Field$() is not correct

Any idea why I got that error?

Hi All,

We get a file from our client for processing everyday. We have to start reading the file from the line after the line that says "version=".
My idea was to grep and find the line...

It's the same. job_jobname is only an alias I'm using in the forum so as to not mention the actual name. Sorry for not mentioning it earlier

dsadm 21299440 37224484 0 10:49:08 - 0:00 phantom DSD.RUN jobname. 0/0/1/0/0

Let me give you a perspective on the issue. We have an ETL process that executes for around 1 hour. The script basically checks for the presence of this process and exits at the instant when the ETL...

Where can I see the trace logs after running the script with the -xv tags?

---------- Post updated at 02:50 AM ---------- Previous update was at 01:52 AM ----------

The trace doesn't seem to...

We do not have pgrep. How does pgrep help? Why could this be happening?

We are trying to design a flow so that an ETL job shouldn't start until the previous job completes. The script we have written is


while [ `ps -ef|grep "phantom DSD.RUN job_jobName"|grep -iv -e...

May I know what the $ in test$ achieves?

@Hanson - What I meant was, if a file already consists of the name of the file, then I do not want to replace anything within that file

saved my day! Thank you!:b::)

---------- Post updated at 04:30 AM ---------- Previous update was at 04:25 AM ----------

How do I ignore the case of my search string? Also I want to exclude...

I am very new to awk and also this forum. Kindly guide me as to where exactly should i be placing my search and replace terms in the code you've provided. Thank you for your time.

Hi,

We have a folder that has files in the following structure

abc.sql
def.sql
efg.sql
.
.
.
xyz.sql


I have to find a certain string (say "test") in each file and replace it with the...