Re: [U2] Changes to the List
[EMAIL PROTECTED] wrote: Argh! I just tried to agree with Bob/Wendy and forgot to reply-all. Sorry to whoever got my email. I really preferred the list when response went to the list. Much as I know that correct behaviour is the current one, yes I've noticed traffic has dropped noticeably. And the current behaviour is very inconvenient to me because my main method of replying to list is webmail (my work email client can't post, posting at home annoys my wife :-(, and webmail DOESN'T HAVE a reply-to-all :-( So to save me having to type or cut-n-paste the list address for EVERY post I try to make, I'm inclined to vote to go back to the old setup ... - I came very close to forgetting to change the address for this post ... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [U2C] Changes to the List
I have a number of times accidentally done reply to instead of reply all, it might be a matter of getting used to it, but I would say it does reduce discussion. However on the other side I do see the hundreds of emails that Larry and Chuck receive due to reject emails and bounces, which this method has reduced by about 75% of. Ps This is the second attempt; I accidentally hit reply to on this email too. Mind you a bad workman does blame his tools Regards David Jordan Managing Consultant [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] Changes to the List
Can't get used to using reply to all, if I get an Email I want to reply to that Email. Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: u2ug [mailto:[EMAIL PROTECTED] Sent: 16 March 2006 01:30 To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [U2C] Changes to the List All, We've now been living with the change to the lists for nearly a month. I'd like to invite opinions on the change. Are we all happy now that we are used to it? Personally, I think Larry made a good call, but this is a community, so I want me be sure that everyone gets heard. I've still got Jerry and Tom's original issues bookmarked, and I'm especially interested to see if their issues are still problematic. - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] 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/
[U2] Haydon Bishop is out of the office.
I will be out of the office starting 15/03/2006 and will not return until 17/03/2006. I will respond to your message when I return. ___ The information contained in this message is intended for the addressee only and may contain confidential and/or privileged information. If you are not the addressee, please delete this message and notify the sender. You should not copy or distribute this message or disclose its contents to anyone. E-mail transmissions cannot be guaranteed to be secure or free of errors or viruses. Therefore, no reliance may be placed on this message without written confirmation from an authorized representative of its contents. Copyright ) 2006 Donovan Data Systems Ltd. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] bci
Rudy What does your code look like? BTW...You should use SQLExecDirect when calling stored procedures, when it doesn't need to be called repeatedly (as it is supposedly more efficient). Check out the online help or BCI manuals for more info. Here's a snippet of source code from a real sample of calling a stored procedure...from BCI under UV... STORED.PROC = call *data_io_handler (?, ?, ?, ?, ?, ?, ?, ?) SQL.STATUS = SQLBindParameter(STMTENV, 1, SQL.B.BASIC, SQL.INTEGER, 0, 0, ERROR.CODE, SQL.PARAM.OUTPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 2, SQL.B.BASIC, SQL.INTEGER, 0, 0, SEVERITY.CODE, SQL.PARAM.OUTPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 3, SQL.B.BASIC, SQL.CHAR, 0, 0, ERROR.TEXT, SQL.PARAM.OUTPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 4, SQL.B.BASIC, SQL.CHAR, 0, 0, TABLE.NAME, SQL.PARAM.INPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 5, SQL.B.BASIC, SQL.CHAR, 0, 0, PRIMARY.KEY, SQL.PARAM.INPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 6, SQL.B.BASIC, SQL.CHAR, 0, 0, INPUT.LIST, SQL.PARAM.INPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 7, SQL.B.BASIC, SQL.CHAR, 0, 0, OUTPUT.LIST, SQL.PARAM.OUTPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLBindParameter(STMTENV, 8, SQL.B.BASIC, SQL.CHAR, 0, 0, QUERY, SQL.PARAM.INPUT) gosub CHECK.STMT.ENV SQL.STATUS = SQLExecDirect(STMTENV, STORED.PROC) if SQL.STATUS then crt Error: SQLExecDirect failed, SQL.STATUS is :SQL.STATUS gosub CHECK.STMT.ENV SQL.STATUS = SQLRowCount(STMTENV, ROWS) if ROWS then crt ROWS: rows returned end Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Saturday, 11 March 2006 9:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] bci Can someone familiar with bci assist me with one of the functions. I'm running bci from w2k UV 10.1.10. I'm trying to get a varchar output parameter from a sql server stored procedure. I made sure the sproc worked in sql analyzer before attempting to use bci. In UV I can execute the sproc just fine, but I can't seem to get the output returned. I'm using SQLBindParameter to get the output from my sproc. I execute immediately after SqlExecute. I don't seem to be getting any output back from SQLBindParameter. No error is generated and the return status is 0. In which argument is my output supposed to be in ? Any hints would be greatly appreciated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
I am used to the changes. I dont see a problem with it. However, the traffic has seemed to drop. We could be missing out on some interesting discussion. The problem is that some people have a hard time adapting to change. I think the reply / reply to all is a nice choice to have. Sometimes you might want the choice to reply only to an individual. Personally, I probably would not have changed anything unless the problem experienced at first was a recurring. I dont go looking for bugs in my system if a user brings me a one time odd ball error. I probably would have tried to write a 'filter' that might eliminate messages with certain info in the subject or body. The problem that occurred could have been eliminated by adding that subject to your filter and those messages could have been sent to the bit bucket. If users on my system find a way to get bad data into the files, you fix the problem by tightening up the edits for the field entry. I see this stiuation as being very similar. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of u2ug Sent: Wednesday, March 15, 2006 8:30 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [U2] Changes to the List All, We've now been living with the change to the lists for nearly a month. I'd like to invite opinions on the change. Are we all happy now that we are used to it? Personally, I think Larry made a good call, but this is a community, so I want me be sure that everyone gets heard. I've still got Jerry and Tom's original issues bookmarked, and I'm especially interested to see if their issues are still problematic. - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] --- 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.3/281 - Release Date: 3/14/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.2.3/281 - Release Date: 3/14/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Gigabit NIC
We've had some clients have trouble with the Broadcom gigabit cards. Swapping them out resolved the issues. This was a while ago. Updated drivers may help. Hth Colin Alfke Calgary Canada -Original Message- From: Mike Pflugfelder Hi all, I remember seeing something in the list a while back about Gigabit NIC cards and Universe but I can't seem to find a reference to it and the search still seems to be down. Does anyone know exactly what the problem is between Universe on Windows and Gigabit NIC cards? I believe that it had to do with the driver for the NIC card and I know that replacing the card with a 10/100 MB card was one solution, but that doesn't sit well with me or my customers. It's getting hard to tell a customer that their new fancy server with it's blazing Gig NIC needs to have it's network card downgraded in order to not have problems with our application. Can I simply change drivers? Do I need to upgrade or downgrade the driver? Thanks in advance... Michael Pflugfelder | Systems Integrator | Keystone Information Systems | 856-722-0700 | [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] Changes to the List
I don't post much, and as a result maybe my opinion doesn't count. But this reply all is a pain. For instance this one. I clicked the reply all on the last email of this topic. So I remove Anthony Dzikiewicz [EMAIL PROTECTED] from the TO:. I'm sure he doesn't want my post twice. Then I have [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], u2-users@listserver.u2ug.org, 'u2ug' [EMAIL PROTECTED] in the CC:. Gee, which is the one I really want to send this too? Normally I say, aw the heck with it, someone else will answer with correctly and I discard my email and go back to work. That's my problem with reply all. I'm not going to winnow out the CC: today, I don't belong to all those lists but what the heck. I suppose that's someone else's problem. Then I have my problem when I read an email from a thread that appears to have a couple of chapters missing. The conversation appears to have gone on for a little between two respondents. And, it seems, that one remembers to send back to the list. Back to lurking Bruce Bruce M Neylon Health Care Management Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
I do not like the 'reply-all' feature either. As developers, I would hope that we would not add a feature to our user interfaces that annoyed all of the users every time they used it, so I don't see why we should tolerate doing it to ourselves. Presumably the list moderator is trying to solve some perceived problem, but I've been on several other high traffic lists and none of them have done this. As far as moving it to a Google list... why would you do this? What problem are you trying to solve? My experience with the free list servers is that it is easy to get unsubscribed without notification if a few list messages bounce to your address. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
In my opinion, the *reply* behavior of the mailing list needs to reflect the announcement vs. discussion mentality of the group. The announcement mentality puts the emphasis on announcing ideas and issues, and promotes discussion between the poster and individuals wanting to know more details. In this case, the reply button behavior should default to only reply to poster. The discussion mentality puts the emphasis on sharing the discussion out in the open, promoting community participation. Unfortunately, this also has the effect of lowering the signal-to-noise ratio, creating a lot of me too replies. Here, the reply button behavior should default to reply all (i.e. the old way). I don't think the drop in traffic is necessarily a bad thing; it will probably pick up once everyone gets accustomed to the rules. Personally, I opt for the discussion mentality where open discussions are the emphasis. rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
I did not post too many messages either, as I am new to UniVerse. I am still learning. But I am thinking that we(ourselves) could have a choice on how to reply the email to the list. Currently, if I want to reply to the person posted the email only, I just hit the Reply on my outlook. If I need to reply to the list, hit Reply All. As for Yahoo user list, I had experience on webLogic Yahoo user group. It works fine to me. It was a little bit slow during the peak hour though. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, March 16, 2006 11:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List I do not like the 'reply-all' feature either. As developers, I would hope that we would not add a feature to our user interfaces that annoyed all of the users every time they used it, so I don't see why we should tolerate doing it to ourselves. Presumably the list moderator is trying to solve some perceived problem, but I've been on several other high traffic lists and none of them have done this. As far as moving it to a Google list... why would you do this? What problem are you trying to solve? My experience with the free list servers is that it is easy to get unsubscribed without notification if a few list messages bounce to your address. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
When I hit reply all, I have to: 1. remove the person's name from the To: box 2. move the Cc: name (u2-users...) to the To: box That is a waste of my time, and tedious. If we programmed a user interface like that we would be laughed at. I'll vote for the old way: reply being a reponse to the list, not the individual. Louie Bergsagel Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
Well, I had forgotten about it, and started to reply yesterday, noticed the 'to' was wrong and fixed it. Didn't bother me a'tall ! You do have excellent suggestions though. Not everyone is as careful with the 'to' as I am. Once you've sent a message to the wrong 'to' you never forget to do that again :-} (sheepish grin) Fortunately no one got fired...heh...did have a hell of a pissed off VP of Ops for a while though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Wednesday, March 15, 2006 21:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List Bruce Nichol wrote: How many now know to Reply All if they want a moment of fame on the list? And this is another point. An announcement was made to the list, there was a hullabaloo for a few days and then it blew over. How many people missed that thread and don't know the secret handshake to send mail to this forum? How many people have tried to post a reponse, had a bounce or other interaction with some other forum member and just decided to not post? I can find no mention of How to Reply to Forum Mail with new instructions on the U2UG site. A new subscriber attempting a reply may conclude the list simply doesn't work. Is it expected that everyone will e-mail their confusion to the moderators? Welcome to real business: dis-satisfied or confused clients are more likely to walk away than complain or petition for change. Sure, I had issues up front, but I quickly adapt to change, so I really don't care what the policy is, and that's typical of anyone we see posting here. It's the people who aren't posting that you should be concerned about. When there is a policy that requires special action to do a common function, instructions should be easily available and quite clear. Suggestions: 1) Append this text to the footer applied to forum posts after the URL: See that page for information about posting and unsubscribing I'd say just bring the footer down to one line but I'm sure there are people using the footer for filtering, so it's probably not a good idea to change it. 2) Put documentation about how to reply on the http://listserver.u2ug.org/ page. 3) Put a clear link to that documentation on the Email Lists page accessible from the u2ug.org home page. Way over my 2 cents, sorry. T --- 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
I concur. - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, March 15, 2006 11:59 PM Subject: RE: [U2] Changes to the List Bruce Nichol wrote: How many now know to Reply All if they want a moment of fame on the list? And this is another point. An announcement was made to the list, there was a hullabaloo for a few days and then it blew over. How many people missed that thread and don't know the secret handshake to send mail to this forum? How many people have tried to post a reponse, had a bounce or other interaction with some other forum member and just decided to not post? I can find no mention of How to Reply to Forum Mail with new instructions on the U2UG site. A new subscriber attempting a reply may conclude the list simply doesn't work. Is it expected that everyone will e-mail their confusion to the moderators? Welcome to real business: dis-satisfied or confused clients are more likely to walk away than complain or petition for change. Sure, I had issues up front, but I quickly adapt to change, so I really don't care what the policy is, and that's typical of anyone we see posting here. It's the people who aren't posting that you should be concerned about. When there is a policy that requires special action to do a common function, instructions should be easily available and quite clear. Suggestions: 1) Append this text to the footer applied to forum posts after the URL: See that page for information about posting and unsubscribing I'd say just bring the footer down to one line but I'm sure there are people using the footer for filtering, so it's probably not a good idea to change it. 2) Put documentation about how to reply on the http://listserver.u2ug.org/ page. 3) Put a clear link to that documentation on the Email Lists page accessible from the u2ug.org home page. Way over my 2 cents, sorry. T --- 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
Don't go there. I think this was discussed many times and the consensus was no. I personally hate, is hate too strong a word, having to go to a group site to find out what is going on. Most of the people on this list work for a living and don't have the time to search out answering questions for free but if it comes into their mailbox and they've got the time they may give a hand. - Original Message - From: Mike Preece [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 16, 2006 3:50 AM Subject: RE: [U2] Changes to the List I've been holding back from putting this question, in the hope that the initiative might come from within U2UG, but it seems high time... What do people think of the idea of moving this list to a google group instead? We'd lose nothing btw - in that we could all send and receive emails to/from the list - or post and read messages online without any emails, and we'd have access to recent posts and, in time, archives, in the same way as for a news group. How many of you have not used a google group or a usenet group with a google interface? Of those that are familiar with google groups - is there anything this list provides that they don't? Maybe someone at U2UG could put a survey up on the U2UG web-site to get some numbers for responses to these and similar questions. Mike. From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List Date: Wed, 15 Mar 2006 19:30:40 -0800 We've now been living with the change to the lists for nearly a month. I'd like to invite opinions on the change. Are we all happy now that we are used to it? Personally, I think Larry made a good call, but this is a community, so I want me be sure that everyone gets heard. [snip] Thanks for asking, Chuck. If numbers are any indication, I've done some rough counts on my mail archive: - In the time period from feb/27 when this change was announced until today, mar/15, there were approximately 181 posts to this forum. I'm including posts prior to the announcement on that day as well generously including vacation posts, dupes, and other mis-haps which occurred. - In the same time period from the 27th of one month to the 15th of a consecutive month, going back for the last 6 months, this forum serves anywhere between 280ish to over 600 posts, with a guessed average of roughly about 390. (vague enough?) Given those numbers, it seems traffic here has dropped by almost half since the change. Whether that's good or bad is up to the individual, but anything that (seemingly) cuts community traffic by this magnitude deserves some evaluation. HTH T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Shopping made easy @ tradingpost.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fwww%2Etradingpost%2Ecom%2Eau%2F%3Freferrer%3DnmsnHMetagv1_t=753082530_r=emailtagline_m=EXT --- 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
Interestingly, that gmane site had a posting rate chart (see link below) which confirms that usage has dropped off. However, you can see that it did the same last year as well so can't necessarily be attributed to the list change being discussed. I don't care either way. I don't post too often but think I can manage fine! Regards, Rob Wills (rob dot wills at tigerinfotech dot com) Wendy wrote on 16/03/2006 16:05:55: If you prefer a newsgroup, it looks like the list is already on Gmane: http://dir.gmane.org/gmane.comp.db.u2.general HTH, -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
Perceived problem? How about I add you to the moderator list, and you can perceive the 1,500 bounce/vacation autoresponse/error emails that end up in YOUR inbox in less than an hour because someone's brain-dead mail server doesn't know how to properly parse email headers? :-D Larry Hiscock Moderator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, March 16, 2006 8:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List I do not like the 'reply-all' feature either. As developers, I would hope that we would not add a feature to our user interfaces that annoyed all of the users every time they used it, so I don't see why we should tolerate doing it to ourselves. Presumably the list moderator is trying to solve some perceived problem, but I've been on several other high traffic lists and none of them have done this. As far as moving it to a Google list... why would you do this? What problem are you trying to solve? My experience with the free list servers is that it is easy to get unsubscribed without notification if a few list messages bounce to your address. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [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/
Re: [U2] Changes to the List
I guess I don't understand why this is so hard to fix. If you can't set up filters in your listserver, 1) set up a free gmail account, 2) set up a filter to send all the bounce/vacation autoresponse/error emails to the trash, and 3) forward the remaining emails to the user group. Louie Bergsagel Seattle On 3/16/06, Larry Hiscock [EMAIL PROTECTED] wrote: Perceived problem? How about I add you to the moderator list, and you can perceive the 1,500 bounce/vacation autoresponse/error emails that end up in YOUR inbox in less than an hour because someone's brain-dead mail server doesn't know how to properly parse email headers? :-D Larry Hiscock Moderator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, March 16, 2006 8:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List I do not like the 'reply-all' feature either. As developers, I would hope that we would not add a feature to our user interfaces that annoyed all of the users every time they used it, so I don't see why we should tolerate doing it to ourselves. Presumably the list moderator is trying to solve some perceived problem, but I've been on several other high traffic lists and none of them have done this. As far as moving it to a Google list... why would you do this? What problem are you trying to solve? My experience with the free list servers is that it is easy to get unsubscribed without notification if a few list messages bounce to your address. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Louie Bergsagel has invited you to open a Google mail account
--- Louie Bergsagel has invited you to open a free Gmail account. To accept this invitation and register for your account, visit http://mail.google.com/mail/a-79288ca1c7-a300dce4b8-20eb5450d6 Once you create your account, Louie Bergsagel will be notified with your new email address so you can stay in touch with Gmail! If you haven't already heard about Gmail, it's a new search-based webmail service that offers: - Over 2,500 megabytes (two gigabytes) of free storage - Built-in Google search that instantly finds any message you want - Automatic arrangement of messages and related replies into conversations - Powerful spam protection using innovative Google technology - No large, annoying ads--just small text ads and related pages that are relevant to the content of your messages To learn more about Gmail before registering, visit: http://mail.google.com/mail/help/benefits.html And, to see how easy it can be to switch to a new email service, check out our new switch guide: http://mail.google.com/mail/help/switch/ We're still working every day to improve Gmail, so we might ask for your comments and suggestions periodically. We hope you'll like Gmail. We do. And, it's only going to get better. Thanks, The Gmail Team (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Trigger (singular)
You are correct -- only one subroutine is allowed - so you have to make sure it does all the work you want. - 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/
RE: [U2] Changes to the List
At 20:50 +1100 2006/03/16, Mike Preece wrote: What do people think of the idea of moving this list to a google group instead? I would not be adverse to it. Google Groups has multiple digesting options, both web and e-mail interface, hides the quoted text from folks that refuse to trim the original email and (most importantly IMHO) can be viewed in a threaded fashion. We've been using a private one internally for work and will set-up ones for our customers shortly. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Triggers
Some questions (I have a few sites that have this as an open topic as well...) I meant to ask earlier, but couldn't figure out if I should Reply or Reply All (kidding!!) What was the driving force to move from D3 to UniData? How difficult was the move - was it all green screen with source code or more difficult? How did you actually DO the move - it's not like D3 files will copy at any high level to UniData! How long did it take to make the move (physically, once you worked out the kinks) Thanks -- I'm sure there are others here who would be interested in knowing more about your migration... David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, March 14, 2006 7:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Triggers I've converted a client's system from D3 to UniData and everything mostly works fine. One of the last items I have to deal with are triggers. I've read the UniData documentation on triggers and am intimately familiar with D3 triggers, so it's no wonder I'm confused about UniData triggers. Questions: 1) Can I create both an update and delete trigger on a file using the same BASIC program or do I need to create two separate programs? In D3 there's an internal function that indicates if the action is an add or delete. This allows a single program to be used for both an update and a delete. 2) How can I tell if a record is being added or changed? 3) Where do the passed variables come from? SUBROUTINE U2.NAMES.BRIDGE.U (ExecStat, DictFlag, FileName, RecIdExpr, RecValue) What specifically is RecIdExpr? The record key being updated (documentation says it's the record to be updated)? Is FileName the file name or the opened file (file variable)? Do I have to set DictFlag? It seems UniData requires a trigger to be defined as either UPDATE or DELETE. Does this mean I have to create two BASIC programs; one for updating and one for deleting? Any assistance would be appreciated. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- 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
Jerry Banker wrote: Don't go there. I personally hate, is hate too strong a word, having to go to a group site to find out what is going on. From: Mike Preece What do people think of the idea of moving this list to a google group instead? Jerry and others, Google Groups sends e-mail as well as providing a web interface - this is something that's widely misunderstood. I'm subscribed to a few mail lists via Google and have only had a couple minor issues. Google Groups puts their mail lists side by side with Usenet (a completely different protocol for which usenet readers are available), which can be confusing but helpful too. So for example, many people get comp.databases.pick (usenet) and the jBASE and QM forums, all in their e-mail, and they think it's all just an e-mail medium - others only read these forums via browser because their employers ban forums at work or for other reasons. I didn't support Mike's initiative to create a U2 Google Group because at the time I didn't see a perceived need. The big problem as I see it now is that there are so many people that would need to make a change, so now, only for this reason, I still don't fully support the proposal. At this point however, I think the idea should at least be reconsidered. The current subscriber list can be imported into the Google Group, everyone would be auto-subscribed, and then people would just need to bookmark the new list address for new posts. It wouldn't be such a big deal really and there would be benefits. Up to 8 cents now on this topic, oops. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
All, The reason I started this thread is because everyone's opinion matters. However, this thread is taking over the lists. So, I am going to ask you all, to forward your thoughts to [EMAIL PROTECTED] instead. Larry and I will go through it all and see what can/should be done. We'll discuss it with the U2UG board, and ultimately will all of you. I don't want to stop the conversation, but I do want to take it off list. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
At 18:43 + 2006/03/16, [EMAIL PROTECTED] wrote: Interestingly, that gmane site had a posting rate chart (see link below) which confirms that usage has dropped off. However, you can see that it did the same last year as well so can't necessarily be attributed to the list change being discussed My guess it's mostly due to: Spectrum DUG (are there any OSS, Epicore, ADP, etc. UG's about this time?) Tax Time End of 1st Quarter approaching I didn't really think it was due to the change. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Louie Bergsagel has invited you to open a Google mail account
Louie, This is a bad idea. Actually, it's a bad idea that's already been tried. Mike Preece already has a (largely inactive) group on Google. Let's do this in measured steps, people. We need to take a collective breath. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 Louie Bergsagel wrote: | --- | Louie Bergsagel has invited you to open a free Gmail account. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
If the U2UG decides to move the lists to Google Groups, my feelings won't be hurt a bit. But until then, let's let the group consider it and make an informed decision, not just run off and start splinter groups all over the net. Larry Hiscock Moderator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Raymond DeGennaro II Sent: Thursday, March 16, 2006 11:25 AM To: Jerry Banker Cc: Mike Preece; u2-users@listserver.u2ug.org Subject: Re: [U2] Changes to the List At 12:35 -0600 2006/03/16, Jerry Banker wrote: I personally hate, is hate too strong a word, having to go to a group site to find out what is going on. You don't have to do that with Google groups. You can set your subscription to No Email, Every post as a separate Email, a traditional Digest Mode and an Abridged mode which sends a daily summary of each thread (number of new posts, a breif clip from the thread (I think it's the most recent post). So, you wouldn't have to use the web interface for daily replies if you didn't want to. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- 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
I would like to make a suggestion. The u2 users list has been in existence for a LONG time. Currently, the list is managed by the U2 User Group. (Up until yesterday, I was a member of the u2ug board, but my term expired). I would suggest that the u2ug board appoint a small team of people to investigate the options for communication to the u2 communities and come back with recommendations to the board. The investigation should look at all available options, listing the pros and cons of each. And it should include polling of the user community. This clearly a topic of interest to a lot of people. I imagine there are even a few people out there who wouldn't mind serving on this suggested team. Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
I wasn't going to vote, because I don't care which way it is (i.e., reply to poster vs. reply-all). On the other hand, I _emphatically_ don't care, so I'll vote after all: I don't care. Which is to say that I'll support, with gratitude, those who maintain the list whichever way they end up doing it. Thank-you Chuck Larry both, Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
It seems like this has been the only thing on the list recently, maybe all the other emails are being sent by replyTIC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Friday, 17 March 2006 9:01 a.m. To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [U2] Changes to the List All, The reason I started this thread is because everyone's opinion matters. However, this thread is taking over the lists. So, I am going to ask you all, to forward your thoughts to [EMAIL PROTECTED] instead. Larry and I will go through it all and see what can/should be done. We'll discuss it with the U2UG board, and ultimately will all of you. I don't want to stop the conversation, but I do want to take it off list. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 --- 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
Mike Preece [EMAIL PROTECTED] wrote: What do people think of the idea of moving this list to a google group instead? Jerry Banker [EMAIL PROTECTED] replied: Don't go there. I think this was discussed many times and the consensus was no. I personally hate, is hate too strong a word, having to go to a group site to find out what is going on. Most of the people on this list work for a living and don't have the time to search out answering questions for free but if it comes into their mailbox and they've got the time they may give a hand. For those familiar with comp.databases.pick, I have one word: [EMAIL PROTECTED] grumble My biggest problem with the Useet-style newsgroups is that they are unmoderated. There is no one to control the content or administer cyber spankings when appropriate, nor can offensive content be removed. As Jerry pointed out, it is easier to have messages pushed to the mailbox than to have to pull them from a website. I'm subscribed for digest reading, and I really appreciate being able to receive the digests for several reasons, primarily: 1) As sole computer support person for my company, my e-mail client is set to provide an audible and visual alert every time a new message arrives. When an active discussion starts on the list, I can't afford the steady stream of interruptions. 2) With newsgroups, I often have to wade through old messages to find the newer ones, especially for a topic that goes on for several days. With the current digests, I only receive the newest posts, and can quickly browse the topic list to find the messages of interest. Considering that Larry has been kind enough to host the lists for the group gratis, like Clif before him, I would suggest that his opinions should carry great weight. Just my plug nickle... --Tom Pellitieri Toledo, Ohio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [u2] bci
David,
Here is my test code. This run's fine without the output parameter from
my stored procedure.
**Source code:**
OPTIONS INFORMATION
*
$INCLUDE UNIVERSE.INCLUDE ODBC.H
*
UCMD = ''
*
STATUS = SQLAllocEnv(DBENV)
STATUS = SQLAllocConnect(DBENV,CONENV)
STATUS = SQLConnect(CONENV,'sagefin_old_odbc','webuser','webuser')
STATUS = SQLAllocStmt(CONENV,STMTENV)
UCMD = {call sp_insert_cmtest ('1*40888','GARY','WILLIAMS','1
SPRING RD.','MOORPARK','CA','93021','USA')}
STATUS = SQLPrepare(STMTENV,UCMD)
STATUS = SQLExecute(STMTENV)
CRT 'Status SqlExecute ':STATUS
CRT 'SQL.SUCCESS ':SQL.SUCCESS
STATUS = SQLFreeStmt(STMTENV,SQL.DROP)
STATUS = SQLDisconnect(CONENV)
STATUS = SQLFreeConnect(CONENV)
STATUS = SQLFreeEnv(DBENV)
END
**Output:**
Status SqlExecute 0
SQL.SUCCESS 0
**My sproc with the output parameter commented out:**
CREATE PROCEDURE [dbo].[sp_insert_cmtest]
@cmid as varchar(50),
@fnameas varchar(50),
@lname as varchar(50),
@addr1 as varchar(50),
@city as varchar(50),
@state as varchar(50),
@zip as varchar(50),
@country as varchar(10)
[EMAIL PROTECTED] as varchar(50) OUTPUT
AS
SET NOCOUNT ON
INSERT INTO
cmtest (id,firstname,lastname,address1,city,state,zip,country)
VALUES
(@cmid,@fname,@lname,@addr1,@city,@state,@zip,@country)
--SELECT @id_out = @cmid
GO
My test source:
OPTIONS INFORMATION
*
$INCLUDE UNIVERSE.INCLUDE ODBC.H
*
UCMD = ''
DBENV = '' ; STMTENV = '' ; CONENV = ''
TESTCOL = ''
*
STATUS = SQLAllocEnv(DBENV)
STATUS = SQLAllocConnect(DBENV,CONENV)
STATUS = SQLConnect(CONENV,'sagefin_old_odbc','webuser','webuser')
STATUS = SQLAllocStmt(CONENV,STMTENV)
UCMD = {call sp_insert_cmtest ('1*40999','GARY','WILLIAMS','1
SPRING RD.','MOORPARK','CA','93021','USA')}
STATUS = SQLPrepare(STMTENV,UCMD)
STATUS = SQLExecute(STMTENV)
CRT 'Status SqlExecute ':STATUS
CRT 'SQL.SUCCESS ':SQL.SUCCESS
STATUS = SQLFetch(STMTENV)
STATUS = SQLBindCol(STMTENV,1,SQL.B.CHAR,TESTCOL)
STATUS = SQLFreeStmt(STMTENV,SQL.DROP)
STATUS = SQLDisconnect(CONENV)
STATUS = SQLFreeConnect(CONENV)
STATUS = SQLFreeEnv(DBENV)
END
Output:
Status SqlExecute -1
SQL.SUCCESS 0
So, on the 2nd test with the output parameter enabled in the sproc, the
insert fails.
So I guess my question is, how do I get the output from the sproc into
my UV program from a stored procedure.
Any suggestions would be greatly appreciated.
Thx,
Rudy
Date: Thu, 16 Mar 2006 23:14:44 +1100
From: Hona, David S [EMAIL PROTECTED]
Subject: RE: [U2] bci
Rudy
What does your code look like?
BTW...You should use SQLExecDirect when calling stored procedures, when
it doesn't need to be called repeatedly (as it is supposedly more
efficient). Check out the online help or BCI manuals for more info.
Here's a snippet of source code from a real sample of calling a stored
procedure...from BCI under UV...
Rudy Cooper
Information Technology
Project Technical Lead
Sage Publications
2455 Teller Road
Thousand Oaks, California 91320
Direct (805) 410-7724
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
At 15:22 -0500 2006/03/16, [EMAIL PROTECTED] wrote: My biggest problem with the Useet-style newsgroups is that they are unmoderated. There is no one to control the content or administer cyber spankings when appropriate, nor can offensive content be removed. Not a problem with a Google group. I would not want to go through the whole process of trying to get a new comp.databases.pick.u2/comp.databases.u2 created or even get the hierarchy reorganized to: comp.databases.multivalue.general, comp.databases.multivalue.d3, comp.databases.multivalue.u2, etc.. Been there, done that. Usenet groups could be moderated with a minimal amount of effort, but again, I wouldn't want to be a moderator. Google Groups are slightly different. The group creator can control the membership, delete posts, etc. As Jerry pointed out, it is easier to have messages pushed to the mailbox than to have to pull them from a website. Not a problem with a Google Group. I'm subscribed for digest reading, and I really appreciate being able to receive the digests for several reasons, primarily: Google Groups have two different digest modes. So you won't lose this feature of typical mailing lists. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changes to the List
These are not groups they are echoes of what is being sent to this list. - Original Message - From: Wendy Smoak [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 16, 2006 10:05 AM Subject: Re: [U2] Changes to the List On 3/16/06, Mike Preece [EMAIL PROTECTED] wrote: What do people think of the idea of moving this list to a google group instead? If you prefer a newsgroup, it looks like the list is already on Gmane: http://dir.gmane.org/gmane.comp.db.u2.general There's also Nabble, with a slightly different interface: http://www.nabble.com/U2---Users-f801.html HTH, -- Wendy --- 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 - NO GOOGLE or etal...
I too hate going to a site, the list is far preferable. Vote with Jerry !! Will someone summarize what this bru ha ha is all about. grs -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, March 16, 2006 3:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List - NO GOOGLE or etal... I vote with Jerry. -Original Message- From: Jerry Banker [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 16, 2006 10:35 AM To: Mike Preece; u2-users@listserver.u2ug.org Subject:Re: [U2] Changes to the List Don't go there. I think this was discussed many times and the consensus was no. I personally hate, is hate too strong a word, having to go to a group site to find out what is going on. Most of the people on this list work for a living and don't have the time to search out answering questions for free but if it comes into their mailbox and they've got the time they may give a hand. - Original Message - From: Mike Preece [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 16, 2006 3:50 AM Subject: RE: [U2] Changes to the List I've been holding back from putting this question, in the hope that the initiative might come from within U2UG, but it seems high time... What do people think of the idea of moving this list to a google group instead? We'd lose nothing btw - in that we could all send and receive emails to/from the list - or post and read messages online without any emails, and we'd have access to recent posts and, in time, archives, in the same way as for a news group. How many of you have not used a google group or a usenet group with a google interface? Of those that are familiar with google groups - is there anything this list provides that they don't? Maybe someone at U2UG could put a survey up on the U2UG web-site to get some numbers for responses to these and similar questions. 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
Seconded. Apologies for posting to the list instead of the moderators but let's all consider the amount of work a small number of people put in to make this happen, and whether we personally would be willing to step up and do it instead of telling them how we'd like them to do it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: 16 March 2006 19:47 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Changes to the List I wasn't going to vote, because I don't care which way it is (i.e., reply to poster vs. reply-all). On the other hand, I _emphatically_ don't care, so I'll vote after all: I don't care. Which is to say that I'll support, with gratitude, those who maintain the list whichever way they end up doing it. Thank-you Chuck Larry both, Chuck Stevenson --- 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
What? Haven't you been getting my emails? John Cassidy Unix Sys Admin DCCCD u2ug [EMAIL PROTECTED] 03/15/06 7:29 PM All, We've now been living with the change to the lists for nearly a month. I'd like to invite opinions on the change. Are we all happy now that we are used to it? Personally, I think Larry made a good call, but this is a community, so I want me be sure that everyone gets heard. I've still got Jerry and Tom's original issues bookmarked, and I'm especially interested to see if their issues are still problematic. - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [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] [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 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/
Re: [U2] Changes to the List
On 3/16/06, Mike Preece [EMAIL PROTECTED] wrote: I've been holding back from putting this question, in the hope that the initiative might come from within U2UG, but it seems high time... Many, including both Clif and me, were vocal about this change immediately. I have seen changes like this turn a list that has good discussions to a list of questions with few answers posted back. It is very frustrating to do a search, find your exact question, and see none of the fine responses that the original poster received personally. What do people think of the idea of moving this list to a google group instead? I would be all for it. I think it would help with both the conversation and the archiving / searching into the future, although we would want to retain the current archives for past conversations. We'd lose nothing btw - in that we could all send and receive emails to/from the list - or post and read messages online without any emails, and we'd have access to recent posts and, in time, archives, in the same way as for a news group. How many of you have not used a google group or a usenet group with a google interface? I find google groups very easy to use. Of those that are familiar with google groups - is there anything this list provides that they don't? Maybe someone at U2UG could put a survey up on the U2UG web-site to get some numbers for responses to these and similar questions. Such a move would get my vote. Cheers! --dawn -- Dawn M. Wolthuis Tincat Group, Inc. Take and give some delight today! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
Personally I appreciate what ever format works best for those individual that expend the time to make this thing work. If I have to do two things instead of one to post to the list or if I have to shake the cobwebs out of my aged old brain to make it work then even I will learn how to do it right. Just make it reasonable for the moderators and the techs that make this thing work. As a vote, I like it just fine the way it is. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 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/
RE: [U2] RE: [u2] bci
Rudy,
Looking at your UV BASIC BCI code and stored procedure, I suggest the
following:
A) I noticed that your stored procedure has 9 arguments, not 8 as you've
defined in your BCI code. You've ommitted the most important one - the
output argument. Isn't that what you're asking about?
B) I recommend you to use SQLExecDirect, instead of SQLExecute (see my
example)
C) When using SQLExecDirect, you will first need to define/declare your
stored procedure and argument list using parameter mark characters (?
characters).
That is, do not put the values in the declaration.
For example: MYSPROC = {sptestproc (?,?,?,?)}.
Secondly, you will need to define all the Input and Output arguments
with SQLBindParameter (see example I posted). Ensure the in correct
sequential order as the stored procedure inputs and outputs them.
Again, look at the example I posted and amend your own source code
appropriately.
Hope this helps.
Regards,
David
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unix Device Number
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/
RE: [U2] [UD] Triggers
David: Answers below. -Original Message- From: David Wolverton Sent: Thursday, March 16, 2006 11:36 AM To: 'Bill Haskett'; u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Triggers What was the driving force to move from D3 to UniData? According to our client: 1) They want the IBM name, 2) D3 costs too much, 3) Support isn't what it should be, 4) D3 is less than stable, 5) Raining Data is treading water. 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). These issues cause our conversion to extend from about 30 man-days to close to 150 man-days. Those who use UniData have no clue about the issues with conversion. Why anyone involved with UniData wouldn't want it to be used by others is beyond my comprehension. How did you actually DO the move - it's not like D3 files will copy at any high level to UniData! They actually do. Colin has had success with ACCOUNT.RESTORE while I copied to UniVerse then to UniData (of course this digression did take about 10 man-days). How long did it take to make the move (physically, once you worked out the kinks)? We have about 4 man-months into this. We estimate if UniData had taken steps to update itself and provided a few utilities to assist in conversions we would have only taken about one man-month (30 days isn't bad for an enterprise application conversion). Thanks -- I'm sure there are others here who would be interested in knowing more about your migration... David W. -Original Message- From: Bill Haskett Sent: Tuesday, March 14, 2006 7:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Triggers I've converted a client's system from D3 to UniData and everything mostly works fine. One of the last items I have to deal with are triggers. [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unix Device Number
Do a status against the file in a basic routine, and the device # is 11. You could write a program to do this and populate a file with the device #, the inode (field 10), and the full path. At least, that's what I do. You'll need to run it periodically. Inodes change; creating a new file, doing a resize, etc. will change the inodes. 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: phil walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Unix Device Number Date: Fri, 17 Mar 2006 16:10:52 +1300 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
Thanks Dan, I had thought of that, but as you highlighted the inode and to a far lesser extent the device number could change. Also this method relies on me knowing what the file is before hand. I want to know what the file is from the device and inode. Like a reverse lookup. The only way to achieve this with this method is to potentially create a file with a reference to every file/directory on the system and keep it up to date. Surely there must be a unix command or configuration file that I could call and parse. If figured if I can find out the mount point for the device via a command or config file then I could execute 'cd mount;find . -inum inode' and parse the results. off to google -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, 17 March 2006 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unix Device Number Do a status against the file in a basic routine, and the device # is 11. You could write a program to do this and populate a file with the device #, the inode (field 10), and the full path. At least, that's what I do. You'll need to run it periodically. Inodes change; creating a new file, doing a resize, etc. will change the inodes. 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: phil walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Unix Device Number Date: Fri, 17 Mar 2006 16:10:52 +1300 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Triggers
Bill, Why didn't you stop at Universe? Why go to Unidata? Universe has a Pick flavor that runs D3 almost just like D3 runs D3. Out TAPE.DUMP and TAPE.LOAD programs move all the files in an account directly from D3 to Universe in two simple steps. Our UvSpoolerPlus provides a generic Pick spooler for generic Pick software like D3 software running on Universe. The only conversion issues we faced recently in converting software from R91 to Universe were related to the syntax of the CONVERT statement and the fact that Universe is not comfortable comparing the numeric value of an alpha string with that of another alpha string - eg. IF ABC XYZ THEN etc. ( I can't understand why :)!). We're in the process of porting UvSpooler Plus to Unidata, as UdSpoolerPlus. Would UdSpoolerPlus help your D3 software feel more at home with a D3-like spooler and D3-like spooler commands? Would UdSpoolerPlus eliminate your need to re-program all of the print programs and procs in the D3 software? Please call me if we can be of assistance. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 16, 2006 7:39 PM Subject: RE: [U2] [UD] Triggers David: Answers below. -Original Message- From: David Wolverton Sent: Thursday, March 16, 2006 11:36 AM To: 'Bill Haskett'; u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Triggers What was the driving force to move from D3 to UniData? According to our client: 1) They want the IBM name, 2) D3 costs too much, 3) Support isn't what it should be, 4) D3 is less than stable, 5) Raining Data is treading water. 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). These issues cause our conversion to extend from about 30 man-days to close to 150 man-days. Those who use UniData have no clue about the issues with conversion. Why anyone involved with UniData wouldn't want it to be used by others is beyond my comprehension. How did you actually DO the move - it's not like D3 files will copy at any high level to UniData! They actually do. Colin has had success with ACCOUNT.RESTORE while I copied to UniVerse then to UniData (of course this digression did take about 10 man-days). How long did it take to make the move (physically, once you worked out the kinks)? We have about 4 man-months into this. We estimate if UniData had taken steps to update itself and provided a few utilities to assist in conversions we would have only taken about one man-month (30 days isn't bad for an enterprise application conversion). Thanks -- I'm sure there are others here who would be interested in knowing more about your migration... David W. -Original Message- From: Bill Haskett Sent: Tuesday, March 14, 2006 7:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Triggers I've converted a client's system from D3 to UniData and everything mostly works fine. One of the last items I have to deal with are triggers. [snipped] --- 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] [UD] Triggers
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/
