Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sybase_pconnect(3) [php man page]

SYBASE_PCONNECT(3)														SYBASE_PCONNECT(3)

sybase_pconnect - Open persistent Sybase connection

SYNOPSIS
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 database

SYNOPSIS
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)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ps -fu

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)
Discussion started by: keerti
4 Replies

2. Shell Programming and Scripting

Connect to a Remote Sybase Server Through Script

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)
Discussion started by: Aparna_k82
3 Replies

3. Shell Programming and Scripting

username password in script

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)
Discussion started by: roshanjain2
5 Replies

4. Shell Programming and Scripting

Err while using find command

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)
Discussion started by: vikramsnest
6 Replies

5. UNIX for Dummies Questions & Answers

to separate values from a string

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)
Discussion started by: ssuresh1999
3 Replies

6. UNIX for Dummies Questions & Answers

Oracle Password having special character

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)
Discussion started by: ssuresh1999
5 Replies

7. Shell Programming and Scripting

oracle connection from shell script

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)
Discussion started by: DILEEP410
4 Replies

8. UNIX for Dummies Questions & Answers

Help understanding sed

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)
Discussion started by: Makaer
6 Replies

9. AIX

Check Sybase installation

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)
Discussion started by: muzahed
4 Replies

10. Shell Programming and Scripting

isql out in shell script

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)
Discussion started by: koti_rama
5 Replies

11. Shell Programming and Scripting

input username and password interactively

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)
Discussion started by: markthien
3 Replies

12. Web Development

redirect http to https in apache

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)
Discussion started by: lawsongeek
4 Replies

13. Shell Programming and Scripting

Sybase connection failing through shell script

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)
Discussion started by: Irishboy24
6 Replies

14. Shell Programming and Scripting

SSH Connectivity

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)
Discussion started by: dr46014
5 Replies

15. Shell Programming and Scripting

Bcp command error in uploading data to Sybase

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)
Discussion started by: Suresh
4 Replies