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
COOKIETOOL(6) Games Manual COOKIETOOL(6)
NAME
cdbsplit - program to operate cookie (fortune) database
SYNOPSIS
cdbsplit [options] <cookie-database> <hitfile>
DESCRIPTION
This manual page documents briefly the cdbsplit command.
This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page. Instead, it
has some plain text documentation, see below.
cdbsplit is a program that can be used to operate cookie database in various formats, the default is standard fortune(6) format, i.e. list
of 'cookies' delimited with line containing a single percent ('%') char . With 'cdbsplit' you can split cookie database, or extract parts
of it depending on various criteria.
OPTIONS
A summary of options is included below. For a complete description, see the documentation in /usr/share/doc/cookietool directory. NOTE,
that default behaviour is to overwrite existing database with its reduced version, so the cookies are MOVED to hitfile. The hitfile is
never overwritten, but may be appended to.
[nothing]
Shows summary of options.
-c case-sensitive comparisons (for both keywords and groups)
-d[0-3]
how fussy about word delimiters? (default: 2)
-k<keyword>
optional keyword
-K<keyword>
mandatory keyword (use both of them to form boolean expressions)
-l<min_lines>
minimal cookie length (in lines)
-L<max_lines>
maximal cookie length (in lines)
-w<chars>
minimal line width (in chars)
-W<chars>
maximal line width (in chars)
-n<min_number>
start at cookie <min_number>
-N<max_number>
stop after <max_number> cookie
-m<chars>
find groups of cookies starting with <n> matching characters (database must be sorted for this to make sense!)
-x extract only, don't modify <cookie-database>
-a append, don't overwrite <hitfile> if such a filename exists
-f[0-3]
input file format - -f3: cookies are separated by '%%' lines; -f2: cookies are separated by '%' lines (DEFAULT); -f1: each line is a
cookie; -f0: each word is a cookie.
SEE ALSO
cookietool(6), cdbdiff(6)
BUGS
None known.
AUTHOR
Upstream author and Aminet cookietool.lha package with AmigaOS binaries uploader is Wilhelm Noeker, <wnoeker@t-online.de>. Unix manpages
(including this one) and makefile are maintained by Miros/law L. Baran <baran@debian.org>. This manual page uses many excerpts from the
original README file.
May 19, 2001 COOKIETOOL(6)