RE: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Tony G
Here is a link to Brian's product page:
http://BrianLeach.co.uk/mvscan.htm 

I do not want to step on toes and attempt to create a solution
which duplicates one already provided by our esteemed colleague
Brian Leach.  If mvScan is not available, or for some reason
doesn't suit specific needs, I will offer to try to put a
graphical front-end on someone's existing application parser.  I
don't have the time to write that sort of detailed and fragile
back-end code but as I said earlier, the graphical part
(surprisingly?) shouldn't be that tough.  (Famous last words...)

I make no apologies about the fact that my business survives when
we get paid for writing software, so anything I come up with will
be sold at some price balanced by both investement and demand.
(It's a helluva world when I actually feel a need to explain
something like that in a professional forum, but here we are.)
If you object in principle to paying for software then you can
either do this on your own or wait (a year? forever?) for someone
to do it for you for free, but please don't hold it against me
for attempting to offer supply for demand without losing my house
in the process.

So I invite people to check out Brian's mvScan.  I invite Brian,
Norman, and John to contact me about collaboration toward a new
product with split revenues (thereby addressing the bottom line
issue which Norman's CEO mentions).  And I invite anyone
interested in a graphical flowchart (and perhaps other
visualizations of their MV data) to contact me so that we have
some idea of whether it will be worth it to even do this.

Thanks for your time.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
Visit PickWiki.com!  Contribute!

 From: Norman Bauer
 I would also love to use it. Brian has a program that 
 essentially does this, however in the economic times 
 we are in now my CEO told me if it does not directly 
 translaye into improveing the bottom line I can not 
 authorize it.
 
 If I get time in the next year I may write something 
 and release it, but don't hold your breath.
 
 Charlie Noah wrote:
  I am sure I'm not the only one interested. Please do 
  request permission to release it. John Israel said 
  he'd written one, but it must be internal to his 
  company, too. I can't find any reference to it, or to 
  Brian Leach's program on the internet. I would be 
  interested in seeing their software as well. Guys? 
  Knowing how snarled and convoluted some of our legacy 
  programs are, this would be extremely difficult 
  software to design and build, and I applaud those who 
  have done so.

  Dan McGrath wrote:
  I have a tool I wrote here that does this for your 
  entire source repo.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Truncated catdir names

2009-05-27 Thread Norman, David (Health)
I made an unpleasant discovery when I recataloged (normally) one of my
accounts (UV10.0, HP-UX).
Some of the catalog names became too long (e.g.
*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog
process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had
several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW,
.RV,  .SE). All of these resulted in the same truncated name so only 1 catdir
entry was created, which was for the last one of the 5 cataloged. The catdir
path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of
*GET.COUN  .
Trying to run the programs results in a warning File name
*SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to
*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.

Is this a known limitation ? Why does the directory nesting stop at the 2nd
level ? The VOC entries show the full names.  catdir is type 1 out of the
box.


David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au


This e-mail may contain confidential information, which also may be legally
privileged. Only the intended recipient(s) may access, use, distribute or copy
this e-mail. If this e-mail is received in error, please inform the sender by
return e-mail and delete the original. If there are doubts about the validity
of this message, please contact the sender by telephone. It is the recipient's
responsibility to check the e-mail and any attached files for viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: Truncated catdir names

2009-05-27 Thread Hona, David
Hi David

This probably goes back to the limitations of the original port of UNIX that 
had the directory name limited and the maximum number of characters in a 
pathname.

It's unfortunate that IBM hasn't address this - but it has been around for a 
long, long time. But, I guess there has been little demand, as most U2 
applications are legacy ones with short filenames and accounts names.

You definitely should **NOT** resize your catdir to type 19 (or any other 
filetype)! :)


Regards,
David

-Original Message-
From: owner-u2-us...@listserver.u2ug.org 
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman, David (Health)
Sent: Wednesday, 27 May 2009 4:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Truncated catdir names

I made an unpleasant discovery when I recataloged (normally) one of my
accounts (UV10.0, HP-UX).
Some of the catalog names became too long (e.g.
*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog
process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had
several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW,
.RV,  .SE). All of these resulted in the same truncated name so only 1 catdir
entry was created, which was for the last one of the 5 cataloged. The catdir
path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of
*GET.COUN  .
Trying to run the programs results in a warning File name
*SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to
*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.

