Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.983.097 Times

SQL::Preproc 0.10

  Date Added: April 08, 2010  |  Visits: 497

SQL::Preproc

Report Broken Link
Printer Friendly Version


Product Homepage
Download (70 downloads)

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use SQL::Preproc::ExceptContainer; use DBIx::Chart; ...some code... my ($host, $user, $passwd) = @ARGV; DECLARE CONTEXT $sqlpp_ctxt; CONNECT TO "Teradata:$host" USER $userid IDENTIFIED BY $passwd AS myconn WITH tdat_mode => ANSI; my $more_rows; WHENEVER NOTFOUND { $more_rows = undef } WHENEVER SQLERROR { my ($ctxt, $err, $state, $errmsg) = @_; die $errmsg; } DECLARE CURSOR mycursor AS SELECT * FROM mytable FOR UPDATE; OPEN mycursor; my ($col1, $col2, $col3, $col4); while ($more_rows) { FETCH mycursor INTO :$col1, :$col2, :$col3, :$col4; if ($col1 > $col4) { UPDATE mytable SET col4 = col4 + 100 WHERE CURRENT OF mycursor; } } CLOSE mycursor; # # do a bulkload via array binding # my @col1 = (); my @col2 = (); my @col3 = (); # # load some data into the arrays, then send it to the DBMS # EXEC SQL INSERT INTO sometable VALUES(:@col1, :@col2, :@col3); # # now create a chart, dumping results to @_ # SELECT * FROM mytable RETURNING LINEGRAPH(*), IMAGEMAP WHERE WIDTH=500 AND HEIGHT=500 AND FORMAT=PNG AND LOGO=myimage.png AND X_AXIS=Date AND Y_AXIS=Stock Price AND MAPNAME=stockmap AND SIGNATURE=GOWI Systems, Inc. AND SHOWPOINTS=1 AND POINT=opencircle; open(OUTF, >mychart.png) || die $!; binmode OUTF; print OUTF, $_[0]; close OUTF; open(OUTF, >mychart.map) || die $!; print OUTF, $_[1]; close OUTF; DISCONNECT myconn;.

Requirements: No special requirements
Platforms: Linux
Keyword: Ala Embed In Your Libraries Module Outf Perl Perl Module Preprocessors Programming Sql Sqlpreproc
Users rating: 0/10

License: Freeware Size: 52.22 KB
SQL::PREPROC RELATED
Form Processors  -  Menus in your windows app 1.1
Menus in your windows app shows how to implement menus in your Win32 application.
20.48 KB  
Installer/Uninstaller Tools  -  EverUpdate SDK Beta
EverUpdate provides a simple component that you embed in your applications to instantly enable robust patch and update management capabilities. Via simple API calls, you can cause your application to check for available patches or updates. You can...
6.83 MB  
Java Based Databases  -  CSV 6.5
Java classes you can use standalone or embed in your own programs to Read, write, align, sort and pack comma, tab and semicolon- separated variable files, commonly known as CSV files. It consists of a 23 Java classes/utilities CSVReader,...
2.37 MB  
Modules  -  Minimun Amount to Enable CC Payments 1.0
This simple mod makes possible to apply a simple minimun amount to enable or disable the credit card payments in your website using the standard cc module. For example:- You want your customers be able to pay with CC only if the total amount is...
 
Libraries  -  Template::Plugin::ASCIITable 0.1
Template::Plugin::ASCIITable is a Perl module that allows you to use Text::ASCIITable in your templates. SYNOPSIS [% USE ASCIITable %] blah [% ASCIITable.cols(a, b, c); ASCIITable.rows([1,2,3],[one,two,three]); ASCIITable.draw() %] A...
7.17 KB  
Libraries  -  Wx::Perl::Packager 0.07
Wx::Perl::Packager provides a module to assist packaging Wx based applications with PAR, ActiveState PerlApp / PDK and Perl A module to assist packaging Wx based applications with PAR, ActiveState PerlApp / PDK and Perl2Exe. All that is needed...
12.29 KB  
Libraries  -  Language::Functional 0.03
Language::Functional is a Perl module which makes Perl slightly more functional. SYNOPSIS use Language::Functional :all; print The first ten primes are: , show(take(10, filter { prime(shift) } integers)), "n"; Perl already contains some...
16.38 KB  
Libraries  -  Drupal::Module::Starter 0.06
Drupal::Module::Starter is a Perl module to create Drupal Module starter files. SYNOPSIS You probably dont want to use this module directly - you want to use the drupal-module-starter script in the scripts directory of the distribution use...
14.34 KB  
Libraries  -  Getopt::EvaP 2.3.5
Getopt::EvaP is a Perl module to evaluate Perl command line parameters. SYNOPSIS use vars qw/@PDT @MM %OPT/; use Getopt::EvaP; EvaP @PDT, @MM, %OPT; EXPORT use Getopt::EvaP exports the subs EvaP and EvaP_PAC into your name space. @PDT...
52.22 KB  
Libraries  -  OzDB 0.02
OzDB is a database Perl interface module for OzBot. SYNOPSIS use OzDB; The OzDB Perl module handles authentication and access control for the OzBot based utility bots. The basic database format is the authentication schema. This is based on...
12.29 KB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.12.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
2.73 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB