Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Multiple SQL Commands
Special Forums UNIX Desktop Questions & Answers Multiple SQL Commands Post 302471953 by OMLEELA on Monday 15th of November 2010 06:40:44 PM
Old 11-15-2010
Multiple SQL Commands
Hello Experts !!!

Im new to this so, please bear with me !

I have the following 2 sql statements
Code:
create table CMD_NEW_USER as
Select FD.EMPLOYEE, FD.PASTUSER, .....
FROM REPORTS FS, TASKLIST FD
WHERE FS.EMPLOYEEID = FD.EMPLOYEEID ;

create table CMD_OLD_USER as
Select FD.EMPLOYEE, FD.PASTUSER, .....
FROM REPORTS FS, TASKLIST FD
WHERE FS.EMPLOYEEID != FD.EMPLOYEEID ;

Now, here are the challenge's
1. I need to create a shell wrapper so that the above two sql create table commands run successfully by connecting to the correct database.
2. Run this everyday at 11 PM so that the next day this is done.

Any and all help is sincerely appreciated !

Thanks,
Lee
Last edited by Scott; 11-15-2010 at 07:46 PM.. Reason: Code tags
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL Commands in Unix

Hi gurus, Being a newbie not sure whether iam asking the right question? can we use oracle commands in unix for ex: to read a count on a table. if so, what needs to be configured and etc.. any kind of help is appreciated. Thanks sish (6 Replies)
Discussion started by: sish78
6 Replies

2. Shell Programming and Scripting

how to sql commands in shell script

hi, plz let me know one example in using sql command in shell script thanks inadvance -bali. (1 Reply)
Discussion started by: balireddy_77
1 Replies

3. Shell Programming and Scripting

SQL commands in Scripting

Hi , Daily I sneding report to client about the status of State 2 jobs in Control M . I would like to schedule it via cron . I am using teh following command : sudo su - <control M server Name> then reach to the control M server then run #isql <It ask for the password > ... (1 Reply)
Discussion started by: chandancsc
1 Replies

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

5. Shell Programming and Scripting

perform 3 awk commands to multiple files in multiple directories

Hi, I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them. Each of... (20 Replies)
Discussion started by: amarn
20 Replies

6. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

7. UNIX for Advanced & Expert Users

Pass Multiple Commands and Open Multiple Xterms via PSS

Hello, I'm attempting to open multiple xterms and run a command as an SAP user via sudo using PSSH. So far, I'm able to run PSSH to a file of servers with no check for keys, open every xterm in to the servers in the file list, and SUDO to the SAP(ADM) user, but it won't do anything else... (11 Replies)
Discussion started by: icemanj
11 Replies

8. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

LEARN ABOUT CENTOS

ibus-table-createdb

IBUS-TABLE-CREATEDB(1)													    IBUS-TABLE-CREATEDB(1)

NAME

       ibus-table-createdb - create ibus-table database from table source

SYNOPSIS

       ibus-table-createdb  [  [ -n name ]  [ --name name ]  ]	[  [ -s source ]  [ --source source ]  ]  [  [ -e extra ]  [ --extra extra ]  ]  [
       [ -p pinyin ]  [ --pinyin pinyin ]  ]  [ -o ]  [ --no-create-index ]  [ -i ]  [ --create-index-only ]  [ -d ]  [ --debug ]

DESCRIPTION

       ibus-table-createdb creates a database for ibus-table from a source table.

OPTIONS

       This program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is  included
       below.

       -n     database-file  specifies	the  file name for the binary database for the IME. The default is ''. If the file name of the database is
	      not specified, the file name of the source file before the first '.' will be appended with '.db' and that will be used as  the  file
	      name of the database.

       -s     source-file specifies the file which contains the source of the IME. The default is ''.

       -e     extra-words-file specifies the file name for the extra words for the IME. The default is ''.

       -p     pinyin-file specifies the source file for the pinyin. The default is '/usr/share/ibus-table/data/pinyin_table.txt.bz2'.

       -o     Do not create an index for a database (Only for distribution purposes, a normal user should not use this flag!)

       -i     Only  create  an	index  for  an	existing database. Specifying the file name of the binary database with the -n or --name option is
	      required when this option is used.

       -d     Print extra debug messages.

EXAMPLES

       ibus-table-createdb -n ipa-x-sampa.db -s ipa-x-sampa.txt
	      Create the binary database ``ipa-x-sampa.db'' from the source file ``ipa-x-sampa.txt''.

       ibus-table-createdb -i -n ipa-x-sampa.db
	      Create an index for the database ``ipa-x-sampa.db''.

AUTHOR

       This manual page was written by Mike FABIAN <mfabian@redhat.com>.

								   Apr 18, 2013 					    IBUS-TABLE-CREATEDB(1)
All times are GMT -4. The time now is 07:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy