Problem solve Get help with specific problems with your technologies, process and projects.

Result fields in Query

I am trying to create queries. I'm running into a wall when it comes to result fields in the iSeries query. Is there any way to have conditional functions (i.e. if..then, case() ) in a query result field? Does this functionality exist in query? Any help or tips in this area of query would be extremely helpful.
There is not a way to conditionally calculate a result field other than using the value operation code. This opcode will select only the first non-null field in a list. The only other way to do this in Query is with multiple queries and intermediate output files.


The Best Web Links: tips, tutorials and more.

Ask your programming questions--or help out your peers by answering them--in our live discussion forums.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.

Dig Deeper on RPG iSeries programming

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.