Sponsored Content
Top Forums Shell Programming and Scripting update a oracle table using shell script Post 58962 by zazzybob on Monday 6th of December 2004 12:11:01 PM
Old 12-06-2004
Have you attempted to code any part of a solution? Have you searched this site for similar solutions? Have you googled for assistance?

Please do not ask for complete answers to your problems. If you show that you have done some work yourself to solve the problem then people would be more willing to help.

Cheers
ZB
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle... (3 Replies)
Discussion started by: sveera
3 Replies

2. Shell Programming and Scripting

updating a column in oracle table using shell script

Hi friends, i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql STATUS is the variable declared in the .profile =============================== if sqlplus <<END... (3 Replies)
Discussion started by: sveera
3 Replies

3. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

4. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies

5. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies

6. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

7. UNIX for Dummies Questions & Answers

How to Update DB table from txt file using CRONJOB in Unix Shell Script

Hi Experts, can guide how we can Update a Database Table using a txt file source Using Unix Shell Scripts. What are the Cron Jobs codes can written to Update DB table. txt file contains record like data. US 09/03/2012 User DocType DocID. these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies

8. Shell Programming and Scripting

How to update a Oracle table through shell scripting?

My Code is get_week_date() { `sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF SET ECHO OFF SET FEEDBACK OFF SET PAGES 0 SET SERVEROUTPUT ON SET VERIFY OFF SET TRIMSPOOL ON (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'... (2 Replies)
Discussion started by: karthick.cho
2 Replies

9. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
smhassist(1M)															     smhassist(1M)

NAME
smhassist - check System Management Homepage configuration problems and recommend solutions SYNOPSIS
DESCRIPTION
is a command-line utility that checks SMH installation and configuration problems and recommends solutions. checks for common SMH instal- lation problems, daemons that must be running but are not running, ports that must be open but are not, and other configuration problems. At the end of the check, generates a report of the problems and recommendations to resolve the problems. Some of the checks done are: 1. swverify on HPSMH 2. swverify on Apache and required patches 3. swverify on WBEM and OpenSSL 4. check for hpsmh group and users 5. check for 2301 and 2381 ports 6. check for smh daemons A detailed output of is logged to the file at /opt/hpsmh/logs/smhassist.log checks and recommends solutions to problems in SMH only. does not perform checks on SMH plugins (applications within SMH) such as fsweb, pdweb, kcweb, and so on. Options supports the following options -v Print verbose output FILES
/opt/hpsmh/logs/smhassist.log - Stores detailed log output of smhassist SEE ALSO
smhstartconfig(1M), hpsmh(1M). AUTHOR
was developed by Hewlett-Packard. smhassist(1M)
All times are GMT -4. The time now is 09:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy