[U2] BLAT with Outlook Calendar/Appointments

[Mark Johnson]

While this isn't a U2 or even an MV question, someone may have some guidance.

I've installed BLAT on a few MV clients systems with very favorable results. I
don't want to entertain any U2-specific email utilities or SENDMAIL unless all
other options are exhausted.

There's something in Outlook whereby a user can be in an appointment and
'send' that appointment to a recipient and it shows up in their calendar
program as an appointment. It may or may not show up as a regular email. But
it definitely shows up as an appointment.

My client uses Outlook at the manager's desk and the MV system can send
scheduled calls as emails to the sales and technical traveling people's
blackberrys. But they would like to deliver the appointments further to the
recipient's calendar.

I'm all ears.

Thanks in advance.
Mark johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [OT][U2] Wintegrate

[Mark Johnson]

In my post I suggested not focusing on cost alone.

So is there a fair comparison (like consumer reports) between Wintegrate and
Accuterm. I've used both and am pro-Accuterm and am finding some of my
colleagues dissing Accuterm 97 as that's as far as they got. Yes, I'm using
Wintegrate 98 but I don't know what their latest is either.

I can't imagine Accuterm 2K2 falling short on any comparison for any
features as Peter Schellenbach has impressed me tremendously with his
knowledge (or access to) MS internals and MV internals in his product.

Therefore, is there an unbiased review of the features of these 2 emulators.
And what about Procomm and/or Viaduct.

Thanks
Mark Johnson


- Original Message -
From: "Bill Haskett" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, December 14, 2006 6:29 PM
Subject: RE: [OT][U2] Wintegrate


> Mark:
>
> The usual rule for technologists is "we want what we want because someone
> else is paying for it".  The usual rule for business people is "we want
what
> works as long as it's cost effective (or cheap)".  :-)
>
> The cost difference isn't really fair for a side-by-side comparison of the
> benefits of the products.
>
> To me the cost is of paramount importance because whatever wIntegrate has
> that AccuTerm doesn't have can't possibly justify wIntegrate costing
$11,250
> for a 50 user operation vs $1,000 for AccuTerm when I'm paying for it.
It's
> like U2 costing $75,000 for a 100 user license while DB2 or SQL Server
costs
> $5,000 - $7,500 for an unlimited single CPU license.  It makes it hard to
> compete.
>
> Bill
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Thursday, December 14, 2006 2:45 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [OT][U2] Wintegrate
>
> I'm all ears. I've been using Wintegrate for 10 years (most recent is W98)
> and was Pro-Wintegrate up until 2 years ago when a client wanted to get
out
> from under VE-Client (that's another disaster).
>
> I wrote up my side of the story and another consultant posted his side
about
> Accuterm 2K2 (The latest). Side, by side things were equal until we got to
> WED, GED and, best of all (although no flames for being only price
> conscious), the price. IBM wanted $225 per seat for my client's 40 user
> system and Accuterm was $1,000 for 50 seats. The best IBM would do is a 5%
> discount.
>
> Considering the immense support that I've personally received from Peter
> Schellenbach and the wonderful features of Accuterm, compared to the stoic
> corporate stonewall from IBM it was more of a no brainer.
>
> Perhaps if you're remembering Accuterm only as a terminal emulator then
> that's not fair to accuterm. The WED program editor is the best I've seen
in
> my 3 decades of MV programming and the GED environment allows VB-looking
> forms to work directly with the MV database without any ODBC or other
> middleware. Plus, there's a whole boatload of VB-Scripting capabilities
that
> make every PC and network resource available to a MV program.
>
> As an emulator, accuterm can have multiple sessions in split windows,
bridge
> copy/paste between different systems, copy/paste to MS apps, detect PC
> elements like last window opened etc plus all the expected keyboard
mapping,
> emulations and other emulator stuff.
>
> For us programmers, WED is worth the price of admission by itself. Words
> cannot fully describe how wonderful editing MV programs with a notepad
> editor that understands MV concepts as compared to just using notepad.
>
> My 2 cents for Accuterm.
> Mark Johnson
>
> - Original Message -
> From: "Symeon Breen" <[EMAIL PROTECTED]>
> To: 
> Sent: Thursday, December 14, 2006 3:43 PM
> Subject: Re: [OT][U2] Wintegrate
>
>
> > No No No- Wintegrate wins against Accuterm any day .
> >
> > On 14/12/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> > >
> > > If you must get wintegrate, it should still be available from IBM.
> > >
> > > I would strongly go with Accuterm as it wins hands down on many
> > > comparisons.
> > > Unless your apps are married to wintegrate's gui components.
> > >
> > > Accuterm's GUI designer is huge. 2 of my clients have dictated that
all
> > > new
> > > programs are done with it and it works perfectly side by side in a
green
> > > screen environment.
> > >
> > > Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from
> IBM.
> > > You do the math.
> > >
> > > My 1,000 cents

Re: [OT][U2] Wintegrate

[Mark Johnson]

I'm all ears. I've been using Wintegrate for 10 years (most recent is W98)
and was Pro-Wintegrate up until 2 years ago when a client wanted to get out
from under VE-Client (that's another disaster).

I wrote up my side of the story and another consultant posted his side about
Accuterm 2K2 (The latest). Side, by side things were equal until we got to
WED, GED and, best of all (although no flames for being only price
conscious), the price. IBM wanted $225 per seat for my client's 40 user
system and Accuterm was $1,000 for 50 seats. The best IBM would do is a 5%
discount.

Considering the immense support that I've personally received from Peter
Schellenbach and the wonderful features of Accuterm, compared to the stoic
corporate stonewall from IBM it was more of a no brainer.

Perhaps if you're remembering Accuterm only as a terminal emulator then
that's not fair to accuterm. The WED program editor is the best I've seen in
my 3 decades of MV programming and the GED environment allows VB-looking
forms to work directly with the MV database without any ODBC or other
middleware. Plus, there's a whole boatload of VB-Scripting capabilities that
make every PC and network resource available to a MV program.

As an emulator, accuterm can have multiple sessions in split windows, bridge
copy/paste between different systems, copy/paste to MS apps, detect PC
elements like last window opened etc plus all the expected keyboard mapping,
emulations and other emulator stuff.

For us programmers, WED is worth the price of admission by itself. Words
cannot fully describe how wonderful editing MV programs with a notepad
editor that understands MV concepts as compared to just using notepad.

My 2 cents for Accuterm.
Mark Johnson

- Original Message -
From: "Symeon Breen" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, December 14, 2006 3:43 PM
Subject: Re: [OT][U2] Wintegrate


> No No No- Wintegrate wins against Accuterm any day .
>
> On 14/12/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> >
> > If you must get wintegrate, it should still be available from IBM.
> >
> > I would strongly go with Accuterm as it wins hands down on many
> > comparisons.
> > Unless your apps are married to wintegrate's gui components.
> >
> > Accuterm's GUI designer is huge. 2 of my clients have dictated that all
> > new
> > programs are done with it and it works perfectly side by side in a green
> > screen environment.
> >
> > Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from
IBM.
> > You do the math.
> >
> > My 1,000 cents
> > Mark Johnson
> > - Original Message -
> > From: "Nick Cipollina" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Wednesday, December 13, 2006 11:47 AM
> > Subject: [OT][U2] Wintegrate
> >
> >
> > > Does anyone know where I can get a copy of Wintegrate?
> > >
> > > Thanks,
> > >
> > > Nick Cipollina
> > >
> > > MCTS, MCP
> > > ACS Heritage, Inc.
> > > 2810 North Parham Road, Suite 210
> > > Richmond, VA 23294
> > > (804) 965-8294
> > > ---
> > > 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [OT][U2] Wintegrate

[Mark Johnson]

If you must get wintegrate, it should still be available from IBM.

I would strongly go with Accuterm as it wins hands down on many comparisons.
Unless your apps are married to wintegrate's gui components.

Accuterm's GUI designer is huge. 2 of my clients have dictated that all new
programs are done with it and it works perfectly side by side in a green
screen environment.

Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from IBM.
You do the math.

My 1,000 cents
Mark Johnson
- Original Message -
From: "Nick Cipollina" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, December 13, 2006 11:47 AM
Subject: [OT][U2] Wintegrate


> Does anyone know where I can get a copy of Wintegrate?
>
> Thanks,
>
> Nick Cipollina
>
> MCTS, MCP
> ACS Heritage, Inc.
> 2810 North Parham Road, Suite 210
> Richmond, VA 23294
> (804) 965-8294
> ---
> 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] Taxware

[Mark Johnson]

In the last 12 years I've lost a bunch of clients due to mergers or
'upgrades' to allegedly more modern systems.

With only one exception, each was a turn for the worse. The users bemoaned
the lack of features we have installed and while it looks 'pretty' with its
GUI interface, it is nice frosting on a very plain cake.

The fact that you're migrating over to an RPG system makes me laugh and cry
at the same time. I programmed with RPG in the mid 1970's before working for
Microdata then. You will sorely miss virtually everything that is missing on
that AS/400 system that is taken for granted on an MV system.

While many contempory IT people look down their noses at us MV people, RPG
is even worse than MV in this case. Today, these youngsters think RPG is
either Role Playing Game or Rocket Propelled Grenade and not Report Program
Generator.

If there's any shred of possibly having a fair trial for the death penalty
of your MV system, then I could offer a few real-world scenarios where the
MV system would have prevailed. Now I know that we're biased towards MV. But
to go to RPG is more Jurrasic than Pick is.

My 2 cents.
Mark Johnson

P.S. I have friends who still program in COBOL, Fortran, Pascal, IDA and
even BAL. And we're the ones criticized for keeping our technologies in the
past.
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, November 29, 2006 7:40 AM
Subject: Re: [U2] Taxware


> Mark,
>
> With all of the changes in Unidata (over the years) we have been able to
> due an awful lot with Shims.  Obviously, it no longer resembles the
> original version.  We interface to conveyor systems, built an EDI engine,
> web presence, Amazon integration, address correction software, external
> search engines, etc.  It really works well for us.  As a matter of fact,
> there is another local company, that I believe, is still using Shims as
> well.
>
> Unfortunately, every good thing comes to an end.  We were acquired by an
> entity that does not use Unidata.  Theoretically, over the next 6 months
> we will be assimilated to their AS/400 RPG 4 system.
>
> Oh, well.
>
> Vance
>
>
>
> "Mark Johnson" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 11/28/2006 11:07 PM
> Please respond to
> u2-users@listserver.u2ug.org
>
>
> To
> 
> cc
>
> Subject
> Re: [U2] Taxware
>
>
>
>
>
>
> I'll bite.
>
> How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago
> along
> with its step brother, RESULTS. Is it supported or detached like Results?
>
> Thanks
> Mark Johnson.
> ---
> 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] Taxware

[Mark Johnson]

I'll bite.

How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago along
with its step brother, RESULTS. Is it supported or detached like Results?

Thanks
Mark Johnson.
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, November 28, 2006 10:36 PM
Subject: Re: [U2] Taxware


> I integrated Taxware into our business system (Shims - Unidata 6.0).  We
> use the transactional approach for exemption certificates but have
> developed a c-wrapper (with the help of this list) for the realtime api
> for the tax calculations.
>
> We do not use the client side application for tax exemptions because it is
> far to limiting (have to download to a local pc and manually enter
> certificates).
>
> If you would like move information, please feel free to contact me
> offline.
>
> Vance
>
>
>
>
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
> 11/28/2006 04:03 PM
> Please respond to
> u2-users@listserver.u2ug.org
>
>
> To
> u2-users@listserver.u2ug.org
> cc
>
> Subject
> [U2] Taxware
>
>
>
>
>
>
> ok
>
> Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x
> and interact on a transactional or batch basis.  I saw Epicor listed as
> one of their partners --- so
>
> Anyone use "Taxware" (first data company)?
>
> Setup?
>
> How it interacts?
>
> Batch or transactional?
>
>
> Problems?
>
> Support raves/woes?
>
> --
> Debster
> ---
> 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] [UV] Question about EQU

[Mark Johnson]

I'm a little confused where dictionaries come into play with compiled versus
interpreted programs. I've worked on interpretive basic system and
dictionaries don't have anything to do with it.

Unless it's a 3rd form of programming, ie parameter driven.

Thanks
Mark Johnson
- Original Message -
From: "Debster" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, November 18, 2006 4:43 PM
Subject: RE: [U2] [UV] Question about EQU


> Wouldn't it then be that anything that is using compiled rather than
> interpretive is faster...
>
> i.e. Basic rather than dictionaries...
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Kevin King
> Sent: Saturday, November 18, 2006 1:06 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] Question about EQU
>
>
> David, I am interested in your opinions as to why, given that equates
> are compile time constructs, would have any impact at all on execution
> speed.  Understand, I am not contesting your premise, but rather would
> simply like more explanation to understand your perspective.
>
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.com
>
> ** Check out scheduled Connect! training courses at
> http://www.PrecisOnline.com/train.html.
> ---
> 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] [UV] Question about EQU

[Mark Johnson]

Let's not have a contest on bad programming techniques or we'll be here all
year.
Thanks.
- Original Message -
From: "Kevin King" <[EMAIL PROTECTED]>
To: 
Sent: Friday, November 17, 2006 8:45 PM
Subject: RE: [U2] [UV] Question about EQU


> >See how the EQU would never be "executed"?
> >Since it works, I assume the tokenizer reads
> >the whole program and picks up the equates,
> >but what I want to know is, is there some
> >reason for doing it this way, perhaps better
> >performance or less memory used?
>
> I would guess there is neither a performance nor memory reason but
> rather just an attempt at cleverness and/or obfuscation.  EQUs, being
> a compiler directive, simply update the symbol table for compilation
> so there is no additional memory being used and as those symbols are
> compiled to p-code there would likely be no performance implication.
> I would think it would necessitate a two pass compilation or deferred
> references to anything equated to avoid unassigned variables, and the
> fact that its lack of obviousness has prompted your question, I'm
> inclined to nominate such a coding practice as The Bad Idea of The
> Week.
>
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.com
>
> ** Check out scheduled Connect! training courses at
> http://www.PrecisOnline.com/train.html.
> ---
> 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] [UV] Question about EQU

[Mark Johnson]

About 20 years ago I saw a programmer use a similar method. Like your
observation, it seemed to work as they were Equated variables and not
available in the debugger.

This programmer also felt that the program would compile faster by having
all of the comment lines after the last logical END. Somehow he felt that
the miniscule time that the compiler spent not compiling a comment line
within the program was worth the time for another programmer (me) to
constantly have to print the commented section just to get the narrative on
the different code sections.

Your key word is 'inherit' as in a relic from the past. Don't tell anyone
outside of the MV community or we're doomed.

My 1 cent
Mark Johnson
- Original Message -
From: "Barry Brevik" <[EMAIL PROTECTED]>
To: "U2-users (E-mail)" 
Sent: Friday, November 17, 2006 8:11 PM
Subject: [U2] [UV] Question about EQU


> I inherited some code and I noticed that the programmer consistently
placed his equates outside of the program flow, in other words, the equates
would never be executed. Nevertheless, the DO get evaluated. For example:
>
> LABEL1:
>   FOR I = 1 TO 10
> PRINT 'HELLO WORLD'
>   NEXT
>   RETURN
>
> EQU THIS TO THAT, YIN TO YANG
>
> LABEL2:
>   I = 1
>   LOOP
> I += 1
>   WHILE I LE 10 REPEAT
>   RETURN
>
> See how the EQU would never be "executed"? Since it works, I assume the
tokenizer reads the whole program and picks up the equates, but what I want
to know is, is there some reason for doing it this way, perhaps better
performance or less memory used?
>
> Barry Brevik
> ---
> 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] [OT] goodbye to the list(s)

[Mark Johnson]

Sounds like fun. Again, good luck in the future.
Mark Johnson
- Original Message - 
From: "Claus Derlien" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, October 24, 2006 2:22 AM
Subject: RE: [U2] [OT] goodbye to the list(s)


> I started programming on a zx81 in 1981 bought in Hong Kong complete
> with tape recorder and 16 kb expansion pack for 650 hk $
> 
> I was a trainee on a huge maersk container ship - my plan was to be an
> engineer maintaining ship diesels
> but got hooked on computers, so i changed direction to computers, but
> now i go back to the basics :-)
> 
> For the record : as a motorman i will be maintaining all mechanical
> parts on the rig, as well as being man over board boat captain, and also
> take of the role as helicopter landing officer :-)
> 
> I will prolly continue to do fun programming on my laptop with UniVerse
> PE - one of the pleasures of being on an oil rig is the schedule : 2
> weeks offshore 3 weeks on shore at home :-)
> 
> 
> best regards from 'Soaking wet' denmark
> 
> Claus Derlien
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] 
> > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> > Sent: Monday, October 23, 2006 2:40 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] [OT] goodbye to the list(s)
> > 
> > Good luck. Sounds more exciting than sitting at a desk all day.
> > 
> > For the benefit of all, what was your movitation to convert 
> > to a really unrelated career? And what got you into 
> > programming in the first place.
> > 
> > Thanks
> > Mark Johnson
> ---
> 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] [OT] goodbye to the list(s)

[Mark Johnson]

Good luck. Sounds more exciting than sitting at a desk all day.

For the benefit of all, what was your movitation to convert to a really
unrelated career? And what got you into programming in the first place.

Thanks
Mark Johnson
- Original Message -
From: "Claus Derlien" <[EMAIL PROTECTED]>
To: 
Sent: Monday, October 23, 2006 7:59 AM
Subject: [U2] [OT] goodbye to the list(s)


> Alas it is my turn to shift focus - starting from next week i will no
> longer be a programmer, instead
> i will start a new career as a motorman onboard an oilrig in the
> northsea
>
> So i would just wish you all luck and prosperity in the u2 business..
>
> For the last time
>
> best regards from Denmark
>
> Claus Derlien
> programmer
> ---
> 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] Slow ascii output

[Mark Johnson]

Keep in mind that 16MB for 32 users is 250 times the memory available circa
late 1970s' with the Microdata Royale series.

There's something to be said for programming on an older system that gives
you respect for todays horsepower. I experience this first hand every other
week when visiting my Microdata client from my normal U2/D3 client base.
While you can't get really technically sophisticated as with the current
systems, you do become more effecient when programming within limits.
Perhaps the single thing I miss the most when programming on this old system
is the fact that I cannot use external subroutiness as freely as on every
other platform. I have a whole bunch of handy subs that I install on all of
my clients but have to convert them to INCLUDES if I want to use them there.
Microdatas don't like mixing RUN and cataloged programs together.

My 1 cent.
Mark Johnson


- Original Message -
From: "Anthony W. Youngman" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, October 21, 2006 6:29 PM
Subject: Re: [U2] Slow ascii output


> In message <[EMAIL PROTECTED]>,
> Claus Derlien <[EMAIL PROTECTED]> writes
> >no one and I mean NO ONE uses a system with 16 MB ram today!
> >
> >we have 65 users on 2 gig ram, and when we do payments of unemployment
> >salaries to our members we do everything in memory, and just write the
> >edi file to a record a large batch takes less than two minutes and it
> >also generates payment specifications for storage in pdf format (using
> >cross pdf package).
> >oh and we also do an xml conversion of the edi file on the fly aswell..
> >UniVerse is really a top performer when it comes to number crunching
> >and file management
> >how do you power a 16 meg system today ?? - with steam ?
>
> Note the use of the PAST tense. That machine is now salvage in my
> garage, waiting for me to restore it to personal use.
>
> I was just pointing out that MMV, and some things may work for some
> people and not for others. Why we were trying to run 32 users on 16 meg,
> even when the system was brand new (1990ish), I don't know.
> Penny-pinching, I guess.
>
> It's just that WRITESEQ makes a lot of sense when you're building BIG
> strings and are short of RAM...
> >
> >Med venlig hilsen
> >
> >Claus Derlien
> >programmxr
> >Edb-afdelingen
>
> Cheers,
> Wol
> >
> >> Our system was short of RAM - 16 meg for 32 users (PI/Open on
> >> an EXL 7330). It thrashed enough under normal load, even
> >> before you started to try and build large (and I mean LARGE)
> >> strings in BASIC...
> >>
> >> Cheers,
> >> Wol
> >> --
> >>
> >> Anthony W. Youngman <[EMAIL PROTECTED]> 'Yings, yow
> >> graley yin! Suz ae rikt dheu,' said the blue man, taking the
> >> thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said
> >> Nanny. The man lowered the thimble. 'Pictsies!' Carpe
> >> Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site -
> >> <http://www.maverick-dbms.org> Open Source Pick
> >> ---
> >> 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/
>
> --
> Anthony W. Youngman <[EMAIL PROTECTED]>
> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
> thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The
man
> lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
> Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source
Pick
> ---
> 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: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM & RM

[Mark Johnson]

I had such an occurrence where someone was creating an additional data-level
file on an existing dict/data file set. So he typed:

CREATE-FILE DATA EXISTINGFILE NEWDATALEVEL 1,1 1,1

