July 05, 2007, 06:30 PM
<Umar Farook S>Create SQLOUT
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....
July 05, 2007, 06:39 PM
Francis Marianiquote:
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.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 05, 2007, 06:52 PM
<Umar Farook S>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
July 05, 2007, 07:04 PM
Francis MarianiYou 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.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 06, 2007, 03:20 AM
Tony AUmar,
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
July 09, 2007, 10:43 AM
iraTony your brief explanation was perfect.
Ira