Hi all,

Please clear my doubts below?
What is the different between missing and nodata in the report?

How many servers contain web FOCUS architecture?

What is n-tier archtecture?

How many ways you can start Report server?

Scenario to interchange the order of the field @ the time of execution?

How to Check the null column in WebFOCUS?

Thanks in advance
Div

This message has been edited. Last edited by: FP Mod Chuck,

Div

Not that is really matters for your questions but are you really still on WebFOCUS 7.6?

MISSING means that the value of a data field is NULL, no data can mean the same or if you don't get any results of a request it probably means that your WHERE conditions screened all the data out and no report could be generated.

The number of servers depends on licensing, that said a typical installation will have a server for the reporting server and the WebFOCUS client but with a single license you can choose to install the WebFOCUS client on a separate server from the reporting server (ie. N-Tier) some companies wish to keep them separate. If you are licensed for cluster management then you can have multiple reporting servers installed depending on how many you license and they can be used for load management and/or for fail over. Additional WebFOCUS clients can be licensed to allow multiple web servers to handle load management or fail over as well.

Depending on the OS you license the reporting server on there are multiple ways to start. For instance on Windows it can be started as a Service or on a command line. The installation manual for the OS you are using details this.

Not clear on the interchange of order question but when you create a report you have complete control of the order in which the fields are displayed.

A WHERE statement such as WHERE FIELD EQ MISSING will test for a NULL value

Hope this helps...

Thats really cool.

Thanks lot for your reply FP Mod Chuck