Re: [U2] [UV] Is anyone up on UV 11.2 ?
We are most interested in Account-Based licensing, and Replication Monitoring. On Tue, Feb 25, 2014 at 1:24 PM, baker_hug...@neimanmarcus.com wrote: Are there patches or features that you are especially interested in? Regards, R. Baker Hughes Senior UV DBA, Wipro/NMG From: Bobby Worley bwor...@coburns.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 02/18/2014 12:49 PM Subject:Re: [U2] [UV] Is anyone up on UV 11.2 ? Sent by:u2-users-boun...@listserver.u2ug.org We will be upgrading to Universe 11.2 (AIX) very soon, as in the next few weeks. -- *Bob Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.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 -- *Bob Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Is anyone up on UV 11.2 ?
We will be upgrading to Universe 11.2 (AIX) very soon, as in the next few weeks. -- *Bob Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
Thanks for all the replies and opinions on mixed case basic coding. A little more info on my personal work configuration: - we are on Universe 11.1 / IBM AIX / Accuterm - I use Rocket BDT for 95% of my coding - - I have a home grown search tool that goes through all our source files but, I looked a little more into the Search menu tool in Eclipse (BDT) and it appears to have much more power (thanks for that tip on Eclipse, Doug). There are more and more features in Basic Developer Toolkit and XAdmin that i'm finding every day. Great tool!Now i'm wanting another 23 or larger monitor to be able to see more data in all the panes ;) Brian Leach - would you be will do share some code samples of how you use mixed case? you can email to me directly. On Mon, Dec 23, 2013 at 9:27 AM, Wols Lists antli...@youngman.org.ukwrote: On 22/12/13 22:39, Peter Cheney wrote: My colleague has recently introduced me to the joys of Emacs but am struggling to un-learn vi. http://www.emacswiki.org/emacs/ViperMode I thought I remembered something like this ... Wol (a dinosaur who wishes he still had the Sheffield EDitor :-) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *Bob Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] BASIC code - upper, lower, CamelCase, what say you?
First off - Merry Christmas and Happy New Year to all. I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for our DesignBais application, and since I'll be starting with a blank code template instead of modifying existing code, and I thought 'hey why not join the 21st century' and make the code look more mainstream, and readable. (falling back on our last TEXMUG presentation by Clif Oliver on refactoring). And considering Universe 11.2 now supports local subroutines and functions, I should make the code look and behave more object-like. Does anyone know of a set of rules or guidelines on how to do this?Just experimenting briefly, Universe BASIC compiler will allow any mix of cases for keywords, but variables are case sensitive. Example: ED BP TEST ABC=1 Abc=2 abc=3 PRINT ABC Print Abc pRiNt abc stop end RUN TEST 1 2 3 So, how are developers mixed case in their code these day? Do keywords, local variables, common variable, equates follow a standard method? thanks in advance, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
I am not concerned about portability at all, this is for our company only. On Fri, Dec 20, 2013 at 1:16 PM, Bruce Decker bdec...@bluepinc.com wrote: Depends on how portable you want your code to be. Some older systems, even some symbols are case insensitive. For U2, Unidata is pickier out of the box about keyword case than UniData. I've settled on UPPERCASE for reserved words and camelCase for variables. But old-school die hards think it's totally unreadable. I think if you program in other languages, you find it appealing. If I discard the criticism of those who still embrace GOTO, then the objections are probably 1 out of 4. You know the programmer is poser if he writes GOTO as goTo :-) -BD On 12/20/2013 12:01 PM, Bobby Worley wrote: First off - Merry Christmas and Happy New Year to all. I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for our DesignBais application, and since I'll be starting with a blank code template instead of modifying existing code, and I thought 'hey why not join the 21st century' and make the code look more mainstream, and readable. (falling back on our last TEXMUG presentation by Clif Oliver on refactoring). And considering Universe 11.2 now supports local subroutines and functions, I should make the code look and behave more object-like. Does anyone know of a set of rules or guidelines on how to do this? Just experimenting briefly, Universe BASIC compiler will allow any mix of cases for keywords, but variables are case sensitive. Example: ED BP TEST ABC=1 Abc=2 abc=3 PRINT ABC Print Abc pRiNt abc stop end RUN TEST 1 2 3 So, how are developers mixed case in their code these day? Do keywords, local variables, common variable, equates follow a standard method? thanks in advance, ___ 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 -- *Bob Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
This is really what got my thought-process flowing on this subject. I saw this code on github after the Rocket Software Whats New in 11.2 webinar: https://github.com/RocketSoftware/u2-servers-lab/blob/master/UniVerse-11.2/Local/BP/LocalMain PROGRAM LocalMain ** Let's have a quick look at local scoping CRT Calling the local SUBROUTINE CALL Main(@SENTENCE) ;* This will call Main() below, rather than an external subroutine CRT Back from the local SUBROUTINE END SUBROUTINE Main(Args) CRT Running inside the local SUBROUTINE CRT Args: :Args FOR Counter = 1 TO 3 CALL InnerLoop(Counter) NEXT Counter RETURN SUBROUTINE InnerLoop(OutsideCounter) * Notice this won't affect Main()'s 'Counter' variable due to scoping FOR Counter = 1 TO OutsideCounter CRT *: NEXT Counter CRT RETURN ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Triggers in Universe
I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. CATALOG BDW TRIGTEST TRIGTEST cataloged. .L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program BDW.O/TRIGTEST. -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob bob_woodw...@k2sports.comwrote: In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. CATALOG BDW TRIGTEST TRIGTEST cataloged. .L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program BDW.O/TRIGTEST. -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.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 -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
That's what I did, Perry! GMTA ;) On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor perry.tay...@zirmed.comwrote: You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC record from the UV account to your Pick-flavored account VOC renaming it something like ICATALOG. We do it all the time for our file-based triggers. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 3:03 PM To: U2 Users List Subject: Re: [U2] Triggers in Universe The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob bob_woodw...@k2sports.com wrote: In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. CATALOG BDW TRIGTEST TRIGTEST cataloged. .L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program BDW.O/TRIGTEST. -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.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 -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] {BDT] Commenting A Block Of Code
The OP (bill) included {BDT] in the subject line so he is asking about
Basic Developer Toolkit.
the Ctrl-/ answer is correct.
On Thu, Jan 10, 2013 at 2:49 AM, Symeon Breen syme...@gmail.com wrote:
The big question is which editor ? Winted, Unidebugger, BDT , etc ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 10 January 2013 01:25
To: U2 Users List
Subject: [U2] {BDT] Commenting A Block Of Code
Rather than going line-by-line... is there a way... or a trick to
highlighting several lines of code...
And commenting out all of these lines in aggregate?
I have a legacy program whose code is no longer compliant... that I am
trying to isolate.
--Bill
___
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: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
*Bobby D. Worley*
IT Applications Developer
Coburn Supply Company
o: 903.753.8613 | m: 214.676.9825
bwor...@coburns.com
** **
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] BDT - formatting basic code
We finally upgraded Universe to 11.1.9 on AIX, so i am now starting to use BDT (Basic Developer Toolkit) on a daily basis. Does anyone know of a way to specify how the code editor formats? Ctrl-Shift-F removes leading spaces, then indents lines using tab char(9) instead of spaces. Example: FORMAT results from TCL EDitor: 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: IF SI=12 THEN 0005: CRT 'HELLO' 0006: END ELSE 0007: GOSUB DO.SOMETHING 0008: END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016:END Bottom at line 16. Format (Ctrl-Shift-F) results in BDT 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: ^009IF SI=12 THEN 0005: ^009^009CRT 'HELLO' 0006: ^009END ELSE 0007: ^009^009GOSUB DO.SOMETHING 0008: ^009END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016: END Bottom at line 16. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT - off topic question
We were on Universe 10.3 which did not work with Eclipse/BDT. On Wed, Dec 19, 2012 at 1:41 PM, doug d...@chancofamily.com wrote: Could you not use it before you upgraded? Sorry about being off topic Dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT - formatting basic code
Bill, Thank you for your helpful response. I found in Preferences Text Editors - i was able to set spaces for tabs, and tab width. (and also show line numbers, which I was missing). So now I just need to find how I can set the first column to 6 instead of 1. On Wed, Dec 19, 2012 at 12:19 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: Googling... eclipse text format... yielded... among other things... http://www.wikihow.com/Change-the-Default-Format-Settings-in-Eclipse --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Wednesday, December 19, 2012 12:57 PM To: U2 Users List Subject: [U2] BDT - formatting basic code We finally upgraded Universe to 11.1.9 on AIX, so i am now starting to use BDT (Basic Developer Toolkit) on a daily basis. Does anyone know of a way to specify how the code editor formats? Ctrl-Shift-F removes leading spaces, then indents lines using tab char(9) instead of spaces. Example: FORMAT results from TCL EDitor: 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: IF SI=12 THEN 0005: CRT 'HELLO' 0006: END ELSE 0007: GOSUB DO.SOMETHING 0008: END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016:END Bottom at line 16. Format (Ctrl-Shift-F) results in BDT 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: ^009IF SI=12 THEN 0005: ^009^009CRT 'HELLO' 0006: ^009END ELSE 0007: ^009^009GOSUB DO.SOMETHING 0008: ^009END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016: END Bottom at line 16. ___ 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 -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT - formatting basic code
Bernard, I am using BDT version 3.0.4.I right-clicked in the editor pane and went to Preferences there. I'm new to Eclipse so I'm still fumbling around, but i'm starting to figure things out - thanks! Bob On Wed, Dec 19, 2012 at 3:50 PM, Bernard Lubin bernard.lu...@pentanasolutions.com wrote: Just tested this on our server and it is placing spaces instead of the tab character. You may have to change your tab setting. (Windows/Preference /Ant/Editor/Formatter) - uncheck the Use tab char instead of spaces checkbox I am using Version 3.0.3 of the BDT. I remember that there were some issues with the previous version, in regards to tab character Rgds Bernard ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Compare/Diff feature in BDT
In Rocket Software's Basic Developer Toolkit, I thought there was a source code compare capability - did I imagine that? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compare/Diff feature in BDT
Thanks, Tom - I knew I had seen it somewhere! I was looking in the toolbar. FYI - you could compare paragraphs, procs, etc if you copy them to a dir-type file like hold or some such. I know its an extra step, but it is possible. Regards, Bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, April 05, 2012 9:03 AM To: U2 Users List Subject: Re: [U2] Compare/Diff feature in BDT There is a compare feature in BDT. It only works for records in directories though. I'd love to be able to compare paragraphs, procs or dictionaries but I haven't seen a way. To compare, you need to select the first program then hold the control key and select the second program. Now right-click and choose Compare with, then each other. Make sure you don't have the folder selected, BDT will report that it doesn't support the function. (not the exact wording). The compare view shows two panes and you have icons to move from one difference to another, and to move code from one pane to another... all icons but the hover does provide a description. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Thursday, April 05, 2012 9:49 AM To: U2 Users List Subject: [U2] Compare/Diff feature in BDT In Rocket Software's Basic Developer Toolkit, I thought there was a source code compare capability - did I imagine that? ___ 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] Job at Rocket in Denver
I would love to take a stab at it, and the wife would love to live in Denver - I just can't leave the good ol' Republic of Texas... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, March 28, 2012 12:49 PM To: U2 Users List Subject: Re: [U2] Job at Rocket in Denver You should read this only as a good sign that the U2 business continues to grow and expand at Rocket Software. This will be a welcome addition to our team as we accelerate and optimize our product development and delivery. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com | Web: www.rocketsoftware.com/u2 \ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT - V3
I would like to live in this tool all day long. I have experimented with BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about it. I'm having to be able to be productive quickly, so I find myself reverting back to WED when I have to get something done quick. It would be helpful if there is an online tutorial, so I could transition to BDT full time. ? (I'm only interesting in learning about BDT, not any other alterative EDIs at this time, thanks) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, March 12, 2012 2:46 PM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 The new BDT is version 3.0.0. Considering that I live in this tool almost all day long, I appreciate Rocket's updating it very much indeed. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT
Is the new BDT newer than version 1.2.4 ?? that's what I have had over a year... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, March 12, 2012 1:06 PM To: U2 Users List Subject: Re: [U2] New U2 BDT I was glad to learn about the new BDT. The BDT install was painless and BDT seems to work well. --Bill ___ 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] Building an Excel File
I just did something very similar last week. 'CSV' is a VM delimited dynarray to be converted: VCNT=DCOUNT(CSV,@VM) FOR VPTR=1 TO VCNT CSVCELL=CSV1,VPTR IF INDEX(CSVCELL,',',1) OR INDEX(CSVCELL,'',1) THEN CSVCELL=CHANGE(CSVCELL,'','') CSVCELL=QUOTE(CSVCELL) CSV1,VPTR=CSVCELL END NEXT VPTR CONVERT @VM TO ',' IN CSVDATA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, February 06, 2012 5:26 PM To: U2 Users List Subject: Re: [U2] Building an Excel File I have always tried to avoid csv files because we have all kinds of characters in our descriptions (commas, double and single quotes, etc.) It is also very easy to build a row of data with 254 delimiters, then simply convert @FMs to tabs. That being said, do you have a good subroutine to build csv rows that will not get confused with commas or quotes in the data? I am willing to give this a try. John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Import XML data [not-secure]
You will not get Universe's XML tools to work on version 10.2. Must be version 10.3 or higher. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Thursday, January 26, 2012 3:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse Import XML data [not-secure] We have never received or processed data in XML before, but in the next 4-6 months we will start receiving data in XML from a partner on a daily basis. The documentation for the XML/DB tool and XML.TODB seems a little sparse. Does anyone have or know of a clearer discussion or walk through on the process? I found one video on Rocket's website that indicated there would be more, but I haven't been able to find any continuing the series. We're using UniVerse 10.2.2 on Solaris 11 (to be upgraded to UV 11.1.x in the next few months)... Mark Hennessey CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a person responsible to receive this e-mail for the intended recipient, please do not disseminate, distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. We will take immediate and appropriate action to see to it that this mistake is corrected.[*LD*] ___ 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] FYI - Another UV shop going away...
This is sad news. I was in on the initial implementation of the Lab Force LIS at Ochsner in New Orleans so many years ago. It was a very fun, challenging project - and I'm proud to see that the product has held out so well after all this time. Glenn Luedke is a very good friend of mine, even though we haven't worked together in years. he was my first boss/PM at Lab Force in 1985 (dating myself now). The last time we worked together was around 2000. I hope he is doing well. Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Tuesday, January 24, 2012 10:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] FYI - Another UV shop going away... Just FYI, Yesterday, Ochsner Health System (8 hospital plus ~40 clinics covering from New Orleans to Baton Rouge, LA.) announced that the in-house maintained Laboratory Information System will be replaced with SoftLab from Soft Computer Corp (softcomputer.com). The in-house system was originally a Pr1me then PI-Open, then Ardent to IBM to Rocket UniVerse system. The source was licensed from LabForce some 20 years ago and maintained and further enhanced in-house with things like automated faxing, connections to PHP/Apache, MS-SQL Sybase, some GUI (where it made sense), etc. Looks like I'll be moving into the Oracle on AIX world here shortly... Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DesignBais Website
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, January 12, 2012 5:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DesignBais Website I was just there last night to check out the v6 enhancements. The site is all run using DesignBais itself - very clean and lightning fast even overseas. If you're going to do a demo, don't bother installing unless you want to demo the designer. Just run the samples off the live site. BTW, if you click that Done, but with errors on the page message it should show the errors which DBI might want to see, and which might tip you off as to why the page didn't display for you. T From:Oaks, Harold I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. ___ 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] DesignBais Website
And if you want to see a video on how the new DesignBais was built using DesignBais 6, you can watch it here: http://www.youtube.com/watch?v=Sw2gA04rRTg Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, January 12, 2012 5:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DesignBais Website I was just there last night to check out the v6 enhancements. The site is all run using DesignBais itself - very clean and lightning fast even overseas. If you're going to do a demo, don't bother installing unless you want to demo the designer. Just run the samples off the live site. BTW, if you click that Done, but with errors on the page message it should show the errors which DBI might want to see, and which might tip you off as to why the page didn't display for you. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DesignBais Website
That is, if you want to see a video on how the new Designbais Website www.designbais.com was built using DesignBais 6 I should proof my emails better before hitting send. I haven't finish my first cup of coffee yet.. ugh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 13, 2012 9:34 AM To: U2 Users List Subject: Re: [U2] DesignBais Website And if you want to see a video on how the new DesignBais was built using DesignBais 6, you can watch it here: http://www.youtube.com/watch?v=Sw2gA04rRTg Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, January 12, 2012 5:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DesignBais Website I was just there last night to check out the v6 enhancements. The site is all run using DesignBais itself - very clean and lightning fast even overseas. If you're going to do a demo, don't bother installing unless you want to demo the designer. Just run the samples off the live site. BTW, if you click that Done, but with errors on the page message it should show the errors which DBI might want to see, and which might tip you off as to why the page didn't display for you. T ___ 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] Extracting XML attributes
Does anybody have an experience reading in very large XML files into Universe on AIX using PrepareXML() function? We received a 176Mb XML file, and I'm running out of memory. I've maxed out ulimit -d and it still blows up with this error: ERROR MESSAGE A DOM error occured during parsing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Wednesday, November 16, 2011 7:34 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes Turns out it is a memory issue. My XML file is 16Mb. Setting ulimit -d 75 resolved the issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, November 11, 2011 10:42 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes My latest challenge: PREPARE.XML FEED.XML MYXML Prepare the XMLDOM failed. XMLParser error message: A DOM error occured during parsing. UNIVERSE RELLEVEL 001 X 002 11.1.0 003 PICK 004 PICK.FORMAT 005 11.1.0 Aix Version 5.3.0.0 FEED.XML is 16mb. It prepares just fine on UV 10.1.17. Unfortunately it wont list on UV 10.1 because UV 10.1 is not aware of namespaces. This is making my pull my hair out... I don't need this on a Friday. Bob Worley Coburn Supply ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extracting XML attributes
I suppose sequential reads is one approach I may need to consider, especially if I develop this as a tool for our end-users (doing the XML import). I was able to process the large file - It took some jumping through hoops, but I got the file imported. 20,669 records. I set ulimit -d to unlimited , but in order to do so, I had to login as root, set ulimit, then go into UV. Then the program completed. This is on a back up UV server with no other users. - Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Thursday, January 12, 2012 10:30 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes When working with large XML files in the past I've always run into issues like this but I use a combination of xmapopen, xmapreadnext, and xmapclose. I couldn't ever come up with a great way to use the UV tools for parsing a large file at once so I open as a sequential file and parse the file until I have a full record. I then process that one record with the xml functions. There might be 15 other ways but this has always served its purpose. - Josh On 1/12/12 11:10 AM, Bobby Worley bwor...@coburns.com wrote: Does anybody have an experience reading in very large XML files into Universe on AIX using PrepareXML() function? We received a 176Mb XML file, and I'm running out of memory. I've maxed out ulimit -d and it still blows up with this error: ERROR MESSAGE A DOM error occured during parsing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Wednesday, November 16, 2011 7:34 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes Turns out it is a memory issue. My XML file is 16Mb. Setting ulimit -d 75 resolved the issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, November 11, 2011 10:42 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes My latest challenge: PREPARE.XML FEED.XML MYXML Prepare the XMLDOM failed. XMLParser error message: A DOM error occured during parsing. UNIVERSE RELLEVEL 001 X 002 11.1.0 003 PICK 004 PICK.FORMAT 005 11.1.0 Aix Version 5.3.0.0 FEED.XML is 16mb. It prepares just fine on UV 10.1.17. Unfortunately it wont list on UV 10.1 because UV 10.1 is not aware of namespaces. This is making my pull my hair out... I don't need this on a Friday. Bob Worley Coburn Supply ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DesignBais Website
supp...@designbais.com Rick Weiser Vice President of Client Services DesignBais International Toll Free: +1 877-889-9777 Local: +1 856-424-2133 Fax:+1 509-355-7539 http://www.youtube.com/user/designbais -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, January 12, 2012 1:39 PM To: U2 Users List Subject: [U2] DesignBais Website I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. Thanks- Harold Oaks Clark County, WA, USA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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] Extracting XML attributes
Turns out it is a memory issue. My XML file is 16Mb. Setting ulimit -d 75 resolved the issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, November 11, 2011 10:42 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes My latest challenge: PREPARE.XML FEED.XML MYXML Prepare the XMLDOM failed. XMLParser error message: A DOM error occured during parsing. UNIVERSE RELLEVEL 001 X 002 11.1.0 003 PICK 004 PICK.FORMAT 005 11.1.0 Aix Version 5.3.0.0 FEED.XML is 16mb. It prepares just fine on UV 10.1.17. Unfortunately it wont list on UV 10.1 because UV 10.1 is not aware of namespaces. This is making my pull my hair out... I don't need this on a Friday. Bob Worley Coburn Supply ___ 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] Extracting XML attributes
My latest challenge: PREPARE.XML FEED.XML MYXML Prepare the XMLDOM failed. XMLParser error message: A DOM error occured during parsing. UNIVERSE RELLEVEL 001 X 002 11.1.0 003 PICK 004 PICK.FORMAT 005 11.1.0 Aix Version 5.3.0.0 FEED.XML is 16mb. It prepares just fine on UV 10.1.17. Unfortunately it wont list on UV 10.1 because UV 10.1 is not aware of namespaces. This is making my pull my hair out... I don't need this on a Friday. Bob Worley Coburn Supply ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Extracting XML attributes
Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extracting XML attributes
The xsl would be much appreciated, thanks! Bob bwor...@coburns.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 09, 2011 4:11 PM To: 'U2 Users List' Subject: Re: [U2] Extracting XML attributes Your start is the Feed element in the pr namespace. The u2 xml extraction does not always work too well with namespaces. If required I can supply you an xsl to 'de namepsace' an xml - it is then simple preprocessing task using xmltproc to give you a cleaner (in u2 regards) xml. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] attention Tony Gravagno
Please contact me directly - thanks Bobby D. Worley IT Applications Developer Coburn Supply Company bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Signature capture solution
Thanks to Tony G. and Bob R. for your quick responses.We will be in touch! Bobby D. Worley IT Applications Developer Coburn Supply Company bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Signature capture solution
We are running Universe on AIX, with Accuterm emulation on Win XP/7 clients. We are looking for a way to capture digital signatures at our sales counters, and store the signature image with the associated invoices and print them on the invoice form. Has anyone accomplished this in a U2 / AIX ERP? Here is an example of a product: http://topazsystems.com/ Thanks, Bobby D. Worley IT Applications Developer Coburn Supply Company bwor...@coburns.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Cross-flavor code
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, June 24, 2011 11:34 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Cross-flavor code I'll ask a simple question and only expand if really necessary. Compile a subroutine in a Pick flavor Universe account. That subroutine has a Named Common statement. Now F-point to that code file from an Information flavor account. Compile another program that calls the first. (This can be in a file local to the Information account or through the pointer into the Pick account.) At runtime we see error COMMON size mismatch. CLEARCOMMON doesn't help UPDATE.ACCOUNT INFORMATION on the subroutine account doesn't help. It seems the subroutine must be compiled with the same flavor as any program which calls it. Is that accurate? If that's the case, I would suggest that the error is incorrect to describe the problem. I'd hope to see something more like Flavor mismatch between caller and called subroutine. Anyone here agree? Thanks. T ___ 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] Unidata command stack (history)
Unless your up-arrow is your break key :/ gggrr... -Original Message- From: John Thompson Sent: Tuesday, June 14, 2011 9:45 AM To: U2 Users List Subject: Re: [U2] Unidata command stack (history) This might help, maybe... I found an option in Universe that you can do at TCL. COMMAND.EDITOR ON Its still fairly lame, but, at least you can use the up arrow. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] BDT 1.2.4 for Universe
I've just downloaded and installed the latest version of Basic Developer Toolkit for Universe (AIX). When I connect to our UV server and select an account, I'm not seeing any cataloged programs or database files. When I attempt to expanded on cataloged programs I getting an error dialog box: Load cataloged program failed. Failed to get cataloged program names from server (our ip). Error message: (blank) Any ideas? Bob Worley Lead Developer Coburn Supply Company ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Instead of Tab-delimited, look at CSV format. It supports embedded single- and double-quotes. And CSV imports into Excel. Embedded double quotes are two consecutive chars: http://en.wikipedia.org/wiki/Comma-separated_values Bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 15:30 To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel That would not work. We use double and single quotes in descriptions for describing lengths. For example, we might sell something whose dimensions are: 2x3x10' Even so, your info was helpful if I know my data will not have double quotes. Anyone else have an idea? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, June 22, 2009 10:25 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Dunno, how about converting double quotes in the data to single quotes? Or stripping them out entirely? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 15:22 To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel Cool. Here is the next wrinkle. What if my UniData data has (or may have) quotes in it? Am I out of luck or is there some alternate way to get the same result? Is there something like in other languages that you could convert double quotes in the raw data to /q or whatever, and Excel would know how to handle this? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Monday, June 22, 2009 9:58 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Yes, if you quote-delimit all your fields then it's possible to pass @VMs as line feeds, and it will do what you want. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 14:56 To: 'U2 Users List' Subject: [U2] Simple Export to Excel We have lots of programs that export our data from UniData to tab-delimited text files. Some of these are opened by Excel (which has its faults), some are imported into other databases. These files will be 1) E-mailed as attachments or written to specific location on the network. If I know that the users will always use Excel to open the attachment, I usually make the file extension xls so that it simply fires up Excel when double-clicked and parses everything out reasonably cleanly (but still drops leading zeros, converts big numbers to scientific notation, etc). We are using UniData on HP-Unix. Is there a good way to convert @VMs to something that Excel will correctly convert to what would be equivalent to the Alt+Enter in Excel? I do not want the data on multiple rows - I want multiple lines with breaks within a single row/cell. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR.
RE: [U2] Denver IBM U2 Office Closed due to Blizzard
Reminds me of when I was employed by Unidata Professional Services group, and we could have quarterly meetings in Denver. October, 1997 my wife came with me to celebrate our 10th wedding anniversary that weekend in a cabin in Breckenridge, CO. Well, that Friday it started snowing, and snowing, and snowing... the airport closed, Eisenhower tunnel closed, every restaurant and business in downtown Denver was closed. We spent three days in a downtown hotel ordering room service and watching cable TV. But we still had a great time ! ;) __ Bobby D. Worley UniVerse Application Development Mouser Electronics, Inc. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Stephen O'Neal Sent: Thursday, March 26, 2009 1:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Denver IBM U2 Office Closed due to Blizzard Enough said. It's got to be bad if the office closes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] list files
It took me a moment, but I love the RTFM acronym. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, April 09, 2007 1:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] list files It word wrapped. The last part of that url is univ_101.html BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, April 09, 2007 10:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] list files Anita, RTFM http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.ht ml BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, April 09, 2007 9:50 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] list files I do this at the OS level... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anita Panda Sent: Monday, April 09, 2007 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] list files Hi, I have connected on to a remote Universe instance.I want to see all the files and tables in that instance .What is the command to see all the main programs ,subroutines and tables. Thanks, Anita =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FILE EXPORT
ON Universe / PI flavor, STOP message here works as well (no M required). __ Bobby D. Worley UV Application Development Mouser Electronics, Inc. 817-804-3871 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Friday, March 30, 2007 8:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] FILE EXPORT STOPM simply allows a text message to be added. STOPM File not opened! Under the pick flavor of Universe that I am currently on that is the only way for the compiler to allow text. Under the ideal flavor I was able to add a text message to the STOP command. The M does not force an input response from the user. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] spam using u2
Can we please stop responding to the spam, thus creating more spam?
RE: [U2] Integration of UniVerse with Microsoft Team System 2005 {Unclassified}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Wednesday, January 17, 2007 3:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team System
2005 {Unclassified}
Kevin
Absolutely agreed: dictionaries have a strange place in the MV world
since
they can be user defined for a useful report, but changes might screw up
a
selection required for a program. Which, as we all know, can be bad bad
BAD.
My approach has been to make everything 'source'. Rather than create
dictionaries directly (urgh) I create a simple script to define one or
more
files - a bit like CREATE TABLE but just for regular files. An example
might
look like this:
BEGIN TABLE BOOK_TITLES
SUBJECT Audio Book Titles
FIELD TITLE_ID FNO 0 NUMERIC
FIELD SHORT_TITLE FNO 1 LEN 30
FIELD UTITLE FNO 1 LEN 30 CONV MCU
(etc)
FIELD PRICE FNO 6 MONEY
ENDDEFN
BEGIN TABLE BOOK_SALES
...
FIELD TITLE_ID FNO 10 NUMERIC MVED
FIELD QTY FNO 11 NUMERIC MVED DEPENDS TITLE_ID
...
FIELD LINE_TOTAL EXPR \QTY * PRICE\ MONEY MVED DEPENDS TITLE_ID
...
ENDDEFN
I then have a very simple program that parses this and builds the
dictionaries accordingly.
Why?
So that I can put the script into source control, and handle it just
like
any other source item, and easily rebuild the dictionaries by running
the
scripts again.
I can also version stamp the script along with the rest of my source
code.
I've recently written an article for Spectrum on version stamping
(should be
in this issue but I haven't got a copy yet!). Version stamping is one of
those critical client/server things - ensuring that the right version of
the
client is talking to the right version of the server.
There's no point getting the client side right in terms of version
management, and then forgetting the server.
Which leads on to a shameless plug ...
shameless advert
My mvInstaller program builds setups for deploying multivalue
applications.
One of my clients is using it to handle rollouts to 250 (that's right)
servers in a distributed system. It is based on the installer I wrote at
MMT
- that saved me more time than anything else in terms of QA as well as
deployment. It supports windows and server based installations, creates
files, installs data and programs, executes commands and runs
subroutines:
and amongst its many useful features the installations can be version
sensitive.
And the setup definitions are scripts, so they can be version managed.
If you're building windows setups for the client, don't forget the
server.
Read more on my website: www.[removethis]brianleach.co.uk
/shameless advert
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: 17 January 2007 02:42
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team
System 2005 {Unclassified}
Really, couldn't it be also argued that - along with what
Clif has mentioned - that ALL dictionaries - even phrases -
are code to be under control as well, not just I-descriptors.
If a dictionary changes, things could get ugly.
-Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Integration of UniVerse with Microsoft Team System 2005 {Unclassified}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Wednesday, January 17, 2007 3:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team System
2005 {Unclassified}
Kevin
Absolutely agreed: dictionaries have a strange place in the MV world
since
they can be user defined for a useful report, but changes might screw up
a
selection required for a program. Which, as we all know, can be bad bad
BAD.
My approach has been to make everything 'source'. Rather than create
dictionaries directly (urgh) I create a simple script to define one or
more
files - a bit like CREATE TABLE but just for regular files. An example
might
look like this:
BEGIN TABLE BOOK_TITLES
SUBJECT Audio Book Titles
FIELD TITLE_ID FNO 0 NUMERIC
FIELD SHORT_TITLE FNO 1 LEN 30
FIELD UTITLE FNO 1 LEN 30 CONV MCU
(etc)
FIELD PRICE FNO 6 MONEY
ENDDEFN
BEGIN TABLE BOOK_SALES
...
FIELD TITLE_ID FNO 10 NUMERIC MVED
FIELD QTY FNO 11 NUMERIC MVED DEPENDS TITLE_ID
...
FIELD LINE_TOTAL EXPR \QTY * PRICE\ MONEY MVED DEPENDS TITLE_ID
...
ENDDEFN
I then have a very simple program that parses this and builds the
dictionaries accordingly.
Why?
So that I can put the script into source control, and handle it just
like
any other source item, and easily rebuild the dictionaries by running
the
scripts again.
I can also version stamp the script along with the rest of my source
code.
I've recently written an article for Spectrum on version stamping
(should be
in this issue but I haven't got a copy yet!). Version stamping is one of
those critical client/server things - ensuring that the right version of
the
client is talking to the right version of the server.
There's no point getting the client side right in terms of version
management, and then forgetting the server.
Which leads on to a shameless plug ...
shameless advert
My mvInstaller program builds setups for deploying multivalue
applications.
One of my clients is using it to handle rollouts to 250 (that's right)
servers in a distributed system. It is based on the installer I wrote at
MMT
- that saved me more time than anything else in terms of QA as well as
deployment. It supports windows and server based installations, creates
files, installs data and programs, executes commands and runs
subroutines:
and amongst its many useful features the installations can be version
sensitive.
And the setup definitions are scripts, so they can be version managed.
If you're building windows setups for the client, don't forget the
server.
Read more on my website: www.[removethis]brianleach.co.uk
/shameless advert
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: 17 January 2007 02:42
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team
System 2005 {Unclassified}
Really, couldn't it be also argued that - along with what
Clif has mentioned - that ALL dictionaries - even phrases -
are code to be under control as well, not just I-descriptors.
If a dictionary changes, things could get ugly.
-Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Integration of UniVerse with Microsoft Team System 2005 {Unclassified}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Wednesday, January 17, 2007 3:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team System
2005 {Unclassified}
Kevin
Absolutely agreed: dictionaries have a strange place in the MV world
since
they can be user defined for a useful report, but changes might screw up
a
selection required for a program. Which, as we all know, can be bad bad
BAD.
My approach has been to make everything 'source'. Rather than create
dictionaries directly (urgh) I create a simple script to define one or
more
files - a bit like CREATE TABLE but just for regular files. An example
might
look like this:
BEGIN TABLE BOOK_TITLES
SUBJECT Audio Book Titles
FIELD TITLE_ID FNO 0 NUMERIC
FIELD SHORT_TITLE FNO 1 LEN 30
FIELD UTITLE FNO 1 LEN 30 CONV MCU
(etc)
FIELD PRICE FNO 6 MONEY
ENDDEFN
BEGIN TABLE BOOK_SALES
...
FIELD TITLE_ID FNO 10 NUMERIC MVED
FIELD QTY FNO 11 NUMERIC MVED DEPENDS TITLE_ID
...
FIELD LINE_TOTAL EXPR \QTY * PRICE\ MONEY MVED DEPENDS TITLE_ID
...
ENDDEFN
I then have a very simple program that parses this and builds the
dictionaries accordingly.
Why?
So that I can put the script into source control, and handle it just
like
any other source item, and easily rebuild the dictionaries by running
the
scripts again.
I can also version stamp the script along with the rest of my source
code.
I've recently written an article for Spectrum on version stamping
(should be
in this issue but I haven't got a copy yet!). Version stamping is one of
those critical client/server things - ensuring that the right version of
the
client is talking to the right version of the server.
There's no point getting the client side right in terms of version
management, and then forgetting the server.
Which leads on to a shameless plug ...
shameless advert
My mvInstaller program builds setups for deploying multivalue
applications.
One of my clients is using it to handle rollouts to 250 (that's right)
servers in a distributed system. It is based on the installer I wrote at
MMT
- that saved me more time than anything else in terms of QA as well as
deployment. It supports windows and server based installations, creates
files, installs data and programs, executes commands and runs
subroutines:
and amongst its many useful features the installations can be version
sensitive.
And the setup definitions are scripts, so they can be version managed.
If you're building windows setups for the client, don't forget the
server.
Read more on my website: www.[removethis]brianleach.co.uk
/shameless advert
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: 17 January 2007 02:42
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team
System 2005 {Unclassified}
Really, couldn't it be also argued that - along with what
Clif has mentioned - that ALL dictionaries - even phrases -
are code to be under control as well, not just I-descriptors.
If a dictionary changes, things could get ugly.
-Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Integration of UniVerse with Microsoft Team System [not-secure] 2005 {Unclassified}
Sorry - my mouse was possessed and started clicking reply/send
uncontrollably.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Wyatt
Sent: Thursday, January 18, 2007 1:44 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team System
[not-secure] 2005 {Unclassified}
You are not alone...
Regards,
Bob Wyatt
Ashwood Computer, Inc.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark
F.
Sent: Thursday, January 18, 2007 14:00
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Integration of UniVerse with Microsoft Team System
[not-secure] 2005 {Unclassified}
Am I the only one who has received this message three times?
-Original Message-
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
