08-13-2010
ODBC Connectivity between Oracle10g on AIX and Mainframe
Hi,
I have a task of setting up connectivity between Oracle 10g (AIX) and Mainframe (1 library). Went through couple of documents, forums, blogs etc. MY understanding is ODBC Generic Connectivity is free from Oracle side.
Question: (may be dumb to you)
1. Has anybody done this and would like to share their documents, lessons learnt, risks etc?
2. Where can I find the ODBC.ini for DB2 Mainframe?
3. Should I install this ODBC Driver on Mainframe or Oracle AIX?
4. Anything else that needs to be taken care.
Thanks to everyone in advance.
Regards,
Mani
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L (0 Replies)
Discussion started by: uhdesai
0 Replies
2. 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 (2 Replies)
Discussion started by: aarora_98
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: sameerstephen
3 Replies
4. 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 (3 Replies)
Discussion started by: paulcarbajal
3 Replies
5. AIX
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)
Discussion started by: sambeet
1 Replies
6. AIX
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)
Discussion started by: sekhar gajjala
5 Replies
7. Shell Programming and Scripting
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)
Discussion started by: Yogesh Aggarwal
0 Replies
8. Red Hat
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)
Discussion started by: roopalidalvi231
0 Replies
9. Shell Programming and Scripting
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)
Discussion started by: TechGyaann
24 Replies
10. AIX
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 DEBIAN
dbix::class::storage::dbi::odbc::access
DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)
NAME
DBIx::Class::Storage::DBI::ODBC::ACCESS - Support specific to MS Access over ODBC
DESCRIPTION
This class implements support specific to Microsoft Access over ODBC.
It is a subclass of DBIx::Class::Storage::DBI::ODBC and DBIx::Class::Storage::DBI::ACCESS, see those classes for more information.
It is loaded automatically by by DBIx::Class::Storage::DBI::ODBC when it detects a MS Access back-end.
This driver implements workarounds for "IMAGE" and "MEMO" columns, and DBIx::Class::InflateColumn::DateTime support for "DATETIME" columns.
EXAMPLE DSN
dbi:ODBC:driver={Microsoft Access Driver (*.mdb, *.accdb)};dbq=C:Users
kitoverDocumentsaccess_sample.accdb
TEXT
/IMAGE/MEMO COLUMNS
Avoid using "TEXT" columns as they will be truncated to 255 bytes. Some other drivers (like ADO) will automatically convert "TEXT" columns
to "MEMO", but the ODBC driver does not.
"IMAGE" columns work correctly, but the statements for inserting or updating an "IMAGE" column will not be cached, due to a bug in the
Access ODBC driver.
"MEMO" columns work correctly as well, but you must take care to set LongReadLen to "$max_memo_size * 2 + 1". This is done for you
automatically if you pass LongReadLen in your connect_info; but if you set this attribute directly on the $dbh, keep this limitation in
mind.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::ODBC::ACCESS(3pm)