[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

[U2] Straw Poll - what GUI do you/would you use?

Perhaps this question should've gone to the community list but I didn't want to miss the technical readers, nor their technical input. I'm conducting a straw poll about the 'preferred' graphical user interface. Please, no vendors or software providers. [We like you, we just want to hear from

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,

RE: [U2] Dataflo Unidata TCL and the INV file

bruce I think this is what you want LIST INV '302618''302618' F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... Regards graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Friday, January 12, 2007 3:58 PM

RE: [U2] Dataflo Unidata TCL and the INV file

Bruce Sorry miss read your email - as Kevin said I think you have a multi level file. Not sure but you probably best using an itype with some basic code to get what you need. Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]

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:

RE: [U2] Dataflo Unidata TCL and the INV file

Graham, I think this is what you want LIST INV '302618''302618' F4 F9 F8 I thought the same thing but Bin Qty Bin Loc are blank when I list INV On the other hand, Inv Code is blank if I list INV,SV It's driving me crazy. Thanks, Bruce --- u2-users mailing list

Re: [U2] Dataflo Unidata TCL and the INV file

Bruce, you will need dictionaries with T-codes (translate) in the dict of the INV file! If there aren't any, you may need to create them. If you can't create new dict items, try EVAL I.e. LIST INV F4 F9 F8 EVAL TSV;X;;4 COL.HDG INVENTORY CODE EVAL TSV;X;;9 COL.HDG BIN QTY EVAL TSV;X;;8

RE: [U2] Dataflo Unidata TCL and the INV file

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

RE: [U2] Straw Poll - what GUI do you/would you use?

.Net has become my environment of choice. The Visual Studio IDE is fantastic and the character based U2 stuff that I've used since the 80's seems archaic and I'm not going back. Microsoft has tools, integration and support that's hard to match. I've become very proficient in both C# and VB.Net

Re: [U2] Dataflo Unidata TCL and the INV file

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