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] SQMSS create Synonym - format Money

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] SQMSS create Synonym - format Money
 Login/Join
 
<dksib>
posted
I have a field on a MS SQL Server 2005 table/view with a format of money. When I use the create New Synonym it creates a field with a format of P21.4. I want to change this to a P21.2 or P20.2 as it shows in the EDA/SQL Data Administration Guide.

How can this be done?

This message has been edited. Last edited by: Kerry,
 
Report This Post
GamP
Virtuoso
posted Hide Post
If you would look in ms sql at the contents of this money field, you will see that in ms sql it is also represented with 4 decimals. And in MS SQL you do not have any control over the number of decimals, at least I couldn't find it.
But it does mean that the translation from MSSQL to the master file seems to be correct.
If you want less precision, then I think there is only one way: the manual one (ie. go into the master file and change it).

Hope this helps.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
The Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS Version 7 Release 6.5
(DN9400259.0408) manual discusses MONEY for SQl Server and states: Data Type: MONEY, Usage: P21.4, Actual: P10, Remarks: range: -263 to 263 - 1.

It is perfectly legal to change the Master after it is generated - you could modify P21.4 to P21.2.

It is my habit to never change the Master after it is generated, I would rather use a DEFINE or reformat the column in a report.

The MONEY column in SQL Server 2000 can indeed hold up to 4 decimal places.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
<dksib>
posted
Thanks for the confirmation. I just wanted there to be a setting that I could use to adjust the precision. That would have saved me alot of time for this adjustment
 
Report This Post
Francis Mariani
Expert
posted Hide Post
Ask and you shall receive.

Take a look at "Changing the Precision and Scale of Numeric Columns" in the Adapter Administration manual, though it appears you can't address MONEY columns specifically...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
<JG>
posted
There is no need to change the precision of a field in the master, IF it is a verb object and not a BY or ACROSS.

PRINT FIELD/P20.2
 
Report This Post
Francis Mariani
Expert
posted Hide Post
quote:
It is my habit to never change the Master after it is generated, I would rather use a DEFINE or reformat the column in a report.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
<JG>
posted
RT*M, basic but training and experience.

It's all documented.
 
Report This Post
<dksib>
posted
I forgot to mention that the user is able to select from all of the columns that are on the table to be displayed on the report. I am creating the dropdown list using CHECK FILE and then Display the title and send fieldname for the selection. Since I have to modify the report column varible to add the format using a combination of POSIT and OVRLAY it will be a slow processes. Which will take 4 lines per field that require to have a new display format.
 
Report This Post
<dksib>
posted
quote:
Originally posted by dksib:
I forgot to mention that the user is able to select from all of the columns that are on the table to be displayed on the report. I am creating the dropdown list using CHECK FILE and then Display the title and send fieldname for the selection. Since I have to modify the report column varible to add the format using a combination of POSIT and OVRLAY it will be a slow processes. Which will take 4 lines per field that require to have a new display format.


Francis thanks for the document but it pointed me back to "Managing Microsoft SQL Server Metadata" which I know about and as you stated does not deal with a MONEY format.
 
Report This Post
<JG>
posted
Why not take an inverse approach and code the report with all columns
already there and formatted preceded by a variable defaulted to -* and if
the user selects a particular column pass a space.


-DEFAULTS &C1='-*'
-DEFAULTS &C2='-*'
-DEFAULTS &C3='-*'
etc.

TABLE FILE xyz
PRINT
&C1.EVAL COL1
&C2.EVAL COL2/D10.2
&C3.EVAL COL3
etc.
 
Report 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] SQMSS create Synonym - format Money

Copyright © 1996-2020 Information Builders