Re: [U2] Rgarding ED editor

2014-04-17 Thread McGowan, Ian
The ED/AE editor has excellent inline documentation, type "HELP" at the editor prompt, and start exploring. As others have said, if you're using AE to edit programs, you're probably doing it wrong. I love using it with prestores to do bulk updates of data (let's see eclipse do that, Doug!), wh

Re: [U2] Reporting Tools

2014-03-03 Thread McGowan, Ian
If I have a "recall" (our terminology for a canned query) like this: RECALL.SHELL Info-Trieve Shell03 Mar 2014 BOTW_DEV217:38:03 Command Name MARKETING.REP Modified: ( by

Re: [U2] Reporting Tools

2014-03-03 Thread McGowan, Ian
If you're not already, it's a really good idea to consider creating something that will make producing excel files (the number one choice of accounting groups everywhere) from your "reports" easily. Many years ago we used to physically print a bunch of reports each night, but since creating a t

Re: [U2] Left Outer Join Question

2014-03-03 Thread McGowan, Ian
I love learning little tidbits like this, that's awesome! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, March 03, 2014 10:39 AM To: U2 Users List Subject: Re: [U2] Left Outer Join Questio

Re: [U2] Left Outer Join Question

2014-03-03 Thread McGowan, Ian
The usual "pick" way to do this is to create an attribute: AE DICT FILE1 BLACKLIST 001: I 002: TRANS("FILE2", @ID, 0, 0) ; or really old-school OCONV(@ID,"TFILE2;X;0;0") 003: 004: 005: 20L 006: S :GET.LIST L1 1000 Items Selected :SELECT FILE1 WITH BLACKLIST = "" 600 Items Selected -Origi

Re: [U2] UniVerse Dictionary question

2014-02-07 Thread McGowan, Ian
y more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -----Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users L

Re: [U2] UniVerse Dictionary question

2014-02-06 Thread McGowan, Ian
That's not true for me, at least in Unidata - it inserts a literal space. Either there's a system option that controls it, or your application doesn't care about spaces in the data ;-) Try a "CA/ /*" after entering some spaces and see what you see? BOTW_DEV2>ae trin.temp test Top of New "TEST"

Re: [U2] UniVerse Dictionary question

2014-02-05 Thread McGowan, Ian
re in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian < james.mcgo...@bankofthewest.com> wrote: > It's well worth spending some time reading the AE help pages. One of > my favorites is "help +" which ends with the gem "We could go on and > on about thi

Re: [U2] UniVerse Dictionary question

2014-02-05 Thread McGowan, Ian
It's well worth spending some time reading the AE help pages. One of my favorites is "help +" which ends with the gem "We could go on and on about this, but you probably get it." I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [http://j

Re: [U2] Logging program execution in Unidata?

2014-01-07 Thread McGowan, Ian
vn to the &PH& file, which would give you date / time evidence of calls to launch (the advantage is that it has tools designed for analysis) JAVA ETC: Java etc calls can be logged outside of UniData. On 7 January 2014 12:27, McGowan, Ian wrote: > That's a good question - always g

Re: [U2] Logging program execution in Unidata?

2014-01-07 Thread McGowan, Ian
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, January 07, 2014 9:17 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? So Ian, everything is globally catalogued? -Original Message----- From: McGowan, Ian To: U2 Users Li

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
n since being catalogued, which always seemed to be an odd choice for me. It may have been run a thousand times, but not run at all in the past ten years. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Origi

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
answer the Q as to whether it's "actively" executed. > > You also get the number of times is has run since being catalogued, which > always seemed to be an odd choice for me. > It may have been run a thousand times, but not run at all in the past ten > years. >

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
when a program is called and how often and by who and from where. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Tuesday, 7 January 2014 1:08 p.m. To: U2-Users@listserver.u2ug.org Subj

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
file contains the most recent execution date for > cataloged programs. Programs that are just "RUN" I don't know of any way. > > Dale > > > On 01/06/2014 06:08 PM, McGowan, Ian wrote: >> We're looking into a major conversion late this year, which will &g

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
rs-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Monday, January 06, 2014 4:14 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? On 1/6/14, 7:08 PM, McGowan, Ian wrote: > We're looking into a major convers

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
t: Re: [U2] Logging program execution in Unidata? Ian, In universe the map file contains the most recent execution date for cataloged programs. Programs that are just "RUN" I don't know of any way. Dale On 01/06/2014 06:08 PM, McGowan, Ian wrote: > We're looking into a maj

[U2] Logging program execution in Unidata?

2014-01-06 Thread McGowan, Ian
We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaway and haven't been touched in years. It would be great to get some sense of which o

Re: [U2] [OT] Interview Questions

2013-12-16 Thread McGowan, Ian
There's an xkcd for everthing: http://xkcd.com/1179/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, December 16, 2013 6:13 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions

Re: [U2] Exporting to File regularly

2013-12-11 Thread McGowan, Ian
I actually think this is a really good solution and was my first thought. Assuming you are allowed to update the dictionary in the source file, you could add an ATB to do a TRANSLATE and make the select of those records that are in the source and not in the dest easier. Do what you need to do

Re: [U2] Calling UniObject directly from Linux?

2013-12-02 Thread McGowan, Ian
http://stackoverflow.com/questions/5877575/a-way-for-c-code-to-access-records-from-the-universe-database https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/unidata/7.2/intrcall.pdf -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.o

Re: [U2] Ref: Web Services at Universe 11.n

2013-10-31 Thread McGowan, Ian
One suggestion is to divide and conquer - break your problem into two pieces. Before trying to make outbound requests from the HP server, use something like SoapUI and get a handle on WSDL's and XML etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-bou

Re: [U2] UD hot backup/RFS options

2013-10-11 Thread McGowan, Ian
ng extra i/o for each > RFS read. But we can usually fully recover our site in a couple of > hours. We are on Unidata 7.1 and hope to move to Unidata 7.2.13 soon. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2

[U2] UD hot backup/RFS options

2013-10-11 Thread McGowan, Ian
We had a server crash 4pm yesterday (very unusual for IBM RS6000) and after guide/fixfile we had so much data corruption that a restore from previous days backup was needed. The question for the list is if anyone is successfully doing RFS or other incremental type backups? A quick google searc

Re: [U2] [OT] Interview Questions

2013-10-08 Thread McGowan, Ian
I'll share the general sentiment that writing some code or debugging a live program is important. http://www.codinghorror.com/blog/2007/02/why-cant-programmers-program.html for why. I think it's fair to have access to google while doing this, but reasonable people can disagree on that. I don

Re: [U2] uvbackup and uvrestore

2013-10-07 Thread McGowan, Ian
Anna, welcome to U2 Users! It's a little difficult to understand your question, don't know if google translate or someone local could help phrase it better? Your English is definitely better than my Spanish though ;-) Couple of suggestions, in order of easy -> hard: 1) It's not clear what you

