Re: [U2] ARGUS

2005-11-10 Thread Mark Johnson
I never heard of Argus. Perhaps it's with the other MCD 4GL's (sic) like
Wizard, ALL and Realcalc.
- Original Message -
From: "John Kent" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, November 10, 2005 11:20 PM
Subject: [U2] ARGUS


> Anyone have any help documentation on how to use the above 4GL
>
> I think it originally came out of AWA before McDonnell Douglas moved into
the
> Aus market
>
> jak
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] ARGUS

2005-11-10 Thread John Kent
Anyone have any help documentation on how to use the above 4GL

I think it originally came out of AWA before McDonnell Douglas moved into the
Aus market

jak
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Taking night classes

2005-11-10 Thread Mark Johnson
Thanks Larry. I often wonder what the next thing I should invest my brain
in.

- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Thursday, November 10, 2005 5:18 PM
Subject: [U2] Taking night classes


> Sometimes I get questions from Universe and Unidata programmers who are
> unemployed or will be unemployed asking about what classes would be
helpful in
> finding new employment.  I am sure their are many directions a person can
go but
> here are a couple of suggestions.
>   As recruiters we are seeing more requests for U2 along with VB.net and
other
> internet software such as HTML, XML, and other web scripting languages.
Also we
> are seeing less requests for Oracle and more request for MS SQL Server
along
> with the U2 experience.  I thought I would just pass those comments on and
I
> realize that every shop is different.
> Larry Okeson
> Executive Vice President
> Software Search
> 1-800-949-5423 (toll free)
> 770-934-5138
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AIX UPGRADE

2005-11-10 Thread John Jenkins
Jeff

There was a problem when GUIDE came out on 5.2 specifically (a totally new
build of GUIDE that allowed concurrent processing of the file). The old
version of GUIDE was included as guide_51 as a fallback or you could disable
the new feature by running the new GUIDE with the -Z1 option if necessary. 

This was addressed as you say in a later release, but using the old GUIDE
(guide_51) or using the -Z1 option would have been OK as well - you just
couldn't run it concurrently with other access to the file(s) - this was
therefore as per previous usage.

Lots of people renamed the guide executable to guide_52 and also copied
guide_51 to guide to avoid issues and having to remember the -Z1 option.

__

Issue 5623 - Problem Description


UniData -- Prior to this release, if you executed the guide utility
against a dynamic file that was being aggressively updated, the file
became corrupt. This problem has been resolved.

___

There have been a few other fixes but nothing as significant.

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schoby
Sent: 10 November 2005 16:49
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] AIX UPGRADE

Not as such - we are running 6.0.0 just fine on aix 5.3.

You should probably upgrade to 6.1 anyway.  Our application vendor made
us aware of a potential file corruption problem on certain versions of
6.0:

"Our application vendor"  has found an issue with running GUIDE on
DYNAMIC files with UniData versions prior to 6.0.7.  If the files are
being accessed or written to while running the guide on the DYNAMIC
file, corruption may occur.



--
Jeff Schoby
Unix/Network Admin
City of Columbia, Missouri
573.874.6320


>>> [EMAIL PROTECTED] 11/10/05 9:57 AM >>>
Does AIX 5.3 require an upgrade to Unidata 6.1?  - We are currently at
6.0+

TIA



Dawn Janel Davis

DBA II

[EMAIL PROTECTED] 

410-386-8058



Carroll Community College

1601 Washington Road

Westminster, MD 21157
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse - file importation [ad]

2005-11-10 Thread Tony Gravagno
Barry Rogen wrote:
> Does anybody know of a good way (or
> program/utility)  to import (translate as it were)  dBase
> IV  data   onto a  UniVerse system.  We have a shipping
> package that uses dBase IV and I 
> would love to be able to utlize that data from UniVerse.
> As always, any help is greatly appreciated.

Barry, at the risk of posting something here about .NET twice in one day,
I'll suggest that .NET is an option for all of these questions we see here
about "how do I connect X to U2?".  See these links for info about dBASE
and .NET (sew the URL pieces together):
General ODBC to dBaseIV without a DSN:
  http://www.carlprothman 
  .net/Default.aspx?tabid=90#ODBCDriverForDBASE
