Does it exists a (marketed?) tool for MV databases (i.e UniVerse) that
would allow
to make the reverse engineering of an application, based on automated
Basic source code analysis ?
Thanks for any information.
Herve' Balestrieri
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
Using UniCommand.Execute / NextBlock to get chunks of data from a UV
server there seems to be up to a minute between fetches. The NextBlock
code is sitting in a hard loop and the servers (source target) seem to
be fairly quiescent for most of this time - so it doesn't appear to be a
load issue.
Phil,
The answer is yes, we have an interface in the testing phase that receives
an xml, wrapped in SOAP, through the IBM web services and passes the data
into our UniVerse system for processing. Michael Byrne at IBM provided us
with a document, Getting Started with the U2 Web Services Developer,
Great minds
Although I find that if I have it CHAIN itself every hour, it doesnt
leave its messy orphan children around.
j
On 6/26/07, David A. Green [EMAIL PROTECTED] wrote:
David,
What I did was to write a Master Scheduler Program that runs as a phantom
and phantoms off the background
I know this question has come up before but there have been many new
developments in Universe including a whole new release so I'm going to
ask it anyway. Also I know that it sometimes it's a matter of what you
have been taught.
What is the best way to get information to and from a SQLServer
There was UN-Basic that took compiled code and reverted it back to source
code.
My 1 cent
Mark Johnson
- Original Message -
From: Herve Balestrieri [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, June 27, 2007 6:37 AM
Subject: [U2] Basic developments reverse engineering
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
You may want to look at D3's Background(s) processor. Sorta does the same
thing.
Mark Johnson
- Original Message -
From: john reid [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, June 27, 2007 8:31 AM
Subject: Re: [U2] Universe Phantom
Great minds
Although I
snip
What is the best way to get information to and from a SQLServer database
using Universe Basic?
/snip
What do you plan on doing? Are you pushing small records to SQLServer,
retrieving small records or pushing/getting large tables?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
You can setup SQL Server for access via XML and utilize the XML tools within
Universe to extrapolate the data. I did this a few years back before the XML
tools were available, so it should be an easy task these days.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
The best way - I cannot answer that... Sorry.
I think somebody will suggest ODBC... So I should let him/her explain
it. :)
I assume when you said Latest version, you mean SQL Server 2005.
http://technet.microsoft.com/en-us/library/ms191274.aspx
Microsoft SQL Server 2005 provides native XML
To clarify the inquiry : I am seeking for a tool reading Basic source code
modules and producing a technical documentation of an application
automatically.
This is not the purpose of an object code decompiler.
Thanks
Herve' Balestrieri
There was UN-Basic that took compiled code and reverted it
Basically it has to do with PCI. We are putting all of our card data on
a secure encrypted SQLServer so we can access the data from all of our
applications. The records will most likely be in one table and we will
want to read the data, record by record, or write it, record by record,
using UV.
At 11:29 AM 6/26/2007, you wrote:
I've been testing NTBackup recently. There are some significant
time delays in backuping up a UD system vs a plain Windows system.
One thing to look at is the size of data prior to backup, IE the size
of the data source, not the size of the resultant backup
Something like PRC? Contact Susan through http://www.sjplus.com/
-Original Message-
From: Herve Balestrieri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 10:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic developments reverse engineering tool ?
To clarify the
The best such tool I ever saw was SoftWhere by Joe Toledo. I don't know
if he still sells it.
It reads source code, dictionaries, procs, and maps dependencies.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Herve
Balestrieri
Sent: Wednesday, June 27,
Yes, I'm told it will be SQL Server 2005 on Windows 2003.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 9:55 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV
The best way - I cannot
Universe BCI works very well.
http://212.241.202.162/kb/kbview.wsp?id=9
Ross
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, June 27, 2007 6:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] The best way to access
unsubscribe [EMAIL PROTECTED]
- Original Message -
From: U2 Users Digest [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 11:29 AM
Subject: U2 Users Digest V1 #1715
U2 Users Digest Wednesday, June 27 2007 Volume 01 : Number
1715
In this issue:
Jerry
Sorry I send my previous reply before seeing this post.
I was thinking of the bulk update side.
Brian
Basically it has to do with PCI. We are putting all of our card data on
a secure encrypted SQLServer so we can access the data from all of our
applications. The records will most likely
Jerry,
I don't know if it's the best way, but we use UV's bci. At tcl enter
HELP BCI and you'll see all the functions. It works great for us. We
can write UV programs with the sql embedded or write UV programs calling
sql server stored procedures returning a result set. We're satisfied
with
Jerry
If by 'built-in' you include the middleware that comes with UV:
1. Create a .Net client.
2. Use the UniXML class to produce a dataset from a RetrieVe or SQL XML
statement.
3. Iterate through the dataset and use a dbCommand to push that into SQL via a
stored procedure.
Simple and
Any reason you're not putting it on a secure encrypted UV server? (I
believe the latest version of UV does native encryption ... :-)
If it's not a 1-1 record-row match, then SQL-Server will be unlikely
to match UV for speed.
Cheers,
Wol
-Original Message-
From: Jerry Banker
We have a series of programs that will dissect a U2 application and create a
series of documentation databases. We have some canned reports or you can
simply use LIST to generate your own reports. The application is available
for installation on one of your systems so you can maintain this level
It's time to wave the white flag and display my ignorance. After all
these years of writing MV code, I am attempting to use a trigger routine
for the first time. I need to find out what is causing the mysterious
disappearance of the contents of certain fields in our PRODUCT master
file. It
Herve
I have something that may do what you need (mvScan).
I'll contact you off-list with some details.
Brian
To clarify the inquiry : I am seeking for a tool reading Basic source code
modules and producing a technical documentation of an application
automatically.
This is not the purpose of
It seems that there is a problem with the digest emails once again as
I'm receiving a digest with just one email in it. Could this be looked
into, please?
Thanks,
Jan Darr
Programmer/Analyst
Tranzact Technologies, Inc
630.833.0890 Main | 630.530.6731 Direct | 630.833.8586 Fax
www.tranzact.com |
Unsubscribe * [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 27 June 2007 16:35
To: [EMAIL PROTECTED]
Subject: U2 Users Digest V1 #1716
U2 Users Digest Wednesday, June 27 2007 Volume 01 : Number
1716
In this issue:
RE:
Strange, I never received a reply from you.
-Original Message-
From: Brian Leach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 11:00 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]
Jerry
Sorry I send my previous
In unidata:
1. Before image you could just read the record from the file.
2. After image is what's in the record parameter passed into the trigger
subroutine.
3. You need different subroutines for the BEFORE UPDATE trigger and the
BEFORE DELETE trigger, as they take different numbers of
Our universe system is accessed too directly from the web for us to
qualify for PCI compliance. We also have other places that contain card
data, like contract images, and we access the data from more than just
UV. So we have to put all of this data on a more secure system in only
one place. Lock
Thanks, Jerry ... PRC can help with this, but does not do specifically what
Herve is really seeking. ROI Syngineering had a great utility for this, I'm
not sure if anyone is marketing it now that Bob has passed away. Does anyone
know? And I remember Softwhere by Toledo Assoc., too, but I'm not
Herve Balestrieri wrote:
To clarify the inquiry : I am seeking for a tool reading Basic source
code modules and producing a technical documentation of an application
automatically.
This is not the purpose of an object code decompiler.
I don't believe there is a way to have a program read code
Norman,
Unidata:
The person running the CREATE.TRIGGER verb needs to be the owner of the file
you are adding a trigger to and the trigger program needs to be globally
cataloged.
HELP CREATE.TRIGGER should get you started.
Tom
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
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
Thanks Doug, I'll look at this.
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Doug Miller
Sent: Wednesday, June 27, 2007 8:26 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UD Backups
At 11:29 AM 6/26/2007, you wrote:
I've been testing
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:
List programs that open each file - useful for verifying that adding an
...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
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:
Without knowing more about what Herve wanted, I'm
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
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
I believe Accuterm is one of the 3rd party products you mentioned. At
least is does have a U2 device licensing option in its configuration.
However we cannot get device licensing to work using Accuterm, with SSH
protocol and RHEL 4.0, Universe 10.2.4 enterprise version?
Is Accuterm still
I can't remember if I've asked this before but we occasional needed to provide
a custom script for our ASP clients. In D3 it looked
like:
01 N
02 DISPLAY ...selecting items for processing
03 P
04 SSELECT ARTOPEN WITH DESC = DELINQUENT CHARGE AND WITH AGE 30 ACCOUNT
05 SL DELINQ.LIST
06 GL
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
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
GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2
SAVE-LIST DELINQ.LIST
GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST
Thanks,
David A. Green
DAG Consulting
-Original Message-
From: [EMAIL PROTECTED]
Have you looked at the SAVING UNIQUE clause of the SSELECT statement? Not
sure if it works under ECLTYPE P, but it's worth a look.
Larry Hiscock
Western Computer Services
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Wednesday,
Hi!
I saw this message but no responses and I'm not sure how much
I'm going to help. And I'm not sure if you're on Unix or
Windows for a server...But let me throw this out...
We wrote/sell a product called PEEK for Unix. It runs at
the Unix level and enabled you to see what someone is doing,
Bill Haskett wrote:
snip
A variety of people in our support department could build these kinds of
scripts. This is a D3 script. Line 03 hushes output, line
06 makes sure redundant IDs aren't selected. I've tried the usual MERGE.LIST
commands and can't get this to work in a paragraph.
I
Numbered lists work in ECL type U mode (you can always use the lower case
versions of the verbs to force U mode - even in a PROC).
There is also the SAVING UNIQUE keyword.
Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO 80237
Tel:
Colin Alfke asked:
Along that line - would there be anything else that may be holding up
DBPAUSE?
A cause of a slow response back from DBPAUSE is not enough disk drives
under a system. When DBPAUSE is initiated, it flushes all of the UDT disk
buffers to disk. If there is a lot of data
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
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
All:
Awesome! I keep forgetting this. :-o
Thanks,
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: Wednesday, June 27, 2007 4:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Duplicate IDs in a list
Bill Haskett
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
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
Stuart,
Does changing the BlockSize help? I guess making it smaller *may* help?
Never used it myself...
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Wednesday, June 27, 2007 8:55 PM
To:
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.
Bill, See below. The first list contained 10 records. The second list
contains the first 10, and 10 others. The commands yield only the 10 unique
records that were not dup. If one list is larger, it has to be first in line
on the merge. Does that help you any?
GET-LIST DW1 TO 1
10 record(s)
We're also using UV TOXML + MS SQLXML to transfer data.
Stuart
What is the best way to get information to and from a SQLServer database
using Universe Basic?
**
This email message and any
On 28/06/2007, at 2:08 AM, Hennessey, Mark F. wrote:
snip
What is the best way to get information to and from a SQLServer database
using Universe Basic?
/snip
What do you plan on doing? Are you pushing small records to
SQLServer, retrieving small records or pushing/getting large tables?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
62 matches
Mail list logo