RE: [U2] D3 to UD conversion
Dave: Please feel free to post here, or to David directly. I haven't really wanted to irritate anyone on the list here; rather I've tried to just be as helpful as I can to those who can use the help. To such an end, I've been sending a fair number of emails off list. Those who've contacted me directly have been extremely kind and helpful, as has also, of course, been those who've posted publicly. Bill > -Original Message- > From: Dave Taylor [mailto:[EMAIL PROTECTED] > Sent: Friday, March 17, 2006 7:04 PM > To: Bill Haskett > Subject: Fw: [U2] D3 to UD conversion > > Hi Bill, > > Your very helpful comments to me today appeared to be sent > only to me and > not the the list. > > I think they would be most helpful also to David Wolverton > who has been a > part of this conversation in other msgs on the list. > > I would like to forward your comments to David if I have your > permission, > unless you have already done so. > > Please let me know if this would be all right with you. > > I will also mention our TAPE.DUMP and TAPE.LOAD programs and > our desire to > port our generic Pick spooler from Universe to Unidata. > > Thanks, > > Dave Taylor > > > - Original Message - > From: "Wally Terhune" <[EMAIL PROTECTED]> > To: > Sent: Friday, March 17, 2006 4:09 PM > Subject: Fw: [U2] D3 to UD conversion > > > > I know of a U2 partner who used a D3 pseudo drive and wrote > T-DUMP/T-LOAD > > routines to migrate data to UniData. Don't know the details, though. > > > > Wally Terhune > > U2 Support Architect > > IBM Information Management > > 4700 South Syracuse Street, Denver, CO 80237 > > Tel: 303.773.7969 > > Fax: 303.773.5915 > > [EMAIL PROTECTED] > > > > > > - Forwarded by Wally Terhune/Denver/IBM on 03/17/2006 > 05:06 PM - > > > > "David Wolverton" > > <[EMAIL PROTECTED] > > et> > To > > Sent by: > > > [EMAIL PROTECTED] > cc > > stserver.u2ug.org > > >Subject > >[U2] D3 to UD conversion > > 03/17/2006 04:48 > > PM > > > > > > > > > > > > > > > > > > I have a site running D3 Linux that is small, and would benefit from > > WorkGroup pricing - their current annual maintenance in D3 > is the same as > > new IBM UniData Seats will run... > > > > It this strictly a 'media move' - in that I cannot really > use a network or > > file to do the move? > > > > The client is not that big, but the tape drive they have on > their Linux > box > > is not anything I have on my Windows2K3 Server -- > > > > Is there a good way/any to do a Unix File move such that I > make a 'pseudo > > floppy/pseudo tape' on D3 and then take the resulting file > and feed it > into > > UniData's Account Restore process? > > > > One of the reasons I was so keen on Bill's experience was > that it sounded > > like experience I was about to have! > > > > David W. > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > [demime 1.01d removed an attachment of type image/gif which > had a name of > pic01299.gif] > > > > [demime 1.01d removed an attachment of type image/gif which > had a name of > ecblank.gif] > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] D3 to UD conversion
David: Colin Alfke was able to use the UniData "ACCOUNT.RESTORE" utility. He was smart enough to get IBM support and not do this on UD PE. I'm going to purchase a 10 seat copy of UD for development and support this week. :-) With the appropriate D3 backup (the correct block size) data movement should be pretty straightforward. Colin sent me some instructions that I'd be happy to forward to you if you need them. Let me know if I can help. :-) Bill Haskett > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > David Wolverton > Sent: Friday, March 17, 2006 3:48 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] D3 to UD conversion > > I have a site running D3 Linux that is small, and would benefit from > WorkGroup pricing - their current annual maintenance in D3 is > the same as > new IBM UniData Seats will run... > > It this strictly a 'media move' - in that I cannot really use > a network or > file to do the move? > > The client is not that big, but the tape drive they have on > their Linux box > is not anything I have on my Windows2K3 Server -- > > Is there a good way/any to do a Unix File move such that I > make a 'pseudo > floppy/pseudo tape' on D3 and then take the resulting file > and feed it into > UniData's Account Restore process? > > One of the reasons I was so keen on Bill's experience was > that it sounded > like experience I was about to have! > > David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] append ENGLISH.MSG error
I am trying to compile something on Unidata 6.0PE and up until recently it has worked just marvelously. Today, when I try to compile I get this: append ENGLISH.MSG error. Error msgno = 50054. args = file\item p The record 50054 is indeed in ENGLISH.MSG, and I've run guide on ENGLISH.MSG with no errors found, rebooted that machine, and still no love. Any ideas? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Fw: [U2] D3 to UD conversion
I know of a U2 partner who used a D3 pseudo drive and wrote T-DUMP/T-LOAD routines to migrate data to UniData. Don't know the details, though. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 03/17/2006 05:06 PM - "David Wolverton" <[EMAIL PROTECTED] et>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] D3 to UD conversion 03/17/2006 04:48 PM I have a site running D3 Linux that is small, and would benefit from WorkGroup pricing - their current annual maintenance in D3 is the same as new IBM UniData Seats will run... It this strictly a 'media move' - in that I cannot really use a network or file to do the move? The client is not that big, but the tape drive they have on their Linux box is not anything I have on my Windows2K3 Server -- Is there a good way/any to do a Unix File move such that I make a 'pseudo floppy/pseudo tape' on D3 and then take the resulting file and feed it into UniData's Account Restore process? One of the reasons I was so keen on Bill's experience was that it sounded like experience I was about to have! David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of pic01299.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Google _is_ email
Bob Little wrote: > I guess I do prefer the email list setup as opposed to a Google-type thingy. If this question ever does come to some kind of vote, people need to understand what they're voting for and against. Google mail works exactly the same as what we have here, just a different address and no ReplyTo confusion. You do not need to read Google groups in a browser, mail comes to you just like it does now, individually or in digest. Reading forums from a browser is an option for people who want to do so. This is not to express opinion about the topic of changing lists, just to correct what seems to be a common misunderstanding of the options. I'm sure mods will want replies to go to the community list but I'm not subscribed there. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] D3 to UD conversion
I have a site running D3 Linux that is small, and would benefit from WorkGroup pricing - their current annual maintenance in D3 is the same as new IBM UniData Seats will run... It this strictly a 'media move' - in that I cannot really use a network or file to do the move? The client is not that big, but the tape drive they have on their Linux box is not anything I have on my Windows2K3 Server -- Is there a good way/any to do a Unix File move such that I make a 'pseudo floppy/pseudo tape' on D3 and then take the resulting file and feed it into UniData's Account Restore process? One of the reasons I was so keen on Bill's experience was that it sounded like experience I was about to have! David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2] Universe Release Notes for Universe 10.0 or 10.1 for UNIX Servers
http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html About half way down the page. - Original Message - From: "Denny Watkins" <[EMAIL PROTECTED]> To: Sent: Friday, March 17, 2006 2:08 PM Subject: [U2] [u2] Universe Release Notes for Universe 10.0 or 10.1 for UNIX Servers U2er's, I cannot find any Universe Release Notes for Universe 10.0 or 10.1 for Unix servers (ala IBM AIX p-series). The only choice is for AIX POWER. All I see is something like the following for 10.0 UniVerse For Windows NT Release 10.0.0 Release Notes December, 2001 for Universe 10.1.2 UniVerse For Windows NT Version 10.1 Release Notes September, 2003 Are there any Release notes available for just the Unix machines? If so, is there a URL available? Thanks In Advance, Denny Watkins Morningside College Email: [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/
RE: [U2] Excel from Unidata
Mr. Angliss: It seems that there's been some namespace shuffling. To generate binary excel files, use Spreadsheet::SimpleExcel, documented here: http://cpan.uwinnipeg.ca/htdocs/Spreadsheet-SimpleExcel/Spreadsheet/SimpleExcel.html For the new-fangled XML format that Microsoft is moving toward, use Spreadsheet::WriteExcelXML, documented here: http://cpan.uwinnipeg.ca/htdocs/Spreadsheet-WriteExcelXML/Spreadsheet/WriteExcelXML.html Thanks, Michael Doyle Linux Administrator / Developer On Fri, 2006-03-17 at 18:55 +, Piers Angliss wrote: > Dave, > > There were a number of suggestions a few months ago, the more > straightforward were along the lines of "write csv or xml and let Excel sort > it out". If you specifically want a .xls file then Michael Doyle posted : > > On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and > Text::CSV modules. My csv2xls.pl script is only about 47 lines long. > > The Spreadsheet::WriteExcel module was utter garbage a few years ago, > but thanks to the efforts of OpenOffice.org and the obvious benefits of > open source software, the module has improved by leaps and bounds. > > I don't know Perl but Google will probably yield some clues > > hth > > Piers > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor > Sent: 17 March 2006 16:39 > To: u2-users@listserver.u2ug.org > Subject: [U2] Excel from Unidata > > > Hi, > > I'd like to be able to create an excel file from a Unidata program to be > used for download on a website, without any user intervention. > > Can anyone offer any tips/tricks to make this a simple process? > > Thanks, > Dave > > PS: Unidata 6.0 / AIX 5.1 > --- > 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] Changes to the List
So long as it is appreciated, I don't mind putting in the time and I *want* your feedback. this topic started because *I* asked. So, let's keep a good face on it and see if we can't guide the list through another few decades of productive use. - Chuck "History Books" Barouch --- Hi, I'm pretty much a lurker here and still very, very new to U2. I do value the expertise available to me here on these lists, and the time and energy it takes to maintain them. So long as I know how to reply to the list, and how to filter the incoming messages so they go into right folders on my end, I don't care how the lists are set up. Having said that, I guess I do prefer the email list setup as opposed to a Google-type thingy. I don't know /jack squat/ about running a mailing list or a newsgroup, so thank you to you folks who do this work. Bob Little UniVerse Developer Market America, Inc. (336) 478-1694 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Triggers
Ken: ...Original Message... from Ken Wallis > It sounds like you feel exactly the same about UniData as I > did about D3 when I spent a few months contracting at a D3 > shop - antiquated stuff, how can anybody work with this when > xxx is so much better? Yea. There's a lot about D3 that wears on anyone; this explains why a lot of people want to convert. :-) > I'm not sure which MV enhancements you mean, but I suspect > the issue is really one of adapting to looking at things from > a different perspective. I would like to think our "perspective" differences is a basis for product improvement. :-) You should see what Microsoft has done with SQL Server 2005 and their admin tools; an impressive improvement from SQL Server 2000. Raining Data doesn't have the resources to achieve anywhere near this kind of improvement to D3. With IBM, however, one would think they would understand U2 can be improved (mostly to assist conversions and new users). I can only hope IBM will take the attitude that U2 can, and should, be improved to bring in other MV applications and encourage new application development. As always, thanks for your help and kind comments. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Testing for an open PC file!
To All: I have been using WIN.PCOPEN to test to see if a PC file is open by another program. But the routine does not give me an error if a program has a PC file already open. It works if WIN.PCOPEN has already opened a file handle. But not if a PC program has the file open. Is there another way to test if a PC file is open or are there options that I need to set with WIN.PCOPEN?? Thanks in Advance!! _ Frank M. Bright [EMAIL PROTECTED] Administrative Computing University of the Arts (A15) http://www.uarts.edu 215-717-6081(w) Coll 17.0.14 AIX 5.2.0.4 Uni 6.03 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [u2] Universe Release Notes for Universe 10.0 or 10.1 for UNIX Servers
U2er's, I cannot find any Universe Release Notes for Universe 10.0 or 10.1 for Unix servers (ala IBM AIX p-series). The only choice is for AIX POWER. All I see is something like the following for 10.0 UniVerse For Windows NT Release 10.0.0 Release Notes December, 2001 for Universe 10.1.2 UniVerse For Windows NT Version 10.1 Release Notes September, 2003 Are there any Release notes available for just the Unix machines? If so, is there a URL available? Thanks In Advance, Denny Watkins Morningside College Email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AIX and UniData version compatibility for using ENCRYPT() function
We had an issue with encrypt on UniVerse and I am not sure if the same issue exists within UniData. With UniVerse, the IBM encryption routines were incompatible with Windows encryption routines. It was, I believe, found that there was a problem with the IBM version and that the problem had been fixed for a sub.release of 10.1, but I am not sure about UniData. It may be worth checking into prior to deciding to which release you want to migrate. HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caleb Ng Sent: Friday, March 17, 2006 11:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] AIX and UniData version compatibility for using ENCRYPT() function We are currently running UniData 6.0.8 on AIX 5.1 on a 32-bit machine and I'm trying to use the ENCRYPT() function for data encryption. However, I was told that AIX 5.1 doesn't have the underlying OpenSSL libraries for ENCRYPT() to work so I'm trying to decide on an upgrade path. I looked at the compatibility matrix on IBM's site, however, I wanted to get some feedback from current UniData users. Is there any reason not to upgrade to AIX 5.3? What version of 32-bit UniData should I upgrade to? Should I upgrade UniData before AIX or does it matter? Are there any "gotchas" to watch out for when upgrading? I'm basing my assumptions on staying with the latest versions of O/S & UniData but I could be wrong. If anyone has any experience and feedback, I would greatly appreciate it. TIA, Caleb Ng Systems Analyst Sweetwater Authority [EMAIL PROTECTED] (619) 409-6763 --- 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] Excel from Unidata
If you want to try out various delimited formats (CSV, HTML, XML etc) you might want to check out Download from Cedarville: ftp.cedarville.edu/download It's free and simple to use, though it doesn't specifically offer XLS as a format. Otherwise you're into scripting Excel in some way. Brian >Dave, > >There were a number of suggestions a few months ago, the more >straightforward were along the lines of "write csv or xml and let Excel sort >it out". If you specifically want a .xls file then Michael Doyle posted : > > On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and >Text::CSV modules. My csv2xls.pl script is only about 47 lines long. > >The Spreadsheet::WriteExcel module was utter garbage a few years ago, >but thanks to the efforts of OpenOffice.org and the obvious benefits of >open source software, the module has improved by leaps and bounds. > >I don't know Perl but Google will probably yield some clues > >hth > >Piers > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor >Sent: 17 March 2006 16:39 >To: u2-users@listserver.u2ug.org >Subject: [U2] Excel from Unidata > > >Hi, > >I'd like to be able to create an excel file from a Unidata program to be >used for download on a website, without any user intervention. > >Can anyone offer any tips/tricks to make this a simple process? > >Thanks, >Dave > >PS: Unidata 6.0 / AIX 5.1 >--- >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/
FW: [U2] Excel from Unidata
I sent this off-list to Dave since the list strips attachments. If anyone else wants a copy of the 3 subroutines let me know. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 10:49 AM To: Dave Tabor Subject: RE: [U2] Excel from Unidata I do it from Universe all then time using the attached routines. Pass a value mark delimited string for each line of data to HTML.LINE and then just write OUTREC to a directory with a ".xls" extension and Excel will happily open the HTML as a speadsheet. Jeff Schasny | Westminster, CO, USA | [EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel from Unidata
>> From: "Dave Tabor" >> I'd like to be able to create an excel file from a Unidata program >> to be used for download on a website, without any user intervention. Dan Fitzgerald wrote: > I did this once by then tweaking an excel file to look right, and > then ftp'ing it back to the server as a template, then populating it > with data & naming it *.xls. I hope you did a Save As XML and used that as a template rather than poking a binary file? This is probably the best, simple, free way to do Excel, especially if your server is *nix. An alternative these days is called Visual Studio Tools for Office, and allows better programmatic control to create Excel or Word docs without Office even being installed on the system. This can be driven from *nix, but of course the code must reside in Windows - I specialize in this sort of inter-system processing and it's an effective way of using the right tools for the job. One can also use a simple comma or tab-delimited file, which seems to be the standard preference among developers because it's simple. I'm of the opinion, sorry folks, that this just sends a message to end-users that we don't know how to do anything better. The good news is that most end-users have come to accept plain text files from IT as being "Excel", so it's tough to complain. Excel is an amazingly powerful tool that more sophisticateed end-users expect to display colors and formatted fields, properly sized columns, charts and multiple worksheets, etc. Many users (feel free to ask them) will spend days reformatting the CSV data they get from their IT people just so it's presentable to management, investors, etc. What do you do if your end-user wants totals highlighted in bold, errors in red, embedded comments to explain the data, or merged cells show a simple heading? I'm not selling anything here, just encouraging people to get the most use out of the tools available. People usually ask for Excel for a reason - getting flat files is easy but may not respond to the true business requirements. Let's make sure people don't blame our MultiValue technology because we give them text files when they ask for GUI. As an example of some Excel work that I've done, please have a look at this product which is no longer offered, but one of these days I might resurrect part of it. This allows your MV BASIC code to completely drive Excel and create complex workbooks.: http:// removethisNebula-RnD.com/products/analysis.htm Here is an audio/video presentation showing NebulAnalysis in action: http:// removethisNebula-RnD.com/demos/nebulanalysis/ Inquiries are of course welcome but my real point is to look beyond 'simple' and really find out what your users want - they often won't tell you when they're disappointed with things like this, they'll just accept whatever they get, or start looking elsewhere. Tony Nebula Research and Development TG@ remove-this-anti-spam-textNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
Dave, As a founding father(?) I have to point out that the U2-Users list, U2-Community list, SBSolutions list, and RBSolutions lists aren't exactly part of the U2UG. Here's the real facts, just so all are clear: Mike O'Rear ran the list for eight years, on his dime and with his time. When he got tired, the list passed to Clif Oliver. Clif ran it for nine years. Clif offered the lists (Users & Community) to the U2UG to oversee. We don't *own* them, we mind the store on behalf of everyone. For the U2UG to run the lists, we needed help. Fortunately, Larry Hiscock stepped up. SBSolutions started with Kevin King. He, like Clif, entrusted us to mind the store. RBSolutions started with Scott Rau. When Scott's work situation changed, he asked us to mind the store. Larry hosts both of these lists as well. The U2UG doesn't own any of these lists. We are the chosen caretakers. Having said all that, there is a move within the board to form a 'what next' committee. It is possible that what's next will be identical to 'what's now' but it may well go in other directions. Just remember that Larry and I moderate the lists as a volunteer activity. *Separately* from that I also happen to be on the U2UG board - also volunteer. We will do the best we can with the time and tools available. The lists are free (as in liberty) and free (as in beer). Hosting and managing them is free (as in free of payment). So long as it is appreciated, I don't mind putting in the time and I *want* your feedback. this topic started because *I* asked. So, let's keep a good face on it and see if we can't guide the list through another few decades of productive use. - Chuck "History Books" Barouch Dave Tabor wrote: Hi, Referring to the U2UG Charter: Bullet #7 --> "To provide a forum for the promotion of excellence in information processing through recognition of individuals who exemplify the best in our profession in their work utilizing the U2 product line." My thoughts: It would seem to me that the promotion of excellence will not happen, when the provided 'excellence' is in the form of replies to specific users (Reply-To), and remains hidden from the rest of the group (Reply-To-All). --- also --- Bullet #8 --> "To promote the exchange of technical information among U2 users." In my opinion, the exchange of technical information is being exchanged via roadblocks and hidden alleys. --- In conclusion --- I've gotten a lot of great ideas from this list, and am saddened at the fact that I (along with many other newbies) won't see a lot of those, due to people with busy schedules forgetting to click the right button. CHANGE IT BACK, PLEASE!!! --- Questions for the moderators/board --- 1) Did our 'founding fathers' really want it run the way it is currently being run? 2) Shouldn't the current format require the board to do a U2UG Charter rewrite? Thanks for allowing the thoughts of someone who actually learns from the posts on this list! - Dave --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel from Unidata
Dave, There were a number of suggestions a few months ago, the more straightforward were along the lines of "write csv or xml and let Excel sort it out". If you specifically want a .xls file then Michael Doyle posted : On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and Text::CSV modules. My csv2xls.pl script is only about 47 lines long. The Spreadsheet::WriteExcel module was utter garbage a few years ago, but thanks to the efforts of OpenOffice.org and the obvious benefits of open source software, the module has improved by leaps and bounds. I don't know Perl but Google will probably yield some clues hth Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor Sent: 17 March 2006 16:39 To: u2-users@listserver.u2ug.org Subject: [U2] Excel from Unidata Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- 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] Spectrum conference
The database challenge was cancelled, unfortunately. Spectrum was fun, but I'll leave the details of the big news to someone like Nathan or Clif. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Friday, March 17, 2006 11:16 AM To: U2 List Server Subject: [U2] Spectrum conference Did anyone attend the Spectrum conference? I'd love to hear about it. I was also wondering about the outcome of this year's Database Challenge. Thanks! -Dianne --- 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.385 / Virus Database: 268.2.4/283 - Release Date: 3/16/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel from Unidata
Hi Dave, One idea for you would be to use our FusionWare ADO.Net Provider, using ASP.NET, write an application that calls FusionWare ADO.NET to execute a basic program that returns the data. Then Create an instance of the Excel Object and pump the data from the ADO.NET Dataset into the spreadsheet. Save it. Ship it. Janet Bond FusionWare Corporation 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor Sent: Friday, March 17, 2006 8:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] Excel from Unidata Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- 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] U2 Board
That's the last one I received. - Original Message - From: Louie Bergsagel To: Tom Dodds Cc: Jerry Banker ; u2-users@listserver.u2ug.org Sent: Friday, March 17, 2006 11:18 AM Subject: Re: [U2] U2 Board I received notification in 2005, but not this year. The last email I received was the following: Dana Baron <[EMAIL PROTECTED]> to u2-users More optionsFeb 2 For those of you on this list who are U2UG members, you should be receiving instructions for voting in this year's board election soon. Due to "technical difficulties" (mostly caused by me), the election has been delayed. Stay tuned! Thanks for your patience, Dana Baron U2UG Nominations & Elections - Show quoted text - On 3/17/06, Tom Dodds <[EMAIL PROTECTED]> wrote: I am in the same position, I think. Hard to tell sometimes if I am a member or not. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, March 17, 2006 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 Board Did everybody know that we recently had a U2UG board election? I remember seeing that nominations were open back in November but nothing since. The website says the elections are open but in truth the elections are over, even the runoffs. I'm a member of the U2UG but I had no notification that the election was on, that there was a runoff, and now no notification of whom is on the board. Jerry --- 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] Spectrum conference
Did anyone attend the Spectrum conference? I'd love to hear about it. I was also wondering about the outcome of this year's Database Challenge. Thanks! -Dianne --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 Board
*Probably. **":)* *Maybe a little more humor or humour would do us all good...* On 3/17/06, Dave Tabor <[EMAIL PROTECTED]> wrote: > > Think they forgot to click 'Reply-to-all'? > (Sorry... my conscience lost on this one!) > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of leslie > chamberlin > Sent: Friday, March 17, 2006 12:47 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] U2 Board > > > That's the last I heard also. -Leslie Chamberlin > > -Original Message- > > I received notification in 2005, but not this year. The last email I > received was the following: > > Dana Baron<[EMAIL PROTECTED]> to u2-users > More options Feb 2 > For those of you on this list who are U2UG members, you should be > receiving > instructions for voting in this year's board election soon. Due to > "technical difficulties" (mostly caused by me), the election has been > delayed. Stay tuned! > > Thanks for your patience, > > > Dana Baron > U2UG Nominations & Elections > - Show quoted text - > --- > 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] AIX and UniData version compatibility for using ENCRYPT() function
Openssl can be downloaded and compiled from here: http://www.openssl.org/ If you dont have a C compiler you can always get the compiled binaries from here: http://aixpdslib.seas.ucla.edu/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Caleb Ng Sent: Friday, March 17, 2006 10:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] AIX and UniData version compatibility for using ENCRYPT() function We are currently running UniData 6.0.8 on AIX 5.1 on a 32-bit machine and I'm trying to use the ENCRYPT() function for data encryption. However, I was told that AIX 5.1 doesn't have the underlying OpenSSL libraries for ENCRYPT() to work so I'm trying to decide on an upgrade path. I looked at the compatibility matrix on IBM's site, however, I wanted to get some feedback from current UniData users. Is there any reason not to upgrade to AIX 5.3? What version of 32-bit UniData should I upgrade to? Should I upgrade UniData before AIX or does it matter? Are there any "gotchas" to watch out for when upgrading? I'm basing my assumptions on staying with the latest versions of O/S & UniData but I could be wrong. If anyone has any experience and feedback, I would greatly appreciate it. TIA, Caleb Ng Systems Analyst Sweetwater Authority [EMAIL PROTECTED] (619) 409-6763 --- 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.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Board
Think they forgot to click 'Reply-to-all'? (Sorry... my conscience lost on this one!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of leslie chamberlin Sent: Friday, March 17, 2006 12:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 Board That's the last I heard also. -Leslie Chamberlin -Original Message- I received notification in 2005, but not this year. The last email I received was the following: Dana Baron<[EMAIL PROTECTED]> to u2-users More options Feb 2 For those of you on this list who are U2UG members, you should be receiving instructions for voting in this year's board election soon. Due to "technical difficulties" (mostly caused by me), the election has been delayed. Stay tuned! Thanks for your patience, Dana Baron U2UG Nominations & Elections - Show quoted text - --- 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] Changes to the List
Hi, Referring to the U2UG Charter: Bullet #7 --> "To provide a forum for the promotion of excellence in information processing through recognition of individuals who exemplify the best in our profession in their work utilizing the U2 product line." My thoughts: It would seem to me that the promotion of excellence will not happen, when the provided 'excellence' is in the form of replies to specific users (Reply-To), and remains hidden from the rest of the group (Reply-To-All). --- also --- Bullet #8 --> "To promote the exchange of technical information among U2 users." In my opinion, the exchange of technical information is being exchanged via roadblocks and hidden alleys. --- In conclusion --- I've gotten a lot of great ideas from this list, and am saddened at the fact that I (along with many other newbies) won't see a lot of those, due to people with busy schedules forgetting to click the right button. CHANGE IT BACK, PLEASE!!! --- Questions for the moderators/board --- 1) Did our 'founding fathers' really want it run the way it is currently being run? 2) Shouldn't the current format require the board to do a U2UG Charter rewrite? Thanks for allowing the thoughts of someone who actually learns from the posts on this list! - Dave --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Board
That's the last I heard also. -Leslie Chamberlin -Original Message- I received notification in 2005, but not this year. The last email I received was the following: Dana Baron<[EMAIL PROTECTED]> to u2-users More options Feb 2 For those of you on this list who are U2UG members, you should be receiving instructions for voting in this year's board election soon. Due to "technical difficulties" (mostly caused by me), the election has been delayed. Stay tuned! Thanks for your patience, Dana Baron U2UG Nominations & Elections - Show quoted text - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] AIX and UniData version compatibility for using ENCRYPT() function
We are currently running UniData 6.0.8 on AIX 5.1 on a 32-bit machine and I'm trying to use the ENCRYPT() function for data encryption. However, I was told that AIX 5.1 doesn't have the underlying OpenSSL libraries for ENCRYPT() to work so I'm trying to decide on an upgrade path. I looked at the compatibility matrix on IBM's site, however, I wanted to get some feedback from current UniData users. Is there any reason not to upgrade to AIX 5.3? What version of 32-bit UniData should I upgrade to? Should I upgrade UniData before AIX or does it matter? Are there any "gotchas" to watch out for when upgrading? I'm basing my assumptions on staying with the latest versions of O/S & UniData but I could be wrong. If anyone has any experience and feedback, I would greatly appreciate it. TIA, Caleb Ng Systems Analyst Sweetwater Authority [EMAIL PROTECTED] (619) 409-6763 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 Board
I received notification in 2005, but not this year. The last email I received was the following: Dana Baron<[EMAIL PROTECTED]> to u2-users More options Feb 2 For those of you on this list who are U2UG members, you should be receiving instructions for voting in this year's board election soon. Due to "technical difficulties" (mostly caused by me), the election has been delayed. Stay tuned! Thanks for your patience, Dana Baron U2UG Nominations & Elections - Show quoted text - On 3/17/06, Tom Dodds <[EMAIL PROTECTED]> wrote: > > I am in the same position, I think. Hard to tell sometimes if I am a > member > or not. > > Tom Dodds > [EMAIL PROTECTED] > 708-234-9608 Office > 630-235-2975 Cell > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, March 17, 2006 10:05 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] U2 Board > > Did everybody know that we recently had a U2UG board election? I remember > seeing that nominations were open back in November but nothing since. The > website says the elections are open but in truth the elections are over, > even > the runoffs. I'm a member of the U2UG but I had no notification that the > election was on, that there was a runoff, and now no notification of whom > is > on the board. > Jerry > --- > 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] Excel from Unidata
I did this once by then tweaking an excel file to look right, and then ftp'ing it back to the server as a template, then populating it with data & naming it *.xls. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: "Dave Tabor" <[EMAIL PROTECTED]> To: Subject: [U2] Excel from Unidata Date: Fri, 17 Mar 2006 11:39:11 -0500 Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- 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] U2 Board
I am in the same position, I think. Hard to tell sometimes if I am a member or not. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, March 17, 2006 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 Board Did everybody know that we recently had a U2UG board election? I remember seeing that nominations were open back in November but nothing since. The website says the elections are open but in truth the elections are over, even the runoffs. I'm a member of the U2UG but I had no notification that the election was on, that there was a runoff, and now no notification of whom is on the board. Jerry --- 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] U2 Board
I received notification of all those events. Richard - Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: Sent: Friday, March 17, 2006 11:04 AM Subject: [U2] U2 Board > Did everybody know that we recently had a U2UG board election? I remember > seeing that nominations were open back in November but nothing since. The > website says the elections are open but in truth the elections are over, even > the runoffs. I'm a member of the U2UG but I had no notification that the > election was on, that there was a runoff, and now no notification of whom is > on the board. > Jerry > --- > 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] Excel from Unidata
Hi, I'd like to be able to create an excel file from a Unidata program to be used for download on a website, without any user intervention. Can anyone offer any tips/tricks to make this a simple process? Thanks, Dave PS: Unidata 6.0 / AIX 5.1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2 Board
Did everybody know that we recently had a U2UG board election? I remember seeing that nominations were open back in November but nothing since. The website says the elections are open but in truth the elections are over, even the runoffs. I'm a member of the U2UG but I had no notification that the election was on, that there was a runoff, and now no notification of whom is on the board. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Conversion from D3
I'll second Ken's opinion. We converted our application from D3 to UniData about 10 years ago. We converted approx 30 clients. Everybody was really happy. You just have to look at some things differently. No slight intended here Bill but I believe you did this all with the PE version and no IBM involvement. This no doubt added to the pain. Of course, an on the ball IBM rep *should* have contacted you... I know you've told me about the world of difference in support you've been getting from MS with VS and SQL (though you didn't say if you actually purchased those ;-) You also seem "pushed" from D3 rather than "pulled" to UniData - that might also be part of the issue. When we converted we had a UniData account UCONV3 on aix that had a number of utilities that I believe we used. I have documentation on it in my UniData manual (circa version 3.6.5?) but haven't seen anything on it since. Perhaps IBM should get on top of this before Tony convinces everyone to move to Jbase ;-) In Bill's defence: UniData does have a Pick compatibility mode - note I said Pick and not D3. It doesn't have some of the "enhancements" done in the last 15-20 years - like still needing quotes around item id's in UniQuery statements. Also UniQuery's sub-totalling on det-supp reports leaves something to be desired. We converted our app to SB+ at the same time as moving to UD. It insulated us from a number of the issues that Bill encountered. It "forces" you to use Pick compatibility mode - I wonder if that is going to change now that IBM no longer supports SB+ on D3? That being said - I wouldn't go back unless someone paid me (anybody!?!?! Heck, I'll even work with Visage if I have to ;-) Way too much for this early on St. Patrick's Day! Colin Alfke Calgary Canada >-Original Message- >From: Ken Wallis > >Bill Haskett wrote: > >> > How difficult was the move - was it all green screen with source >> > code or more difficult? >> >> It wasn't that difficult. The biggest problems were UniData is like >> interfacing with Microdata in 1982...it's a time warp! The UniData >> environment is excruciatingly tedious and the lack of MV >enhancements >> is what I'd expect from mvBASE (an end-of-line product). > >It sounds like you feel exactly the same about UniData as I >did about D3 when I spent a few months contracting at a D3 >shop - antiquated stuff, how can anybody work with this when >xxx is so much better? > >I'm not sure which MV enhancements you mean, but I suspect the >issue is really one of adapting to looking at things from a >different perspective. > >Cheers, > >Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Triggers
Agreed -- we have D3 users and UniData users and UniVerse users ... I'm not sure that part of UniData is 'Time Warped' -- we've seen a ton of new features built in during the last few years, while D3 chugs along, they've only produced 3rd level point revisions in the last 2 years! Wow. It does make their maintenance seem high! I'm getting the same feedback from my customers. The only thing D3 has that I miss in UniData is Case Insensitivity everywhere. Gosh that was nice. Gosh that was a nightmare. Gosh that was nice. And while UniVerse may be slightly more compatible with D3, UniVerse is slightly more complex to administrer than UniData in my experience. Not as much once you know all the edges, but there are more edges in UniVerse for sure! (No flame wars needed or intended!) Bill - Welcome your customer to U2 land!! DW Bill Haskett wrote: > > How difficult was the move - was it all green screen with source > > code or more difficult? > > It wasn't that difficult. The biggest problems were UniData is like > interfacing with Microdata in 1982...it's a time warp! The UniData > environment is excruciatingly tedious and the lack of MV enhancements > is what I'd expect from mvBASE (an end-of-line product). Ken wrote: >It sounds like you feel exactly the same about UniData as I did about D3 when I spent a few months contracting at a D3 shop - antiquated stuff, how can anybody work with this when xxx is so much better? >I'm not sure which MV enhancements you mean, but I suspect the issue is really one of adapting to looking at things from a different perspective. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Gigabit NIC / list changes
>-Original Message- >From: John Jenkins > >For those that have access, there is an item in the IBM U2 >Knowledgebase on issues with Gigabit NICs who have problems. > >Issues relate to "Nagle Effect" and issues with drivers and >firmware versions when small packets are sent (i.e. Telnet on >full duplex). > >Seems to be Windows more so than Unix. > >Regards > >JayJay I think john votes for reverting the list ;-) Me, I'm good either way so whatever makes it easiest for the people volunteering their time and equipment to run the list gets my vote. Google groups would work fine. As long as it doesn't have the same failings that yahoo groups have/had. SBSolutions was moved here partly because of the problems there. My .02 CAD Colin Alfke Calgary Canada --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Trigger (singular)
Bill, I don't see anything "wrong" - just a hint. Once you are in the trigger subroutine your calls don't have to conform to the trigger. I realize that this may be just because you were thinking you could add them both as triggers and wrote them that way. Hth Colin Alfke Calgary Canada >-Original Message- >From: Bill Haskett > >Raymond: > >Thanks. I'm thinking the following ought to do the trick >(unless, of course, I've missed something). :-) > >SUBROUTINE U2T.APVENDOR.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) >** Update trigger for APVENDOR file on UniData [snip] >* >CALL U2.NAMES.BRIDGE.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) >CALL U2.HOMETASTIC.UPD (ExecStat, DictFlag, atFILENAME, atID, atRECORD) >* [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] Changes to the List
It was so simple when Cliff ran things. Receive an Email and reply to it. I have more posts about how to post this week then anything else, it is getting very boring, and more complicated. I have had a couple of failed to delivery messages because I an not a valid user on some of the lists. The amount of usefull posts have gone down. I do not like the way things are going. To many committees not enough action and common sense. Think I will be unsubscribing very soon. I wonder who is going to get this reply, I haven't got a clue..! Can't remember if I select "Reply" or "Reply to all", bother. Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 08:06 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2C] Changes to the List Thank you all for your views on this subject. The status of the user lists is one of many areas the U2UG are considering as we move forward this year. At our next board meeting we will be constituting a committee to advise on the best options for the list hosting. It may be that the committee finds a better option for the current list, recommends a move to a different list service, or recommends that the lists stay as current. Any recommendations, together with their rationale, will be fed back to the community and any decisions on the future of the lists will ultimately need to rest with the list membership. The committee will be continuing to seek comment from the membership on this issue. So in the meantime: 1. Please move this discussion over to the community list. That's where it belongs now. 2. If anyone wishes to contact the board directly on this matter, please email myself or other board members off-list. Thank You, Brian Leach, U2UG Board u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Trigger (singular)
Hi Bill, What you have is the simplest form of the wrapper. I had to create a 'generic' wrapper so I had to add logic to deal with the possible return values of execstat and the possibly amended record. As the wrapper is making the multiple calls it now has the responsibility of quitting at the appropriate time and maintaining the record value between subroutine calls. I'm on leave today, but I will post the 2 wrappers I have for update and delete as soon as I get a chance. Regards Raymond de Bourbon -Original Message- From: "Bill Haskett" <[EMAIL PROTECTED]> To: "u2-users@listserver.u2ug.org" Sent: 17/03/06 00:44 Subject: RE: [U2] [UD] Trigger (singular) Raymond: Thanks. I'm thinking the following ought to do the trick (unless, of course, I've missed something). :-) SUBROUTINE U2T.APVENDOR.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) ** Update trigger for APVENDOR file on UniData ** (C) Copyright 1985-2004, Advantos Systems, Inc. All Rights Reserved. ! ** Last Modified: 16 Mar 2006, wph ** First Created: 16 Mar 2006, wph ** Program Type-: Trigger (Web) ! ** Notes: ** ** This is a "trigger" program placed on the (APVENDOR) file. It has ** to execute all UPDATE triggers for this file. ** **---** ** ** **I N I T I A L I Z A T I O N** ** ** **---** * CALL U2.NAMES.BRIDGE.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) CALL U2.HOMETASTIC.UPD (ExecStat, DictFlag, atFILENAME, atID, atRECORD) * **** **** ** E N D O F P R O G R A M ** **** **** * RETURN END Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -Original Message- > From: Raymond de Bourbon [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 2:21 PM > To: Bill Haskett; u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Trigger (singular) > > Hi Bill, > > You are correct, Unidata only supports one trigger for both > update and delete. In order to have multiple triggers you > need a wrapper program... I can send you the source if you want. > > Regards > > Raymond de Bourbon > > > -Original Message- > From: "Bill Haskett" <[EMAIL PROTECTED]> > To: "u2-users@listserver.u2ug.org" > Sent: 16/03/06 21:03 > Subject: [U2] [UD] Trigger (singular) > > I'm almost done with triggers (thank goodness I only have a > few to create). > It appears UniData only allows one trigger created on a file > at a time. Is > this true? > > 2 Dtademo (0)-> LIST-TRIGGER APVENDOR > BEFORE UPDATE TRIGGER: U2.NAMES.BRIDGE.U > BEFORE DELETE TRIGGER: U2.NAMES.BRIDGE.D > 2 Dtademo (0)-> CREATE-TRIGGER APVENDOR U2.HOMETASTIC.UPD UPDATE > The specified trigger already exists. > > The documentation doesn't mention this at all. So, in order > to get multiple > triggers on a file would I have to create a "wrapper" BASIC > program that > CALLs each trigger program as a subroutine (or EXECUTEs each trigger > program)? > > Any enlightenment would be appreciated. :-) > > Bill Haskett > --- > 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] Unix Device Number
df shows all currently used mount points in its last columns and the device in column 1. oops ... I have an alias on df to df -k plain df gives the info too but in a different format. HTH -- mats phil walker wrote: Hi, The output of list.readu returns the device and inode number of a Universe file. I can resolve the inode number by using find . -inum xx, but if I am positioned at / then it is possible that 1 or more files may have that same inode number, so I want to restrict the find to the corresponding device. Is there a way of determining the mount point for a file system device id in UNIX? Cheers, Phil. --- 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] Unix Device Number
df shows all currently used mount points in its last columns and the device in column 1. HTH -- mats phil walker wrote: Hi, The output of list.readu returns the device and inode number of a Universe file. I can resolve the inode number by using find . -inum xx, but if I am positioned at / then it is possible that 1 or more files may have that same inode number, so I want to restrict the find to the corresponding device. Is there a way of determining the mount point for a file system device id in UNIX? Cheers, Phil. --- 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] Changes to the List
Thank you all for your views on this subject. The status of the user lists is one of many areas the U2UG are considering as we move forward this year. At our next board meeting we will be constituting a committee to advise on the best options for the list hosting. It may be that the committee finds a better option for the current list, recommends a move to a different list service, or recommends that the lists stay as current. Any recommendations, together with their rationale, will be fed back to the community and any decisions on the future of the lists will ultimately need to rest with the list membership. The committee will be continuing to seek comment from the membership on this issue. So in the meantime: 1. Please move this discussion over to the community list. That's where it belongs now. 2. If anyone wishes to contact the board directly on this matter, please email myself or other board members off-list. Thank You, Brian Leach, U2UG Board --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/