use shell scripts to update tables from databases

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out...

2. Shell Programming and Scripting

What do I do in shell scripting to access ma databases from my system?

How do I go about programming my system? I have access to multiple data bases but no way to operate them

3. Shell Programming and Scripting

UPDATE COmmand post comparing 2 columns in 2 mysql tables

my queryis : select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1; But how should I update them? i used update statetment : Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1 Is this wrong?

4. Shell Programming and Scripting

Scripts for exporting backup from selected tables of Oracle DB

dear all please help me ! i need a script for exporting the selected tables of oracle database installed on CentOs. i waiting your response. thanks and regards

5. Shell Programming and Scripting

need to store query output fields in variables edit them and update the same in tables.

Hi , I have a query like select err_qty,drop_qty,unbld_qty,orig_qty from usage_data; I need to store the values of these fetched fields in variables, Need to edit them and update the new values into the table. Can anyone please help me in writing this piece of code:(

6. Shell Programming and Scripting

Compare the rowcount from tables of two databases

All, I have to create a shell script to comapre the rowcount of 120 tables from two oracle databases. In fact, using informatica the data is loading from 120 source tables to 120 staging tables. After that, they want to have a shell script to comapre the rowcount of all these tables. 1) I...

7. Shell Programming and Scripting

tables in scripts

Hi , I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1, t3= t1 - t2 t3= t1 - t2 I am new to scripts, any help please? thanks

8. UNIX for Dummies Questions & Answers

finding out tables not used in scripts.

Hi all, Please see my requirement and post me asap. Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence...

9. Post Here to Contact Site Administrators and Moderators

TODO: Sync User Tables Between Databases

Need to eventually sync the MY.UNIX userdata to the forums database (and others). Suggestions on the best approach welcome.

LEARN ABOUT REDHAT

update

update(n)						       Tcl Built-In Commands							 update(n)

__________________________________________________________________________________________________________________________________________________

NAME

       update - Process pending events and idle callbacks

SYNOPSIS

       update ?idletasks?
_________________________________________________________________

DESCRIPTION

       This command is used to bring the application ``up to date'' by entering the event loop repeatedly until all pending events (including idle
       callbacks) have been processed.

       If the idletasks keyword is specified as an argument to the command, then no new events or errors are processed;  only idle  callbacks  are
       invoked.   This causes operations that are normally deferred, such as display updates and window layout calculations, to be performed imme-
       diately.

       The update idletasks command is useful in scripts where changes have been made to the application's state and you  want	those  changes	to
       appear  on  the display immediately, rather than waiting for the script to complete.  Most display updates are performed as idle callbacks,
       so update idletasks will cause them to run.  However, there are some kinds of updates that only happen in response to events, such as those
       triggered by window size changes; these updates will not occur in update idletasks.

       The update command with no options is useful in scripts where you are performing a long-running computation but you still want the applica-
       tion to respond to events such as user interactions;  if you occasionally call update then user input will be  processed  during  the  next
       call to update.

SEE ALSO

       after(n), bgerror(n)

KEYWORDS

       event, flush, handler, idle, update

Tcl									7.5								 update(n)

Shell Programming and Scripting