Is this a known limitation ? Why does the directory nesting stop at the 2nd
level ? The VOC entries show the full names.  catdir is type 1 out of the
box.


David Norman
Senior Software Engineer - SA Ambulance Service

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: Truncated catdir names

2009-05-27 Thread phil walker
Any reason for not resizing catdir as type 19? I have done this and
nothing seems to have broken. In fact I would hope that it would not as
the file type should be transparent to any application.


 -Original Message-
 From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
 us...@listserver.u2ug.org] On Behalf Of Hona, David
 Sent: Wednesday, 27 May 2009 6:30 p.m.
 To: u2-users@listserver.u2ug.org
 Subject: [U2] RE: Truncated catdir names
 
 Hi David
 
 This probably goes back to the limitations of the original port of
UNIX
 that had the directory name limited and the maximum number of
 characters in a pathname.
 
 It's unfortunate that IBM hasn't address this - but it has been around
 for a long, long time. But, I guess there has been little demand, as
 most U2 applications are legacy ones with short filenames and
 accounts names.
 
 You definitely should **NOT** resize your catdir to type 19 (or any
 other filetype)! :)
 
 
 Regards,
 David
 
 -Original Message-
 From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
 us...@listserver.u2ug.org] On Behalf Of Norman, David (Health)
 Sent: Wednesday, 27 May 2009 4:02 PM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] Truncated catdir names
 
 I made an unpleasant discovery when I recataloged (normally) one of my
 accounts (UV10.0, HP-UX).
 Some of the catalog names became too long (e.g.
 *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the
 catalog
 process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I
 had
 several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO,
 .NW,
 .RV,  .SE). All of these resulted in the same truncated name so only
1
 catdir
 entry was created, which was for the last one of the 5 cataloged. The
 catdir
 path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of
 *GET.COUN  .
 Trying to run the programs results in a warning File name
 *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to
 *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.
 
 Is this a known limitation ? Why does the directory nesting stop at
the
 2nd
 level ? The VOC entries show the full names.  catdir is type 1 out of
 the
 box.
 
 
 David Norman
 Senior Software Engineer - SA Ambulance Service
 
 ** IMPORTANT MESSAGE *
 This e-mail message is intended only for the addressee(s) and contains
 information which may be
 confidential.
 If you are not the intended recipient please advise the sender by
 return email, do not use or
 disclose the contents, and delete the message and any attachments from
 your system. Unless
 specifically indicated, this email does not constitute formal advice
or
 commitment by the sender
 or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its
 subsidiaries.
 We can be contacted through our web site: commbank.com.au.
 If you no longer wish to receive commercial electronic messages from
 us, please reply to this
 e-mail by typing Unsubscribe in the subject line.
 **
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] RE: Truncated catdir names

2009-05-27 Thread Hona, David
I was going to add that in the past it would break stuff...I haven't tried it 
recently!!

I guess you can just make a backup / shutdown UV first whilst people aren't 
accessing the catdir :)


-Original Message-
From: owner-u2-us...@listserver.u2ug.org 
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker
Sent: Wednesday, 27 May 2009 5:16 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] RE: Truncated catdir names

Any reason for not resizing catdir as type 19? I have done this and
nothing seems to have broken. In fact I would hope that it would not as
the file type should be transparent to any application.


 -Original Message-
 From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
 us...@listserver.u2ug.org] On Behalf Of Hona, David
 Sent: Wednesday, 27 May 2009 6:30 p.m.
 To: u2-users@listserver.u2ug.org
 Subject: [U2] RE: Truncated catdir names
 
 Hi David
 
 This probably goes back to the limitations of the original port of
UNIX
 that had the directory name limited and the maximum number of
 characters in a pathname.
 
 It's unfortunate that IBM hasn't address this - but it has been around
 for a long, long time. But, I guess there has been little demand, as
 most U2 applications are legacy ones with short filenames and
 accounts names.
 
 You definitely should **NOT** resize your catdir to type 19 (or any
 other filetype)! :)
 
 
 Regards,
 David
 
 -Original Message-

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Best algorithm for UV part files

