RE: [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Brian Leach
All

This is something we're keen to add to the U2UG website.

We're testing out a couple of different Wikis at the moment. We expect to have 
something in place very soon for the community to add technical tips, FAQs, 
learning materials, utilities, possibly vendor pages and similar materials.

Watch this space for announcements!

Regards

Brian

Other user groups that I belong(ed) to provide(d) a repository for user
submitted utilities. Things like neatly formatted file ACL's, tape listings,
database copy routines, etc Each submission would include the utility's
documentation, source code, any ancillary files (db) and executable if
applicable.

I am sure that there is a wealth of end user utilities available for U2.
This source code listing program would be a great start. Since our software
vendor does not provide any technical documentation about their system, the
sort of cross-reference source code tool features mentioned by Susan is
something I would find very usefull.

Currently, I just save any emails from this group that have useful proc's or
commands. Searching the archives is usefull but an index of software
utilities by category might be a better way to help fledging U2 programmers
see how to accomplish certain tasks.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Brian Leach
Tony/Susan

Having written two such 'system auditors' I can tell you from experience that 
it's not that easy to do a good source analysis.

The problem is that every system is different, adopts different standards, use 
different tools, are often very incomplete, and most include lots of bad links, 
obsolete code, multiple versions of the same program in different source files 
and the like.

[on to the predictable ad..]

Which is why mvScan was designed as a navigation and parsing tool. It scans 
through a system in a defined order running various 'plug-ins' at each stage. 
The provided plugins do source code (and object code) analysis, build impact 
maps of all calls, file opens/reads/writes from BASIC, PROC etc, SUBR() calls, 
dictionary translations, executed commands (from BASIC, Menus, paragraphs, 
PROCs), where things are cataloged, common block and include file usage - all 
that standard stuff.

But it also allows you to write custom plugins to pick up site-specific 
functionality. For example, you might have a generic file opener function that 
it needs to pick up on. Or you may have custom headers to your programs, or use 
a precompiler that handles includes and definitions. If you use a 4GL like 
uvCase or SB+, you might need to include the tool definitions. So the parser 
has to be very flexible to individual needs.

You also have to recognize that static analysis only goes so far. It can't 
parse relations that are derived at run time. The original auditor I wrote 
supported trigger insertion - automatically changing source code to replace 
reads/writes/opens/executes with functions that would capture and log 
information in real time as the system ran. mvScan doesn't - that approach is 
too dangerous unless done under controlled conditions. Instead, it uses an 
autodoc approach in which you are encouraged to 'fill in the gaps' yourselves 
with special documentary comments in the source code.

So the whole becomes an iterative process that will lead to a better understood 
and documented system.


Brian



Susan Lynch wrote:
 Tony, there are a number of things that a source code analyzer can do
 that would be very helpful if you found yourself coming into a
 company as a consultant or as a new employee and they had no
 technical documentation:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Credit Card Verification Software

2007-06-28 Thread Brian Leach
All

I'm looking for recommendations on credit card verification software that will 
integrate nicely with an MV application.

It needs to perform real-time authorisation, and should support the standard 
credit cards used in the UK - Diners, Amex and charge cards are not required. 
Direct or merchant verification will be considered.

I've used DataCash in the past and found their stuff easy to use and their 
staff very helpful, but I need some comparisons.

And of course it must be a cost-effective solution.

Thanks all!

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


RE: [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Anthony Youngman
PLEASE put stuff like this on PickWiki.

It's a wonderful place to put snippets, small programs, etc etc.

The one thing to watch out for about a user group keeping a repository
is that there's copyright issues involved. If you wrote the utility, you
can put it on PickWiki, or in a repository, or whatever. What the User
Group must NOT do (unfortunately) is to copy the code from the email
into a repository :-( This would raise a massive can of worms :-( When
did the US sign Berne? Things were a lot easier for USians (not us
Europeans) before then.

An alternative (should someone care to volunteer!) is to maintain an
index on the u2ug website pointing at a repository that stores the
emails.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 27 June 2007 22:50
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Basic developments reverse engineering tool ?

Other user groups that I belong(ed) to provide(d) a repository for user
submitted utilities. Things like neatly formatted file ACL's, tape
listings,
database copy routines, etc Each submission would include the
utility's
documentation, source code, any ancillary files (db) and executable if
applicable.

I am sure that there is a wealth of end user utilities available for U2.
This source code listing program would be a great start. Since our
software
vendor does not provide any technical documentation about their system,
the
sort of cross-reference source code tool features mentioned by Susan is
something I would find very usefull.

Currently, I just save any emails from this group that have useful
proc's or
commands. Searching the archives is usefull but an index of software
utilities by category might be a better way to help fledging U2
programmers
see how to accomplish certain tasks. 



Garry L. Smith
Dir Info Systems
Charles McMurray Company
V# 559-292-5782   F# 559-346-6169
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Credit Card Verification Software

2007-06-28 Thread George Land
Brian,

It depends on how you want to do it, we have software that works from the mv
server (UniData in our case) and posts the data to a payment provider
getting the appropriate messages in return.  It has the advantage that being
server based it can be used by anyone using any device and we can do it on a
fixed price basis rather than the usual percentage of transaction value.  It
would be easiest to talk about it if you are interested.  Email me at george
dot land at aptsolutions dot co dot uk if you would like to talk

George


On 28/6/07 08:38, Brian Leach [EMAIL PROTECTED] wrote:

 All
 
 I'm looking for recommendations on credit card verification software that will
 integrate nicely with an MV application.
 
 It needs to perform real-time authorisation, and should support the standard
 credit cards used in the UK - Diners, Amex and charge cards are not required.
 Direct or merchant verification will be considered.
 
 I've used DataCash in the past and found their stuff easy to use and their
 staff very helpful, but I need some comparisons.
 
 And of course it must be a cost-effective solution.
 
 Thanks all!
 
 Brian
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/


**
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify us immediately on +44 
(01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies 
in any format of this email you may have received in error. The recipient 
should note that the views contained or expressed within this correspondence do 
not necessarily reflect those of APT Solutions Limited , it subsidiaries, 
affiliates or associates. This email and any attachments are not guaranteed to 
be free from so-called computer viruses and it is recommended that you check 
for such viruses before down-loading it to your computer equipment. It is the 
responsibility of the recipient to ensure that the onward transmission, opening 
or use of this message or any attachments will not adversely affect their 
systems or data.

Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 
3AB

Registration Number:- 2228445

Place of Registration: England  Wales
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Device Licensing

2007-06-28 Thread phil walker
Sorry for the error on my part. It took me a while to figure that out
myself when I tried to find it on another client ;-).

What version of UV are you running?

My environment is UV 10.2.4 Enterprise on RHEL 4.0 using SSH. (This is
not officially supported).

It doesn't work. I get the following error file in the accuterm
directory and also in the dynamic control directory when trying that
with telnet.

U2devlic.err

11:26:08 06/28/07 pid = 3180 U2GetMachId(): unable to get host
information of hostname Error = 131
12:56:16 06/28/07 pid = 1748 U2GetMachId(): unable to get host
information of hostname Error = 183
13:06:10 06/28/07 pid = 1748 U2GetMachId(): unable to get host
information of hostname Error = 183

Does anyone know what that means?

Cheers,

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Thursday, 28 June 2007 3:46 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

Good call Bill. Mine is 3.0.3049.0


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 9:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing


David:

You might try ...\Atwin\u2licn.dll.  Mine's dated 10/28/04.

Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Wednesday, June 27, 2007 7:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

There is no such file on my system.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Wednesday, June 27, 2007 6:59 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing


David,

What version of the uvlicn.dll are you running?

Cheers

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Thursday, 28 June 2007 11:46 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

I finally resolved the issue. I reloaded and reauthorized,
then downloaded
accuterm as someone suggested. I was able to write a quick uniobjects
routine and connect with accuterm at the same time.

Thank you to all who replied

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins
Sent: Wednesday, June 27, 2007 3:46 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Device Licensing


As others have posted:

Device Licensing works for both U2 databases as long as you
have a license
which is one of:

* Workgroup
* Enterprise
* Server with device licensing (a recent offering)

In order that this will work you need a TELNET client that
supports Device
Licensing, and as there have been some changes in DL internals 
over time
they should also concurrent in release - ideally (of course) the latest
releases or fairly close.

IBM supply SBClient, wIntegrate and Dynamic as Telnet clients
that work with
DL - on wIntegrate and DC you need to remember to check the Use Device
Licensing on Unix check box if that is you server platform. 
DL will also
work with UniObjects and ODBC (for example) thought you should 
read up on
the use of subkeys for UO.

Some 3rd parties have arrangements with IBM to use the DL
software libraries
with their software, and they offer DL compatibility with their TELNET
clients. It is worth noting the point above though, DL internals have
changed over time. You might find that older versions of the 
TELNET clients
may not work correctly froma  DL viewpoint with more recent 
copies of the
databases. That being the case then an upgrade from your friendly local
TELNET client provider to a current build with updated software should
resolve it.

Issues which got in the way in the past related mostly to
combinations of
stty settings in Unix, all (even vaguely) recent versions 
got the code
modified so that's not an issue. There was also an issue more 
recent) where
ODBC sessions (for example) used a different DL user pool to TELNET
sessions. So ODBC would allow up to 10 sessions as one 
license, and TELNET
would do the same - but each connection would use a separate 
slot. In those
circumstances (for example) one UO and one TELNET would take 2 licenses
(fixed).

Always a useful test - try using Dynamic Connect from the
current client
softwarethat should work fine and act as a check on any 3rd
party software.

Hoping this answers any queries - please post if any follow-ups.

Regards

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

RE: [U2] Device Licensing

2007-06-28 Thread David Ward
I'm running 10.2.0 on windows.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Thursday, June 28, 2007 3:50 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing


Sorry for the error on my part. It took me a while to figure that out myself
when I tried to find it on another client ;-).

What version of UV are you running?

My environment is UV 10.2.4 Enterprise on RHEL 4.0 using SSH. (This is not
officially supported).

It doesn't work. I get the following error file in the accuterm directory
and also in the dynamic control directory when trying that with telnet.

U2devlic.err

11:26:08 06/28/07 pid = 3180 U2GetMachId(): unable to get host information
of hostname Error = 131 12:56:16 06/28/07 pid = 1748 U2GetMachId(): unable
to get host information of hostname Error = 183 13:06:10 06/28/07 pid = 1748
U2GetMachId(): unable to get host information of hostname Error = 183

Does anyone know what that means?

Cheers,

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Thursday, 28 June 2007 3:46 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

Good call Bill. Mine is 3.0.3049.0


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 9:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing


David:

You might try ...\Atwin\u2licn.dll.  Mine's dated 10/28/04.

Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Wednesday, June 27, 2007 7:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

There is no such file on my system.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Wednesday, June 27, 2007 6:59 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing


David,

What version of the uvlicn.dll are you running?

Cheers

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Thursday, 28 June 2007 11:46 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Device Licensing

I finally resolved the issue. I reloaded and reauthorized, then 
downloaded accuterm as someone suggested. I was able to write a quick 
uniobjects routine and connect with accuterm at the same time.

Thank you to all who replied

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins
Sent: Wednesday, June 27, 2007 3:46 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Device Licensing


As others have posted:

Device Licensing works for both U2 databases as long as you have a 
license which is one of:

* Workgroup
* Enterprise
* Server with device licensing (a recent offering)

In order that this will work you need a TELNET client that supports 
Device Licensing, and as there have been some changes in DL internals
over time
they should also concurrent in release - ideally (of course) the latest
releases or fairly close.

IBM supply SBClient, wIntegrate and Dynamic as Telnet clients that work 
with DL - on wIntegrate and DC you need to remember to check the Use 
Device Licensing on Unix check box if that is you server platform.
DL will also
work with UniObjects and ODBC (for example) thought you should 
read up on
the use of subkeys for UO.

Some 3rd parties have arrangements with IBM to use the DL software 
libraries with their software, and they offer DL compatibility with 
their TELNET clients. It is worth noting the point above though, DL 
internals have changed over time. You might find that older versions of 
the TELNET clients
may not work correctly froma  DL viewpoint with more recent 
copies of the
databases. That being the case then an upgrade from your friendly local
TELNET client provider to a current build with updated software should
resolve it.

Issues which got in the way in the past related mostly to combinations 
of stty settings in Unix, all (even vaguely) recent versions
got the code
modified so that's not an issue. There was also an issue more 
recent) where
ODBC sessions (for example) used a different DL user pool to TELNET
sessions. So ODBC would allow up to 10 sessions as one 
license, and TELNET
would do the same - but each connection would use a separate 
slot. In those
circumstances (for example) one UO and one TELNET would take 2 licenses
(fixed).

Always a useful test - try using Dynamic Connect from the current 
client softwarethat should work fine and act as a check on 
any 3rd party software.

Hoping this answers any queries - please post if any follow-ups.

Regards

JayJay
---
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 

RE: [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Susan Joslyn
I was thinking of the sort of documentation that you could get from writing
a utility to comb through code. I've written some (not for prime time)
versions of this sort of thing. In particular whenever converting from one
platform to another.

The types of technical documentation that one can glean programmatically
from an application are:

What files are opened by what programs
Where are records written
What fields/amcs are read and written by what programs
What subroutines are called by what programs
What includes/inserts are in use, where
In the case of SB+ (or any system where fields are referenced by name) -
schemas can be built identifying field name across files and when and where
these are updated

What else?

One thing that I have built into my application that I use rarely but when I
need it I find it extremely handy - every one of my programs calls a
subroutine at the beginning that just time-date stamps that it has been run.
I think I keep the last five or ten runs in a Multivalue list.

This helps when I want to clean up and find stuff that never gets run - or
when I want to see the last time a customer ran something.  I tiny little
subroutine that you can stuff programmatically into a top line of all
programs and let it go for awhile.  Then come back and find interesting
things.

Susan

Date: Wed, 27 Jun 2007 11:33:17 -0700
From: Tony Gravagno [EMAIL PROTECTED]

I don't believe there is a way to have a program read code and figure out
what it does from a logical perspective.  When you say technical
documentation, I'm not sure what sort of info you wish to extract from your
code.  If you mean file usage, common usage, etc, the only way to get a
program to process such information is to make sure you have your code
completely consistent - or you need to use meta data as described below.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Device Licensing

2007-06-28 Thread Jerry Banker
Does it work with ssh?

-Original Message-
From: John Jenkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 3:46 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Device Licensing

As others have posted:

Device Licensing works for both U2 databases as long as you have a
license
which is one of:

* Workgroup
* Enterprise
* Server with device licensing (a recent offering)

In order that this will work you need a TELNET client that supports
Device
Licensing, and as there have been some changes in DL internals over time
they should also concurrent in release - ideally (of course) the latest
releases or fairly close.

IBM supply SBClient, wIntegrate and Dynamic as Telnet clients that work
with
DL - on wIntegrate and DC you need to remember to check the Use Device
Licensing on Unix check box if that is you server platform. DL will
also
work with UniObjects and ODBC (for example) thought you should read up
on
the use of subkeys for UO.

Some 3rd parties have arrangements with IBM to use the DL software
libraries
with their software, and they offer DL compatibility with their TELNET
clients. It is worth noting the point above though, DL internals have
changed over time. You might find that older versions of the TELNET
clients
may not work correctly froma  DL viewpoint with more recent copies of
the
databases. That being the case then an upgrade from your friendly local
TELNET client provider to a current build with updated software should
resolve it.

Issues which got in the way in the past related mostly to combinations
of
stty settings in Unix, all (even vaguely) recent versions got the code
modified so that's not an issue. There was also an issue more recent)
where
ODBC sessions (for example) used a different DL user pool to TELNET
sessions. So ODBC would allow up to 10 sessions as one license, and
TELNET
would do the same - but each connection would use a separate slot. In
those
circumstances (for example) one UO and one TELNET would take 2 licenses
(fixed).

Always a useful test - try using Dynamic Connect from the current client
softwarethat should work fine and act as a check on any 3rd
party software.

Hoping this answers any queries - please post if any follow-ups.

Regards

JayJay
---
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] Credit Card Verification Software

2007-06-28 Thread Brutzman, Bill
Google has a way to do this.  Also consider AWS, Amazon Web Services.

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brian Leach
Sent: Thursday, June 28, 2007 3:38 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Credit Card Verification Software


All

I'm looking for recommendations on credit card verification software that
will integrate nicely with an MV application.

It needs to perform real-time authorisation, and should support the standard
credit cards used in the UK - Diners, Amex and charge cards are not
required. Direct or merchant verification will be considered.

I've used DataCash in the past and found their stuff easy to use and their
staff very helpful, but I need some comparisons.

And of course it must be a cost-effective solution.

Thanks all!

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


RE: [U2] UD Backups

2007-06-28 Thread Brutzman, Bill
Bill:

I would be interested to look over these NT scripts...  

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 7:32 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Backups


Colin:

As always, thanks.  I guess it could be anything.  I was thinking it was
just how slow stuff is, and how much junk we're all willing
to put up with.  :-)

