Perl with Sql Server2005


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Perl with Sql Server2005
# 1  
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
Login or Register to Ask a Question

Previous Thread | Next Thread

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

2. 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

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

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

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

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

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

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

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

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() ... (1 Reply)
Discussion started by: new2ss
1 Replies
Login or Register to Ask a Question
Padre::Current(3pm)					User Contributed Perl Documentation				       Padre::Current(3pm)

NAME
Padre::Current - A context object, for centralising the concept of what is "current" DESCRIPTION
The "Padre::Current" detectes and returns whatever is current. Use it whenever you need to do something with anything which might get a focus or be selectable otherwise All methods could be called as functions, methods or class methods. CLASS METHODS
"config" my $config = Padre::Current->config; Returns a Padre::Config object for the current document. Padre has three types of configuration: User-specific, host-specific and project-specific, this method returnsa config object which includes the current values - ne need to for you to care about which config is active and which has priority. "document" my $document = Padre::Current->document; Returns a Padre::Document object for the current document. "editor" my $editor = Padre::Current->editor; Returns a Padre::Editor object for the current editor (containing the current document). "filename" my $filename = Padre::Current->filename; Returns the filename of the current document. "ide" my $ide = Padre::Current->ide; Returns a Padre::Wx object of the current ide. "main" my $main = Padre::Current->main; Returns a Padre::Wx::Main object of the current ide. "notebook" my $main = Padre::Current->notebook; Returns a Padre::Wx::Notebook object of the current notebook. "project" my $main = Padre::Current->project; Returns a Padre::Project object of the current project. "text" my $main = Padre::Current->text; Returns the current selection (selected text in the current document). "title" my $main = Padre::Current->title; Returns the title of the current editor window. NAME
Padre::Current - convenient access to current objects within Padre SYNOPSIS
my $main = Padre::Current->main; # ... DESCRIPTION
Padre uses lots of objects from different classes. And one needs to have access to the current object of this sort or this other to do whatever is need at the time. Instead of poking directly with the various classes to find the object you need, "Padre::Current" provides a bunch of handy methods to retrieve whatever current object you need. METHODS
new # Vanilla constructor Padre::Current->new; # Seed the object with some context Padre::Current->new( document => $document ); The "new" constructor creates a new context object, it optionally takes one or more named parameters which should be any context the caller is aware of before he calls the constructor. Providing this seed context allows the context object to derive parts of the current context from other parts, without the need to fall back to the last-resort "Padre->ide" singleton-fetching method. Many objects in Padre that are considered to be part of them context will have a "current" method which automatically creates the context object with it as a seed. Returns a new Padre::Current object. "ide" Return the Padre singleton for the IDE instance. "config" Returns the current Padre::Config configuration object for the IDE. "main" Returns the Padre::Wx::Main object for the main window. "notebook" Returns the Padre::Wx::Notebook object for the main window. "document" Returns the active Padre::Document document object. "editor" Returns the Padre::Editor editor object for the active document. "filename" Returns the file name of the active document, if it has one. "title" Return the title of current editor window. "project" Return the "Padre::Project" project object for the active document. "text" Returns the selected text, or a null string if nothing is selected. COPYRIGHT &; LICENSE Copyright 2008-2012 The Padre development team as listed in Padre.pm. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. perl v5.14.2 2012-06-27 Padre::Current(3pm)