SYBASE_PCONNECT(3)SYBASE_PCONNECT(3)sybase_pconnect - Open persistent Sybase connectionSYNOPSIS
resource sybase_pconnect ([string $servername], [string $username], [string $password], [string $charset], [string $appname])
DESCRIPTION sybase_pconnect(3) acts very much like sybase_connect(3) with two major differences.
First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and
password. If one is found, an identifier for it will be returned instead of opening a new connection.
Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for
future use (sybase_close(3) will not close links established by sybase_pconnect(3)).
This type of links is therefore called 'persistent'.
PARAMETERS
o $servername
- The servername argument has to be a valid servername that is defined in the 'interfaces' file.
o $username
- Sybase user name
o $password
- Password associated with $username.
o $charset
- Specifies the charset for the connection
o $appname
- Specifies an appname for the Sybase connection. This allow you to make separate connections in the same script to the same data-
base. This may come handy when you have started a transaction in your current connection, and you need to be able to do a separate
query which cannot be performed inside this transaction.
RETURN VALUES
Returns a positive Sybase persistent link identifier on success, or FALSE on error.
SEE ALSO sybase_connect(3).
PHP Documentation Group SYBASE_PCONNECT(3)
Check Out this Related Man Page
INGRES_PCONNECT(3) 1 INGRES_PCONNECT(3)ingres_pconnect - Open a persistent connection to an Ingres databaseSYNOPSIS
resource ingres_pconnect ([string $database], [string $username], [string $password], [array $options])
DESCRIPTION
Open a persistent connection to an Ingres database.
There are only two differences between this function and ingres_connect(3): First, when connecting, the function will initially try to
find a (persistent) link that is already opened with the same parameters. If one is found, an identifier for it will be returned instead of
opening a new connection. Second, the connection to the Ingres server will not be closed when the execution of the script ends. Instead,
the link will remain open for future use (ingres_close(3) will not close links established by ingres_pconnect(3)). This type of link is
therefore called "persistent".
PARAMETERS
o $database
- The database name. Must follow the syntax: $[vnode::]dbname[/svr_class]
o $username
- The Ingres user name
o $password
- The password associated with $username
o $options
- See ingres_connect(3) for the list of options that can be passed
RETURN VALUES
Returns an Ingres link resource on success or FALSE on failure
SEE ALSO ingres_connect(3), ingres_close(3).
PHP Documentation Group INGRES_PCONNECT(3)
I use ps -fu in a script. It was working for a different box. Here, the username is very long. This is causing the command to error out with a message "unknown username". How do I see all the processes owned by this user?
Thanks,
Keerti (4 Replies)
Hi all,
I am trying to connect to Remote Sybase database Server through shell script. I am operating on WindowsXP, connect to Unix(version SunOS: 5.8)
The thing is i dont know how to connect to Sybase Server through my script file?
Are there any manual pages which can guide me through the... (3 Replies)
Can we write a script to telnet to a unix server from unix with the username and password hardcoded in the script??
something like ssh a@b -p password ??? (5 Replies)
hi frnds,
I have written a script as follows.
ssh username@servername "find $1 -type f -name $2 -mtime +1 -exec rm '{}' \;"
when i excute tis script i get error
FIND: Parameter format not correct
parameter 2 is the file name .. .
Thx in advance (6 Replies)
Hi
I would like to take input from user like username/password@connectstring
I should be able to cut the username and password and connect string
for example if someone enters like
sam/sammy@ora1
my program should take sam as username sammy as password and ora1 as connectstring and... (3 Replies)
Hi
I am trying to connect to oracle using shell script with username/pwd@constring
The password is having special character . I have to ignore the special character else i am getting invalid username or password. How to achieve that
My password is having $ , but the... (5 Replies)
Hi,
For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus... (4 Replies)
I am trying to create a basic script that converts an Oracle script into a Sybase script.
The only things im changing are Datatypes and the to_char and to_date functions.
I am not really 100% sure of the way it works. I have tried running the functions through a loop to replace each word line... (6 Replies)
Hi,
How do i check if Sybase is installed on aix..The sybase guy is doing remote installation and i need to check if he has installed sybase or not.
ive tried the following approaches.
#lslpp -L "*Sybase*" # tried other strings like "*ybase*" , "*base*"
#lslpp -ha |grep syb # tried... (4 Replies)
Hi
I wrote a script for connecting isql(Sybase database) and stored the SQL output in Unix box.
my script:
isql -U${USER} -P${PASS} -S${SERVER} <<EOF > $WORK_DIR/out1.log
go
select convert(varchar(10),sdcurrent,101) from pr_sysdate
go
exit
EOF
Unfortunately, the output file not... (5 Replies)
Hi guys,
I am using Solaris 10 and we install IBM OnDemand server there. there's a command called arsload that we use to load document and query document too. I need to write a script to query document but when querying document, this command prompt for username then password.
My question is... (3 Replies)
i read thru a few article how to do it, but i could not get it to work the way i want it.
vi ../httpd.conf
Redirect permanent /dev https://servername/portal/
when i type servername, works fine.
my goal is to type dev, and it takes me to https://servername/portal/ (4 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)
I am trying to setup a password less connection from a Linux server to Window server and will be using a script to scp a file without using password.
Linux Server (source)
servername : testlinux
id : testbatch
Windows Server (Target)
servername : testwin
id : testwinlogin
I copied... (5 Replies)
Hi All,
I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table.
I have a file called vrs_temp.txt (with two columns):
22055;20181001
21088;20181001
93840;20181001
30990;20181001
50990;20181001
50950;20181001Created a... (4 Replies)