Hi
i want write a script for list of sysbase are having access or open.
then i wrote like:
then i can find some error messgae if some of database not found the server.
But i am not sure is this only way to find the database hasbeen running or not.
I hope we can use opendatabase command in sybase.. but i am not sure about this.please help me on this to write a single script for find the dabase are access or not.
---------- Post updated 02-26-10 at 09:54 AM ---------- Previous update was 02-25-10 at 02:31 PM ----------
Pls anyone tell me the Isql opendatabase issue
Last edited by koti_rama; 02-26-2010 at 06:59 AM..
Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
hi all
i have an isql sentence in a ksh script, what get some values from my database (Sybase IQ 12.5 - solaris 5.7)
how can i read this sql results??? do i have to do a while?? a for???
where do i put the values??
my idea is put them in an array, is that possible?
please, help me... (3 Replies)
Hi All-
First time using iSql.
I have 4 query files - some have more than 1 line of sql statements
After a bit of research it appears I can just use the -i command and specify the input file.
Questions:
Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Hi All,
O/S: Linux 86x64 Red Hat
I have a sql script that queries top consuming processes of Linux using TOP commnd.
Now I need to automate this task and pass the top processes i.e., PID to the sql script through unix shell script.
Could anyone please let me know how to achieve this.
... (2 Replies)
Hi guys,
I've create 3 shells concerning my work, which named as 1.sh, 2.sh and 3.sh.
However, how can I make an interactive query for these shells just like the old (fdisk) in windows9x. I want to make an interface tells the user just like this:
Press 1 to execute "1.sh"
Press 2 to... (5 Replies)
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT SUSE
net::config
Net::Config(3pm) Perl Programmers Reference Guide Net::Config(3pm)NAME
Net::Config - Local configuration data for libnet
SYNOPSYS
use Net::Config qw(%NetConfig);
DESCRIPTION
"Net::Config" holds configuration data for the modules in the libnet distribution. During installation you will be asked for these values.
The configuration data is held globally in a file in the perl installation tree, but a user may override any of these values by providing
their own. This can be done by having a ".libnetrc" file in their home directory. This file should return a reference to a HASH containing
the keys described below. For example
# .libnetrc
{
nntp_hosts => [ "my_preferred_host" ],
ph_hosts => [ "my_ph_server" ],
}
__END__
METHODS
"Net::Config" defines the following methods. They are methods as they are invoked as class methods. This is because "Net::Config" inherits
from "Net::LocalCfg" so you can override these methods if you want.
requires_firewall HOST
Attempts to determine if a given host is outside your firewall. Possible return values are.
-1 Cannot lookup hostname
0 Host is inside firewall (or there is no ftp_firewall entry)
1 Host is outside the firewall
This is done by using hostname lookup and the "local_netmask" entry in the configuration data.
NetConfig VALUES
nntp_hosts
snpp_hosts
pop3_hosts
smtp_hosts
ph_hosts
daytime_hosts
time_hosts
Each is a reference to an array of hostnames (in order of preference), which should be used for the given protocol
inet_domain
Your internet domain name
ftp_firewall
If you have an FTP proxy firewall (NOT an HTTP or SOCKS firewall) then this value should be set to the firewall hostname. If your
firewall does not listen to port 21, then this value should be set to "hostname:port" (eg "hostname:99")
ftp_firewall_type
There are many different ftp firewall products available. But unfortunately there is no standard for how to traverse a firewall. The
list below shows the sequence of commands that Net::FTP will use
user Username for remote host
pass Password for remote host
fwuser Username for firewall
fwpass Password for firewall
remote.host The hostname of the remote ftp server
0 There is no firewall
1
USER user@remote.host
PASS pass
2
USER fwuser
PASS fwpass
USER user@remote.host
PASS pass
3
USER fwuser
PASS fwpass
SITE remote.site
USER user
PASS pass
4
USER fwuser
PASS fwpass
OPEN remote.site
USER user
PASS pass
5
USER user@fwuser@remote.site
PASS pass@fwpass
6
USER fwuser@remote.site
PASS fwpass
USER user
PASS pass
7
USER user@remote.host
PASS pass
AUTH fwuser
RESP fwpass
ftp_ext_passive
ftp_int_passive
FTP servers can work in passive or active mode. Active mode is when you want to transfer data you have to tell the server the address
and port to connect to. Passive mode is when the server provide the address and port and you establish the connection.
With some firewalls active mode does not work as the server cannot connect to your machine (because you are behind a firewall) and the
firewall does not re-write the command. In this case you should set "ftp_ext_passive" to a true value.
Some servers are configured to only work in passive mode. If you have one of these you can force "Net::FTP" to always transfer in
passive mode; when not going via a firewall, by setting "ftp_int_passive" to a true value.
local_netmask
A reference to a list of netmask strings in the form "134.99.4.0/24". These are used by the "requires_firewall" function to determine
if a given host is inside or outside your firewall.
The following entries are used during installation & testing on the libnet package
test_hosts
If true then "make test" may attempt to connect to hosts given in the configuration.
test_exists
If true then "Configure" will check each hostname given that it exists
perl v5.12.1 2010-07-01 Net::Config(3pm)