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.