ODBC .NET Data Provider to datasources like dBaseIV with a DSN:
  http://www.carlprothman
  .net/Default.aspx?tabid=86#ODBCManagedProvider
  (scroll down to "For all other ODBC Drivers)
  (lots of other providers listed on that page, good info!)
ODBC and OLEDB connection info to DBF among many others:
  http:// www.connectionstrings .com/
Sample code:
  http://www.kdkeys
  .net/forums/748/ShowPost.aspx
And
  http://www.experts-exchange
  .com/Programming/Programming_Languages
  /Dot_Net/Q_20666541.html
And
  http://aspadvice
  .com/blogs/andrewmooney/archive/2004/10/22/2477.aspx

So that gets your dBASE files connected to .NET, but then what?  ADO.NET,
usable with those links above is a good universal hub for data from any
relational or MV source.

And then to U2?  [now the ad part]
mv.NET is a wheel spoke (so to speak) to any MV environment.  UO.NET is not
adequate for this it does not include native integration with ADO.NET where
mv.NET does, so while you can use UO.NET to do this for free, you will need
to manually write a lot of code for all of these sorts of projects.

I hope that helps.
Tony
TG@ removethisNebula-RnD .com
(all domains and addresses munged to minimize spam)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [SPAM] RE: [U2] Unidata's .Net UniDynArray

2005-11-10 Thread George Smith
David,

Your statement below was exactly what I was doing. I decided to move the

CloseUniSession above the population of the dataset and got the error.
It would be nice though, don't you agree, to work with UniDynaArray.

george

>However I connect, get the data, drop it into a dataset and disconnect
and
>from then on I don't really use any of the UO. Net commands.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Taking night classes

2005-11-10 Thread larry
Sometimes I get questions from Universe and Unidata programmers who are
unemployed or will be unemployed asking about what classes would be helpful in
finding new employment.  I am sure their are many directions a person can go but
here are a couple of suggestions.
  As recruiters we are seeing more requests for U2 along with VB.net and other
internet software such as HTML, XML, and other web scripting languages.  Also we
are seeing less requests for Oracle and more request for MS SQL Server  along
with the U2 experience.  I thought I would just pass those comments on and I
realize that every shop is different.
Larry Okeson
Executive Vice President
Software Search
1-800-949-5423 (toll free)
770-934-5138
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniVerse - file importation

2005-11-10 Thread Gordon J Glorfield
Whoa!  dBase IV!  As I recall that DB was way before ODBC for external 
access to the data.  But IIRC the data files themselves are just text 
files with fixed length fields.  You should be able to access the DB files 
with UniBasic and READSEQ.  The first "record" in a dBase file is the data 
definition with the length and name of each field.  From there you should 
be able to parse the records as needed.


Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839

[EMAIL PROTECTED] wrote on 11/10/2005 02:07:45 PM:

> Does anybody know of a good way (or program/utility)  to
> import (translate as it were)  dBase IV  data   onto a  UniVerse
> system.  We have a shipping package that uses dBase IV and I
> would love to be able to utlize that data from UniVerse. As always,
> any help is greatly appreciated.

> UV :10.0.19
> HPUX:   11.0
> 
> Cheers,

> Barry  Rogen
> PNY Technologies, Inc.
> Senior  Programmer/Analyst
> (973)  515 - 9700  ext 5327
> [EMAIL PROTECTED]




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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata's .Net UniDynArray

2005-11-10 Thread David Jordan
Once you disconnect, all the dynarray, counts, and similar commands do not
work.  I am not sure if this just the developers view from a character
environment that you stay connected or if it is a form of licensing control
or that they pass the commands back to the database.

However I connect, get the data, drop it into a dataset and disconnect and
from then on I don't really use any of the UO. Net commands.

I use the SPLIT command to break the string on character marks and I build
the strings simply by var1 & chr(254) & var2 

VS2005 makes a lot of this very simple.

Regards

David Jordan
Managing Consultant
 
[EMAIL PROTECTED]

DACONO Holdings Pty Ltd
www.dacono.com.au
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Sorting By Price

2005-11-10 Thread Dianne Ackerman
What flavor of universe are you in?  I know that LOCATE works 
differently in different flavors.

-Dianne

Brutzman, Bill wrote:


With UniVerse, I am trying to sort by descending dollar value using the
following code.

I have tried 'AL'  'DL'  'AR'  'DR'.   I see what it is doing...
Suggestions would be appreciated.

  R.Valuation  = Extended.F   : VM
	 R.Valuation := Part.Nbr : VM 
	 R.Valuation := Bin.Location 


 locate R.Valuation   in  Val.Array<1>by 'DR' setting posn
else  null
 insR.Valuation   before  Val.Array

for R.This = 1 to Total.Items

   This.HK.PN = Val.Array
	  This.Ext   = Val.Array
	  This.Bin   = Val.Array   


   This.Ext.F = field(This.Ext, '.', 1)  ;* To remove pennies

   Prn.Str  = '  '  
	  Prn.Str := This.HK.PN 'L#9'

  Prn.Str := This.Ext.F 'R#11' : '  '
	  Prn.Str := This.Bin   'R#6' 


  print Prn.Str

 next R.This


*-
Output:

 10367322 5H3
 10176720 5C4
 10351119,049 XX3
 10338718 5C4
 10355617,330 FF5
 10324512 4C3
 10259211 WF2
 10351111,525 319
 10358811,252 319
 10041311,125 FF5

--Bill
---

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse - file importation

2005-11-10 Thread Brutzman, Bill
Perhaps a nightly (or hourly) Windows script to create a .txt file from
dBase to a Windows network drive.

I presume that wIntegrate has some (cron) scripting functionality.  From
wIntegrate, run a UniBasic application to thing to grab the .txt file and
save the data to a UV file.

As an alternative, I expect that an ODBC/JDBC/XML thing could be setup.

A challenging task...

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen
Sent: Thursday, November 10, 2005 2:08 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse - file importation


Does anybody know of a good way (or program/utility)  to
import (translate as it were)  dBase IV  data   onto a  UniVerse
system.  We have a shipping package that uses dBase IV and I
would love to be able to utlize that data from UniVerse. As always,
any help is greatly appreciated.

 UV :10.0.19
   HPUX:   11.0


  Cheers,

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
[EMAIL PROTECTED]

-
Far better it is to dare mighty things, to win
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata's .Net UniDynArray

2005-11-10 Thread Marc Harbeson
I copy the records to a local array by SPLIT ing them with something
along the tune of

Dim LocalRec() as string
LocalRec = Split(UdVar.ToString,Chr(254))

And if I need to mess with VM's, I built the equiv of FIELD over in .NET
as part of my generic UniData Global Block.

So I can grab a record, disconnect and continue to use the data  I
did it for performance - it appeared to me that every time I pulled a
field out, there was traffic to the host... (could be me)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno
Sent: Thursday, November 10, 2005 2:29 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata's .Net UniDynArray

Rattling this off for lack of time, I hope it makes sense.  It makes no
technical sense to keep a connection open to the server just to
manipulate
data in a client/middle-tier, except as was suggested when you require
iconv/oconv or other platform-specific services.  mv.NET, for example,
does
not require a server connection to manipulate a dynamic array.  At the
core
of .NET is the concept of the disconnected data architecture - there is
nothing in .NET itself that would mandate a server connection when
you're
manipulating data.  This issue with UO.NET has nothing to do with COM or
Microsoft's implementation of .NET, I'm guessing it's simply a matter of
how the library was designed (the class hierarchy), or perhaps the
UO.NET
wrapper around UO.  If you instantiate a dynamic array from a live
connection then closing the connection might wrapup all "child" objects.
It shouldn't work that way though.  I wouldn't consider a dynamic array
to
be a child of a given connection.  A SelectList or data that relies on
server-side indexes, sure.  This could be a business issue and the price
for UO.NET being "free" - they might have a flag that causes wrapup of
all
objects when the last session is disconnected, but I haven't heard
anyone
mention this since UO.NET was announced.

As a test, can you create a UniDynArray and manipulate it without first
creating a session?  What about creating a connection object but not
logging it in, then working with a DynArray?  (I've forgotten the
specific
class names, sorry.)  If you login, create a DynArray, logout, watch the
array "break", then log back in, can you now access the DynArray?
That's a
sure sign of an activation process at work.  If the DynArray is still
broken after you reconnect then there might just be something up with
their
hierarchies or wrapup code.

About the objects "all" being managed code, I don't think this is the
case.
Please accept my apologies for not knowing enough about UO.NET, but
based
on errors I've seen on connections I believe it's just a PInvoke/wrapper
around UO.  Can someone confirm or deny that?  Thanks.

HTH
Tony Gravagno
Nebula Research and Development
TG@ removethisNebula-RnD.com
Disclosure: Nebula R&D is an authorized Distributor of mv.NET.


George Smith wrote:
>> Is it possible to work on uodotnet.UniDynArrays without
>> having a session object open? I have tried to manipulate
>> a uodotnet.UniDynArray, but when the session is closed,
>> it throws an error. 
> 
> I did not find any definitive answer. It would be in my
> opinion very beneficial to close the session object and
> then do some processing with the UniDynArrays.
> 
> Can anyone see why you should not be able to close the
> session and still work with the UnidynArrays. I do not
> think it has anything to do with COM as I was stepping
> thru C# code Visual Studio. I believe the docs say the
> the objects are all managed code. 
> 
> Thoughts ?
> 
> George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Sorting By Price

2005-11-10 Thread gerry-u2ug
use a second array to sort just the amount field :

Sorted=""


   R.Valuation  = Extended.F   : VM
 R.Valuation := Part.Nbr : VM 
 R.Valuation := Bin.Location 

 locate Extended.F   in  Sorted<1>by 'DR' setting posn
   else  null

 insExtended.F   before  Sorted
 insR.Valuation   before  Val.Array



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Thursday, November 10, 2005 3:11 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Sorting By Price


With UniVerse, I am trying to sort by descending dollar value using the
following code.

I have tried 'AL'  'DL'  'AR'  'DR'.   I see what it is doing...
Suggestions would be appreciated.

   R.Valuation  = Extended.F   : VM
 R.Valuation := Part.Nbr : VM 
 R.Valuation := Bin.Location 

 locate R.Valuation   in  Val.Array<1>by 'DR' setting posn
else  null
 insR.Valuation   before  Val.Array

 for R.This = 1 to Total.Items

This.HK.PN = Val.Array
  This.Ext   = Val.Array
  This.Bin   = Val.Array   

This.Ext.F = field(This.Ext, '.', 1)  ;* To remove pennies

Prn.Str  = '  '  
  Prn.Str := This.HK.PN 'L#9'
  Prn.Str := This.Ext.F 'R#11' : '  '
  Prn.Str := This.Bin   'R#6' 

  print Prn.Str
 
  next R.This

*-
Output:

  10367322 5H3
  10176720 5C4
  10351119,049 XX3
  10338718 5C4
  10355617,330 FF5
  10324512 4C3
  10259211 WF2
  10351111,525 319
  10358811,252 319
  10041311,125 FF5

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Sorting By Price

2005-11-10 Thread BNeylon
Suggestion, turn it sideways
Val.Array<1> = Extended.F ]Extended.F ]Extended.F ]Extended.F 
Val.Array<2> = Part.Nbr]Part.Nbr]Part.Nbr]Part.Nbr]Part.Nbr
Val.Array<3> = Bin.Location]Bin.Location]Bin.Location]Bin.Location]Bin.Location

