Re: [U2] U2UG Professional Development Program
As part of the Board's deliberations on ensuring that the user group continues to be relevant to the needs of its members, the user group is implementing a professional development program from the 1st of May 2012. Individuals who maintain professional development in other technologies such as Microsoft and IBM are recognised for their efforts. Their professional development in those technologies adds value to their resume and benefits their career development. The user group wants to create the same advantage for U2 Developers, to have the same recognition and benefits for building U2 skills as their peers do in other disciplines. Please read the full announcement and joint letter from David Jordan and Susie Siegesmund on the U2UG Website. http://www.u2ug.net/download/LetterFromU2UGPresident.pdf Regards David Jordan President of the U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
ICONV works, too! ICONV( 120425, DYMD[2'',2''] ) -- 16187 OCONV( 16187, DYMD[2'',2''] ) -- 120425 If you ICONV an invalid date, e.g. April 34th: ICONV( 120434, DYMD[2'',2''] ) -- and STATUS()=1 I believe mathemeticians would call those inverse transformations. I was going to say reflexive but that would mean the very same transformation applied 2x gets back to the original place. cds On 4/24/2012 6:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Yes. Many people don't know you can stack conversion codes, separated by value marks (like in Pick dict 8 correlatives). But in this instance the DYMD[2'',2'',2] conversion discussed elsewhere in the thread has the advantage of being able to be used in ICONV, too, to get from YYMMDD to an internal date: ICONV( 120425, DYMD[2'',2''] ) -- 16187 On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Professional Development Program
In relation to your letter's mentioning the use of wikis. Can I just put out there, that there are millions of people who are at least somewhere familiar with editing in MediaWiki (which is the software Wikipedia uses). I would suggest that software as the basis. While other Wiki software might be as good, it introduces a brand-new learning curve and so would discourage participation. -Original Message- From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 5:02 am Subject: Re: [U2] U2UG Professional Development Program As part of the Board's deliberations on ensuring that the user group continues to be relevant to the needs of its members, the user group is implementing a professional development program from the 1st of May 2012. Individuals who maintain professional development in other technologies such as Microsoft and IBM are recognised for their efforts. Their professional development in those technologies adds value to their resume and benefits their career development. The user group wants to create the same advantage for U2 Developers, to have the same recognition and benefits for building U2 skills as their peers do in other disciplines. Please read the full announcement and joint letter from David Jordan and Susie Siegesmund on the U2UG Website. http://www.u2ug.net/download/LetterFromU2UGPresident.pdf Regards David Jordan President of the U2UG ___ 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] YYMMDD easy way?
I find this however to be a rather unfamiliar area. I like the idea of using the CONVERT because I have confidence that at least one other person in my group would understand what that meant. This use of formatting to limit the size of output in this way ( below) is pretty obscure. -Original Message- From: Charles Stevenson stevenson.c...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 5:42 am Subject: Re: [U2] YYMMDD easy way? Yes. Many people don't know you can stack conversion codes, separated by value marks (like in Pick dict 8 correlatives). But in this instance the DYMD[2'',2'',2] conversion discussed elsewhere in the thread has the advantage of being able to be used in ICONV, too, to get from YYMMDD to an internal date: ICONV( 120425, DYMD[2'',2''] ) -- 16187 On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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] YYMMDD easy way?
OBTW, on UniVerse both concatenations: D2YMD:@VM:MCN are done at compile-time because all elements are constant strings. (@VM isn't really a variable, more like an EQUate.) So if you stick Martin's construct inside a loop, there no added burden. On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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] YYMMDD easy way?
RHEL5 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, April 25, 2012 8:30 AM To: U2 Users List Subject: Re: [U2] YYMMDD easy way? me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2's. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD['' , '']) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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 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
[U2] Huge Dynamic Unidata file
I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
Hi, That will work, I have done that many times. Just make sure you check the permissions at unix level after the copy. Dave I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ 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] YYMMDD easy way?
Hi Chuck, I've never seen this to fail on any implementation or flavor: OCONV(TODAY,'DY2')'R%2': OCONV(TODAY,'DM')'R%2': OCONV(TODAY,'DD')'R%2' If anyone has, please let me know and I'll rethink. The code assumes (yeah, I know) that TODAY is in ICONV form. I've always used D2Y (I don't remember why) but it's interesting to note that DY2 works as well. Charlie On 04-25-2012 9:30 AM, Charles Stevenson wrote: me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
We've recently added a new UniData tuneable to udtconfig UDT_SPLIT_POLICY which can help conserve space when an overflowed dynamic file splits. The total size of the contents are not necessarily the same as the physical file size. Always worth checking with guide and the latest fixes and changes for this change if you have a stake here as the new split policy needs to be positively chosen. Regards JayJay On 25 Apr 2012, at 15:39, Dave Henderson dave_hender...@dsl.pipex.com wrote: Hi, That will work, I have done that many times. Just make sure you check the permissions at unix level after the copy. Dave I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ 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] YYMMDD easy way?
Even the best code for converting an internal date to an external one is a tad complicated. I would take all reasonable steps to avoid doing it an extra two times per date. -Rick On Apr 25, 2012, at 7:43 AM, Charlie Noah cwn...@comcast.net wrote: Hi Chuck, I've never seen this to fail on any implementation or flavor: OCONV(TODAY,'DY2')'R%2': OCONV(TODAY,'DM')'R%2': OCONV(TODAY,'DD')'R%2' If anyone has, please let me know and I'll rethink. The code assumes (yeah, I know) that TODAY is in ICONV form. I've always used D2Y (I don't remember why) but it's interesting to note that DY2 works as well. Charlie On 04-25-2012 9:30 AM, Charles Stevenson wrote: me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Major enhancements in our XLr8Resizer for version 3.4.9 [ad]
We at U2logic are proud to announce one of the more significant updates of our XLr8Resizer product. You can save of your statistics history which allows you to access prior runs through an Eclipse based wizard. The filter option shows only the files you would like to see. The progress bar shows you how many of process are left from what you selected. Our May project plan is sporting many other enhancements, we can hardly wait to try them out ourselves. Here is the full Change Log information for that product and our others. v3.4.9 - April 25, 2012 Removed Heading and appearance options for XLr8Object Editor Added option for Bing translate key in XLr8Object Editor Removed Heading and toolbar options from XLr8Installer Removed Heading and appearance options from XLr8Developer Removed Heading and appearance options from XLr8Resizer Added Alt+N to call the New Wizard for XLr8Object Editor Added Alt+A to add new items to XLr8Installer Bugzilla [Bug 473] XLr8Resizer is not handling 38GB files calculation Bugzilla [Bug 434] XLr8Resizer maintains history and allows access to prior runs Bugzilla [Bug 474] XLr8Resizer refresh option is not working as expected v3.4.8 - April 17, 2012 Bugzilla [Bug 431] - Unlinking elements when under source control does not delete local files Bugzilla [Bug 462] - XLr8Resizer needs to use the account filter Bugzilla [Bug 463] - XLr8Resizer needs to show a count on the progress bar Bugzilla [Bug 450] - XLr8Resizer needs to be able to export the resize or memresize commands Removed Sync DB to local function from the XLr8Installer Removed Heading and appearance option for the XLr8Dictionary Editor Regards, Doug www.u2logic.com/tools.html XLr8Resizer still only $99.00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
Also be sure that anyone that could have access to that file logs out/in before re-accessing the new file. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Henderson Sent: Wednesday, April 25, 2012 10:40 AM To: Jonathan Leckie; U2 Users List Cc: u2-users@listserver.u2ug.org Subject: Re: [U2] Huge Dynamic Unidata file Hi, That will work, I have done that many times. Just make sure you check the permissions at unix level after the copy. Dave I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ 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] YYMMDD easy way?
Actually the below is a trifle odd What this seems to be saying is, the M returns 4 or perhaps 4 (space 4) by itself, since the '' evidently removes spaces or something But the M with a 2'' returns a ZERO 4 (04) From where the heck does the zero come? I could see it as logical is the M returned a 04 normally but it seems to not. Unless of course the '' means also supress leading zeroes On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Mine is on HP-UX B.11.31. Richard On Wed, Apr 25, 2012 at 8:07 AM, Rick Nuckolls r...@lynden.com wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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] BDT what's the big deal?
Another bug-or-oddity in the BDT Editor. Some wily programmer before me, decided it was jim dandy to use certain reserved words as variables. The compiled has no problem with it, but the BDT Editor is barfing when it sees something like FOR LOOP = 1 TO 10 and also when it sees GOTO NEXT NEXT: do something here It thinks I suppose that LOOP and NEXT shouldn't be used in these ways, and probably they shouldn't. But they can. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT what's the big deal?
It doesn't like this syntax EXECUTE CMD, SELECT. L.UM DONE = FALSE ; CNT = 0 ; THE.FILE = '' EXECUTE CMD, SELECT. L.UM DONE = FALSE ; CNT = 0 ; THE.FILE = '' '' CRT SPACE(7):RECORDS PROCESSED: LOOP CRT SPACE(7):RECORDS PROCESSED: LOOP LOOP READNEXT K.UM FROM L.UM ELSE DONE = TRUE READNEXT K.UM FROM L.UM ELSE DONE = TRUE It claims that I don't need the comma after CMD But if I remove it, it then complains that CMD is an unexpected token It also complains that I never set the value of L.UM (on the readnext line) which of course I did It seems like it doesn't understand this perfectly good syntax which the compiler happily makes work as I intended. By the way, the point of selecting out to a list and then readnexting from that list, for those who are virgins, is that two selects in one program, are almost always prevented from stepping on each other's toes. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT what's the big deal?
The reason for both of those errors is BDT is not using the real compiler for error checking. Those Rocket software engineers used ANTLR parse generator to go through the UniBasic code. In my opinion a fatal flaw. Regards, Doug www.u2logic.com Makers of XLr8Editor the BDT competitor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ 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] Huge Dynamic Unidata file
On 25/04/12 15:46, John Jenkins wrote: We've recently added a new UniData tuneable to udtconfig UDT_SPLIT_POLICY which can help conserve space when an overflowed dynamic file splits. The total size of the contents are not necessarily the same as the physical file size. Always worth checking with guide and the latest fixes and changes for this change if you have a stake here as the new split policy needs to be positively chosen. Regards JayJay Dunno Unidata, but if you're copying to a dynamic file, would it make sense to use MINIMUM_MODULUS on the new file? JayJay, you'd know far more than me about this, but in UniVerse, it makes sense to use it if your file is not going to shrink and you're creating it specifically to populate it with a large amount of pre-existing data. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Huge Dynamic Unidata file
Yes, absolutely - I'm a great believer in a minimum modulo. If I have to copy large files from one to another my preferred method is to drive a load of PHANTOMs with save-lists in parallel. Also useful to drive from a SELECT not a SSELECT so you get a file-sequential order by chunking the input list as well so each PHANTOM gets a file-sequential ordered set of input data to process. Large disk caches can futz this idea a little, but it still holds true in general terms. I think someone else mentioned this as well recently. Regards JayJay On 25 Apr 2012, at 21:28, Wols Lists antli...@youngman.org.uk wrote: On 25/04/12 15:46, John Jenkins wrote: We've recently added a new UniData tuneable to udtconfig UDT_SPLIT_POLICY which can help conserve space when an overflowed dynamic file splits. The total size of the contents are not necessarily the same as the physical file size. Always worth checking with guide and the latest fixes and changes for this change if you have a stake here as the new split policy needs to be positively chosen. Regards JayJay Dunno Unidata, but if you're copying to a dynamic file, would it make sense to use MINIMUM_MODULUS on the new file? JayJay, you'd know far more than me about this, but in UniVerse, it makes sense to use it if your file is not going to shrink and you're creating it specifically to populate it with a large amount of pre-existing data. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Coding style with lists (was BDT...)
Please forgive a digression on coding style. From: Wjhonson By the way, the point of selecting out to a list and then readnexting from that list, for those who are virgins, is that two selects in one program, are almost always prevented from stepping on each other's toes. Are you talking about SELECT FV1 TO LISTX followed by SELECT FV2 TO LISTX? That's the reason for the CLEARSELECT statement. Re-using a variable is perfectly reasonable for many reasons. Re-using a variable because you're not sure if its state is awkward. The word almost above is either an error or feigned insight. In either case, I don't like anything in code almost working. Some code is structured such that the management of the flow is explicitly controlled. Some code is written to cover for situations where it is not aware of the current state, so it attempts to compensate. I prefer the former to the latter. If you're not sure of the state of processing at some point in the code then you can only guess what's happening, and you could miss options. State management is a development technique that precludes many kinds of errors, and unusual or unnecessary workarounds. There are times when you legitimately may not know exactly what the code is doing, where the code is not aware of its execution state, but this should not be by design. For the above situation, you're either actively reading through a list, or you've made a logical choice to stop using that list. When that choice is made, clear the variable if you intend to re-use it - even if not. This way you're not re-using the same variable just in case it was already in some prior state, and if your code does happen to fall into a different path of logic, maybe from a later mod, the list won't accidentally be active with IDs from another selection. If that doesn't fit your code logic, use a state variable that identifies the selection currently active, and reset that variable when the list is exhausted or when you have chosen to stop using it. Check the variable before using the list to ensure it's in the proper state. This is the kind of thing that separates amateurs from pros - sorry if it offends anyone, but it is what it is, and I prefer posting something like this to the technique that was offered. Being a non-virgin doesn't mean you know how to, uh, do it. ;) T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
We are looking at options for larger files in UniData as there are some BIG data sets out there. The options that are being looked at include (and in no particular order): 1. 64 bit files - over 2Gb 2. Distributed files (like UniVerse) 3. More dat/over/idx files - going from datnnn to dat Each has pros and cons, and if there are other options let's hear them! If you have a need and a preference then please speak up. Regards JayJay On 25 Apr 2012, at 21:29, Baakkonen, Rodney A (Rod) 46K rodney.baakko...@cigna.com wrote: I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Job: Hampshire College
We have an opening and someone with good U2 skills could certainly be an asset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you in industry, we offer a competitive salary for this market and great benefits (4 weeks paid vacation from day 1, among others). https://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 Hampshire College, an independent, innovative liberal arts institution and member of the Five College consortium in Amherst Massachusetts, is accepting applications for a Database Systems Developer in its Information Technology Department. The Database Systems Developer is the lead developer and administrator providing a variety of technical and user support for the college’s Colleague administrative computing system; develops programs to augment vendor-supplied software; and enhance web-based services. This position analyzes, develops, implements and documents custom administrative software enhancements, and supports end-users by creating ad-hoc reports and providing application training. The developer creates new applications, determines user needs, and implements efficient solutions to end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in information systems and software design or equivalent training and experience. Application programming and analysis experience in the design, development and implementation of administrative application functions such as Finance, Human Resources, Student and Academic records and Development or equivalent systems highly desirable. Five years of experience with at least one relational database, using a query language and with several programming languages, especially BASIC, is also required. Previous experience with Colleague highly desirable. Prior web programming experience, knowledge of Java, PERL, Python or PHP, and experience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a competitive salary and excellent benefits program. Please submit your cover letter, resume and names/phone numbers of three professional references via our website at http://jobs.hampshire.edu -- Jeff Butera Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statement with only two cases... or for that matter... one case
Hi Will, As I said, I don't use it myself, but a reason one might use it is that one can easily cut and paste (or include) logic. For example: --- LOCKED put some generic logic here END --- regards, Keith WJohnson wrote: Why the extra lines? Why not just IF A = TEST THEN gosub do.something END ELSE gosub do.something.else END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- eff Butera ampshire College but...@hampshire.edu 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
Well, it is pretty impressive that Jeff (aka Dr. Butera) actually knows that his ERP system is running on U2/MultiValue/PICK while many Datatel administrators think of themselves as Datatel developers or Colleague developers or Envision programmers or, at a stretch, possibly even UniData developers. I doubt that (m)any Datatel developers would search for a new position using U2 in spite of some efforts to make that term more visible. There are a ton of Datatel positions out there and you do not see many come through here, so I would not shoot the messenger on this one, K? smiles --dawn P.S. Jeff, sadly I do not qualify for the position as I do not have a degree in Computer Science (there was no such degree at my college back when I attended), although I have taught the subject. cheers! On Wed, Apr 25, 2012 at 4:23 PM, Wjhonson wjhon...@aol.com wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- eff Butera ampshire College but...@hampshire.edu 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
If a job seeker is looking for Unidata, which is a rare to unique term, they will never see this job. Yet that is the very skill for which the organization is looking. That Jeff knows it, is not material, if no one else can even find the job. -Original Message- From: Dawn Wolthuis dw...@tincat-group.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:31 pm Subject: Re: [U2] Job: Hampshire College Well, it is pretty impressive that Jeff (aka Dr. Butera) actually knows hat his ERP system is running on U2/MultiValue/PICK while many Datatel dministrators think of themselves as Datatel developers or Colleague evelopers or Envision programmers or, at a stretch, possibly even niData developers. I doubt that (m)any Datatel developers would search for new position using U2 in spite of some efforts to make that term more isible. There are a ton of Datatel positions out there and you do not see many come hrough here, so I would not shoot the messenger on this one, K? smiles --dawn .S. Jeff, sadly I do not qualify for the position as I do not have a egree in Computer Science (there was no such degree at my college back hen I attended), although I have taught the subject. cheers! On Wed, Apr 25, 2012 at 4:23 PM, Wjhonson wjhon...@aol.com wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- eff Butera ampshire College but...@hampshire.edu 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- awn M. Wolthuis Take and give some delight today __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
We have an opening and someone with good U2 skills could certainly be an asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
To this list. Then the job description ITSELF does not mention Unidata whatsoever. To me that says that posting this job anywhere other than this list, for example Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to make an offhand remark and THEN post the specific job description. The specific job description itself, without Jeff's offhand starting remark does NOT mention Unidata. It's practically blasphemy. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:33 pm Subject: Re: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be n asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- --- eff Schasny - Denver, Co, USA schasny at gmail dot com --- __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
I was going to write a polite well structured response pointing out that Colleague is a special skill set above and beyond U2 but you know what, for my own personal satisfaction and that of the whole group, Shut the fuck up Will. Wjhonson wrote: To this list. Then the job description ITSELF does not mention Unidata whatsoever. To me that says that posting this job anywhere other than this list, for example Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to make an offhand remark and THEN post the specific job description. The specific job description itself, without Jeff's offhand starting remark does NOT mention Unidata. It's practically blasphemy. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:33 pm Subject: Re: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be n asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ASCII ^010^013 Removal (LF CR)
Hey Guys, Any suggestions how I can use CONVERT to strip ASCII control characters DEC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ASCII ^010^013 Removal (LF CR)
Doesn't CONVERT CHAR(10):CHAR(13) TO IN X.ID work? -Original Message- From: Greg Coelho coe...@american.edu To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 3:30 pm Subject: Re: [U2] ASCII ^010^013 Removal (LF CR) Hey Guys, Any suggestions how I can use CONVERT to strip ASCII control characters EC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID Thanks! Greg __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] Coding style with lists (was BDT...)
For some reason the cut and paste from BDT to this list, duplicated every single line. Which is unfortunate. It didn't look that way when I SENT it to the list, only when I received it back again. So just ignore every other line in the code segment -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 3:38 pm Subject: [U2] Coding style with lists (was BDT...) Please forgive a digression on coding style. From: Wjhonson By the way, the point of selecting out to a list and then eadnexting from that list, for those who are virgins, is that two selects in ne program, are almost always prevented from stepping on each other's toes. Are you talking about SELECT FV1 TO LISTX followed by SELECT FV2 TO ISTX? hat's the reason for the CLEARSELECT statement. Re-using a variable is perfectly reasonable for many reasons. Re-using variable because you're not sure if its state is awkward. The word almost above is either an error or feigned insight. In ither case, I don't like anything in code almost working. Some code is structured such that the management of the flow is xplicitly controlled. Some code is written to cover for situations here it is not aware of the current state, so it attempts to ompensate. I prefer the former to the latter. If you're not sure of the state f processing at some point in the code then you can only guess what's appening, and you could miss options. State management is a evelopment technique that precludes many kinds of errors, and unusual r unnecessary workarounds. There are times when you legitimately may ot know exactly what the code is doing, where the code is not aware f its execution state, but this should not be by design. For the above situation, you're either actively reading through a ist, or you've made a logical choice to stop using that list. When hat choice is made, clear the variable if you intend to re-use it - ven if not. This way you're not re-using the same variable just in ase it was already in some prior state, and if your code does happen o fall into a different path of logic, maybe from a later mod, the ist won't accidentally be active with IDs from another selection. If hat doesn't fit your code logic, use a state variable that identifies he selection currently active, and reset that variable when the list s exhausted or when you have chosen to stop using it. Check the ariable before using the list to ensure it's in the proper state. This is the kind of thing that separates amateurs from pros - sorry if t offends anyone, but it is what it is, and I prefer posting omething like this to the technique that was offered. Being a non-virgin doesn't mean you know how to, uh, do it. ;) T ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
On 04/25/2012 05:23 PM, Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? I'm more interested in someone who knows academia and Datatel. But yes, if someone here spies the list I assume they know various things. -Original Message- From: Jeffrey Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
On 04/25/2012 05:30 PM, Dawn Wolthuis wrote: P.S. Jeff, sadly I do not qualify for the position as I do not have a degree in Computer Science (there was no such degree at my college back when I attended), although I have taught the subject. cheers! Note the reference to or equivalent experience/training. We'd hire you Dawn! But it's a long commute from Iowa. -Original Message- From: Jeffrey Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- eff Butera ampshire College but...@hampshire.edu 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
So you're interested in someone who knows Datatel, and yet your ad does not mention Datatel. And that doesn't seem peculiar at all? Doesn't strike you that perhaps the ad itself is faulty in some way? That googling for datatel job unidata would not find this posting at all? That perhaps a dozen job seekers with exquisite datatel credentials would not apply simply because they can't find your ad? Doesn't it seem likely that 80% of Unidata programmers don't read this list whatsoever ? And they will only find the job if you specify Unidata or Datatel in the actual description? And yes I did look on your website, and it also does not specify Unidata, nor does it specify Datatel. And no one googles for colleague. So essentially you eliminate every qualified person, since they can't even find your job. -Original Message- From: Jeff Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 3:48 pm Subject: Re: [U2] Job: Hampshire College On 04/25/2012 05:23 PM, Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? I'm more interested in someone who knows academia and Datatel. But yes, f someone here spies the list I assume they know various things. -Original Message- From: Jeffrey Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu - eff Butera, PhD anager of ERP Systems ampshire College 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
LOL. Thanks for the vote of confidence, Jeff. Back atcha. smiles. --dawn On Wed, Apr 25, 2012 at 5:51 PM, Jeff Butera jbut...@hampshire.edu wrote: On 04/25/2012 05:30 PM, Dawn Wolthuis wrote: P.S. Jeff, sadly I do not qualify for the position as I do not have a degree in Computer Science (there was no such degree at my college back when I attended), although I have taught the subject. cheers! Note the reference to or equivalent experience/training. We'd hire you Dawn! But it's a long commute from Iowa. -Original Message- From: Jeffrey Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.**orgu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/**index.cgi?JA_m=JASDETJA_s=164http://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- eff Butera ampshire College but...@hampshire.edu 13-559-5556 __**_ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
On 04/25/2012 05:37 PM, Wjhonson wrote: To this list. Then the job description ITSELF does not mention Unidata whatsoever. To me that says that posting this job anywhere other than this list, for example Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to make an offhand remark and THEN post the specific job description. I'm going to pour some gas on the fire for Wil and say many of you on this list don't know crap about academia. Then again, I don't know much about working in the corporate side - but I don't try to tell you what to do. We NEVER advertise on Dice, Monster or other national sites - the quality of applicants from those sites is a horrible mismatch for us in academia. We have very targeted advertising for our positions, most of which are college-centric (higeredjobs.com, chronicle.com, etc). I chose to post it here as a courtesy for some who may have the U2 skillset and looking for work, even though they may not be familiar with a college environment. Yes, Wil, perhaps I would do better to put Unidata directly in the job description if I were seeking to pull in a super-qualified U2 programmer. Then again, perhaps I know more about the position and/or our 5 and 10 year plans that may have us out of the Unidata world (for various non-technical reasons - most here know I'm an ardent U2 supporter). Perhaps I know that Datatel (err, Ellucian's) toolkit is so damn proprietary that knowing U2 is only a small piece of he puzzle. The job doesn't mention Datatel because Datatel no longer exists and I just restructured so there's no split between Datatel and other non-ERP programming in this job. Likewise, see my 5- and 10- year comment above - we may not be with Datatel for long. Let's say that contrary to Wil's opinion, I actually know what I'm doing - the job description was carefully crafted with certain words left out on purpose. -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
Right so you get applicants who don't have a clue about the core software you are using. That's brilliant! -Original Message- From: Jeff Butera jbut...@hampshire.edu To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 4:06 pm Subject: Re: [U2] Job: Hampshire College On 04/25/2012 05:37 PM, Wjhonson wrote: To this list. Then the job description ITSELF does not mention Unidata hatsoever. To me that says that posting this job anywhere other than this list, for xample Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to ake an offhand remark and THEN post the specific job description. I'm going to pour some gas on the fire for Wil and say many of you on his list don't know crap about academia. Then again, I don't know much bout working in the corporate side - but I don't try to tell you what o do. We NEVER advertise on Dice, Monster or other national sites - he quality of applicants from those sites is a horrible mismatch for us n academia. We have very targeted advertising for our positions, most of which are ollege-centric (higeredjobs.com, chronicle.com, etc). I chose to post t here as a courtesy for some who may have the U2 skillset and looking or work, even though they may not be familiar with a college environment. Yes, Wil, perhaps I would do better to put Unidata directly in the job escription if I were seeking to pull in a super-qualified U2 rogrammer. Then again, perhaps I know more about the position and/or ur 5 and 10 year plans that may have us out of the Unidata world (for arious non-technical reasons - most here know I'm an ardent U2 upporter). Perhaps I know that Datatel (err, Ellucian's) toolkit is so amn proprietary that knowing U2 is only a small piece of he puzzle. The job doesn't mention Datatel because Datatel no longer exists and I ust restructured so there's no split between Datatel and other non-ERP rogramming in this job. Likewise, see my 5- and 10- year comment bove - we may not be with Datatel for long. Let's say that contrary to Wil's opinion, I actually know what I'm doing the job description was carefully crafted with certain words left out n purpose. - eff Butera, PhD anager of ERP Systems ampshire College 13-559-5556 ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
No.. one... searches... for... colleague. What part of English don't you get? No one is going to find a job by searching for the word colleague -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 4:20 pm Subject: Re: [U2] Job: Hampshire College I was going to write a polite well structured response pointing out that olleague is a special skill set above and beyond U2 but you know what, or my own personal satisfaction and that of the whole group, Shut the uck up Will. Wjhonson wrote: To this list. Then the job description ITSELF does not mention Unidata hatsoever. To me that says that posting this job anywhere other than this list, for xample Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to ake an offhand remark and THEN post the specific job description. The specific job description itself, without Jeff's offhand starting remark oes NOT mention Unidata. It's practically blasphemy. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:33 pm Subject: Re: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be n asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers yping n Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- --- eff Schasny - Denver, Co, USA schasny at gmail dot com --- __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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: Hampshire College
Wouldn't it make more sense if you were a RocketSoftware U2 support? Ardent is old news... From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera [jbut...@hampshire.edu] Sent: Wednesday, April 25, 2012 7:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Job: Hampshire College most here know I'm an ardent U2 supporter. Jeff Butera, PhD ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ASCII ^010^013 Removal (LF CR)
I don't recall about which platforms this applies, but CONVERT is used to change a single character. CHANGE or SWAP (depending on platform) changes multiple chars: CONVERT SINGLE1 TO SINGLE2 IN VAR VAR = CHANGE(VAR,MULTI1,MULTI2) VAR = SWAP(VAR,MULTI1,MULTI2) From: Wjhonson Doesn't CONVERT CHAR(10):CHAR(13) TO IN X.ID work? From: Greg Coelho Any suggestions how I can use CONVERT to strip ASCII control characters EC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: Manners
I agree wholeheartedly John H Carter III Impact Business Consulting Corporation Cell (760) 497-5545 Unlocking Your Potential -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 25, 2012 5:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Manners Someone posts a job posting in here and the job poster is belitted? Unbelievable. Since I didn't see anyone else say it, I will say it. Thank you Mr. Butera for posting your employment opportunity at Hamsphire College on our lists, I appreciate it. Regards, Don Verhagen ___ 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] OT: Manners
I might as well take the time here to agree. It's great that some on this list have jobs; but there are others of us who could use a job and would appreciate a job poster not be heckled! Bill - Original Message - *From:* jcar...@impactbuscon.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 4/25/2012 5:29 PM *Subject:* Re: [U2] OT: Manners I agree wholeheartedly John H Carter III Impact Business Consulting Corporation Cell (760) 497-5545 Unlocking Your Potential -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 25, 2012 5:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Manners Someone posts a job posting in here and the job poster is belitted? Unbelievable. Since I didn't see anyone else say it, I will say it. Thank you Mr. Butera for posting your employment opportunity at Hamsphire College on our lists, I appreciate it. Regards, Don Verhagen ___ 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] OT: Manners
Well said Don, couldn't agree with you more... Danny Ruckel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 25, 2012 5:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Manners Someone posts a job posting in here and the job poster is belitted? Unbelievable. Since I didn't see anyone else say it, I will say it. Thank you Mr. Butera for posting your employment opportunity at Hamsphire College on our lists, I appreciate it. Regards, Don Verhagen ___ 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: Hampshire College
Doesn't it seem likely that 80% of Unidata programmers don't read this list whatsoever ? That is too bad. Those 80% are truly missing out on a (mostly) supportive, collegial and welcoming U2 community resource. On 4/25/2012 6:55 PM, Wjhonson wrote: So you're interested in someone who knows Datatel, and yet your ad does not mention Datatel. And that doesn't seem peculiar at all? Doesn't strike you that perhaps the ad itself is faulty in some way? That googling for datatel job unidata would not find this posting at all? That perhaps a dozen job seekers with exquisite datatel credentials would not apply simply because they can't find your ad? Doesn't it seem likely that 80% of Unidata programmers don't read this list whatsoever ? And they will only find the job if you specify Unidata or Datatel in the actual description? And yes I did look on your website, and it also does not specify Unidata, nor does it specify Datatel. And no one googles for colleague. So essentially you eliminate every qualified person, since they can't even find your job. -Original Message- From: Jeff Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 3:48 pm Subject: Re: [U2] Job: Hampshire College On 04/25/2012 05:23 PM, Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? I'm more interested in someone who knows academia and Datatel. But yes, f someone here spies the list I assume they know various things. ___ 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] Most U2 personnel don't read this list was Hampshire job
It's true imho. A large percentage of U2 programmers don't read Spectrum, have never been to a pick users group, don't read this list, aren't a member of the U2UG, etc etc. Perhaps that's true in general for all programming environments. -Original Message- From: Matthew Strand mstr...@mtholyoke.edu To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 6:19 pm Subject: Re: [U2] Job: Hampshire College Doesn't it seem likely that 80% of Unidata programmers don't read this list whatsoever ? That is too bad. Those 80% are truly missing out on a (mostly) supportive, collegial and welcoming U2 community resource. On 4/25/2012 6:55 PM, Wjhonson wrote: So you're interested in someone who knows Datatel, and yet your ad does not mention Datatel. And that doesn't seem peculiar at all? Doesn't strike you that perhaps the ad itself is faulty in some way? That googling for datatel job unidata would not find this posting at all? That perhaps a dozen job seekers with exquisite datatel credentials would not apply simply because they can't find your ad? Doesn't it seem likely that 80% of Unidata programmers don't read this list whatsoever ? And they will only find the job if you specify Unidata or Datatel in the actual description? And yes I did look on your website, and it also does not specify Unidata, nor does it specify Datatel. And no one googles for colleague. So essentially you eliminate every qualified person, since they can't even find your job. -Original Message- From: Jeff Buterajbut...@hampshire.edu To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 3:48 pm Subject: Re: [U2] Job: Hampshire College On 04/25/2012 05:23 PM, Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? I'm more interested in someone who knows academia and Datatel. But yes, f someone here spies the list I assume they know various things. ___ 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] OT: Manners
In our constant debate of which peanut butter tastes more like fresh peanuts, it discouraging when people lose sight f the fact that it really is about the peanut butter, and not an overt attack on people who are allergic to nuts... On Wed, Apr 25, 2012 at 7:16 PM, Danny Ruckel dan...@southwesttraders.comwrote: Well said Don, couldn't agree with you more... Danny Ruckel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 25, 2012 5:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Manners Someone posts a job posting in here and the job poster is belitted? Unbelievable. Since I didn't see anyone else say it, I will say it. Thank you Mr. Butera for posting your employment opportunity at Hamsphire College on our lists, I appreciate it. Regards, Don Verhagen ___ 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