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     Resolved sort problem and changing column size

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Resolved sort problem and changing column size
 Login/Join
 
DaveZ
Gold member
posted
I have a 300+ line sql passthru and named some of the columns as a_fg, b_promised for sorting, my thinking was I would be able to save the file as focus hold file then rename them, I've tried using define and compute with no luck and ideas?


Secongd question is how do you change the properties of a column in a heading?

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


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
GamP
Virtuoso
posted Hide Post
Why would you want to rename a column? You can always use the AS phrase while reporting...
Changing the properties of a column in a heading ... I think you mean the way the column is presented? If that's indeed the case, then use DEFINE to create a new field with the desired properties (format and edit options) and use that field in the heading.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
DaveZ
Gold member
posted Hide Post
Maybe I didn't explain myself clear enough...it's data that I'm trying to change not a column name. In sql I saved the data as a_fg, b_promised and c_ and d_ and so on, so when I sort on the column the the data comes out the way the user wants it. I've tried to do a define with no luck, but a define should work correct?


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
GamP
Virtuoso
posted Hide Post
The DEFINE should in that case take care of stripping the a_ b_ c_ aso.
But you do need to keep sorting in that way, so you'll need both fields in the request:
BY ORIG_FIELD NOPRINT
BY DEF_FIELD
or some such code.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
DaveZ
Gold member
posted Hide Post
I'M GETTING THE FOLLOWING ERROR FOR DESCRIPTION ON FIle
code follows

(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: LOB1

APP PATH MFGVIS
APP DELETEF MFGVIS LOB1 MASTER
DEFINE FILE LOB1
RECORD_TYPE_2/A35 = IF RECORD_TYPE EQ 'A.FG' THEN 'FG' ELSE '';
AVG_AR_TERM/D20.0 = IF AVG_AR_TERMS GE 0 THEN AVG_AR_TERMS ELSE 0;
END
APP HOLD MFGVIS
END
ENGINE SQLORA SET DEFAULT_CONNECTION mfgvis

// SQL HERE


END
TABLE FILE SQLOUT
BY PLANT_C
BY PART_X
BY RECORD_TYPE
PRINT BALANCE
RECORD_TYPE
END_PAYWK
DESCR_X
YIELD_6_MONTH_N
INDUSTRY_CODE
AVG_AR_TERMS
ON TABLE NOTOTAL
ON TABLE HOLD AS LOB1 FORMAT FOCUS INDEX PLANT_C PART_X
END
TABLE FILE LOB1
SUM
'LOB1.SEG01.BALANCE'
BY 'LOB1.SEG01.PART_X' NOPRINT
BY RECORD_TYPE NOPRINT
BY RECORD_TYPE_2
ACROSS 'LOB1.SEG01.END_PAYWK' AS ''
ON 'LOB1.SEG01.PART_X' PAGE-BREAK
ON TABLE SUBHEAD
"company name"
"&DATEMDYY <+0> LINE OF BALANCE SUMMARY BY PLANT"
HEADING
"ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Waz
Expert
posted Hide Post
Are there any othere errors being reported.

What happens if you add a -RUN before the TABLE FILE LOB1.

Are there records being written to the FOCUS file ?


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
Jim Morrow
Platinum Member
posted Hide Post
Stick in your code a ?FF SQLOUT I general place it between the End of the SQL ":" and the TABLE FILE SQLOUT

When I review the list of field names I am generally surprised by at least one name or the capitalization.


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



 
Posts: 129 | Registered: June 01, 2005Report This Post
DaveZ
Gold member
posted Hide Post
I got rid of the ERROR FOR DESCRIPTION ON FIle my removing the delete of the hold file

now it does not recognize the define file
THE FIELDNAME IS NOT RECOGNIZED: RECORD_TYPE_2


-*APP DELETEF MFGVIS LOB1 MASTER
DEFINE FILE LOB1
RECORD_TYPE_2/A35=IF RECORD_TYPE EQ 'A.FG' THEN 'FG' ELSE '';
AVG_AR_TERM/D20.0=IF AVG_AR_TERMS GE 0 THEN AVG_AR_TERMS ELSE 0;
TERMS/D12=IF LOB1.SEG01.AVG_AR_TERMS GE 0 THEN LOB1.SEG01.AVG_AR_TERMS ELSE 0;
END


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
You have put the define before the SQL coding.
I think that should be done after retrieving the SQL output

Your defines do not work on the SQL tables.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
DaveZ
Gold member
posted Hide Post
Thanks to everyone for your help.


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
it is helpfull for this forum if you tell us how it is solved




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 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     Resolved sort problem and changing column size

Copyright © 1996-2020 Information Builders