http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/jql2_CONVER SION.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.h tm From: [email protected] [mailto:[email protected]] On Behalf Of Doug Fleetham Sent: Tuesday, May 21, 2013 4:06 PM To: [email protected] Subject: Dictionary reference to file 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. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
