Search Results

It worked fine. but how to put the sql output into the xls file.

Now How do i send it to excel sheet.
I have done some part but dont know how to append the sql output

FILENAME:...

Thanks Scott it works now. let me know how to write the output of this statement in a file as well

Scott Can you please be more specific. Do I have to use another script like sqlscript. I am just a begginer so asking. Dont have much idea.

echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on";

Select statement is mentioned below
echo...

#!/usr/local/bin/bash

set -vx

/prod/HotelierLinks/palaceLink/bin/PalacefilesWait /prod/HotelierLinks/palaceLink/bin/prodEnvSetup 03212013 &
if [ $? ne 0 ]
then
echo "fatal error:...

We are using AIX version not GNU. Provide the solution for AIX for date increment where --date is not supported.

for i in {1..10}
do
date +"%d/%m/%y" --date="-$i days ago"
done


but getting the error

date: 0551-402 Invalid character in date/time specification.
Usage: date [-u] [+"Field...

Need to increment the date from "currentdate + 90days" inside the for loop (i=1 to i=50)

INPUT FILE1:

Fri Jan 25 12:13:59 EST 2013:threadWebContainer : 624:com.travimp.hotelierlinks.abba.service.RequestHandler.requestService(String, ITICSDataSet): hotelMakeNewReservation response: ...

Input File:
5081
2058
175
8282
2358
7347
6612
3459
END OF INPUT FILE

I need to know how to calculate minimum,maximum,average of the values in the file and also what percentage is the...

I am trying to find the minimum maximum and average from one file which has values

Received message from [https://www.demandmatrix.net/app/dm/xml] in [939] milliseconds.
Received message from...

TIME_DATE_SPLIT=`date +%Y-%m-%d-%p`

TIME_CHECK="`(echo $TIME_DATE_SPLIT | cut -d "-" -f 4)`"

#######FUNCTION START########
PREVIOUS_DATE_FUNCTION()
{

date '+%m %d %Y' |
{
read MONTH...

I need help to store the value returned from the function to one variable and then use that variable.
PREVIOUS_DATE_FUNCTION()
{

date '+%m %d %Y' |
{
read MONTH DAY YEAR
DAY=`expr "$DAY" -...

But when i am using this
PREVIOUSDATE="`(PREVIOUS_DATE_FUNCTION)`" tempfile=CANCEL_FILE_$PREVIOUSDATE

I am not getting the output correct...i am only getting
tempfile=CANCEL_FILE_

but i...

no please tell me how to save the value in variable and use it, Thanks..!!

+ PREVIOUSDATE=2012-06-26
+ echo 2012-06-26
2012-06-26

There is one function to calculate previous day value and then touch one file with that date.The problem is i am getting the previous day value but not able to store it in other variable and use it....

This is what i am doing:

TIME_DATE_SPLIT=`date +%Y-%m-%d-%p`

TIME_CHECK="`(echo $TIME_DATE_SPLIT | cut -d "-" -f 4)`"

TIME_CLOCK="AM"

if [ $TIME_CHECK -eq $TIME_CLOCK ]; then
echo...

Please help me with this:

I need to compare two values in if condition in shell script but its goes always to else condition:
TIME_CHECK=PM
TIME-CLOCK=PM

if [ $TIME_CHECK -eq $TIME-CLOCK ];...

AIX saturn 3 5 00044BB7D600

I tried both but it gives me error:
date +%Y-%m-%d-%p -d yesterday
Error:date: 0551-402 Invalid character in date/time specification.
Usage: date [-u] [+"Field Descriptors"]

date --date '1 day...

Hi,

I need help to display the yesterday date in format mentioned below:
2012-06-26-PMI tried this but it displays current date: `date +%Y-%m-%d-%p`

it works very closely but gives all the response say for error code=1035 and errorCode=1010 and etc but i need only Link_ConfID for errorCode=1008.I think u made it general for all "errorCode="

Thanks but is it possible to refine it more like instead of printing the whole Cancel request if we can just give the linkConfID=BTCCo2yvMB from the request and the whole error code response.

For...

Hi,
I need a help to search a pattern and print the multiple lines between them.

Input file:
Tue May 29 12:30:33 EDT 2012:threadWebContainer :...