DBD::Sponge man page on AIX

Man page or keyword search:  
man Server   4752 pages
apropos Keyword Search (all sections)
Output format
AIX logo
[printable version]

DBD::Sponge(3)	      User Contributed Perl Documentation	DBD::Sponge(3)

       DBD::Sponge - Create a DBI statement handle from Perl data

	 my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });
	 my $sth = $sponge->prepare($statement, {
		 rows => $data,
		 NAME => $names,

       DBD::Sponge is useful for making a Perl data structure accessible
       through a standard DBI statement handle. This may be useful to DBD mod‐
       ule authors who need to transform data in this way.


	 my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });

       Here's a sample syntax for creating a database handle for the Sponge
       driver.	No username and password are needed.


	 my $sth = $sponge->prepare($statement, {
		 rows => $data,
		 NAME => $names,

       ·   The $statement here is an arbitrary statement or name you want to
	   provide as identity of your data. If you're using DBI::Profile it
	   will appear in the profile data.

	   Generally it's expected that you are preparing a statement handle
	   as if a "select" statement happened.

       ·   $data is a reference to the data you are providing, given as an
	   array of arrays.

       ·   $names is a reference an array of column names for the $data you
	   are providing.  The number and order should match the number and
	   ordering of the $data columns.

       ·   %attr is a hash of other standard DBI attributes that you might
	   pass to a prepare statement.

	   Currently only NAME, TYPE, and PRECISION are supported.

       Using this module to prepare INSERT-like statements is not currently

       This module is Copyright (c) 2003 Tim Bunce

       Documentation initially written by Mark Stosberg

       The DBD::Sponge module is free software; you can redistribute it and/or
       modify it under the same terms as Perl itself. In particular permission
       is granted to Tim Bunce for distributing this as a part of the DBI.


perl v5.8.8			  2011-09-14			DBD::Sponge(3)
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server AIX

List of man pages available for AIX

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
Vote for polarhome
Free Shell Accounts :: the biggest list on the net