10 More Discussions You Might Find Interesting
1. AIX
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
2. Shell Programming and Scripting
Hi ,
I have 2 databases which has same table names and I need to list entries of a particular table in database1 not existing in the same tablename of database2.
eg : I have db1 having table name orders
ad_d | code | start | end | amountscore | id | amount_class |... (1 Reply)
Discussion started by: siya@
1 Replies
3. Programming
I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5.
I plan to do this mechanically, so the approach should work for any table in my database schema.
Suppose for illustration purposes I start with the following table:
CREATE TABLE `sources` (
... (4 Replies)
Discussion started by: figaro
4 Replies
4. Programming
On the Linux systems, we have scripts which monitor disk usage. I want to take that data and feed that into SQL database. Can you give some advise.
For example here is one of the file. I have many files like this but the format is same...
2012-09-24 04:36:14 2012-09-24 04:36:16 48414984... (3 Replies)
Discussion started by: samnyc
3 Replies
5. Shell Programming and Scripting
Dear Friends :-),
Need your help once again.
I have following SQL in a shell script to pick values from database
select date_stamp, time_stamp from logs
where date=31012012
However, at times we need to take these value(s) from a variable. To do this we have following query.
select... (2 Replies)
Discussion started by: anushree.a
2 Replies
6. UNIX for Dummies Questions & Answers
I have two queries
query1
select IDW_SITE_NAME REGION,a.location_sid,a.CALENDAR_SID,count(*) from idw.vod_stream a, IDW_REF_DATA b
where a.location_sid = b.location_sid and a.calendar_sid between 20110901 and 20110915 --this is start date parameter and end date
parameter
and... (5 Replies)
Discussion started by: qutesanju
5 Replies
7. Programming
I have a B+ tree flat file database which is used by the application we use.
I would like to implement a SQL kind of access for that DB.
I have implemented my data structures to parse and store the user written query for execution.
But i would like to know, do we have any standard data... (2 Replies)
Discussion started by: kumaran_5555
2 Replies
8. Shell Programming and Scripting
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?
Thank you! :D
J. (0 Replies)
Discussion started by: ph0enix
0 Replies
9. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
10. AIX
Hello UNIX gurus, I need to install the mysql odbc connector with unixODBC on my AIX 5.3 machine. I have a mySQL database running on another server (Ubuntu 7.04). The SQL database works fine. The problem I am having is when trying to run ./configure for mysql-connector-odbc it seems to be looking... (1 Reply)
Discussion started by: raidzero
1 Replies
grass-sqlite(1grass) Grass User's Manual grass-sqlite(1grass)
NAME
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is
sufficient to define the connection (see next step).
Connecting GRASS to SQLite
The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it
will be automatically created when database content is created:
# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
db.connect -p
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file stored within the current mapset, the following way is suggested (corre-
sponds to above database connection):
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
SEE ALSO
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-sqlite(1grass)