10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear All,
I am trying to write a script which will generate output to a file based on input files on basis of a pattern which I am able to do so. But, I am stuck as I am trying to connect this to database server. Below is my command and output details.
Input Code
filedate=$(date... (6 Replies)
Discussion started by: grvk101
6 Replies
2. Shell Programming and Scripting
could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever.
requirement:
1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
3. Shell Programming and Scripting
Hi Friends,
I have a one unix box "x.y.z" on SunOS , where oracle is not installed. And another machine "a.b.c" on AIX , where oracle is installed. Now i want to make a script on x.y.z , that can connect to database on a.b.c, using sqlplus command. and then generate a report based on the... (5 Replies)
Discussion started by: gauravgarg
5 Replies
4. UNIX for Dummies Questions & Answers
How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database).
I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies
5. Shell Programming and Scripting
Hi all
I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Discussion started by: vijays3
6 Replies
6. Windows & DOS: Issues & Discussions
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Discussion started by: danin
3 Replies
7. Shell Programming and Scripting
Hi,
could you please help me out what are the command line commands to connect to as400.
Thanks, (0 Replies)
Discussion started by: mgirinath
0 Replies
8. IP Networking
i am working on informix database
can any body helps me with coding how to connect to it on solaris (3 Replies)
Discussion started by: ramneek
3 Replies
9. Programming
Anybody please help me how connect a database file in TC for windows.
regards
Senthil. K (5 Replies)
Discussion started by: Senthil
5 Replies
10. Shell Programming and Scripting
please, help me-....
i need connect to a database Sybase IQ 12 and I don't know if i can do it using a shell program.
if it's posibble, please tell me how...
please, help me, because I don't know what to do....
thanks...
jonathan (1 Reply)
Discussion started by: DebianJ
1 Replies
USER_CLUSTERS(5) Debian PostgreSQL infrastructure USER_CLUSTERS(5)
NAME
user_clusters - File linking users to PostgreSQL clusters
DESCRIPTION
This file maps users against the database clusters to which they will connect by default. However, every user can override these settings
in ~/.postgresqlrc.
When scanning this file, the first matching line will be used. It is a good idea to provide a default explicitly, with a final line where
both user and group are set to *.
If there is no default, the implicit default is to connect to the cluster whose postmaster is listening on port 5432 and to the database
matching the user's login name.
FORMAT
Comments are introduced by the character #. Comments may follow data on a line; the first comment character terminates the data. Leading
whitespace and blank lines are ignored.
Each uncommented, non-blank line must describe a user, group or the default (where both user and group are set to *).
Fields must be given in the following order, separated by white space:
USER The login id of the Unix user to whom this line applies. The wildcard character * means any user.
GROUP The group name of the Unix group to which this line applies. The wildcard character * means any group.
VERSION
The major PostgreSQL version of the cluster to connect to.
CLUSTER
The name of a cluster to connect to. A remote cluster is specified with host:port. If port is empty, it defaults to 5432.
DATABASE
Within the cluster, the database to which the user will connect by default if he does not specify a database on the command line.
If this is *, the default database will be the one named by the user's login id.
NOTES
Since the first matching line is used, the default line must come last.
SEE ALSO
pg_wrapper(1), postgresqlrc(5)
Debian Feburary 2005 USER_CLUSTERS(5)