10-14-2008
Database access
Hell all,
I have the following snippet of code:
$sql=qq{select * from (
select to_char(t.start_time_timestamp,'yyyy/mm/dd hh24:mi:ss') start_time,t.s_p_number_address, null cos_icsa_code, null cos_icsa_subcode from cc_unrated_msc_flow t
union
select to_char(r.start_time_timestamp,'yyyy/mm/dd hh24:mi:ss') start_time,r.s_p_number_address, r.cos_icsa_code, r.cos_icsa_subcode from cc_unrated_icsa_flow r
)
order by start_time, s_p_number_address};
$sth = $dbh->prepare( $sql );
$sth->execute( );
while(@row = $sth->fetchrow_array()) {
print("MATCH FOUND!\n");
open (DEST1, ">>/opt/rap/preprocessing/unrated_output/TEMP1")||die "$!";
print DEST1 (join ("|", @row), "\n");
}
How can i indicate that $sth->fetchrow_array failled to retrieve a specific line? Can i print tis line?
Thank you very much
Chris
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
I am a newborn baby to Unix and I was told that it was possible to have Microsoft Access databases on a Unix web server. I am using Perl to interface and query the Access database, which puts the information into the appropriate fields of a web page. Then updated information is submitted... (1 Reply)
Discussion started by: spiderling
1 Replies
2. Programming
Hey,
I want to access oracle database through Unix C programming.. Can you through me some light on that... (5 Replies)
Discussion started by: kavi
5 Replies
3. Shell Programming and Scripting
Hi,
I tried to run this code but it isnt giving me any output or errors.
My aim is to retrieve the row based on the flag name(this is the primary key).
flag_test is my table
This is how i ran it:
perl read_db.pl flag1
flag1 is the criteria in where clause
--------
this is my... (2 Replies)
Discussion started by: mercuryshipzz
2 Replies
4. UNIX for Advanced & Expert Users
Hi!
I need to access two diferent databases allocated in a linux server through PHP. I know in the php.ini file I can't configure some parameters as odbc.default_db... but I can't configure it.
I've already installed unixodbc drivers
Can Anybody point me to a tutorial web o teach me how... (0 Replies)
Discussion started by: ncatdesigner
0 Replies
5. Shell Programming and Scripting
Hi
i have the following code:
if(($line!=1) and (@field!='\$')){
print ( "\nTRY TO CONNECT TO DATABASE................\n");
my $dbh = DBI->connect($dsn, $user, $pass);
print ("CONNECTED TO DATABASE\n");
eval
... (1 Reply)
Discussion started by: chriss_58
1 Replies
6. Shell Programming and Scripting
hi guys,
I am using the following code in order to access a database.
#!/usr/bin/perl
print "READ DATA FROM DATABASE\n";
use DBI;
use strict;
#use DBD::Oracle;
my $user='reassure';
my $pass='R3Assur3';
#my $dsn="dbi:Oracle:orcl";
my $dsn='dbi:Oracle:cobscs.world';
my $dbh =... (1 Reply)
Discussion started by: chriss_58
1 Replies
7. IP Networking
Hi! :D
I'm new here, and I will appreciate all the help you can give.
This is the problem we are trying to solve at my office.
At office 1 we have SCO UNIX 5.0.can't remember last number. On it runs database software on which we input/read/modify data throughout terminal software, on remote... (1 Reply)
Discussion started by: PNemesis
1 Replies
8. Shell Programming and Scripting
i want to access database (sql script) within a unix script.
help me (2 Replies)
Discussion started by: chamaraa
2 Replies
9. UNIX for Dummies Questions & Answers
Hello all,
is it possible to write a script in order to connect to a database, load data in a specific domain and execute the corresponding command? (3 Replies)
Discussion started by: FelipeAd
3 Replies
10. AIX
Hi,
I am running a JDBC:ODBC code to access .mdb file in my windows system successfully but, not able to access MS Access mdb file in AIX Unix box. when I am trying to run the same piece of code in AIX Unix box it is saying "No Suitable Driver". I need some immediate help. (0 Replies)
Discussion started by: thirunp
0 Replies
LEARN ABOUT DEBIAN
swac-get
SWAC-GET(1) General Commands Manual SWAC-GET(1)
NAME
swac-get - audio collections of words (SWAC) manager
SYNOPSIS
swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
[sql <query>] | [--help] | [--version]
DESCRIPTION
Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC) in a SQLite3 database.
Audio collections can be imported from the hard drive or directly from the Internet using the HTTP protocol. Swac-get is designed to be
used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database. An important set of free audio collec-
tions of words (SWAC) is available at: http://swac-collections.org/
For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .
COMMANDS
clear clear database
deselect <url|packid>
delete records of the package <url|packid> from the database
list list installed packages
list-available
list available packages
list-sources
list source repositories
sql <query>
execute a sql query in the database
select <url|packid>
insert records of the package <url|packid> in the database
ex: swac-get select file:///home/<my directory>/
swac-get select http://packs.shtooka.net/<my package>/ogg/
swac-get select fra-balm-voc
select source-delete <url>
delete <url> from the repositories list
source-deselect <url>
deselect <url> from the repositories list
source-select <url>
add <url> to the repositories list
ex: swac-get source-select http://packs.shtooka.net/
swac-get source-select file:///home/<my directory>/
update update the list of available packages
upgrade
upgrade installed packages
OPTIONS
-t, --target <path>
set the SQLite3 database path (default path is ~/.swac/swac.db)
-v, --version
print version information and exit
-h, --help
print this help and exit
EXAMPLES
swac-get source-select http://packs.shtooka.net/
swac-get update
swac-get select chi-balm-hsk1
swac-get select fra-balm-voc
BUGS
swac-get doesn't care about the version number for the upgrade command.
AUTHOR
swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.
mai 25, 2008 SWAC-GET(1)