I always try to use associated multivalues. easy to insert, delete or 
rearrange.


Bruce M Neylon
Health Care Management Group 





"Brutzman, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/10/2005 03:11 PM
Please respond to u2-users

 
To: "'u2-users@listserver.u2ug.org'" 
cc: 
Subject:[U2] Sorting By Price

With UniVerse, I am trying to sort by descending dollar value using the
following code.

I have tried 'AL'  'DL'  'AR'  'DR'.   I see what it is doing...
Suggestions would be appreciated.

   R.Valuation  = Extended.F   : VM
  R.Valuation := Part.Nbr : VM 
  R.Valuation := Bin.Location 

  locate R.Valuation   in  Val.Array<1>by 'DR' 
setting posn
else  null
  insR.Valuation   before  Val.Array

 for R.This = 1 to Total.Items

This.HK.PN = Val.Array 
   This.Ext   = Val.Array 
   This.Bin   = Val.Array 

This.Ext.F = field(This.Ext, '.', 1)  ;* To remove pennies

Prn.Str  = '  ' 
   Prn.Str := This.HK.PN 'L#9'
   Prn.Str := This.Ext.F 'R#11' : '  '
   Prn.Str := This.Bin   'R#6' 

   print Prn.Str
 
  next R.This

*-
Output:

  10367322 5H3
  10176720 5C4
  10351119,049 XX3
  10338718 5C4
  10355617,330 FF5
  10324512 4C3
  10259211 WF2
  10351111,525 319
  10358811,252 319
  10041311,125 FF5

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Sorting By Price

