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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
Hi Leah, I have just come across this when moving code from 7.7.2 to 7.7.03. The CTRAN function is now displaying an a with a ` above it whereas before it was blank. What no. did you change to 160 to ? Regards, Ian
quote:
Originally posted by Leah: SP/A1....
It's fine for me under 4.3.6. Shows space.
Perhaps your browser has a different default language. In ASCII the 160 under extended is actually the a with the ` above it.
I know when we went from mainframe to ascii world we had an issue with conversion using the CTRAN function. Had to change the number we were using.
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Many thanks J.Gross for your suggestion however the code below produces different results in 7.7.2 than in 7.7.3 - results are shown for both. The 7.7.3 version shows the á symbol. Any reason for the change ?
DEFINE FILE CAR SP/A1 = HEXBYT(160, 'A1'); SP1/A1 = ' '; SP2/A10 = CTRAN(1,SP1,32,160,SP2) END -* TABLE FILE CAR PRINT SP SP2 COUNTRY END -RUN
results from 7.6.2...... PAGE 1
SP SP2 COUNTRY ENGLAND JAPAN ITALY W GERMANY FRANCE
results from 7.7.3...... PAGE 1
SP SP2 COUNTRY á á ENGLAND á á JAPAN á á ITALY á á W GERMANY á á FRANCE
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Hi Tom, Yes normally I could do this but as I am holding the output so that it can be passed to an html page the showblanks doesn't work. The idea is to line up the fields in a drop down list for ease of reading.
VALUESAM/A15 = FTOA(SETT_AMNT,'(D15.2c)','A15') ; -*nb. ascii 160 below produces a nice non-printable character ie. a space but html -* treats it if it is a normal character ie. maintains leading blanks VALUEUS/A15 = CTRAN(15, VALUESAM, BYTVAL(' ','I2'), 160, 'A15'); ACCTHTY/A2 = CTRAN(2, ACCT_HTYP, BYTVAL(' ','I2'), 160, 'A2'); ACCTNUM/A9 = CTRAN(9, ACCT_HNUM, BYTVAL(' ','I2'), 160, 'A9'); CURRCDE/A3 = CTRAN(4, SETT_CURR, BYTVAL(' ','I2'), 160, 'A3');
SBYLINE/A150 ='' ; END -* TABLE FILE SETTU1 PRINT SBYLINE ON TABLE HOLD AS SETTUPD1 FORMAT ALPHA END -* -* this html page displays the list created above - but now in 7.7.03 with funny chars. replacing the blanks.
-HTMLFORM QMONUPD1 -RUN
and the hold file has the a with a ' symbol on top. No-one seems to explain why this worked in 7.6.02 but NOT in 7.7.03.
Regards, Ian
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Excellent suggestion Tom - worked a treat - changed the NLS code from 437 to 137 in both the Admin Console and the Server Console and all OK now - yippee - Many thanks, Ian
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005