AIX SP update and Oracle interaction

4 More Discussions You Might Find Interesting

1. 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. UNIX for Advanced & Expert Users

oracle update not working

Hi, I have a oracle source with a field my_date =06/02/2009 I am trying to update the table to SYSDATE with a myscript.sql where I have UPDATE table set my_date=to_DATE(SYSDATE,'MM/DD/YYYY'); Now I try to run it with myupdate.SH script where I have sqlplus nolog @myscript.sql ...

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...

4. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

LEARN ABOUT DEBIAN

sbuild-update

SBUILD-UPDATE(1)						   Debian sbuild						  SBUILD-UPDATE(1)

NAME

       sbuild-update - update, upgrade, and clean an sbuild chroot with apt-get

SYNOPSIS

       sbuild-update  [-h|--help]  [-V|--version]  [--arch=architecture] [-u|--update] [-g|--upgrade] [-d|--dist-upgrade] [-c|--clean] [-a|--auto-
       clean] [-r|--autoremove] CHROOT1 [CHROOT2 [CHROOTn...]]
       sbuild-update -k|--keygen
       (DEPRECATED) sbuild-upgrade [-h|--help] [-V|--version] CHROOT1 [CHROOT2 [CHROOTn...]]
       (DEPRECATED) sbuild-distupgrade [-h|--help] [-V|--version] CHROOT1 [CHROOT2 [CHROOTn...]]
       (DEPRECATED) sbuild-clean [-h|--help] [-V|--version] [-c|--clean] [-a|--autoclean] [-r|--autoremove] CHROOT1 [CHROOT2 [CHROOTn...]]

DESCRIPTION

       sbuild-update runs apt-get inside the specified chroot performing  update,  upgrade,  dist-upgrade,  clean,  autoclean,	and/or	autoremove
       depending on the options specified on the command line.

       sbuild-upgrade,	sbuild-distupgrade,  and  sbuild-clean,  are  deprecated.  They  now simply run sbuild-update with the appropriate options
       (--upgrade or --dist-upgrade for sbuild-upgrade or sbuild-distupgrade respectively) along  with	whatever  arguments  were  passed  in  the
       scripts.

OPTIONS

   Actions
       -h, --help
	      Display this manual.

       -V, --version
	      Print version information.

       --arch=architecture
	      Update chroot for the architecture specified.

       -u, --update
	      Perform an apt-get update.

       -g, --upgrade
	      Perform an apt-get upgrade.

       -d, --dist-upgrade
	      Perform an apt-get dist-upgrade.

       -c, --clean
	      Perform an apt-get clean.

       -a, --autoclean
	      Perform an apt-get autoclean.

       -r, --autoremove
	      Perform an apt-get autoremove.

       -k, --keygen
	      Generate a GPG public/private key pair for self-signing local apt archives, used for installation of dependency packages.  Note that
	      this requires a significant amount of entropy (randomness) and may hang on systems with poor entropy sources, such as headless  sys-
	      tems  without direct user input.	In this situation, it is advisable to create the key on a trusted local system, and copy the files
	      to the build system by hand from /var/lib/sbuild/apt-keys/.

   Chroot selection
       CHROOT The chroot to use.  Note that 'o', 's', 't', 'u' and 'e' may be used as abbreviations for 'oldstable', 'stable', 'testing',  'unsta-
	      ble' and 'experimental', respectively.

EXAMPLES

       To update the unstable chroot:

       % sbuild-update --update unstable

       To upgrade the unstable chroot:

       % sbuild-update --upgrade unstable

       To clean the unstable chroot:

       % sbuild-update --clean unstable

       To perform an update, dist-upgrade, clean, autoclean, and autoremove for the unstable chroot:

       % sbuild-update -udcar unstable

AUTHORS

       Roger Leigh.
       Andres Mejia.

COPYRIGHT

       Copyright (C) 2006-2009 Roger Leigh <rleigh@debian.org>.
       Copyright (C) 2010 Andres Mejia <mcitadel@gmail.com>.

SEE ALSO

       sbuild(1), sbuild-apt(1),

Version 0.63.2							    18 Aug 2012 						  SBUILD-UPDATE(1)

AIX