2005-11-10 Thread Pingilley, Ron
Slight correction to previous e-mail:

This.HK.PN = Val.Array<2,R.This><<-- I had attr. #'s swapped
here
  This.Ext   = Val.Array<1,R.This><<--
  This.Bin   = Val.Array<3,R.This>   
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Sorting By Price

2005-11-10 Thread Tom Dodds
In a true UniVerse environment you want to loose the <1> from the locate
statement.  That would indicate to start the search in field 1 and search at
a value mark level.  You are inserting at a field level and searching at a
value mark level in field 1.

locate R.Valuation   in  Val.Arrayby 'DR' setting posn

Tom Dodds
[EMAIL PROTECTED]
630-235-2975
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, November 10, 2005 2:11 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Sorting By Price

With UniVerse, I am trying to sort by descending dollar value using the
following code.

I have tried 'AL'  'DL'  'AR'  'DR'.   I see what it is doing...
Suggestions would be appreciated.

   R.Valuation  = Extended.F   : VM
 R.Valuation := Part.Nbr : VM 
 R.Valuation := Bin.Location 

 locate R.Valuation   in  Val.Array<1>by 'DR' setting posn
else  null
 insR.Valuation   before  Val.Array

 for R.This = 1 to Total.Items

This.HK.PN = Val.Array
  This.Ext   = Val.Array
  This.Bin   = Val.Array   

