Search Results

Hi ,
I have this crontab job which is not able to write a db2 command output to a file . The output file comes out to be of file zero and it sends me wrong alerts .

cat...

Using [0-9] repeatedly worked :)

Thanks a LOT folks ![COLOR="#738fbf"]

---------- Post updated 01-14-10 at 03:00 PM ---------- Previous update was 01-13-10 at 04:01 PM ----------

It throws an error with -r

sed -r 's/7[0-9]{8}//g' XSITEMAP_CP_REQUEST_sample.DEL
sed: illegal option -- r

---------- Post updated at 01:07 PM ---------- Previous update was at 01:06 PM...

I tried the solution here but it is not changing anything in the file .

Before using sed

cat XSITEMAP_CP_REQUEST_sample.DEL
"/-Mazda-Hitches/720000300-710040783-20005332-600022614.car"...

Hi ,
I have this file having thousands of records in it . I want to remove every 9 digit number starting with 7 in it . The few lines from the sample file are
...

I tried to run the same script as higher id ( id added to sudoer file ) and that works fine .
It worked when i had /tmp as the path before i wrote the full path too .

Thanks , it works now :)

Hi ,
I have a crontab job that is trying to write a file and the read it . But the crontab is not able to create any file . But when i run the script as shell then it runs fine . could you...

It is working !

Thanks a lot sir :)

Hi ,
I am trying to run this script in crontab but I get errors. When I run it explicitly like ./monitor_tblsp from another location then it runs fine . I am messing somewhere with paths but...

Thanks a lot !
I appreciate your knowledge and you !!

Perderabo , It works with ./Q.shl !!
Thanks

why it doesn't work other way ?

Yes , I am in the same directory where this file resides . Also I have given chmod 777 on the Q.shl

Thanks ,

Hi ,
I am new to solaris world but worked in unix for a while . I have this solaris box version 8 .I am trying to run a simple unix file . Q.shl

cat Q.shl
#!/bin/ksh

db2 get connection...

My bad . i was in bit haste to reply earlier . I had to test it in multiple scripts .

The newer script is giving weird result .

The comparison part is failing and db2look is skipping. After...

thanks a lot . This is working fine now :)

Solution was in some thread .

cat word_replace.shl
#!/bin/ksh

for y in `ls *.sql`;
do sed "s/UHCDEV01/UHCETL01/g" $y > temp; mv temp $y;
done

found it .
...

Hi ,
I have bunch of sql file which contain UHCDEV01 in them . I want to replace all the UHCDEV01 with UHCETL01 in all the files. I have written this code which shows correct output on sh -x...

Hi ,
I am running this script ( pasting only error code ) to generate some ddl definition for tables . But what I want is to break out of the db2look part when the base_table is not like...

Thanks a lot !

Ok this is last question of the day from my side .
I have this file and I want to replace the last letter " , " with " ) " .
The input file is

#cat zip.20080604.sql
CONNECT TO TST103 ;
SET...

You ROCK Mr Franklin !

Hi ,
Unix.com has been life saver for me I admit :)
I am trying to extract a paragraph based on matching pattern "CREATE TABLE " from a ddl file . The paragraphs are seperated by blank line ....

Thanks a lot Franklin , With few modifications to the code . its working all right now .

Appreciate your time and effort !!!

Daya

Rubin ,
The sql file that I provided here is just one of the many sql files that I have related to schema OOPSD002. Your solution will solve only one file but not the others. Ok , Here the...

#cat OPSDM002.dim_provider.20080602.sql
CONNECT TO TST103 ;
SET CURRENT SCHEMA OPSDM002 ;

CREATE TABLE OPSDM002.DIM_PROVIDER (
PROV_ID CHAR(7) NOT NULL ,
...