Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Kevin King
It's my understanding that George hit the issue squarely on the head with
this comment:

Instead if you connection pool using Rocket's or your own technology then
you need to buy connection pooling licenses.

Rocket doesn't want people creating their own connection pooling logic that
would allow a single license to service what might otherwise be an
unreasonable number of clients.  They are, after all, in the business of
selling seats.  That being said, the issue is one of concurrency.  With
telnet, people are squatting on ports all day.  With a web-based
application a connection might last a fraction of a second and be done.
 This allows the web-based application to utilize each single license more
effectively as one license could realistically service thousands of
different clients over the course of a day.  The down side to this
connect-do-disconnect model, of course, is the overhead of establishing
each connection.  With connection pooling they offer an alternative to
making a new connection each time, and have established the rules and price
for whatever they think makes sense.

-K

On Mon, Jun 4, 2012 at 2:33 AM, George Land
george.l...@aptsolutions.co.ukwrote:

 I think that there is quite a bit of confusion on different terms.

 Firstly there is no problem in developing and hosting web based
 applications
 using U2, many of the successful U2 applications today are web based.  But
 since U2 is licensed per user what you can't do is simply have a small
 license that connection pools - in other words runs a few processes that
 listen for work from a large user base and services them.

 Instead if you connection pool using Rocket's or your own technology then
 you need to buy connection pooling licenses.  Whilst this pricing model is
 different to Oracle and Microsoft it is also often less expensive, it all
 depends on the configuration of the system being implemented.

 But that's different from SaaS, connection pooling is about a technical
 architecture whilst SaaS is really a pricing model.  You can adopt a SaaS
 pricing model on an in house application just as you can adopt a
 conventional user licensing model on an application that is hosted/in the
 cloud.

 If you are implementing a true SaaS pricing model, so the customers pay per
 transaction or per some other metric, and you want to pay for your U2
 licenses on the same metric then you need to talk to Rocket or your
 distributor if you are outside the US.  It is almost impossible to have an
 'off the shelf' pricing model for this environment because the metrics you
 use and the software you need to back it up will vary, particularly if the
 demand is going to be seasonal.  But talk about it with whoever you buy
 from.

 George Land
 APT Solutions Ltd
 U2 UK Distributor



 On 03/06/2012 07:22, Robert Houben robert.hou...@fwic.net wrote:

  I should clarify my question.  What is the legality behind licensing a
 SaaS
  (or BPaaS) offering with a U2 system behind it?
 
  I believe at one point there were terms of use in the user license that
 made a
  SaaS implementation potentially impractical.
 
  BTW, believe it or not, providing Microsoft products in a SaaS
 environment is
  a violation of their license agreement, unless you get a special variant
 of
  their licenses (these raise the price significantly).  This is little
 known,
  and to date Microsoft has not been aggressive in enforcing it, but that
  apparently might be about to change.
 
  U2, to my knowledge requires a special type of network license if you are
  going to provide pooled connections of any sort (e.g. through a web
 server.)
  The special terms to look up seem to be Connection Pooling and
 Concurrent
  User.  My initial read of the section describing these is that if I have
  potentially 2 million different users who may use my service through
 web-based
  connection pooling through the term of the license, (even if not
  concurrently), I must have licenses enough (2 million of them) to support
  this.  I copy the block of text at the bottom of this message from a
 copy of
  the license agreement that I have (possibly out of date - that's part of
 the
  question).  Their definition of Concurrent seems a bit odd...
 
  (BTW, I agree: I would *never* use an unprotected telnet session over the
  internet.  I would be inclined to have the U2 server hiding behind a good
  solid commercial grade web server.)
 
  Connection Pooling (CP): Licensee is not authorized to enable or engage
 in
  Connection Pooling unless Licensee is able to count and acquire required
  Concurrent Session or Concurrent User entitlements covering all unique
  individuals or single, unique instances of a software application that
 might
  process transactions using the Program. CP session entitlements [ which
 would
  cover use by any and all unique individuals or unique single instances of
  software programs over a single logical open, persistent connection ] are
  optionally available for purchase for 

Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread David Wolverton
They do have an ASP license -- it's an annual license fee instead of the
'permanent' fee.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Saturday, June 02, 2012 6:04 PM
To: U2 Users List
Subject: Re: [U2] Universe/Unidata in the Cloud

Just so I'm clear... what exactly would be different about such a license?
 Seems to me the typical licensing terms would work just fine, as long as
you have enough seats to handle the traffic.  I would, however, be concerned
about opening up the telnet port on a cloud architecture.

On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.netwrote:

 Does Rocket license Universe or Unidata for use in the cloud?

 Robert Houben
 IBM Certified Solution Advisor and Architect - Cloud Computing 
 Architecture Chief Technology Officer FusionWare Integration Corp.
 p: 604-777-4254 x158
 f: 604-608-5544
 http://www.fwic.nethttp://www.fwic.net/
 LinkedIn 
 http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_ba
 dge  Twitter http://www.twitter.com/fusionwareint  FaceBook
 http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integra
 tion-Corp/115116258510923
 

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread George Land
Actually ASP is being 'retired', there is now a fixed term license which
means that you don't have the same up front fee but pay more as an annual
fee.  And if true SaaS is what you need, paying based on the number of
transactions processed or whatever, then you need to talk about it.  I'm not
saying that it will be agreed to, but if it's a sensible proposal that
brings in decent revenue there is every chance it may be agreed.

George Land
APT Solutions Ltd
U2 UK Distributor


