[U2] unsubscribe * [EMAIL PROTECTED]
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] unsubscribe *
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
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 ?
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
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 ?
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
> ...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 ?
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
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
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
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 ?
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 ?
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]
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
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]
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
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
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 ?
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
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 ?
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]
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
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
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]
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
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
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
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 ?
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 ?
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
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]
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 ?
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
"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
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]
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
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
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 ?
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
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
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
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
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 ?
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/
