I have a procedure in Oracle that returns a xml, with several levels. Web Focus will treat me properly and automatically.

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

Thats nice to hear

Is there a question

Sorry ...

"WebFOCUS could properly treat different levels of nodes? My colleagues tells me that WebFOCUS is only able to treat:

xxx xxz

and not:


yyy xxx

Thanks in advance

7.6.8, Linux
HTML,Excel,PDF,...

Sorry ...

WebFOCUS could properly treat different levels of nodes? My colleagues tell me that WebFOCUS is only able to treat:
" > / Request>"

and not

" > / Request>"

Thanks in advance

7.6.8, Linux
HTML,Excel,PDF,...

 <Request> <Level1> </ Level1> </Request> 

and not

 <Request> <Level1><Level2></Level2></Level1> </Request> 

I don't think that is necessarily correct.



would be represented in the Master as:

FIELDNAME=REQUEST, ALIAS=Request, USAGE=A1, ACTUAL=A1,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
PROPERTY=ELEMENT, $

FIELDNAME=LEVEL1, ALIAS=Level1, USAGE=A30, ACTUAL=A30,REFERENCE=REQUEST, PROPERTY=ELEMENT, $

FIELDNAME=LEVEL2, ALIAS=Level2, USAGE=A30, ACTUAL=A30,
REFERENCE=LEVEL1, PROPERTY=ELEMENT, $

Am I missing something in the analysis.

quote:

My colleagues tells me that WebFOCUS

This is at least the second instance of wrong / bad information about WebFOCUS and it abilities
from your colleagues.

I seriously suggest that you get your company to invest in some training for both you and your
colleagues.

As a starting point I would make sure that you download the correct documentation for the features
and functionality that you want to use in WebFOCUS.

Based on the very obvious lack of knowledge of your colleagues I would definitely not rely on them
as a way to go forward developing with WebFOCUS.

I do not work with WF, only with Oracle. But my "colleagues" make me change my code because they say WF can do many things.

Please, indicate to me that I must do to learn everything you can about WF and has not have to re edit my code. I would be eternally grateful.

We on FocalPoint are just trying to help each other out. If I misunderstood your requirements then I'm sorry.

But, based on what I think I understand, you have an XML file where you have a structure as follows:

Request
Level1
Level2
/Level2
Level2
/Level2
/Level1
Level1
Level2
/Level2
/Level1
/Request

I'm leaving the caret signs out because they do not show properly in FOCALPOINT.

I the Master I previously posted, it was based on one occurrence of Level1. When I tested that scenario out it worked fine.

But, if you require a structure as indicated above, then the Master would look as follows:

FILENAME=BASEAPP_FOCALPOINT, SUFFIX=XML , $
SEGMENT=REQUEST, SEGTYPE=S0, $
FIELDNAME=REQUEST, ALIAS=Request, USAGE=A1, ACTUAL=A1, MISSING=ON,
ACCESS_PROPERTY=(INTERNAL), $

SEGMENT=LEVEL1, SEGTYPE=S0, PARENT=REQUEST, $
FIELDNAME=LEVEL1, ALIAS=Level1, USAGE=A10, ACTUAL=A10, MISSING=ON,
REFERENCE=REQUEST, PROPERTY=ELEMENT, $

SEGMENT=LEVEL2, SEGTYPE=S0, PARENT=LEVEL1, $
FIELDNAME=LEVEL2, ALIAS=Level2, USAGE=P33, ACTUAL=A33, MISSING=ON,
REFERENCE=LEVEL1, PROPERTY=ELEMENT, $

I tried this out and it worked fine.

Remember, we are responding to what we think the requirements are. If there is a misunderstanding, it must be posted in the thread.

Please feel free to post in this thread if I'm still not understanding what you are asking.
I will try to help you out.

Efrem post anything containing HTML/XML tags
inside the code tags by clicking on the

</>

tab