Search Results

Thank you. Everything is working as expected now.

Thanks
Ajay

Thanks Jim for your reply. print is not working and so I changed it to printf, but it is not printing it out correctly:

Below is the statement that I see in tmp.sql:
SELECT...

Thanks for your reply. My bad, I had a typo in the password and so throwing that error.

But it is now failing with below error:
SELECT pi.memberid||,||pi.poolid||,||m.mediagtype from poolsitems...

Hi,
I am trying to get the rows(First step is to get the poolid's and then second step run a loop to get the output based on each pool id and third connection is to get the member id and pool id...

Thanks Aia for your help.

Thanks
Ajay

Thanks Don. It works exactly as per my requirement.

Thanks
Ajay

Hi Don,
Sorry for the confusion. Please find my input below:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<iwgroups>
<nextid value="128">
</nextid>
<iwgroup...

Hi,
Need help with parsing xml data in unix and place it in a csv file. My xml file looks like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<iwgroups>
<nextid...

Thank you. My files had ^M characters in the file and so it didnt work.
After removing the ^M characters, it is working fine now.

Thanks
Ajay

Sorry about the names:

output2.csv


http://www1.abc.com/cms/slp/2/Flowerbomb http://www1.abc.com/cms/slp/2/Everlon-Jewelry http://www1.abc.com/cms/slp/2/Sofft...

Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..

output3.csv:
flowerbomb
everlon-jewelry
sofft
steve-madden...

Hi,
Sorry for not posting my script. Here's my ftp script:
ftp_script=$(
ftp -n $HOST 2>/dev/null <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
cd development/Mission\...

Hi,
I am trying to write a script where I need to pull any file if the date is from yesterday. Can you please help me on how to check the dates for the files on the remote server?

Please let me...

Hi,
I am trying to write a code, where it reads the jobnames from a file and checks for the logs in the server. If the log is not found in the first server, then it will ssh to the 2nd server and...

Thanks for the replies. They are working.

---------- Post updated at 12:51 PM ---------- Previous update was at 10:35 AM ----------

Now I have my data in variables.. Like duration, volume,...

Hi,
I am trying to place the contents of a .CSV file to an array, but not sure how to do that.

Here is my .CSV file content:

App,SLA,Job name,Avg start time,Avg run...

Hi,
Sorry for the delay in replying.
Yes, There will be many jobs in a application , and I am placing the first job and the last job of the application in my config file. The time mentioned in...

Our batch starts at 5PM and runs till next day ~1pm.
We manually give the batch process date which is $1.(We should be able to check the batch status for previous days as well and so passing it as...

This is the entire code:

#!/bin/ksh
conf=BS.config
Appl=""
st_dt=""
end_dt=""
status=""
job_start_date=""
job_start_time=""
today=$1
exec<$conf
while read job
do
set -A Arr...

I used the below code:

echo $today $job_start_date | awk '
BEGIN {
d[1]= 31
d[2]= 28
d[3]= 31
d[4]= 30
d[5]= 31
d[6]= 30
d[7]= 31
...

Hi,
To get the batch status, I will need to check if the particular job started after 5PM. if the job start time is before 5 pm, then it means that the job has not started for this particular date....

Hi,
We are using CA7 scheduler to trigger the jobs in UNIX. To check the status, we are opening the mainframe window and checking the status of the jobs. Is it possible to check the status from...

But I need the format to be in xls as I need to do some analysis on that excel. Is it not possible to keep the format as excel and delete the column?

---------- Post updated 02-23-11 at 12:22 AM...

Hi,
I am saving this data in excel sheet, and when I delete a column from excel and then uploading it to unix box, the paste is not working properly.
Code that im using:
paste output.xls...

Yes, that command is not working on command line also. .
I used that cut option and it is now working fine.

Thank you.