IFX_PCONNECT(3) 1 IFX_PCONNECT(3)ifx_pconnect - Open persistent Informix connectionSYNOPSIS
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 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)
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)
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)
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)
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 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)
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)
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)
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)
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)
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)
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)
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)
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)