[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/


[U2] unsubscribe *

2007-06-27 Thread Greg York

On 28/06/2007, at 2:08 AM, Hennessey, Mark F. wrote:


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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


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) selected to SELECT list #1.
>GET-LIST DW2 TO 2
20 record(s) selected to SELECT list #2.
>MERGE.LIST 1 DIFF 2 TO 0
0 record(s) selected to SELECT list #0.
>GET-LIST DW2 TO 1
20 record(s) selected to SELECT list #1.
>GET-LIST DW1 TO 2
10 record(s) selected to SELECT list #2.
>MERGE.LIST 1 DIFF 2 TO 0
10 record(s) selected to SELECT list #0.
>>SAVE-LIST DW1
10 record(s) SAVEd to SELECT list "DW1".

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 7:45 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Duplicate IDs in a list


David:

Thanks.  But this doesn't remove duplicate IDs (nor does INTERSECTION).

7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC =
"ASSOCIATION DUES" ACCOUNT

282 records selected to list 0.

7 Brpm (0)>> SAVE.LIST BILL
282 key(s) saved to 1 record(s).
7 Brpm (0)-> get.list BILL TO 1
282 records retrieved to list 1.
7 Brpm (0)-> get.list BILL TO 2
282 records retrieved to list 2.
7 Brpm (0)-> merge.list 1 UNION 2
282 record(s) selected.
7 Brpm (0)>> CLEARSELECT
7 Brpm (0)-> DL BILL
'BILL' deleted.

It should reflect the following:

7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC =
"ASSOCIATION DUES" ACCOUNT

282 records selected to list 0.

7 Brpm (0)>> U2.NODUPLIST
253 items selected.
7 Brpm (0)>> SAVE.LIST BILL
Overwriting existing saved list.
253 key(s) saved to 1 record(s).
7 Brpm (0)-> DL BILL
'BILL' deleted.
7 Brpm (0)->

Thanks again, I was getting excited.  :-)

Bill 

>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of David A. Green
>Sent: Wednesday, June 27, 2007 4:38 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] Duplicate IDs in a list
>
>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]
>[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
>Sent: Wednesday, June 27, 2007 3:47 PM
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Duplicate IDs in a list
>
>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 DELINQ.LIST {U
>07 SL DELINQ.LIST
>08 P
>09 DISPLAY ...selection complete
>10 FTWIZ
> 
>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 guess my first problem is; does UniData have any ability to get a 
>list without selecting redundant IDs?  I tried:
> 
>GET.LIST DELINQ.LIST TO 1
>GET.LIST DELINQ.LIST TO 2
>MERGE.LIST 1 UNION 2 TO 3
>SAVE-LIST DELINQ.LIST
> 
>...and it didn't work too well.  I tried it in BASIC and that didn't 
>work too well either.  I had to write a custom BASIC program to
>use LOCATE to build an array then did a FORMLIST then a 
>SAVE.LIST.  This was
>pretty bogus and development staff have to get involved
>in this.
> 
>I'm in ECLTYPE "P" mode.  Can anyone help?  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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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".  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 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/


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: u2-users@listserver.u2ug.org
Subject: [U2] UniCommand NextBlock inter-time

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. Does anyone know if this is a tuneable parameter?
Regards,
Stuart Boydell
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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 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 http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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 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 http://listserver.u2ug.org/


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 wrote:
>
>> 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 guess my first problem is; does UniData have any ability 
>to get a list without selecting redundant IDs?  I tried:
>>  
>> GET.LIST DELINQ.LIST TO 1
>> GET.LIST DELINQ.LIST TO 2
>> MERGE.LIST 1 UNION 2 TO 3
>> SAVE-LIST DELINQ.LIST
>
>
>Not certain about Unidata; in the version of Universe I'm 
>running, this 
>works, (assuming that DELINQ.LIST is a list of IDS to DELINQ.FILE):
>
>PA
>GET.LIST DELINQ.LIST
>SELECT DELINQ.FILE SAVING UNIQUE @ID
>SAVE.LIST DELINQ.LIST
>
>HTH.
>
>-- 
>Allen Egerton
>aegerton at pobox dot com
>---
>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] 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 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/


RE: [U2] Duplicate IDs in a list

2007-06-27 Thread Bill Haskett
David:

Thanks.  But this doesn't remove duplicate IDs (nor does INTERSECTION).

7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC = "ASSOCIATION 
DUES" ACCOUNT

282 records selected to list 0.

7 Brpm (0)>> SAVE.LIST BILL
282 key(s) saved to 1 record(s).
7 Brpm (0)-> get.list BILL TO 1
282 records retrieved to list 1.
7 Brpm (0)-> get.list BILL TO 2
282 records retrieved to list 2.
7 Brpm (0)-> merge.list 1 UNION 2
282 record(s) selected.
7 Brpm (0)>> CLEARSELECT
7 Brpm (0)-> DL BILL
'BILL' deleted.

It should reflect the following:

7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC = "ASSOCIATION 
DUES" ACCOUNT

282 records selected to list 0.

7 Brpm (0)>> U2.NODUPLIST
253 items selected.
7 Brpm (0)>> SAVE.LIST BILL
Overwriting existing saved list.
253 key(s) saved to 1 record(s).
7 Brpm (0)-> DL BILL
'BILL' deleted.
7 Brpm (0)->

Thanks again, I was getting excited.  :-)

Bill 

>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of David A. Green
>Sent: Wednesday, June 27, 2007 4:38 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] Duplicate IDs in a list
>
>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]
>[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
>Sent: Wednesday, June 27, 2007 3:47 PM
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Duplicate IDs in a list
>
>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 DELINQ.LIST {U
>07 SL DELINQ.LIST
>08 P
>09 DISPLAY ...selection complete
>10 FTWIZ
> 
>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 guess my first problem is; does UniData have any ability to 
>get a list
>without selecting redundant IDs?  I tried:
> 
>GET.LIST DELINQ.LIST TO 1
>GET.LIST DELINQ.LIST TO 2
>MERGE.LIST 1 UNION 2 TO 3
>SAVE-LIST DELINQ.LIST
> 
>...and it didn't work too well.  I tried it in BASIC and that 
>didn't work
>too well either.  I had to write a custom BASIC program to
>use LOCATE to build an array then did a FORMLIST then a 
>SAVE.LIST.  This was
>pretty bogus and development staff have to get involved
>in this.
> 
>I'm in ECLTYPE "P" mode.  Can anyone help?  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/


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


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 waiting to be written, it can 
take a while.

Another cause, is when a single disk drive is hot.  Example: if a file, 
that has a lot of updates, is on a single disk drive.  Optimally, files 
with a lot of updates should be striped across multiple disk drives.
   Steve

   Stephen M. O'Neal
   U2 Lab Services Sales Specialist
   Information Management, IBM Software Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]





 "Bill Haskett"
 <[EMAIL PROTECTED]
 os.net>To
 Sent by:  
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   [U2] Duplicate IDs in a list
 06/27/2007 04:47
 PM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






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 DELINQ.LIST {U
07 SL DELINQ.LIST
08 P
09 DISPLAY ...selection complete
10 FTWIZ

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 guess my first problem is; does UniData have any ability to get a list
without selecting redundant IDs?  I tried:

GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST

...and it didn't work too well.  I tried it in BASIC and that didn't work
too well either.  I had to write a custom BASIC program to
use LOCATE to build an array then did a FORMLIST then a SAVE.LIST.  This
was pretty bogus and development staff have to get involved
in this.

I'm in ECLTYPE "P" mode.  Can anyone help?  Thanks.

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

[demime 1.01d removed an attachment of type image/gif which had a name of 
graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
pic12116.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
ecblank.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Duplicate IDs in a list

2007-06-27 Thread Allen Egerton

Bill Haskett wrote:


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 guess my first problem is; does UniData have any ability to get a list without selecting redundant IDs?  I tried:
 
GET.LIST DELINQ.LIST TO 1

GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST



Not certain about Unidata; in the version of Universe I'm running, this 
works, (assuming that DELINQ.LIST is a list of IDS to DELINQ.FILE):


PA
GET.LIST DELINQ.LIST
SELECT DELINQ.FILE SAVING UNIQUE @ID
SAVE.LIST DELINQ.LIST

HTH.

--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[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,
and to type on their behalf.  It's typically used for remote
support, training, audit trails, etc.  And you can use
programs/scripts to capture screens AND send keystrokes, which
is what we're talking about for you...

We had requests from users years ago for a way to pass through
commands like  or whatever your interrupt character is
set to.  We added this but it is not trivial; we enable the
interrupt for our process, trap and detect it, then propogate
the signal down to the child process, such as UV or UDT.

It is something that had to be specially programmed.  Whether
this helps you in any way is beyond me.  If it would (assuming
you're using Unix) then you can try the software out; PEEK is
available for a free trial at http://www.computronics.com

We don't do anything on Windows, so no ideas if that's where
you're coming from.  Good luck!  Randy


++
| Computronics   Randy Styka, [EMAIL PROTECTED] |
| 4N165 Wood Dale Road   Phone: 630/941-7767 |
| Addison, Illinois  60101 USA   Fax:   630/941-7714 |
++
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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, June 27, 2007 3:47 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Duplicate IDs in a list

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 DELINQ.LIST {U
07 SL DELINQ.LIST
08 P
09 DISPLAY ...selection complete
10 FTWIZ
 
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 guess my first problem is; does UniData have any ability to get a list
without selecting redundant IDs?  I tried:
 
GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST
 
...and it didn't work too well.  I tried it in BASIC and that didn't work
too well either.  I had to write a custom BASIC program to use LOCATE to
build an array then did a FORMLIST then a SAVE.LIST.  This was pretty bogus
and development staff have to get involved in this.
 
I'm in ECLTYPE "P" mode.  Can anyone help?  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/


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]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Wednesday, June 27, 2007 3:47 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Duplicate IDs in a list

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 DELINQ.LIST {U
07 SL DELINQ.LIST
08 P
09 DISPLAY ...selection complete
10 FTWIZ
 
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 guess my first problem is; does UniData have any ability to get a list
without selecting redundant IDs?  I tried:
 
GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST
 
...and it didn't work too well.  I tried it in BASIC and that didn't work
too well either.  I had to write a custom BASIC program to
use LOCATE to build an array then did a FORMLIST then a SAVE.LIST.  This was
pretty bogus and development staff have to get involved
in this.
 
I'm in ECLTYPE "P" mode.  Can anyone help?  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/


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


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 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] 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 DELINQ.LIST {U
07 SL DELINQ.LIST
08 P
09 DISPLAY ...selection complete
10 FTWIZ
 
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 guess my first problem is; does UniData have any ability to get a list 
without selecting redundant IDs?  I tried:
 
GET.LIST DELINQ.LIST TO 1
GET.LIST DELINQ.LIST TO 2
MERGE.LIST 1 UNION 2 TO 3
SAVE-LIST DELINQ.LIST
 
...and it didn't work too well.  I tried it in BASIC and that didn't work too 
well either.  I had to write a custom BASIC program to
use LOCATE to build an array then did a FORMLIST then a SAVE.LIST.  This was 
pretty bogus and development staff have to get involved
in this.
 
I'm in ECLTYPE "P" mode.  Can anyone help?  Thanks.
 
Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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 supported?
Is SSH supported?
Does the host os make a difference?
What version of the uvlicn.dll is required?
Anything else to look out for.

Cheers,

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins
Sent: Thursday, 28 June 2007 10:30 a.m.
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] 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
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

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Wednesday, June 27, 2007 11:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Basic developments "reverse engineering" tool ?

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 sure they
are marketing that anymore.

Seems to me this comes up a lot -- maybe one of us should write one, hmm?

Regards,
Susan Joslyn
SJ+ Systems Associates, Inc.
PRC(r) Real software configuration management for U2/Multivalue.

---

Date: Wed, 27 Jun 2007 10:40:07 -0500
From: "Jerry Banker" <[EMAIL PROTECTED]>
Subject: RE: [U2] Basic developments "reverse engineering" tool ?

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 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 back to
source
> code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.


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

--

End of U2 Users Digest V1 #1717
***


u2-users-digest 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] 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 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/


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 making this up as I go.
It seems to me that anyone could do this, even making it open source, so
I'll flesh it out just a little more.

Regarding paragraphs, etc, one of the things I was alluding to was that
separate items should be maintained which contain XML related to code which
cannot itself contain the metadata.  For example, Susan, it would be nice
to have Where Used data in your HR Partner DesignBais front-end, so that
you know which menus call to specific forms, which fields are used on which
forms, which forms run specific selection processes, which programs use
PROCESS.STACK to invoke other forms, etc.

In DesignBais or with other utilities that allow GUI queries it would be
helpful to know where various dict items are used.  It may not be practical
to put the XML in the dict item (extended dict items, paragraphs, etc) and
these environments don't have a special/common place for metadata, so a
custom file would need to be created that defines where dict items are
used, how they're used, etc.

As always, Garbage In, Garbage Out, and unless metadata is maintained the
reports one derives from the data are going to be inaccurate.  Manual
procedures must be implemented which require update of the data, or version
control software can prompt developers to ensure they have updated docs
before checking in changes.

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


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 having
> a "pristine" backup).

It's pretty common to use an extra mirrored copy or a flash copy to 
provide backups of a quiescent database without suspending processing.  It 
goes like this:

1) Pause updates with dbpause
2) Split off the copy, which will now be as of a point in time
3) Resume updates with dbresume
4) Back up from the quiescent, split copy, using the backup utility of 
your choice
5) Resync, snap back or do whatever is necessary to get the copy back up 
to date

The duration of the pause will depend on many factors, but it's usually 
pretty quick - generally measured in seconds rather than minutes.  And of 
course the exact commands to perform steps 2 and 5 will vary based on your 
operating system, disk storage facilities, high availability options, 
etc., etc.  If your application uses transaction processing semantics, the 
transactions will be consistent within the backup, thanks to the dbpause. 
And you won't have to worry about files being backed up while groups are 
being updated, since they're not being accessed by the production users, 
who are happily going about their business, regardless of how long the 
actual backup takes.


Tim Snyder
Consulting I/T Specialist
U2 Lab Services
Information Management, IBM Software Group
---
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-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 
attribute won't blow up dimensioned arrays or confuse the program logic that 
deals with the last attribute in the current dimension size, depending on 
your version/flavor of MV - also useful when you are asked to add another 
code for a field (eg Active/Terminated status field, suddenly users want to 
add Pending or Sabbatical statuses - where do you need to add logic to 
handle those new status values?)


List programs that write to each file (useful when trying to figure out "how 
did that attribute get that inappropriate data in there?")


List of programs that call a given program (including by a variable name) - 
useful when you change the list of variables passed to the program


Of course, now that we also have paragraphs that can write data, and tools 
like SB and a variety of others that can store procedural information and 
write commands in places other than Basic and Proc, it gets a bit trickier 
to write that sort of automated source code analyzer - gone are the days 
when you could pass the source code analyzer a list of Basic Program files, 
a list of Proc files, and let it generate this sort of technical 
documentation.


Susan Lynch
F.W. Davison & Company, Inc.
- Original Message - 
From: "Tony Gravagno" <[EMAIL PROTECTED]>

To: 
Sent: Wednesday, June 27, 2007 2:33 PM
Subject: RE: [U2] Basic developments "reverse engineering" tool ?



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

Java and .NET use structured comments with XML for doing this and I've 
seen

a few MV packages do the same with BASIC.  I'll make up some sample XML
below but this is how I might do it.

[Snipped to reduce size ]

Tony Gravagno

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


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 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 image 
>file.  This is because if you know anything about hashed files and 
>how they compress, it is not uncommon to be able to compress most 
>hashed files to be only 20% of the original space it took on 
>disk.  That being said, your backup software is still going to need 
>to scan all that data regardless if there are records there or 
>not.  So if your original data set is much larger on the U2 side, 
>this would probably (in theory) explain the difference.
>
>I would also download a benchmark utility to test your disks to rule 
>that out as being a problem as well.
>
>
>
>Doug Miller   [EMAIL PROTECTED]
>Manager of Technical Services
>Strategy 7Dallas TX 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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

>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of 
>[EMAIL PROTECTED]
>Sent: Tuesday, June 26, 2007 4:16 PM
>To: u2-users@listserver.u2ug.org
>Subject: {Blocked Content} RE: [U2] UD Backups
>
>Bill;
>
>How long does the backup take on the server if you shutdown UD 
>first? Just trying to rule out a problem with NTBackup before
>getting carried away.
>
>Do you have transaction processing? DBPause waits for any 
>writes to complete before it actually stops anything. It
>may wait for the entire transaction.  Along that line -
>would there be anything else that may be holding up DBPause?
>
>To answer your question - we've mostly used Backup Exec
>(there were some issues with older versions of UD). We don't
>have anything critical running overnight so we usually leave
>UD running and set the "backup open files" and "backup
>without a lock" options set. Not sure if it's any faster (I
>think NTBackup is a pared down version of Backup Exec).
>
>We've also had clients use Arcserve successfully, and we even 
>have one client that backs up to a server on the NET (don't
>remember what that product is called).
>
>hth
>Colin Alfke
>Calgary Canada
>sorry list - I haven't been able to turn off rich-text e-mails 
>with this
>version of Outlook Web Access :-(
>
>
>
>From:  Bill Haskett
>
>Bill:
>
>I have the entire backup process scripted and the main script 
>is called from a
>configured Windows scheduled task.  Nothing about the
>backup process is done from within UD.  We have a VB script 
>included, called
>by this main backup script, that deletes old backup
>files older than the number of days passed in via the command line.
>
>Bill
>This is a message from the MailScanner E-Mail Virus Protection Service
>--
>The original e-mail attachment "winmail.dat"
>was believed to be infected by a virus and has been replaced 
>by this warning
>message.
>
>If you wish to receive a copy of the *infected* attachment, please
>e-mail helpdesk and include the whole of this message
>in your request. Alternatively, you can call them, with
>the contents of this message to hand when you call.
>
>At Tue Jun 26 16:19:00 2007 the virus scanner said:
>   Could not parse Outlook Rich Text attachment
>
>Note to Help Desk: Look on the AngelicHost MailScanner in
>/home/virtual/site2/fst/var/spool/mail.quarantine/20070626 (message
>l5QNIvYF027208).
>--
>Postmaster
>MailScanner thanks transtec Computers for their support
>---
>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] 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 PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, June 27, 2007 1:34 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Trigger help

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 parameters.  

I've never used an SB+ subroutine inside of a trigger.  Not sure if that
would work.  The problem with doing that is, what happens if a non-SB+
application is performing the file updates? 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan
Sent: Wednesday, June 27, 2007 12:09 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Trigger help

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 looks like an update trigger would be the best way, but how do
I:

A) compare the before and after images of the record to catch changes in
those fields
B) determine what program is doing the felonious update and what user is
running it.

I can do all of these easily in an SB+ subroutine, but it looks like I need
to do it in barefoot UniBasic.

Can someone give me some pointers?

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
A Basic programmer's girlfriend wears a G$
===
---
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/


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

Java and .NET use structured comments with XML for doing this and I've seen
a few MV packages do the same with BASIC.  I'll make up some sample XML
below but this is how I might do it.

* 
*  Joe Coder
*  
*   This proggie processes orders
*   
* Longer desc here.
*   
*  
*  
*   
* Fixed this to do that.
*   
*  
*  
*   ORDERS
*   PRICING
*  
* 
...
* 
*   Get the current price using special tables.
* 
CALC.PRICE: *
...

CALL SOMEPROG("blah")

Similar metadata can be created for I-Types or wherever BASIC code is used
or referenced.  Once these tags are embedded in BASIC you can have a
program scan your program files and other source records and build XML
documents.  These can then be imported into templates or maybe reformatted
into HTML with XSLT.  You can also use the data to create Where Used type
reports.

Tony Gravagno
Nebula R&D
TG@ always.remove.thisNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[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 sure they
are marketing that anymore.

Seems to me this comes up a lot -- maybe one of us should write one, hmm?

Regards,
Susan Joslyn
SJ+ Systems Associates, Inc.
PRC(r) Real software configuration management for U2/Multivalue.

---

Date: Wed, 27 Jun 2007 10:40:07 -0500
From: "Jerry Banker" <[EMAIL PROTECTED]>
Subject: RE: [U2] Basic developments "reverse engineering" tool ?

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 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 back to
source
> code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.


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

--

End of U2 Users Digest V1 #1717
***


u2-users-digest 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] 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 it down and encrypt all of it.

-Original Message-
From: Anthony Youngman [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]

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 [mailto:[EMAIL PROTECTED] 
Sent: 27 June 2007 16:20
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]

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. Or, get/put, whatever the term being used. It has to be real
time and as fast as possible, up to 5,000 cards a minute, as we do now.

-Original Message-
From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 9:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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


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 parameters.  

I've never used an SB+ subroutine inside of a trigger.  Not sure if that
would work.  The problem with doing that is, what happens if a non-SB+
application is performing the file updates? 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan
Sent: Wednesday, June 27, 2007 12:09 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Trigger help

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 looks like an update trigger would be the best way, but how do
I:

A) compare the before and after images of the record to catch changes in
those fields
B) determine what program is doing the felonious update and what user is
running it.

I can do all of these easily in an SB+ subroutine, but it looks like I
need to do it in barefoot UniBasic.

Can someone give me some pointers?

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
A Basic programmer's girlfriend wears a G$
===
---
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] 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 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 be in one table and we will
want to read the data, record by record, or write it, record by record,
using UV. Or, get/put, whatever the term being used. It has to be real
time and as fast as possible, up to 5,000 cards a minute, as we do now.

-Original Message-
From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 9:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/
---
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] 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: [U2] The best way to access SQLServer from UV

--

Date: Wed, 27 Jun 2007 17:31:51 +0200
From: Brian Leach <[EMAIL PROTECTED]>
Subject: RE: [U2] The best way to access SQLServer from UV

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 effective.

Brian


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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



Jerry


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

--

End of U2 Users Digest V1 #1716
***


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

*Email confidentiality notice*
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. However, any views or opinions presented are solely those of the 
author and do not necessarily represent those of BTB Mailflight Ltd.

If you are not the stated recipient, you must not deal with it in any way and 
are prohibited from using, printing, copying, distributing or disseminating 
this e-mail or any information contained in it. In such case please notify us 
by telephone and confirm that it has been deleted from your system and any 
copies destroyed.

*Disclaimer*
This e-mail has been swept for the presence of computer viruses, but no 
warranty is given that this e-mail and any attachments are virus free. You 
should undertake your own virus checking. 
The right to monitor e-mail communications through our networks is reserved by 
us.

BTB Mailflight Ltd is a limited company registered in England and Wales. 
Registered number: 1028718. Registered office: Wolseley Road, Woburn Road 
Industrial Estate, Kempston, Bedfordshire, MK42 7UA
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[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 | [EMAIL PROTECTED]
---
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-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 an object code decompiler.

Thanks

Herve' Balestrieri

> 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]>
>
> > 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.
---
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] 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 looks like an update trigger would be the best way, but how do
I:

A) compare the before and after images of the record to catch changes in
those fields
B) determine what program is doing the felonious update and what user is
running it.

I can do all of these easily in an SB+ subroutine, but it looks like I
need to do it in barefoot UniBasic.

Can someone give me some pointers?

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
A Basic programmer's girlfriend wears a G$
===
---
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-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 of
documentation.
We are working on a second module that will allow for the entry of textual
descriptions for each component and then generate various types of
documentation. IE. html, pdf, csv, rtf, etc

Contact me off line if this sounds interesting.

Tom Dodds 
[EMAIL PROTECTED]
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Herve Balestrieri
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 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 back to source
> code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.
---
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] 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 [mailto:[EMAIL PROTECTED] 
Sent: 27 June 2007 16:20
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]

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. Or, get/put, whatever the term being used. It has to be real
time and as fast as possible, up to 5,000 cards a minute, as we do now.

-Original Message-
From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 9:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/
---
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] 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 effective.

Brian


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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



Jerry
---
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] 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 it.  Plus there are a number of list members who are familiar with
the technology who can offer much assistance.



Rudy



Date: Wed, 27 Jun 2007 08:09:44 -0500

From: "Jerry Banker" <[EMAIL PROTECTED]>

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



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 database

using Universe Basic?



I would prefer to hear about built in features and not outside sources.
Not

that I don't appreciate that you guys have some wonderful products but
we

have a fully qualified staff of programmers here and other than the

operating systems we have pretty much developed everything we have
in-house.



We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12

Reality flavor. The SQLServer will be on a Windows 2003 Server and most

likely the latest version of SQLServer. We are not opposed to upgrading
the

Linux or uniVerse if that would give us more to work with.







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


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 be in one table and we will
want to read the data, record by record, or write it, record by record,
using UV. Or, get/put, whatever the term being used. It has to be real
time and as fast as possible, up to 5,000 cards a minute, as we do now.

-Original Message-
From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 9:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/
---
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] 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] UD Backups

--

Date: Wed, 27 Jun 2007 10:26:02 -0500
From: Doug Miller <[EMAIL PROTECTED]>
Subject: Re: [U2] UD Backups

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 image
file.  This is because if you know anything about hashed files and
how they compress, it is not uncommon to be able to compress most
hashed files to be only 20% of the original space it took on
disk.  That being said, your backup software is still going to need
to scan all that data regardless if there are records there or
not.  So if your original data set is much larger on the U2 side,
this would probably (in theory) explain the difference.

I would also download a benchmark utility to test your disks to rule
that out as being a problem as well.



Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX

--

End of U2 Users Digest V1 #1715
***


u2-users-digest 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] 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 SQLServer from UV

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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



Jerry
---
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] 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 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 Web Services through the
SQL Server 2005 Database Engine by using the following open standards:

HTTP, SOAP, WSDL, blah, blah, blah..."


So maybe you can use Universe's callHTTP.  

Good Luck!

 -Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, June 27, 2007 9:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] The best way to access SQLServer from UV

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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



Jerry
---
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/


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, 2007 8:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Basic developments "reverse engineering" tool ?

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 back to 
> source code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.
---
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] 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 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 back to
source
> code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.
---
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-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 image 
file.  This is because if you know anything about hashed files and 
how they compress, it is not uncommon to be able to compress most 
hashed files to be only 20% of the original space it took on 
disk.  That being said, your backup software is still going to need 
to scan all that data regardless if there are records there or 
not.  So if your original data set is much larger on the U2 side, 
this would probably (in theory) explain the difference.


I would also download a benchmark utility to test your disks to rule 
that out as being a problem as well.




Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX 
---

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


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. Or, get/put, whatever the term being used. It has to be real
time and as fast as possible, up to 5,000 cards a minute, as we do now.

-Original Message-
From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 9:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] The best way to access SQLServer from UV [not-secure]


What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/
---
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-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 back to source
> code.
> My 1 cent
> Mark Johnson
> - Original Message -
> From: "Herve Balestrieri" <[EMAIL PROTECTED]>
>
> > 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.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


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 Web Services through the
SQL Server 2005 Database Engine by using the following open standards:

HTTP, SOAP, WSDL, blah, blah, blah..."


So maybe you can use Universe's callHTTP.  

Good Luck!

 -Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Wednesday, June 27, 2007 9:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] The best way to access SQLServer from UV

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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



Jerry
---
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] 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] 
Sent: Wednesday, June 27, 2007 8:22 AM
To: [EMAIL PROTECTED]
Subject: U2 Users Digest V1 #1707



U2 Users Digest   Wednesday, June 27 2007   Volume 01 : Number 1707



In this issue:

[U2] The best way to access SQLServer from UV

--

Date: Wed, 27 Jun 2007 08:09:44 -0500
From: "Jerry Banker" <[EMAIL PROTECTED]>
Subject: [U2] The best way to access SQLServer from UV

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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources. Not
that I don't appreciate that you guys have some wonderful products but we
have a fully qualified staff of programmers here and other than the
operating systems we have pretty much developed everything we have in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12
Reality flavor. The SQLServer will be on a Windows 2003 Server and most
likely the latest version of SQLServer. We are not opposed to upgrading the
Linux or uniVerse if that would give us more to work with.



Jerry

--

End of U2 Users Digest V1 #1707
***


u2-users-digest 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] The best way to access SQLServer from UV [not-secure]

2007-06-27 Thread Hennessey, Mark F.

What is the best way to get information to and from a SQLServer database
using Universe Basic?


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/


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: 
Sent: Wednesday, June 27, 2007 8:31 AM
Subject: Re: [U2] Universe & Phantom


> 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 processes when it is their time.
> >
> > Thanks,
> > David A. Green
> > DAG Consulting
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of David Ward
> > Sent: Tuesday, June 26, 2007 12:20 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] Universe & Phantom
> >
> > These are all good suggestions, but the issue is I cannot tell if the
job
> > failed due to an out of licenses condition. In the old days it was easy,
if
> > the process was not attached to a terminal device, it was construed as a
> > phantom and didn't consume a license. (or at least that's the way I
remember
> > it).
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard
> > Sent: Tuesday, June 26, 2007 1:57 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] Universe & Phantom
> >
> >
> > < Is it possible to issue a phantom from OS? >
> >
> > I have several jobs that are run through the Windows scheduler.  Simply
set
> > up a batch file, and schedule the job to execute the batch file.
> >
> > Sample batch file:
> > echo start UniVerse End Of Day job
> > cd IBM\uv
> > bin\uvsh.exe "RUN UVSOURCE END.OF.DAY"
> > echo finished with End Of Day
> >
> > Dick Kryka
> > Director of Applications
> > Paragon Financial Services
> > a Division of Money Management International
> > 303-632-2226
> > [EMAIL PROTECTED]
> > ---
> > 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/
> >
>
>
> --
> john
> ---
> 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-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 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/


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: 
Sent: Wednesday, June 27, 2007 6:37 AM
Subject: [U2] Basic developments "reverse engineering" tool ?


