Dictionary reference to file

[Doug Fleetham]

I have a vague memory of setting up a dictionary item for a file to reference values in another file.

 

So that if the ORDER.FILE has dictionary items 1 (which is the customer ID), LAST.NM where 1 might be:

 

0001 A

0002 1

0003 Customer Id

0004

0005

0006

0007

0008

0009 L

0010 8

 

And LAST.NM would approximate:

 

0001 A

0002 1

0003 Last Name

0004

0005

0006

0007 CUSTOMER.FILE<2>

0008

0009 L

0010 22

 

      or some such thing that would take the value at field 1 of the ORDER record and use that to access the appropriate record in the CUSTOMER.FILE returning the appropriate value in field 2 of the record which is hopefully going to be the last name.

 

The system that I last used this in many years ago emulated Advanced Pick. There is no emulation set on my current system. Should there be? Is it required for this kind of functionality and, if it is, is there some kind of workaround for non-emulating systems.

 

If anyone knows how to set up dictionaries in this manner, would it be too much trouble to beg for an example?

 

And while I’m parading my fading memory in these hallowed groups, does anyone know how to set up a dictionary so that it will return the Nth value of a multi-valued field? That is, <19> = 1]2]3]4]5 and the item 19.2 might return ‘2’?

 

Thanks in advance,

 

Doug Fleetham.

 

 

[Mark Hogden]

http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/jql2_CONVERSION.TFILE.htm

 

007 Tfilename;X;;amc  TCUSTOMER.FILE;X;;2

 

Entries in 007 are post(selection) processing, so if you need to sort or select on LAST.NM put the translate in 008

 

The same command can be used to extract a specific value where v is the VALUE number.

 

007 Tfilename;Xv;;amc  

 

The filename can be the same as the primary file, but it’s probably way more efficient to write a little basic routine and call that from the dict item.

http://www.jbase.com/r5/knowledgebase/howto/general/common/DictSubroutines.htm

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
 
---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.