This.Ext.F = field(This.Ext, '.', 1)  ;* To remove pennies

Prn.Str  = '  '  
  Prn.Str := This.HK.PN 'L#9'
  Prn.Str := This.Ext.F 'R#11' : '  '
  Prn.Str := This.Bin   'R#6' 

  print Prn.Str
 
  next R.This

*-
Output:

  10367322 5H3
  10176720 5C4
  10351119,049 XX3
  10338718 5C4
  10355617,330 FF5
  10324512 4C3
  10259211 WF2
  10351111,525 319
  10358811,252 319
  10041311,125 FF5

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Sorting By Price

2005-11-10 Thread Pingilley, Ron
Bill,

I think you're going to have to transpose your array (swap
columns for rows), or create a stand-alone array to hold just the dollar
amount, in order to make this work.  The thing you're trying to LOCATE
is a 3-value dynamic array itself (1 attribute, 3 values), so it's not a
number, but rather a string.

If you make Val.Array<1> hold the extended amounts, Val.Array<2>
hold the part#'s, and <3> hold the bin locations, then you have all your
dollar amounts in one attribute, and you can LOCATE Extended.F within
that attribute, and then do 3 inserts at the located value position.

Then change your extracts accordingly  See below

--Ron P. 

Loop through part info
   R.Valuation  = Extended.F   : VM
 R.Valuation := Part.Nbr : VM 
 R.Valuation := Bin.Location 

 locate Extended.F   in  Val.Array<1>by 'DR' setting
posn else  null
 insExtended.F   before  Val.Array<1,posn>
 insPart.Nbr   before  Val.Array<2,posn>
 insBin.Location   before  Val.Array<3,posn>
Repeat

*---printing section

 for R.This = 1 to Total.Items

This.HK.PN = Val.Array<1,R.This>
  This.Ext   = Val.Array<2,R.This>
  This.Bin   = Val.Array<3,R.This>   

This.Ext.F = field(This.Ext, '.', 1)  ;* To remove
pennies

Prn.Str  = '  '  
  Prn.Str := This.HK.PN 'L#9'
  Prn.Str := This.Ext.F 'R#11' : '  '
  Prn.Str := This.Bin   'R#6' 

  print Prn.Str
 
  next R.This
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Sorting By Price

2005-11-10 Thread Brutzman, Bill
With UniVerse, I am trying to sort by descending dollar value using the
following code.

I have tried 'AL'  'DL'  'AR'  'DR'.   I see what it is doing...
Suggestions would be appreciated.

   R.Valuation  = Extended.F   : VM
 R.Valuation := Part.Nbr : VM 
 R.Valuation := Bin.Location 

 locate R.Valuation   in  Val.Array<1>by 'DR' setting posn
else  null
 insR.Valuation   before  Val.Array

 for R.This = 1 to Total.Items

This.HK.PN = Val.Array
  This.Ext   = Val.Array
  This.Bin   = Val.Array   

This.Ext.F = field(This.Ext, '.', 1)  ;* To remove pennies

Prn.Str  = '  '  
  Prn.Str := This.HK.PN 'L#9'
  Prn.Str := This.Ext.F 'R#11' : '  '
  Prn.Str := This.Bin   'R#6' 

  print Prn.Str
 
  next R.This

*-
Output:

  10367322 5H3
  10176720 5C4
  10351119,049 XX3
  10338718 5C4
  10355617,330 FF5
  10324512 4C3
  10259211 WF2
  10351111,525 319
  10358811,252 319
  10041311,125 FF5

--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AIX UPGRADE

2005-11-10 Thread Keith Johnson
I do not think so; we were on that for a short time.  I usually load
only once a year for OS and UNIDATA.  We went from 5.2 to 5.3 for two
weeks then when to UNIDATA 6.14 or something like that.  Now 7.+ is
available for UNIDATA 
-Keith Johnson
Lewis-Clark State College
Lewiston, ID
208 792 2510

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Davis, Dawn
Sent: Thursday, November 10, 2005 7:58 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] AIX UPGRADE

Does AIX 5.3 require an upgrade to Unidata 6.1?  - We are currently at
6.0+

