ODBC Connectivity between Oracle10g on AIX and Mainframe Post: 302453353

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Aix 5.3 L Odbc

Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L

2. Solaris

How to check Oracle odbc connectivity in solaris ?

Hi, I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server. Please guide me how to do it in solaris env. Aru

3. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ...

4. AIX

ODBC on AIX

I�m using an app that uses odbc to connect to the data base, i thought odbc was only available for NT plataforms...anybody knows how to create an odbc connection on AIX 5.1 (if possible). Thanks a lot

5. AIX

Problems with SSH/SFTP between AIX and Mainframe

Hi, I'm not sure if this has been solved in this forum already but please do help me out if possible. Basically, I've already setup a passwordless SSH connection between 2 AIX IDs (say ID-1 and ID-2) with a Mainframe server ID (say MVSID). I'm able to successfully do an SSH from the AIX server to...

6. AIX

Problem in ftpying the datasets containing comp values to AIX from mainframe

Hi, When i am trying to ftp COBOL generated data sets which contain comp values to AIX in ASCII mode. the comp values are getting corrupted. If i ftp the data set in binary mode it is working properly, but for this i have to change some compiler options in the COBOL. Also if i want to use the...

7. Shell Programming and Scripting

shell script returning error code 2 from AIX to Mainframe

Hi, I have a shell script which is residing on AIX which is triggered by Mainframe through Connect Direct. The shell script creates several files and sends those files to mainframe using Connect Direct. The shell script is working fine, still it is returning exit code 2 to mainframe. What...

8. Red Hat

DB2 ODBC connectivity problem in RHEL5 32 bit

Hi, I installed Db2 9.7 on RHEL5 32bit . Instance Name is db2inst1 amd in that i created database as mydb. I exported env variables for classpath ,db2dir,db2instance LD_LIBRARY_PATH ,PATH ,ODBC, ODBCHOME ,ODBCINI My application needs ODBC connectivity and so I modified odbc.ini file . ...

9. Shell Programming and Scripting

FTP from AIX to Mainframe

Hi All, This is the scenario:- I am writing a script to automate FTP files from AIX to Mainframe. ( Binary mode, passive connection) FTP the currently available files(poll a directory to find the list) and put it to mainframe in one connection instance Verify if all the files are copied...

10. AIX

AIX Forum: FTP from AIX to Mainframe

This discussion thread is an extension to what was discussed in Shell scripting section. Please refer the post for the requirement: Requirement Post - Click Here The whole thread - Click Here I would like to know how I can use NDM to transfer file from AIX to Mainframe and to verify the...

LEARN ABOUT PHP

pdo_informix-dsn

PDO_INFORMIX-DSN(3)							 1						       PDO_INFORMIX-DSN(3)

PDO_INFORMIX DSN - Connecting to Informix databases

	The  PDO_INFORMIX  Data Source Name (DSN) is based on the Informix ODBC DSN string. Details on configuring an Informix ODBC DSN are avail-
       able from the Informix Dynamic Server Information Center. The major components of the PDO_INFORMIX DSN are:

	      o DSN prefix
		- The DSN prefix is informix:.

	      o DSN
		- The DSN can be either a data source setup using odbc.ini or a complete connection string.

       Example #1

	      PDO_INFORMIX DSN example using odbc.ini

	       The following example shows a PDO_INFORMIX DSN for connecting to an Informix database cataloged as Infdrv33 in odbc.ini:

	      $db = new PDO("informix:DSN=Infdrv33", "", "");

	      [ODBC Data Sources]
	      Infdrv33=INFORMIX 3.3 32-BIT

	      [Infdrv33]
	      Driver=/opt/informix/csdk_2.81.UC1G2/lib/cli/iclis09b.so
	      Description=INFORMIX 3.3 32-BIT
	      Database=common_db
	      LogonID=testuser
	      pwd=testpass
	      Servername=ids_server
	      DB_LOCALE=en_US.819
	      OPTIMIZEAUTOCOMMIT=1
	      ENABLESCROLLABLECURSORS=1

       Example #2

	      PDO_INFORMIX DSN example using a connection string

	       The following example shows a PDO_INFORMIX DSN for connecting to an Informix database named common_db using the Informix connection
	      string syntax.

	      $db = new PDO("informix:host=host.domain.com; service=9800;
		  database=common_db; server=ids_server; protocol=onsoctcp;
		  EnableScrollableCursors=1", "testuser", "tespass");

PHP Documentation Group 												       PDO_INFORMIX-DSN(3)