Sponsored Content
Top Forums UNIX for Dummies Questions & Answers accessing the informix database Post 20515 by bysysnet on Sunday 28th of April 2002 11:09:18 AM
Old 04-28-2002
hi

.profile:
INFORMIXDIR=....
export INFORMIXDIR
INFORMIXSERVER=...
export INFORMIXSERVER
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to figure out the size in MB for an informix database

This is the info i have so far. please if you are dead positive can u let me know if i my math/process is correct. Chunks address chk/dbs offset size free bpages flags pathname 5003e1f8 1 1 0 250000 177177 PO- /database/link_cw_p01_rootdbs 5003e494 2 ... (5 Replies)
Discussion started by: Optimus_P
5 Replies

2. UNIX for Dummies Questions & Answers

Informix server

Hi, Just installed solaris Does anyone know where I can download Informix server for Unix thanks, (1 Reply)
Discussion started by: Mike1
1 Replies

3. UNIX for Dummies Questions & Answers

Informix

Hi there thanks for checking in. Would you know where i should go to find a Informix tutorial In html. Thanks in advance. (1 Reply)
Discussion started by: nemex
1 Replies

4. UNIX for Dummies Questions & Answers

offset - informix chunk

Hello all, I am trying to add chunks to my informix dataspace. I have one dataspace ( the rootdbs ) and the new chunk is a raw device. Precisely slice1 on my new external harddisk. The question is, what should be the offset value. The document says, the offset is used by the engine to... (1 Reply)
Discussion started by: shibz
1 Replies

5. SCO

Media for Informix 4.1

HI ! I NEED A MEDIA TO INSTALLING INFORMIX 4.1 IN SCO UNIX. OUR MEDIA ARE LOST AND THE SERVER IS GOING BAD ! HELP ME PLEASE ! THANK YOU VERY MUCH ! (5 Replies)
Discussion started by: tomribeiro
5 Replies

6. 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

7. UNIX and Linux Applications

Scripts for Informix

Hello, I want to write a ksh script to connect to a remote Informix DB and insert rows. I understand from the various threads that isql is the most popular choice and that it can be done. I'm new to both scripting and Informix and have some questions - 1) Does isql have listener/ tnsnames files... (1 Reply)
Discussion started by: zcanji
1 Replies

8. UNIX for Dummies Questions & Answers

Debian - Connect To Informix Database

Can anyone point me toward information on setting up a Debian server ODBC connection to an Informix server? I have a Windows server set up with the Informix drivers in ODBC and I'd like to do the same thing on Debian so that my Rails apps can query the database beneath our call-logging software. ... (1 Reply)
Discussion started by: badmoon75
1 Replies

9. Programming

Column update using Informix

Hi, I am using INFORMIX 8 and trying to update column value by apending '09' to existing record . update sample_data_table set Name = Name||22 where id = 90 and state = NY This worked fine in oracle Database,But throwing error in informix . I need output as Ravi22 for Ravi record in... (0 Replies)
Discussion started by: Perlbaby
0 Replies

10. Linux

Problem in accessing Oracle Database Server from Linux Machine

I am facing a strange issue in connecting to Oracle database from Linux Machine - The connectivity is not failing all the time , the failure to success ratio is 1:70. - Error "ORA-12545: Connect failed because target host or object does not exist" - Majority of the time the connection... (6 Replies)
Discussion started by: balaji kumar
6 Replies
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)
All times are GMT -4. The time now is 06:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy