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     Default NODATA Characters appearing in 1st row

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Default NODATA Characters appearing in 1st row
 Login/Join
 
ta2007
Member
posted
Have SET NODATA=' ' per discussions here. In WF DEV environment this works. When interpreted by the reporting App Server, the columns in the first row which are blank receive the default '.' but the same columns in other rows properly show as empty or blank. Any idea what might be driving this behavior?


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
Waz
Expert
posted Hide Post
Are you able to reproduce with the sample data.

This should not happen.

Are the Master Files the same for Dev Studio and the WF server ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
ta2007
Member
posted Hide Post
Cust Sell Ind Inventory Purch From Acct Purch From Name Lease Type Sales Channel
N OL . . CE_LTD AUCTION
N OL CE_LTD TRADE
N OL CE_LTD AUCTION
N OL CE_LTD AUCTION

Example of output data.

Code snippet:

SQL SQLORA PREPARE SQLOUT FOR
SELECT *
FROM table(Data_Pkg.Function_Name(&Param1, &Param_2, &Param3, &Param4))
END

SET NODATA = ''

TABLE FILE SQLOUT
PRINT *
END

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


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
ta2007
Member
posted Hide Post
This is coming from a Oracle Database pipeline function call.


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
Waz
Expert
posted Hide Post
Is it the same Oracle source ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
ta2007
Member
posted Hide Post
I confirmed...it is hitting the same oracle database source.


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
ta2007
Member
posted Hide Post
I have been doing a side by side comparison of the original view records, to the output of the pipe function in Oracle to the WF report output. The data is the same, except for the odd occurances of some cells in the first row of the WF report data containing the default '.' symbol. It is very strange...


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
Waz
Expert
posted Hide Post
It certainly is.

Could you add ? HOLD SQLOUT after the TABLE FILE

This will show the column details. I'm hoping that there is a difference.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
ta2007
Member
posted Hide Post
Still shows those two fields with the period.


7.6.4
XP SP3
EXL2K, HTML, PDF
 
Posts: 26 | Location: Ohio | Registered: April 13, 2009Report This Post
Waz
Expert
posted Hide Post
I should have asked to also add -EXIT after the ? HOLD SQLOUT.

The program output should show Column Name Format and missing state.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 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     Default NODATA Characters appearing in 1st row

Copyright © 1996-2020 Information Builders