Sponsored Content
Full Discussion: Querying database from unix
Top Forums Shell Programming and Scripting Querying database from unix Post 302200826 by ragavhere on Friday 30th of May 2008 06:48:45 AM
Old 05-30-2008
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 then hangs up. There is no progress. Can anyone tell me what the problem could be and a solution for it?

Ragav.
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connecting and Querying DB2 database from Unix Script?

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies

2. UNIX for Advanced & Expert Users

Connecting to DB2 database on Mainframe and Querying DB

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies

3. HP-UX

Querying HP VA array

Hello, all... I've got an older HP-UX 11i machine hooked up to an HP VA array. I've never worked with VA arrays, so I was wondering if anyone could point me in the direction of some documentation on querying and manipulating VAs (HP VAs for Dummies or something). I'm used to EMC arrays, so... (2 Replies)
Discussion started by: kknigga
2 Replies

4. AIX

Servers still querying old DNS server?

Hello, I've created new DNS servers and changed all of the clients /etc/resolv.conf to point to them, but when I check the old DNS logs, I see that the clients are still querying it. Does anybody know why? thanks, (2 Replies)
Discussion started by: ctcuser
2 Replies

5. Solaris

commands hanging when querying hardware

Hi all Got another strange one. If I try to enquire about the hardware, the command hangs implying Ive got a hardware issue. So, if I execute :- iostat -en sysdef - ( stops at the devices part ) format cfgadm -al Anything that searches the devices, then the command hangs. ... (4 Replies)
Discussion started by: sbk1972
4 Replies

6. Red Hat

Error in querying file information

Hi, We have one application running where there is Linux Machine. For some some process I found the following message came, error 5.8/116455-02/116455-02.zip Error in querying file information: Permission denied :confused: If anybody has any idea for this please let me... (2 Replies)
Discussion started by: sptr
2 Replies

7. Shell Programming and Scripting

Generic script for Querying a DB

I have a few databases that i need to get some basic output from... so I'll be returning 1 or 2 records from a variety of different databases and the input queries will always differ. What im looking for is a generic script that I can use across of the databases. Theory being i have: ... (2 Replies)
Discussion started by: atelford
2 Replies

8. Shell Programming and Scripting

Querying v$session table

Hi All, I'm using below code entry_data_control=`sqlplus ${sysuser}/${syspwd} << data_control whenever sqlerror exit sql.sqlcode; whenever oserror exit failure; INSERT INTO LSHADMIN.STUDY_LEVEL_TABLE(SESSION_SID,SESSION_SERIAL_NO,FILE_NAME) ... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
database(1grass)						Grass User's Manual						  database(1grass)

GRASS GIS 6.4.2 Reference Manual
       Geographic Resources Analysis Support System, commonly referred to as GRASS, is a <a href="http://en.wikipedia.org/wiki/Geographic_informa-
       tion_system">Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps  produc-
       tion, spatial modeling, and visualization. GRASS is currently used in academic and commercial settings around the world, as well as by many
       governmental agencies and environmental consulting companies.

       This reference manual details the use of modules distributed with Geographic Resources Analysis Support System (GRASS), an open source (GNU
       GPL'ed), image processing and geographic information system (GIS).  Go back to help overview
       database commands:
	    | db.columns   | List all columns for a given table.
	    | db.connect   | Prints/sets general DB connection for current mapset and exits.
	    | db.copy	   | Copy a table.
	    | db.describe  | Describes a table in detail.
	    | db.drivers   | Lists all database drivers.
	    | db.dropcol   | Drops a column from selected attribute table
	    | db.droptable	| Drops an attribute table.
	    | db.execute   | Executes any SQL statement.
	    | db.in.ogr    | Imports attribute tables in various formats.
	    | db.login	   | Sets user/password for driver/database.
	    | db.out.ogr   | Exports attribute tables into various formats.
	    | db.select    | Selects data from attribute table (performs SQL query statement(s)).
	    | db.tables    | Lists all tables for a given database.
	    | db.test	   | Test database driver, database must exist and set by db.connect.

       Full Index
       (C) 2003-2011 GRASS Development Team

GRASS 6.4.2															  database(1grass)
All times are GMT -4. The time now is 01:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy