[U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Herve Balestrieri
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

[U2] UniCommand NextBlock inter-time

2007-06-27 Thread Boydell, Stuart
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.

RE: [U2] Universe PE - Web Services

2007-06-27 Thread Mike Dallaire
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,

Re: [U2] Universe Phantom

2007-06-27 Thread john reid
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

[U2] The best way to access SQLServer from UV

2007-06-27 Thread Jerry Banker
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

Re: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread MAJ Programming
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

RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly

2007-06-27 Thread TPellitieri
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

Re: [U2] Universe Phantom

2007-06-27 Thread MAJ Programming
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

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Hennessey, Mark F.
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

[U2] RE: U2 Users Digest V1 #1707

2007-06-27 Thread David Ward
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]

RE: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Shin.Tanaka
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

Re: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Herve Balestrieri
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

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Jerry Banker
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.

Re: [U2] UD Backups

2007-06-27 Thread Doug Miller
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

RE: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Jerry Banker
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

RE: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Stevenson, Charles
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,

RE: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Jerry Banker
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

RE: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Ross Craig
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

[U2] unsubscribe

2007-06-27 Thread Betsy Cohn
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:

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Brian Leach
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

Re: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Cooper, Rudy
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

RE: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Brian Leach
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

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Anthony Youngman
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

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

2007-06-27 Thread Tom Dodds
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

[U2] Trigger help

2007-06-27 Thread Norman Morgan
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

Re: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Brian Leach
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

[U2] digest emails

2007-06-27 Thread Jan Darr
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 |

[U2] RE: U2 Users Digest V1 #1716

2007-06-27 Thread Leigh Millard
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:

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Jerry Banker
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

RE: [U2] Trigger help

2007-06-27 Thread Dave Davis
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

RE: [U2] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Jerry Banker
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

[U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Susan Joslyn
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

RE: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Tony Gravagno
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

RE: [U2] Trigger help

2007-06-27 Thread Cordes, Tom (contractor)
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

RE: {Blocked Content} RE: [U2] UD Backups

2007-06-27 Thread 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

RE: [U2] UD Backups

2007-06-27 Thread Bill Haskett
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

Re: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Susan Lynch
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

RE: [U2] UD Backups

2007-06-27 Thread Timothy Snyder
...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

RE: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread Tony Gravagno
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

[U2] Device Licensing

2007-06-27 Thread John Jenkins
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

RE: [U2] Basic developments reverse engineering tool ?

2007-06-27 Thread GarryS
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

RE: [U2] Device Licensing

2007-06-27 Thread phil walker
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

[U2] Duplicate IDs in a list

2007-06-27 Thread Bill Haskett
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

RE: [U2] UD Backups

2007-06-27 Thread colin.alfke
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

RE: [U2] UD Backups

2007-06-27 Thread Bill Haskett
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

RE: [U2] Duplicate IDs in a list

2007-06-27 Thread David A. Green
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]

RE: [U2] Duplicate IDs in a list

2007-06-27 Thread Larry Hiscock
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,

[U2][AD] Sending Ctrl-break to udt process via kill?

2007-06-27 Thread Randy Styka
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,

Re: [U2] Duplicate IDs in a list

2007-06-27 Thread Allen Egerton
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

Re: [U2] Duplicate IDs in a list

2007-06-27 Thread Wally Terhune
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:

RE: [U2] UD Backups

2007-06-27 Thread Stephen O'Neal
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

RE: [U2] Device Licensing

2007-06-27 Thread David Ward
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

RE: [U2] Device Licensing

2007-06-27 Thread phil walker
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

RE: [U2] Duplicate IDs in a list

2007-06-27 Thread Bill Haskett
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

RE: [U2] Device Licensing

2007-06-27 Thread David Ward
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

RE: [U2] Device Licensing

2007-06-27 Thread Bill Haskett
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

RE: [U2] UniCommand NextBlock inter-time

2007-06-27 Thread Hona, David S
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:

RE: [U2] Device Licensing

2007-06-27 Thread David Ward
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.

RE: [U2] Duplicate IDs in a list

2007-06-27 Thread David Ward
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)

RE: [U2] The best way to access SQLServer from UV

2007-06-27 Thread Boydell, Stuart
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

[U2] unsubscribe *

2007-06-27 Thread Greg York
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] unsubscribe * [EMAIL PROTECTED]

2007-06-27 Thread Greg York
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/