RE: [Maybe spam] [U2] Uniobjects in a Citrix environment
Yes, We have about 120 Citrix machines. We have written VB apps that use uniobjects to access out universe database. Didn't have any great problems. Les -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: 22 April 2005 00:03 To: u2-users@listserver.u2ug.org Subject: [Maybe spam] [U2] Uniobjects in a Citrix environment Has anyone implemented this ? Any advice/comments appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Leroy Dreyfuss wrote: > Mike Henderson wrote: > >And what is the "equivalent number of U2 licenses " that I > would need to buy? > >If I had an internet-facing U2 system for example - which I > don't - how > >could I work out this number? In theory it could be millions of > >prospective users, and while I'm sure IBM would love to sell me a > >million-seat license, I'm equally sure I couldn't afford it! > > >LeRoy, I'm not trying to be difficult here, I'm genuinely > interested in > >how, if I were back in the IT Manager role, I would license my U2 > >database in a way that meet both IBM's reasonable > expectation that they > >should receive a fair return for the use of their IP, and my > >management's equally reasonable expectation that I should provide the > >service they require at a cost that the business can sustain. > > The answer here is RedBack. It is designed for exactly this > purpose. We > have customers servicing millions of requests per day on a > hundred or less Webshares. Leroy, the issue with the answer being Redback is that using Redback imposes too much of the shape of the solution to any given problem. Take Craig's example. Disparate systems in a large organisation hooked together via MQ Series. That organisation can't rewrite its web application architecture around redback just so some data can be hooked out of a U2 database. It is great that IBM sells what many people seem to consider top-notch technology for building web applications, but I'm fairly sure that they will get into trouble if they are seen to be using their licensing agreements to force people to buy that technology in preference to other competitive ones. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Mark Shannon/Australia/IBM is out of the office.
I will be out of the office starting 22/04/2005 and will not return until 02/05/2005. Please send case updates to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Ken, Once the UniObjects connection pooling is in, the problem goes away. It sounds like: (1) IBM sees a licensing problem, (2) IBM offers a stopgap via RedBack, (3) IBM offers a proper solution as soon as is feasible... Granted, I can be objective, since all my situations are compliant under the current rules. I've been listening to the frustrations expressed on this topic but I also see the UniObjects pooling as a reasonable answer for those of us who aren't planning on adding Redback to our process. - Chuck "It sounds like it's almost solved" Barouch Leroy, the issue with the answer being Redback is that using Redback imposes too much of the shape of the solution to any given problem. Take Craig's example. Disparate systems in a large organisation hooked together via MQ Series. That organisation can't rewrite its web application architecture around redback just so some data can be hooked out of a U2 database. It is great that IBM sells what many people seem to consider top-notch technology for building web applications, but I'm fairly sure that they will get into trouble if they are seen to be using their licensing agreements to force people to buy that technology in preference to other competitive ones. Cheers, Ken --- 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] [UD 6.0] Address verification calls to the web
HP-UX 11.11 UD 6.0 We do exactly what you are attempting to do using CALLC to a product from FirstLogic called ACE Libraries or PostalSoft. Their information comes directly from USPS (which sometimes contradicts some of the more common carriers). I believe that their PostalSoft Professional and Business Editions allow for calls to a web-service (although I have not pursued this at all). The ACE libraries (which I could not readily find on their website www.firstlogic.com) allows us to perform realtime address corrections. We have developed 'batch' utilities to perform mass cleansing. The real challenge was creating a c-wrapper the would deal with file-handles (since Unidata does not use file-handles in the same capacity). This list was very instrumental in assisting us to create that wrapper. Vance Alspach J & L Industrial Supply "Bruce Lunt" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/21/2005 06:38 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:[U2] [UD 6.0] Address verificcation calls to the web Hi All, I have seen a bunch of postings on this list lately about linking Unidata (and Universe) to the outside world but I am not sure if the answers that I am looking for have been talked about, or not. So, finally, I am going to ask the question. We would like to subscribe to an address verification service on the web. When an address is entered or changed on our system, we want to send a call to a web-service. We do approx. 150,000 address entries per month. (Some month's will be bigger than that and some month's will be less than that) We have considered and rejected scrubbing our entire database of addresses. It was thought that only the currently active addresses need to be corrected and if an old customer decides to become active again, we'll verify them at that time. The service that we think we're going to go with uses SOAP, if that helps. Has this type of interface been done already? If so, how did you do it? I mean, can you make the calls directly from UniBasic or did you create a flat-file and export it to Unix first? If you export it to Unix, did you use Perl? Or some other tool? Also, this whole process needs to be pretty quick since it is a Order-entry screen. We would appreciate any help that you all can offer! Thanks in advance, R. Bruce Lunt 408.832.1900 cell 925.924.2132 office --- 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 6.0] Address verification calls to the web
Might be something that you could do with MQ Series. It seems to run on a lot of different hardware. I don't know a lot about SOAP. But I think it is a request to exchange information. I think you could set up one MQ queue to send the request. And another to receive the response. You would need some type of tracking number to match the original request to the response. MQ has the added feature that if one of the servers is down, the messages just queue up until the down server is back. -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 5:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD 6.0] Address verificcation calls to the web Hi All, I have seen a bunch of postings on this list lately about linking Unidata (and Universe) to the outside world but I am not sure if the answers that I am looking for have been talked about, or not. So, finally, I am going to ask the question. We would like to subscribe to an address verification service on the web. When an address is entered or changed on our system, we want to send a call to a web-service. We do approx. 150,000 address entries per month. (Some month's will be bigger than that and some month's will be less than that) We have considered and rejected scrubbing our entire database of addresses. It was thought that only the currently active addresses need to be corrected and if an old customer decides to become active again, we'll verify them at that time. The service that we think we're going to go with uses SOAP, if that helps. Has this type of interface been done already? If so, how did you do it? I mean, can you make the calls directly from UniBasic or did you create a flat-file and export it to Unix first? If you export it to Unix, did you use Perl? Or some other tool? Also, this whole process needs to be pretty quick since it is a Order-entry screen. We would appreciate any help that you all can offer! Thanks in advance, R. Bruce Lunt 408.832.1900 cell 925.924.2132 office --- 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] color laserjet pcl programming for logos
Troy Buss ([EMAIL PROTECTED]) wrote on Thu, 21 Apr 2005 11:57:59 -0700 > I have some forms that print to HP printers using standard > PCL formatting codes. > ... > However, when I print direct to the printer, I get a lot of the > logo in blue, but rectangular portions of the logo in black as > if the raster portions are ignoring my color selection. Part of the problem is that the background is defined, and the CMY pallet uses "0" for white. > Just wanting to know if someone else out there has > successfully implemented PCL coloring. I have managed using Simple Color, but it was a long journey... In the Simple CMY pallet the colors are as follows: # Description - --- 0 White 1 Cyan 2 Magenta 3 Dark Blue 4 Yellow 5 Green 6 Red 7 Black *r-3U sets the Simple CMY pallet *v#S set color # (0-7) *r1U resets the normal pallet The following BASIC program will demonstrate printing plain text in color. PRINTER ON PRINT "Test Color Printing - Default" PRINT "Setting CMY Pallet" PRINT CHAR(27):"*r-3U-->Pallet Set" PRINT "Setting Colors 0-7" FOR I = 0 TO 7 PRINT CHAR(27):"*v":I:"SPrint Test Color # ":I NEXT I PRINT "Reset Pallet to B&W" PRINT CHAR(27):"*r1UPallet Reset" PRINT "This should be normal color" PRINTER OFF PRINTER CLOSE Graphics are another story. You can review my article on B&W Logo printing at www.u2ug.org - click on Topics then Newsletter. To add color, you must set the pallet as with the text example above, then export your Cyan, Magenta and Yellow data layers separately. To print # bytes of pixel data, use *b#V[cyan data] *b#V[magenta data] *b#W[yellow data] You can speed things up by printing 0 bytes of colors you don't need - for example, to print 5 bytes in Yellow, use *b0V*b0V*b5W<5 data bytes> I had problems with certain data values in the data bytes (e.g., 10-15). I wound up having to print in two phases (as with the B&W article) but with different data arrangements. Off hand, I think I used the low two bits in each hex digit, then shifted two bits to do the second half of the logo. We have not put this option into production. Even though I can get our two-color logo to display properly, the code is specific to color printers. The color commands do not adjusted well in our B&W printers. --Tom Pellitieri Century Equipment --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] URL Encoding
Craig, Thursday, April 21, 2005, 4:28:33 PM, you wrote: CB> David, CB> if you are doing a POST, shouldn't this bit: >> API=CustomsCN22&XM >> L=> PASSWORD=1919191919191>>FirstName>JohnSmith >>XYZ Co >> rporationSuite CB> A1234 Etail >> er Dr.Los CB> Angeles> te>CA90052 ... CB> be in the body rather than the url? if you are not sending any content CB> in the request (and all the parameters are in the url) you should CB> probably use GET. I had tried both GET and POST. In both cases the url never got encoded .. as i thought the manuals say CB> Off the top of my head maybe you need to: CB> addrequestparamter to add API with a value of CustomsCN22 CB> then to add XML with a value containing your XML string. so as i *thought* addrequestparameter is for POST and used to build the 'parameter'/'value' pairs .. CB> Either way, you would think the request process would check that the url CB> was correctly encoded. yes .. since there is no URLENCODE/URLDECODE commands .. yes you would think it would do this. Thanks i will keep playing with this --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD 6.0] Address verification calls to the web
We do this on Universe with a mixture of HTTP requests, XML and CORBA services. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 22 April 2005 13:56 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD 6.0] Address verification calls to the web Might be something that you could do with MQ Series. It seems to run on a lot of different hardware. I don't know a lot about SOAP. But I think it is a request to exchange information. I think you could set up one MQ queue to send the request. And another to receive the response. You would need some type of tracking number to match the original request to the response. MQ has the added feature that if one of the servers is down, the messages just queue up until the down server is back. -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Thursday, April 21, 2005 5:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD 6.0] Address verificcation calls to the web Hi All, I have seen a bunch of postings on this list lately about linking Unidata (and Universe) to the outside world but I am not sure if the answers that I am looking for have been talked about, or not. So, finally, I am going to ask the question. We would like to subscribe to an address verification service on the web. When an address is entered or changed on our system, we want to send a call to a web-service. We do approx. 150,000 address entries per month. (Some month's will be bigger than that and some month's will be less than that) We have considered and rejected scrubbing our entire database of addresses. It was thought that only the currently active addresses need to be corrected and if an old customer decides to become active again, we'll verify them at that time. The service that we think we're going to go with uses SOAP, if that helps. Has this type of interface been done already? If so, how did you do it? I mean, can you make the calls directly from UniBasic or did you create a flat-file and export it to Unix first? If you export it to Unix, did you use Perl? Or some other tool? Also, this whole process needs to be pretty quick since it is a Order-entry screen. We would appreciate any help that you all can offer! Thanks in advance, R. Bruce Lunt 408.832.1900 cell 925.924.2132 office --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]
It's both. You pose a scenario that have users interactively working with an MQ-based iPhantom. The only reason why that is acceptable is that it is in fact, an iPhantom charging a license. You will find that you will need more than one to serve many requests because the response times will not be desirable when many users are waiting for MQ itself to deliver the messages from a single U2 MQ iPhantom. More than one would be needed, and each one costs a license. Indeed, MQ could be viewed as multiplexing type of technology, but the reality is that it's not practical to use MQ that way. So, if you use MQ like a connection pool, that is not desirable performance-wise, and is a breach of your license agreement. But if you use it for applications to communicate (which is the purpose of MQ), you are not violating the license agreement. Applications would send messages back and forth as a result of something a user initiated and wasn't waiting for an answer. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Craig Bennett <[EMAIL PROTECTED] au>To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [Fwd: Re: [U2] IBM Licensing 04/22/2005 12:47 Requirement - MQ Series] AM Please respond to [EMAIL PROTECTED] er.u2ug.org Leroy, I don't understand. First you say: >However, remember that if you are using MQ as a >means of users communicating with the database in the scenario you >describe, you are using MQ as a de facto connection pool and violating >your U2 license agreement if you don't have the equivalent number of U2 and then you say: > Message queues in the user scenario you suggest also does not violate the > agreement because they consume licenses (as an iPhantom); users are > interactively working the U2 database, regardless of the method. Which is it? if I use MQ series to pass messages to and from my web application or an atm or whatever to support an application user to access the database am I neccessarily correctly licensed because the phantoms are each using a db licence or do I have to worry about the number of users putting requests on the queue in relation to the number of phantoms servicing the queue? thanks, Craig --- 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 pic24478.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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]
I hope you get a respone from LeRoy on this, Craig -- I said the same thing while reading his second response --- huh? It seems that answer is 180 degrees from the first answer... >Leroy, >I don't understand. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Base 16, 26, 36
I'm throwing this together on a whim, so I hope it works right for you. You can have as many digits as you want and decipher them any way you need to. The key deciding how you want to encode and decode the values. ASCII 0-9 = x30 to x39 48 to 57 ASCII A-Z = x41 to x5A 65 to 90 !Build a base36 translation map FOR X = 1 TO 10 MAP = SEQ(X-1) NEXT X FOR X = 11 TO 36 MAP = SEQ(X+54) NEXT X 0 = MAP<1> = "0" 1 = MAP<2> = "1" 11 = MAP<11> = "A" 12 = MAP<12> = "B" Add the first two values together to get a single decoded bit: 011 = Box 01, bag 1 AA1 = Box 20, bag 1 Use the first two values as a decoded bit pair and you get: 011 = Box 01, bag 1 AA1 = Box 1010, bag 1 LOCATE "0" IN MAP SETTING VM THEN DIGITVAL = VM-1; VALUE IS 0 END LOCATE "A" IN MAP SETTING VM THEN DIGITVAL = VM-1; VALUE IS 10 END Glen http://mvdevcentral.com > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill > Sent: Friday, April 22, 2005 2:54 PM > To: 'u2-users@listserver.u2ug.org' > Subject: [U2] Base 16, 26, 36 > > > We have a bar-code labeling challenge. We need to print hundreds of unique > serialized labels. > > We have three characters available. > > I am expecting to do something like > > Master (pallet): H42 2x MMM H42 is our supplier ID. > > Box # 1 H42 2x AA0 2x is the six-digit packslip > number. > Bag # 1 H42 2x AA1 > H42 2x AA2 > > Box # 2 H42 2x AB0 > Bag # 1 H42 2x AB1 > H42 2x AB2 > > Z * Z = 26 * 26 = 676. Thus, we could have up to 676 boxes. > > Thus on a single packing slip, we could have up to 676 boxes each having > nine bags. > > It appears that UniBasic has no built-in functionality (operators) to handle > base 26, that is, A thru Z. > > base 36, A thru Z, and one thru ten. > > I expect that it could be done, brute force, using arrays and equates. > > Using Wintegrate, we write a txt-file from UniVerse to Windows. BarTender > (Windows-based) prints labels from the txt file. > > BarTender has some VB functionality that I expect we will be forced to use. > > I am writing because I do not want to overlook other U2 voodoo which may be > available. > > Suggestions would be appreciated. > > --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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Hi, I will be out of the office on Monday April 25th. I will not have access to e-mail or voice mail. If a you need an immediate response to your e-mail please e-mail [EMAIL PROTECTED] or you can call Frank at extension 467. Thanks and have a great day! Josh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Base 16, 26, 36
Try this Bill. It returns a value for SUFFIX of AA1 for box 1, bag 1 and ZZ9 for box 676, bag 9. You could extend it to capture numbers also but would need to account for the gap in the ASCII character chart between upper case letters and numbers. This could be condensed into a single line; I used multiple for readability. N1 = INT((BOX - 1) / 26) N2 = BOX - (N1 * 26) - 1 SUFFIX = CHAR(65+N1):CHAR(65+N2):BAG Regards, Cliff Brutzman, Bill wrote: We have a bar-code labeling challenge. We need to print hundreds of unique serialized labels. We have three characters available. I am expecting to do something like Master (pallet): H42 2x MMM H42 is our supplier ID. Box # 1 H42 2x AA0 2x is the six-digit packslip number. Bag # 1 H42 2x AA1 H42 2x AA2 Box # 2 H42 2x AB0 Bag # 1 H42 2x AB1 H42 2x AB2 Z * Z = 26 * 26 = 676. Thus, we could have up to 676 boxes. Thus on a single packing slip, we could have up to 676 boxes each having nine bags. It appears that UniBasic has no built-in functionality (operators) to handle base 26, that is, A thru Z. base 36, A thru Z, and one thru ten. I expect that it could be done, brute force, using arrays and equates. Using Wintegrate, we write a txt-file from UniVerse to Windows. BarTender (Windows-based) prints labels from the txt file. BarTender has some VB functionality that I expect we will be forced to use. I am writing because I do not want to overlook other U2 voodoo which may be available. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Millions (plural) of DB requests per day will require serious infrastructure regardless of middleware platform. Plus there's always the last-day-of-quarter discount with IBM. 8-) With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I believe the more full-featured server versions are more expensive on the server side. I am confident IBM is well aware of MS SQL and Oracle server and client DB licensing models since DB2 plays in the same space. Leroy, thanks for providing some interpretation of current licensing terms and some scenarios. Could you please give us details (including pricing) for the forthcoming UniObjects pooling mechanism as soon as you are able? That, plus some detailed implementation scenarios, will let everyone on the list understand options in the near future. Regards, Cliff Bill H. wrote: If I figure correctly, a hundred webshares cost $150,000 at $1,500 per webshare retail! Let's see...SQL Server unlimited site license (single CPU) for $5,000. Sounds like this is an invitation to get off the U2 products...or do I have this completely miscalculated? Bill -Original Message- from Leroy Dreyfuss The answer here is RedBack. It is designed for exactly this purpose. We have customers servicing millions of requests per day on a hundred or less Webshares. --- 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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
If I figure correctly, a hundred webshares cost $150,000 at $1,500 per webshare retail! Let's see...SQL Server unlimited site license (single CPU) for $5,000. Sounds like this is an invitation to get off the U2 products...or do I have this completely miscalculated? Bill > -Original Message- from Leroy Dreyfuss > > The answer here is RedBack. It is designed for exactly this > purpose. We have customers servicing millions of requests per > day on a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Base 16, 26, 36
We have a bar-code labeling challenge. We need to print hundreds of unique serialized labels. We have three characters available. I am expecting to do something like Master (pallet): H42 2x MMM H42 is our supplier ID. Box # 1 H42 2x AA0 2x is the six-digit packslip number. Bag # 1 H42 2x AA1 H42 2x AA2 Box # 2 H42 2x AB0 Bag # 1 H42 2x AB1 H42 2x AB2 Z * Z = 26 * 26 = 676. Thus, we could have up to 676 boxes. Thus on a single packing slip, we could have up to 676 boxes each having nine bags. It appears that UniBasic has no built-in functionality (operators) to handle base 26, that is, A thru Z. base 36, A thru Z, and one thru ten. I expect that it could be done, brute force, using arrays and equates. Using Wintegrate, we write a txt-file from UniVerse to Windows. BarTender (Windows-based) prints labels from the txt file. BarTender has some VB functionality that I expect we will be forced to use. I am writing because I do not want to overlook other U2 voodoo which may be available. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]
In a message dated 4/22/2005 7:29:58 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > So, if you use MQ like a connection pool, that is not desirable > performance-wise, and is a breach of your license agreement. But if you use > it for applications to communicate (which is the purpose of MQ), you are > not violating the license agreement. Applications would send messages back > and forth as a result of something a user initiated and wasn't waiting for > an answer. I fill in a form on a web page to view an invoice, I click submit and now I'm waiting for the invoice to pop up. So in this scenario I am waiting for an answer. So is IBM's position that the only valid engine that I can use is Redback? If so, then why weren't the other four providers at Spectrum served with papers? Thanks Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] color laserjet pcl programming for logos
Tom, Thanks for your reply. Playing around late last night, I was able to select the CYAN color option and resolve the problem I had with the graphics. Coincidentally, that color was acceptable and the 2 bit logo mapped into the CMYK pallette with white(0) and cyan(1) just right. Had I wanted another color (beyond color # 1), I would have had to massage the graphics download as you suggested. What a pain. Thanks again for your update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series]
LeRoy, Perhaps I don't fully understand your example, but I don't see the distinction here. If I have a webpage that sends a request to the U2 database (via any method mentioned in this thread) and waits for it's response then goes on with it's own life each web site vistor would only be using the database services for the duration of the request. Now if I have a service (phantom) that is trying to service these web requests it can only service one at a time. Stated another way only one web-user is accessing the database at a time. Are you saying that this violates the license? I can understand your position only if each of the web sessions maintains some kind of persistent connection to the database. A request/response messaging system should not violate the concurrent license restrictions. BTW, thank you for posting in this thread. I don't think I have seen another IBM person respond (if I missed one I apologize) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 Craig, Since MQ is designed to be send and forget technology, and because you can have multiple listeners, there is nothing to stop you, and is, in fact, the purpose of the technology. However, remember that if you are using MQ as a means of users communicating with the database in the scenario you describe, you are using MQ as a de facto connection pool and violating your U2 license agreement if you don't have the equivalent number of U2 licenses that match the interactive users. Regards, LeRoy F. Dreyfuss --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Hold-file to CSV
I created the best of both worlds. I have a preview program that gathers the &HOLD& (PEQS) items and displays the first 5 non-blank lines. When a user chooses an item, the program asks if its going to a TXT file or CSV. If TXT, I simply copy it to that filename verbatim. If CSV, I run it through a parser that makes a good attempt to find the columns (usually one or more columns of spaces, with some allegience to RTRIM instead of just TRIM.) The whole premise is for existing reports so having the key or other datafields wrap is their problem that should have been reported earlier when the output was just going to paper. For new downloads, I have an English parser program whereby you use a regular SSELECT program to filter and sequence and then use a TCL command in the form: DOWNLOAD CUSTOMER NAME ADDRESS CITY STATE ZIP (C:\MAJ\CUST.CSV I know that UD/UV have some magic in their query processor for redirecting to a file, but 50% of my clients are not U2 and by installing my DOWNLOAD utility, everything uses the same syntax (easier for me). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] URL Encoding
FYI. Anything past the first ? will be ignored by the webserver as a URL, but WILL be passed to the .cgi in the environment variable for URL. It will then be up to the .cgi or whatever program, to decode the URL paramters and use them as such. so http://somewebsite.com/foldername is the same URL to the webserver as http://somewebsite.com/foldername?andsomeother?data?to?be?passed?to?a?cgi? or?such PS. It's not good security to have the Password as part of the URL in plain text. >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of David Tod >Sigafoos >Sent: Friday, April 22, 2005 10:15 AM >To: Craig Bennett >Subject: Re[2]: [U2] URL Encoding > > >Craig, > >Thursday, April 21, 2005, 4:28:33 PM, you wrote: > >CB> David, > >CB> if you are doing a POST, shouldn't this bit: > >> API=CustomsCN22&XM > >> L= >> PASSWORD=1919191919191> >>FirstName>JohnSmith > >>XYZ Co > >> rporationSuite >CB> A1234 Etail > >> er Dr.Los >CB> Angeles >> te>CA90052 ... > > >CB> be in the body rather than the url? if you are not sending >any content >CB> in the request (and all the parameters are in the url) you should >CB> probably use GET. > >I had tried both GET and POST. In both cases the url never got >encoded .. as i thought the manuals say > >CB> Off the top of my head maybe you need to: > >CB> addrequestparamter to add API with a value of CustomsCN22 >CB> then to add XML with a value containing your XML string. > >so as i *thought* addrequestparameter is for POST and used to build >the 'parameter'/'value' pairs .. > >CB> Either way, you would think the request process would >check that the url >CB> was correctly encoded. > >yes .. since there is no URLENCODE/URLDECODE commands .. yes you would >think it would do this. > >Thanks i will keep playing with this --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Cliff: > With SQL Server, you also need one or two CAL's (Client > Access Licenses) per named user (not concurrent). Plus I > believe the more full-featured server versions are more > expensive on the server side. A quick look on Google and you'll find an SQL Server Enterprise for $2,000 - $5,000. This product is very inexpensive. It is an unlimited client/device licensing model for a defined number of CPUs. Here's a pretty good whitepaper from Microsoft about the various costs associated with SQL Server, Oracle, and DB2. http://download.microsoft.com/download/1/0/a/10adfeca-48f4-4d89-949a-04167d6 54b40/SQL_UnderstandingDBPricing.doc This gives a small example of a price comparison: Tier Features Sample ProductsPrice Free Limited database Microsoft SQL Desktop $ 0 functionality, Memory Engine (MSDE) Limits, database size limits, etc. Basic Basic database function- MS SQL Server WkGrp Edition$ 500 - ality, Basic security Oracle Std Edition One 5,000 Up to 2 CPUs DB2 Expressper CPU StdFull database function-MS SQL Server Std Edition $5,000 - ality, Basic ManagementOracle Std Edition 15,000 Tools, Up to 4 CPUs DB2 WkGrp Edition per CPU Enterprise High availability MS SQL Server Enterprise $20,000 - Scalability Oracle Enterprise 40,000 High-end mgmt tools DB2 Enterprise per CPU Enterprise security No CPU limit As you can see a basic dbms access model over the web costs about $500 - 5,000 per CPU ! A full featured standard model costs about $5,000 - 15,000 per CPU. Of course, Microsoft products can be purchased from other vendors other than from Microsoft so significant discounts are available. In the above referenced paper, Microsoft also talks about additional costs such as support and service packs. Very interesting reading. > I am confident IBM is well aware of MS SQL and Oracle server > and client DB licensing models since DB2 plays in the same space. And they've begun playing. I know way too many people using SQL Server in the small to medium business end of the market to accept the notion that Microsoft stinks. From what I learned it is excellent software at a great price. In fact, I've started using it myself for some conversions we're doing on our application. Now all we have to do is get the U2 products priced reasonably and all the software mvDbms developers have developed over the years can be exposed over the web. :-) Bill > ...Bill H. wrote: > > > If I figure correctly, a hundred webshares cost $150,000 at > > $1,500 per webshare retail! > > > > Let's see...SQL Server unlimited site license (single CPU) > > for $5,000. Sounds like this is an invitation to get off > > the U2 products...or do I have this completely miscalculated? > > > > Bill > > > > > >>-Original Message- from Leroy Dreyfuss > >> > >>The answer here is RedBack. It is designed for exactly this > >>purpose. > >>We have customers servicing millions of requests per day on > >>a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Base 16, 26, 36
Here's a link to similar discussion in CDP a number of years ago. There you'll find a couple programs and what may be a one-liner *nix solution. http://groups-beta.google.com/group/comp.databases.pick/browse_frm/thread/c c9509f274c79134/c40d80cdc7e46bad (may need to be sewn together if your mail reader breaks it up) HTH Tony [EMAIL PROTECTED] .com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Base 16, 26, 36
Take a look at this small program... 0001 FOR I = 0 TO 625 0002 A=INT(I/26) ; B=MOD(I,26) ; C=MOD(A,26) 0003 PRINT I,CHAR(65+C),CHAR(65+B) 0004 NEXT I It will map the numbers from 0 to 625 into AA to ZZ. -- Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, April 22, 2005 11:54 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Base 16, 26, 36 We have a bar-code labeling challenge. We need to print hundreds of unique serialized labels. We have three characters available. I am expecting to do something like Master (pallet): H42 2x MMM H42 is our supplier ID. Box # 1 H42 2x AA0 2x is the six-digit packslip number. Bag # 1 H42 2x AA1 H42 2x AA2 Box # 2 H42 2x AB0 Bag # 1 H42 2x AB1 H42 2x AB2 Z * Z = 26 * 26 = 676. Thus, we could have up to 676 boxes. Thus on a single packing slip, we could have up to 676 boxes each having nine bags. It appears that UniBasic has no built-in functionality (operators) to handle base 26, that is, A thru Z. base 36, A thru Z, and one thru ten. I expect that it could be done, brute force, using arrays and equates. Using Wintegrate, we write a txt-file from UniVerse to Windows. BarTender (Windows-based) prints labels from the txt file. BarTender has some VB functionality that I expect we will be forced to use. I am writing because I do not want to overlook other U2 voodoo which may be available. Suggestions would be appreciated. --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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
What is the definition of a webshare ? Cliff Bennett <[EMAIL PROTECTED]> wrote:Millions (plural) of DB requests per day will require serious infrastructure regardless of middleware platform. Plus there's always the last-day-of-quarter discount with IBM. 8-) With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I believe the more full-featured server versions are more expensive on the server side. I am confident IBM is well aware of MS SQL and Oracle server and client DB licensing models since DB2 plays in the same space. Leroy, thanks for providing some interpretation of current licensing terms and some scenarios. Could you please give us details (including pricing) for the forthcoming UniObjects pooling mechanism as soon as you are able? That, plus some detailed implementation scenarios, will let everyone on the list understand options in the near future. Regards, Cliff Bill H. wrote: > If I figure correctly, a hundred webshares cost $150,000 at $1,500 per > webshare retail! > > Let's see...SQL Server unlimited site license (single CPU) for $5,000. > Sounds like this is an invitation to get off the U2 products...or do I have > this completely miscalculated? > > Bill > > >>-Original Message- from Leroy Dreyfuss >> >>The answer here is RedBack. It is designed for exactly this >>purpose. We have customers servicing millions of requests per >>day on a hundred or less Webshares. > > --- > 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/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
SQL Server fans, To be fair, UniVerse and UniData aren't just Datastores, they are environments. SQL Server is a starting point. So, if you want to buy SQL server, and buy or freeware a programing language, and buy or freeware a scripting language, and buy or freeware an editor, etc... then you can compare them. Additionally, SQL Server forces you to work exclusively in first normal form, which is slower, creates bloated (comparatively) data storage, and less flexible. U2 is certainly not the cheapest solution, neither is it the most expensive. If cost is the issue, there are databases that are even cheaper than SQL Server. I've used MyBase for some small projects (no cost to redistribute). Still, after 20 years, I find that U2, jBASE, OpenInsight, and all the other multivalues end up cheaper than cobbling together tools that aren't optimized for each other. - Chuck "Been Flat, Didn't Like It" Barouch Bill H. wrote: >Cliff: > > >>With SQL Server, you also need one or two CAL's (Client >>Access Licenses) per named user (not concurrent). Plus I >>believe the more full-featured server versions are more >>expensive on the server side. >> >> > >A quick look on Google and you'll find an SQL Server Enterprise for $2,000 - >$5,000. This product is very inexpensive. It is an unlimited client/device >licensing model for a defined number of CPUs. > >Here's a pretty good whitepaper from Microsoft about the various costs >associated with SQL Server, Oracle, and DB2. > >http://download.microsoft.com/download/1/0/a/10adfeca-48f4-4d89-949a-04167d6 >54b40/SQL_UnderstandingDBPricing.doc > >This gives a small example of a price comparison: > >Tier Features Sample ProductsPrice >FreeLimited database Microsoft SQL Desktop $ 0 > functionality, Memory Engine (MSDE) > Limits, database size > limits, etc. > >Basic Basic database function- MS SQL Server WkGrp Edition$ 500 - > ality, Basic security Oracle Std Edition One 5,000 > Up to 2 CPUs DB2 Expressper CPU > >StdFull database function-MS SQL Server Std Edition $5,000 - > ality, Basic ManagementOracle Std Edition 15,000 > Tools, Up to 4 CPUs DB2 WkGrp Edition per CPU > >Enterprise High availability MS SQL Server Enterprise $20,000 - >Scalability Oracle Enterprise 40,000 >High-end mgmt tools DB2 Enterprise per CPU >Enterprise security >No CPU limit > >As you can see a basic dbms access model over the web costs about $500 - >5,000 per CPU ! A full featured standard model costs about $5,000 - 15,000 >per CPU. Of course, Microsoft products can be purchased from other vendors >other than from Microsoft so significant discounts are available. In the >above referenced paper, Microsoft also talks about additional costs such as >support and service packs. Very interesting reading. > > > >>I am confident IBM is well aware of MS SQL and Oracle server >>and client DB licensing models since DB2 plays in the same space. >> >> > >And they've begun playing. I know way too many people using SQL Server in >the small to medium business end of the market to accept the notion that >Microsoft stinks. From what I learned it is excellent software at a great >price. In fact, I've started using it myself for some conversions we're >doing on our application. > >Now all we have to do is get the U2 products priced reasonably and all the >software mvDbms developers have developed over the years can be exposed over >the web. :-) > >Bill > > > >>...Bill H. wrote: >> >> >> >>>If I figure correctly, a hundred webshares cost $150,000 at >>>$1,500 per webshare retail! >>> >>>Let's see...SQL Server unlimited site license (single CPU) >>>for $5,000. Sounds like this is an invitation to get off >>>the U2 products...or do I have this completely miscalculated? >>> >>>Bill >>> >>> >>> >>> -Original Message- from Leroy Dreyfuss The answer here is RedBack. It is designed for exactly this purpose. We have customers servicing millions of requests per day on a hundred or less Webshares. >--- >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] Uniobjects in a Citrix environment
I have had no problem with running UinObjects with UniVerse. There was some issues with device licensing in early releases of UniVerse. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 22 April 2005 9:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] Uniobjects in a Citrix environment Has anyone implemented this ? Any advice/comments appreciated jak --- 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/