Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: pls. help with SQL database...
Top Forums Programming pls. help with SQL database... Post 302710695 by samnyc on Thursday 4th of October 2012 04:48:33 PM
Old 10-04-2012
pls. help with SQL database...
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...

Code:
 
2012-09-24 04:36:14 2012-09-24 04:36:16 48414984 emc1:/home1/peter nfs 1393977600 590560512 803417088 43% /home/peter
 2012-09-25 02:06:00 2012-09-25 02:06:02 48414984 emc1:/home1/peter nfs 1393977600 647708736 746268864 47% /home/peter
 2012-09-26 04:00:22 2012-09-26 04:00:24 48414984 emc1:/home1/peter nfs 1393977600 800012576 593965024 58% /home/peter
 2012-09-27 05:01:11 2012-09-27 05:01:13 48414984 emc1:/home1/peter nfs 1393977600 800431776 593545824 58% /home/peter
 2012-09-28 05:13:25 2012-09-28 05:13:27 48414984 emc1:/home1/peter nfs 1393977600 800747072 593230528 58% /home/peter

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Read SQL database from Unix...

Hi there, I am new here and looking for a bit of help... I don't don't know much about Unix but I've tried to include as much info as possible. We currently operate our system as a bespoke on SCO 5.05 with Informix databases. This includes a financials package called "Multisoft". Both... (0 Replies)
Discussion started by: uptheposh
0 Replies

2. Shell Programming and Scripting

pls help me !! about text database shell programming

my teacher assigned me an assignment about text database shell programming but I don't know anything about that. here is about problem. I must submit this assignment to my teacher before 3 August. contact me at **deleted**, thank you Given a text database file for student registration name... (2 Replies)
Discussion started by: sunattha
2 Replies

3. Shell Programming and Scripting

A script pls( To retrieve database information)

KSH - Unix -AIX - db2 ************** Get the input from the user say '123' (It varies) Then i want to connect to a database say "D1" then i want th extract from the database by giving "select * from tablename where input = '123' I also want to connect to another database "D2" then i... (3 Replies)
Discussion started by: rollthecoin
3 Replies

4. Programming

sql help pls

Can anyone help come up with an sql code for the below? The fields are as follows: SerialNum GroupCode TktType DueDate Amount Examples values are: 1. SN123456 GC0001 Start 15-OCT-2008 28,500 2. SN123460 GC0001 (1 Reply)
Discussion started by: xinoo
1 Replies

5. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

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

6. Programming

SQL for flat file database

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

7. UNIX for Dummies Questions & Answers

shell/sql to get difference between two database

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

8. Shell Programming and Scripting

SQL in LINUX. Variable or Database

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

9. Shell Programming and Scripting

SQL compare database

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

10. AIX

Connect to database server and execute sql

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

LEARN ABOUT LINUX

groff_mom

GROFF_MOM(7)						 Miscellaneous Information Manual					      GROFF_MOM(7)

NAME

       groff_mom - groff `mom' macros

SYNOPSIS

       groff -mom [ files... ]
       groff -m mom [ files... ]

DESCRIPTION

       mom  ("my own macros", "my other macros", "maximum overdrive macros", ...) is a macro set for groff, designed primarily to format documents
       for PostScript output.

       mom provides two categories of macros: macros for typesetting and macros for document processing.  The typesetting macros provide access to
       groff's	typesetting  power  in ways that are simpler to master and to use than groff's primitives.  The document processing macros provide
       customizable markup "tags" that allow the user to design and output professional-looking documents with a minimum of typesetting  interven-
       tion.

       mom comes with her own (very) complete documentation in HTML format.

FILES

       om.tmac
	      - the main macro file
       mom.tmac
	      - a wrapper file that calls om.tmac directly.

       </usr/share/doc/groff-base/html/mom/toc.html>
	      - entry point to the HTML documentation

       /usr/share/doc/groff-base/examples/mom/*
	      - example files using mom

AUTHOR

       mom  was  written  by  Peter  Schaffter <peter@schaffter.ca>.  Please send bug reports to the groff bug mailing list <bug-groff@gnu.org> or
       directly to the author at the address, above.

Groff Version 1.21						   25 June 2012 						      GROFF_MOM(7)
All times are GMT -4. The time now is 06:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy