Re: [U2] Getting daily data from SAP from Universe
John, you can create one generic routine that can execute any BCI query. I could probably dig one out given a bit of notice (next week, when I get home from Japan). Call is something like: RESULT = BCI(DSN, USERID, PASSWORD, SQLQUERY) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows
If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
Here's a Basic routine I use in UD: SUBROUTINE QUICKSORT(ARRAY) *** Quick Sort the elements of a dynamic array EQU AM TO CHAR(254) VALUES = DCOUNT(ARRAY,AM) IF VALUES = 1 THEN RETURN PIVOT = ARRAY1;** First element HIGHSTRING = ''; ** list of elements pivot LOWSTRING = ''; ** list of elements pivot FOR X = 2 TO VALUES ELEMENT = ARRAYX IF ELEMENT PIVOT THEN HIGHSTRING-1 = ELEMENT END ELSE LOWSTRING-1 = ELEMENT END NEXT X CALL QUICKSORT(LOWSTRING) CALL QUICKSORT(HIGHSTRING) ARRAY = IF LOWSTRING # THEN ARRAY-1 = LOWSTRING IF PIVOT # THEN ARRAY-1 = PIVOT IF HIGHSTRING # THEN ARRAY-1 = HIGHSTRING RETURN === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === You are in a maze of twisty subroutines, all alike! === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 9:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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] Basic SORT() Function not avail in UniVerse?
Baker Off the top of my head: FUNCTION SortArray(InArray, AllowDups) Dc = DCount(InArray,@FM) OutArray = '' For I = 1 To Dc Locate InArrayI In OutArray By AL Setting Pos Then If AllowDups Then Ins InArrayI Before OutArrayPos End Else Ins InArrayI Before OutArrayPos End Next Return(OutArray) Then add DEFFUN SortArray(InArray, AllowDups) to your calling routine. Brian Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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] converting from UniVerse on Redhat Linux to UniVerse on Windows
Brenda: If I understand correctly, your managers know little of IT while your IT know little about the business; they just trust each other. As a result, most of your managers and IT want that massive 99% of your IT, that is little related to your core business, to swallow up the 1% of your IT that is the core of the business. I wonder if an MBA would have taught me this neat trick, or maybe this explains about outsourcing. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Tuesday, July 22, 2008 5:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- 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] static/dynamic file(s) opinions wanted!
I have always preferred dynamic files. In the long run, they are easier to deal with. You should still determine the best block size. Also, if you are going to bulk load it, you should set the min mod so that it does not start splitting right off the bat. You still want the basic size to be accurate if you can determine that up front. That being said, there is the nasty blink error (backward link). The only time I have seen these were in a vendor's proprietary index files, but when we got them, the file was worthless. Fortunately, since they were not data, we could rebuild these files. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Tuesday, July 22, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] static/dynamic file(s) opinions wanted! hey all, I have heard bad things about using dynamic files versus hashed/static ones. Can anyone share any thoughts on which is better (in particular on a system where the files grow at a fairly steady rate). I always understood that dynamic files were best on files that did not change that much that fast as the constant need to resize would outweigh the manual effort of resizing the files manually (or with a program). I am looking for insight (or where to find some insight) on universe and best file practices (right now I am reading the system description manual and its helping but lacks insights that I am sure some of the old pickies on here have) so any thoughts/suggestions/ideas/comments are welcomed! thanks dougc ps universe 10.1 and aix 5.2 --- 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] Basic SORT() Function not avail in UniVerse?
Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/
[U2] RE: Basic SORT() Function not avail in UniVerse?
John - me too, when I can. In this case I'm reading in a mv list of other record ID's. They are likely in order, but its imperative that they are, so the SORT is a precaution, since 'stuff' happens. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:44 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? When I need an array to be sorted, I always build it that way using the LOCATE command with the BY option. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/
RE: [U2] Basic SORT() Function not avail in UniVerse?
Thank you Bill, Brian Norman, If I'm allowed to deploy a separate Function or Sub you've virtually coded it for me. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
Thanks WOL, A colleague also directed me to PickWiki and the thoughts on SORT there are a good read, and show the options. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 22, 2008 10:53 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? Look on PickWiki - there are several sort routines there. Of course, I'd recommend the SHELL sort :-) NB - which version of UV are you using - it's long fixed but there's a nasty bug in the COMPARE function in 9.6. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
Baker, In that case, I do not think there is exactly what you want (or not one I know of). I would write a simple subroutine to do this, and write it such that you can just plug it in where ever you need it, including (and maybe most importantly), into a Dict. Pass it several arguments (like the raw data, what the delimiter is (FM, VM, etc), and such) so that it can be reused anywhere. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 1:35 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? John - me too, when I can. In this case I'm reading in a mv list of other record ID's. They are likely in order, but its imperative that they are, so the SORT is a precaution, since 'stuff' happens. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:44 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? When I need an array to be sorted, I always build it that way using the LOCATE command with the BY option. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] static/dynamic file(s) opinions wanted!
We use dynamic files no problem - yes I suppose in certain circumstances there is an overhead, but it would still be faster than a badly sized static file. The conclusion we have is if you are really on top of your file sizes and administrating things daily there is probably less need for dynamic files. If however you have hundreds of accounts and files then dynamic files are easier to admin and hence probably faster in the long term. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 22 July 2008 16:36 To: u2-users@listserver.u2ug.org Subject: [U2] static/dynamic file(s) opinions wanted! hey all, I have heard bad things about using dynamic files versus hashed/static ones. Can anyone share any thoughts on which is better (in particular on a system where the files grow at a fairly steady rate). I always understood that dynamic files were best on files that did not change that much that fast as the constant need to resize would outweigh the manual effort of resizing the files manually (or with a program). I am looking for insight (or where to find some insight) on universe and best file practices (right now I am reading the system description manual and its helping but lacks insights that I am sure some of the old pickies on here have) so any thoughts/suggestions/ideas/comments are welcomed! thanks dougc ps universe 10.1 and aix 5.2 --- 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 - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
One thing I would say on this is never presume - experiment - I have been stung in the past when using remove on the dynamic array portion of a dimensioned array - turned out to be faster to have the whole thing dynamic.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 22 July 2008 18:26 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] static/dynamic file(s) opinions wanted!
Thanks for the info, so you do any maintenance on the files or does universe do a good job maintaining the files? The reason I ask is that we resized all our files back in DEC (using fitzgerald and long's fast tool) and our nightly process went from finishing @6am to @3am and we are now back to 6am finish times, since I get a daily report of processing time I was able to watch it creeping Now I know that there are a lot more items to process but my gut feeling is that the files are in need of resizing but since they are dynamic maybe I am wrong dougc __ Information from ESET NOD32 Antivirus, version of virus signature database 3288 (20080722) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows
Actually 99% of our business data and logic is contained on the Universe database but 90% of the fluff that connects to it is in windows. This has created a problem in that the majority of personnel dedicated to the fluff far exceeds the number of personnel dedicated to UV, and there's power in numbers. The problem Brenda is talking about started just before I started with the company and caused us to loose the manager and a couple of other UV programmers. Unfortunately I came in during the middle of it with a signed contract that said I wouldn't leave for at least a year. I had to learn their applications very rapidly and finally found that everything that went wrong was due to screwed up cross reference files that had multiple entries making the reports all come out with double or triple entries. The data was not wrong it was just reporting wrong. I created programs to rebuild the cross reference files, tested the reports for accuracy, and was happy to tell the new manager that the problem was fixed when he walked in the door. I celebrated my 10th year with the company in May. You tell me, how difficult would it be to convert close to 40 GB of data in thousands of files all of which have multi-valued and some sub-multi-valued data, to SQL Server tables. Plus over 4000 programs to access, manipulate, display, or print the data. -- From: Brenda Price [EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- 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] static/dynamic file(s) opinions wanted!
Files that grow at a controlled rate and especially files that could exceed 2G are good candidates for dynamic files. Files that are cleared, or files that have masses of data loaded or removed from them, are not. Work files, for example, can be a horrible use of dynamic files. As was stated earlier, it's crucial that the original block size of the dynamic file be set properly, otherwise the file could split way too often. On Tue, Jul 22, 2008 at 1:02 PM, Symeon Breen [EMAIL PROTECTED] wrote: We use dynamic files no problem - yes I suppose in certain circumstances there is an overhead, but it would still be faster than a badly sized static file. The conclusion we have is if you are really on top of your file sizes and administrating things daily there is probably less need for dynamic files. If however you have hundreds of accounts and files then dynamic files are easier to admin and hence probably faster in the long term. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 22 July 2008 16:36 To: u2-users@listserver.u2ug.org Subject: [U2] static/dynamic file(s) opinions wanted! hey all, I have heard bad things about using dynamic files versus hashed/static ones. Can anyone share any thoughts on which is better (in particular on a system where the files grow at a fairly steady rate). I always understood that dynamic files were best on files that did not change that much that fast as the constant need to resize would outweigh the manual effort of resizing the files manually (or with a program). I am looking for insight (or where to find some insight) on universe and best file practices (right now I am reading the system description manual and its helping but lacks insights that I am sure some of the old pickies on here have) so any thoughts/suggestions/ideas/comments are welcomed! thanks dougc ps universe 10.1 and aix 5.2 --- 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 - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
Hey, and don't forget to do a speed test. You know, because LOCATE is coded as part of the OS it just *might* be faster than bubble or speed sort options. In fact, this was a topic on this list about 3 or 4 years ago and someone doing the speed test concluded LOCATE was in fact faster. And no I don't remember who it was, or have a link to the thread (sorry) :-) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:26 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows
Your doomed. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Tuesday, July 22, 2008 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows Actually 99% of our business data and logic is contained on the Universe database but 90% of the fluff that connects to it is in windows. This has created a problem in that the majority of personnel dedicated to the fluff far exceeds the number of personnel dedicated to UV, and there's power in numbers. The problem Brenda is talking about started just before I started with the company and caused us to loose the manager and a couple of other UV programmers. Unfortunately I came in during the middle of it with a signed contract that said I wouldn't leave for at least a year. I had to learn their applications very rapidly and finally found that everything that went wrong was due to screwed up cross reference files that had multiple entries making the reports all come out with double or triple entries. The data was not wrong it was just reporting wrong. I created programs to rebuild the cross reference files, tested the reports for accuracy, and was happy to tell the new manager that the problem was fixed when he walked in the door. I celebrated my 10th year with the company in May. You tell me, how difficult would it be to convert close to 40 GB of data in thousands of files all of which have multi-valued and some sub-multi-valued data, to SQL Server tables. Plus over 4000 programs to access, manipulate, display, or print the data. -- From: Brenda Price [EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- 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/
RE: [U2] static/dynamic file(s) opinions wanted!
Symeon, In today's world of faster and faster processors with more and more disk space, we always use dynamic files for transactions based records and static for code files or files that have little growth. We work in both Unidata and Universe and find they both have drawback and pluses which would take pages and pages to hash out the differences. Resizing on static files if the are used as described above ends up being a annual or semi-annual task. Dynamic files for Universe, we resize on a bimonthly basis. Unidata files are resized on a monthly basis. We rarely see a slow down in any of our client sites, since we are on top of our clients file systems. [ad] Of course, we use our own resizing tool based on the www.eclipse.org tool. It is the only new tool that resizes both Unidata and Universe files fast and effectively. This tool supports multiple accounts and multiple customers simultaneously without the need to download anything software on their machines. You can run this tool from any machine that has Eclipse installed on it. So if you like Mac's or Linux, and even Windows you can use our tool. [/ad] Regards, Doug www.u2logic.com - Original Message - From: Symeon Breen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: 07/22/2008 3:02 PM Subject: RE: [U2] static/dynamic file(s) opinions wanted! We use dynamic files no problem - yes I suppose in certain circumstances there is an overhead, but it would still be faster than a badly sized static file. The conclusion we have is if you are really on top of your file sizes and administrating things daily there is probably less need for dynamic files. If however you have hundreds of accounts and files then dynamic files are easier to admin and hence probably faster in the long term. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 22 July 2008 16:36 To: u2-users@listserver.u2ug.org Subject: [U2] static/dynamic file(s) opinions wanted! hey all, I have heard bad things about using dynamic files versus hashed/static ones. Can anyone share any thoughts on which is better (in particular on a system where the files grow at a fairly steady rate). I always understood that dynamic files were best on files that did not change that much that fast as the constant need to resize would outweigh the manual effort of resizing the files manually (or with a program). I am looking for insight (or where to find some insight) on universe and best file practices (right now I am reading the system description manual and its helping but lacks insights that I am sure some of the old pickies on here have) so any thoughts/suggestions/ideas/comments are welcomed! thanks dougc ps universe 10.1 and aix 5.2 --- 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 - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- 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/
RE: [U2] converting from UniVerse on Redhat Linux to UniVerse o n Windows
OnGroup.com has a product for this sort of thing. While I have not worked with OnWare, the concept reminds me of a thing in the real estate world called a Bridge Loan. It is like I have a house to sell, I buy another house before I sell the first house, pay two mortgages and then get a third mortgage to help pay for the first two mortgages. Of course, I can barely afford the first mortgage. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of JPB-U2UG Sent: Tuesday, July 22, 2008 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows Actually 99% of our business data and logic is contained on the Universe database but 90% of the fluff that connects to it is in windows. This has created a problem in that the majority of personnel dedicated to the fluff far exceeds the number of personnel dedicated to UV, and there's power in numbers. The problem Brenda is talking about started just before I started with the company and caused us to loose the manager and a couple of other UV programmers. Unfortunately I came in during the middle of it with a signed contract that said I wouldn't leave for at least a year. I had to learn their applications very rapidly and finally found that everything that went wrong was due to screwed up cross reference files that had multiple entries making the reports all come out with double or triple entries. The data was not wrong it was just reporting wrong. I created programs to rebuild the cross reference files, tested the reports for accuracy, and was happy to tell the new manager that the problem was fixed when he walked in the door. I celebrated my 10th year with the company in May. You tell me, how difficult would it be to convert close to 40 GB of data in thousands of files all of which have multi-valued and some sub-multi-valued data, to SQL Server tables. Plus over 4000 programs to access, manipulate, display, or print the data. -- From: Brenda Price [EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- 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/
Re: [U2] Getting daily data from SAP from Universe
Ray, that would be appreciated At the moment i am hesitating on going down this path as its seems like a redundant technology given its verbosity Also a bit of a learning curve compared to say making Universe accessible to SQL queries . 2nd problem is actually getting access to SAP table names, data definitions etc. The only known i have at the moment is that they can send me spreadsheets but i dont like this as a solution for daily data. jak - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, July 22, 2008 5:16 PM Subject: Re: [U2] Getting daily data from SAP from Universe John, you can create one generic routine that can execute any BCI query. I could probably dig one out given a bit of notice (next week, when I get home from Japan). Call is something like: RESULT = BCI(DSN, USERID, PASSWORD, SQLQUERY) --- 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] static/dynamic file(s) opinions wanted!
To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3289 (20080722) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 3289 (20080722) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Use video conversation to talk face-to-face with Windows Live Messenger. http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_ Refresh_messenger_video_072008 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
We had the same issue back in the 90's. So a clever guy (Ed) that worked with us wrote a small C program (on Unix) to do the sort. This also included controlling/dependants fields. Any universe program could call it, passing in the variables and returned the items sorted. Speed is incredible. To this day it's still used and blitzes any universe program methods in sorting large arrays. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 23 July 2008 6:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Hey, and don't forget to do a speed test. You know, because LOCATE is coded as part of the OS it just *might* be faster than bubble or speed sort options. In fact, this was a topic on this list about 3 or 4 years ago and someone doing the speed test concluded LOCATE was in fact faster. And no I don't remember who it was, or have a link to the thread (sorry) :-) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:26 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 279 2555 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting daily data from SAP from Universe {Unclassified}
John 2nd problem is actually getting access to SAP table names, data definitions etc. As I understand it, the SAP Table names are in SAP (German) code, and the column names are in SAP code. Then there is another set of tables - also named in SAP code, of course - which provide translations between the SAP column names and insert name of your installed language(s). Oh, yes, it's as complicated as heck. That's how SAP consultants make all their money, and why you need them. The data may be more easily accessible in something like SAP BW, provided you bought that. The only known I have at the moment is that they can send me spreadsheets Which are possibly produced by a point-and-click GUI, so the user will have no idea of the underlying data structures. Or by some customised ABAP reporting, see 'SAP Consultants' above. The easiest and most cost effective mechanism may even be to read in, parse and consume the spreadsheets. Sorry Regards Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] static/dynamic file(s) opinions wanted!
Ray, is there any problem to doing this while people are logged in and might write to the file Assuming the file is not in common jak - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 23, 2008 9:09 AM Subject: RE: [U2] static/dynamic file(s) opinions wanted! Occasionally RESIZE filename * * * is a good thing to do with dynamic files. This re-packs each group, consolidating fragmented free space (from deleted/reduced records) in (at the end of) each group buffer. It may, if you're lucky, also bring some groups out of overflow. Dynamic files do not, of themselves, re-pack groups in normal operation unless by doing so they would avoid extending the group into overflow. - Original Message - From: Doug Chanco [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] static/dynamic file(s) opinions wanted! Date: Tue, 22 Jul 2008 18:25:50 -0400 Thanks Kevin but I am still missing something, if dynamic files are well dynamic why would one need to resize them and how would one know what to resize them to? I am sorry if this is basic stuff but I come from a jBASE world and have never really used dynamic files. --- 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] static/dynamic file(s) opinions wanted!
RESIZE filename * * * CONCURRENT USING tempdirpath will be fine even if the dynamic hashed file is open in COMMON. Make sure that the combination tempdirpath/filename is less than 128 characters long. They have put a deal of work into making CONCURRENT safe over the years. Any bad press you read is probably old. It's still true that you should avoid INPLACE at all costs, especially for dynamic files! - Original Message - From: John Kent [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] static/dynamic file(s) opinions wanted! Date: Wed, 23 Jul 2008 09:48:50 +1000 Ray, is there any problem to doing this while people are logged in and might write to the file Assuming the file is not in common jak - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 23, 2008 9:09 AM Subject: RE: [U2] static/dynamic file(s) opinions wanted! Occasionally RESIZE filename * * * is a good thing to do with dynamic files. This re-packs each group, consolidating fragmented free space (from deleted/reduced records) in (at the end of) each group buffer. It may, if you're lucky, also bring some groups out of overflow. Dynamic files do not, of themselves, re-pack groups in normal operation unless by doing so they would avoid extending the group into overflow. - Original Message - From: Doug Chanco [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] static/dynamic file(s) opinions wanted! Date: Tue, 22 Jul 2008 18:25:50 -0400 Thanks Kevin but I am still missing something, if dynamic files are well dynamic why would one need to resize them and how would one know what to resize them to? I am sorry if this is basic stuff but I come from a jBASE world and have never really used dynamic files. --- 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/
[U2] [uv] Secure Sockets / SSL
I'm trying to write some software to send e-mail to a mail server. I would like to encrypt the connection using SSL or TLS. Could someone point me in the direction of documentation or example code that I could look at to get started with this. It's all very new to me, and I'm not getting anywhere with the Universe documentation. For example, where do I start? I know that my Exchange server supports TLS encryption, and that when I connect, the traffic is unencrypted until I issue the STARTTLS command. Can I switch from an unencrypted connection to an encrypted connection on the fly? TIA C. Michael Pflugfelder | Systems Manager | Keystone Information Systems, Inc. | 856-722-0700 | [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv] Secure Sockets / SSL
Why re-invent the wheel when there are plenty of commerical SSL/TLS packages out there already? Such as SecureBlackBox suite (there are plenty more out there)...they have downloadable trialware code examples, etc. http://www.eldos.com/sbb/net-ssl.php Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: Wednesday, 23 July 2008 12:53 PM To: u2-users Subject: [U2] [uv] Secure Sockets / SSL I'm trying to write some software to send e-mail to a mail server. I would like to encrypt the connection using SSL or TLS. Could someone point me in the direction of documentation or example code that I could look at to get started with this. It's all very new to me, and I'm not getting anywhere with the Universe documentation. For example, where do I start? I know that my Exchange server supports TLS encryption, and that when I connect, the traffic is unencrypted until I issue the STARTTLS command. Can I switch from an unencrypted connection to an encrypted connection on the fly? TIA C. Michael Pflugfelder | Systems Manager | Keystone Information Systems, Inc. | 856-722-0700 | [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/