Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Database alias name

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Database alias name
# 1  
Old 04-22-2005
Database alias name
Hi all,

I am connecting to two Databases <databasename1> <databasename2>
through dbaccess tool in a script

can i have an alias name to the two Databases and connect. I have to concurrently switch between two databases

for that how to establish an alias name for the two database names.

Any help or idea would be greatly appreciated.
Thanks
# 2  
Old 04-22-2005
Code:
alias db1="export INFORMIXSERVER=database1"
alias db2="export INFORMIXSERVER=database2"

Run db1 or db2 before switching to the database1 or database2.

Hope this helps.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

IP Alias

Quick question Have a AIX system that has been up for years with a 192.9.x.x IP scheme and we want to add a second IP to the system. I setup the second IP 10.1.x.x as an alias via smit. Since these two IP's are on different VLANs will this be an issue? Reason I ask is that I cannot ping... (3 Replies)
Discussion started by: Chrisp
3 Replies

2. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

3. UNIX for Dummies Questions & Answers

Create alias files (not alias commands)

If one: $ find -name 'some expression' -type f > newfile and then subsequently wants to create an alias file from each pathname the find command retrieved and the > placed within 'newfile', how would one do this? Ideally, the newly created alias files would all be in one directory. I am... (3 Replies)
Discussion started by: Alexander4444
3 Replies

4. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

5. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies

6. UNIX for Dummies Questions & Answers

Help with Alias

Hi, I have a software package consisting of a group of BASH shell scripts. There is a master script which calls a series of subscripts. To run the software users must open the master script, modify and save it, and then run it. To open the script you can either double-click on it, or you can... (2 Replies)
Discussion started by: msb65
2 Replies

7. UNIX for Dummies Questions & Answers

alias

i used 'alias' command for a set of daily used long commands. But i noticed they are gone once i log out of the ssh session. Can any one plz let me know if there is a way to set it permanently for my user. (1 Reply)
Discussion started by: pharos467
1 Replies

8. UNIX for Advanced & Expert Users

Alias database error

I am running Postfix 2.3 on FreeBSd 6.1 everytime I use the postalias command I get this error message that says no mapping in /etc/mail/mailer.conf hash database is installed and that is what is uncommented out in my main.cf file in the mailer.conf file everthing is pointing ... (0 Replies)
Discussion started by: rbizzell
0 Replies
Login or Register to Ask a Question