Re: Memo: RE: [UD] Union Query

[Mark Johnson]

My 2 cents on this topic and maybe it'll trigger a UD/UV response.

D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your
next process.

Could this work for this person by pre-qualifying the 2 separate SELECT
statements into 2 lists, blah. blah, blah.

I'm interested to know as well.

Thanks.

- Original Message -
From: "Bruce Lunt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 10:11 PM
Subject: Re: Memo: RE: [UD] Union Query


> Open mouth, ... insert foot. Or whatever :)
>
> I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I
> would copy all the ID's to a work file and then TRANS-ing the NAME.LO,  to
> ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in
> both files you have to decide what do to do with that.
>
> Again, sorry for not testing out my solution before I offered it.
>
> Regards,
> Bruce
>
>
>
>
>
> >From: "Allen Egerton" <[EMAIL PROTECTED]>
> >Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
> >To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> >Subject: Re: Memo: RE: [UD] Union Query
> >Date: Fri, 30 Apr 2004 14:41:17 -0400
> >
> >
> >From: "Burwell, Edward" <[EMAIL PROTECTED]>
> >To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
> >Sent: Friday, April 30, 2004 2:00 PM
> >Subject: RE: Memo: RE: [UD] Union Query
> >
> >
> > > Does that work for you?  It doesn't work for me.
> > >
> > > ORDER.FILE NAME.
> > >
> > > 114061 C.M.O.S. INC. *ASC*
> > > 114062 AMERICAN PERFIT XSTAL
> > > 18 TIMELAND COMPANY
> > > 19 MCCANN ELECTRONICS *STR*
> > > 130395 TERMINAL TECH SERVICE
> > > 138562 TOWN VISION ELECTRONICS
> > > 154897 CASIO SERV CENTER *ASC*
> > > 163063 CASIO SERV CENTER *ASC*
> > > 171230 AMERICAN PERFIT XSTAL
> > > 195731 ELECT MUSIC INSTR *FAS*
> > > 10 records listed
> > > Enter  to print non exist record ids
> > > 007890
> > > 007891
> > > 007892
> > > 007893
> > > 007894
> > > 016057
> > > 016058
> > > 016059
> > > 016060
> > > 016061
> > >
> > > Here is the dict:
> > >
> > > 001: I
> > > 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> > > 003:
> > > 004: NAME
> > > 005: 25L
> > > 006: S
> >
> >
> >I can't test it right now, I don't have access to a Universe machine
until
> >tonight.   Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly
> >aren't
> >in ORDER.FILE.
> >
> >--
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >http://www.oliver.com/mailman/listinfo/u2-users
>
> _
> MSN Toolbar provides one-click access to Hotmail from any Web page - FREE
> download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Input weirdo...

[Mark Johnson]

The Advanced Pick manual illustrates most all of the SYSTEM() references.
It's one of my favorite manuals as it's chapterized like all the others but
the index is pure as it contains everything. I don't like the UD/UV manuals
as you need to know which index in which book to look up your topic. If
you're looking up U50BB, is it in the ECL book, the UniProc book or the
UniBasic book?. Not that helpful. Please no flames about books on CD's. Not
always helpful either.

my 1 cent.
- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 8:10 AM
Subject: RE: Input weirdo...


> Thanks Mark!
>
> Bjorn managed to find his reply (in an Advanced Pick manual)
> just after
> I'd sent the request, which kinda worked, but not exactly,
> but your
> length of inputbuffer works a charm.
>
> Speaking of these SYSTEM thangs - is there anywhere I can
> get a list of
> all the settings / variables included in SYSTEM(x)?
>
> -Original Message-
>
> [snip]
>
> SYSTEM(14) is the length of the typeahead buffer. D3 for
> sure and
> possibly UV/UD. The CLEARSELECT is UV/UD specific.
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Accuterm like Wintegrate

[Mark Johnson]

I use wintegrate a lot as an emulator, file transfer and running PC-based programs. 

2 new clients both have accuterm and I'm wondering if their file transfer 
(import/export) facilities are programmable or are manually managed. Also, is there 
the equivilent of WIN.PCRUN. 

I can always install wintegrate but I may not want to rock the boat.

Thanks in advance.

Mark Johnson
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Input weirdo...

[Mark Johnson]

I have a new client that i've yet to be able to  with over the
modem. So if I'm running a program (readnext etc) but i want to break, I
include this INCLUDE.

IF SYSTEM(14) # 0 THEN
 INPUT A
 IF A="Q" THEN CLEARSELECT (sic) ; STOP
 IF A="D" THEN DEBUG
END

SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly
UV/UD.
The CLEARSELECT is UV/UD specific.

My 1 cent.

- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 10:54 AM
Subject: Input weirdo...


> We have a program looping through all data files searching
> for something
> - sometimes it gets to a file containing several million
> records and
> we'd like to be able to tell it to skip that file and
> continue with the
> next file. We've tried the following approaches with said
> results:
>(1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT
>OPT.OUT = 0
>the program sits waiting for input in every
> iteration, ie every
> record
>
>(2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT
>OPT.OUT = 0
>CLEARDATA
>CLEARINPUT
>the program works perfectly until an 'S' is entered
> then skips
> every file after that...
>
>HOWEVER, if I press Ctrl-Break, enter DEBUG, enter
> C(ontinue),
> the program continues as normal until another 'S' is
>entered..
>
> Obviously the machine still has something in the input
> buffer, despite
> the CLEARDATA, something that gets whacked when debug hits
> the scene...
>
> Any ideas?
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How far can U2 scale?

[Mark Johnson]

I know it was an Ultimate. I worked with MCD during that time and they used
the ultimate x's somewhat for comparison purposes. I worked with Ted in
1978-79 before he spun off from 4 Gary Rd.

Again, what would an 'x' be in MHZ. Or for that fact, what would a MCD
spirit 600 be. One of my clients still has one and I could reference it
against some of my 2.4Ghz D3 clients.

my 1 cent.
- Original Message -
From: "Roger Glenfield" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Saturday, April 24, 2004 11:17 AM
Subject: RE: How far can U2 scale?


> Circa 1983-85.  I'm pretty sure that Ted was showing off a Honeywell Level
6
> and not a Microdata.
>
> Ultimate's X calculations were based on the native speed of the cpu.
>
> Original Level 6, circa 1979-81 = 1x
> The 5x board came out in 1982-83.  If I remember correctly, my tests
showed
> the speed was more like 3-4 times faster.  But you could add a bunch more
> terminals without slowing down.
> I never saw a 7x and don't know when it came out.
> We had one site that needed a 10x, but Ultimate and Honeywell Bull Germany
> couldn't keep the machine stable.  So the site went to another platform.
>
> At least that's my 20 year old recollections.
> Roger
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Behalf Of Mark Johnson
> > Sent: Saturday, April 24, 2004 12:55 AM
> > To: U2 Users Discussion List
> > Subject: Re: How far can U2 scale?
> >
> >
> > A bit of history here. I'm sure that these high user counts all
> > participate
> > with telnet connections. Back in the day, I believe circa 1983-5, Ted
> > Sabarese, president of Ultimate, illustrated one of the highest number
of
> > connected *serial* terminals on one system. It was an interesting
> > photograph
> > as he lined up 1,000 dumb terminals on the bleachers at a local
> > high school
> > and had them all BLOCK-PRINTing something like their port number.
> >
> > I don't exactly remember the machine's specs, but given the Microdatas
of
> > that time it probably had 260MB disc drive, 8 MB of 'core' memory and
the
> > latest '14x' processor. Boy, I wish I knew what those speeds of
> > those older
> > systems were in today's terms. 2x, 7x, 14x...What's an 'x'?  IIRC, the
> > original IBM-PC was 4.7Mhz.
> >
> > My 4.7 cents.
> >
> >
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How far can U2 scale?

[Mark Johnson]

A bit of history here. I'm sure that these high user counts all participate
with telnet connections. Back in the day, I believe circa 1983-5, Ted
Sabarese, president of Ultimate, illustrated one of the highest number of
connected *serial* terminals on one system. It was an interesting photograph
as he lined up 1,000 dumb terminals on the bleachers at a local high school
and had them all BLOCK-PRINTing something like their port number.

I don't exactly remember the machine's specs, but given the Microdatas of
that time it probably had 260MB disc drive, 8 MB of 'core' memory and the
latest '14x' processor. Boy, I wish I knew what those speeds of those older
systems were in today's terms. 2x, 7x, 14x...What's an 'x'?  IIRC, the
original IBM-PC was 4.7Mhz.

My 4.7 cents.


- Original Message -
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, April 23, 2004 10:32 PM
Subject: RE: How far can U2 scale?


I would imagine in any of the scenarios that has been given, if some form of
"local" (client side) intelligence is employed, coupled with a
non-persistent connection scheme to the central database, that the numbers
that have been quoted here (2-10,000) could easily be multiplied by a factor
of 5-10 . but of course you may  hit the wall in terms of saleability of
web servers (web farms), network topology & infrastructure etc.

I think it would be fair to say, within the parameters that others have
outlined (massively large databases vs. massively large user populations)
that there are no practical limits to mv scalability.

I recall hearing a story about when Tim Holland migrated Pick Open
Architecture to the Sequoia machine. Similar concerns were raised about the
saleability of "pick", but it soon became obvious that it was the underlying
Unix that would be "pushed"

Given the historic position that mv allows you to do more with less, I don't
think we should be too surprised by this.


Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Ray Wurlod
>Sent: Saturday, 24 April 2004 9:05 AM
>To: U2 Users Discussion List
>Subject: RE: How far can U2 scale?
>
>There are quite a few sites running upwards of 2000 users in my region
>(Asia Pacific).  The model is many small users (such as insurance brokers,
>accountants, tax agents, etc.) having dial-in access.  One site is licensed
>for 3300 users, and sustains a load over 3000 users most of the day with
>acceptable response metrics.  Strictly two tier (one tier really).
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.665 / Virus Database: 428 - Release Date: 21/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.665 / Virus Database: 428 - Release Date: 21/04/2004

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Barcode printing

[Mark Johnson]

In my 15 years of printing/using bar codes, I've concluded that it's best to
not re-invent the wheel and purchase printers that are bar code capable.
Thus, you don't really make up the bar code lines themselves, you just send
an escape sequence telling the printer what kind of code, orientation,
position and value.

I used to do bar code manually on Printronix printers and will never go back
to calculating the spaces. Let the printers do their magic.

my 1 cent.
- Original Message -
From: "Lee Messenger" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] Com" <[EMAIL PROTECTED]>
Sent: Friday, April 23, 2004 11:03 AM
Subject: Barcode printing


> I am attempting to identify a solution to printing barcodes from within
> Universe basic.  I have reviewed the archives at IndexFocus and found some
> references to examples, however the 2 of 5 example only handles numeric
data
> and the link to the 128 barcode was no longer active.
>
> Can anyone provide me with some information or examples.
>
> We are a Windows environment with HP printers.
>
> Any assistance would be appreciated.
>
> Thank you,
>
> Lee J Messenger
> Sr VP Operations
> [EMAIL PROTECTED]
>
> DLT Transportation Services, Inc.
> Phone :(816) 242-4505
> Fax   :(816) 483-7222
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How do we convert lowercase letters to uppercase in Pick basi c

[Mark Johnson]

Only downsides to these OCONV's is that McDonalds and O'Henry lose the 2nd
capitalized letter. The only true way to manage would be to have a BEGIN
CASE situation to look for MC or O' at the beginning and handle that way.
Plus maintain a list of unprogrammable exceptions.

I have a music database program that needs this, especially the exception
list like LeAnn Rimes, DJ Freddie, USA etc. Also, the exception list could
force certain words to not capitalize. The exception list's primary key is
the Uppercase version of the word and <1> is the true form.

mY 1 cEnT

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 3:17 PM
Subject: RE: How do we convert lowercase letters to uppercase in Pick basi c


> tx for the help
>
> regards
> reddy
>
>
>
>
> Jeff Schasny <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 04/22/2004 03:12 PM
> Please respond to
> U2 Users Discussion List <[EMAIL PROTECTED]>
>
>
> To
> U2 Users Discussion List <[EMAIL PROTECTED]>
> cc
>
> Subject
> RE: How do we convert lowercase letters to uppercase in Pick basi c
>
>
>
>
>
>
>
> OCONV("whatever","MCU")
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 12:11 PM
> To: [EMAIL PROTECTED]
> Subject: How do we convert lowercase letters to uppercase in Pick basic
>
>
> Hi,
>
>
> Can some one tell me how to convert lower case letters to uppercaseand
> vise versa
>
>
> tx in advance for the help
>
>
> regards
> reddy
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: GUI as nice as character-based

[Mark Johnson]

 flow and make
> > life
> > genuinely easier.
> > I have seen bad GUIs that interrupt work flow, slow people down (bl**dy
> > mice
> > and message boxes).
> >
> > Good GUI works.
> > Bad GUI is bad bad bad.
> >
> > But too often GUI is blamed for the lack of vision or competence of
those
> > implementing it.
> >
> >
> > Brian
> >
> >
> >
> >
> >
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
> > Behalf Of Dawn M. Wolthuis
> > Sent: 20 April 2004 02:03
> > To: 'U2 Users Discussion List'
> > Subject: RE: GUI as nice as character-based
> >
> > Citrix and I don't get along -- too many bad memories trying to set up
> > ODBC
> > so that client machines ... anyway, I know that there are reasons that
> > shops
> > use it, just as there are reasons I hope not to have to touch the
product
> > again ;-)
> >
> > And I didn't intend for Java to be the only possible solution to fit the
> > rules -- I just tried to be sure to rule out the V-word ;-)  [Just a
> > little
> > joke there -- I actually think that Visage is likely an excellent choice
> > for
> > Microsoft-centric sites and I'm a Ross-fan myself, remember]
> >
> > Cheers!  --dawn
> >
> > Dawn M. Wolthuis
> > Tincat Group, Inc.
> > www.tincat-group.com
> >
> > Take and give some delight today.
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
> > Behalf Of Ross Ferris
> > Sent: Monday, April 19, 2004 7:21 PM
> > To: U2 Users Discussion List
> > Subject: RE: GUI as nice as character-based
> >
> > Dawn,
> >
> > Citrix Server would break DLG (Dawn's Law of GUI) rule 4 anyway, as you
> > would need to pre-install Citrix client software on most platforms.
> >
> > BTW Dawn, do you have a mathematic proof of DLG ?
> >
> > Just wondering, 'cause just like the "Great Date Debate", many may be
> > happy
> > to 'bend' these rules because they don't apply to the environment they
> > use ?
> >
> > For example, Citrix has MANY other advantages, especially in larger
> > organizations, when it comes to issues like securing the desktop, and
> > centralized updates etc.
> >
> > In Wyatt's case, he can simply install SmartTerm (oops, Windows only
> > product, breaks rule 1 - hmm, but with Citrix his client 'can' be a Mac
> > ?!!?
> > Your "proof" could be 'interesting' ?!?!) onto his Server, and it then
> > requires no pre-installation.
> >
> > He can have a link on a web page to download the Citrix client software
> > 
> > does this 'break' your 'rules', or does it fit ?
> >
> > Of course Citrix Server/Terminal Server has an important place in larger
> > enterprises, addressing issues like security, desktop lockdown,
> > patch/update
> > management, software distribution etc - which transcend DLG
> >
> > Also with your "rule revision" below, as with the original DLG, you
still
> > haven't included the "J" word, which I believe is an implicit (and
> > understood) requirement for DLG !?!
> >
> > Ross Ferris
> > Stamina Software
> > Visage - an Evolution in Software Development
> >
> >
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >> On Behalf Of Dawn M. Wolthuis
> >> Sent: Tuesday, 20 April 2004 5:14 AM
> >> To: 'U2 Users Discussion List'
> >> Subject: RE: GUI as nice as character-based
> >>
> >> Ah, I should add or modify one of the requirements -- when I indicated
> >> that there needs to be no setup on the client, I should put that in the
> >> "client tier" and consider citrix servers to be application clients, of
> >> sorts.  So, for my purposes (though not for everyone), a citrix server
> >> is not an option.
> >>
> >> 1. Client Tier (no setup)
> >> 2. Http Server Tier (could include app server, such as tomcat or EJB
> >> container such as Eclipse or WebSphere) 3. Database Server Tier
> >>
> >> I'll clarify the requirements to add "no more tiers".
> >>
> >> --dawn
> >>
> >> Dawn M. Wolthuis
> >> Tincat Group, Inc.
> >> www.tincat-group.com
> >>
> >> Take 

MV Data Warehousing with Great Plains

[Mark Johnson]

Wow. Thanks to all who have helped me create a proposal for my client to possibly keep 
their MV system as a Data Warehouse to Great Plains. Especially the Data Cube concept 
which has been in Results for 24 years.

I would like to get some first hand examples if anyone has used a MV system as a Data 
Warehouse to either a non-MV system or an MV system. More towards the non-MV system. 
In particular, was the Data Warehouse new software and new reports had to be created 
in that environment. Or was the Data Warehouse the previous application, which is more 
of my situation.

Thanks in advance.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: GUI or Event ? as nice as character-based

[Mark Johnson]

Isn't that what System Builder did (does) with its sbclient software?

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, April 19, 2004 2:27 PM
Subject: Re: GUI or Event ? as nice as character-based


> Clarify.  Are you talking about *within* the mv environment? Or an outside
app?
>
> Accuterm has the ability to recognize where a mouse-click is in regards to
(col, row).  This is the same col, row that PRINT @ uses.  Now if your mv
programs have a single, standard INPUT subroutine then you can simply modify
that subroutine.
>
> So your modification would look something like
> If I.am.using.accuterm then
>if mouseclick then
>   get.location; determine.which.field; reset fieldno = this.field
>   redo.input = true; return
>end
> end else
>input xxx
> end
>
> Or something along those lines.
> I have only seen one application package that integrated this ability,
however, the screen drivers it built allowed the user to point-and-click and
enter data into any field in any order on the screen.  It was then up to the
programmer to ensure that intra-field dependencies were properly handled.
But it was certainly a good start.
>
> Is that what you meant?
> Will
>
> In a message dated 4/19/2004 2:17:34 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > I haven't gotten through all of the postings in the GUI thread as yet,
but
> > am working on the question of how to write a GUI that is as good as a
"green
> > screen" from the perspective of folks currently using a green screen
> > application.  I saw hints at that, but nothing that tackled it from the
> > standpoint of being able to use any tools on the market today to
accomplish
> > this (no need to retain databasic code, for example).
> >
> > What could be used to actually replace, completely, the character
screens?
> >
> > Requirements:
> > 0) work with U2 as multiuser databases
> >
> > 1) Be able to use any Windows, new Mac (unix) or Linux client
> > 2) Have graphically attractive & colorful screens, looking enough like
> > standard GUIs (M$, in particular) that users would understand the use of
> > icons, etc.
> > 3) Respond to keystrokes by users -- not only to the click of a "submit"
> > button
> > 4) Require no preparation of the client computers in advance of using
the
> > software, likely directing user to a web page.
> > 5) "type ahead" can be done so that the user is not waiting constantly
for
> > the computer to respond
> > 6) Heads down data entry folks are as happy with this as they were with
> > their green screens when they first got those and have only minor
complaints
> > if converting now from a green screen, none of substance
> >
> > What are the options -- who has written or seen such a GUI?
> >  --dawn
> >
> > Dawn M. Wolthuis
> > Tincat Group, Inc.
> > www.tincat-group.com
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: GUI as nice as character-based

[Mark Johnson]

Dawn: Good luck in your search for this holy grail. Lemme know if such a
silver bullet is found.

I've been hunting for years.

Mark Johnson

 Original Message -
From: "Dawn M. Wolthuis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 19, 2004 2:17 PM
Subject: GUI as nice as character-based


I haven't gotten through all of the postings in the GUI thread as yet, but
am working on the question of how to write a GUI that is as good as a "green
screen" from the perspective of folks currently using a green screen
application.  I saw hints at that, but nothing that tackled it from the
standpoint of being able to use any tools on the market today to accomplish
this (no need to retain databasic code, for example).

What could be used to actually replace, completely, the character screens?

Requirements:
0) work with U2 as multiuser databases

1) Be able to use any Windows, new Mac (unix) or Linux client
2) Have graphically attractive & colorful screens, looking enough like
standard GUIs (M$, in particular) that users would understand the use of
icons, etc.
3) Respond to keystrokes by users -- not only to the click of a "submit"
button
4) Require no preparation of the client computers in advance of using the
software, likely directing user to a web page.
5) "type ahead" can be done so that the user is not waiting constantly for
the computer to respond
6) Heads down data entry folks are as happy with this as they were with
their green screens when they first got those and have only minor complaints
if converting now from a green screen, none of substance

What are the options -- who has written or seen such a GUI?  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: GUI from Mv code Re: Crystal Reports

[Mark Johnson]

Thanks Dawn! You have enlightened me in quite a few ways.

First, If this Cube concept is today's latest buzz word, then I'm gonna run
with it for my GP client I'e been whining about on this forum. As I was
singing the praises of the Results system, It contains 4-5 sales history
files that exactly match your definition of a cube.

One of these files, called CUST-PROD sales is a 108 field multiple year file
representing month by month sales, ext price, budgets and gross margin. This
single file is the basis of over 90% of the customized sales reports I've
added in the last 6 years.

I've always liked this file and duplicated it on other MV clients that
didn't have it. Given the perpetual collection of transactions in an
INVOICE-HISTORY file and the significant fields in each record (CUSTNO,
PRODUCTS, SHIPTOS, SALESMAN, PRODUCT families, DATES etc) these CUST-PROD
and other sales accumulations (cubes) make for quick reports and inquiries.
Also, they don't take away from the lessor fields being attacked with the
transaction file.

BTW, the most extreme example of a multi-part primary key that I've ever
seen was for a security monitoring client. It looked like this:

ACCOUNT-RECEIVER-DATE-TIME-ZONE-SIGNAL-INCIDENTNUMBER

and oddly enough, this file contained no data fields. Just the primary key.

thanks.


- Original Message -
From: "Dawn M. Wolthuis" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 4:49 PM
Subject: RE: GUI from Mv code Re: Crystal Reports


Cube summary: In an MV implementation, a cube might be a file with a
multipart key and each part of the key being a foreign key to another file.
Additionally, instead of virtual fields for summing such numbers as
total-sales-per-salesperson-per-quarter, the cube might actually store these
sums just in case someone wants to see them then they do their online
analytical processing (OLAP), for example.

The most important aspects of a cube are the FACT table (that's the one with
the multipart key), the DIMENSION tables (the ones the foreign keys point
to) and the MEASURES (the values to be summed, counted, etc when slicing and
dicing the data).

RDBMS users often rehost their data in a data mart or warehouse using a
"star schema" (the name for a fact and dimension table design) so they can
report against the data.  [And as an aside, PICK folks sometimes also port
their data to a relational database so they can then make stars and put in
an OLAP cube so they can then report against it as if it were multivalued
data.  We end up doing that due to a lack of standard reporting solutions
other than the character-based MV query tools.  That's why I promote such
tools as Informer at www.entrinsik.com -- we could bypass a lot of steps if
we don't buy into the relational mistakes -- couldn't resist the soapbox
opportunity, sorry].

--dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Sunday, April 18, 2004 2:49 PM
To: U2 Users Discussion List
Subject: Re: GUI from Mv code Re: Crystal Reports

Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.

Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports


> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > For example, aligning this back to the original post, rather than
attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
> > AccuTerm !
>
> Warning! Salesman quote!
> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
>
> You replaced the 300 reports, with one huge cube where you STILL have
users recreating (or trying to) their original 300 reports...
>Users don't want to see 50 fields, they want to see the 6 fields
they've been analyzing for the past 3 years ...
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.

Re: GUI from Mv code Re: Crystal Reports

[Mark Johnson]

Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.

Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports


> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > For example, aligning this back to the original post, rather than
attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
> > AccuTerm !
>
> Warning! Salesman quote!
> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
>
> You replaced the 300 reports, with one huge cube where you STILL have
users recreating (or trying to) their original 300 reports...
>Users don't want to see 50 fields, they want to see the 6 fields
they've been analyzing for the past 3 years ...
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV to Text Conversion Standard?

[Mark Johnson]

Let's not forget the lower case L for 1 (one).

- Original Message -
From: "Larry Hiscock" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Saturday, April 17, 2004 2:08 PM
Subject: RE: UV to Text Conversion Standard?


> > You expect delimiters? When I started in computers, our binary
> > only had zeros - and we were glad to have them!
>
> You had zeros?!?  We had to use the letter O   ;->
>
> Larry Hiscock
> Western Computer Services
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Results
> Sent: Saturday, April 17, 2004 10:54 AM
> To: U2 Users Discussion List
> Subject: Re: UV to Text Conversion Standard?
>
>
> Ross,
>
> >Perhaps we should all capitulate & start to use flat CSV files ?
>
> You expect delimiters? When I started in computers, our binary only had
> zeros - and we were glad to have them!
> The thing about MV or flat really comes down to a case-by-case to my way
of
> thinking. I generally program Order Entry systems as 1NF, even on MV
> systems. Pricing, Inventory, and any number of other parts tend to lend
> themselves to MV. I like being able to choose the best form for each case.
>
> --
>
>  Sincerely,
>   Charles Barouch
>   www.KeyAlly.com
>   [EMAIL PROTECTED]
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Crystal Reports

[Mark Johnson]

Maybe I'm not strong enough to convince my clients to begin to integrate GUI
based entities to their MV systems. I have had these discussions with each
of them and I often get the "We like things the way they are".

2 of my clients have had their order entry software from around 1977. One in
particular had it initially developed by an outside company and then the 2
owners have been tweaking it until the mid 1990's when i got involved. They
are both a little stubborn for new ideas (which actually is kinda good, MV
wise) so I just keep adding features within the same looking environment. I
even have to follow house rules for the symantics for saving records,
leaving programs etc.

I've added regular and email blasts to their system, automatic faxing,
automatic FTPing, web exporting and a few other modern tricks to their
system. When we upgraded, it had to be on a W2K box to keep the PC
familiarity instead of unix.

I know that many of my clients are at a crossroads that if I were to suggest
some major spending on GUI-for-MV products that the implied new expense may
make a replacement system a little more appealing. If they're going to spend
$10 to $20K on something, why not throw out MV. It's a hard place to be.

Personally, I'm committed to helping them get the best out of their MV
system. I also feel that it's in its twilight and I'm taking some other
routes for revenue generation. I wish I were either at a VAR or at one
end-user so I could plant my feet and really invest for their (our) future.
But being independent, that's probably the way the ball bounces.

Thanks.

- Original Message -
From: "Mike Randall" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Saturday, April 17, 2004 12:08 PM
Subject: RE: Crystal Reports


> Mark,
>
> I think you've hit it right on the head regarding the dilemma surrounding
> MV.   The visual aspect KILLS us.   The MV solutions out there are many
and
> very good at what they do.  The problem is that most of them look ancient
> and lack the GUI glitz and integration ability.
>
> The REAL shame is that the technology to develop full GUI products in our
> environment is here.   The story you mentioned of clients migrating to
some
> other GUI solution only to find it less capable than the MV system is a
> recurring nightmare.   I think the solution lies in the hands of the
> developers like yourself and the MV organizations that provide solutions.
>
> The tools are there to produce applications on par with anything on the
> market.  Web interfaces via tools like Redback. UOJ, .Net PDP, or the java
> interfaces are all there to produce great solutions for U2.   There are
host
> of 4GL tools for our environment like SB+, Visage, Nucleus and others
> (apologies for any omissions).   I think the developers, consultants and
> solution providers almost have to embrace "something" other than
delivering
> character based apps.   If you don't, then get used to clients leaving.
>
> Personally,  I came to this crossroads in the late 90s and decided to
learn
> the web technologies.  My company is a consulting group specializing in
web
> development for MV via Redback and now Raining Data's Data Provider.   It
> sounds cruel, but it's a case of switch to something or be eaten.
>
> Mike R.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Mark Johnson
> Sent: Saturday, April 17, 2004 10:34 AM
> To: U2 Users Discussion List
> Subject: Re: Crystal Reports
>
> Ross:
>
> Your square peg, round hole analogy is pretty accurate. GP seems to be the
> next step for quickbooks users.
>
> The package that they're migrating from is Results from Microdata from the
> early 1980's. I still have 4 other clients using Results as well as a
> mixture of other Order entry packages/homegrown.
>
> While I can itemize a few shortcomings of Results, it has stood the test
of
> time because it's still being used. Each of my 4 other Results clients
have
> taken their copy and evolved it in their own localized versions.
>
> What absolutely impresses me is that none of these 4.5 clients have used
> *all* of the originally installed features of Results. They use many and
> have added many of their own. But the core design of Results remains true
> and someone got it very correct back during its rollout. Add to the fact
> that the developers didn't have a 4GL to think of, had 50MB 64K 1Mhz
> machines and had to watch the compiler meticulously display those line-by
> line asterisks during compiling. Plus, those programs were pretty long as
> well, didn't have INCLUDES and didn't have the open CALL concept that
> every

Re: Crystal Reports

[Mark Johnson]

Ross:

Your square peg, round hole analogy is pretty accurate. GP seems to be the
next step for quickbooks users.

The package that they're migrating from is Results from Microdata from the
early 1980's. I still have 4 other clients using Results as well as a
mixture of other Order entry packages/homegrown.

While I can itemize a few shortcomings of Results, it has stood the test of
time because it's still being used. Each of my 4 other Results clients have
taken their copy and evolved it in their own localized versions.

What absolutely impresses me is that none of these 4.5 clients have used
*all* of the originally installed features of Results. They use many and
have added many of their own. But the core design of Results remains true
and someone got it very correct back during its rollout. Add to the fact
that the developers didn't have a 4GL to think of, had 50MB 64K 1Mhz
machines and had to watch the compiler meticulously display those line-by
line asterisks during compiling. Plus, those programs were pretty long as
well, didn't have INCLUDES and didn't have the open CALL concept that
everyone else has. Not to mention the original 32 K record (program) size
file structure.

Only 1 of my Results clients remains on the older MCD box and oddly enough,
he has the 2nd most sophisticated deviations of my 4.5 clients. The others
are either on R90 or UD.

I think the greatest oversight in all of MV is the inability to re-compile
the existing source code to a GUI equivilent. I'm smart enough to realize
how tremendously difficult that would be. But I know that a major reason for
my current dilema with this UD/Results guy going to Great Plains is the
visual aspect of it. People taste with their eyes and most IT 20-something
guys have never seen anything decent on a character-based screen so they
relegate it to the sophistication of command-line DOS. While they have made
an incorrect conclusion, their voices speak loudest. And since they hold the
keys to the contemporary services: email, web sites, network admin etc,
their opinions may carry more weight.

One of my other clients is bouncing back and forth with a proposal of mine
for a $10K new module and the concept of ROI comes into play. How in the
world could this MV-to-GP client justify the ROI on all the extra time and
expense to shift to GP.

Mark Johnson
- Original Message -
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Saturday, April 17, 2004 9:31 AM
Subject: RE: Crystal Reports


H,

We spent 3 years developing a product (CrystalLynx) that allowed us to work
with Crystal - it automatically "normalized" the data for you, so I think it
would be fair to say that "we used it for a while" - and you are right, I
don't want to go back (to Crystal).

Typical square peg/round hole stuff, because it DIDN'T understand mv all
that well - or maybe it was just us ! and I surely didn't like ODBC
performance (and reliability on D3 platforms).

CR is obviously a good product - #1 in it's field, but these days there ARE
products available that work with mv data in a native format, and give CR a
good run for it's money !


Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mike Randall
>Sent: Saturday, 17 April 2004 5:41 AM
>To: 'U2 Users Discussion List'
>Subject: RE: Crystal Reports
>
>Crystal is indeed a very fine product.  It is a banded report writer with a
>multitude of programmability.   Multivalued data is indeed a pain in the
>neck.   Normalize the data 1st and you'll find Crystal a joy to use with
>output, features and polish that MV can't come close to.  The 'problems'
>that your users are facing can be addressed with Crystal code (VB syntax or
>Crystal's scripting syntax).  After using it a while, you'll never want to
>go back...
>
>Mike R.
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mark Johnson
>Sent: Friday, April 16, 2004 2:51 PM
>To: U2 Users Discussion List
>Subject: Crystal Reports
>
>One of my clients wants to connect Crystal Reports to their UD database to
>apparently give greater access to the data that they sometimes deem as
>hidden and only accessable through me.
>
>This client converted to Great Plains 6 weeks ago (SQL based) and their CR
>experts were struggling with duplicating some of the more mundane reports
>that already exist in UD. A monthly sales tax summary (by jurisdiction)
>took
>the GP guy 3 days futzing with CR using GP's data.
>
>How much trouble are they going to get in trying to use MV'd data from the
>UD system (ODBC) if they hav

Crystal Reports

[Mark Johnson]

One of my clients wants to connect Crystal Reports to their UD database to apparently 
give greater access to the data that they sometimes deem as hidden and only accessable 
through me.

This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts 
were struggling with duplicating some of the more mundane reports that already exist 
in UD. A monthly sales tax summary (by jurisdiction) took the GP guy 3 days futzing 
with CR using GP's data.

How much trouble are they going to get in trying to use MV'd data from the UD system 
(ODBC) if they have so much trouble with more 'normalized' data. Everyone seems to 
think that CR is a magic pill and once attached to a SQL database, the sophisticated 
reports simply roll off.

I'm trying to strongly propose a data warehouse concept whereby the day's sales data 
gets exported and updated into their prior application for the sake of the multitude 
of existing, proven reports in MV. If these guys took 3 days for a simple tax report, 
how can CR fabricate temporary tables for the sake of these consolidated sophisticated 
MV reports?

I'm just interested in hearing of some experiences. This client is too stubborn to go 
back from GP and may even disregard their entire MV system completely. I really have 
nothing to lose if I insult them. 

Thanks in advance.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Productivity metrics

[Mark Johnson]

Oh boy, I can smell the debates regarding programming styles in lieu of
reducing lines of code. Could this be where GOTO's have their day.
my 1 cent.
- Original Message -
From: "Bob Dubery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 14, 2004 7:24 AM
Subject: Productivity metrics


> Hi all,
>
> IBM initiated a metric called "Function Points" that attempts to provide a
> means for measuring programming tools by the amount of code that has to be
> written in order to produce a program of a certain complexity.
>
> There have been several studies by which programming languages have been
> ranked in terms of lines of code (LOC) per function point (FP)
>
> Smalltalk, for example, is reckoned to have a ratio of 20 LOC per FP. Java
> and C++ come in around the 50 mark.
>
> Is anybody aware of studies that have applied this kind of scoring to the
> BASIC used in MV databases, or any other study that seeks to rank
> programming languages in terms of programmer producivity and that includes
> MV BASIC?
>
> Thanks
>
> Bob
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Pro-4

[Mark Johnson]

Haven't heard of Application Liberation Language in a dogs age.

- Original Message - 
From: "Barry Brooks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 07, 2004 9:53 PM
Subject: Pro-4


Hi all

I'm looking for someone who maybe be able to assist with support of a
customer using PRO-4 (ex McDonald Douglas "ALL") I think.

Support will be required in Sydney, Australia.

Can anyone help ?

Thanks ... Barry Brooks
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Label printers on AIX and/or Solaris

[Mark Johnson]

I've purchased many Prodigy DataMax label printers (4x6 UPS or smaller) from
Ebay for around $80-$150 each over the last few years. The replacement heads
alone are $280 new.

The PCL (sic) is pretty straightforward. It isn't WYSIWYG but debugable.
These printers have all the bar code fonts contained. They all have many
helvetica-style fonts and sizes. Complete orientation, sizing etc. They are
usually serial.

There are thermal and ink-based labels. If it's temperature sensitive
(either hot or cold) don't use thermal as they fade in time. If they're
shipping, thermal is fine.

my 1 cent.


- Original Message -
From: "Karjala Koponen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 05, 2004 1:05 PM
Subject: Label printers on AIX and/or Solaris


Hello,

I'm running UniData 5.2.15 on AIX 4.3.2 but will be going to UniData 6.0.9
on Solaris 2.8.  We have two stand alone Epson LX300+ 9 pin dot matrix
printers we use to print labels.  They are defined as generic (ASCII)
devices.  The printers are old and the output is acceptable, at best.

I'd like to replace the printers with label printers that will print on peel
off labels of roll stock.  These printers generally come with Windows
drivers but Unix drivers seem to be lacking.  Some of the higher end
printers come with a programming manual that would allow me to write code to
send control sequences to the printer and control everything.  I've done
that before but I'd rather not take the time to do that if I can simply
attach a printer, either to the network or a serial connection, load a
driver and create a queue, and then simply send my few lines of text to the
print queue and get a label.  Bar code would be nice but is not mandatory.

I'm sure that we are just not looking in the right place or closely enough.
We are not printing high volumes of labels so less expensive is better.  Any
suggestions?

Thanks, Karjala
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

[Mark Johnson]

To answer the other questions:

I would gain ODBC access with MS Access to the Invoice Header/Line Tables,
Customer and Product Tables. I would maintain in Access a table of those
Invoices already converted. I would then create a CSV export of the new
Invoices and current Customer/Product tables and then have a UD process
import them. This process could be run any time and often.

This client is too cheap to purchase the ODBC connection for UD. That is,
they don't want to pay for my or the VAR's time to install it. Penny-wise.

thanks.

> > Mark,
> > Technically Overview:
> >Using some sort of a schedule, you identify new and modified data
> > on the Great Plains system,  and move just that data to the MV system,
> > converting the layout and data.
> >
> > That leaves you with the following discreet tasks:
> >How do you identify new or modified data in Great Plains?
> >How do you move and transform the data?
> >How fresh does the data have to be? (i.e. what is the User's
> > expectation weighted against the network overhead of 'shipping' the
data.)
> >How do you schedule that move and transform?
> >
> > Management Overview:
> > Tax law (in the US, I believe you are in the US) will require
> > you to keep records going back at least 5 years. Therefore, the old
> > system needs to be available. Since it will have to be up and intact,
> > you see a major cost and performance savings in using that already paid
> > for hardware and already developed software to act as a data warehouse.
> > If they want to move those reports in the future, they can do it
> > in a controlled manner, without having a loss of productivity or
> > information. Not using the older system as a data warehouse will apply
> > pressure to complete these functions now, adding cost and delaying the
> > needed flow of information.
> > --
> >
> >  Sincerely,
> >   Charles Barouch
> >   www.KeyAlly.com
> >   [EMAIL PROTECTED]
> >
> >
> > Mark Johnson wrote:
> >
> > >This sounds very tempting, using MV as a data warehouse to a non-MV (or
> MV)
> > >primary application. Does anyone else have any insight on how this
flies,
> > >management-wise or technically.
> > >
> > >I like it as all of the original reports are already written and tested
> and
> > >it keeps the customer a MV customer.
> > >
> > >Thanks
> > >Mark Johnson
> > >
> > >
> >
> >
> > --
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

[Mark Johnson]

Bullseye. The client already experienced a month-end (Mar31) and the VP of
Marketting was in a snit as most of her reports could not be completed in
Great Plains either directly or with Crystal Reports which everyone believes
is a magic pill.

I visit this client once per week and each week since the migration has been
uncovering one shortcoming or another of GP. Everything seems to be an
add-on. I've added so many features in the 6-1/2 years of my tenure that
they think that today's shopping cart systems will do the same. Sales Tax,
Customer Lookup, Product Lookup, Invoice Print, Check Print, Order Print,
Job Cost and many others are all too generic and need help.

The client is too stubborn to revert back to their legacy MV situation.
Thus, damn the torpedos and continue hacking at GP to get the job done.

Thanks.
- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 04, 2004 12:55 PM
Subject: Re: Conversions


> Mark,
> Technically Overview:
>Using some sort of a schedule, you identify new and modified data
> on the Great Plains system,  and move just that data to the MV system,
> converting the layout and data.
>
> That leaves you with the following discreet tasks:
>How do you identify new or modified data in Great Plains?
>How do you move and transform the data?
>How fresh does the data have to be? (i.e. what is the User's
> expectation weighted against the network overhead of 'shipping' the data.)
>How do you schedule that move and transform?
>
> Management Overview:
> Tax law (in the US, I believe you are in the US) will require
> you to keep records going back at least 5 years. Therefore, the old
> system needs to be available. Since it will have to be up and intact,
> you see a major cost and performance savings in using that already paid
> for hardware and already developed software to act as a data warehouse.
> If they want to move those reports in the future, they can do it
> in a controlled manner, without having a loss of productivity or
> information. Not using the older system as a data warehouse will apply
> pressure to complete these functions now, adding cost and delaying the
> needed flow of information.
> --
>
>  Sincerely,
>   Charles Barouch
>   www.KeyAlly.com
>   [EMAIL PROTECTED]
>
>
> Mark Johnson wrote:
>
> >This sounds very tempting, using MV as a data warehouse to a non-MV (or
MV)
> >primary application. Does anyone else have any insight on how this flies,
> >management-wise or technically.
> >
> >I like it as all of the original reports are already written and tested
and
> >it keeps the customer a MV customer.
> >
> >Thanks
> >Mark Johnson
> >
> >
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

[Mark Johnson]

This sounds very tempting, using MV as a data warehouse to a non-MV (or MV)
primary application. Does anyone else have any insight on how this flies,
management-wise or technically.

I like it as all of the original reports are already written and tested and
it keeps the customer a MV customer.

Thanks
Mark Johnson
>
> I have one client that uses Great Plains.  Although an old version I
> felt that the system was not as aligned to the work flow as many PICK
> systems are.  There was also a trap similar to the old spreasheets in
> the report generator, where the calculations are directional ir verticle
> or horizontal.  Ie if you calculate horizontal then April's Open Bal is
> calculated from March's Closing Balance before March Closing Balance has
> been calculated.
>
> We currently suck data out of the Great Plains General Ledger and build
> it into a Multidimensional Warehouse based on Universe and actually do
> all the forecasting, Budgeting and Reporting from Universe.  One
> application allows users from Excel spreadsheet to view the journals in
> Great Plains related to the line item and this is through Universe.  We
> do this online through the SQL features in UvBasic.


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

[Mark Johnson]

Thanks to all who have provide some good ideas. The conversion has occurred
and is in the growing pains. Still a mistmatch but there's no going back.

Perhaps I'll take this approach to learn Crystal Reports or MS Access
reports. There are many previous reports and downloads that can't possibly
come from these wizard oriented facilities and I will have to re-create them
using their tools.

One question. Many of the MV reports that I've created were consolidations
of multiple sales/customer/product files into concise reports. They enlist
databasic to create a temp file and populate it with the report-related
sub-categories that don't consolidate easily in MVQuery. Thus the temp file
is then query-able.

I've been told that Crystal Reports doesn't allow for the creation of temp
tables while Access can. Is this true and should I develop their replacement
reports in Access.

One strange thought occurred to me that may not fly. Export all the
sales/customer/product data back to the MV system and use the existing
reports. At least they're already tested & finished.

Thanks again.

- Original Message -
From: "Dawn M. Wolthuis" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Saturday, April 03, 2004 9:50 AM
Subject: RE: Conversions


Mark -- I don't have experience with Great Plains, but can definitely
sympathize with your situation.  I have been on both the technical and
management side of such conversions.

Given that it sounds like the decision has been made, money has been spent,
and work has been done, you could tackle it by coming through with a "this
is how we COULD accomplish what is desired" set of chats and formal
meetings.

-->Document (if it isn't already) precisely what the goals are for the
implementation of the new software so that it is clear what needs to be
accomplished from the perspective of "Bob the owner".  Include goals of what
we don't want to impact and not just what we do want to change (for example,
is a negative impact on profitability acceptable for 1 year, 2 years?)

-->Collect all issues/concerns that those in the trenches have related to
this project; back these up with metrics/facts where you can

-->Ask this same trenches group how they think these obstacles can be
removed or mitigated

-->Discuss the issues and possible solutions with mid/upper management and
request their brainstorming as well on how to mitigate the concerns

-->Interview other Great Plains users and ask them how they addressed
similar issues

-->Prepare a report (put in writing in some format, perhaps ppt) that has
the angle of how we can accomplish this and does not have an underlying tone
to indicate that you disagree with the decision to move forward with this
software.  The report can still indicate that there are costs to the
conversion and perhaps even that there were unanticipated costs that were
found once those who work with the software became familiar with the
software

-->Work with all parties to choose the approaches for handling the obstacles
in the path of a successful conversion and then implement those.

Of course, it is never as easy as following bullet points.  I would also
suggest having a good "inventory" of those with whom you have a good working
relationship and build on those relationships to help the project run
smoothly to completion.

Best wishes.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Friday, April 02, 2004 10:05 PM
To: U2 Users Discussion List
Subject: Conversions

Does anyone have a short paper on the care and feeding of both the company
and its employees during a conversion/migration from one system to another.

I'm facilitating a migration from MV/Results/Primac to Great Plains and it
is a very large mismatch. GP seems to be shopping-cart oriented and
Results/Primac are more of a traditional Order Entry system.

I can't seem to convey that difference as management (read: those who don't
use the computer) like the GUI and all of the nice links and screens. The
worker bees are in a turmoil with the increased amount of carpal-tunnel
potential mouse/keyboard back and forth as well as the absense of many
functions that were present under the MV app. Their productivity has fallen
75% as it takes 4x longer to enter an order.

There are no sales tax lookups, no product or customer lookups. You clearly
cannot scroll through 35,000 line items. There's no easy alternate shipping
addresses and the original reports leave a lot to be desired. The accounting
package is appealing but a company doesn't exist just for the accounting
dept. Not to mention all the hamburger-helper features i've installed over
t

Conversions

[Mark Johnson]

Does anyone have a short paper on the care and feeding of both the company and its 
employees during a conversion/migration from one system to another.

I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very 
large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a 
traditional Order Entry system. 

I can't seem to convey that difference as management (read: those who don't use the 
computer) like the GUI and all of the nice links and screens. The worker bees are in a 
turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and 
forth as well as the absense of many functions that were present under the MV app. 
Their productivity has fallen 75% as it takes 4x longer to enter an order. 

