Hi,

Iam using the below code and trying to read the values in a table file
using the readfile command as shown below and later using these values in the Table file request:

 ENGINE SQLORA SET DEFAULT_CONNECTION USER_CONNECT

SQL SQLORA PREPARE REPORT1 FOR
SELECT * FROM SCHM1.V_TABLE1;
END

TABLE FILE REPORT1
PRINT
COLUMN1_1
COLUMN1_2
COLUMN1_3
WHERE REPORT_DATA EQ ''
ON TABLE HOLD AS MYFILE_REPT
END
-RUN

-READFILE MYFILE_REPT
-TYPE &COLUMN1_1
-TYPE &COLUMN1_2
-TYPE &COLUMN1_3

TABLE FILE REPORT1
PRINT
DIVISION
DEPARTMEMT
STATE
COLUMN1_1 AS '&COLUMN1_1'
COLUMN1_2 AS '&COLUMN1_2'
COLUMN1_3 AS '&COLUMN1_3'
EMD
-RUN
-EXIT
 

When I run the report, in the auto prompting facility under parameters, it is prompting to enter the
values for COLUMN1_1,COLUMN1_2 and COLUMN1_3 but I want all these variables to be hidden and not to show up when I run the report.
The report still runs if I click on the Run button under auto prompting facility but somehow I dont want these
variables to show up in the auto prompting facility because it confuses my client/stakeholder saying that these variables need some inputs
to be entered before running the report.

Could anyone please let me know on how to hide these(COLUMN1_1,COLUMN1_2 and COLUMN1_3) in the Auto prompting facility ?

Any help is greatly appreciated. Thanks a lot in advance!

Regards,
IP

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

You can either turn off autoprompt entirely for your site (which is probably not what you want), or you can add -DEFAULT's for your variables between the -READFILE and where you first use them.

I don't think there's a way to temporarily disable autoprompt in a section of a fex. I'd love to have a feature like that.

Hi Wep,

I have one default variable(State) which is linked to the parameter page of this report and I haven't mentioned in the code which I had pasted earlier.

May I know how can I turnoff autoprompt entirely and also could you please let me know how can I add DEFAULT's for my variables between the -READFILE.Please help.

Regards,
IP

You need to DEFAULTH all columns that are part of the HOLD file (in your case : MYFILE_REPT).
And I do suggest to add a -RUN after the READFILE

-DEFAULTH &COLUMN1_1 = ''
-DEFAULTH &COLUMN1_2 = ''
-DEFAULTH &COLUMN1_3 = ''

TABLE FILE REPORT1
PRINT
COLUMN1_1
COLUMN1_2
COLUMN1_3
WHERE REPORT_DATA EQ ''
ON TABLE HOLD AS MYFILE_REPT
END
-RUN

-READFILE MYFILE_REPT
-RUN
-TYPE &COLUMN1_1
-TYPE &COLUMN1_2
-TYPE &COLUMN1_3

To turn off auto-prompting, if I don't mistaken, go to BIP / Administration Console / Configuration / Application Settings / Parameter Prompting and I think that you need to set to "ON". But I'm not 100% sure since I have issue with the IBI help display.

Hi Martin,

Thanks a ton for your help
It worked!

Regards,
IP

Conversely you can also uncheck the prompt for parameters checkbox on the properties for the report

quote:

Conversely you can also uncheck the prompt for parameters checkbox on the properties for the report

True, but with WF8, it may not be sufficient, unfortunately.

Ah, quelle domage

quote:

Originally posted by MartinY:
You need to DEFAULTH all columns that are part of the HOLD file (in your case : MYFILE_REPT).
And I do suggest to add a -RUN after the READFILE

-DEFAULTH &COLUMN1_1 = '';
-DEFAULTH &COLUMN1_2 = '';
-DEFAULTH &COLUMN1_3 = '';

TABLE FILE REPORT1
PRINT
COLUMN1_1
COLUMN1_2
COLUMN1_3
WHERE REPORT_DATA EQ ''
ON TABLE HOLD AS MYFILE_REPT
END
-RUN

-READFILE MYFILE_REPT
-RUN
-TYPE &COLUMN1_1
-TYPE &COLUMN1_2
-TYPE &COLUMN1_3

What I was suggesting, which prevents the warning from -READFILE about the parameters being overwritten, is this (notice where the -DEFAULT's went):

TABLE FILE REPORT1
PRINT
COLUMN1_1
COLUMN1_2
COLUMN1_3
WHERE REPORT_DATA EQ ''
ON TABLE HOLD AS MYFILE_REPT
END
-RUN

-READFILE MYFILE_REPT
-DEFAULTH &COLUMN1_1 = ''
-DEFAULTH &COLUMN1_2 = ''
-DEFAULTH &COLUMN1_3 = ''

-RUN
-TYPE &COLUMN1_1
-TYPE &COLUMN1_2
-TYPE &COLUMN1_3

Cred's go to someone else on this forum, but I forgot who taught me this. Sorry and thanks

About adding -RUN after -READFILE; Be very careful with that!

Using -RUN closes any open files. So if you use -READFILE within a loop (-REPEAT or -GOTO), you'll be reading the first line over and over.
Furthermore, if you're only exiting that loop when -READFILE results in an I/O error after the last line - that won't happen! (well, unless you're reading an empty file)

Yeah, been there, stopped doing that.

And another thing I just noticed: -DEFAULT without a closing semi-colon is old-style syntax and is being advised against (note that I'm not an authority on the matter).

quote:

-DEFAULT without a closing semi-colon is old-style syntax

Not so. Although tolerated, it's absent from the documented syntax:

Syntax: How to Supply a Default Value
-DEFAULT &[&]name=value , [&[&]name=value]
where:
&name
Is the name of the variable.
value
Is the default value assigned to the variable.

-- Which makes sense -- semicolon is needed (in -SET, for example) when the expression it delimits can be continued over multiple lines. -DEFAULT cannot.