assuming that the 1,1 pertained to the dict and the 1,1 applied to the
new datalevel that they were creating. The 1,1 was ignored

While D3 and native systems reply with the base and mod frame numbers of the
new file, it wasn't read by the programmer. But when the new datalevel file
was put into production, the client called in a few weeks as it got
hammered. There was some egg on the face of that programmer, especially
reviewing the TCL-STACK file (big brother) for the typed command.

FYI
Mark Johnson
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Thursday, October 19, 2006 11:51 AM
Subject: RE: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM &
RM


> Mark
>
>  >Today's numbers are downright staggering in the MV world.
>
> A couple of weeks ago I had to repair a failed RedBack implementation.
>
> The garbage collection wasn't running, and so their state file had grown
to being a mere 15,000 times undersized.
>
> Strangely enough, this eventually led to corruption and decay. But it must
have been running a long while before it did.
>
> and, yes, I left the tuning manual and garbage collection instructions on
the guy's desk.
>
> 
>
> Brian
> ---
> 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] VOCLIB and keeping VOC entries Short and Small, IM & R M

[Mark Johnson]

You're welcome.

In another magazine that I write for, I've been labeled "The Resident
Curmudgeon". I guess my age shows up not believeing (or wanting to believe)
things that others may get excited about.

Oddly enough I have a brother who writes HTML in Wordpad and despite my
suggestions, he's become pretty profecient with it. I guess the same can be
said for Jurrasic Pick programmers like myself who have lived 100 years in
ED BP ABC with the L22 editor. I now use WED from Accuterm and many on this
forum use other modern tools for managing these text files we call programs.
Some even use vi as their preferred editor.

Using programming tools like SB, GED and the other hamburger helper 4GL's,
we are spared from the tedious nature of the generic MV EDitor. On the other
hand, many people are still supporting and enhancing systems that were
written 10-25 years ago and one could wonder how they could write such
sophisticated applications with *only* the L22 editor. The average age of my
client's systems is 18 years.


I am enjoying using Accuterm with its GUI editor for making VB-looking forms
on top of the standard MV database and haven't been this excited about an MV
product since the creation of the EXECUTE command. Add their Windows Editor
WED and all of the connectivity stuff and sell it for $995 for 50 licenses
and it's a no brainer. All of my clients (except for those still on
Microdata) will be installing Accuterm and I will deliver happiness with the
GUI programs.


Thanks
Mark Johnson
- Original Message -
From: "Ron Sharcott" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, October 19, 2006 12:48 PM
Subject: RE: [U2] VOCLIB and keeping VOC entries Short and Small, IM & R M


> I enjoyed reading that and wanted to say thank you.
>
> Rapid Application Development (RAD) does not have to be sloppy and quick.
If
> slowed down a touch it can start to include a touch of quality. Often RAD
is
> taken to mean "just get it done" when really it means "roll it out when it
> can do the job" and "use prebuilt tools to do the job".
>
> Applications that assist RAD can be bloating if used without a watchful
eye.
> Editing HTML in Word is a prime example of that. At the same rate writing
> 100 pages of HTML using nothing but Notepad is a waste of time.
>
> Its all about balance.
>
> Thank you again.
>
>
> Ron Sharcott (3635)
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Thursday, October 19, 2006 7:50 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM & RM
>
>
> In observing this thread the words 'page size' caught my eye.
>
> In 1978 I remember a much older programmer working with me at Microdata
> (sic) reading very closely the Basic compiler output generated with the
MAP
> option. Microdata's compiler didn't (doesn't) generate the necessary file
> helpful with debugging programs automatically so you had to specify with
the
> (M option to generate it. It produced the variable table and laid out the
> basic code lines as they were spread out over the object code record.
>
> I recall him reviewing a FOR...NEXT loop that had the FOR part in one
frame
> and the NEXT part in another and he was spending time trying to put
> compilable code (not comments) in front of the FOR section in the hope
that
> the both the FOR and NEXT were in the same frame. This may have had the
> moniker "Frame Faulting". Mainframes called this a Core Dump.
>
> So he would code and compile and review, code and compile and review until
> he felt it was right.
>
> Perhaps his age at the time (50?) indicated a respect for the incredibly
> precious resources that he was used to and the disciplines that he had to
> adhere to. In the last 28 years of my MV programming I have never recalled
> having to be so anal as to perform such a lower-level observation for such
> an unmeasurable improvement. I could never count the number of times I
typed
> the word "BASIC"
>
> I don't advocate sloppy programming or poor file design techniques. But
with
> today's incredibly fast, fast, fast, fast and large, large, large systems,
I
> believe there is also an unmeasurable element to over analyzing the
> tweaking.
>
> While it's easy to take an academic approach to the micro-managing of each
> CPU cycle and disc read, at some time it just really doesn't matter.
Granted
> if you create a file with a mod of 1 and try to cram 10 MB into it, the
> system will accomodate this gross error and reward you with a slower file.
>
> But if the file was created with a mod of 1001 (sic) and it shoul

Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM & RM

[Mark Johnson]

I stand corrected. I've used (sic) for years and no-one has complained.
Perhaps they didn't know either.

I just don't want someone replying to a post because my editorial example
isn't technically correct, prime-wise. In this case, 3001 is prime but I
don't want to insure that all the other numbers are prime just for a
dissertation. It was for relative difference and an example only.

Thanks
Mark Johnson
- Original Message -
From: "Jeff Schasny" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, October 19, 2006 12:32 PM
Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM & RM


> Much as I hate to make editorial comments on a very nice writeup, I'd
> hate for you to go on misusing [sic].
>
>  From the wikipedia (and correct as far as I have always known):
>
> /*Sic*/ is a Latin  word meaning "thus", "so", or
> "just as that". In writing, it is italicized and placed within square
> brackets   [/sic/]  to indicate that an incorrect or
> unusual spelling, phrase, or other preceding quoted material is a
> verbatim <http://en.wiktionary.org/wiki/verbatim> reproduction of the
> quoted original and is not a transcription error.
>
> This may be used either to show that an uncommon or archaic usage is
> reported faithfully (for instance, quoting the U.S. Constitution
> , "The House of Representatives
>  shall chuse [/sic/] their Speaker...")
> or to highlight an error, often for the purpose of ridicule or irony
> (for instance, "Dan Quayle  famously changed a
> student's spelling to 'potatoe ' [/sic/]"), or otherwise,
> to quote accurately whilst maintaining the reputation of the person or
> organisation quoting its source.
>
> In folk etymology , "sic" is sometimes erroneously
> thought to be an abbreviation of "spelling is correct", "same in copy
> ", "spelled incorrectly", "spelling
> incompetent", "said in context", "stupid in context", "stand incorrect",
> or "spelling intentionally changed", to cite but a few backronyms
> .
>
>
>
> Mark Johnson wrote:
> > But if the file was created with a mod of 1001 (sic) and it should have
been
> > 1401 (sic), how measurably different is the delay with the 40%
undersized
> > file of 1001? (PS for those who don't know, (sic) means example. Don't
reply
> > with lessons on prime numbers. It's just an example).
> >
> [large amounts of stuff trimmed]
>
> --
> ==
>  Jeff Schasny
>  jschasnyATricochetDOTcom
> ==
> ---
> 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] VOCLIB and keeping VOC entries Short and Small, IM & RM

[Mark Johnson]

In observing this thread the words 'page size' caught my eye.

In 1978 I remember a much older programmer working with me at Microdata
(sic) reading very closely the Basic compiler output generated with the MAP
option. Microdata's compiler didn't (doesn't) generate the necessary file
helpful with debugging programs automatically so you had to specify with the
(M option to generate it. It produced the variable table and laid out the
basic code lines as they were spread out over the object code record.

I recall him reviewing a FOR...NEXT loop that had the FOR part in one frame
and the NEXT part in another and he was spending time trying to put
compilable code (not comments) in front of the FOR section in the hope that
the both the FOR and NEXT were in the same frame. This may have had the
moniker "Frame Faulting". Mainframes called this a Core Dump.

So he would code and compile and review, code and compile and review until
he felt it was right.

Perhaps his age at the time (50?) indicated a respect for the incredibly
precious resources that he was used to and the disciplines that he had to
adhere to. In the last 28 years of my MV programming I have never recalled
having to be so anal as to perform such a lower-level observation for such
an unmeasurable improvement. I could never count the number of times I typed
the word "BASIC"

I don't advocate sloppy programming or poor file design techniques. But with
today's incredibly fast, fast, fast, fast and large, large, large systems, I
believe there is also an unmeasurable element to over analyzing the
tweaking.

While it's easy to take an academic approach to the micro-managing of each
CPU cycle and disc read, at some time it just really doesn't matter. Granted
if you create a file with a mod of 1 and try to cram 10 MB into it, the
system will accomodate this gross error and reward you with a slower file.

But if the file was created with a mod of 1001 (sic) and it should have been
1401 (sic), how measurably different is the delay with the 40% undersized
file of 1001? (PS for those who don't know, (sic) means example. Don't reply
with lessons on prime numbers. It's just an example).

I tried this years ago on a single user system (multiple user systems are
much harder to truly measure with the other user's affect). IIRC I had a
file that needed a 3001 (sic) modulo and I loaded it from tape into
different file sizes ranging from 11, 101, the calculated 3001 and even
15001. I performed some crude timing tests, ie sorting, read/re-write etc
and came away with the impression that it really doesn't matter unless it's
tremendously undersized. The 11 size file was the poorest but the 101, 501
and 15001 were suprisingly close to the 'preferred' 3001. IIRC even having
some non-prime modulos near 3001 and it didn't matter either.

I haven't tried this test recently but I can imagine that the results would
be quicker but the shot-group would be the same if not tighter. I don't know
about U2 systems, but D3 systems have long dropped the separation value in
creating files with the assumption of '1'. That closes that chapter on file
calculations.

I can't imagine justifying the process to analyze and re-analyze this today.
Perhaps I'm wrong and someone managing a 10,000 user system will babble
about every precious CPU. But for the rest of us it is an entertaining
distraction that would be hard to cost-justify. We don't have a 10 MB hard
drive system supporting 16 users with 32K of core memory anymore. Today's
numbers are downright staggering in the MV world.

My 101,1 cents
Mark Johnson

- Original Message -
From: "Anthony W. Youngman" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, October 18, 2006 5:06 AM
Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM & RM


> In message
> <[EMAIL PROTECTED]>, Adrian
> Merrall <[EMAIL PROTECTED]> writes
> >> And on, and on, until the particular bit of data is found.
> >> So... (this being one of the overwhelmingly elegant things about the
> >> Pickuverse) this means that in a properly sized hashed file NO MATTER
> >> HOW BIG it only takes one disk read to get to any record given a known
> >> key. Ask your local Oracle/Sybase/Informix/SQL Server DBA if they can
do
> >> that. Stand back though, they tend to sputter alot.
> >
> >But won't this only work if your data fits into the modulo that
> >matches your page size?  If your data is lumpy and doesn't nicely fit
> >into the page size/file modulo selected you get level 1overflow and
> >more disk IO.
> >
> The stats I've come across (yes, they're old, they came from Prime) say
> that PROVIDED Adrian's "properly sized" caveat is followed, even when

Re: RE: [U2] Roman Numerals

[Mark Johnson]

I recall this in the D3 manual and wondered why would anyone have such a
thing.

A=123
PRINT OCONV(A,"U0033")

yields CXXIII

I guess it was for incrementing chapters or some other formal/outline number
sequences. I don't know what the maximum number is but OCONV("25000","U0033)
yields M. 50,000 and 100,000 didn't work.

My XIV cents.
Mark Johnson




- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Thursday, October 19, 2006 4:25 AM
Subject: RE: RE: [U2] Roman Numerals


> The Chinese Year has always been wrong, since it is still assumes 01 Jan
as the start day of the year. I think I reported that to VMARK about 20
years ago...
>
> Brian
>
> >David A. Green wrote:
> >>> Does any one have a Digit to Roman Numeral converter they would like
> >>> to share?
> >
> >Ron White responded:
> >> How about ICONV/OCONV with the NR function code.  Look in the
> >> Basic Reference Manual index for roman numerals.
> >
> >A search on CDP reveals a couple interesting tidbits on this.
> >
> >According to Oliver Elphick, the NR conversion in Universe "uses a change
> >of alphabetic case to represent multiplication by 1000, so v=5 but
V=5000."
> >
> >According to Tom Rauschenbach, [sic] "the author of the NR conversion
> >(someone named Hal) says
> >that there was a reason for the upper/lower case distinction, but he
can't
> >remember what it was.  He also claims that the Chinese New Year is
wrong."
> >(I have no idea what that means.)
> >
> >The D3 equivalent (as if anyone here cares) is the user exit U33.
> >And the Reality equivalent is conversion MCDR.
> >R83 had conversion MCR.
> >
> >So many standards, so little time...
> >T
> >---
> >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] VOCLIB and keeping VOC entries Short and Small

[Mark Johnson]

Steve's suggestions are right on the money and have been for the past 30
years.

Virtually every one of my client's system, regardless of flavor, has had
this form of clutter. Oftentimes it's just as simple as copying the VOC item
to the VOCLIB (MD to PROCLIB etc) and changing the VOC item to reference the
VOCLIB item.

The VOC (MD) is rarely SELECTED but since all new items added to the VOC are
appended to the group, the 'lumpy' effect may make certain items appear
'slower'.

My 1 cent.
- Original Message -
From: "Stephen O'Neal" <[EMAIL PROTECTED]>
To: 
Sent: Sunday, October 15, 2006 5:30 PM
Subject: [U2] VOCLIB and keeping VOC entries Short and Small


> The intent of VOCLIB is to reduce the VOC size.  One idea for speed is to
> keep your VOC very small.  This way the search for all items is faster.
>
> For some VOC items, like 'PA'ragrpahs and 'PR'ocs can be sizable (like
> 1,000's of characters).  This causes "Lumpy" records.  (To be shocked,
> sometime LIST VOC SIZE.)
>
> So, the intent was for people to make 'R'emote pointers and to put the
> larger sized items in the VOCLIB.
>
> Yes, if you do this, your system will run faster.
>
> Example:
>
> ED VOC LARGE.PARAGRAPH
> 1) R
> 2) VOCLIB
> 3) LARGE.PARAGRAPH
>
> ED VOCLIB LARGE.PARAGRAPH
> 1) PA Some really large description of the paragraph
> 2) SELECT
> 3) LIST...
>
> While you are at it, you should check your VOC for overflow, which will
> also slow down your system.
>
> For your education,
>Steve
>
>Stephen M. O'Neal
>Lab Services Sales for U2
>IBM SWG Information Management Lab Services
>
>
>
>
> "Anthony W. Youngman" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 10/15/2006 01:17 PM
> Please respond to
> u2-users@listserver.u2ug.org
>
>
> To
> u2-users@listserver.u2ug.org
> cc
>
> Subject
> Re: [U2][UV] UO.NET Help
>
>
>
>
>
>
> In message
> <[EMAIL PROTECTED]>, Nick
> Cipollina <[EMAIL PROTECTED]> writes
> >Paul,
> >
> >Thank you very much.  Turns out we were missing the VOCLIB file.  This
> >is a very useful piece of information.  Is this documented anywhere?
> >
> >Thanks,
> >
> >Nick Cipollina
> >
> I've got a feeling VOCLIB isn't created automatically. It's a Pr1me-ism,
> and doesn't contain anything by default, I don't think, so it's odd that
> it's required.
>
> That said, I've never seen an INFORMATION account without it, and I
> think the ODBC stuff originally came from Prime, so it's probably a
> historic hangover.
>
> Cheers,
> Wol
> --
> Anthony W. Youngman <[EMAIL PROTECTED]>
> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
> thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The
> man
> lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
> Visit the MaVerick web-site -  Open Source
> Pick
> ---
> 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][UD] UniQuery SELECT WITH Limits

[Mark Johnson]

Just because I respect the past and can recognize the perpetual changing of
the 'state of the art' doesn't mean I live in the past.

Your comments are unwelcome, short-sighted and clearly illustrate a complete
lack of knowledge of what I know and where I've been. I praised "F"
correlatives in the past tense and they were certainly an incredible asset
in their time when compared to the prevailing databases. What we could
accomplish in a single, albeit cryptic, line of code took other systems a
whole lot more lines of code and other very expensive resources.

The very fact that you don't have to endure F correlatives today is a
tribute to their help in building up the overall Pick/MV marketplace that
you currently enjoy. Without them, Pick would have been just another
VSAM/ISAM or other flat, processor heavy database and English (sic) would
never have grown to be the powerful tool it is. Everytime, and I mean every
time you are at TCL and type an English query you should thank F
correlatives.

My present client base includes MV systems all the way from early 1980's-era
Microdatas all the way to U2, D3, Mvbase and a bunch in between, not to
mention many non-MV technologies. My duration in the MV world allows me to
comment with first-hand experience on possibly the full extent of its time
period and all of its milestones..

Thanks for your comments and I will continue to defend the F correlative for
its contributions.

Mark Johnson
- Original Message -
From: "Bruce Nichol" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, October 12, 2006 11:13 PM
Subject: Re: [U2][UD] UniQuery SELECT WITH Limits


> At 08:30 26/09/06 -0400, you wrote:
>
> >Don't pick on the F correlatives as they were the state of the art back
then
> >and got us where we are today.
>
> And so were valve radios and kerosene fridges.Whilst there is a
> resurgence of valve amplifiers for audiophiles  the rest of us great
> unwashed  can do without either having them or knowing anything about
> them especially when there is a progression path.
>
> Catch up with the rest of the world.Your customer will ultimately
thank
> you unless you want to go down in history as the last person defending
> F-correlatives. There really are times when the tripe still propounded
> for vanilla Pick is just not the answer in U2..
>
>
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURYNSW 2640
> Australia
>
> http://www.taloncs.com.au
>
> Tel: +61 (0)411149636
> Fax: +61 (0)260232119
>
> If it ain't broke, fix it till it is!
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06
16:15
> ---
> 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] Command that is the opposite of MATPARSE.

[Mark Johnson]

Does that eliminate MATBUILD?
- Original Message -
From: "Dave Walker" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, October 03, 2006 8:39 AM
Subject: RE: [U2] Command that is the opposite of MATPARSE.


> They work in Unidata...
>
> --
> Dave Walker
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
> Sent: Monday, October 02, 2006 8:35 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Command that is the opposite of MATPARSE.
>
>
> Mark:
>
> I don't believe this works in the U2 products.  All those little niceties
of
> D3 are not considered essential in U2.  :-)
>
> Bill
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Monday, October 02, 2006 4:14 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Command that is the opposite of MATPARSE.
>
> I don't know if this would work on U2 but as I was trying to remember this
> for D3, I simply equated them as such:
>
> DIM A(100)
> MATREAD A FROM FILE, ID ELSE STOP
> B=A
> PRINT A(49), B<49>
>
> My .001 cents.
> Mark Johnson
>
> - Original Message -
> From: "Kevin King" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, October 02, 2006 6:53 PM
> Subject: RE: [U2] Command that is the opposite of MATPARSE.
>
> > >Just curious - Does anyone know if there is a command/function
> > >that will do just the opposite (of MATPARSE)?
> >
> > MATBUILD
> >
> > -Kevin
> > [EMAIL PROTECTED]
> > http://www.PrecisOnline.com
> ---
> 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] Command that is the opposite of MATPARSE.

[Mark Johnson]

I don't know if this would work on U2 but as I was trying to remember this
for D3, I simply equated them as such:

DIM A(100)
MATREAD A FROM FILE, ID ELSE STOP
B=A
PRINT A(49), B<49>

My .001 cents.
Mark Johnson
- Original Message -
From: "Kevin King" <[EMAIL PROTECTED]>
To: 
Sent: Monday, October 02, 2006 6:53 PM
Subject: RE: [U2] Command that is the opposite of MATPARSE.


> >Just curious - Does anyone know if there is a command/function
> >that will do just the opposite (of MATPARSE)?
>
> MATBUILD
>
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.com
>
> ** Check out scheduled Connect! training courses at
> http://www.PrecisOnline.com/train.html.
> ---
> 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][UD] UniQuery SELECT WITH Limits

[Mark Johnson]

Don't pick on the F correlatives as they were the state of the art back then
and got us where we are today.

Klugy? Yes, Effective? Yes.

Anyone with an HP Calculator can appreciate the RPN (Reverse Polish
Notation) power of that stack-oriented processor, the F Correlative.

Am I showing my age?
Mark Johnson

P.S. I'm consolidating an article on the history of databases and would
welcome any pros/cons on the earlier PC-oriented databases including regular
Apple computers, all MS databases as well as non-PC databases, like those
for mini-computers and mainframes.

Thanks.
- Original Message -
From: "Bill Haskett" <[EMAIL PROTECTED]>
To: 
Sent: Monday, September 25, 2006 9:48 PM
Subject: RE: [U2][UD] UniQuery SELECT WITH Limits