2009-05-27 Thread Brian Leach
Hi Baker

Well as you probably know the partitioning needs to be based on the key, so
it depends upon what meaningful information you can store there in an
invariant way.

For example:

If they are coming from archive, do/could the keys have an originating date
component? If so, you can distribute easily across yearly or quarterly files
by creating a partitioning expression that is simply:

ThatDateComponentAsAYear - StartYear (or with added quarters)

Brian



 -Original Message-
 From: owner-u2-us...@listserver.u2ug.org 
 [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baker Hughes
 Sent: 26 May 2009 22:00
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] Best algorithm for UV part files
 
 Does anyone have an opinion about the best algorithm to use 
 for UV distributed files?
 
 The goal is ease of moving the records in the distributed 
 files to other files.
 
 There may be other criteria by which to gauge the best DF 
 strategy, but in this case I'm just working with restored 
 archive records, and moving records here and about.
 
 Regards,
 -Baker
 
 
 This communication, its contents and any file attachments 
 transmitted with it are intended solely for the addressee(s) 
 and may contain confidential proprietary information.
 Access by any other party without the express written 
 permission of the sender is STRICTLY PROHIBITED.
 If you have received this communication in error you may not 
 copy, distribute or use the contents, attachments or 
 information in any way.  Please destroy it and contact the sender.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Brian Leach
Tony

Many thanks for the pitch!!

mvScan is a tool for building a database of the relations in a system,
parsing through source code, object code, dictionaries, paragraphs, PROCS,
menus etc. and above all designed to be flexible enough to allow customized
'add-in' parsers that can handle site-specific conventions: there is no use
in looking for OPEN statements, for example, if the site always uses a
standard file open subroutine in its place.

I wrote it as a tool for me to use in consulting work, and when this was
raised on the list last month I took a long hard look at the product and
realized that whilst it produces reams of useful information it isn't quite
as user-friendly as it should be.. So I'm putting together some ideas on how
to improve the usability, including generating a more graphical view of the
results. Currently it will export to HTML pages to create documentation that
will hyperlink through the various levels, but I think that having a chart
view would assist the product greatly. 

Right now I'm in the middle of releasing a new product - a cut-down version
of my PDF tools called 'mvPDF Lite' for the more budget-conscious consumer
grin - but as soon as that is out of the way I'll be giving my attention
to mvScan.

In the meantime, I've written a white paper on what the scanner produces for
anyone who is interested.

And yes, Tony, I'll be in touch!

Regards

