EXTRACTING LOCAL.REF FIELDS

Hi,
How can i extract local references field in a table i.e. for each LOCAL.REF field put it in its own column

Thanks.
Greatness is often found in common places...amongst common faces

I am not clear exactly what/where you need?

Can you try with the below queries from Jbase prompt.

-->LIST DICT FBNK.CUSTOMER WITH F2 LIKE LOCAL.REF... ONLY F2

OR

-->LIST DICT FBNK.CUSTOMER WITH F2 LIKE LOCAL.REF... ONLY

If you want to extract all the data from LOCAL.REF i.e can be done using the below query.

-->LIST FBNK.CUSTOMER ONLY LOCAL.REF

OR
-->TERM 132
-->LIST FBNK.CUSTOMER ONLY EVAL 'LOCAL.REF<1,1>' EVAL 'LOCAL.REF<1,2>'

hai maya this may solve ur problem. this is a way by which we can extract the data from local reference field of an application.


CALL GET.LOC.REF('CUSTOMER','BIRTH.CERTI',YBIRTH.POS)

YVALUE = R.NEW(EB.CUS.LOCAL.REF,YBIRTH.POS)



3 arguments to be passed in the routine.



2 input parameters



Name of the application = 'CUSTOMER'

Name of the local field = 'BIRTH.CERTI



1 output:



Name of the outcoming variable to get the position = 'YBIRTH.POS'