Re: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Dean Fox
What people are doing is through special programs and queuing where they can run several users continuously with several background processes that stay active. This is what IBM has frowned upon. - My brain wiring doesn't allow me to separate this scenario from real life either. None

RE: [U2] Unidata dynamic file problem

2005-04-18 Thread Alfke, Colin
See the section: File Corruption in the Administering UniData on Unix manual. They don't really get into the specifics of the errors - just the techniques to find and correct problems. There is also some good information on the U2 Survival CD. Hth Colin Alfke Calgary, Canada -Original

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread David Jordan
I have not heard of a single legal case in the IT world, not just the MV market, brought by a DBMS vendor against a VAR/developer for abuse of this common communications design. I think any company that does so would be committing political suicide, if it allowed its developer base to go so long

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Alfke, Colin
Much dittoing I know there have been some changes in the recent versions of U2 to try to prevent the type of multi-plexing that IBM really had a problem with - the use of (unlicensed) phantoms to service these requests. Current versions require phantoms to use a license if they perform

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread David Jordan
Hi Dean I have gone through a number of detailed sessions with Microsoft on issues of Piracy and Microsoft regards improper licensing of database licenses in the same light as running one version of Word on multiple PCs. In my estimation there are probably more companies who have run into

Re: [U2] Hold-file to CSV

2005-04-18 Thread Mark Johnson
How can Basic be limiting. It has everything English (sic) has and so much more. In fact, there are many reports that 'turn the corner' and cannot be done in English and must be done in Basic. - Original Message - From: Dave S [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent:

RE: [U2] Clarification on FOR...NEXT loops

2005-04-18 Thread Pingilley, Ron
Jeff, UV/UD do not keep track of which multi-value was last accessed. Only the attribute. Each iteration of the For-Next had to start counting from the beginning of attribute 1 according to your notes below. If you re-run your test with FOR/NEXT/I (instead of 1,I) you should see a

Re: [U2] Hold-file to CSV

2005-04-18 Thread Dave S
Is it simpler to change the sort sequence in basic or English ? Is it simple to add subtotals in basic or English ? Is it easier to export data in basic or English ? Mark Johnson [EMAIL PROTECTED] wrote: How can Basic be limiting. It has everything English (sic) has and so much more. In fact,

Re: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Dean Fox
I'm not shooting the messenger. My apologies. What Microsoft says about their licensing they can take up with the EU and other criminal charges they have and will continue to answer too. It's is a separate issue unrelated to my discussion about IBM and their product. As is copyright violation,

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Dave S
Could you elaborate on this issue ? breaches on SQL Server license David Jordan [EMAIL PROTECTED] wrote: I have not heard of a single legal case in the IT world, not just the MV market, brought by a DBMS vendor against a VAR/developer for abuse of this common communications design. I think

Re: [U2] Hold-file to CSV

2005-04-18 Thread u2
[EMAIL PROTECTED] wrote: Is it simpler to change the sort sequence in basic or English ? Why should it make any difference? EXECUTE SELECT is your friend :-) Is it simple to add subtotals in basic or English ? Don't jump to conclusions. Given my data, do subtotals even make sense? Is it

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Glen B
The gotcha there, is the fact that you *know* that 500 employees are using the DBMS simultaneously via 2 seats. If you said, I _know_ that no more than 10 employees are using the software at any given moment and I have 10 licenses to justify that, then there would be no problem. Whether or not

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Dave S
Piracy would mean installing and using an unlicensed software product. Piracy and multiplexing are not the same issue. David Jordan [EMAIL PROTECTED] wrote: Hi Dean I have gone through a number of detailed sessions with Microsoft on issues of Piracy and Microsoft regards improper licensing of

RE: [U2] Hold-file to CSV

2005-04-18 Thread George Gallen
as well, You will need to know which column is a key, if any, and if there are mulitple lines for a column, is it because it's a multivalue, or did the previous line need to wrap? Also, do you have totals that are being broken on? and are they displayed at the bottom of each page? George

RE: [U2] Hold-file to CSV

