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.

This was last published in March 2001

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.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...