Hi

1) My issue is the following: I am unable to run a report from BOTLDATA using the field REPORT which is a BLOB field.

=> Is it possible using WebFOCUS to create a focexec to read and correctly
display the content of this field ?

2) As a workaround, I have tried to execute getreport.jsp from a focexec.
I am using the REPORTID and VERSION fields in the JSP call.
But, we hit the LOGON page.
Once authenticated, more calls using the JSP are directly displaying the report.

=> What should be coded in the focexec to directly feed the userid and &
password ?
Currently, we have coded :
TYPE=DATA, COLUMN=HISTOPDF, URL=getreport?(id=REPORTGID version=VERSION),$ "

Thanks for your investigation.
Sevim

You might want to consider makeing copies of two files:
/library/liblogon.jsp and /library/libgetreport.jsp (<- is the actual jsp that is called when you refer to getreport.jsp), and put them in your own directory under the rcaster web application [for example /mylibrary).
In your new liblogon.jsp, there are parameters for establishing the user/pass (IBIB_user, IBIB_pass) that you can pass as parameters on the url.
You then alter the "response.sendRedirect" method in liblogon.jsp to call your new libgetreport.jsp instead of the servlet call that is currently there.
Then you can alter the libgetreport.jsp and remove all the stuff you do not want the users to see or have access to (like the delete option).

Now, no one on this forum would ever recomend that you send the userid and password as part of a url, but that is your call. At a minimum, you might want to have the url call a html page that contains a form with the user/pass that will call the /mylibrary/liblogon.jsp via a auto submit post action. Although that is not secure, it is more secure that putting a user/pass as plain text query string.

Hope this helps.

Have you read the documentation of how to define a Blob as long text, and use the Focus format of TXnnn to describe it? Search the tech doc (top of page) on the word BLOB, and choose the database you are working with..
Also you need to let the database know that the BLOB is text, ENGINE [DB2] SET CONVERSION LONGCHAR {ALPHA|TEXT|BLOB}