There are no sales tax lookups, no product or customer lookups. You clearly cannot 
scroll through 35,000 line items. There's no easy alternate shipping addresses and the 
original reports leave a lot to be desired. The accounting package is appealing but a 
company doesn't exist just for the accounting dept. Not to mention all the 
hamburger-helper features i've installed over the last 6.5 years.

I also have to fabricate custom reports with Crystal Reports and/or Access as there 
are many fields of data that should be there like customer back orders, sample 
customers, customer categories and a whole truckload of sales reporting fields that 
simply don't exist. Am I wrong in concluding that Great Plains is just a glorified 
shopping cart application.

Has anyone else experienced this kind of mis-match, especially with great plains. At 
least i could inform the users that others have these growing pains. There doesn't 
seem to be a light at the end of the tunnel for them.

thanks in advance. 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How to launch remote browser from UniVerse server?

[Mark Johnson]

I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks.
You could provide your desired browser in the first parameter and the URL in
the second. Just because a small fraction doesn't use IEXPLORE doesn't mean
that 99.9 percent don't either. Everyone can figure this out for themselves.

- Original Message -
From: "Anthony Youngman" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, April 01, 2004 4:46 AM
Subject: RE: How to launch remote browser from UniVerse server?


Except that it assumes that IE is the default browser. And at home,
where my firewall is configured to BLOCK IE, it would probably get you
nowhere.

I'm not sure of the syntax, but something like

 CALL WIN.PCRUN(URL)

should fire up the url in the default browser. There were reports on
u2-users a couple of weeks back that this sort of thing (executing a
document) does work fine.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Johnson
Sent: 01 April 2004 04:53
To: U2 Users Discussion List
Subject: Re: How to launch remote browser from UniVerse server?

If running Wintegrate this databasic command works:

CALL WIN.PCRUN("IEXPLORE.EXE", URL)

where URL could be any web address. I use it often to retrieve shipping
from
UPS.com or hooking map sites to dispatching screens.

my 1 cent. can't help you on topic 2 unless you post the report as HTML
to a
PC file and have the URL be the file reference.

In fact, here's a sub to hook to any cust maint.

001 SUBROUTINE MAP01(ADDR, ZIP)
002 ***
003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL
004 * MAJ 121002
005 ***
006 CONVERT " " TO "+" IN ADDR
007 CONVERT " " TO "+" IN ZIP
008 PROG="C:\Program Files\Internet Explorer\IEXPLORE.EXE"
009
URL="http://maps.yahoo.com/py/maps.py?BFCat=&Pyt=Tmap&newFL=Use+Address
+Below&addr=":ADDR:"&csz=":ZIP:"&Country=us&Get%A0Map=Get+Map"
010 CALL WIN.PCRUN(PROG, URL)
011 RETURN
012 END

I see that you are in AU so adjust the URL in this example for the
appropriate country. I just go to the yahoo map page with an address and
cut/paste that url into MV and fixup.

Happy April 1. It's still yesterday here.


- Original Message -
From: "LeRoi Keiller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 10:39 PM
Subject: How to launch remote browser from UniVerse server?


> Hi
>
> I have a client (customer) who wishes to launch users' desktop
browsers
from
> a UniVerse server.
>
> 1/ How can this be done (actual instructions, if possible)
>   So far, UniObjects has been mentioned and DDE - but, any other
ideas.
Or,
> what are the instructions to actually do this?
>
> 2/ Once the above is possible, how could a UniVerse report be
displayed in
> the user's browser, for example?
>
> Thanks,
> LeRoi
> ___
> LeRoi Keiller
> Client Support - Technical
>
> UltraData - Vision to Reality
> Ph +61 3  9291 1700
> www.ultradata.com.au
>
>
>
> Disclaimer Notice
> This message contains privileged and confidential information intended
only
> for the use of the addressee named above.  If you are not the intended
> recipient of this message you are hereby notified that you must not
> disseminate, copy or take any action or place any reliance on it. If
you
> have received this message in error please notify Ultradata
immediately.
> Any views expressed in this message are those of the individual
sender,
> except where the sender specifically states them to be the views of
> Ultradata Australia Pty. Ltd.
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users






This transmission is intended for the named recipient only. It may contain
private and confidential information. If this has come to you in error you
must not act on anything disclosed in it, nor must you copy it, modify it,
disseminate it in any way, or show it to anyone. Please e-mail the sender to
inform us of the transmission error or telephone ECA International
immediately and delete the e-mail from your information system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911
7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1
212 582 2333.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How to launch remote browser from UniVerse server?

[Mark Johnson]

If running Wintegrate this databasic command works:

CALL WIN.PCRUN("IEXPLORE.EXE", URL)

where URL could be any web address. I use it often to retrieve shipping from
UPS.com or hooking map sites to dispatching screens.

my 1 cent. can't help you on topic 2 unless you post the report as HTML to a
PC file and have the URL be the file reference.

In fact, here's a sub to hook to any cust maint.

001 SUBROUTINE MAP01(ADDR, ZIP)
002 ***
003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL
004 * MAJ 121002
005 ***
006 CONVERT " " TO "+" IN ADDR
007 CONVERT " " TO "+" IN ZIP
008 PROG="C:\Program Files\Internet Explorer\IEXPLORE.EXE"
009
URL="http://maps.yahoo.com/py/maps.py?BFCat=&Pyt=Tmap&newFL=Use+Address
+Below&addr=":ADDR:"&csz=":ZIP:"&Country=us&Get%A0Map=Get+Map"
010 CALL WIN.PCRUN(PROG, URL)
011 RETURN
012 END

I see that you are in AU so adjust the URL in this example for the
appropriate country. I just go to the yahoo map page with an address and
cut/paste that url into MV and fixup.

Happy April 1. It's still yesterday here.


- Original Message -
From: "LeRoi Keiller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 10:39 PM
Subject: How to launch remote browser from UniVerse server?


> Hi
>
> I have a client (customer) who wishes to launch users' desktop browsers
from
> a UniVerse server.
>
> 1/ How can this be done (actual instructions, if possible)
>   So far, UniObjects has been mentioned and DDE - but, any other ideas.
Or,
> what are the instructions to actually do this?
>
> 2/ Once the above is possible, how could a UniVerse report be displayed in
> the user's browser, for example?
>
> Thanks,
> LeRoi
> ___
> LeRoi Keiller
> Client Support - Technical
>
> UltraData - Vision to Reality
> Ph +61 3  9291 1700
> www.ultradata.com.au
>
>
>
> Disclaimer Notice
> This message contains privileged and confidential information intended
only
> for the use of the addressee named above.  If you are not the intended
> recipient of this message you are hereby notified that you must not
> disseminate, copy or take any action or place any reliance on it. If you
> have received this message in error please notify Ultradata immediately.
> Any views expressed in this message are those of the individual sender,
> except where the sender specifically states them to be the views of
> Ultradata Australia Pty. Ltd.
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Data typing in MV Basic

[Mark Johnson]

Could I add that discussing data typing in MV Basic may not change what we
cannot control. The absense of true data typing, ie A, A$, A% or DIM A AS
STRING 50 is both a blessing and a curse. Such loose assignments only makes
us better and more careful programmers. This is one thing I enjoy about MV
in that files and records can be freely copied. I've got many frustrated
experiences trying to import/export/merge data in typed environments like MS
Access or SQL.

My 1 cent.

- Original Message -
From: "Mitchell, Stewart" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 3:30 PM
Subject: RE: Data typing in MV Basic


> Wol,
>
> It is not how the compiler deals with the information but how the runtime
> engine deals with the data.
> I have demonstrated the runtime engine types the data based on how it is
> entered in the source code.
> A = 1 is typed as a numeric by the runtime engine and A = "1" is typed as
a
> string. In an earlier
> post I provided the following proof.
>
>  TST
> 0001 DEBUG
> 0002 A = 1
> 0003 A = "1"
> 0004 STOP
> >RUN XP TST
>  TST:   2: A = 1
> :: S
>  TST:   3: A = "1"
> :: A/
> INTEGER: 1
> :: S
>  TST:   4: STOP
> :: A/
> STRING: T r L=1 `1'
> ::
>
> The program simply sets the variable A to 1 or "1" and when run it goes in
> to debug mode.
> I then stepped through each line and displayed the contents of the
variable
> A by typing A/ as you can
> see the runtime engine reports each line as INTEGER or STRING depending on
> how the data was entered in the
> source code.
>
> Regards,
> Stewart
>
> -Original Message-
> From: Anthony Youngman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 31 March 2004 19:15
> To: U2 Users Discussion List
> Subject: RE: Data typing in MV Basic
>
>
> Why?
>
> Let's work on the basic principal of "coercion occurs when necessary,
> and not before".
>
> The compiler detects "1" as a string literal. It stores it as a literal.
> The compiler detects 1 as a numeric literal. It stores it as a literal.
> (The compiler doesn't give a damn about strings or numerics - a literal
> is a literal is a literal)
>
> Therefore 'A = 1' and 'A = "1"' both result in IDENTICAL p-code.
>
> Therefore, unless you know how the compiler works, your conclusion is
> demonstrably flawed.
>
> Cheers,
> Wol
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of Mitchell, Stewart
> Sent: 31 March 2004 08:31
> To: 'U2 Users Discussion List'
> Subject: RE: Data typing in MV Basic
>
> A = 1 is held as an integer
> A = "1" is held as a string
> A = "1" + 0 is held as an integer
>
> Cheers,
> Stewart
>
> -Original Message-
> From: Anthony Youngman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 31 March 2004 17:00
> To: U2 Users Discussion List
> Subject: RE: Data typing in MV Basic
>
>
> You've missed the point! :-)
>
> These two statements apparently have exactly the same effect - the
> question is do they?
>
> A = 1
> A = "1"
>
> (In the stuff I'm writing, they'd be the same - everything is a string
> until it is forced into numeric.)
>
> Cheers,
> Wol
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of Jim Garratt
> Sent: 31 March 2004 07:39
> To: U2 Users Discussion List
> Subject: Re: Data typing in MV Basic
>
> Would this not be set by your initialisation of the variable A.
>
> eg A = '';*Alpha/Numeric or  String
>  A = 0   ; Numeric
>
>
> - Original Message -
> From: "Trevor Ockenden" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 31, 2004 2:25 PM
> Subject: Re: Data typing in MV Basic
>
>
> > Will, I stand corrected on that one. So far in 20 odd years of
> programming
> > in MV I haven't needed to worry about it.
> >
> > Now Will raises a terrific question. If A = "1" assigns 1 as numeric.
> How
> > would you determine if A contained a numeric or a string in this case?
> >
> > My short answer is - why would I need to know? BUT I'm sure somebody
> has a
> > good answer to that one.
> >
> > Cheers
> >
> > Trevor Ockenden
> > Open Systems Professionals
> >
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 31, 2004 4:10 PM
> > Subject: Re: Data typing in MV Basic
> >
> >
> > > In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time,
> > > [EMAIL PROTECTED] writes:
> > >
> > >
> > > > A = 1 assigns a numeric integer. The expression need not contain
> > operators
> > > > (+,-,etc) to be numeric.
> > > > A = "1" assigns a string however, as you have explicitly declared
> it
> to
> > be
> > > > string.
> > > > A = "1" + 2 assigns a numeric integer value (3) as the result is
> > numeric.
> > > > A = "one" + 2 assigns a zero - according to the error message.
> > >
> > > yes
> > > no
> > > yes
> > > yes
> > >
> > > they all assign numerics imho
> > > "1" is cast as a numeric because the system 

Re: The lists are closing

[Mark Johnson]

Perhaps if IBM or whomever is sponsoring the U2UG.org site is listening to
the feedback of the current members of this list that they will respond in a
'customer-oriented' kinda way. That's why it's called SOFTware. It can
change to meet the needs of its customers.

I agree with the reduction of efficiency that the new method will cause.
Hopefully IBM can cause a change to accomodate the high level of service the
oliver list provided.

my 1 cent.

- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 30, 2004 5:18 AM
Subject: RE: The lists are closing


> Listen, Will "the blind, deaf and possibly dumb" Johnson
>
> Are you hearing nothing? There are those of us who don't
> live in the
> land of the mighty dollar. We have to pay for our traffic,
> we have
> employment contracts that forbid us from internet access
> during the day,
> yet we still need access to U2 info.
>
> What do _you_ suggest we do?
>
> I've subscribed to your glorious forum, I get wee posties
> saying there
> are people talking about juicy thangs, but I cannot get to
> see these.
>
> What do _you_ suggest I do?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> On Behalf Of [EMAIL PROTECTED]
> Sent: 29 March 2004 09:03
> To: U2 Users Discussion List
> Subject: Re: The lists are closing
>
>
> 1) We DO want to leave the archives at indexinfocus.
> 2) We DONT want to replicate the archives onto u2ug
> 3) We DONT want the lists to continue
>
> Go to the web site, and enter each forum you are interested
> in and click
> on SUBSCRIBE this will make all responses come to your email
> box just as
> they do now.  You can register, but if you dont SUBSCRIBE
> you wont be
> seeing nothing Will
>
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Modern Universe - was: The lists are closing

[Mark Johnson]

I agree that this list will be sorely missed. It has a genuine technical
value as well as a human value for some of the soft topics that floated
around. Plus, it helped identify some quite knowledgable people that I hope
still contribute later.

I've gotten some UV/UD and even D3 and AP-Pro and other native advice from
this list. Even the VAR for one of my clients frequents this list with
questions and answers.

Anyway, thanks to Clif and everyone for all their help over the years. See
you on the other side.

Mark Johnson

- Original Message -
From: "Trevor Ockenden" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 30, 2004 12:35 AM
Subject: Re: Modern Universe - was: The lists are closing


> Joe
>
> You must have more time on your hands than I but I will try to reply to
you
> before this list terminates.
>
> This list has helped me and I'm sure many others overcome our ignorance or
> lack of experience etc. When genuine problems are encountered we usually
go
> through our support channels and they get fixed (usually). In fact only
the
> other day a small issue was confirmed (in my mind) as an introduced bug
and
> I have since reported it to IBM with their response being "acknowledged"
and
> "will be in the next release" etc.
>
> Now, one of my pet topics is typing!
>
> You are partly correct when you say UV treats all data as strings.
However,
> if the UV programmer is careful he/she can get it to do maths processing.
> Variables within UVBasic are string unless the result of an expression is
> numeric whereby it becomes numeric. If it needs to be treated as string UV
> will automatically convert it back to string. Now this makes programming
> much easier and if the programmer is careful not to treat it as a string
> he/she can perform many mathematical operations on it without it becoming
a
> string again.
>
> Now this brings me to the next point when referring to typing.
>
> UV stores numeric data such as dates, time and numbers as a string value
> with no decimal point etc. quite deliberately. This technique makes
> selection or searches on the file much more efficient than 'mainstream'
> searches as they must use the numeric capabilities of the processor to
carry
> out the necessary comparisons whereby UV simply does string comparisons.
>
> Now at this point I must draw back a little as I have too many comments to
> make...
>
> The procedural code you provide is crude to say the least and yes there
are
> many tools that allow you to use more 'business rules' and so forth.
>
> Finally, in Australia where we generally are considered to be minor
players
> there is an UV site with 2000 plus concurrent users on a wide area network
> that processes 3-4 million transactions per day 7x24 and has to date been
> first to bring new technologies to the market before any 'mainstream'
> products. Poof is in the eating I'm afraid.
>
> Cheers
>
> Trevor Ockenden
> OSP
>
> - Original Message -
> From: "Joe Eugene" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 30, 2004 3:06 PM
> Subject: RE: Modern Universe - was: The lists are closing
>
>
> >
> > Trevor,
> >
> > I am a member of serveral other Technical Forms. When i have found
> problems
> > with any software, have brought it up on several occasions. A few of
these
> > issues
> > were acknowledged by the Software Vendor and later architectural changes
> > were made to rectify the issue.
> >
> > On this Forum, i have rarely heard anybody talk about Problems OF UV...
> Why?
> > Perhaps they are too big Loyalists of UV to approve of the Problem
> > Do you know what this leads to...the Vendor is never going to improve
the
> > software,
> > unless the Clients asks for more..
> >
> > Do you think VB.NET will Perform better than C#.NET? C# is a strongly
> typed
> > language, just like java...this helps it Peform and scale better.
> >
> > Our UV Developers tell me, everything in UV is treated as Strings..
> > Do you think MATH Functions will Perform better in UV than a DataBase
that
> > supports DataTypes?
> > A String can be any Possible Combinations, so the the underlying
> > Language/Compiler takes
> > more time to achive the same results. Leave alone MATH... Try some BIG
> > Loops.
> >
> > Another Big Problem..Unicode on any MainStream Database is a very easy
> thing
> > to do..
> > No effort required. We were trying to get Unicode into UV For about 4
> > Months. We failed
&g

Re: OKI Code 39 BarCode

[Mark Johnson]

One could check www.okidata.com to see if there's any support for manual
printer driver stuff like bar codes. I use www.hp.com to get beaucoups of HP
PCL stuff.

my 1 cent.

- Original Message -
From: "Ray Buchner" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 9:42 AM
Subject: OKI Code 39 BarCode


> I'm have little documentation for my OKI's and am trying to print a Code
39
> Bar Code on my pick tickets that contains the pick ticket number.  That is
> the ID in the below example.
>
> What I have is:
>
> ESC DEL B 10 :ID
>
> Is this correct?  It does not seem to be functioning.
>
> -Ray
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The lists are closing

[Mark Johnson]

Thanks Clif for providing the forum for the years.

My only concern is that while it has been great for UV/UD questions, I have
also received good advice about D3 and even hooked up with someone regarding
an old copy of AP-Pro. Thus, would/could there be an 'all other MV' forum
such that I could have my cake and eat it too.

Not for nothing, but I did enjoy the diversity of the topics, UV/UD and
others in my single email inbox. Even though I wasn't looking for any
specific topic, just scanning the various topics and responses was useful.

thanks.

Mark Johnson

- Original Message -
From: "Moderator" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, March 27, 2004 3:14 AM
Subject: The lists are closing


> Dear Friends:
>
> After 10+ years of either hosting or supporting the info-prime,
> info-unidata, info-vmark, info-informix, and u2-users etc lists, I have
> decided to shut down the list server.
>
> u2-users and u2-community will cease to exist as of 1 April 2004. IBM is
> officially supporting the efforts of the new U2UG.org group. (Yes. I am
> a member of the establishing Board of that group. So this is not a
> "coup" or Sour Grapes!) If you check out the forums that have been set
> up, I think you will will see that they cover everything anyone has
> asked for over the years in this group.
>
> I *really* want to encourage ALL of you to come over the the
> www.u2ug.org site and support this effort. This is *exactly* what many
> of you on this list have wanted over the years. If Not Now, When?
>
> Almost ten years on my Watch. How many years before that on Mike
> O'Rear's Watch? In the Net World, this has been a Hell of a good run. (I
> just couldn't resist tripping the Net Nanny filters one last time  evil grin>)
>
> I'll see all of you on the other media, ok?
>
> --
>
> Regards,
>
> Clif
>
> ~~~
> W. Clifton Oliver, CCP
> CLIFTON OLIVER & ASSOCIATES
> Tel: +1 619 460 5678Web: www.oliver.com
> ~~~
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: U2 file articles in International Spectrum

[Mark Johnson]

Is OHM a pretty big player in the application arena? Are they today's
Eclipse? I keep seeing their job postings.

Thanks.

- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, March 21, 2004 11:18 PM
Subject: Re: U2 file articles in International Spectrum


> Ross,
> L-O-quint, as always. The show was 200-ish people in a nice sized
> venue with 75 or so classes on everything from products (including
> VISAGE and Zeus), technology (PDA programming, OO programing, GUI
> overview), technique (AIX/UniVerse Pitfalls, Help Desk Survival), and
> more. The floor had a wide range of vertical and database vendors,
> supplemented by booths for Database Trends, Spectrum Magazine,
> horizontals like OHM, and the Spectrum Deli (I kid you not).
> It was three and one half days of Revelation, Reality, U2,
> UniVision, D3, jBASE, and more. It marked the first Spectrum (that I
> know of) where Microsoft bought breakfast and ran special seminars.
>
> - Charles "Hey, I forgot to take a bribe before I spilled my guts"
> Barouch
>
> Ross Ferris wrote:
>
> >Ahhh, what do I want to know  and the answer given by all good users
is "if I knew what I didn't know then I wouldn't have to ask, but I don't
know WHAT I don't know, so I don't know !" (or sumfin like dat)
> >
> >Ross Ferris
> >Stamina Software
> >Visage – an Evolution in Software Development
> >
> >
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: LOCATE Command - Help :(

[Mark Johnson]

This is a similar issue with the LOCATE and understanding what level it's
trying to locate in.

For example, let's say you just read in a REC that has attributes, values
and sub values.

If one of the attributes may contain the value "FRED" then the reference for
REC would be:

LOCATE "FRED" IN REC SETTING POS...

and POS would be the attribute FRED was in. Notice REC is alone without any
<>.

If attribute 5 could have a whole value of TOM, then the reference would be:

LOCATE "TOM" IN REC<5> SETTING POS.

and POS would be the value TOM was in.

If a rare circumstance has "BILL" in a value in REC<7,10>, then it's
LOCATE "BILL" IN REC<7,10> SETTING POS
and POS would be the subvalue BILL was in.

Basically it's one level up.

If you READV A5 and are LOCATING for a simple multi-value of "SUE", then you
use

LOCATE "SUE" IN A5<1> SETTING POS
not
LOCATE "SUE" IN A5 SETTING POS

Reason: The LOCATE doesn't know that A5 was the result of a READV. It very
well could be the start of something attributed later but now just has a lot
of multi-values in attribute 1.

my 3 cents.
- Original Message -
From: "Kate" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, March 19, 2004 10:42 PM
Subject: LOCATE Command - Help :(


> Hi!
>
> I am trying to accomplish the following
>
> 1) Build a header for all possible dates for a person with certain data in
it.  e.g.  one person might have 3 dates where they had activity but another
person might have 5 dates with activity, but I want the header to have all
possible dates with activity.  So the Header Date variable contains all
possible dates.  And that prints fine.
>
> LOCATE V.DATES IN X.DATE.LIST<1,1> BY "AR" SETTING LOC ELSE
> INS V.DATES BEFORE X.DATE.LIST<1,LOC>
> END
>
> But then for each person, I want to have the values print under the
correct date headings.  And it changes for each page.
>
> 2)  For each record:
>  a)  obtain the # of dates and print the values to print under the
correct dates for each person
>
> LOCATE X.AB.DATE IN X.DATE.LIST<1,1> BY "AR" SETTING POS THEN
> IF VALUE = 'B' THEN
> X.AB.PRINT<1,POS> = TRIM(X.AB.TYPE)
> END
> END
>
> Then I remove the @VM's and print X.AB.PRINT.  It prints the values but
all in one sequence.  Not in the proper position.
>
> Can anyone tell me what I am doing wrong?
>
> Thanks for any help you can pass my way.
>
> Kate
>
>
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Alpha-Micro to D3

[Mark Johnson]

I don't know. It appears to be either a 486 or P1 vintage. Early 90's
perhaps.
thanks.
- Original Message -
From: "Dave S" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, March 18, 2004 12:35 PM
Subject: Re: Alpha-Micro to D3


> What year model is that Alpha-Micro system ?
>
> Ron White <[EMAIL PROTECTED]> wrote:
> - Original Message -
> From: "Mark Johnson"
> To:
> Sent: Wednesday, March 17, 2004 12:39 PM
> Subject: Alpha-Micro to D3
>
>
> Dear All:
>
> One of my clients has a 40 user Alpha Micro native system that's in need
of
> a migration. I want to migrate to D3/W2K. I've done a few and am
comfortable
> supporting it remotely as a consultant instead of as an employee. While I
> welcome the possibility of going to 'nix U2 or NT U2, I want to focus on
> D3/W2K.
>
> Has anyone had any experience converting from Alpha Micro to D3 or UD/UV
and
> are there any pitfalls regarding incompatible source code. I can expect
some
> slight differences in syntax but I'm looking to see if there's a major
> roadblock. I don't suspect anything beyond PQ proc but IIRC an earlier
> conversion from GA to AP-Pro brought with it some missing commands like
SWAP
> and MAX.
>
> Thanks in advance.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> ---
>
> D3 does have the SWAP statement, but like several other statements you
> need to but a $OPTIONS EXT compiler directive in your program or it
> will not compile. My documentation does not mention a MAX statement.
>
> I wish you luck dealing with Raining Data. At my earliest convenience I
> will kick D3 and Raining Data out the back door and run everything on
> UniVerse. RD has raised their maintenance to 90 USD per seat and have
> instituted a 50% charge to get a major release (release 8.0 is due out
this
> year).
> They have mostly stopped enhancing the product and to get anything fixed
or
> added to the product you must submit a "business requirements statement"
to
> them convincing them that it is in their business interest to provide the
> fix or
> function. That doesn't sound like a company that is very interested in
> keeping
> D3 around for the long haul.
>
> YMMV
> Ron White
>
>
>
>
> ---
> [ Eckel certifies this E-mail to be virus free. ]
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less spam
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Alpha-Micro to D3

[Mark Johnson]

Perhaps I've been buffered by the wrath of RD as i don't work with them
directly. I work with a company called Zumasys and they've been incredibly
helpful with the migrations and new systems that I've installed.

I did go to bat with RD directly discussing a licensing issue and was able
to convince them of my perspective. It was regarding the 50% discount on D3
for currently supported native systems. There was a loophole that i
identified and they accomodated me. They do play hardball on virtually
everything else.

I have existing UV and UD clients, all of which had their environments
converted prior to my involvement. Thus, I've never experienced the birthing
pains of converting from native to U2. Observing all the conversations on
this forum regarding the release levels, implementations, connectivity etc,
and that I am an outside consultant and not an employee, a delivered virgin
D3 system on W2K is about as clean an environment one could expect to start
from. Pop in the last file-save, do the restore and compile. In fact,
converting from AP-pro doesn't even need the compiling.

I observe all the unix and NT commands being offered and they're out of my
league. Plus, my clients, being native to begin with, aren't aching for the
ODBC, triggers, sockets, IIS and other magic features of today. They just
want to continue with their green screen apps.

Thanks.

Someone earlier posted a comparison between Pick and Microsoft. It stated
that MS is happy with 10% paying licenses out of 100,000,000 while Pick
wanted 100% paying licenses out of 10,000.


- Original Message -
From: "Ron White" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, March 18, 2004 9:22 AM
Subject: Re: Alpha-Micro to D3


>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 17, 2004 12:39 PM
> Subject: Alpha-Micro to D3
>
>
> Dear All:
>
> One of my clients has a 40 user Alpha Micro native system that's in need
of
> a migration. I want to migrate to D3/W2K. I've done a few and am
comfortable
> supporting it remotely as a consultant instead of as an employee. While I
> welcome the possibility of going to 'nix U2 or NT U2, I want to focus on
> D3/W2K.
>
> Has anyone had any experience converting from Alpha Micro to D3 or UD/UV
and
> are there any pitfalls regarding incompatible source code. I can expect
some
> slight differences in syntax but I'm looking to see if there's a major
> roadblock. I don't suspect anything beyond PQ proc but IIRC an earlier
> conversion from GA to AP-Pro brought with it some missing commands like
SWAP
> and MAX.
>
> Thanks in advance.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
> ---
>
> D3 does have the SWAP statement, but like several other statements you
> need to but a $OPTIONS EXT compiler directive in your program or it
> will not compile.  My documentation does not mention a MAX statement.
>
> I wish you luck dealing with Raining Data.  At my earliest convenience I
> will kick D3 and Raining Data out the back door and run everything on
> UniVerse.  RD has raised their maintenance to 90 USD per seat and have
> instituted a 50% charge to get a major release (release 8.0 is due out
this
> year).
> They have mostly stopped enhancing the product and to get anything fixed
or
> added to the product you must submit a "business requirements statement"
to
> them convincing them that it is in their business interest to provide the
> fix or
> function.  That doesn't sound like a company that is very interested in
> keeping
> D3 around for the long haul.
>
> YMMV
> Ron White
>
>
>
>
> ---
> [ Eckel certifies this E-mail to be virus free. ]
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Alpha-Micro to D3

[Mark Johnson]

Dear All:

One of my clients has a 40 user Alpha Micro native system that's in need of a 
migration. I want to migrate to D3/W2K. I've done a few and am comfortable supporting 
it remotely as a consultant instead of as an employee. While I welcome the possibility 
of going to 'nix U2 or NT U2, I want to focus on D3/W2K.

Has anyone had any experience converting from Alpha Micro to D3 or UD/UV and are there 
any pitfalls regarding incompatible source code. I can expect some slight differences 
in syntax but I'm looking to see if there's a major roadblock. I don't suspect 
anything beyond PQ proc but IIRC an earlier conversion from GA to AP-Pro brought with 
it some missing commands like SWAP and MAX.

Thanks in advance.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Help Needed regarding performance improvement of delete query

[Mark Johnson]

I'm honored. Can you convince my clients to allow me to replace their
thousands of GOTO'd programs with this structure. If you think my example
was error prone, you should see the crap I have to support.

mark (uses GOTO's sparingly) johnson

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 6:08 PM
Subject: Re: Help Needed regarding performance improvement of delete query


> Gives Mark the "most improved player" award.
> Will
>
> In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > LOOP WHILE READNEXT ID DO
> >READV DTE FROM F.MASTER, ID, 5 THEN
> > IF DTE LE DEL.DATE THEN
> >  DELETE F.MASTER, ID
> >  DELETE F.REFERENCE, ID
> > END
> >END
> > REPEAT
> >
> > there you go (to).
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Looking for associated multi-value algorithm...

[Mark Johnson]

Perhaps the most glaring problem here is the level of the LOCATE. Since
SPECIAL.PARTS is a value and thus possibly multi-valued, the ,STARTPOS
indicator suggests to the LOCATE to look at the first subvalue of the
value'd. Somehow, especially since STARTPOS isn't previously defined, it
become zero and <1,0> is the same as <1> which may accidentally satisfiy the
LOCATE.

Remove the STARTPOS from the <> in the LOCATE and the
STARTPOS=SPECIAL+1 as they don't contribute anything.

Also, this looks like a FIFO/LIFO algorithm. What are the failures if the
qtys don't match. The LOCATE should eliminate the FOR...NEXT loop unless you
have the PART.NBR in the <12> more than once. In any case, the FOR...NEXT is
is useless.

If the PART.NBR is in <12> more than once, use FOR...NEXT and do a simple
equals test on <12>. I don't believe that LOCATE can find occurrences of
PART.NBR after the first one it finds. At least using numbers inside the <>.
Perhaps LOCATE X in Y<1>,STARTPOS on the outside. I don't use it.

FInally, if it's any contribution (and it's my purely non-technical
opinion). Remove all the extraneous uses of the prefix SPECIAL. That makes
it hard to read as all the variables start with SPECIAL and it's hard to
identify their purpose quickly. I'm sure I'll get flamed for this, but it
does make it more readable.

PARTS=SPECIAL.REC<12>
C.PARTS=DCOUNT(PARTS,VM)
QTYS=SPECIAL.REC<14> ; PRICES=SPECIAL.REC<16>
QTEMP=0
FOR I=1 TO C.PARTS
  IF PARTS<1,I>=PART.NBR THEN
   QTY=QTYS<1,I>
   IF QTY < QTY.REQUESTED AND QTY > QTEMP THEN
DATA.OUT=OCONV(PRICES<1,I>,MDP)"R#12"
QTEMP=QTY
   END
END
NEXT I

my 2 cents.


I'm looking for an algorithm for searching through a group of associated
multi-value fields.  The fields are F12 (PartsList), F14 (From Qty) and F16
(Unit Price).  I can't depend on these being in any certain order, just that
the associated fields will be in identical order.  What I want to return is
the Unit Price (F16) given PART.NBR and QTY.REQUESTED.  I've got a code
snippet of what I think will work, but I'd like to get some feedback on
it...it won't work because, there's a better way of doing this, etc.
Thanks.

SPECIAL.PARTS = SPECIAL.REC<12>
SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM)
SPECIAL.FROM.QTY.TEMP = 0
FOR SPECIALPART = 1 TO SPECIALCOUNT
   LOCATE PART.NBR IN SPECIAL.PARTS<1,STARTPOS> SETTING SPECIAL ELSE EXIT
   SPECIAL.FROM.QTY=SPECIAL.REC<14,SPECIAL>
   IF SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN
  SPECIAL.FROM.QTY = SPECIAL.REC<14,SPECIAL>
  SPECIAL.PART.PRICE = SPECIAL.REC<16,SPECIAL>
  TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) "R#12"
  SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY
   END
   STARTPOS = SPECIAL + 1
   FIRST = 0
NEXT SPECIALPART
DATA.OUT=TEMP.OUT
RETURN
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Help Needed regarding performance improvement of delete query

[Mark Johnson]

For those who cannot read GOTO's, here's the code expressed goto-less.

LOOP WHILE READNEXT ID DO
READV DTE FROM F.MASTER, ID, 5 THEN
 IF DTE LE DEL.DATE THEN
  DELETE F.MASTER, ID
  DELETE F.REFERENCE, ID
 END
END
REPEAT

there you go (to).


- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 4:33 PM
Subject: Re: Help Needed regarding performance improvement of delete query


> In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > 10 READNEXT ID ELSE STOP
> >READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10
> >IF DTE GT DEL.DATE THEN GOTO 10
> >DELETE F.MASTER, ID
> >DELETE F.REFERENCE, ID
> >GOTO 10
>
> I count three goto's
> So three times through the spank machine.
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

D3 Automatic Faxing

[Mark Johnson]

Dear All:

One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his 
system generate roughly 100 faxes per day for invoices and purchase orders.

I would be interested what the off-the-shelf approach would be. He has a US Robotics 
Modem connected to a serial port and all of his users are PC's running Accuterm.

One thought is the user-level Blat-like approach whereby the document is downloaded to 
the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. 

I'm open for suggestions.

Thanks in advance.

Mark Johnson
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Terminology

[Mark Johnson]

So what does "Service Level Agreement Metrics" or "Operational Level
Agreement Metrics" mean.

Is this the new MTBF, ie Mean Time Between Failures.

thanks.
- Original Message -
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 10:47 PM
Subject: RE: Terminology


I'm on the wrong side of the world, but IIRC DataFlo is a product, like
InfoFlo - these days out of the Epicore stable

I'd imagine SLA would be a "Service Level Agreement" and OLA would be an
"Operational Level Agreement", both relating (more or less) to the uptime &
availability of a system

Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-----Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mark Johnson
>Sent: Tuesday, 16 March 2004 12:56 PM
>To: [EMAIL PROTECTED]
>Subject: Terminology
>
>Dear all:
>
>I'm not familiar with the following as referred to by MV: SLA and OLA
>metrics.
>
>Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL
>like Eclipse.
>
>thanks.
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Terminology

[Mark Johnson]

Dear all:

I'm not familiar with the following as referred to by MV: SLA and OLA metrics.

Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse.

thanks.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Help Needed regarding performance improvement of delete query

[Mark Johnson]

I have a client that needs roughly 250,000 items removed monthly from a file
containing 5-6 million records.

Since there is no need to use the keys (records) for any other purpose
except for deleting because they are old, a standard data/basic SELECT
statement is just about as fast as you can get. It isn't encumbered by the
number of selected keys as it's not retaining them for any purpose.

This simple program looks like this:

OPEN "MASTER" TO F.MASTER ELSE STOP
OPEN "REFERENCE" TO F.REFERENCE ELSE STOP
DEL.DTE=ICONV("01/02/2003","D")
SELECT F.MASTER
10 READNEXT ID ELSE STOP
READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10
IF DTE GT DEL.DATE THEN GOTO 10
DELETE F.MASTER, ID
DELETE F.REFERENCE, ID
GOTO 10
END

Of course if there's additional use for the deleted keys, then use another
approach.

my 1 cent.
- Original Message -
From: "ashish ratna" <[EMAIL PROTECTED]>
To: "Anthony Youngman" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 7:55 AM
Subject: RE: Help Needed regarding performance improvement of delete query


Hi Wol,

The scenario is that-

We have a master file having more than 3-4 million records and have
corresponding reference file which contains reference data for this master
file.

Now we start our purge program which selects records from master file on the
basis of date. Corresponding data should be deleted from the other file
(reference file).

For this requirement we have adopted the approach that- select the record
from master file on the basis of date. Save the list of these records, then
on the basis of this list select the records from reference file.

Issue is that this list contains more than 0.5 million and I want to take
few (say 10,000 at a time) record ids from this list for further processing.

Any pointers for this problem will be very helpful.

Thanks in advance.

Ashish.



-Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 4:50 PM
To: ashish ratna
Subject: RE: Help Needed regarding performance improvement of delete
query


Ahhh

I thought you were selecting records and deleting them. So the first
thousand would have disappeared, and you would obviously get a different
thousand next time round because the first lot would have gone :-)
Sounds like that's not the case.

In that case, do you have a field that is repeated across many records,
but where each individual value (or range of values) wouldn't return too
big a bunch of records? Or do you have a numeric id - you could declare
an index on that ...

Let's take that numeric id idea - and then you'll have to build on it
for yourself. Declare an i-descriptor as @ID[3]. That logically
partitions your file into a thousand pieces. Declare an index on this.
The first term in your select will then be "WITH IDESC EQ
whatever-number-you-want". That'll reduce the load on the database for
each pass, you'll just need to wrap it in a loop where "whatever-number"
goes from 0 to 999

Actually, what I would probably do is declare my i-descriptor as
INT(@ID/30) and then run this purge daily with "whatever-number" as
today's day. Obviously, it'll do nothing on the 31sts, and in March
it'll do two month's work on the 29th and 30th, but you've reduced the
"hit" on the system considerably.

Without knowing what you're doing in more detail, it's difficult to give
you any proper advice, but certainly I'll try and think of any tips that
you can build upon, like this. But you need to work out what's right for
you :-)

NB Any reason for taking this off the mailing list? By all means cc it
to me, but if you keep it on the list there are other people who may be
able to help too - I'm very good at overviews, but I fall short on the
logic - I think there is a way to get the next thousand records, but I
haven't got a clue what the syntax is ...

Cheers,
Wol

-Original Message-
From: ashish ratna [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 10:33
To: Anthony Youngman
Subject: RE: Help Needed regarding performance improvement of delete
query

Hi,

Thanks for the nice suggestions.
I have another question that, using SAMPLE once I process 1000 records
(using SAMPLE 1000), how can I select next 1000 records in next run
(i.e. 1001 to 2000 records and so on)?

I was trying few combinations but didn't succeeded. Can you tell me the
syntax for that?

Thanks again.

Regards,
Ashish.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Anthony Youngman
Sent: Monday, March 15, 2004 2:32 PM
To: U2 Users Discussion List
Subject: RE: Help Needed regarding performance improvement of delete
query


This might help speed things up a bit ...

Firstly, of course, is your file properly sized?

Secondly, (and in this case you will need to run the SELECT / DELETE
sequence several times) try putting a SAMPLE 1000 (or whatever number
makes sense) at the end of your select.

Basically, this will mean that the SELEC

Re: Formating Negative Numbers

[Mark Johnson]

I'm gonna bet that code is the answer.

- Original Message -
From: "Phil Walker" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 11:53 PM
Subject: Formating Negative Numbers


> Does anyone have a quick way to format a negative number in a field filled
> with zeros such that the '-' sign appears at the front replacing the 1st
> zero.
>
> For example
>
> -2 using 'R%6' becomes -2
> 2 using 'R%6' becomes 02
>
> But I would like -2 to become -2 and 2 to remain 02. I know I
could
> write code to do this, but I was wondering if you can do it just using the
> fmt syntax.
>
> Regards,
>
> Phil Walker
> +64 21 336294
> [EMAIL PROTECTED]
> infocusp limited
> \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz
> DISCLAIMER:  This electronic message together with any attachments is
> confidential.  If you are not the intended recipient, do not copy,
disclose
> or use the contents in any way. Please also advise us by return e-mail
that
> you have received the message and then please destroy. infocusp limited is
> not responsible for any changes made to this message and / or any
> attachments after sending by infocusp limited. We use virus scanning
> software but exclude all liability for viruses or anything similar in this
> email or any attachment
>
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UniVerse on NT vs *nix - Higher User Counts with W2003?

[Mark Johnson]

Sidebar on sizing. One client of mine had 240 users on a 75 mhz 486 R90
system. Around 30 printers with the rest as users both as local and
multiplexed. Slow? Sort of. Working? Yes. MTBF? Incredibly infrequent given
the user count.

The system was written in ScreenGen which was ABS heavy. Also the
application was heavily app and system indexed. Converted to D3/AIX with
beaucoups of Digi-Boards. Flamethrower.

my 1 cent.
- Original Message -
From: "Steven M Wagner" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 12:28 AM
Subject: RE: UniVerse on NT vs *nix - Higher User Counts with W2003?


> Stephen M. O'Neal, CDP said that "...currently, most W2000 installations
> max out at about 300 users."  I wonder how often sites that plan for
higher
> user counts go with a *nix solution to start with?
>
> For what it is worth, I had 200 UV9.6.2.8 users on a WinNT 4.0 box.  And
> this was with a Compaq Proliant 5500 with 512MB of RAM and two 200Mhz
CPUs,
> Xeons I believe.  And no complaints about speed.
>
> 
>
>
> --
> Steven M Wagner
> [EMAIL PROTECTED]
> Cary, North Carolina, United States of America
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] Would anyone be interested in UV based bible software?

[Mark Johnson]

Aren't there bible applications already written. I don't know of them but
i've heard of them as they can quickly cross reference passages and named
references.


- Original Message -
From: "Glenn W. Paschal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 11:03 PM
Subject: [UV] Would anyone be interested in UV based bible software?


> I am working on a bible application for my personal use.  If anyone else
> would be interested in this type application, let me know.  I would
welcome
> the inputs and ideas on what it should be capable of.
>
> Thanks,
>
> Glenn W. Paschal
> PasTech LLC
> Computer Consulting
> ph. (931) 526-9631
> fx. (931) 526-9678
> email.   [EMAIL PROTECTED]
> web.   www.pastech.net
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UniVerse on NT vs *nix

[Mark Johnson]

My 2 cents: Are the persons applying the pressure MS preferred for its own
sake or is it the result of an actual comparison of AIX to W2003. A client
of mine bought into an MS app because of the implied greatness of MS only to
have a huge disappointment.

mark
- Original Message -
From: "Sara Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 08, 2004 6:48 PM
Subject: UniVerse on NT vs *nix


> I am under considerable pressure to convert from UniVerse on AIX to
UniVerse
> on Windows 2003.
>
> We have licenses for 320 users and do get up to this number at times
> although 300 is more normal.
>
> We run up to 30 phantom processes during the day above this interactive
user
> count.  At times these would be running in parallel, processing sections
of
> our customer base.  This is a daily event during the afternoon whilst
other
> users are doing normal work.
>
> Currently we run UniVerse 10.0.11 on an IBM p660 with 4 cpus and 7Gb ram.
> We also run Oracle and Vantive on this same box which is why the ram is so
> high.  We transfer data between UniVerse and Oracle real time using BCI &
> OpenLink.  The reverse is an in-house Oracle Pipes development which is
> gradually being replaced by UniObjects for Java.  I anticipate we would
need
> to run these applications on separate boxes if under Windows 2003.
>
> Our DBAs, both UniVerse and Oracle, are reluctant to go down this path as
> they believe they will not have the same ability to monitor their systems.
>
> I would appreciate comments, good and bad, from anyone with experience of
> this number of users in an Windows environment.  Email me off-line if this
> seems appropriate.
>
> Thanks in anticipation
> Sara Burns
>
> Sara Burns (SEB)
> Project Leader (Vantive)
> Public Trust
> Phone: +64 (04) 474-3841 (DDI)
>
> Mobile: 027 457 5974
> < 
mailto:[EMAIL PROTECTED]>
>
> Information contained in this communication is confidential. If you are
not
> the intended recipient the information should not be used, disclosed,
copied
> or commercialised. The information is not necessarily the views nor the
> official communication of Public Trust. No guarantee or representation is
> made that the communication is free of errors, virus or interference.
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Pick AP-Pro Discs

[Mark Johnson]

Is that a URL or how do i get into it.

thanks
> I assume you've asked the question on comp.databases.pick?
> If not, you may get more joy there.
> 
> Brian 
> 


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Pick AP-Pro Discs

[Mark Johnson]

Thanks. I will try it.
- Original Message - 
From: "Brian Leach" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, March 05, 2004 9:01 AM
Subject: RE: Pick AP-Pro Discs


> Mark,
> 
> I assume you've asked the question on comp.databases.pick?
> If not, you may get more joy there.
> 
> Brian 
> 
> > 
> > I'll restate the question:
> > 
> > Does anyone have the box, manuals and installation diskettes 
> > for AP-Pro for the Pentium I system that they could give/loan/sell?
> 
> 
> 
> This email was checked on leaving Microgen for viruses, similar
> malicious code and inappropriate content by MessageLabs SkyScan.
> 
> DISCLAIMER
> 
> This email and any attachments are confidential and may also be
> privileged.
> 
> If you are not the named recipient, please notify the sender
> immediately and do not disclose the contents to any other
> person, use it for any purpose, or store or copy the information.
> 
> In the event of any technical difficulty with this email, please
> contact the sender or [EMAIL PROTECTED]
> 
> Microgen Information Management Solutions
> http://www.microgen.co.uk
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Pick AP-Pro Discs

[Mark Johnson]

I'll restate the question:

Does anyone have the box, manuals and installation diskettes for AP-Pro for
the Pentium I system that they could give/loan/sell?

I have a new client that I want to break into the Pick world
with an inexpensive application to start. I can develop their
new app on my own AP-Pro yet in 2 months they will want their
own system. We've explored the concepts of a W2K/D3 or U2 box
and its cost would kill the deal. I want to get my foot in the
door and as they grow, we can convert later.


Thanks for all that replied with offers of alternate pick environments but
given my time constraints I don't want to venture into something new at this
time. I am comfortable with AP-Pro, installation & support-wise.

I have many clients on a variety of MV platforms and AP-Pro is the most
appropriate for this situation. I know how to install, remove, create
accounts etc on it.

Oddly enough, i've not been in on the decision for which MV that my other
clients have. I just come in after the original installers take their money
& run with no application support. This client has zero Pick background and
is running an app on dBase 3. AP-Pro would be nirvana for them.

Thanks again.

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] Variable never assigned a value warning

[Mark Johnson]

Not to mention the infidel CLEAR statement that does the same thing, hides
errors.

I believe the practice of variable assignment at the top is a practice
brought over from other languages where all variables apparently need to be
defined up front with DIM statements and variable types. I support some QB &
VB code and don't think twice about introducing the variable mj late in the
program for a local test and not DIMming it at the front.

Come to think of it, those systems tend to have an implied CLEAR as from out
of nowhere, you could have PRINT A and the unassigned value of A would be
zero (it's a numeric variable). You could also PRINT A$ and get nothing
wrong. Hell, you even get the first 9 or 10 array elements without even
using a DIM to dimension. PRINT A$(6) would yield null as well without being
previously defined.

Perhaps the early defining of variables is a discipline that was taught but
not really required.

I shiver when i see the CLEAR statement when the program needs my
assistance. I relucantly comment it out while reviewing to see if that's the
cause of an unexpected value somewhere. More often than not, after compiling
and when run the first time with no CLEAR, I get distracted by some other
errmsgs unrelated to the problem at hand. I relegate that command to the
lazy category. I've never used it in all my years of MV.

my 2 cents.
> > Incidentally, I find the worryingly common practice of
> > setting all variables to zero / null at the top of a program
> > very annoying as it hides the very useful unassigned variable
> > trap, leaving you thinking your program works when actually
> > it doesn't.
> >
> > Martin Phillips
> > Ladybridge Systems
>
>
> Yes, this practice HIDES real errors.
>
> I too see it a lot, and I think it is absolutely disgusting.
> Maybe the practice originated with programmers who were used to working
> in languages where they had to declare variables & var types at the top
> of their program. They just felt kinda naked without saying,
> I=0;A='';[EMAIL PROTECTED], at the top of their basic code. A poor reason.
>
> Don't do it.
>
> Be aware that the *occasional* such message may hint at a *multitude* of
> unreported error incidents. Especially when the error is deep inside an
> important loops. Let me illustrate by expanding Martin's example:
>
> LOOP
> GOSUB ASSIGN.A
> BEGIN CASE
> CASE A = 1; B = 'Apple'
> CASE A = 2; B = 'Orange'
> CASE A = 3; B = 'Banana'
> END CASE
> DISPLAY B
> REPEAT
>
> You will get an "unassigned error" message only if A just happens to not
> be 1,2,or 3 on the very FIRST pass through the loop. Subsequent passes
> where that occurs would use the value assigned to B on the previous
> iteration. UV will be happy to do so.
>
> Initializing B at the top of the program, above the loop, would
> eliminate those occasional error message but not eliminate the buggy
> code or a fundamental logic flaw.
>
> Try to initialize & assign variables exactly where they apply. Then
> watch for error messages that point out your flaws, and be grateful for
> them.
>
> Chuck Stevenson
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
> -
>   Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
Download Messenger Now
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] Ever wondered how something works...

[Mark Johnson]

I don't know exactly but LD may be short for LISTDICTS and since you're not
providing a filename, it may bomb, taking the active list with it.

Sometimes on UD i wish there were an easier way to clear an active list
instead of CLEARSELECT. I used TIME on all native systems but UD is more
durable and gives you more chances to either get the MVQuery statement
correct or actually bail with clearselect.

my 1 cent.
- Original Message -
From: "Barry Brevik" <[EMAIL PROTECTED]>
To: "U2 list (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 9:34 PM
Subject: [UV] Ever wondered how something works...


> One day, I stumbled across an interesting behavior; at TCL, if I type 'L',
> it results in my current SELECT list being cleared. You get an error
> message, but it does not seem to hurt anything. This is great, because I
> hate typing in CLEARSELECT.
>
> But ever since, I've been wondering what it's really doing. Turns out that
> 'L' is one of only two similar VOC entries, the other being 'LD'. It looks
> like this:
>
> 0001: V
> 0002: L
> 0003: PR
>
> The error message you get reads:
>
>   Unable to create new process.  Will try again.
>   Create Process failed (2).
>
> This is on NT. IIRC, on unix the message is different. Anybody know what
> this is doing, or if it is safe?
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How to start windows programs

[Mark Johnson]

I don't mean to over illustrate WIN.PCRUN but I must endorse it. I've got
clients using it to FTP to remote sites for order downloads, delete remote
data, instantiate text file transfers, link UPS tracking numbers to UPS.com
and fedex. 2 of my clients maintain fleets of 20-30 dispatchable trucks and
when the dispatcher has the customer on the screen, they type 'MAP' and
mapquest.com (sic) shows the map of the customer to help the driver on the
walkie-talkie.

Another client has an interactive voice response IVR order entry system that
saves orders in a shared directory. WIN.PCRUN runs bat files to get the new
filenames, pick does the conversion and error log and WIN.PCRUN then deletes
the successful orders from the original folder and copies the not-so-good
orders to a reject folder. It polls every 5 minutes during the day, sleeps
from 5pm to 730 am and refreshes the IVR data tables with fresh customers
and products at 1:30 am.

If I could run a macro from within excel with WIN.PCRUN i would be home free
as I could export CSV's and format them from within excel instead of the
suggested methods from the outside.

One final use is to incorporate BLAT to kick off single or mass emails from
within Pick (native or network). I even have the end of month process email
to the owner at home of one of my clients that the process is complete so he
can VPN in and print the various reports. Pretty cool.

my 1 cent
- Original Message -
From: "Stuart Boydell" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 6:49 PM
Subject: RE: How to start windows programs


> > Is there a way of starting windowsprograms on the users PC from a
Unibasic
> > program or do I need Wintergrate or some other tool to do that?
>
> You need a proficient terminal emulator. Wintegrate could be one option of
> many.
>
> > I would like to send a invoice number away to an invoice archive on MS
> > sql-server to get a pdf copy of the invoice in an Internet Exploreror
> > acrobat reader window.
>
> The simplest method to open a pdf is to write the pdf to a server then
send
> the URI of the pdf to the emulator via an escape sequence. For example, to
> open a pdf in your browser using ftp using Netterm: CRT
> CHAR(27):'[]ftp://user:[EMAIL PROTECTED]/invoice12345.pdf':CHAR(27):'[0*'
>
> My personal preference for emulators is Netterm. http://securenetterm.com.
> It supports the ability to open URIs, kick off programs on the client as
> well as more sophisticated functions. It's free to evaluate (with no
expiry
> time) and if you decide you want to buy it it's about US$30 for 1 and gets
> cheaper by the dozen.
>
> Regards,
> Stuart
>
>
>
> **
> This email message and any files transmitted with it are confidential
> and intended solely for the use of addressed recipient(s). If you have
> received this email in error please notify the Spotless IS Support Centre
(61 3 9269 7555) immediately who will advise further action.
>
> This footnote also confirms that this email message has been scanned
> for the presence of computer viruses.
> **
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How to start windows programs

[Mark Johnson]

I've got a nifty 15 line utility that anyone could complete called NOTEPAD.
Basically is it like EDIT (pick) except it copies the Pick file to a known
PC filename (C:\notepad.txt) and starts notepad. I and users can edit
textfiles simply (don't try data files as there's no line numbers) and when
you close notepad, you're left with a pick prompt that you simply hit 
to import the record back to pick. Works on native as well as networked pick
systems.

Example:

NOTEPAD FILE ITEM

my 2 cents.
- Original Message -
From: "Jeff Schasny" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 1:03 PM
Subject: RE: How to start windows programs


> How about EXECUTE 'DOS /C "notepad.exe"'
>
> substituting whatever windows executable you like for "notepad.exe" or if
> its more complex than that you could write out a batch file and run it by
> this same method.
>
>
> >Is there a way of starting windowsprograms on the users PC from a
Unibasic
> >program or do I need Wintergrate or some other tool to do that?
> >
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: How to start windows programs

[Mark Johnson]

Wintegrate is real easy (not that Accuterm isn't, i just know wintegrate).

As a blind terminal emulator the MV host knows nothing of the emulator
(native or telnet). From one of the connected users you can 'upload host
programs' that puts 100 or more main and sub programs into WIN.PROGS
(flavored) and then they're available for all wintegrate users.

I use WIN.EXPORT and WIN.IMPORT extensively. A little parameter heavy but
you can consolidate. In second place is WIN.PCRUN which is as simple as it
gets:

CALL WIN.PCRUN("IEXPLORE",WWW.EBAY.COM)
or
CALL WIN.PCRUN("SOL.EXE", "")

In fact i use WIN.EXPORT to push down MS FTP scripts and then WIN.PCRUN to
FTP. I've hooked a lot with WIN.PCRUN.

BTW, if you EXPORT a BAT file and you initiate it with WIN.PCRUN, open
windows explorer and make a shortcut of the bat file. Then right click to
the properties and check on the 'close on exit'. This .PIF file is the
hamburger helper for the BAT and allows the BAT process to open and close
instead of staying open once complete.

my 2 cents.

- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 12:58 PM
Subject: Re: How to start windows programs


> Björn,
> I know you can do it from AccuTerm, I don't know of a way to do it
> from wIntergrate.
>
> - Charles Barouch
> [EMAIL PROTECTED]
>
> Björn Eklund wrote:
>
> >Hi,
> >Is there a way of starting windowsprograms on the users PC from a
Unibasic
> >program or do I need Wintergrate or some other tool to do that?
> >
> >I would like to send a invoice number away to an invoice archive on MS
> >sql-server to get a pdf copy of the invoice in an Internet Exploreror
> >acrobat reader window.
> >
> >Björn Eklund
> >
> >
> >
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Pick AP-Pro Discs

[Mark Johnson]

I had considered this option as well as the MV-Lite environments already out
there. This is really a low-key client (private club membership) that i am
making a good deal on developing the app from scratch. Once they get their
original system duplicated (dbase) to Pick, I can enhance their application
with many desired features and they will have a greater appreciation for
what the system can do for them. Perhaps, they can even grow.

As it is, I'm searching my office for the red-box set of AP-Pro install
discs from a converted client to install on an older P1-133 box. I'll steal
an Arnet board from one of my other AP boxes (I don't need 24 users anymore)
and 'build' them a good starting system. That's why I also solicited any
older AP-Pro systems.

thanks.
- Original Message -
From: "Tony Gravagno" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Sunday, February 29, 2004 2:10 PM
Subject: RE: Pick AP-Pro Discs


If you had more of these deals you could setup a hosted environment (your
choice of DBMS including U2 and D3).  You use your own licenses on that
system and do your development there.  End-users can SSH into their own
production accounts and pay you some monthly rate for using your app and
resources until they're ready to move up.  Voila', your own ASP.  The
initial cost of getting a licensed DBMS and ports may be prohibitive, but
the advantage is that the system still belongs to you when the end-user has
moved on to their own environment or even to a hosted solution of their own.
If you already have a licensed environment then it should cost nothing to
move the license to a hosted box, so the cost of getting this going is
trivial.

Note that (to my knowledge) it violates license agreements to run live
end-users on development software provided by any of the MV DBMS vendors.
You might be able to get a free temporary license to let users run for a
couple months on a "try before they buy" basis.  If you can manage that then
they can host a DBMS locally and still pay you for your app.

Couple ways to cut this cookie...
Let me know if any of this is of interest.
Tony
Nebula R&D
[EMAIL PROTECTED]

>-Original Message-
>I would like to acquire... an older Pick AP-Pro system... I only
> need 3-5 users.
>
>I have a new client that I want to break into the Pick world
>with an inexpensive application to start. I can develop their
>new app on my own AP-Pro yet in 2 months they will want their
>own system. We've explored the concepts of a W2K/D3 or U2 box
>and its cost would kill the deal. I want to get my foot in the
>door and as they grow, we can convert later.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Pick AP-Pro Discs

[Mark Johnson]

Dear All:

I would like to acquire or purchase the complete box, manual and all diskettes for an 
older Pick AP-Pro system or someone's retired AP-Pro system (133-166 P1 preferably). I 
only need 3-5 users. I think the minimum is 3.

I have a new client that I want to break into the Pick world with an inexpensive 
application to start. I can develop their new app on my own AP-Pro yet in 2 months 
they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and 
its cost would kill the deal. I want to get my foot in the door and as they grow, we 
can convert later.

Thanks in advance.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] paragraph labels

[Mark Johnson]

#1. I agree. #2 was my bad on the re-use of 'non-existant'.

The last sentence indicates that a GO in a paragraph can only go forward.
I'm not paragraph oriented (a proctologist) but i wonder if that's right.
Proc and Basic GOTO's obviously go forward or backward.

On this topic, does the proc statement
[PQ.LIB OTHER.PROC] 100
work on U2's. Just wondering.

THANKS.

- Original Message -
From: "Ray Wurlod" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 2:50 PM
Subject: Re: [UV] paragraph labels


> 1. "also documented" means that it's in the UniVerse manuals, but I don't
have access to them right now.
>
> 2. I did not refer to "non-existant" labels earlier in the paragraph.
Check my words again.
>
> 3. Try it and see!
>
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> Date: Sun, 22 Feb 2004 11:46:25 -0500
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Subject: Re: [UV] paragraph labels
>
> > What does the 'also documented' sentence mean. How would a non-existant
> > label appear before the GO in a paragraph.
> >
> > Regarding paragraphs: Do they behave like procs whereby you can
accidentally
> > have the same label twice and the proc goes to the first occurrence
> > (starting at the beginning). This is a downside of procs due to not
needing
> > to be compiled.
> >
> > my 1 cent.
> >
> > - Original Message -
> > From: "Ray Wurlod" <[EMAIL PROTECTED]>
> > To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> > Sent: Sunday, February 22, 2004 5:03 AM
> > Subject: RE: [UV] paragraph labels
> >
> >
> > > It's documented behaviour that GO to a label that does not exist in a
> > paragraph will cause the process to exit from the paragraph.  From
memory
> > it's in the UniVerse System Description somewhere.  There's no "default
> > label".  It's also documented that the same behaviour will occur if you
> > attempt to GO to a label that is earlier in the paragraph than the GO
> > command.
> > > --
> > > u2-users mailing list
> > > [EMAIL PROTECTED]
> > > http://www.oliver.com/mailman/listinfo/u2-users
> >
> > --
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
> >
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: WinteGrate

[Mark Johnson]

Are we agreeing that WIN.PCRUN would be the best way to 'launch' pictures if
they're stored on a shared Windows drive. Yo No Habla Samba.

mark
- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 12:24 AM
Subject: Re: WinteGrate


> In a message dated 2/21/2004 10:24:10 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > I dont' understand the phrase 'UNIVERSE wants to open'. If the pictures
are
> > stored on the 'nix box, then i can't help you. If they're somewhere on a
> > windows filespace available to that user, then use
> > WIN.PCRUN.
>
> Mark I'm assuming this is a new application and the user has the freedom
to put the pictures in the most convenient location.  I was saying that
putting the images in a shared Windows drive would eliminate the need to
have the user also have to administer SAMBA.  Right?
> Will Johnson
> Fast Forward
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [OT] Pr1me Hardware question

[Mark Johnson]

My guess is that it is a Serial Port Controller Board. I used to know what
all the Royale/Reality/Sequel boards were. NIC's surely saves a lot of space
now.

my 1 cent.

P.S. Howja get a gig like that. Is it the History Channel aspect of the CS
program. I and i'm sure others could talk hours on the hardware issues we
had to deal with. My favorite exercise was having to put my finger against
the 1/2 inch tapehead of the open reel-to-reel Microdatas when reading tapes
from one system to another. The tape would stream back and forth trying to
catch its parity until just enough pressure by my fingers would cause those
8 tracks (not to be confused with 8-tracks) to line up. Jurrasic Pick at its
best. Then along came Cipher drives and i put my fingers to better use.

My oldest piece of nostalgia is a 1972 Microdata manual pre-Pick. It was a
process controller looking for something to do.
- Original Message -
From: "Dawn M. Wolthuis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 22, 2004 10:00 PM
Subject: [OT] Pr1me Hardware question


> I'm doing a talk tomorrow to college CS majors (name of talk is: IT is How
> it Seams -- at least I'm able to entertain myself with the double double
> meaning)
>
> I thought I'd bring in some of the odds and ends I've acquired over the
> years and one is a board from a Pr1me computer I worked on.  It was gifted
> to me when the machine was retired.  However, I'm a s/w kinda "guy" and I
> don't know a cpu board from a memory board from anything else.  I figured
> this was the best place to ask about prime hardware, but sorry for being a
> little off-topic.
>
> It is an 18 inch-ish square green board with black chips and few white
ones
> that say "Bechman" on them.  The black ones are at least three different
> sizes.  Along one side it has stickers that say "LINES 0-3" ... "LINES
> 12-15".  That seems like a big clue, but I figured someone here would know
> what such a board might have been called.
>
> Thanks in advance. --dawn
>
> Dawn M. Wolthuis
> Tincat Group, Inc.
> www.tincat-group.com
>
> Take and give some delight today.
>
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] paragraph labels

[Mark Johnson]

What does the 'also documented' sentence mean. How would a non-existant
label appear before the GO in a paragraph.

Regarding paragraphs: Do they behave like procs whereby you can accidentally
have the same label twice and the proc goes to the first occurrence
(starting at the beginning). This is a downside of procs due to not needing
to be compiled.

my 1 cent.

- Original Message -
From: "Ray Wurlod" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, February 22, 2004 5:03 AM
Subject: RE: [UV] paragraph labels


> It's documented behaviour that GO to a label that does not exist in a
paragraph will cause the process to exit from the paragraph.  From memory
it's in the UniVerse System Description somewhere.  There's no "default
label".  It's also documented that the same behaviour will occur if you
attempt to GO to a label that is earlier in the paragraph than the GO
command.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: WinteGrate

[Mark Johnson]

My assumption is based that at least one of your wintegrate users has
uploaded the host programs from their PC to the host system
(UD/UV/D3/AP-Pro/Microdata whatever) into the file called WIN.PROGS.

If you are doing any file transfers (in or out) with wintegrate, then i
believe that they depend on WIN.PROGS. If that's true, WIN.PCRUN came along
for the ride.

I dont' understand the phrase 'UNIVERSE wants to open'. If the pictures are
stored on the 'nix box, then i can't help you. If they're somewhere on a
windows filespace available to that user, then use WIN.PCRUN. If UNIVERSE
itself has a picture viewer, then i can't help you as i don't know what it
is.

mark johnson

visit www.icecreamproducts.com and see around 1,100 product pictures that
are available to the web visitor as well as to anyone going into product
maintenance with wintegrate on a D3 (whatever) system..

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 3:53 PM
Subject: Re: WinteGrate


> In a message dated 2/21/2004 10:23:37 AM Pacific Standard Time,
> [EMAIL PROTECTED] writes:
>
>
> > A simpler way would be:
> >
> > PCFILE="C:\FOLDER\PICTURE.JPEG"
> > CALL WIN.PCRUN("IEXPLORE", PCFILE)
> >
> > It opens up a new window with the aforementioned picture.
>
> Of course you assume the system has such a command CALL WIN.PCRUN
> and you are opening up the same picture over and over using that.
> I was specifying a way to open whatever picture UNIVERSE wants to open, as
> opposed to whatever picture WINDOWS wants to open.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: WinteGrate

[Mark Johnson]

A simpler way would be:

PCFILE="C:\FOLDER\PICTURE.JPEG"
CALL WIN.PCRUN("IEXPLORE", PCFILE)

It opens up a new window with the aforementioned picture.

You can also pass URL's that you fabricate to open up very useful windows.
Two that i use are:

www.maps.yahoo.com\&address=123&main&street&zip=12345

and
www.ups.com/tracking/1Z12345678901234567

These are fictious urls, but you can visit both UPS/Fedex and/or
Mapquest/Yahoo or any other map-like site and cut & paste the real URL and
modify the variable portion. Brings green screen users a little closer to
the nice feel of the windows world.

All of my UPS clients use the UPS concept and 3 of mine with 'truck' use the
map concept.

my 3 cents.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 11:39 AM
Subject: Re: WinteGrate


> In a message dated 2/19/2004 5:51:51 AM Pacific Standard Time,
> [EMAIL PROTECTED] writes:
>
> >  Question:  Using WinteGrate, running UniVerse 10, Unix - Is there
> > a way to display a 'jpeg' file in UniVerse ?
> > We have trucking companies that send up 'proof of
> > deliveries' in jpeg format. Our user base would love
> > to be able to view them straight from UniVerse.
> >
> > As always, very appreciative for ideas/assistance
> >
> > Barry Rogen
>
> Barry store all the jpegs in a shared windows directory on your network
> In Universe have your program tell Wintegrate to "write the following path
> into the clipboard" blah blah blah (the path of the image in the shared
Windows
> directory)
> Then in your Universe program tell Wintegrate to execute its script
> "showjpg.scr" or something like that (you create this script in a shared
location as
> well)
> The Wintegrate script merely launches whatever it finds in the clipboard
>
> Will Johnson
> Fast Forward Technologies
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Australia

[Mark Johnson]

Pickjobs.net


- Original Message - 
From: "Mara Cohn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 11:09 AM
Subject: Australia


> Anyone have any contacts/links to PICK jobs in Perth, W. Australia.
>  
>  
> 
> 
> -
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [OT] Looking for U2 owners in northern suburbs PA, USA

[Mark Johnson]

go to pickjobs.com. there's one in wilkesbarre.
- Original Message -
From: "Rich Sias" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 11:13 AM
Subject: [OT] Looking for U2 owners in northern suburbs PA, USA


> Well, I got to start my searching for gainful employment. I have used 2.5
weeks
> just working on refining the resume, it is near done soon and I need to
gather
> potential sites near where I live first.
>
> Contact me directly with places (company names) and other details if known
and
> date of last contact if old knowledge.  If you had a contact name and or
phone
> number that would be even nicer.  Can be former employers, current ones,
> customers, buyers or other contacts that you are aware they own a U2
system and
> just might need a DBA or such.
>
> Rich Sias
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: D3 /NTand RESIZE function not working

[Mark Johnson]

lemme get this straight. If a 'live' resize of a file in D3 requires no
users using that file, how is it considered live?
my 1 cent.
- Original Message -
From: "Lee Bacall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 15, 2004 8:00 AM
Subject: Re: D3 /NTand RESIZE function not working


> On D3, changing attribute 13 to set the new file size will ONLY will have
an
> effect after a RESTORE of the system from tape.
> I don't remember if it will change the file size on a SEL-RESTORE.
>
> You can do a live resize of the file in D3 (increasing the size only) as:
> RESIZE-FILE Yourfile NewModulo
> Be sure to get your users off the system or disable access to the file
being
> resized or you may encounter some problems.
>
> Lee Bacall
> http://www.binarystar.com
> Phone: +1 (954) 791-8575, emergency# 954-937-8989
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, December 16, 2003 12:34 PM
> > To: [EMAIL PROTECTED]
> > Subject: D3 /NTand RESIZE function not working
> >
> >
> > Version 7.3 service Pack 6 of D3 on NT
> >
> > Has anyone experienced the RESIZE not working after new file sizes have
> been
> > updated into the file-stats record?  It appears that it is complete yet
> the
> > dict item is unchanged.
> > --
> > Debster
> >
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Hashing Algorithm

[Mark Johnson]

Is that one similiar to the 'only' one available to native systems, which
many people have known for years?


- Original Message -
From: "Ray Wurlod" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Saturday, February 14, 2004 5:06 PM
Subject: Re: Hashing Algorithm


> It might be interesting if someone were to publish the "Ardent" hashing
algorithms, then. ;)
> Not something I'm prepared to risk doing, however.
>
> - Original Message -
> From: [EMAIL PROTECTED]
> Date: Sat, 14 Feb 2004 10:45:45 EST
> To: [EMAIL PROTECTED]
> Subject: Re: Hashing Algorithm
>
> > I have to say that in general IMHO a company cannot retroactively
"seize"
> > control of something that at one time was freely available.  Something
in the US
> > about seizure without a warrant?  Bill of rights or something?
> > Will "I'm not a lawyer, but I play one on the Internet" Johnson
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: wIntegrate Trial Version

[Mark Johnson]

As far as i know, there isn't a server portion of wintegrate, rather it is a
client session to telnet to a MV system. The magic comes with matching term
settings, ie vt100, addsvp etc.

my 1 cent.
- Original Message -
From: "Glenn W. Paschal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 5:07 PM
Subject: wIntegrate Trial Version


Ok, first, I am new to wIntegrate.  I downloaded the trial version, and
installed it on an XP pro machine which also runs the UniVerse personal
edition.

Note:trial version can be obtained at:

https://www-927.ibm.com/software/data/u2/support/u2techconnect/wintlist.asp?
newreg=1

How do I get the server portion of wIntegrate installed?  If it is due to
the personal edition of UV, is there a way to install the server portion of
wIntegrate trial on a real UV license?  (this would be UV 10).

I've looked through the manuals, and I am obviously missing something.  Can
someone point me in the right direction?

Thanks for your help.
--Glenn

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

SQL Server and Crystal Reports

[Mark Johnson]

I would like to know the best beginning books for either of these two topics. I don't 
yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone 
else has better beginning selections.

My UD client migrating to these wants to keep me and this is the environment.

thanks.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The result of VARIABLE[1,3] + 0

[Mark Johnson]

I was claiming only that which i can touch. I never got into the internals
as it is hard to justify that effort to a boss who wants the accounts
receivable to balance.
mark

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 8:16 PM
Subject: Re: The result of VARIABLE[1,3] + 0


> No, the "loosly typed" nature of MvBASIC is that you don't see this and
can't control it.  You can't specify that a variable is numeric and have the
system barf when you try to do A[1,3] on it.
>That's the curse and blessing of the environment.
>I was only correcting where you said that everything was treated as a
string.  You accepted that file variables and arrays are different sorts of
creatures.  So are numbers, its just that the system, in general, knows how
to translate on-the-fly between numbers and numeric strings.
> Will
>
> In a message dated 2/6/2004 8:08:35 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > Does this opcode stuff come into play on the outside where
> > we write code.
> > Please provide an example.
> > Thanks.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The result of VARIABLE[1,3] + 0

[Mark Johnson]

Does this opcode stuff come into play on the outside where we write code.
Please provide an example.
Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 7:47 PM
Subject: Re: The result of VARIABLE[1,3] + 0


> There is a numeric type or "datum" as some people call it.
> Since we are talking MV here and not specifically one vendor.
>
> If you look at the opcode of an ADDS machine there is a code for LOADS
(string) and also a seperate one for LOADN (numeric).  This implies that
there are in fact two seperate types of variables.  If you inquire into the
frame where the variable map is being stored as it's running (workspace not
object code) you will see that yes a string variable starts with a 09 and a
numeric I forgot I think its a 01 or 02 ...
>At any rate, its not stored as a string while running, but rather I
believe its probably stored based on whatever the last action was on it.  A
numeric action returns a numeric value and is stored as a numeric.  A string
action like concatenation would probably switch it to be stored, at that
moment, at any rate, as a string.  I didn't test *this* behaviour
explicitly, so I'm not quite sure.
> Will
>
>
> In a message dated 2/6/2004 3:29:01 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > > > It's been affirmed here and other places that MV considers
everything as
> > a text variable (keep file handles and arrays out of this
> > discussion) and
> > its numerological properties come
> > > > into play only when we expect it to behave as a number.
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: InValid Characters

[Mark Johnson]

UD has EDIT-LIST or EDIT.LIST.
- Original Message -
From: "Susan Lynch" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 6:51 PM
Subject: Re: InValid Characters


> Bill,
>
> Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST
> command (which UD does not have).  Given that restriction, probably the
> easiest method would be to
>
> SELECT PS = "[101393" BY-DSND @ID
> (assuming that @id is left-justified)
>
> If only 1 item selected, DELETE PS
>
> If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure
> that the one selected is the one with the unusual characters in the key.
>
> If yes, then repeat the two SELECTs and DELETE PS.  If no, then your
system
> is sorting unprintable characters differently than mine is, and you will
> have to play with the selection process in order to get the right record
> selected prior to deleting it.
>
>
> Susan M. Lynch
> F.W. Davison & Company, Inc.
>
>
>
> - Original Message -
> From: "Brutzman, Bill" <[EMAIL PROTECTED]>
> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
> Sent: Friday, February 06, 2004 5:49 PM
> Subject: InValid Characters
>
>
>
> When I issue the following LIST command, there is are apparent bad
> characters, ascii box drawing characters.
>
> How can I clear them ?  The two characters show up a single "box" below.
>
> Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit
> Up-Arrow mode, or UV.VI.
>
> I tried the ascii equivalents of the box characters per...
>
>>DELETE PS ^210^201
>Record ID "^210^201" not found.
>0 records DELETEd.
>
>>DELETE PS ^210
>Record ID "^210" not found.
>The records for @ID 103662 and 101393 appear to be clean.
>
>>DELETE PS ^D2
>Record ID "^D2" not found.
>0 records DELETEd.
>
>>DELETE PS ^D2^C9
>Record ID "^D2^C9" not found.
>0 records DELETEd.
>
> Suggestions would be appreciated.
>
> --Bill
>
> ---
>
> LIST PS
>
> D.PS..
>
> 103662
>    101393
> 101312
>
> 
>
>
> D.PS. 103662
> NEXT.COMP.PN.
> PREV.COMP.PN. 103661
> QTY.PER.ASSY.
> TYPE.
> SCRAP.FACTOR.
> LEAD.TIME.OFFSET.
> OPERATION
> EFFECTIVE.DATE...
> EFFECTIVE.CODE...
> ENG.CHG.ID...
> DATE.ADDED...
> NWU.PN...
> PWU.PN...
> BALýNBR..
> REFERENCEýDESIGNATORS.
> NOTEýREFERENCE...
> ECO DATE.
>
> D.PS.  NEXT.COMP.PN.
> PREV.COMP.PN.
> QTY.PER.ASSY.
> TYPE.
> SCRAP.FACTOR.
> LEAD.TIME.OFFSET.
> OPERATION
> EFFECTIVE.DATE...
> EFFECTIVE.CODE...
> ENG.CHG.ID...
> DATE.ADDED...
> NWU.PN...
> PWU.PN...
> BALýNBR..
> REFERENCEýDESIGNATORS.
> NOTEýREFERENCE...
> ECO DATE.
>
> D.PS. 101393
> NEXT.COMP.PN.
> PREV.COMP.PN. 103626
> QTY.PER.ASSY.
> TYPE.
> SCRAP.FACTOR.
> LEAD.TIME.OFFSET.
> OPERATION
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
>
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The result of VARIABLE[1,3] + 0

[Mark Johnson]

I don't understand. What is this numeric variable. I got the reply '42'.

thanks.

- Original Message -
From: "gerry simpson" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 4:01 PM
Subject: Re: The result of VARIABLE[1,3] + 0


> 42
>
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> Sent: Friday, February 06, 2004 3:29 PM
> Subject: Re: The result of VARIABLE[1,3] + 0
>
>
> > I'm all ears. What is this numeric variable.
> >
> > Thanks.
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> > Sent: Friday, February 06, 2004 2:34 PM
> > Subject: Re: The result of VARIABLE[1,3] + 0
> >
> >
> > > In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time,
> > [EMAIL PROTECTED] writes:
> > >
> > > > It's been affirmed here and other places that MV considers
everything
> as
> > a text variable (keep file handles and arrays out of this discussion)
and
> > its numerological properties come
> > > > into play only when we expect it to behave as a number.
> > >
> > > No that's not so.  There is a numeric variable (internally stored), in
> MV.
> > It is not a string and only translated to a number when needed, rather
> it's
> > a number.
> > > Will
> > > --
> > > u2-users mailing list
> > > [EMAIL PROTECTED]
> > > http://www.oliver.com/mailman/listinfo/u2-users
> >
> > --
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The result of VARIABLE[1,3] + 0

[Mark Johnson]

I'm all ears. What is this numeric variable.

Thanks.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 2:34 PM
Subject: Re: The result of VARIABLE[1,3] + 0


> In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > It's been affirmed here and other places that MV considers everything as
a text variable (keep file handles and arrays out of this discussion) and
its numerological properties come
> > into play only when we expect it to behave as a number.
>
> No that's not so.  There is a numeric variable (internally stored), in MV.
It is not a string and only translated to a number when needed, rather it's
a number.
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UD] Determining if list exists

[Mark Johnson]

I'm glad that the scrambled output buffers was not a psycho. Imagine what he would do 
in databasic.

I worked at MCD when PQN came out and we got tricky as a PQ proc couldn't reference a 
PQN proc and vice versa. So you either changed all the procs or bounced the command 
off the MD. Since MCD didn't get PERFORM until around 1984-5, I got real good with PQN 
to the point of doing file read/writes, readnexts, iconv, oconv and multiple commands 
on the same line (saves the branching). A great improvement was being able to validate 
date answers using iconv instead of pattern matching as (2n/2n/2n) which 12/34/56 
would be acceptable. For whatever reason, i really understood procs with all the 
buffers and user exits.

Speaking as someone very versed in both F and A correlatives, i initially missed them 
with my UD clients. I did get the hang of simple I types and i don't think i will ever 
enjoy UD's version of stacking with I types. I like the OCONV(@ID,"T1,2") direct 
expressions and you'll probably never catch me writing the SUBS -IFS(-IFS ones as 
unfortunately all the examples i've seen in my clients are very hard to read and 
understand.

One client had their system converted from Microdata to UD and there must have been a 
dict converter as it put the original 10 line dict on line 10 and built the 
appropriate 6 line dict. Unfortunately since the 10 line variety allows the false 
start of primary field, many converted dicts look like this:

002 F99; F1; F2;@[EMAIL PROTECTED]

because the source dict had 002=99 and 008=A;F1+F2. Given the three choices to assign 
to 002 in a 10 line dict item, many earlier programmers fell into a bad habit of 
putting all of their calculating dict items either in 002=0 or 002=99. Once you 
reference a field in 008, it doesn't matter what's in 002. So the converter wrote the 
above 002 with the unnecessary F99.

I do enjoy writing SUBR dict items as i try to make those subs usable by regular 
databasic programs as well. There are a bunch of things that i like doing in SUBR  
(UD/UV or D3) that you cannot do in any real dict item. Very handy.

thanks
  - Original Message - 
  From: [EMAIL PROTECTED] 
  To: U2 Users Discussion List 
  Sent: Thursday, February 05, 2004 1:23 PM
  Subject: Re: [UD] Determining if list exists



  Good Heavens, Mark, I think you kind of missed the tone of my post. :-)  I see you 
sent it just before midnight, you must have been tired. 

  I suppose after rereading my post in the light of a new day, you will see that I 
understand why the code I copied from a prior post was poorly written.  (Don't believe 
in your wildest dreams, I would have written something like that.)  And, as you are 
rereading my posting,  you will also come to understand that the second proc was a 
joke based upon the poor understanding of procs by so many programmers.  If you got 
the joke, you must understand something about proc. 

  After 21 years in PICK, I know PQ procs and how to use them to best advantage.  I 
have to admit PQN procs I have to look up syntax.  I must admit, as much as I like 
procs, I don't use them much anymore.   

  Now if only UniData would support F-correlatives... (Mark, that is another joke. :-) 
) 

  Take care,

  Bruce M Neylon
  Health Care Management Group 



   "Mark Johnson" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
02/04/2004 11:52 PM 
Please respond to U2 Users Discussion List 

   
To:"U2 Users Discussion List" <[EMAIL PROTECTED]> 
cc: 
Subject:Re: Re: [UD] Determining if list exists 


  Your proc example doesn't need the P after the STON in line 3. The reasons you have 
the STON, H< and P(x) on lines 7,8,9 is twofold. The first reason is that in a typical 
GET-LIST/LIST pairing, your list statement could exceed the maximum size of the 
Secondary Output buffer (STON without the H< and P). That required Secondary Output 
buffer extensions of H<< which needed to be properly placed and when changes were 
made, you had to recalculate where they belonged. 

  Using the STON, H<, P then the HLIST put the entire LIST statement into the Primary 
Output buffer which is seemingly limitless. Like a paragraph, you were executing 2 
consecutive statements. 

  The downside is that if the preceeding SELECT doesn't yield any items or the 
GET-LIST comes up empty, the HLIST will process your report against the entire file. 
Thus the IF E=401 concept was introduced to validate the active list. 

  That psycho couldn't possibly have programmed that on purpose. I've seen some 
excessive use of STOFF/STON pairs, ie STOFF after a P when it comes automatically. 
(Like RI then S1. Duh, RI implies S1). The fact that the psy

UD-EDIT-LIST multiple records.

[Mark Johnson]

Is there anyway to UDT.OPTION the EDIT-LIST to not have all the records. I had 
selected 150,000 records, saved them and was changing part of the key on all of them 
and got into this 'next record' stuff. I ended up WRITELISTing my desired new list in 
Basic.

thanks.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Format Text in Output Data File

[Mark Johnson]

I must be missing something. How is creating HTML simpler than CSV for
simple tables.. I may be wrong but i've gotten hung up on the -like
overhead before i can get to the cells. I would like to learn more if this
is an easier way especially if i can export formatting. Any code examples
would be nice.

thanks.
- Original Message -
From: "Ian McGowan" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 10:38 AM
Subject: RE: Format Text in Output Data File


> On Thu, 2004-02-05 at 07:08, Peter Olson wrote:
> > you might want to check out sylk files. not exactly as simple as .csv
> > but but easier then .xls (?)
> > you should be able to add style maybe search the archive i
> > remember someone had a subroutine...
>
> i posted a routine to create sylk files from a uniquery, but agree
> with all the other comments recommending html - it's much easier
> to deal with nowadays...
>
> ian
> --
> Ian McGowan <[EMAIL PROTECTED]>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Format Text in Output Data File

[Mark Johnson]

Single caveat emptor on sylk or any text/csv file destined for excel. Do not have the 
A1 cell contain the phrase ID. Somehow excel will interpet it differently and give you 
a SYLK error and you'll scratch your head.
my 1 cent.
  - Original Message - 
  From: Peter Olson 
  To: 'U2 Users Discussion List' 
  Sent: Thursday, February 05, 2004 10:08 AM
  Subject: RE: Format Text in Output Data File


  you might want to check out sylk files. not exactly as simple as .csv but but easier 
then .xls (?) 
  you should be able to add style maybe search the archive i remember someone 
had a subroutine... 
-Original Message-
From: Simon Adams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 5:28 PM
To: [EMAIL PROTECTED]
Subject: Format Text in Output Data File


I am trying to format text outputted to a csv data file.
I'm building a string of data and writing it out to a data file with 'comma' 
separation, line by line, and naming the outputted file with a ".csv" extension.

Is there a way to format the text/data line(s), as "bold" or "italics" or "colour" 
etc. without using a third-party software ?
Cheers, Simon.

Australia.





*
This e-mail, including any attachments to it, may contain confidential and/or 
personal information.
If you have received this e-mail in error, you must not copy, distribute, or 
disclose it, use or take any action 
based on the information contained within it.

Please notify the sender immediately by return e-mail of the error and then delete 
the original e-mail.

The information contained within this e-mail may be solely the opinion of the 
sender and may not necessarily 
reflect the position, beliefs or opinions of Salmat on any issue.

This email has been swept for the presence of computer viruses known to Salmat's 
anti-virus systems.

For more information, visit our website at www.salmat.com.au.

*




  Notice of Confidentiality: The information included and/or attached in this 
electronic mail transmission may contain confidential or privileged information and is 
intended for the addressee. Any unauthorized disclosure, reproduction, distribution or 
the taking of action in reliance on the contents of the information is prohibited. If 
you believe that you have received the message in error, please notify the sender by 
reply transmission and delete the message without copying or disclosing it. 





--


  -- 
  u2-users mailing list
  [EMAIL PROTECTED]
  http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Proc or Para

[Mark Johnson]

It's on every system that i have now covering many mv's. Not all, but many.
- Original Message -
From: "Anthony Youngman" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 3:06 AM
Subject: RE: Proc or Para


Old history now, but as a Pr1mate (as in used, not worked for), I never
learnt (or even MET!) procs until extremely late in the day. Official
support for procs appeared with INFORMATION 8.1, released probably about
1991 just before they went bust :-(

It just WASN'T THERE on any system I ever worked with ...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Johnson
Sent: 05 February 2004 04:41
To: U2 Users Discussion List
Subject: Re: Proc or Para

Here, Here!! I agree with Chuck on the value of procs. Being a 25 year
proctologist myself allows me to support a wide variety of platforms.
Many
of my UD/UV/D3 clients, while having paragraphs and other newer
additions
available, still function with a lot of code that was inherited from
earlier
conversions. Oftentimes management many not be able to justify a
re-write of
code just because the language isn't today's flavor.

Coming from Microdata since the 70's, you only had procs with
procread/procwrite as a way to get fancy with PQ procs. PQN in 1979
offered
more read/write and direct variable features but the other licenses were
developing EXECUTE which, looking back, was the better tact. Still, i
keep
my proc skills sharpened as I still have to support it. Proc does have
some
pretty nifty features for such a simple command set.

Earlier PQ proc didn't have read/write so they developed a sideline
language
called BATCH which did these tasks. BATCH is officially removed from the
direct decendancy of R80/83 as D3 doesn't recognize it and i haven't
seen it
on any U2 systems. RPL, which predates this further never made it past
the
mid 1970's.

Isn't it great to have choices.
my 1 cent.
- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 1:18 PM
Subject: Re: Proc or Para


> L,
> Proc predates Pick BASIC as a programming language. The short
answer
> (to my mind) is that Paragraph is an add-on to
> Access/English/AQL/Retrieve, but Proc is really a scripting language.
If
> you need to automate procedures, tie complex programs into a batch, or
> do other heavy lifting, Proc is great. The problem that gets all these
> Proc haters on their soapbox isn't Proc, its when people use Proc for
> the wrong tasks (like Proc menus instead of parametric menus). Proc
> really is incredibily powerful and well worth knowing, but it
shouldn't
> be used for 9-% of the tasks it is normally associated with in the
Pick
> world.
> Personally, I rtarely use Paragraph because I need to port
software.
>
> - Charles 'Proc is JCL on Steroids' Barouch
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users





***

This transmission is intended for the named recipient only. It may contain
private and confidential information. If this has come to you in error you
must not act on anything disclosed in it, nor must you copy it, modify it,
disseminate it in any way, or show it to anyone. Please e-mail the sender to
inform us of the transmission error or telephone ECA International
immediately and delete the e-mail from your information system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911
7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1
212 582 2333.


***

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Memo: Re: [UD] Determining if list exists

[Mark Johnson]

I didn't test the 401 on UV but it was a very popular item on MCD's back in
the day and i've got some UD that were clearly converted from MCD (Results)
and they work there. So, i may hae jumped the gun trying to remember which
is which. Also, maybe the flavor matters.

I do recall an ex client with UV having a lot of E tests but i don't have
any of it available at this time. Perhaps this indicates a need to be
platform specific or to retire the concept as it's scattered.

I just checked the ERRMSG file on a nearby D3 system and item 0 is for
automatic testing. Perhaps the implementation moved some ERRMSG items
around. 201 should be Filename? and 203 should be Itemname? 335 was the
initial logon message.

thanks.

- Original Message -
From: "Bruce Nichol" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 12:12 AM
Subject: Re: Memo: Re: [UD] Determining if list exists


> Goo'day,
>
> Well I don't know..keep reading
>
> At 11:05 04/02/04, you wrote:
>
> >The E=401 is a test to see if a process generated an ERRMSG record,
item-id
> >of 401. The ERRMSG file had its own syntax of displaying the messages
with
> >the parameters, but i'm sure it's a long lost art. Sort of like RUNOFF
and
> >BATCH. GFE (Gone ForEver).
> >
>
> Look at this:
>
>  >CT MD U2.TEST
>
>   U2.TEST
> 0001 PQ
> 0002 HSELECT MD WITH F1 "RUBBISH"
> 0003 STON
> 0004 P
> 0005 IF E = 401 GO 10
> 0006 IF E = 0 GO 20
> 0007 HLIST MD F1
> 0008 P
> 0009 G 99
> 0010 10 C
> 0011 O 401 HIT!
> 0012 G99
> 0013 20 C
> 0014 O 0 HIT!
> 0015 99 C
> 0016 X
>  >U2.TEST
>
> 0 record(s) selected to SELECT list #0.
>   0 HIT!
>  >
>
> As I said earlier (below), we had to replace all of *our*  PROCS with "IF
E
> = 401"s with "IF E = 0 " to get them to work.
>
> The same applies (here) with a BASIC program that :
> 0011  SENTENCE = \SELECT MD WITH F! "RUBBISH"\
> 0012  EXECUTE SENTENCE CAPTURING JUNK RETURNING ERR
>
> In this case ERR = 0 if there's no items, not 401 under vanilla (R83, AP)
Pick
>
> Unless.. Is there a UV Option (besides "Pick Flavo*u*r) that gives
back
> a "401"??
>
>
> >- Original Message -
> >From: "Bruce Nichol" <[EMAIL PROTECTED]>
> >To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> >Sent: Tuesday, February 03, 2004 6:34 PM
> >Subject: RE: Memo: Re: [UD] Determining if list exists
> >
> >
> > > Goo'day,
> > >
> > > Are you sure the "IF E = 401" bit works in UV?
> > >
> > > AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick
> >flavo*u*r.
> > >
> > > The "401" bit is vanilla Pick, which I remember we had to change on
> > > conversion to UV back in 9.3???.
> > >
> > > Dunno about UD, though
> > >
> > > At 10:06 04/02/04, you wrote:
> > >
> > > >In a proc you would have:
> > > >PQ
> > > >HSELECT SOMEFILE SAMPLE 3
> > > >P
> > > >IF E = 401  G 99
> > > >HLIST SOMEFILE
> > > >P
> > > >99 O No Items Selected
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >__
> > > >Do you Yahoo!?
> > > >Yahoo! SiteBuilder - Free web site building tool. Try it!
> > > >http://webhosting.yahoo.com/ps/sb/
> > > >--
> > > >u2-users mailing list
> > > >[EMAIL PROTECTED]
> > > >http://www.oliver.com/mailman/listinfo/u2-users
> > > >
> > > >
> > > >
> > > >--
> > > >Incoming mail is certified Virus Free.
> > > >Checked by AVG Anti-Virus (http://www.grisoft.com).
> > > >Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
> > >
> > > Regards,
> > >
> > > Bruce Nichol
> > > Talon Computer Services
> > > ALBURYNSW 2640
> > > Australia
> > >
> > > Tel: +61 (0)411149636
> > > Fax: +61 (0)260232119
> > >
> > > If it ain't broke, fix it till it is!
> > >
> > >
> > > --
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG Anti-Virus (http://www.grisoft.com).
> > > Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
> > >
> > >
> > > --
> > > u2-users mailing list
> > > [EMAIL PROTECTED]
> > > http://www.oliver.com/mailman/listinfo/u2-users
> >
> >--
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >http://www.oliver.com/mailman/listinfo/u2-users
> >
> >
> >
> >--
> >Incoming mail is certified Virus Free.
> >Checked by AVG Anti-Virus (http://www.grisoft.com).
> >Version: 7.0.211 / Virus Database: 261.8.2 - Release Date: 03/02/04
>
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURYNSW 2640
> Australia
>
> Tel: +61 (0)411149636
> Fax: +61 (0)260232119
>
> If it ain't broke, fix it till it is!
>
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.211 / Virus Database: 261.8.2 - Release Date: 03/02/04
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Re: [UD] Determining if list exists

[Mark Johnson]

Your proc example doesn't need the P after the STON 
in line 3. The reasons you have the STON, H< and P(x) on lines 7,8,9 is 
twofold. The first reason is that in a typical GET-LIST/LIST pairing, your list 
statement could exceed the maximum size of the Secondary Output buffer (STON 
without the H< and P). That required Secondary Output buffer extensions of 
H<< which needed to be properly placed and when changes were made, you had 
to recalculate where they belonged.
 
Using the STON, H<, P then the HLIST put the 
entire LIST statement into the Primary Output buffer which is seemingly 
limitless. Like a paragraph, you were executing 2 consecutive 
statements.
 
The downside is that if the preceeding SELECT 
doesn't yield any items or the GET-LIST comes up empty, the HLIST will process 
your report against the entire file. Thus the IF E=401 concept was introduced to 
validate the active list.
 
That psycho couldn't possibly have programmed that 
on purpose. I've seen some excessive use of STOFF/STON pairs, ie STOFF after a P 
when it comes automatically. (Like RI then S1. Duh, RI implies S1). The fact 
that the psycho alternated their two sentence's words in consecutive statements 
was either to hide some code or fool around. 
 
my 1 cent

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: U2 Users Discussion List 
  Sent: Wednesday, February 04, 2004 2:06 
  PM
  Subject: Re: Re: [UD] Determining if list 
  exists
  I think that the reason so 
  many mv'ers don't like procs is they don't understand them.  HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST 
  ARLISTPHGET-LIST ARLISTSTONH

Re: Proc or Para

[Mark Johnson]

Here, Here!! I agree with Chuck on the value of procs. Being a 25 year
proctologist myself allows me to support a wide variety of platforms. Many
of my UD/UV/D3 clients, while having paragraphs and other newer additions
available, still function with a lot of code that was inherited from earlier
conversions. Oftentimes management many not be able to justify a re-write of
code just because the language isn't today's flavor.

Coming from Microdata since the 70's, you only had procs with
procread/procwrite as a way to get fancy with PQ procs. PQN in 1979 offered
more read/write and direct variable features but the other licenses were
developing EXECUTE which, looking back, was the better tact. Still, i keep
my proc skills sharpened as I still have to support it. Proc does have some
pretty nifty features for such a simple command set.

Earlier PQ proc didn't have read/write so they developed a sideline language
called BATCH which did these tasks. BATCH is officially removed from the
direct decendancy of R80/83 as D3 doesn't recognize it and i haven't seen it
on any U2 systems. RPL, which predates this further never made it past the
mid 1970's.

Isn't it great to have choices.
my 1 cent.
- Original Message -
From: "Results" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 1:18 PM
Subject: Re: Proc or Para


> L,
> Proc predates Pick BASIC as a programming language. The short answer
> (to my mind) is that Paragraph is an add-on to
> Access/English/AQL/Retrieve, but Proc is really a scripting language. If
> you need to automate procedures, tie complex programs into a batch, or
> do other heavy lifting, Proc is great. The problem that gets all these
> Proc haters on their soapbox isn't Proc, its when people use Proc for
> the wrong tasks (like Proc menus instead of parametric menus). Proc
> really is incredibily powerful and well worth knowing, but it shouldn't
> be used for 9-% of the tasks it is normally associated with in the Pick
> world.
> Personally, I rtarely use Paragraph because I need to port software.
>
> - Charles 'Proc is JCL on Steroids' Barouch
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Memo: Re: [UD] Determining if list exists

[Mark Johnson]

I once worked on a UV (SCO/Dell Poweredge) that was ported from a MCD that
had a lot of IF E = 401, IF  E = 201 etc. Come to think of it, every TCL
statement generates an ERRMSG. They're just not all errors. "100 items
selected" is stored in ERRMSG.

The ERRMSG dialect is evoked from the STOP databasic Statement. Does anyone
know of any other way to evoke ERRMSG text. I've often wondered.

thanks.

- Original Message -
From: "Glenn Herbert" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 9:17 AM
Subject: RE: Memo: Re: [UD] Determining if list exists


> At 06:34 PM 02/03/2004, you wrote:
> >Goo'day,
> >
> >Are you sure the "IF E = 401" bit works in UV?
>
> This would not work within UV unless proc had been rewritten
> (doubtful).  The error handling within uv is different and this is one of
> those areas affected by that difference.  You can only test IF E or IF #E.
>
>
> >AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick
> >flavo*u*r.
>
> Yep.
>
>
> >The "401" bit is vanilla Pick, which I remember we had to change on
> >conversion to UV back in 9.3???.
> >
> >Dunno about UD, though
> >
> >At 10:06 04/02/04, you wrote:
> >
> >>In a proc you would have:
> >>PQ
> >>HSELECT SOMEFILE SAMPLE 3
> >>P
> >>IF E = 401  G 99
> >>HLIST SOMEFILE
> >>P
> >>99 O No Items Selected
> >>
> >>
> >>
> >>
> >>
> >>__
> >>Do you Yahoo!?
> >>Yahoo! SiteBuilder - Free web site building tool. Try it!
> >>http://webhosting.yahoo.com/ps/sb/
> >>--
> >>u2-users mailing list
> >>[EMAIL PROTECTED]
> >>http://www.oliver.com/mailman/listinfo/u2-users
> >>
> >>
> >>
> >>--
> >>Incoming mail is certified Virus Free.
> >>Checked by AVG Anti-Virus (http://www.grisoft.com).
> >>Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
> >
> >Regards,
> >
> >Bruce Nichol
> >Talon Computer Services
> >ALBURYNSW 2640
> >Australia
> >
> >Tel: +61 (0)411149636
> >Fax: +61 (0)260232119
> >
> >If it ain't broke, fix it till it is!
> >
> >--
> >Outgoing mail is certified Virus Free.
> >Checked by AVG Anti-Virus (http://www.grisoft.com).
> >Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
> >
> >
> >--
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >http://www.oliver.com/mailman/listinfo/u2-users
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UDT SELECT optimization

[Mark Johnson]

Title: Message



My example was multiple WITH clauses that are 
ANDed. Breaking them up may be more efficient. Your example begs the question of 
what is faster:
 
SELECT ORDERS WITH DATE = "01.01.04" BY 
TIME
vs
SELECT ORDERS BY TIME WITH DATE = 
"01.01.04"
 
I tend to put the WITH's first if that 
matters.
 

  - Original Message - 
  From: 
  Dennis Bartlett 
  
  To: 'U2 Users Discussion List' 
  Sent: Wednesday, February 04, 2004 8:45 
  AM
  Subject: RE: UDT SELECT 
optimization
  
  I've 
  always thought that a SELECT that reduces the results first then SORTS would 
  be quicker, eg
   SELECT ORDERS WITH 
  DATE = "01/01/04" BY TIME
  where
   WITH DATE = 
  "01/01/04"    is what reduces the results
  and
   BY 
  TIME   is 
  the selection criteria
   
  based on the logic that  the reduced list would be quicker to 
  sort... Dunno where I picked up this thought process, but I am from a Prime / 
  R83 background.
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
Behalf Of Mark JohnsonSent: 03 February 2004 
02:34To: U2 Users Discussion ListSubject: Re: UDT 
SELECT optimization
Cached in memory is correct as well as the 
second statement will only have to process fewer records if the WITH was 
done in the first. Breaking up a SELECT statement into 2 parts may be 
advantageous, regardless of caching, if there are multiple ANDed WITH 
clauses and one or more of them involve translates. For 
example:
 
SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = 
"12345" AND WITH PERIOD = "199910"
 
would be faster as
SELECT HUGE.ARCHIVE.FILE WITH PERIOD = 
"199910"
then
SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = 
"12345"
 
assuming that CUST.ZIP is translated and the 
PERIOD is a local field. Note the SSELECT in the second statement as 
well.
 
I've often wondered if, when using consecutive 
ANDs the filter processor skips the record if the first WITH is false. Why 
bother testing the second field if both are ANDed.
 
my 1 cent.

  - Original Message - 
  From: 
  Brian Leach 
  To: 'U2 Users Discussion List' 
  Sent: Monday, February 02, 2004 11:24 
  AM
  Subject: RE: UDT SELECT 
  optimization
  
  Chuck,
   
  The order should be immaterial ( it is on every other 
  database I can think of ). 
   
  Just be aware that if you test it by issuing the 
  commands one after the other, the second may may complete quicker, simply 
  because the file may be cached in memory.
   
  Brian Leach
  
  
  From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Chuck 
  MongioviSent: 02 February 2004 16:16To: U2 Users 
  Discussion ListSubject: UDT SELECT 
  optimization
  
  Does anyone know whether one of these two 
  statements is faster?
   
  SELECT FILE BY SOME.DATE WITH SOME.FIELD = 
  "XXX"
  -or-
  SELECT FILE WITH SOME.FIELD = "XXX" BY 
  SOME.DATE
   
  Does the parser / optimizer (if there is one) do 
  the filter portion of the statement first regardless of the order that you 
  build it in or does it do things EXACTLY in the order that you enter them 
  on the command line?
   
  -ChuckThis 
  email was checked by MessageLabs SkyScan before entering 
  Microgen.This 
  email was checked on leaving Microgen for viruses, similarmalicious 
  code and inappropriate content by MessageLabs 
  SkyScan.DISCLAIMERThis email and any attachments are 
  confidential and may also beprivileged.If you are not the 
  named recipient, please notify the senderimmediately and do not 
  disclose the contents to any otherperson, use it for any purpose, or 
  store or copy the information.In the event of any technical 
  difficulty with this email, pleasecontact the sender or 
  [EMAIL PROTECTED]Microgen Information Management 
  Solutionshttp://www.microgen.co.uk
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
  
  

  -- u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Memo: Re: [UD] Determining if list exists

[Mark Johnson]

The E=401 is a test to see if a process generated an ERRMSG record, item-id
of 401. The ERRMSG file had its own syntax of displaying the messages with
the parameters, but i'm sure it's a long lost art. Sort of like RUNOFF and
BATCH. GFE (Gone ForEver).


- Original Message -
From: "Bruce Nichol" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 6:34 PM
Subject: RE: Memo: Re: [UD] Determining if list exists


> Goo'day,
>
> Are you sure the "IF E = 401" bit works in UV?
>
> AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick
flavo*u*r.
>
> The "401" bit is vanilla Pick, which I remember we had to change on
> conversion to UV back in 9.3???.
>
> Dunno about UD, though
>
> At 10:06 04/02/04, you wrote:
>
> >In a proc you would have:
> >PQ
> >HSELECT SOMEFILE SAMPLE 3
> >P
> >IF E = 401  G 99
> >HLIST SOMEFILE
> >P
> >99 O No Items Selected
> >
> >
> >
> >
> >
> >__
> >Do you Yahoo!?
> >Yahoo! SiteBuilder - Free web site building tool. Try it!
> >http://webhosting.yahoo.com/ps/sb/
> >--
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >http://www.oliver.com/mailman/listinfo/u2-users
> >
> >
> >
> >--
> >Incoming mail is certified Virus Free.
> >Checked by AVG Anti-Virus (http://www.grisoft.com).
> >Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
>
> Regards,
>
> Bruce Nichol
> Talon Computer Services
> ALBURYNSW 2640
> Australia
>
> Tel: +61 (0)411149636
> Fax: +61 (0)260232119
>
> If it ain't broke, fix it till it is!
>
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] VARIABLE<-1> = "" andBasicCompile"$OPTIONSEXTRA.DELIM"work "consistently"

[Mark Johnson]

My issue was the possibility of <-1>ing a null value. I use <-1> plenty of
times if i absolutely know that the value is not null or i'm creating a log
file.

If i'm appending a set of associated mv'd attributes, i still DCOUNT the
controlling one (one with never a null) add 1 and directly replace from
there. Just my preference that hasn't hurt me.

thanks.

- Original Message -
From: "Martin Phillips" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 9:55 AM
Subject: Re: [UV] VARIABLE<-1> = "" andBasicCompile"$OPTIONSEXTRA.DELIM"work
"consistently"


> Mark,
>
> > ...the use of a MV counter either derived or managed is clearly the best
> solution...
>
> Some interesting performance figures...
>
> X has 100 fields (I cannot remember how big they were for this test)
>
> X<-1> = 'A'  takes 100 time units
> X := @FM : 'A'takes 150 time units
> X<101> = 'A'   takes 9320 time units
> X = X : @FM : 'A'   takes 9010 time units
>
> Perhaps, sometimes, X<-1> is a winner!
>
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
>
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Re: [UD] Determining if list exists

[Mark Johnson]

Likewise if you're using new proc you may use the 
original ERRMSG file indicator as
HSELECT FILE WHATEVER
STON
HSAVE-LIST LISTNAME
P
IF E = 401 GO somewhere as there were no items 
selected.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: U2 Users Discussion List 
  Sent: Tuesday, February 03, 2004 9:02 
  AM
  Subject: Memo: Re: [UD] Determining if 
  list exists
  Hi Chris,I believe there is the IF S or 
  the IF #S construct that you can use in aproc to test the existence or 
  otherwise of a select list.So if you modify your proc:HSSELECT 
  AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST 
  ARLISTPHGET-LIST ARLISTSTONHSent by:    
  [EMAIL PROTECTED]To:    
  <[EMAIL PROTECTED]>cc:bcc:Subject:    
  [UD]Determining if list existsIs there a Unidata or Uniquery 
  command that tells you if a select listexists?  In UniBasic I can use 
  a SelectInfo function to determine if alist exists, but I can't find a way 
  to do it at the TCL prompt.I have the following PQN PROC.  The 
  PROC itself works fine if there issomething to return from the selection 
  criteria.  However, if nothing isselected in the SELECT statement 
  (like the one below would if we ran ittoday), the PROC does what it is 
  told and lists the whole file, since itis never given a list, resulting in 
  a huge printout of every ARtransaction.HSSELECT AR WITH 
  PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST ARLISTPHGET-LIST 
  ARLISTSTONH

Re: [UV] VARIABLE<-1> = "" and Basic Compile"$OPTIONSEXTRA.DELIM"work "consistently"

[Mark Johnson]

I think that the amount of diverse replies on this 
topic indicates an inconsistency across platforms and that the use of a MV 
counter either derived or managed is clearly the best solution that a programmer 
can take to any MV environment, new or old. It would remove any suspicion to 
wonder if it's working or not. I've never been let down by a real 
counter.
 
If you were managing an array in another form of 
Basic then you would have to use a counter.
 
my 1 cent.

  - Original Message - 
  From: 
  gerry simpson 
  To: U2 Users Discussion List 
  Sent: Tuesday, February 03, 2004 7:25 
  AM
  Subject: Re: [UV] VARIABLE<-1> = "" 
  and Basic Compile"$OPTIONSEXTRA.DELIM"work "consistently"
  
  this is not exactly correct
   
  while you are correct that the 3 statements 
  result in 2 attributes,
  the 2nd state does indeed have 
  an effect
   
   
  A='abc'  
  ;* A=abc , len(A)=3
  A<-1>='' 
  ;* A=abc:@FM , len(A)=4
  
  A<-1>='def'   
  ;* A=abc:@FM:def , len(A)=7
   
   
  when EXTRA.DELIM is used the results are 
  :
   
  
  A='abc'  
  ;* A=abc , len(A)=3
  A<-1>='' 
  ;* A=abc:@FM , len(A)=4
  
  A<-1>='def'   
  ;* A=abc:@FM:@FM:def , len(A)=8
   
   
   
  
- Original Message - 
From: 
Louis 
Windsor 
To: U2 Users Discussion List 
Sent: Tuesday, February 03, 2004 6:42 
AM
Subject: Re: [UV] VARIABLE<-1> = 
"" and Basic Compile "$OPTIONSEXTRA.DELIM"work "consistently"

Sorry for jumping in without checking my facts 
first.
 
You are right the sequence
 
A = 'abc'

A<-1> = ''
A<-1> = 'def'
results in A having TWO attributes NOT 
three.  The second
statement has no effect.  This is as it 
works on Windows XP Prof
and the Personnel version of UniVerse.  
If my memory serves me
this is also how it works on UV9.6 on Unix 
(HPUX).  Again I think
the statement A<-1>='' is always 
ineffective.  UV without over-
riding options etc will never insert a null 
at the end of a string variable.
My experience is mainly with Pick 
flavour.
Louis

  - Original Message - 
  From: 
  Marco 
  Manyevere 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, February 03, 2004 5:34 
  PM
  Subject: Re: [UV] VARIABLE<-1> 
  = "" and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently"
  
  
  The same documentation goes on to say:
   
  
  In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string
  and the new element is appended to the end of the dynamic 
  array, the end of
  a field, or the end of a value, a delimiter is appended to 
  the dynamic array,
  field, or value. Use the -EXTRA.DELIM option of 
  the $OPTIONS 
  statement
  to make the REPLACE function work as it does in IDEAL, PICK, 
  and
  REALITY flavor accounts.
  In my opinion this behaviour is still unexpected and 
  here is why I say so:
  If Information behaves the same as PICK as you say, then the 
  behaviour is still contrary to documentation because in the example I gave 
  below, a @FM was still appended even if the string to be added was empty: 
  i.e.
  A = 'abc'
  A<-1> = ''
  A<-1> = 'def'
  will result in 3 fields. According to the 
  REPLACE extract you quoted, A<-1> = '' should not add a 
  field mark regardless of whether A is empty or not for PICK flavour.
  Marco
  Marco,As 
some previous replies were saying, the behaviour you describe is 
normaland documented. The explanation for this is found in the 
"REPLACE" Basicfunction, which is the equivalent for the angle 
brackets notation at theleft of an assignment operator ("=") for 
dynamic arrays handling.For more information, please refer to the 
Basic documentation manual (File"BASIC.pdf" in the CDROM 
library)Here is an excerpt of the documentation 
:REPLACE functionSyntaxREPLACE (_expression_, 
field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_ 
[ ,field# [ ,value#] ] ; replacement)variable < field# [ ,value# 
[ ,subvalue#] ] >.../...In IDEAL, PICK, PIOPEN, and REALITY 
flavor accounts, if replacement is anempty string and an attempt is 
made to append the new element to the endof the dynamic ar ray, 
field, or value, the dynamic array, field, or valueis 
leftunchanged; additional delimiters are not appended. Use the 
EXTRA.DELIMoption of the $OPTIONS statement to make the REPLACE 
function appenda delimiter to the dynamic array, field, or 
value/...The fact is that "UniVerse" is mainly 
designed to reproduce the behaviourof legacy products in the "Pick" 
family. In this case, the impleme

Re: Recent issues

[Mark Johnson]

I take the blame for announcing that MV doesn't have typed variables (file
handles and arrays excluded here). My contention is that we're not burdened
by too many choices that may sometimes get in our way (integer vs long vs
floating point etc) especially for numbers. There is a brain set,
particularily with integers, that saving some precious byte or bit in memory
is worth pursuing, or that

FOR I%=1 TO 10
is any easier on the processor than
FOR I=1 to 10

MV concludes a type (numeric or text) when it's needed and i believe this
freeform, undisciplined approach has made us MV programmers that more
productive instead of worrying about all that syntax. OPTION BASE 1 anyone?

my 1 cent
- Original Message -
From: "Martin Phillips" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 4:39 AM
Subject: Re: Recent issues


> Just to add my few cents worth to a couple of recent issues...
>
> X<-1> = '' works exactly as it has been defined to work for the last 35
> years!
> One of the things about not (originally) having the concept of an SQL
style
> null item is that you cannot tell the difference between an empty list and
a
> list with one null entry.  It is trivial to program around this once you
> recognise the problem.
>
>
> X = '123' + '456' performs an arithmetic calculation.
> This is absolutely fundamental to how UV/Udt work.  I have lost the
original
> mail that started this thread but I recall it was being blamed on a
> particular release of UV.  If this didn't work, nothing would work so it
> must be more subtle than that.
>
> Although we think of UV Basic as being a typeless language, it isn't.
There
> are actually around a dozen data types inside the product. All operators
> look at the data they are working on and, where appropriate, transform it
to
> the correct type.  The addition operator (and all other arithmetic
> operators) will try to convert character string data to numeric form.  If
> the conversion is successful, the addition takes place.  If not, you get
the
> "non-numeric data where numeric required" message.
>
> The entire product relies on this translation taking place.  For example,
if
> you ask a user to type in a number it will actually be stored as a
character
> string.  Each use of the data as a number will transform it.  Whilst this
is
> no problem if we only use the data infrequently, a loop that does the
> conversion hundreds of thousands of times will do the conversion each
time:
>
> INPUT CT (user types 100)
> FOR I = 1 TO CT
> 
> NEXT CT
>
> This will convert CT for every iteration of the loop.  It gets worse if
you
> use CT many times in the loop too.  For this reason, programmers sometimes
> force a data conversion with the apparently pointless "add zero"
statement:
>
> INPUT CT (user types 100)
> CT = CT + 0
> FOR I = 1 TO CT
> 
> NEXT CT
>
> The extra statement takes CT as a string, adds 0 to it forcing a
conversion
> and stores it as a number.  The loop then goes faster.  I once worked on
an
> application where getting the data types optimised in this way made the
> program go over 1 times faster!
>
>
> In my work I encounter many UV/Udt users and get to see many different
> applications.  I find it amazing how little some programmers understand
> about the product they are using.  The questions raised on this list are
> sometimes so simple that it makes me wonder if the users concerned have
> actually ever looked at the documentation or been on a training course.
By
> way of a quick advert, my company (Ladybridge Systems) offer UV/Udt
training
> in the UK and parts of Europe.  IBM have courses that are delivered
> worldwide (by us in the UK).  I know I have plugged it before but I
strongly
> recommend the UniVerse Internals course for those who really want to get a
> deep understanding of how this system works.  Sadly, there is no
equivalent
> for Unidata.  The programming courses are great fun and address many
issues
> like the ones discussed above.
>
>
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
>
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: using commas in a csv file output

[Mark Johnson]

Tony: Have you experienced the earlier MS mess of ignoring commas as
answers? That's the basis of my frustration that before VB, there was no
real good INPUT statement in the MS flavors of basic (GW, QB and for that
matter VB). MS Basic has half a dozen INPUT-like statements but none work
cleanly. VB has propertied text boxes but i've had to write my own over the
years for GW & QB to accept commas and limit the length on screen inputs.

MS removing the comma from human use is just wrong. It could have been a
tilde or pipe or any other CHAR GE 127. At least the tab in its human form
is identical to the purpose as a delimiter.

I've switched to CSV's when exporting to the popular Excel target as my
earlier experiences with tabs had some issues when sending it through
Wintegrate (which most of my clients have).

my 1 cent
- Original Message -
From: "Tony Gravagno" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 3:12 AM
Subject: RE: using commas in a csv file output


In the interest of fairness, the comments about brain surgeons and poor
judgement (in this case) are mis-directed.

First Excel can easily import TAB delimited data.  Go to menu > Data >
Import External Data > Import data, then use the wizard to specify the
delimiter is a tab and not a comma.  That process can easily be made into a
macro.

Second, the issue with commas and decimals can't be attributed to Excel vs
MV.  Excel processes and formats (renders) data.  By passing pre-formatted
data into the Excel you blur the line between business rules and
user-interface, something that OO developers will tell you is a big no-no
because it causes exactly the problems you experience here.  The proper way
to put numbers into Excel is to forget about all of the MV formatting and
just import unformated data, then assign formatting to cells, columns, and
rows as required.

Third, related to the last note in any case, by wrapping text in quotes you
are telling Excel that a piece of data is Text and not numeric.  This may
cause problems later if you try to do calculations or reformat the data as
though it were numeric.

There are many ways to automate processes like this.  People tend to look at
every Excel import function like a nail because the only tool they know
about is the CSV hammer.  Excel is a powerful tool and you should look
beyond comma delimited text files for your import/export needs - or at least
learn how to properly swing that hammer.

Oops, 3 cents there.
Tony
Nebula R&D


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Monday, February 02, 2004 10:19 PM
To: U2 Users Discussion List
Subject: Re: using commas in a csv file output


The reason quotes are needed in CSV is because some brain surgeon long ago
decided that commas aren't human characters and that they should become
value delimiters. Thus, CSV elements containing commas need the surrounding
quotes.

We MV people are thankful that our delimiters are far away from the human
characters, 254 etc. Early MS basic allowed INPUT A,B and your answer
contained a comma and their INPUT put it into the 2 variables. If your
single answer to INPUT A was "Perth,SW", you got an 'extra ignored'  and
lost the SW.

It's a shame that we must live within the poor judgement of these early
designs. But they're out there.

I have 2 utilities that i use extensively when building CSV's (rows &
columns) from within Databasic when export/importing to a PC system. The
first is called LINE.CSV and it converts LINE<1>, LINE<2> LINE<3> (a built
variable representing one row) into a CSV row for appending to your eventual
text file (OPENSEQ or emulator export). I have its opposite called CSV.LINE
which will convert an invoming CSV row into LINE<1> etc paying attention to
the commas. If anyone would like a copy email me off line. I'm probably
going to publish them in Spectrum anyway.

BTW, to answer the second question, to remove the pennies from an ICONV'd
value you would use MD03. That's Zero Three , not Oh. The Zero indicates the
displayed decimals and the 3 is the converted. Thus, MD3 is the same as
MD33.

Also, check to see if the comma contained in a number offends the numerical
format of that cell. I don't think the comma contained is numeric, ie PRINT
NUM("123,456") returns false and PRINT NUM(123,456) implies a second
argument to the NUM function. you can't say X=123,456 and if you put quotes
around it, it's not numeric.

my 1 cent.
- Original Message -
From: Simon Adams
To: U2 Users Discussion List
Sent: Tuesday, February 03, 2004 12:45 AM
Subject: RE: using commas in a csv file output


OK, I now get10,000.00but I would like to suppress the decimal
places.

This is my line o

Re: VARIABLE<-1> = '' Inconsistent behaviour

[Mark Johnson]

I worked on an application that had:

A=INSERT(A,1,-1;NEWVAL:@VM)

and it was tricky. You should develop your own best approach to this concept
of managing manual delimiters.

BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you
use A=A[2,1000]. My question is if the second value in [] exceeds the
length of A are there any surprising trailing characters? I've used
A=A[2,10] (or some knowingly high number) with no consequences over the
years.

my 1 cent.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 2:09 AM
Subject: RE: VARIABLE<-1> = '' Inconsistent behaviour


One easy way I sometimes use is to just concatenate a field mark along with
the new value and then remove the first field mark at the end... eg.

A = ""
LOOP
   INPUT B
   A := @FM:B
UNTIL condition
REPEAT
A = A[2,LEN(A)-1]

AdrianW

-Original Message-
From: Marco Manyevere [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3 February 2004 15:00
To: U2 Users Discussion List
Subject: Re: VARIABLE<-1> = '' Inconsistent behaviour


OK the documentation for REPLACE says something about inserting empty
strings. For information flavour it does say the @FM will be added for empty
strings without making a distinction between adding to an empty or non empty
array.

If this is a feature then it implies major code revisions for me whereever I
use the <-1> construct. What would be the shortest/smartest way of adding
strings including non significant nulls? I hate to do:

A = ''


INPUT B;  * May be empty
IF LEN(B) THEN
   A<-1> = B
END ELSE
   IF LEN(A) THEN
  A<-1> = B
   END ELSE
  A = @FM
   END
END

I have also tested

A<1> = ''
A<2> = ''
A<3> = 3
A<4> = ''
A<5> = 5

and it inserts the @FM as expected but this involves maintaining a counter
for the dynamic array.

Louis Windsor <[EMAIL PROTECTED]> wrote:

I think this is a "feature".

Universe does NOT insert non-significant nulls.  In other words your first
two
(A<-1> = '') do not do anything!  It is consistent in its' behaviour as you
can
count on it to do the above.  It has done this as long as I remember.

I found this out through bitter experience.

Louis


- Original Message -
From: Marco   Manyevere
To: [EMAIL PROTECTED] 
Sent: Tuesday, February 03, 2004 12:55 PM
Subject: VARIABLE<-1> = '' Inconsistent behaviour

Hi All,

Consider the program:

A = ''
A<-1> = ''
A<-1> = ''
A<-1> = 3
A<-1> = ''
A<-1> = 4
PRINT A<3>

I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV
9.6 [NT] running information flavour.

Regards,
Marco




   _

BT Yahoo! Broadband - Free modem offer, sign
 up online
today and save £80



   _




___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users




   _


 Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
 Download Messenger Now

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
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: VARIABLE<-1> = '' Inconsistent behaviour

[Mark Johnson]

At least with maintaining a variable you are in 
control.

  - Original Message - 
  From: 
  Marco 
  Manyevere 
  To: U2 Users Discussion List 
  Sent: Tuesday, February 03, 2004 2:00 
  AM
  Subject: Re: VARIABLE<-1> = '' 
  Inconsistent behaviour
  
  OK the documentation for REPLACE says something about inserting 
  empty strings. For information flavour it does say the @FM will be added for 
  empty strings without making a distinction between adding to an empty or non 
  empty array.
   
  If this is a feature then it implies major code revisions for me 
  whereever I use the <-1> construct. What would be the shortest/smartest 
  way of adding strings including non significant nulls? I hate to do:
   
  
  A = ''
  
  
  INPUT B;  * May be empty
  IF LEN(B) THEN
     A<-1> = B
  END ELSE
     IF LEN(A) THEN
    A<-1> = B
     END ELSE
    A = @FM
     END
  END
  I have also tested
   
  A<1> = ''
  A<2> = ''
  A<3> = 3
  A<4> = ''
  A<5> = 5
   
  and it inserts the @FM as expected but this involves maintaining a 
  counter for the dynamic array.
  Louis Windsor <[EMAIL PROTECTED]> wrote:
  



I think this is a "feature".
 
Universe does NOT insert non-significant nulls.  
In other words your first two 
(A<-1> = '') do not do anything!  It is consistent in its' 
behaviour as you can
count on it to do the above.  It has done this as long as I 
remember.
 
I found this out through bitter experience.
 
Louis
 

  - Original Message - 
  From: 
  Marco 
  Manyevere 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, February 03, 2004 
  12:55 PM
  Subject: VARIABLE<-1> = '' 
  Inconsistent behaviour
  
  Hi All,
   
  Consider the program:
   
  A = ''
  A<-1> = ''
  A<-1> = ''
  A<-1> = 3
  A<-1> = ''
  A<-1> = 4
  PRINT A<3>
   
  I expect it output '3' but it outputs '4'. Whats the explanation? I'm 
  on UV 9.6 [NT] running information flavour.
   
  Regards,
  Marco
   
  
  
  BT Yahoo! Broadband - Free modem offer, sign 
  up online today and save £80 
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users___u2-users 
mailing 
list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
  
  
  Yahoo! 
  Messenger - Communicate instantly..."Ping" your friends today! Download 
  Messenger Now
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: VARIABLE<-1> = '' Inconsistent behaviour

[Mark Johnson]

Best approach when combining the <-1> function with values that may be null,
especially when updating associated fields, is to not allow the null value
(no null debates) rather to use a token '*' character to at least force the
values  (253 or 254) to grow properly.

The <-1>="" is historically inconsistent across platforms. Using <-1>="*"
then converting the '*' to '' leaves the elements intact.

If i'm growing a bunch of associated attributes with some transaction, i
look for one of the values that is always present and use a DCOUNT to count
its elements and then add +1 to force the new syncronized mv's using
REC<5,MV>=val. Thus if REC<8,MV>is assigned to null, at least that
transaction will be in the mv'th multivalue.

ALso, if using the INSERT or INS function to put it at the beginning MV,
watch out for nulls as well.

my 1 cent.
- Original Message -
From: "Darren Percival" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 12:58 AM
Subject: Re: VARIABLE<-1> = '' Inconsistent behaviour


> At 04:55 AM 3/02/2004 +, you wrote:
> >Hi All,
> >
> >Consider the program:
> >
> >A = ''
> >A<-1> = ''
> >A<-1> = ''
> >A<-1> = 3
> >A<-1> = ''
> >A<-1> = 4
> >PRINT A<3>
> >
> >I expect it output '3' but it outputs '4'. Whats the explanation? I'm on
> >UV 9.6 [NT] running information flavour.
> >
> >Regards,
> >Marco
> >
>
>
> Check what "A" really is just before your print.
> I think that you will find it is   "3" @FM '"" @FM "4"
> and not ""@FM "" @FM "3" @FM "" @FM  "4"
>
> So that A<3> gives the you 4 not the 3 you expect
>
>
> IIRC I have seen this behavior before where
>
> A = "" and A<-1> = "" doesn't actually result in the marker being appended
> to the array.
>
> Unfortunately I cant remember/don't know the reasoning or the why behind
> it. I will try and find out the situation I saw it if nobody else can shed
> any light.
>
> Cheers,
>
>  .Darren.
> 
> Law of Probable Dispersal:
>  Whatever it is that hits the fan will not be evenly distributed.
> ===
>
>
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: using commas in a csv file output

[Mark Johnson]

The reason quotes are needed in CSV is because some 
brain surgeon long ago decided that commas aren't human characters and that they 
should become value delimiters. Thus, CSV elements containing commas need the 
surrounding quotes.
 
We MV people are thankful that our delimiters are 
far away from the human characters, 254 etc. Early MS basic allowed INPUT A,B 
and your answer contained a comma and their INPUT put it into the 2 variables. 
If your single answer to INPUT A was "Perth,SW", you got an 'extra 
ignored'  and lost the SW.
 
It's a shame that we must live within the poor 
judgement of these early designs. But they're out there.
 
I have 2 utilities that i use extensively when 
building CSV's (rows & columns) from within Databasic when export/importing 
to a PC system. The first is called LINE.CSV and it converts LINE<1>, 
LINE<2> LINE<3> (a built variable representing one row) into a CSV 
row for appending to your eventual text file (OPENSEQ or emulator export). I 
have its opposite called CSV.LINE which will convert an invoming CSV row into 
LINE<1> etc paying attention to the commas. If anyone would like a copy 
email me off line. I'm probably going to publish them in Spectrum 
anyway.
 
BTW, to answer the second question, to remove the 
pennies from an ICONV'd value you would use MD03. That's Zero Three , not Oh. 
The Zero indicates the displayed decimals and the 3 is the converted. Thus, MD3 
is the same as MD33.
 
Also, check to see if the comma contained in a 
number offends the numerical format of that cell. I don't think the comma 
contained is numeric, ie PRINT NUM("123,456") returns false and PRINT 
NUM(123,456) implies a second argument to the NUM function. you can't say 
X=123,456 and if you put quotes around it, it's not numeric.
 
my 1 cent.

  - Original Message - 
  From: 
  Simon Adams 
  To: U2 Users Discussion List 
  Sent: Tuesday, February 03, 2004 12:45 
  AM
  Subject: RE: using commas in a csv file 
  output
  
  OK, I now 
  get    10,000.00    but I would like to suppress 
  the decimal places.
   
  This is my line 
  of code :
  FLAT.LINE:='"':OCONV(PARTS.REC<8,W>,"MD3,"):'"'
   
  Any further 
  advise, most appreciated.
   
  
  Cheers, Simon.Australia.
  
-Original Message-From: Kevin King 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, 3 February 2004 
15:51To: U2 Users Discussion ListSubject: RE: using 
commas in a csv file output
quote the entire data value.

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On 
  Behalf Of Simon AdamsSent: Monday, February 02, 2004 9:44 
  PMTo: [EMAIL PROTECTED]Subject: using commas in a 
  csv file output
  How can I 
  force a comma in an outputted csv file ?
   
  I want to 
  put commas in numbers  eg:  10,000  but as the delimiter is 
  a comma, it puts 10 in one column and then the 000 in the next 
  column.
  How can I 
  OCONV the output but keeping the number together ?
  
  Cheers, Simon.Australia.
   *This 
  e-mail, including any attachments to it, may contain confidential and/or 
  personal information.If you have received this e-mail in error, you 
  must not copy, distribute, or disclose it, use or take any action 
  based on the information contained within it.Please notify the 
  sender immediately by return e-mail of the error and then delete the 
  original e-mail.The information contained within this e-mail may 
  be solely the opinion of the sender and may not necessarily reflect 
  the position, beliefs or opinions of Salmat on any issue.This 
  email has been swept for the presence of computer viruses known to 
  Salmat's anti-virus systems.For more information, visit our 
  website at 
  www.salmat.com.au.*
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UDT SELECT optimization

[Mark Johnson]

Title: RE: [UD]LOGTO



Cached in memory is correct as well as the second 
statement will only have to process fewer records if the WITH was done in the 
first. Breaking up a SELECT statement into 2 parts may be advantageous, 
regardless of caching, if there are multiple ANDed WITH clauses and one or more 
of them involve translates. For example:
 
SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" 
AND WITH PERIOD = "199910"
 
would be faster as
SELECT HUGE.ARCHIVE.FILE WITH PERIOD = 
"199910"
then
SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = 
"12345"
 
assuming that CUST.ZIP is translated and the PERIOD 
is a local field. Note the SSELECT in the second statement as well.
 
I've often wondered if, when using consecutive ANDs 
the filter processor skips the record if the first WITH is false. Why bother 
testing the second field if both are ANDed.
 
my 1 cent.

  - Original Message - 
  From: 
  Brian Leach 
  To: 'U2 Users Discussion List' 
  Sent: Monday, February 02, 2004 11:24 
  AM
  Subject: RE: UDT SELECT 
optimization
  
  Chuck,
   
  The order should be immaterial ( it is on every other 
  database I can think of ). 
   
  Just be aware that if you test it by issuing the 
  commands one after the other, the second may may complete quicker, simply 
  because the file may be cached in memory.
   
  Brian Leach
  
  
  From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Chuck 
  MongioviSent: 02 February 2004 16:16To: U2 Users 
  Discussion ListSubject: UDT SELECT 
optimization
  
  Does 
  anyone know whether one of these two statements is faster?
   
  SELECT FILE BY SOME.DATE WITH SOME.FIELD = 
  "XXX"
  -or-
  SELECT FILE WITH SOME.FIELD = "XXX" BY 
  SOME.DATE
   
  Does 
  the parser / optimizer (if there is one) do the filter portion of the 
  statement first regardless of the order that you build it in or does it do 
  things EXACTLY in the order that you enter them on the command 
  line?
   
  -ChuckThis 
  email was checked by MessageLabs SkyScan before entering 
  Microgen.This 
  email was checked on leaving Microgen for viruses, similarmalicious code 
  and inappropriate content by MessageLabs 
  SkyScan.DISCLAIMERThis email and any attachments are 
  confidential and may also beprivileged.If you are not the named 
  recipient, please notify the senderimmediately and do not disclose the 
  contents to any otherperson, use it for any purpose, or store or copy the 
  information.In the event of any technical difficulty with this email, 
  pleasecontact the sender or [EMAIL PROTECTED]Microgen 
  Information Management Solutionshttp://www.microgen.co.uk
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: The result of VARIABLE[1,3] + 0

[Mark Johnson]

I tried this on a MCD spirit, D3 W2k and 
AP-Pro as well and got the '1' and 567 that we're all getting.
 
It's been affirmed here and other places that MV 
considers everything as a text variable (keep file handles and arrays out of 
this discussion) and its numerological properties come into play only when we 
expect it to behave as a number. Thus 
 
X="ABCDEF123IKIJIJ" ; 
Y="456ABCDEFG"
PRINT (X[7,3])+(Y[5,3]) 
 
would produce the 579 as well.
 
This brings up another aspect of the text/string 
situation: Consider this
 
A="00"[1,3]   ;*zeros for both 
lines
B="00"[1,2]
 
PRINT (A=B)
 
and you would expect to get false as textually 
speaking 000 is not 00. But left alone, these 2 variables can be concluded to be 
numbers and thus equal even though their lengths are different.
 
my 1 cent.
 

  - Original Message - 
  From: 
  Marco 
  Manyevere 
  To: [EMAIL PROTECTED] 
  Sent: Sunday, February 01, 2004 11:13 
  PM
  Subject: The result of VARIABLE[1,3] + 
  0
  
  Hi All,
   
  What is the correct interpratation of 
   
  A = '001'
  B = A[1,3] + 0
  PRINT B
   
  On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical 
  explanation of this. Does UV use '+' for string concatenation as well? Then 
  why doesnt '123' + '456' result in '123456' (I get a runtime error)?
   
  Regards,
  Marco
  
  
  BT 
  Yahoo! Broadband - Free modem offer, sign up 
  online today and save £80
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Distributed & multipart files [as RE: [UV] Resize - Dynamic or64 bit?]

[Mark Johnson]

Title: Message



Just curious. Are Distributed files handled by the 
OS or the programmer. One client of mine had 12 monthly files (2-3 million 
records each) and the software combined the data into work files for cross-month 
queries.
 
thanks.

  - Original Message - 
  From: 
  Logan, David (SST 
  - Adelaide) 
  To: U2 Users Discussion List 
  Sent: Thursday, January 29, 2004 5:53 
  PM
  Subject: RE: Distributed & multipart 
  files [as RE: [UV] Resize - Dynamic or64 bit?]
  
  Hi 
  Stuart,
   
  One 
  large advantage (from my perspective) is the ability to address the file as 
  one large file or as an single part individually. The open statement in the 
  program is the same, only the name changes.
   
  The 
  ability to put the parts on different file systems, balancing the load is 
  another that springs to mind. The ability to split a file into manageable 
  chunks is another. Some of our tables are starting to stretch toward the 20Gb 
  mark and to split these into manageable chunks makes for reasonable resizing 
  times etc. The individual parts can be resized at different 
  times.
   
  The 
  ability to split your data according to your own algorithm is especially 
  useful.
   
  With 
  multi-data part files, I don't believe you could address the complete file as 
  one, other than that, the other points I have made are still applicable. I 
  suppose distributed files are easier to deal with from the application point 
  of view. If your distribution algorithm is reasonably well balanced the 
  records will be placed evenly over the individual parts. Even if they are not, 
  eg. you use say, a branch code as the key,  you don't have to worry 
  about opening up the correct multi-part, the system will automatically do that 
  for you.
   
  Regards
   
  David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia 
  +61 8 8408 4273 
  +61 417 268 665 

  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
Behalf Of Stuart BoydellSent: Friday, 30 January 2004 8:57 
AMTo: U2 Users Discussion ListSubject: Distributed 
& multipart files [as RE: [UV] Resize - Dynamic or 64 
bit?]
I have never come across distributed files in a system and 
they sound a lot like multiple part files (like 
SYS.HELP,XXX).
What is the difference / advantages / disadvantages between 
using distributed files and multiple data-part files? Can a 
distributed file also be a multiple part file?
Cheers,
Stuart

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On 
  Behalf Of David T. MeeksSent: Friday, 30 January 2004 
  07:50To: U2 Users Discussion ListSubject: RE: 
  UNCLASSIFIED RE: [UV] Resize - Dynamic or 64 
  bit?
  Actually, a DISTRIBUTED file 
  is largely a logical construct.  It is a collection of normal 
  files under the umbrella of a master logical file.The components of 
  the DISTRIBUTED file (also called a PART file) can beany hashed file 
  type.The file type that has DATA.30 and OVER.30 is a DYNAMIC file. 
  Dave**This 
email message and any files transmitted with it are confidentialand 
intended solely for the use of addressed recipient(s). If you have 
received this email in error please notify the Spotless IS Support 
Centre (61 3 9269 7555) immediately who will advise further 
action.This footnote also confirms that this email message has been 
scannedfor the presence of computer 
viruses.**
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Membership Program

[Mark Johnson]

Sort of a country club for pilots. I don't 
understand its purpose either but it's tied to an aviation trade 
association.

  - Original Message - 
  From: 
  Laursen, Mark 
  To: 'U2 Users Discussion List' 
  Sent: Thursday, January 29, 2004 7:12 
  AM
  Subject: RE: Membership Program
  
  
  What type of 
  Club?
   
  
  Thanks Mark 
  Laursen 
  Marriott 
  Vacation Club International (863) 
  688-7700 Ext. 
  4339 [EMAIL PROTECTED] 
  This communication contains information 
  from Marriott International, Inc. that may be confidential. Except for 
  personal use by the intended recipient or as expressly authorized by the 
  sender, any person who receives this information is prohibited from 
  disclosing, copying, distributing, and/or using it. If you have received this 
  communication in error, please immediately delete it and all copies, and 
  promptly notify the sender. Nothing in this communication is intended to 
  operate as an electronic signature under applicable 
  law.
  -Original 
  Message-From: Mark 
  Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 
  29, 
  2004 12:03 AMTo: u2[EMAIL PROTECTED]Subject: Membership 
  Program
   
  
  Does anyone know of a club 
  membership accounting package that's written in generic Pick (very portable) 
  or in MS Access (editable as well). It needs to keep track of renewals, dues 
  and other simple accounting items.
  
   
  
  Also, does anyone have any 
  experience with Ladybridge's PC-Pick program. If i cannot find this club app 
  that's 80% usable, i'll develop from scratch. Also, any input on PC-Universe 
  regarding downloading demos, user costs, system 
  requirements.
  
   
  
  Thanks in 
  advance.
  
   
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users