Hi All,
I was able to connect to sybase in shell script and also able to run few sql queries, something like this,
#!/usr/bin/ksh -x
temp=`echo "select name from sysobjects where type = 'U'"`
results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF
set rowcount 6
$temp
go
EOF`
line_count=0... (1 Reply)
Hi All,
This is my first post. Need your favour guys.
I need to authenticate syabse login/password thru shell script.
I am getting the ID & Pwd form user and storing it in variable..
But how to authenticate and echo user back if the id/pwd doesnt work.
isql -U$1 -P$2 -S$3 ??
... (1 Reply)
Hi
I want to create a script that will authenticate user from a file and if both of them match then only the script is allowed to be executed...
Suppose I have a script say test.sh and a file config.txt
for users whose user ids exist in the text file should only be given permission to... (1 Reply)
Greetings,
I need to capture the output of a Sybase stored procedure, inside my
shell script( k shell). Based on this output, I need to call another
perl script, with input arguments as the result set of the procedure
execution. I need to keep looping through and call the perl script, ... (2 Replies)
Using unix shell script file I need to telnet to a IP further send a command to the telnet IP and get the response to a file with out using "expect" utility and I have achieved this by below command.
(sleep 3; echo admin; sleep 3; echo mypass; sleep 5;echo "show status-list"; sleep 5; echo... (3 Replies)
Hi,
I need to check the sysbase database connectivity through the Unix Shell Script. Can you help me on the how to write the script to test the sysbase database connection.
Thanks in Advance
Nandha (0 Replies)
Hi All,
I'm trying to connect to Sybase via shell script. i'm getting the following error.
Please let me know where i'm going wrong. Note that i'm not having this issue when connecting via terminal.
#!/usr/bin/bash
SYBASE=/usr/sybase
ISQL=$SYBASE/bin/isql
export SYBASE ISQL
... (6 Replies)
Hi, I am new to advanced scripting.
I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters.
I need to do this via shell scripting, I have got half logic (on how to get varchar/char columns and stored it in a... (2 Replies)
Hi,
is that possible to login to solaris 11.1 authenticate with windows active directory? the user id is created in the windows active directory.
Environment:
Solaris 11.1
Windows 2012 Active Directory (3 Replies)
Discussion started by: freshmeat
3 Replies
LEARN ABOUT SUNOS
list-connector-connection-pools
asadmin-list-connector-connection-pools(1AS) User Commands asadmin-list-connector-connection-pools(1AS)NAME
asadmin-list-connector-connection-pools, list-connector-connection-pools - gets all the connection pools
SYNOPSIS
list-connector-connection-pools --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure |-s] [--password-
file filename] [--terse=false] [--echo=false] [--interactive=true]
gets all the connector connection pools. This command is supported in remote mode only.
OPTIONS --user authorized domain application server administrative username.
--password password to administer the domain application server.
--host machine name where the domain application server is running.
--port port number of the domain application server listening for administration requests.
--secure if true, uses SSL/TLS to communicate with the domain application server.
--passwordfile file containing the domain application server password.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script. Default is false.
--echo setting to true will echo the command line statement on the standard output. Default is false.
--interactive if set to true (default), only the required password options are prompted.
Example 1: Using list-connector-connection-pools
asadmin> list-connector-connection-pools --user admin
--password adminadmin
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-create-connector-connection-pool(1AS), asadmin-delete-connector-connection-pool(1AS)J2EE 1.4 SDK March 2004 asadmin-list-connector-connection-pools(1AS)