Perl with Sql Server2005

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set...

2. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

3. Shell Programming and Scripting

PERL : Bind 2D array to SQL

Hi, I am in the need of doing a bulk insert via : SQL - INSERT INTO <table> (SELECT..) OR PLSQL Block - FORALL i IN 1 .. count INSERT INTO <table>(arrayname(i)) I have a 2D array in my perl code which has the rows to be bulk inserted. Is there a way to bind the 2D array to the SQL...

4. Shell Programming and Scripting

Handling SQL prompt through Perl expect module

Hi All, I have a doubt whether expect module in perl will work in SQL prompt or its applicable only for shell prompt ? Thanks, Arun V

5. Shell Programming and Scripting

run sql query via perl script

Hello, If I run this command on the server it works. # dbc "update config set radio_enabled = 0;" how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver...

6. UNIX for Dummies Questions & Answers

.sql file in perl

Hi, Can anybody help me to create .sql file in PERL. Requiement: while executing a query in perl script instead of writting a query output in to a file in .csv, is there a way to create directly .sql file. Please reply at the earliest. Thanks for your support.

7. Shell Programming and Scripting

Reading PL/SQL output online from perl??

Hi there, I got this situation at job. First i have a Perl script that connect to Oracle 10g and execute a package. That package execute severals transactions and must generate log about process status each interval of time. What i'm doing now is saving the plsql package log in an auxiliar...

8. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular...

9. Shell Programming and Scripting

Perl sql table upload variable problem

Hi, I wrote a perl script to create and upload data to a mysql data base. Please see the script as shown below, #!/usr/bin/perl -w #Defenetion of modules use in this scrpt use CGI qw(:standard); use DBI ; my $datetable1 = `date +%Y%m%d`; my $datetable = $datetable1 ; print...

10. Shell Programming and Scripting

Incorrect SQL query in perl

I the the following perl script, however it does not return anything. Did i form my syantax wrongly? $sth=$dbh->prepare("select a.rowid,a.* from Table1 a where a.field1 = \'$Indicator1\' and a.schedule = \'$Indicator2\' and a.lastdate <= sysdate"); $sth->execute() ...

LEARN ABOUT DEBIAN

padre::plugin::yaml

Padre::Plugin::YAML(3pm)				User Contributed Perl Documentation				  Padre::Plugin::YAML(3pm)

NAME

       Padre::Plugin::YAML - YAML support for Padre The Perl IDE

VERSION

       This document describes Padre::Plugin::YAML version 0.06

DESCRIPTION

       YAML support for Padre, the Perl Application Development and Refactoring Environment.

       Syntax highlighting for YAML is supported by Padre out of the box.  This plug-in adds some more features to deal with YAML files.

   Example
       Example is not revelant as this is a Padre::Plugin

BUGS AND LIMITATIONS

       No bugs have been reported.

METHODS

       o     menu_plugins_simple

       o     padre_interfaces

       o     plugin_enable

       o     plugin_disable

       o     plugin_name

       o     registered_documents

       o     show_about

SUPPORT

       You can find documentation for this module with the perldoc command.

	 perldoc Padre::Plugin::YAML

       You can also look for information at:

       o   RT: CPAN's request tracker

	   http://rt.cpan.org/NoAuth/Bugs.html?Dist=Padre-Plugin-YAML <http://rt.cpan.org/NoAuth/Bugs.html?Dist=Padre-Plugin-YAML>

       o   AnnoCPAN: Annotated CPAN documentation

	   http://annocpan.org/dist/Padre-Plugin-YAML <http://annocpan.org/dist/Padre-Plugin-YAML>

       o   CPAN Ratings

	   http://cpanratings.perl.org/d/Padre-Plugin-YAML <http://cpanratings.perl.org/d/Padre-Plugin-YAML>

       o   Search CPAN

	   http://search.cpan.org/dist/Padre-Plugin-YAML/ <http://search.cpan.org/dist/Padre-Plugin-YAML/>

AUTHOR

       Zeno Gantner <zenog@cpan.org>

CONTRIBUTORS

       Kevin Dawson  <bowtie@cpan.org>

       Ahmad M. Zawawi <ahmad.zawawi@gmail.com>

LICENCE AND COPYRIGHT

       Copyright (c) 2011-2012, Zeno Gantner <zenog@cpan.org>. All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.

perl v5.14.2							    2012-05-15						  Padre::Plugin::YAML(3pm)

Shell Programming and Scripting