.sql file in perl

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

3. Shell Programming and Scripting

perl- oracle sql query

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

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

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. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

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. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

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

cvm-mysql

cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME

       cvm-mysql - MySQL module

SYNOPSIS

       cvm-mysql

CREDENTIALS

       Pass phrase

DESCRIPTION

       This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).

CONFIGURATION VARIABLES

       CVM_MYSQL_DEFAULT_FILE
	      The  full  path of the defaults file to read if the following variable is set.  If not set, the file $HOME/.my.cnf will be read (the
	      MySQL default).

       CVM_MYSQL_DEFAULT_GROUP
	      If set, the module will read connection default options from the named group in the defaults file as above

       CVM_MYSQL_HOST
	      The hostname or IP of the MySQL server.  If not set, a connection to the local host is assumed.

       CVM_MYSQL_USER
	      The MySQL login ID to connect as.  If not set, the invoking user is assumed.

       CVM_MYSQL_PASS
	      The password for the above user.

       CVM_MYSQL_DB
	      The database name, must be set.

       CVM_MYSQL_PORT
	      The port number for the TCP/IP connection (only used if the server is not local).

       CVM_MYSQL_POSTQ (optional)
	      The SQL query to execute after the credentials have been validated, see cvm-sql(7).

       CVM_MYSQL_PWCMP (optional)
	      The password comparison module to use.

       CVM_MYSQL_SOCKET
	      The path to the socket that should be used for connections to a local server.

       CVM_MYSQL_QUERY (optional)
	      The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).

SEE ALSO

       cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8),  cvm-benchclient(8),  cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/pwcmp/pwcmp.html
	http://untroubled.org/cvm/cvm.html

																      cvm-mysql(8)

UNIX for Dummies Questions & Answers