Interesting... If this turns into a NFR, then requested mixed case names.
September 04, 2018, 03:22 PM
S.J. Kadish
Thanks, Doug. Let's see if anybody else tunes in.
Thanks,
Sandy
September 04, 2018, 04:00 PM
BabakNYC
I can do this with a HOLD and FILEDEF but it's really not the same as PCHOLD.
-SET &NAME='c:\Return_Reject_';
-SET &EXT='.XLSX';
FILEDEF HOLD DISK '&NAME&DATEMtDYY&EXT'
TABLE FILE CAR
PRINT CAR BY COUNTRY
ON TABLE HOLD FORMAT XLSX
END
WebFOCUS 8206, Unix, Windows
September 04, 2018, 05:33 PM
Waz
I don't like your chances.
I would suggest asking TechSupport, as its WebFOCUS Client that returns the report to the browser.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 05, 2018, 08:00 AM
S.J. Kadish
I appreciate everyone's responses and will keep the thread open for a few more days.
Sandy
September 05, 2018, 12:01 PM
jgelona
Sandy, are you a Linux/UNIX shop? If so, do your settings have SET FILECASE = LOWER? If so, I believe that will set all file names to lower case no matter how you name them in a fex. Here's what the documentation says:
FILECASE - Both UNIX and WebFOCUS support uppercase, lowercase, and mixed-case file names and directories. Since lowercase is the default in UNIX environments, WebFOCUS offers a way to automatically convert file names and directories to lowercase.
The syntax is: SET FILECASE = {ACTUAL|LOWER}
where: ACTUAL Retains file names in uppercase, lowercase, or mixed-case, exactly as they are entered. When this setting is used, WebFOCUS looks for file names exactly as they are entered (uppercase, lowercase, or mixed-case). LOWER Converts uppercase or mixed-case names to lowercase. When this setting is used, WebFOCUS looks for file names in lowercase.
What the command doesn't say is what the default is. I would guess it depends on your system.
You may want to try SET FILECASE = ACTUAL or ON TABLE SET FILECASE ACTUAL in your fex.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
September 05, 2018, 12:24 PM
Tony A
Docs state that default is lowercase.
Also, it cannot be set temporarily i.e. ON TABLE SET FILECASE is invalid.
On my windows install SET FILECASE = ACTUAL results in all uppercase filename.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 05, 2018, 01:01 PM
S.J. Kadish
SET FILECASE = ACTUAL returned "RETURN_REJECT_SEP 5, 2018" (all caps) just as Tony noted. I will run this past our team because upper case might be preferable to lower case.
I will keep the thread open because there have been such great responses.