Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Question about database in Unix Post 302258044 by wendyz on Thursday 13th of November 2008 05:48:20 PM
Old 11-13-2008
Question about database in Unix

I want to write a command file in Unix that can access database. what unix command can access database.
Actually, I installed software in SCO Unix, there is a database. but I want to access database without run this software in unix. How can I do?
 

10 More Discussions You Might Find Interesting

1. Programming

unix has it's own database

Well I am new to Unix, I small doubt to clarify with our colloquies here. Does Unix any of the versions contains its own database or it stores data on the file system. How to migrate data in Unix to Oracle Data base is there any tool or utility available on Unix that helps to do this... (4 Replies)
Discussion started by: IRFI_P
4 Replies

2. UNIX for Dummies Questions & Answers

unix database server

hello , guys , im new to unix , just passed out my system admin certification from sun. i need to do few things at home , which are 1. ihave a unix box and windows box wired together using hub , i want to use internet from windows box . i have win98 ist edition , as well as win2000 server. kindly... (7 Replies)
Discussion started by: definate
7 Replies

3. UNIX for Dummies Questions & Answers

Unix Database

Hi :) I'm a new unix user and i don't know much things about it.At the moment i've to make a work about unix databases.so i decided to come here and ask for help, if someone could tell me about a site or other mean where i can get some information about this i'll be pleased. Tanks for any... (3 Replies)
Discussion started by: Briga
3 Replies

4. Solaris

DiskSuite 4.2.1 Database creation question

I'm trying to figure out how to simply create a 500Gb ufs file system named /rec using DiskSuite 4.2.1 on a Solaris 8 platform via command line using two 250Gb partitions on two different disks. Does anyone know what the proper command string and options are to perform this task? Would I use the... (2 Replies)
Discussion started by: ruger14
2 Replies

5. Shell Programming and Scripting

Querying database from unix

Hi, I have a shell script to query the database to get the statistics of tables like sum,max,min,etc of all numeric columns,max and min of date columns and length of varchar columns for each and every table. There are nearly 1600 tables. My script queries few tables like about 100 tables and... (3 Replies)
Discussion started by: ragavhere
3 Replies

6. SCO

Old SCO point of sale system database question

As a free lance computer consultant, I am working for a local store. They have an ancient point of sale (POS) system that has a server and several register machines, all running on a SCO unix. The system is at least 10 years old, maybe 15. The the POS vendor discontinued the product... (1 Reply)
Discussion started by: jgt10
1 Replies

7. Solaris

Oracle Database 10g installation question

I wanted to ask how do i assign the control files and archive log to be stored in different volume? I didn't come through any selection for that during the GUI installation. :) Thanks in advance for any reply. p/s: I will appreciate it also if anyone can provide me a link for me to go... (1 Reply)
Discussion started by: beginningDBA
1 Replies

8. Solaris

Solaris Volume Manger - Database Replicas Question - Benefits of Increasing Default Size?

Hey all! I was hoping someone knew anything about this one... I know with Solaris Volume Manager the default Database Replica size is 8192 blocks (4MB approximately) Now I know you can increase this amount but is there any point? The reason I am asking this is that I've setup mirroring on... (2 Replies)
Discussion started by: Keepcase
2 Replies

9. Shell Programming and Scripting

Database connectivity using unix

Hi, I am trying to connect to the database through Unix serer using following command- mysql -u root -Jepadt -D dtdatabase But it giving me error - mysql: unknown option '-J' Can anybody help me to solve this problm Thanks in advance Please use code tags, thanks. (2 Replies)
Discussion started by: pspriyanka
2 Replies

10. Shell Programming and Scripting

Is it possible to get the database details in UNIX?

Hi, Sorry i can't find what particular forum should i post my question. I was given a username and password for the database, but i was not given the hostname, SID and the port to were i can connect to with. Is there a way for me to get the following details in unix, by the way i am using... (5 Replies)
Discussion started by: reignangel2003
5 Replies
DROP 
DATABASE(7) PostgreSQL 9.2.7 Documentation DROP DATABASE(7) NAME
DROP_DATABASE - remove a database SYNOPSIS
DROP DATABASE [ IF EXISTS ] name DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to postgres or any other database to issue this command.) DROP DATABASE cannot be undone. Use it with care! PARAMETERS
IF EXISTS Do not throw an error if the database does not exist. A notice is issued in this case. name The name of the database to remove. NOTES
DROP DATABASE cannot be executed inside a transaction block. This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb(1) instead, which is a wrapper around this command. COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard. SEE ALSO
CREATE DATABASE (CREATE_DATABASE(7)) PostgreSQL 9.2.7 2014-02-17 DROP DATABASE(7)
All times are GMT -4. The time now is 07:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy