Search Results

Hi,
I have a basic question regarding scripting.
I want to execute one script(child script) from another script(master script) and pass some values as well.

There are certain function present...

Thanks. Unsetting worked

Thak you all for the wonderful input. It sings like a bird. But here comes the major problem.

Whenever i use IFS in my script, sqlplus doesnot run and throws me an error saying that no such file...

Hi,

Variable=MKT1,MKT2,MKT3 and so on

i am trying to seperate MKT1,MKT2,MKT3 and store each in a variable.
the values in variable1 may vary. I am using bash

No, i donot want to use the array variable inside sqlplus

Hi Srini,
i tried using your method. Wheneever i am using IFS=",", sqlplus is throwing me error. If i comment out IFS=",", then sqlplus runs without any problem. Has this something to do with the...

i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.


IFS=","
declare -a Arr=($Variable1);

SQLPLUS=sqlplus -s...

Hi anbu23

thanks for the reply. I tried this code as an example beore applying the same logic in my work. It worked fine. :)
But when i incorporated the same logic in my work, it is throwing...

Hi,

Variable1 = MKT1,MKT2,MKT3,MKT4

Now i want to store each of these value seperated by comma to a array and access each of the values. Also find out number of such values seperated by...

Hi anbu23,

I am putting your statement in a function.
It doesnot work if i put your statement in a function because i am using $5 after awk statement. It tries to find the argument present in...

Hi,

i want to extract a number from a statement.

03/07/14 00:58:41 CRPr::CopyTotable inserted 3501 rows into table

Now i want to assign 3501 to a variable. This number may change every...

Hi I would like to embed a sql query in my shell script.
Also, before any the sql query is executed, i would like to validate username and password.

Updating the code
if [[ ${STAGE} = "ABC" ] && [ ${nxtstgcnt} -eq 1 ]] || [[ ${STAGE} = "XYZ" ] && [ ${nxtstgcnt} -eq 2 ]]
then
line 1
else
line 2
fi


Dont forget to use code tags next time!

I am getting systax error whenever i try to use the following piece of code

if [[ ${STAGE} = "ABC" ] && [ ${nxtstgcnt} -eq 1 ]] || [[ ${STAGE} = "ABC" ] && [ ${nxtstgcnt} -eq 1 ]]
then
line 1...

Hi,

here are few lines present in the logs. I want to grep on Error and print few lines before and after Error word is found

line1
Line2
Line3
Error
Line4
Line5
Line6
Line7

I want...

Hi,

I am quite new to shell scripting.
I am facing challenge in retrieving a specific number from a sentence from the log. the number is random and changes everytime in the log.
For example, ...

Hi,

I am a tester and i am trying to create a batch job.

My dev has created few scripts which performs specific task. Manually we need to run these script one by one. We can only run...