RE: [U2] Data Editor
The obvious place is for a vendor to add a page to PickWiki, and then any other vendors add themselves to that ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: 29 July 2008 00:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Data Editor Could we get links to multivalue vendors (who wish them) on the U2UG Knowledge Base page or somewhere? It is a crying shame that all these nifty multivalue tools are out there, and one only stumbles across them in miscellaneous posts. Also multivalue software packages. We have users with thousands of hours (millions?) of experience in the multivalue world, and we seem to be intent on keeping it all a secret. -- Louie --- 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] Data Editor
Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 July 2008 20:47 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor AD
Couple more freebies: For programs, data etc. mvDeveloper is a Windows based editor (over UniObjects) that supports highlighting and lots of useful bits and pieces. Also to view data in a more structured way, ENTER is a dictionary driven screen entry/display tool. Both downloadable for free from my website (www.brianleach.co.uk). Brian I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- 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] Data Editor
As a UniData client using wIntegrate there a program and VOC for WIN.EDIT (wIntegrate editor) Ex: :WIN.EDIT DIRECTORY RECORDNAME Here it has the goodies for editing, re-ftping back to the server, compiling, cataloging. Also other goodies in there that might be useful to you (as per post below from Symeon). Also we are running HP-UX 11 v1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 4:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 July 2008 20:47 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- 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] Universe ODC field association
I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe ODC field association
I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
I just tunnel telnet through ssh using putty. Unidebugger uses uniobjects so I again do the same for the uo port. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 29 July 2008 11:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODC field association
You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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] Data Editor
A nice multivalue subroutine for interactive screens, that takes row and column start points and headings for associated attributes, conversion and formatting of same, number of data rows displayed, and (A)dd, (I)nsert, (D)elete, (P)age, (E)nter (for next or field), and (S)ave prompts would be a nice gift for the group. Can someone fork one over to the group? john On 7/28/08, Louie Bergsagel [EMAIL PROTECTED] wrote: Could we get links to multivalue vendors (who wish them) on the U2UG Knowledge Base page or somewhere? It is a crying shame that all these nifty multivalue tools are out there, and one only stumbles across them in miscellaneous posts. Also multivalue software packages. We have users with thousands of hours (millions?) of experience in the multivalue world, and we seem to be intent on keeping it all a secret. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Universe ODC field association
What help exactly do you need? Make sure that the @ID is listed in @SELECT or whereever (I try to always list it as the very first field). That way, you can simply JOIN the single-value table to the ASSOCiated table. And have you seen the article on PickWiki? It's a bit out-of-date but still useful - go to the UniVerse page and it's linked from there. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: 29 July 2008 13:08 To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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] Data Editor
We just tried turning off telnet on our Redhat Linux UniVerse 10.2.4 test server to see what would happen as we are going to be permanently turning telnet off due to PCI requirements. The connection to the server using the UniObjects to edit the program worked just fine. I was able to connect in and open a program. However, the terminal session connection fails. One half of the debugger works, the editor. You just can't run the program in the debugger. Which makes it a full screen editor instead of a debugger. Brenda Price Affiliated Acceptance Corporation -Original Message- From: Symeon Breen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 7:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I just tunnel telnet through ssh using putty. Unidebugger uses uniobjects so I again do the same for the uo port. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 29 July 2008 11:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] static/dynamic file(s) opinions wanted!
Hi. Everybody talks about performance and maintenance. But, what about fragility? Years ago we move towards dynamic files. But many of our customer's servers didn't have UPS. So, a single storm or power supply failure could result in file corruption. Today we don't have dynamic files at all, except from those servers that are hosted in a very well conditioned environment. And yes, the resize of static files is absollutly necessary. We do it with a self made basic program. But we do it at night, because we had bad experiences with the CONCURRENT clause. By the way, could someone tell me from wich release of UniVerse the CONCURRENT clause is sure enough? Thanks, __ Augusto Alonso I.T. Manager Quiter Servicios Centrales Tel: +34 902 23 33 23 Fax: +34 902 23 42 80 [EMAIL PROTECTED] www.quiter.com __ - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, July 25, 2008 7:51 AM Subject: Re: [U2] static/dynamic file(s) opinions wanted! UniVerse Dynamic files do NOT resize every time they split. They only resize a single group at each split. The next group to split is allocated on a round robin basis from group number 1 up to the group number that is the highest power of 2 less than or equal to the current modulus. So, for a large dynamic file, it can be a long interval between when a group is resized and the next time it is resized. This is why we advocate resizing Dynamic files periodically. Yes, they will work OK if you don't. - Original Message - From: JPB-U2UG [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] static/dynamic file(s) opinions wanted! Date: Thu, 24 Jul 2008 22:23:51 -0500 Tom, The point is that it doesn't work with dynamic files. David, I don't really think you need to resize dynamic files because they are always resizing themselves, unless they are not changing size. This type of resizing is equivalent to defragging on a windows system. Since dynamic files resize every time they split then it is not necessary. --- 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 ODC field association
I was able to see (through an ODBC connection) an I-descriptor that displays only the first value of a multi-valued field without using a subroutine call. Here is the DICT entry: I FIELD(SitusStreetNbr,@VM,1):' ':FIELD(SitusStreetName,@VM,1) Situs Address 50L S I could also use a standard I-descriptor to return the COUNT of values in a multi-value field - through an ODBC connection: I DCOUNT(SitusStreetName,@VM) + 0 MD0 SITUS COUNT S I concur with Garry Smith on the creation of a separate account with VOC entries pointing to production data, but maintaining a local DICT that is used solely for ODBC connections (minimize the work by choosing only the fields you need, and rename the DICT entries with names appropriate to the outside world). Garry Smith [EMAIL PROTECTED] 7/29/2008 8:57 AM You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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 ODC field association
I have ODBC connections to our Universe 10.x files with multi-values working fine. I am not certain what you mean by setting up the association between the MV fields and regular fields in the file. The Universe scrubber takes care of providing a connection to the multi-values as a separate file which you can join to the master file. David Katz [EMAIL PROTECTED] 7/29/2008 7:50 AM I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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] Green Software - Green Business
Don Verhagen made the point that we do what comes naturally (conveniently) and sometimes that's green and sometimes it's not. For me, I admit, that's true. My green efforts have stemmed from what is convenient and less expensive, I admit it. I just think that it's lucky we are in an industry / business where being greener and doing what is better and cheaper all line up! My sister's company issued a green offer to the employees that it would pay for a bicycle for any employee that would ride it to work. So my sister jumped on it, got a great new bicycle and rides it to work every day and is the world's biggest enthusiast now. She's lost weight and says she feels 20 years younger. It's a huge triple win. I thought I might hear a few stories like my sister's company bicycle. I guess these kinds of initiatives are still rare, but expect they will become more common -- both for the marketing appeal of being able to claim greenness and because of the price of gas. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Green Software - Green Business
Ultimately, there's only one kind of green that companies care about (though for those of you outside the US, they print it in more than one color), and the other kind of green won't happen unless it facilitates making more of the first kind. Susan Joslyn wrote: Don Verhagen made the point that we do what comes naturally (conveniently) and sometimes that's green and sometimes it's not. For me, I admit, that's true. My green efforts have stemmed from what is convenient and less expensive, I admit it. I just think that it's lucky we are in an industry / business where being greener and doing what is better and cheaper all line up! My sister's company issued a green offer to the employees that it would pay for a bicycle for any employee that would ride it to work. So my sister jumped on it, got a great new bicycle and rides it to work every day and is the world's biggest enthusiast now. She's lost weight and says she feels 20 years younger. It's a huge triple win. I thought I might hear a few stories like my sister's company bicycle. I guess these kinds of initiatives are still rare, but expect they will become more common -- both for the marketing appeal of being able to claim greenness and because of the price of gas. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe ODC field association
If you create association fields in the dictionary for any associated multivalued fields they will appear as separate subtables via ODBC. You can also create association fields for individual (ie. not associated with any other) MV fields and they will appear as subtables. Garry Smith wrote: You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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/ -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Data Displayer
Following John Reid's wish list, the following hack may be of some use... --Bill *--- --- *R0 Bill Brutzman Jul.2008 prompt '' equate AM to char(254) equate VM to char(253) equate true to 1, false to 0 Red = @(-5) Grn = @(-6) Width = 6 *--- --- Main.Program: gosub Access.Check gosub First.Screen gosub Prompt.Fields.To.Show gosub Displayer go Main.Program *--- --- *--- --- First.Screen: crt @(-1) crt crt crt crt crt crt crt crt crt ' __ ' crt ' / \' crt ' \ DD / Data.Displayer ' crt ' \/ ' crt @(2,18) : @(-4) : 'File [X] ' : input Ans.1, 1 : Ans.1 = upcase(Ans.1) begin case case Ans.1 = 'X' ; go The.End end case input Ans.2 Ans.2 = upcase(Ans.2) File.Name = Ans.1 : Ans.2 open File.Name to F.File else null *--- --- crt @(2,20) : ' Record X ' : input Record Record = upcase(Record) begin case case Record = 'X' ; return to Main.Program end case *-- read R.File from F.File, Record else go Error.Not.On.File return *--- --- Prompt.Fields.To.Show: crt @(-1) Field.Array = '' for This.Field.Count = 1 to 200 crt @(4, This.Field.Count) : @(-4) : ' Field.# X ' : input Field.Nbr Field.Nbr = upcase(Field.Nbr) begin case case Field.Nbr = 'X' ; exit end case Field.Array-1 = Field.Nbr next This.Field.Count Next.This.Field.Count: return *--- --- Displayer: crt @(-1) print print ' ' : File.Name : ' ' : Record print Field.1 = Field.Array1 This.Field = R.FileField.1 Total.Nbr.Entries = dcount(This.Field, VM) Total.Nbr.Fields = dcount(Field.Array, AM) Field.Last = Field.ArrayTotal.Nbr.Fields for This.Field = Field.1 to Field.Last print This.Field 'R#2' : Red : ':' : Grn : for This.Count = 1 to Total.Nbr.Entries begin case case Width = 1 ; print R.FileThis.Field, This.Count 'L#1' : Red : '_' : Grn : case Width = 2 ; print R.FileThis.Field, This.Count 'L#2' : Red : '_' : Grn : case Width = 3 ; print R.FileThis.Field, This.Count 'L#3' : Red : '_' : Grn : case Width = 4 ; print R.FileThis.Field, This.Count 'L#4' : Red : '_' : Grn : case Width = 5 ; print R.FileThis.Field, This.Count 'L#5' : Red : '_' : Grn : case Width = 6 ; print R.FileThis.Field, This.Count 'L#6' : Red : '_' : Grn : case Width = 7 ; print R.FileThis.Field, This.Count 'L#7' : Red : '_' : Grn : case Width = 8 ; print R.FileThis.Field, This.Count 'L#8' : Red : '_' : Grn : case Width = 9 ; print R.FileThis.Field, This.Count 'L#9' : Red : '_' : Grn : case Width = 10 ; print R.FileThis.Field, This.Count 'L#10' : Red : '_' : Grn : case Width = 11 ; print R.FileThis.Field, This.Count 'L#11' : Red : '_' : Grn : case Width = 12 ; print R.FileThis.Field, This.Count 'L#12' : Red : '_' : Grn : case Width = 13 ; print R.FileThis.Field, This.Count 'L#13' : Red : '_' : Grn : case Width = 14 ; print R.FileThis.Field, This.Count 'L#14' : Red : '_' : Grn : case Width = 15 ; print R.FileThis.Field, This.Count 'L#15' : Red : '_' : Grn : case Width = 16 ; print R.FileThis.Field, This.Count 'L#16' : Red : '_' : Grn : case Width = 17 ; print R.FileThis.Field, This.Count 'L#17' : Red : '_' : Grn : case Width = 18 ; print R.FileThis.Field, This.Count 'L#18' : Red : '_' : Grn : case Width = 19 ; print R.FileThis.Field, This.Count 'L#19' : Red : '_' : Grn : case Width = 20 ; print R.FileThis.Field, This.Count 'L#20' : Red : '_' : Grn : case 1 ; print R.FileThis.Field, This.Count 'L#6' : Red : '_' : Grn : end case next This.Count print next This.Field gosub Bottom.Prompt return *--- --- Bottom.Prompt: crt crt ' [] Width.## [XX]' : input Ans, 2 Ans = upcase(Ans) begin case case Ans = 'XX' ; go The.End case 1 ; Width = Ans ; return to Displayer end case
RE: [U2] Data Editor
Where... is it in wIntegrate? I have a copy of wIntegrate installed on a PC that I use all of the time. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 4:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 July 2008 20:47 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- 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] Invalid Lock Sequence Write Errors
I'm getting the following error that's bailing me out of a UniData (version 6.0.9) subroutine. Because I thought it might be corruption, I ran guide, found no corruption, but a little undersized. I created a new file at correct modulo, then copied all records from original file over, then renamed new file to INVWHS. All records copied over (did a count on both). Ran guide on the new file and everything was as it should be. But I'm still getting the errors. So...I went in and verified I could edit the individual record, file it, even copy to new record name and delete original, and that's all working. In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL error = 102 : Invalid lock sequence In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Lockname (3 76257 1073807361) RX -- 13359104 PT-fid -- (376257 1073807361) IX R(13359104)--[1 0] 703(X 1) In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 upl lock er ror(102). In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 1: error in U_dyn_hash for file 'INVWHS', key '46483*195', number=6522 In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Fatal error : WRITE error This is not just one record (hit about 20 so far), but here's the syntax below: The syntax at line 115 is WRITE ITEM.WH ON FILE.WH,WH.KEY. The record was locked about 10 lines earlier... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
[AD] Hopefully, you all have heard of XLr8Editor. This editor has been available for free for 2 1/2 years now. We have over 700 licensed users. The client runs on Eclipse.org IDE under Windows, Linux or MacOS. It uses UniRPC to edit programs or data on Universe or Unidata. Unidata version support is available from 6.1 forward. Universe support is from version 9.6 forward. To mention a few of the many features: 1) It has the ability to show you differences on a line by line basis using QuickDiff. 2) You can click on your include files and they will open another editor tab window. 3) You can edit programs on any number of servers simultaneously. 4) You can compile or format using Alt keys. 5) All internal subroutines show up on the outline tab, allowing quick movement to them. 6) Global search variables and replace variables. 7) Use either CVS or Subversion for source code control 8) Color code of keywords and comments See our web site for more information at http://www.u2logic.com/XLr8_Editor.html. Email me for special pricing support options. Regards, Doug [/AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Tuesday, July 29, 2008 11:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor We just tried turning off telnet on our Redhat Linux UniVerse 10.2.4 test server to see what would happen as we are going to be permanently turning telnet off due to PCI requirements. The connection to the server using the UniObjects to edit the program worked just fine. I was able to connect in and open a program. However, the terminal session connection fails. One half of the debugger works, the editor. You just can't run the program in the debugger. Which makes it a full screen editor instead of a debugger. Brenda Price Affiliated Acceptance Corporation -Original Message- From: Symeon Breen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 7:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I just tunnel telnet through ssh using putty. Unidebugger uses uniobjects so I again do the same for the uo port. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 29 July 2008 11:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- 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] Data Editor
The terminal does indeed use telnet, but for pci you are allowed telnet, just not beyond the firewall - so all you need to do is close port 23 on the firewall, then you can tunnel your telnet over ssh with say putty, or your ssh tool of choice, or indeed vpn in. Or if you are inside the firewall just use telnet. TBH I rarely use its debugging functions, I think the name is perhaps misleading, yes you can use it to do visual debugging, but it is also a pretty decent editor, which is how I use it 90% of the time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: 29 July 2008 18:08 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor We just tried turning off telnet on our Redhat Linux UniVerse 10.2.4 test server to see what would happen as we are going to be permanently turning telnet off due to PCI requirements. The connection to the server using the UniObjects to edit the program worked just fine. I was able to connect in and open a program. However, the terminal session connection fails. One half of the debugger works, the editor. You just can't run the program in the debugger. Which makes it a full screen editor instead of a debugger. Brenda Price Affiliated Acceptance Corporation -Original Message- From: Symeon Breen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 7:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I just tunnel telnet through ssh using putty. Unidebugger uses uniobjects so I again do the same for the uo port. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 29 July 2008 11:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1578 - Release Date: 28/07/2008 17:13 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.6/1579 - Release Date: 29/07/2008 06:43 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Anyone heard from Ross Morrissey?
I've been trying to reach him for several days; Anyone heard anything from Ross? -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Green Software - Green Business
On Tue, Jul 29, 2008 at 11:24 AM, Susan Joslyn [EMAIL PROTECTED] wrote: I thought I might hear a few stories like my sister's company bicycle. I guess these kinds of initiatives are still rare, but expect they will become more common -- both for the marketing appeal of being able to claim greenness and because of the price of gas. Especially with the price of gas, there's no better time than the present for companies to seriously consider telecommuting. I've been a full time telejockey for many years now and there's nothing quite like filling up the (motorcycle) tank for $8, especially knowing it's all for entertainment travel rather than required to make a living. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Data Displayer
No offense, but do you realize that big CASE statement could be reduced to three lines? If (Width LT 1 or Width GT 20) Then Width = 6 Mask = L# : Width print R.FileThis.Field, This.Count Mask : Red : '_' : Grn : On Tue, Jul 29, 2008 at 2:48 PM, Brutzman, Bill [EMAIL PROTECTED]wrote: Following John Reid's wish list, the following hack may be of some use... --Bill *--- --- *R0 Bill Brutzman Jul.2008 prompt '' equate AM to char(254) equate VM to char(253) equate true to 1, false to 0 Red = @(-5) Grn = @(-6) Width = 6 *--- --- Main.Program: gosub Access.Check gosub First.Screen gosub Prompt.Fields.To.Show gosub Displayer go Main.Program *--- --- *--- --- First.Screen: crt @(-1) crt crt crt crt crt crt crt crt crt ' __ ' crt ' / \' crt ' \ DD / Data.Displayer ' crt ' \/ ' crt @(2,18) : @(-4) : 'File [X] ' : input Ans.1, 1 : Ans.1 = upcase(Ans.1) begin case case Ans.1 = 'X' ; go The.End end case input Ans.2 Ans.2 = upcase(Ans.2) File.Name = Ans.1 : Ans.2 open File.Name to F.File else null *--- --- crt @(2,20) : ' Record X ' : input Record Record = upcase(Record) begin case case Record = 'X' ; return to Main.Program end case *-- read R.File from F.File, Record else go Error.Not.On.File return *--- --- Prompt.Fields.To.Show: crt @(-1) Field.Array = '' for This.Field.Count = 1 to 200 crt @(4, This.Field.Count) : @(-4) : ' Field.# X ' : input Field.Nbr Field.Nbr = upcase(Field.Nbr) begin case case Field.Nbr = 'X' ; exit end case Field.Array-1 = Field.Nbr next This.Field.Count Next.This.Field.Count: return *--- --- Displayer: crt @(-1) print print ' ' : File.Name : ' ' : Record print Field.1 = Field.Array1 This.Field = R.FileField.1 Total.Nbr.Entries = dcount(This.Field, VM) Total.Nbr.Fields = dcount(Field.Array, AM) Field.Last = Field.ArrayTotal.Nbr.Fields for This.Field = Field.1 to Field.Last print This.Field 'R#2' : Red : ':' : Grn : for This.Count = 1 to Total.Nbr.Entries begin case case Width = 1 ; print R.FileThis.Field, This.Count 'L#1' : Red : '_' : Grn : case Width = 2 ; print R.FileThis.Field, This.Count 'L#2' : Red : '_' : Grn : case Width = 3 ; print R.FileThis.Field, This.Count 'L#3' : Red : '_' : Grn : case Width = 4 ; print R.FileThis.Field, This.Count 'L#4' : Red : '_' : Grn : case Width = 5 ; print R.FileThis.Field, This.Count 'L#5' : Red : '_' : Grn : case Width = 6 ; print R.FileThis.Field, This.Count 'L#6' : Red : '_' : Grn : case Width = 7 ; print R.FileThis.Field, This.Count 'L#7' : Red : '_' : Grn : case Width = 8 ; print R.FileThis.Field, This.Count 'L#8' : Red : '_' : Grn : case Width = 9 ; print R.FileThis.Field, This.Count 'L#9' : Red : '_' : Grn : case Width = 10 ; print R.FileThis.Field, This.Count 'L#10' : Red : '_' : Grn : case Width = 11 ; print R.FileThis.Field, This.Count 'L#11' : Red : '_' : Grn : case Width = 12 ; print R.FileThis.Field, This.Count 'L#12' : Red : '_' : Grn : case Width = 13 ; print R.FileThis.Field, This.Count 'L#13' : Red : '_' : Grn : case Width = 14 ; print R.FileThis.Field, This.Count 'L#14' : Red : '_' : Grn : case Width = 15 ; print R.FileThis.Field, This.Count 'L#15' : Red : '_' : Grn : case Width = 16 ; print R.FileThis.Field, This.Count 'L#16' : Red : '_' : Grn : case Width = 17 ; print R.FileThis.Field, This.Count 'L#17' : Red : '_' : Grn : case Width = 18 ; print R.FileThis.Field, This.Count 'L#18' : Red : '_' : Grn : case Width = 19 ; print R.FileThis.Field, This.Count 'L#19' : Red : '_' : Grn : case Width = 20 ; print R.FileThis.Field, This.Count 'L#20' : Red : '_' : Grn : case 1 ; print R.FileThis.Field, This.Count 'L#6' : Red : '_' : Grn : end case next This.Count print next This.Field gosub Bottom.Prompt
Re: [U2] Invalid Lock Sequence Write Errors
re: In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL error = 102 : Invalid lock sequence UniData physical lock manager (eg group locks - not record locks per se). I would work with your UniData support provider - Epicor? For this sort of problem isolation, likely a better route than this forum. Indexes on the file? virtual field index update sequence (Tfilename - back to the same record in the same file?) Triggers? full UniData version? eg 7.1.16 platform? udtconfig settings? What changed? udtdiag dump as close to the time the problem is occuring might help (lock table dump is part of that). small test case that demonstrates the error? happy hunting. Wally Terhune Mark your U2 Support Architectcalendar! IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support [demime 1.01d removed an attachment of type image/jpeg which had a name of 23547588.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Getting stuck inside DOS shell UV-W2000
Gentlemen, Does anyone know how to shell to DOS from UV-Basic without losing control of the possibility to respond to INPUT generated from the DOS program that was called? For example if I do EXECUTE DOS /c gpg etc to encrypt a data file, I would want that the DOS gpg program prompt me for a value and then continue. The only thing that occurs when I do this is that my session gets hung. Any helpful hints? Version 10.2.3 W2000 Many thanks, Marc Hilbert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Green Software - Green Business
Jeff, you wouldn't happen to have worked for EBS and VERSYSS? David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, July 25, 2008 7:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Green Software - Green Business Well Susan, my company makes it's money selling products to manufacturers of oil and natural gas equipment. I tried to bring up the subject of telecommuting and was laughed out of the room. My motives were however purely selfish as I don't like pouring $40-$50 a week down the filler tube on my car. We are trying to go paperless. We print thousands of sheets of paper, then scan and shred them once we're done writing on them. Oh well ... going green is not on the radar anytime soon. --- 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/