The cost is always a shock when one moves out of MV.  But, I'm getting used
to it so pricing isn't that big a deal.  However, the
backup solution has to be loaded on about 7 Windows servers.  As it stands
now, I've built a couple of interesting NTBackup scripts
that do everything for me, including ftp'ing the backups across the network
to a storage machine, emailing me, and cleaning up the
archives (so I don't end up with so many backup files it crashes the disk).

Thanks again.

Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 4:19 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Backups

So it could be anything from poor drive setup/layout, slow controller,
lack of ram, busy server (domain controller?). 

I have seen print processes run amok and create items in the temp
folder that filled the drive. Maybe that's where your extra space went.
I haven't seen anything taking up 10 times more space than 
reported (are
you sure you read it correctly!?)

None of our clients really needs high-speed backup. We did have one
client come close as they had offices all over the world so a good
backup window was getting tough to find. 

Backup Exec does have an open files option - or is it the cost that you
don't like?

hth
Colin Alfke
Calgary, Canada

-Original Message-
From: Bill Haskett

Colin:

The backups seem to take about the same time with or without UD
shutdown, on the development server.  I just ran a backup on our UD
directory and it was 1Gb, compressed to 120Mb, and took about 5 1/2
minutes to create.  On one of our client's D3 server, the uncompressed
file-save, of the same data, took about 40 seconds and was about 200Mb.
I took a look at another one of our clients and their D3 backup was
1.1Gb of a 5-6Gb database, on Windows, and it took 6 minutes to create.
In one of our beta accounts, someone created a 12Mb hold entry and
somehow Windows showed there were 11.7Gb in the _HOLD_ directory when
the item, created on 6/25/07, showed as 12Mb in Windows Explorer.  I
deleted that item and this problem disappeared (where'd that come
from?).  I suppose this is just one more of the multitude of problems
I've got to keep my eye on!  Anyway...

We don't have any transaction processing.  The timing starts when the
NTBackup starts, after the dbpause.  The timing ends when the dbresume
is executed, not when it completes.

I've been researching backup software and it all seems to point back to
Symantec (jeeze!).  I was hoping someone would have experience with a
high-speed backup product that would backup open files for U2.  Since
our application has a module that uses ASP.NET we really don't want to
shut down the dbms for very long (this is more important than backuping
up open files and not having a pristine backup).

Thanks,

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


[U2] Phantoms not working

2007-06-28 Thread Moderator
REPOSTED FOR NON-MEMBER ADDRESS: DMeerholz [EMAIL PROTECTED]

Hi,

Anyone got any ideas what the problem here could be?
I installed uniVerse on a FedoracCore 6 box the other day, got everything 
working fine... I thought, until i realised today that the phantoms aren't 
running.

I have a little BP program TEST.XXX, only code in it is PRINT 1, 
compiled and cataloged.
PHANTOM TEST.XXX

This is the output in the PH file.

LIST.ITEM PH LIKE ...XXX... 03:43:59pm  28 Jun 2007  PAGE1
001 Unable to execute the operating system file bin/uv.  
002 [ENOENT] No such file or directory

1st I thought I just need to add the /usr/ibm/uv path to my global paths for 
linux, but checked another box and it wasnt part of the paths.
Then I thought permissions, but permissions on the file are exactly the same a 
the working box.
I then tried making a little script that would send it straight to /usr/ibm/uv 
and execute bin/uv like it seemed it was trying to do... I
placed this in the account that I was running the program, but then the phantom 
basically starts a session for you... PH output...

LIST.ITEM PH LIKE ...XXX... 03:43:52pm  28 Jun 2007  PAGE1
TEST.XXX_48815_14424
001 UniVerse Command Language 10.1
002 (c) Copyright IBM Corporation 2003. All rights reserved.
003 uv logged on: Thu Jun 28 13:33:35 2007
005 

So thats not it either...

Anyone got any ideas what is wrong?

Thanks.
BOUNCE NOTICE:

   Your recent post to our lists bounced because either you are not a member or 
because you are not signed up using the e-mail address which you used to post. 
To subscribe or resubscribe please visit http://listserver.u2ug.org/.

- Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions, RBSolutions
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Phantoms not working

2007-06-28 Thread Anthony Youngman
Not sure what you mean by checked another box, but it does sound very
like a paths problem. What user is the phantom running as? What does
that user's .profile contain? Could the user launching the phantom drop
to the linux command line and run bin/uv?

Cheers,
Wol

-Original Message-
From: Moderator [mailto:[EMAIL PROTECTED] 
Sent: 28 June 2007 15:06
To: DMeerholz; u2-users@listserver.u2ug.org
Subject: [U2] Phantoms not working

REPOSTED FOR NON-MEMBER ADDRESS: DMeerholz [EMAIL PROTECTED]

Hi,

Anyone got any ideas what the problem here could be?
I installed uniVerse on a FedoracCore 6 box the other day, got
everything working fine... I thought, until i realised today that the
phantoms aren't running.

I have a little BP program TEST.XXX, only code in it is PRINT
1, compiled and cataloged.
PHANTOM TEST.XXX

This is the output in the PH file.

LIST.ITEM PH LIKE ...XXX... 03:43:59pm  28 Jun 2007  PAGE1
001 Unable to execute the operating system file bin/uv.  
002 [ENOENT] No such file or directory

1st I thought I just need to add the /usr/ibm/uv path to my global paths
for linux, but checked another box and it wasnt part of the paths.
Then I thought permissions, but permissions on the file are exactly the
same a the working box.
I then tried making a little script that would send it straight to
/usr/ibm/uv and execute bin/uv like it seemed it was trying to do... I
placed this in the account that I was running the program, but then the
phantom basically starts a session for you... PH output...

LIST.ITEM PH LIKE ...XXX... 03:43:52pm  28 Jun 2007  PAGE1
TEST.XXX_48815_14424
001 UniVerse Command Language 10.1
002 (c) Copyright IBM Corporation 2003. All rights reserved.
003 uv logged on: Thu Jun 28 13:33:35 2007
005 

So thats not it either...

Anyone got any ideas what is wrong?

Thanks.
BOUNCE NOTICE:

   Your recent post to our lists bounced because either you are not a
member or because you are not signed up using the e-mail address which
you used to post. To subscribe or resubscribe please visit
http://listserver.u2ug.org/.

- Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions,
RBSolutions
---
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: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly

2007-06-28 Thread Dean.Armbruster
According to the UniData documentation (UniData UniBasic Commands
Reference (BASR.pdf), Appendix B), @SYSTEM.RETURN.CODE is supposed to be
the number of items in the select list.  This is for all the various
SELECT commands, (SELECT, SSELECT, NSELECT, QSELECT), not just BSELECT.

Using the example below, @SYSTEM.RETURN.CODE should be 60, just like
SYSTEM(11).  It should not be 20, which is the number of records
scanned/queried.  If other selects worked that way, then @SYSTEM.RETURN
code for any SELECT would return the number or records in the file, or
the number of items in an active list before the command was executed.
For example, if there were 100 Customers, 20 of which were in Ohio, the
SELECT CUSTOMER WITH STATE = OH would select 20 records with
@SYSTEM.RETURN.CODE = 100 and SYSTEM(11) = 20.


[re: OFF TOPIC ASIDE]
That is our typical structure also, but there are times where we do
multiple selects and that is where BSELECT bit us.  Something like this:

EXECUTE \BSELECT PO.HEADER WITH DATE EQ 6/27 DIRECT.INVOICES\
IF @SYSTEM.RETURN.CODE GT 0 THEN
  EXECUTE \BSELECT AP.TO.PO.XREF WITH VENDOR EQ 12345 PURCH.AGENT\

If there were PO.HEADER records that met the selection criterion but
DIRECT.INVOICES were null for all, there would be no active list after
the first BSELECT.  Unfortunately, @SYSTEM.RETURN.CODE will not be 0, so
the second BSELECT will execute but act against the whole file instead
of a limited list, which is not the intended action.

[/re: OFF TOPIC ASIDE]



 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 [EMAIL PROTECTED]
 Sent: Wednesday, June 27, 2007 9:52 AM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
 
 Dean Armbruster wrote on 26 Jun 2007 16:14:21 -0400
 
  ... This is about BSELECT ...
 
  @SYSTEM.RETURN.CODE is not supposed to be the number of
  *records* selected.  It is supposed to be the number of 
 items in the 
  select list.
 
 I would suggest that, in this case, the documentation is 
 incorrect (or at least unclear), not the return code.
 
 Why?  Because BSELECT allows you to select more than one 
 attribute.  From the help:
 
 Unlike the SELECT command, which retrieves only record IDs, 
 BSELECT builds a list of the attributes you name in the 
 UniQuery statement.
 
 Typically, this command is used to get record ID's stored in 
 one file (e.g., BSELECT ORDER.HEADER LINE.KEY), but it can 
 also be used to get a SET of fields.  For example, 
 
 BSELECT CUSTOMER WITH STATE = OH NAME PHONE FAX
 
 In this case, I would get a list with (typically) three 
 entries for each of my Customers in Ohio:  Name, Phone and 
 Fax, in repeating order.  If I have 20 customers in Ohio 
 would expect @SYSTEM.RETURN.CODE to return 20 (the number of 
 items/records selected), and I would expect SYSTEM(11) would 
 have the total number of items in my list (i.e., 60).  
 However, if any of the fields were multi-valued, I would get 
 ALL of those values in my list, just as if I had used a 
 BY-EXP in a sort.
 
  Watch out!  @SYSTEM.RETURN.CODE for BSELECT is not what the 
  documentation says it is.  Your list may not have the number of 
  entries indicated.  Your list may even be empty even though 
  @SYSTEM.RETURN.CODE is greater than zero.
 
 Can you support this last statement?  In every test I ran, 
 @SYSTEM.RETURN.CODE was the number of records selected, and 
 @SYSTEM(11) was the total number of items.  Of course, I tend 
 to BSELECT FILE WITH ATTR ATTR...
 
 --Tom Pellitieri
   Century Equipment
 
 [OFF TOPIC ASIDE]
 
 For what it's worth, I was taught to check SYSTEM(11) for the 
 number of items returned by an EXECUTE statement, although 
 typically I don't check it at all.  My usual processing loop uses:
 
 CTR = 0
 EXECUTE \SELECT ...\
 LOOP WHILE READNEXT ID DO
   CTR += 1
   ...
 REPEAT
 
 So CTR has my processed count, and if there isn't anything to 
 process, the loop exits immediately.
 
 [/OFF TOPIC ASIDE]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[AD] [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread Laura Hirsh
The type of Technical Documentation that Susan mentions is a part of
DocuSys! Not only does DocuSys comb through basic code, and also the gamut
of SB+ bits, but it sends it to MS Word - nicely formatted, with a table of
contents, pagination, Styles, etc. Options include both User Documentation
(for SB+ Apps) and Technical Documentation (SB+/Non-SB+). 

This isn't really an ad, but DocuSys a really useful product/tool. If anyone
would like more information, let me know!

Laura Hirsh


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Thursday, June 28, 2007 7:59 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Basic developments reverse engineering tool ?

I was thinking of the sort of documentation that you could get from writing
a utility to comb through code. I've written some (not for prime time)
versions of this sort of thing. In particular whenever converting from one
platform to another.

The types of technical documentation that one can glean programmatically
from an application are:

What files are opened by what programs
Where are records written
What fields/amcs are read and written by what programs
What subroutines are called by what programs
What includes/inserts are in use, where
In the case of SB+ (or any system where fields are referenced by name) -
schemas can be built identifying field name across files and when and where
these are updated

What else?

One thing that I have built into my application that I use rarely but when I
need it I find it extremely handy - every one of my programs calls a
subroutine at the beginning that just time-date stamps that it has been run.
I think I keep the last five or ten runs in a Multivalue list.

This helps when I want to clean up and find stuff that never gets run - or
when I want to see the last time a customer ran something.  I tiny little
subroutine that you can stuff programmatically into a top line of all
programs and let it go for awhile.  Then come back and find interesting
things.

Susan

Date: Wed, 27 Jun 2007 11:33:17 -0700
From: Tony Gravagno [EMAIL PROTECTED]

I don't believe there is a way to have a program read code and figure out
what it does from a logical perspective.  When you say technical
documentation, I'm not sure what sort of info you wish to extract from your
code.  If you mean file usage, common usage, etc, the only way to get a
program to process such information is to make sure you have your code
completely consistent - or you need to use meta data as described below.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [AD] UniVerse Programmer needed in New Jersey

2007-06-28 Thread Barry Rogen
  Position:   Full time, permanent  U2 programmer
Environment:   UniVerse, residing on HP systems
  Location:Northern New Jersey
  Experience Level:   1 - 5 years
  Type Business:   Manufacturing

   Requirements/Expectations:  Must be able to mutitask and work in a
challenging, fast paced environment. EDI knowledge is necessary.
Terrific opportunities for technical growth and training. Solid
programming skills expected.

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

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

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


RE: [U2] Credit Card Verification Software

2007-06-28 Thread John Hester
 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
 Sent: Thursday, June 28, 2007 12:38 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Credit Card Verification Software
 
 All
 
 I'm looking for recommendations on credit card verification 
 software that will integrate nicely with an MV application.

We're using PayFlow Pro from PayPal (previously Verisign) to do
verification from UV.  It's not an MV specific product, but was
nonetheless pretty trivial to integrate.  They supply an OS level
executable that calls their web service in real-time.  We just put
together a flat XML file from within UV, send it to the PayFlow
executable via a BASIC EXECUTE, then parse the XML we get back.  We've
been using it for about a year and a half and it's been working
flawlessly for us.

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


RE: [U2] UD Backups

2007-06-28 Thread Bill Haskett
Bill:

Try http://www.pickwiki.com/cgi-bin/wiki.pl?AutomateNTBackup.

Let me know if this helps.

Bill 

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, June 28, 2007 6:19 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UD Backups

Bill:

I would be interested to look over these NT scripts...  

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 7:32 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Backups


Colin:

As always, thanks.  I guess it could be anything.  I was 
thinking it was just how slow stuff is, and how much junk
we're all willing to put up with.  :-)

The cost is always a shock when one moves out of MV.  But, I'm 
I'm getting used to it so pricing isn't that big a deal.  However,
the backup solution has to be loaded on about 7 Windows servers.  
As it stands now, I've built a couple of interesting NTBackup
scripts that do everything for me, including ftp'ing the backups 
across the network to a storage machine, emailing me, and cleaning
up the archives (so I don't end up with so many backup files it 
crashes the disk).

Thanks again.

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


Re: [AD] [U2] Basic developments reverse engineering tool ?

2007-06-28 Thread MAJ Programming
How does it work with parameter driven code.

One of my clients has procs like this:

HRUN BP SOP1500
STON
HORDER
HCUSTOMER
HPRODUCT
HVENDOR
P

whereby the program (BP SOP1500) has the corresponding INPUT statements for
the file names and opens them as F1, F2, F3 which is a real bear when
reading the code. Plus all of the bottom line field prompts are also
tableized. Very klugy and not friendly at all.

I tend to copy the program in question to another place and do a global
replace of the R/F1/ORDER just to see the flow.

Thanks
Mark Johnson
- Original Message -
From: Laura Hirsh [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, June 28, 2007 2:26 PM
Subject: [AD] [U2] Basic developments reverse engineering tool ?


 The type of Technical Documentation that Susan mentions is a part of
 DocuSys! Not only does DocuSys comb through basic code, and also the gamut
 of SB+ bits, but it sends it to MS Word - nicely formatted, with a table
of
 contents, pagination, Styles, etc. Options include both User Documentation
 (for SB+ Apps) and Technical Documentation (SB+/Non-SB+).

 This isn't really an ad, but DocuSys a really useful product/tool. If
anyone
 would like more information, let me know!

 Laura Hirsh


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
 Sent: Thursday, June 28, 2007 7:59 AM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] Basic developments reverse engineering tool ?

 I was thinking of the sort of documentation that you could get from
writing
 a utility to comb through code. I've written some (not for prime time)
 versions of this sort of thing. In particular whenever converting from one
 platform to another.

 The types of technical documentation that one can glean programmatically
 from an application are:

 What files are opened by what programs
 Where are records written
 What fields/amcs are read and written by what programs
 What subroutines are called by what programs
 What includes/inserts are in use, where
 In the case of SB+ (or any system where fields are referenced by name) -
 schemas can be built identifying field name across files and when and
where
 these are updated

 What else?

 One thing that I have built into my application that I use rarely but when
I
 need it I find it extremely handy - every one of my programs calls a
 subroutine at the beginning that just time-date stamps that it has been
run.
 I think I keep the last five or ten runs in a Multivalue list.

 This helps when I want to clean up and find stuff that never gets run - or
 when I want to see the last time a customer ran something.  I tiny little
 subroutine that you can stuff programmatically into a top line of all
 programs and let it go for awhile.  Then come back and find interesting
 things.

 Susan
 
 Date: Wed, 27 Jun 2007 11:33:17 -0700
 From: Tony Gravagno [EMAIL PROTECTED]

 I don't believe there is a way to have a program read code and figure out
 what it does from a logical perspective.  When you say technical
 documentation, I'm not sure what sort of info you wish to extract from
your
 code.  If you mean file usage, common usage, etc, the only way to get a
 program to process such information is to make sure you have your code
 completely consistent - or you need to use meta data as described below.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/