TIA



Dawn Janel Davis

DBA II

[EMAIL PROTECTED]

410-386-8058



Carroll Community College

1601 Washington Road

Westminster, MD 21157
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata's .Net UniDynArray

2005-11-10 Thread Tony Gravagno
Rattling this off for lack of time, I hope it makes sense.  It makes no
technical sense to keep a connection open to the server just to manipulate
data in a client/middle-tier, except as was suggested when you require
iconv/oconv or other platform-specific services.  mv.NET, for example, does
not require a server connection to manipulate a dynamic array.  At the core
of .NET is the concept of the disconnected data architecture - there is
nothing in .NET itself that would mandate a server connection when you're
manipulating data.  This issue with UO.NET has nothing to do with COM or
Microsoft's implementation of .NET, I'm guessing it's simply a matter of
how the library was designed (the class hierarchy), or perhaps the UO.NET
wrapper around UO.  If you instantiate a dynamic array from a live
connection then closing the connection might wrapup all "child" objects.
It shouldn't work that way though.  I wouldn't consider a dynamic array to
be a child of a given connection.  A SelectList or data that relies on
server-side indexes, sure.  This could be a business issue and the price
for UO.NET being "free" - they might have a flag that causes wrapup of all
objects when the last session is disconnected, but I haven't heard anyone
mention this since UO.NET was announced.

As a test, can you create a UniDynArray and manipulate it without first
creating a session?  What about creating a connection object but not
logging it in, then working with a DynArray?  (I've forgotten the specific
class names, sorry.)  If you login, create a DynArray, logout, watch the
array "break", then log back in, can you now access the DynArray?  That's a
sure sign of an activation process at work.  If the DynArray is still
broken after you reconnect then there might just be something up with their
hierarchies or wrapup code.

About the objects "all" being managed code, I don't think this is the case.
Please accept my apologies for not knowing enough about UO.NET, but based
on errors I've seen on connections I believe it's just a PInvoke/wrapper
around UO.  Can someone confirm or deny that?  Thanks.

HTH
Tony Gravagno
Nebula Research and Development
TG@ removethisNebula-RnD.com
Disclosure: Nebula R&D is an authorized Distributor of mv.NET.


George Smith wrote:
>> Is it possible to work on uodotnet.UniDynArrays without
>> having a session object open? I have tried to manipulate
>> a uodotnet.UniDynArray, but when the session is closed,
>> it throws an error. 
> 
> I did not find any definitive answer. It would be in my
> opinion very beneficial to close the session object and
> then do some processing with the UniDynArrays.
> 
> Can anyone see why you should not be able to close the
> session and still work with the UnidynArrays. I do not
> think it has anything to do with COM as I was stepping
> thru C# code Visual Studio. I believe the docs say the
> the objects are all managed code. 
> 
> Thoughts ?
> 
> George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniVerse - file importation

2005-11-10 Thread Barry Rogen
Does anybody know of a good way (or program/utility)  to
import (translate as it were)  dBase IV  data   onto a  UniVerse
system.  We have a shipping package that uses dBase IV and I
would love to be able to utlize that data from UniVerse. As always,
any help is greatly appreciated.

 UV :10.0.19
   HPUX:   11.0


  Cheers,

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
[EMAIL PROTECTED]

-
Far better it is to dare mighty things, to win
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Debugger in SB+

2005-11-10 Thread Kevin King
TRACE.ON and TRACE.OFF can be useful, although they are arguably the
most annoying debugging tools.  I'm more of an EXEC 'EE' guy myself
for most of my debugging, especially with paragraphs. 

I also don't use logging, btw.

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Debster
Sent: Thursday, November 10, 2005 9:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Debugger in SB+

and correct me if I am wrong Kevin, oh Grand Poobah of SB+
secrets...

I always used the trace function in order to determine the process
flow and if needed coupled with imbedding display functions (with "if
user.id = " ) if needed to determine the exact value of a variable.

I know you can also use logging but I never had the need.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] AIX UPGRADE

2005-11-10 Thread Jeff Schoby
Not as such - we are running 6.0.0 just fine on aix 5.3.

You should probably upgrade to 6.1 anyway.  Our application vendor made
us aware of a potential file corruption problem on certain versions of
6.0:

"Our application vendor"  has found an issue with running GUIDE on
DYNAMIC files with UniData versions prior to 6.0.7.  If the files are
being accessed or written to while running the guide on the DYNAMIC
file, corruption may occur.



--
Jeff Schoby
Unix/Network Admin
City of Columbia, Missouri
573.874.6320


