[U2] Problem un-subbing
Hi all I need to unsub for a while, and can't. I've been away for a day or two and received 665 U2 posts today. On going to the link I've entered both my email addresses and it cannot find any subscription details for No subscribed Lists For [EMAIL PROTECTED] Found. No subscribed Lists For [EMAIL PROTECTED] Found. As both email addresses are invalid I don't mind posting them. - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UVNT] How to check if current user is UV Administrator
Dear all, I want to check if the current user is OS/UV Administrator to perform restricted OS/UV commands like uvbackup/uvrestore! Under UV forWindows. Thanks for any comments. Manu Fernandes Infodata S.`r.l. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UVUX] How to check if current user is UV Administrator
Dear all, I want to check if the current user is OS/UV Administrator to perform restricted OS/UV commands like uvbackup/uvrestore! Under Unix implementation, the uv's documentation explain SYSTEM(27) return the OS User-Id and by the way, if User-ID is 0 ; it is root ! Ok, but if I log under unix with a non-root user and I execute a su or sudo to root and load a uv session, the SYSTEM(27) is 0 but uvbackup show errors and do'nt run correctly. By the same, if the non-root user is member of root group, uvbackup do'nt run correctly too. Any idea to be sure the user is UVAdministrator ? Many thanks Manu Fernandes Infodata S.`r.l. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata acount on unix
Than you all for the response (all below). I had tried 'newacct' and it didn't fly but I think the bit about including $UDTBIN in the path was the key. At any rate, once I used a full path to newacct it seemed to do the trick. Thanks! Martin Canty: just like Windoze, only better. 'newacct' You will also need to specify a valid unix group owner. Mike Randall: It's been a while but I believe it was makeudt? Wally Terhune: same.You can also avoid the lists and prompts for owner and group by specifying eg newacct root sys Ken Wallis: Its the same ... You might need to make sure that your PATH includes $UDTBIN, and indeed that $UDTBIN is set, but once that is done, newacct user group should work. Mike Randall: So what was makeudt? Martin Canty: If I remember (in my dim distant past), it's used to compile a new UniData executable... Used if custom C routines need to be compiled into UniData. Kevin King: ...to rebuild the udt executable from object libraries. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects Ports?
Hi, Everyone. I'm trying to get a program that works fine on our intranet, to work from a remote location. If I put in the external IP address of the server from 'outside' it never connects. I'm guessing this is a firewall issue. Are there any ports that need to be opened in the firewall specifically for UniObjects? Should I approach this a different way? Any other thoughts? Thanks, Dave --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Redback Startup
What has been the general experience with Implementing/Using Redback? Does one need training on this or can it easily be picked by oneself. If training is needed were can I get it. Any help on this subject would be greatly appreciated! Thanks, __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects Ports?
By default UDT UO works on port 31438, so You probablu must enable this Dave Tabor wrote: Hi, Everyone. I'm trying to get a program that works fine on our intranet, to work from a remote location. If I put in the external IP address of the server from 'outside' it never connects. I'm guessing this is a firewall issue. Are there any ports that need to be opened in the firewall specifically for UniObjects? Should I approach this a different way? Any other thoughts? Thanks, Dave --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 tel. +372 6566232 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uv pe
Replied to on u2-community. John Kent wrote: Leroy, so if a client wants to see some knowledge base article they must go from --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata acount on unix
Please also note, that in case You need unirpc, LANG should be C, otherwise You will run into problems with UOJ Susan Joslyn wrote: Than you all for the response (all below). I had tried 'newacct' and it didn't fly but I think the bit about including $UDTBIN in the path was the key. At any rate, once I used a full path to newacct it seemed to do the trick. Thanks! Martin Canty: just like Windoze, only better. 'newacct' You will also need to specify a valid unix group owner. Mike Randall: It's been a while but I believe it was makeudt? Wally Terhune: same.You can also avoid the lists and prompts for owner and group by specifying eg newacct root sys Ken Wallis: Its the same ... You might need to make sure that your PATH includes $UDTBIN, and indeed that $UDTBIN is set, but once that is done, newacct user group should work. Mike Randall: So what was makeudt? Martin Canty: If I remember (in my dim distant past), it's used to compile a new UniData executable... Used if custom C routines need to be compiled into UniData. Kevin King: ...to rebuild the udt executable from object libraries. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 tel. +372 6566232 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] wintegrate query builder question
I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Problem un-subbing
Go to http://listserver.u2ug.org/. Enter your email address and click unsub then click GO. Ron White - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, February 18, 2005 2:52 AM Subject: [U2] Problem un-subbing Hi all I need to unsub for a while, and can't. I've been away for a day or two and received 665 U2 posts today. On going to the link I've entered both my email addresses and it cannot find any subscription details for No subscribed Lists For [EMAIL PROTECTED] Found. No subscribed Lists For [EMAIL PROTECTED] Found. As both email addresses are invalid I don't mind posting them. - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [ E-mail scanned Virus Free by NAI - McAfee anti-virus system ] --- [ E-mail scanned Virus Free by NAI - McAfee anti-virus system ] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
John, Basically, it comes down to a cultural (as in PICK community preference). The logic is that dictionaries are cheap, easy, and reusable, so why not create a virtual field. Back in the bad old days database structures were fairly rigid constructs. PICK was one of the only models that maintained a very clear separation of data field definition from the actual data. So the habit/technique/culture was to take advantage of that flexibility. Today you have a choice. You can create virtual fields on the fly in a retrieve statement. At least you can in UV. The exact syntax is not at my finger tips as I don't use it often (I prefer to create a dictionary) but it is covered in the manuals. As I recall it is only slightly more complicated than a similar function in SQL. Of course, as someone mentioned earlier, you do have the option of doing SQL syntax in UV today too. Having created complex reports both in UV and in native SQL (non-U2 database) my opinion is that SQL is stronger in creating complex relational reporting and retrieve is better at quick column oriented reports. Once you know the language neither is significantly more difficult than the other. They both have strengths and weaknesses. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 17, 2005 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe True, I really shouldn't write off anything that I am not informed about, but we have programmers here that have been programming Unidata since time immemorial and they don't know how to do something like a select statement that converts criteria into caps for comparison. E.g. SELECT blah WITH UPCASE(x) LIKE ...HELLO... (Doesn't work, but is what I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that method, but the logic of it completely escapes me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: Thursday, February 17, 2005 2:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe John, There is also a huge amount of things which can be done with a single line query in both UD and UV. Because you don't know how to do them does not mean they cannot be done. As you say, you are new, it's an unwise man who rubbishes a product he knows little about. Suggest you ask a few questions, especially on the issues which take so much time to do. Andy -Original Message- From: Aherne, John [mailto:[EMAIL PROTECTED] Sent: 17 February 2005 20:31 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Ease of development? Very little support required? I have just started to use UD, and development is horrific, it take 10 times longer to do things that can be accomplished by a single line query in an RDBMS'. Our system requires constant attention, more attention than even MS Sql server on a bad week. But the thing that annoys me most is the poor support from IBM. I cannot get access to some of their tech docs because our UD license is held by our VAR (Don't ask). What kind of policy is that? For any other DBMS I can get access to vast amounts of information, and I don't even need to have seen the software, nevermind have a license. I looked forward to working with UD when I found out I would be developing on it, I have never used an mvdbms before, and the concept intrigued me. But so far, I do not see any benefit to using UD for anything what-so-ever, and nothing IBM or our VAR has provided has even hinted that UD, and UV are anything but an archaic relic of times gone by, like COBOL. Why else would a company make it so difficult for someone to learn about development on their software, if not because they didn't really have any interest in supporting it, and believe that you should have upgraded to more modern technology already? Regards, John Aherne --- 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] uv pe
Leroy, I am sorry, but that argument doe not hold water. The client has purchased, whether directly or indirectly, a U2 database product. They have full access to the system to do their own development if they desire. They should be able to review any available knowledge-base. I can not think of any other database product or associated development tool that does not have this. It may not be a good one, but they don't wave information in front of people then say you can't have it. The client is the one that ultimately paid for the license not the VAR. If the VAR wants to lock-down their client to prevent modifications that is their responsibility. I feel safe in saying this as I used to be a VAR working for a company that marketed an ERP system on UV. Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe IBM isn't treating you unfairly, John. We sell through business partners and they act according to their own business models and contractual obligations with their clients as well as with their vendors. For technical information, your reseller (in your case, your Master VAR) would be the responsible party to provide it- that is the agreement your business has with your reseller. That is the agreement they have with us. A very good way to obtain technical information is to attend our annual technical conferences. An excellent (and quicker) way is to post your questions here on the u2-users list server, run by the U2 Users Group. This is a great community of very knowledgeable and helpful individuals. Having said that, U2TechConnect did not prevent you from accessing the personal editions. Anyone, including those folks that do not work for a business using U2 products could download them. That was the point. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 John Kent [EMAIL PROTECTED] m.au To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] uv pe 02/16/2005 03:19 PM Please respond to [EMAIL PROTECTED] er.u2ug.org What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org, [EMAIL PROTECTED]
RE: [U2] Unidata acount on unix
Actually, having just done a Linux compile, all this is fresh in my head!! Make sure your .profile exports LANG=C, or it you are still in the testing mode, before you start udt (the $ is the *nix prompt): $LANG=C $export LANG ${fill in your UDTBIN path here}/udt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lembit Pirn Sent: Friday, February 18, 2005 8:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata acount on unix Please also note, that in case You need unirpc, LANG should be C, otherwise You will run into problems with UOJ Susan Joslyn wrote: Than you all for the response (all below). I had tried 'newacct' and it didn't fly but I think the bit about including $UDTBIN in the path was the key. At any rate, once I used a full path to newacct it seemed to do the trick. Thanks! Martin Canty: just like Windoze, only better. 'newacct' You will also need to specify a valid unix group owner. Mike Randall: It's been a while but I believe it was makeudt? Wally Terhune: same.You can also avoid the lists and prompts for owner and group by specifying eg newacct root sys Ken Wallis: Its the same ... You might need to make sure that your PATH includes $UDTBIN, and indeed that $UDTBIN is set, but once that is done, newacct user group should work. Mike Randall: So what was makeudt? Martin Canty: If I remember (in my dim distant past), it's used to compile a new UniData executable... Used if custom C routines need to be compiled into UniData. Kevin King: ...to rebuild the udt executable from object libraries. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 tel. +372 6566232 [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] Redback Startup
We have been using Redback for over 4 years now. The learning curve is not that easy for Unidata/Universe programmers. The paradigm switch to coding in ASP/JavaScript/HTML is not that hard, but the debugging can be quite overwhelming. I would recommend at least two or three days training on Redback. We have found the learning curve to be at least 4 to 8 weeks. As an IBM VAR we offer on-site and local training for our customers and clients. Our IBM certified staff have the real world experience creating web software. We are not just trainers, but we are programmers that can teach. Additionally, we sell a tool, called XLr8, which uses Redback to create the code and therefore minimizes the amount of effort and knowledge needed. Our tool creates the ASP/JSP code to run your page along with the HTML/JavaScript automatically. We have a new enhancement for XLr8 that helps the SB+ programmers convert their applications to the web. You can go to our web site at http://www.u2logic.com/xlr8_GuidedTours.htm to see the product in action via some movies examples and data sheets. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Castilletti Sent: Friday, February 18, 2005 6:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] Redback Startup What has been the general experience with Implementing/Using Redback? Does one need training on this or can it easily be picked by oneself. If training is needed were can I get it. Any help on this subject would be greatly appreciated! Thanks, __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com --- 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] EVAL keyword -- was: uv pe
John, Per the Unidata 6.1 manual on the IBM web site: EVAL Syntax EVAL expression Description --- The UniQuery EVAL keyword allows you to define a virtual attribute expression for the current execution of a UniQuery statement only. expression can be any expression valid in a virtual attribute. You must enclose expression in single or double quotation marks. Note: UniQuery only supports the EVAL keyword in ECLTYPE U. -- You could do something like this (at least in UniVerse :) SELECT blah WITH EVAL UPCASE(@RECORDattribute number) LIKE ...HELLO... That would create an on-the-fly virtual field for the comparison. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 17, 2005 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe snip converts criteria into caps for comparison. E.g. SELECT blah WITH UPCASE(x) LIKE ...HELLO... snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Problem un-subbing
Or, Send an email to [EMAIL PROTECTED] the body text of unsubscribe u2-users to resubscribe send majordomo an email with subscribe u2-users Bruce M Neylon Health Care Management Group Ron White [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/18/2005 09:28 AM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Problem un-subbing Go to http://listserver.u2ug.org/. Enter your email address and click unsub then click GO. Ron White - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, February 18, 2005 2:52 AM Subject: [U2] Problem un-subbing Hi all I need to unsub for a while, and can't. I've been away for a day or two and received 665 U2 posts today. On going to the link I've entered both my email addresses and it cannot find any subscription details for No subscribed Lists For [EMAIL PROTECTED] Found. No subscribed Lists For [EMAIL PROTECTED] Found. As both email addresses are invalid I don't mind posting them. - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [ E-mail scanned Virus Free by NAI - McAfee anti-virus system ] --- [ E-mail scanned Virus Free by NAI - McAfee anti-virus system ] --- 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] uv pe
Replied to on u2-community. Richard Taylor wrote: Leroy, I am sorry, but that argument doe not hold water. The client has purchased, whether directly or indirectly, a U2 database product. They have full access to the system to do their own development if they desire. They should be able to review any available knowledge-base. I can not think of any other database product or associated development tool that does not have this. It may not be a good one, but they don't wave information in front of people then say you can't have it. The client is the one that ultimately paid for the license not the VAR. If the VAR wants to lock-down their client to prevent modifications that is their responsibility. I feel safe in saying this as I used to be a VAR working for a company that marketed an ERP system on UV. Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 17, 2005 11:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe IBM isn't treating you unfairly, John. We sell through business partners and they act according to their own business models and contractual obligations with their clients as well as with their vendors. For technical information, your reseller (in your case, your Master VAR) would be the responsible party to provide it- that is the agreement your business has with your reseller. That is the agreement they have with us. A very good way to obtain technical information is to attend our annual technical conferences. An excellent (and quicker) way is to post your questions here on the u2-users list server, run by the U2 Users Group. This is a great community of very knowledgeable and helpful individuals. Having said that, U2TechConnect did not prevent you from accessing the personal editions. Anyone, including those folks that do not work for a business using U2 products could download them. That was the point. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 John Kent [EMAIL PROTECTED] m.au To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] uv pe 02/16/2005 03:19 PM Please respond to [EMAIL PROTECTED] er.u2ug.org What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org, [EMAIL PROTECTED]
[U2] Universe usm permissions
I am trying to allow users to be able issue 'usm -r' command. I put an option on their menu to 'Release Delivery Slips' (which are still in the spooled due to 'RETAIN'). This basically does a 'usm -r 160' (160 being the spool #). When I issue this as a 'general user', the file does not release. I tried doing 'chmod u=rws usm' or 'chmod +s usm'. I belive this was done on the DG/UX system, we had to set a 'sticky bit' for users to have acces to this command. I am looking thru a possible solution via ACL's. Anyone, already solve this problem ? Anthony --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wintegrate query builder question
Kevin: Try sending it to the Report Viewer first then export it from there. I think this will be easier. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] Redback Startup
John As with all things it depends on your existing knowledge! As a minimum you will need to know: Database programming (UniBasic or UniVerse Basic) HTML Active Server Pages VBScript You will also need to be confident designing and building web sites. RedBack is an enabling tool, not a site builder. That means you need all the attendant page design, validation and navigation skills (CSS, JavaScript and so forth). You also need to be able to write fast, efficient database code. If you have all of these areas of knowledge, RedBack will be straight forward. If not, the main thing is to find some training that covers as many of those bases as possible. RedBack is NOT difficult - none of these technologies are and you don't have to be an expert in any of them (except possibly the database) to write a good RedBack application - but it is having the mix of knowledge that is important. I would also find somebody else to look after the web server and internet connection side of things if this is for public access. That gives you someone else to shout atbackspacebackspaceresolve issues with. Regards, Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate query builder question
Hi Kevin, I believe you are running into invalid dict items or dict items that don't work in your query. It appears you were able to run the report to the screen without a problem, is that true? In Query Builder, try changing the output destination to Screen and see if it works. I wondering if you added a dict items to the 'Items', 'Sort', and/or 'Output' fields on your Query Builder screen that may not be valid. What happens to me: * For output to PC (excel), if I have a bad/non-existent dict item I get that QueryImport to PC failed Invalid Fields message * If I change the Query to go to the screen then I get a different message for a non-existent dict item: At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' not recognized You can do the 'old' trial and error testing of your Query and eliminate 1 dict item at a time until you get it working... Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] uv pe
Richard wrote: Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. I believe Richard, that on the www.u2ug.org website there is a place there somewhere to suggest enhancements. So this request doesn't get lost, maybe you would be interested in posting it there? HTH Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Redback Startup
Brian wrote: RedBack will be straight forward. If not, the main thing is to find some training that covers as many of those bases as possible. RedBack is NOT difficult - none of these technologies are and you don't have to be an expert in any of them The problem here is that IBM is behind a tool that happens to be the most difficult one of the breed to work with imho ! And possible the most expensive as well. Of course it may be the best at certain things. But those of us who want to get out business on the web don't necessarily want to spend three weeks in training and another nine months figuring out how to use it. Mostly we just want to start using it. So to my mind, that's a real problem. As a programmer, using ASP without Redback at all, I'm at least able to start getting interaction from U2 to and from the web and can learn as I go. And so far it hasn't cost me anything. Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uv pe
Charles wrote: (1) Please move this to U2-Community. (2) Please don't kill the messenger. Some of the comments to Leroy (who is taking his own time to respond to us) are bordering on rude. Your reply-to list is not community. Many people don't know *how* to take it to community. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wintegrate query builder question
Which version on wIntegrate and Excel are you using? I have found that it does not work with all versions of Excel. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] u2TechConnect
Gary wrote: To some degree I would like to know about a 64bit file Header corruption and how to run the tools to fix. Or how to find out if I have 32bit or 64bit files. But really I just need to know about UVADMIN, COPY and cpio, Named or Unnamed Common, indexes and @SELECT in a dictionary or a knarly Gary both of these issues have been discussion on this list and are in the archives. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe usm permissions
How about creating a phantom process that runs as Administrator to issue your command? It can watch for an entry in file, which would be the spooler number, then it would issue the usm command without having to give normal users the extra rights of an admin. Just a thought. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Friday, February 18, 2005 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe usm permissions I am trying to allow users to be able issue 'usm -r' command. I put an option on their menu to 'Release Delivery Slips' (which are still in the spooled due to 'RETAIN'). This basically does a 'usm -r 160' (160 being the spool #). When I issue this as a 'general user', the file does not release. I tried doing 'chmod u=rws usm' or 'chmod +s usm'. I belive this was done on the DG/UX system, we had to set a 'sticky bit' for users to have acces to this command. I am looking thru a possible solution via ACL's. Anyone, already solve this problem ? Anthony --- 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] uv pe
What an absolutely wonderful idea! Glad I thought of it ;) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Richard wrote: Perhaps IBM could work with this group to establish a generally available knowledge-base within this community's web-space. I believe Richard, that on the www.u2ug.org website there is a place there somewhere to suggest enhancements. So this request doesn't get lost, maybe you would be interested in posting it there? HTH Will Johnson --- 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] Redback Startup
I think Brian's comments were excellent and very accurate. Redback itself is relatively easy to use. I think he hit it right on the head with it's the myriad of other technologies that can make it seem daunting. Coming from a U2/Pick background, the major hurdles in my learning curve were clearly the web technologies. You need knowledge of html/javascript/vbscript/ASP to put out commercial grade browser based product. Now you have .Net or the Java world worlds as the latest technology options to use with Redback. Redback is a piece of cake if you know the web side. As you get into UOJ, the exact same learning curve applies. I think your level of productivity would be about the same with Redback. In fact, I'd say the curve you go through with UOJ is the same as that of Redback with .Net. Very similar stuff IMO. As you get to issues like scaling up or apps that support a larger number of users, Redback will shine and it works with all the web the technologies (ASP/ASP.Net/Java/JSP). Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Redback Startup The problem here is that IBM is behind a tool that happens to be the most difficult one of the breed to work with imho ! And possible the most expensive as well. Of course it may be the best at certain things. But those of us who want to get out business on the web don't necessarily want to spend three weeks in training and another nine months figuring out how to use it. Mostly we just want to start using it. So to my mind, that's a real problem. As a programmer, using ASP without Redback at all, I'm at least able to start getting interaction from U2 to and from the web and can learn as I go. And so far it hasn't cost me anything. Will Johnson Fast Forward --- 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] wIntegrate query builder question
I ran it to the screen with out any issue. I ran it to report viewer and got a timed out error. So I don't think is has to do with the dictionary items. Any other possibilities??? Kevin At 09:37 AM 2/18/2005 -0800, you wrote: Hi Kevin, I believe you are running into invalid dict items or dict items that don't work in your query. It appears you were able to run the report to the screen without a problem, is that true? In Query Builder, try changing the output destination to Screen and see if it works. I wondering if you added a dict items to the 'Items', 'Sort', and/or 'Output' fields on your Query Builder screen that may not be valid. What happens to me: * For output to PC (excel), if I have a bad/non-existent dict item I get that QueryImport to PC failed Invalid Fields message * If I change the Query to go to the screen then I get a different message for a non-existent dict item: At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' not recognized You can do the 'old' trial and error testing of your Query and eliminate 1 dict item at a time until you get it working... Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] Election Results
I would like to congratulate David Jordan on winning the runoff election for the last member-at-large seat with the U2 board. Looking forward to a great year with the u2ug! To the board: Please feel free to call upon me as an extra [unofficial] resource should such a thing be needed in the coming year. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] u2TechConnect
Which are at www.indexinfocus.com [EMAIL PROTECTED] wrote: Gary wrote: To some degree I would like to know about a 64bit file Header corruption and how to run the tools to fix. Or how to find out if I have 32bit or 64bit files. But really I just need to know about UVADMIN, COPY and cpio, Named or Unnamed Common, indexes and @SELECT in a dictionary or a knarly Gary both of these issues have been discussion on this list and are in the archives. Will Johnson --- 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] Redback Startup
Or you can separate out the data layer from the presentation layer. Programmers - Respsonsible for Redback object properties (fields) and methods (databasic programs) REAL Web Designers - Responsible for website presentation. Redback allows web designers to be web designers and programmers, dba's, etc. to stay in their own little data world. My 2cents, Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 [EMAIL PROTECTED] 12:23:18 PM 02/18/2005 [Snipped..]' As a minimum you will need to know: Database programming (UniBasic or UniVerse Basic) HTML Active Server Pages VBScript You will also need to be confident designing and building web sites. RedBack is an enabling tool, not a site builder. That means you need all the attendant page design, validation and navigation skills (CSS, JavaScript and so forth). You also need to be able to write fast, efficient database code. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate query builder question
Could be that when you view the report the access statement is throwing away (not using) the bad dict item but sending your output to Report Viewer or PC cannot do so. Note, when using an invalid dict item and sending the output to Report View I also get the same error message that outputting to excel gave me. * What release of wIntegrate do you have? I'm using 4.2.1. I also have earlier releases of wIntegrate but the 4.2.1 utility programs are probably loaded on my system - I'm sure they are. Check the help-about to see what release you have. I would suggest Viewing it, examine the data to see what column you are missing from the Output dict items you have in the Query Builder to find the bad dict item. If that doesn't work, I guess I'm back to the eliminating dict items one at a time until you get the report to output to Excel. Try outputting to Excel97, later releases won't work as my old friend Kathleen Bodine mentioned (Hi Kathleen). Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 10:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] wIntegrate query builder question I ran it to the screen with out any issue. I ran it to report viewer and got a timed out error. So I don't think is has to do with the dictionary items. Any other possibilities??? Kevin At 09:37 AM 2/18/2005 -0800, you wrote: Hi Kevin, I believe you are running into invalid dict items or dict items that don't work in your query. It appears you were able to run the report to the screen without a problem, is that true? In Query Builder, try changing the output destination to Screen and see if it works. I wondering if you added a dict items to the 'Items', 'Sort', and/or 'Output' fields on your Query Builder screen that may not be valid. What happens to me: * For output to PC (excel), if I have a bad/non-existent dict item I get that QueryImport to PC failed Invalid Fields message * If I change the Query to go to the screen then I get a different message for a non-existent dict item: At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' not recognized You can do the 'old' trial and error testing of your Query and eliminate 1 dict item at a time until you get it working... Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe usm permissions
Good thought. I have a JOB.MONITOR that is kicked off by cron (as root) that does all the batch processing. This program processes a number of job queues. I was thinking that if I couldn't get this done via access rights, then I would resort to this and just set up a job queue for printer commands. I had to do something similar with list_readu and ipcs to allow users the ability to issue LIST.READU and PORT.STATUS. It is required by managers to help to determine who to log off when needed (not often). The solution to allow users access to these commands was 'chmod u=rws /usr/bin/ipcs'. This did the trick ! So, I figured that I'd try to find out what is going on during the command 'usm -r 160'. I did 'strace usm -r 160' and examined the output for when it worked (logged on as root) and when it didn't (logged on as me). The only difference was when the call to geteuid32() was made. For root, it returned '0'. For me, it returned '500'. I really don't see anything else - no errors, etc ... Thanks Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, February 18, 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe usm permissions How about creating a phantom process that runs as Administrator to issue your command? It can watch for an entry in file, which would be the spooler number, then it would issue the usm command without having to give normal users the extra rights of an admin. Just a thought. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Friday, February 18, 2005 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe usm permissions I am trying to allow users to be able issue 'usm -r' command. I put an option on their menu to 'Release Delivery Slips' (which are still in the spooled due to 'RETAIN'). This basically does a 'usm -r 160' (160 being the spool #). When I issue this as a 'general user', the file does not release. I tried doing 'chmod u=rws usm' or 'chmod +s usm'. I belive this was done on the DG/UX system, we had to set a 'sticky bit' for users to have acces to this command. I am looking thru a possible solution via ACL's. Anyone, already solve this problem ? Anthony --- 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] EVAL keyword -- was: uv pe
I tried the 'EVAL @RECORDn', but can't seem to get it to work. I've always had to resort to referencing the DICT ID for that loc, and we're using UD. Is there an options setting that would enable this for me? For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Virtual fields calling Virtual fields
Hi All, Is it a bad thing when a virtual field references a virtual field in another file, which calles a sub-routine to retrieve values from yet another file? Does that even make sense? If not, how far could one take that before things do get bad? Thanks, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Virtual fields calling Virtual fields
John, Never tried to see how far it would go. The real issue is inefficiencyeach virtual field requires an additional read from the dictionary in which it is located. Doing this for every item in a report, you can see where the overhead makes chaining virtual fields inefficient. Drew Aherne, John wrote: Hi All, Is it a bad thing when a virtual field references a virtual field in another file, which calles a sub-routine to retrieve values from yet another file? Does that even make sense? If not, how far could one take that before things do get bad? Thanks, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -- Drew Henderson 110 Ginger Hall Dir. for Computer Center OperationsMorehead State University [EMAIL PROTECTED] Morehead, kY 40351 (606) 783-2445 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wintegrate query builder question
Excel 2002 and wIntegrate version 4.2. Are there any know issues with those versions. Kevin At 10:04 AM 2/18/2005 -0800, you wrote: Which version on wIntegrate and Excel are you using? I have found that it does not work with all versions of Excel. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] EVAL keyword -- was: uv pe
That works. Thank you. SW -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] EVAL keyword -- was: uv pe For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL keyword -- was: uv pe
Really?! Yuck. I never knew that. That's just plain mean. 2nd good candidate today for www.u2ug.org forums enhancements. I tried the 'EVAL @RECORDn', but can't seem to get it to work. I've always had to resort to referencing the DICT ID for that loc, and we're using UD. Is there an options setting that would enable this for me? For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Virtual fields calling Virtual fields
Hey John, Actually, it makes perfect sense. In the old days, where you had 20 dumb terminals attached to a system that barely equaled the processing power of a 10 MHz PC-AT, you could really hammer the system by having embedded calls in dict items. The old days were the early 90's. 15 years later, the systems are so incredibly fast that you can get away with doing just about anything no matter how complex However, the methodology remains the same. Try it, and if it's not too slow to live with, then it's fine. If it's slower than molasses on a cold winter morning AND you're in a hurry, then it's time to try a different approach. If your willing to wait, then again, it's fine. I recently had a client that wanted a report that pulled from an enormous transactional based file. I offered to create an index to improve performance, but they declined saying that there were currently using Excel and manual data entry to create the same report at the end of the month, and that having it run in 15 minutes instead of 10 seconds was acceptable. So I just wrote it with a simple SELECT and it takes 15 minutes and they're happy as heck that it takes 15 minutes instead of the two days it used to take them to do it in Excel. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aherne, John Sent: Friday, February 18, 2005 11:37 To: u2-users@listserver.u2ug.org Subject: [U2] Virtual fields calling Virtual fields Hi All, Is it a bad thing when a virtual field references a virtual field in another file, which calles a sub-routine to retrieve values from yet another file? Does that even make sense? If not, how far could one take that before things do get bad? Thanks, John --- 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] Virtual fields calling Virtual fields
inefficient compared to what? And Inefficient measured how? And is said Efficiency necessarily the significant software quality attribute when up against competing attributes such as Maintainability, Reusability, Robustness. Of course, there's no single right answer. I'm just being curmudgeonly. So, John, you often have to take things very very far before things get bad. Virtual fields are very very nice. (except for that EXTRACT() instead of varfld business mentioned earlier today. Now I'm being curmudgeonly again.) cds -Original Message- From: Drew Henderson John, Never tried to see how far it would go. The real issue is inefficiencyeach virtual field requires an additional read from the dictionary in which it is located. Doing this for every item in a report, you can see where the overhead makes chaining virtual fields inefficient. Drew Aherne, John wrote: Hi All, Is it a bad thing when a virtual field references a virtual field in another file, which calles a sub-routine to retrieve values from yet another file? Does that even make sense? If not, how far could one take that before things do get bad? Thanks, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate query builder question
Kevin, What version of wIntegrate are you using? I've noticed on version 5.2 if you specify in the before box GET-LIST without an actual get-list name (assuming that it will pick up your most current TEMPXXX list) it will fail with the same error. Gerral -Original Message- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] wIntegrate query builder question I ran it to the screen with out any issue. I ran it to report viewer and got a timed out error. So I don't think is has to do with the dictionary items. Any other possibilities??? Kevin At 09:37 AM 2/18/2005 -0800, you wrote: Hi Kevin, I believe you are running into invalid dict items or dict items that don't work in your query. It appears you were able to run the report to the screen without a problem, is that true? In Query Builder, try changing the output destination to Screen and see if it works. I wondering if you added a dict items to the 'Items', 'Sort', and/or 'Output' fields on your Query Builder screen that may not be valid. What happens to me: * For output to PC (excel), if I have a bad/non-existent dict item I get that QueryImport to PC failed Invalid Fields message * If I change the Query to go to the screen then I get a different message for a non-existent dict item: At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' not recognized You can do the 'old' trial and error testing of your Query and eliminate 1 dict item at a time until you get it working... Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Virtual fields calling Virtual fields
Yah, when I started programming, I used to count the clock cycles of instructions in C to see which method to use to do things :) I guess I have never gotten out of that mentality, which is why it offends my sensibilities to do things just because it is the easy way. I thought, though, that maybe that UD might do some magic in the way it handles things like nested calls to VF's. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Friday, February 18, 2005 1:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Virtual fields calling Virtual fields Hey John, Actually, it makes perfect sense. In the old days, where you had 20 dumb terminals attached to a system that barely equaled the processing power of a 10 MHz PC-AT, you could really hammer the system by having embedded calls in dict items. The old days were the early 90's. 15 years later, the systems are so incredibly fast that you can get away with doing just about anything no matter how complex However, the methodology remains the same. Try it, and if it's not too slow to live with, then it's fine. If it's slower than molasses on a cold winter morning AND you're in a hurry, then it's time to try a different approach. If your willing to wait, then again, it's fine. I recently had a client that wanted a report that pulled from an enormous transactional based file. I offered to create an index to improve performance, but they declined saying that there were currently using Excel and manual data entry to create the same report at the end of the month, and that having it run in 15 minutes instead of 10 seconds was acceptable. So I just wrote it with a simple SELECT and it takes 15 minutes and they're happy as heck that it takes 15 minutes instead of the two days it used to take them to do it in Excel. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aherne, John Sent: Friday, February 18, 2005 11:37 To: u2-users@listserver.u2ug.org Subject: [U2] Virtual fields calling Virtual fields Hi All, Is it a bad thing when a virtual field references a virtual field in another file, which calles a sub-routine to retrieve values from yet another file? Does that even make sense? If not, how far could one take that before things do get bad? Thanks, John --- 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] Virtual fields calling Virtual fields
I recently had a client that wanted a report that pulled from an enormous transactional based file. I offered to create an index to improve performance, but they declined saying that there were currently using Excel and manual data entry to create the same report at the end of the month, and that having it run in 15 minutes instead of 10 seconds was acceptable. So I just wrote it with a simple SELECT and it takes 15 minutes and they're happy as heck that it takes 15 minutes instead of the two days it used to take them to do it in Excel. We are in the midst of converting from D3 to UniData on AIX (RS/6000 M80). I just tested an inventory select that takes nearly two hours on D3. It finished in under 8 minutes on UniData. This involves selecting about 30,000 records from a file of nearly 800,000 VERY large records, about 60% of them over 2K, i.e. pointer items on D3. That's a pretty dramatic improvement. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Boyd, Dewey, Cheatham and Howe -- Attorneys at Law === -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Virtual fields calling Virtual fields
The real issue is inefficiencyeach virtual field requires an additional read from the dictionary in which it is located. Doing this for every item in a report, you can see where the overhead makes chaining virtual fields inefficient. I think that the above conjecture is probably wrong. I think if you generated (compiled) a compound dictionary (C) made up of dictionary A and B. Then you deleted dictionary A B the compound dictionary, A, would still work (though would not recompile in the future). Thus, proving, there is no read at runtime of component dictionaries. Hence, it can be stated that there is no particular inefficiency caused by compounding dictionaries, other than the efficiency of the components themselves. In fact, there are some that would say that the construction of new , more complex, components from existing simpler components is something to be desired. Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Virtual fields calling Virtual fields
FWIW, Although in theory this technique may logically access multiple dictionary items for every record read, and potentially worse, if other records are accessed by some foreign key, in practice there is so much cache memory floating around in a commercial (and even home based) system, that the physical reads are only a fraction of what they used to be, in coal-powered systems. For a start, one I-type may use several other I-types in its execution but they are compiled into pseudo-subroutine so it is NOT the case that each element causes a Dict read. So in the case of say 3 Dict entries TOM, DICK and HARRY where TOM = A+B, DICK = C+D and HARRY = TOM + DICK , once they have been compiled TOM and DICK can be deleted but independent HARRY keeps on running (at least until it gets re-compiled). Even paged memory is unlikely to be rolled out to disk as this is only likely to happen if your discs [US translation: Disks] cannot deliver data fast enough to keep the cache alive. If however you use a foriegn key to access a record from secondary file from whence you need several fields (e.g. a read to a Product record for Description, weight, and colour [color]) then you could shave off a little time by pulling-in the whole record in one hit (@record) and slice and dice it within the I-type or subroutine. For a one-off this may not be worth the time to set up, but a weekly run on a big file is another story. Sadly, I'm getting a bit rusty on Uv these days as all our new stuff is SQL based - but keep flying the flag y'hear. Ray (the celt [kelt]) - G! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/