[U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Andy Moore
DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hello,

I am currently writing an application in VB.Net that communicates with
Universe servers via UVSH.EXE
(can't use Uniobjects as not all our users install them or allows them)

I have hit a problem where I am trying to create a file via UVSH.EXE as it
appears I am limited to one line commands, unless anyone knows differently?

The problem is that I am trying to create a type 19 file and although the help
file on Universe states I can do this with one line, Universe itself doesn't
seem to alllow it.

In the help file it says the following:

CREATE.FILE [DICT | DATA] [filename [, datafile]]  [type] [modulo]
[separation] [parameter [value]...]   [description]

Am I incorrect in understanding the TYPE option to be the file type?

For an example to this I am typing (following the above)  CREATE.FILE TESTFILE
19 1 3

which I would expect to create me a type 19 file, but it creates a type 18
file!

Is there something I am doing wrong here or is the help file incorrect?

I have tried this on Universe 10.0.4 and 10.1.0 and both versions seem to act
the same.

Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Dennis Bartlett
Hi Andy

Yes I got your post, but didn't reply as I had only an
inkling of what
possible direction you could choose. I toddled off to the
manuals, and
as yet haven't found anything of value, so ... here's my
theory:

why can't you use the mkdbfile executable in UV\bin? Or
it's pal
create.file?

Somewhere I used it to create files in another account, and
found the
how-to in the archives... however today I can't even find
the
archive... :)

What I do remember is that I assembled the command, then
executed it
from within Basic - if this is correct you should be able to
access it
from outside of basic?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Les Hewkin
To create a test file type

CREATE.FILE TESTFILE 1,2,18 1,2,19

1,1,18 is the dict size and type (mod = 1, sep = 2, type = 18) 
1,1,19 is the data size and type (mod = 1, sep = 2, type = 19)

Les

-Original Message-
From: Andy Moore [mailto:[EMAIL PROTECTED]
Sent: 07 July 2004 11:42
To: [EMAIL PROTECTED]
Subject: [U2] CREATE.FILE one liner and UVSH.EXE


DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hello,

I am currently writing an application in VB.Net that communicates with
Universe servers via UVSH.EXE
(can't use Uniobjects as not all our users install them or allows them)

I have hit a problem where I am trying to create a file via UVSH.EXE as it
appears I am limited to one line commands, unless anyone knows differently?

The problem is that I am trying to create a type 19 file and although the help
file on Universe states I can do this with one line, Universe itself doesn't
seem to alllow it.

In the help file it says the following:

CREATE.FILE [DICT | DATA] [filename [, datafile]]  [type] [modulo]
[separation] [parameter [value]...]   [description]

Am I incorrect in understanding the TYPE option to be the file type?

For an example to this I am typing (following the above)  CREATE.FILE TESTFILE
19 1 3

which I would expect to create me a type 19 file, but it creates a type 18
file!

Is there something I am doing wrong here or is the help file incorrect?

I have tried this on Universe 10.0.4 and 10.1.0 and both versions seem to act
the same.

Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


This e-mail and any attachments are confidential and intended solely for the use of 
the addressee only. If you have received this message in error, you must not copy, 
distribute or disclose the contents; please notify the sender immediately and delete 
the message.
This message is attributed to the sender and may not necessarily reflect the view of 
Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis 
Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no responsibility for 
changes made to this message after it was sent. Whilst steps have been taken to ensure 
that this message is virus free, Travis Perkins accepts no liability for infection and 
recommends that you scan this e-mail and any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone 
Road, Northampton, NN5 7UG.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Mike Dallaire
Andy,
Try CREATE.FILE filename 1,3 1,3,19
HTH,
Mike Dallaire
Mortgage Builder Software Inc.
(248) 208-3223 ext. 103
[EMAIL PROTECTED]
www.mortgagebuilder.com



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Andy Moore
Sent: Wednesday, July 07, 2004 6:42 AM
To: [EMAIL PROTECTED]
Subject: [U2] CREATE.FILE one liner and UVSH.EXE


DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hello,

I am currently writing an application in VB.Net that communicates with
Universe servers via UVSH.EXE
(can't use Uniobjects as not all our users install them or allows them)

I have hit a problem where I am trying to create a file via UVSH.EXE as it
appears I am limited to one line commands, unless anyone knows differently?

The problem is that I am trying to create a type 19 file and although the
help
file on Universe states I can do this with one line, Universe itself doesn't
seem to alllow it.

In the help file it says the following:

CREATE.FILE [DICT | DATA] [filename [, datafile]]  [type] [modulo]
[separation] [parameter [value]...]   [description]

Am I incorrect in understanding the TYPE option to be the file type?

For an example to this I am typing (following the above)  CREATE.FILE
TESTFILE
19 1 3

which I would expect to create me a type 19 file, but it creates a type 18
file!

Is there something I am doing wrong here or is the help file incorrect?

I have tried this on Universe 10.0.4 and 10.1.0 and both versions seem to
act
the same.

Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
---
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/


RE: [U2] building DICT items

2004-07-07 Thread Chuck Mongiovi
Sorry that I haven't responded to any of these posts - I was away for a few
days ..

Stuart answered the real question with:

F6/F6/I(i-dict) [thanks Stuart!]

Mark, I'm curious where you got the syntax for:

008 A;S(10*(NV=4))

I can't use TFILE;X;10;10 because UV doesn't support indexing (even as a
local file loopback TRANS)

Besides, it falls into the performance conversation - It causes another read
of the record.
-Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Andy Moore
DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Piers,

This still requires the modulo and seperation to be entered seperately in the same way 
that it would require the file type to be entered seperately if I entered just the 
modulo and seperation which is the problem I am trying to avoid as I am using UVSH.EXE

Mike  Les,

Thanks, both your answers worked!

IBMs documentation is misleading with this, but thanks for your help all.

-Original Message-
From: Piers Angliss [mailto:[EMAIL PROTECTED]
Sent: 07 July 2004 13:09
To: [EMAIL PROTECTED]
Subject: RE: [U2] CREATE.FILE one liner and UVSH.EXE


Re Creating Type 19 files, have you tried 

CREATE.FILE TESTFILE 19  without the modulo and separation ?

Hth

Piers
---
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/


Re: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Terry Layne
On Wed, 7 Jul 2004 11:42:11 +0100, Andy Moore wrote
 DISCLAIMER:
 This email and any files transmitted with it are confidential and intended
 solely for the use of the individual or entity to whom they are addressed.
 If you have received this email in error, please delete it and notify
 the sender immediately.  Please note that there is no guarantee that
 this email or any attachment is virus free or has not been 
 intercepted or amended.
 

Putting this worthless dribble at the top of an email is really annoying. 
See the following for a discussion of how stupid they are.

http://www.goldmark.org/jeff/stupid-disclaimers/

--
Terry Layne
Portland, OR
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Andy Moore
DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

I apologise about the disclaimer at the start of my email, I have complained about 
this in the past to our system administrator, but he's adament that it stays. (I've 
had complaints from customers that I email as on HTML mail it's coded in such a way 
that sets of some spam catchers!)

Sorry everyone, but there's not much I can do about it and I hate it as much as you do.

I have suggested a link in the email somewhere to our disclaimer or even putting the 
disclaimer at the end of the email if it really must be there.

As your referenced site states, they aren't much use anyway.



-Original Message-
From: Terry Layne [mailto:[EMAIL PROTECTED]
Sent: 07 July 2004 16:04
To: [EMAIL PROTECTED]
Subject: Re: [U2] CREATE.FILE one liner and UVSH.EXE


On Wed, 7 Jul 2004 11:42:11 +0100, Andy Moore wrote
 DISCLAIMER:
 This email and any files transmitted with it are confidential and intended
 solely for the use of the individual or entity to whom they are addressed.
 If you have received this email in error, please delete it and notify
 the sender immediately.  Please note that there is no guarantee that
 this email or any attachment is virus free or has not been 
 intercepted or amended.
 

Putting this worthless dribble at the top of an email is really annoying. 
See the following for a discussion of how stupid they are.

http://www.goldmark.org/jeff/stupid-disclaimers/

--
Terry Layne
Portland, OR
---
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/


[U2] Re: Useless Dribble

2004-07-07 Thread Karl L Pearson
In most, if not all cases, the sender of those 'useless' posts have no
control over what or where. Unfortunately, that's the nature of
corporations. They are so interested in protecting themselves, they
forget how annoying they can be. To maintain my sanity, I choose to let
it rest. Advice worth considering? perhaps not...

Karl

On Wed, 2004-07-07 at 09:04, Terry Layne wrote:
 On Wed, 7 Jul 2004 11:42:11 +0100, Andy Moore wrote
  DISCLAIMER:
  This email and any files transmitted with it are confidential and intended
  solely for the use of the individual or entity to whom they are addressed.
  If you have received this email in error, please delete it and notify
  the sender immediately.  Please note that there is no guarantee that
  this email or any attachment is virus free or has not been 
  intercepted or amended.
  
 
 Putting this worthless dribble at the top of an email is really annoying. 
 See the following for a discussion of how stupid they are.
 
 http://www.goldmark.org/jeff/stupid-disclaimers/
 
 --
 Terry Layne
 Portland, OR
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
-- 
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [OT} email disclaimers

2004-07-07 Thread Jeff
Once upon a time some PHB in a company far far away dictated that there be disclaimers 
at the bottom of all outbound corporate email.  Another PHB saw the disclaimer and 
said well, if they have one then we'd better get one too and so began the 
exponential chain reaction of disclaimers.  At first the disclaimers were small and 
relatively unoffensive but as time went on the content of the disclaimers became less 
and less important and the sheer volume of the verbiage began to grow and grow.  Then 
one day the entire content of email messages was obscured by the disclaimers and the 
Internet as we knew it died.

Or not.


[stuff snipped]
Putting this worthless dribble at the top of an email is really annoying. 
See the following for a discussion of how stupid they are.

http://www.goldmark.org/jeff/stupid-disclaimers/

--
Terry Layne
Portland, OR


Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] CREATE.FILE one liner and UVSH.EXE

2004-07-07 Thread Peter Olson
yorkshire  terrier  next door is living on borrowed
time, let me tell you.. ROFLMAO!!!


Thank You!!!



This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately. 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Cannot see UniOleDB drivers

2004-07-07 Thread Lynn Fernando
We installed Unidata 6.0 on the Unix server and the Middleware client on
WindowsXP. On the list of drivers in Windows under Adminstrative
Tools/Data Source, I only see the IBM Unidata ODBC driver but not the
UniOledb Driver. I made sure UniOleDB was clicked when I installed
UniDK, however it does not want to show up. I did setup the uci.config
file correctly. Please could you tell me how I could check whether
UniOledb is setup and working and what is the quickest way to do it. 
Any help is greatly appreciated.
Thanks.
Lynn
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [OT} email disclaimers

2004-07-07 Thread Larry Hiscock
How about if we move this thread to U2-Community?  It does not really belong
on this list.

Thanks,

Larry Hiscock
Moderator 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Sent: Wednesday, July 07, 2004 8:56 AM
To: U2 Group
Subject: [U2] [OT} email disclaimers

Once upon a time some PHB in a company far far away dictated that there be
disclaimers at the bottom of all outbound corporate email.  Another PHB saw
the disclaimer and said well, if they have one then we'd better get one
too and so began the exponential chain reaction of disclaimers.  At first
the disclaimers were small and relatively unoffensive but as time went on
the content of the disclaimers became less and less important and the sheer
volume of the verbiage began to grow and grow.  Then one day the entire
content of email messages was obscured by the disclaimers and the Internet
as we knew it died.

Or not.


[stuff snipped]
Putting this worthless dribble at the top of an email is really annoying. 
See the following for a discussion of how stupid they are.

http://www.goldmark.org/jeff/stupid-disclaimers/

--
Terry Layne
Portland, OR


Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED]
---
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/


RE: [U2] [OT] No Mail from List

2004-07-07 Thread Grant.Boice
No, either we are awake or on vacation (holiday).  Plus, we have a 4 day work week 
this week, due to the fact Monday was a federal holiday.

Don't worry...Everyone will be back on Monday.

Grant

-Original Message-
From: Dennis Bartlett [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 6:43 AM
To: [EMAIL PROTECTED]
Subject: [U2] [OT] No Mail from List


I know amer*ica is sleeping, but I've had a total of 11
posts from the
list today - has the planet met it's nemesis and I don't
know? Is it a
holiday?
---
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/


RE: [U2] Cannot see UniOleDB drivers

2004-07-07 Thread alfkec
The OleDB drivers are a little different. I do two things to test them:

1. Create a file on my desktop called myconnection.udl. When you open this
file it is a data link properties item. Change the driver to UniData on the
providers tab. Enter the settings in the connection tab. The Data Source is
looking for the data source name you created with the uci config (like
localud). Careful, it's case-sensitive. The location is either a database
you have defined in ud_database or the full path the account (eg.
c:\unidata\demo). I check Use a specific user name and password and allow
saving password and make sure blank password is unchecked. Then I enter a
valid user name and password and then click the test connection button. It
should say OK. You may want to delete this file when you are done as it is
actually a plain text file with the user and password in clear text.

Once 1 is successful I use:

2. From http://gpoulose.home.att.net/ I downloaded the Query Tool (using
ADO). You then connect with it (much like the .udl file). It will let you
browse the tables/views setup with VSG as well as directly enter SQL
statements. There is also a query tool for ODBC that you can use to test
your ODBC setup.

The biggest gottcha is that many things are case-sensitive that you may
not expect. Treating everything as case-sensitive seems to really help
prevent problems.

Good luck

-- 
Colin Alfke
Calgary, Alberta Canada

Just because something isn't broken doesn't mean that you can't fix it

Stu Pickles


-Original Message-
From: Lynn Fernando [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 11:27 AM
To: [EMAIL PROTECTED]
Subject: [U2] Cannot see UniOleDB drivers


We installed Unidata 6.0 on the Unix server and the Middleware 
client on
WindowsXP. On the list of drivers in Windows under Adminstrative
Tools/Data Source, I only see the IBM Unidata ODBC driver but not the
UniOledb Driver. I made sure UniOleDB was clicked when I installed
UniDK, however it does not want to show up. I did setup the uci.config
file correctly. Please could you tell me how I could check whether
UniOledb is setup and working and what is the quickest way to do it. 
Any help is greatly appreciated.
Thanks.
Lynn
---
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/


[U2] uvfixfile select lists

2004-07-07 Thread Norman, David (SAAS)
We are preparing to migrate from our old HP-UX system running UV 9.4 HP-UX
10.20 to our new system running UV 10.0.16 HP-UX 11i and are doing some file
consistency checks before migration.
We have noticed some bizarre behaviour when uvfixfile is running on a select
list of dynamic files.
We originally copied the 9.4 dynamic files over to the new system using tar.
Selecting some of these files and running uvfixfile against this select list
works as expected. When we create a new dynamic file under 10.0.16 and run
uvfixfile on that file by itself it works as expected. If a 10.0.16 file is
the FIRST one in the select list it also works OK. BUT if a 10.0.16 file is
other than the first file in the select list, uvfixfile aborts with Invalid
separation of 0x0 encoded in header. Floating point exception. and stops
processing the list.
Anyone else noticed this peculiarity ?

BTW, if uvfixfile reports a problem such as 'file load discrepancy', is it
best to run uvfixfile -fix or resize * * * to fix these problems ?

Thanks,

David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] uvfixfile select lists

2004-07-07 Thread Logan, David (SST - Adelaide)
Hi David,

Try using fixtool instead. You can run this from the uvadmin screen and
this will do the consistency checks that you need. This is the tool that
is now preferred at version 10 AFAIK. uvfixfile also doesn't cope too
well with 64bit files whereas fixtool is quite happy. I think it is
titled file tool on the uvadmin screen

Regards

David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Norman, David
(SAAS)
Sent: Thursday, 8 July 2004 9:12 AM
To: '[EMAIL PROTECTED]'
Cc: 'John Kent'
Subject: [U2] uvfixfile  select lists


We are preparing to migrate from our old HP-UX system running UV 9.4
HP-UX
10.20 to our new system running UV 10.0.16 HP-UX 11i and are doing some
file
consistency checks before migration.
We have noticed some bizarre behaviour when uvfixfile is running on a
select
list of dynamic files.
We originally copied the 9.4 dynamic files over to the new system using
tar.
Selecting some of these files and running uvfixfile against this select
list
works as expected. When we create a new dynamic file under 10.0.16 and
run
uvfixfile on that file by itself it works as expected. If a 10.0.16 file
is
the FIRST one in the select list it also works OK. BUT if a 10.0.16 file
is
other than the first file in the select list, uvfixfile aborts with
Invalid
separation of 0x0 encoded in header. Floating point exception. and
stops
processing the list.
Anyone else noticed this peculiarity ?

BTW, if uvfixfile reports a problem such as 'file load discrepancy', is
it
best to run uvfixfile -fix or resize * * * to fix these problems ?

Thanks,

David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
---
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/


Re: [U2] building DICT items

2004-07-07 Thread Mark Johnson
I created this expression back in the early 1980's on a Microdata. At that
time I only worked on R80 and MCD and MCD had advanced A correlatives and
our main inventory file had field 22 as the On-Hand, 23 for On-orders, 24
for Commits etc with the whs's being the according multi-value. Thus the
data looked like:

022 11]22]33]44]55]66]77

