Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ifx_pconnect(3) [php man page]

IFX_PCONNECT(3) 							 1							   IFX_PCONNECT(3)

ifx_pconnect - Open persistent Informix connection

SYNOPSIS
resource ifx_pconnect ([string $database], [string $userid], [string $password]) DESCRIPTION
ifx_pconnect(3) acts very much like ifx_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 (ifx_close(3) will not close links established by ifx_pconnect(3)). This type of links is therefore called 'persistent'. PARAMETERS
All of the arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (ifx.default_host for the host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the password (none if not defined). o $database - The database name, as a string. o $userid - The username, as a string. o $password - The password, as a string. RETURN VALUES
Returns: valid Informix persistent link identifier on success, or FALSE on errors. SEE ALSO
ifx_connect(3). PHP Documentation Group IFX_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. HP-UX

Upgrade HP UX in Informix environment

Currently running Informix 7.23 UC11 on HP UX 10.20. Want to upgrade O/S to HP UX 11i. ANyone done this before? will informix 7.23 run on 11i? Thanks. (4 Replies)
Discussion started by: mrviking
4 Replies

2. UNIX for Advanced & Expert Users

Inserting a new column in a file

Hey.. I'm writing a code to download some stuff from Informix database and put it on Xls. It works fine, but I have a problem fitting in a new requirement. I have currently a file which has information like below. f_name|Ronnie|Johnson|23.00| f_sal|Ronnie|Jhonson|4000.00|... (4 Replies)
Discussion started by: rosh0623
4 Replies

3. Shell Programming and Scripting

unix command to find the version of Informix database

Hi All Please let me know if there is command to check the version of the informix database installed..? Thanks in advance. Suresh (4 Replies)
Discussion started by: sureshg_sampat
4 Replies

4. Web Development

SQL Select inside Insert

I have following. . . . $userid = 2 . $query = "select username from users where userid = ".$userid.";"; . $username = $line; $data="Some Data Here"; . $query = "insert into logger (username, data) valuse ($username, $data);"; . I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 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. Solaris

Check Database availability?

Hi All, My script gets aborted as it is connecting as a remote database through a DB link on every 3rd sunday.As the remote DB is down for more than 6 hours. Can TNSPING DBNAME inside my script ensure the database is up??? Then how can i check the database is up or down ? ... (2 Replies)
Discussion started by: megh
2 Replies

7. AIX

How to check password expiry in AIX?

Hi All, Could anyone please help me with the command or script for checking the password expiry for a particular userid on AIX. Regards, Sanjay...:) (5 Replies)
Discussion started by: SanjayPasum
5 Replies

8. Shell Programming and Scripting

Get Database Service Names

Hi Everyone, I want to know which database (Oracle,SQL,Informix...) are installed on Unix Machine. I have very limited experience on Unix Environment, :confused: So I have no idea of getting this information. But in windows we can get Service names using WMI. Is there any similar way of Doing... (5 Replies)
Discussion started by: Roshan1286
5 Replies

9. Programming

how to obtain a persistent oracle connection in proc*c pthread

Hi all, I have problem to set up a persistent oracle connection in child thread. We have a massive batch process dealing with large data. Application was written and impossible to be rewritten. I am trying to extract the most time consuming data fetching and put it into a dedicated child... (3 Replies)
Discussion started by: ora-dev
3 Replies

10. UNIX for Dummies Questions & Answers

userid and pw

questions: a. where can I customized the password of userid in solaris? say I wanted 10digits long, all caps? thanks (4 Replies)
Discussion started by: lhareigh890
4 Replies

11. Shell Programming and Scripting

Calling DB user from separate file in Shell script

Hi All, I need to execute a SQL via shell script and i am connecting to Oracle DB by this way $USERNAME1/$PASSWORD1@$STRING1 and i need to get username, password and string from someother file stored in the Unix Directory. $Username, $Password and $String is stored in File A in Path A and i want... (3 Replies)
Discussion started by: sathish.tn
3 Replies

12. Shell Programming and Scripting

How to read userid and password information from txt file

Hi Experts, I am writing a shell script (for displaying disk space details) which is logging to 15 different servers using following command. ssh userid@servername It is prompting me for password for all 15 servers when I manually run it. However , soon I would like to schedule this script... (4 Replies)
Discussion started by: ajaypatil_am
4 Replies

13. SCO

Kernel parameters for Informix on Open Server 6

Hi guys, Anybody is running Informix Dynamic Server on Open Server 6? Can you share your kernel parameters for SHM, SEM, etc.? I have a situation where oninit stops starting when the BUFFERS Informix parameter is increased. Already went through the machine release notes for Informix but... (6 Replies)
Discussion started by: ferdez
6 Replies

14. AIX

Change processor compatibility mode without hmc

Hello, One of my colleagues is working on a p730 without HMC, only one LPAR has all resources. The server is showing some issues with Informix (10.00 & 11.50), the same config (OS & IFX) works perfectly on Power6 so I would like to ask him to change the processor compatibility mode to power6 on... (3 Replies)
Discussion started by: fapl
3 Replies

15. Shell Programming and Scripting

Script for database task.

Hi, I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password. Could you please provide the script for this task? Steps are given below. 1. Login into database from server sqlplus... (5 Replies)
Discussion started by: Maddy123
5 Replies