Search Results

Hi!

here is the sql statement within shell script

---------
---------

sqlplus system/manager@SID @myreport

myreport passes 3 values so how should i store it in a varibale.
i know i have...

thank you so much!

Hi guyz,

Posting a thread after a long time.

I want to pass two variables to unix shell script from sql script.

Note: I am calling sql script from unix script. sql script has 2 variables one...

thanks for the reply.

I am not getting what you guys have explained probably bcoz i am jst a beginner.

Once again i am making my question clear. how to add null value to a file?

just wanna...

Hi everybody,

How to add null values in unix file?

This is what was asked to me in an interview.

yes i want this o/p:
Input Rec # 150 Client: BGARx No: 7713043 Fill Date: 20070627

to remove blank lines what i did was
cat abc.txt|grep -v "^$" >xyz.txt
but the blank line doesnt go away.
...

A big thank you to vgersh99!

@cassg

look at this" Error: (W)Submit Date after Fill Date(SUBMIT-DATE)"

this error is due to after i.e, why i chose after if i choose error then it will list...

@cassj

Thank you for the way you have presented. just awesome!

There are blank lines present between records as i have displayed.

suppose there are 100 records.

out of that 50 records are errored out due to various reasons.
ex:

Input Rec # 80 Client: BGA Rx No: 7820730 Fill Date: 20070629
Error:...

its not working!

thanx for the quick reply.

dude!

there are lines without any error too. If i do that then i will have records with error and without any error merged together. My goal is to catch record id of...

Hi Everyone.

I want to get all the lines above the word error. Note some records dont have error.
ex

Input Rec # 2384 Client: BGA Rx No: 0735845
...

Hi everyone,
$ more abcdefg.ksh
abcdef
alpha beta gamma
abcdef
abcdef
lmnop
$ wc sachin1.ksh
5 7 132 abcdefg.ksh
...

thanx porter

I am using putty.
Also on my 19inch monitor if message is appearing in one line then on 14inch it appears in two lines. Is there any settings that i need to do so that there is consistency.

thanx porter and rest of the guys for the reply but i really cant understand you porter. It's toooooo technical.

porter i am new to unix so i really cant understand what you are asking.

in simple way i would say at command prompt i am echoing that line.

i am displying it on my screen.

suppose if want to echo "USER DOESNT EXIST"

i want "USER DOESNT EXIST" TO HAVE A FONT SIZE OF 15.

can any one tell me how to set the font size in unix?

Hi Everyone!

I just want to know how to set $HOME.
I cant see $HOME in my profile.

Below is my profile.



export PATH=.:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/mai...

Thanx porter but in this case i would like to use if then instead of case. Damn! two many cases. lolz

if test $b -ne [0-9]
then
echo "\n\n\n\tPassword reset has been done successfully"
else
echo "\n\n\n\tAn error occurred"
fi

i want to check whether $b is non-numeric so how to do that?

thank you very much porter. It was 'I' that wasted my hour. Seriouly debugging sucks when you have couple of hundreds lines of code. once again thanx

korn shell

If [ "$a" != "" ]
then
update_smartcare_user_password "$u_id"
else
echo "Not a database user"
fi

i get this error
Syntax error at line *** : `then' is not expected.
what...