Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

DB2/400 and DB2 UDB

Top expert advice on DB2/400 and DB2 UDB for the iSeries.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Answers to your technical questions and expert advice on using DB2/400 and DB2 UDB for the iSeries.
View more Q&As

The Top Expert Advice newsletter helps iSeries professionals manage tasks they deal with regularly. Each month we will give you expert advice on such topics as security, backup and recovery, Web development and application development. Sign up to receive this newsletter, simply edit your member profile and check Top Expert Advice newsletter under the Tips section.

Read this month's Q&A's below or click here to read all the Ask the Expert responses related to DB2 on the iSeries.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB2/400 ON V5R2 CONFLICT WITH OLDER UDB SERVER? | by Kent Milligan

Dear Ken,
I have to upgrade my iSeries to V5R2. Some of my applications use the ODBC connection of a UDB server that is still at UDB 5.2. Does DB2/400 on V5R2 cause any problems for ODBC connections from an older version of UDB? We plan to upgrade our UDB servers to 8.1, but it will take some time before we can perform the upgrade. The OS/400 upgrade is about to start. Do you advise that we stop this upgrade?

Read Ken's answer

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
COPY MULTIPLE FILES INTO ONE DB2 FILE | by Kent Milligan

Dear Ken,
How do you copy multiple stream files into one DB2 file using wildcard (*) at the CPYFRMSTMF command?

Read Ken's answer

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
WORKING WITH COMMIT AND ROLLBACK STATEMENTS | by Kent Milligan

Dear Ken,
Stored procedures with commit and rollback statements don't seem to work if they are created from Operations Navigator or STRSQL. The only way I can get it to work is to use the "RUNSQLSTM" with the "COMMIT(*CHG)" option. How can I get it work from Operations Navigator or STRSQL?

Read Ken's answer

** MORE IMPORTANT INFORMATION ON THIS TOPIC **

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Ask the DB2 UDB doctor


Dig Deeper on DB2 UDB (universal databases)

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close