Bruce: I'll give you a quick view from a PICK perspective. It is normal, and natural, to allow data files to share a dictionary. In PRIME one simply created two separate data files, one dictionary and modified the (VOC) entry of each to point to the "shared" dictionary like:
INV 001 F 002 \dbms\live\DATAFLO\INV\ 003 \dbms\live\DATAFLO\D_INV SV 001 F 002 \dbms\live\DATAFLO\SV\ 003 \dbms\live\DATAFLO\D_INV Here you can reference each file by: LIST INV ...and LIST SV In PICK this was implemented a little differently; a file was created with both a dictionary and a data portion (the data being "under" the dictionary), then a new data portion was created under the shared dictionary. The structure is exactly as you described. References to each would be: LIST INV (or you can LIST INV,INV but listing INV defaults to itself) ...and LIST INV,SV Generally, these structures are built when both the INV and the SV files contain the exact same file structure. You indicate this isn't the case so...C'est la vie. When you use "F." dictionaries these are generally U2 default dictionaries for attribute numbers; thus F1 lists attribute 1, F2 lists attribute 2, and so forth. In your case, again, this isn't the case. So, you need to build appropriate dictionaries that extract the data you want then list them in the query. For instance, copy F4 to INV_CODE, F9 to BIN_QTY, and F8 to BIN_LOC, then, assuming F4 references field# 4, your INV_CODE would be changed to look like: INV_CODE 001 I The inventory code from the SV data file 002 TRANS ( "INV,SV", @ID, 4, "X") 003 004 INVENTORY CODE 005 15L 006 M Now you can: :LIST INV INV_CODE BIN_QTY BIN_LOC Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway > Sent: Friday, January 12, 2007 11:08 AM > To: [email protected] > Subject: RE: [U2] Dataflo Unidata TCL and the INV file > > Kevin, > > It's MV alright, but there is something I don't understand about this > file. > > That's why I was hoping a someone familiar with the app might be > browsing today. > > I've got a work around using two Query Builders to export and > then using > sub queries in Access. > > BTW here's the dirctory structure: > > \dbms\live\DATAFLO\INV\ > |_________________________INV > |_________________________SV > > INV has a dictionary > Some inventory data for a part is stored in INV and some in SV. > I can't figure out how to pull data from both in one query. > I also can't figure out why this was ever broken up this way. > > Thanks, > > Bruce > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Friday, January 12, 2007 10:45 AM > To: [email protected] > Subject: RE: [U2] Dataflo Unidata TCL and the INV file > > >Anybody familiar with Dataflo running on Unidata? > > I don't know the application specifically, but just looking at > the commands you've entered it appears that INV is a multi-level > data file. > > This means that basically you have two data tables sharing one > dictionary. For what you want to do, translates between the > files might do the trick but I would suspect that with what > appear to be multivalues there's probably more complexity > involved than simple translates to make this happen. > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > > ** Check out scheduled Connect! training courses at > http://www.PrecisOnline.com/train.html. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Friday, January 12, 2007 3:58 PM To: [email protected] Subject: [U2] Dataflo Unidata TCL and the INV file Hi, Anybody familiar with Dataflo running on Unidata? I'm tryng to view a list of records from INV & am having trouble with my TCL. What queries I've tried only return partial info. What I need is a combination of the info returned by the two queries below: ******************* INV query ******************************* LIST INV WITH F0 = "302618" F4 F9 F8 INV....... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK SV VR 1 record listed ******************** INV,SV query ************************** LIST INV,SV WITH F0 = "302618" F4 F9 F8 INV....... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 14.0000 67C 1.0000 44B 1 record listed *************************************************************** i.e. What I want to see is this: INV....... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK 14.0000 67C SV 1.0000 44B VR 1 record listed ********************************************************************* Can somebody show me how to query INV correctly? Thanks, Bruce Ordway Viking Engineering P.S. I find INV to be the most confusing part of my MV world. I'd like to hear any insights/comments on INV. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
