Hi I am new to WEBFOCUS
please help me out

I like to know whether every select should be followed with the following statements or only if i need to print those i need to follow these steps please advice ASAP

TABLE FILE SQLOUT
---
ON TABLE HOLD AS
END
-RUN

DEFINE FILE
....
END

TABLE FILE
PRINT....

quote:

i need to print those i need to follow these steps please advice ASAP

- Don't know what you mean.

If you use SQL passthru, you will need
TABLE FILE SQLOUT
ON TABLE HOLD AS hold
END
-RUN

for each SQL request.

I really asked the same question
1.ok i write SQLOUT statement
2.what i would write then in next block of define
3.i do not want to print- even then do i have to write print statement

plesae help m eout

You need a basic course in FOCUS.

TABLE FILE SQLOUT
ON TABLE HOLD AS hold
END

creates a temporary file called hold...

then you can DEFINE fields and then PRINT and HOLD after the DEFINE. Depends on what you want to do next.

Umar,

A brief explanation -

When you have SQL passthru, WebFOCUS passes that to the predetermined adapter accroding to the SET ENGINE etc. statements.

The RDBMS processes the SQL and throws an answerset back at WebFOCUS (known internally to WF as SQLOUT).

Now, what does WebFOCUS do with it?

Nothing unless you tell it what to do.

Therefore you require a minimum
TABLE FILE SQLOUT
PRINT what ever columns from the SQLOUT answerset that you need.
END

There are a few restictions such as not being able to do a DEFINE on the SQLOUT, so you would need to HOLD it and the process a DEFINE and then TABLE the hold file.

But the DEFINE and TABLE would be covered in a basic training course, so press your bosses to send you on one of the many that IB run (no I am not an IB employee, although I would never turn down introduction fees Gerry ).

We, on the Forum, can help in so many ways but please do not expect us to provide you with the basic skills to start using WebFOCUS. It is not fair on us and it is not fair on you, You would benefit more from a structured training path than you will just trying to pick up the language from a Forum.

T

Thanks Tony

Tony your brief explanation was perfect.
Ira