There's an odbc.ini file which need to be configured. It might be found in your webserver./ also where your oracle client is located.
In your case I'm assuming you install the oracle client inside the mainframe. And the oracle server is where you have your oracle 10G installed.
vi this odbc.ini and modify the (just an example)
and from my experience odbc file needs to be configured only for RHEL machine not aix. you guys can correct me if im wrong.
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 (2 Replies)
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++;
}
... (3 Replies)
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 (3 Replies)
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... (1 Reply)
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... (5 Replies)
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... (0 Replies)
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 . ... (0 Replies)
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... (24 Replies)
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... (3 Replies)
Discussion started by: TechGyaann
3 Replies
LEARN ABOUT PHP
odbc_prepare
ODBC_PREPARE(3) 1 ODBC_PREPARE(3)odbc_prepare - Prepares a statement for executionSYNOPSIS
resource odbc_prepare (resource $connection_id, string $query_string)
DESCRIPTION
Prepares a statement for execution. The result identifier can be used later to execute the statement with odbc_execute(3).
Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as
defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $query_string
- The query string statement being prepared.
RETURN VALUES
Returns an ODBC result identifier if the SQL command was prepared successfully. Returns FALSE on error.
EXAMPLES
Example #1
odbc_execute(3) and odbc_prepare(3) example
In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:
<?php
$a = 1;
$b = 2;
$c = 3;
$stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>
If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your
database (for example, mssql for MS SQL Server, or oci8 for Oracle).
SEE ALSO odbc_execute(3).
PHP Documentation Group ODBC_PREPARE(3)