[CLOSED] AS400: HTTP FILEDEF?

Hi all,

Another day; another interesting issue!

At the moment I'm at a customer which uses different servers for the WebFOCUS Client and the Reporting Server.
The Reporting Server has WebFOCUS 7.6.8 installed on an AS400 server (OS400 5.4).

The customer has requested that I use an external file in one of my fexes. This file (a .txt-file) is available via HTTP (and works).

My issue is just even accessing the file. The FILEDEF with HTTP looked like the easy solution to this; but I can't get it to work!

I've created a test-fex which just tests the access; but this fails:

FILEDEF BESTAND HTTP http://server/test.txt
-RUN

-DEFAULT &INHOUD = '';
-READ BESTAND &INHOUD.A255.
-RUN
-TYPE &INHOUD
-RUN

-HTMLFORM BEGIN

!IBI.FIL.BESTAND;

-HTMLFORM END

As you can see I've tried two ways to test whether the content of the file has been read; the READ and the !IBI.FIL.BESTAND;.
The READ simply doesn't return any error, and the !IBI.FIL.BESTAND; returns:
(FOC36225) UNABLE TO OPEN FILE DOMEIN SPECIFIED BY WEBFOCUS TABLE

Am I doing anything wrong; or does it have to do with the fact that I'm trying this on an iSeries machine?
Any help is greatly appreciated!

This message has been edited. Last edited by: Kerry,

<JG>

posted

Jochem,

Not an AS400 issue does not work on Windows either.

It used to work but appears to be broken now.

I checked and another customer as a hottrack open for exactly the same issue at the moment.

Tom Flynn

Expert

posted

Hide Post

The DDNAME is not used in HTMLFORM, AND, the output is not a file, but an AMPer:

  
-READ BESTAND &INHOUD.A255.

-HTMLFORM BEGIN
!IBI.FIL.BESTAND;
-HTMLFORM END

Should Be:

  
-HTMLFORM BEGIN
!IBI.AMP.INHOUD;
-HTMLFORM END

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

<JG>

posted

Sorry to disagree Tom but the DDNAME is used.

 
TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS FRED FORMAT ALPHA
END
-RUN
!COPY FRED.FTM FREDA.FTM
-RUN
FILEDEF BERT DISK FREDA.FTM
-RUN
-HTMLFORM BEGIN
!IBI.FIL.BERT;
-HTMLFORM END

Tom Flynn

Expert

posted

Hide Post

JG,

THANKS, I have never used the DDNAME; good to know. I would have !IBI.FIL.FRED;.

But, Jochem's example is not a HOLD file, he's doing a -READ - correct?

and, NO SORRY's today!!!

and, wouldn't the fully server qualified path be required for the external file??

Always keep learning!

Tom

EDIT: Ah, the -READ is probably not working either...

This message has been edited. Last edited by: Tom Flynn,

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

<JG>

posted

Tom,

When you create a hold file WebFOCUS automatically issues a FILEDEF if it's a flat file and assigns the AS name as the DDNAME

With FILEDEF you have several options

DISK, HTTP, HTTPS, TERM and PRINTER

HTTP and HTTPS are supposed to be able to use a file that is accessible via your HTTP server as if it were a physical file actually on your server

Tom Flynn

Expert

posted

Hide Post

THANKS JG, good info; learned something new today...Tom

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

posted

JG,

Thanks for the reply!
(Yesterday was a national holiday here in the Netherlands, so that's why my reply took a while).
So the HTML FILEDEF doesn't work anymore... that's quite a pain.
I'll get back to the customer and will have to find another way then.

Thanks for all the replies!

(About the READ and IBI.FIL commands in the example fex: I just put them both in so I have different methods of testing if the FILEDEF worked or not. In the final version I would off course only have used one of them).

Please Wait. Your request is being processed...