Recent content by FOCMAN

You can try using an MRE exit routine which can be used to validate against anything. In essence you write a program which can issue JDBC calls to any database.

LET CLEAR * only will clear LET command aliases and not && variables. There is no way to clear && variable. But, do to the non persistence of WebFOCUS, after a report is rendered a fresh connection is made and all && variable are cleared as long as you have a private connection set up which is...

Not sure but it should work. IBI will probably not support this configuration. I do not believe 4.3.1 is supported anymore. The current release is 5.3.2. 4.3.5, 4.3.6, 5.1, and 5.2 were its predecessors.

iWay Software also provides a Lawson adapter

How are you configured? Are there 2 separate WebFOCUS Servers? Are they configured to see each other? What is the file type you are reading?

Can you display your procedure around line 27? Are you issuing SQL in your procedure? By settting engine to SQLORA your SQL out of the back end has to meet ORACLE syntax. If you leave SQLENGINE alone WebFOCUS takes care of the proper ORACLE syntax. I do not use SQLENGINE seetings unless using...

Do not think you can do a GRAPH FILE with EXL2K format. You can take the data in EXL2K and use Excel itself to do a graph. You can also hold the data in EXL2K as a pivot table and can easily graph in Excel from there.

Rather than trying to hack into the MRE repository which just shows who the registered users are and not how much they use you should investigate the FOCLOG or Resource Analyzer product(s) which gathers usage statistics and give an accurate view of who is doing what and how often. The MRE...

You need to do a DEFINE based JOIN: Something like: JOIN MYFIELD IN TABLE1 TO ALL FIELD2 IN TABLE2 AS J1 END DEFINE FILE TABLE1 MYFIELD/A4 WITH FIELD1 = EDIT(FIELD1); END TABLE FILE TABLE1 PRINT MYFIELD FIELD2 END Look this up in a manual. Also the TO field in TABLE2 should be indexed.

Put a -RUN betwwen the DYNAM command and the -READ -RUN executes whats in the stack, in this case the DYNAM command

Try: BEGIN TRANSACTION IF EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[jobs]')AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE JOBS

The message says that you are using fields from multiple data paths. Do a CHECK FILE MYFILE PICT if you can and you will see you have a multipath hierachy. Example : NAME | | VACATION SALARY Its like saying IF VACATION EQ '20040501' AND SALARY GT 1000; This...

RESULTS.DATA is used, I believe, is for deferred requests and has nothing to do with VSAM specifically. Make sure DISP=SHR on RESULTS.DATA, have a DSNTYPE=LIBRARY and is allocated in the server startup JCL. It should be managed by SMS.

I have. What is the issue?

If you have -SET &ECHO=ALL and do view source in browser you can see the ECHO output which you can save locally.