I am having an Input box to pass parameters with 15000 characters and generate the report based on the parameters. Is the max width 4096 characters in Webfocus? If so, do I have to have a Feature Request to increase the boundary limit of 4K? Please advise.

This message has been edited. Last edited by: FP Mod Chuck,

15000 charachters is quite a lot for one parameter. What's the usecase? No options to split it?

I am confronted with the same issue so i am very interested.


I should read closer i do not have a 15K parameter, I too cannot imagine that. I have fields that size that i am trying to pass to my output

This message has been edited. Last edited by: Geoff Fish,

How does the user can enter 15K characters in a input box ?

I cannot imagine that a user will have to enter (even copy/paste) 15K digits as a parameter...

You may should consider other option such as file upload.

quote:

How does the user can enter 15K characters in a input box ?

Not much of WF, it is a limit of browser in query string. https://support.microsoft.com/...in-internet-explorer
see if you can use POST.

Thank you very much for the 15K response. Here are details,

1. When a user Logs in, my front end(java) brings all the data associated with the login id. This data has a
concatenated value like aaa~bbb~ccc,ddd~eee~fff,ggg~hhh~iii,......... and so on that counts to 15000 characters

OR

2. When I paste the same data from WF BI Portal in the Portal Input box

OR

3.When I hard code the same data in .fex file input parameter

On all the three situations, when it exceeds 4188 data characters, it gives (FOC1487) SQL SYNTAX ERROR. But with less than 4188 data, it generates the report successfully. (Earlier,the error was in wfRepository BOTPARMS(PARAM_VALUE) and I modified it from varchar to text datatype and that error is gone now)

3. Are these values are processed in memory somewhere in webfocus before calling .fex file?(I am not sure but I was told)

4. If successful, it calls the .fex file with this data, which in turn calls the .mas file that calls the stored proc. The Procedure splits the tilda separated values into columns and comma separated values in to rows in tmptable and the procedure runs and generates the report based on these tmptable. What is the alternate option? Please assist.

I am new to webfocus and I will be enrolling in WF Reporting soon

quote:

This data has a concatenated value like aaa~bbb~ccc,ddd~eee~fff,ggg~hhh~iii,......... and so on that counts to 15000 characters

No matter the way the data is retrieved, one question : what is data for ? What does it represent ?

quote:

When a user Logs in, my front end(java) brings all the data associated with the login id

If the data can be retrieved from java based on user id, why not let WF retrieve it and store it in a format (such as multiple parameters, ...) that will be usable later on ?
I suppose that the string is organized such a way that the values can either be divided using the comma or the tilde ? So you potentially could create several parameters based on that.

The more detailed information you'll give us, the easiest it will be to help you

These parameters with tilde represent business data with saleslocation(aaa), salesbranch(bbb) and salescode(ccc)aaa~bbb~ccc,ddd~eee~fff,.....

The parameters retrieved from frontend are the data from source database based on logon id and I want them inserted in my destination mysql datamart for report generation using webfocus(.mas,.fex and stored procedure)

If the parameters is more than 4188 characters, it is not entered in mysql datamart tmptable, but less than that gets entered in mysql datamart tmptable.

Sounds like you're using that 15k data for security, based on logon id, to determine what records to include in reports?

You might want to consider using Webfocus's DBA security scheme. It's way simpler. Just my 2 cents.

quote:

The parameters retrieved from frontend are the data from source database based on logon id and I want them inserted in my destination mysql datamart for report generation using webfocus(.mas,.fex and stored procedure)

How do you store (insert) the string in the tmptable ?

Also, I still don't understand why you would like to read a table to extract data (parms) that you will then be inserted in another table to be finally read ?

Another way if you want to keep the "tmptable" is to insert one row per parm value.
Meaning that for each combination of "saleslocation(aaa), salesbranch(bbb) and salescode(ccc)" you do insert a row.
That way, instead of having a up to 15K string, you will have many rows into a table. You will then be able to extract your data based on the value within "tmptable" using a JOIN and not a WHERE as you do actually.

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

Thanks all for the response. I will try to make changes as per suggestions.