AW: [U2] UniVerse 10.2
Hi Mike, This is what I understood from last years DB2 conference in Orlando: Yes, web services use SOAP and XML over http. The new SOAP server in UniVerse 10.2 should offer both and expose it as a standard web service. It even supports WSDL, a language to describe a web service to a client program similar to a dictionary describing the structure of a data file. E. g. Visual Studio can use this information and generate a nice view of all the methods that the web service offers and their parameters. So it will be easy to access UniVerse from a .NET application across the internet. On the backend, standard UniBasic subroutines are called. Even complex multiattributed/multivalued parameters are possible and can be mapped to XML structures, so that the client (e.g. Java or .NET) can handle complex data sets returned from a UniBasic subroutine natively. There will be a graphical tool to set up the definitions and mappings for the web service. SQL Server 2005 supports .NET programs as stored procedures, so this one should also be able to act as a client. It can store the multivalued data retrieved from a UniVerse system natively in XML format. The new SOAP server is highly anticipated by us. Forget about ODBC, SQL, UniObjects and all the other normalized or non standard solutions using proprietary communication protocols. Klaus -Urspr|ngliche Nachricht- Von: Mike Dallaire [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 15. Februar 2006 20:19 An: u2-users@listserver.u2ug.org Betreff: [U2] UniVerse 10.2 It has been mentioned that with the release of version 10.2 there will be a web services development tool available in UniVerse. To clarify, would that be the much anticipated SOAP server? Thanks, Mike Mike Dallaire Programmer IBM Certified Solutions Expert - U2 UniVerse V9.6 Administrator for Unix and Windows Mortgage Builder Software Inc. (248) 304-0600 x 103 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
AW: [U2] UniVerse 10.2
Mark, They announcement at the conference was for August 2006. I do not remember if it was beta availability or final shipment. Also this has been scheduled some months ago, so I would take it only as a rough estimation. Klaus -Urspr|ngliche Nachricht- Von: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 16. Februar 2006 14:17 An: u2-users@listserver.u2ug.org Betreff: RE: [U2] UniVerse 10.2 snip Yes, web services use SOAP and XML over http. The new SOAP server in UniVerse 10.2 should offer both and expose it as a standard web service. /snip Klaus, was there any indication on a release date for UV 10.2? Or is it a 'real soon now' thing... :) --- 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/
AW: [U2] CC encrypting for unidata
UniData and UniVerse offer native encryption, have a look at this recently published developerWorks article: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0601winter/ -Urspr|ngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 15. Februar 2006 08:01 An: u2-users@listserver.u2ug.org Betreff: SV: [U2] CC encrypting for unidata Dana, have a look at ENCRYPT() and DIGESET() functions in the manual. /Bjvrn -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Dana Baron Skickat: den 14 februari 2006 22:39 Till: u2-users@listserver.u2ug.org Dmne: [U2] CC encrypting for unidata Anyone have or know of software to encrypt credit card numbers in Unidata. (Probably someone has already asked this on this list - sorry) Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
AW: [U2] U2 and MAC
Should not be a problem: AIX on ppc is a tier one platform for UniVerse/UniData. -Urspr|ngliche Nachricht- Von: Claus Derlien [mailto:[EMAIL PROTECTED] Gesendet: Montag, 23. Januar 2006 10:37 An: u2-users@listserver.u2ug.org Betreff: SV: [U2] U2 and MAC mac os x is based on bsd, but remember that its a ppc processor, so you will need the version of universe/unidata compiled for a ppc, or wait until os x is released on an intel platform. best regards from denmark Claus Derlien --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Bad news from Microsoft
MSDE is replaced with the upcoming release of Microsoft SQL Server 2005. It is now called SQL Server 2005 Express and it is FREE! It is limited to 1 CPU, 1 GB Ram and 4GB Database size. Although it is just a better way of marketing MSDE, I would consider this as a thread to U2. Especially for those of us, that develop some kind of standard software with U2 and also target smaller customer sizes, as we do. See also: http://www.microsoft.com/sql/spotlight/expandsqlserver.mspx -Klaus -Urspr|ngliche Nachricht- Von: Kritan [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 23. Oktober 2005 07:17 An: u2-users@listserver.u2ug.org Betreff: [SPAM] - RE: [U2] Bad news from Microsoft - Sender blacklisted Its called SQL MSDE (Desktop Edition). It has been available for several years for free. It doesn't come with the SQL Analyzer or Enterprise Manager so its a bit harder to manage than a purchased copy. U2 has been around and going strong while its been available, so I doubt a new release will have much of an effect. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, October 21, 2005 11:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Bad news from Microsoft From what I understand, this has been available for a while already. They are just releasing an update. I don't think this is that much of a concern to us. At least I don't consider it that much MORE of a concern. Your mileage may very, of course. Bob W --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 10/21/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 10/21/2005 --- 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/
AW: [U2] [UV][OT]Embed command in CSV file?
Barry, Instead of using CSV, you could use SLK Format (Symbolic Link Format). It is slightly more work to format the data, but you have total control about cell formatting. You also get your cell types correctly, e.g. a date is formatted as a date and not as a string. Even formulas are possible. And the nice thing about it is, that it is pure ASCII. Not a binary format like .XLS. -Klaus -Urspr|ngliche Nachricht- Von: Barry Brevik [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 20. Oktober 2005 20:05 An: U2-users (E-mail) Betreff: [U2] [UV][OT]Embed command in CSV file? A little off-topic... From universe, I am creating a sequential file which is formatted as a CSV file, in other words each field is quoted and separated from each other by commas, for example: John,Jacob,Dingleheimer Schmidt The intent is that the resulting file is opened with Excel. You can force any cell into multiple lines by embedding a CHAR(10), for example: WRITESEQ \John,Jacob,Dingleheimer\:CHAR(10):\Schmidt\ TO MY.CSV.FILE THEN NULL ...when viewed in Excel will give you... JohnJacobDingleheimer Schmidt ...which is a great way of expressing multi-values. Finally I arrive at the crux. When you open such a document in Excel, it only displays one line per row even if a cell in that row contains multiple lines. To see all lines you have to select all and hit FORMAT | ROW | AUTOFIT. My users seem to be incapable of dealing with that, so... ...does anyone know if it is possible to embed some kind of command in a CSV file that will get Excel to autofit those rows automatically? Barry Brevik --- 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] Lock Management (was part of 'Good Programming Practice')
My whole point in the original posting is, that many application programmers do not even think about correct locking sequences, transactions and deadlock avoidance. All they do is make sure that the record is locked while updating. This is not enough! As part of a Good Programming Practice I would recommend to Put your files in a sequence and always lock them in that sequence! In my example that would mean: Always lock the header before you lock the detail. Otherwise you are in trouble with deadlocks and most probably you will not even realize it when testing. I give you another example of how using transaction processing makes things even worse: - Program one writes a record to a journal, then updates a balance in another file. - Program two first updates the balance, then writes the journal. So far, everything is fine. As locks are released immediately, no danger of deadlocks. Then you introduce transaction processing and put the step of writing the journal and updating the balance into one transaction. Unfortunately locks are not released within a transaction until the whole transaction is finished (committed). So what happens is: - Program one writes to the journal. The lock is kept even after the write, because you are in a transaction. - Program two writes to the balance file. The lock is also kept because of the transaction. - Program one tries to obtain the lock on the balance file. - Program two tries to obtain the lock on the journal. - Deadlock! Conclusion: If you put your files into a sequence and only lock (update) them in that sequence, you do not even need to think about all this. You never get in any troubles, even when making your application transactional. So this should be worth thinking about when training new programmers for good coding style. -Urspr|ngliche Nachricht- Von: David Tod Sigafoos [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 29. September 2005 17:53 An: Serguei Betreff: Re[2]: AW: [U2] Good Programming Practice Question. Serguei, Thursday, September 29, 2005, 8:04:07 AM, you wrote: S There is no reason to lock details if the header is locked (you would S not want two users to modify the same invoice). So the correct S procedure is not to lock details at all. '... So the correct procedure ...' G What problem does this cause? IF the locks are placed and removed correctly there is no problem. I would agree that it is easier to simply lock the header but only if you can guarantee that this will IN ALL SITUATIONS handle the entire set. Should be .. could be .. maybe .. Sometimes, as a consultant, I might do this (belt and suspenders) because of the state of the code and programming style that the 'employees' (monkeys) have exibited in the system does not give me any confidence that they will correctly respect lock 'sets' that way. dsig --- 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/
AW: [U2] Integrating .NET and UniVerse 10
Hi Simon At DB2 Information Management Conference, IBM announced a new extension to UniVerse: U2 Soap Server. It is definitely the way to go for integration with .NET. As it fully supports WSDL, it plugs very nicely into Visual Studio 2003/2005. And Service Oriented Architecture (SOA) is the future! The only disadvantage: It takes until August 2006 until it is available as part of UniVerse 10.2. But maybe IBM gives you an early version for beta testing? Give it a try! Regards, Klaus Ewinger -Urspr|ngliche Nachricht- Von: Simon Jackson [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 20. September 2005 01:25 An: u2-users@listserver.u2ug.org Betreff: [U2] Integrating .NET and UniVerse 10 Hi All, We are looking at integrating our UniVerse 10 system with applications written in .NET, particularly ASP.NET. We are currently evaluating five mechanisms for accessing UniVerse data: * UVODBC * RedBack * PDP.NET (http://www.rainingdata.com/products/connect/dotnet/index.html) * MV.NET (http://bluefinity.com/) * UniConduit (http://www.conduitit.hostecom.com/Products.htm) Does anyone have any experience with these products that would be useful for us to know? Thanks. Regards Simon Jackson [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