>>> [EMAIL PROTECTED] 11/10/05 9:57 AM >>>
Does AIX 5.3 require an upgrade to Unidata 6.1?  - We are currently at
6.0+

TIA



Dawn Janel Davis

DBA II

[EMAIL PROTECTED] 

410-386-8058



Carroll Community College

1601 Washington Road

Westminster, MD 21157
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Shell Dispatch Quoting

2005-11-10 Thread Mats Carlid

Thanks Charles,

I  jumped to using Your U routine and came up with two enhancements.

1)  Print a warning  when  the command supplied uses  all three of  \,' 
and " .

Can anyone dream up a way of handling it instead ?

2)  Add some hardcoded command aliases
  ( It's sooo irritating to shell out from uv to find that your
unix aliases don't work ! )

and in the spirit of open source  the enhanced program is here:



 CMD = TRIMF( @SENTENCE )[' ',2,999] 
 
 IF CMD = OCONV( CMD,'MCU') THEN CMD = OCONV( CMD,'MCL' )
 
 UC = CMD[' ',1,1]   
 **  Some aliases,  change and/or add Your own:
 BEGIN CASE  
 CASE UC = 'll'; CMD = '/usr/ucb/ls -ls ':CMD[' ',2,999]  
 CASE UC = 'ps'; CMD = '/usr/ucb/':CMD   
 END CASE
  
 
 IF INDEX(CMD,'"',1) THEN
IF INDEX(CMD,"'",1) THEN 
   IF INDEX(CMD,'\',1) THEN  
  CRT "Sorry, but you've used all quotes!"   
  END
   ELSE  
  CMD = '\':CMD:'\'  
  END
   END   
ELSE 
   CMD = SQUOTE(CMD) 
   END   
END  
 ELSE
CMD = DQUOTE(CMD)
END  
 
 EXECUTE "sh -c ":CMD
 
 STOP
 END 
- 
 

((  For the curious:  /usr/ucb is where the Berkely command versions are 
kept on solaris ))


-- mats

<<   Intentional overquoting  to faciliate comparisons.   >>



Stevenson, Charles wrote:


For working at TCL, typing SH -c and proper quote marks, too, is just
way too hard for me.
So I have a little utility verb, "U", that just takes everything after
the first word, and dispatches it.
Furthermore, if the entire line is Uppercase (the usual for TCL), then
it figures you probably meant Lowercase (the usual for Unix), so it
flips it before handing it to sh.

  U PWD; LS -L
  U ls -l \&SAVEDLISTS\& | grep "Nov  9"

get executed as

  SH -c"pwd; ls -l"
  SH -c'u ls -l \&SAVEDLISTS\& | grep "Nov  9"'

respectively.
If you insist on using all 3 (',", and \), you're on your own.

---

PROGRAM U
* Author: Charles Stevenson
* Date  : Jan. 1999
* Type  : General Utility verb
* Desc. : Shells to unix & executes what's on the command line.
* If entire command line is uppercase, converts everything to
* lowercase, first.
CMD = TRIMF( @SENTENCE )[' ',2,999]
IF CMD = OCONV( CMD, 'MCU' ) THEN CMD = OCONV( CMD, 'MCL' )
IF INDEX( CMD, '"', 1 ) THEN
 IF INDEX( CMD, "'", 1 ) THEN
   CMD = '\':CMD:'\'
 END ELSE
   CMD = SQUOTE( CMD )
 END
END ELSE
 CMD = DQUOTE( CMD )
END
EXECUTE 'SH -c':CMD 
STOP

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Debugger in SB+

2005-11-10 Thread Debster
and correct me if I am wrong Kevin, oh Grand Poobah of SB+ secrets...

I always used the trace function in order to determine the process flow and
if needed coupled with imbedding display functions (with "if user.id = " )
if needed to determine the exact value of a variable.

I know you can also use logging but I never had the need.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Kevin King
Sent: Thursday, November 10, 2005 9:35 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Debugger in SB+


Absolutely.  Check out my "Debugging Tips and Tricks for the SB+
Developer" online class on December 15th.
http://www.PrecisOnline.com/train.html.

And my apologies for the advertisement.

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr
Sent: Thursday, November 10, 2005 5:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Debugger in SB+

Does anybody know how to debug Processes in SB+

Thanks in advance
Bjorn Behr
Super Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/165 - Release Date:
11/9/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Unidata's .Net UniDynArray

2005-11-10 Thread George Smith
I ran into the following error last night and did a search on the
postings, Martin asked the following question. 

>Is it possible to work on uodotnet.UniDynArrays without having a
session
>object open?
>I have tried to manipulate a uodotnet.UniDynArray, but when the session
is
>closed, it throws an error.

I did not find any definitive answer. It would be in my opinion very
beneficial to close the session object and then do some processing with
the UniDynArrays.

Can anyone see why you should not be able to close the session and still
work with the UnidynArrays. I do not think it has anything to do with
COM as I was stepping thru C# code Visual Studio. I believe the docs say
the the objects are all managed code.
 
Thoughts ? 

George





Full posting is below.
==
Hi Martin

I am sure you don't need a database connection for the UniDynarray to
work.
You do need it if you use oconv/iconv as these need to work from the
server
variables.

However if there is a possibility that you do not expect to use other
databases that U2 in the future, you may have a licensing problem using
UniDynarray without purchasing U2 licenses.

Relation to COM/COM+, I always tell clients, that a UniVerse Basic
program
has been able to Run for 20 years on the mainframe, but their PC based
programs only have a shelf life of 3-5 years. Win16, Win 32, Win 64,
Dos,
NT, activex, com, com+, ...  

Regards

David Jordan

A late reply,  I was distracted by work.

David, I agree, the issue is with the way that .Net treats Com Objects.
What
a mess Microsoft did there to finish off the COM paradigm.  For years
COM
and COM+ was the holy grail of programming in the windows world and now
we
are expected to change completly into the .Net world of wonders.

In my current web based product I use the UniDynArray only as storage
container for the data.  I am independent from the database, in fact I
can
write the stringvalue of a DynArray into SQL server or any other
database.
That's why I can't deal with UODOTNET's UniDynArray.  Just to create it
I
need a database connection which I don't have.  jBase gave me a trial of
their mv.net product and I have to try it out.

Maybe I have to write my own class of a UniDynArray in .Net  using just
string operations.  A worthy project, but sure to take time and
dedication.

Martin Scholl


Hi Martin

I suspect the issue you are having is not with the dynamic array, but
that
you are using a com object within the .Net framework, which requires it
to
step out of the environment each time you make a call, ie each time you
update the dynamic array.  The issue is not with UniObjects, but COM in
.Net. You would resolve the problem going to IBM's U2 .Net interface as
going with jBase or Raining data's .Net product.


If you wish to stay with the com version, and it seems to be a batch
update,
you could put the update routine as a VB6 compiles routine and then pass
the
array to it to update as 1 com call.

Alternatively you could build the dynamic array manually by
concatenating
the strings with CHAR(254), etc and stay fully in the .Net frame work.

With .Net UniObj, I have opened a session, got data and closed the
session
and then used the dynamic array handling without issue, so you should
not
require a session to be open to use the dynamicarray facilities.


Regards
David Jordan



Is it possible to work on uodotnet.UniDynArrays without having a session
object open?

I have tried to manipulate a uodotnet.UniDynArray, but when the session
is
closed, it throws an error.
I have the nagging suspicion that UO.Net needs an open session to
execute
'Oconv', Iconv' etc on the server through a call.  I hope this is not
true.
It would make UO.Net pretty useless for stateless paradigms like web
programming.

Has anybody tried jBase's mv.Net?

Martin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] AIX UPGRADE

2005-11-10 Thread Davis, Dawn
Does AIX 5.3 require an upgrade to Unidata 6.1?  - We are currently at
6.0+

TIA



Dawn Janel Davis

DBA II

[EMAIL PROTECTED]

410-386-8058



Carroll Community College

1601 Washington Road

Westminster, MD 21157
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Debugger in SB+

2005-11-10 Thread u2ug

Bjorn,
You may want to sign up for the SB+ mailing list and see if they 
can help you. Instructions for signing up can be found below.


--

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

	Visit http://listserver.u2ug.org, 
	enter your e-mail address, 
	and 'browse all' lists to maintain your access.


For non-U2UG e-mail: [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Debugger in SB+

2005-11-10 Thread Kevin King
Absolutely.  Check out my "Debugging Tips and Tricks for the SB+
Developer" online class on December 15th.
http://www.PrecisOnline.com/train.html.

And my apologies for the advertisement.

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr
Sent: Thursday, November 10, 2005 5:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Debugger in SB+

Does anybody know how to debug Processes in SB+

Thanks in advance
Bjorn Behr
Super Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/165 - Release Date:
11/9/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Shell Dispatch Quoting

2005-11-10 Thread Don Kibbey
Thanks for sharing the U program.  Such a simple thing, so many ways to use it!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Debugger in SB+

2005-11-10 Thread Bjorn Behr
Does anybody know how to debug Processes in SB+

Thanks in advance
Bjorn Behr
Super Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/