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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
padre::help
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)