On 04/06/2012 14:41, David Wolverton dwolv...@flash.net wrote:

 They do have an ASP license -- it's an annual license fee instead of the
 'permanent' fee.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
 Sent: Saturday, June 02, 2012 6:04 PM
 To: U2 Users List
 Subject: Re: [U2] Universe/Unidata in the Cloud
 
 Just so I'm clear... what exactly would be different about such a license?
  Seems to me the typical licensing terms would work just fine, as long as
 you have enough seats to handle the traffic.  I would, however, be concerned
 about opening up the telnet port on a cloud architecture.
 
 On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.netwrote:
 
 Does Rocket license Universe or Unidata for use in the cloud?
 
 Robert Houben
 IBM Certified Solution Advisor and Architect - Cloud Computing
 Architecture Chief Technology Officer FusionWare Integration Corp.
 p: 604-777-4254 x158
 f: 604-608-5544
 http://www.fwic.nethttp://www.fwic.net/
 LinkedIn 
 http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_ba
 dge  Twitter http://www.twitter.com/fusionwareint  FaceBook
 http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integra
 tion-Corp/115116258510923
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Robert Houben
As usual this group is a wealth of information.  I think the talk to Rocket 
is the most useful thing.  Our OLE DB driver uses Microsofts OLE DB Resource 
Pooling (built into Windows) to pool.  Our other products provide built-in 
pooling. We've always told our U2 customers that they need to get connection 
pooling licenses.  The wording of the license agreements suggests that whoever 
wrote it did not understand how most applications use connection pooling.  I 
was curious if this had been cleared up.  Unfortunately, if anything goes 
wrong, unless you have something written to refer to, the actual wording of the 
license will be used by the courts.

Thank you,

Robert Houben
IBM Certified Solution Advisor and Architect - Cloud Computing Architecture
Chief Technology Officer
FusionWare Integration Corp.
p: 604-777-4254 x158
f: 604-608-5544
http://www.fwic.net
LinkedIn  Twitter  FaceBook



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land
Sent: June-04-12 1:33 AM
To: U2 Users List
Subject: Re: [U2] Universe/Unidata in the Cloud

I think that there is quite a bit of confusion on different terms.

Firstly there is no problem in developing and hosting web based applications 
using U2, many of the successful U2 applications today are web based.  But 
since U2 is licensed per user what you can't do is simply have a small license 
that connection pools - in other words runs a few processes that listen for 
work from a large user base and services them.

Instead if you connection pool using Rocket's or your own technology then you 
need to buy connection pooling licenses.  Whilst this pricing model is 
different to Oracle and Microsoft it is also often less expensive, it all 
depends on the configuration of the system being implemented.

But that's different from SaaS, connection pooling is about a technical 
architecture whilst SaaS is really a pricing model.  You can adopt a SaaS 
pricing model on an in house application just as you can adopt a conventional 
user licensing model on an application that is hosted/in the cloud.

If you are implementing a true SaaS pricing model, so the customers pay per 
transaction or per some other metric, and you want to pay for your U2 licenses 
on the same metric then you need to talk to Rocket or your distributor if you 
are outside the US.  It is almost impossible to have an 'off the shelf' pricing 
model for this environment because the metrics you use and the software you 
need to back it up will vary, particularly if the demand is going to be 
seasonal.  But talk about it with whoever you buy from.

George Land
APT Solutions Ltd
U2 UK Distributor