> 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 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] 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 database
using Universe Basic?

I would prefer to hear about built in features and not outside sources.
Not that I don't appreciate that you guys have some wonderful products
but we have a fully qualified staff of programmers here and other than
the operating systems we have pretty much developed everything we have
in-house.

We are running Red Hat Enterprise Linux AS release 3 with uniVerse
10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server
and most likely the latest version of SQLServer. We are not opposed to
upgrading the Linux or uniVerse if that would give us more to work with.



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


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 processes when it is their time.

Thanks,
David A. Green
DAG Consulting


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Ward
Sent: Tuesday, June 26, 2007 12:20 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe & Phantom

These are all good suggestions, but the issue is I cannot tell if the job
failed due to an out of licenses condition. In the old days it was easy, if
the process was not attached to a terminal device, it was construed as a
phantom and didn't consume a license. (or at least that's the way I remember
it).

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard
Sent: Tuesday, June 26, 2007 1:57 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe & Phantom


< Is it possible to issue a phantom from OS? >

I have several jobs that are run through the Windows scheduler.  Simply set
up a batch file, and schedule the job to execute the batch file.

Sample batch file:
echo start UniVerse End Of Day job
cd IBM\uv
bin\uvsh.exe "RUN UVSOURCE END.OF.DAY"
echo finished with End Of Day

Dick Kryka
Director of Applications
Paragon Financial Services
a Division of Money Management International
303-632-2226
[EMAIL PROTECTED]
---
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/




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


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," that
was very helpful.
Mike

Mike Dallaire
Mortgage Builder Software Inc.
(248) 304-0600 ext. 103
[EMAIL PROTECTED]
www.mortgagebuilder.com



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Tuesday, June 26, 2007 10:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe PE - Web Services

Can IBM web services handle getting passed an xml document, such as a sales
order? The example provided in the 'hard to find' knowledgebase using two
number to be multiplied is very simplistic...and I was wondering how you
would use then to process incoming sales orders.

Cheers,

Phil.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, 22 June 2007 7:46 p.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe PE - Web Services

Sara

The web services require a pooled connection licence.
Which is, unfortunately, not available with PE.

Grrr

Though I have to say, when I finally got to play with the IBM web services
I've found them disappointing, particularly in the lack of data types. Maybe
someone who can afford them now can tell me if they've extended that.

I rolled my own a couple of years back ("mvSOAP"), then mothballed them when
I heard IBM were bringing their own out. But I'm considering blowing the
dust off them again - support for doc and RPC modes, standard data types,
control over multivalues, reusable templates and basic validation were all
in there, and fast.

Brian



While we are waiting for an official version of UniVerse 10.2.4 we have
been trying to get Web Services working in the downloadable PE version.

We have created a Web Service but when we try to run it we are advised
in the log that the license has expired.

Is this not able to be used in the PE version or is there some way of
extending the license?

Any assistance would be appreciated.

Regards,
Sara Burns



Sara Burns (SEB)


IS Development Manager

Public Trust
Phone: +64 (04) 978 4534 (DDI)

Mobile: 029 978 4534
 >




A family trust can help you protect your assets if the unexpected happens.
To
find out how a family trust works and if one's right for you, call 0800 505
405.

The information contained in this communication (including any attachment)
is
confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the information
contained in this communication. Any views expressed in this communication
are
not necessarily the views of Public Trust. No representation is made that
this
communication is free of error, virus or interference.
---
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 http://listserver.u2ug.org/


[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. Does anyone know if this is a tuneable parameter?
Regards,
Stuart Boydell



**
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/


[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 unsubscribe please visit http://listserver.u2ug.org/