2005-04-18 Thread Paul Trebbien
Hi Mark, I note you're from Comcast - they used to run use the DataFlo ERP system. I met Comcast employees in 2002 at the Epicor Users Group conference in Minnesota. I believe Comcast has switched to E by Epicor. Anyway, possibly if you still have wIntegrate you can use the

RE: [U2] Hold-file to CSV

2005-04-18 Thread Stevenson, Charles
From: Mark Johnson How can Basic be limiting. It has everything English (sic) has and so much more. In fact, there are many reports that 'turn the corner' and cannot be done in English and must be done in Basic. If you will stipulate that - generally speaking - the most important attribute

RE: [U2] IBM Licensing Requirement

2005-04-18 Thread Wendy Smoak
Tony Gravagno wrote: I'd also like to get some real numbers on the table. Some people say you can get 10 users on a single license. Anyone who has implemented a multi-user environment knows this isn't the case because, as stated above, the first user will connect and you'll have 9

RE: [U2] Pro's/cons of keeping UV maint/support contract current (paid)

2005-04-18 Thread Maresh, Mel
I've used QM at a 6-user site for 2 years. The site was converted from R83. I found few problems in converting, and these may all be gone as it now supports A S dictionaries and other things that I had to change. It has options to make locates, wildcards the like flavor specific. I've been

[U2][UD] JDBC connection

2005-04-18 Thread Chauhan, Savita
I am trying to connect to UniData (on AIX) from my PC through a java program. This is how I am trying to connect: String url = jdbc:ibm-u2://server.college.edu/the/acct/path;dbmstype=UNIDATA; Class.forName(com.ibm.u2.jdbc.UniJDBCDriver); Connection con = DriverManager.getConnection(url, john,

[U2] Decoding 64Base string

2005-04-18 Thread David Tod Sigafoos
I am looking for information on decoding a base64 string. We will be receiving this back with an xml stream from a client. The base64 string is a image which we must decode and write out. Anyone having done this? Would love to talk to you about it or possibly get snippets to get us on our way.

RE: [U2][UD] JDBC connection

2005-04-18 Thread Kevin King
Check your webserver configuration. Just because you can login w/ telnet doesn't mean the webserver is open to that dir. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Monday, April 18, 2005 11:13 AM To:

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Bill H.
Somehow or other this thread points out issue(s) mvDbms vendors need to come to grips with. I got onto google and entered SQL Server site license and picked the first link I saw and found out I could get a single processor SQL Server Standard license for $3,500 (or a single processor SQL Server

RE: [U2][UD] JDBC connection

2005-04-18 Thread Chauhan, Savita
I am not connecting thru a webserver. I am trying to directly connect to UniData machine. This is my first attempt to connect thru java. So please let me know what settings do I have to look for and where? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] [UV] Release 3.2 of the SRS_UV_HEADER program now available

2005-04-18 Thread Gyle Iverson
Hello, Tony. The SRS.UV.HEADER program is nearly public domain. Anyone can do anything they want with the source code. All I ask is that they distribute the source code and keep the attributions. A license is not required where conscience will suffice. Best regards, Gyle Tony Gravagno says:

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Marc Harbeson
The legal run around would be write a transaction interface for MV to SQL, and float a SQL processor license solution on the web side... At this point you think why do I want to even use a U2 backend? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill

[U2] Re: Decoding Base64 String

2005-04-18 Thread Jeff Schasny
Go here: http://www.fourmilab.ch/webtools/base64/ Freeware command line base64 encoder/decoder Quoting David Tod Sigafoos [EMAIL PROTECTED]: I am looking for information on decoding a base64 string. We will be receiving this back with an xml stream from a client. The base64 string is a

[U2] Please, Be Kind Trim

2005-04-18 Thread TPellitieri
Just a reminder to be kind and trim your replies to the relevant portions of prior posts. I just received the second digest for today, which contained just 12 new messages. Several contained the full text (including posting footers) of three prior messages. Some people on the list still have to

RE: [U2] Decoding 64Base string