> Charles:
>
> And some complain about the obtuse nature of "F" correlatives.  :-)
>
> Bill
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
> Sent: Monday, September 25, 2006 4:22 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2][UD] UniQuery SELECT WITH Limits
>
> Don't know about UD limits.  Here's a workaround:
>
> Write a control record with the 251 different numbers that you are
> searching for.
> Then
>SELECT file WITH EVAL "SUBR( '!EQS', TRANS( controlfile, controlid,
> -1, 'X' ), REUSE( field.in.question ))" = "1"
>
> Something close to that, anyway.
> It loops through the entire file once (the expensive part), and does 251
> comparisons for each record (not so sepenseive).
>
> cds
> ---
> 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][UD] UniQuery SELECT WITH Limits

[Mark Johnson]

I have another thought on this many WITH's.

As a filter (I'm sure it's pretty much all AND's as mixing AND's and OR's
tends to be misleading), and you're wanting a single list, perhaps just
write a program to go through the file and challenge everything
sequentially. If it passes all of the 200 or so tests, retain the item-id
either in a local variable or writing to a temp file. As soon as it fails on
any test go to the next item-id.

Then either WRITELIST the local variable or SELECT the temp file to get your
list of quailfied records.

My 2 cents
Mark Johnson

P.S. Something tells me that your current TCL SELECT statement isn't
generated by hand or run in a PROC and that it's being created by a
data/basic program. Thus, by the time you assemble the TCL statement, you
could be testing the records.

- Original Message -
From: "Richard Brown" <[EMAIL PROTECTED]>
To: 
Sent: Monday, September 25, 2006 7:04 PM
Subject: Re: [U2][UD] UniQuery SELECT WITH Limits


> A couple of thoughts.  If you do
>
> SELECT FILENAME WITH FIELD = "123""456""479"
>
> does that count as multiple WITHs?
>
> You could setup a dict item that looks at a certain position in the field
> then select on that.
> D3UD/U2
> FIELD.NAMEFIELD.NAME
> 1 A 1 I
> 2 0  2 @ID[3,1]
> 3 3
> 4 4
> 5 5 1L
> 6 6 S
> 7
> 8 T3,1
> R
> 1
>
> SELECT FILENAME WITH FIELD.NAME = "1"
>
> Will get all the items that have a 1 in the 3rd position of the ID
>
>
> - Original Message -
> From: "jjuser ud2" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, September 25, 2006 3:21 PM
> Subject: [U2][UD] UniQuery SELECT WITH Limits
>
>
> > Hi hello how are ya :)
> >
> > Limits.  The documentation I have for "Using UniQuery" says that you
> > can only have 120 different "with" fields in a SELECT statement.  I'm
> > trying to select a series of non-contiguous numbers at random
> > intervals to generate a select list.  There are 251 of these numbers.
> > Do I have to split the list into three different groups in order to
> > generate three different lists that I can do a SAVE.LIST on?  What's
> > the best way to go about getting these select lists?
> >
> > When I execute the LIMIT command in UniData, it tells me:
> >
> > U_MAXFNAME:  File name limit =   198.
> > U_NAMESZ:Record id(key) size =   126.
> > U_SELEMAX:   Number of select list = 10.
> > U_MAXDATA:   Number of DATA statement =  500.
> > U_HEADSZ:HEADER/FOOTER length =  2120.
> > U_MAXHASHTYPES: Number of hash functions =   3.
> > U_MAXSORT:   Number of sort fields(BY...) in LIST =  20.
> > U_MAXWITH:   WITH stack size =   256.
> > U_MAXWHEN:   WHEN stack size =   60.
> > U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54.
> > U_MAXBREAK:  Number of BREAK.ON+BREAK.SUP in LIST =  15.
> > U_MAXLIST:   Number of attribute names in LIST = 999.
> > U_LINESZ:Page width in printing =272.
> > U_PARASIZE:  Paragraph name and its parameter size = 256.
> > U_LPCMD: System spooler name =   NT Spooler.
> > U_MAXPROMPT: Number of prompts allowed in paragraph =  60.
> > U_FSIZE: Dictionary field name size =31.
> > U_MAXVALUE:  Number of values WHEN can handle =  10240.
> > U_MAXBYEXPVAL:  Number of values BY.EXP can handle =  10240.
> > U_SENTLEN:   Maximum sentence length =   9247.
> > U_PROCBUFSZ:  Proc buffer size = 4095.
> > U_NIDES: Maximum number of virtual fields in query=  256.
> >
> > Thanks! :)
> > ---
> > 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][UD] UniQuery SELECT WITH Limits

[Mark Johnson]

I'm curious as well with so many WITH's. Please entertain us with the
specifics of your query.

Performance wise, this offers the following question. If the first WITH
fails and it's a bunch of ANDed WITH's, does the system continue to gather
the other pass/fails despite the first failing and the rest are moot.

I've streamlined many queries by dividing and conquering. Especially if some
of the fields are heavier than the others, ie correlatives or translates.
Not to mention any indexed fields.

Thanks
Mark Johnson
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Monday, September 25, 2006 4:45 PM
Subject: Re: [U2][UD] UniQuery SELECT WITH Limits


> Not to second guess, but anytime someone says something about hitting one
> of the limits, I have to think there is a better way of doing what you
> want to do.
>
> Why don't you give us a little more detail as to what you are trying to
> do?
>
> Bruce M Neylon
> Health Care Management Group
>
>
>
>
> "jjuser ud2" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 09/25/2006 03:21 PM
> Please respond to
> u2-users@listserver.u2ug.org
>
>
> To
> u2-users@listserver.u2ug.org
> cc
>
> Subject
> [U2][UD] UniQuery SELECT WITH Limits
>
>
>
>
>
>
> Hi hello how are ya :)
>
> Limits.  The documentation I have for "Using UniQuery" says that you
> can only have 120 different "with" fields in a SELECT statement.  I'm
> trying to select a series of non-contiguous numbers at random
> intervals to generate a select list.  There are 251 of these numbers.
> Do I have to split the list into three different groups in order to
> generate three different lists that I can do a SAVE.LIST on?  What's
> the best way to go about getting these select lists?
> ---
> 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] [UV] TEXT box subroutine

[Mark Johnson]

Just sharing a nice feature of Accuterm.
Good Luck
Mark Johnson
- Original Message - 
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Monday, September 18, 2006 11:37 AM
Subject: RE: [U2] [UV] TEXT box subroutine


> Thanks, Mark, but changing term emulator software is not an option. This
> needs to work in Dynamic Connect.
> 
> BobW
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Sunday, September 17, 2006 9:20 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [UV] TEXT box subroutine
> 
> Accuterm has a TXTBOX subroutine that can be immediately added anywhere
> from
> within any green screen program for the desired answer.
> 
> I didn't look specifically, but I'm guessing that it has a multi-line
> counterpart.
> 
> Thanks.
> ---
> 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] [UV] TEXT box subroutine

[Mark Johnson]

No subs within Dynamic Correct? Is that correct?

Gee, where do I sign up<\sarcasim>


- Original Message -
From: "Bruce Nichol" <[EMAIL PROTECTED]>
To: 
Sent: Friday, September 15, 2006 7:14 PM
Subject: RE: [U2] [UV] TEXT box subroutine


> At 16:56 15/09/06 -0500, you wrote:
>
> >In the past, I have integrated applications with a text box using
wIntegrate
> >subroutine calls and have been very successful with that technique.
>
> You may well have done, but the OP is "Dynamically Connected", and IIRC,
> stuck there.Dynamic Connect is, unfortunately, a cut-down version of
> wIntegrate, and AFAICR, does not support subroutine calls..   But I
> could be proven w..www...ww.wwwrong.   There!
>
>
>
>
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURYNSW 2640
> Australia
>
> http://www.taloncs.com.au
>
> Tel: +61 (0)411149636
> Fax: +61 (0)260232119
>
> If it ain't broke, fix it till it is!
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.406 / Virus Database: 268.12.4/449 - Release Date: 15/09/06
> ---
> 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] [UV] TEXT box subroutine

[Mark Johnson]

Here goes.

Accuterm is incredibly affordable. $1,000 for 50 licenses. That's great to
begin with.

Second, for us programmers: WED is a great editor marrying the MS feel of
Notepad with a MV-oriented editor. Indenting, multi-windows, cut & paste,
label finding, color coding, opening subordinate programs etc.

Third, GED (the GUI designer) creates regular mv subroutines that can be
incorporated in an existing green screen apps and menus.

2 of my clients mandate new development in GED and to back-develop existing
programs when time is available.

IIRC, there is no magic pill to convert a green screen app to a gui app. Key
word is CONVERT instead of re-write. The ability to manage a multi-year
transition with GED/green screens is very appealing to end user environments
instead of VAR environments.

My 2 cents.
Mark Johnson
- Original Message -
From: "IT-Laure Hansen" <[EMAIL PROTECTED]>
To: 
Sent: Friday, September 15, 2006 4:59 PM
Subject: RE: [U2] [UV] TEXT box subroutine


> I would really like it if all parties could give arguments to support
> their opinion of it: is it solid? Satisfying to the users? Supported or
> not on certain platforms? Working best or worst with certain types of
> programs? etc. I would help me and hopefully others cut through some
> time and efforts.
>
> Thanks in advance.
>
> Laure Hansen,
> City of Redwood City
> Information Technology
> www.redwoodcity.org
> 1017 Middlefield Road
> Redwood City, CA 94063
> Tel: 650-780-7087
> Fax: 650-556-9204
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman
> Sent: Friday, September 15, 2006 12:29 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [UV] TEXT box subroutine
>
>
> Wow, it's really something to say it's a "horrible tool for gui" without
>
> any explanation!  We LOVE LOVE LOVE the Accuterm gui and switched our
> development from OpenInsight to Accuterm and have had nothing but
> success! -Dianne
>
> [EMAIL PROTECTED] wrote:
>
> >Accuterm, as we have found it, is a horrible tool for gui.  You should
> >have check out OpenInsight.  Real windows tool.
> >
> >But then eveyone has their favorites.
> >
> >DSig
> >David Tod Sigafoos
> >SigsSolutions, Inc.
> >
> >
> >
> >
> >> Original Message 
> >>Subject: Re: [U2] [UV] TEXT box subroutine
> >>From: "Martin Phillips" <[EMAIL PROTECTED]>
> >>Date: Thu, September 14, 2006 9:32 am
> >>To: 
> >>
> >>Hi Bob,
> >>
> >>Have you looked at AccuTerm as an alternative to Dynamic Connect. The
> >>associated GUI library is amazing. We were recently involved in
> >>conversion of a UniVerse application from character mode to GUI mode
> >>complete with mouse support and the major parts of the job took two
> >>people less than three days.
> >>
> >>
> >>Martin Phillips
> >>Ladybridge Systems
> >>17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> >>+44-(0)1604-709200
> ---
> 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] [UV] TEXT box subroutine

[Mark Johnson]

Accuterm has a TXTBOX subroutine that can be immediately added anywhere from
within any green screen program for the desired answer.

I didn't look specifically, but I'm guessing that it has a multi-line
counterpart.

Thanks.

- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Friday, September 15, 2006 4:46 PM
Subject: RE: [U2] [UV] TEXT box subroutine


> I wasn't implying I was looking for a gui tool.  Maybe I phrased it
> wrong.  What I'm trying to accomplish is a green screen solution where
> I'd be more than happy to re-display my underlying form and data after
> I've allowed the user to modify a lengthy description field.  My intent
> is to only display the first couple of lines but when the user wants to
> edit that description, I display a "box" that they can move up and down,
> left and right, insert and delete then either save the changes or reset
> back to the original contents of the field.
>
> The solutions I've been given, thus far, all look promising.  I'm
> currently checking each to see how I could customize them to what my
> specific needs are.
>
> Again, thanks to everyone on the list!
>
> BobW
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman
> Sent: Friday, September 15, 2006 12:29 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [UV] TEXT box subroutine
>
> Wow, it's really something to say it's a "horrible tool for gui" without
>
> any explanation!  We LOVE LOVE LOVE the Accuterm gui and switched our
> development from OpenInsight to Accuterm and have had nothing but
> success!
> -Dianne
>
> [EMAIL PROTECTED] wrote:
>
> >Accuterm, as we have found it, is a horrible tool for gui.  You should
> >have check out OpenInsight.  Real windows tool.
> >
> >But then eveyone has their favorites.
> >
> >DSig
> >David Tod Sigafoos
> >SigsSolutions, Inc.
> >
> >
> >
> >
> >> Original Message 
> >>Subject: Re: [U2] [UV] TEXT box subroutine
> >>From: "Martin Phillips" <[EMAIL PROTECTED]>
> >>Date: Thu, September 14, 2006 9:32 am
> >>To: 
> >>
> >>Hi Bob,
> >>
> >>Have you looked at AccuTerm as an alternative to Dynamic Connect. The
> >>associated GUI library is amazing. We were recently involved in
> conversion
> >>of a UniVerse application from character mode to GUI mode complete
> with
> >>mouse support and the major parts of the job took two people less than
> three
> >>days.
> >>
> >>
> >>Martin Phillips
> >>Ladybridge Systems
> >>17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> >>+44-(0)1604-709200
> ---
> 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] [UV] TEXT box subroutine

[Mark Johnson]

I'm interested in hearing why accuterm is so bad and why Openinsight is
preferred.

One of the consultants I work with uses both and prefers accuterm. I'm
liking accuterm the more I use it for GUI and have presently concluded that
OI is a database instead of a front end/emulator. It's easier to implement a
new emulator like accuterm with its features than a new database conversion.

Thanks
Mark Johnson
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Friday, September 15, 2006 9:36 AM
Subject: RE: [U2] [UV] TEXT box subroutine


> Accuterm, as we have found it, is a horrible tool for gui.  You should
> have check out OpenInsight.  Real windows tool.
>
> But then eveyone has their favorites.
>
> DSig
> David Tod Sigafoos
> SigsSolutions, Inc.
>
>
> >  Original Message 
> > Subject: Re: [U2] [UV] TEXT box subroutine
> > From: "Martin Phillips" <[EMAIL PROTECTED]>
> > Date: Thu, September 14, 2006 9:32 am
> > To: 
> >
> > Hi Bob,
> >
> > Have you looked at AccuTerm as an alternative to Dynamic Connect. The
> > associated GUI library is amazing. We were recently involved in
conversion
> > of a UniVerse application from character mode to GUI mode complete with
> > mouse support and the major parts of the job took two people less than
three
> > days.
> >
> >
> > Martin Phillips
> > Ladybridge Systems
> > 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> > +44-(0)1604-709200
> > ---
> > 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] [UV] TEXT box subroutine

[Mark Johnson]

GED is a great program.

2 of my clients have dictated that all new development is in GED. It's a
wonderful marriage between VB forms and our beloved pick database.

Plus, Peter Schellenbach should get some form of Nobel Peace Prize for WED
as well.

My 1 cent.
Mark Johnson
- Original Message -
From: "Martin Phillips" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, September 14, 2006 12:32 PM
Subject: Re: [U2] [UV] TEXT box subroutine


> Hi Bob,
>
> Have you looked at AccuTerm as an alternative to Dynamic Connect. The
> associated GUI library is amazing. We were recently involved in conversion
> of a UniVerse application from character mode to GUI mode complete with
> mouse support and the major parts of the job took two people less than
three
> days.
>
>
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
> ---
> 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] Any have a Sun Sparc Box

[Mark Johnson]

Look up Bob Wyatt from Sun/Unidata. He knows virtually everything about that
implementation.

- Original Message -
From: "george r smith" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, September 14, 2006 12:04 PM
Subject: [U2] Any have a Sun Sparc Box


> All,
>
> Anyone have any experience with Sun Sparc boxes as development boxes for
> Unidata.
>
> Anyone heard if IBM might certify Unidata on the Solaris AMD boxes.
>
> thanks
> grs
> ---
> 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] Time/Date as a single number

[Mark Johnson]

I worked on a Security Monitoring system for years and the best date/time
schema is

(DATE()*86400)+TIME()

It's incredibly useful when detecting time differences between 2 times that
may or may not cross a day boundary.

It was never meant to be an alternative to the DATE() and TIME() functions
alone.

The DATE()-1 concept would mean that you're trying to replace the DATE()
method and you're correct. With the method mentioned above, it really
doesn't matter as long as its consistent because the date expressions.

During my time when using the method above, it never was a replacement for
the actual date and time of an occurrence. It was simply used to derive the
time 'difference' as many signals, alarms and incidents in the security
monitoring business are time sensitive, ie received 2 signals within 15
minutes, which could obviously cross midnight.

My 1 cent
Mark Johnson
- Original Message -
From: "Kevin King" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, September 12, 2006 4:45 PM
Subject: RE: [U2] Time/Date as a single number


> >My method is take date()*86400+time()
>
> Is the goal to track a chronology via a single field? If so, I'd say
> your calulation is close.  Wouldn't it be:
>
> ((DATE() - 1) * 86500) + TIME()
>
> (...as the number of days elapsed is today - 1, not today.)
>
> Regardless, you're right that the date could get humongous.  For the
> cycles you're going through to do this calculation it would be a small
> step to convert it into and out of any other base to compress and
> decompress the bytes.
>
> The foundational question, however, is one of context.  Why do you
> need this?  That answer may limit or expand your options.
>
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.com
>
> ** Check out scheduled Connect! training courses at
> http://www.PrecisOnline.com/train.html.
> ---
> 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] Using DICT items in basic program

[Mark Johnson]

Thank you Brian for your observations.

I'm of the Jurrasic Pick era with 95% of my world being mv and the other 5%
being MS Access. I am enjoying the GUI development environment of Accuterm
and may convert upcoming MS clients to that GUI front end on top of D3 as
the client doesn't care that much about back end databases when it has a
nice front end.

I've inherited many, many systems (45 in the last 10 years alone) with their
incredibly diverse and over-written methods for many, many tasks. Certainly
I've not seen everything but I've seen a ton of programming of which I can
extract the best methods to continuously add to my own personal library of
what's effecient. I can also ignore the less intelligent ineffeciencies.

My download utility's purpose is for the one-time project. It's pretty much
a TCL only command issued typically by the only cook in the kitchen, me.
I've written many portable subs that I install at all of my clients for
their recurring needs. While there could be some extension of
unidata/universe that allows direct writing to a PC folder, most
implementations don't have it that easy. The native ones don't have it at
all.

Thus I develop my subroutines and tweak them per mv flavour on which they're
installed. Thus whether it's UD/UV, D3, Mvbase, Microdata or native systems,
DOWNLOAD works the same as well as most of my subroutines.

If I were to add DOWNLOAD to a proc or a program, my experience would
prevent me from performing 5 million executes and approach the solution with
a more effecient method. I have subs that easily make CSV's or simple HTML's
and have automated many import/export facilities including unix-ftp, MS-ftp,
VB scripts and other contemporary attachments.

Thus, if my clients were to convert to other version of MV, only my subs
need be changed and not the local changes in dozens if not hundreds of
programs.

One sub that answered the original post is called GET.DICT(FILE, ID, VAL)
which has the embedded English sentence mentioned earlier. I use it in
DOWNLOAD as well as I've put it in regular CUSTOMER maintenance or other
single item programs to get the results of a complex expression instead of
writing the same code again. If the logic is complex or has the possibility
of being changed, business-wise, changing the dict reference causes its use
elsewhere to be changed as well.

One thing I miss in D3 that I enjoy in UD/UV is the more advanced called
subs from dict items. D3's versions can only pass (return) one parameter in
the parameter string. It has access (ACCESS()) to the item-id, file and
record but only once you're in the sub. It also gets a little funky when
returning multi-valued values.

The joy in the UD/UV called subs is that the sub being called doesn't care
if it's called from English or a basic program. Thus, the intelligence can
be shared whereby in D3 is has to be replicated or managed in a more klugy
way. Score one for U2.

My 3 cents.
Mark Johnson



- Original Message -
From: "Brian Leach" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, August 03, 2006 9:24 AM
Subject: RE: [U2] Using DICT items in basic program


> Tim/Mark
>
> You both make good points. Mark was responding to a specific requirement
> (how to get a single field for a single record) with one working and
largely
> cross platform solution. Obviously getting a tranch of data requires a
> different solution. I don't think Mark was seriously suggesting that a
> million executes is a way to go.
>
> Personally I would now look towards XML as that seems to be the best
current
> option for integrating the enquiry and development languages - finally
> something native to close that gap in the PICK model - though in the past
I
> have used everything from REFORMAT (slow but predicatable) to creating
> compound I Descriptors of the form:
>
> CONVERT(@FM:@VM:@SVM,CHAR(1):CHAR(2):CHAR(3),field1:@FM:field2:@FM ...)
etc
>
> and doing a SELECT .. SAVING that descriptor. Each ReadNext then gets an
> entire row - just CONVERT() the delimiters back again - and the result is
> extremely fast. Doesn't work well with WHEN clauses though - but then few
> things really do :(
>
> Tim's point about DOWNLOAD does have some merit. But Mark is an old pro
> (sorry, forgive the 'old' bit ! ) and I'm sure he writes his utilities in
a
> way that other developers can work out what they do . Calling a
> utility without looking to see how it works first - well that's just lazy.
> And it's not just MV that will screw up in those cases! You wouldn't
expect
> to call a SQL Server or Oracle stored procedure without some DBA's
approval,
> would you?
>
>
> Brian
> ---
> 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] Using DICT items in basic program

