Re: [U2] So, what product is Dan McGrath managing @ Google?
I saw that too. I wish him the best. Big loss for Rocket. On Sun, May 4, 2014 at 5:31 PM, Ross Ferris ro...@stamina.com.au wrote: LinkedIn tells me Dan has moved on unless Google are making an MV play (think LaughIn Very Interesting! -- I'll forgo the but stupid, 'cause I'm sure it is not!) Ross Ferris Stamina Software Visage Better by Design! ___ 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] Dynamic Concepts Unibasic ... Is this Pick ?
As I recall the 'other Unidata' is at the NIST, so being The Government, is effectively legally untouchable. On Thu, Apr 24, 2014 at 6:35 PM, Charles Stevenson stevenson.c...@gmail.com wrote: there's another outfit called Unidata in Colorado, too. It's part of a university or an NGO thing, maybe unifying data across several NGOs. Maybe an arm of the Amalgamated Organization of Federated Associations. (hat tip to Garrison Keillor.) On 4/24/2014 9:41 PM, Tom Whitmore wrote: This appears to be unrelated to Rocket's UniBASIC. In fact, it appears to run at the OS level. It is odd that their documentation states UniBasic is a trademark of Dynamic Concepts Inc. Does Rocket have an infringement issue? Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@ listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 24, 2014 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dynamic Concepts Unibasic ... Is this Pick ? http://www.dynamic.com/software/unibasic/ This company confuses me. Is this the same UniBASIC ? They are based in Irvine but their website makes it seem like this UniBasic is theirs. No mention of Rocket. Or are their actually two completely unrelated companies, hawking products both called Uni Basic ? ___ 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] Business ?
F.W. Davison does PEO/HR software. On Fri, Mar 28, 2014 at 1:55 PM, jeffrey Butera jbut...@hampshire.eduwrote: Does anyone know much about FW Davidson http://www.fwdco.com? They came across my radar and I see references to Unidata along with SQL and Oracle. Just curious if anyone know precisely what solution(s) they run on Unidata... -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ 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] Unidata 7.2.6 Secure submitRequest Question
Anybody ever seen anything like this before: 1523926:error:0D0890A1:asn1 encoding routines:ASN1_verify:unknown message digest algorithm:a_verify.c:141: 1523926:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:844: This is displaying on a routine when it hits a submitRequest after the following routines have been successfully called: * createSecurityContext * setAuthenticationDepth * addCertificate * createSecureRequest * addRequestParameters Where should I start digging? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.6 Secure submitRequest Question
It appears the problem was a change in the URL and we were using an old spec. Back on track! On Mon, Mar 24, 2014 at 7:34 PM, Peter Cheney peter.che...@firstmac.com.auwrote: When you do the addCertificate do you get a zero as the return code? If the RC is non-zero then perhaps check: o is it the correct certificate? o correct usedAs parameter? o correct format (PEM/DER)? o the correct algorithm (RSA/DSA)? o is in the correct location? Also what is happening in your code with the security context (handle) that is returned? It should remain untouched for re-use down the chain of those remaining routines. Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, 25 March 2014 07:36 To: U2 Users List Subject: [U2] Unidata 7.2.6 Secure submitRequest Question Anybody ever seen anything like this before: 1523926:error:0D0890A1:asn1 encoding routines:ASN1_verify:unknown message digest algorithm:a_verify.c:141: 1523926:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:844: This is displaying on a routine when it hits a submitRequest after the following routines have been successfully called: * createSecurityContext * setAuthenticationDepth * addCertificate * createSecureRequest * addRequestParameters Where should I start digging? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Unreal. This old dog just learnt a new trick. On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian james.mcgo...@bankofthewest.com wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... The backtick is just the default 'command delimiter'. You can read more about it with: *--: help delimiter Command: CDelimiter (CD) 'CD' allows you to change the command delimiter to any single character. When you enter the editor for the first time the command delimiter is set to the ` (weirdmark, not single quote) character. Examples: *--: CD [displays the current command delimiter; no change] Command delimiter is ` *--: CD# [changes the command delimiter to '#'] Command delimiter is now # The Command Delimiter is a single character that separates multiple editor commands when they are entered at a single editor prompt. Valid command delimiters are: ` , ; # $ % ~ | [ ] { } / ' and then onto prestores Example: *--: G10`G20`G30 [go to line 10, then to 20, then to 30] A rather pointless command, but it illustrates the principle. Multipart commands are very useful as prestored commands. They allow processing many records with a single command. For example, suppose you had a select list of 100 records, and each of them needs every occurrence of '100' changed to '250'. You can do this with a multipart prestored command. First create the prestored command: =DOITALL CU/100/250`FI`=DOITALL Then run the command '=DOITALL' by entering '=DOITALL' as a command. The editor will then loop through the list of records, perform the change for each of them, file each of them, and then run =DOITALL again on the next record. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, February 05, 2014 4:33 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Unreal. This old dog just learnt a new trick. On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page -- -- - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create
Re: [U2] [OT] Interview Questions
Asking the list...I'd label that as resourceful. So yeah, that's a positive. On Mon, Dec 16, 2013 at 10:08 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Maybe it's a good thing you're not interviewing me, Kevin. My immediate answer would be I don't know. Let me check the documentation and get back to you. I've never had to do anything like that so it's not something I'd know off the top of my head. I'm sure there's probably and OCONV format that would get me started but. Oh! I know! I'd as this list! silly smile Does that count? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, December 14, 2013 8:15 AM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions David, I've used many of these questions in the past but where it fell down was that it didn't give any real picture of technical ability. The one question I've been using lately to assess technical thinking is how would you calculate the last Thursday in a month? The answers have been everywhere from accurate to sheer ridiculous. The unexpected takeaway from this question is that it has helped to identify people who simply want to answer quickly without thinking - not a good trait unless the answer is right and to date that's happened a total of zero times - vs people who think first and then give a reasoned response. I've just found it too easy for people to stretch the truth when explaining their technical ability, so I'm asking questions intended to give some evidence. On Saturday, December 14, 2013, David Sharp wrote: Here is something I have used: What single project or task would you consider the most significant accomplishment in your career so far? * Can you give me a detailed overview of the accomplishment? * Tell me about the company, your title, your position, your role, and the team involved. * What were the actual results achieved? * When did it take place and how long did the project take. * Why you were chosen? * What were the 3-4 biggest challenges you faced and how did you deal with them? * Where did you go the extra mile or take the initiative? * Walk me through the plan, how you managed to it, and if it was successful. * Describe the environment and resources. * Describe your manager's style and whether you liked it or not. * Describe the technical skills needed to accomplish the objective and how they were used. * Some of the biggest mistakes you made. * Aspects of the project you truly enjoyed. * Aspects you didn't especially care about and how you handled them. * How you managed and influenced other, with lots of examples. * How you changed and grew as a person. * What you would do differently if you could do it again. * What type of formal recognition did your receive? Regards, David Sharp Date: Fri, 13 Dec 2013 12:27:18 -0800 From: i...@keyway.net javascript:; To: u2-users@listserver.u2ug.org javascript:; Subject: Re: [U2] [OT] Interview Questions Please email me in regards to your ads. I am currently in between contracts/assignments/projects and looking for my next assignment. Multivalue languages I have been programming in: * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group
Re: [U2] [OT] Interview Questions
Except, Will, the question did not ask for current month. Rather it asked for a month. Similar, yes, but a different request. On Monday, December 16, 2013, Wjhonson wrote: What is the last Thursday of the current month. Current Date minus Current Day of Month number plus 1 puts you on the first of the current month Or you could just Oconv d2/ and replace the middle number with 01 with Iconv that. Now take that internal date and add 32, this will *always* put you exactly into the next month somewhere. Now oconv that date D2/ and replace the middle number with 01 which will always put on the first of next month Now if the DOW number is larger than Thursday subtract the difference If its less than Thursday subtract that number and an extra 2 to get to last Thursday -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com javascript:; To: U2 Users List u2-users@listserver.u2ug.org javascript:; Sent: Mon, Dec 16, 2013 2:55 pm Subject: Re: [U2] [OT] Interview Questions Build an API to Mechanical Turk. neededDate = Mech_Turk(In /mm/dd format, what is the last Thursday of :month: :year) Hmmm - I guess that's why I don't code anymore ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, December 16, 2013 3:22 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Asking the list...I'd label that as resourceful. So yeah, that's a positive. On Mon, Dec 16, 2013 at 10:08 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Maybe it's a good thing you're not interviewing me, Kevin. My immediate answer would be I don't know. Let me check the documentation and get back to you. I've never had to do anything like that so it's not something I'd know off the top of my head. I'm sure there's probably and OCONV format that would get me started but. Oh! I know! I'd as this list! silly smile Does that count? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, December 14, 2013 8:15 AM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions David, I've used many of these questions in the past but where it fell down was that it didn't give any real picture of technical ability. The one question I've been using lately to assess technical thinking is how would you calculate the last Thursday in a month? The answers have been everywhere from accurate to sheer ridiculous. The unexpected takeaway from this question is that it has helped to identify people who simply want to answer quickly without thinking - not a good trait unless the answer is right and to date that's happened a total of zero times - vs people who think first and then give a reasoned response. I've just found it too easy for people to stretch the truth when explaining their technical ability, so I'm asking questions intended to give some evidence. On Saturday, December 14, 2013, David Sharp wrote: Here is something I have used: What single project or task would you consider the most significant accomplishment in your career so far? * Can you give me a detailed overview of the accomplishment? * Tell me about the company, your title, your position, your role, and the team involved. * What were the actual results achieved? * When did it take place and how long did the project take. * Why you were chosen? * What were the 3-4 biggest challenges you faced and how did you deal with them? * Where did you go the extra mile or take the initiative? * Walk me through the plan, how you managed to it, and if it was successful. * Describe the environment and resources. * Describe your manager's style and whether you liked it or not. * Describe the technical skills needed to accomplish the objective and how they were used. * Some of the biggest mistakes you made. * Aspects of the ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Well now... this is getting interesting. Wol has a very valid point. Assumptions can be deadly. Hence why I called Will out on his. It's minor in the sense of this dialogue, but if when customers are putting up money for the end result assumptions and misunderstanding can be the difference between getting the gig or getting the boot. On Mon, Dec 16, 2013 at 7:13 PM, Bill Haskett wphask...@advantos.netwrote: Another option, which I always have done, is to iconv dates in 15 Jan 2013 format. This always works regardless of which date method is selected. Don't know why yanks do things that irritate you. But then, most people do things that irritate someone. As Mark Brown always points out; the trouble with standards is everybody has one. This seems more of an issue than what yanks do. :-) Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 12/16/2013 6:00 PM *Subject:* Re: [U2] [OT] Interview Questions On 17/12/2013 00:17, Wjhonson wrote: What is the last Thursday of the current month. Current Date minus Current Day of Month number plus 1 puts you on the first of the current month Or you could just Oconv d2/ and replace the middle number with 01 with Iconv that. Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY, D2) gives me 17/12/13. If I replace the middle number (or if Kevin replaced the middle number) we'd both end up somewhere in January! Why do you Yanks put the least significant number in the middle? That's crazy! If you want the first of the month, the easiest way to do it is FIRST = 01/:OCONV(@TODAY,D2[M,Y]) (if I've remembered my syntax correctly). Then to get that into internal format I_FIRST = ICONV(FIRST, D2DMY) You should NEVER assume that dates are in the format you expect, unless you are in control (which you aren't, here, seeing as you've messed up pretty spectacularly :-) 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
David, I've used many of these questions in the past but where it fell down was that it didn't give any real picture of technical ability. The one question I've been using lately to assess technical thinking is how would you calculate the last Thursday in a month? The answers have been everywhere from accurate to sheer ridiculous. The unexpected takeaway from this question is that it has helped to identify people who simply want to answer quickly without thinking - not a good trait unless the answer is right and to date that's happened a total of zero times - vs people who think first and then give a reasoned response. I've just found it too easy for people to stretch the truth when explaining their technical ability, so I'm asking questions intended to give some evidence. On Saturday, December 14, 2013, David Sharp wrote: Here is something I have used: What single project or task would you consider the most significant accomplishment in your career so far? · Can you give me a detailed overview of the accomplishment? · Tell me about the company, your title, your position, your role, and the team involved. · What were the actual results achieved? · When did it take place and how long did the project take. · Why you were chosen? · What were the 3-4 biggest challenges you faced and how did you deal with them? · Where did you go the extra mile or take the initiative? · Walk me through the plan, how you managed to it, and if it was successful. · Describe the environment and resources. · Describe your manager’s style and whether you liked it or not. · Describe the technical skills needed to accomplish the objective and how they were used. · Some of the biggest mistakes you made. · Aspects of the project you truly enjoyed. · Aspects you didn’t especially care about and how you handled them. · How you managed and influenced other, with lots of examples. · How you changed and grew as a person. · What you would do differently if you could do it again. · What type of formal recognition did your receive? Regards, David Sharp Date: Fri, 13 Dec 2013 12:27:18 -0800 From: i...@keyway.net javascript:; To: u2-users@listserver.u2ug.org javascript:; Subject: Re: [U2] [OT] Interview Questions Please email me in regards to your ads. I am currently in between contracts/assignments/projects and looking for my next assignment. Multivalue languages I have been programming in: * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic
Re: [U2] [OT] Interview Questions
) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; 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] [OT] Interview Questions
The most challenging date math we've faced recently (a real project) is the ISO 8601 week calculation. Extremely easy to introduce an off-by-one error! On Sat, Dec 14, 2013 at 11:13 AM, Wols Lists antli...@youngman.org.ukwrote: On 14/12/13 16:48, Dan Fitzgerald wrote: Kevin: I'd take the month (verifying; gigo), then run it through a case statement to determine the number of days in that month (sounds like a handy subroutine to have in the toolbox). Then I'd convert to get the day of the week, another case statement to get the number of days past Thursday, do the math from the last DOM internal date, oconv the result, and grab a cup of dark roast. There are probably more efficient ways, but that's how I'd work it through my head in an interview. This is pretty much the same problem as current week of the year :-) Can't remember off the top of my head, but it's *extremely* easy to make an off by one error - I remember someone copying my Pickwiki code and getting it wrong, introducing the very error I'd fixed. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
The 8601 week is based on the count of Thursdays but the week starts on the Monday and ends on the following Sunday. I haven't tested this, but is this accounted for in your logic? And what about the situation where Jan 1 (on a Fri, Sat, Sun) is in the 52nd or 53rd week of the prior year? On Sat, Dec 14, 2013 at 12:14 PM, Wols Lists antli...@youngman.org.ukwrote: On 14/12/13 18:53, Kevin King wrote: The most challenging date math we've faced recently (a real project) is the ISO 8601 week calculation. Extremely easy to introduce an off-by-one error! THAT'S MY CODE! And how long has it been on Pickwiki? Absolutely ages! How does your solution compare with mine? Six lines of code :-) http://www.pickwiki.com/cgi-bin/wiki.pl?IsoWeekNum I think my code was lifted for this ... http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility Which had the off by one introduced :-) Cheers, Wol On Sat, Dec 14, 2013 at 11:13 AM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 16:48, Dan Fitzgerald wrote: Kevin: I'd take the month (verifying; gigo), then run it through a case statement to determine the number of days in that month (sounds like a handy subroutine to have in the toolbox). Then I'd convert to get the day of the week, another case statement to get the number of days past Thursday, do the math from the last DOM internal date, oconv the result, and grab a cup of dark roast. There are probably more efficient ways, but that's how I'd work it through my head in an interview. This is pretty much the same problem as current week of the year :-) Can't remember off the top of my head, but it's *extremely* easy to make an off by one error - I remember someone copying my Pickwiki code and getting it wrong, introducing the very error I'd fixed. 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-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] Interview Questions
I'll have to run this through some testing, as it's definitely simpler than the solution I came up with. On Sat, Dec 14, 2013 at 12:40 PM, Wols Lists antli...@youngman.org.ukwrote: On 14/12/13 19:20, Kevin King wrote: The 8601 week is based on the count of Thursdays but the week starts on the Monday and ends on the following Sunday. I haven't tested this, but is this accounted for in your logic? And what about the situation where Jan 1 (on a Fri, Sat, Sun) is in the 52nd or 53rd week of the prior year? YES IT IS :-) If you read my code, it takes the given date, goes back to the start of the week, then goes forward to the Thursday. It then works out where in its year that Thursday falls. This is guaranteed (if the maths is correct) to give the correct answer. Cheers, Wol On Sat, Dec 14, 2013 at 12:14 PM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 18:53, Kevin King wrote: The most challenging date math we've faced recently (a real project) is the ISO 8601 week calculation. Extremely easy to introduce an off-by-one error! THAT'S MY CODE! And how long has it been on Pickwiki? Absolutely ages! How does your solution compare with mine? Six lines of code :-) http://www.pickwiki.com/cgi-bin/wiki.pl?IsoWeekNum I think my code was lifted for this ... http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility Which had the off by one introduced :-) Cheers, Wol On Sat, Dec 14, 2013 at 11:13 AM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 16:48, Dan Fitzgerald wrote: Kevin: I'd take the month (verifying; gigo), then run it through a case statement to determine the number of days in that month (sounds like a handy subroutine to have in the toolbox). Then I'd convert to get the day of the week, another case statement to get the number of days past Thursday, do the math from the last DOM internal date, oconv the result, and grab a cup of dark roast. There are probably more efficient ways, but that's how I'd work it through my head in an interview. This is pretty much the same problem as current week of the year :-) Can't remember off the top of my head, but it's *extremely* easy to make an off by one error - I remember someone copying my Pickwiki code and getting it wrong, introducing the very error I'd fixed. 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-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] [OT] Interview Questions
I ran it through dates from 01 Jan 13 to 31 Dec 2099 and it works perfectly. Now I just need to adjust it to include the date in the format -ww. On Sat, Dec 14, 2013 at 12:54 PM, Wols Lists antli...@youngman.org.ukwrote: On 14/12/13 19:44, Kevin King wrote: I'll have to run this through some testing, as it's definitely simpler than the solution I came up with. Read the notes at the top, explaining the logic. Satisfy yourself that's correct (it is :-), then satisfy yourself that the code actually implements it. What did you come up with? Cheers, Wol On Sat, Dec 14, 2013 at 12:40 PM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 19:20, Kevin King wrote: The 8601 week is based on the count of Thursdays but the week starts on the Monday and ends on the following Sunday. I haven't tested this, but is this accounted for in your logic? And what about the situation where Jan 1 (on a Fri, Sat, Sun) is in the 52nd or 53rd week of the prior year? YES IT IS :-) If you read my code, it takes the given date, goes back to the start of the week, then goes forward to the Thursday. It then works out where in its year that Thursday falls. This is guaranteed (if the maths is correct) to give the correct answer. Cheers, Wol On Sat, Dec 14, 2013 at 12:14 PM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 18:53, Kevin King wrote: The most challenging date math we've faced recently (a real project) is the ISO 8601 week calculation. Extremely easy to introduce an off-by-one error! THAT'S MY CODE! And how long has it been on Pickwiki? Absolutely ages! How does your solution compare with mine? Six lines of code :-) http://www.pickwiki.com/cgi-bin/wiki.pl?IsoWeekNum I think my code was lifted for this ... http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility Which had the off by one introduced :-) Cheers, Wol On Sat, Dec 14, 2013 at 11:13 AM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 16:48, Dan Fitzgerald wrote: Kevin: I'd take the month (verifying; gigo), then run it through a case statement to determine the number of days in that month (sounds like a handy subroutine to have in the toolbox). Then I'd convert to get the day of the week, another case statement to get the number of days past Thursday, do the math from the last DOM internal date, oconv the result, and grab a cup of dark roast. There are probably more efficient ways, but that's how I'd work it through my head in an interview. This is pretty much the same problem as current week of the year :-) Can't remember off the top of my head, but it's *extremely* easy to make an off by one error - I remember someone copying my Pickwiki code and getting it wrong, introducing the very error I'd fixed. 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-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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Adding the week number was no big deal. That's a pretty nifty bit of code there man. Thanks for sharing. On Sat, Dec 14, 2013 at 1:03 PM, Kevin King ke...@precisonline.com wrote: I ran it through dates from 01 Jan 13 to 31 Dec 2099 and it works perfectly. Now I just need to adjust it to include the date in the format -ww. On Sat, Dec 14, 2013 at 12:54 PM, Wols Lists antli...@youngman.org.ukwrote: On 14/12/13 19:44, Kevin King wrote: I'll have to run this through some testing, as it's definitely simpler than the solution I came up with. Read the notes at the top, explaining the logic. Satisfy yourself that's correct (it is :-), then satisfy yourself that the code actually implements it. What did you come up with? Cheers, Wol On Sat, Dec 14, 2013 at 12:40 PM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 19:20, Kevin King wrote: The 8601 week is based on the count of Thursdays but the week starts on the Monday and ends on the following Sunday. I haven't tested this, but is this accounted for in your logic? And what about the situation where Jan 1 (on a Fri, Sat, Sun) is in the 52nd or 53rd week of the prior year? YES IT IS :-) If you read my code, it takes the given date, goes back to the start of the week, then goes forward to the Thursday. It then works out where in its year that Thursday falls. This is guaranteed (if the maths is correct) to give the correct answer. Cheers, Wol On Sat, Dec 14, 2013 at 12:14 PM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 18:53, Kevin King wrote: The most challenging date math we've faced recently (a real project) is the ISO 8601 week calculation. Extremely easy to introduce an off-by-one error! THAT'S MY CODE! And how long has it been on Pickwiki? Absolutely ages! How does your solution compare with mine? Six lines of code :-) http://www.pickwiki.com/cgi-bin/wiki.pl?IsoWeekNum I think my code was lifted for this ... http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility Which had the off by one introduced :-) Cheers, Wol On Sat, Dec 14, 2013 at 11:13 AM, Wols Lists antli...@youngman.org.uk wrote: On 14/12/13 16:48, Dan Fitzgerald wrote: Kevin: I'd take the month (verifying; gigo), then run it through a case statement to determine the number of days in that month (sounds like a handy subroutine to have in the toolbox). Then I'd convert to get the day of the week, another case statement to get the number of days past Thursday, do the math from the last DOM internal date, oconv the result, and grab a cup of dark roast. There are probably more efficient ways, but that's how I'd work it through my head in an interview. This is pretty much the same problem as current week of the year :-) Can't remember off the top of my head, but it's *extremely* easy to make an off by one error - I remember someone copying my Pickwiki code and getting it wrong, introducing the very error I'd fixed. 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-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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Will... anything to share with the rest of the class? On Fri, Dec 13, 2013 at 2:53 PM, Wjhonson wjhon...@aol.com wrote: Oh my. Bites Tongue. -Original Message- From: Robert i...@keyway.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 13, 2013 12:27 pm Subject: Re: [U2] [OT] Interview Questions Please email me in regards to your ads. I am currently in between contracts/assignments/projects and looking for my next assignment. Multivalue languages I have been programming in: * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ 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] GUIDE / FIXFILE
There are certain situations where a fix file is not generated. Usually this happens with bad backward links in dynamic files, but there are other situations as well. In this case, the only solution is to create a new file, copy what you can get, clear the original, and copy the records back. On Sun, Dec 1, 2013 at 2:25 PM, Cook, Amy amy_c...@k2sports.com wrote: I am running guide on a single file that reports the integrity has been compromised, but the GUIDE_FIXUP.DAT is not created for fixfile. Unidata 6.1.16. Never seen the fixup file not get created before... I can copy records over to a new file to try and fix, but thought I'd look for some input in case anyone can help TIA, Amy ___ 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] Mysterious Error Message
Is there a particular reason you can't share that DMSECURITY file across all SB enabled accts? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, I did an ESEARCH on the DM file, looking for E115. I did not find it in MM, but did find it in the following: _SB.GENERAL.S _SB.LOGIN _SB.SYSMENU _SB.USER.CHECK I did not find it in _MM, but this still looks like progress. I do not have access to SB source code, but at least this is something I can send back to Epicor, who can hopefully get with Rocket. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 12:36 AM To: U2 Users List Subject: [U2] Mysterious Error Message John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63h OOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pY GjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr 3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://cp.mcafee.com/d/5fHCMUi3zqbbPX332b39KVJ6WarZQrFCzASzt5d-Waq9EVd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIund-COOM qekT-LOrPbVEVjjWZOWbOt-ohpKqen4-mKDp5dmZSel3PWApmU6CQjr1KVKVI06vaAWv4P Yurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SZtdwSq mMCCqnjh0q81IJivNBlKxEw6ENH4Qg3vQFF7PtPqo_5hhM8
Re: [U2] Mysterious Error Message
If I recall, the checksum itself is account specific. So if the checksum were being calculated for one account but accessing sb resources/processes from another, could that be triggering the checksum mismatch? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, This is a temporary situation for testing an unrelated issue. When THAT issues is resolved, I will go back to a single, common DMSECURITY. This is NOT the problem - PILOT and LIVE are both using the same DMSECURITY file - PILOT has the problem, but LIVE does not. The problem is either a local file OR something in DMSECURITY that itself is account specific. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto: u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 9:52 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Is there a particular reason you can't share that DMSECURITY file across all SB enabled accts? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, I did an ESEARCH on the DM file, looking for E115. I did not find it in MM, but did find it in the following: _SB.GENERAL.S _SB.LOGIN _SB.SYSMENU _SB.USER.CHECK I did not find it in _MM, but this still looks like progress. I do not have access to SB source code, but at least this is something I can send back to Epicor, who can hopefully get with Rocket. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 12:36 AM To: U2 Users List Subject: [U2] Mysterious Error Message John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my t jr 3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; javascript:; http://cp.mcafee.com/d/5fHCMUi3zqbbPX332b39KVJ6WarZQrFCzASzt5d-Waq9E Vd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIund-CO OM qekT-LOrPbVEVjjWZOWbOt-ohpKqen4-mKDp5dmZSel3PWApmU6CQjr1KVKVI06vaAWv 4P Yurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SZtdw Sq mMCCqnjh0q81IJivNBlKxEw6ENH4Qg3vQFF7PtPqo_5hhM8 ___ U2-Users mailing list U2-Users
Re: [U2] Mysterious Error Message
I believe the program that generates that message is MM in DM. The error signifies that the calculated checksum in the DMSECURITY record is not correct for the version of SB+ in use. On Monday, November 25, 2013, Israel, John R. wrote: Amy, I do have a pointer to ECL_PHPARMS. Putting a DEBUG in IILOGIN would not work for StoreFront because have no session to interact with the debugger, just a browser. However, that gives me a few idea. I build a log that tracks how far I get and when I fail to get to a certain point, narrow my search around there. Might still bang into a program that I have no source to, but it's a start. Let me do some more digging. What I really need is to know which program is read and using DMCONT ERROR F115! From that, I could back track to the problem. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto: u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 4:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message We The difference is, when you come in through RedBack it's using the agent itself, so it sees it as a phantom user. It may be easiest to stick a debug in IILOGIN - check around line 46 (in our version), for comment: 'Check for iConnect Phantom processing'. This would also make sense in that both test and pilot in the same realm are not working, since IILOGIN is in BP. However...if you already compared live to pilot, then I guess that goes out the window. Any chance your VOC pointer to ECL_PHPARMS is missing? I think that all those pointers are established when you 'share' the data account from either the iconnect progs account or the dfl-progs account, but I don't remember which. Assuming you retained your VOC when you created your test/pilot accounts, that should not have changed. But it's something to look at... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:54 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Amy, Yes, I am using iConnect's SB login/pw as soon as UniData/SB launches and I get right in. I looked at the date stamp on the iConnect data and it has not been touch in a LONG time. What is different between this and running it on-line? Since I can get in that way w/o any problems, why is SB thinking there is a problem? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 2:39 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes, agreed. So you're using the sb+ uid/pw of the iconnect service manager? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:36 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Amy, Yes, both look good. Based on the 1st word in the message (II), this really looks like a SB error. I get NO errors if I login manually using the Redback UNIX login, cd to the TEST account, launch UniData (udt), and type in the iConnect login/pw. That is as close to simulating iConnect as I can think of. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message is WW.SB.RB cataloged in pilot and test? Is BP IILOGIN the same? If yes to both, take redback out of the picture, along with the screen changes (it's not making it to the screen yet...) Do you get the same message when you login through SB+, with the same user that the iConnect agent logs in with? (make sure that user group is allowing it to get into the pilot/test accounts) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 10:28 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account
[U2] Mysterious Error Message
John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF-VsH ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ 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] Epicor is now in Denver?
Yeah, I noticed last time I was in the city that Epicor has an office downtown in the black tower of doom, same neighborhood where Unidata lived for a while. On Mon, Oct 28, 2013 at 11:28 AM, Hilk, Brandon brandon.h...@iqor.comwrote: They have a building just outside Minneapolis as well. Not sure which business units belong to which campuses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 28, 2013 12:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] [JOB] Epicor is now in Denver? http://www.linkedin.com/jobs2/view/9263360?trk=rj_em I had them in a place called Yardley PA. Did they move? Or do they have multiple programming centers? ___ 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] Interview Questions
Unfortunately, in one case I hired a friend. Needless to say, it was one of the worst decisions I've made. Not only lost a friend, but lost a lot of customer confidence by her attitude, poor workmanship, and unwillingness to adapt. On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.comwrote: Wow, seen a lot of that and managers trying to get friends hired to create a perfect office society. quit hiring backstabbing chaff with their own agendas. Robert - Original Message - From: Kevin King ke...@precisonline.com To: Susan Joslyn sjos...@sjplus.com; U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, October 09, 2013 8:07 PM Subject: Re: [U2] [OT] Interview Questions Susan, yes. I've been very open in my interviews, and it's netted significantly regrettable results. So this time I'm going for people who can get behind and contribute to the common cause as soon after hire as possible. I don't have any aspirations of hiring for life, though I certainly do endeavor to have that kind of an environment for a person who wants that sort of thing. I just need to quit hiring backstabbing chaff with their own agendas. On Tue, Oct 8, 2013 at 1:54 PM, Susan Joslyn sjos...@sjplus.com wrote: Kevin, Not that I have any real experience - at least not for what seems like a lifetime - with hiring. But my instinct might be to let the applicant tell me whatever they want. You know, just an open ended Tell me what you would like me to know about your skills, your ambitions and your work ethic. Probably that's an approach you've already tried. Susan -Original Message- From: mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[ mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, 8 October 2013 1:40 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Interviewer: What is one of your weak points? Applicant: My honesty. Interviewer: I would have thought that was a strong point. Applicant: I don't give a %^* what you think you stupid ^^%$ __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://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-users
Re: [U2] [OT] Interview Questions
You are correct, with my apologies to the group. On Fri, Oct 11, 2013 at 11:12 AM, Doug Averch dave...@gmail.com wrote: Kevin, You realize this is not a therapy session. There are people you know and others that may be reading this. This is not the venue for that. Regards, Doug www.u2logic.com On Fri, Oct 11, 2013 at 10:56 AM, Kevin King ke...@precisonline.com wrote: Unfortunately, in one case I hired a friend. Needless to say, it was one of the worst decisions I've made. Not only lost a friend, but lost a lot of customer confidence by her attitude, poor workmanship, and unwillingness to adapt. ___ 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] Interview Questions
I also agree. I'm willing to train, but what I've found is that someone that is willing to learn doesn't necessarily mean they're able to learn or willing to do what they've learned. What happened here was that a group of folks with little experience got a lot of good training and then took the training elsewhere, so I'd rather not start from scratch if at all possible. We need folks to be able to contribute quickly, so I don't have the time nor desire to give someone their first programming job knowing that I'm only giving them wings to fly. And yeah, I'm still a little bitter. I'll get over it. :-) On Fri, Oct 11, 2013 at 1:33 PM, Robert Frailey rfrai...@utahmed.comwrote: I totally agree with Brenda and Bill. Work sent Brooke and I to Epicor's Unidata and Pick classes in California, I only had Novell and Microsoft when I was hired. I picked up Unix, Unidata, redback and DBMS from classes provided by work. 19 years later, Brooke and I are self sufficient. We show up on time and put in whatever necessary to complete our tasks. We learn everything in sight. We would be hard pressed if one or both of us got hit by a bus. I'm expected to be 24 hours a day / seven days a week and Brooke fills in when I can't. I run into very few people with our work ethic anymore. Robert - Original Message - From: Brenda Ives bren...@marketamerica.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, October 11, 2013 1:18 PM Subject: Re: [U2] [OT] Interview Questions How about the other end here? By other end, I mean this. What about someone in college or out of college with a degree other than an IT subject or if with an IT degree or working on one, who has been taught by someone with over 20 years of experience outside of college but the student/graduate has no employment history of what has been taught them outside of college. Plus they meet all 3 of your requirements listed below? UniVerse/UniData/D3/JBASE/**CACHE is not taught in colleges and if we don't teach them what happens when all of us oldies are gone? Brenda -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[mailto: u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, October 11, 2013 2:41 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Kevin: After actually hiring a lot of people, and firing those that needed it, I've come to the conclusion that all employers need a person with the following three attributes: 1) An ability, and willingness, to be on-time, 2) An ability, and willingness, to be presentable in all business situations, and 3) An ability, and willingness, to learn what they don't know (which is always a lot!). The people coming out of college these days are mostly unemployable. Today's bachelors degree is like a 1930 8th grade education, or a 1970 high school education. So, no matter what any Human Services dweeb says, getting someone to show up looking presentable and willing to work whatever it takes to learn what they don't know is gold! These kinds of people are quite trainable and, considering all software frameworks have a short shelf life anyway, offer a lot of flexibility for your purposes. Just a thought. :-) Bill --**--** - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/11/2013 9:56 AM *Subject:* Re: [U2] [OT] Interview Questions Unfortunately, in one case I hired a friend. Needless to say, it was one of the worst decisions I've made. Not only lost a friend, but lost a lot of customer confidence by her attitude, poor workmanship, and unwillingness to adapt. On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.com wrote: Wow, seen a lot of that and managers trying to get friends hired to create a perfect office society. quit hiring backstabbing chaff with their own agendas. Robert - Original Message - From: Kevin King ke...@precisonline.com To: Susan Joslyn sjos...@sjplus.com; U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, October 09, 2013 8:07 PM Subject: Re: [U2] [OT] Interview Questions Susan, yes. I've been very open in my interviews, and it's netted significantly regrettable results. So this time I'm going for people who can get behind and contribute to the common cause as soon after hire as possible. I don't have any aspirations of hiring for life, though I certainly do endeavor to have that kind of an environment for a person who wants that sort of thing. I just need to quit hiring backstabbing chaff with their own agendas. On Tue, Oct 8, 2013 at 1:54 PM, Susan Joslyn sjos...@sjplus.com wrote: Kevin, Not that I have any real experience - at least not for what
Re: [U2] [OT] Interview Questions
Okay Will, I'll bite. So what's that look like? How can you identify someone looking for their last job, and what qualities does one need to offer? Clearly it's not excessive cash, flexible schedules, great equipment, wonderful customers, a wide variety of technologies to learn and grow, and a quiet, bring-your-dog-to-work type environment. Yeah, there's heavy workloads, but that's a sign that we're doing a good job when customers are loading us down with opportunities, right? On Fri, Oct 11, 2013 at 3:26 PM, Wjhonson wjhon...@aol.com wrote: If you give them their first programming job they will leave The trick is finding people to whom you are giving them their *last* programming job. -Original Message- From: Kevin King ke...@precisonline.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Oct 11, 2013 1:15 pm Subject: Re: [U2] [OT] Interview Questions I also agree. I'm willing to train, but what I've found is that someone that is willing to learn doesn't necessarily mean they're able to learn or willing to do what they've learned. What happened here was that a group of folks with little experience got a lot of good training and then took the training elsewhere, so I'd rather not start from scratch if at all possible. We need folks to be able to contribute quickly, so I don't have the time nor desire to give someone their first programming job knowing that I'm only giving them wings to fly. And yeah, I'm still a little bitter. I'll get over it. :-) On Fri, Oct 11, 2013 at 1:33 PM, Robert Frailey rfrai...@utahmed.com wrote: I totally agree with Brenda and Bill. Work sent Brooke and I to Epicor's Unidata and Pick classes in California, I only had Novell and Microsoft when I was hired. I picked up Unix, Unidata, redback and DBMS from classes provided by work. 19 years later, Brooke and I are self sufficient. We show up on time and put in whatever necessary to complete our tasks. We learn everything in sight. We would be hard pressed if one or both of us got hit by a bus. I'm expected to be 24 hours a day / seven days a week and Brooke fills in when I can't. I run into very few people with our work ethic anymore. Robert - Original Message - From: Brenda Ives bren...@marketamerica.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, October 11, 2013 1:18 PM Subject: Re: [U2] [OT] Interview Questions How about the other end here? By other end, I mean this. What about someone in college or out of college with a degree other than an IT subject or if with an IT degree or working on one, who has been taught by someone with over 20 years of experience outside of college but the student/graduate has no employment history of what has been taught them outside of college. Plus they meet all 3 of your requirements listed below? UniVerse/UniData/D3/JBASE/**CACHE is not taught in colleges and if we don't teach them what happens when all of us oldies are gone? Brenda -Original Message- From: u2-users-bounces@listserver.**u2ug.org u2-users-boun...@listserver.u2ug.org[mailto: u2-users-bounces@**listserver.u2ug.org u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, October 11, 2013 2:41 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Kevin: After actually hiring a lot of people, and firing those that needed it, I've come to the conclusion that all employers need a person with the following three attributes: 1) An ability, and willingness, to be on-time, 2) An ability, and willingness, to be presentable in all business situations, and 3) An ability, and willingness, to learn what they don't know (which is always a lot!). The people coming out of college these days are mostly unemployable. Today's bachelors degree is like a 1930 8th grade education, or a 1970 high school education. So, no matter what any Human Services dweeb says, getting someone to show up looking presentable and willing to work whatever it takes to learn what they don't know is gold! These kinds of people are quite trainable and, considering all software frameworks have a short shelf life anyway, offer a lot of flexibility for your purposes. Just a thought. :-) Bill --**--** - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/11/2013 9:56 AM *Subject:* Re: [U2] [OT] Interview Questions Unfortunately, in one case I hired a friend. Needless to say, it was one of the worst decisions I've made. Not only lost a friend, but lost a lot of customer confidence by her attitude, poor workmanship, and unwillingness to adapt. On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.com wrote: Wow, seen a lot
Re: [U2] [OT] Interview Questions
Hey man, it was funny! Thanks for the levity. On Mon, Oct 7, 2013 at 8:43 PM, Leverett, Brendon brendon.lever...@spotless.com.au wrote: Kevin, Sorry if I was making light of your serious request but this rather bad joke came back to me as soon as I read your post. Good luck with the tech non-tech Qs -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, 8 October 2013 1:40 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Interviewer: What is one of your weak points? Applicant: My honesty. Interviewer: I would have thought that was a strong point. Applicant: I don't give a %^* what you think you stupid ^^%$ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, 8 October 2013 1:36 PM To: U2 Users List Subject: [U2] [OT] Interview Questions This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ 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] [OT] Interview Questions
Susan, yes. I've been very open in my interviews, and it's netted significantly regrettable results. So this time I'm going for people who can get behind and contribute to the common cause as soon after hire as possible. I don't have any aspirations of hiring for life, though I certainly do endeavor to have that kind of an environment for a person who wants that sort of thing. I just need to quit hiring backstabbing chaff with their own agendas. On Tue, Oct 8, 2013 at 1:54 PM, Susan Joslyn sjos...@sjplus.com wrote: Kevin, Not that I have any real experience - at least not for what seems like a lifetime - with hiring. But my instinct might be to let the applicant tell me whatever they want. You know, just an open ended Tell me what you would like me to know about your skills, your ambitions and your work ethic. Probably that's an approach you've already tried. Susan -Original Message- From: mailto:u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, 8 October 2013 1:40 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Interviewer: What is one of your weak points? Applicant: My honesty. Interviewer: I would have thought that was a strong point. Applicant: I don't give a %^* what you think you stupid ^^%$ ___ 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] Interview Questions
David, I'm a company of 10. HR, technology, hell, even vacuuming the facility falls to moi. On Tue, Oct 8, 2013 at 2:27 PM, David A. Green dgr...@dagconsulting.comwrote: Why not let HR handle the personality questions and background checks, that's what they do. That leaves you to concentrate on their technical abilities. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Tuesday, October 08, 2013 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] Interview Questions Kevin, Not that I have any real experience - at least not for what seems like a lifetime - with hiring. But my instinct might be to let the applicant tell me whatever they want. You know, just an open ended Tell me what you would like me to know about your skills, your ambitions and your work ethic. Probably that's an approach you've already tried. Susan -Original Message- From: mailto:u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, 8 October 2013 1:40 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Interviewer: What is one of your weak points? Applicant: My honesty. Interviewer: I would have thought that was a strong point. Applicant: I don't give a %^* what you think you stupid ^^%$ ___ 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] Interview Questions
TG, I hired a guy with copious MV skill. He came on strong and then just one day decided that he was smarter than everyone else and didn't want to do the tasks that he was assigned. Unbelievable waste of an otherwise talented resource. On Tue, Oct 8, 2013 at 3:56 PM, Tony Gravagno 3xk547...@sneakemail.comwrote: I wrote a short blog series on the ineffectiveness of 98% of the companies recruiting for MV positions, I just haven't published it yet. In short, they don't know what questions to ask and most end-users don't know either. That's why we see a high percentage of failed hires in this industry, and Kevin is just confirming that. Kevin, don't forget PickJobs.net. In addition to some of the suggestions here, I'd give a candidate a set of hands-on tests. Their resources: The command line and a browser. We're all going to have varying degrees of success coughing up a solution on the spot, in a verbal interview, or in writing. But if we can put it to the keyboard, most of us are going to have much better success. The browser is there for a touch of the real world. I might not know the exact syntax to get something done, but if I screw up and fall into debug, I will still get the job done quickly if I can access the product documentation, wiki's, and these valuable forums. Rather than asking a person for a fish, just make sure they know where to fish and that they know how to use the fishing pole. If they don't know where to find solutions then they're going to flounder (pun wasn't intended, but I'll take it). If they know where the industry/community resources are then they'll be able to respond to dynamic requirements even if they don't know a solution off-hand. And I'm going to alienate about 70% of our colleagues here, but I think a modern interview needs to favor those who have current knowledge of a variety of technologies. A BASIC-only developer isn't going to cut it anymore and people who are BASIC-only are holding onto their jobs because they know their current applications, not for their technical skills. If you're going to hire someone who isn't familiar with your app, they Must be on top of technologies, only one of which is MV. So depending on your company/client directions, the modern candidate must know MV + (Java and/or .NET and/or PHP and/or MySQL and/or SQL Server). They must have a solid grasp on XML and/or JSON. They must have a working knowledge of web services with SOAP and/or REST - and sending/receiving transactions with MV. A new hire must understand how MV behaves as a component in an enterprise, not as the one and only server in an office. Yeah, we're going to pay more for this person, but the person who differentiates themselves by knowing more than just Pick has already distinguished themselves in their ability to adapt to change - and that's really the kind of person we need to hire these days. Unfortunately it's going to be a lot easier to train someone to use Pick if they already know other technologies, than it will be to train a MV-only person to use other technologies. The people who haven't picked up on technology from this millennium demonstrate a long-term lack of drive and initiative - that's the kind of person we do Not want to hire these days. (One of the services I passively offer is assistance with hiring, interviewing, etc. Please feel free to contact me for assistance in creating job ads which attract the right people, and evaluating the people who respond.) Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog http://LinkedIn.com/in/TonyGravagno http://Twitter.com/TonyGravagno http://PickWiki.com http://groups.google.com/group/MVDBMS http://www.LinkedIn.com/groups/Pick-Users-Group-64935 http://BitBucket.org/FOSS4MV ___ 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] Interview Questions
Rex, copious thanks. Great information. On Wed, Oct 9, 2013 at 12:57 PM, Rex Gozar rgo...@gmail.com wrote: Kevin, You want people who are smart and get things done -- http://www.joelonsoftware.com/articles/fog73.html rex On Wed, Oct 9, 2013 at 4:39 AM, Brian Leach br...@brianleach.co.uk wrote: Kevin I remember a long time back working for a consultancy in Oxford we had long and ineffective interview processes. Then we took on a client that was an institute of personnel directors, and found they published some very good materials on how to conduct interviews. The main lesson was to have a very clear set of goals and criteria drawn up and agreed before you go in, and a clear way to assess against that. Sounds obvious, but we weren't doing that. When we did it was much easier to decide whether they had demonstrated that they had met those criteria and we could be more analytical especially at the first interview stage. That was more valuable than trying to come up with clever questions. Technical assessment is a different story. For that, a clear task to perform with measurable criteria for correctness. Brian ___ 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] Interview Questions
For everyone else who responded and that I didn't respond personally, thank you so much. I've come to the conclusion that not only have I been lax in testing technical knowledge, Brian is right, I didn't really have a vision for where to slot someone and therefore the interview was a little washed out. Thanks to everyone who has (and will) respond to this. It's most helpful. On Wed, Oct 9, 2013 at 8:11 PM, Kevin King ke...@precisonline.com wrote: Rex, copious thanks. Great information. On Wed, Oct 9, 2013 at 12:57 PM, Rex Gozar rgo...@gmail.com wrote: Kevin, You want people who are smart and get things done -- http://www.joelonsoftware.com/articles/fog73.html rex On Wed, Oct 9, 2013 at 4:39 AM, Brian Leach br...@brianleach.co.uk wrote: Kevin I remember a long time back working for a consultancy in Oxford we had long and ineffective interview processes. Then we took on a client that was an institute of personnel directors, and found they published some very good materials on how to conduct interviews. The main lesson was to have a very clear set of goals and criteria drawn up and agreed before you go in, and a clear way to assess against that. Sounds obvious, but we weren't doing that. When we did it was much easier to decide whether they had demonstrated that they had met those criteria and we could be more analytical especially at the first interview stage. That was more valuable than trying to come up with clever questions. Technical assessment is a different story. For that, a clear task to perform with measurable criteria for correctness. Brian ___ 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] [OT] Interview Questions
This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting....
Isn't there something that strips the symbol table during compile? If the symbol table were suppressed the D might not appear because it couldn't do much anyway, right? On Oct 2, 2013 11:53 AM, George Gallen ggal...@wyanokegroup.com wrote: I Don't know? I never really looked into the PTERM signals. I would think that is referring to a Break signal vs Control C (but I don't know) It's not that the Break is disabled - just the DEBUG option was missing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson Sent: Wednesday, October 02, 2013 1:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting Is BREAK=NULL what you expected to see ? -Original Message- From: George Gallen-2 [via U2 (UniVerse UniData)] ml-node+s1073795n41901...@n5.nabble.com To: Will Johnson wjhon...@aol.com Sent: Wed, Oct 2, 2013 10:46 am Subject: Re: Interesting PTERM DISPLAY (RUNNING UV 10.0.2) MODEEMULATE CC INTR= ^C QUIT= ^\ SUSP= OFF DSUSP = OFF SWITCH = OFF ERASE = ^H WERASE = OFF KILL= ^U LNEXT = OFF REPRINT = OFF EOF = ^D EOL = ^@ EOL2= ^@ FLUSH = OFF START = ^Q STOP= ^S LCONT = ^_ FMC = ^^ VMC = ^] SMC = ^\ TMC = ^T SQLNULL = ^N INPUTCTLOFF CARRIER RECEIVE -HANGUP -LOCAL CASE-UCIN -UCOUT -XCASE -INVERT CRMODE -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY DELAY BS0 CR0 FF0 LF0 VT0 TAB0 -FILL ECHOECHO ERASE=BSB KILL=LF CTRL -LF HANDSHAKE XON -ANY -TANDEM -DTR OUTPUT POST -TILDE -BG CS -EXPAND PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP SIGNALS ENABLE FLUSH BREAK=NULL -Original Message- From: [hidden email] [mailto:[hidden email]] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 1:23 PM To: [hidden email] Subject: Re: [U2] Interesting The INTR.KEY in the VOC is not the only thing controlling breaking behaviour. It specifies the maximum level of ability, not the minimum, it can be overridden. However, please type PTERM DISPLAY at TCL and post the results for us to review. That is your first step, before we get more technical. -Original Message- From: George Gallen [hidden email] To: U2 Users List [hidden email] Sent: Wed, Oct 2, 2013 10:20 am Subject: Re: [U2] Interesting Yes... The only time I've not had the D option, is when I break from a VOC Which is expected, since you can't debug a VOC. So, why would the D option not appear when you break from a basic program? Whenit does when you break from an input it does when another program is in a loop just this program in this loop it did not appear And it wasn't executing a SELECT that was taking a long time or something, then That would be like breaking out of a VOC George ___ U2-Users mailing list [hidden email] http://listserver.u2ug.org/mailman/listinfo/u2-users If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41901.html To start a new topic under U2 - Users, email ml-node+s1073795n3...@n5.nabble.com To unsubscribe from U2 (UniVerse UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41905.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] No mail
We are here, we are here, we are HERE!! You'd never know my kids are grown. :) On Sat, Sep 21, 2013 at 2:44 AM, Allen Egerton aeger...@pobox.com wrote: Pong. (Allen - Sent from my paperweight) On Sep 20, 2013, at 10:01 PM, Michael Spencer mspen...@dbkeeper.com wrote: Test. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson Sent: Friday, September 20, 2013 5:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] No mail Still no mail from the list. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/No-mail-tp41844p41855.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] in Colorado ?
Well, that's unfortunate. But a quick web search turned up this: Colorado Hospital Association Attn: Human Resources 7335 East Orchard Road Greenwood Village, CO 80111 I'm sure there's an email address somewhere too, I just didn't look that far. Knowing a bit about CHA, this would be a pretty excellent job for someone. On Tue, Sep 17, 2013 at 11:46 AM, Wjhonson wjhon...@aol.com wrote: I'm sure it's just me, but really if *I* were to post a job ad, I would at least tell people how to respond to it http://www.intl-spectrum.com/Multivalue_jobs.aspx No phone number, no address, no email, no way to actually respond. Unless Spectrum is now taking and forwarding resumes ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Tap-In
John, the slash intercept process is at /HK.CONTROL, on the F5 screen I believe. On Mon, Sep 9, 2013 at 9:54 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: We are looking to somehow tap into the SB security to add our own logic that would always run when a process is fired off. Any thoughts? How do you control what logic gets run when the slash is typed? Any other great ideas? We know how we want to do it, but do not know where to tap into SB to have this take effect everywhere. JRI ___ 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] UDT 7.1 Indexing question
My guess is that it shouldn't matter. Each multivalue in a list gets a separate index entry. On Tue, Aug 27, 2013 at 10:46 AM, Lunt, Bruce bl...@shaklee.com wrote: Hi All, Will indexing a field that I retrieve with BY-EXP be faster than an un-indexed field? Thanks, Bruce ___ 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] UDT 7.1 Indexing question
Dave's right, if you can look for a specific value (or values with xyz) you'll get significantly faster speed than with with BY.EXP. You can then use a LOCATE(..) in BASIC to figure out which rows are to be included on the report. On Tue, Aug 27, 2013 at 11:58 AM, Lunt, Bruce bl...@shaklee.com wrote: Each record has 2-5 multi-values that are date periods. I am looking for the most recent 3 periods. There are over a million records so the BY-EXP gives me 3 million values to process. I thought about writing a work file with the values in a separate record but the size seems like it would take forever to do and then I would still need to create the report from the work file's 3 million records. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, August 27, 2013 10:52 AM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question It really depends on the percentage of records that contain the value you are looking for - multivalued or not I think if you include a criteria like: WITH mv_indexed_field = value it will be faster than without the index. However, if most of the records in the file have that value it won't make much difference. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, August 27, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question That's what I was afraid of. I have a large file and I was looking for some way to speed up a report that I am creating with Uniquery. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, August 27, 2013 10:43 AM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question My guess is that it shouldn't matter. Each multivalue in a list gets a separate index entry. On Tue, Aug 27, 2013 at 10:46 AM, Lunt, Bruce bl...@shaklee.com wrote: Hi All, Will indexing a field that I retrieve with BY-EXP be faster than an un-indexed field? Thanks, Bruce ___ 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 Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg ] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ 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] Unidata 7.1.22/AIX - Stack overflow
We have a customer that has a program (and associated subroutines) that has not been modified in a good long while. Just this past week it started blowing up with a memory failure and segfault at different times in the process. Unidata was recently restarted. I'm suspecting that some bit of code in this quagmire is doing some GOSUBs and not unravelling the stack, and eventually it's just running out of stack space. But ... how can I prove this without stepping through the code line by line? Is there something in the Unidata debugger that shows the GOSUB stack? I've tried running this through the MM -E trick (this is a SB+ app, btw) and it never drops in the debugger when this happens, the process just terminates and returns to AIX. So I'm a little uncertain as to how to go about figuring this one out. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22/AIX - Stack overflow
Thank you for the insight. The program in question is entirely BASIC. It is a subroutine called from an SB+ paragraph that then calls other subroutines to do the heavy lifting. So while it's called from SB+, it doesn't use anything in SB+, it's just some vendor-written subroutines calling other vendor-written subroutines. We have the source for it, but was hoping we could find a way to debug it as it's a massive number of lines across an equally massive number of routines, running against a pretty significant list of records across an equally impressive number of files. At the time this started happening, Unidata had been running for about six months without a restart. Restarting Unidata didn't change the outcome of this program, it still aborts randomly, which leads me to think that there has been some change in the data that is causing this vendor code to misbehave, but without single-stepping through the code (which literally could take months) I was just wondering if there's anything in the debugger that would tell me how many un-returned GOSUBS have been hit? This site uses work order assemblies in this particular vendor product and I'm wondering if there's a loop in the bill of materials somewhere that's basically exhausting memory, but there just isn't time to single-step through the code to try to find that without some trickery or magic to help the process along. -K On Sat, Aug 10, 2013 at 5:23 PM, John Jenkins u2g...@btinternet.com wrote: Kevin, Could someone be constantly using /process_name to constantly jump around the system? If so, the. One of the SB files will build up a history (not recalling which one off the top of my head) . Look for a massive increase build up of records which will point to a culprit user or process. SB code - unless you code your own subroutines or generate code /GC - are interpreted. Otherwise I recommend checking files and indexes for corruption. BASIC catalog used can become corrupt just like any other data, it's incredibly rare though. Regards JayJay On 10 Aug 2013, at 21:12, Kevin King ke...@precisonline.com wrote: We have a customer that has a program (and associated subroutines) that has not been modified in a good long while. Just this past week it started blowing up with a memory failure and segfault at different times in the process. Unidata was recently restarted. I'm suspecting that some bit of code in this quagmire is doing some GOSUBs and not unravelling the stack, and eventually it's just running out of stack space. But ... how can I prove this without stepping through the code line by line? Is there something in the Unidata debugger that shows the GOSUB stack? I've tried running this through the MM -E trick (this is a SB+ app, btw) and it never drops in the debugger when this happens, the process just terminates and returns to AIX. So I'm a little uncertain as to how to go about figuring this one out. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22/AIX - Stack overflow
Wol, MM -E is the greatest debugging tool in the SB+ arsenal (IMO, of course) and it's not really even an SB+ feature, it's a Unidata thing. It allows you to start the SB+ main menu (MM) with the Unidata -E (drop to debug on error) option. When there's a problem, unassigned variable, divide by zero, etc., Unidata usually doesn't stop and it doesn't tell you where the problem is. With this, you drop in the debugger on the exact line. Works brilliantly for tracing through these big nests of OPM (other people's messes). On Sat, Aug 10, 2013 at 4:16 PM, Anthonys Lists antli...@youngman.org.ukwrote: On 10/08/2013 21:12, Kevin King wrote: We have a customer that has a program (and associated subroutines) that has not been modified in a good long while. Just this past week it started blowing up with a memory failure and segfault at different times in the process. Unidata was recently restarted. Did it start happening at the same time as Unidata was restarted? I suspect you don't actually know. I'm suspecting that some bit of code in this quagmire is doing some GOSUBs and not unravelling the stack, and eventually it's just running out of stack space. But ... how can I prove this without stepping through the code line by line? Is there something in the Unidata debugger that shows the GOSUB stack? I've tried running this through the MM -E trick (this is a SB+ app, btw) and it never drops in the debugger when this happens, the process just terminates and returns to AIX. So I'm a little uncertain as to how to go about figuring this one out. Not knowing what MM -E is, I don't know what this is supposed to do, but surely a basic stack overflow should not crash Unidata itself? The first thing I'd be inclined to rule out is a hardware failure of some sort. Can you run a memory test? Any ideas? Just my tuppence worth - if it's worth even that ... :-) Cheers, Wol __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://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-users
Re: [U2] SB: Character Mode Works Great, GUI Does Not
Try setting @ACTION to 2 in addition to setting the @KEY and reading @RECORD. See if that helps.. On Fri, Aug 9, 2013 at 12:07 PM, Al DeWitt adew...@stylmark.com wrote: I am creating a simple screen. Two fields. The Before Process in the Definition defines @KEY, reads @RECORD and loads @RECORD6 into @WORK1 which is displayed on the screen (lines of text). @WORK1 is a multivalue field. The Before Process invokes the text editior. The user is allowed to manipulate text. When the user presses F2 to exit the text editor and goes to the second field and the length of the MV field is displayed and if it is greater than 350 it displays an error and returns the user to the field to shorten it. Once things are good it will write the new field to the file (WRITEV) and exit the screen. Everything works in character mode. The text field displays, etc. However, it GUI the text field is blank. REGEN.GUI does nothing to fix the problem. Any ideas. Albert DeWitt, CPIM ___ 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] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] XML or JSON converter for Unibasic
Charles, if you're not on 7.3 the built-in JSON parser isn't going to help much. In that case, I may be able to help you out. We move lots of JSON between Unidata and our Red Leaf web portal. On Fri, Aug 2, 2013 at 1:19 PM, charles_shaf...@ntn-bower.com wrote: Very good advice. I did know that XML support was built-in to Unidata, and apparently JSON support is included in the newest version of Unidata. I guess I am leaning towards JSON because as Aaron Titus pointed out, it is more lightweight than XML. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org, Date: 08/02/2013 01:05 PM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org I do this sort of thing all the time. I'm also curious to know if a Uni-query can be rendered directly as XML or JSON. I know QM can render as XML with a simple modifier on the command-line, thought U2 could do this too. JSON is a different animal and I'm not aware of any decent JSON builders for any MV environment - they're all proprietary and unpublished except for the new one in Unidata. The real problem with all of these XML/JSON solutions is that the output we get from our reports is 2-dimensional columns and rows - a curious anomaly after all of these years, considering how much we pride ourselves on being multi-dimensional. XML and JSON aren't of much use with flat data. Coding a 2D export to XML or JSON is trivial. Where this gets complex is in nested relationships, XML and JSON excel in representation of multi-dimensional data, and again, none of the MV platforms have rushed to provide decent rendering in this area. (Except maybe TigerLogic which has built a rich XML server around the D3 core, like DataStage was built around Universe.) In plain terms, a U2 report will have something like: ORD# SHIP.ADDR SHIP.CITY ... ORD# SHIP.ADDR SHIP.CITY ... That's 2D. But when you're passing data to another environment, it expects 3D: order id123/id shipto addr.../addr city.../city /shipto /order JSON is exactly the same as XML in structure, just different in syntax. Part of the problem is that the output here needs to use names which are acceptable in XML/JSON tags. That might come from the dict item, probably not unless you have custom dict items just for this. The way this is usually done is with metadata stored in the dict item or somewhere else. So you'll have a dict item named ORD#, the description might say Order ID but the node name will be id. Note above that I'm using id123/id. But that could have been done like this: order id=123 The issue here is that there is no schema definition that defines whether you use elements (unique nodes) or attributes (id=123) within elements. Hardcoded general-purpose solutions will work for your internal purposes but they won't work as a general solution for exchanging data with other entities. And let's not even get into namespaces. In summary, the above explains why it's tough to have a general-purpose solution for rendering query output as XML or JSON. A lot of other metadata is required in order to describe what the document will look like. The only recourse we have is to use the XML hooks provided in the DBMS, to hard-code on a case-by-case basis, or to export and let some external tool do the formatting ... but in all cases you still need to provide metadata or none of these tools will know whether to use id or ordnum, or whether to use elements or attributes. All of that said, the nature of my business is to create solutions to problems like this. I'll be happy to do so for any company that associates value with such solutions. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv/nebulaware From: Charles_Shaffer I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] What is true
Or as we say it here: The way you write code today will determine the words used to describe you six months from now. On Fri, Aug 2, 2013 at 10:00 AM, Wjhonson wjhon...@aol.com wrote: To me the purpose is that -- it helps when reading the code If more effort is spent on the next programmer understanding what your code is doing that is time well worth spent -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Aug 1, 2013 11:16 am Subject: Re: [U2] What is true Hi again, I have been on a site where they insisted that A = B = C should be written as A = B EQ C to emphasise that the second operator is a relational test. Personally, I use A = (B = C) even though the brackets serve no purpose. It just helps when reading the code. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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] What is true
Martin, that's actually one of my standards. Due to the ambiguity of several characters, most notably , , and =, we use EQ, NE, LT, LE, GT, and GE for comparison and use for array extraction and replacement and = for assignment. Except in SB+, which doesn't allow such critters. And kudos for the characters that serve no purpose! Personally, I prefer the readability of: IF (VAR1 GT VAR2) THEN vs. IF VAR1VAR2 THEN but then again, that's just one perspective. On Thu, Aug 1, 2013 at 12:15 PM, Martin Phillips martinphill...@ladybridge.com wrote: Hi again, I have been on a site where they insisted that A = B = C should be written as A = B EQ C to emphasise that the second operator is a relational test. Personally, I use A = (B = C) even though the brackets serve no purpose. It just helps when reading the code. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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] What is true
There is only one truth, and it's false (0 or ). On Wed, Jul 31, 2013 at 8:30 AM, Larry Hiscock lar...@wcs-corp.com wrote: UniData treats WITH fieldname as the equivalent of WITH fieldname . Both 1 and 0 would be selected, the empty string would not. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, July 31, 2013 3:46 AM To: U2 Users List Subject: Re: [U2] What is true And then there's the query language: Suppose INVOICED field is supposed to be true or false. Stored as 1 or 0, but maybe left null in some records (We've all been there.): SELECT CUSTOMER WITH INVOICED If INVOICED is 0 or null, will said CUSTOMER record be selected or not? UV selects if 0, but excludes if null. Do all MV platforms work that way? On 7/31/2013 11:06 AM, Martin Phillips wrote: Hi, About the true/false thing, I always use 0 and 1 but I was chastised about that by a colleague recently, that it might not be completely cross-platform, and now I stutter on it every time I do that, wondering if I'm not really following a best practice I seem to recall this same topic being discussed a year or two back, perhaps in a different group. In the multivalue world, the language definition says that anything that returns true/false returns 1 for true, 0 for false. Anything that interprets a value as true/false treats zero and a null string as false, everything else as true. This definition holds for all multivalue products but not necessarily in other languages. Any new multivalue product that breaks this definition is probably doomed to failure because migration of existing applications would become a nightmare task. In our type variant world where we have no such thing as a Boolean data type, it is very easy to write statements such as INVOICED = 1 Is INVOICED a Boolean variable, perhaps telling us in this case that an invoice has been raised? Or, is it a state flag with multiple values for which this might be indicating a type of invoice that has been sent? There is no way for the reader to tell. At risk of starting a whole new discussion on programming style (and I start form the viewpoint that there are many acceptable styles, it is more important to be consistent), this is probably best resolved by use of tokens. I have for many years held an interesting opinion that a program should never have any hard coded numeric values except perhaps zero, not that I adhere rigidly to my own opinion. The above line becomes something like INVOICED = TRUE or INVOICED = INV.PDF Now, all is clear(er) to the reader. Prime Information introduced @FALSE and @TRUE as symbolic constants (0 and 1 respectively) to avoid the need for our own equated tokens and several other multivalue products have followed this convention. Of course, nothing is ever completely black and white. As multivalue Basic has developed, internal data types have gone beyond simply numbers and strings. If I write IF FVAR THEN ... where FVAR is a file variable, what do I expect this to do? The language definition does not tell us but most multivalue products would give us a data type error of some sort because there is no rule for transforming a file variable to a Boolean value. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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] What is true
I picked up that trick from some old code may years ago, and haven't used it in a while since @TRUE and @FALSE have been available on Unidata and Universe, but you may be seeing some of my old code. As far as I have seen, TRUE is usually 1 on MV platforms, but at the time I started writing that bit of code there were new players in the mix (i.e. jBase, mvBase, microReality?) and it seemed prudent at the time to calculate truth rather than assume it will always be 1. This was not my idea, however. I believe I borrowed it from something I read in Spectrum back in the late 80's. On Tue, Jul 30, 2013 at 6:49 PM, Wjhonson wjhon...@aol.com wrote: Are there MV systems, which do not recognize 1 as being TRUE ? I typically EQUATE FALSE TO 0, TRUE TO 1 But today I ran across code where they do this TRUE = (1=1) FALSE = NOT(TRUE) I suppose this works on all possible computer systems, but is it overkill for multi-value ? ___ 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] What is true
For me it was more of a concern when there were new players entering the market. As we haven't really seen any new MV platforms in a good long while it seems like this is much less of a concern. On Tue, Jul 30, 2013 at 9:21 PM, Tony Gravagno 3xk547...@sneakemail.comwrote: From: Wjhonson I saw it here by KRJ whoever that is http://www.pickwiki.com/cgi-bin/wiki.pl?Compare That's Keith Johnson in NZ. What an unusual last name... ;) Ironically, it looks like he recently modified one of your postings to PickWiki too. About the true/false thing, I always use 0 and 1 but I was chastised about that by a colleague recently, that it might not be completely cross-platform, and now I stutter on it every time I do that, wondering if I'm not really following a best practice: OK = 1 IF OK THEN FOO ELSE BAR IF NOT(OK) THEN BLAH ... I'm curious too - is anyone aware of a platform/flavor where this has not worked in the last decade? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv/nebulaware ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Dynamic File Splitting Question
I agree with Dave, SPLIT/MERGE ratios need to be checked. On Fri, Jul 12, 2013 at 11:00 AM, Dave Laansma dlaan...@hubbardsupply.comwrote: Agreed, the first step is to create the file so there are as many DAT files as necessary and only one or two OVER files. Once you've done that, copied all of the records over to the new file and it remains with only one or two OVER files, THEN do some analytics to establish the SPLIT/MERGE and the hash type (KEYONLY vs KEYDATA) Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, July 12, 2013 12:56 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question We have some very large dynamic files. Some are over 100 gigabytes in size. Too me it is weird that you have one dat portion and 45 overflow portions of the file. My 100 gig file has 43 Dat portions and 1 overflow, which is what I try to maintain. I want as few overflow portions of the file as I can get. What does GROUP.STAT say about this file? When you do the guide, it shows how many records fall into 1-512 512-10281028-2056 etc. I try and adjust my block size for the file to get close to 80-90% of the records in the file to fit into the block size. I usually don't use memresize to rebuild my dynamic files. I create a new file with the configuration I want. We have developed a process called PHANTOM.COPY. It requires a list of the id's that exist in the current file. Then if I tell PHANTOM.COPY to run using 10 phantoms, it breaks the list up into 10 pieces and does simultaneous copies. So it is not much slower than memresize. The reasoning for this is that memresize creates one overflow portion for every dat portion. And I don't want my 100 gig file to have 43 dats and 43 overflow portions. I want 43 dats and one overflow if I can do it. And PHANTOM.COPY allows me to get that setup. This allows me to figure out what files need resizing too. If I have more than a couple overflow portions, it is time to rebuild the file again. Are you using KEYONLY or KEYDATA for your dynamic files. We have had problems with KEYDATA when we have a keys that have #''s for separators in the key. So for these files, I use KEYONLY. We use all kinds of dynamic files and most are quite large. We are on 7.1 though. So maybe 7.2 has issues. - Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 11:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniData Dynamic File Splitting Question I work with the North Carolina Community College System which supports the 58 NC colleges. We have an unusual dynamic file issue at a couple of the colleges and am hoping someone could provide some insight/direction. OS - Solaris 10 UniData version 7.2.5 (have upgraded a couple of times in the past from 6.1 and 7.1) Colleges have been running Ellucian's Colleague software since 2001 The problems do not seem to be occurring in all dynamic files but where there are issues, there are more than 100 files affected. From timestamps in some of the files, we can see that this has been going on for several years but we are unaware of the issue until the files have split into so many parts that the application can no longer open enough files to read/write the files. Database tools do not show these files as undersized or in overflow2. Guide will show you the many parts if you know what to look for but it is not obvious that the file is fragmented. When we found the issue at the first college we opened a call with Ellucian and was told to resize the files.We had a call to Rocket opened and unfortunately didn't get much further. The Rocket support analyst looked at udtdiags for us and did not find anything out of the ordinary. Rocket identified a couple of potential dynamic file issues at our UniData version and suggested that we upgraded to UniData 7.3. One of the identified issues seemed to apply but it did not explain all issues. We are looking at the UniData upgrade but we likely will still need to address the current file issues. We started resizing files and the files were compressed as expected but soon began splitting again. To 'fix' the files now, we are manually recreating the files, copying data to new files, renaming everything and rebuilding any indices. Long and tedious process but the file seem to behave better, at least so far. Below is a listing of one of the main application files and all its parts. Many of the files have many more parts that the listing below. The splitting occurs with dat,
Re: [U2] [UV] Auto Starting Applications
Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d (depending on Linux)? On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor perry.tay...@zirmed.comwrote: What techniques are you folks using to start up apps when UniVerse on Linux is started? Obviously hooking into uv.rc is an option. Are there others? Thanks. Perry Perry Taylor Senior MV Architect Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Business rules, unknown to business users
My thinking is that while it is a solid idea, it would be an uphill battle at best. There are several challenges. First, how to represent the business rules so that they are clearly communicated to and through non-technical personnel. Second, to ensure that the human readable business rules are stated in such a way as to remain materially compliant to what the code is actually doing without handicapping either. Often times the most efficient way to handle something isn't exactly the most easily translated into human readable terms; an insertion sort for example. That technique in particular also could be grouped into a discussion of practical granularity. Then there's the whole issue of compliance to the standard by a team of developers, as well as compliance to the conceptual issues by the team of non-technical people, and the bridge that must necessarily be in place between the two camps to make it all work out. And finally there is the consideration of what this might cost the business organism in time and hard coin and how to measure the return on that investment. On Fri, Jun 14, 2013 at 4:06 PM, Wjhonson wjhon...@aol.com wrote: Several times I've run into business rules that I find embedded in code, that are so old, that no one can remember why they were implemented or what they could possibly mean to the business. I'm thinking of encoding in some routines, a way to output the rules it's using on a periodic basis (like once a month?) so that business users are made aware of what the rules are, and can therefore comment on what they should be, or what should be removed. Anyone do this? Or have thoughts about what I'm proposing? ___ 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] U2 demos and sample code now on Github
The Colorado Multivalue Users Group usually has a GotoMeeting available; check with Dan Schmitt for connection details. On Thu, May 23, 2013 at 4:48 PM, William Brutzman bi...@hkmetalcraft.comwrote: Dan: Easy for me to say... Perhaps a video stream is possible from there... --Bill On Thu, May 23, 2013 at 2:25 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: For anyone near the Denver area, I'll be doing a hands on demo/tutorial at the upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's Denver office. http://www.eventbrite.com/event/6793013085 Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 22, 2013 9:45 AM To: wjhon...@aol.com; u2-users@listserver.u2ug.org Subject: Re: [U2] U2 demos and sample code now on Github -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: Wjhonson wjhon...@aol.com Sent: Tue, May 21, 2013 8:58 pm Subject: RE: [U2] U2 demos and sample code now on Github Hi, You cannot directly edit our repositories, but this is a 'Fork' button that will create a copy of it in Github under your account name. You can then edit anything there. You can have the system submit patches back by doing a 'Pull Request', which will automatically create an issue on our repositories issue page, along with a request that contains all your changes to us. From this we can review it and choose to accept it back into the Rocket repository. If you are logged into your Github account, each file you view will have an edit button. This allows you to edit the file directly in the browser. If you click this edit button on our repository, it will automatically do the fork for you and save your edits in your forked copy. This is the sort of information I'm planning to explain in the webinar. It is much easier to convey by showing it in action. Regards, Dan ___ 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 -- William J. Brutzman Manager, IT HK MetalCraft Mfg Corp 35 Industrial Road Lodi NJ 07644-2607 973.471.7770 x145 bi...@hkmetalcraft.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] History of Prime Information
Vmark + Unidata = Ardent - Informix - IBM - Rocket, right? On Fri, Apr 26, 2013 at 7:12 PM, David Taylor da...@sysmarkinfo.com wrote: If I'm not mistaken, there was another company in between Vmark and IBM. I believe (and there may have been some smoke and mirrors in all this) that Informatics acquired Ardent and then assigned the CEO of Ardent as the President of Informatics, or something like that, to run both Ardent and Informatics. And then later, IBM acquired Informatics for their database and just inherited Vardent almost by accident. Then, I believe that IBM acquired Unidata and formed the U2 product group. Certainly someone (Suzie) at Rocket could clarify this and perhaps publish an document for historical purposes to document this history completely and accurately. Dave Taylor Sysmark Information Systems, Inc. Prime Computer out of Natick Massachusetts went out of business. One of their products was PR1ME INFORMATION. They were acquired by another computer, Computervision (Thank you Mark, I'd forgotten the name). The product PRIME INFORMATION was acquired by VMark. Vmark was later acquired by Ardent Software. I don't remember if there were any companies in between Ardent and IBM, and while this was going on, there was a separate history happening for Unidata. Net upshot was that IBM acquired both Universe and Unidata, and branded them as U2. Source - my memory, (such as it is). I started playing with PR1ME INFORMATION on a PR1ME 450-II back in 1978. I bought disk drives, controllers, and tape units off and on throughout the years from Computronix, specifically from Randy Styka, which is where I came into this conversation. On 4/26/2013 4:18 PM, Wjhonson wrote: so explain that better and whats the source? -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:58 pm Subject: Re: [U2] TCL input and response logging (AD) I didn't say vmark acquired prime. I said they acquired prime information. (Allen - Sent from my paperweight) On Apr 26, 2013, at 3:07 PM, Wjhonson wjhon...@aol.com wrote: That idea doesn't seem right Allen. I can't find any reference to Vmark acquiring Prime, after Prime's bankruptcy. One reference says that the Prime assets all went to ComputerVision, but it's just a blog Anyone have a newspaper article link ? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:58 am Subject: Re: [U2] TCL input and response logging (AD) I'll have to update the wiki poo pea a pages Who is the woman in this picture? http://en.wikipedia.org/wiki/File:Prime9950_kean.jpg -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:31 am Subject: Re: [U2] TCL input and response logging (AD) Prime Information was a product running as an application on PRIMOS. It was acquired by Vmark and subsequently by Advent if memory serves me correctly. IBM acquired Universe and Unidata and subsequently sold them to Rocket. (Allen - Sent from my paperweight) On Apr 26, 2013, at 1:40 PM, Wjhonson wjhon...@aol.com wrote: I don't think Universe was ever Prime. -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 25, 2013 5:06 pm Subject: Re: [U2] TCL input and response logging (AD) On 4/25/2013 5:36 PM, Randy Styka wrote: Hi! It's been a long time since I posted here but our company, Computronics, has sold a product called PEEK for Unix systems since 1993. It is most often used for remote support, to see what is on someone's screen. And, if needed to send keystrokes as if they were typing them, to help them out or close out programs. But one of the other uses is for logging. PEEK can be set up to fire off a background process when a user logs in. That process is independent of the user, and can run under another id. It can then write a log of either all keystrokes of the user (input only mode) or of input and the resulting output. Since it runs under a different id, the logs can be placed where you want and they can't be modified or accessed by the user being peeked on. If this is of interest, visit http://www.computronics.com and look for information on PEEK. The manuals are there and a free trial is available. Note we are UNIX only (we don't do Windows ;-) If you have questions, email me at ra...@computronics.com. Thanks! Randy ++ | Computronics Randy Styka, ra...@computronics.com
Re: [U2] is this an INDEX ISSUE?
May I presume this is Unidata? Make sure everyone is logged off when the index is rebuilt. On Fri, Apr 12, 2013 at 5:46 PM, david yu d...@yahoo.com wrote: hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] WRITESEQ Error
Al brings up a good point though... Where would one find what error 9 means exactly? I scanned the documentation and didn't see any mention of an error 9 for WRITESEQ or even described in STATUS() which is where a lot of the IO errors show up. On Thu, Apr 11, 2013 at 3:45 PM, Wjhonson wjhon...@aol.com wrote: You're first test is always permissions. Permissions, permissions, I hate them. -Original Message- From: Al DeWitt adew...@stylmark.com To: (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Thu, Apr 11, 2013 2:10 pm Subject: [U2] WRITESEQ Error I have a program that has been working fine until today. The users are now experiencing an error at the following statement #: 508: WRITESEQ RECRD APPEND ON FILEIN ELSE ... at line 508 write error, errno = 9 Can someone tell me what errno 9 is and what my cause it?The file resides on a virtual XP machine that runs a third-party app that reads this file. Thanks. Albert DeWitt, CPIM ___ 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] ODBC Errors 81001/81002
I'm on a client's site today trying to get a working ODBC connection to a Unidata server running 7.1.19. The connection works fine for one request, then from that point on we get either error 81001 or 81002 for about 5 minutes and then it begins to work again. Has anyone else experienced this and possibly found a solution? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ODBC Errors 81001/81002
Please forgive the response to my own post. The problem appears to be the log files that are being created by the UniRPC daemon. The users have a mix of umask settings and this is leaving log files around (millions of 'em) that aren't overwritable due to umask settings. Clearing the log files appears has had very positive results so far. On Mon, Mar 25, 2013 at 10:22 AM, Kevin King ke...@precisonline.com wrote: I'm on a client's site today trying to get a working ODBC connection to a Unidata server running 7.1.19. The connection works fine for one request, then from that point on we get either error 81001 or 81002 for about 5 minutes and then it begins to work again. Has anyone else experienced this and possibly found a solution? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
Good stuff Tony. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
I actually agree with Tony but for a number of different reasons. Sure, there are some who won't go to FB or Twitter or Linked In, and that's perfectly fine, but there are others who will. More importantly, I believe there is value in having the widest swath of distributed information out there for people to find. And while I highly respect TG for all he knows and does, anything that helps him limit his thoughts to a micro- format has some value. :-) (Tony, I hope you know I'm not dissing on you; I just wish I had more time to read and digest every word.) -K On Fri, Mar 15, 2013 at 4:11 PM, Tony Gravagno 3xk547...@sneakemail.comwrote: I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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] FW: Clearing Input Buffer
I would think flushing the input buffer in either location would be sufficient, assuming the problem is as you described. I've seen situations where there's something in the second field, for example, that is data stacking something new and the data stacking from the gun is conflicting with that. If you're confident that's not the case, flushing the input before that third field should suffice. On Fri, Feb 22, 2013 at 12:20 PM, Al DeWitt adew...@stylmark.com wrote: I have an input screen (built with System Builder) where data can either be entered manually or via a barcode scanner. The screen has 3 text boxes for input. The barcode option fills two of the text boxes and is supposed to land on the third box to await input. However, the scanner must be adding an extra return or something because when I scan it the third field's Process After executes. What can I do to flush the input buffer at the end of my validation routine on my second field...or is it better to do this on the Process Before on my third field. It's more of a nuisance but it would look more professional if I could make it clean. Thanks. Albert DeWitt, CPIM ___ 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] AIX 5.3 IBMIHS Web Server
Only one virtual host and I followed these instructions as linked, plus a half dozen other things when this did not work. (I started with these instructions.) On Wed, Feb 20, 2013 at 3:00 PM, Brian Whitehorn brian.whiteh...@tollgroup.com wrote: Kevin, Do you have more than one Virtual Host defined? If so, it would appear that each requires a separate IP to be bound. Not sure if you've already come across this link, but contains some documentation for setting up SSL with IBM HTTP Server: http://www-01.ibm.com/support/docview.wss?uid=swg21179559 HTH. Regards, Brian. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, 21 February 2013 8:35 AM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Where does one get this magical GUI? I wonder, John, if I am unable to procure such an animal if I sent you my key file if you could see if you could nominate a default for me? On Wed, Feb 20, 2013 at 1:58 PM, John Hester jhes...@momtex.com wrote: This would be an IBM support issue rather than Rocket since you're dealing specifically with IHS. You might want to check with the customer to see if they're currently under maintenance. There's a good chance they are if the IHS install was recent because AFAIK you can't even get the installation files without a support login. One other thing you might try is using the iKeyman GUI to create the keystore database rather than the command line utility. That's what I always use. You can run it via an X session, or locally on Windows desktop. I typically create and test a keystore locally on my desktop and copy the kdb file to the server when I'm sure it's working correctly. The iKeyman interface is fairly intuitive, and it's easy to designate a default cert with the click of a button. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, February 19, 2013 6:23 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server I tried checking for a default certificate and it reports null. The KDB file has the GSK certs and my cert - that's it, and when I follow the instructions to set up my cert as the default, it gives me a cryptic I'm sorry Dave, I can't do that kind of message. This is on a customer's system, and they don't have any good paths to contact Rocket, as their vendor is entirely unresponsive which is why they work with us in the first place, and we're not a var. So I post here and hope someone from Rocket is listening. Wally, Kevin, Mike, ... there've been a number of very good Rocket folks helping out here over the years. (Apologies for anyone I missed.) -K On Tue, Feb 19, 2013 at 6:12 PM, John Hester jhes...@momtex.com wrote: I doubt the unqualified listen has any connection. It sounds like something's corrupt in the kdb file. If you only have one cert in the file, you might try removing the SSLServerCert directive altogether. Normally one cert in the database is marked as the default to use when none is specified, and if you only have one, that should be it. I would also create a new kdb file from scratch just to make sure it's clean. If it still won't work after that, I'd suggest opening a case with IBM support if you have a current entitlement. I open cases with them all the time for issues with new software installations, and they're always very responsive. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, February 19, 2013 4:03 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules
Re: [U2] AIX 5.3 IBMIHS Web Server
Where does one get this magical GUI? I wonder, John, if I am unable to procure such an animal if I sent you my key file if you could see if you could nominate a default for me? On Wed, Feb 20, 2013 at 1:58 PM, John Hester jhes...@momtex.com wrote: This would be an IBM support issue rather than Rocket since you're dealing specifically with IHS. You might want to check with the customer to see if they're currently under maintenance. There's a good chance they are if the IHS install was recent because AFAIK you can't even get the installation files without a support login. One other thing you might try is using the iKeyman GUI to create the keystore database rather than the command line utility. That's what I always use. You can run it via an X session, or locally on Windows desktop. I typically create and test a keystore locally on my desktop and copy the kdb file to the server when I'm sure it's working correctly. The iKeyman interface is fairly intuitive, and it's easy to designate a default cert with the click of a button. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, February 19, 2013 6:23 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server I tried checking for a default certificate and it reports null. The KDB file has the GSK certs and my cert - that's it, and when I follow the instructions to set up my cert as the default, it gives me a cryptic I'm sorry Dave, I can't do that kind of message. This is on a customer's system, and they don't have any good paths to contact Rocket, as their vendor is entirely unresponsive which is why they work with us in the first place, and we're not a var. So I post here and hope someone from Rocket is listening. Wally, Kevin, Mike, ... there've been a number of very good Rocket folks helping out here over the years. (Apologies for anyone I missed.) -K On Tue, Feb 19, 2013 at 6:12 PM, John Hester jhes...@momtex.com wrote: I doubt the unqualified listen has any connection. It sounds like something's corrupt in the kdb file. If you only have one cert in the file, you might try removing the SSLServerCert directive altogether. Normally one cert in the database is marked as the default to use when none is specified, and if you only have one, that should be it. I would also create a new kdb file from scratch just to make sure it's clean. If it still won't work after that, I'd suggest opening a case with IBM support if you have a current entitlement. I open cases with them all the time for issues with new software installations, and they're always very responsive. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, February 19, 2013 4:03 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443 Are you getting any errors in the IHS SSL logs, either at server startup or when you attempt to browse to port 443? -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, February 18, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still
Re: [U2] AIX 5.3 IBMIHS Web Server
Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443 Are you getting any errors in the IHS SSL logs, either at server startup or when you attempt to browse to port 443? -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, February 18, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still it just can't find a combination that works. I'm wondering if the problem here is the fact that it's a self-signed cert without a chain? Are you using a self-signed cert here? Do you have other certs in your key file that may represent a chain for the self-signed cert? Thank you gentlemen for the insight. Most appreciated. -K On Mon, Feb 18, 2013 at 3:09 PM, John Hester jhes...@momtex.com wrote: It sounds like you've done all you need to for basic IHS SSL functionality. As long as api.client.com matches the name you gave the certificate via ikeyman, and you have the KeyFile directive, you should be OK. There are a lot of other options you can add for optimization and browser compatibility, but I don't think leaving any of those out would break it outright. Here's my working IHS config from the development server on my Windows workstation for comparison: VirtualHost *:443 SSLEnable SSLProtocolDisable SSLv2 SSLServerCert is12.momtex.com Directory c:/IBM/HTTPServer/htdocs/html Options +Includes AddType text/html .shtml AddOutputFilter INCLUDES .shtml /Directory /VirtualHost KeyFile C:/IBM/HTTPServer/key.kdb SSLDisable -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, February 16, 2013 4:02 PM To: U2 Users List Subject: [U2] AIX 5.3 IBMIHS Web Server Might anyone have any tips or tricks for getting SSL to work on the IBMIHS/Apache 2.0.47 web server on an AIX 5.3 box? The documentation I've found on the web is byzantine at best and it would be fine if the commands actually worked, but I keep getting odd error messages and stalled at every turn. I've upgrade the GSK so that the server will start with SSL enabled, I have a virtual host configured, but I have no clue how to tie a specific certificate to the VirtualHost. Well, let's say I have clues, but nothing is working. Here's the VirtualHost stanza I have set up in httpd.conf: VirtualHost *:443 SSLEnable SSLClientAuth None SSLServerCert api.client.com ServerName api.client.com DocumentRoot /usr/www Directory /usr/www Order Allow,Deny Allow From All /Directory ErrorLog logs/api_error.log CustomLog logs/api_error.log common /VirtualHost I've been able to generate a CSR and create a self-signed certificate, and it would appear that I've even successfully imported that certificate into my key database, as demonstrated by this command: $ gsk7cmd -cert -details -db /usr/IBMIHS/ssl/client.kdb -label api.client.com -pw password ...which produces the following output... Label: api.client.com Key Size: 512 Version: X509 V1 Serial Number: 00 DB 00 41 9A 19 77 7E 9F Issued By: api.client.com CLIENT City, ST, US Subject: api.client.com CLIENT City, ST, US Valid From: Saturday, February 16, 2013 6:06:08 PM EST To: Saturday, April 17, 2032 7:06:08
Re: [U2] AIX 5.3 IBMIHS Web Server
I tried checking for a default certificate and it reports null. The KDB file has the GSK certs and my cert - that's it, and when I follow the instructions to set up my cert as the default, it gives me a cryptic I'm sorry Dave, I can't do that kind of message. This is on a customer's system, and they don't have any good paths to contact Rocket, as their vendor is entirely unresponsive which is why they work with us in the first place, and we're not a var. So I post here and hope someone from Rocket is listening. Wally, Kevin, Mike, ... there've been a number of very good Rocket folks helping out here over the years. (Apologies for anyone I missed.) -K On Tue, Feb 19, 2013 at 6:12 PM, John Hester jhes...@momtex.com wrote: I doubt the unqualified listen has any connection. It sounds like something's corrupt in the kdb file. If you only have one cert in the file, you might try removing the SSLServerCert directive altogether. Normally one cert in the database is marked as the default to use when none is specified, and if you only have one, that should be it. I would also create a new kdb file from scratch just to make sure it's clean. If it still won't work after that, I'd suggest opening a case with IBM support if you have a current entitlement. I open cases with them all the time for issues with new software installations, and they're always very responsive. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, February 19, 2013 4:03 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443 Are you getting any errors in the IHS SSL logs, either at server startup or when you attempt to browse to port 443? -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, February 18, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still it just can't find a combination that works. I'm wondering if the problem here is the fact that it's a self-signed cert without a chain? Are you using a self-signed cert here? Do you have other certs in your key file that may represent a chain for the self-signed cert? Thank you gentlemen for the insight. Most appreciated. -K On Mon, Feb 18, 2013 at 3:09 PM, John Hester jhes...@momtex.com wrote: It sounds like you've done all you need to for basic IHS SSL functionality. As long as api.client.com matches the name you gave the certificate via ikeyman, and you have the KeyFile directive, you should be OK. There are a lot of other options you can add for optimization and browser compatibility, but I don't think leaving any of those out would break it outright. Here's my working IHS config from the development server on my Windows workstation for comparison: VirtualHost *:443 SSLEnable SSLProtocolDisable SSLv2 SSLServerCert is12.momtex.com Directory c:/IBM/HTTPServer/htdocs/html Options +Includes AddType text/html .shtml AddOutputFilter INCLUDES .shtml /Directory /VirtualHost KeyFile C:/IBM/HTTPServer/key.kdb SSLDisable -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent
Re: [U2] AIX 5.3 IBMIHS Web Server
Good thinking Peter, but I've made sure permissions and owner are correct. As to the environment path, I'll have to check that... now that you mention it I don't recall how the key file is integrated into the Apache config. Maybe the problem isn't the key in the file, but perhaps the key file itself? On Tue, Feb 19, 2013 at 8:04 PM, Peter Cheney peter.che...@firstmac.com.auwrote: Perhaps a silly question but it's not something as simple as file permissions or owner/group membership or environment path is it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, 20 February 2013 10:03 To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443 Are you getting any errors in the IHS SSL logs, either at server startup or when you attempt to browse to port 443? -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, February 18, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still it just can't find a combination that works. I'm wondering if the problem here is the fact that it's a self-signed cert without a chain? Are you using a self-signed cert here? Do you have other certs in your key file that may represent a chain for the self-signed cert? Thank you gentlemen for the insight. Most appreciated. -K On Mon, Feb 18, 2013 at 3:09 PM, John Hester jhes...@momtex.com wrote: It sounds like you've done all you need to for basic IHS SSL functionality. As long as api.client.com matches the name you gave the certificate via ikeyman, and you have the KeyFile directive, you should be OK. There are a lot of other options you can add for optimization and browser compatibility, but I don't think leaving any of those out would break it outright. Here's my working IHS config from the development server on my Windows workstation for comparison: VirtualHost *:443 SSLEnable SSLProtocolDisable SSLv2 SSLServerCert is12.momtex.com Directory c:/IBM/HTTPServer/htdocs/html Options +Includes AddType text/html .shtml AddOutputFilter INCLUDES .shtml /Directory /VirtualHost KeyFile C:/IBM/HTTPServer/key.kdb SSLDisable -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, February 16, 2013 4:02 PM To: U2 Users List Subject: [U2] AIX 5.3 IBMIHS Web Server Might anyone have any tips or tricks for getting SSL to work on the IBMIHS/Apache 2.0.47 web server on an AIX 5.3 box? The documentation I've found on the web is byzantine at best and it would be fine if the commands actually worked, but I keep getting odd error messages and stalled at every turn. I've upgrade the GSK so that the server will start with SSL enabled, I have a virtual host configured, but I have no clue how to tie a specific certificate to the VirtualHost. Well, let's say I have clues, but nothing is working. Here's the VirtualHost stanza I have set up in httpd.conf: VirtualHost *:443 SSLEnable SSLClientAuth None SSLServerCert api.client.com ServerName api.client.com
Re: [U2] AIX 5.3 IBMIHS Web Server
John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still it just can't find a combination that works. I'm wondering if the problem here is the fact that it's a self-signed cert without a chain? Are you using a self-signed cert here? Do you have other certs in your key file that may represent a chain for the self-signed cert? Thank you gentlemen for the insight. Most appreciated. -K On Mon, Feb 18, 2013 at 3:09 PM, John Hester jhes...@momtex.com wrote: It sounds like you've done all you need to for basic IHS SSL functionality. As long as api.client.com matches the name you gave the certificate via ikeyman, and you have the KeyFile directive, you should be OK. There are a lot of other options you can add for optimization and browser compatibility, but I don't think leaving any of those out would break it outright. Here's my working IHS config from the development server on my Windows workstation for comparison: VirtualHost *:443 SSLEnable SSLProtocolDisable SSLv2 SSLServerCert is12.momtex.com Directory c:/IBM/HTTPServer/htdocs/html Options +Includes AddType text/html .shtml AddOutputFilter INCLUDES .shtml /Directory /VirtualHost KeyFile C:/IBM/HTTPServer/key.kdb SSLDisable -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, February 16, 2013 4:02 PM To: U2 Users List Subject: [U2] AIX 5.3 IBMIHS Web Server Might anyone have any tips or tricks for getting SSL to work on the IBMIHS/Apache 2.0.47 web server on an AIX 5.3 box? The documentation I've found on the web is byzantine at best and it would be fine if the commands actually worked, but I keep getting odd error messages and stalled at every turn. I've upgrade the GSK so that the server will start with SSL enabled, I have a virtual host configured, but I have no clue how to tie a specific certificate to the VirtualHost. Well, let's say I have clues, but nothing is working. Here's the VirtualHost stanza I have set up in httpd.conf: VirtualHost *:443 SSLEnable SSLClientAuth None SSLServerCert api.client.com ServerName api.client.com DocumentRoot /usr/www Directory /usr/www Order Allow,Deny Allow From All /Directory ErrorLog logs/api_error.log CustomLog logs/api_error.log common /VirtualHost I've been able to generate a CSR and create a self-signed certificate, and it would appear that I've even successfully imported that certificate into my key database, as demonstrated by this command: $ gsk7cmd -cert -details -db /usr/IBMIHS/ssl/client.kdb -label api.client.com -pw password ...which produces the following output... Label: api.client.com Key Size: 512 Version: X509 V1 Serial Number: 00 DB 00 41 9A 19 77 7E 9F Issued By: api.client.com CLIENT City, ST, US Subject: api.client.com CLIENT City, ST, US Valid From: Saturday, February 16, 2013 6:06:08 PM EST To: Saturday, April 17, 2032 7:06:08 PM EDT Fingerprint: ... Signature Algorithm: 1.2.840.113549.1.1.5 Trust Status: enabled But even though this certificate is in the keyfile (and yes, I have a KeyFile directive elsewhere in the httpd.conf file pointing to the client.kdb file) I can't seem to associate it to the virtual host. What am I missing? (And yes, I'm aware this is not specifically a U2 question but I need this to provide web connectivity to a Unidata machine from a Rackspace hosted server. So in a way... it sorta is U2 related.) Help? ___ 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] AIX 5.3 IBMIHS Web Server
Might anyone have any tips or tricks for getting SSL to work on the IBMIHS/Apache 2.0.47 web server on an AIX 5.3 box? The documentation I've found on the web is byzantine at best and it would be fine if the commands actually worked, but I keep getting odd error messages and stalled at every turn. I've upgrade the GSK so that the server will start with SSL enabled, I have a virtual host configured, but I have no clue how to tie a specific certificate to the VirtualHost. Well, let's say I have clues, but nothing is working. Here's the VirtualHost stanza I have set up in httpd.conf: VirtualHost *:443 SSLEnable SSLClientAuth None SSLServerCert api.client.com ServerName api.client.com DocumentRoot /usr/www Directory /usr/www Order Allow,Deny Allow From All /Directory ErrorLog logs/api_error.log CustomLog logs/api_error.log common /VirtualHost I've been able to generate a CSR and create a self-signed certificate, and it would appear that I've even successfully imported that certificate into my key database, as demonstrated by this command: $ gsk7cmd -cert -details -db /usr/IBMIHS/ssl/client.kdb -label api.client.com -pw password ...which produces the following output... Label: api.client.com Key Size: 512 Version: X509 V1 Serial Number: 00 DB 00 41 9A 19 77 7E 9F Issued By: api.client.com CLIENT City, ST, US Subject: api.client.com CLIENT City, ST, US Valid From: Saturday, February 16, 2013 6:06:08 PM EST To: Saturday, April 17, 2032 7:06:08 PM EDT Fingerprint: ... Signature Algorithm: 1.2.840.113549.1.1.5 Trust Status: enabled But even though this certificate is in the keyfile (and yes, I have a KeyFile directive elsewhere in the httpd.conf file pointing to the client.kdb file) I can't seem to associate it to the virtual host. What am I missing? (And yes, I'm aware this is not specifically a U2 question but I need this to provide web connectivity to a Unidata machine from a Rackspace hosted server. So in a way... it sorta is U2 related.) Help? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata submitRequest
This is somewhat described in Submitting a Request on page 62 of the Unidata 7.1 UniBASIC Extensions manual, where it states: *For a POST request with non-empty post_data, the data is attached to the request message as is. No encoding is performed, and any parameters added through addRequestParameter() will be totally ignored. Otherwise the following processing will be performed:* * * *For a POST request with default content type, the parameter string is assembled, a Content-Length header created, and then the string is attached as the last part of the request message.* * * *For a POST request with multipart/* content type, a unique boundary string is created and then multiple parts are generated in the sequence they were added through calling addRequestParameter(). Each will have a unique boundary, followed by optional Content-* headers, and data part. The total length is calculated and a Content-Length header is added to the message header.* Bottom line, use addRequestParameter to add your fields to the POST data and send this parameter into submitRequest as an empty string. Otherwise, if you want to send in something like an XML document that has no particular name associated with the value, put that value here and it will be sent exactly as you put it in there without encoding of any kind (or so the manual suggests). -K On Sat, Feb 9, 2013 at 4:36 PM, Jeffrey Butera jbut...@hampshire.eduwrote: I'm trying my hand at some http interation from within Unidata. I'm unclear about the proper way to POST data as the manual is vague. In short, I'm trying to POST two variables foo and bar to a given url: X.URL = 'http://some.url.com/script.**cgi http://some.url.com/script.cgi ' X.METHOD='POST' X.HANDLE = '' X.RESULT = createRequest(X.URL,X.METHOD,**X.HANDLE) X.TIMEOUT=2000 X.POST.DATA = ?? X.RESULT = submitRequest(X.HANDLE,X.**TIMEOUT,X.POST.DATA,X.** RESPONSE.HEADERS,X.RESPONSE.**DATA,X.HTTP.STATUS) I'm not clear how to properly format the post data - the documentation says it ignores previously set addRequestParameters. I'm guessing X.POST.DATA should be something like: X.POST.DATA = 'foo':@VM:'foo value':@FM:'bar':@VM:'bar value' But that's a complete guess. Thanks, Jeff (thawing from loads of snow) -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
+1. Well stated. On Thursday, February 7, 2013, Woodward, Bob wrote: In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the default locking system of READU. -Original Message- From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto:u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Wjhonson Sent: Thursday, February 07, 2013 3:41 PM To: u2-users@listserver.u2ug.org javascript:; Subject: Re: [U2] Record locks (Unidata 7.2) I wouldn't however *recommend* this approach to locking as the user can never tell if their terminal is waiting on a lock, or just hung in some other odd manner, or perhaps processing a batch of something. So it's rather a nasty trick to play on the user, to just use READU without a LOCKED clause -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com javascript:; To: U2 Users List u2-users@listserver.u2ug.org javascript:; Sent: Thu, Feb 7, 2013 2:43 pm Subject: Re: [U2] Record locks (Unidata 7.2) You're exactly right. The only time you REALLY need the LOCKED clause if there is some need to change that approach. That was what I attempted to show in my first response. I guess I was a bit terse in that one, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto:u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Anthonys Lists Sent: Thursday, February 07, 2013 2:21 PM To: u2-users@listserver.u2ug.org javascript:; Subject: Re: [U2] Record locks (Unidata 7.2) On 07/02/2013 20:46, Jon Wells wrote: What I'm wondering is; what can I put into the 'Xxx what to do if locked' section whereby it waits until the record lock clears, once it clears, set my own lock, read the record, alter the record, and then write the record (which would release my lock)? Somebody will correct me if I'm wrong, but I thought that was exactly what READU did! If you don't provide a LOCKED clause, READU will hang and wait until the lock clears, then read and lock the record. As I say, check the docu and make sure I'm right ... I've never had to bother much with locks ... Cheers, Wol Thank you, Jon Wells ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org javascript:; http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Thanks Wally. You so rock. This customer does have a support contract with an awful provider that does very little, charges very much, and is the antithesis of responsive. That's why they come to me. I don't have any official connections but can usually get them some help within minutes vs. days. Unfortunately, the way the VAR agreements are structured with U2, there's no way they can ever escape the abuse they get from this vendor. On Sat, Jan 19, 2013 at 4:01 PM, Wally Terhune wterh...@rocketsoftware.comwrote: I doubt that your system non-responsiveness is related to UniData record locks. Not sure what you even mean by an 'overflowed lock table'. However, you can look at record locks with a non-documented engineering tool: glm_tool. First menu choice: 1: Show the Map of Locks might be useful. If you just want to see the number of locks held by each UniData process, select 4: More Options for Developer and then 1: transaction table (in this case 'transaction' refers to each udt process - listing udtnos counting from 0 instead of 1 (as you see in listuser output). Does this customer not have a support contract? Have they submitted a udtdiag dump to their support provider while the problem was occuring? regards, Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.com From: u2-users-boun...@listserver.u2ug.org [ u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Saturday, January 19, 2013 12:16 PM To: U2 Users List Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly Usually we can still telnet into AIX. That's how I'm running the stopud/startud. This errpt command is new to me but thanks to everyone for that input; that should be very valuable. I still wish there was some way we could do a LIST.READU from AIX without having to login to udt, like listuser but for locks. I don't know if an overflowed lock table is even remotely related to the problem, but it would be nice to be able to check it without having to get to TCL. -K On Fri, Jan 18, 2013 at 10:49 AM, doug chanco d...@chancofamily.com wrote: That was my question as well, do you telnet or ssh into the box? Once you login su over to root and do errpt -aD this will give you short listing of all the errors aix has logged and consolidates duplicate errors (see below for an example) LABEL: STOK_RCVRY_EXIT Date/Time: Tue Dec 14 15:25:33 Type:TEMP Resource Name: tok0 Description PROBLEM RESOLVED Detail Data FILE NAME line: 273 file: stok_wdt.c SENSE DATA DEVICE ADDRESS 0004 AC62 25F1 My aix sysadmin days are way behind me but I am willing to bet that the company has a aix support contract and you could contact them to help with any errors found. dougc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, January 18, 2013 12:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly On 18/01/13 03:18, Kevin King wrote: Peter, I'm 1200+ miles away from the box. Getting to the console is not an option. To restart, I've been forcing Unidata down with stopud -f and starting it again with startud. Yeah, drastic, I know. But that's why I'm looking for better ways. How do you get to the box to do a stopud/startud? This implies AIX is up and responding. So it shouldn't be too hard to open a remote session at the AIX level to find out what is going wrong. Not that I can advise how to do it ... 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-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] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Usually we can still telnet into AIX. That's how I'm running the stopud/startud. This errpt command is new to me but thanks to everyone for that input; that should be very valuable. I still wish there was some way we could do a LIST.READU from AIX without having to login to udt, like listuser but for locks. I don't know if an overflowed lock table is even remotely related to the problem, but it would be nice to be able to check it without having to get to TCL. -K On Fri, Jan 18, 2013 at 10:49 AM, doug chanco d...@chancofamily.com wrote: That was my question as well, do you telnet or ssh into the box? Once you login su over to root and do errpt -aD this will give you short listing of all the errors aix has logged and consolidates duplicate errors (see below for an example) LABEL: STOK_RCVRY_EXIT Date/Time: Tue Dec 14 15:25:33 Type:TEMP Resource Name: tok0 Description PROBLEM RESOLVED Detail Data FILE NAME line: 273 file: stok_wdt.c SENSE DATA DEVICE ADDRESS 0004 AC62 25F1 My aix sysadmin days are way behind me but I am willing to bet that the company has a aix support contract and you could contact them to help with any errors found. dougc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, January 18, 2013 12:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly On 18/01/13 03:18, Kevin King wrote: Peter, I'm 1200+ miles away from the box. Getting to the console is not an option. To restart, I've been forcing Unidata down with stopud -f and starting it again with startud. Yeah, drastic, I know. But that's why I'm looking for better ways. How do you get to the box to do a stopud/startud? This implies AIX is up and responding. So it shouldn't be too hard to open a remote session at the AIX level to find out what is going wrong. Not that I can advise how to do it ... 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Holy crap, that would have been good information to have 10 years ago. :-) Thanks Jeff for the errpt mention; I always wondering where that stuff was on AIX. On Wed, Jan 16, 2013 at 1:36 PM, Jeff Schasny jscha...@gmail.com wrote: The AIX errpt command reads the system error log. See man errpt for details. That would be a good place to start Kevin King wrote: We have a customer with a box as described in the subject that has recently been experiencing something odd. Overnight, the system will just lock up and stop responding. Normally there isn't anyone doing anything at night; the backup runs, that sort of thing, but then some days when they come in early in the morning the entire machine is unresponsive. Connecting with telnet there is no login prompt, just a blank screen. It happened last night and I've confirmed from the logs that the backup (which is using a split mirror backup strategy) ran successfully and finished at 2:02am. Sometime between then and 4am, when there really should not have been anything going on, it just locked up. Are there any logs that can be enabled on AIX to record some evidence for these kinds of failures so we can figure out what's going on with this machine? -K __**_ 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 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-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Peter, I'm 1200+ miles away from the box. Getting to the console is not an option. To restart, I've been forcing Unidata down with stopud -f and starting it again with startud. Yeah, drastic, I know. But that's why I'm looking for better ways. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
We have a customer with a box as described in the subject that has recently been experiencing something odd. Overnight, the system will just lock up and stop responding. Normally there isn't anyone doing anything at night; the backup runs, that sort of thing, but then some days when they come in early in the morning the entire machine is unresponsive. Connecting with telnet there is no login prompt, just a blank screen. It happened last night and I've confirmed from the logs that the backup (which is using a split mirror backup strategy) ran successfully and finished at 2:02am. Sometime between then and 4am, when there really should not have been anything going on, it just locked up. Are there any logs that can be enabled on AIX to record some evidence for these kinds of failures so we can figure out what's going on with this machine? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
The problem is that the characters for the insert key enable a mode in SBClient that causes things to display as you're seeing. Normally in SB+ the characters are captured and not displayed on the screen, but @ real TCL, the characters are echoed back to SBClient and the mode is enabled. I have not yet discovered the characters to turn off this mode. Shutting down SBClient and restarting seems to be the only option to restore sanity. On Sat, Dec 8, 2012 at 1:38 PM, Stuat Boydell stu...@sbcs.com.au wrote: Have you tried MM RESET.TERM.DEFN at real TCL or /RESET.TERM.DEFN from SB+ On 08/12/12 21:00, u2-users-request@listserver.**u2ug.orgu2-users-requ...@listserver.u2ug.orgwrote: Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://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-users
Re: [U2] Unidata 6.1.15 Oddity
Thank you everyone for the feedback. I had some suspicion in the back of my mind that doing an OCONV MCU on a full mv'd string was a Somewhat Bad Idea, now I know why. :-) On Thu, Nov 8, 2012 at 10:56 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Hi Kevin, Two times in my Unidata career I've had a problem like this where something doesn't work in a subroutine. My work around, both times, was to add a simple line of code at the beginning of the program. Usually just assigning a value to a new, unused, variable like JUNK=JUNK is all it would take. With it, the program would work flawlessly but if I took it back out, or commented it out, the odd behavior returned. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, November 07, 2012 4:26 PM To: U2 Users List Subject: [U2] Unidata 6.1.15 Oddity We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ 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] Unidata 6.1.15 Oddity
We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
TonyG wrote: *Profile your skills as a problem solver who can get qualified people to write code, rather than competing with a million people who can write code but can't solve real world business problems. Sell your understanding of business rules, because this is an area where you excel compared to all of those people who can write code but have no idea what to write.* I know it's difficult to find a position in this economy but from the employer side I can tell you it's been difficult to find people who even acknowledge that the world of technology reaches beyond their current skillset. One of the questions I ask in every interview is what have you learned and applied recently? and yet more times than not I get blank stares instead of a real answer. Well guess what? Nobody is going to pay you to get trained, but do it anyway. There are copious resources available for free or low cost to get started, and once you get started you'll find more stuff to learn with less to invest. Get creative. That's what we've been doing for our employers for years, so why not do it for yourself? Sure, you're tired, there's no time to learn, yada, yada. Do it anyway. Learn or burn. Not that anyone cares, but I have a deal with myself that has served me well for decades. Commit to yourself that any investment in your yourself must come with a payout of a factor of the investment. For me, that factor is 100x. In other words, if I spend $50 on a book I commit to myself to learn enough from that book to earn $5K. If I spend an hour of time learning something, then I commit to finding 100 hours of opportunity to apply what I have learned. Certainly through the years there've been a few duds, but more often than not this has worked splendidly. The key to the whole deal is in committing to execute the payout. If you can't be counted on to pay yourself back for an investment in yourself, why would an employer want to make a similar commitment? I know, I know... preaching to the choir. Or am I? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Accessing an https:// server with callHTTP
Just guessing but I would think that would be from a self-signed certificate without having the local CA cert in the chain. On Sat, Oct 20, 2012 at 5:04 PM, David A. Green dgr...@dagconsulting.comwrote: I get a lot of logging information, maybe you need to bump up the log level. I'm glad you're having success, here is where I'm having an issue: Peer certificate not verified. Reason: 20, unable to get local issuer certificate I'm still researching this one, not sure what a peer certificate is, or how to create one that works. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, October 20, 2012 3:55 PM To: U2 Users List Subject: Re: [U2] Accessing an https:// server with callHTTP I do have the logging enabled, but it doesn't log anything up to the point of the submit request. I finally got it working with some combination of things that as of yet I am uncertain of why it works. But I think it's due to the name of the certificate. Once I named the certificate with a .PEM extension and reloaded the cert, things began working. On Sat, Oct 20, 2012 at 11:38 AM, David A. Green dgr...@dagconsulting.comwrote: Kevin my UniBasic is the client. Have you this line in your code? protocolLogging(_PH_\HTTP.LOG.FILE, ON, 10) it might provide some important clues. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 8:55 PM To: U2 Users List Subject: Re: [U2] Accessing an https:// server with callHTTP David, are you hosting an HTTPS server with this, or is this a client of an HTTPS connection? Just wondering about the 2 in the below context. On Fri, Oct 19, 2012 at 5:36 PM, David A. Green dgr...@dagconsulting.comwrote: I just used this and it worked for me: addCertificate(_PH_\HTTP.CERT, 2, 1, 1, SEC.CONTEXT) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 11:07 AM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ 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-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] Accessing an https:// server with callHTTP
I do have the logging enabled, but it doesn't log anything up to the point of the submit request. I finally got it working with some combination of things that as of yet I am uncertain of why it works. But I think it's due to the name of the certificate. Once I named the certificate with a .PEM extension and reloaded the cert, things began working. On Sat, Oct 20, 2012 at 11:38 AM, David A. Green dgr...@dagconsulting.comwrote: Kevin my UniBasic is the client. Have you this line in your code? protocolLogging(_PH_\HTTP.LOG.FILE, ON, 10) it might provide some important clues. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 8:55 PM To: U2 Users List Subject: Re: [U2] Accessing an https:// server with callHTTP David, are you hosting an HTTPS server with this, or is this a client of an HTTPS connection? Just wondering about the 2 in the below context. On Fri, Oct 19, 2012 at 5:36 PM, David A. Green dgr...@dagconsulting.comwrote: I just used this and it worked for me: addCertificate(_PH_\HTTP.CERT, 2, 1, 1, SEC.CONTEXT) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 11:07 AM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ 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] Accessing an https:// server with callHTTP
Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Accessing an https:// server with callHTTP
I did, but I couldn't get any of the options to change the outcome; it still couldn't find the cert with the relative path, default path, absolute path... nothing. Would love to see some example code of how some of this is to be used, as there are no examples in the docs that I could find. On Fri, Oct 19, 2012 at 2:04 PM, Wolfgang Huettinger w...@campana.comwrote: Did you add addAuthenticationRule() with the option path? See Universe Security Feature manual Page 1-15 and 1-16 http://www.rocketsoftware.com/u2/products/universe/resources/technical-manuals/universe-v11r1/security-v11r1.pdf/view There is also the possibility you have a too high security setting while your certificate does not fulfill that level (like not verified) Wolfgang Huettinger, MSc Math Junior Technical Developer Campana Systems Inc. www.campana.com Office: +1.800.463.2688 x286 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: October-19-12 2:07 PM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This email and any attachments may contain confidential and privileged information which is not subject to public disclosure. For more information about Campana's privacy policy, or to read this email disclaimer in French, read our Privacy Policy at http://www.campana.com/privacy.asp. ___ 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] Accessing an https:// server with callHTTP
What does this mean? *There is also the possibility you have a too high security setting while your certificate does not fulfill that level (like not verified)* It is a Verisign verified certificate. On Fri, Oct 19, 2012 at 2:04 PM, Wolfgang Huettinger w...@campana.comwrote: Did you add addAuthenticationRule() with the option path? See Universe Security Feature manual Page 1-15 and 1-16 http://www.rocketsoftware.com/u2/products/universe/resources/technical-manuals/universe-v11r1/security-v11r1.pdf/view There is also the possibility you have a too high security setting while your certificate does not fulfill that level (like not verified) Wolfgang Huettinger, MSc Math Junior Technical Developer Campana Systems Inc. www.campana.com Office: +1.800.463.2688 x286 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: October-19-12 2:07 PM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This email and any attachments may contain confidential and privileged information which is not subject to public disclosure. For more information about Campana's privacy policy, or to read this email disclaimer in French, read our Privacy Policy at http://www.campana.com/privacy.asp. ___ 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] Accessing an https:// server with callHTTP
I wonder if there's any restriction on the name. Let me try some things. Thanks, David. On Fri, Oct 19, 2012 at 5:36 PM, David A. Green dgr...@dagconsulting.comwrote: I just used this and it worked for me: addCertificate(_PH_\HTTP.CERT, 2, 1, 1, SEC.CONTEXT) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 11:07 AM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ 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] Accessing an https:// server with callHTTP
David, are you hosting an HTTPS server with this, or is this a client of an HTTPS connection? Just wondering about the 2 in the below context. On Fri, Oct 19, 2012 at 5:36 PM, David A. Green dgr...@dagconsulting.comwrote: I just used this and it worked for me: addCertificate(_PH_\HTTP.CERT, 2, 1, 1, SEC.CONTEXT) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, October 19, 2012 11:07 AM To: U2 Users List Subject: [U2] Accessing an https:// server with callHTTP Does anyone have a working sample of communicating with an https server from Unidata 7.1 using callHTTP? We've pulled the certificate and put it on the server, but every time we try to use addCertificate() we get error 2: Certificate file could not be opened or directory does not exist. Must be missing something simple... ___ 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] SSL certificate problems
Unidata 7.1: I have a PEM-formatted certificate in _PH_ called TEST.CERT, with the begin and end comments at the top and bottom of the text. This code cannot find it: CERT.PATH = '_PH_/TEST.CERT' STATUS = analyzeCertificate(CERT.PATH,1,RESULT) CRT STATUS This is a second attempt at trying to figure out what Unidata is expecting so that I can make a https call, and the status continues to be returned as 2, described in the docs as Failed to open cert file.. The permissions on the file are wide open, and the cert looks like this (abbreviated): -BEGIN CERTIFICATE- MIIF7DCCBNSgAwIBAgIQbsx6pacDIAm4zrz06VLUkTANBgkqhkiG9w0BAQUFADCB yjELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQL ... W+yzf5VK+wPIrSbb5mZ4EkrZn0L74ZjmQoObj49nJOhhGbXdzbULJgWOw27EyHW4 Rs/iGAZeqa6ogZpHFt4MKGwlJ7net4RYxh84HqTEy2Y= -END CERTIFICATE- I figure I'm missing something obvious, but the documentation isn't helping me see it. Ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SSL certificate problems
Correction: analyzeCertificate returns a status of 1. It's the addCertificate that's returning a status of 2. In either case they mean the same thing - the certificate cannot be found. On Fri, Oct 19, 2012 at 11:08 PM, Kevin King ke...@precisonline.com wrote: Unidata 7.1: I have a PEM-formatted certificate in _PH_ called TEST.CERT, with the begin and end comments at the top and bottom of the text. This code cannot find it: CERT.PATH = '_PH_/TEST.CERT' STATUS = analyzeCertificate(CERT.PATH,1,RESULT) CRT STATUS This is a second attempt at trying to figure out what Unidata is expecting so that I can make a https call, and the status continues to be returned as 2, described in the docs as Failed to open cert file.. The permissions on the file are wide open, and the cert looks like this (abbreviated): -BEGIN CERTIFICATE- MIIF7DCCBNSgAwIBAgIQbsx6pacDIAm4zrz06VLUkTANBgkqhkiG9w0BAQUFADCB yjELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQL ... W+yzf5VK+wPIrSbb5mZ4EkrZn0L74ZjmQoObj49nJOhhGbXdzbULJgWOw27EyHW4 Rs/iGAZeqa6ogZpHFt4MKGwlJ7net4RYxh84HqTEy2Y= -END CERTIFICATE- I figure I'm missing something obvious, but the documentation isn't helping me see it. Ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SSL certificate problems
Well, one mystery solved. If the file name ends in .PEM, the below code will show information about the cert. The addCertificate (in another thread) still does not find the certificate, even named with a PEM or pem extension. On Fri, Oct 19, 2012 at 11:11 PM, Kevin King ke...@precisonline.com wrote: Correction: analyzeCertificate returns a status of 1. It's the addCertificate that's returning a status of 2. In either case they mean the same thing - the certificate cannot be found. On Fri, Oct 19, 2012 at 11:08 PM, Kevin King ke...@precisonline.comwrote: Unidata 7.1: I have a PEM-formatted certificate in _PH_ called TEST.CERT, with the begin and end comments at the top and bottom of the text. This code cannot find it: CERT.PATH = '_PH_/TEST.CERT' STATUS = analyzeCertificate(CERT.PATH,1,RESULT) CRT STATUS This is a second attempt at trying to figure out what Unidata is expecting so that I can make a https call, and the status continues to be returned as 2, described in the docs as Failed to open cert file.. The permissions on the file are wide open, and the cert looks like this (abbreviated): -BEGIN CERTIFICATE- MIIF7DCCBNSgAwIBAgIQbsx6pacDIAm4zrz06VLUkTANBgkqhkiG9w0BAQUFADCB yjELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQL ... W+yzf5VK+wPIrSbb5mZ4EkrZn0L74ZjmQoObj49nJOhhGbXdzbULJgWOw27EyHW4 Rs/iGAZeqa6ogZpHFt4MKGwlJ7net4RYxh84HqTEy2Y= -END CERTIFICATE- I figure I'm missing something obvious, but the documentation isn't helping me see it. Ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Speeding sort
I can't say definitively, but I would expect the answer to be 'no'. On Thu, Oct 18, 2012 at 6:39 AM, Jeffrey Butera jbut...@hampshire.eduwrote: Stupid question of the day on unidata 7.2.x I build indexes all over to speed queries - I have plenty of disk to burn. However does having an index help when sorting on a field that's not part of the selection criteria? For example we often do this dance between two files: SELECT FILE WITH FIELD='VALUE' SAVING UNIQUE SOME_KEY NO.NULLS SELECT ANOTHER_FILE BY SORT_FIELD I know indexing FIELD helps the first question, but does having an index on SORT_FIELD help the second? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/**hampshirecollegeithttp://www.facebook.com/hampshirecollegeit __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://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-users
Re: [U2] [UD] Odd question re: 7.1 docs (Unclassified)
Ah, makes sense. Thanks! On Fri, Oct 5, 2012 at 6:20 AM, Wally Terhune wterh...@rocketsoftware.comwrote: Most often we don't really know if customers rely on a particular behavior in the product. When UniData has behaved in a particular manner for many years, we hesitate to just change the behavior in some cases. We have been surprised more than once when we did change behavior without providing an option and found that customers had coded around the product behavior and had their application 'break' upon upgrading to a new UniData release. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, October 04, 2012 8:45 PM To: U2 Users List Subject: Re: [U2] [UD] Odd question re: 7.1 docs (Unclassified) At a guess, an important customer relies on the behaviour that the option turns off and lost the argument about whether this was a feature-not-a-bug rather than a bug-not-a-feature Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 5 October 2012 3:19 p.m. To: U2 Users List Subject: [U2] [UD] Odd question re: 7.1 docs I just found this in the UDT.OPTIONS manual... If UDT.OPTIONS 107 is off, UniData returns incorrect multivalues from the target file. Here's my question. With that description in mind, why would anyone want this to be off? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ 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] [UD] Odd question re: 7.1 docs
I just found this in the UDT.OPTIONS manual... If UDT.OPTIONS 107 is off, UniData returns incorrect multivalues from the target file. Here's my question. With that description in mind, why would anyone want this to be off? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and data-stacking
Rather than data stacking, can you do this: EXECUTE 'SB.LOGIN user,password,terminal' Where the lower case stuff is the appropriate user, password, and term type? On Wed, Sep 26, 2012 at 8:23 PM, Susan Joslyn sjos...@sjplus.com wrote: Hi geniuses! I know that in Unidata there is a udt options flag that allows data-stacking to work. I can't find anything similar in Universe. But even if I could, my problem seems to run a little deeper than that. I can write a test program that data stacks two pieces of info into another program that has two input commands. No problem, that works. But if I try to CHAIN or EXECUTE SB.LOGIN datastacking the user ID and password it fails. But get this - it succeeds in some of the accounts (universe directory accounts) but fails in others. Is there something about the accounts, the flavor, some setting that would prevent a datastack from making it -- maybe because it is a chained command? I tried it with EXECUTE, no difference. Anyone run into something like this? Anyone who is an SB+ user might suggest that I use the AUTOLOGIN option, but that doesn't change the behavior at all. It still makes me login, still won't take the data stack. I am not well-versed at administrative commands that might tell me things about the account settings and flavor and tunable parameters - so if there is something obvious I could look at, don't assume that I know it. Any and all help, as always, greatly appreciated! Susan ___ 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] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:43 AM To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 04y!LlOoL8USVGrPZehFfPKcPPmbfFPdrr1lqOECv!Swg== 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
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.comwrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:43 AM To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com wrote: And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.com wrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:43 AM To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2