So to get the On-Hand for whs 5, DICT INVENTORY OH-5 was
008 A;S(22*(NV=5))

There was no TINVENTORY;X5;22;22 (note the X5) function. We could have used
008 A;(0(TINVENTORY;X;22;22))(G4 1)
but that included an extra read. Apparently mv's get translated to spaces
this way. I don't recall if blank intermediate mv's produced a space or null
which confused the G4.

There were no subroutines for dict items either. MCD offered some user exits
followed by a semi-colon and the appropriate mv number but I don't recall
them working either.

Mark Johnson

- Original Message -
From: Chuck Mongiovi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 9:08 AM
Subject: RE: [U2] building DICT items


 Sorry that I haven't responded to any of these posts - I was away for a
few
 days ..

 Stuart answered the real question with:

 F6/F6/I(i-dict) [thanks Stuart!]

 Mark, I'm curious where you got the syntax for:

 008 A;S(10*(NV=4))

 I can't use TFILE;X;10;10 because UV doesn't support indexing (even as a
 local file loopback TRANS)

 Besides, it falls into the performance conversation - It causes another
read
 of the record.
 -Chuck
 ---
 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/


[U2] Results Formula/Work Order Module

2004-07-07 Thread Mark Johnson
Does anyone have any version of the original Microdata Results Formula/Work
Order module. I have a client with Results that would be interested in
acquiring it.

I have another client with this module but I haven't approached them on
acquiring it. It's an interesting dilemma.

If that doesn't pan out, I would be interested in a MRP/BoM module that could
be easily integrated into the Results PRODUCT concept.

If that doesn't pan out, I would be interested in any MV-based MRP/BoM
module.

If you are a seller of choice #2 or choice #3, please give me a week to see if
#1 comes through. I don't want to intitiate sales inquiries just yet.

Thanks in advance.
Mark Johnson
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] terminal on universe

2004-07-07 Thread Louie Gouws
Dave,

Do you want to print to a file OR do you really want to use rs232 etc.?

Louie

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Raven
Sent: 07 July 2004 08:28
To: [EMAIL PROTECTED]
Subject: [U2] terminal on universe


I have universe 9 on a windows 2000 server and would like to attached to the
rs232 port on the server a dumb terminal, has anyone done this and if so how
do I setup the port.

My intention is to capture an input line from a rs232 printer port.

I would logon a the rs232 port and start a basic program with an input
prompt. then start the remote computer running a report to the rs232 port on
the server and capture the report to a file.


Thanks


D Raven
e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811
---
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/