Hi, I'm new to using ods html, and I was wondering if someone could help me. The user enters a valid PROC SQL statement, and the dispatcher program takes it and display it to a html output page. Right now, when the SQL statement returns no result, the HTML output page is blank. How can I display a message on the HTML output page telling the users that no output returned from the query they requested, instead of having just a blank page?
Are you by any chance using SAS/IntrNet and/or htmSQL??? I wondered because usually when you use the dispatcher program, you are using SAS/IntrNet. Generally, you can code something in your dispatcher program to return a message to _webout using data _null_ or ODS TEXT=. If you are using SAS/IntrNet, look at this example that displays a message when there is an invalid attempt to login: http://support.sas.com/rnd/web/intrnet/dispatch/sesssamp.html