[Mark Johnson]

I am fully aware of the possibility of 5 executes for 1 million records
totalling 5 million executes.

Anyone can create an example of extremes to invalidate any suggestion. My
example was to acquire the results of a dict item within basic, one of those
missing elements that my sub can handle.

If I were intending to process 5 million records as you would suggest, I
would write a simple program to create the csv's. I create many of these as
programs for their recurring use. I use download for the one-shot simple
projects.

Besides, so what if it did 5 million executes. These systems can handle it.
Time or processor consumption wasn't an issue in the original request

My 1 cent
Mark Johnson
- Original Message -
From: "Timothy Snyder" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, August 31, 2006 9:57 PM
Subject: Re: [U2] Using DICT items in basic program


> [EMAIL PROTECTED] wrote on 08/31/2006 07:03:29 PM:
>
> > The magic is to take the TCL statement, derive the filename (CUSTOMER)
> and
> > using READNEXT, acquire each of the item id's from the SSELECT
> statement.
> >
> > Then I generate very tiny English statements of the form:
> >
> > EXECUTE "LIST FILE "ID" NAME ID-SUPP COL-HDR-SUPP {any other necessary
> > suppressors}" CAPTURING X
>
> If I'm reading this correctly, you're performing multiple executes for
> each record in the file.  In the example you provided, you would be
> performing one execute each for NAME, CSZ, PHONE, CONTACT, and
> AGED.BALANCE.  If you're processing a million records, that means you'll
> be performing FIVE-MILLION executes!!!
>
> Maybe I've misunderstood what you're doing.  But if not, I don't recommend
> this approach.  The overhead of performing that many executes is
> staggering.  I had a customer that had a process that was running in eight
> hours, and they desperately wanted to get it down to four hours.  It was
> consuming an entire CPU and imposing significant I/O wait times that
> impacted system-wide performance.  I found where the program was spending
> most of its time and CPU cycles - it was in a routine that was performing
> executes to locate a value within an index and read through that.  I
> changed it to eliminate the executes and use intrinsic basic functions
> instead - nothing else was changed.  It went down to twenty minutes - much
> better than they had hoped for.  CPU and disk consumption became
> insignificant.  Executes are a wonderful thing, but they are very
> expensive operations when performed many times.  By adding the capturing
> clause, you're adding even more overhead.
> ---
> 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] Using DICT items in basic program

[Mark Johnson]

I've created a utility that allows me to process an English statement
(output columns only, the select and sort are done prior) to produce a
free-form CSV.

SSELECT CUSTOMER WITH STATE = "NJ" AND WITH AGED.BALANCE GT "100"

DOWNLOAD CUSTOMER NAME CSZ PHONE CONTACT AGED.BALANCE (C:\FOLDER\ABC.CSV

Thus, my download utility will parse the sentence and derive the values for
the output dict items.

The magic is to take the TCL statement, derive the filename (CUSTOMER) and
using READNEXT, acquire each of the item id's from the SSELECT statement.

Then I generate very tiny English statements of the form:

EXECUTE "LIST FILE "ID" NAME ID-SUPP COL-HDR-SUPP {any other necessary
suppressors}" CAPTURING X

and viola, the variable "X" contains the single row, single column value of
that customer's NAME.

So your request is a variant of just processing a specific file with one or
more ID's for one field. Using English allows the magic of the correlatives
to dothe work so you don't have to re-write anything.

I've implemented this in Ud/Uv, D3, Mvbase. It's too cumbersome on Microdata
and mvbase has a quirk where the CAPTURING doesn't inhibit the screen output
so it gets a little busy.

My 2 cents.
Mark Johnson
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: "U2-Users List" 
Sent: Wednesday, August 30, 2006 6:21 PM
Subject: [U2] Using DICT items in basic program


> Hi folks,
>
> I'm trying to set up a general use utility and what I'd like to do is to
> be able to call this utility, passing it an open file handle, a couple
> other parameters plus one that could be used to specify a dict entry
> name, not a field number.  The catch is I'd like to use the dict entry
> regardless of what type of definition it is.  Obviously there would be
> some limits but the general definition is that the dict item ultimately
> points to a piece of data.  An example would be I would want to use a
> data position field like CUST.NUM in the INVOICE file.  I'd also want to
> be able to use something like CUST.NAME in the INVOICE file which would
> be a pointer to the CUSTOMER file's NAME field.  The utility would use
> READ or maybe XLATE to obtain the desired information.  I looked at
> ITYPE() but I'm not sure that's going to get me what I'm looking for.
> In AREV it was simply using the {} brackets.
>
> TIA
>
> BobW
> ---
> 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] Fwd: Ultimate users

[Mark Johnson]

I spent 13 years managing a 100 user Microdata (1981-1994) for a large
($85M) industrial pipe, valve & fitting (plumbing) wholesaler using custom
software from me and programmers prior. Being in NJ, (Ultimate's HQ roughly
15 miles away), we were clearly in their turf for this business.

During the mid-late 1980's, Ultimate propogated the system SHIMS (Supply
House Inventory Management System) and got a great deal of sales addressing
this market specifically. It wasn't until I left in 1994 to then realize
that SHIMS was a derivitave of the Microdata Results system.

I obtained 6 SHIMS clients from 1987-1993 and later had 5 Results clients
and they were incredibly similar in their data structures. This was probably
based on both of their origins being 4 Gary Rd and the split-up of May 1979
when Ted Sabarese got the boot. Perhaps no-one checked the outgoing
briefcases for file-save tapes.

BTW, there's another derivitive called IDS (Industrial Data Systems) that's
also based on Results. I also had another client using a renamed Results
package. Imitation is the sincerest form of flattery?

None of my SHIMS clients were on RS6000's. They were all on standard single
rack proprietary OS true-Ultimate systems (Honeywells). I only got involved
with RS6000's from 1993 through 2003.

Slowly during the 1990's my SHIMS clients were absorbed by larger, more
national plumbing wholesalers, thus dead-ending the Pick systems. Now I have
zero. I still have 4 Results clients.

I remained in contact with some of the SHIMS guys who stuck around (more
business than IT guys) with one having switched to Eclipse. Based on his
info, I didn't care that much for Eclipse as it seemed to be yet again
another Pick 4GL that, as an outside consultant, I can't justify
specializing in.

I don't know if SHIMS is still around. I know that Results died with
Microdata (et al) but the code still lingers with 4 of my clients.

My 2 cents.
Mark Johnson
- Original Message -
From: "Clifton Oliver" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, August 12, 2006 11:46 AM
Subject: [U2] Fwd: Ultimate users


> Posted on behalf of Henry Keultjes.
>
>
> Begin forwarded message:
>
> > From: Henry Keultjes <[EMAIL PROTECTED]>
> > Date: August 11, 2006 7:20:27 PM PDT
> > To: Clif Oliver <[EMAIL PROTECTED]>
> > Subject: Ultimate users
> >
> > Clif:
> >
> > Would you mind posting this to the U2 list?
> >
> > Henry
> >
> > There used to be quite a few plumbing wholesalers on Ultimate on RS/
> > 6000 machines.  I would like to know about any and all of those and
> > what they migrated to,  if they are not still on the same system.
> >
> > Henry Keultjes hbkeultjesatearthlinkdotnet
> > Database Scientifics Project http://www.ncolug.org/ppc.htm
> > Mansfield Ohio USA
> ---
> 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] RE: [U2C] FW: Opening

[Mark Johnson]

Is it In Like Flynn or In Like Flint?

- Original Message -
From: "Allen E. Elwood" <[EMAIL PROTECTED]>
To: "Eric Armstrong" <[EMAIL PROTECTED]>
Cc: "U2Users" ; "U2Community"
<[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2006 2:05 PM
Subject: [U2] RE: [U2C] FW: Opening


> Hi Eric
>
> Andy is just a friend that I sent this email on behalf of, and isn't
> actually a member of this group.
>
> By M2K he meant Manage-2000 which is now owned by Epicor.  This product
has
> been around since 1978, and at last count had something like 700 menus.
> Never bothered counting the number of programs but it's probably around 10
> to 12 thousand programs/subroutines.
>
> http://www.epicor.com/www/products/manufacturing/manage2k/
>
> And on the other subject of 'good programming skills' if anyone here has
> ever seen one of Andy's programs they would know what he meant.  He almost
> redesigns the language with his custom functions, so if you don't have a
> good handle on Unidata you might be lost for a month or so.
>
> I imagine that if you had 5 to 7 years of Unidata programming you'd be in
> like Flynn.  M2k has a huge number of Utilities but they are fairly easy
to
> learn, so the familiarity with Unidata would be more important, imho...
>
> hth,
> Allen
>
>
>
> -Original Message-
> From: Eric Armstrong [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 10, 2006 09:19
> To: [EMAIL PROTECTED]
> Subject: FW: [U2C] FW: Opening
>
>
> Andrew,
> What did you mean by M2K? Did you mean W2K?
>
> Eric Armstrong
> Programmer/Analyst
> Lobel Financial
> 714.816.1207
> 714.995.7012 fax
>
>
> -Original Message-
> From: Allen E. Elwood [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 09, 2006 11:01 AM
> To: U2Users; U2Community
> Subject: [U2C] FW: Opening
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf
> Of Andrew McLaughlin
> Sent: Thursday, August 03, 2006 13:18
> To: [EMAIL PROTECTED]
> Subject: [ManageUG2K] Opening
>
>
> Howdy all,
>
> First of all, a quick note to let everyone know, I've decided to
> resign from Shurflo and get back in to full time Java development.
> Woohoo! :) My last day here is 8/11.
>
> Now, my position will be open and we're interested in interviewing a
> suitable replacement. Anyone with M2K experience and good programming
> skills is a candidate. The office is located in beautiful Cypress, CA
> (Orange County).
>
> If you or someone else you know is interested, please send resume or
> CV directly to:
>
> [EMAIL PROTECTED]
>
> Thanks,
> Andrew
>
>
> __._,_.___
> Messages in this topic (1) Reply (via web post) | Start a new topic
> Messages | Files | Photos | Links | Database | Polls | Members | Calendar
>
> You are receiving Individual Emails Change Delivery Settings
> Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your
Group
> SPONSORED LINKS
>   a.. Business application software
>   b.. Business application development
>   c.. Business application
>   d.. Epicor
> Yahoo! HotJobs
> Be Discovered!
>
> Employers find you
>
> Upload your resume
>
> New web site?
> Drive traffic now.
>
> Get your business
>
> on Yahoo! search.
>
> Y! Messenger
> Talk it up - free!
>
> Call your friends
>
> worldwide - free!
> .
> __,_._,___
> 
> u2-community mailing list
> [EMAIL PROTECTED]
> 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] FW: Opening

[Mark Johnson]

Not to open a can of worms, but what does "Good Programming Skills" mean?

Thanks
Mark Johnson
- Original Message -
From: "Allen E. Elwood" <[EMAIL PROTECTED]>
To: "U2Users" ; "U2Community"
<[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2006 2:01 PM
Subject: [U2] FW: Opening


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf
> Of Andrew McLaughlin
> Sent: Thursday, August 03, 2006 13:18
> To: [EMAIL PROTECTED]
> Subject: [ManageUG2K] Opening
>
>
> Howdy all,
>
> First of all, a quick note to let everyone know, I've decided to
> resign from Shurflo and get back in to full time Java development.
> Woohoo! :) My last day here is 8/11.
>
> Now, my position will be open and we're interested in interviewing a
> suitable replacement. Anyone with M2K experience and good programming
> skills is a candidate. The office is located in beautiful Cypress, CA
> (Orange County).
>
> If you or someone else you know is interested, please send resume or
> CV directly to:
>
> [EMAIL PROTECTED]
>
> Thanks,
> Andrew
>
>
> __._,_.___
> Messages in this topic (1) Reply (via web post) | Start a new topic
> Messages | Files | Photos | Links | Database | Polls | Members | Calendar
>
> You are receiving Individual Emails Change Delivery Settings
> Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your
Group
> SPONSORED LINKS
>   a.. Business application software
>   b.. Business application development
>   c.. Business application
>   d.. Epicor
> Yahoo! HotJobs
> Be Discovered!
>
> Employers find you
>
> Upload your resume
>
> New web site?
> Drive traffic now.
>
> Get your business
>
> on Yahoo! search.
>
> Y! Messenger
> Talk it up - free!
>
> Call your friends
>
> worldwide - free!
> .
> __,_._,___
> ---
> 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 proc manual

[Mark Johnson]

Being a Jurrasic Pick PROCtologist, I'm observing this thread and looked at
my set of UD manuals. I didn't see anything for Proc.

Perhaps as a job control language, its functions were replaced with the
advent of the EXECUTE/PERFORM commands or paragraphs.

I lived through the introduction of true PQN proc in the late 1970's from
Microdata and their tangent was to further enhance proc with better buffer
management etc. The other implementations developed EXECUTE and their
flavors of MV.

As I support both now, ie Microdata, U2, D3, native and others, I can
appreciate the wrong turn Microdata did by enhancing PROC instead of BASIC.

Perhaps the absense of the proc manuals for UD is the grandfather effect.
They will support it but not endorse it. Granted, now-a-days, everyone can
manage their apps through Basic and I can't recall either a command that
works only in PROC and not Basic. Sure, there were some tricky user-exits in
Proc but they existed as a work-around given the need to have all
criteria-specific Select statements outside of Basic.

I'm glad that I'm well versed in both PQ and PQN styles of Proc as I'm not
in a position to re-write my clients' apps just because they're old-school.
Until the compiler (processer) ceases to process Proc, I'll keep those balls
rolling.

My 2 cents
Mark  Johnson

P.S. I'm glad that UD supports PQN procs. I've seen conversions to Microdata
to D3 and they're a bit messy.

- Original Message -
From: "John Jenkins" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, August 09, 2006 7:14 AM
Subject: RE: [U2] UniData proc manual


> I've used PROC happily and consistently on UniData for ages - despite
gibes
> from some colleagues - ;-'
>
> All the great toys :
>
> Buffer subscripts, Select buffers, file buffers, etc
>
> (and no - no manual) - I have always worked from memory, but used the ROS
> manuals to learn it in the past. I also remember writing a quick (basic
but
> complete) Ledger system, in (PQN)PROC...
>
> and no, it wasn't my choice - it was also not a good idea - but it was
> mandated and it did work. It just shows you what you CAN do if you have to
> (but don't do this at home kiddies).
>
> Regards
>
> JayJay
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: 08 August 2006 17:50
> To: U2
> Subject: [U2] Unidata proc manual
>
> Has anyone ever seen a unidata proc manual? I can't find any reference,
> other than some information on user exits
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006
> ---
> 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] FOLD can mutilate {Unclassified}

[Mark Johnson]

Ding, Ding, Ding, Ding. We have a winner.
- Original Message -
From: "Derek M. Falkner" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, May 31, 2006 12:39 AM
Subject: RE: [U2] FOLD can mutilate {Unclassified}


> We used to use the Hollerith code. That was after we changed from 7-track
> paper tape - I was quite good at making corrections to that.
>
> Derek Falkner
> Kingston, Ontario, Canada
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: May 30, 2006 11:26 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] FOLD can mutilate {Unclassified}
>
>
> Trivia Question:
> What's the name of the pattern (language) used for the traditional 80
column
> IBM punch cards.
>
> My 2 cents.
> ---
> 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] FOLD can mutilate {Unclassified}

[Mark Johnson]

Trivia Question:
What's the name of the pattern (language) used for the traditional 80 column
IBM punch cards.

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

Re: [U2] Multiple Data Files

[Mark Johnson]

Control files tend to be a hodge-podge of miscellaneous counters and other
'control' values. There tends not to be a DICT of a CONTROL file as the data
is pretty inconsistent.

Multiple Data Levels are pretty useful as otherwise indicated. Only drawback
is when deleting the file, all the data levels go bye-bye and you may not
want all to be deleted and thus manage separately.

Multiple data structures within one data file is pretty much a pain in the
ass. The Results Distribution system has the PRODUCT file containing 2
separate files structures, the Product Master record with the generic
description, classes, weights etc and the many Warehouse records showing the
on-hands and other transactional information per warehouse.

I've been dealing with Results for over 20 years and I truly wish it weren't
written that way. I worked with a stolen version of Results called IDS that
separated it and was a lot cleaner. I worked briefly with another stolen
version called SHIMS and it was combined.

The trouble is that rarely are you wanting all Master and Warehouse records
at once. You're either selecting Master or Warehouse records and every
English request must contain "AND WITH WHSE" or "AND WITH NO WHSE" to
differentiate between them. Add to the Basic selects having to separate and
it's not been a good idea.

I'm just sharing my opinion on primary combined files. One application, SAS
for HVAC Servicing, has all of the pesky files like STATES, Salesman,
Technicians, Vehicles, Tax Codes etc in one file with the primary key having
a prefix of ST, SM, TE, VE, TX etc. Since that app has a whole lot of
transactional data files, having these static files in one 'file' sorta
makes sense.

My 2 sense.
Mark Johnson
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 16, 2006 7:04 PM
Subject: RE: [U2] Multiple Data Files


> If you are meaning multiple data record structures inside of a single
> file then for me, it's a lot more manageable to keep things like control
> records in a single file/table than to have many files/tables with only
> one or a few records/rows.
>
> If this is not what you mean then your question has me totally confused.
>
> BobW
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings
> Sent: Tuesday, May 16, 2006 2:33 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Multiple Data Files
>
> I came to the Pick world by way fo Prime Information through Universe
> with
> the Prime Flavor.  I am currently working on an implementation of
> Universe
> with the Pick flavor.  I have come across examples fo Multiple Data
> Files in
> the application and am having a difficult time understanding the purpose
> of
> this file structure.  Can anyone share some practical uses for these
> file
> structures?
> ---
> 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] call sunroutine in command line

[Mark Johnson]

I've answered this before with an incredibly simple utility that should be
part of the standard issue TCL commands. It was first printed in Datastream
in the mid 1980's. It's called PRINT

ED MD PRINT
001 PQN
002 HRUN BP PRINT
003 P

ED BP PRINT
001 PROCREAD X ELSE STOP (or use @command and have PRINT be
cataloged)
002 OPEN "BP" ELSE STOP
003 X<-1>="END"
004 WRITE X ON "%PRINT%"
005 EXECUTE "DECATALOG BP %PRINT%"
006 EXECUTE "BASIC BP %PRINT%"
007 EXECUTE "RUN BP %PRINT%"
008 END

That's it. Period.

Thus any databasic instructions that can be expressed on a single line of
code can be passed from TCL and be processed. The limits are limitless.

Here's some TCL examples with their implied results
PRINT 5+5
PRINT ; FOR I=1 TO 10 ; PRINT I ; NEXT I
PRINT ; FOR I=1 TO 12 ; PRINT OCONV(I*28,"DMA") ; NEXT I ;   from previous
thread
PRINT ; OPEN "PRODUCT" THEN READ REC FROM "ABC" THEN REC<15>=REC<20> ; WRITE
REC ON "ABC"
PRINT ; A=1; B=2; C=3; D=4 ; CALL FRED(A,B,C,D,E) ; PRINT E
PRINT ; EXECUTE "GET-LIST ABC" ; LOOP WHILE READNEXT ID DO ; PRINT ID ;
REPEAT

We're not talking rocket science here. It's just a single line of code that
gets compiled in the program above.

This saves your system (and eventually mine) from containing thousands of
tiny 3 line basic programs just to see what "MTHS" looks like as a time
conversion, or any other nuisance programs.

I use it at least a few dozen times a day, especially when testing
formatting or even some math. PRINT 1501234/15 is better than DIVD.

The only limit is when you get caught up with an ELSE that causes the rest
of the line tobe part of the ELSE and not the rest of the program. Thus, you
can program with consecutive (successful) THEN's like in the 4th example.

Specifically you would not use RUN or CALL in the original posting. PRINT
becomes a new verb in the MD and if it's there, it's probably a throwaway
connective for English.

I have installed this or its platform altered version on Microdata,
Ultimate, UV, UD, AP-Pro, D3, Adds, GA, MvBase, Sequoia, Alpha-Micro, Altos
and Revelation. It is so darn simple.

It's also Emulator independent being on Procomm, Hyperterminal, Telnet,
Wintegrate, Accuterm, Wintegrate and even PK-Harmony back in the day

Thanks and hopefully many can take advantage of this incredibly useful
program concept.

Mark Johnson

- Original Message -
From: "Vance, Kathy" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 09, 2006 9:17 AM
Subject: [U2] call sunroutine in command line


