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     [SOLVED] Convert a P20 to an A10

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Convert a P20 to an A10
 Login/Join
 
Latigresa
Platinum Member
posted
How do I go about changing a P20 to an A10?

Thank you for all your help in advance.

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


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
Mighty Max
Guru
posted Hide Post
Please do a search for PTOA.
This function converts Packed fields to Alpha fields.


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Latigresa,

If your field is P20 and you want to change to A10, does that mean that you want to have, in the alpha field, 2 decimal digits per byte? If so, use PCKOUT.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Latigresa
Platinum Member
posted Hide Post
Danny,

Thanks but when I do a pckout it gives me jiberish. I tried a compute but it adds a bunch of zeros I don't need in there. I think after the compute I need to do another edit to remove the leading zeros.

Thanks!!!

M Max,

Thanks as well getting ready to do the search for your suggestion. I'll let you know what I find and if that gets me going.

Thanks!!!


WEBFOCUS 7.6.4
Server: WINXP
 
Posts: 121 | Registered: September 20, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
PCKOUT writes a packed number from an unpacked number. That is not what you want to do. Max's suggestion of PTOA is the one you need to go with. However, as with all of the cTOA functions, usually the output alpha format tends to be larger than the number of digits in the original number. If you want to smash it into an A10, you will have to massage to PTOA output even further to get rid of non-significant characters as you have already alluded to.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Latigresa,

If you say "jiberish" that means that you want to see the numbers in the A10 field and not output 10 bytes packed.

So, yes, you should use PTOA. Beware, if your P20 field has more than 10 significant digits, then you will get ********** in your alpha field. See the 7.6 Using Functions Manual, page 10-15.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report 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     [SOLVED] Convert a P20 to an A10

Copyright © 1996-2020 Information Builders