On 03/06/2012 07:22, Robert Houben robert.hou...@fwic.net wrote:

 I should clarify my question.  What is the legality behind licensing a
 SaaS (or BPaaS) offering with a U2 system behind it?

 I believe at one point there were terms of use in the user license
 that made a SaaS implementation potentially impractical.

 BTW, believe it or not, providing Microsoft products in a SaaS
 environment is a violation of their license agreement, unless you get
 a special variant of their licenses (these raise the price
 significantly).  This is little known, and to date Microsoft has not
 been aggressive in enforcing it, but that apparently might be about to change.

 U2, to my knowledge requires a special type of network license if you
 are going to provide pooled connections of any sort (e.g. through a
 web server.) The special terms to look up seem to be Connection
 Pooling and Concurrent User.  My initial read of the section
 describing these is that if I have potentially 2 million different
 users who may use my service through web-based connection pooling
 through the term of the license, (even if not concurrently), I must
 have licenses enough (2 million of them) to support this.  I copy the
 block of text at the bottom of this message from a copy of the license
 agreement that I have (possibly out of date - that's part of the question).  
 Their definition of Concurrent seems a bit odd...

 (BTW, I agree: I would *never* use an unprotected telnet session over
 the internet.  I would be inclined to have the U2 server hiding behind
 a good solid commercial grade web server.)

 Connection Pooling (CP): Licensee is not authorized to enable or
 engage in Connection Pooling unless Licensee is able to count and
 acquire required Concurrent Session or Concurrent User entitlements
 covering all unique individuals or single, unique instances of a
 software application that might process transactions using the
 Program. CP session entitlements [ which would cover use by any and
 all unique individuals or unique single instances of software programs
 over a single logical open, persistent connection ] are optionally
 available for purchase for use with the Workgroup Edition, but are
 limited to a maximum of two (2) CP sessions. Enterprise Edition 

Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Wjhonson

 

Surely Robert you know that courts understand that wording can be ambiguous.
If you really think some court is going to tell you you need 2 million 
licenses I think you're trying to make a case out of tissue


 

 

 

-Original Message-
From: Robert Houben robert.hou...@fwic.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 7:35 am
Subject: Re: [U2] Universe/Unidata in the Cloud


As usual this group is a wealth of information.  I think the talk to Rocket 
is 
the most useful thing.  Our OLE DB driver uses Microsofts OLE DB Resource 
Pooling (built into Windows) to pool.  Our other products provide built-in 
pooling. We've always told our U2 customers that they need to get connection 
pooling licenses.  The wording of the license agreements suggests that whoever 
wrote it did not understand how most applications use connection pooling.  I 
was 
curious if this had been cleared up.  Unfortunately, if anything goes wrong, 
unless you have something written to refer to, the actual wording of the 
license 
will be used by the courts.

Thank you,

Robert Houben
IBM Certified Solution Advisor and Architect - Cloud Computing Architecture
Chief Technology Officer
FusionWare Integration Corp.
p: 604-777-4254 x158
f: 604-608-5544
http://www.fwic.net
LinkedIn  Twitter  FaceBook



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of George Land
Sent: June-04-12 1:33 AM
To: U2 Users List
Subject: Re: [U2] Universe/Unidata in the Cloud

I think that there is quite a bit of confusion on different terms.

Firstly there is no problem in developing and hosting web based applications 
using U2, many of the successful U2 applications today are web based.  But 
since 
U2 is licensed per user what you can't do is simply have a small license that 
connection pools - in other words runs a few processes that listen for work 
from 
a large user base and services them.

Instead if you connection pool using Rocket's or your own technology then you 
need to buy connection pooling licenses.  Whilst this pricing model is 
different 
to Oracle and Microsoft it is also often less expensive, it all depends on the 
configuration of the system being implemented.

But that's different from SaaS, connection pooling is about a technical 
architecture whilst SaaS is really a pricing model.  You can adopt a SaaS 
pricing model on an in house application just as you can adopt a conventional 
user licensing model on an application that is hosted/in the cloud.

If you are implementing a true SaaS pricing model, so the customers pay per 
transaction or per some other metric, and you want to pay for your U2 licenses 
on the same metric then you need to talk to Rocket or your distributor if you 
are outside the US.  It is almost impossible to have an 'off the shelf' pricing 
model for this environment because the metrics you use and the software you 
need 
to back it up will vary, particularly if the demand is going to be seasonal.  
But talk about it with whoever you buy from.

George Land
APT Solutions Ltd
U2 UK Distributor



On 03/06/2012 07:22, Robert Houben robert.hou...@fwic.net wrote:

 I should clarify my question.  What is the legality behind licensing a
 SaaS (or BPaaS) offering with a U2 system behind it?

 I believe at one point there were terms of use in the user license
 that made a SaaS implementation potentially impractical.

 BTW, believe it or not, providing Microsoft products in a SaaS
 environment is a violation of their license agreement, unless you get
 a special variant of their licenses (these raise the price
 significantly).  This is little known, and to date Microsoft has not
 been aggressive in enforcing it, but that apparently might be about to change.

 U2, to my knowledge requires a special type of network license if you
 are going to provide pooled connections of any sort (e.g. through a
 web server.) The special terms to look up seem to be Connection
 Pooling and Concurrent User.  My initial read of the section
 describing these is that if I have potentially 2 million different
 users who may use my service through web-based connection pooling
 through the term of the license, (even if not concurrently), I must
 have licenses enough (2 million of them) to support this.  I copy the
 block of text at the bottom of this message from a copy of the license
 agreement that I have (possibly out of date - that's part of the question).  
Their definition of Concurrent seems a bit odd...

 (BTW, I agree: I would *never* use an unprotected telnet session over
 the internet.  I would be inclined to have the U2 server hiding behind
 a good solid commercial grade web server.)

 Connection Pooling (CP): Licensee is not authorized to enable or
 engage in Connection Pooling unless Licensee is able to count and
 acquire required Concurrent Session or Concurrent User entitlements
 covering all unique individuals or 

[U2] [UV] Using Global sign certificates in UV

2012-06-04 Thread Jacques G.



Hello,

The URL of a webservice I need to use has a port number in it ei:

Acceptance = 
https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/;

The libraries U2 libraries I'm using are somehow interpreting: 
Leonardo.Rafael.be:9101 as the complete hostname (which it doesn't find in the 
host file. 

05/29/2012 16:07:02 [ 26930 26925 ] new host 221010:Leonardo.Rafael.be:9101 
allocated (proxy:no)
05/29/2012 16:07:02 [ 26930 26925 ] host Leonardo.Rafael.be:9101 not found in 
hostList
05/29/2012 16:07:09 [ 26930 26925 ] Unknown socket error : 1000

The code below is from the pick wiki article.   Any ideas on now to get 
CreateSecureRequest() to interpret the host + port correctly ?

Thanks.


*** ### Code ***
*For getting onto webservices we use this sort of code:


  * Read an xml request to send to the webservice *
  OPEN , WORK.OUT TO WORK.OUT ELSE STOP 201, WORK.OUT
  READ XML.REQUEST FROM WORK.OUT, TURTLE.XML ELSE STOP
  XML.REQUEST = CONVERT(@AM,,XML.REQUEST) 

  PROMPT ''  ;* 212.65.63.70 
  Acceptance = 
https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/;
**  Acceptance = 
https://212.65.63.70:9101/CustomerOrder/OrderManagementService/01/;
  Production = 
https://Leonardo.Rafael.be/CustomerOrder/OrderManagementService/01/;


  X.LOG.FILE   = /trace_pc/work.out/CERT.LOG
  X.LOG.ACTION = 'ON'
  X.LOG.LEVEL = '10'
  WRITE  ON WORK.OUT, CERT.LOG ;* Overwrite existing log file

  X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL)

  
  URL = Acceptance ;* Setting URL to the acceptance site

  L.ERR = 
  sec_context=''
  L.ERR =createSecurityContext(sec_context,'')
  usedAs=2 ;* 2 = Issuer Certificate CA
  format = 2 ; algorithm = 1 ;

* Uncomment to next 4 lines to create a new certificate

* they only last for 365 days

* action = 1

*    req = '/PROD/certificates'

  CACert = '/trace_pc/work.out/CERT/REPTILE_SERVERS_CA.CRT' ; extensions = 
'' ; CertOut = '/trace_pc/work.out/CERT/ACTUAL'
*    ret = 
createCertificate(action,req,priveKey,explore,CACert,365,extensions,CertOut)
  ret = addCertificate(CertOut, usedAs, format, algorithm,sec_context)
    
  CRT The Return code is :ret



  depth=1    ; * 0 = self signed, 1 = Signed by a CA
  serverOrClient=2   ; * 1 = Server, 2 = client
  
  L.ERR+=setAuthenticationDepth(sec_context, depth, serverOrClient)




  CRT L.ERR After setAuthenticationDepth : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  ret = 
addAuthenticationRule(sec_context,serverOrClient,VerificationStrength,Generous)

  L.ERR+=setHTTPDefault(HEADERS,)

  CRT L.ERR after addAuthenticationRule : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  L.ERR+=setHTTPDefault(VERSION,1.1)

  CRT L.ERR after setHTTPDefault : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  request_handle=''
  L.ERR+=createSecureRequest(URL, POST, request_handle,sec_context) ;* 
Using the url

  CRT L.ERR after createSecureRequest : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  XML = XML.REQUEST
  MAX.RETRIES = 10
  SERVER.IP.ADDRESS = Leonardo.Rafael.be

  TIMEOUT    = 9

  L.ERR+=addRequestParameter(request_handle, xmlStream, XML, )
  CRT L.ERR after addRequestParameter : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  L.STATUS = 0 ; L.OUTPUT =  ; L.TIMEOUT =  ; L.POST.DATA = ;
  L.HEADER = 
  L.ERR+=submitRequest(request_handle, TIMEOUT, L.POST.DATA, L.HEADER, 
L.OUTPUT, L.STATUS)

  CRT L.ERR : :L.ERR
  CRT L.HEADER:L.HEADER
  CRT
  CRT L.OUTPUT:L.OUTPUT
  CRT L.POST.DATA:L.POST.DATA

  SOCKET.PORT    = 9101
  BLOCKING.MODE  = 1 ;* 1 = Blocking Mode,  2 = Non-Blocking Mode


  X.LOG.ACTION = 'OFF'
  X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread George Land
If you are connection pooling without connection pooling licenses then the
most a court will do is rule that you need to buy those connection pool
licenses, they aren't going to tell you that you need 2 million licenses.


On 04/06/2012 15:58, Wjhonson wjhon...@aol.com wrote:

 
  
 
 Surely Robert you know that courts understand that wording can be ambiguous.
 If you really think some court is going to tell you you need 2 million
 licenses I think you're trying to make a case out of tissue
 
 
  
 
  
 
  
 
 -Original Message-
 From: Robert Houben robert.hou...@fwic.net
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Mon, Jun 4, 2012 7:35 am
 Subject: Re: [U2] Universe/Unidata in the Cloud
 
 
 As usual this group is a wealth of information.  I think the talk to Rocket
 is 
 the most useful thing.  Our OLE DB driver uses Microsofts OLE DB Resource
 Pooling (built into Windows) to pool.  Our other products provide built-in
 pooling. We've always told our U2 customers that they need to get connection
 pooling licenses.  The wording of the license agreements suggests that whoever
 wrote it did not understand how most applications use connection pooling.  I
 was 
 curious if this had been cleared up.  Unfortunately, if anything goes wrong,
 unless you have something written to refer to, the actual wording of the
 license 
 will be used by the courts.
 
 Thank you,
 
 Robert Houben
 IBM Certified Solution Advisor and Architect - Cloud Computing Architecture
 Chief Technology Officer
 FusionWare Integration Corp.
 p: 604-777-4254 x158
 f: 604-608-5544
 http://www.fwic.net
 LinkedIn  Twitter  FaceBook
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of George Land
 Sent: June-04-12 1:33 AM
 To: U2 Users List
 Subject: Re: [U2] Universe/Unidata in the Cloud
 
 I think that there is quite a bit of confusion on different terms.
 
 Firstly there is no problem in developing and hosting web based applications
 using U2, many of the successful U2 applications today are web based.  But
 since 
 U2 is licensed per user what you can't do is simply have a small license that
 connection pools - in other words runs a few processes that listen for work
 from 
 a large user base and services them.
 
 Instead if you connection pool using Rocket's or your own technology then you
 need to buy connection pooling licenses.  Whilst this pricing model is
 different 
 to Oracle and Microsoft it is also often less expensive, it all depends on the
 configuration of the system being implemented.
 
 But that's different from SaaS, connection pooling is about a technical
 architecture whilst SaaS is really a pricing model.  You can adopt a SaaS
 pricing model on an in house application just as you can adopt a conventional
 user licensing model on an application that is hosted/in the cloud.
 
 If you are implementing a true SaaS pricing model, so the customers pay per
 transaction or per some other metric, and you want to pay for your U2 licenses
 on the same metric then you need to talk to Rocket or your distributor if you
 are outside the US.  It is almost impossible to have an 'off the shelf'
 pricing 
 model for this environment because the metrics you use and the software you
 need 
 to back it up will vary, particularly if the demand is going to be seasonal.
 But talk about it with whoever you buy from.
 
 George Land
 APT Solutions Ltd
 U2 UK Distributor
 
 
 
 On 03/06/2012 07:22, Robert Houben robert.hou...@fwic.net wrote:
 
 I should clarify my question.  What is the legality behind licensing a
 SaaS (or BPaaS) offering with a U2 system behind it?
 
 I believe at one point there were terms of use in the user license
 that made a SaaS implementation potentially impractical.
 
 BTW, believe it or not, providing Microsoft products in a SaaS
 environment is a violation of their license agreement, unless you get
 a special variant of their licenses (these raise the price
 significantly).  This is little known, and to date Microsoft has not
 been aggressive in enforcing it, but that apparently might be about to
 change.
 
 U2, to my knowledge requires a special type of network license if you
 are going to provide pooled connections of any sort (e.g. through a
 web server.) The special terms to look up seem to be Connection
 Pooling and Concurrent User.  My initial read of the section
 describing these is that if I have potentially 2 million different
 users who may use my service through web-based connection pooling
 through the term of the license, (even if not concurrently), I must
 have licenses enough (2 million of them) to support this.  I copy the
 block of text at the bottom of this message from a copy of the license
 agreement that I have (possibly out of date - that's part of the question).
 Their definition of Concurrent seems a bit odd...
 
 (BTW, I agree: I would *never* use an unprotected telnet session over
 the 

[U2] Regarding: programming Techinques

2012-06-04 Thread satya satya
Hi Everyone,

Can any one explain, were we can get the nformation about the
Unidata Programming Logic.

Thank you,
Satya.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Regarding: programming Techinques

2012-06-04 Thread Wjhonson

At TCL type
HELP BASIC



-Original Message-
From: satya satya satyapal...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 9:30 am
Subject: [U2] Regarding: programming Techinques


Hi Everyone,
Can any one explain, were we can get the nformation about the
nidata Programming Logic.
Thank you,
atya.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Wjhonson

Yes.
And I have to say, that contrary to some of my peers, the majority of the 
income does not arise from the sale of seats, which are relatively cheap.
It arises from the sale of consulting services, which can run a seat per hour, 
if you get my drift.
And the sale of training, seminars, analysis, sell-ups and so on.

They want more clients, and I'm sure they will do what it takes to not piss 
them off.
However, as you probably know, the number of Rocket employees who monitor this 
list is woefully small.  One or two.
The ones you need, don't.

So make the phone call, get the ball rolling.








-Original Message-
From: Robert Houben robert.hou...@fwic.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 9:37 am
Subject: Re: [U2] Universe/Unidata in the Cloud


I understand all of this, but an ISV does not want a potential lawsuit, they 
ant a license agreement (or options) that are clear, and the current one is 
ot.  The wording suggests something quite unusual, and not at all what the 
ndustry expects, and is frankly ambiguous.  There are some very rich MV apps 
ut there that could provide world-class SaaS offerings.  An ISV looking at 
ptions may not want to tip their hand even to a company like Rocket. If the 
icense agreement leaves them unclear about the options, then they may move on 
n their search.
Note that not all MV vendors have a track record of being reasonable...
This is based on actual inquiries from customers of ours.  We like to be able 
to 
ntelligently advise our customers, so I'm asking in order to remove the 
ncertainty.  Inquiring minds want to know... :)
So My understanding is this:   It is the opinion of the community that Rocket 
ould cooperate with an ISV, but it would require talking to them, and getting 
heir buy-in.
Thank you,
Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of George Land
ent: June-04-12 9:19 AM
o: U2 Users List
ubject: Re: [U2] Universe/Unidata in the Cloud
If you are connection pooling without connection pooling licenses then the most 
 court will do is rule that you need to buy those connection pool licenses, 
hey aren't going to tell you that you need 2 million licenses.

n 04/06/2012 15:58, Wjhonson wjhon...@aol.com wrote:



 Surely Robert you know that courts understand that wording can be ambiguous.
 If you really think some court is going to tell you you need 2 million
 licenses I think you're trying to make a case out of tissue








 -Original Message-
 From: Robert Houben robert.hou...@fwic.net
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Mon, Jun 4, 2012 7:35 am
 Subject: Re: [U2] Universe/Unidata in the Cloud


 As usual this group is a wealth of information.  I think the talk to Rocket
 is
 the most useful thing.  Our OLE DB driver uses Microsofts OLE DB
 Resource Pooling (built into Windows) to pool.  Our other products
 provide built-in pooling. We've always told our U2 customers that they
 need to get connection pooling licenses.  The wording of the license
 agreements suggests that whoever wrote it did not understand how most
 applications use connection pooling.  I was curious if this had been
 cleared up.  Unfortunately, if anything goes wrong, unless you have
 something written to refer to, the actual wording of the license will
 be used by the courts.

 Thank you,

 Robert Houben
 IBM Certified Solution Advisor and Architect - Cloud Computing
 Architecture Chief Technology Officer FusionWare Integration Corp.
 p: 604-777-4254 x158
 f: 604-608-5544
 http://www.fwic.net
 LinkedIn  Twitter  FaceBook



 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of George Land
 Sent: June-04-12 1:33 AM
 To: U2 Users List
 Subject: Re: [U2] Universe/Unidata in the Cloud

 I think that there is quite a bit of confusion on different terms.

 Firstly there is no problem in developing and hosting web based
 applications using U2, many of the successful U2 applications today
 are web based.  But since
 U2 is licensed per user what you can't do is simply have a small
 license that connection pools - in other words runs a few processes
 that listen for work from a large user base and services them.

 Instead if you connection pool using Rocket's or your own technology
 then you need to buy connection pooling licenses.  Whilst this pricing
 model is different to Oracle and Microsoft it is also often less
 expensive, it all depends on the configuration of the system being
 implemented.

 But that's different from SaaS, connection pooling is about a
 technical architecture whilst SaaS is really a pricing model.  You can
 adopt a SaaS pricing model on an in house application just as you can
 adopt a conventional user licensing model on an application that is hosted/in 
he cloud.

 If you are implementing a true SaaS pricing model, so the customers
 

Re: [U2] Regarding: programming Techinques

2012-06-04 Thread Mark Eastwood
www.rocketsoftware.com/rocket-resources/tech-resources/u2




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya
Sent: Monday, June 04, 2012 9:30 AM
To: U2 Users List
Subject: [U2] Regarding: programming Techinques

Hi Everyone,

Can any one explain, were we can get the nformation about the Unidata 
Programming Logic.

Thank you,
Satya.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Regarding: programming Techinques

2012-06-04 Thread Charles_Shaffer
satya,

You should be able to find documentation on the Rocket site.  If you are 
interested in techniques read the document called Developing Unibasic 
Applications.  There is also a UniBasic Commands Reference for a list 
of commands and how they work.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   satya satya satyapal...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   06/04/2012 11:30 AM
Subject:[U2] Regarding: programming Techinques
Sent by:u2-users-boun...@listserver.u2ug.org



Hi Everyone,

Can any one explain, were we can get the nformation about the
Unidata Programming Logic.

Thank you,
Satya.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
This email was Anti Virus checked by Astaro Security Gateway. 
http://www.astaro.com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Robert Porter
And they'd never give you $2,860,000 for not realizing coffee is hot and 
spilling it on your lap... Yes, I know it was re-done for an undisclosed 
amount. My point is that relying on the court system to be reasonable when it 
has repeatedly been absurd in their judgement (or lack thereof) is 
short-sighted.
 
Rob


 George Land george.l...@aptsolutions.co.uk 6/4/2012 11:19 AM 
If you are connection pooling without connection pooling licenses then the
most a court will do is rule that you need to buy those connection pool
licenses, they aren't going to tell you that you need 2 million licenses.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe/Unidata in the Cloud

2012-06-04 Thread Wjhonson

That was a jury award.
It's common knowledge that juries can be swayed to grant millions of dollars to 
bloated greedy record labels, or people who got cancer after smoking three 
packs a day for 20 years.








-Original Message-
From: Robert Porter ropor...@ochsner.org
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 10:21 am
Subject: Re: [U2] Universe/Unidata in the Cloud


And they'd never give you $2,860,000 for not realizing coffee is hot and 
pilling it on your lap... Yes, I know it was re-done for an undisclosed amount. 
y point is that relying on the court system to be reasonable when it has 
epeatedly been absurd in their judgement (or lack thereof) is short-sighted.

ob

 George Land george.l...@aptsolutions.co.uk 6/4/2012 11:19 AM 
f you are connection pooling without connection pooling licenses then the
ost a court will do is rule that you need to buy those connection pool
icenses, they aren't going to tell you that you need 2 million licenses.

___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Nick Gettino

As John stated we use dimensioned arrays but we also equate each attribute 
which reserves a spot for the piece of data making it tremendously faster 
updating.



Nicholas M Gettino, Director of Professional Services  Support, EnRoute 
Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX 
(678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
u2-users-requ...@listserver.u2ug.org
Sent: Friday, June 01, 2012 3:00 PM
To: u2-users@listserver.u2ug.org
Subject: U2-Users Digest, Vol 38, Issue 1

Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org

To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
or, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org

You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org

When replying, please edit your Subject line so it is more specific
than Re: Contents of U2-Users digest...


Today's Topics:

   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
   2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
   3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
   4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
   5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
   6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
   7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
   8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
   9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  11. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)


--

Message: 1
Date: Fri, 1 Jun 2012 10:29:55 -0400
From: Dave Laansma dlaan...@hubbardsupply.com
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed
Message-ID:
071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com
Content-Type: text/plain;   charset=us-ascii

I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:

 

Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective null multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com http://www.hubbardsupply.com 

Delivering Products, Services and Innovative Solutions

 



--

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Regarding: programming Techinques

2012-06-04 Thread Tony Gravagno
The difference between logic and syntax is huge. Common reference
manuals are intended to provide details for people who already
understand the environment. In addition to the guide on techniques
referenced below, look for code at http://PickWiki.com. There you'll
find a lot of functional code in-context, which might be far more
helpful than tiny snippets in a reference manual.

As well as getting a formal education in programming, I originally
learned how to code by picking apart programs that I used. Knowing how
they worked allowed me to look at code and then work out exactly what
the lines of code did toward creating the experience that I already
understood. When I first started in the 1970's, I was playing games on
a TTY device like StarTrek, and at the time I picked apart the code
which was written in Fortran and BASIC. Over the years I found that
learning code through games was not only educational but fun too -
hacking the code to make the games better (or to cheat) provided the
developer experience of analyze, code, test, debug, repeat. Of course
there weren't many games written in COBOL, RPG, BAL, or a slew of
other languages I learned, but there was always some huge set of
examples to follow which demonstrated how to use the language - and
lots of examples of bad coding style as well.

With the internet, the best education one can get on mainstream
languages is available from code published as freeware, and in forums
where people post fully working code with questions and answers. I
just wish we had more exchanges like this in our industry but we don't
because there are so few newcomers. Don't hesitate to post newbie
questions here, or at the MVDBMS forum - we all like to help
newcomers.
http://groups.google.com/group/mvdbms/about

If you're going to learn Pick BASIC, look in your own system for
examples. That's how I learned Pick BASIC (and Proc, RPL, Access, etc)
- I spent my evenings reading code that made my company work.  Ask
other developers who have worked on your application about where some
small code items are which aren't going to be too big or overwhelming.
And ask them if there is any source code for games on the system. ;)

HTH

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula RD sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
http://Nebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno


 From: 
Charles_Shaffer 
 satya,
 
 You should be able to find documentation on the Rocket site.  If you
 are interested in techniques read the document called Developing
 Unibasic Applications.  There is also a UniBasic Commands
 Reference for a list of commands and how they work.


 From:   satya 
 Can any one explain, were we can get the nformation about the
 Unidata Programming Logic.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Perry Taylor
If someone has already suggested this then forgive me as I haven't been 
following this discussion in great detail.

Since you are handling the records in a dimensioned array you can RAISE() each 
element, process each element as attributes where field caching will come into 
play, then LOWER() them prior to writing them to disk.  You should be amazed at 
how much faster this can be.

Assuming all elements of the array are multivalued (if not you'll have to hard 
code which elements are multivalued) ...

MATREADU DX FROM .
DX.ELEMENTS = INMAT()   
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = RAISE(DX(AMC))
NEXT AMC
... Process them as attribute-delimited arrays
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = LOWER(DX(AMC))
NEXT AMC

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, June 04, 2012 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)


Equating doesn't reserve a spot, so I assume you mean dimensioning reserves 
a spot
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino nick.gett...@enroute911.com
To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services  Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX 
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1
Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org
To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific
han Re: Contents of U2-Users digest...

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
 10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
 11. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
 12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: Dave Laansma dlaan...@hubbardsupply.com
o: U2-Users@listserver.u2ug.org
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com
ontent-Type: text/plain;charset=us-ascii
I have a file that is taking a very long time to update, seemingly
onger and longer each month. Here is briefly how the attributes are
rganized, a relatively simple example:
 
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
2-03 etc.
Attributes 2 through 30 are dependent on attribute 1 and contain a
ariety of dollar amounts that are accumulated for the respective period
n attribute 1.
 
At the end of each month, a new G/L Period is inserted into the
ultivalued position of attribute 1 as well as each of the respective
ultivalued positions in attributes 2 through 30. Nothing complicated.
 
My question is this and is aimed largely at the technicians at Rocket
..
 
If, at the beginning of the year, I were to insert each of the
2-periods into their respective multivalues in attribute 1 and insert
espective null multivalues into attributes 2 through 30, thus
erforming all of the 'inserts' at once, will the processing each month
un faster as numbers are simply accumulated into attributes 2 through
0 and no inserting of new multivalues will have to be performed?
 
A couple 

Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Daniel McGrath
Note: This is only true for UniVerse which implements an internal hint 
mechanism. This will not provide the desired effect in UniData.

Also note, correctly using LOOP/REMOVE will outperform the RAISE/LOWER method 
as it doesn't do the 2 extra laps of string scanning and modified delimiters.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Monday, June 04, 2012 2:48 PM
To: U2 Users List
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

If someone has already suggested this then forgive me as I haven't been 
following this discussion in great detail.

Since you are handling the records in a dimensioned array you can RAISE() each 
element, process each element as attributes where field caching will come into 
play, then LOWER() them prior to writing them to disk.  You should be amazed at 
how much faster this can be.

Assuming all elements of the array are multivalued (if not you'll have to hard 
code which elements are multivalued) ...

MATREADU DX FROM .
DX.ELEMENTS = INMAT()   
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = RAISE(DX(AMC))
NEXT AMC
... Process them as attribute-delimited arrays
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = LOWER(DX(AMC))
NEXT AMC

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, June 04, 2012 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)


