Sponsored Content
Full Discussion: Perl with Sql Server2005
Top Forums Shell Programming and Scripting Perl with Sql Server2005 Post 302590252 by parthmittal2007 on Sunday 15th of January 2012 06:31:26 AM
Old 01-15-2012
Perl with Sql Server2005

Hi all,
I am getting an issue in connecting perl with sql server 2005.
I am unsing Padre as an IDE on Strawberry perl.

Please help me about this matter
 

10 More Discussions You Might Find Interesting

1. 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() ... (1 Reply)
Discussion started by: new2ss
1 Replies

2. 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... (2 Replies)
Discussion started by: maheshsri
2 Replies

3. 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... (1 Reply)
Discussion started by: userscript
1 Replies

4. 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... (4 Replies)
Discussion started by: jparra
4 Replies

5. 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. (0 Replies)
Discussion started by: jam_prasanna
0 Replies

6. 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... (0 Replies)
Discussion started by: sureshcisco
0 Replies

7. 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 (2 Replies)
Discussion started by: arun_maffy
2 Replies

8. 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 Replies)
Discussion started by: sinpeak
4 Replies

9. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks (1 Reply)
Discussion started by: tdev457
1 Replies

10. 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... (1 Reply)
Discussion started by: arunshankar.c
1 Replies
Padre::Help(3pm)					User Contributed Perl Documentation					  Padre::Help(3pm)

NAME
Padre::Help - Padre Help Provider API DESCRIPTION
The "Padre::Help" class provides a base class, default implementation and API documentation for help provision support in Padre. In order to setup a help system for a document type called "XYZ" one has to do the following: Create a module called "Padre::Help::XYZ" that subclasses the "Padre::Help" module and override 3 methods: "help_init", "help_list" and "help_render". In the class representing the Document ("Padre::Document::XYZ") one should override the "get_help_provider" method and return an object of the help provide module. In our case it should contain require Padre::Help::XYZ; return Padre::Help::XYZ->new; (TO DO: Maybe it should only return the name of the module) The "help_init" method is called by the new method of "Padre::Help" once for every document of "XYZ" kind. (TO DO: maybe it should be only once for every document type, and not once for every document of that type). "help_list" should return a reference to an array holding the possible strings the system can provide help for. "help_render" is called by one of the keywords, it should return the HTML to be displayed as help and another string which is the location of the help. Usually a path to a file that will be used in the title of the window. perl v5.14.2 2012-06-27 Padre::Help(3pm)
All times are GMT -4. The time now is 10:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy