checking sql connectivity in unix Post: 302210664

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

My sql connectivity

Hi myself rupesh, i want the mysql database connectivity and a simple shell script.. also if the links of books for shell programming

2. Shell Programming and Scripting

Dos-Unix Connectivity

Hi, Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt.

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

4. Programming

Checking columns in SQL, comparing user input and sizes.

I'm writing a KSH shell script that's using SQL though DB2. If I have a table defined and populated db2 "create table tb(num int,letter char(4))" db2 "insert into tb values(111,a) db2 "insert into tb values(112,b) db2 "insert into tb values(111,c) How can I check if a letter user...

5. Shell Programming and Scripting

Database connectivity using unix

Hi, I am trying to connect to the database through Unix serer using following command- mysql -u root -Jepadt -D dtdatabase But it giving me error - mysql: unknown option '-J' Can anybody help me to solve this problm Thanks in advance Please use code tags, thanks.

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

7. Windows & DOS: Issues & Discussions

Help with Windows to Unix connectivity

Hi Can we pass the parameter from the excel in windows and invoke the unix shell script from excel VBA by passing this parameter and get the results of shell script to the excel sheet? We tried to get the things in unix independently but we still strucked in connecting the excel to...

8. Programming

Dynamically checking rules in database tables using SQL

I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5. I plan to do this mechanically, so the approach should work for any table in my database schema. Suppose for illustration purposes I start with the following table: CREATE TABLE `sources` ( ...

9. Shell Programming and Scripting

Checking SQL DB Availability

Hello everybody. I have a little question. Im creating a script for checking the status of different servers, and everything is running fine except for one thing. I have to check if certain DBs are connectables, I dont care anything else, nor running querys nor updating tables, the only thing I...

LEARN ABOUT REDHAT

tcp-env

tcp-env(1)                                                    General Commands Manual                                                   tcp-env(1)

NAME

       tcp-env - set up TCP-related environment variables

SYNOPSIS

       tcp-env [ -rR ] [ -ttimeout ] program [ arg ...  ]

DESCRIPTION

       The  input  for  tcp-env  must be a TCP connection.  tcp-env finds out information about that connection, puts the information into several
       environment variables as described in tcp-environ(5), and runs program with the given arguments.

       Usually tcp-env is run from inetd.  It might instead be run from another server that already sets up the right  environment  variables;  if
       PROTO  is  set  to  TCP  when  tcp-env  is invoked, tcp-env assumes that all the other variables are set up properly, and it does not check
       whether the input is a TCP connection.

OPTIONS

       -r     (Default.)  Attempt to obtain TCPREMOTEINFO from the remote host.

       -R     Do not attempt to obtain TCPREMOTEINFO from the remote host.

       -ttimeout
              Give up on the TCPREMOTEINFO connection attempt after timeout seconds.  Default: 30.

SEE ALSO

       tcp-environ(5), inetd(8)

                                                                                                                                        tcp-env(1)