Search Results

[/COLOR]

If u have Database access, you can simply fetch details using:
select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_TYPE in ('TABLE', 'VIEW', 'PROCEDURE', 'PACKAGE') order by...

If u are using Bash, Please try this one ..

user_option=`echo $user_input | tr '[:lower:]' '[:upper:]'`

Before executing your main script,
Just add the one more if condition for TimeStamp checking.

If [ $CurrentTimeStamp == "00:10 MST" ]
then
exit
echo "Execution of...

First Check `mailx` service is enable on your server or not ?
If enable, U want database Query output in mail or Attachments in mail, confirm?

Once again thanks for your detailed explanation.

Thank you, it's working fine.

But why we are giving the extra -- for creation of the -file.txt .

Hi All,

I am not able to create any file name start with "-" hyphen. Any logical issue with these types of files creation in Solaris.

==============================
bash-3.00$ touch...

Thanks for your support.
"-a" option will work successfully. But we are not able to fix the "-a suffixlength". Any dynamic updation of the suffixlength for every time.

Other integration applications are not supported for the large size files. For that purpose we will split the large file into small once's and pass it.

We are using the SunSolaris5.10

I think splitting 2 times is the double work & there is no manual activity also. script will run in the cronjob.

Hi All,

I have a parent file with 10 million records. I want to split the parent file in to child files.

Each child file contains 5000 records.

I am using the following command for...

Dear All,

I want to decode the one of the file field.

Input file:
9393939393|999|2009-02-20 00:00:01|2||4587|2007-02-28 00:00:01|0
9393939393|2001|2009-02-20 00:00:01|2||4587|2007-02-28...

Thanks to all,

I got the output from tr command..

cat i/p file |tr '|' ' '|awk '{print $1"||"$3"||"$5"|"}'

Dear All,

I have the following input file. I want to replace data with null values.

I/P File:
9022334455|2008-12-06 06:10:21|2|Error@@@|esoo8erp|
9024334432|2008-12-06...

Check the script for execution permissions. Crontab required the execution permission..

I am asking not for me & not for the XManager Terminal host.

Suppose any new guy joined in the project, then how to control of script execution to that guy in the above case.

Dear All,

I have a shell script. which has the read, write & execute permissions.
I am entering from X-Manager Console.

OS Details are:
SunOS P382XLRTY 5.9 Generic_118558-34 sun4u sparc...

It will give the .pdf file. But it is not in openable format.

At the start of the post "I will write the code. That is also give the same .pdf file"

That is also not in openable format..

bash-2.05$ bash -c 'x=OK.;echo ${x%.}'
OK
bash-2.05$

bash-2.05$ ps -p $$
PID TTY TIME CMD
6934 pts/51 0:00 bash

Still it will give the same error message (: bad substitution)..

---------------------- Failed Output-------------------------
bash-2.05$ cat HelloPDF.sh

cd $HOME

for name in `ls -1 *.doc`
do
mv $name ${name%.doc}.pdf
done

bash-2.05$ sh...

REMOTESERVER=97.253.00.001
REMOTEPATH='/usr'
LOGIN='oracle'
PASSWORD='oracle'
cd $LOCALDIR
ftp -n $REMOTESERVER << INPUT_END
quote USER $LOGIN
quote PASS $PASSWORD
hash
bin
cd $REMOTEPATH...

Hi All,

I want to Rename/Convert all the .doc files in to .pdf format.
I am using the following Script. But the final output is not proper.

##########################################
cd...

################# FTP #############################

USER_LOG='/u01/UAT/scripts/scriptslog/in_ftp_pushing.log'
`touch $USER_LOG`
REMOTESERVER=97.253.17.142 # Your...

Hi Hema,

I had given choice to u only. U know oracle - - I am only executing the simple Stored Procedure{ODS_SP_REMOVE_PRE_SUB_DUP(OUT_STATUS, OUT_MSG)}. Instead of SP, You can use the simple...