Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] PCHOLD FORMAT ALPHA PROMPTS TO FIND OR SAVE FILE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] PCHOLD FORMAT ALPHA PROMPTS TO FIND OR SAVE FILE
 Login/Join
 
Platinum Member
posted
ON TABLE PCHOLD AS UBTF001 FORMAT ALPHA

Prior to Banner 8 and Oracle 10g and WebFOCUS 7.6.10 this didn't prompt 'Do you want to save this file, or find a program online to open it?'
If I save it it is no longer a fixed format file. That is, the columns are too wide. it defaults to a .ftm format. The user use to be able to just run the report and save it to their hard drive as a .txt file.
Any help is apprciated.

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


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
Master
posted Hide Post
Try this
ON TABLE PCHOLD FORMAT WP


Check the redirection settings in WebFOCUS Administration Console.
For Version 7.6.7 onwards, if Save Report option against particular extension is set to Yes, then the report output will prompt a dialog box to save.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Virtuoso
posted Hide Post
Redirection settings may be a clue, but for the most part, the prompting for save/find is due to the browser not knowing what to do with the file type being returned and that will be different for every user's individual browser. Does it have the same problem on different PC's? The default extension for an ALPHA file is and always has been .FTM, so it's probably something else that has changed. I would check the browser settings to tell it what to do with a .ftm file.

In response to Ram's post, format WP will NOT get you what you are looking for. It includes page numbering, column headings, and page and report headings and footing, along with page-break sequences.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Platinum Member
posted Hide Post
Browser settings? or Explorer file types? My explorer file tpye is set to open a .ftm file in notepad. (Yea I knew WP wasn't going to work.)
However, again this is deifferent behavior since going through the UTF8 upgrade.


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
Gold member
posted Hide Post
When you get the save as option, have you tried saving the file with a .txt as the extension? (XXXX.txt)

oops, just reread your post (doh! I need more coffee!) & you say you used to do this....still works on 7.6.8.


81.05 All formats
 
Posts: 56 | Location: Manchester | Registered: November 21, 2006Report This Post
Platinum Member
posted Hide Post
Here's the problem. I've opened a case with IBI #61022524

After trying a number of alternatives I did a ON TABLE SAVE and got this format. You can see the lenght is 3 times what it should be. This is what is happening with ON TABLE HOLD or ON TABLE PCHOLD


  0 FIELDNAME                         ALIAS         FORMAT        LENGTH
 FILL_1                                          A12            36
 SSN                               E02           A15            45
 BIRTH_DATE                        E03           YYMD            8
 FILL_2                                          A18            54
 MSTAT                                           A6             18
 GENDER                            E04           A1              3
 ID                                E06           A9             27
 FILL_9                                          A01             3
 LST_ATT_YR                                      YY              4
 FILL_3                                          A04            12
 FIRSTNM                                         A30            90
 MID_INIT                                        A30            90
 LASTNM                                          A55           165
 FILL_4                                          A60           180
 FILL_5                                          A07            21
 PRM_STREET1                                     A40           120
 PRM_STREET2                                     A40           120
 FILL_10                                         A40           120
 PRM_CITY                                        A30            90
 PRM_STATE                                       A6             18
 PRM_ZIP                                         A15            45
 COUNTRY                                         A06            18
 ATYPE                                           A06            18
 FILL_13                                         A6             18
 PHONE1                                          A30            90
 FILL_3                                          A04            12
 FILL_6                                          A25            75
 SCHOOL                                          A6             18
 SHRDGMR_MAJR_CODE_1               E18           A4             12
 FILL_7                                          A02             6
 SHRDGMR_MAJR_CODE_MINR_1          E19           A4             12
 FILL_8                                          A14            42
 FILL_13                                         A6             18
 DEG_DEC                                         A6             18
 LST_ATT_DD                                      D               2
 LST_ATT_MO                                      M               2
 LST_ATT_YR                                      YY              4
 FILL_11                                         A256          768
 FILL_12                                         A130          390
 TOTAL                                                        2792 

This message has been edited. Last edited by: Rick Man,


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
Expert
posted Hide Post
Rick,

We are on Oracle(Banner) and converted to UTF8. By doing this, all "ALPHA" formats tripled, as you stated. It is due to UTF8.

We redefined the ALPHA fields only until IBI gets a fix:

SET HOLDLIST=PRINTONLY
-RUN
TABLE FILE ODS_TABLE_NAME
PRINT
FILL_1/A12
SSN/A15
BIRTH_DATE
FILL_2/A18
MSTAT/A18
ON TABLE PCHOLD AS UBTF001 FORMAT ALPHA
END


FYI


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
Yep it is UTF8, what a pain.
This didn't work in my environment. Got the same results. Thanks, Rick


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
Expert
posted Hide Post
Rick,

HOLD the data, then display:

 
SET HOLDLIST=PRINTONLY
-RUN
TABLE FILE ODS_TABLE_NAME
PRINT
    FILL_1/A12
    SSN/A15
    BIRTH_DATE 
    FILL_2/A18 
    MSTAT/A18 
  ON TABLE HOLD AS HOLD1 FORMAT ALPHA
END
-RUN
?FF HOLD1
-RUN
TABLE FILE HOLD1
PRINT
    FILL_1
    SSN
    BIRTH_DATE 
    FILL_2
    MSTAT
ON TABLE PCHOLD AS UBTF001 FORMAT ALPHA
END
-EXIT

and, I understand the pain!


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Master
posted Hide Post
In the orginal table are the formats A##V? I have hit that 3 times the length problem before. You can add ENGINE SQLORA SET VARCHAR OFF to your program or your server profile.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Platinum Member
posted Hide Post
No, the orginal formats are just A12, etc. I alreadt hae the SET VARCHAR OFF in my profile.
The only way I can come close is to do FORMAT COM and that should work as she then imports it into an Access database. (Don't ask. Done before me.) I've asked her to test it.
I've asked IBI to give my case to Jared Posner, who worked on our original UTF8 issues. So I'll keep you posted.


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] PCHOLD FORMAT ALPHA PROMPTS TO FIND OR SAVE FILE

Copyright © 1996-2020 Information Builders