Re: [U2] Interesting... Unidata VLIST options

2013-10-02 Thread McGowan, Ian
o:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 1:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting... Unidata VLIST options What is "!strings" ? I have no such command in Universe -Original Message- From: McGowan, Ian To:

Re: [U2] Interesting... Unidata VLIST options

2013-10-02 Thread McGowan, Ian
oject itself knows the name of what it's opening. So you can walk the object code, and reconstruct any literal strings within it. In fact I think I have a tool that does that -Original Message- From: McGowan, Ian To: U2 Users List Sent: Wed, Oct 2, 2013 9:

Re: [U2] Interesting....

2013-10-02 Thread McGowan, Ian
>The use of PORT.STATUS using the "PID" option and "LAYER.STACK" (>PORT.STATUS >PID 123456 LAYER.STACK) > over and over again can show you what hex address in the program your process > is at. I suggest calling this > 50 or 100 times in a row and inspecting the output. Once you have the hex

Re: [U2] Universe errlog reader

2013-10-01 Thread McGowan, Ian
Huh, Will, thanks for the heads up - haven't seen this message before: "Invalid UserID 111, preferences not saved. (Preferences require cookies, but no cookie was sent.)". Checking into that. Another suggestion is to share code on www.github.com. Which I think applies to anyone that codes - e

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread McGowan, Ian
Not sure if this is elegant or an ugly hack, but running "start /path/to/excel/file.xlsx" (or perhaps "cmd /c start ..file.xlsx") works, and can be handy if some people use Excel and others use OpenOffice - it's driven by whatever file associations you have in windows explorer. Regards, Ian --

Re: [U2] Select from one file with save-list from another file

