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

Possible to run SQL/400 programs in a batch environment?

We have an iSeries model 820/2436/1525 with interactive features, partitioned two ways and running OS/400 V5R1 on both. We are exploring SQL/400 for our applications. Is it possible to make SQL/400 program(s) run in a batch environment? Right now the SQL programs created by our programmers consume 35% interactive CPU.

There's no way to have SQL run in batch without changing your design so that the programs containing the embedded SQL run in batch. You may want to do some SQL performance analysis to verify that the SQL is being executed in the most efficient manner (e.g., Do you have the right indexing strategy in place?). There are some SQL performance materials online here.


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

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.