Search Results

Hi All,

I want to establish a ODBC connection to a database from linux and query the tables of a database.

Please let me know how I can achieve this.

Thanks and Regards
Nagaraja...

Thanks for your reply!!

I was able to achieve it using ssh command in quotes as you suggested.

Hi All,

Need to connect to target host and execute a command and connect back to source host to continue with next set of command execution.

Is there a utility/command using which we can...

This is the command I use in linux to send mail

sendMail -dst nagaraja@xyz.com (nagaraja@xyz.com) -msg "TestMail" -bodyText "Data refresh not done"

-t option is used to get the to, cc and...

No Hanson,

only sendMail is configured in linux machine. mail, mailx etc are not working.

Thanks
Nagaraja

Hi All,


When I send a mail using sendMail command it sends a mail to the concerned with few people in cclist. Not sure where cc list is configured.

I want to change that cc list...

Hi All,

Have scheduled a cron entry to run once a week.


0 0 * * 1 /export/home/nz/history_load/prod/LoadManager.sh >>/dev/null 2>&1


Not sure, why this job did not got triggered last...

Thanks. It is working fine..

I have a text file which has the content starting with "....."
Not able to filter out lines staring with "....."

Is there anything wrong with grep stagement ??


.....processing table 2 of...

Hi All,

We have a shell script(ODS_Load)which loads the data from perticular flat file to oracle table invoking sqlplus based on the parameter.

When we execute the script(ODS_Load)...

a delete script which reads number of days, location and file type as the parameters from the config file.

First, it has to check SET UP VALUES.

For example,

if set up value is...

Hi All,

I want to read all lines after a perticular string {SET UP VALUES}apprears in the file.

SET UP values contains direcory, number of days and file type.

Step1: Read all lines below...

Thanks both of you..!!

Hi All,

I am using below code to delete files older than 2 days. In case if there are no files, I should log an error saying no files to delete.

Please let me know, How I can achive this.
...

Ahamed,

Thanks for your answer. I will check this option.

Chubler,

tar -V gives below results.


tar: option requires an argument -- V
Try `tar --help' for more information

...

We execute script to tarr files as normal user. Normal user doesn't have permission to append file to existing tarr file, since tarr files are owned by root user.

Even though script is creating...

Hi all,

1.
Is it better to use perl modules to achive date related caclulations or connect to database from app server and perform date related caclulations and spool it a file and disconnect...

Thanks for your response radoulov..!!

I can convert system date(date) to YYYYMMDD format but not sure how to convert start date and end date to this format. Can you please help on this?
...

Thanks Skrynesaver for your response..!!

I supply date in DD-MON-YYYY format. I am not aware of using epoc in UNIX. Could you please help me on the same?

Note: Don't want to use perl to...

Hi All,

I am entering StartDate and EndDate as parameters to script. Want to have an check saying, "If StartDate is greater than EndDate then don't execute the script".

Pseudo Code:


if...

This is how I did it.

If tar file does not exists use below command.
tar -cvf <tar-file-name.tar> < files to be added>

If tar file exists then use.
tar -rf <tar-file-name.tar> < files to be...

Praveen, Thanks for your response.

Changed 2000 to 1900 and code works fine.

Thanks Murphy..!!

Hi Murphy.

Small flaw I found while executing this script. If I give dates of a month then it is working fine but if I execute this script for the period of 2 months then getting wrong output....

Thanks murphy for your response..!!

I copied and pasted this code and named the scipt as archive_perl.pl and executed the script. Got some error. Can you please tell me what is wrong here?

...

Hi All,

Want to get all dates and Julian week number for that date between the start date and end date. How can I achive this using perl?
(To achive above functionality, I was connecting to the...