2013-08-28 Thread McGowan, Ian
Create new T)ranslate ATB's in Y.INFO to lookup the data in X.INFO, and just do the query directly from Y.INFO? One thing that's common in this situation is to have an xref file where the key is PACKET.ID and attribute 1 is a multivalued list of keys for Y.INFO. If this is a packaged app, you

Re: [U2] Select from one file with save-list from another file

2013-08-27 Thread McGowan, Ian
At least on Unidata you can put the foreign key in the select statement, and that's the id that will be used: #SELECT X WITH STATUS = "ccc" Y.PACKET.ID #SAVE.LIST L1 #GET.LIST L1 #LIST Y If you put two atb names in the select, they are interleaved in the resulting saved list, which can be a qui

Re: [U2] KeyPressed

2013-08-09 Thread McGowan, Ian
Assuming Unidata (because Unibasic) the IN() function is handy (a working example at http://www.pickwiki.com/cgi-bin/wiki.pl?GetLineStack ) Syntax IN( ) Description The UniBasic IN function captures raw data from an input queue or from a terminal. Tip: IN can capture function, arrow, and other s

Re: [U2] XAdmin wiki?

2013-08-06 Thread McGowan, Ian
www.Pickwiki.com *is* disorganized, despite heroic attempts from Wendy, Rex and Tony to wrangle the content. Simpler is usually better, but pickwiki may be a little too simple - Tony did a lot of work porting 90% to mediawiki, but it's probably too much for one person to take on. As for assura

Re: [U2] Copy File to SharePoint

2013-08-01 Thread McGowan, Ian
Not an endorsement, but my kneejerk response is java: https://code.google.com/p/java-sharepoint-library/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, August 01, 2013 3:14 PM To: u2-u

Re: [U2] Writing to a Windoz box from Universe

2013-07-10 Thread McGowan, Ian
We use smbclient, scripted as though we were doing ftp's. DO.SMB: FTP.REC="lcd ":LOCALDIR FTP.REC<-1>="cd ":REMOTEDIR FTP.REC<-1>="put ":FILE FTP.REC<-1>="quit" WRITE FTP.REC ON HOME.F, "FTP.SCRIPT" PRINT "SMBing to ":ADDRESS E="!smbclient ":ADDRESS:" ":PASSWORD:" -U ":USER:"

Re: [U2] Monitoring Program: Can This Be Done?

2013-06-26 Thread McGowan, Ian
Not a technical solution, but after trying timeouts, tandem and nagging, what worked for us is peer pressure. We have a menu program that users access before getting into Unidata. I added a "show idle users" option to that program and we trained people to call the idle offenders when they rece

Re: [U2] Resurrecting a crashed session

2013-06-12 Thread McGowan, Ian
Screen, or the more modern tmux, is awesome for not disconnecting - we use it during upgrades or long-running processes in the evenings when it's possible that the dreaded windows patches will decide to install just as you're finishing a 4-hour process. It's also convenient in day-to-day use to

Re: [U2] Writing into metadata

2013-06-11 Thread McGowan, Ian
Another great tool, with a little bit of a learning curve though, is exiftool: http://www.sno.phy.queensu.ca/~phil/exiftool/ I am using it to reorganize a large photo library (which it's awesome for), but this page talks about updating tags: http://www.sno.phy.queensu.ca/~phil/exiftool/#writing

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread McGowan, Ian
If you're still using telnet in 2013, that's a security problem - you must not be in a regulated industry ;-) Putty[1], is a free ssh client (ok, it does telnet too), that seems to be the defacto standard on windows. My ROI is infinite, since I use it constantly and it's free. [1] http://www.

Re: [U2] srs4uv.com status [Was: Corrupted object in global catalog]

2013-01-04 Thread McGowan, Ian
Seems like a fun, if tedious, exercise in understanding the internals of compiled code. Surely different between ud and uv, given their lineage. Are there any tools or documentation available to give a head start? Does the debugger leak any information on the internals? It comes down to the

Re: [U2] Code Collaboration

2011-11-21 Thread McGowan, Ian
Steady now - the comment was about mediawiki attracting link spammers. Nothing 'dangerous' about it, except for the google juice of the person hosting the site. Perhaps we can move past the conversation about code collaboration being doomed to fail and have those who want to try give it a shot

Re: [U2] Code Collaboration

2011-11-19 Thread McGowan, Ian
O ye of little faith! ;-) It exists, but for me is besides the point. A wiki is *not* a great method to collaborate on the actual code. It's obviously possible, but there are much better ways (cough, github). To move this from the abstract to concrete, what kind of "code" do people imagine co

Re: [U2] Code Collaboration

2011-11-18 Thread McGowan, Ian
Rex Gozar wrote: >But let's face it, nobody's going to change or tweak your program code just >because they can. If your code is useful to them, then they might download and >use it. >...This is not a tool or convenience problem. Most people are simply not >inspired >to share what they know; tho

Re: [U2] Interesting article

2011-07-13 Thread McGowan, Ian
I respectfully disagree - through the years the few times I've been royally screwed, it's always by a closed-source vendor. I have never made a major commitment to an open-source tool and been burned. Debian, Eclipse, Tomcat, Apache and Postgres have been good to me for a long time. Not sayin

Re: [U2] Unidata command stack (history)

2011-06-14 Thread McGowan, Ian
The one on PickWiki (http://www.pickwiki.com/cgi-bin/wiki.pl?TclStack) is mine, and attempts to be somewhat "bash compatible" with ^A, ^E, ^D doing the usual things. It is (unfortunately) vt100 centric, with a small nod at wy50. I've had plans forever to add tab-expansion of file names but y'a

Re: [U2] Pick History

2011-02-07 Thread McGowan, Ian
Only 20 minutes!? How many times did he say "Orthogonal"? The best part of comp.databases.pick was teasing meaning from Henry's posts. It was always worth the effort, but often required a dictionary ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] PickWiki

2011-02-06 Thread McGowan, Ian
It turns out to be at that threshold where it interferes with the day job. Setting up mediawiki isn't a big deal, but the conversion from the current format is a semi-manual process. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.o

Re: [U2] Sending interrupt to UniBasic program

2010-08-16 Thread McGowan, Ian
If you want to script some process, passing it input as though a real user were typing, "expect" is a good tool to use. http://www.nist.gov/mel/msid/expect.cfm I'm not sure if it will help your sigint problem, but it should be immune to the CLEARINPUT verb... Ian McGowan 925.609.2554 -O

Re: [U2] Remote Printing

2010-04-30 Thread McGowan, Ian
If you can, email the user a pdf :-) I went to a lot of trouble many years ago printing via samba on AIX to local windows printers, and while it worked, it was painful to support (and then the requirements changed to have remote users with ssh but not vpn access). You can do some amazing things

Re: [U2] AccuTerm File Transfer

2010-04-29 Thread McGowan, Ian
] On Behalf Of McGowan, Ian Sent: Thursday, April 29, 2010 6:25 PM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer If you can arrange for the terminal emulator to run a command, you can fire off (for example): "cmd /c start http://myserver/files/abc123.pdf"; And the end user

Re: [U2] AccuTerm File Transfer

2010-04-29 Thread McGowan, Ian
If you can arrange for the terminal emulator to run a command, you can fire off (for example): "cmd /c start http://myserver/files/abc123.pdf"; And the end user's PC will launch the default browser and attempt to connect to the web service. You set the mime-type to application/pdf, include som

Re: [U2] UniVerse Programmer Job Opening

2010-04-23 Thread McGowan, Ian
Before everyone piles in, those candidates who cannot figure out which continent this job is offered on need not apply.. :-) Ian McGowan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bryan Evans Sent: Friday, A

Re: [U2] Embedded program for Windows

2010-02-20 Thread McGowan, Ian
OpenQM or MaVerick seem to be the only options for freely distributing a pick basic runtime. MaVerick may be interesting, in that it cross compiles pick basic to java. Robert Calhoun (?) has an antlr parser for basic. http://www.maverick-dbms.org/doc/install.html http://www.maverick-dbms.org/s

RE: [U2] What Next?

2008-08-20 Thread McGowan, Ian
Java or .Net, the red pill or the blue pill :-) You can use uniobjects to connect to your existing data and actually deliver some business value as you learn things. Write some web based query screens that you can roll out to the existing userbase. They won't care how rough it is, it will blow t

RE: [U2] locking code question

2008-05-15 Thread McGowan, Ian
doug chanco wrote: >The main issue I am trying to get resolved is to lock the record at the pick level , in >case someone does nto check out a code and then tries to edit it when another developer >already has it checked out, since most of our developers use a "pick aware" editor as >long as the r