Equating doesn't reserve a spot, so I assume you mean dimensioning reserves 
a spot
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino nick.gett...@enroute911.com
To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services  Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com 
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1 Send U2-Users mailing list submissions 
to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide 
Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to 
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific han Re: 
Contents of U2-Users digest...

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)  10. Re: 
Monthly Multivalue Inserts and Speed (Dave Laansma)  11. Re: Monthly Multivalue 
Inserts and Speed (Wjhonson)  12. Re: Monthly Multivalue Inserts and Speed 
(David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: Dave Laansma dlaan...@hubbardsupply.com
o: U2-Users@listserver.u2ug.org
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com
ontent-Type: text/plain;charset=us-ascii
I have a file that is taking a very long time to update, seemingly onger and 
longer each month. Here is briefly how the attributes are rganized, a 
relatively simple example:
 
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
2-03 etc.
Attributes 2 through 30 are dependent on attribute 1 and contain a ariety of 
dollar amounts that are accumulated for the respective period n attribute 1.
 
At the end of each month, a new G/L Period is inserted into the ultivalued 
position of attribute 1 as 

Re: [U2] [UV] Using Global sign certificates in UV

2012-06-04 Thread Gregor Scott
Is the actual host name (Leonardo.Rafael.be) in the hosts file on the server?
Can you use ping Leonardo.Rafael.be to resolve the host name into the correct 
IP?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Tuesday, 5 June 2012 1:55 AM
To: U2 Users List
Subject: [U2] [UV] Using Global sign certificates in UV




Hello,

The URL of a webservice I need to use has a port number in it ei:

Acceptance = 
https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/;

The libraries U2 libraries I'm using are somehow interpreting: 
Leonardo.Rafael.be:9101 as the complete hostname (which it doesn't find in the 
host file.

05/29/2012 16:07:02 [ 26930 26925 ] new host 221010:Leonardo.Rafael.be:9101 
allocated (proxy:no)
05/29/2012 16:07:02 [ 26930 26925 ] host Leonardo.Rafael.be:9101 not found in 
hostList
05/29/2012 16:07:09 [ 26930 26925 ] Unknown socket error : 1000

The code below is from the pick wiki article.   Any ideas on now to get 
CreateSecureRequest() to interpret the host + port correctly ?

Thanks.


*** ### Code *** *For getting onto webservices we use 
this sort of code:


  * Read an xml request to send to the webservice *
  OPEN , WORK.OUT TO WORK.OUT ELSE STOP 201, WORK.OUT
  READ XML.REQUEST FROM WORK.OUT, TURTLE.XML ELSE STOP
  XML.REQUEST = CONVERT(@AM,,XML.REQUEST)

  PROMPT ''  ;* 212.65.63.70
  Acceptance = 
https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/;
**  Acceptance = 
https://212.65.63.70:9101/CustomerOrder/OrderManagementService/01/;
  Production = 
https://Leonardo.Rafael.be/CustomerOrder/OrderManagementService/01/;


  X.LOG.FILE   = /trace_pc/work.out/CERT.LOG
  X.LOG.ACTION = 'ON'
  X.LOG.LEVEL = '10'
  WRITE  ON WORK.OUT, CERT.LOG ;* Overwrite existing log file

  X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL)


  URL = Acceptance ;* Setting URL to the acceptance site

  L.ERR = 
  sec_context=''
  L.ERR =createSecurityContext(sec_context,'')
  usedAs=2 ;* 2 = Issuer Certificate CA
  format = 2 ; algorithm = 1 ;

* Uncomment to next 4 lines to create a new certificate

* they only last for 365 days

* action = 1

*req = '/PROD/certificates'

  CACert = '/trace_pc/work.out/CERT/REPTILE_SERVERS_CA.CRT' ; extensions = 
'' ; CertOut = '/trace_pc/work.out/CERT/ACTUAL'
*ret = 
createCertificate(action,req,priveKey,explore,CACert,365,extensions,CertOut)
  ret = addCertificate(CertOut, usedAs, format, algorithm,sec_context)

  CRT The Return code is :ret



  depth=1; * 0 = self signed, 1 = Signed by a CA
  serverOrClient=2   ; * 1 = Server, 2 = client

  L.ERR+=setAuthenticationDepth(sec_context, depth, serverOrClient)




  CRT L.ERR After setAuthenticationDepth : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  ret = 
addAuthenticationRule(sec_context,serverOrClient,VerificationStrength,Generous)

  L.ERR+=setHTTPDefault(HEADERS,)

  CRT L.ERR after addAuthenticationRule : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  L.ERR+=setHTTPDefault(VERSION,1.1)

  CRT L.ERR after setHTTPDefault : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  request_handle=''
  L.ERR+=createSecureRequest(URL, POST, request_handle,sec_context) ;* 
Using the url

  CRT L.ERR after createSecureRequest : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  XML = XML.REQUEST
  MAX.RETRIES = 10
  SERVER.IP.ADDRESS = Leonardo.Rafael.be

  TIMEOUT= 9

  L.ERR+=addRequestParameter(request_handle, xmlStream, XML, )
  CRT L.ERR after addRequestParameter : :L.ERR
  CRT Hit a key to continue :;XX = KEYIN()


  L.STATUS = 0 ; L.OUTPUT =  ; L.TIMEOUT =  ; L.POST.DATA = ;
  L.HEADER = 
  L.ERR+=submitRequest(request_handle, TIMEOUT, L.POST.DATA, L.HEADER, 
L.OUTPUT, L.STATUS)

  CRT L.ERR : :L.ERR
  CRT L.HEADER:L.HEADER
  CRT
  CRT L.OUTPUT:L.OUTPUT
  CRT L.POST.DATA:L.POST.DATA

  SOCKET.PORT= 9101
  BLOCKING.MODE  = 1 ;* 1 = Blocking Mode,  2 = Non-Blocking Mode


  X.LOG.ACTION = 'OFF'
  X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
Message  protected by DealerGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.pentanasolutions.com

Click here to report this message as spam:
https://login.mailguard.com.au/report/1ESfTWqvLE/44bpo49N2SMmIDPHsjpPyk/7.157


This email and any attachments to it are confidential.
You must not use, disclose or act on the email if you are not the intended
recipient.  Liability limited by a scheme approved 

Re: [U2] Regarding: programming Techinques

2012-06-04 Thread dennis bartlett
Satya
Google Jonathan E Sisk for a good book on the architecture, (and it's built
in BASIC programming  SQL language) if that's what you're looking for.
There are many variations (Unidata / Universe / D3  Revelation / etc) but
the basic database architecture is the same.

Pickwiki has source code as well as great articles.

T24All has code and processes specific to jBase/Globus, but since jBase is
Pick based, similar to  Universe) it can help.


On 5 June 2012 06:08, Tony Gravagno 3xk547...@sneakemail.com wrote:

 The difference between logic and syntax is huge. Common reference
 manuals are intended to provide details for people who already
 understand the environment. In addition to the guide on techniques
 referenced below, look for code at http://PickWiki.com. There you'll
 find a lot of functional code in-context, which might be far more


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users