[U2] Interesting interview with Susie
All Here is an interesting interview with Susie about how things are now with U2 and Rocket. It's given by Elkie Holland of Prospectus: http://www.prospectus.co.uk/t/SusieSiegesmundMarch10.htm Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Microsoft SQL Server Driver Support
The U2 team at Rocket Software announces a renewed focus on improving SQL interfaces to the UniData and UniVerse data servers. Microsoft SQL Server Driver Support Starting with the November release of UniData on Windows, the Rocket U2 team will deliver and support the Microsoft SQL Server driver for External Database Access (EDA) on Windows platforms. The same driver is available now in the Early Adopter release of UniVerse 11. To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell us what database you're using when you do so. External Database Access (EDA) is required in order to use the SQL Server Driver. EDA is available for Workgroup and Server edition and is included with Enterprise edition of the databases. Common Mapping Tool and Schema Generator In addition, we are in the early planning stages for an improved, common mapping tool and schema generator for fully describing the U2 data model in order to generate SQL and EDA schemas. This new tool will provide a modern, extensible interface for both initial mapping as well as updating of schemas. This tool, with its associated APIs, will improve deployment of ISV solutions to end customer sites thereby saving time and speeding time to market. This tool will be available with UniVerse 11.1 and in a UniData 7.3 release to follow. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse on Windows 2003 Server - Environment
Have you checked the physical server itself to make sure there are no resource intensive events around the time it fails? One of our EDI applications services running in a virtual server will hang when a backup/hardware intensive event is triggered on the physical server. I am glad to hear you guys are having success with UniVerse on a virtual server, we're planning on moving to a virtual environment this year (probably a 2003 virtual server running on a physical 2008 server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Roosa Sent: Tuesday, March 02, 2010 7:38 AM To: U2 Users List Subject: Re: [U2] UniVerse on Windows 2003 Server - Environment There are a couple of other applications on that server and I did disable MySQL yesterday. The other one is NiceLabel but I can't just disable that as we are using it to handle printing labels all day long. The plan is to start with MySQL and see if that helps. It's really no longer used (at least that's what they tell us) but the service was still running. Thanks. On Mon, Mar 1, 2010 at 7:14 PM, Bill Haskett wphask...@advantos.net wrote: Mike: You might look for things like SQL Server, Anti-Virus, and other software that does things every day. I've run into installations where SQL Server was installed as some kind of administration tool. Something fired off every hour in SQL Server which brought to (almost) a complete halt telnet responsiveness for several minutes. Once this was identified, I had to identify this since the administrator couldn't, and put off then responsiveness was very acceptable. Windows is very tricky when the dbms is loaded onto a multi-use server (I'm sure the same is true in Linux/Unix). HTH, Bill Mike Roosa said the following on 3/1/2010 10:50 AM: We are running UniVerse on Windows 2003 Server in a virtualized environment. 99% of the time the system runs great and we have no issues, however, about once a day or every other day during the busiest time, we have a period of 2-3 minutes where the server slows down and basically quits responding. Without us taking any action the system begins responding normally again and we usually make it through that day without issue. We typically have around 85 users on the system at one time sometimes that gets up closer to 95 or 100 but not often. I have noticed certain processes that definitely cause the issue like running winmsd from the command line or renaming a directory on the server. Since I know these processes cause the issue I don't do that during the day. Obviously there are other processes that also can cause issues for us. We have worked with our vendor and Rocket and the latest we've gotten from them is that our server is under-resourced. While that very well could be true, we want to do a little more research first and reach out to other Windows/UniVerse users to see what hardware they are running and if anyone is in a virtualized environment. Any help we can get would be appreciated. Thanks Mike Roosa ___ 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
[U2] [UD] Enable Break Key From Separate Port
This will likely get me branded as a crackpot (like it wasn't already a question?) but is there a way on Unidata (from version 6--) to enable the break key from a remote port? Here's the situation: I have some customers that disable the break key for everyone who logs in. I, of course, forget about this until AFTER launching a report that takes for-freakin'-ever to run. At that moment, I would sincerely love to be able to enable the break key on that port. Possible? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Spectrum
Spectrum is just over a month away. Who's in? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Enable Break Key From Separate Port
$UDTBIN/udtbreakon Haven't played with this in decades... From the UniData Commands Reference: udtbreakon Syntax udtbreakon pid Description The system-level udtbreakon command enables the interrupt key from another port. With this capability, users can enter the UniBasic debugger to terminate a program that may be stuck in a loop. pid represents the udt process id on another port for which you enable the interrupt key. Use this command at the system prompt, or use the ECL ! (bang) command to execute this command from the ECL (colon) prompt.Tip: Use the LISTUSER command to find the process ID for which you intend to enable the interrupt key. The process ID for the UniData session is shown in the USRNBR column. Related Commands ON.BREAK, PTERM -BREAK ON Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, March 03, 2010 9:55 AM To: U2 Users List Subject: [U2] [UD] Enable Break Key From Separate Port This will likely get me branded as a crackpot (like it wasn't already a question?) but is there a way on Unidata (from version 6--) to enable the break key from a remote port? Here's the situation: I have some customers that disable the break key for everyone who logs in. I, of course, forget about this until AFTER launching a report that takes for-freakin'-ever to run. At that moment, I would sincerely love to be able to enable the break key on that port. Possible? -Kevin http://www.PrecisOnline.com ___ 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] Examples of working ENCRYPT function?
Larry: This is a customer box, and I don't know if it's there or not, but I'll check. It has to have OpenSSL to work? Bob: So is it true the KEY has to be in hex? I knew the IV and salt were hex but ... the key also? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] AUTOLOGOUT
Have a quick couple of questions on the AUTOLOGOUT function. This is on Red Hat Enterprise Server 5.3, Universe 10.2.7. Is the AUTOLOGOUT function a global setting, or can we use this in just 1 account? For example, we have 2 accounts, PROD and DEV. If we put AUTOLOGOUT 15 in the DEV account, will those people that go to the DEV account be the only ones affected by it? Also, if we have a select or program that is running that takes greater than the 15 minutes in the AUTOLOGOUT, will it kill the process, or wait until it is finished, then start the 15 minutes idle time? Thanks in advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax All generalisations are dangerous, even this one. CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Examples of working ENCRYPT function?
Here's my code to date: * * Test Encryption Program * ALGORITHM= 'rc4' CRYPT.ACTION = 1 TEXT = 'THIS IS A TEST' TEXT.LOC = 1 KEY = 'ABCDEFG' KEY.LOC = 1 KEY.ACTION = 1 SALT = '' IV = '' RESULT = '' RESULTLOC= 1 STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC, KEY.ACTION, SALT, IV, RESULT, RESULTLOC) PRINT 'STATUS= ' : STATUS PRINT 'RESULT= ' : RESULT PRINT 'RESULTLOC = ' : RESULTLOC STOP END And here's what it shows: RUN USER-FORMS TEST.ENCRYPT STATUS= 1 RESULT= RESULTLOC = 1 What am I missing? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Examples of working ENCRYPT function?
I should also mention that the client has confirmed OpenSSL is on the box, and I've tried the key both in plaintext (as shown) and also O-converted via MX, same results. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Examples of working ENCRYPT function?
Bob, I modified my routine to use the same values as your subroutine, and at least on this Unidata box, still no love. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse on Windows 2003 Server - Environment
When you experience the slowdown, check the Task Manager. It is likely you'll see something bad there. If not, you should get the sysinternals code procmon and diskmon. They'll help too, if the problem isn't with the CPU usage. Actually, it's pretty interesting what one finds running on servers these days. :-) Bill Mike Roosa said the following on 3/2/2010 5:37 AM: There are a couple of other applications on that server and I did disable MySQL yesterday. The other one is NiceLabel but I can't just disable that as we are using it to handle printing labels all day long. The plan is to start with MySQL and see if that helps. It's really no longer used (at least that's what they tell us) but the service was still running. Thanks. On Mon, Mar 1, 2010 at 7:14 PM, Bill Haskett wphask...@advantos.net wrote: Mike: You might look for things like SQL Server, Anti-Virus, and other software that does things every day. I've run into installations where SQL Server was installed as some kind of administration tool. Something fired off every hour in SQL Server which brought to (almost) a complete halt telnet responsiveness for several minutes. Once this was identified, I had to identify this since the administrator couldn't, and put off then responsiveness was very acceptable. Windows is very tricky when the dbms is loaded onto a multi-use server (I'm sure the same is true in Linux/Unix). HTH, Bill Mike Roosa said the following on 3/1/2010 10:50 AM: We are running UniVerse on Windows 2003 Server in a virtualized environment. 99% of the time the system runs great and we have no issues, however, about once a day or every other day during the busiest time, we have a period of 2-3 minutes where the server slows down and basically quits responding. Without us taking any action the system begins responding normally again and we usually make it through that day without issue. We typically have around 85 users on the system at one time sometimes that gets up closer to 95 or 100 but not often. I have noticed certain processes that definitely cause the issue like running winmsd from the command line or renaming a directory on the server. Since I know these processes cause the issue I don't do that during the day. Obviously there are other processes that also can cause issues for us. We have worked with our vendor and Rocket and the latest we've gotten from them is that our server is under-resourced. While that very well could be true, we want to do a little more research first and reach out to other Windows/UniVerse users to see what hardware they are running and if anyone is in a virtualized environment. Any help we can get would be appreciated. Thanks Mike Roosa ___ 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] Examples of working ENCRYPT function?
A simple cut'n'paste of your code on UD 7.1.6 windows gives this: STATUS= 0 RESULT= njץCﮥ#¼hP! RESULTLOC = 1 So your code isn't missing anything - it's something in the environment. P.S. the help encrypt does say Both salt and IV must be provided in hexadecimal format. Hth Colin Alfke Calgary, Canada -Original Message- From: Kevin King Here's my code to date: * * Test Encryption Program * ALGORITHM= 'rc4' CRYPT.ACTION = 1 TEXT = 'THIS IS A TEST' TEXT.LOC = 1 KEY = 'ABCDEFG' KEY.LOC = 1 KEY.ACTION = 1 SALT = '' IV = '' RESULT = '' RESULTLOC= 1 STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC, KEY.ACTION, SALT, IV, RESULT, RESULTLOC) PRINT 'STATUS= ' : STATUS PRINT 'RESULT= ' : RESULT PRINT 'RESULTLOC = ' : RESULTLOC STOP END And here's what it shows: RUN USER-FORMS TEST.ENCRYPT STATUS= 1 RESULT= RESULTLOC = 1 What am I missing? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Examples of working ENCRYPT function?
Kevin, Your key isn't really a key -- RC4 is a 128 bit encryption algorithm, which requires a 128 bit key. If you change the KEY.ACTION to 2 (generate a real key from the passphrase), you should get different results. You can (and should) use a long passphrase made up of pseudo-random numbers, upper- and lower-case letters and symbols to make your encryption more difficult to crack. You can also set CRYPT.ACTION to 2 to have the ENCRYPT() function base64 encode the result, so that it's safe to store in the database. Otherwise, you could end up with attribute, value or sub-value marks in your encrypted string. Use CRYPT.ACTION = 4 to base64 decode before decrypting. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, March 02, 2010 7:57 AM To: U2 Users List Subject: Re: [U2] Examples of working ENCRYPT function? Here's my code to date: * * Test Encryption Program * ALGORITHM= 'rc4' CRYPT.ACTION = 1 TEXT = 'THIS IS A TEST' TEXT.LOC = 1 KEY = 'ABCDEFG' KEY.LOC = 1 KEY.ACTION = 1 SALT = '' IV = '' RESULT = '' RESULTLOC= 1 STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC, KEY.ACTION, SALT, IV, RESULT, RESULTLOC) PRINT 'STATUS= ' : STATUS PRINT 'RESULT= ' : RESULT PRINT 'RESULTLOC = ' : RESULTLOC STOP END And here's what it shows: RUN USER-FORMS TEST.ENCRYPT STATUS= 1 RESULT= RESULTLOC = 1 What am I missing? ___ 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] Examples of working ENCRYPT function?
Oh Larry, absolutely. My test program was just to see if I could get any results. On 7.1, yes. Pre-7.1, no. So at this point I'm just chalking it up to IBM putting out a turd in Unidata 6. Not like the documentation for this stuff has been the model of accuracy anyway. I would just prefer that going forward, Rocket document current and working features, not something that might come into the product a couple years later. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Enable Break Key From Separate Port
Wally, once again you are my hero. Thanks, man! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Examples of working ENCRYPT function?
FWIW, your program compiled ran fine on UD 6.1 running on SCO OSR5.0.7, with the following output: STATUS= 0 RESULT= _53↨%N`Tf¶j¶l RESULTLOC = 1 Or the following, when I changed CRYPT.ACTION to 2: RUN TEST.BP TEST.CRYPT STATUS= 0 RESULT= X7WzlyXOYNTmlKZqlGw= RESULTLOC = 1 It must be an AIX issue. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, March 03, 2010 11:38 AM To: U2 Users List Subject: Re: [U2] Examples of working ENCRYPT function? Oh Larry, absolutely. My test program was just to see if I could get any results. On 7.1, yes. Pre-7.1, no. So at this point I'm just chalking it up to IBM putting out a turd in Unidata 6. Not like the documentation for this stuff has been the model of accuracy anyway. I would just prefer that going forward, Rocket document current and working features, not something that might come into the product a couple years later. ___ 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] Examples of working ENCRYPT function?
That's good to know Larry, thanks. Yeah, must be AIX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] Essbase or other BI
Greetings, all! We have some new financial folks who think Essbase is the be-all, end-all of financial reporting. We're a 100% UV shop, and we really don't have experience in any type of external reporting functionality yet. I have two general questions: 1. Does Essbase integrate with U2? 2. What other packages are out there that would be comparable? No one has said anything about trying to force us into using Essbase, but we want to be able to talk intelligently about it when it comes up in discussions/meetings. We're going into it with open minds - maybe it is something we would want to use. We just don't know enough to know. I have contacted Oracle to try to get some information, but that was humorous to say the least. At this point, they might get back to me in 2-4 business days. I have also started working with a VAR to see if we can get a dog and pony just for information gathering purposes. I figured I'd ask here as well to see if anyone out there has some real-world info/experience they'd be willing to pass along. Thanks!! Brian F. Paige Manager of Systems Operations Serta International bpa...@serta.com _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Decoding URL in UniBasic
I just ran into something that I'm surprised I haven't run into before. I'm passing some data into a UniBasic subroutine from PHP using UniObjects for Java. When the string contains a single quote or a double quote, it is being escaped. It is sent as 5 Ring but arrives as 5\ Ring. I am encoding it in JavaScript and decoding it in PHP before using UniObjects for Java to send it to the UniBasic subroutine. If I don't decode it in PHP and send it through encoded, is there a way to decode it in UniBasic? Unidata 7.1. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AUTOLOGOUT
Hi Marc, AUTOLOGOUT is session based. Onceit is executed it remains in effect regardless of where the user navigates. Also, the session must be waiting for input from the user for the logout counter to begin. Once the user enters someting as input, the counter stops and starts over only at the next input. Cheers, LeRoy Sent from my iPhone 3Gs On 03 Mar 2010, at 8:03 PM, Caminiti, Marc m...@nashbar.com wrote: Have a quick couple of questions on the AUTOLOGOUT function. This is on Red Hat Enterprise Server 5.3, Universe 10.2.7. Is the AUTOLOGOUT function a global setting, or can we use this in just 1 account? For example, we have 2 accounts, PROD and DEV. If we put AUTOLOGOUT 15 in the DEV account, will those people that go to the DEV account be the only ones affected by it? Also, if we have a select or program that is running that takes greater than the 15 minutes in the AUTOLOGOUT, will it kill the process, or wait until it is finished, then start the 15 minutes idle time? Thanks in advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax All generalisations are dangerous, even this one. CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Decoding URL in UniBasic
Hi Charles: Try: VALUE = CHANGE(VALUE,'\','') Regards, Doug www.u2logic.com XLr8Editor for U2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, March 03, 2010 3:03 PM To: U2 Users List Subject: [U2] Decoding URL in UniBasic I just ran into something that I'm surprised I haven't run into before. I'm passing some data into a UniBasic subroutine from PHP using UniObjects for Java. When the string contains a single quote or a double quote, it is being escaped. It is sent as 5 Ring but arrives as 5\ Ring. I am encoding it in JavaScript and decoding it in PHP before using UniObjects for Java to send it to the UniBasic subroutine. If I don't decode it in PHP and send it through encoded, is there a way to decode it in UniBasic? Unidata 7.1. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Decoding URL in UniBasic
Hi Charles, Just to add to Doug, I'll assume you are encoding '\' as '\\' well? Otherwise you would have no way to send the string '\' without it being (incorrectly) decoded as just ''. If this is the case, don't forget to SWAP '\\' with '\' before you fix up the rest. So it should look something like: VALUE = CHANGE(VALUE,'\\','\') VALUE = CHANGE(VALUE,'\','') VALUE = CHANGE(VALUE,\',') Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Thursday, 4 March 2010 10:48 AM To: 'U2 Users List' Subject: Re: [U2] Decoding URL in UniBasic Hi Charles: Try: VALUE = CHANGE(VALUE,'\','') Regards, Doug www.u2logic.com XLr8Editor for U2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, March 03, 2010 3:03 PM To: U2 Users List Subject: [U2] Decoding URL in UniBasic I just ran into something that I'm surprised I haven't run into before. I'm passing some data into a UniBasic subroutine from PHP using UniObjects for Java. When the string contains a single quote or a double quote, it is being escaped. It is sent as 5 Ring but arrives as 5\ Ring. I am encoding it in JavaScript and decoding it in PHP before using UniObjects for Java to send it to the UniBasic subroutine. If I don't decode it in PHP and send it through encoded, is there a way to decode it in UniBasic? Unidata 7.1. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Essbase or other BI
From: Brian F. Paige 1. Does Essbase integrate with U2? As I've mentioned in my blog and in forums, U2 can connect to anything - don't let anyone convince you otherwise. One of the biggest things holding the MV market back is that even people who use and love the platform have an overwhelming tendency to wonder whether the system can actually do things that are advertised elsewhere. Sure it can! The primary concern for integrating U2 to anything else is how fast you need transaction data reflected in the new environment. That determines whether an interface will be online, offline, or near-line, and that narrows down your selection of tools to be used for integration. For anyone who's curious, here's info on Essbase: http://en.wikipedia.org/wiki/Essbase Side note: What's more interesting to me is how this is defined emphatically as a multidimensional database management system (MDBMS), and this page http://en.wikipedia.org/wiki/Multidimensional_database simply redirects to Online Analytical Processing unless you stop it from doing so. (MV Marketing people should get some clues here... the rest of the world equates MultiDimensional to OLAP while most people in our market don't use the term OLAP in relation to their MV/MD DBMS.) Anyway ... what I get from wikipedia is that Essbase really is nothing more than a database, novel to relational folks but nothing unusual to us. So Essbase Analytics is a pretty GUI on top of a system just like what you have now, just marketed as something special. (Perhaps MV Marketing people will find another clue there.) The important thing is not Essbase itself, but what the pretty GUI provides. And that leads us to an evaluation of functionality... 2. What other packages are out there that would be comparable? What I recommend is that you define specific goals for reporting and then decide if you need extended reporting tools or if you need Business Intelligence. For MV-centric tools you'll find products like MITS from MITS, Informer from Entrinsik, Velocity from Tantiva, DeepSee from InterSystems, and Viságe from Stamina. Some of these are for BI and others reporting... In addition to the more common mainstream offerings, many people like Jasper Reports, but (arguably) that's not BI. I have been very impressed by ClickView and some of our colleagues are integrating MV with it. I'd welcome an opportunity to do so as well. You may also get what you need using off-the shelf development tools like Telerik Reporting (for less than 1k plus development time compared to 50-100k just to start working with some of the others). You'll find many discussions on reporting and BI in the archive for this forum, and in comp.databases.pick. Here is a link to one such thread: http://tinyurl.com/ydx52rd Google using query: group:comp.databases.pick and terms like mits, entrinsik, reporting, etc. Example: group:comp.databases.pick mits group:comp.databases.pick reporting HTH BTW, I used to contract for Serta Corporate back in the early 90's when they were running on Microdata. Fond memories... Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD provides Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Essbase or other BI
In a message dated 3/3/2010 5:15:44 PM Pacific Standard Time, 3xk547...@sneakemail.com writes: Side note: What's more interesting to me is how this is defined emphatically as a multidimensional database management system (MDBMS), and this page http://en.wikipedia.org/wiki/Multidimensional_database simply redirects to Online Analytical Processing unless you stop it from doing so. I've now updated it so it redirs direct to the subsection instead of the top of the page. Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Essbase or other BI
While I completely agree that U2 is totally flexible and easy to interface with - even though U2 is multidimensional it is not an OLAP or BI system. BI solutions are specifically designed to crunch data into a form that will return (usually aggregated) answers across millions of rows in milliseconds. ie What were sales figures for New South Wales in December, for 2007,2008 2009? A user on our BI system (MS SSAS) can drag drop that query and have it answered in a few seconds. The user can add and change filters and parameters on the fly (which categories performed, how much is still outstanding) and the cube will respond instantly. Much of this speed is due to several hours nightly processing which pre-builds the data into optimised aggregates. But it is also the fact that the DBMS itself is highly optimised for the task of data analysis. I just don't think you'd get the RIGHT performance from U2 if you tried to replicate what the BI systems do - U2 is designed for more generalised information and reporting (pun intended). Cheers, Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 4 March 2010 12:16 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Essbase or other BI From: Brian F. Paige 1. Does Essbase integrate with U2? As I've mentioned in my blog and in forums, U2 can connect to anything - don't let anyone convince you otherwise. One of the biggest things holding the MV market back is that even people who use and love the platform have an overwhelming tendency to wonder whether the system can actually do things that are advertised elsewhere. Sure it can! The primary concern for integrating U2 to anything else is how fast you need transaction data reflected in the new environment. That determines whether an interface will be online, offline, or near-line, and that narrows down your selection of tools to be used for integration. For anyone who's curious, here's info on Essbase: http://en.wikipedia.org/wiki/Essbase Side note: What's more interesting to me is how this is defined emphatically as a multidimensional database management system (MDBMS), and this page http://en.wikipedia.org/wiki/Multidimensional_database simply redirects to Online Analytical Processing unless you stop it from doing so. (MV Marketing people should get some clues here... the rest of the world equates MultiDimensional to OLAP while most people in our market don't use the term OLAP in relation to their MV/MD DBMS.) Anyway ... what I get from wikipedia is that Essbase really is nothing more than a database, novel to relational folks but nothing unusual to us. So Essbase Analytics is a pretty GUI on top of a system just like what you have now, just marketed as something special. (Perhaps MV Marketing people will find another clue there.) The important thing is not Essbase itself, but what the pretty GUI provides. And that leads us to an evaluation of functionality... 2. What other packages are out there that would be comparable? What I recommend is that you define specific goals for reporting and then decide if you need extended reporting tools or if you need Business Intelligence. For MV-centric tools you'll find products like MITS from MITS, Informer from Entrinsik, Velocity from Tantiva, DeepSee from InterSystems, and Viságe from Stamina. Some of these are for BI and others reporting... In addition to the more common mainstream offerings, many people like Jasper Reports, but (arguably) that's not BI. I have been very impressed by ClickView and some of our colleagues are integrating MV with it. I'd welcome an opportunity to do so as well. You may also get what you need using off-the shelf development tools like Telerik Reporting (for less than 1k plus development time compared to 50-100k just to start working with some of the others). You'll find many discussions on reporting and BI in the archive for this forum, and in comp.databases.pick. Here is a link to one such thread: http://tinyurl.com/ydx52rd Google using query: group:comp.databases.pick and terms like mits, entrinsik, reporting, etc. Example: group:comp.databases.pick mits group:comp.databases.pick reporting HTH BTW, I used to contract for Serta Corporate back in the early 90's when they were running on Microdata. Fond memories... Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD provides Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** This email message and any files