> All,
>
> How could I test a subroutine with AccuTerm command line? For example,
> the subroutine is called WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) and
> it has a select statement and returns a result set. In subroutine, there
> is something like:
>
> SUBROUTINE WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG)
> .
> EXECSQLSTMT = SQLSTMT
> ST=SQLExecDirect(@HSTMT,EXECSQLSTMT)
>
> RETURN
> End
>
> Could I call this subroutine in command line by using:
> > RUN WEB.BI.RENTAL.SUB('953145678','4897','');
> OR
> > CALL WEB.BI.RENTAL.SUB('953145678','4897','');
>
> As a result, I could check the result of returned values from this
> subroutine.
>
> Thanks a lot,
>
> Kathy
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

Mats: You'll like my (I*28) a little cleaner.
- Original Message -
From: "Mats Carlid" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 09, 2006 2:34 AM
Subject: Re: [U2] OPEN Statement DICT Default


> You mean sthg like:
>
> FOR I=31 TO 365 STEP 28
>PRINT  (I,'DMAL')[1,3]
>NEXT I
>
> Tried  'DMBL'  but the abbreviations were only two characters.
> But printing the actual string is somewhat shorter ...
>
> -- mats
>
>
> Mark Johnson wrote:
>
> >I specifically remember being taught
> >X=STR("0",5-LEN(X)):X
> >for the 1 concept.
> >Before the % was allowed, a shorter form was
> >X=("0":X)"R#5"
> >which I recall using until % came about.
> >
> >On that note, I stole "R-10" and "C#10" from UD and offered it to D3
> >hopefully for their next release.
> >
> >Thanks
> >Mark Johnson
> >
> >P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM"
is
> >the shortest way.
> >Puzzle: Illustrate the simplest way to generate Jan thru Dec.
> >
> >
> >- Original Message -
> >From: "Roger Glenfield" <[EMAIL PROTECTED]>
> >To: 
> >Sent: Monday, May 08, 2006 9:42 AM
> >Subject: Re: [U2] OPEN Statement DICT Default
> >
> >
> >
> >
> >>The same programmer that doesn't read the manual does an
> >>
> >>EXECUTE instead of a SELECTINDEX, and yes, the index already existed
> >>
> >>or
> >>A=STR('0',20-LEN(B)):B
> >>instead of
> >>A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
> >>crowd  A= B'L%20'
> >>
> >>or
> >>TODAY=OCONV(DATE(),'D2/')
> >>CONVERT '/' TO @VM IN TODAY
> >>MONTH=TODAY<1,2>
> >>instead of
> >>MONTH=OCONV(DATE(),'DM')
> >>
> >>
> >>And yes, I have observed all of the above recently.
> >>
> >>;)  Just 15 minutes a week to look through the current manuals to find
> >>out about a new option that you might not know existed?
> >>
> >>Roger
> >>
> >>Louie Bergsagel wrote:
> >>
> >>
> >>>I've never used the null dict indicator. Who ever reads the syntax book
> >>>unless a command doesn't work?
> >>>
> >>>*":)*
> >>>-- Louie Bergsagel
> >>>
> >>>
> >>>On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> >>>
> >>>
> >>>
> >>>>To All:
> >>>>
> >>>>Was there ever a real requirement on any prior flavor to have the
> >>>>typically
> >>>>non-used DICT portion of the OPEN statement be the set of quotes and a
> >>>>comma.
> >>>>
> >>>>I accidentally forgot it in 1978 on a Microdata and it still compiled.
> >>>>
> >>>>
> >To
> >
> >
> >>>>this
> >>>>day I have not seen a reason for the OPEN "","FILE" null dict
indicator
> >>>>and
> >>>>have not used it since unless I actually want the DICT level.
> >>>>
> >>>>Just wondering.
> >>>>
> >>>>Thanks
> >>>>Mark Johnson
> >>>>---
> >>>>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/
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

That's cool. I owe Pete Colucci for this one:
FOR I=1 TO 12
   CRT (I*28)"DM"
NEXT I

Thanks.

- Original Message -
From: "Womack, Adrian" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 08, 2006 11:27 PM
Subject: RE: [U2] OPEN Statement DICT Default


> All the months order (full names):
>
> CRT OCONVS(ICONVS("1}2}3}4}5}6}7}8}9}10}11}12","DM"),"DMAL")
>
> Abbreviations:
>
> CRT OCONVS(ICONVS("1}2}3}4}5}6}7}8}9}10}11}12","DM"),"DMAL[3]")
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Tuesday, 9 May 2006 10:50 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] OPEN Statement DICT Default
>
> I meant all of the months in order. Thanks.
>
>
> DISCLAIMER:
> Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and
delete the e-mail and any attachments without using or disclosing the
contents in any way. The views expressed in this e-mail are those of the
author, and do not represent those of this company unless this is clearly
indicated. You should scan this e-mail and any attachments for viruses. This
company accepts no liability for any direct or indirect damage or loss
resulting from the use of any attachments to this e-mail.
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

My Bad, I meant [1,2], not the year part. Actually the [1,2] works for both
hemispheres if the SET-DATE command is set to either US or European. Thus
[1,2] or "DM" grabs the month and [4,2] or "DD" grabs the day.

Thanks
- Original Message -
From: "Roger Glenfield" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 08, 2006 11:05 PM
Subject: Re: [U2] OPEN Statement DICT Default


> You did mean
> OCONV(DATE(),"D2/")[1,2] for month, at least in the Western Hemisphere
> and [4,2] for the Eastern, right? ;-)
>
>
> Roger
> Mark Johnson wrote:
>
> >I specifically remember being taught
> >X=STR("0",5-LEN(X)):X
> >for the 1 concept.
> >Before the % was allowed, a shorter form was
> >X=("0":X)"R#5"
> >which I recall using until % came about.
> >
> >On that note, I stole "R-10" and "C#10" from UD and offered it to D3
> >hopefully for their next release.
> >
> >Thanks
> >Mark Johnson
> >
> >P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM"
is
> >the shortest way.
> >Puzzle: Illustrate the simplest way to generate Jan thru Dec.
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

I meant all of the months in order. Thanks.
- Original Message -
From: "Adrian Overs" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 08, 2006 9:53 PM
Subject: Re: [U2] OPEN Statement DICT Default


> Solution to "puzzle" :
> Month = OCONV(DATE(),"DMBL")
> D = Date
> MB = Abbreviated Month Name
> L = Lower Case
>
>
> On 9/5/06 9:45 AM, "Mark Johnson" <[EMAIL PROTECTED]> wrote:
>
> > I specifically remember being taught
> > X=STR("0",5-LEN(X)):X
> > for the 1 concept.
> > Before the % was allowed, a shorter form was
> > X=("0":X)"R#5"
> > which I recall using until % came about.
> >
> > On that note, I stole "R-10" and "C#10" from UD and offered it to D3
> > hopefully for their next release.
> >
> > Thanks
> > Mark Johnson
> >
> > P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM"
is
> > the shortest way.
> > Puzzle: Illustrate the simplest way to generate Jan thru Dec.
> >
> >
> > - Original Message -
> > From: "Roger Glenfield" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Monday, May 08, 2006 9:42 AM
> > Subject: Re: [U2] OPEN Statement DICT Default
> >
> >
> >> The same programmer that doesn't read the manual does an
> >>
> >> EXECUTE instead of a SELECTINDEX, and yes, the index already
existed
> >>
> >> or
> >> A=STR('0',20-LEN(B)):B
> >> instead of
> >> A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
> >> crowd  A= B'L%20'
> >>
> >> or
> >> TODAY=OCONV(DATE(),'D2/')
> >> CONVERT '/' TO @VM IN TODAY
> >> MONTH=TODAY<1,2>
> >> instead of
> >> MONTH=OCONV(DATE(),'DM')
> >>
> >> 
> >> And yes, I have observed all of the above recently.
> >>
> >> ;)  Just 15 minutes a week to look through the current manuals to find
> >> out about a new option that you might not know existed?
> >>
> >> Roger
> >>
> >> Louie Bergsagel wrote:
> >>> I've never used the null dict indicator. Who ever reads the syntax
book
> >>> unless a command doesn't work?
> >>>
> >>> *":)*
> >>> -- Louie Bergsagel
> >>>
> >>>
> >>> On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> >>>
> >>>> To All:
> >>>>
> >>>> Was there ever a real requirement on any prior flavor to have the
> >>>> typically
> >>>> non-used DICT portion of the OPEN statement be the set of quotes and
a
> >>>> comma.
> >>>>
> >>>> I accidentally forgot it in 1978 on a Microdata and it still
compiled.
> > To
> >>>> this
> >>>> day I have not seen a reason for the OPEN "","FILE" null dict
indicator
> >>>> and
> >>>> have not used it since unless I actually want the DICT level.
> >>>>
> >>>> Just wondering.
> >>>>
> >>>> Thanks
> >>>> Mark Johnson
> >>>> ---
> >>>> 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/
> >
>
> --
> Adrian Overs
> Phone : +61 (0)2 9484-7160
> Mobile: +61 (0)411 358 354
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

I specifically remember being taught
X=STR("0",5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=("0":X)"R#5"
which I recall using until % came about.

On that note, I stole "R-10" and "C#10" from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.


- Original Message -
From: "Roger Glenfield" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default


> The same programmer that doesn't read the manual does an
>
> EXECUTE instead of a SELECTINDEX, and yes, the index already existed
>
> or
> A=STR('0',20-LEN(B)):B
> instead of
> A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
> crowd  A= B'L%20'
>
> or
> TODAY=OCONV(DATE(),'D2/')
> CONVERT '/' TO @VM IN TODAY
> MONTH=TODAY<1,2>
> instead of
> MONTH=OCONV(DATE(),'DM')
>
> 
> And yes, I have observed all of the above recently.
>
> ;)  Just 15 minutes a week to look through the current manuals to find
> out about a new option that you might not know existed?
>
> Roger
>
> Louie Bergsagel wrote:
> > I've never used the null dict indicator. Who ever reads the syntax book
> > unless a command doesn't work?
> >
> > *":)*
> > -- Louie Bergsagel
> >
> >
> > On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote:
> >
> >> To All:
> >>
> >> Was there ever a real requirement on any prior flavor to have the
> >> typically
> >> non-used DICT portion of the OPEN statement be the set of quotes and a
> >> comma.
> >>
> >> I accidentally forgot it in 1978 on a Microdata and it still compiled.
To
> >> this
> >> day I have not seen a reason for the OPEN "","FILE" null dict indicator
> >> and
> >> have not used it since unless I actually want the DICT level.
> >>
> >> Just wondering.
> >>
> >> Thanks
> >> Mark Johnson
> >> ---
> >> 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] OPEN Statement DICT Default

[Mark Johnson]

It's a shame that the habit wasn't broken when it became optional.
Thanks.
- Original Message - 
From: "Kevin King" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, May 06, 2006 11:06 AM
Subject: RE: [U2] OPEN Statement DICT Default


> Early versions of Reality did require it, including PC-MicroReality. 
> 
> 
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.com
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Friday, May 05, 2006 10:37 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] OPEN Statement DICT Default
> 
> To All:
> 
> Was there ever a real requirement on any prior flavor to have the
> typically non-used DICT portion of the OPEN statement be the set of
> quotes and a comma.
> 
> I accidentally forgot it in 1978 on a Microdata and it still compiled.
> To this day I have not seen a reason for the OPEN "","FILE" null dict
> indicator and have not used it since unless I actually want the DICT
> level.
> 
> Just wondering.
> 
> Thanks
> Mark Johnson
> ---
> 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.392 / Virus Database: 268.5.5/333 - Release Date:
> 5/5/2006
> ---
> 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] OPEN Statement DICT Default

[Mark Johnson]

To All:

Was there ever a real requirement on any prior flavor to have the typically
non-used DICT portion of the OPEN statement be the set of quotes and a comma.

I accidentally forgot it in 1978 on a Microdata and it still compiled. To this
day I have not seen a reason for the OPEN "","FILE" null dict indicator and
have not used it since unless I actually want the DICT level.

Just wondering.

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

Re: [U2] U2 Courses offered by Raining Data

[Mark Johnson]

Wouldn't that be like asking Ford for Chevy questions.

- Original Message - 
From: "Bruce McAdoo" <[EMAIL PROTECTED]>
To: 
Sent: Friday, May 05, 2006 11:43 AM
Subject: [U2] U2 Courses offered by Raining Data


> Does anyone have any experience with any U2 courses offered by Raining
> Data that they would share?
> 
> Bruce W. McAdoo
> Wagner & Brown, Ltd.
> [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] Forum General Question

[Mark Johnson]

So one renegade email auto-responder changed this for everyone.
Too bad that was the only solution.

- Original Message -
From: "Larry Hiscock" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 1:47 PM
Subject: RE: [U2] Forum General Question


> 50+ in a single day?  Try 1500+ in an hour :-S
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield
> Sent: Tuesday, May 02, 2006 6:52 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Forum General Question
>
> Somebody's auto-email-responder zoomed out 50+ "I'll be back in the
> office on blah, blah, blah" in a single day.  At one point even
> responding to it's own 'responses'.
>
> Mark Johnson wrote:
> > So why was it changed in the first place. I wonder how many liked it
that
> > way.
> > Mark Johnson
> ---
> 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] Forum General Question

[Mark Johnson]

So one person's screwed-up auto-responder changes it for everyone else.
Doesn't seem right.

- Original Message -
From: "Roger Glenfield" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 9:52 AM
Subject: Re: [U2] Forum General Question


> Somebody's auto-email-responder zoomed out 50+ "I'll be back in the
> office on blah, blah, blah" in a single day.  At one point even
> responding to it's own 'responses'.
>
> Mark Johnson wrote:
> > So why was it changed in the first place. I wonder how many liked it
that
> > way.
> > Mark Johnson
> ---
> 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] Forum General Question

[Mark Johnson]

Actually not. That's probably why I'm asking why the volume appears low.
- Original Message - 
From: "Nick Cipollina" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 9:52 AM
Subject: RE: [U2] Forum General Question


> Haven't you seen any of the about 3000 emails on this subject?
> 
> Thanks,
>  
> Nick Cipollina
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Tuesday, May 02, 2006 9:21 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Forum General Question
> 
> So why was it changed in the first place. I wonder how many liked it
> that
> way.
> Mark Johnson
> - Original Message -
> From: "Richard Brown" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:45 PM
> Subject: Re: [U2] Forum General Question
> 
> 
> > I think what Larry is saying is that it is now back to the first
> scenario
> > you described.  When you hit reply,  the message goes to the list,
> which
> is
> > then distributed to all of us.  I subscribe to different list.  Some I
> have
> > to know to hit 'reply to all' to get my message to everyone.  Some I
> can
> > just hit reply and it goes to the list & the poster.  The poster will
> get
> it
> > twice,  once from me, once from the list.  Personally I don't care
> which
> way
> > it is setup.  If I reply wrong for the list,  that is my bad.
> >
> > Richard
> >
> > - Original Message -
> > From: "Mark Johnson" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Monday, May 01, 2006 11:20 PM
> > Subject: [U2] Forum General Question
> >
> >
> > > While I'm a MV person, I don't know everything about all of this
> > > email/web/forum/thread stuff.
> > >
> > > What was the kind of U2 forum whereby a person posted a request and
> > everyone
> > > got it. Then each answer got sprayed to everyone. And so on until it
> died.
> > >
> > > Now, it appears that only the person issuing the question gets the
> reply
> > and
> > > many of us who might learn something of their public discussion are
> out
> of
> > the
> > > loop.
> > >
> > > Am I detecting this properly.
> > >
> > > Thanks
> > > Mark Johnson
> > > ---
> > > 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/
> ---
> 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] Forum General Question

[Mark Johnson]

So why was it changed in the first place. I wonder how many liked it that
way.
Mark Johnson
- Original Message -
From: "Richard Brown" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 01, 2006 11:45 PM
Subject: Re: [U2] Forum General Question


> I think what Larry is saying is that it is now back to the first scenario
> you described.  When you hit reply,  the message goes to the list, which
is
> then distributed to all of us.  I subscribe to different list.  Some I
have
> to know to hit 'reply to all' to get my message to everyone.  Some I can
> just hit reply and it goes to the list & the poster.  The poster will get
it
> twice,  once from me, once from the list.  Personally I don't care which
way
> it is setup.  If I reply wrong for the list,  that is my bad.
>
> Richard
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:20 PM
> Subject: [U2] Forum General Question
>
>
> > While I'm a MV person, I don't know everything about all of this
> > email/web/forum/thread stuff.
> >
> > What was the kind of U2 forum whereby a person posted a request and
> everyone
> > got it. Then each answer got sprayed to everyone. And so on until it
died.
> >
> > Now, it appears that only the person issuing the question gets the reply
> and
> > many of us who might learn something of their public discussion are out
of
> the
> > loop.
> >
> > Am I detecting this properly.
> >
> > Thanks
> > Mark Johnson
> > ---
> > 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/

[U2] Forum General Question

[Mark Johnson]

While I'm a MV person, I don't know everything about all of this
email/web/forum/thread stuff.

What was the kind of U2 forum whereby a person posted a request and everyone
got it. Then each answer got sprayed to everyone. And so on until it died.

Now, it appears that only the person issuing the question gets the reply and
many of us who might learn something of their public discussion are out of the
loop.

Am I detecting this properly.

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

[U2] Different Conversion

[Mark Johnson]

With all of this talk of UD to D3, I'm interested in converting a client
from Microdata *to* D3.

That client is semi-proficient in MCD and to be quite honest, I'm not that
interested in the 6/7 line dict items as compared to the 10 line ones. He's
pretty good at creating A-type or F-type and leaves the more complex ones
for me.

I also have a client that was on MCD and now on UD and I detect a conversion
utility that must have been run that took the original 10 line dict items
and converted them to the 6/7 line dicts for UD, leaving the original 10
line dict item on the UD line 10 with a non-processing delimiter. Keeping
the old dict item was probably for familiarity purposes.

While they worked, they all became the REUSE and SUBR style on 002 that take
some getting used to.

While I have some clients on UD/UV, i'm not as good as others who focus
wholy on UD/UV. Based on the speed deficiency, I've installed many phantom
process on this MCD starting programs so that long reports do not tie up the
actual user issuing them. They use the spooler pretty flexibly, more
flexible than D3.

The ironic thing may be that for the last 12 years of working on this
client, all of my MCD tricks may have caused a greater burden for any
upcoming conversion. C'est la vie. This client is pretty savvy and won't
convert unless there are really, really good reasons. But the dialog has
already been startd on a possible upgrade based on disc space.

I guess my question is to learn of some conversion headaches that I may
encounter. I know that Northbridge exists but haven't heard anything beyond
their own words on how great they are. Real-life opinions are very
important.

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

Re: [U2] PRODUCT EVALUATIONS

[Mark Johnson]

I'm presently happy with Accuterm as a terminal emulator, GED which is their
GUI development module that designs like VB forms but is 100% pick
subroutines with pretty managable code. Toss in WED, which is their Windows
editor for programs and it's a home run.

I'm sure there's many other screen editors but WED has met all of my desires
for being 100% of the MS interface while intelligently editing MV programs,
ie formatting, compiling, INCLUDES, CALLS, Multiple documents etc.

Plus at $1000 for 50 licenses, it's a real sweet deal.

Peter Schellenbach is 100% behind this product and incredibly knowledgable
with MV, VBA and all of the GUI stuff. Having an emulator that can gradually
allow you to convert programs to GUI on a priority basis instead of all at
once allows for a smart transition.

There is no magic pill. We decide which programs need upgrading, typically
inquiry-based to give the users something beyond 80x24 green screens. We
also take some existing programs with the business logic already coded and
convert them to Callable subs for the GED to reference.

My 2 cents.
Mark Johnson
- Original Message -
From: "will" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, March 02, 2006 1:57 PM
Subject: [U2] PRODUCT EVALUATIONS


>An  MV  client  has  inquired  about moving to GUI screens, Rapid/Easy
>Management   Reporting   Systems   and   Multi-Location   Transmission
>protocols.   We  could simply give our client a recommendation of what
>is  familiar  to  us,  but that would not be an honest evaluation.  In
>that  light  we are hoping that there are some real happy users of the
>new  or  updated  products we have seen advertised and promoted at the
>trade  shows.   If  anyone  would care to weigh in with their pleasant
>surprises  it  might be helpful for everyone who are contemplating new
>purchases.   Don't  be  shy if you threw or are contemplating throwing
>out something... that is of value also.
>If  this  list  is an inappropriate forum for candid evaluations, then
>please  send  replies  direct  to [EMAIL PROTECTED]  When we have had
>time to compile the results (shades of American Idol voting?), we will
>be happy to share them with any interested parties.
>Will
> ---
> 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] Steve Cashman

[Mark Johnson]

I'm guessing March 6. Just a hunch.

I think that the list server should/could detect these and terminate.
Otherwise, they could spin out of countrol.

Mark Johnson
- Original Message -
From: "Nick Cipollina" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, February 25, 2006 7:51 AM
Subject: [U2] Steve Cashman


> Does anyone know when Steve Cashman will be back in the office?
>
>
>
> Nick Cipollina
>
>
>
> Pick Programmer
>
> ACS Heritage, Inc.
>
> 2810 North Parham Road, Suite 210
>
> Richmond, VA 23294
>
> (804)965-8294
> ---
> 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] Java Script

