Not for nuthin' but if F0 represents the primary key, would you be better served with this statement:
LIST INV "302618" F4 F9 F8 as it will go to that record directly instead of searching through the entire file. My 1 cent Mark Johnson P.S. upon further review, you are addressing 2 data sections. ----- Original Message ----- From: "Bruce Ordway" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, January 12, 2007 10:57 AM 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
