04-18-2002
accessing the informix database
How do I access Informix from unix? It's been about 2 years since I've last used unix and I've forgotten the command.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT PHP
ifx_pconnect
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)