[Mark Johnson]

A client of mine has a folder filled with PDF's. I want to cause the printing
(choice and copies) from my MV application.

Prior, I could set up a DOS command line with the /P print switches but Adobe
now doesn't support switches. They suggested that I get at acrobat reader 5.0
using a java script.

I want the user to be able to choose a reference from the MV app, create a
batch file or script on their C: drive and print blindly (or at least without
human intervention) the PDF. I probably can control the copy count from my end
with multiple identical lines.

The emulator is Wintegrate but could be Accuterm.

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

Re: [U2] Is there a Better Editor?

[Mark Johnson]

Accusoft's WED is absolutely huge. Your programs will come to life as you
have a higher degree of visibility on them than the regular EDIT.

Unlike notepad or wordpad, WED is MV oriented with keyword highlighting,
indenting, double clicking to bring in INCLUDES and called subs, Compiling,
multiple windows, colors, color printing etc. Plus the normal cut & paste
and windows keyboard shortcuts.

I'm a converted EDit person who never got into VI or AE and it's great. I
speak with Peter Schellenbach on a weekly basis and I'll be writing an
article on WED soon. There are some nice features that will be added soon as
well.

Do not use it (or any program editor) as a data editor as you could offset
the fields pretty easily.

When combined with the GUI designer and run time, and at $1,000 US for 50
licenses, it's the absolute best bargain, hands down.

My 2 cents.
Mark Johnson
- Original Message -
From: "Dave Taylor" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 21, 2006 7:46 PM
Subject: Re: [U2] Is there a Better Editor?


> Michael,
>
> Yes.
>
> Download a free 30-day trial of Accuterm 2K2 from AccuSoft Enterprises at
> www.asent.com.
>
> Try their Windows editor, WED, at TCL and you'll love it.
>
> It will also move data back and forth between Unidata and your PC for
> whatever purposes you wish.
>
> You can buy it direct from AccuSoft on line.
>
> Dave Taylor
> President
> Sysmark Information Systems, Inc.
> 49 Aspen Way
> Rolling Hills Estates, CA 90274
> 800-SYSMARK (800-797-6275)
> (O) 310-544-1974
> (C) 310-561-5200
> (P) 800-339-1497
> (F) 310-377-3550
> Your Source for Integrated EDI Translation and DataSync Integration
> www.sysmarkinfo.com
>
> - Original Message -
> From: "Caskey, Michael" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, February 21, 2006 3:10 PM
> Subject: [U2] Is there a Better Editor?
>
>
> > Hi all, this is my first post to the board, so a big "Hi" to you all!
> >
> > I'm probably showing off my lack of knowledge here, but I hope someone
> > might have the knowledge I seek, so...
> >
> > I have been tasked with creating reports from our UniData system using
> > UniQuery.  For building queries, I have been given a tool called
> > PARADEX.  This tool seems extremely ancient to me.  The interface is
> > extremely cumbersome.  To edit anything, special commands are employed
> > to edit my queries, one line at a time.  I'm already fairly lost in the
> > system, so the last thing I need is cumbersome tools to make my life
> > even more difficult.  I like things to be easy peasy.  :)
> >
> > So, my questions are:
> >
> > 1. Is there a better way to run these queries?
> >
> > and
> >
> > 2. Is there a better query editor; text-based or GUI or both?
> >
> >
> >
> > Thank you all!
> >
> > Michael T. Caskey
> > ---
> > 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] Dict Item

[Mark Johnson]

There are a few things that I've always been curious about English that are
somewhat esoteric in nature. This was one of them that came up this week and
I really didn't have an anwer. I believe your answer is in sync with mine,
that English builds what it needs at the onset and goes from there.

I inherit a lot of crap in my travels and I saw this conflict but got into a
debate with another MV programmer.

Thanks
- Original Message -
From: "David A. Green" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, February 18, 2006 11:11 AM
Subject: RE: [U2] Dict Item


> Mark,
>
> Not having access to the English source code I couldn't say for sure.  But
> having written my own web version, and from a designer's standpoint, it
just
> makes sense to open and read all dictionary records once at the beginning.
>
> An exception might be a Virtual Attribute that uses other dictionary
items.
>
> Thanks,
> David A. Green
> DAG Consulting
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Thursday, February 16, 2006 8:27 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Dict Item
>
> If a process has already started with a file and dict items, either a
SELECT
> or SORT, and one or more of the dict items get deleted or changed during
> that
> time by another process, does it have any adverse effect on the first
> process.
>
> Not that this comes up often, but it did today with some temp files shared
> by
> users. I'm not looking for a lesson in temp files, just the English (sic)
> processor.
>
> Thanks in advance.
> Mark Johnson
> ---
> 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/

[U2] Dict Item

[Mark Johnson]

If a process has already started with a file and dict items, either a SELECT
or SORT, and one or more of the dict items get deleted or changed during that
time by another process, does it have any adverse effect on the first
process.

Not that this comes up often, but it did today with some temp files shared by
users. I'm not looking for a lesson in temp files, just the English (sic)
processor.

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

Re: [U2] Question about execute and stacked data.

[Mark Johnson]

I use DATA statements for both situations. To pre-answer the next INPUT
instead of programming around it, or to provide the next TCL command for
consecutive sentences.

I've used a controlled set of dozens of pre-quailfied answers to use entry
programs as blind data validation or other entry update programs. By turning
off the crt response (PH in proc or processing the verb 'P') it can appear
seamless.

Another cross platform scenario.
Some support
 DATA "SAVE-LIST FRED"
EXECUTE "SELECT MD"
and others
EXECUTE "SELECT MD"
EXECUTE "SAVE-LIST FRED"
and more:
TCL="SELECT MD"
TCL<2>="SAVE-LIST FRED"
EXECUTE TCL

This area is the one I find that I need to pay attention to when converting
systems within MV. Some systems allow named list references in a program.
Others allow numbers. It got out of hand and is pretty splintered.

My 1 cent.
Mark Johnson

- Original Message -
From: "Louie Bergsagel" <[EMAIL PROTECTED]>
To: 
Sent: Monday, February 13, 2006 6:34 PM
Subject: Re: [U2] Question about execute and stacked data.


> According to the documentation, DATA is only used "...as an input stack to
> act as responses to INPUT statements..."
>
> so your "basic.program.that.builds.a.list" would have to contain
>INPUT COMMAND;EXECUTE COMMAND
> or you could add another EXECUTE line after the DATA/EXECUTE lines which
ran
> the following program:
>0001: INPUT COMMAND
>0002: IF @SELECTED THEN EXECUTE COMMAND
>0003: END
>
>
>
> On 2/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > I've got a bunch of code coming from another system where this worked.
> > We have a lot of places with things like:
> > DATA 'basic.program.that.uses.a.list'
> > EXECUTE 'basic.program.that.builds.a.list'
> > And under universe this just isn't working. The basic program isn't
> > setting something that universe wants to see before it will execute the
> > DATA. Some of it could easily be changed to
> > PERFORM 'basic.program.that.builds.a.list'
> > PERFORM 'basic.program.that.uses.a.list'
> > Or as
> > EXECUTE 'basic.program.that.builds.a.list' RTNLIST LST
> > EXECUTE 'basic.program.that.uses.a.list' PASSLIST LST
> > But I was hoping someone knew the internals that allow
> > DATA 'SAVE-LIST LST'
> > EXECUTE 'SELECT VOC'
> > To work but
> > DATA 'SAVE-LIST LST'
> > EXECUTE 'basic.program.that.builds.a.list'
> > To not work.
> ---
> 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] Question about execute and stacked data.

[Mark Johnson]

My 2 cents on this regardless of platform is to take the low road. Sure you
can set up tricky DATA/EXECUTE statements that you hope will work but
somewhere along the way they will get out of sync.

I test things like consecutive selects, ie First Select for the majority and
the second to fine tune (there are effeciency reasons). But if the first one
fails, I don't want the second to process 'alone' and get far more (or zero)
items than expected.

Proc had the IF E = 401 blah, blah intermediate tests. There is a lot of
status, Returning and, Capturing clauses to consider.

Assume the worst and program around unvalidated data and the good stuff will
prevail.

Mark Johnson
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
Sent: Monday, February 13, 2006 11:54 AM
Subject: [U2] Question about execute and stacked data.


> This is on universe 10.0.10 on windows xp.
> If you have stacked data, it will be executed after an EXECUTE, so:
> 001 DATA 'WHO'
> 002 EXECUTE 'SELECT VOC'
> Will select the voc to list 0, then execute WHO.
> If the command in EXECUTE doesn't yield a list, then the data isn't
> executed, so
> 001 DATA 'WHO'
> 002 EXECUTE 'GET-LIST VOCCRAP' ;* assuming you don't have a list named
> voccrap
> 003 INPUT A
> 004 CRT A
> The GET-LIST doesn't return a list, so the WHO stays stacked and gets
> picked up by the INPUT later.
>
> Now here's the problem/question.
> Suppose you have a basic program that creates a list, for example:
> 001 L='A':@AM:'B'
> 002 SELECTN L TO 0
> Saved and cataloged as MY.LIST.PROG
> And change the test program above to
> 001 DATA 'WHO'
> 002 EXECUTE 'MY.LIST.PROG'
> 003 CRT @SELECTED
> The WHO does not execute, even though the basic program creates a list.
> You can fiddle with the VOC catalog entries adding 'K' to attribute 4 so
> that you can see the list created by running the program from TCL.
> So the question is, what magic does a basic program need to do so that
> it can create a list and participate in the serial execution of stacked
> data?
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.15.6/258 - Release Date:
> 2/13/2006
> ---
> 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] Justification for removal of savedlists

[Mark Johnson]

I've seen instances of 'permanent' save lists but I've converted them to
control records in a separate files.

I like Microdata's date & time stamp of their lists. UD/UV certainly have
these in the unix level. I wish D3 had some because when looking only at the
pointer-file, you really can't tell when they're made. And hunting down
their source is not that easy with both SAVE-LIST, WRITELIST and writing
directly to the POINTER-FILE.

My 1 cent.

- Original Message -
From: "Pingilley, Ron" <[EMAIL PROTECTED]>
To: 
Sent: Monday, February 06, 2006 10:38 AM
Subject: RE: [U2] Justification for removal of savedlists


> Try "Savedlists do not contain data.  They are collections of record
> keys selected for processing as a group (reports, postings, etc.), and
> deleting them does not change or delete the actual data.  The records
> pointed to by the keys still exist as-is in their original files/tables.
> Keeping them does not add value to the system, as the records
> represented by the keys in the saved list may no longer exist in the
> file, or may have been updated since the saved list was created.".
>
> --Ron P.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer
> Sent: Monday, February 06, 2006 8:33 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Justification for removal of savedlists
>
> I wrote a small routine that will go through Savedlists, HOLD files,
> ST.PPROCES records, etc. and selectively delete the records that are no
> longer needed but I have been stopped by my VP.
>
> She wants justification for the process.  I don't have the knowledge to
> be able to give her what she wants.  I've tried the following arguments
> with no luck:
>
> Savedlists can be outdated as soon as they are created.
> Taking up too much server room.
>
> Any one have any others to try?
>
> - Bill Pizer
> ---
> 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] Simple OT question

[Mark Johnson]

Granted, it's RJ-45 or RJ-11 or RJ-12 depending on the number of wires. I
was just curious as we were discussing connector names for a few minutes and
came up with easily over 50 (audio, video, A/C & of course computers). The
Square-D was the one that stumped us.
Thanks.
- Original Message -
From: "Larry Hiscock" <[EMAIL PROTECTED]>
To: 
Sent: Monday, February 06, 2006 1:03 PM
Subject: RE: [U2] Simple OT question


> AC Power cord, female.  ;-)
>
> Actually, cat-5 is the name of the CABLE, not the connectors.  The
> connectors that go on cat5, cat5e and cat6 cables are called RJ-45.  db9
and
> db25 come in both male and female, as do AC power cords ;-)
>
> Larry Hiscock
> Western Computer Services
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Sunday, February 05, 2006 5:41 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Simple OT question
>
> With every computer (and other) connector having a 'name', ie cat-5, db25
> etc,
> what is the name of the female end (computer end) of the AC power cord?
>
> No joke, just curious.
>
> Thanks in advance.
> Mark Johnson
> ---
> 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] Simple OT question

[Mark Johnson]

Gracias. It sorta looks liek a square D, despite it being a brand name.

- Original Message -
From: "Gordon J Glorfield" <[EMAIL PROTECTED]>
To: 
Cc: <[EMAIL PROTECTED]>; 
Sent: Monday, February 06, 2006 10:31 AM
Subject: Re: [U2] Simple OT question


> Mark,
>
> I asked our PC techs here and they tell me it's referred to as a Square-D
> (pronounced Square Dee) connector.
>
> HTH,
> Gordon
>
>
> Gordon J. Glorfield
> Sr. Applications Developer
> MAMSI (A UnitedHealth Company)
> 301-360-8839
>
> [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM:
>
> > With every computer (and other) connector having a 'name', ie cat-5,db25
> etc,
> > what is the name of the female end (computer end) of the AC power cord?
>
> > No joke, just curious.
>
> > Thanks in advance.
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
>
>
> 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Simple OT question

[Mark Johnson]

With every computer (and other) connector having a 'name', ie cat-5, db25 etc,
what is the name of the female end (computer end) of the AC power cord?

No joke, just curious.

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

Re: [U2] Newbies need love too

[Mark Johnson]

I've found that existing systems can offer a great learning area. Perhaps
not for the best programming styles. But it's usually pretty readable and
the newbies can relate to the inside based on what's happening on the
outside.

My 1 cent
- Original Message -
From: "Wendy Smoak" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, January 31, 2006 6:35 PM
Subject: Re: [U2] Newbies need love too


> On 1/31/06, Walter Vaughan <[EMAIL PROTECTED]> wrote:
>
> > Is there not a "UniVerse for Dummies" website? Our sales rep asked his
> > programmer and he said, "I learned it 20 years ago, I don't know how you
would
> > learn it today."
> >
> > I have 23 and 28 year old programers that will have to live with this
solution
> > for the next 20 years. They're bright, but in order to get them excited
about
> > this platform I need to let them experiment.
>
> I'm not aware of any "introductory" material... you just have to dive in.
:)
>
> Have them install the Personal Edition on their development
> workstations, then go through the library of PDFs.
>
>  *
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trials
>  *
http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html
>
> It goes without saying that they should be subscribed to u2-users!
>
> --
> Wendy
> ---
> 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] Combined Print.

[Mark Johnson]

A client has thousands of TIF images on a separate server that our D3
application can instantiate a new Internet Explorer session to view with. From
that new IE session, the user can elect to print that image.

A request was made to incorporate a 50% version of that image on one half of
an 8.5x11 sheet of paper and include regular MV database output on the other
half. Any help? Exclusively HP printers with PCL-5 or 6.

Another alternative would be to cause the image to appear automatically as a
referential picture in a word document. Thus the user would have everything in
that DOC and either print using MS or email. I could create a DOC template
with an empty picture box but I would have to know how to populate it. Maybe I
should just keep a template of that document in a text file to export to the
user.

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

Re: [U2] [AD] JOB POSTING: CENTRAL NEW JERSEY [/AD]

[Mark Johnson]

Whomever replies should do a thorough analysis of this opportunity. Take it
as you wish.

- Original Message -
From: "u2ug" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Saturday, January 28, 2006 3:54 PM
Subject: [U2] [AD] JOB POSTING: CENTRAL NEW JERSEY [/AD]


> REPOSTED FOR NONMEMBER: Silver Line Windows <[EMAIL PROTECTED]>
>
> CENTRAL NEW JERSEY (LOCAL APPLICANTS ONLY)
>
> IS PROJECT MANAGER (WEB APPLICATIONS DEVELOPMENT)
>
> Silver Line Windows is one of the largest and fastest growing
manufacturers of vinyl windows and doors in the country. Our quality
products are the result of state-of-the-art engineering and manufacturing.
We have nearly 60 years of experience behind every item we produce,
DELIVERING high value results again and again from our facilities in New
Jersey, Illinois, Georgia, Ohio, Texas, Massachusetts and North Carolina. We
have been awarded the Home Depot Vendor of the Year again and again and our
North Brunswick, NJ facility has won the Window and Door Magazine's 2005
award for Most Innovative US Plant.
>
> We invite you to join in our success. The growing demand for our quality
products continues to fuel our record growth nation wide. Our record growth
requires that we add a top project manager to our world class IS team to
help take us to the next level.  The successful candidate will lead a series
of high visibility state of the art Web Base Application projects in support
of our Companys continuing growth.
>
> The ideal candidate will have a minimum of seven years experience
including at least three in project manager roles implementing Internet
Based Applications knowledge of Microsoft Internet Information Services
(IIS). Knowledge of DesignBais a strong plus. Expertise in User Interface
Design and Multi-Value Data Bases is also important.
>
> Why join Silver Line? We're the industry leader, and one of NJ's fasted
growing companies. We reward team spirit, loyalty and strong performance
with a competitive salary, medical/dental/prescription benefits, vision
discount, tuition reimbursement, profit sharing, 401k, on site cafeteria and
opportunities for career advancement.
>
>
>
> For confidential consideration, please send your resume to: Manager Plant
Recruitment, Job Code: ISPM, Silver Line Windows, 1 Silver Line Drive, PO
Box 6029, North Brunswick, NJ 08902-6029; Fax: (732) 247-9325; E-mail:
[EMAIL PROTECTED]
>
> Visit our website at: www.silverlinewindow.com
>
> EOE M/F/D/V
>
> --
>
> - 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] PROC question

[Mark Johnson]

Look for any PROCREAD or PROCWRITE statements as well in the programs.
- Original Message -
From: "John Hester" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, January 25, 2006 4:41 PM
Subject: Re: [U2] PROC question


