Connectivity to Bteq through Perl Post: 302211274

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Database connectivity

Dear all, can any body help me about database connectivity? i want to data by extracting from oracle... so please give me some idea... Thanks, Regards, Pankaj

2. UNIX for Dummies Questions & Answers

Log file not getting populated when using BTEQ

Hi, I am trying to run some SQL scripts under the UNIX server using BTEQ. When I try to create a log file, the file gets populated only to the point where I log into BTEQ. The log file for the running of the actual script does not seem to be stored. Would any one know ehy this could be...

3. IP Networking

Connectivity check.

How to check connectivity with an external server if I know the IP. Please note traceroute is not working for me, as it is saying command not found.

4. IP Networking

Lack of IP Connectivity

Hi Can any one please help identify the issue in scenario 2: Connectivity Diagram: 1) Distribution Switch----Int_Switch----LabSwitch(Fa1/0)----Terminal Ser 2) Distribution Swtich----Int_Swtich----LabSwitch(Fa2/0)----3640 Router ---all links are access links Distribution Switch...

5. Shell Programming and Scripting

Teradata connectivity through UNIX by use bteq

Hi, I want a script for connecting teradata to load the file to teradata table. Can you please help me out. Thanks in advance.

6. Shell Programming and Scripting

How to pass parameter to bteq?

I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as below code but not working. bteq < /download/viv/dev/ops/Scripts/ter.sh FLTORGTKR_ORG_etc.. ...

7. UNIX and Linux Applications

Using BTEQ with perl to Teradata

Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into...

8. Shell Programming and Scripting

How to write BTEQ batch scripts in UNIX?

Hi All, I need to write Unix shell script. To star with : I need to do some file checking on unix file system, then based on file existance, I need to run diff SQL in Teradata Bteq. After that, depending on Results of SQL, I need to code other shell scripting like moving file, within same...

9. Shell Programming and Scripting

BTEQ script in Shell Script

Hi Team, I have a requirement where I need to check for table. If exists, drop it else do nothing. For that I written below code. T_NAME="V_"`echo ${PARAM_BASE} | cut -d'_' -f4-` tab_name="UV_"${T_NAME} query_et() { bteq << EOBTQ | grep '^>' | sed -e "s/^>//" ...

LEARN ABOUT SUSE

cpanplus::shell::default::plugins::remote

CPANPLUS::Shell::Default::Plugins::Remote(3pm)		 Perl Programmers Reference Guide	    CPANPLUS::Shell::Default::Plugins::Remote(3pm)

NAME

       CPANPLUS::Shell::Default::Plugins::Remote

SYNOPSIS

	   CPAN Terminal> /connect localhost 1337 --user=foo --pass=bar
	   ...
	   CPAN Terminal@localhost> /disconnect

DESCRIPTION

       This is a "CPANPLUS::Shell::Default" plugin that allows you to connect to a machine running an instance of "CPANPLUS::Daemon", allowing
       remote usage of the "CPANPLUS Shell".

       A sample session, updating all modules on a remote machine, might look like this:

	   CPAN Terminal> /connect --user=my_user --pass=secret localhost 1337

	   Connection accepted

	   Successfully connected to 'localhost' on port '11337'

	   Note that no output will appear until a command has completed
	   -- this may take a while

	   CPAN Terminal@localhost> o; i *

	   [....]

	   CPAN Terminal@localhost> /disconnect

	   CPAN Terminal>

BUG REPORTS

       Please report bugs or other issues to <bug-cpanplus@rt.cpan.org<gt>.

AUTHOR

       This module by Jos Boumans <kane@cpan.org>.

COPYRIGHT

       The CPAN++ interface (of which this module is a part of) is copyright (c) 2001 - 2007, Jos Boumans <kane@cpan.org>. All rights reserved.

       This library is free software; you may redistribute and/or modify it under the same terms as Perl itself.

SEE ALSO

       CPANPLUS::Shell::Default, CPANPLUS::Shell, cpanp

perl v5.12.1							    2010-04-26			    CPANPLUS::Shell::Default::Plugins::Remote(3pm)