2005-04-18 Thread Rex Gozar
Universe has the ENCODE function. When I tried using it last, it seemed to encode my data into base64 just fine, but decoding always gave me an empty string. Eventually, I just wrote my own encoding/decoding functions from documentation off the www. rex --- u2-users mailing list

RE: [U2][UD] JDBC connection

2005-04-18 Thread Chauhan, Savita
Hi All, Thanks for any help. Just to let you all know, I got my program working. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Monday, April 18, 2005 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UD] JDBC

Re: [U2][UD] JDBC connection

2005-04-18 Thread Ian Renfrew
Mind sharing the solution in the event others encounter the same or similiar issue in the future. As Dawn M. Wolthuis, would say 'Take and give some delight today.' Regards, Ian Renfrew - Original Message - From: Chauhan, Savita [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent:

Re: [U2] Re: Decoding Base64 String

2005-04-18 Thread David Tod Sigafoos
Jeff, Monday, April 18, 2005, 11:59:00 AM, you wrote: JS Go here: http://www.fourmilab.ch/webtools/base64/ JS Freeware command line base64 encoder/decoder oh man .. thanks .. i think G .. c .. uuu JS Quoting David Tod Sigafoos [EMAIL PROTECTED]: I am looking for information on decoding

RE: [U2][UD] JDBC connection

2005-04-18 Thread Chauhan, Savita
Sure. My url string was wrong: String url =jdbc:ibm-u2://server.college.edu/the/acct/path;dbmstype=UNIDATA; It shd have been String url =jdbc:ibm-u2://server.college.edu//the/acct/path;dbmstype=UNIDATA; It needed two slashes (/) between the server (server.college.edu) and the account path

RE: [U2] Decoding 64Base string {Unclassified}

2005-04-18 Thread HENDERSON MIKE, MR
If you're on UniVerse and on release 10.x (UD 6.x may have the same functionality, check the IBM reference manuals, for UV it's in the Basic Extensions manual) then you should be able to use the ENCODE() function. Your code might look a bit like this: E.DLOC = '1' ; * data

Re: [U2] Decoding 64Base string

2005-04-18 Thread Craig Bennett
David, I am looking for information on decoding a base64 string. We will be receiving this back with an xml stream from a client. The base64 string is a image which we must decode and write out. what version of U2 are you on? What O/S? UV 10.0 and later allows you to call ALG = Base64 ACTION = 2

Re: [U2] Hold-file to CSV

2005-04-18 Thread Mark Johnson
To answer your specific questions, no, no, no. Once designed, basic can do everything that English can, albiet the afterthought changes may be more difficult. We all strive towards getting as many reports from English (sic) as possible. That's obvious. Surely you recognize when you 'turn the

Re: [U2] Hold-file to CSV

2005-04-18 Thread Mark Johnson
Thanks. - Original Message - From: Paul Trebbien [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, April 18, 2005 11:22 AM Subject: RE: [U2] Hold-file to CSV Hi Mark, I note you're from Comcast - they used to run use the DataFlo ERP system. I met Comcast employees in

Re: [U2] Hold-file to CSV

2005-04-18 Thread Mark Johnson
I got good at writing English-like Basic programs (sorting, break-on, totals, id-supp, det-supp etc) 20 years ago with large files and very slow systems. Basic can generate multiple simultaneous (not just consecutive, simultaneous) reports and having gotten some good experience that way, in

Re: [U2] Hold-file to CSV

2005-04-18 Thread Mark Johnson
Thanks for the critique. I have access to virtually all of the procs or basic that creates these client's reports. It always comes down to money with my clients, not pure technology. Thus, Re-directing their existing hold-files puts basic and English on the same playing field. It's a lot easier

[U2] Solonde Warehouse Workbench for u2

2005-04-18 Thread Rosenberg Ben
A friend of mine is evaluating ETL tools that might be useful for developing and maintaining an MS-SQL-based data warehouse where one major data source is u2-based. My friend is probably going to use DTS (recently renamed as SSIS in MS-SQL-2005), and is also evaluating some well known tools such