> Bob Woodward wrote:
> > Maybe I'm just missing the finer points of PROC processing.  I've got a
> > MENU proc that's structured like this:
> >
> > PQ
> > 10 C Top of Main Menu
> > OA number of lines that display the available menu choices
> > ...
> > OEnter choice +
> > IP:
> > IF # A X
> > IF A = 1 [PROD.PL PROG1.PROC
> > IF A = 1 G 10
> > ...
> > IF A = 99 [PROD.PL PROG99.PROC
> > IF A = 99 G 10
> > O
> > O That is not a valid menu choice.
> > OPRESS [ENTER] +
> > IP
> > G 10
> >
> > My problem is when I come back from one of the PROGxx.PROC's, I'm not
> > getting the menu choice value back to execute the G 10 command.  Instead
> > it displays the error message at the bottom.
>
> As others have pointed out, the problem is likely that your input buffer
> is getting cleared.  One easy way around this is to change the structure
> of your menu proc so you don't have to worry about the input buffer
> after the call to the program proc is made.  All of our menu procs have
> this basic structure:
>
> PQ
> 10 C Top of Main Menu
> OA number of lines that display the available menu choices
> ...
> OEnter choice +
> IP:
> IF # A X
> IF A = 1 GO 100
> IF A = 2 GO 200
> IF A = 3 GO 300
> GO 10
> 100 [PROGRAM PROC
> GO 10
> 200 [PROGRAM PROC
> GO 10
> 300 [PROGRAM PROC
> GO 10
>
> We have a proc like this named BLANK.MENU that we just copy and modify
> anytime we need a new one.
>
> -John
> --
> John Hester
> System & Network Administrator
> Momentum Group Inc.
> (949) 833-8886 x623
> http://memosamples.com
> ---
> 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] U2 and MAC

[Mark Johnson]

Not for nuthin' but what would be the purpose of putting UV/UD on a Mac. I
see it as a technical challenge that can be accomplished but it doesn't seem
that practical or worthwhile. Macs are traditionally 50% more expensive than
equivilent PC, mano y mano, so what's the gain? I've owned many versions of
both from Apple I & II, Lisa, and IBM-PC, XT, Heathkits, S100's, TRS-80's to
today's P4's and Powerbooks and have kept the two families apart for their
own positive reasons.

I use my Powerbooks & G4's for video editing with Final Cut Pro and PC's for
everything else.

Just asking.
Thanks
- Original Message -
From: "Glen Batchelor" <[EMAIL PROTECTED]>
To: 
Sent: Monday, January 23, 2006 11:52 AM
Subject: RE: [U2] U2 and MAC


> Don't you mean OS-X as been available on Intel systems for 2 weeks? I find
> it impossible to believe that Apple would stoop down to Intel processor
> architecture, just to get more market share. If they DID, then I'm going
to
> go outside and wait for the pink elephants and flying pigs(not to be
> confused with Pink Floyd).
>
> ---
> Glen Batchelor
> IT Director
> All-Spec Industries
> phone: (910) 332-0424
> fax: (910) 763-5664
> e-mail: [EMAIL PROTECTED]
> ---
> www.allspec.com
> ---
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:owner-u2-
> > [EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K
> > Sent: Monday, January 23, 2006 10:01 AM
> > To: 'u2-users@listserver.u2ug.org'
> > Subject: RE: [U2] U2 and MAC
> >
> > Macs have been Available on the Intel platform for about two weeks.
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of Claus Derlien
> > Sent: Monday, January 23, 2006 3:37 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: SV: [U2] U2 and MAC
> >
> >
> > mac os x is based on bsd, but remember that its a ppc processor, so you
> > will
> > need the version of universe/unidata compiled for a ppc, or wait until
os
> > x
> > is released on an intel platform.
> >
> > best regards from denmark
> >
> > Claus Derlien
> >
> > -Oprindelig meddelelse-
> > Fra: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] vegne af Raymond DeGennaro
> > II
> > Sendt: 23. januar 2006 05:24
> > Til: u2-users@listserver.u2ug.org
> > Cc: u2-users@listserver.u2ug.org; Mark Johnson
> > Emne: Re: [U2] U2 and MAC
> >
> >
> > At 14:14 -0500 2006/01/21, Mark Johnson wrote:
> > >Isn't the underlying OS either Linux or Unix. That should be a start.
> >
> > In a nutshell, it's the best of FreeBSD, NetBSD and OpenBSD.
> >
> > Ray
> >
> > Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse -
www.f-f.dk
> >
> >
**
> > **
> > ***
> > Denne email og alle filer vedlagt som bilag kan indeholde fortroligt
> > materiale, der kun er beregnet for adressaten,
> > og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en
> > fejltagelse modtaget denne email, bedes
> > De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa
> > forhaand
> > tak.
> >
**
> > **
> > ***
> > This email and any files transmitted with it may contain confidential
> > information intended for the addressee(s) only.
> > The information is not to be surrendered or copied to unauthorised
> > persons.
> > If you have received this
> > communication in error, please notify us immediately by telephone: +45
> > 6313
> > 8550. Thank you.
> >
**
> > **
> > ***
> > ---
> > 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] U2 and MAC

[Mark Johnson]

Isn't the underlying OS either Linux or Unix. That should be a start.
- Original Message -
From: "Jerry Banker" <[EMAIL PROTECTED]>
To: 
Sent: Friday, January 20, 2006 10:17 AM
Subject: [U2] U2 and MAC


> Has there ever been a thought to put either of the U2 products on a Mac?
With
> all of the recent news about Apple making a comeback I was wondering if
there
> has ever been a thought to put a release on the MacOS.
>
> Jerry Banker
> ---
> 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] CSVs' (Different Question)

[Mark Johnson]

Where do I quote these?
I have MV basic programs that create csv's, ie
"A","B","C","12345","000123"
already.
Thanks.
- Original Message - 
From: "Kevin King" <[EMAIL PROTECTED]>
To: 
Sent: Monday, January 16, 2006 10:08 AM
Subject: RE: [U2] CSVs' (Different Question)


> To get Excel to keep the leading zeroes when importing a CSV, quote
> the value, aka:
> 
> ="012345" 
> ---
> 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] CSVs' (Different Question)

[Mark Johnson]

Subject: Exporting leading zero fields in csv.

I have been exporting from MV to CSV for years and one of my pet peeves is
that leading zero fields, like customer numbers, product codes and zip codes
lose their leading zeros when the csv is opened in Excel.

I will save everyone the trouble with prior suggestions by illustrating what
hasn't worked yet. I've tried exporting as simple HTML but null cells don't
get the proper frames. I've tried prepending a single quote but the single
quote appears as data in Excel. I've also tried pre/append a single space but
it still loses the leading zeros.

I've noticed that when manually entering a value in Excel with a leading
single quote, it retains the leading zeros. But when the CSV cell is  "'07748"
it keeps '07748.

I know that the user can re-format the cell to be zip code or custom but that
gives the impression that the main system can only do part of the job. I also
know that if the user is in Excel, they can import the TXT file and follow the
import wizard to change the column's style to TEXT and not GENERAL. Again,
this puts the burden on the users.

HTML retains the value and the missing frames on null cells is okay but the
users are used to clicking on the filename in Windows Explorer and HTML 'opens
with' Internet Explorer. Great for viewing but not useful if they desire any
data manipulation in excel.

I am not versed in java or perl but if they can accomplish the job then maybe
I'll learn them. I don't mind having the difficult part be on my side (MV) as
long as the users get their simplicity.

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

Re: [U2] PROC Question

[Mark Johnson]

One final oft-seen PROC thing.

You can have a PROC that has statement labels within have those statement
sections referenced individually from the outside.

Example
PROX AAA
PQN
100 T "HERE AT 100"
X
200 T "HERE AT 200"
X
300 T "HERE AT 300"
X

and have calling PROCS likewise:

[PROX AAA] 100
(some other proc statements)
[PROX AAA] 200
(some other proc statements
[PROC AAA] 300

So it's like haveing a library of SUBs in one place.

My 1 cent.
Mark Johnson
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, January 11, 2006 2:50 PM
Subject: RE: [U2] PROC Question


> Thanks, everyone.  I got exactly the answer I was afraid I would get.
> Yes, my mind is fried...  
>
> Because of system programming standards, I need to stay with a PROC but
> I was hoping to be able to streamline them a little bit.
>
> I appreciate the answers everyone offered, including the ones to quit
> using PROC's (and the thought has crossed my mind a number of times) but
> for the most part, we keep the PROC's pretty simple.
>
> Again, thanks.
>
> BobW
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
> Sent: Wednesday, January 11, 2006 9:35 AM
> To: U2-Users List
> Subject: [U2] PROC Question
>
> Hi folks,
>
> I can't find anything in the IBM Doc's for ProVerb's that tells me how
> to create an entry that will allow me to put multiple commands on a
> single line.  In a nutshell, from a "menu" when a user selects an
> option, I want to be able to execute multiple commands.
>
> Currently, I use multiple lines such as:
>IF A = 5 [USER.PL BASIC.PGM1
>IF A = 5 [USER.PL BASIC.PGM2
>IF A = 5 G 10
>
> What I want to be able to do is:
>IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10
>
> Is my mind fried?  Maybe...  But is there something that will work?
>
> BobW
> ---
> 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] PROC Question

[Mark Johnson]

Microdata allows multiple lines on PROCS, and I used to be very good at PQN
procs but I don't recall the syntax.

I would stay with the offered suggestions.
My 1 cent
- Original Message -
From: "Bill Haskett" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, January 11, 2006 1:35 PM
Subject: RE: [U2] PROC Question


> Bob:
>
> I used to be pretty proficient in PROC and have never heard of this...but
> that doesn't mean it doesn't exist.  :-)
>
> Bill
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
> > Sent: Wednesday, January 11, 2006 9:35 AM
> > To: U2-Users List
> > Subject: [U2] PROC Question
> >
> > Hi folks,
> >
> > I can't find anything in the IBM Doc's for ProVerb's that
> > tells me how to create an entry that will allow me to put
> > multiple commands on a single line.  In a nutshell, from a
> > "menu" when a user selects an option, I want to be able to
> > execute multiple commands.
> >
> > Currently, I use multiple lines such as:
> >IF A = 5 [USER.PL BASIC.PGM1
> >IF A = 5 [USER.PL BASIC.PGM2
> >IF A = 5 G 10
> >
> > What I want to be able to do is:
> >IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10
> >
> > Is my mind fried?  Maybe...  But is there something that will work?
> >
> > BobW
> > ---
> > 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] DCOUNT

[Mark Johnson]

Thanks for all that responded.

It was not a trick or underhanded question. It was just one of those days
when I had programmed DCOUNT about a zillion times and I was wondering if
there was any shortcut. It's better than the COUNT function that actually
counts something different.

I agree that having FOR I=1 to DCOUNT is not a problem with the small counts
but dare not consider it as my conscience (the U2 Forum) would frown on it.

I've learned a lot from this forum despite my decades of experience as I
have not transversed every possible style of coding. My personal collection
of styles is gleened from that vast experience of inheriting both good and
bad code examples and keeping the best.

Thanks
Mark Johnson
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To: 
Sent: Friday, January 06, 2006 11:42 AM
Subject: RE: [U2] DCOUNT


> Correct me if I'm wrong but does this method not require the DCOUNT
> function to be executed each iteration of "I" to determine if you have
> reached your max value?  Granted, for a small number of values it would
> not be that much of a hit but I'd not like to encourage this on the off
> chance that you use it on a large number of values somewhere else.
>
> BobW
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Serguei
> Sent: Friday, January 06, 2006 6:02 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] DCOUNT
>
> I personally would even write it like this if I am sure the number of
> values
> is no more then ten:
> FOR I=1 TO DCOUNT(REC<15>,@VM)
>
> (and of course I would not use number as a field position)
> ---
> 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] DCOUNT

[Mark Johnson]

I'm finding that I'm doing a lot of programming for the processing through
multi-valued attributes.

I'm wondering if the method I'm using is the best way to determine the last
element.

LAST=DCOUNT(REC<15>,@VM)
FOR I=1 TO LAST
(process something)
NEXT I

There was a REMOVE thread a few months ago and I use that when I expect that
the number of elements could test the patience of the EXTRACTs. REMOVE doesn't
give you the MV counter for the associated fields by itself. You have to
manage separately and hope to keep in sync. That's more code.

I know that in VB certain object array variables (a list box for example) has
a property for the number of elements. Is there anything in MV that I'm not
aware of for determining the last multi-value that's easier to type than the
DCOUNT expression. I'm looking at reducing my keystrokes.

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

Re: [U2] Converting number to word

[Mark Johnson]

I wish that this Check Print Amount routine were standard MV-issue instead
of home grown.

On that topic, there is a user exit for converting a number to a roman
numeral. For sales reports to the branch offices in Italy.

My 1 cent.
- Original Message -
From: "Bruce Nichol" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, January 05, 2006 12:12 AM
Subject: Re: [U2] Converting number to word


> Goo'day, David,
>
> Dick Pick's gift to the world:
>
> At 15:24 05/01/06 +1100, you wrote:
>
> >Happy New Year,
> >
> >A current project involves printing a number string in its alphabetic
> >description e.g. 1 = one, 3 = three, 11 = eleven etc etc. The precise
task
> >is printing a label of book information and in this case the label is
> >"edition" e.g. first/second.
> >
> >The universe basic manual does not appear to provide a conversion code as
> >in "MCN" etc ; would someone know of a UV code or algorithm that
> >converts these strings?
> >
> >Regards
> >
> >David Knight
> >---
> >u2-users mailing list
> >u2-users@listserver.u2ug.org
> >To unsubscribe please visit http://listserver.u2ug.org/
>
>
> Just add "TH" to everything above "THREE" and replace ONe TWO THREE with
> FIRST SECOND THIRD... (I think)
>
> And discard the cents!
>
>
> 0001: SUBROUTINE(N,S)
> 0002: S= ''; IF NUM(N) ELSE RETURN
> 0003: N = N'R26%12'
> 0004: FOR I = 1 TO 7 STEP 3
> 0005:  X = N[I,3]
> 0006:  SX = ''
> 0007:  IF X > 99 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN
> EIGHT
>   NINE',' ',X[1,1]):' HUNDRED'
> 0008:  X = X[2,2]
> 0009:  IF X > 0 AND SX # '' THEN SX = SX:' &'
> 0010:  IF X > 0 AND SX = '' AND S# '' THEN SX = ' &'
> 0011:  IF X > 19 THEN SX = SX:' ':FIELD(' TWENTY THIRTY FORTY FIFTY SIXTY
> SEVENTY EIGHTY NINTY',' ',X[1,1]); X = X[2,1]
> 0012:  IF X >  0 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN
> EIGHT NINE TEN ELEVEN TWELVE THIRTEEN FOURTEEN FIFTEEN SIXTEEN SEVENTEEN
> EIGHTEEN NINETEEN',' ',X)
> 0013:  IF SX # '' THEN S = S:SX:FIELD(' MILLION... THOUSAND','.',I)
> 0014: NEXT I
> 0015: IF S = '' THEN S = 'ZERO'
> 0016:  IF S = ' ONE' THEN TEXT = ' DOLLAR ' ELSE TEXT = ' DOLLARS '
> 0017: S = S:TEXT
> 0018: IF N[11,2] = 0 THEN
> 0019:  S = S:'ONLY'
> 0020: END ELSE
> 0021:  IF N[11,2] > 9 THEN
> 0022:   S = S:N[11,2]:'/100'
> 0023:  END ELSE
> 0024:   S = S:'& ':N[11,2]+0:' CENT'
> 0025:   IF N[11,2] > 1 THEN S= S:'S'
> 0026:  END
> 0027: END
> 0028: RETURN
>
>
>
>
>
> >--
> >No virus found in this incoming message.
> >Checked by AVG Anti-Virus.
> >Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 03/01/06
>
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURYNSW 2640
> Australia
>
> http://www.taloncs.com.au
>
> Tel: +61 (0)411149636
> Fax: +61 (0)260232119
>
> If it ain't broke, fix it till it is!
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 03/01/06
> ---
> 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] New Year

[Mark Johnson]

Here's to everyone having a prosperous new year.
Thanks for last year.
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UD: Named common

[Mark Johnson]

Having lived through the entire DOS world and before, I welcomed long
filenames when Bill got around to them. We've had them in Pick since day one
(or two) and clearly before Mr. Gates started with 8.3.

While numerically there are 8 billion (I'll take your word on that although
I know how to derive, Minesweeper anyone?), the real trouble was two-fold.
First, you either had to have an external table to help with the definitions
of the 8 digits or you had to un-do the abbreviations.

If you assigned sequential values, ie BUD1.XLS (sic) or SLS01.XLS
you would have to know what the numbers meant, ie an external reference. If
you tried to abbreviate, you ran into "1987 Actual vs Budget" spreadsheet as
ACTBUD87.XLS and it gets pretty tricky. And forget about program names. I've
got dozens of Quick Basic apps written under the 8.3 guidelines and since
the 3 was usually BAS, you weren't given much abbreviation room.

Perhaps the big difference is that while an older environment could have
hundreds of spreadsheets or basic programs, a MV system probably won'd have
but a few names common entities.

My 1 cent.
Mark Johnson
- Original Message -
From: "David Wolverton" <[EMAIL PROTECTED]>
To: 
Sent: Monday, December 26, 2005 10:21 PM
Subject: RE: [U2] UD: Named common


> At this moment and time, that would be true... But how many unique
> combinations of 7 characters can be created? 26 to the 7th power? (if we
> exclude numerics, anyway!)  So far, 8 billion+ choices has been enough
> leeway for us to work within - But it is a hard limit -- we just truncated
> our Common Group labels to meet the requirement, and moved the 'unique'
> attributes to the FRONT of the common block labels.
>
> DW
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Monday, December 26, 2005 9:05 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] UD: Named common
>
> Is it true UniData named common cannot have a label longer than 7
> characters?  Is this a paleozoic joke or is it a PICK basic type thing?
> "Onward & Upward".  :-)
>
> Thanks.
>
> 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Using Esc

[Mark Johnson]

This is exactly what I'm talking about. No offense to whomever wrote the
keyboard mapping program, but it deviates from our real goals of application
programming.
My 1 cent.
- Original Message -
From: "Jacques G." <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, December 20, 2005 11:58 AM
Subject: Re: [U2] Using Esc


> > I am sick of having to
> > write filter routines for
> > the control characters. It doesn't look good to the
> > users either.
>
> On the plus side, many terminal emulators can have
> their keyboard re-programmed so that when you press a
> key it sends the key that you want.  I've used this
> feature to send the proper arrow escape sequences on
> bad VT220 emulators.  Once the terminal emulator is
> properly configured the setup file for it can become
> part of the standard installation procedure for the
> user. So if the escape key sends CHAR(251), it can be
> changed on the emulator without writing new code.
>
> I know that Hostaccess and Hummingbird allow for
> keyboard re-programming.  I've used Accuterm before
> but don't remember if you can re-program its keyboard
> as well.
>
> On my emulator, I've configured F12 to do:  S^M so
> that when I step through the debugger I only need to
> press one key.
>
> __
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> ---
> 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] Using Esc

[Mark Johnson]

> I worked with a client a while back and their
> application only used the BASIC INPUT statement.  This
> caused some garbage data to occasionnally appear in
> their files.


I can honestly say that over 95% of my client's programs are INPUT ANS. Some
have INPUT ANS,5 or INPUT ANS,5: or INPUT ANS,5:_ or even INPUT ANS:. Of
these, my preference is INPUT ANS,5:_.

One client with The Programmer's Helper has an Input subroutine but it
doesn't appear to recognize the arrow keys. It does filter control
characters.

Like always, it's left to the individual programmer. Thus goes any help.

My 1 cent.
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Using Esc

[Mark Johnson]

Despite the progress made with conversions from green screen to GUI, my
client base for example is virtually 100% green screen. I've been adding a
few Accuterm GED programs but not to any huge extent.

I believe that the providers should catch up with the times, especially
Raining Data and IBM. They should recognize that the conversions from green
screen to GUI do not happen overnight and it is truly an extremely large
undertaking to consider re-writing legacy code for a gui interface. I'm not
talking about re-developing the apps, just trying to make them a little more
modern.

One client would like their legacy Order Entry app re-written in a GUI
interface. I'm truly afraid that my cost for this project will be
prohibitive and that it may never happen. Thus adds another frustration.

Nothing embarrasses me more than having to explain to a client's new
employee that they have to re-type the whole answer if they spelled Apt 4B
instead of Apt 4A on a long address line. That tiny piece of time starts off
their relationship on a tremendous backwards note. Granted we know that the
apps are sophisticated underneath. But the employee's shrugging shoulders
speaks volumes.

Perhaps what I'm hearing is that RD & IBM will turn their back on this
concept and, like many things, it's in my hands. So I'll re-deploy my
GET.ANS() subroutine and try to tweak it for my different client's
environments. Most users are not cut & paste oriented. They just want to get
to the end of 123 East South Street NW, Apt 4B and replace the B with an A.
I don't blame them for condemming the application (and thus the database)
with such a tired user interface.

MS QuickBasic didn't provide any  kind of INPUT
statement. It actually provided too many INPUT formats so I had to write my
own. Fortunately there were no terminal emulations or other 'environments',
just DOS.  Now, anyone programming with VB doesn't concern themselves one
bit with these shortcomings. It's part of the environment.

My 2 cents.
Mark Johnson
- Original Message -
From: "Brian Leach" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, December 20, 2005 7:22 AM
Subject: Re: [U2] Using Esc


> Mark,
>
> AFAIR UV does provide cursor driven input - see the Input @, KeyEdit and
KeyTrap statements. It is however pretty horrible.
>
> You can't blame the vendors for this one though. The problem has been the
mindset of a community that hasn't shared code (how many virtually identical
menu runners or input subroutines have I seen over the years) even though
the runtime binding model of external subroutines makes it so easy...
>
>  I doubt the vendors would be interested in extending a 20 year old text
interface when you can download the free VB 2005 Express, UO.Net and do it
all properly ...
>
>
> Brian
>
>
> -Original Message-
> From: "Mark Johnson"<[EMAIL PROTECTED]>
> Sent: 19/12/05 05:25:10
> To: "u2-usChis case MS got it right. Every input behaves very much
like every other
> with the special keys.
>
> I believe that this should be accomplished by the providers
themselves, ie
> Raining Data and IBM in their future releases. They already interpet
the
> TERM setting and it would remove the differences. I took my GET.ANS
and
> tried to fit it on Accuterm and couldn't get the proper backspace.
> ---
> 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] Small FootPrint MultiValue

[Mark Johnson]

Not for nothin' but whenever I install D3 on a box, it seems to take around
5 seconds. Noticably shorter than any MS office product. If that qualifies
as a small footprint.

My 1 cent.
- Original Message -
From: "Andy Pflueger" <[EMAIL PROTECTED]>
To: 
Sent: Monday, December 19, 2005 11:32 AM
Subject: Re: [U2] Small FootPrint MultiValue


> On 12/19/05, Brutzman, Bill <[EMAIL PROTECTED]> wrote:
> > Aside from U2 Personal Edition, are there any multi-value products like
say
> > IBM's CloudScape that do multi-value?
> >
>
> There's always the open-sourced solution which does have a commercial
> version. Details found at www.openqm.com courtesy of LadyBridge
> Systems. :)
>
> --
> The Linux philosophy is 'Laugh in the face of danger'.
> Oops. Wrong One. 'Do it yourself'. Yes, that's it.
> Linus Torvalds
> ---
> 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] Using Esc

[Mark Johnson]

That is the one thing that is the most Jurrasic about MV systems, the INPUT
statement. It's a shame that it needs so many home-grown methods that try to
match with the language's IN or GET statements with the specific emulator's
expressions of the characters being typed (and filtered).

I wish the emulators themselves included a platform specific subroutine that
could be easily edited as a replacement for the INPUT statements. I have
successfully created a Wintegrate version emulating Adds-VP but there are so
many combinations. GET.ANS()

I know that some VAR's have developed their own configurable subroutines and
attempted to emulate the very consistent Microsoft Textbox input scenario.
In this case MS got it right. Every input behaves very much like every other
with the special keys.

