06-13-2017
If you give it $SID for a remote database, does it connect?
If so, simply wrap your code in a shell loop. It would probably be better if you can read a list of SIDs from a file so you can maintain that more simply than editing the script each time you need to add/remove a SID.
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file contains
TASK gsnmpproxy {
CommandLine = $SMCHOME/bin/gsnmpProxy.exe
}
TASK gsnmpdbgui {
CommandLine = $SMCHOME/bin/gsnmpdbgui.exe
I would like to comment and than uncomment specific task eg TASK gsnmpproxy
Pls suggest how to do in shell script (9 Replies)
Discussion started by: madhusmita
9 Replies
2. Shell Programming and Scripting
I have an task definition listing xml file that contains a list of tasks such as
<TASKLIST
<TASK definition="Completion date" id="Taskname1" Some other
<CODE name="Code12"
<Parameter pname="Dog" input="5.6" units="feet" etc /Parameter>
<Parameter... (3 Replies)
Discussion started by: MissI
3 Replies
3. Shell Programming and Scripting
hi,
infile-
create table salary
( occupation_code char(40),
earnings decimal(10,2),
occ_yearend integer
);
outfile-
salary:create table salary
salary:( occupation_code char(40),
salary: earnings decimal(10,2),
salary: occ_yearend integer
salary:);
Thanks. (4 Replies)
Discussion started by: dvah
4 Replies
4. Shell Programming and Scripting
ksh $CODE/dis/scripts/IS_BTEQ_LZ_TABLE_AUDIT.sh
DIS_BTEQ LZ_DIS_LOAD_LOG_KEY > $CODE/dis/logs/lz_table_audit_`date '+%Y%m%d_%H%M%S'`.log 2>&1
Can some one tell me what the above script is doing?
As per my understanding we are executing the script and sending the output to a log file. The... (4 Replies)
Discussion started by: karthikkasarla
4 Replies
5. Shell Programming and Scripting
Hello all..
i have few task to do on specific day ar per weekday or weekend...
for example i have 3 tasks:
task1
task2
task3
Now i need to create a shell script
If it is weekday it will change the status of these tasks as below
sendevent -E CHANGE_STATUS -s SUCCESS -J task1... (4 Replies)
Discussion started by: j_panky
4 Replies
6. Shell Programming and Scripting
input file's one set header is this,
-----------------------------------------------------
OUTPUT FROM ASCII FILE: CAST #1
-----------------------------------------------------
CC Cruise Latitude Longitude YYYY MM DD Time Cast #Levels
CA 8504 50.083 -144.883 1970 1 2... (6 Replies)
Discussion started by: Akshay Hegde
6 Replies
7. Shell Programming and Scripting
In following attached 748phy.xls file, fifth column is ST_Date, which contains time and dates in this format
22-11-2012 7:54:54 PM in single column
I want it to split in this format either 1st column 22/11/2012 and in second column 7:54:54 PM
Or like this in separate... (13 Replies)
Discussion started by: Akshay Hegde
13 Replies
8. Shell Programming and Scripting
I have an ETL process that triggers a shell script. This script picks the files created by the ETL process and does an SFTP. These are huge files. Due to infrastructure limitations, we need to trigger the actual SFTP part only during the 2nd, 16th, 31st and 46th minute of an hour. Please let me... (2 Replies)
Discussion started by: vskr72
2 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write a script checkFiles.sh that takes an arbitrary number of file paths from the command line and carries ... (5 Replies)
Discussion started by: Ezraek
5 Replies
10. Shell Programming and Scripting
Hello
I have a problem with use bash script in windows task.
If I use script by cygwin it's working well.
If I use it by Windows task I'm get error
Error :
ERROR 2 (HY000) at line 2: File '.\xxx.csv' not found (Errcode: 2)
Code Line :
load data local infile './xxx.csv' REPLACE into... (16 Replies)
Discussion started by: karp
16 Replies
LEARN ABOUT REDHAT
clusterdb
CLUSTERDB(1) PostgreSQL Client Applications CLUSTERDB(1)
NAME
clusterdb - cluster a PostgreSQL database
SYNOPSIS
clusterdb [ connection-options... ] [ --table | -t table ] [ dbname ]
clusterdb [ connection-options... ] [ --all | -a ]
DESCRIPTION
clusterdb is a utility for reclustering tables in a PostgreSQL database. It finds tables that have previously been clustered, and clusters
them again on the same index that was last used. Tables that have never been clustered are not touched.
clusterdb is a shell script wrapper around the backend command CLUSTER [cluster(7)] via the PostgreSQL interactive terminal psql(1). There
is no effective difference between clustering databases via this or other methods. psql must be found by the script and a database server
must be running at the targeted host. Also, any default settings and environment variables available to psql and the libpq front-end
library do apply.
clusterdb might need to connect several times to the PostgreSQL server, asking for a password each time. It is convenient to have a
$HOME/.pgpass file in such cases.
OPTIONS
clusterdb accepts the following command-line arguments:
-a
--all Cluster all databases.
[-d] dbname
[--dbname] dbname
Specifies the name of the database to be clustered. If this is not specified and -a (or --all) is not used, the database name is
read from the environment variable PGDATABASE. If that is not set, the user name specified for the connection is used.
-e
--echo Echo the commands that clusterdb generates and sends to the server.
-q
--quiet
Do not display a response.
-t table
--table table
Clusters table only.
clusterdb also accepts the following command-line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for
the Unix domain socket.
-p port
--port port
Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as
-W
--password
Force password prompt.
DIAGNOSTICS
CLUSTER
Everything went well.
clusterdb: Cluster failed.
Something went wrong. clusterdb is only a wrapper script. See CLUSTER [cluster(7)] and psql(1) for a detailed discussion of error
messages and potential problems. Note that this message may appear once per table to be clustered.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters.
EXAMPLES
To cluster the database test:
$ clusterdb test
To cluster a single table foo in a database named xyzzy:
$ clusterdb --table foo xyzzy
SEE ALSO
CLUSTER [cluster(7)]
Application 2002-11-22 CLUSTERDB(1)