I AND J DESCRIPTORS

can anyone pls post the details of j descriptors with example and the difference between i and j(along with an example pls). for i descriptors, the example has already been posted in this forum by takoor. many thanks takoor for the same.

thanks in advance.

Rgds,
mks

J descriptor allows data extracted from related files and can be used as a data

FILE.NAME......... ACCOUNT

---

1.12 SYS.FIELD.NAME. INDUSTRY
2.12 SYS.TYPE....... J
3.12. 1 SYS.FIELD.NO CUSTOMER.NO>CUSTOMER>INDUSTRY
6.12 SYS.DISPLAY.FMT 4R
10.12 SYS.SINGLE.MULT S


The above example is an ?ACCOUNT? record in SS.
Account application doesn?t contains a field INDUSTRY
So the value of INDUSTRY is extracted from Customer file using ?J? Descriptors.

The linkage uses chain syntax

Available field> Key to file > field to be extracted

CUSTOMER.NO>CUSTOMER>INDUSTRY

Customer. No ? is the field available in Account application
Customer - is the file to be referred using Customer. No as a record.
Industry - is the field to be extracted from the file Customer
Using Customer. No as an id

Multiple chains is also possible like this,

CUSTOMER.NO>CUSTOMER>ACCOUNT.OFFICER>DEPT.ACCT.OFFICER>DESCRIPTION

Which extracts Description of Account Officer from the DEPT.ACCT.OFFICER using Customer No

I think it may clear ur doubt...
_________________
Thanks n Regards,
Somz

Thank you very much Soms for the explicit reply.

Rgds,
MKS

Hi,

Nice to see this conversation..

Then whats the difference between I and J descriptors.

Your answers are more welcome.
_________________
M A L A I

Hello Malai,

In case of 'I Descriptors', we can use both Field names and Field numbers but for 'J Descriptors' we can use only Field Names. Use of Field numbers are not allowed in case of J Descriptors.

Please correct me if I am wrong.


Anyone to cent regarding the conceptual difference between I and J Descriptors are most welcome.

Thanks in Advance.
Rgds,
MKS

Hi,

As per my point of view,
the chain like structure is possible only in J-Descriptor.
ie..CUSTOMER.NO>CUSTOMER>INDUSTRY

But I-Descriptor uses subroutine to extract a value..else it may use some functions to extract the value such as FIELD etc...
eg,
SUBR('E.AC.CURR.AVAIL.BAL','')

And it will also use Jbase functions,
SWEEP.REF. Here SWEEP.REF is one of the SS field.
_________________
Thanks n Regards,
Somz

Hello,

The chain (CUSTOMER.NO>CUSTOMER>INDUSTRY
) works fine for I-descriptor too. I have tested it. I followed the same process given by takoor.

Please correct me if there is any division.

Thnx & Rgds,
MKS

Hi MKS,

Sorry for the wrong info. n Thanx for correcting me!
_________________
Thanks n Regards,
Somz