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]READING a value ends up appending 000023 with data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]READING a value ends up appending 000023 with data
 Login/Join
 
Rifaz
Guru
posted
Hi,

Today, I'm facing a strange issue. I can't repro using CAR.

Precisely, when i try to read a data from my HOLD file, it ends up with appending 000023data1.

Without reading it, displays the output successfully with no spaces or any.(Eg, ENGLAND,ITALY,JAPAN)

TABLE FILE ABC
PRINT COL1
ON TABLE SAVE
-*ON TABLE HOLD AS HOLDFILE FORMAT ALPHA(Tried as well, results same)
END
-RUN
-READ SAVE, &DATA1.A200.
-*-READ HOLDFILE &DATA1.A200.
-TYPE &DATA1


Let's assume COL1 has ENGLAND,ITALY,JAPAN and perhaps its a ALPHANUMERIC field.
Output
-------
000023ENGLAND

Seems, blank lines are in my HOLD file.Further, i searched in google, guess it is taking out a special character([]) of HEXA, something like square box.

Tried with ON TABLE SET PAGE-NUM NOPAGE as well, results vain.

Has anyone faced this kind of issue?

Environment: Oracle DB,WF-7611.

Thanks,
Rifaz

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


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Alan B
Virtuoso
posted Hide Post
That's because it is a variable length field. See this post.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
njsden
Virtuoso
posted Hide Post
As Alan pointed out, that behaviour is due to the use of AnV fields in your request.

Unfortunately you are not still on a 7.7.x platform. Since its introduction in 7.7 I switched to using the new -READFILE feature instead of the classic -READ and never looked back. It takes care of all of that stuff for you.

In your case, I suggest that you define/compute a new fixed-length alpha field and use that instead to read into a Dialogue Manager variable.

TABLE FILE ABC
PRINT
        COL1 NOPRINT
COMPUTE COL1_A/A200 = COL1;
ON TABLE SAVE AS HDATA
ON TABLE SET HOLDLIST PRINTONLY
END
-RUN
-READ HDATA &DATA1.A200.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Rifaz
Guru
posted Hide Post
Thanks both of you, but believe me i tried already by defining in one field, still results the same.

I will recheck again tomorrow morning in real time.

Any other possible solutions in 7611?


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
njsden
Virtuoso
posted Hide Post
quote:
i tried already by defining in one field, still results the same.


That's strange. Please look closely at my sample code and focus on the SET HOLDLIST PRINTONLY call which guarantees that only values being "printed" will be available in your SAVE/HOLD file, therefore only COL1_A would be in the file with no prefixed length as it is an A200 field.

Please feel free to also post a short and simplified version of the code you're using for ease of assistance.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Rifaz
Guru
posted Hide Post
sure njsden, i do it tomorrow. I din't have SET HOLDLIST=PRINTONLY in my fex. I'll try and let you know Smiler


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Rifaz
Guru
posted Hide Post
Alan is correct, its because of variable length field, able to suppress the junk values after changing the format to A200 with SET HOLDLIST=PRINTONLY.

Thanks Alan and njsden again!!!


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report 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]READING a value ends up appending 000023 with data

Copyright © 1996-2020 Information Builders