Re: [U2] Web services at 11.x
Consuming webservices from the outside world is relatively trivial in UV 11 (and 10.x). Look in the Basic Extensions manual for details. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, May 13, 2014 10:11 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dynamic connect
Sounds like a UAC issue. A lot of applications try to store their settings/config/.ini files in their program directory (i.e. c:\program files\application\, where application is the directory the application uses). In Windows 7, UAC wants to redirect those to the users %APPDATA% directory (e.g. \users\username\AppData\Roaming\application). There are a couple of ways to address this: 1) Change the start in location in the application's properties (right click on the icon, and select properties) to start in %APPDATA%\application (where application is the directory referenced above). 2) If you have local admin rights on the computer, you can copy the settings/config/.ini file to the \program files\application directory. Hope this helps. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley Sent: Monday, April 21, 2014 3:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] dynamic connect I have a customer who just upgraded all workstations to windows7. I installed dynamic connect to replace their uvterm. Under SETUP I made them VT100 set up the scripts and folders, (all default directories), and saved session1.dcs. I had to SET the numeric keypad and have saved the numeric keypad, and the session. Whenever a user logs in the numeric keypad has reverted to escape sequences. They can reload the one I saved, but should not have to do that. Has anybody encountered this and figured it out? -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/dynamic-connect-tp42970.htm l 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
Re: [U2] Ref: Web Services at Universe 11.n
Consuming web services from U2 is really not that difficult. I've done both SOAP and RESTful transactions via both secure (HTTPS) and insecure (HTTP) connections. Some examples of the web services I've consumed from within U2 are: 1) UPS and FedEx package tracking services 2) Credit card authorization 3) Address validation and correction 4) Address geocoding using the Google maps API Protocol logging is your friend. It will log the complete transaction in a text file that you can review to see specifically where your errors are. Also, don't forget that if you're going to do secure transactions via HTTPS, you need to create a Security Context. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, October 31, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] Ref: Web Services at Universe 11.n Hi Rudy: We're not using any web services at present - but we'd like to. (Basically I'm a beginner at this and trying to learn what is possible.) We need to interface our current jail system with a new RMS that is coming in, and the vendors of it prefer web services interfaces. So that's why. Unlike you, our underlying O/S is a form of unix - hpux actually - not Windows. Unfortunately, I don't know anything about WSD on unix. You notice Richard used curl and was happy with it, but right now that is not available on our hpux system. There is a download available where we can get curl along with some other web tools, but my system admin is not particularly enthusiastic about that idea. Richard: When you use curl, are you running on windows or unix (or something else)? Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 31, 2013 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Ref: Web Services at Universe 11.n Could you give an example of web services you are actually using and why? -Original Message- From: Cooper, Rudy rudy.coo...@sagepub.com To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Thu, Oct 31, 2013 1:18 pm Subject: [U2] Ref: Web Services at Universe 11.n Harold, We’re on a windows platform and we’ve doing web services with UV since 10.2. Use the WSD for creating the soap server and and use soapui (free) for testing. We access external services from UV using the soap api that is documented in basicext.pdf of the uv documentation. The documentation from Rocket for your release, IBM U2 Web Services Developer, is very good. rudy Date: Wed, 30 Oct 2013 12:00:40 -0700 From: Oaks, Harold harold.o...@clark.wa.govmailto:harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n Message-ID: e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.localmailto:e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.local Content-Type: text/plain; charset=us-ascii I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. Rudy Cooper Lead Applications Developer Sage Publications Inc. 2455 Teller Road Thousand Oaks, Ca. 91320 USA T:805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors societies Please consider the environment before printing this email Are you a fan of SAGE? Show us at www.facebook.com/SAGEPublicationshttp://www.facebook.com/SAGEPublications. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list
Re: [U2] Web Services at Universe 11.n
Look in the UniVerse Basic Extensions manual at the Simple Object Access Protocol (SOAP) chapter. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, October 30, 2013 12:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Support Ticket Software
http://www.salesforce.com/remedyforce/features/ Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, October 23, 2013 8:47 AM To: U2 Users List Subject: Re: [U2] [OT] Support Ticket Software Hi Symeon, I had looked at salesforce and it wasn't really intuitive that they had a support ticket system. I think they are the one, though. The reason I was curious is that BigCommerce said that under the new system they sprung on us unannounced over the weekend, we could enter support tickets, but not look up or view tickets we'd submitted. I thought that was rather strange. I've never used a system before where I couldn't view my tickets. The old system they used allowed viewing of tickets, and responding either via email or online. It's just one more capability BC has taken away - and to think I moved away from Intuit for doing that very same thing... Thanks, Charlie On 10-23-2013 2:14 AM, Symeon Breen wrote: The secure server at force.com , e.g. secure.force.com ? which would be salesforce - and they do have ticketing software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 23 October 2013 03:55 To: U2 Users List Subject: [U2] [OT] Support Ticket Software My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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] Slow list traffic
For those who have been reporting issues receiving mail from the list recently, I believe we have corrected the issue. An automatic update broke our DNS server so that it would not respond to Reverse DNS queries. Since many of the large ISPs (including AOL, Comcast, etc) use rDNS queries to validate senders, they were rejecting mail from the list. The DNS server has been patched, and emails should be going out successfully to all subscribers now. Larry Hiscock Moderator ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exchanging XML data instead of JSON between hosts via RESTful Server
code
{batchRequests: {BatchRequest: {referenceNumber:
f549c4dd-01f4-4b9b-99e2-6dd6862cf364,serviceRequest: {SERVICE:
{-name:VALID.POST.CODE,PORTAL_USER_ID: testuser,POSTCODE:
4300,SUBURB: GOODNA} /code
Curious why you're mixing XML JSON in your converted example?
Shouldn't that read:
{code:
{batchRequests:
{BatchRequest:
{referenceNumber: f549c4dd-01f4-4b9b-99e2-6dd6862cf364,
serviceRequest:
{SERVICE:
{-name:VALID.POST.CODE,
PORTAL_USER_ID: testuser,
POSTCODE: 4300,
SUBURB: GOODNA}
}
}
}
}
}
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Wednesday, August 21, 2013 12:30 AM
To: 'U2 Users List' [u2-users@listserver.u2ug.org]
Subject: [U2] Exchanging XML data instead of JSON between hosts via RESTful
Server
Hi Everyone,
Is it possible to configure a RESTful service subroutine to accept XML as
the input to one of its defined parameters?
I keep getting the following error:
500:
Expected+a+','+or+'}'com.rs.u2.u2rest.marshaller.U2JSONTokenizer@13c33b7
The subroutine has 2 parameters XML.IN in Position 1 and XML.OUT in Position
2. Each type is set to string.
Normally this program is used elsewhere in our other services so it is
already XML ready.
I've converted my test xml to json and tried that. While the error
disappears the response while valid xml (output from the program) is
otherwise empty. (I changed the type from string to json too).
If I key in any random string I get the same valid yet empty program
response.
So how do I configure the server to pass this xml string straight to the
subroutine?
Perhaps I need to convert some of the characters (e.g. '/' in the xml below
as per uri requirements?
Is it possible or am I way off course here?
Sample xml:
code
batchRequestsBatchRequestreferenceNumberf549c4dd-01f4-4b9b-99e2-6dd686
2cf364/referenceNumberserviceRequestSERVICE
name=VALID.POST.CODEPORTAL_USER_IDtestuser/PORTAL_USER_IDPOSTCODE43
00/POSTCODESUBURBGOODNA/SUBURB/SERVICE/serviceRequest/BatchReques
t/batchRequests
/code
Converted to json:
code
{batchRequests: {BatchRequest: {referenceNumber:
f549c4dd-01f4-4b9b-99e2-6dd6862cf364,serviceRequest: {SERVICE:
{-name:VALID.POST.CODE,PORTAL_USER_ID: testuser,POSTCODE:
4300,SUBURB: GOODNA} /code
Many thanks in advance.
Cheers
Peter
[Description: Description:
https://www.firstmac.com.au]http://www.firstmac.com.au/
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.aumailto:peter.che...@firstmac.com.au | w
www.firstmac.com.auhttps://www.www.firstmac.com.au/
---
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] [UV] Globally catalogs - source code
If you ED the CATDIR or GLOBAL.CATDIR file, just type a ^ to put ED into view non-printable characters mode. Then the path to the program is on the last line. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, August 20, 2013 7:07 PM To: U2 Users List Subject: [U2] [UV] Globally catalogs - source code We are running UV on AIX We have some programs that have been globally catalogued - they are visible in the GLOBAL.CATDIR file. I am aware some are system commands but a number are programs we have globally catalogued as (shown as *ProgName). Any tips on the best way to find which program library the source code resides in? Buried in the GLOBAL.CATDIR record, along with all the compiled code 'junk' I can see the path but viewing (via a CT or ED) it is not user friendly as the 'junk' will often crash/lock the screen. Regards, Brendon Information Services Spotless Services Australia Limited T: 03 9269 7738 M: 0419 349122 F: 03 8399 7013 E-mail brendon.lever...@spotless.com.au W www.spotless.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] OPENSEQ
I could be wrong, but I seem to recall that OPENSEQ supports two syntaxes Option 1 has 2 arguments: openseq voc.pointer, filename to ... Option 2 has only 1 argument: openseq absolute.path.to.filename to ... Also, if the server where your shared folder resides is not Windows, then filenames will be case sensitive. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Monday, August 05, 2013 6:10 AM To: (u2-users@listserver.u2ug.org) Subject: [U2] OPENSEQ 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] What is true
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
Re: [U2] U2 List Changes?
Bill, Your subscription is set to receive copies of your own posts, but it's also set to avoid duplicates. This means if you copy yourself on the original post, you'll only see your direct copy, and won't see a copy from the list. If you're not copying yourself, and you're still not seeing your own posts, I'd suggest checking your mail server to make sure your posts aren't getting filtered. Sometimes spam filters will reject incoming mail with a from address of an inside email address (i.e. your address) that did not originate on your mail server. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Tuesday, July 23, 2013 9:23 AM To: U2 Users List Subject: [U2] U2 List Changes? I posted two things... but did not see my own posts. Do I only see my own posts now if someone responds? Please let me know. --Bill Brutzman ___ 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] CentOS with Universe?
We use CentOS for our Linux web servers, and for most of our customers. CentOS is RHEL. It's compiled from the RedHat sources, which are freely available. The only changes the CentOS team makes is the logos. If it will run on RHEL, it will run on CentOS. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Wednesday, July 17, 2013 6:42 AM To: U2 Users List Subject: [U2] CentOS with Universe? We have a VAR who would prefer to load Universe and their application on a supported platform, but we would prefer not to pay for RHEL 6. I searched the list and found a few tidbits, but does anyone have a good list of what changes might be required to successfully run Universe 11.1 on CentOS? How much pain would we be introducing for ourselves and our VAR, if they were willing to play along? Thanks. --dawn -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [way ot] - Electronic Button Purshers?
It's called a solenoid, and you can probably find one at your local electronics store... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 03, 2013 8:32 AM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? Just had a thought. Might be able to do this with a rod attached to a magnet, And then energize and create a like poled magnetic field which would push The other magnet away - connected together with a spring to pull it back When the eletro magnet gets deenergized. Hmmm. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 03, 2013 11:25 AM To: U2 Users Subject: [U2] [way ot] - Electronic Button Purshers? OK. I'm trying to use a Raspberry pi to push a button, but only want to use one GPIO port. Basically, I'm trying to get the pi to turn a device on or off - and can't easily get to Where the button on the device's board is at to have the pi trigger with a relay, So I plan to mount the device, and have something just push the button directly. Do they make a device that when energized, will push a rod out then back? Right now, my only option (maybe not only), would be to create a Scotch Yoke http://en.wikipedia.org/wiki/Scotch_yoke But for space contraints, and ease, I'd rather put in something that would do That as it's primary function. George ___ 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] History of Prime Information
If I recall correctly (and I may not ;-), Ardent was the company behind UniData. Ardent and VMark merged (or Ardent acquired VMark -- I'm not 100% clear on the details), and retained the Ardent name. Ardent was subsequently acquired by Informix, which was acquired by IBM, which later sold the U2 division to Rocket Software. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Taylor Sent: Friday, April 26, 2013 6:13 PM To: U2 Users List Subject: Re: [U2] History of Prime Information 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
Re: [U2] Selection Suggestions for using UV instead of SQL
select registration with EID = '1' saving unique PID to 1 select people to 2 merge.list 2 diff 1 Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 6:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George ___ 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] Consuming web services
There are a whole suite of BASIC verbs and functions for consuming web services, like SOAPCreateRequest, SOAPSubmitRequest, etc. It's not a terribly difficult thing to implement a web service consumer. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, October 03, 2012 1:56 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Consuming web services I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MATREAD vs MATPARSE
You don't need to do the matbuild/write, you could simply do a MATWRITE MATRECORD TO F.FILE,KEY Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, July 30, 2012 8:52 AM To: U2-Users@listserver.u2ug.org Subject: [U2] MATREAD vs MATPARSE I'm experimenting with dimension arrays in general and have a question. I have a file with variable length records. To take advantage of the performance of dimension arrays, is this the most effective logic? READ RECORD FROM F.FILE,KEY ELSE ... ATT.CNT = DCOUNT(RECORD,@AM) DIM MATRECORD(ATT.CNT) MATPARSE MATRECORD FROM RECORD,@AM update MATRECORD logic, which there is substantial MATBUILD RECORD FROM MATRECORD USING @AM WRITE RECORD TO F.FILE,KEY Sincerely, David Laansma IT Manager Hubbard Supply Co. ___ 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] Mailing list delays
I received it within 1 minute after you sent it... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 12:09 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Mailing list delays Is anyone else having 1+ hour delays when posting responses to this list? Almost all of my replies are delayed (I'm sending this at 1:09pm for reference) ___ 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] Problem running script from crontab
Do you have LOGIN paragraph in your VOC file? If you do, make sure you test @USER.TYPE and bypass anything that might require a prompt. We run a dozen different cron jobs multiple times per day on SCO UD 6. 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_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 9:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
LOL ... what can I say. It's an older system that hasn't been updated in a while. We have a RedHat upgrade planned somewhere out on the horizon, but in this economy? Ptt... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, June 28, 2012 11:38 AM To: U2 Users List Subject: Re: [U2] Problem running script from crontab SCO!? Bill - Original Message - *From:* lar...@wcs-corp.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 6/28/2012 10:27 AM *Subject:* Re: [U2] Problem running script from crontab Do you have LOGIN paragraph in your VOC file? If you do, make sure you test @USER.TYPE and bypass anything that might require a prompt. We run a dozen different cron jobs multiple times per day on SCO UD 6. 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_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 9:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
In the LOCKED clause of your READU/MATREADU statement, STATUS() will contain the UID of the user locking the record. The GETREADU() function will return a dynamic array of all record locks held by the system, similar to the LIST.READU TCL command. e.g.: :LIST.READU UNO UNBR UID UNAME TTY FILENAME INBR DNBR RECORD_ID M TIME DATE 1 21776 200 larry ttyp0 /u/MA.IN 23074 299 187740 X 14:28:47 Apr 30 GETREADU() returns: 1}21776}200}larryh}ttyp0}/u/MA.INFO/CUST.MST}23074}299}187740}X}14:30:58}Apr 30 2012 STATUS() in the LOCKED clause of a READU would return the UID, which is 200 (the 3rd element in the array, i.e. arrayx,3). You could loop through the array to find an entry where the UID matches your STATUS() value, and the RECORD_ID (arrayx,9) matches the key you're trying to read. You could also check the file name (arrayx,6) for good measure. Once you've found the right line, arrayx,4 contains the user name, and arrayx,5 contains the tty they're logged in on (which may be less than helpful in a telnet/ssh environment). Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andy Krause Sent: Monday, April 30, 2012 1:55 PM To: U2 Users List Subject: [U2] User ID of a LOCKED record I am trying to notify a user of a locked record so they can ask the person locking that record to GET OUT. Is there a simple way to retrieve the user ID given the port number in a BASIC program? The only method I have found is to call !GET.USERS and then loop through the USER.INFO param comparing port numbers until I find the user and pull their user ID from there. Thanks in advance. Andy Krause ___ 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] The CONTINUE statement
Please don't feed the troll -- you'll only encourage it to come back for more. If we don't restore a modicum of civility to this list, we will be forced to judiciously apply the moderator tools at our disposal... Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Wilson Sent: Thursday, April 26, 2012 3:25 PM To: U2 Users List Subject: Re: [U2] The CONTINUE statement Some of you are PATHETIC - needing to pat your own back - wtf From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Thursday, April 26, 2012 6:19 PM Subject: Re: [U2] The CONTINUE statement You're trying to make me form an argument, and that was not my intention at all. Merely to present two contrasting forms of programming to solicit opinion. I have no argument. (Hell freezes over) -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 3:17 pm Subject: Re: [U2] The CONTINUE statement Why... even Joey Buttafucco has got better polemics... --Bill -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Thursday, April 26, 2012 5:59 PM ubject: Re: [U2] The CONTINUE statement he point is versus, compare and contrast, opine, pontificate, soapbox, et etera __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Case Statement with only two cases... or for that matter... one case
Dennis, You didn't mention if you're on UV or UD, but the FORMAT command in AE (in UD) has options for margin and indent. You can do FORMAT -M0 -I2 to get the format you specified. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Saturday, April 21, 2012 4:06 PM To: U2 Users List Subject: Re: [U2] Case Statement with only two cases... or for that matter... one case @Mecki.. What is your editor of choice, ie can you get it to indent 1 space? I've always been a standard FORMAT in ED fella, but the site I've just joined doesn't want that, code must start right up against the edge, have 2 space indenting.. So hard to not instinctively FORMAT, equally hard to find that missing 'END' when I can't simply format, since the code structure looks so foreign squashed up. Thanks Dennis On Apr 22, 2012 6:50 AM, Mecki Foerthmann mec...@gmx.net wrote: Well, I prefer: IF A = TEST THEN GOSUB DO.SOMETHING ;* Say why END ELSE GOSUB DO.SOMETHING.ELSE ;* The reason END IMO much more readable - because you see immediately that is is a conditional branching. It is also easier maintainable if you want to add some more code later or you need more conditions and want to change branching into case. And of course it will auto-indent correctly in my editor of choice ;-). On 20/04/2012 23:05, Kate Stanton wrote: Rather than: BEGIN CASE CASE A = TEST; GOSUB DO.SOMETHING CASE 1; GOSUB DO.SOMETHING.ELSE END CASE or IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE I prefer: IF A = TEST THEN GOSUB DO.SOMETHING ;* Say why ELSE GOSUB DO.SOMETHING.ELSE ;* The reason lining up the GOSUBs under each other, with comment making it clear why. __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserv er.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] u2ug.net Website
We also host the DNS for u2ug.org, so I can easily repoint www.u2ug.org anywhere you'd like, while keeping listserver.u2ug.org pointed to our listserver. What say you? --Larry Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, April 04, 2012 12:41 AM To: U2 Users List Subject: Re: [U2] u2ug.net Website Colin The u2ug.org web was redirecting to my old hosted provider, which I no longer use. The change to a new provider - with more capacity - is one step towards rewriting the site (finally), itself part of a very exciting set of proposals the board are putting together for the direction in which we wish to be taking the group. We will be putting out a release over the next few weeks to the members to outline our strategy, and I have to say personally I think its a great direction that David J has encouraged and that will make the group genuinely more useful to all its members. Thats the teaser, now you're all going to have to wait - ha, ha! Now the complication is (isnt there always?) that u2ug.org domain is owned by one of our members who very kindly looks after this email list. There are no plans to change the list, and so we keep that name for email. At some point I hope he will also redirect the web traffic to the new site so it remains consistent, it just hasn't happened yet. Brian Sent from my iPad On 4 Apr 2012, at 00:22, Colin Alfke alfke...@hotmail.com wrote: Yeah, I thought .org redirected to .net at one point. I did ask in the website forum about email (as it's still using .org). I tried to ask Laura Hirsch why the change was made but was having trouble with my email and I don't think the question ever got out. Brian, if it's supposed to redirect - it's not doing it now. Today's been a good day, but we have a snowfall warning so it may change Colin -Original Message- From: Bill Haskett Sent: April 3, 2012 3:55 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website Colin: The domain was changed from u2ug.org to u2ug.net. I think the .org was going to Brian's IP address and is the one that doesn't work. Not sure why they changed the domain. Sometimes we all have days like these. :-( Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2ug.net Website
FYI - AngelicHost.net is a wholly owned subsidiary of Western Computer Services. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, April 04, 2012 11:24 AM To: 'U2 Users List' Subject: Re: [U2] u2ug.net Website We also host the DNS for u2ug.org, so I can easily repoint www.u2ug.org anywhere you'd like, while keeping listserver.u2ug.org pointed to our listserver. What say you? --Larry Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, April 04, 2012 12:41 AM To: U2 Users List Subject: Re: [U2] u2ug.net Website Colin The u2ug.org web was redirecting to my old hosted provider, which I no longer use. The change to a new provider - with more capacity - is one step towards rewriting the site (finally), itself part of a very exciting set of proposals the board are putting together for the direction in which we wish to be taking the group. We will be putting out a release over the next few weeks to the members to outline our strategy, and I have to say personally I think its a great direction that David J has encouraged and that will make the group genuinely more useful to all its members. Thats the teaser, now you're all going to have to wait - ha, ha! Now the complication is (isnt there always?) that u2ug.org domain is owned by one of our members who very kindly looks after this email list. There are no plans to change the list, and so we keep that name for email. At some point I hope he will also redirect the web traffic to the new site so it remains consistent, it just hasn't happened yet. Brian Sent from my iPad On 4 Apr 2012, at 00:22, Colin Alfke alfke...@hotmail.com wrote: Yeah, I thought .org redirected to .net at one point. I did ask in the website forum about email (as it's still using .org). I tried to ask Laura Hirsch why the change was made but was having trouble with my email and I don't think the question ever got out. Brian, if it's supposed to redirect - it's not doing it now. Today's been a good day, but we have a snowfall warning so it may change Colin -Original Message- From: Bill Haskett Sent: April 3, 2012 3:55 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website Colin: The domain was changed from u2ug.org to u2ug.net. I think the .org was going to Brian's IP address and is the one that doesn't work. Not sure why they changed the domain. Sometimes we all have days like these. :-( Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2ug.net Website
In the meantime, I've added a rewrite rule to redirect www.u2ug.org to www.u2ug.net --Larry Larry Hiscock AngelicHost Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Wednesday, April 04, 2012 11:27 AM To: U2 Users List Subject: Re: [U2] u2ug.net Website This may be more about name resolution than you ever wanted to know, but here goes anyway... (knowledge is always a good thing). Sorry for the long post, domain name resolution is often misunderstood (kind of like people referring to somename.com as a top level domain or TLD - it's not, it's a 2nd level domain. The TLD is com.) The SOA nameservers in question are controlled by angelichost.net not Network Solutions (unless NS has some connection to Angelic I'm unaware of which is entirely possible). The only authoritative nameservers for the domain are ns9 and ns10 on angelichost.net's network. Anything else would have to be caching. Name resolution is hierarchical and works from right to left... ORG, U2UG.ORG, etc... The reason it works from anywhere is when you type it in locally, it will go to the one of the 13 root nameservers, aka (letter a-m).root-servers.net, (run by Verisign/Network Solutions and MANY others including NASA, DOD, Cogent, etc.) if not in cache based on the TLD in this case .ORG, it will then ask for the nameservers for the next level (U2UG.ORG in this case). In this case it will get ns9/ns10.angelichost.net. Root nameservers do not contain the zone records for the hosts themselves only the nameservers that are authoritative. It could keep going based on the break up of the domains. You can see this in action if you like... Here's part of the query for www.u2ug.org to a.root-servers.net: Default server: a.root-servers.net Address: 2001:503:ba3e::2:30#53 set q=any www.u2ug.org Server: a.root-servers.net Address:198.41.0.4#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer Authoritative answers can be found from: org nameserver = a0.org.afilias-nst.info. org nameserver = b0.org.afilias-nst.org. (clipped) Note how it says it cannot answer authoritatively, and points to the next level... Next I set the server to the 1st in the list from the root server Default server: a0.org.afilias-nst.info Address: 2001:500:e::1#53 www.u2ug.org Server: a0.org.afilias-nst.info Address:199.19.56.1#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer set q=any www.u2ug.org Server: a0.org.afilias-nst.info Address:199.19.56.1#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer Authoritative answers can be found from: u2ug.orgnameserver = ns9.angelichost.net. u2ug.orgnameserver = ns10.angelichost.net. Notice that the 1st time I messed up and hadn't set a q=any yet (query any/all information) and it refused to give me any answer at all. After I get the q=any, it simply pointed me up the change (or down if you like) to the angelichost.net servers... From there I can get the host. server ns9.angelichost.net Default server: ns9.angelichost.net Address: 216.240.154.246#53 set q=any www.u2ug.org Server: ns9.angelichost.net Address:216.240.154.246#53 Name: www.u2ug.org Address: 216.240.154.254 Those are the only 2 servers that can answer authoritatively. I've got at least a dozen nameservers under my control... Network Solutions has access to none of them. If they were to request a propagation of a domain (aka a zone transfer) it would be denied by the nameserver as it would not recognize their servers as having rights to do so (nor do they need it for dns resolution to work). This is a common security measure. I (or my clients) make DNS zone updates all the time, and N.S. isn't involved... The only zone transfers that take place are between the SOA namservers (those listed as nameservers for the domain) the upper level DNS servers only get involved when there's a change of nameservers for the domain not for host level changes. The other nameservers around the world would not resolve the name except if it was in cache - meaning a client requested it and the domain's TTL (Time To Live - most are set to 12 hours, other more volatile domains drop that to 15 minutes... 15 minutes is the shortest most nameservers will honor). At the TTL has expired, the name must be re-resolved starting the right to left process over ORG's namservers - U2UG.ORG's nameservers - host resolution. I have seen reputable companies frown on it without explanation (I've been actively working with/in the hosting industry for a long time...) It's unusual enough that it would at least raise questions. Many hosts are protective of their networks. If something raises a red flag (spam?) they'd at least look a little harder at it. ___ U2-Users
Re: [U2] u2ug.net Website
To reiterate -- AngelicHost hosts the DNS for U2UG.org. We have complete control over the A, MX, CNAME, etc. records. Right now, all of the DNS records point to one of our servers. I have a redirect setup on that server so that any incoming requests for www.u2ug.org are redirected to www.u2ug.net. It's a simple matter to modify the A record for www.u2ug.org to point it to the appropriate server. Because of the lists, we need to keep the MX record pointed to our server, but if we want official @u2ug.org email addresses for the board, or whatever, those can be accommodated. Larry Hiscock AngelicHost Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 04, 2012 5:34 PM To: 'U2 Users List' Subject: Re: [U2] u2ug.net Website Bill, You missed something =). Network solutions does not host the domain only redirects to the specified named server(s) (ns9.angelichost.net), i.e. doesn't host the A or MX record directly. Respectfully, Don V. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, April 04, 2012 12:57 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website Robert: [snipped..] When I looked at the whois record for u2ug.org, the sponsoring registrar and the Tech organization for the u2ug.org domain is Network Solutions, LLC. I may have missed something here, which is quite possible. :-) Bill - Original Message - *From:* ropor...@ochsner.org *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/4/2012 9:08 AM *Subject:* Re: [U2] u2ug.net Website Pointing the WWW host isn't so much about where/who the registrar is, but where the nameservers are. Network Solutions does offer DNS services, but the u2ug.org domain appears to use angelichost.net nameservers. Not sure if Don has direct control over the A records or not. Plus a few hosts frown on records pointing to other providers (mainly paranoid ones)... He may have to ask them to do it, and possibly explain why he'd want it that way. Robert ___ 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's DOS command
Ummm ... it's not a UniVerse thing, it's a command prompt thing. Open up a command prompt window, and type cmd /? And you'll see all the options. /c means run the following command, then close the window /k means run the following command, and keep the window open There's a whole list of command options ... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, February 15, 2012 11:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe's DOS command Oh... My... God Amazing try DOS /C DIR then try DOS /K DIR how come they don't document this and we have to make guesses? -Original Message- From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 15, 2012 10:38 am Subject: Re: [U2] Universe's DOS command An educated guess would be that the DOS command invokes the command rocessor (command.com in long-ago Windows, cmd.exe now) and passes the \c (or is it /c?) to it. If in Windows you open a CMD prompt, and type cmd /? ou can see what options it accepts. My output includes: /C Carries out the command specified by string and then terminates Further down the help display, it gives more information. On Wed, 15 Feb 2012, Wjhonson wrote: The DOS command in Universe takes a /c argument and then you can specify a at file like DOS \c test.bat What does \c mean? Are there other arguments like \z or \x that it can take? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, ...Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] CareerBuider.com exploiting animals in their advertising
This thread is inappropriate to this list. If you wish to continue, please move it to U2-Community. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen Sent: Monday, February 06, 2012 9:18 AM To: U2 Users List Subject: Re: [U2] [OT] CareerBuider.com exploiting animals in their advertising Thank you, Rob I am not going to sugar coat it like you did though. The OP was a DUMP TRUCK LOAD overflowing with bull crap. Karen Bessel Developer Tyler Technologies, Inc. P: 972.713.3770 ext: 113472 F: 972.713.3780 www.tylertech.com-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Monday, February 06, 2012 9:17 AM To: 'U2 Users List' Subject: Re: [U2] [OT] CareerBuider.com exploiting animals in their advertising I find this offensive... NOT careerbuilder's user of chimpanzees, but your libelous statements without offering any proof whatsoever except a link to an organization page filled with generalizations and examples that have nothing to do with the matter at hand. Did careerbuilder perform acts cruel to chimps? If so, please offer some specific proof. A 1st hand account of what if any acts were cruel, that they committed not something someone else may have done in the past. If you cannot (as I suspect), you owe them an apology. Robert Stuart Boydell stu...@sbcs.com.au 2/4/2012 6:05 PM Hi, Sorry this is off topic, but as it involves a company that some of you may use for job placement I thought it's not too inappropriate. For the upcoming US Super Bowl the job placement company CareerBuilder intend to run TV advertisements using Chimpanzees as unruly office workers. Although the 'fun antics' of chimps may seem harmless, sorry to say there are very sad consequences for them. Previously CareerBuilder has agreed not to exploit Chimpanzees in their advertising and this reversal has no doubt been based on having had good advertising success rate overriding their commitment to desist. I don't need to expand on the ethical implications of this position by a job placement company. If you believe that going back on a promise or cruelty to animals are morally unsupportable please consider writing to CareerBuilder to make your feelings known. You can read more about it here https://secure.peta.org/site/Advocacy?cmd=displaypage=UserActionid=3494 Thank you for reading and apologies for posting off topic. Regards, Stuart Boydell stu...@sbcs.com.au ___ 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] SOAP Request via an HTTPS call
UD or UV? Have you created a security context? Does the IIS server have a valid SSL Certificate installed? I've had a secure SOAP consumer running since UD 6.1. There were a few glitches in creating the SOAP header, IIRC. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Monday, December 05, 2011 12:53 PM To: U2-Users@listserver.u2ug.org Subject: [U2] SOAP Request via an HTTPS call Hi all - I am trying to submit a SOAP request via a secure connection, and have been unsuccessful so far. We are able to create the secure connection, but it is failing on the SOAP request at the IIS server with a fault error. Does anyone have an example they can provide for submitting SOAP calls in this manner? Thanks in advance! Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ 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] SOAP Request via an HTTPS call
I ended up using the SOAP-specific verbs, not just CallHTTPS, but I built
the SOAP headers manually. Here's the main part of the program, which does
an address verification (mundane parts snipped for brevity, and private data
redacted). Hope it helps.
Larry Hiscock
Western Computer Services
SoapURL =
'https://api.qualifiedAddress.com/Address/v1/VerifyService.asmx'
SoapAction = https://api.qualifiedaddress.com/Address/V1/Execute;
SoapMethod = Execute
SoapNameSpace= https://api.qualifiedaddress.com/Address/V1/;
SoapBody = '?xml version=1.0 encoding=UTF-8?'
SoapBody := LF:'soap:Envelope
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;'
SoapBody := LF:' xmlns:xsd=http://www.w3.org/2001/XMLSchema;'
SoapBody := LF:'
xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/;'
SoapBody := LF:' soap:Body'
SoapBody := LF:' ':SoapMethod:' xmlns=':SoapNameSpace:''
SoapBody := LF:'request'
SoapBody := LF:' Addresses'
SoapBody := LF:'AddressRequest'
IF ADDRESSEE '' THEN
SoapBody := LF:' Addressee':ADDRESSEE:'/Addressee'
END
SoapBody := LF:' Street':ADDRESS:'/Street'
IF ADDRESS2 '' THEN
SoapBody := LF:' Street2':ADDRESS2:'/Street2'
END
SoapBody := LF:' City':CITY:'/City'
SoapBody := LF:' State':STATE:'/State'
SoapBody := LF:' ZipCode':ZIPCODE:'/ZipCode'
SoapBody := LF:'/AddressRequest'
SoapBody := LF:' /Addresses'
SoapBody := LF:' Suggestions':MaxSugg:'/Suggestions'
SoapBody := LF:' Key':xmlAccessKey:'/Key'
SoapBody := LF:'/request'
SoapBody := LF:' /':SoapMethod:''
SoapBody := LF:' /soap:Body'
SoapBody := LF:'/soap:Envelope'
* Load the security context
Ret = loadSecurityContext(context, contextName, passPhrase)
* Create the Request
RETVAL = SOAPCreateSecureRequest(SoapURL, SoapAction, SoapReq,
context)
IF RETVAL 0 THEN { handle the error }
* Set up the Request Body
RETVAL = SOAPSetRequestContent(SoapReq, SoapBody, 1)
IF RETVAL 0 THEN { handle the error }
* Submit the Request
RETVAL = SOAPSubmitRequest(SoapReq, Timeout, ResponseHeaders,
ResponseData, SoapStatus)
IF RETVAL 0 THEN { handle the error }
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Authorization Page
Looks like a certificate on one of their internal servers has expired, and their ISA server is barfing on it. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Sunday, September 18, 2011 5:17 PM To: U2 Users List Subject: [U2] Rocket Authorization Page Is anyone able to access https://u2tc.rocketsoftware.com/ today? -- -Kevin http://www.PrecisOnline.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] Ardent programmers
Ah, but how many of them can still write PQ procs ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 09, 2011 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Ardent programmers By the way, I today, for the first time in my career, encountered a seasoned Pick BASIC programmer, conversant with Paragraphs, but who did not know what Proc was. Never heard of it. It only took 20 years of trying to make Proc die I guess ;) ___ 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] Ardent programmers
It's no coincidence that proctology starts with PROC ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, September 09, 2011 1:17 PM To: U2 Users List Subject: Re: [U2] Ardent programmers Doesn't PROC mean Painfull Reading Of Code? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 09, 2011 4:14 PM To: U2 Users List Subject: Re: [U2] Ardent programmers You haven't missed much. Be thankful you have never had to look at a PROC. On Fri, Sep 9, 2011 at 4:03 PM, Dawn Wolthuis dw...@tincat-group.comwrote: Oh, I can find a whole slug of 'em among the Datatel customer base. I did not know what a proc was until I peeked out into the larger MV world. Even now I have not purposely ever looked at a proc. --dawn On Fri, Sep 9, 2011 at 2:53 PM, Wjhonson wjhon...@aol.com wrote: By the way, I today, for the first time in my career, encountered a seasoned Pick BASIC programmer, conversant with Paragraphs, but who did not know what Proc was. Never heard of it. It only took 20 years of trying to make Proc die I guess ;) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Masking of Password Input (Universe Basic)
How about backspacing to correct mistakes? ;-) Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, August 16, 2011 12:54 PM To: 'U2 Users List' Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) That's actually pretty good! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Tuesday, August 16, 2011 3:43 PM To: U2 Users List Subject: Re: [U2] Simple Masking of Password Input (Universe Basic) Just a quick sample PROMPT '' PW='' ECHO OFF LOOP INPUT X,1: IF X = '' THEN EXIT IF X THEN PRINT '*': PW := X REPEAT ECHO ON PRINT PRINT PW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: Tuesday, August 16, 2011 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple Masking of Password Input (Universe Basic) Does anyone have a simple routine for entering a password and only displaying an asterisk for the character entered? -- View this message in context: http://old.nabble.com/Simple-Masking-of-Password-Input-%28Universe-Basic %29-tp32274238p32274238.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job won't run
One thing I would do is to add 21 to the end of every line that contains a $LOG or $LOG. This will redirect any error messages from stderr to the log file as well. Then you can check the log file to see if any type of error is occurring. It may be that your script isn't even starting udt. Also curious why you're using the EOD syntax instead of simply doing: $UDTBIN/udt PHANTOM RUN GD-BPGM EXTRACT_FPO -N Which would create a como file in _PH_, in which you could also look for errors. What happens if you run the script from a Linux command prompt? BTW, there's nothing in your script that requires ksh. You could replace the #!/usr/bin/ksh with either : or #!/usr/bin/bash, and it should run fine. 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_shaf...@ntn-bower.com Sent: Friday, August 05, 2011 8:27 AM To: U2 Users List Subject: [U2] Job won't run I have run into something I have never seen before. We exchange a lot of data with an AS400 in Chicago. For many years we have taken the approach that the AS400 would submit a job to our UNIX box that would run a script. Many of the scripts run a Unibasic program and send the resulting file back to the AS400. This happens several times a day and we have been doing this for many years. One job has started doing something odd. It runs the script and transfers the file, but never runs the Unibasic program, so it has been resending an old version of the file. This seems to have started happening 3 days ago. I can log in manually using the same credentials as the remote job, and run the script by typing it in at the command line. It runs perfectly. Unibasic program runs, new file is sent to the AS400. There is joy. I have checked permissions. Nothing has changed at the AS400 end. Nothing has changed here. (That we know of). I have rechecked the code of he script and the Unibasic program. Looks good. I am stumped. Here is the script code. #!/usr/bin/ksh #Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG rm $LOG touch $LOG cd /NTN/DATA/CORPORATE echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG $UDTBIN/udtEOD$LOG RUN GD-BPGM EXTRACT_FPO -N bye EOD echo Sending Firm Planned Orders to AS400 730 $LOG /usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO echo `date` Finished sending Firm Planned Orders $LOG This runs perfectly when run from CL, but not when submitted from the AS400. And ideas? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniBasic SELECT
#1 - Why would you want to change a Basic SELECT to EXECUTE a SELECT? #2 - If you still want to do this, change this: Execute SELECT F.ICC to LIST.2 To this: Execute SELECT F.ICC to :LIST.2 Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 29, 2011 3:14 PM To: U2 Users List Subject: [U2] UniBasic SELECT In an inherited legacy app, I have a few commands like LIST.1 = 1 LIST.2 = 2 LIST.3 = 3 LIST.4 = 4 SELECT F.ICC to LIST.2 SELECT F.ICC to LIST.3 SELECT F.ICC to LIST.4 And then LIST.2 LIST.3 and LIST.4 show up in loops such as ... loop readnext CLASS.KEY from LIST.2 else EOP = 1 until EOP = 1 DO read R.ICC from F.ICC, CLASS.KEY else go Get.Next.Class.Key . . Repeat The red warning marks on the right of the Rocket BDT IDE indicate... expecting INTEGER, found LIST.2 Notwithstanding the red warnings, the program compiles and runs ok. When I try to encapsulate these commands with Execute SELECT F.ICC to LIST.2 The red warnings go away... the program runs ok but, I get a SQL+ prompt after the report prints which can be resolved by just hitting Enter. I do not want my end users to have to deal with (for them) an unusual SQL+ prompt. Suggested work-arounds to make the SQL+ prompt go away would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SOAP Header
Here's an example of one we're using to validate mailing addresses (the indentation is just for readability): * Build the SOAP request SoapBody = '?xml version=1.0 encoding=UTF-8?' SoapBody := 'soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;' SoapBody := ' xmlns:xsd=http://www.w3.org/2001/XMLSchema;' SoapBody := ' xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/;' SoapBody := ' soap:Body' SoapBody := ' ':Method:' xmlns=':NameSpace:'' SoapBody := 'request' SoapBody := ' Addresses' SoapBody := 'AddressRequest' SoapBody := ' Addressee':ADDRESSEE:'/Addressee' SoapBody := ' Street':ADDRESS:'/Street' SoapBody := ' Street2':ADDRESS2:'/Street2' SoapBody := ' City':CITY:'/City' SoapBody := ' State':STATE:'/State' SoapBody := ' ZipCode':ZIPCODE:'/ZipCode' SoapBody := ' LastLine':LASTLINE:'/LastLine' SoapBody := '/AddressRequest' SoapBody := ' /Addresses' SoapBody := ' Suggestions':MaxSugg:'/Suggestions' SoapBody := '/request' SoapBody := ' /':Method:'' SoapBody := ' /soap:Body' SoapBody := '/soap:Envelope' * Load the security context RtnVal = loadSecurityContext(Context, ContextName, password) * Create the Request RtnVal = SOAPCreateSecureRequest(SoapURL, SoapAction, SoapReq, Context) * Set up the Request Content RtnVal = SOAPSetRequestContent(SoapReq, SoapBody, 1) * Submit the Request RtnVal = SOAPSubmitRequest(SoapReq, Timeout, RespHeaders, RespData, SoapStatus) There's obviously more error trapping in the live version, but I stripped it out for this example just to show the process flow. SoapURL contains the URL to the web service (https://.../VerifyService.asmx), and SoapAction, NameSpace and Method contain the appropriate data specified in the WSDL. The Response headers and data are returned in RespHeaders and RespData respectively. Hope this helps... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, July 27, 2011 11:23 AM To: U2 Users List Subject: Re: [U2] SOAP Header Thanks Larry. They are on 7.2. Currently we are using the SOAPCreateRequest, SOAPSetRequestContent, and SOAPSubmitRequest functions only. I would like to avoid adding the header info to the SOAP body if possible, but if not, how did you do it? Did you surround it by the Header tags or did you just put the info at the beginning of the body? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, July 27, 2011 9:32 AM To: 'U2 Users List' Subject: Re: [U2] SOAP Header Hi Steve, What version of UD and on what platform? The reason I ask is that we have a client that is stuck on UD v6.1 for the time being (because they're on SCO OpenServer). At that rev and on that platform, we ran into issues using some of the SOAP functions. We were able to work around it, but only ended up using the SOAPCreateSecureRequest(), SOAPSetRequestContent() and SOAPSubmitRequest() functions. We built our own SOAP headers into the SOAP body that is passed to SOAPSetRequestContent(). You might also try turning on Protocol Logging. It does give some mostly useful information about exactly where your SOAP transaction is failing. VAR = protocolLogging(/path.../soapprotocol.log, ON, 7) Larry Hiscock Western Computer Services PH: 661-255-0235 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, July 27, 2011 9:05 AM To: U2 Users List Subject: [U2] SOAP Header Hi All - I am using the Unidata functionality to do SOAP calls and I now need to specify header information to call a SSL page. It is failing because there is not info in the header. The documentation is very sparse on this, as you all know. Anyone have any insight on how to specify header info using the SOAPSetRequestHeader function? Thanks in advance! Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ 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
Re: [U2] SOAP Header
It's been a while since I've created one, but IIRC, the easiest way is to use UniAdmin to create a CSR, then a self-signed certificate (or you can purchase a cert using the CSR) and the security context. Check out the UniData Security Features guide at http://www.rocketsoftware.com/u2/products/unidata/resources/manuals/security -v7r2.pdf/view Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, July 27, 2011 11:57 AM To: U2 Users List Subject: Re: [U2] SOAP Header Thanks Larry. I think we need to try the secureRequest, but I haven't messed with the setup. I see you are doing loadSecurityContext. How did you create the context? Via the saveSecurityContext? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, July 27, 2011 11:47 AM To: 'U2 Users List' Subject: Re: [U2] SOAP Header Here's an example of one we're using to validate mailing addresses (the indentation is just for readability): * Build the SOAP request SoapBody = '?xml version=1.0 encoding=UTF-8?' SoapBody := 'soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;' SoapBody := ' xmlns:xsd=http://www.w3.org/2001/XMLSchema;' SoapBody := ' xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/;' SoapBody := ' soap:Body' SoapBody := ' ':Method:' xmlns=':NameSpace:'' SoapBody := 'request' SoapBody := ' Addresses' SoapBody := 'AddressRequest' SoapBody := ' Addressee':ADDRESSEE:'/Addressee' SoapBody := ' Street':ADDRESS:'/Street' SoapBody := ' Street2':ADDRESS2:'/Street2' SoapBody := ' City':CITY:'/City' SoapBody := ' State':STATE:'/State' SoapBody := ' ZipCode':ZIPCODE:'/ZipCode' SoapBody := ' LastLine':LASTLINE:'/LastLine' SoapBody := '/AddressRequest' SoapBody := ' /Addresses' SoapBody := ' Suggestions':MaxSugg:'/Suggestions' SoapBody := '/request' SoapBody := ' /':Method:'' SoapBody := ' /soap:Body' SoapBody := '/soap:Envelope' * Load the security context RtnVal = loadSecurityContext(Context, ContextName, password) * Create the Request RtnVal = SOAPCreateSecureRequest(SoapURL, SoapAction, SoapReq, Context) * Set up the Request Content RtnVal = SOAPSetRequestContent(SoapReq, SoapBody, 1) * Submit the Request RtnVal = SOAPSubmitRequest(SoapReq, Timeout, RespHeaders, RespData, SoapStatus) There's obviously more error trapping in the live version, but I stripped it out for this example just to show the process flow. SoapURL contains the URL to the web service (https://.../VerifyService.asmx), and SoapAction, NameSpace and Method contain the appropriate data specified in the WSDL. The Response headers and data are returned in RespHeaders and RespData respectively. Hope this helps... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, July 27, 2011 11:23 AM To: U2 Users List Subject: Re: [U2] SOAP Header Thanks Larry. They are on 7.2. Currently we are using the SOAPCreateRequest, SOAPSetRequestContent, and SOAPSubmitRequest functions only. I would like to avoid adding the header info to the SOAP body if possible, but if not, how did you do it? Did you surround it by the Header tags or did you just put the info at the beginning of the body? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, July 27, 2011 9:32 AM To: 'U2 Users List' Subject: Re: [U2] SOAP Header Hi Steve, What version of UD and on what platform? The reason I ask is that we have a client that is stuck on UD v6.1 for the time being (because they're on SCO OpenServer). At that rev and on that platform, we ran into issues using some of the SOAP functions. We were able to work around it, but only ended up using the SOAPCreateSecureRequest(), SOAPSetRequestContent() and SOAPSubmitRequest() functions. We built our own SOAP headers into the SOAP body that is passed to SOAPSetRequestContent(). You might also try turning on Protocol Logging. It does give some mostly useful information about exactly where your SOAP transaction is failing. VAR = protocolLogging(/path.../soapprotocol.log, ON, 7) Larry Hiscock Western Computer Services PH: 661-255-0235 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent
Re: [U2] udt dir file max key length
Try ls -b at a linux prompt to see if there are any unprintable characters in any of the names Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, July 22, 2011 3:22 AM To: 'U2 Users List' Subject: Re: [U2] udt dir file max key length These are 54 characters long - no funny characters whatsoever Output of ls :- [symeon@advertisers UPLOAD]$ ls bentley-continental-gtc-convertible-petrol_3510704.jpg bentley-continental-gtc-convertible-petrol_3510705.jpg bentley-continental-gtc-convertible-petrol_3510719.jpg bentley-continental-gtc-convertible-petrol_3510723.jpg fileslist bentley-continental-gt-petrol_3510699.jpg Voc entry :CT VOC UPLOAD VOC: UPLOAD: DIR UPLOAD D_UPLOAD LIST UPLOAD 10:55:08 22 Jul 2011 1 UPLOAD Fileslist bentley-continental-gt-petrol_3510699.jpg 2 records listed Enter CR to print non exist record ids bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 bentley-continental-gtc-convertible-petrol_35107 : ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 22 July 2011 09:51 To: U2 Users List Subject: Re: [U2] udt dir file max key length Hi Symeon, The DIR key length in UDT is 124. Sure you do not have an @VM in the key? That would give you this error. Thanks, Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 21 July 2011 20:38 To: 'U2 Users List' Subject: [U2] udt dir file max key length I have a dir type file in udt, at linux I can ls the directory contents no problem in udt LIST shows them all but then says several are not found. All of the ones it says are not found have the same 49 characters the same and the last 10 or so different. Is there a limit of 49 chars on DIR file keys - can this be changed anywhere ?? Cheers Symeon. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1518/3779 - Release Date: 07/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECT question, paginated select.
Look at the BSCAN directive. It allows you to scan and traverse B-Tree type files and alternate indices. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, July 20, 2011 12:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SELECT question, paginated select. Curt, My problem is understanding how to traverse the query. Our dropdown is paginated, we can specify the # of results per paginated drop-down so it being super long or short isn't an issue. The problem is getting the SELECT statements/UniVerse to match what we want the dropdown to do. For example if I query a table called CLIENT which has @ID indexed, I do the following: EXECUTE 'SELECT CLIENT BY @ID' My questions are: #1) How would I specify 10 results back from the query? #2) How would I 'pick up' where I left off for page 2 (values 11-20)? Doug mentioned using SAVE.LIST to do this, Bill says that you have to do a dance in UniVerse. I guess I'm curious what this dance is that I need to do? If it's not handled in the SELECT then what technique are you using in UniVerse? Chris Date: Wed, 20 Jul 2011 13:59:48 -0500 From: cstew...@tri-sysconsulting.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] SELECT question, paginated select. Chris, I agree with Bill, using an index is your best solution. Are you able to apply any kind of filter criteria to the names? If not here's one of your dilemmas... If you make your drop down list too small nobody will use it because it will take too long to get to anyone beyond the A's. If you make it too long it will be cumbersome to find someone on the page and the build time of the drop down list on the client side may be too slow. I strongly recommend, from experience, using something other than a dropdown list, even using a combo box list allows the user to provide some criteria to narrow the search. Hth Curt Stewart Chris Austin cjausti...@hotmail.com wrote: Bill, I was curious if you had a quick example? I'm just curious how you guys are suggesting to do this Chris Date: Wed, 20 Jul 2011 11:13:04 -0700 From: wphask...@advantos.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] SELECT question, paginated select. Chris: I'm betting the solution also needs indexing, because you want to pick up where the last list left off and you don't want to wait for a select to return to save the list. So, SAMPLE isn't really a solution but indexing is. We do this all the time, but we have to use indexing. In fact, we parse through a file with millions of records to get a page full of stuff and the pop-up list is instantaneous. Secondly, I'm not sure a dropdown list is the appropriate choice for a thousand items. HTH, Bill - Original Message - *From:* cjausti...@hotmail.com *To:* u2-users@listserver.u2ug.org *Date:* 7/20/2011 10:14 AM *Subject:* [U2] SELECT question, paginated select. I'm working on a screen in our webapp where we're using a dojo widjet to create a drop down with client names. The problem is that we have 1,000's of clients and when we do a SELECT on this many clients it takes a while. I know we can index the field but I was wondering if you can do smart selecting in UniVerse. For example if I wanted to use this query: SELECT CLIENT WITH @ID = A] SAMPLE 10 (returns 10 clients starting with the letter A). I want to paginate my drop down so the first query has the above data. The problem I'm facing is that I don't know how to get the NEXT 10 clients? Is there a way to do this? For example if I wanted to return the next 10 CLIENTS, without including any of the first 10. Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Simple FMT question
Try: X = FMT(X,'40R') ... works here on UniData 6.1 Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Friday, July 08, 2011 12:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] Simple FMT question Hi Group, I don't know why this is kicking my butt but I'm trying to do a simple X = FMT(X,4\0R) statement, straight out of the HELP UNIBASIC listing and I can't seem to get it to work. The problem is the fill character, in this case the number zero, but what I get back is just the letter R, without the quote marks. I get pretty much the same result no matter what fill character I use. I simply want to format a number to be 4 characters long with leading zeros. If X=1, then it should result in X=0001, or so I've been lead to believe. I know that X = (:X)[4] works to get my results but FMT should work, too. The major benefit is that if the number is more than 4 digits, FMT won't truncate it. I hope. Environment is UniData 6.1 on a Windows server. Comments anyone? Thanks, BobW ___ 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] Adding capabilities in the sort term
I've worked with signature capture devices, although not in U2. I have worked with web services from within a UniData application. What type of web service are you looking to implement, and what platform are you running UniVerse on? Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, July 06, 2011 11:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] Adding capabilities in the sort term Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2
Your computer appears to be compromised. I have temporarily unsubscribed you from the U2 Users list. Once you have corrected your infection, you can resubscribe at http://listserver.u2ug.org. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: Friday, May 27, 2011 2:58 AM To: scott_hutchi...@baylor.edu; scott220...@hotmail.com; scrump...@sbcglobal.net; skiph...@dfwair.net; u2-users@listserver.u2ug.org Subject: Re: [U2] 2 ..I can give you a good advice: visit this drugstore and your problem will be solved. http://ecole2jauche.be/page.php?oyahoo=76eb3 ___ 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] 2
Mea culpa. I hit reply and didn't change TO: address. I have sent a separate email privately to Ron. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Friday, May 27, 2011 8:26 AM To: U2 Users List Subject: Re: [U2] 2 Who are you directing this to, Larry? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Friday, May 27, 2011 7:16 AM To: 'U2 Users List' Subject: Re: [U2] 2 Your computer appears to be compromised. I have temporarily unsubscribed you from the U2 Users list. Once you have corrected your infection, you can resubscribe at http://listserver.u2ug.org. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: Friday, May 27, 2011 2:58 AM To: scott_hutchi...@baylor.edu; scott220...@hotmail.com; scrump...@sbcglobal.net; skiph...@dfwair.net; u2-users@listserver.u2ug.org Subject: Re: [U2] 2 ..I can give you a good advice: visit this drugstore and your problem will be solved. http://ecole2jauche.be/page.php?oyahoo=76eb3 ___ 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] serial #
Does UV have the WHAT tcl verb like UD does? Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Saturday, May 07, 2011 10:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] serial # Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ 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] Mailing List Hacked
To my knowledge, the list hasn't been hacked, nor has anyone subscribed and sent phishing attempts through the list. It is being mirrored/archived via Nabble and a couple of others, I believe, which may be the source of the email harvesting. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Tuesday, April 19, 2011 5:28 AM To: U2 Users List Subject: Re: [U2] Mailing List Hacked I was about to mention that... his email address appears in 3+ dozen pages in google. So unless there's some other evidence, I'm not worrying about the list being hacked. Robert George Gallen ggal...@wyanokegroup.com 4/19/2011 7:26 AM not to mention that the list is on search engines as well -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Tuesday, April 19, 2011 7:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Mailing List Hacked On 04/19/2011 07:22 AM, u2list0...@curt.com wrote: I just received a phishing attack addressed to my U2 Mailing list email address. That doesn't mean the list was hacked (eg: found a way to scrape addresses from the outside). Anyone can join the list, harvest email from it and then use it for bad things. I've seen this before on other high-traffic lists I'm on. -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Question about uvbackup dd and uvrestore
LOL, Tom. Just to clarify -- when users of a product or service praise the product or company, when they have no fiduciary stake or relationship to the company, the AD tag is not required. An AD tag is only required when someone stands to gain financially from the product or service that they're recommending. It's just fair disclosure. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 5:44 AM To: U2 Users List Subject: Re: [U2] Question about uvbackup dd and uvrestore Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files
Re: [U2] Disclosing technology - Was 'Has anyone ever heard of Kyle Stetson?'
Especially since so many Prime installations never changed the sysadmin password :-D Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, April 11, 2011 5:52 AM To: U2 Users List Subject: Re: [U2] Disclosing technology - Was 'Has anyone ever heard of Kyle Stetson?' That reminds me of when I first attended college, the university ran Prime's. I had purhcased a primos system admin manual direct from Prime, and had it with me at school. They were NOT pleased that Prime sold it to me. So those concerns were very active, even in the early 80's. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Sunday, April 10, 2011 11:04 PM To: U2 Users List Subject: Re: [U2] Disclosing technology - Was 'Has anyone ever heard of Kyle Stetson?' Agreed. When managing a Pr1me shop on a college campus in the early 90's when so many youngsters and hackers knew *nix or Windows, I really appreciated the added security by ignorance we had on our administrative machines. If students were going to hack, it would be on the boxes other than where their grades were or the payroll was, for example There is something to be said for keeping such things quiet. It really isn't an impressive line item in a real security plan but does add to it. Good point, Dan. --dawn ___ 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] Does UV have a BLOCK command
If you're not really repeating the loop (i.e. the EXIT just before the repeat), why do you need a loop/repeat? What's wrong with: code code IF NOT(condition) THEN more code END Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, February 07, 2011 12:26 PM To: U2 Users List Subject: [U2] Does UV have a BLOCK command I want to setup a block of commands, and be able to exit out of the block if needed. Right now I use a LOOP/REPEAT with an EXIT statement before the REPEAT. I'd rather not use labels (or subroutines). The Loop/Repeat works, it just looks weird since it isn't really a loop... I tried using an IF block, but I couldn't use the EXIT within that block IF (1=1) THEN..END LOOP block code block code if condition then EXIT block code EXIT REPEAT Would be nice if BEGIN BLOCK block code block code if condition then EXIT block code END BLOCK George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] The sky is so falling! {Unclassified}
There's no place like ::1 ;-)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, February 03, 2011 2:29 PM
To: U2 Users List
Subject: [U2] The sky is so falling! {Unclassified}
In case you hadn't already heard, IANA has allocated the last blocks of
IPv4 addresses to the Regional Internet Registries (RIRs). There are *NO
MORE*, the cupboard is bare.
See, amongst what will doubtless be lots of others,
http://www.apnic.net/final-five.
If AfriNIC is your RIR, you'll probably be able to get an IPv4 address
allocation for several years.
IF APNIC (which serves China, India, Korea and Japan as well as
Australia NZ) is your RIR, you'll be flat out of luck before Christmas
- some commentators say as soon as July.
So, how IPv6 Ready is the U2 community?
How IPv6 Ready are you?
E.g. Have you got any tables where you store IP addresses? If so, what
happens when you need to store and display/list
DEAD:BEEF::1020:17AA:0236:1AAA instead of 192.168.215.132?
The fun is about to start
:-)
Regards
Mike
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
Re: [U2] What do you do with CallHTTP?
We're using it to consume address verification web services. Larry Hiscock Western Computer Services On Fri, Jan 28, 2011 at 1:50 PM, David Wolverton dwolv...@flash.net wrote: What uses have you found for CallHTTP for in your applications? Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Thanks for your thoughts! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
We use Qualified Address (http://www.qualifiedaddress.com). They offer both Address Verification as a web service and batch address scrubbing with full CASS certification. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, January 28, 2011 4:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] What do you do with CallHTTP? On 1/28/2011 3:49 PM, Larry Hiscock wrote: We're using it to consume address verification web services. Larry Hiscock Western Computer Services Can you recommend a company for CASS verification? ___ 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] CoRelating Two Arrays
Am I missing something? It doesn't appear to me that you are modifying Where.We.Left.Off anywhere in this code snippet, so I don't see how UV is resetting it, since it never gets set to anything but 1 at the beginning of your code. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, January 26, 2011 9:26 AM To: U2 Users List Subject: [U2] CoRelating Two Arrays When I try do something like the following, inside the loop, UV keeps resetting Where.We.Left.Off to 1. To solve this, I am expecting to invoke brute force. I am surprised that UV-Basic behaves this way. An explanation would be appreciated. --Bill Where.We.Left.Off = 1 for Blanket.PO.Count = 1 to Total.Nbr.PO.Releases read R.POD from F.POD... PO.Qty = R.POD, Blanket.PO.Count for Receiver.Count = Where.We.Left.Off to Total.Nbr.Receivers read R.Rcvr from F.Rcvr... Received.Qty = R.RcvrReceiver.Count Received.Running.Total += Received.Qty begin case case Received.Running.Total PO.Line.Item.Qty ; crt PO.Qty : ' ' : Received.Qty Receeived.Running.Total = 0 exit end case next Receiver.Count next Blanket.PO.Count ___ 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+ User Group
Welcome back Gordon. The U2UG also host an SB mailing list called SBSolutions. You can subscribe at http://listserver.u2ug.org/mailman/listinfo/sbsolutions. You can see all of the mailing lists hosted by U2UG at http://listserver.u2ug.org/mailman/listinfo Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Thursday, October 28, 2010 7:51 AM To: U2 Users Subject: [U2] SB+ User Group Does anyone have a line on a SB+ discussion group? As it's been about 15 years since I last used SB+ I have a few questions. Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ 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] too many values in sort
On our UniData 6.1 system: :LIMIT ... U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. ... According to HELP LIMIT: The ECL LIMIT command displays maximum size limits for elements of UniData. These limits are NOT CONFIGURABLE. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 7:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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] Free software licence
Brian Leach wrote: All I've been planning for a while to release my system scanning tools (mvScan) as free/open software. Has anyone any insight to share on this? Confused Brian Have you looked at the Creative Commons licensing models? http://creativecommons.org/about/licenses/ Larry Hiscock Western Computer Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ 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] how to round to 2 decimals?
What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 14 October 2010 16:49 To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ 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 html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style
Re: [U2] how to round to 2 decimals?
No idea if it's been implemented in UV ... it appears not, from your error message. It works in UD shrug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, October 14, 2010 9:35 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2 decimals? Are you sure DROUND() is a UniVerse function? When I do the following code: X = 2596 * 8.333 * PRINT DROUND(X,2) I get the following error: Array 'DROUND' never dimensioned. From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re: [U2] how to round to 2 decimals? What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 14 October 2010 16:49 To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ 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 html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please
Re: [U2] Fwd: Warning: mvargh...@silverlinewindow.com - User unknown!
Matt has been unsubscribed... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Tuesday, October 12, 2010 11:23 AM To: 'U2 Users List' Subject: Re: [U2] Fwd: Warning: mvargh...@silverlinewindow.com - User unknown! Matt does not work at Silverline any more. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Slow READ/WRITE with indexes
Are any of your indices based on virtual fields? I haven't worked with UV in a while, but UD has the DISABLE.INDEX, ENABLE.INDEX and UPDATE.INDEX commands. If UV also has them, you could disable the indexes prior to the archival and re-enable and update them at the end. I'm not sure if it would be any faster, but certainly worth an attempt. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ryan M Sent: Thursday, September 09, 2010 10:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] Slow READ/WRITE with indexes I am hoping I can find some help here. I am running into a serious performance issue with indexes on our UV system (UV 10.2, on AIX). An example of this is our sales order files, SO (current/active) and SOH (history) files. We archive sales orders from SO to SOH on a daily basis, this is moving approx 15,000 records from one file to the other. If I remove all indexes from both files, the process flies by, hundreds of transactions per second. But, with indexes on, we are luck to get one per second. Basically what happens with the code that does the archiving is it reads the SO record, does some quick checks to make sure we can move it, then writes the record to SOH, then deletes the SO. There are 7 indexes on the SO file and 5 on the SOH. I've tried removing one index from a file and running the process, but see no performance gain until all indexes are gone. The SO file is approx 7GB with 280k records, and the SOH file is 11GB, with 8,900,000 records I have check the files sizes in UV and they are correct. Can anyone provide some pointers on ways to setup indexes so they will run faster? Some of the indexes are 'ORDER.DATE', 'COUNTRY', 'MEMBER ID' -- View this message in context: http://old.nabble.com/Slow-READ-WRITE-with-indexes-tp29653705p29653705.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] Test ... please ignore
Test, please ignore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unix to SQLServer
At the risk of being roasted for mentioning my vendor product (see other threads - it seems to be unpopular) ... I'm not speaking for the U2UG officially, but as a moderator on this list, and as the list host. IMHO, there is nothing wrong with mentioning or endorsing a product, whether it's free or commercial. If it provides a solution to the problem in question, then it's germane to the discussion. What I personally find distasteful is when someone gives a product a glowing review without disclosing the fact that they stand to benefit from its sale. That's why we've simply asked that when endorsing a product with which one has a fiduciary relationship, that it be disclosed as such. Ok, back to the topic... Larry Hiscock Moderator ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Windows SSH without telnet service
I've never run an sshd service on Windows, but we do it all the time on Linux. We usually shut telnet down completely. Terminal emulation should be identical between telnet and ssh. What terminal emulator / ssh client are you using? Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve McConnell Sent: Friday, June 18, 2010 4:45 PM To: U2 Users List Subject: [U2] UV Windows SSH without telnet service We have a user running on a Windows UniVerse server who has a security requirement which forbids running any telnet services. They want to use ssh to connect and have installed bitvise winsshd. It allows us to kick of a uvsh.exe upon authentication. We are able to login to our software or the uv account fine. But, once we are in, we are having serious terminal emulation problems. I haven't found a term type which will work. vt100, console, ansi, etc all display incorrectly (CRLF looks like LF). Commands such as PTERM CRMODE do not work, etc. Has anyone out there connected to a UniVerse windows server without the telnet service via ssh? Steve McConnell Columbia Ultimate ___ 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] I've run out of quotes
You can usually escape any given character passed to the shell by preceding it with a backslash. In other words: To pass a quote: \ To pass a backslash: \\ Etc. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 17, 2010 10:15 AM To: U2 Users List Subject: [U2] I've run out of quotes OKHow do I setup a sh -c when what I want to pass has in it, single quotes, double quotes and backslashes? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I've run out of quotes
Use the QUOTE() function, thusly: sh -c mysql --user username -e :QUOTE(LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp();) database Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 17, 2010 10:30 AM To: U2 Users List Subject: Re: [U2] I've run out of quotes that doesn't help. I'm passing is: mysql --user username -e LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp(); database I can't think of anyway to escape anything, and still not confuse UV. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Thursday, June 17, 2010 1:22 PM To: 'U2 Users List' Subject: Re: [U2] I've run out of quotes You can usually escape any given character passed to the shell by preceding it with a backslash. In other words: To pass a quote: \ To pass a backslash: \\ Etc. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 17, 2010 10:15 AM To: U2 Users List Subject: [U2] I've run out of quotes OKHow do I setup a sh -c when what I want to pass has in it, single quotes, double quotes and backslashes? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] I've run out of quotes
Oops ... missed something at the end. Try this: sh -c mysql --user username -e :QUOTE(LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp();): database --Larry -Original Message- From: Larry Hiscock [mailto:lar...@wcs-corp.com] Sent: Thursday, June 17, 2010 10:43 AM To: 'U2 Users List' Subject: RE: [U2] I've run out of quotes Use the QUOTE() function, thusly: sh -c mysql --user username -e :QUOTE(LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp();) database Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 17, 2010 10:30 AM To: U2 Users List Subject: Re: [U2] I've run out of quotes that doesn't help. I'm passing is: mysql --user username -e LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'D', DateAdded = current_timestamp(); LOAD DATA infile '/mnt/mount/FILE.TXT' REPLACE INTO TABLE database.updates FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Emailaddress, Reference) SET UpdateType = 'A', DateAdded = current_timestamp(); database I can't think of anyway to escape anything, and still not confuse UV. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Thursday, June 17, 2010 1:22 PM To: 'U2 Users List' Subject: Re: [U2] I've run out of quotes You can usually escape any given character passed to the shell by preceding it with a backslash. In other words: To pass a quote: \ To pass a backslash: \\ Etc. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 17, 2010 10:15 AM To: U2 Users List Subject: [U2] I've run out of quotes OKHow do I setup a sh -c when what I want to pass has in it, single quotes, double quotes and backslashes? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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 Silly Gripe
Really? We have more than 20 subdirectories in our program directory. Each of them is defined as a DIR in Unidata, but at the Unix level (and convcode is a system-level command, not a Unidata verb) each is simply a sub-directory of the source directory. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, March 25, 2010 5:35 AM To: 'U2 Users List' Subject: Re: [U2] Unidata Silly Gripe Probably because you would never have subdirectories in your program directory. snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Silly Gripe
Actually, you COULD do this on the Pr1me. Our application was migrated to Unidata from Pr1me Information. We always kept program sub-directories segregated by application (e.g. AR, AP, GL, etc). --Larry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Thursday, March 25, 2010 3:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata Silly Gripe In message 031801cacc3b$feb964a0$fc2c2d...@com, Symeon Breen syme...@gmail.com writes Just a different way of doing it i suppose - i do have separate sub directories but they are under the dev account and not under say BP Just a little point - bearing in mind I've never used genuine Pick but I think Larry et al are describing *TYPICAL* Pick usage. You couldn't do that on Pr1me so anybody (like me) only used to the Pr1me approach this would seem strange. We had three (actually four) main program directories on our system, called CBP, GBP and RBP. But on a Pick system they would typically have been defined as subfiles of BP, eg BP,COL BP,GEN and BP,REM. Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 25 March 2010 16:23 To: 'U2 Users List' Subject: Re: [U2] Unidata Silly Gripe Really? We have more than 20 subdirectories in our program directory. Each of them is defined as a DIR in Unidata, but at the Unix level (and convcode is a system-level command, not a Unidata verb) each is simply a sub-directory of the source directory. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, March 25, 2010 5:35 AM To: 'U2 Users List' Subject: Re: [U2] Unidata Silly Gripe Probably because you would never have subdirectories in your program directory. snip ___ 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 -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ 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] I'm looking for PICK
Yep ... should have been Always in motion the future is ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, March 18, 2010 11:59 AM To: U2 Users List Subject: Re: [U2] I'm looking for PICK OK but... Yoda with verbs sentences he finishes. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laurie Blain Sent: Thursday, March 18, 2010 2:02 PM To: U2 Users List Subject: Re: [U2] I'm looking for PICK,Universe Unidata professionals for nationwide openings... Nice comments. I have been looking for work and it seems I am only finding resume collectors. Laurie --- On Thu, 3/18/10, aelw...@socal.rr.com aelw...@socal.rr.com wrote: From: aelw...@socal.rr.com aelw...@socal.rr.com Subject: Re: [U2] I'm looking for PICK, Universe Unidata professionals for nationwide openings... To: U2 Users List u2-users@listserver.u2ug.org Date: Thursday, March 18, 2010, 1:58 PM I have to agree with Karen here. As Yoda said Difficult to see. Always in motion is the future Those you eschew today could be your salvation tomorrow. Bessel wrote: = Wow. Chill. Maybe there are some people who ARE interested in hearing what he has to say. I don't agree with him harvesting email addresses from the list, but the rest of your points are a little over the top. Karen Bessel Software Developer Tyler Technologies, Inc. 972.713.3770 ext: 6227 www.tylertech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, March 17, 2010 7:30 PM To: 'Roy Contreras'; 'U2 Users List' Subject: Re: [U2] I'm looking for PICK, Universe Unidata professionals for nationwide openings... 1) I do not appreciate the unsolicited email. 2) DON'T send an email with NO BODY and an attachment that is just a freaking word document that you could have typed in body of the email. 3) The use generic free email addresses of roy...@att.net and roycontre...@charter.net is very unprofessional. You should really spend a hundred or two and get a real domain and email address for your company. 4) You list NO COMPANY INFORMATION and/or ADDRESSS. 5) You should not harvest email addresses from the U2UG.org website. If you want to recruit join the email list. 6) This response has been posted on the U2UG email list to warn other members you may spam. 7) I will not now, nor in the future, be in need your services. From: Roy Contreras [mailto:royc...@att.net] Sent: Wednesday, March 17, 2010 2:35 PM To: x...@xx.xxx Subject: I'm looking for PICK, Universe Unidata professionals for nationwide openings... Text of Word Attachment: Pick/Unix Personnel Agency My name is Roy Contreras and I run a Company called Pick/Unix Personnel. I find positions for Pick, Unidata, Universe, UNIX and other Pick related professionals, nationally. If you are open to hearing about new positions available or know of anyone who is considering other opportunities, please let me know. I currently have full-time and consulting position available. I can be contacted via e-mail -roycontre...@charter.net or at (817) 449-2038. Thank You. Roy Contreras ___ 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] Examples of working ENCRYPT function?
Kevin, Your key isn't really a key -- RC4 is a 128 bit encryption algorithm, which requires a 128 bit key. If you change the KEY.ACTION to 2 (generate a real key from the passphrase), you should get different results. You can (and should) use a long passphrase made up of pseudo-random numbers, upper- and lower-case letters and symbols to make your encryption more difficult to crack. You can also set CRYPT.ACTION to 2 to have the ENCRYPT() function base64 encode the result, so that it's safe to store in the database. Otherwise, you could end up with attribute, value or sub-value marks in your encrypted string. Use CRYPT.ACTION = 4 to base64 decode before decrypting. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, March 02, 2010 7:57 AM To: U2 Users List Subject: Re: [U2] Examples of working ENCRYPT function? Here's my code to date: * * Test Encryption Program * ALGORITHM= 'rc4' CRYPT.ACTION = 1 TEXT = 'THIS IS A TEST' TEXT.LOC = 1 KEY = 'ABCDEFG' KEY.LOC = 1 KEY.ACTION = 1 SALT = '' IV = '' RESULT = '' RESULTLOC= 1 STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC, KEY.ACTION, SALT, IV, RESULT, RESULTLOC) PRINT 'STATUS= ' : STATUS PRINT 'RESULT= ' : RESULT PRINT 'RESULTLOC = ' : RESULTLOC STOP END And here's what it shows: RUN USER-FORMS TEST.ENCRYPT STATUS= 1 RESULT= RESULTLOC = 1 What am I missing? ___ 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] Examples of working ENCRYPT function?
FWIW, your program compiled ran fine on UD 6.1 running on SCO OSR5.0.7, with the following output: STATUS= 0 RESULT= _53↨%N`Tf¶j¶l RESULTLOC = 1 Or the following, when I changed CRYPT.ACTION to 2: RUN TEST.BP TEST.CRYPT STATUS= 0 RESULT= X7WzlyXOYNTmlKZqlGw= RESULTLOC = 1 It must be an AIX issue. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, March 03, 2010 11:38 AM To: U2 Users List Subject: Re: [U2] Examples of working ENCRYPT function? Oh Larry, absolutely. My test program was just to see if I could get any results. On 7.1, yes. Pre-7.1, no. So at this point I'm just chalking it up to IBM putting out a turd in Unidata 6. Not like the documentation for this stuff has been the model of accuracy anyway. I would just prefer that going forward, Rocket document current and working features, not something that might come into the product a couple years later. ___ 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] Examples of working ENCRYPT function?
I have it working under UniData 6.1, using the following syntax: CRYPTSTAT = ENCRYPT(ALG,2,TEXT,1,CRYPTPASS,1,2,'','',CTEXT,1) The arguments are: ALG = encryption algorithm (rc4, des3, etc) 2 = action: encrypt, then base64 encode TEXT = original cleartext string 1 = dataLog: data to encrypt is in TEXT string CRYPTPASS = encryption passphrase (make it long and random) 1 = keyLoc: key data is in CRYPTPASS string 2 = keyAction: derive key from passphrase '' = salt (left blank) '' = initialization vector (IV - left blank) CTEXT = resulting encrypted base64 encoded string 1 = resultLoc: store encrypted/encoded data in CTEXT string For decrypting, I use the same syntax, but replace the action argument with 4 (base64 decode, then decrypt), and swap the CTEXT and TEXT variables. Hope this helps Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, March 01, 2010 2:47 PM To: U2 Users List Subject: [U2] Examples of working ENCRYPT function? Unidata 6.1.17; Trying to get the ENCRYPT function working, no love. I have all of the parameters set to what I believe is correct (but of course the documentation is notably ambiguous on a number of details). At this point I'm just trying to get a simple rc4 working, but the result is coming back as 1 (invalid cipher). Any clues, insights, assistance would be most appreciated. -Kevin http://www.PrecisOnline.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] Examples of working ENCRYPT function?
Ah ... I have it working on SCO 5.0.7. Do you have openssl installed on the AIX box? Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, March 01, 2010 4:30 PM To: U2 Users List Subject: Re: [U2] Examples of working ENCRYPT function? Thanks Larry. That's identical to what I'm trying, and it's not working on AIX. ___ 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] Credit Card info
Actually, it's a Visa REQUIREMENT to print only the last 4 digits of a Visa card number on sales receipts, etc. Larry Hiscock Western Computer Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Credit Card info
#1 Encrypt credit card numbers with the strongest possible encryption - AES-256 is the current standard #2 Do **NOT** store CVV codes. This is a HUGE no-no, and will cost not only your merchant account, but large fines as well #3 Display/print only the last 4 digits of the card number If you can avoid storing card numbers, do so. Storing them puts you inside PA-DSS scope, and subjects you to liability and audits. If you're doing credit card authorization via a gateway from your UV software, consider using one of the payment gateways that supports Managed Payer Data. With MPD, you don't store a card number, rather you store a token that is returned by the gateway when you first authorize a specific card. You can save the token, and re-use it for future transactions. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Dallaire Sent: Friday, January 15, 2010 2:07 PM To: 'U2 Users List' Subject: [U2] Credit Card info Hi all, We are looking for any thoughts on storing credit card information in UniVerse for our customers. Up until now we have not stored this information and we welcome any thoughts, helpful tips, etc. on doing so. We have already decided we will encrypt the stored data, but there are other issues such as printing of the data, etc. Keep in mind we provide the software, our customers are using and controlling the data. Thanks in advance for any info. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. mi...@mortgagebuilder.com Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confidentiality Notice This transmission may contain confidential information which is intended for the exclusive use of the intended recipient. Any disclosure, copying, distribution or use of the contents by anyone other than the intended recipient is strictly prohibited. If received in error, please reply to 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
Re: [U2] uucp
http://www.manpagez.com/man/1/rsync/ Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barber, Bonnie Sent: Friday, November 20, 2009 9:52 AM To: U2 Users List Subject: Re: [U2] uucp Thanks, I will definitely look into those commands; they might be on the system, just not in the man pages. Thanks, Bonnie :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, November 20, 2009 11:36 AM To: U2 Users List Subject: Re: [U2] uucp Sounds like they might need to be installed... :( but they should both be available. Both are significantly improved copy mechanisms. scp (secure cp) works like a remote cp with encryption. rsync is nice as it can keep files in sync between 2 machines transmitting only updated files also with encryption and optionally compression. Rob Barber, Bonnie bonnie.bar...@perseusbooks.com 11/20/2009 11:29 AM Thanks, I can see as a Universe programmer I am very much out of date with my UNIX skills and need to do a little more research. Neither scp or rsync are in the man pages on my systems. Thanks for the suggestions. Bonnie :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, November 20, 2009 10:51 AM To: U2 Users List Subject: Re: [U2] uucp Hadn't seen uucp used in a while... For a one-shot deal I'd do like Rod says. If this is an ongoing process, I'd either look at scp or rsync over uucp. Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Baakkonen, Rodney A (Rod) 46K rodney.baakko...@cigna.com 11/20/2009 10:46 AM I would tar up the files, zip them and ftp them -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barber, Bonnie Sent: Friday, November 20, 2009 10:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] uucp Hi everyone. I would like to use uucp to copy files from our AIX production server to our AIX development/test server. I already use rcp to copy programs back and forth, but that does not work for files. Ftping the files to the desktop then to the development server is very tedious. I have created the uucppublic directories and the .hosts directory has the server names. When I enter the uucp command on the production server I get an error that states the dev server name is not valid. I think I am missing another setup for uucp but I do not know what it is. Thanks, Bonnie Barber Perseus Distribution | Senior Programmer, J-Cispub 731-988-3135 Direct 800-343-4499 ext. 178 731-988-4452 Fax Unus pro omnibus, omnes pro uno ___ 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] Count tab characters
tr -d '\n' myfile | sed 's/[^\t]//g' | wc -c Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Monday, October 26, 2009 4:02 PM To: u2-Users Subject: [U2] Count tab characters Hi all, Can anyone tell me a unix command that will count the number of tab characters in a unix regular file? I'm using the wc command to return bytes, lines, etc but now I need to count ONLY the tabs. For some reason, I thought grep -c would work for me but forgot that that only returns the number of lines that have a tab character. I could open the file sequentially and count but I need something that is fast fast fast. Thanks ___ 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] Unibasic: Sample program - to extract data from Table
Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Test
Test -- ignore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Getting to the OS
Execute runs commands in a separate shell. The current working directory of the parent shell is not changed. Therefore, the second 'pwd' command shows the current working directly correctly. Try this: execute 'SH -c pwd ' execute 'SH -c cd / ; pwd ' Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, October 01, 2009 1:17 PM To: U2 Users List Subject: [U2] [UV] Getting to the OS The first UniBasic command works; the second command does not... execute 'SH -c pwd ' execute 'SH -c cd / ' execute 'SH -c pwd ' UniVerse on HP-Ux comes back with... /u2/METAL /u2/METAL Help would be appreciated. --Bill Brutzman ___ 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] Problem with Multi-value market in general
AMEN! (but I still love my iPhone :-/) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, September 18, 2009 1:37 PM To: 'U2 Users List' Subject: Re: [U2] Problem with Multi-value market in general ground-breaking iPod You have succumbed to apple marketing, people think they invented the gui or windows - both wrong - people now think they invented mp3 players - i still have a tiny 256meg mpg player with an oled screen that i bought a couple of years before apple entered with the ipod. I have met people who think the iphone is the first ever phone with a proper web browser - in fact the advert in the uk hinted at this, and was subsequently banned for being inaccurate. Apple are one of my gripes they invent nothing but marketing ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: 17 September 2009 22:50 To: 'U2 Users List' Subject: Re: [U2] Problem with Multi-value market in general The iPhone was a progression of proprietary touch technology and combined supporting technologies and software (stemming from the original ground-breaking iPod through to the iTouch/iPhone) that did not exist with other mobile multi-media or cellular phone products. Other makers have been trying to catch up with their versions of Apple's mobile products, but they're just not in the same league. It wasn't _just_ marketing that has made iPhone popular. The overall design and execution of the technology progression was planned very well. Can you say the same for any MV database? Apple has had a long-term (and huge) client following for many of their hardware devices and software applications. Many facets of the iPhone including interface design and app design and deployment venues contributed to the fast growth. It's not just a smart phone with web toys on it. It's a business sales channel with access to many markets. It will change the way business is being done, even more so than the Palm and Blackberry. Suggesting that marketing can help U2 grow the way the iPhone has is just absurd. Sure, we need marketing help in general but what has been said before is still true; people don't buy databases, they buy solutions. The iPhone is a solution (which runs SQLite for the apps BTW). Write an application for the iPhone that talks to U2 and sell it if you want to broaden the horizon. I have a few ideas of my own, but I'm not paying $800 for a used MacBook just to try a market idea out. :) I got twin toddlers to feed and bills to pay!! Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Thursday, September 17, 2009 5:14 PM To: U2 Users List Subject: Re: [U2] Problem with Multi-value market in general Maybe they will hire apple's marketing dept. and in a release or two down the line we'll have customers standing in line to buy U2? They did it with iPhone so I'm sure they can do it with U2 Dougc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Frank Eperjesi Sent: Thursday, September 17, 2009 4:53 PM To: U2 Users List Subject: [U2] Problem with Multi-value market in general Not to knock Rocket (Especially now that I guess I am be a dealer of there). Also I have no history with them A lot of what all you say as to U2 not evolving enough is true, but part of the reason for that and problems in the D3, U2 or mult-value world in general is that almost all the current multi-value providers are doing one or more of these things .: 1) Either living off the bones of their installed base and/or swooping in to feed off of whoever is still running D3 and its flavors, but doing nothing to attract new users. IBM falls into the 2nd category. 2) Jbase ( I think Cache) are successful application software companies that basically created their own version of Multi-value to migrate to save their investment. I have not looked a Jbase in a while, but Cache has some nice new features. My company (BAI) is one of the dwindling software providers still bringing in fresh meat to the table. Up to now just saying U2 was part of IBM made a HUGE difference. The original Unidata name was not a good as saying we were an IBM database but their name and support material were very good. As good a Rocket may be, not sure saying we are running on a data base from a company called rocketsoftware will be any help in selling to our prospect base.
Re: [U2] just a suggestion but ......
Since this isn't technically a technical discussion (pun intended), we should probably move it to the u2-community list. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Friday, September 18, 2009 2:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] just a suggestion but .. In message 007001ca385a$857a7e50$906f7a...@com, doug chanco d...@chancofamily.com writes does anyone besides me think that a new list rocketU2 or something could be added to talk about rocket, so that this list can go back to being technical? I certainly think that people need to vent/express their opinion about rocket/where u2 is going, if its dying (or not), etc .. but maybe its time to move thoes discussuions over to the community list or create a new one specific to rocket/ the sale of U2 I don't think there's any point in a new list ... I know we want (some of us at any rate) for this to be a technical list, but all this Rocket stuff is going to blow over fairly quickly. And imho it belongs on this list because it's stuff we NEED to know. Give it till the deal is formally approved and Rocket start talking, and all these threads will be gone. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ 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] Change is a coming!
http://www-01.ibm.com/software/data/u2/rocket/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, September 15, 2009 11:23 AM To: U2 Users List Subject: Re: [U2] Change is a coming! What is your source? It is not on the http://www.rocketsoftware.com/ web site (at least not that I have found). John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, September 15, 2009 2:18 PM To: 'U2 Users List' Subject: [U2] Change is a coming! September 15, 2009: IBM has signed an agreement to sell the U2 assets to Rocket Software, a global software development company. Founded in 1990, Rocket is a provider of OEM software to IBM, HP and other Fortune 500 companies. Rocket's RD focus has the potential to accelerate the growth of U2's business. Please read the attached document from Susie Siegesmund regarding the announcement. Surprise surprise ___ 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] SSH Viewpoint Emulation
Both AnzioWin and AnzioLite from Rasmussen Software (http://www.anzio.com) do Viewpoint and SSH. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti, Marc Sent: Wednesday, September 02, 2009 1:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] SSH Viewpoint Emulation Does anyone have any recommendations on a SSH client that has Viewpoint Emulation? We currently use Dynamic Connect, but do not think that it has SSH. Thanks in advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Today's subliminal thought is: CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this 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] What ever happened...
Fruit Loops wanted him back ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Thursday, August 27, 2009 9:36 AM To: 'U2 Users List' Subject: [U2] What ever happened... Whatever happened to the Toucan? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ 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] Simple Export to Excel
Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 8:34 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel The problem with Excel stripping leading zeroes and converting stuff to dates can be completely mitigated if you download and open the sheet manually. If you open the sheet automatically, Excel does its magic. However, if you open a .txt file with tabs (or even commas for that matter) you can then decide what each column should be. -K ___ 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] Unix mail server?
As an alternative to #4, you could also create an alias that pipes the incoming mail to a script (which in turn could fire off a phantom) to process the received mail and do something with it. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 25, 2009 7:05 AM To: U2 Users List Subject: Re: [U2] Unix mail server? as others have said, regarding opening the server up to the net, what you could also do is. 1. configure SENDMAIL on the rs/6000 to masquarade your domain as another server, and use a relay server. 2. configure hosts.allow/SENDMAIL to ONLY allow receipt of email from that relay server. 3. configure a linux box as an email server that only allows relaying from the rs/6000 box. 4. configure the rs/6000, an alias of an email address to append to a filename (ex: emailname: /tmp/EMAILIN), then setup a UV VOC as 1F 2/tmp 3D_SOURCE. You can now read the data by ED vocentry EMAILIN George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Burwell, Ed Sent: Thursday, June 25, 2009 9:57 AM To: U2 Users List Subject: Re: [U2] Unix mail server? Here's a high-level view of what I'm envisioning: 1. Our Unidata application sends an email to the outside world, giving the recipient certain options. 2. The recipient hits REPLY, types a few characters and hits SEND. 3. Our rs/6000 receives the email and put it somewhere. 4. Our Unidata application could periodically check that somewhere for received mail and do whatever with it. Thanks for your responses so far. ___ 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] Mixed Case UV Basic Programming Standards.
I tend to use all lower case for verbs (e.g. read, for, loop, etc), all upper case for constants (i.e. equates -- equ TAB lit char(9)), and camel case for variables (e.g. orderMaster, customerName, etc) One advantage is that I can tell at a glance the difference between a variable and a constant. Just my $.02 Larry Hiscock Western Computer Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unix mail server?
In short, yes, however, the first question should be: what are you planning to do with the mail you receive? I wouldn't recommend using your application server as a mail server, since to do that, you'd have to expose it, at least to some degree, to the outside world. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Burwell, Ed Sent: Wednesday, June 24, 2009 3:45 PM To: U2 Users List Subject: [U2] Unix mail server? We can send email from our rs/6000 (AIX version 5.3) using sendmail and it works great. Is it possible to receive email also? Thanks. Ed (We are running Unidata version 7.1) __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.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] XML mapping to multiple files records
Why two files? That would be the approach with a SQL type database, but in Universe, you can make the track data multi-valued related fields in the albums file. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Tuesday, June 23, 2009 10:38 AM To: U2 Users List Subject: [U2] XML mapping to multiple files records Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album track data that we'd like to import into 2 different Universe files. A sample layout might be something like: albums album album_ID/ album_title/ album_total_runtime/ album_total_tracks/ tracks track number=1 track_ID/ track_title/ track_artist/ /track track number=2 track_ID/ track_title/ track_artist/ /track /tracks album /albums What I'm trying to do is have an ALBUMS file and a TRACKS file. I want a single record in the ALBUMS file for each album and a record in the TRACKS file for each track. Essentially every album record in the XML will product one ALBUMS record and potentially multiple TRACKS records. The trouble I'm having is getting more than one TRACKS record. I'm wondering if anyone has ever tried this before and how their experience went. I end up with just one TRACKS record with the first iteration. Is what I'm trying even possible? I've opened a case with IBM as well but figured maybe one of you has been in this situation before. - Josh ___ 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] Digest Version Available?
A digest version is still available. One difference between Mailman and Majordomo is that with Mailman, you can't subscribe to both the digest and regular versions of a single list. To change your subscription preferences, simply point your browser to http://listserver.u2ug.org, and select the list for which you want to maintain your subscription. At the bottom of the listinfo page, there is a section for current subscribers to login to maintain their subscriptions. Enter your email address click the Unsubscribe or edit options button. You will be prompted for a password. Enter the password that you should have received from mailman. If you haven't received a password, click the Remind button at the bottom of the page to have your password sent to you. Once you have logged in, there are a number of options you can set, including whether to receive the regular version or the digest version of the list. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jan Darr Sent: Monday, June 15, 2009 9:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Digest Version Available? I'm guessing that a digest version is no longer available? Thanks, Jan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Monday, June 15, 2009 11:06 AM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 2, Issue 59 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. Re: Error 30102 (Martin Scholl) -- Message: 1 Date: Mon, 15 Jun 2009 12:06:07 -0400 From: Martin Scholl msch...@martinscholl.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Error 30102 Message-ID: 200906151606.n5fg683r030...@mail175c2.megamailservers.com Content-Type: text/plain; charset=us-ascii Do you have an email address for them? Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Cell: 301-613-9572 msch...@martinscholl.com _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, June 15, 2009 11:09 AM To: 'U2 Users List' Subject: Re: [U2] Error 30102 Forward this case information to IBM as well so they can update their Objects error listing... you will not be the last person to see this issue! Would be nice to ensure the documentation is 'complete' DW _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Monday, June 15, 2009 9:52 AM To: 'U2 Users List' Subject: Re: [U2] Error 30102 Thank you. That's it. Since this machine is replication subscriber, I have to set this flag. I will amend my UniError collection and add error 30102, Replication subscriber. Not writable. Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Cell: 301-613-9572 msch...@martinscholl.com _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, June 15, 2009 9:56 AM To: 'U2 Users List' Subject: Re: [U2] Error 30102 Nothing is 'wrong' per se -- you just cannot normally write into the 'subscriber' files. If you need to write in the subscriber files 'manually' (as in, not from the publisher) then I think you put this in the RepConfig FILE=SUB_WRITEABLE DATA BP FILE=SUB_WRITEABLE DICT BP DW _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Monday, June 15, 2009 8:46 AM To: 'U2 Users List' Subject: Re: [U2] Error 30102 UniData 7.2.0 on Windows. There is something wrong with the account. I try to create any file in BP and I get the following error: In C:\IBM\ud72\sys\CTLG\a\AE_AE at line 2214 Adding/updating record is not allowed on non-writeable subscribing file BP.CATALOG(1036,1955995309). [AE] UniBasic WRITE failed, STATUS=1, check triggers. Quit CALL.CREATE.ID in file BP.CATALOG not created. The permissions in Windows are: Everyone - full control Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Cell: 301-613-9572 msch...@martinscholl.com _ From: u2-users-boun...@listserver.u2ug.org
Re: [U2] [u2u] UV on Windows question
It might be your email client, Jerry. I have the lists setup to reply-to the list itself (the default for Mailman is to reply to the original sender). Using MS Outlook 2007 here, I just clicked reply to this post, and the list address was automatically selected. Larry Hiscock Moderator From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Monday, June 01, 2009 3:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2u] UV on Windows question How interesting, you can't just reply to the email anymore, you have to change the to address. Jerry Banker snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[u2u] New Listserver
Hi all, The lists hosted by U2UG have been moved to a new server, and upgraded from majordomo to mailman. There will be a few changes in the administrative side of things (subscription management, etc), but the email address for the lists will remain the same. One not insignificant (but not really major) change is that mailman handles digests differently from majordomo. With majordomo there were 2 separate lists for each list -- a regular list and a digest list. Some folks were subscribed to BOTH the regular and digest lists. With mailman, this is no longer possible, since mailman only keeps a single list, and manages the digest based on user-selectable options. So anyone who was subscribed to a digest list and the corresponding regular list is now only subscribed to a single list, with the digest option turned on. Any user can now login and change their options from regular to digest for any of the lists to which they're subscribed. One other change is that administrative requests (subscribe, unsubscribe, etc) that are sent via email will no longer be sent to majord...@listserver.u2ug.org, but to listname-...@listserver.u2ug.org where listname is one of the lists (i.e. u2-users, u2-community, etc), and xxx is one of several commands, such as join, leave, subscribe, unsubscribe, request, etc. For example, to subscribe to u2-users, send an email to u2-users-j...@listserver.u2ug.org (or u2-users-subscr...@listserver.u2ug.org). There will still be a web-based interface to the lists as well, but the url for that will change slightly as well. The new location will be http://listserver.u2ug.org/mailman/listinfo for general information, and a list of all of the mailing lists, or http://listserver.u2ug.org/mailman/listinfo/listname for list specific information and subscription management. http://listserver.u2ug.org redirects to the general listinfo page. The IP address was just changed to point to the new server last night, so it may be a day or so before the DNS servers around the globe are all fully updated. Please be patient as we work through these changes. We will work to correct any issues that arise as quickly as possible. Thanks, Larry Hiscock Moderator ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[u2u] New Listserver
Hi all, The lists hosted by U2UG have been moved to a new server, and upgraded from majordomo to mailman. There will be a few changes in the administrative side of things (subscription management, etc), but the email address for the lists will remain the same. One not insignificant (but not really major) change is that mailman handles digests differently from majordomo. With majordomo there were 2 separate lists for each list -- a regular list and a digest list. Some folks were subscribed to BOTH the regular and digest lists. With mailman, this is no longer possible, since mailman only keeps a single list, and manages the digest based on user-selectable options. So anyone who was subscribed to a digest list and the corresponding regular list is now only subscribed to a single list, with the digest option turned on. Any user can now login and change their options from regular to digest for any of the lists to which they're subscribed. One other change is that administrative requests (subscribe, unsubscribe, etc) that are sent via email will no longer be sent to majord...@listserver.u2ug.org, but to listname-...@listserver.u2ug.org where listname is one of the lists (i.e. u2-users, u2-community, etc), and xxx is one of several commands, such as join, leave, subscribe, unsubscribe, request, etc. For example, to subscribe to u2-users, send an email to u2-users-j...@listserver.u2ug.org (or u2-users-subscr...@listserver.u2ug.org). There will still be a web-based interface to the lists as well, but the url for that will change slightly as well. The new location will be http://listserver.u2ug.org/mailman/listinfo for general information, and a list of all of the mailing lists, or http://listserver.u2ug.org/mailman/listinfo/listname for list specific information and subscription management. http://listserver.u2ug.org redirects to the general listinfo page. The IP address was just changed to point to the new server last night, so it may be a day or so before the DNS servers around the globe are all fully updated. Please be patient as we work through these changes. We will work to correct any issues that arise as quickly as possible. Thanks, Larry Hiscock Moderator ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] UV Timed INPUT
Does UV support the WAITING clause on the INPUT statement? In UD you can do: INPUT VAR WAITING 30 ELSE ... END Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 8:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OSBWRITE problem
What are the permissions to all of the directories to the path in which the files reside? The user running the script must have execute permissions on each directory in the path. We do a lot of this sort of thing, via scripts that are started by cron. The only significant difference I can see in our scripts, is that instead of running the programs they way you are, we catalog the programs with the LOCAL option (which really just creates a VOC pointer to the compiled object code), then instead of: $UDTBIN/udtEOD$LOG RUN BP CONV_ORD -N bye EOD We do: $UDTBIN/udt PHANTOM OP610 Where OP610 is an example of a VOC pointer to a LOCAL cataloged program. This runs the program as a phantom and automatically creates an output log in _PH_ Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Wednesday, March 11, 2009 11:56 AM To: u2-users@listserver.u2ug.org Subject: [U2] OSBWRITE problem I am having a problem with an OSBWRITE statement. We exchange data with Chicago, Japan, the UK, etc. We have worked out a method that we have been using for years withoput problem. On downloads the sender (AS400 or 390) submits a request to run a *nix script on our RedHat server. The script does some things including running a UniBasic program like this $UDTBIN/udtEOD$LOG RUN BP CONV_ORD -N bye EOD This is a method we haver used for many years with no problems. The script and UniBasic program run with errors. However. When run through the script, a particular OSBWRITE command does not write anything to the file. Running the UniBasic program from ECL like this: :RUN BP CONV_ORD Writes data to the file with no problem. There are other OSBWRITEs in the same program that run fine either way. The only difference is that they use relative paths FILES_AS400/poconv.pad, while the problem uses absolute paths /NTN/DATA/CORPORATE/FILES_AS400/CUST_XFER. I check the STATUS after the OSBWRITE and status is 0. The file is owned by the same user that runs the program and permissions are rw-rw-r-- umask for the user is 002 The environment in the script is setup by calling a boilerplate script containing this: # Set up the CMI environment CMIHOME=/NTN/CMI/TRANS4M UDTHOME=/NTN/CMI UDTBIN=/usr/ud/bin TERM=vt100 export CMIHOME UDTHOME UDTBIN TERM PATH=$UDTBIN:/usr/local:PROCESSES:$PATH export PATH #EOF EOF It seems to only occur when the subroutine is invoked through a script and the filename uses an absolute path. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Inter-Process Control...
Yep ... sure miss sem$wait sem$notify. You could accomplish the same thing with a simple socket-based protocol. The main process could listen on a socket and wait for any of the sub-processes to connect and send a message via the socket. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 26, 2009 12:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Inter-Process Control... I agree. I wrote two little programs. LOCK.TEST1 0001 LOCK 60 ELSE CRT '60 LOCKED' 0002 CRT 'UNLOCKED' LOCK.TEST2 0001 UNLOCK 60 0002 CRT '60 WAS UNLOCKED' LOCK.TEST1 locked 60 displayed unlocked. LOCK.TEST2 generated the error ' Program LOCK.TEST2: Line 1, Lock 60 not owned by calling process' and then displayed 60 WAS UNLOCKED. As I was playing with the test programs as I type this. it looks like the first process needs to perform the first lock. The second process will then lock, and wait on the lock until the first process unlocks. I need to be able to support many-to-one processes. The one process waits on the lock and any of the many processes need to release the lock... which the old semaphore process supported... I confess, I'm spoiled. :) Thanks Tom -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, February 26, 2009 2:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inter-Process Control... Tom, can you elaborate when you say the only process that can modify the lock is the one that set it. Isn't that exactly how a semaphore is supposed to work? Both processes should be able to set the lock but only one can have it at any moment in time. Or am I missing the point? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Wednesday, February 18, 2009 8:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Noah, Try SELECT TAB WITH (STATUS = A OR STATUS = B) AND ST_DATE = You can' have status equaling A and B at the same time! Eric Armstrong IBM Certified Solutions Expert- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: Noah Hart [mailto:n...@lipmantpa.com] Sent: Tuesday, February 17, 2009 10:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Need help with SELECT limiting MV I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank I tried SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE = But this will select records which might have a blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
