Re: [U2] Attribute Problem
I would guess that the calculation is trying to subtract MATL from F. Could it be enclosed in quotes or something? Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions (p) 262-432-3897 (c) 262-227-9619 Real-World Solutions for Real-World Problems! www.tri-sysconsulting.com View my LinkedIn R Profile -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, May 02, 2012 2:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Attribute Problem Hi. I think I have finally gone insane. I am having a problem with the attribute MATL.AMT. It calculates the extended amount on hand by taking the frozen material cost times the on hand amount. The problem is when I use F_MATL for the frozen material cost, MATL.AMT is good. When I use F-MATL for the frozen material cost, it returns 0 everytime. F_MATL and F-MATL are identical and if you list them both work fine. But when they are used in the calculation F_MATL works, but F-MATL. doesn't. Can anyone see what the problem is? ** :AE DICT INVENTORY-LOCATION_18 MATL.AMT Top of "MATL.AMT" in "DICT INVENTORY-LOCATION_18", 6 lines, 43 characters. *--: P 001: V 002: ON.HAND * F-MATL 003: MR25, 004: MATERIAL.AMT 005: 13R 006: S Bottom. ** :AE DICT INVENTORY-LOCATION_18 F_MATL Top of "F_MATL" in "DICT INVENTORY-LOCATION_18", 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, "G0*1"); OCONV(@2, "TINVENTORY-MASTER*18;X;66;66") 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. *** :AE DICT INVENTORY-LOCATION_18 F-MATL Top of "F-MATL" in "DICT INVENTORY-LOCATION_18", 6 lines, 93 characters. *--: P 001: V 002: @ID; OCONV(@ID, "G0*1"); OCONV(@2, "TINVENTORY-MASTER*18;X;66;66") 003: MD5, 004: MATERIAL/UNIT 005: 13R 006: S Bottom. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calling U2UG Members
Allen Egerton wrote: >Will, > >How about a third choice? > >Dan's post is a RE-POSTING from last year, from before when he worked >for Rocket... > > > >On 3/9/2012 12:51 PM, Wjhonson wrote: >> >> You work for Rocket. >> There are 20 U2 people there, and only 2 have "heard" of U2UG. >> Words fail me. >> I'm not sure if I should be just amazed or righteously angry. >> >> >> -Original Message- >> From: Daniel McGrath >> To: U2 Users List >> Sent: Fri, Mar 9, 2012 9:12 am >> Subject: Re: [U2] Calling U2UG Members >> >> >> Hi Brian/U2UG, >> Now that I work for Rocket, I'm not sure if I should still vote. Thoughts? >> If I can, I'd like to reiterate the questions I posed this time last year >> before >> do vote. >> " Hi all, >> I've posted an open letter regarding the U2UG elections to the nominees. I'd >> ove to see more dialogue around these elections as I feel I don't really >> now what I'm voting for when I place my votes. >> http://u2tech.wordpress.com/2011/03/15/u2ug-elections-2011/ >> Along with this, I also wonder how many people on this list are members of >> he U2UG and how many actually vote? I've never seen any numbers. I know I'm >> ne of two out of the roughly 20 U2 people at my work who know of the U2UG >> nd am the only member. Not the greatest odds. On the positive side, it >> eaves a lot of room to expand. :) >> Regards, >> an" >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Icons
Colin Alfke wrote: >There is a technote on the availability matrix. > >hth >Colin Alfke > >-Original Message- >From: Israel, John R. > >Disabling Aero sounds familiar! It is Windows 7 - 64 bit. SB Client 5.4. > >HOW do I disable Aero w/ SB? > >Thanks > >John Israel > > >-Original Message- >From: Colin Alfke > >Try disabling Aero mode for SBClient. Which version of SBClient and is it 32 >or 64 bit Windows 7? > >hth >Colin Alfke >Calgary, Canada > >-Original Message- >From: Israel, John R. > >We have a user that just loaded SB onto a Windows 7 box. In GUI mode, she >is not getting the icons at the top of the window (Home, Back, Favorites, >etc). > >Anyone know how to fix this? > > >John Israel > > >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ENCRYPT in Universe
In which version, 10.2? The last time I tried it failed, but maybe I was doing it wrong. I don't remember what version this system is on but I'll look that up tonight. Thanks, Curt Daniel McGrath wrote: >Indexing encrypted fields should already be available in UniVerse. > >This functionality is also on the roadmap for UniData 7.4. > >Regards, > >Dan McGrath >U2 Product Manager >Rocket Software >4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA >Tel: +1.720.475.8098 * Fax: +1.617.630.7392 >Email: dmcgr...@rs.com >Web: www.rocketsoftware.com/u2 > > >-Original Message- >From: u2-users-boun...@listserver.u2ug.org >[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes >Sent: Wednesday, September 28, 2011 8:56 AM >To: 'U2 Users List' >Subject: Re: [U2] ENCRYPT in Universe > >Data At Rest encryption became available with UV 10.2 I believe. We >implemented it after that upgrade. > >If you're asking whether you can INDEX an Encrypted DAR field, I rather doubt >it, but have not tried it. > >I would ping Nic Kesic with this question; perhaps he is listening or has a >google alert set for his name. > >Thank you. >-Baker > > > >-Original Message- >From: u2-users-boun...@listserver.u2ug.org >[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart >Sent: Wednesday, September 21, 2011 11:41 AM >To: U2 Users List >Subject: Re: [U2] ENCRYPT in Universe > >DAR = Data At Rest > >John Thompson wrote: > >>Or better yet, what is DAR? >> >>On Wed, Sep 21, 2011 at 12:11 PM, Curt Stewart < >>cstew...@tri-sysconsulting.com> wrote: >> >>> Does the DAR data support indexes? And do you know which release DAR >>> became available? >>> Curt Stewart > > >This communication, its contents and any file attachments transmitted with it >are intended solely for the addressee(s) and may contain confidential >proprietary information. >Access by any other party without the express written permission of the sender >is STRICTLY PROHIBITED. >If you have received this communication in error you may not copy, distribute >or use the contents, attachments or information in any way. Please destroy it >and contact the sender. >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ENCRYPT in Universe
Thanks for info, I was hoping for a different answer though. I have an application where the check nbr and the account number need to be both encrypted and indexed. Anybody have any suggestions on how I can accomplish that? Thanks Curt Baker Hughes wrote: >Data At Rest encryption became available with UV 10.2 I believe. We >implemented it after that upgrade. > >If you're asking whether you can INDEX an Encrypted DAR field, I rather doubt >it, but have not tried it. > >I would ping Nic Kesic with this question; perhaps he is listening or has a >google alert set for his name. > >Thank you. >-Baker > > > >-Original Message- >From: u2-users-boun...@listserver.u2ug.org >[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart >Sent: Wednesday, September 21, 2011 11:41 AM >To: U2 Users List >Subject: Re: [U2] ENCRYPT in Universe > >DAR = Data At Rest > >John Thompson wrote: > >>Or better yet, what is DAR? >> >>On Wed, Sep 21, 2011 at 12:11 PM, Curt Stewart < >>cstew...@tri-sysconsulting.com> wrote: >> >>> Does the DAR data support indexes? And do you know which release DAR >>> became available? >>> Curt Stewart > > >This communication, its contents and any file attachments transmitted with it >are intended solely for the addressee(s) and may contain confidential >proprietary information. >Access by any other party without the express written permission of the sender >is STRICTLY PROHIBITED. >If you have received this communication in error you may not copy, distribute >or use the contents, attachments or information in any way. Please destroy it >and contact the sender. >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ENCRYPT in Universe
DAR = Data At Rest John Thompson wrote: >Or better yet, what is DAR? > >On Wed, Sep 21, 2011 at 12:11 PM, Curt Stewart < >cstew...@tri-sysconsulting.com> wrote: > >> Does the DAR data support indexes? And do you know which release DAR became >> available? >> Curt Stewart >> >> Baker Hughes wrote: >> >> >Hey John, >> > >> >The ENCRYPT uniBasic function is for encrypting something on the fly. >> Whereas, with Data At Rest encryption, you simply specify which fields in >> the file, or the whole file itself, to be encrypted, and the database takes >> care of the encryption/decryption, without any programmer intervention. >> > >> >Before we had DAR going I toyed with the ENCRYPT function. If you want a >> code snippet that would demonstrate how this works, email me off list. >> > >> >HTH, >> >-Baker >> > >> > >> >-Original Message- >> >From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >> >Sent: Tuesday, September 20, 2011 8:51 AM >> >To: U2 Users List >> >Subject: Re: [U2] ENCRYPT in Universe >> > >> >I think I am understanding it a little more now. It seems as long as you >> don't decrypt it or store the keys in an "insecure" place, you are good to >> go. You can just compare the encrypted strings to see if a password matches >> or not. >> > >> >I'm curious though, whats the difference between the actual Encrypted >> Files features vs. the ENCRYPT function in BASIC? >> > >> >I'm guessing you might use encrypted files if you are doing something like >> credit cards? >> > >> > >> > >> >This communication, its contents and any file attachments transmitted with >> it are intended solely for the addressee(s) and may contain confidential >> proprietary information. >> >Access by any other party without the express written permission of the >> sender is STRICTLY PROHIBITED. >> >If you have received this communication in error you may not copy, >> distribute or use the contents, attachments or information in any way. >> Please destroy it and contact the sender. >> >___ >> >U2-Users mailing list >> >U2-Users@listserver.u2ug.org >> >http://listserver.u2ug.org/mailman/listinfo/u2-users >> > >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > > >-- >John Thompson >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ENCRYPT in Universe
Does the DAR data support indexes? And do you know which release DAR became available? Curt Stewart Baker Hughes wrote: >Hey John, > >The ENCRYPT uniBasic function is for encrypting something on the fly. Whereas, >with Data At Rest encryption, you simply specify which fields in the file, or >the whole file itself, to be encrypted, and the database takes care of the >encryption/decryption, without any programmer intervention. > >Before we had DAR going I toyed with the ENCRYPT function. If you want a code >snippet that would demonstrate how this works, email me off list. > >HTH, >-Baker > > >-Original Message- >From: u2-users-boun...@listserver.u2ug.org >[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >Sent: Tuesday, September 20, 2011 8:51 AM >To: U2 Users List >Subject: Re: [U2] ENCRYPT in Universe > >I think I am understanding it a little more now. It seems as long as you >don't decrypt it or store the keys in an "insecure" place, you are good to go. > You can just compare the encrypted strings to see if a password matches or >not. > >I'm curious though, whats the difference between the actual Encrypted Files >features vs. the ENCRYPT function in BASIC? > >I'm guessing you might use encrypted files if you are doing something like >credit cards? > > > >This communication, its contents and any file attachments transmitted with it >are intended solely for the addressee(s) and may contain confidential >proprietary information. >Access by any other party without the express written permission of the sender >is STRICTLY PROHIBITED. >If you have received this communication in error you may not copy, distribute >or use the contents, attachments or information in any way. Please destroy it >and contact the sender. >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects and multiple select lists
Doug, I don't know UniObjects well enough, but since its still the weekend, I figured I could throw out a thought until someone more knowledgeable in UniObjects respons. You should be able to select the list to a list number and then readnext from the assigned list number? In basic, Universe, it's something like; SELECT FILE TO 3 ... READNEXT KEY FROM 3 ... Looking at the UniObjects (.NET) manual you should be able to do something like; UniSelectList uSelect = uSession.CreateselectList();where uselect should be a reference # 0 - 9 or 10 I don't know if you've already tried something like this, or even if it helps, I hope so. It's something to try. I look forward to hearing if this helps. Curt Stewart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Sunday, August 21, 2011 8:56 AM To: U2 Users List Subject: [U2] uniobjects and multiple select lists I am trying to write a c# program that will do multiple selects each one using the list from the previous select. I can't seem to find a way to do this (in uniobjects) ,I think/hope it can be done and in this case I cannot write a subroutine to do it (yes I agree it is probably the best way). Is it possible just using uniobjects to use a previous select (did I mention I do not want to save the list) in a new select? thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CONV MCU on indexed field?
Chris, The problem is that your index was built case sensitive and now you're requests are upper case only so it will only get upper case indexes. You need to rebuild the index with the dictionary item that does the MCU, that way all of your indexes are upper case. Hth, Curt Stewart Chris Austin wrote: > >> Could you create another dict item called NAME.UPCASE and put the MCU in >> that definition? > >I guess I'm not sure what the above dictionary entry would look like. Would >this be a dictionary entry >that's just used to do the conversion on NAME? > >Currently this is what I have for field name: > > NAME >> 0001 D >> 0002 5 >> 0003 >> 0004 Name >> 0005 25L >> 0006 S >> 0007 >> 0008 CHARACTER,25 > >So I would be creating another DICT entry called NAME.UPCASE, the part I don't >understand is > >#1) what that DICT would look like >#2) how that DICT entry would be used > >Sorry for the numerous questions. > >Chris > > > >> From: bl...@shaklee.com >> To: u2-users@listserver.u2ug.org >> Date: Tue, 26 Jul 2011 10:41:40 -0700 >> Subject: Re: [U2] CONV MCU on indexed field? >> >> Did you create the index for the field like John Thompson suggested? >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin >> Sent: Tuesday, July 26, 2011 10:37 AM >> To: u2-users@listserver.u2ug.org >> Subject: Re: [U2] CONV MCU on indexed field? >> >> >> >> I changed the DICT entry for field NAME on the CLIENT table to the >> following: >> >> NAME >> 0001 D >> 0002 5 >> 0003 MCU >> 0004 Name >> 0005 25L >> 0006 S >> 0007 >> 0008 CHARACTER,25 >> >> But it still doesn't seem to work in regards to the case-sensitive. >> >> Chris >> >> >> >> > From: bl...@shaklee.com >> > To: u2-users@listserver.u2ug.org >> > Date: Tue, 26 Jul 2011 09:44:35 -0700 >> > Subject: Re: [U2] CONV MCU on indexed field? >> > >> > We are using Unidata and this is a dict for Country: >> > >> > CNTRY: >> > >> > D >> > >> > 4 >> > >> > MCU >> > >> > Cntry >> > >> > 6L >> > >> > M >> > >> > >> > You could do the same change to the NAME definition but I was >> > suggesting that if you didn't want to or couldn't do that then another >> > definition could be created that forced the name to be upper-case. >> > >> > -Original Message- >> > From: u2-users-boun...@listserver.u2ug.org >> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris >> > Austin >> > Sent: Tuesday, July 26, 2011 9:36 AM >> > To: u2-users@listserver.u2ug.org >> > Subject: Re: [U2] CONV MCU on indexed field? >> > >> > >> > >> > I'm not exactly following you. Would this dict item called >> > NAME.UPCASE, would that be a new field to test this or woudl that be a >> > specific field used to do the conversion? What would the dictionary >> > look like. >> > >> > Chris >> > >> > >> > > From: bl...@shaklee.com >> > > To: u2-users@listserver.u2ug.org >> > > Date: Tue, 26 Jul 2011 09:32:48 -0700 >> > > Subject: Re: [U2] CONV MCU on indexed field? >> > > >> > > Could you create another dict item called NAME.UPCASE and put the >> > > MCU >> > > in that definition? >> > > >> > > -Original Message- >> > > From: u2-users-boun...@listserver.u2ug.org >> > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris >> > > Austin >> > > Sent: Tuesday, July 26, 2011 9:25 AM >> > > To: u2-users@listserver.u2ug.org >> > > Subject: [U2] CONV MCU on indexed field? >> > > >> > > >> > > >> > > We've been using the following command to select a name regardless >> > > of >> > > how it's capitalized: >> > > >> > > SELECT CLIENT WITH NAME CONV MCU = "BRUCE]" >> > > >> > > However, after I indexed the field NAME on the CLIENT table the same >> > > command only returns the values that match the case-sensitive. In >> > > other wor
Re: [U2] SELECT question, paginated select.
Chris, Bscan is a universe command that will let you traverse a secondary index. Say the last company on the page was ABC Company, your BSCAN commands match value could be Abc and then step thru the list with a loop. The UV docs description isn't too bad. Curt Chris Austin wrote: > >I have no idea what the BSCAN directive is? Is that a UniVerse command? It >seems that there's not really a straightforward consensus on >the solution to this problem. > >Chris > > >> From: lar...@wcs-corp.com >> To: u2-users@listserver.u2ug.org >> Date: Wed, 20 Jul 2011 12:42:10 -0700 >> Subject: Re: [U2] SELECT question, paginated select. >> >> Look at the BSCAN directive. It allows you to scan and traverse B-Tree type >> files and alternate indices. >> >> Larry Hiscock >> Western Computer Services >> >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin >> Sent: Wednesday, July 20, 2011 12:19 PM >> To: u2-users@listserver.u2ug.org >> Subject: Re: [U2] SELECT question, paginated select. >> >> >> Curt, >> >> My problem is understanding how to traverse the query. Our dropdown is >> paginated, we can specify the # of results per paginated drop-down so it >> being super long or short >> isn't an issue. The problem is getting the SELECT statements/UniVerse to >> match what we want the dropdown to do. >> >> For example if I query a table called CLIENT which has @ID indexed, I do the >> following: >> >> EXECUTE 'SELECT CLIENT BY @ID' >> >> My questions are: >> >> #1) How would I specify 10 results back from the query? >> #2) How would I 'pick up' where I left off for page 2 (values 11-20)? >> >> Doug mentioned using SAVE.LIST to do this, Bill says that you have to do a >> dance in UniVerse. I guess I'm curious what this dance is that I need to do? >> If it's not handled in the SELECT then what technique are you using in >> UniVerse? >> >> Chris >> >> >> > Date: Wed, 20 Jul 2011 13:59:48 -0500 >> > From: cstew...@tri-sysconsulting.com >> > To: u2-users@listserver.u2ug.org >> > Subject: Re: [U2] SELECT question, paginated select. >> > >> > Chris, >> > I agree with Bill, using an index is your best solution. Are you able to >> apply any kind of filter criteria to the names? If not here's one of your >> dilemmas... If you make your drop down list too small nobody will use it >> because it will take too long to get to anyone beyond the A's. If you make >> it too long it will be cumbersome to find someone on the page and the build >> time of the drop down list on the client side may be too slow. I strongly >> recommend, from experience, using something other than a dropdown list, even >> using a combo box list allows the user to provide some criteria to narrow >> the search. >> > Hth >> > Curt Stewart >> > >> > Chris Austin wrote: >> > >> > > >> > >Bill, >> > > >> > >I was curious if you had a quick example? I'm just curious how you guys >> are suggesting to do this >> > > >> > >Chris >> > > >> > >> Date: Wed, 20 Jul 2011 11:13:04 -0700 >> > >> From: wphask...@advantos.net >> > >> To: u2-users@listserver.u2ug.org >> > >> Subject: Re: [U2] SELECT question, paginated select. >> > >> >> > >> Chris: >> > >> >> > >> I'm betting the solution also needs indexing, because you want to pick >> > >> up where the last list left off and you don't want to wait for a select >> >> > >> to return to save the list. So, SAMPLE isn't really a solution but >> > >> indexing is. We do this all the time, but we have to use indexing. In >> >> > >> fact, we parse through a file with millions of records to get a page >> > >> full of stuff and the pop-up list is instantaneous. >> > >> >> > >> Secondly, I'm not sure a dropdown list is the appropriate choice for a >> > >> thousand items. >> > >> >> > >> HTH, >> > >> >> > >> Bill >> > >> >> > >> >> >> > >> - Original Message -
Re: [U2] SELECT question, paginated select.
Chris, I agree with Bill, using an index is your best solution. Are you able to apply any kind of filter criteria to the names? If not here's one of your dilemmas... If you make your drop down list too small nobody will use it because it will take too long to get to anyone beyond the A's. If you make it too long it will be cumbersome to find someone on the page and the build time of the drop down list on the client side may be too slow. I strongly recommend, from experience, using something other than a dropdown list, even using a combo box list allows the user to provide some criteria to narrow the search. Hth Curt Stewart Chris Austin wrote: > >Bill, > >I was curious if you had a quick example? I'm just curious how you guys are >suggesting to do this > >Chris > >> Date: Wed, 20 Jul 2011 11:13:04 -0700 >> From: wphask...@advantos.net >> To: u2-users@listserver.u2ug.org >> Subject: Re: [U2] SELECT question, paginated select. >> >> Chris: >> >> I'm betting the solution also needs indexing, because you want to pick >> up where the last list left off and you don't want to wait for a select >> to return to save the list. So, SAMPLE isn't really a solution but >> indexing is. We do this all the time, but we have to use indexing. In >> fact, we parse through a file with millions of records to get a page >> full of stuff and the pop-up list is instantaneous. >> >> Secondly, I'm not sure a dropdown list is the appropriate choice for a >> thousand items. >> >> HTH, >> >> Bill >> >> >> - Original Message - >> *From:* cjausti...@hotmail.com >> *To:* u2-users@listserver.u2ug.org >> *Date:* 7/20/2011 10:14 AM >> *Subject:* [U2] SELECT question, paginated select. >> > I'm working on a screen in our webapp where we're using a dojo widjet to >> > create a drop down with client names. The problem >> > is that we have 1,000's of clients and when we do a SELECT on this many >> > clients it takes a while. I know we can index the field but >> > I was wondering if you can do smart selecting in UniVerse. >> > >> > For example if I wanted to use this query: >> > >> > SELECT CLIENT WITH @ID = "A]" SAMPLE 10 (returns 10 clients starting >> > with the letter A). >> > >> > I want to paginate my drop down so the first query has the above data. The >> > problem I'm facing is that I don't know how to >> > get the NEXT 10 clients? Is there a way to do this? >> > >> > For example if I wanted to return the next 10 CLIENTS, without including >> > any of the first 10. >> > >> > Chris >> > >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
precisonl...@gmail.com wrote: >I think the difference might be Unidata vs. Universe. George, you're on UV, >right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extreme slow down on Universe periodically
Thanks to all that have replied. We're still busy researching and testing but we did catch a break yesterday and it appears that the problem could be the same that Wol mentioned. We have had reports of CPU spikes in the past, but these were only reported in off hours and usually the following day or later. Yesterday however, they noticed a process that was Spiking using 100% CPU. We were able to track it to the user and find out exactly what they were doing. The user confirmed that they would just exit from the telnet session window (Windows Telnet) and not log off properly. When I tested this, the Process immediately began spiking. We're thinking and hoping that the slow downs that we have experienced are the cumulative affects of multiple bad disconnects and CPU spikes. I have contacted Rocket to see if/when this issue has been resolved and we will keep monitoring the server. Again thanks for the help and input. We're still going through several of the suggestions to see what impact they may have. Curt Stewart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 08, 2011 11:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extreme slow down on Universe periodically On 08/04/11 14:04, Curt Stewart wrote: > Has anyone in the group experienced this issue and found a resolution? > > > Any and all suggestions would be appreciated. > > Environment > Universe 10.2.10 > Windows Server 2003 > Virtual Machine (sorry don't know any details on this component) > 34 user license, only about 15 active > This is an old problem, that might well be resolved on 10.2, but do you have any rogue uvtelnets? We used to get that - they'd get disconnected somehow from their user, and then grab 100% cpu. Kill them, and things went back to normal (we had to crash them, they wouldn't kill, by attaching the debugger or something). Charles mentioned the network. Are your network buffers too large? I'm beginning to pick up from my reading on a hardware/software mismatch at the TCP level, and network slowdown (and catastrophic failure) are the result. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PDF Files directly from UniData or UniVerse
We recommend and use PrintWizard. I like that it not only allows you to create and format documents to a PDF but also direct it to the printer, Fax or Email. It also handles the scanning of documents. Curt Stewart TRI-SYS Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Tuesday, April 12, 2011 8:40 AM To: U2 Users List Subject: [U2] PDF Files directly from UniData or UniVerse Here is a question for this group. Has anyone been able to generate PDF files directly from UniData and/or UniVerse without having a manual step involved? In other words, just running a program using the standard PRINTER ON and PRINTER OFF commands, and having the output be a PDF file? Any pointers would be very welcome. Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extreme slow down on Universe periodically
Thanks to all that replied. I'll be following up on your suggestions and comments today, as well as several responses I received off-list. When we find an answer I'll post it for reference. I'm still hoping that it's something easy that I just haven't been able to pin-point yet. Thanks again. Curt Stewart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Friday, April 08, 2011 5:55 PM To: U2 Users List Subject: Re: [U2] Extreme slow down on Universe periodically I'm sure you'll already have this in mind but I see the slow down as a symptom that can be caused by any number of things so even though I'm sure collaboration will be very helpful, it's not guaranteed that the same problem would exist in both locations. What may have passed inspection at your clients site may be the cause at Curt's client site. But you guys already knew that, I'm sure, so I'm just stating the obvious. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, April 08, 2011 3:34 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extreme slow down on Universe periodically > From: Curt Stewart > My client is reporting the periodic slow down of their > system. It slows down to almost the point of a hang. Curt, one of our clients has a large site where this has been a chronic issue for about a year. They've done all the exercises with process monitors, network monitors, etc. Rocket has been all over this but I'm not sure they have a solid resolution. I'll link you guys up off-list so that you may be able to benefit from their experience. Best, T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Extreme slow down on Universe periodically
Has anyone in the group experienced this issue and found a resolution? My client is reporting the periodic slow down of their system. It slows down to almost the point of a hang. This affects both existing processes (menu selections, data entry, reports) and logins. Their system admins (IBM) reports that it is a Universe or application problem. I havent been able to identify any runaway processes or hogs. The log files that Ive looked at havent shed any light on the matter. Could there be a log file that Im overlooking that might need to be cleared? But if its an undersized file, why wouldnt it be a consistent problem? Im hoping that the group might be able to suggest some things to look at and consider. Any and all suggestions would be appreciated. Environment Universe 10.2.10 Windows Server 2003 Virtual Machine (sorry dont know any details on this component) 34 user license, only about 15 active Thanks for your help. Curt Stewart TRI-SYS Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [Repost] Response from mvCommunitymap
First off we want to thank everyone that has visited, provided feedback and have made contributions to mvCommunitymap.com. Secondly, I apologize for the length of this post, but I do feel the need to clarify some issues. We did anticipate some skepticism from the mvCommunity and I apologize for not responding to your posts yesterday. There are two reasons why we haven't publicized everyone in our database. # 1, We have to respect the Users privacy and confidentiality, not just end-users, but vendors as well. As a vendor, how often do you advertise the tools that you use to run your business. We don't unless we thought it would have a positive impact on sales. So for an end-user how would marketing "We use MV" positively impact their sales? Secondly, which I thought might have been too obvious, is that we are a business. mvCommunitymap does provide a free service to the entire community, users and vendors. It does not however provide free advertising, except to User Groups, they get their group profile displayed at no charge. Why, because generally speaking a User Group is giving back to the mvCommunity by providing networking opportunities and operating at cost. Every one else will need to pay for the advertising. Since we are a business, yes, we hope to get some new business out of this venture. Not by poaching, but by and through advertising. We can say confidently that more companies have heard of mvCommunitymap and TRI-SYS today than on Monday. Will it lead to more business? We don't know, that's the gamble of advertising. But, while advertising our business, we have been able to give something back to the mvCommunity. Something that the mvCommunity can use to advertise itself, in our opinion. This is not a scheme to scam you out of your client lists. In fact, for those of you that understandably, don't want to release your customer names, we offer you a way of contributing, maintaining the anonymity of customers and getting some free advertising. If you want to participate, supply us with a list of your clients, but ONLY include your internal client number or some other code that can uniquely identify them to YOU and their zip code. This way you are not releasing any customer identifiable information to anyone. And, in return, when anyone clicks on the map marker, we will display "This location is verified by Your Vendor Name Here." Please explain to me if we are missing how this would violate A) your confidentiality with your customers and B) how we would be able to poach from this type of list. We do however see a downside to this. There will be an increased chance of duplication. We are working on a routine that multiple vendors could run against their list to produce a uniquely identifiable code, based on user name and zip. The trick is how do we make it so that the code can't be reversed engineered by us to reproduce the Customer name and zip. I'm open to any ideas or suggestions. We have been made aware, this morning, that some countries zip/postal codes are a bit more accurate than the US and the location revealed is too accurate. We are working to rectify this issue, but if anyone else has concerns such as this, please let us know. As we originally stated in our announcement, what really is going to make this site powerful is the participation of the mvCommunity. We are happy to work with you to address any concerns that you may have. We know that this site can benefit the entire Global mvCommunity with your help. The stronger this site is the more it will benefit us all. A posting in CDP, asked why should we be trusted. Well for most of you we haven't earned that trust, so I'm not asking you to trust us, I'm just asking you to participate in the process for now and we plan to earn your trust as time goes by. Again, thanks for your time and feedback. Sincerely, Curt Stewart mvCommunitymap.com A world view of the MultiValue Community (p) 262-432-3897 (c) 262-227-9619 www.mvCommunitymap.com Mapping MultiValue Users Worldwide! View my LinkedIn R Profile ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [AD]New website for the MV Community[AD]
We are announcing the launch of a new website today for the multivalue community, www.mvcommunitymap.com. We have taken our database of multivalue users and vendors and have begun mapping them using Google Maps and eventually Google Earth. Our goal, albeit a lofty one, is to eventually map 80%-90% of the user community world wide. We believe that this tool can be a very valuable contribution to the mvCommunity. End-Users can use it to view resources available (Developers, Consultants or Vendors) in their area. Vendors can use it to demonstrate the strength and diversity of the mvCommunity, locally and globally, in their sales endeavors. To make this the powerful tool that I know it can be, we need the help of the community. We are asking for everyone's help in identifying as many of the multivalue End Users, Vendors and Software products as possible. Send us the name of your employer, your past employers, MV Vendors, the applications that you've worked with, the MV Tools that you've used and of course, your name. We want to map all things multivalue. To contribute, you can use the contact us page, or email your contributions to i...@mvcommunitymap.com. Contributions should contain at a minimum the Company Name or Developers Name, City, State or Zip/Postal Code and Country. If a product, Product Name, Vendor Name and Zip/Postal Code & Country. All information received will be kept confidential but we will contact companies and individuals to confirm their current multivalue status. Thanks for your time and I look forward to hearing your feedback. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions (p) 262-432-3897 (c) 262-227-9619 www.tri-sysconsulting.com Real-World Solutions for Real-World Problems! View my LinkedIn R Profile ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
Symeon Breen wrote: >Can you see this other file/folder from the cmd prompt ? > > > >From: u2-users-boun...@listserver.u2ug.org >[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of grmhbeers >Sent: 22 January 2011 15:10 >To: u2-users@listserver.u2ug.org >Subject: [U2] re directing a unidata directory to another server > > > > > >I have created a Unidata (1.7x) directory to which I am writing files in a >unibasic program. However I want the file to be saved directly in a folder >on another server that is in the same virtual machine as our Unidata based >system. All reside on windows server. I have tried everything I can think >of from drive mapping to shortcuts, but Unidata still can't find the folder >on the other server. What do I do so Unidata sees the mapping or shortcut or >??. Can this be done in Unidata? I do not want to ftp the files, I want >them saved on the other server when the Unibasic program writes the file. >-- >View this message in context: >http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30 >736884p30736884.html >Sent from the U2 - Users mailing list archive at Nabble.com. > >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > > _ > >No virus found in this message. >Checked by AVG - www.avg.com >Version: 10.0.1191 / Virus Database: 1435/3395 - Release Date: 01/21/11 > >___ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC
Allen Bell wrote: >After changing uvconfig you must compile it. I believe the uniadmin does >this for you, but you probably have to shutdown and restart UniVerse. >Check the time date stamp on .uvconmfig (the compiled version) to see if >it matches. > > > >On 8/4/2010 3:46 PM, Augusto Alonso wrote: >> Hi Dan. >> Yes, the 64BIT parameter in uvconfig is set to 1. (However, the CONFIG ALL >> reports 0...) >> Yes, the Redhat is a 32-bit version, and it's the last one. And the hardware >> is brand new. >> The problem has been certified by RocketSoftware, who suggest to change the >> OS to AIX-Powerpc. (Universe for AIX-PPC has newer versions than Linux-PPC) >> >> And the difficulty to distribute files is because of the Indexes. (We have >> pointers to the Index Files...) >> >> Regards >> -- >> Augusto Alonso Alonso >> Director de Sistemas >> QUITER SERVICIOS CENTRALES >> Zoco Gran Santander, 1ª planta - 39011 Santander - España >> Telf: +34 902233323 - Fax: +34 902234280 >> >> AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al >> usuario de destino, pudiendo contener información confidencial o protegida >> legalmente. Si, por un error de envío o transmisión, ha recibido este >> mensaje y usted no es el destinatario del mismo, por favor, notifique de >> este hecho al remitente y no use, informe, distribuya, imprima, copie o >> difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida, >> es exclusiva de su autor y no representa necesariamente la opinión de Quiter >> Servicios Centrales. >> >> LEGAL WARNING: This e-mail and any attachment, contain information intended >> solely for the addressee and may contain confidential information or legally >> protected data. If you are not the intended recipient, please notify the >> sender and do not use, disclose, distribute, copy, print or rely on this >> e-mail under any circumstances. The views and opinions expressed are the >> author´s own and do not necessarily reflect those of Quiter Servicios >> Centrales. >> >> >> >> 2010/8/4 Dan Fitzgerald >> >> >>> I'm curious as to why the app won't allow distributed files. >>> >>> Is the 64BIT parameter in uvconfig set to 1? >>> >>> If so, then it's probably either the Redhat PowerPC is a 32-bit version, or >>> it's very old 32-bit hardware. If either of these are the case, you'll want >>> to upgrade to 64-bit versions. >>> >>> From: aalo...@quiter.com To: u2-users@listserver.u2ug.org Date: Wed, 4 Aug 2010 12:26:51 +0200 Subject: Re: [U2] Impossible to handle big files (over 2 Gb) with >>> Universe onPowerPC >>> It is not a matter of the OS nor the File System. It is a UV limitation. I know the distributed files option, but this is not possible because of >>> the app. >>> Regards -- AA -mensaje original- Asunto: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe >>> onPowerPC >>> De: "Morawa, Hans" Fecha: 04/08/2010 10:44 Augusto, To check if your system handles large file support you need to use the >>> getconf program, syntax something like getconf FILESIZEBITS /path on most >>> systems. >>> Regards, Hans Morawa -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: >>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso >>> Sent: Wednesday, 4 August 2010 4:39 PM To: U2 Users List Subject: [U2] Impossible to handle big files (over 2 Gb) with Universe >>> onPowerPC >>> Hi. I have a big problem. In Universe 10.1.21 on RedHat PowerPC I need to handle big files, but it >>> is impossible. >>> I have tested it and I have this ERROR: > CREATE.FILE TEST 2 2 > Creating file "TEST" as Type 2, Modulo 2, Separation 4. Creating file "D_TEST" as Type 3, Modulo 1, Separation 2. Added "@ID", the default record for RetrieVe, to "D_TEST". > RESIZE TEST 18 1 1 64BIT > RESIZE: Invalid file name, sizing parameter, or option on command line. > Even trying to create it: > CREATE.FILE NEWFILE 2 2 2 64BIT > Enhanced files (64bit) are not currently supported on this platform. > I'm very surprised that I am the first customer with this issue, but the >>> tech people from Rocket said that there is no plans to solve it. >>> Does anyone knows any workaround? Regards -- Augusto Alonso Alonso IT manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 >>> ___ >>> U2-Users mailing
Re: [U2] CPU Spikes to 100%
Thanks Tony, As always that's good advice. I'll be sure to keep the group posted if I make any advances on this. Curt www.tri-sysconsulting.com Real-World Solutions for Real-World Problems! View my LinkedIn R Profile -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, March 29, 2010 12:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CPU Spikes to 100% > From: Curt Stewart > The environment is a virtualized Windows 2003 Server and > Universe 10.2.10 > > On occasion, I've been notified twice, it may have > occurred more often, a Universe process > (tl_server.exe) will consume 100% of the CPU. Curt, I wasn't watching this tread earlier, sorry. This is the Exact same problem that Mike Roosa at Tolt is having, as documented in another recent thread here. Rocket has been unable to thoroughly diagnose the issue but tl_server does seem to be either the culprit or a "telltale victim". I highly recommend you contact Rocket and tell them this may be related to the Tolt situation. Note that their environment is also virtualized in VMware. Perhaps there is something in VMware, like flushing, or some abnormal condition, which causes tl_server to start spinning. Good luck bud. T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CPU Spikes to 100%
Thanks to everyone for their ideas and feedback. I will try running PORT.STATUS if I can ever be on the system when it occurs. I'm probably the 3rd or 4th person that would be notified. I will have to see if we can get the #1 person to access UV and run it. I don't think that the recompile will do it, but it won't hurt. Brian, under your scenario, would the process ever go away on it's own? They are using just the plain telnet app that comes with windows, and I can see them just closing the window without logging off. I'll see if I can't duplicate the issue by trying this tonight. Leroy, how would the keepalive option help if the user has closed the window? Would the socket be closed gracefully once keepalive didn't get its response back? Thanks again for the ideas and suggestions. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions (p) 262-432-3897 (c) 262-227-9619 www.tri-sysconsulting.com Real-World Solutions for Real-World Problems! View my LinkedIn ® Profile -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Thursday, March 25, 2010 4:46 AM To: 'U2 Users List' Subject: [U2] CPU Spikes to 100% The environment is a virtualized Windows 2003 Server and Universe 10.2.10 On occasion, Ive been notified twice, it may have occurred more often, a Universe process (tl_server.exe) will consume 100% of the CPU. When this happens, support is automatically notified and they need an explanation. As far as the application goes, there is only one background job and all other jobs would execute immediately. I was last notified when it occurred at 2:20am on the 3rd and then again apparently this week. There are some users based in India that could be using the system at the time these occur, but I have not been able to make a connection to a user process yet. Doe's anyone have any ideas why this might be happening or suggestions on how to identify what ever is causing the spike? Is there a Universe log that might be able to give me a clue? Thanks for any suggestions. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] CPU Spikes to 100%
The environment is a virtualized Windows 2003 Server and Universe 10.2.10 On occasion, Ive been notified twice, it may have occurred more often, a Universe process (tl_server.exe) will consume 100% of the CPU. When this happens, support is automatically notified and they need an explanation. As far as the application goes, there is only one background job and all other jobs would execute immediately. I was last notified when it occurred at 2:20am on the 3rd and then again apparently this week. There are some users based in India that could be using the system at the time these occur, but I have not been able to make a connection to a user process yet. Doe's anyone have any ideas why this might be happening or suggestions on how to identify what ever is causing the spike? Is there a Universe log that might be able to give me a clue? Thanks for any suggestions. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] odd problem with read statement assigning variable with random data with else clause in pick flavor
Troy, The things that stick out to me about this, is that CITEM is a common, it has changed values and it hasn't been reproduced outside of the 4gl code. I would look into the common statements of the code surrounding and including the code that you have isolated this problem to and verify that they all contain the same variables and in the same order. If the common variables order has been mixed up than CITEM is being assigned some other variables value, perhaps a screen control value, since its and escape sequence. Normally common's are defined in an INCLUDE file, so if most programs have the include file, check those that don't, if any. Also, is it possible that F.FILE has a trigger associated with it that might be manipulating the result of CITEM? The other thing that I would check out would be the integrity of F.FILE, has the file been corrupted? I'm guessing not, but one more thing to eliminate. I know that these don't explain why it would happen on Readu and not Read, but they are worth checking out. Good Luck and Happy Holidays. Curt Stewart TRI-SYS Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, December 22, 2009 3:32 PM To: U2 Users List Subject: Re: [U2] [UV] odd problem with read statement assigning variable with random data with else clause in pick flavor Thanks for the replies... In this example I was using, the ID was not on file, so it would not have taken the LOCKED clause. I just added the locked clause to my actual failing code to test the theory and it still takes the ELSE clause because the record is truly not on file. I tried George's idea of using named common and the problem still happens. One last clarification, the problem seems to occur if the READ statement is a READU. If the statement is a regular READ, it does not happen. -Troy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Tuesday, December 22, 2009 1:23 PM To: U2 Users List Subject: Re: [U2] [UV] odd problem with read statement assigning variablewith random data with else clause in pick flavor Hi Troy The problem with that code is that the else clause is taken when the record is locked. You are assuming if the else clause is taken that the record does not exist, which is not a safe assumption. I would suggest Readu citem from fv, key locked * locked options End then * then options End else Citem = "" end -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Logitek Systems) Sent: Wednesday, 23 December 2009 7:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] odd problem with read statement assigning variable with random data with else clause in pick flavor We are running universe 10.2.10 in pick flavor. I have a program (part of a 4gl subroutine) that simplified does the following: CITEM = "" READU CITEM FROM F.FILE, CID THEN END ELSE IF CITEM # "" THEN PRINT "CITEM IS NOT NULL!" END According to the documentation, when running in pick flavor, the value of CITEM is unchanged if the read fails. What happens is that CITEM is sometimes assigned to a random value and not NULL. Right now it is being assigned to zero. Last week, this same CITEM was being assigned to an escape sequence (about 8 characters long) when the read failed. CITEM is a non-named common variable. This issues does NOT happen if CITEM is not a common variable. The result also has varied if I use READU vs READ. Clearly there is a bug here in retaining the value of CITEM with a READ statement in pick flavor. Unfortunately, I have not been able to create a simple example to reproduce this problem outside of the 4gl. And this does not happen in all the code, only in one section so far and IS reproducible in this one case from logon session to logon session. Any ideas? -Troy ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.722 / Virus Database: 270.14.117/2581 - Release Date: 12/22/09 02:09:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] An interesting find....
I'm not too familiar with the Prime Flavor, but doesn't the CASE and the setting of F.FILETOUSE need to be on separate lines or have a semi-colon (;)? CASE X=1 ; F.FILETOUSE = F.FILE1 CASE X=2 F.FILETOUSE = F.FILE2 Curt Stewart TRI-SYS Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, December 15, 2009 1:24 PM To: U2 Users List Subject: [U2] An interesting find Here is an interesting tidbit I happened to run across. PROGRAM A: OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1" OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2" * F.FILETOUSE = F.FILE1 (Adding this here will get rid of the compile warning) BEGIN CASE CASE X=1 F.FILETOUSE = F.FILE1 CASE X=2 F.FILETOUSE = F.FILE2 CASE -1 F.FILETOUSE = F.FILE1 END CASE READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA="" The above program when compiled says F.FILETOUSE never assigned a value and when it executes, gives an improper file type error HOWEVER: PROGRAM B: OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1" OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2" F.FILETOUSE=F.FILE1 IF X=1 THEN F.FILETOUSE = F.FILE1 IF X=2 THEN F.FILETOUSE = F.FILE2 READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA="" Compiles and run just fine, no errors. This is using UV 10.0.2 under the Prime Information flavor George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.716 / Virus Database: 270.14.107/2564 - Release Date: 12/15/09 01:52:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
David, Thanks for the ideas. I don't have a great deal of access to this server, it's being managed by IBM. I think you can guess the kind of red tape involved with doing anything. I'm pretty sure that most if not all the UV config's are set to the defaults. I didn't think about comparing the two. I'll get a copy of both and do that this week. Thanks for the ideas, I'll post my findings. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, November 10, 2009 12:37 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Did you do a "sanity check" (on your system/UV setup - not you:))- being a Windows platform check- no real-time anti-virus scanner is in operation on every file modification and that the UV config is NOT using the defaults (perhaps you should be setting it to the something similar to your AIX UV config - as applicable). Or any run-away processes do you get them same thing after you rebooted your server? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Sunday, 1 November 2009 12:15 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Phil, This appears to be a Windows bug. I ran my test program on a Universe 10.3 AIX box and it also took just 2 seconds. Does anyone know if this bug is scheduled for resolution? Thanks everyone, for all the help Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Saturday, October 31, 2009 1:05 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Saturday, 31 October 2009 5:46 p.m. > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > Phil, > > My test file is 1009,1 type 18. My record id is just a sequential > number 1 to 10,000 for this test file and the data is only 40-50 more > bytes. So > I > don't think the file size is the problem. I've tested the logic by > calling the trigger subroutine direct from the program and I get a 2 > second process time, so I don't think the logic is the problem either. > > Are you on Universe or Unidata? > > Thanks for the response. > > Curt Stewart > TRI-SYS Consulting > Integrated Multi-Value Business Solutions > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker > Sent: Friday, October 30, 2009 5:39 PM > To: U2 Users List > Subject: Re: [U2] Universe Triggers > > Check your file sizes out or your logic, because I experience nothing > like this still subsecond responses, and we use triggers for > auditing/data quality/ and replication through a log/webservice to > sql, although the later part of that is handled asynchronously > > ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Kevin, I resized the VOC and it did not help at all. It was worth a shot. Thanks for the idea. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, October 31, 2009 11:25 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Crazy thought... Could it have anything to do with the VOC being too small? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Phil, This appears to be a Windows bug. I ran my test program on a Universe 10.3 AIX box and it also took just 2 seconds. Does anyone know if this bug is scheduled for resolution? Thanks everyone, for all the help Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Saturday, October 31, 2009 1:05 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Saturday, 31 October 2009 5:46 p.m. > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > Phil, > > My test file is 1009,1 type 18. My record id is just a sequential > number 1 to 10,000 for this test file and the data is only 40-50 more > bytes. So > I > don't think the file size is the problem. I've tested the logic by > calling the trigger subroutine direct from the program and I get a 2 > second process time, so I don't think the logic is the problem either. > > Are you on Universe or Unidata? > > Thanks for the response. > > Curt Stewart > TRI-SYS Consulting > Integrated Multi-Value Business Solutions > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker > Sent: Friday, October 30, 2009 5:39 PM > To: U2 Users List > Subject: Re: [U2] Universe Triggers > > Check your file sizes out or your logic, because I experience nothing > like this still subsecond responses, and we use triggers for > auditing/data quality/ and replication through a log/webservice to > sql, although the later part of that is handled asynchronously > > > > -----Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > > Sent: Saturday, 31 October 2009 6:45 a.m. > > To: 'U2 Users List' > > Subject: Re: [U2] Universe Triggers > > > > Thanks Doug, > > > > That's pretty much the conclusion I came to after I ran my test on a > > 10.3.3 > > Universe system. > > > > Unfortunately, this application doesn't use a common WRITE or DELETE > > routine, so I get to update about 90 programs with the audit logic. > > It'll be > > tedious but not too bad. > > > > Thanks for the feedback > > > > Curt Stewart > > TRI-SYS Consulting > > Integrated Multi-Value Business Solutions www.tri-sysconsulting.com > > > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug > > Sent: Friday, October 30, 2009 12:19 PM > > To: 'U2 Users List' > > Subject: Re: [U2] Universe Triggers > > > > Curt, > > > > We run Web applications a 25 second delay would be a death march for > > our staff with the users pointing things at us. This is a known > > Universe issue and to be fixed on a later release according the folks > > at U2 University. > > > > We wrote our own auditing the works with Universe and Unidata. This > is > > pretty easy for us since high percentage of our writes and deletes > are > > handled out of a single subroutine. The programs that use their own > > WRITE or DELETE had to have all another line or two added to complete > > the auditing processes. > > > > We have about a 50-300ms delay for the additional read and writes to > > the audit file. This strategy works very well for our call center > > application. > > > > Regards, > > Doug > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt > Stewart > > Sent: Friday, October 30, 2009 10:37 AM > > To: 'U2 Users List' > > Subject: Re: [U2] Universe Triggers > > > > The speed issue is not in the subroutine itself. I tried a > subroutine > > that did nothing, just a return and the process takes 25 seconds > > compared > to > > 2 > > seconds with out a trigger. My main trigger subroutine is using a > > common for the file opens and that did cut the processing time down > > from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. > >
Re: [U2] Universe Triggers
Phil, My test file is 1009,1 type 18. My record id is just a sequential number 1 to 10,000 for this test file and the data is only 40-50 more bytes. So I don't think the file size is the problem. I've tested the logic by calling the trigger subroutine direct from the program and I get a 2 second process time, so I don't think the logic is the problem either. Are you on Universe or Unidata? Thanks for the response. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Friday, October 30, 2009 5:39 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Check your file sizes out or your logic, because I experience nothing like this still subsecond responses, and we use triggers for auditing/data quality/ and replication through a log/webservice to sql, although the later part of that is handled asynchronously > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Saturday, 31 October 2009 6:45 a.m. > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > Thanks Doug, > > That's pretty much the conclusion I came to after I ran my test on a > 10.3.3 > Universe system. > > Unfortunately, this application doesn't use a common WRITE or DELETE > routine, so I get to update about 90 programs with the audit logic. > It'll be > tedious but not too bad. > > Thanks for the feedback > > Curt Stewart > TRI-SYS Consulting > Integrated Multi-Value Business Solutions www.tri-sysconsulting.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug > Sent: Friday, October 30, 2009 12:19 PM > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > Curt, > > We run Web applications a 25 second delay would be a death march for > our staff with the users pointing things at us. This is a known > Universe issue and to be fixed on a later release according the folks > at U2 University. > > We wrote our own auditing the works with Universe and Unidata. This is > pretty easy for us since high percentage of our writes and deletes are > handled out of a single subroutine. The programs that use their own > WRITE or DELETE had to have all another line or two added to complete > the auditing processes. > > We have about a 50-300ms delay for the additional read and writes to > the audit file. This strategy works very well for our call center > application. > > Regards, > Doug > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Friday, October 30, 2009 10:37 AM > To: 'U2 Users List' > Subject: Re: [U2] Universe Triggers > > The speed issue is not in the subroutine itself. I tried a subroutine > that did nothing, just a return and the process takes 25 seconds > compared to > 2 > seconds with out a trigger. My main trigger subroutine is using a > common for the file opens and that did cut the processing time down > from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. > > Does Universe require any special settings for triggers? Or file types? > Does the account have to be a specific flavor of Pick? Permissions? > > I don't know any other thoughts or suggestions? My searches have not > turned up anything useful but someone's post did say that they found > it to be slow on 10.2 but they did not elaborate or get a response > that I found. > > Thanks for your help. > Curt > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Thanks Doug, That's pretty much the conclusion I came to after I ran my test on a 10.3.3 Universe system. Unfortunately, this application doesn't use a common WRITE or DELETE routine, so I get to update about 90 programs with the audit logic. It'll be tedious but not too bad. Thanks for the feedback Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions www.tri-sysconsulting.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, October 30, 2009 12:19 PM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Curt, We run Web applications a 25 second delay would be a death march for our staff with the users pointing things at us. This is a known Universe issue and to be fixed on a later release according the folks at U2 University. We wrote our own auditing the works with Universe and Unidata. This is pretty easy for us since high percentage of our writes and deletes are handled out of a single subroutine. The programs that use their own WRITE or DELETE had to have all another line or two added to complete the auditing processes. We have about a 50-300ms delay for the additional read and writes to the audit file. This strategy works very well for our call center application. Regards, Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Friday, October 30, 2009 10:37 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers The speed issue is not in the subroutine itself. I tried a subroutine that did nothing, just a return and the process takes 25 seconds compared to 2 seconds with out a trigger. My main trigger subroutine is using a common for the file opens and that did cut the processing time down from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. Does Universe require any special settings for triggers? Or file types? Does the account have to be a specific flavor of Pick? Permissions? I don't know any other thoughts or suggestions? My searches have not turned up anything useful but someone's post did say that they found it to be slow on 10.2 but they did not elaborate or get a response that I found. Thanks for your help. Curt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
The speed issue is not in the subroutine itself. I tried a subroutine that did nothing, just a return and the process takes 25 seconds compared to 2 seconds with out a trigger. My main trigger subroutine is using a common for the file opens and that did cut the processing time down from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. Does Universe require any special settings for triggers? Or file types? Does the account have to be a specific flavor of Pick? Permissions? I don't know any other thoughts or suggestions? My searches have not turned up anything useful but someone's post did say that they found it to be slow on 10.2 but they did not elaborate or get a response that I found. Thanks for your help. Curt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, October 30, 2009 10:38 AM To: U2 Users List Subject: Re: [U2] Universe Triggers is the trigger program doing any file opens? That would probably be your slow down. I've not tried to setup a common with any of the triggers I've setup, since the number of writes has been minimal for us (maybe 5 per hour maximum). George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart > Sent: Friday, October 30, 2009 10:47 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Universe Triggers > > I'm testing using triggers to maintain an Audit log of transactions. > Everything works, the file, the subroutine, but the trigger process is > extremely slow. > > My test program loops through 1 to 1 and writes a record to my > test file with the trigger. Without the trigger in place the program > runs in 2 seconds, with the trigger in place the program runs in 25 > seconds. The timings are roughly the same if the trigger program is > doing nothing more than a return. I've also tested calling the > trigger subroutine from the program (without the trigger on the file) > and the process runs in 2-3 seconds. > > This is Universe 10.2.10 on a virtual Windows 2003 server. The > trigger file is type 18 and the trigger was created with this > statement; CREATE TRIGGER AUDIT_LOG BEFORE UPDATE OR INSERT OR DELETE > ON TEST.TRIGGER.FILE FOR EACH ROW CALLING '*apps*AUDIT.LOG.TRIGGER'; > > It appears that just calling a trigger significantly degrades the > process. > Does anyone have any ideas or suggestions. > > Thanks for any help you can provide. > Curt > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe Triggers
Im testing using triggers to maintain an Audit log of transactions. Everything works, the file, the subroutine, but the trigger process is extremely slow. My test program loops through 1 to 1 and writes a record to my test file with the trigger. Without the trigger in place the program runs in 2 seconds, with the trigger in place the program runs in 25 seconds. The timings are roughly the same if the trigger program is doing nothing more than a return. Ive also tested calling the trigger subroutine from the program (without the trigger on the file) and the process runs in 2-3 seconds. This is Universe 10.2.10 on a virtual Windows 2003 server. The trigger file is type 18 and the trigger was created with this statement; CREATE TRIGGER AUDIT_LOG BEFORE UPDATE OR INSERT OR DELETE ON TEST.TRIGGER.FILE FOR EACH ROW CALLING '*apps*AUDIT.LOG.TRIGGER'; It appears that just calling a trigger significantly degrades the process. Does anyone have any ideas or suggestions. Thanks for any help you can provide. Curt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Converting from mvBase to Universe
I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to "nail" the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV/NET questions/confirmation
First off let me apologize for my last post. I realized it was unsigned the moment I released the button after clicking on Send. I've just reviewed the Uv/Net documentation and would just like to get confirmation on my understanding of what I read. For UV/NET to work, both systems need to be running Universe and UV/NET. Do both have to have the same user licenses? What is the minimum license count needed for the remote server, given the local server is licensed for 34 users? The documentation states that the Unix version must be installed and authorized, but the Windows version is installed and licensed. Does this mean that the Windows version does not need to be authorized and can be used right out of the box? Thanks for all the help and insight. Curt Stewart Tri-sys Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] more UV questions, triggers & who
Thanks to everyone who has been helping to re-educate me on Universe. Apparently I've successfully managed to comingle my Unidata and Universe features and now need help separating the two. Unfortunately I haven't been able to get all my answers from the manuals. My next question, doesn't Universe support Triggers, besides the SQL triggers? I searched through the manual and found reference to the SQL triggers but nothing yet for Universe triggers. Can someone confirm this for me? And if triggers are supported, which manual tells me about them. Also, when I do a WHO it returns the system id and the login id. I'm assuming that it's a configuration setting, but how do I not include the system id? Is it part of the Flavor settings? I've never seen it before so it was a complete surprise to me. Any directions in how I can get this back to normal would be appreciated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How to setup Distributed files across the network
Can someone tell me what is required to setup and use distributed files over a network. My client want's to separate the Application from the Data, so that each is on a separate server. I'm sure someone has already done this or something similiar before and I would appreciate any insight you could share on how to set this up, what if any, additional Universe modules are required. Any feedback would greatly be appreciated. Thanks for all the help to date. Curt Stewart Tri-Sys Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Windows reading a Virtual Tape File
I apologize if this is a dumb question, but I haven't found a definitive answer anywhere including the manuals. I'm still in the process of converting a D3 application to Universe and I've T-Dumped a bunch of file dictionaries to a VTF and now I just want to be able to T-LOAD them into the Universe Account. I've tried setting the device to the VTF but it won't read the file. What am I missing? I would appreciate any comments that you are willing to share. Thanks for your help. Sincerely, Curt Stewart TRI-SYS Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Accessing Active Directory
I need to pull a users Active Directory Group settings on a Universe Windows system to integrate into the application. Has somebody already done this and can you give me any suggestions and recommendations on how to accomplish this? I've found scripts to read the AD settings, but I don't know how to execute the script from within Universe Windows. Any recommendations, suggestions and examples are greatly appreciated. Thanks in advance. Curt Stewart No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.4.9/1548 - Release Date: 7/12/2008 7:40 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
