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

Building query sentences with the AS/400

I need to know if with the AS/400 SQL I can build query sentences like on another SQL environments in which I can use "=*" symbol to prevent me from void results.

I am unfamiliar with the "=*" syntax but from the rest of your question I think you are looking for the phrase "is not null" to be used in your SQL statements in place of the =*. For more information on AS/400 SQL and other topics, try the IBM online publications page.I generally find the Online Library, AS/400 information center and the Redbooks links to be the most useful.

Dig Deeper on iSeries programming commands

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.