I believe that this should be accomplished by the providers themselves, ie
Raining Data and IBM in their future releases. They already interpet the
TERM setting and it would remove the differences. I took my GET.ANS and
tried to fit it on Accuterm and couldn't get the proper backspace.

I'm not looking for code solutions now so please do not provide. I'm just
suggesting that this 15 year old pursuit for a consistent INPUT interface be
drawn to a close by the providers and not downstream by the VARs or
individual programmers. Gone is the day where an employee's first brush with
a keyboard is our old clunky Wyse-50. Virtually every new employee is coming
from the MS interface and I am sick of having to write filter routines for
the control characters. It doesn't look good to the users either.

My 2 cents.
Mark Johnson
- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: 
Sent: Monday, December 19, 2005 2:04 PM
Subject: Re: [U2] Using Esc


> Bill,
> Try CRT'ing the ASCII value of ANS to see what Esc is reporting as
> on this system. I have see 27 (typical), 251, and even 21 on some other
> terminal emulators.
>
> - Chuck
>
> >The following code does not behave as intended.
> >
> >  Esc = char(251)
> >
> >  begin case
> >case Ans = ''   ;  null
> >case Ans = Esc  ;  return
> >  end   case
> >
> >On the screen displays the characters...^[  appear.
> ---
> 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] Deciphering Pick UniBasic statement

[Mark Johnson]

> I've worked with a client who purchased a package some
> years back and they only have the binaries.  If the
> supplier ever goes out of business they are in
> trouble.


I must offer my opinion here on VAR-delivered object-code only systems.

If I had any say in such a situation, I would require that the VAR place the
source code that matches my purchased (licensed) system in escrow or some
3rd party place. I've run into a few prospective client situations that I
could not turn into actual clients as I had nothing to work with.

When the relationship is active or current, it's a nice deal for both the
VAR and the client. The client gets current updates etc and the VAR has a
locked in client. But when the VAR goes out of business, the client has a
system with no source code and eventually it screws the entire MV community
as in all of my examples, the replacement system wasn't MV-based.

I don't want to digress into a debate on the merits of software licensing
etc. That gets too out of hand. But when a VAR goes out of business and
leaves no source code behind. No-one wins.

Perhaps anyone in this current situation should re-negotiate the terms of
their relationship with an application VAR who doesn't provide the source
code. Otherwise, if the VAR folds, you're screwed.

One VAR pulling a similar deceitful move removed from all of the
dictionaries those dict items that weren't part of any English reports or
Select statements. Think about it, if field 39 is used only in data/basic
programs, it really doesn't need to have a dict item to work. I've spent
many hours (and my client's $) backfilling missing dict items from source
code.

Likewise for source code with comments removed. If this were 1984 we would
all have to play it a little closer. But it's 2005 and we should stick
together because it really is MV versus other databases and not UD versus UV
or MCD vs ULT or ADDS vs Sanyo etc. United we stand..

My 2 cents.
Mark Johnson



- Original Message -
From: "Jacques G." <[EMAIL PROTECTED]>
To: 
Sent: Sunday, December 11, 2005 11:31 AM
Subject: RE: [U2] Deciphering Pick UniBasic statement


> > Caleb's. It could take days to unravel the code by
> > hand versus the few
> > minutes needed to send it out to www.srs4uv.com.
>
> From one horror story I read on the site about a
> programmer that had sabotaged source code:
>
> "The company used the SRS on the object code they were
> running. In addition, they compiled the suspect source
> code and used the SRS on that set. By comparing the
> two source code result sets they figured out which
> programs had been sabotaged."
>
> Why not simply compare the binaries ?  Unix has a
> small program called: "cmp" that can compare two files
> and Windows has "comp".
> You can tell which ones have been changed that way.
>
> You can also know when the files were last compiled by
> looking at the dates with ls -al on the binary.
>
> Still I think the decompiler can be a useful tool.

>
>
> __
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> ---
> 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] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?

[Mark Johnson]

Not for nothing but I've worked on both platforms and I prefer Ud to Uv.
My 1 cent
- Original Message -
From: "Ken Wallis" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, December 01, 2005 11:07 PM
Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery
keyword?


> To all you UniVerse experts out there.
>
> A site I know is moving from UniData on VMS to UniVerse on UNIX.  Don't
ask
> why, they just decided that was the path they wanted to go down.  Anyhow,
> they've got used to the ability in UniData to LIST filename ALL and see
> everything.  They're a bit surprised that this doesn't work in UniVerse.
> Any ideas?
>
> Of course we could write them a BASIC program called LIST that scans the
> command for the keyword ALL and if it finds it, works out what ALL means
in
> the context of that file before invoking the real UniVerse LIST with a
> modified command, but I'd like to exhaust other options first.
>
> Cheers,
>
> Ken
>
>   ALL
>
>   Syntax
>
>   ... filename ALL
>
>   Description
>
>   The UniQuery ALL keyword displays every data (D-type) attribute defined
in
> the dictionary of filename. ALL does not display virtual (V-type)
> attributes.
>
>   Example
>
>   In the following example, the ALL keyword lists every D-type attribute
in
> the INVENTORY file:
>
>   :LIST INVENTORY ALL
>
>   LIST INVENTORY ALL 10:25:34 Mar 25 1999 1
>
>   Product Number 15001
>   Inventory Date 08/20/1995
>   Inventory Time 01:00PM
>   Product Name Modem
>   Features 14.4K Internal V34
>   Color Quantity Price Reorder
>   N/A 7486 $119.00 40
>   Product Number 35000
>   Inventory Date 07/09/1995
>   Inventory Time 10:00AM
>   Product Name Speaker
>   Features 250W, Direct/reflecting
>   Color Quantity Price Reorder
>   Black 148 $198.93 50
>   Charcoal 125 $198.93 50
> ---
> 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] USB printer on D3

[Mark Johnson]

I have D3 installed on an Windows Xp system. I have a HP 1020 LaserJet printer
(USB) that works fine on the windows side.

I've properly created the device with 1 page eject. I have the printer folder
open and when I send a print-job, I hear the wheels spinning on the printer
but nothing comes out. I've appended 2-3 char(12)'s to the end of the job to
kick it but to no avail.

When I go to windows and print a test page, that job waits until I power-down
the printer. The D3 job disappears and the test page comes out.

Any suggestions?
Thanks in advance.
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] 20 Digit Number

[Mark Johnson]

I was intending to make it easy on myself when having to enter these 20
digit numbers with my fingers when reading them on a printed paper.

Thanks for all who replied.
Happy Thanksgiving.
Feliz dia de pabo.
Mark Johnson
- Original Message -
From: "John Jenkins" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, November 23, 2005 4:05 AM
Subject: RE: [U2] 20 Digit Number


> Simplistic view maybe - but what about good old-fashioned BCD (Binary
Coded
> Decimal)?
>
>  Value  Comp-3, hex
>+0   0C
>+1   1C
>   +1201 2C
>  +12312 3C
> +1234 01 23 4C
>-1   1D
> -1234 01 23 4D
>
>
> Here's a useful link...:
> http://www.discinterchange.com/TechTalk_COBOL_comp_.html
>
> Take a look at COMP-3.
>
> Alternative BCD/packed decimal schemas use the concept of an "Overpunch"
to
> indicate negative numbers as some bit patterns are never used for digits:
>
>  (0); 0001 (1) -> 1001 (9)
>
>
> Regards
>
> JayJay
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: 20 November 2005 05:14
> To: u2-users@listserver.u2ug.org
> Subject: [U2] 20 Digit Number
>
> General Question. A client has just taken on a new major customer and we
> have
> to keep track of their product codes. These codes are 20 numbers long with
> no
> real prefixing, suffixing or patterns.
>
> Is there any way to abbreviate numbers. I know this is a weird question
but
> I
> know that I may be entering these codes manually during the testing and/or
> installation phase of this project and 20 numbers is a lot of typing.
>
> I've run out of ideas that simplify as most tend to complicate matters.
The
> users will eventually be using bar code, scanning off of printed
documents.
> As
> I develop, I will not have that benefit.
>
> I can calculator-enter numbers pretty effeciently given my accounting
> background. But 20 digits is a lot.
>
> I'm open to any ideas even if to know there are none.
>
> Thanks in advance.
> Mark Johnson
> ---
> 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: Fun with Robots (was: FW: [U2] 20 Digit Number)

[Mark Johnson]

Bar codes tend to be long as well. For UPC, the first section may be
repetitive, thus can be omitted.

I'm dealing with 20 digit numbers of no apparent syntax. They belong to my
client's external customer.

My request was a way to hand-type less than 20 to get 20 without a
cheat-sheet or other short-cuts. I thought your original post had
encryptions stored somewhere.

Sorry for the confusion
Mark Johnson
- Original Message -
From: "Ross Morrissey" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, November 22, 2005 12:28 PM
Subject: Fun with Robots (was: FW: [U2] 20 Digit Number)


> I'm not sure what you mean - there was no encryption in this app.
>
> Data entry applied barcodes to film canisters.  The film sorting robot
read
> the barcode and passed it (through &DEVICE& - what fun) to a routine that
> looked up order characteristics (e.g. 2 sets of 4x6 prints, slides, CD,
> express shipping) and calculated a bin number and returned the bin value
to
> the robot.  If the robot didn't hear back in less than .05 seconds, it
> defaulted to an error bin.  The robot then dropped the roll into the
target
> bin (actually it spun a J-shaped tube on a carousel the size of a
Volkswagen
> and blasted the film down the tailpipe with a burst of compressed air).
>
> Testing this was similar to your issue of typing in long barcodes.  I
needed
> to "type" in thousands of barcodes and validate the results against (table
> driven) business logic changes - i.e. sort "express" and "retail"
together.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Sunday, November 20, 2005 8:29 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] 20 Digit Number
>
> So what was the secret and was it human-able. I can code anything. I can't
> encrypt in my head that well.
>
> Thanks.
> - Original Message -
> From: "Ross Morrissey" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, November 21, 2005 1:24 PM
> Subject: RE: [U2] 20 Digit Number
>
>
> > I worked on the back end system for a film sorting robot.  It read
> barcodes
> > off 35mm film cartridges and I had to generate a bin number based on
> > some complex logic.  I put the logic in a subroutine, made an
> > I-descriptor-callable shell, then wrapped it in a paragraph that
> > allowed me
> > to test against tens of thousands of historical transactions to give
> > any code changes a real workout.  No barcodes typed, and as a bonus,
> > the logic was easily re-deployed to a manual interface later on.
> >
> > Thanks, Ross.
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> > Sent: Saturday, November 19, 2005 9:14 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] 20 Digit Number
> >
> > General Question. A client has just taken on a new major customer and
> > we have to keep track of their product codes. These codes are 20
> > numbers long with no real prefixing, suffixing or patterns.
> >
> > Is there any way to abbreviate numbers. I know this is a weird
> > question
> but
> > I know that I may be entering these codes manually during the testing
> and/or
> > installation phase of this project and 20 numbers is a lot of typing...
> ---
> 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] Swapping OS

[Mark Johnson]

Test a few programs before compiling every program en masse. We went to 5.2
a few years ago and some of the more cryptic code containing FILE defining
Include equates caused some run time errors. Things like "Line 587, Variable
not assigned a value, Zero used" and line 587 was an END.

It was on Sun. Bob Wyatt may have more info on the Pantone conversion of
2001.

Thanks
Mark Johnson
- Original Message -
From: "Dave R" <[EMAIL PROTECTED]>
To: 
Sent: Monday, November 21, 2005 6:03 PM
Subject: Re: [U2] Swapping OS


> If you going from Unidata to Unidata I would think it would be a straight
> account save to an account restore, with a recompile of your basic code
(if
> you have source code). The resetting, workstations and printers,
>
>
> D Raven
> [EMAIL PROTECTED]
> cell (949)2282224
> e Fax (815)4259364
> P.O. Box 17811, Irvine CA 92623-7811
>
> -- "Steven Frost" <[EMAIL PROTECTED]> wrote:
> Hi - we are looking at the feasibility of switching our Unidata 5.2
platform
> from Tru64 to HPUX ( 64bit)
> has anyone done this before? I am assuming it wouldnt be a straight data
and
> code migration.
>
>
> Steven Frost
>
> POWERCO
> 35 Junction Street
> Private Bag 2004
> New Plymouth
> New Zealand
>
> Helpdesk  0800491491
> DDI:  +64 6 759 6583
> Fax:  +64 6 759 6253
> Mob:  +64 274 403940
> Email:[EMAIL PROTECTED]
> Web:  www.powerco.co.nz
>
>
>

#
> 
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal
>

#
> 
>
>

*
> ***
> CAUTION: This email and any attachments may contain information that is
> confidential.  If you are not the intended recipient, you must not read,
copy,
> distribute, disclose or use this email or any attachments.  If you have
> received this email in error, please notify us and erase this email and
any
> attachments.  You must scan this email and any attachments for viruses.
> DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or
other
> consequences, whether caused by its negligence or not, resulting directly
or
> indirectly from the use of this email or attachments or for any changes
made
> to this email and any attachments after sending by Powerco Limited.  The
> opinions expressed in this email and any attachments are not necessarily
those
> of Powerco Limited.
>
>

*
> ***
> ---
> 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] 20 Digit Number

[Mark Johnson]

So what was the secret and was it human-able. I can code anything. I can't
encrypt in my head that well.

Thanks.
- Original Message -
From: "Ross Morrissey" <[EMAIL PROTECTED]>
To: 
Sent: Monday, November 21, 2005 1:24 PM
Subject: RE: [U2] 20 Digit Number


> I worked on the back end system for a film sorting robot.  It read
barcodes
> off 35mm film cartridges and I had to generate a bin number based on some
> complex logic.  I put the logic in a subroutine, made an
> I-descriptor-callable shell, then wrapped it in a paragraph that allowed
me
> to test against tens of thousands of historical transactions to give any
> code changes a real workout.  No barcodes typed, and as a bonus, the logic
> was easily re-deployed to a manual interface later on.
>
> Thanks, Ross.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Saturday, November 19, 2005 9:14 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] 20 Digit Number
>
> General Question. A client has just taken on a new major customer and we
> have to keep track of their product codes. These codes are 20 numbers long
> with no real prefixing, suffixing or patterns.
>
> Is there any way to abbreviate numbers. I know this is a weird question
but
> I know that I may be entering these codes manually during the testing
and/or
> installation phase of this project and 20 numbers is a lot of typing.
>
> I've run out of ideas that simplify as most tend to complicate matters.
The
> users will eventually be using bar code, scanning off of printed
documents.
> As I develop, I will not have that benefit.
>
> I can calculator-enter numbers pretty effeciently given my accounting
> background. But 20 digits is a lot.
>
> I'm open to any ideas even if to know there are none.
>
> Thanks in advance.
> Mark Johnson
> ---
> 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] 20 Digit Number

[Mark Johnson]

Thanks to all. I'm feeling good that my original assumption of abbreviating
wasn't going to work. I appreciate all the different methods of entering.
One will rise to the top. I'll post later.

Thanks.

- Original Message -
From: "Drew Henderson" <[EMAIL PROTECTED]>
To: 
Sent: Monday, November 21, 2005 8:02 AM
Subject: Re: [U2] 20 Digit Number


> Mark,
>
> If you have specific numbers, or just need to have 20-digit numbers for
> testing, you can always generate several pages with the numbers and
> their associated bar-codes on them, allowing you to scan them in.
>
> Drew
>
> Mark Johnson wrote:
>
> >General Question. A client has just taken on a new major customer and we
have
> >to keep track of their product codes. These codes are 20 numbers long
with no
> >real prefixing, suffixing or patterns.
> >
> >Is there any way to abbreviate numbers. I know this is a weird question
but I
> >know that I may be entering these codes manually during the testing
and/or
> >installation phase of this project and 20 numbers is a lot of typing.
> >
> >I've run out of ideas that simplify as most tend to complicate matters.
The
> >users will eventually be using bar code, scanning off of printed
documents. As
> >I develop, I will not have that benefit.
> >
> >I can calculator-enter numbers pretty effeciently given my accounting
> >background. But 20 digits is a lot.
> >
> >I'm open to any ideas even if to know there are none.
> >
> >Thanks in advance.
> >Mark Johnson
> >---
> >u2-users mailing list
> >u2-users@listserver.u2ug.org
> >To unsubscribe please visit http://listserver.u2ug.org/
> >
> >
>
>
> --
> --
> Drew Henderson "There are two types of people -
> Dir. for Computer Center Operations those who do the work and those
> [EMAIL PROTECTED] who take the credit. Try to be
> in the first group, there is
> 110 Ginger Hall less competition."
> Morehead State University   Indira Ghandi
> Morehead, KY  40351
> Phone: 606/783-2445   Fax: 606/783-5078
> --
> ---
> 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] 20 Digit Number

[Mark Johnson]

It's the customer's carton numbers. We get an EDI document containing
hundreds of them that get imported into the application. As normal, the
client wants tracking down to the carton level (ie, received, shipped,
received, errors, mis-matches).

The users will eventually get printed tally sheets with the cartons bar
coded. But for now, it's me and my fingers. The notepad idea looks good.

Thanks.
- Original Message -
From: "Brian Leach" <[EMAIL PROTECTED]>
To: 
Sent: Monday, November 21, 2005 4:51 AM
Subject: RE: [U2] 20 Digit Number


> Mark,
>
> How are these numbers originated? It is rare for such complex numbers to
be
> produced entirely randomly. How are you being supplied with the numbers to
> use for testing? Are they being printed out for you? If so, from where -
and
> could they be transmitted or OCR'ed?
>
> More background please...
>
> Brian
>
> > -Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> > Sent: 20 November 2005 05:14
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] 20 Digit Number
> >
> > General Question. A client has just taken on a new major
> > customer and we have to keep track of their product codes.
> > These codes are 20 numbers long with no real prefixing,
> > suffixing or patterns.
> >
> > Is there any way to abbreviate numbers. I know this is a
> > weird question but I know that I may be entering these codes
> > manually during the testing and/or installation phase of this
> > project and 20 numbers is a lot of typing.
> >
> > I've run out of ideas that simplify as most tend to
> > complicate matters. The users will eventually be using bar
> > code, scanning off of printed documents. As I develop, I will
> > not have that benefit.
> >
> > I can calculator-enter numbers pretty effeciently given my
> > accounting background. But 20 digits is a lot.
> >
> > I'm open to any ideas even if to know there are none.
> >
> > Thanks in advance.
> > Mark Johnson
> > ---
> > 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] 20 Digit Number

[Mark Johnson]

That's cool. I think it'll work. Maybe not for everything but I can post to
Notepad and work backwards.
- Original Message -
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: 
Sent: Monday, November 21, 2005 1:44 AM
Subject: RE: [U2] 20 Digit Number


> Assuming you are using a windows PC, have the codes in a NOTEPAD
> document & just cut/paste as required
>
> >-Original Message-
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> >Sent: Monday, 21 November 2005 4:32 PM
> >To: u2-users@listserver.u2ug.org
> >Subject: RE: [U2] 20 Digit Number
> >
> >Depends on the application.  If you're entering it into your
> >own application, patch your account number validation routine
> >such that allows you to do whatever abbreviations you want:
> >"A" could equal "123456763245435425324324" and that would be
> >easy enough to do and would save you boatloads of time in testing.
> >
> >-Original Message-
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> >Sent: Saturday, November 19, 2005 10:14 PM
> >To: u2-users@listserver.u2ug.org
> >Subject: [U2] 20 Digit Number
> >
> >General Question. A client has just taken on a new major
> >customer and we have to keep track of their product codes.
> >These codes are 20 numbers long with no real prefixing,
> >suffixing or patterns.
> >
> >Is there any way to abbreviate numbers. I know this is a weird
> >question but I know that I may be entering these codes
> >manually during the testing and/or installation phase of this
> >project and 20 numbers is a lot of typing.
> >
> >I've run out of ideas that simplify as most tend to complicate
> >matters. The users will eventually be using bar code, scanning
> >off of printed documents. As I develop, I will not have that benefit.
> >
> >I can calculator-enter numbers pretty effeciently given my
> >accounting background. But 20 digits is a lot.
> >
> >I'm open to any ideas even if to know there are none.
> >
> >Thanks in advance.
> >Mark Johnson
> >---
> >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.13.4/175 - Release Date:
> >11/18/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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] 20 Digit Number

[Mark Johnson]

General Question. A client has just taken on a new major customer and we have
to keep track of their product codes. These codes are 20 numbers long with no
real prefixing, suffixing or patterns.

Is there any way to abbreviate numbers. I know this is a weird question but I
know that I may be entering these codes manually during the testing and/or
installation phase of this project and 20 numbers is a lot of typing.

I've run out of ideas that simplify as most tend to complicate matters. The
users will eventually be using bar code, scanning off of printed documents. As
I develop, I will not have that benefit.

I can calculator-enter numbers pretty effeciently given my accounting
background. But 20 digits is a lot.

I'm open to any ideas even if to know there are none.

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