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

Retrieving data from AS/400 into Crystal Reports

Crystal Reports does not have direct access to data in AS/400, therefore an external stored procedure or an external user-defined function is necessary.

Do you have a example of how to retrieve a AS/400 data area into Crystal Reports?
I don't have a coding example. However, you would need to create either an external stored procedure or an external user-defined function to do this since Crystal Reports can't access a data area directly. The external procedure or function allow you to invoke any high-level language program -- the program would retrieve the value from the data area and then just return the value to the invoker of the procedure or function.

The IBM Redbook Stored Procedures, Trigger and User-Defined Functions on DB2 UDB for iSeries has several examples of external routines.

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.