Brian

 -Original Message-
 From: owner-u2-us...@listserver.u2ug.org 
 [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G
 Sent: 27 May 2009 06:48
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] UV BASIC Flowing Charting Tools
 
 Here is a link to Brian's product page:
 http://BrianLeach.co.uk/mvscan.htm 
 
 I do not want to step on toes and attempt to create a 
 solution which duplicates one already provided by our 
 esteemed colleague Brian Leach.  If mvScan is not available, 
 or for some reason doesn't suit specific needs, I will offer 
 to try to put a graphical front-end on someone's existing 
 application parser.  I don't have the time to write that sort 
 of detailed and fragile back-end code but as I said earlier, 
 the graphical part
 (surprisingly?) shouldn't be that tough.  (Famous last words...)
 
 I make no apologies about the fact that my business survives 
 when we get paid for writing software, so anything I come up 
 with will be sold at some price balanced by both investement 
 and demand.
 (It's a helluva world when I actually feel a need to explain 
 something like that in a professional forum, but here we 
 are.) If you object in principle to paying for software then 
 you can either do this on your own or wait (a year? forever?) 
 for someone to do it for you for free, but please don't hold 
 it against me for attempting to offer supply for demand 
 without losing my house in the process.
 
 So I invite people to check out Brian's mvScan.  I invite 
 Brian, Norman, and John to contact me about collaboration 
 toward a new product with split revenues (thereby addressing 
 the bottom line issue which Norman's CEO mentions).  And I 
 invite anyone interested in a graphical flowchart (and 
 perhaps other visualizations of their MV data) to contact me 
 so that we have some idea of whether it will be worth it to 
 even do this.
 
 Thanks for your time.
 Tony Gravagno
 Nebula Research and Development
 TG@ remove.pleaseNebula-RnD.com
 Nebula RD sells mv.NET and other Pick/MultiValue products 
 worldwide, and provides related development services Visit 
 PickWiki.com!  Contribute!
 
  From: Norman Bauer
  I would also love to use it. Brian has a program that 
 essentially does 
  this, however in the economic times we are in now my CEO 
 told me if 
  it does not directly translaye into improveing the bottom 
 line I can 
  not authorize it.
  
  If I get time in the next year I may write something and 
 release it, 
  but don't hold your breath.
  
  Charlie Noah wrote:
   I am sure I'm not the only one interested. Please do request 
   permission to release it. John Israel said he'd written 
 one, but it 
   must be internal to his company, too. I can't find any 
 reference to 
   it, or to Brian Leach's program on the internet. I would be 
   interested in seeing their software as well. Guys?
   Knowing how snarled and convoluted some of our legacy 
 programs are, 
   this would be extremely difficult software to design and 
 build, and 
   I applaud those who have done so.
 
   Dan McGrath wrote:
   I have a tool I wrote here that does this for your entire source 
   repo.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Steve Romanow
Tony, take a look at graphviz.  May be helpful and is free.  I am not 
saying this should be _the_ tool, just a helper library.


If you can describe the system problematically, this library can render it.

Here http://www.graphviz.org/Gallery.php are some graphs created from 
basically text files of data.  It could be re-rendered automaically on a 
cron or something and published up to the company wiki or intranet.


Tony G wrote:

Here is a link to Brian's product page:
http://BrianLeach.co.uk/mvscan.htm 


I do not want to step on toes and attempt to create a solution
which duplicates one already provided by our esteemed colleague
Brian Leach.  If mvScan is not available, or for some reason
doesn't suit specific needs, I will offer to try to put a
graphical front-end on someone's existing application parser.  I
don't have the time to write that sort of detailed and fragile
back-end code but as I said earlier, the graphical part
(surprisingly?) shouldn't be that tough.  (Famous last words...)

I make no apologies about the fact that my business survives when
we get paid for writing software, so anything I come up with will
be sold at some price balanced by both investement and demand.
(It's a helluva world when I actually feel a need to explain
something like that in a professional forum, but here we are.)
If you object in principle to paying for software then you can
either do this on your own or wait (a year? forever?) for someone
to do it for you for free, but please don't hold it against me
for attempting to offer supply for demand without losing my house
in the process.

So I invite people to check out Brian's mvScan.  I invite Brian,
Norman, and John to contact me about collaboration toward a new
product with split revenues (thereby addressing the bottom line
issue which Norman's CEO mentions).  And I invite anyone
interested in a graphical flowchart (and perhaps other
visualizations of their MV data) to contact me so that we have
some idea of whether it will be worth it to even do this.

Thanks for your time.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
Visit PickWiki.com!  Contribute!

  

From: Norman Bauer
I would also love to use it. Brian has a program that 
essentially does this, however in the economic times 
we are in now my CEO told me if it does not directly 
translaye into improveing the bottom line I can not 
authorize it.


If I get time in the next year I may write something 
and release it, but don't hold your breath.

 
  

Charlie Noah wrote:

I am sure I'm not the only one interested. Please do 
request permission to release it. John Israel said 
he'd written one, but it must be internal to his 
company, too. I can't find any reference to it, or to 
Brian Leach's program on the internet. I would be 
interested in seeing their software as well. Guys? 
Knowing how snarled and convoluted some of our legacy 
programs are, this would be extremely difficult 
software to design and build, and I applaud those who 
have done so.
  


  

Dan McGrath wrote:
I have a tool I wrote here that does this for your 
entire source repo.
  

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

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


RE: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Israel, John R.
Along the same lines, I have a similar set of programs that looks at Redback 
objects (as defined in the Redback Designer).  It grabs all the objects, 
figures out all the methods associated with an object, then determines all the 
subroutines that could possibly be called from the method.  The results are 
E-mailed to the user in an easy to read HTML based table.

This uses the same type of logic as I mentioned to recursively loop through all 
subroutines.

For all those using Redback, this would be a useful sort of tool.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

-Original Message-
From: owner-u2-us...@listserver.u2ug.org 
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Tuesday, May 26, 2009 7:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV BASIC Flowing Charting Tools

   Dan,
   I am sure I'm not the only one interested. Please do request permission to
   release it.
   John Israel said he'd written one, but it must be internal to his company,
   too. I can't find any reference to it, or to Brian Leach's program on the
   internet. I would be interested in seeing their software as well. Guys?
   Knowing how snarled and convoluted some of our legacy programs are, this
   would be extremely difficult software to design and build, and I applaud
   those who have done so.
   Regards,
   Charlie Noah
   Inland Truck Parts Company
   On 5/26/2009 4:45 PM, Dan McGrath wrote:

I have a tool I wrote here that does this for your entire source repo.

It creates a UD file and processes each source file, mapping out which
subroutines the code calls and saves it as a record in the UD file.

I then have several dictionary items, such as SHALLOW, DEEP, ISPROGRAM
and TREE, which you can used to find programs/subroutines, which
directly/indirectly call something, or with TREE, display the entire
call tree 'graphically'.

It would be fairly trivial to change it to handle INCLUDEs, etc. If
anyone is interested, I could ask if I can release it.

Regards,

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Wednesday, 27 May 2009 6:50 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UV BASIC Flowing Charting Tools

I wrote something like this a while ago.  It has a driver program that
prompts for what you want (includes, calls, etc) and what program to
start on, then calls the main external subroutine.

This external subroutine recursively calls itself for each call and
include.

The trick to this is to remember which programs you have already
checked.  Otherwise, you could find yourself in a nasty endless loop
because you keep testing the same subroutines over and over.

John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G
Sent: Tuesday, May 26, 2009 4:31 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV BASIC Flowing Charting Tools

The trick isn't creating charts, or pretty ones.  The trick is to
create a flowchart from BASIC which shows Calls and Includes (one
kind of report), or files and fields used (another kind of
report).  You can take it further and trace Exceutes, procs,
paragraphs, etc.  All of those report types are data-centric and
it's a real challenge to create a generic utility that can derive
that sort of metadata from any given MV application.  Once you
have the data you can render it with any tools you wish.  Doing
the charting is the easy part.  :)

I believe Brian Leach has something for doing MV-oriented flow
charting as described above.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Visit PickWiki.com!  Contribute!

From: dennis bartlett

I like FusionCharts.

Steve Romanow wrote:
not specifically for unibasic, but Dia is nice and free.

Marco Manyevere wrote:

Does anyone have a good recommendation for Universe
BASIC source code flow charting software to aid with
analysis and documentation of existing code?

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

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
###

The information transmitted in this message and attachments (if any) is intende
d only
for the person or entity to which it is addressed. The message 

RE: [U2] Best algorithm for UV part files

2009-05-27 Thread Boydell, Stuart
Well, it's a 'how long's a piece of string' type of question but we had
a requirement to archive old data from a heavily used file.
The file has several indices too many and is in use 24/7
This makes copy/delete a fairly heavy impact on the system and archiving
was always an issue.
The IDs in the file are a mix of numeric and prefixed keys eg 123456 or
B123456 from different systems.

We decided that a part file would solve the issue because you can remove
the part from the DF and because the indices are attached to the part
it's a very quick, clean action. If for some reason you need to put it
back - it's also very quick and easy.

So, we came up with a part file system which puts 10 sequential IDs
into a part then moves onto the next one. For our requirement numeric
keys go in a different part from prefixed keys.

Theoretically this makes it easy to archive chunks of data by moving a
whole part and also to find specific date ranges for records based on
their keys within a particular part.

@PART.ALGORITHM = OCONV(@ID,'MCN':@VM:'MR05')[1] + 1;IF @ID MATCH '0N'
THEN @1 ELSE @1 + 10

Regards,
Stuart Boydell

-Original Message-
Does anyone have an opinion about the best algorithm to use for UV
distributed files?

The goal is ease of moving the records in the distributed files to other
files.


 
**
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 communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/