Convert SAP Oracle Database to IBM DB2 Database??Hello,
I would like to hear from anyone here who has converted their SAP Oracle
database to IBM DB2 database?
Did you realize greater disk saving via DB2 compression?
Did you run the latest version of DB2 rather than allow SAP to keep your
Oracle version back-leveled?
Please, DB2 Bashers need not apply, looking for the business case anyone
used to convert to DB2.
Thank you.
Charles
On 6 Feb, 01:52, "Charles Davis" <cdavis10...@comcast.net> wrote:
> Hello,
>
> I would like to hear from anyone here who has converted their SAP Oracle
> database to IBM DB2 d...
Connect to IBM DB2 database without installing the DB2 client.Hi,
To connect to the DB2 Driver, from a remote machine. Do we requier DB2
client.
Can't we connect by just having IBM DB2 driver which is just a single
file (db2cli.dll).
I am using vb application from Windows platform to connect to DB2 on
Linux machine.
Regards,
Santosh
SB wrote:
> Hi,
>
> To connect to the DB2 Driver, from a remote machine. Do we requier DB2
> client.
> Can't we connect by just having IBM DB2 driver which is just a single
> file (db2cli.dll).
> I am using vb application from Windows platform to connect to DB2 on
> Linux machine.
>
It's imposiblle. The IBM DB2 ODBC Driver is not only db2cli.dll. Try to
install DB2 Run Time Client Lite merge modules with your VB application
under client workstation.
Direct connecting to DB2 databases supported JDBC Type 4 Driver only.
P.S. Sorry for my bad english :(
With best regards, Dmitry.
FYI: On Windows DB2 comes with db2iprune tool.
With this utility you can reduce size of installation binaries, for
example you can reduce your DB2 runtime client to include only the
interfaces you need. The db2iprune tool is located in the
\db2\windows\utilities\db2iprune directory on DB2 product installation
image.
So, if you are planning install DB2 client with/within your application
you can combine the tool with the response file and perform quick
batch installation.
-- Artur Wronski
...
java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSourceHi,
I want to get connection to a DB2 database using the driver
COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in
the classpath. However I am getting the exception
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Conn.main(Conn.java:44)
The code that I am using (with try/catch removed) is as follows:
String url = "jdbc:db2:sample";
String driver = "COM.ibm.db2.jdbc.DB2XADataSource";
String dbuser = "db2u...
oct 24 DB2 for LUW Tech Talk: What's Hot from IOD for PureData Systems, IBM Mobile Database and DB2 for LUWNow we can tell you more! IBM announced PureData Systems on October 9th --=
a series of expert integrated solutions for your transactional and analyti=
c workloads.=20
In the next DB2 Tech Talk, we'll come to you from Las Vegas with hot news f=
rom the conference from a DB2 for LUW, PureData Systems perspective! We'll=
also cover a new free software download called IBM Mobile Database, which =
helps you enable your DB2 data apps for Android mobile users. And then we =
will bring you the best of the presentations from the conference, including=
an IBM Champion and other interesting perspectives on DB2. =20
Register: bit.ly/tt2012oct
...
DataBase DataBase DataBase DataBaseDataBase DataBase DataBase DataBase
Porfessional Programmable Database Ver. 2.0
2.1 Million Record Capacity.
Search Rate: 2000/Records/Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Easy to Learn (Typically 30 Seconds)
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
Easy Paypal Online Ordering. See Site Below.
http://www.vehiclerepair.org/dbPro/dbpro.html
...
DataBase DataBase DataBase DataBaseDataBase DataBase DataBase DataBase
Porfessional Programmable Database Ver. 2.0
2.1 Million Record Capacity.
Search Rate: 2000/Records/Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Easy to Learn (Typically 30 Seconds)
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
Easy Paypal Online Ordering. See Site Below.
http://www.vehiclerepair.org/dbPro/dbpro.html
Scott:
#DataBase...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5
CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia
ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia
ColdFusion MX for J2EE, other
IBM DB2 Connect Enterprise Edition v8.2
17/Sep/2004
WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR
16 297
DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR
16 110
IBM DB2 UDB Enterprise Server Edition v8.2 16 053
Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029
Sybase:524953-454f57-4e53594-f55123-456rm4
Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4
DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5
Oracle:524953-454f57-4e53594-f55123-452o1s
Informix:524953-454f57-4e53594-f55123-453x5w
DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5
CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia
ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia
ColdFusion MX for J2EE, other
IBM DB2 Connect Enterprise Edition v8.2
17/Sep/2004
WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR
16 297
DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR
16 110
IBM DB2 UDB Enterprise Server Edition v8.2 16 053
Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029
Sybase:524953-454f57-4e53594-f55123-456rm4
Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4
DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5
Oracle:524953-454f57-4e53594-f55123-452o1s
Informix:524953-454f57-4e53594-f55123-453x5w
DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5
CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia
ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia
ColdFusion MX for J2EE, other
IBM DB2 Connect Enterprise Edition v8.2
17/Sep/2004
WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR
16 297
DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR
16 110
IBM DB2 UDB Enterprise Server Edition v8.2 16 053
Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029
Sybase:524953-454f57-4e53594-f55123-456rm4
Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4
DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5
Oracle:524953-454f57-4e53594-f55123-452o1s
Informix:524953-454f57-4e53594-f55123-453x5w
DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager ExprIBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...
IBM Sets DB2 Database Freehttp://www.linuxtoday.com/it_management/2006013101526NWSV
Will UniVerse and UniData follow?
Henrry Keultjes
hbkeultjesat
earthlinkdotnet
csigline@hotmail.com wrote:
> http://www.linuxtoday.com/it_management/2006013101526NWSV
>
> Will UniVerse and UniData follow?
Good catch, Henry (or is it two r's now-see below). We will have to
ask IBM what their intentions are with U2 in light of this, but I
suspect that the PE editions will be the extent of the free offering.
We shall see. Cheers! --dawn
> Henrry Keultjes
> hbkeultjesat
> earthlinkdotnet
Hard to compete when others such as MS SQL and Oracle are offering free
versions too.
mpizl@yahoo.com wrote:
> Hard to compete when others such as MS SQL and Oracle are offering free
> versions too.
The only one my primary ISP will provide for me is MySQL. I suspect
that is true of other ISPs as well. I feel the barometer falling in
the database industry. cheers! --dawn
do you think we can at least get some stuff for free like pdp.net? What
is RD going to do to survive? Cant see too many new people wanting to
learn or buy pick.
dawn wrote:
> mpizl@yahoo.com wrote:
>
>>Hard to compete when others such as MS SQL and Oracle are offering free
>>versions too.
>
>
> The only one my primary ISP will provide for me is MySQL. I suspect
> that is true of other ISPs as well. I feel the barometer falling in
> the datab...
List of users connected to DB2 UDB databaseHi everybody,
How to get the list of all users/clients who are connected to my DB2
UDB database v 8.2 server in RHEL?
Please help me out...
"satish mullapudi" <satishmullapudi84@gmail.com> wrote in message
news:1154191928.282506.307780@s13g2000cwa.googlegroups.com...
> Hi everybody,
> How to get the list of all users/clients who are connected to my DB2
> UDB database v 8.2 server in RHEL?
> Please help me out...
>
db2 list applications show detail
This will show the logon id. Included in one of the strings is IP address of
the remote clients...
Writing User defined function in the db2 database.Can i write user defined function in the db2 persional edition by the
java, without the COM.ibm.db2.app.*?
Maroon wrote:
> Can i write user defined function in the db2 persional edition by the
> java, without the COM.ibm.db2.app.*?
Yes, use the PARAMETER STYLE JAVA clause in the CREATE FUNCTION statement
and adhere to the calling conventions applicable to that style.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
...
Using .NET to access to a IBM DB2 databaseHello
I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I
cannot choose the provider, this is the only one I can use.
The tables in AS/400 don't have journal and I cannot change this.
When I define an ODBC and link tables in ACCESS I can perform every
actions. I change the ODBC options to commit data immediately.
Using the same ODBC and the same insert statement, when I connect in
my C# application using ODBCConnection, I get this error:
ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2
UDB]SQL0206 - Column N not in specified tables.
What I want is to use a DNS Less situation, and I want to enter in the
connection string all the parameters to connect to the AS/400
database.
This is my connection string:Provider=IBMDA400;Data
Source=999.999.999.999;
When I put the AutoCommit option in the connection string I get this
error:
No error message available, result code:
DB_E_ERRORSOCCURRED(0x80040E21).
I get this message even when the autocommit is 1, 0, true or false and
this is the connection string: Provider=IBMDA400;Data
Source=192.168.192.12;autocommit=0
right now I can perform all the operation with Access database but I
can't with my .NET application in C#.
anyone can assist me?
tkx in advance
Paulo Aboim Pinto
Esqueleto wrote:
> ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2
> UDB]SQL0206 - Column N not in specified tables.
Are you submitting a query with a VARIA...
IBM DB2 Database SpecialistWe are looking to fill the following permanent position with one of
our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED).
Apply to: APPLICATION@GOAHEADCONSULTING.CO.UK
Job Title IBM DB2 Database Specialist
Location: Saudi Arabia
Objective Responsible for the administration of DB2 subsystems and
associated software on the client=92s mainframes
Accountable to Data Centre Manager
Responsibilities This SENIOR position involves the full spectrum of
DB2 system programming activities, including product installation,
customization, deployment, software tools integration, exploitation,
and performance analysis activities. Implement, upgrade, Migrate and
support DB2 and related vendor products. Monitor and tune DB2 daily
performance, resolving problems as needed.DB2 Internal tuning (buffer
pools, DASD (SMS), performance reports (PM, OMEGAMON, CA
tools).Application tuning (database design review, SQL tuning, stored
procedures, triggers V6, user defined functions V6, again reports).
Implement TCP/IP access to DB2 using DRDA Compare DB2/connect with
Star/SQL gateway and make recommendation. This position requires being
on call 24 hours a day Provide documentation and skills transfer to
existing staff.
Working relationships Work closely with Applications Development and
systems programmers in z/OS, DB2, Networking and Websphere groups and
other members of the CICS and MQ Department
Essential Skills Recent and extensive knowledge of latest DB2 Versi...
DBI:ibm_db connection for IBM DB2 databaseHello,
I am attempting to make a DBI connection from Ruby code running on Win32
(XP) machine to an IBM DB2 v9.5 database running under Linux
On the Win32 machine, I have Ruby 1.8.6 (installed with the one-click
installer) and have successfully launched the following gem installation
commands for the IBM DB drivers and required libraries:
>gem install activesupport -v 1.4.2
>gem install activerecord -v 1.15.3
>gem install ibm_db -v 0.8.5
I have also (as required by the IBM documentation at
http://rubyforge.org/docman/view.php/2361/967/IBM_DB-0.6.0.pdf) added
‘ibm_db’ to the list of connection adapters on line77 of
gems\1.8\gems\activerecord-1.15.3\lib\active_record.rb :
RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird
sqlserver db2 oracle sybase openbase frontbase ibm_db )
Here is the ruby code :
-------------
require 'rubygems'
gem 'ibm_db'
require 'dbi'
# Connect to a database
dbh =
DBI.connect('DBI:ibm_db:host=localhost;port=50000;database=MY_DB;',
'username', 'password')
# Select some data
sth = dbh.prepare('select * from my_table')
sth.execute
# Print out selected data
while row=sth.fetch do
p row
end
---------------
Error reported is as follows :
C:\dev\ruby\dbtest>dbtest.rb
c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to
load drive
r 'ibm_db' (DBI::InterfaceError)
from c:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in
`_get_full_drive...
Re: IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit,
vvcd said:
> IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
> bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
> Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
> Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
> Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other
> IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2
> CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM
> Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere
> Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5
> CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia
> ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia
> ColdFusion MX for J2EE, other
What the heck, I'm sure IBM won't have a problem with a little copyright
violation... >:o)
> please send e-mail, ola2@mail.gr, astra35@mailbox.gr,
Do they have internet access in Greek jails, I wonder...
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list
...
IBM.Data.DB2.iSeries database access problemWhen I run the following vb.net code, I'm not able to acces the my database
AMFLIB.
I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries
Access but now I want to use the new managed IBM.Data.DB2.iSeries data
provider from iSeries Access V5R3.
When I remove Database=AMFLIB from the connection string, I can connect but
as soon as I try to specify a known database (like my good old AMFLIB) I get
the following error:
IBM.Data.DB2.iSeries.iDB2ConnectionFailedException
"The connection cannot be opened because an error ocurred."
I'm runn...
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on DB2/POrtal on AIXHi,
I have installed WebSphere Portal on AIX and connected to DB2 on a
remote machine, Getting the followin errors when trying to get the
values from database thru applications installed on Portal.
Any Help Appreciated.
Thanks in advance.
Praveen Singh
IBM Workplace, India
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N A
communication error has been detected. Communication protocol being
used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "9.33.12.221". Communication function
detectin...
IBM.Data.DB2.iSeries database access problemWhen I run the following vb.net code, I'm not able to acces the my
database AMFLIB.
I use to be able to access AMFLIB with the old ODBC driver from IBM
iSeries Access but now I want to use the new managed
IBM.Data.DB2.iSeries data provider from iSeries Access V5R3.
When I remove Database=AMFLIB from the connection string, I can connect
but as soon as I try to specify a known database (like my good old
AMFLIB) I get the following error:
IBM.Data.DB2.iSeries.iDB2ConnectionFailedException
"The connection cannot be opened because an error ocurred."
I'm running IBM iSeries Acc...
Whether ACE threads work with IBM Db2 DatabaseHi All,
We are starting one Project with following Skills
1) Language :- C++ with Embedded SQL Programming ( Source file format
:- .sqC )
2) Database :- IBM UDB database
3) Platform:- Solaris Sparc 5.8 Machine.
4) ACE Threads.
Please let us know, can we use ACE Threads with C++ and Db2 Embedded
SQL under Solaris Sparc 5.8 Machine.
Thanks & Regards,
Divya
...
export IBM UDB (7.2) database into DB2 MainframeHi
I am trying to export a database and its data from UDB 7.2 or 8.1 to
Mainframe DB2. Is this possible? The last time I did this, i ended
up having to write insert statements for each row. Is there a
utilitity to accomplish this?
Thanks
John
John Turek wrote:
> Hi
>
> I am trying to export a database and its data from UDB 7.2 or 8.1 to
> Mainframe DB2. Is this possible? The last time I did this, i ended
> up having to write insert statements for each row. Is there a
> utilitity to accomplish this?
>
> Thanks
>
> John
You po...