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,

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.

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.

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.

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.

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,

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

Yep it is UTF8, what a pain.
This didn't work in my environment. Got the same results. Thanks, Rick

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!

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.

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.