Re: [U2] Rgarding ED editor
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!), which is arguably even more wrong, but I can't help myself ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shanmukh Nandha Sent: Thursday, April 17, 2014 2:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] Rgarding ED editor Hello Friends, Can any one help with ED editor docs in Unibasic Programming language Thank you, Shanmukh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
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 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Monday, March 03, 2014 9:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] Left Outer Join Question I have 2 files. File 2 is a black list of records (keys) I want to exclude in and active select list of File 1. I've been looking into this for a little while and am not sure what I'm doing wrong. Docs are not very helpful with any examples on the how to do with this. I know of ways to deal with this in code, but was hoping for an SQL way to deal with it. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740.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 - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
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 Question
Then, there's always:
:SELECT FILE1
xxx items selected.
NSELECT FILE 2
yyy items selected.
You can also do the same as noted below with an EVAL command. e.g.
:select FILE1 WITH EVAL TRANS('FILE2', @ID, 0, 0) =
xxx items selected.
Bill
- Original Message -
*From:* james.mcgo...@bankofthewest.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/3/2014 9:56 AM
*Subject:* Re: [U2] Left Outer Join Question
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
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
randyleesmith
Sent: Monday, March 03, 2014 9:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Left Outer Join Question
I have 2 files.
File 2 is a black list of records (keys) I want to exclude in and active
select list of File 1.
I've been looking into this for a little while and am not sure what I'm doing
wrong.
Docs are not very helpful with any examples on the how to do with this.
I know of ways to deal with this in code, but was hoping for an SQL way to
deal with it.
-
I used to be an Optimist until I knocked over the glass.
--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Quest
ion-tp42740.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
-
IMPORTANT NOTICE: This message is intended only for the addressee
and may contain confidential, privileged information. If you are not
the intended recipient, you may not use, copy or disclose any
information contained in the message. If you have received this
message in error, please notify the sender by reply e-mail and delete
the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
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 tool the users can easily use, almost everything is electronic. http://www.pickwiki.com/cgi-bin/wiki.pl?DumpRecall shows one way to do it, though it's pretty specific to our needs. It wouldn't be hard to use this as inspiration for something that works in your own environment. I'd forgotten about the 150 field limit in unidata, but this comment remembers: * We have a list of field names and a select, parse them the hard way * and write a tab-seperated file. This is slower but avoids limitations * on the number of columns (of unidata) and the perl module WriteExcel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Monday, March 03, 2014 1:05 PM To: U2 Users List; dmcgr...@rocketsoftware.com Subject: Re: [U2] Reporting Tools On 3/3/14, 4:01 PM, Daniel McGrath wrote: Hi Jeff, In case you missed it before: Does your query use the LIMIT keyword? This is an internally hardcoded limit that was increased, IIRC, in 7.3.6 to 250. On further checking, here is the issue, along with fix version. I suggest you update to the latest UDT version. UDT-4284 - Request for UniQuery hard limit of 150 attributes (in LIST or REFORMAT commands) to be increased A change was made to increase this to 250 attributes in 7.3.5. The actual limit has now been added to the report from the LIMIT verb so you can see limitation as U_ATTRLIST Thanks Dan - this helps immensely. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
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: ( bytes) Compiled: ( bytes) by root SELECT PARAMETER BY MRKT.NAME WITH @ID = 10*]~ LIST PARAMETER UATB.MRKT.NAME UATB.MRKT.OFFICE ATB Edit Copy Mail New Run Search Width Quit I get an excel spreadsheet as an attachment like this, limited only by what excel can handle. I've used a variety of formats over the years, but have come back to doing tab-delimited, but naming the file *.xls - that seems to be the most likely to not get mangled in transit and still open in a variety of spreadsheet programs and versions. NAME OFFICE 3RD PARTY SERVICER 1 AB HUSSMAN PROGRAM 4 ACCURAY, INC. PROGRAM 6 -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, March 03, 2014 1:42 PM To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Subject: Re: [U2] Reporting Tools Ian you don't happen to have an example of what this code *does* do you? IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
That's brilliant! Colin, would you mind if I steal that for www.pickwiki.com? Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Friday, February 07, 2014 2:14 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by 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 List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
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_DEV2ae trin.temp test Top of New TEST in TRIN.TEMP. *--: i 001= 1 002= 2 003= 3 004= 005= 5 006= 6 *--: p Top. 001: 1 002: 2 003: 3 004: 005: 5 006: 6 Bottom. *--: ca/ /* Changed all occurrences (1) of to * in record. *--: p Top. 001: 1 002: 2 003: 3 004: * 005: 5 006: 6 Bottom. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 06, 2014 5:10 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Hi, I use a single space which is nulled out by the editor. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, February 05, 2014 7:31 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Well, I'll be a son of a biscuit eater! I never knew that. I've done it the same way Martin does for 35 years. I just checked it in Jbase and it works. You learn something new every day. Of course, I consider a day a total waste if I don't either learn something new or catch hell about something. As you can guess, I don't have many wasted days. Thanks, Dan! Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-05-2014 6:15 PM, Daniel McGrath wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page -- -- - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
It's well worth spending some time reading the AE help pages. One of my
favorites is help + which ends with the gem We could go on and on about
this, but you probably get it. I'm a huge fan of AE, even though I spend most
of my programming time inside a visual editor (I like joe
[http://joe-editor.sourceforge.net/], not to start a religious debate). I
don't use AE prestores with the wild abandon of my misspent youth, but they're
still a handy thing to know. If anyone knows the author of AE, let me know - I
owe him or her several drinks...
The backtick is just the default 'command delimiter'. You can read more about
it with:
*--: help delimiter
Command: CDelimiter (CD)
'CD' allows you to change the command delimiter to any single character.
When you enter the editor for the first time the command delimiter is
set to the ` (weirdmark, not single quote) character.
Examples:
*--: CD [displays the current command delimiter; no change]
Command delimiter is `
*--: CD# [changes the command delimiter to '#']
Command delimiter is now #
The Command Delimiter is a single character that separates multiple
editor commands when they are entered at a single editor prompt.
Valid command delimiters are:
` , ; # $ % ~ | [ ] { } / '
and then onto prestores
Example:
*--: G10`G20`G30 [go to line 10, then to 20, then to 30]
A rather pointless command, but it illustrates the principle.
Multipart commands are very useful as prestored commands. They allow
processing many records with a single command. For example, suppose
you had a select list of 100 records, and each of them needs every
occurrence of '100' changed to '250'. You can do this with a multipart
prestored command.
First create the prestored command:
=DOITALL CU/100/250`FI`=DOITALL
Then run the command '=DOITALL' by entering '=DOITALL' as a command.
The editor will then loop through the list of records, perform the
change for each of them, file each of them, and then run =DOITALL again
on the next record.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, February 05, 2014 4:33 PM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary question
Unreal. This old dog just learnt a new trick.
On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath
dmcgr...@rocketsoftware.comwrote:
A tip my original mentor taught me on the first day was that in ED/AE,
the back tick (`) gets treated as an empty line so you can keep going
in insert mode and not need to worry about it.
Regards,
Dan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: Wednesday, February 05, 2014 5:07 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Dictionary question
The dots were just there to keep the numbered list going, The same I
use dots in the Editor to enter blank lines. Later I go to the top and
do
R/.//50 to remove the dot.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, February 04, 2014 3:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Dictionary question
What are the periods in 3 and 4 for?
Did you try removing those?
-Original Message-
From: Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 4, 2014 11:49 am
Subject: Re: [U2] UniVerse Dictionary question
Just to make sure, you're wanting FIELD 178 and the first value of
that field. Correct? Because you have a length of 1, left justified
I want to make sure you're not looking for the first character of the 178th
field.
Maybe if you showed what you're wanting and what you're getting,
instead, then we'd be sure to give you an answer that makes sense.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill
Haskett
Sent: Tuesday, February 04, 2014 11:45 AM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary queston
Martin:
This is the only way to do accomplish the defined task in UniData.
Maybe @RECORD178,1 is the preferred method in UV.
Bill
Untitled Page
--
--
- Original Message -
*From:* msch...@martinscholl.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/4/2014 11:33 AM
*Subject:* [U2] UniVerse Dictionary queston
UniVerse.
I want to create a dictionary item that extract value 178,1
I thought
1. I
2. EXTRACT(@RECORD,178,1,0)
3. .
4. .
5. 1L
6. S
Would do but it does not give me the desired result. Any suggestions?
___
U2-Users mailing list
Re: [U2] UniVerse Dictionary question
http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian james.mcgo...@bankofthewest.com wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
It's probably overkill, but we have an elaborate scheme for dealing with compiling code. It ties into our source control and build methods. * All generic/utility programs are cataloged global so the same version is available in all accounts. * Anything specific to a particular account (we have multiple accounts for different lines of business) is cataloged local, so the object code lives in the account, and we get that specific version if the account is ever restored or if we're working in an old copy (we keep month end copies going back a year). * Our vendor code arrives cataloged direct - there are VOC pointers to the object code in a central directory. Dennis had the best point - there's going to be a few different methods to pull together a broad picture of what's used. -Original Message- From: u2-users-boun...@listserver.u2ug.org [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 james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 6:57 pm Subject: Re: [U2] Logging program execution in Unidata? Wow! Didn't know about that command either. This has been very instructional. I can easily filter out the vendor code from that command by path, and just see our custom programs. There seems to be some caching going on too, at least until the user logs off - the reference count stays for some period of time. It runs really fast too, so I could run a cron job once per minute and not have too much overhead. Every 10 minutes wouldn't be good enough, but we likely have few processes that login, do their thing and then logout within a minute. Most of those would be web-service clients, and those call a couple of generic handlers first. Great suggestion, thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Monday, January 06, 2014 5:24 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? I believe there is something wrong with this suggestions. IIRC you don't get the time and date it was last RUN, only the date it was last Accessed. I suspect this is the touch date, which could mean that just looking at it in a directory scan, touches it. Along with a host of other things that don't actually *run* the code. So it wouldn't 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. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 4:55 pm Subject: Re: [U2] Logging program execution in Unidata? Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular
Re: [U2] Logging program execution in Unidata?
Dennis, I think you're right that a combo is the best approach. There were several great ideas in this thread, and it was a good opportunity to learn some new things (apparently I just don't read the manuals like I used to ;_) We do use a pseudo-TCL utility called STACK - http://www.pickwiki.com/cgi-bin/wiki.pl?TclStack - and it does indeed log what the OPS folks are doing. Duh! Should have thought of that.. Between that, sbcsprogs and our STREAM command (which stores commands in a file), we should be able to get a pretty good idea of what's going on. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dennis Bartlett Sent: Monday, January 06, 2014 10:02 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Ian Perhaps your answer lies in a combo - rather than looking at the actual code you have, why not focus on what calls it: This will minimise what changes are needed. MENU: you say you don't have code for the menu system - but you do have access to the VOC, so why not do the R pointer thing on the VOC entries of the menu stuff. A little research could get the main 'calling' routine, and maybe something like uniVerse's @PARASENTENCE might tell you what was called. FILES USED: Files can have triggers applied that simply 'touch' a file at o/s level - file being named of file:date:time:seq:action. The resultant ls will tell you what files were read/written and when. TCL: As for the ops staff dropping to TCL, you could write a pseudo TCL that has all the commands, but logs their use. I've seen this done successfully in situations where some staff are limited in what they can do. Most folk don't even realise they're at a pseudo level. CRON: As for the cron items, what about R pointer'ing the PHANTOM verb (dunno if that's possible!) - then you could trap what's being launched each time. Alternatively, stepping outside of the UniData environment you could apply svn 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 james.mcgo...@bankofthewest.comwrote: That's a good question - always get to what the user really needs, not what they say they want ;-) I support a vendor supplied application. It runs from the LOGIN paragraph and provides a menu interface. Over the years we have written a lot of supporting code around the vendor app, so now we have (at least) four ways a custom program can be run: 1) We can add user-defined menu items and they get EXECUTE'd from the menu (by code I don't have access to) 2) Our operations people can drop to TCL and run a command directly from there 3) We have an elaborate cron setup that ends up running streams on a variety of schedules 4) We use uniobjects, and different external interfaces making calls into Unidata (mostly subroutine calls from java and .net clients) As a result of an upcoming upgrade (in 1 year), we're likely going to have to touch all of the programs and make some modifications. Ideally we'd cut down the number by disregarding one-off programs that haven't run in ages. We have programs last compiled in 2004, but I know they run many times per day, so time-stamps don't cut it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, January 06, 2014 5:31 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Ian, You said you didn't have a wrapper program. How do your programs get executed? Charlie On 01-06-2014 7:23 PM, Baakkonen, Rodney A (Rod) 46K wrote: What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging
[U2] Logging program execution in Unidata?
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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: 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 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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
Will/Jeff, you're right that it's an option, but it's not a very appetizing option. We certainly could add an include or subroutine at the top of every program (does anyone care about the performance difference between the two anymore? That used to be a big deal :-). Less concern with how to do that, and more with the broader impact, as well as blowing the minds of our change control group. It's hard to prove there won't be *any* possible breakage from such a lot of recompiles. Let's call that plan b... Ian -Original Message- From: u2-users-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 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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Can I assume you're not excited about inserting some logging code into each program simply do to the number of pieces to edit? We have done this programatically with all paragraphs and I image the same approach would be possible with programs. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: 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 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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Logging program execution in Unidata?
Phil, thanks for the suggestion. This isn't going to work for us as we catalog our programs and don't generally catalog direct. I.e. we don't have VOC pointers (except when someone forgets and does FIBR from within AE). Thanks for the idea though; I learned two new things today - off to check out R pointers now! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Monday, January 06, 2014 4:17 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Maybe convert the VOC entries for the programs to R pointers. The r pointer would point to a file with the original VOC entry for the program. Then in attribute 4 of the R pointer put a security subroutine which logs the calling details for each call etc. That way you can gain a picture of 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 Subject: [U2] Logging program execution in Unidata? 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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
That's a good question - always get to what the user really needs, not what they say they want ;-) I support a vendor supplied application. It runs from the LOGIN paragraph and provides a menu interface. Over the years we have written a lot of supporting code around the vendor app, so now we have (at least) four ways a custom program can be run: 1) We can add user-defined menu items and they get EXECUTE'd from the menu (by code I don't have access to) 2) Our operations people can drop to TCL and run a command directly from there 3) We have an elaborate cron setup that ends up running streams on a variety of schedules 4) We use uniobjects, and different external interfaces making calls into Unidata (mostly subroutine calls from java and .net clients) As a result of an upcoming upgrade (in 1 year), we're likely going to have to touch all of the programs and make some modifications. Ideally we'd cut down the number by disregarding one-off programs that haven't run in ages. We have programs last compiled in 2004, but I know they run many times per day, so time-stamps don't cut it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, January 06, 2014 5:31 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Ian, You said you didn't have a wrapper program. How do your programs get executed? Charlie On 01-06-2014 7:23 PM, Baakkonen, Rodney A (Rod) 46K wrote: What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? I believe there is something wrong with this suggestions. IIRC you don't get the time and date it was last RUN, only the date it was last Accessed. I suspect this is the touch date, which could mean that just looking at it in a directory scan, touches it. Along with a host of other things that don't actually *run* the code. So it wouldn't 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. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 4:55 pm Subject: Re: [U2] Logging program execution in Unidata? Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: 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 major conversion late this year, which
Re: [U2] Logging program execution in Unidata?
Wow! Didn't know about that command either. This has been very instructional. I can easily filter out the vendor code from that command by path, and just see our custom programs. There seems to be some caching going on too, at least until the user logs off - the reference count stays for some period of time. It runs really fast too, so I could run a cron job once per minute and not have too much overhead. Every 10 minutes wouldn't be good enough, but we likely have few processes that login, do their thing and then logout within a minute. Most of those would be web-service clients, and those call a couple of generic handlers first. Great suggestion, thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Monday, January 06, 2014 5:24 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? I believe there is something wrong with this suggestions. IIRC you don't get the time and date it was last RUN, only the date it was last Accessed. I suspect this is the touch date, which could mean that just looking at it in a directory scan, touches it. Along with a host of other things that don't actually *run* the code. So it wouldn't 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. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 4:55 pm Subject: Re: [U2] Logging program execution in Unidata? Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: 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 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 ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas
Re: [U2] [OT] Interview Questions
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 Another option, which I always have done, is to iconv dates in 15 Jan 2013 format. This always works regardless of which date method is selected. Don't know why yanks do things that irritate you. But then, most people do things that irritate someone. As Mark Brown always points out; the trouble with standards is everybody has one. This seems more of an issue than what yanks do. :-) Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 12/16/2013 6:00 PM *Subject:* Re: [U2] [OT] Interview Questions On 17/12/2013 00:17, Wjhonson wrote: What is the last Thursday of the current month. Current Date minus Current Day of Month number plus 1 puts you on the first of the current month Or you could just Oconv d2/ and replace the middle number with 01 with Iconv that. Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY, D2) gives me 17/12/13. If I replace the middle number (or if Kevin replaced the middle number) we'd both end up somewhere in January! Why do you Yanks put the least significant number in the middle? That's crazy! If you want the first of the month, the easiest way to do it is FIRST = 01/:OCONV(@TODAY,D2[M,Y]) (if I've remembered my syntax correctly). Then to get that into internal format I_FIRST = ICONV(FIRST, D2DMY) You should NEVER assume that dates are in the format you expect, unless you are in control (which you aren't, here, seeing as you've messed up pretty spectacularly :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exporting to File regularly
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 with that list. Then use SREFORMAT (does uv have that command?) to just copy the ID's of the list to the target to mark them done. HELP SREFORMAT is: Help Information For: UNIQUERY SREFORMAT Page: 1/3 SREFORMAT Syntax SREFORMAT filename attributes [selection_criteria] Description The UniQuery SREFORMAT command sorts specified records by their record IDs and copies the record attributes from one file to another file. SREFORMAT uses the first attribute named in the UniQuery statement as the record ID in the destination file. The remaining attributes in the UniQuery statement become record attributes in the destination file. UniQuery prompts for the name of the destination file after you enter the SREFORMAT command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Wednesday, December 11, 2013 10:38 AM To: U2 Users List Subject: Re: [U2] Exporting to File regularly Hi David, Though this is not a great option, you could create a new file and either just copy the current contents of the file you want to watch into it or just a fingerprint record if all you need is a record exists type of monitoring. Then a simple SELECT of the first file followed by an NSELECT of the fingerprint file would give you a resulting active select list, if any, of the new records which you could use to update your fingerprint file. These would be done inside a new., small program that you could then send an email message from. Run it from the OS's task scheduler and it's fully automated. Like I said, this is probably NOT the best solution but it gives you another approach to consider, depending on your needs. It also is completely separate from the current system you have with no interference of the vendors application. I'd be happy to give you more specifics if you want to try this. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Tuesday, December 10, 2013 9:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to File regularly Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regul arly-tp42264.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 - IMPORTANT NOTICE:
Re: [U2] Calling UniObject directly from Linux?
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.org] On Behalf Of Augusto Alonso Sent: Monday, December 02, 2013 10:31 AM To: U2 Users List Subject: [U2] Calling UniObject directly from Linux? Hi all. Does anyone know a way to call UniObject directly from Linux? Not UniObject for Java, but directly from a C++ program or similar. I have looking for it but I haven't found anything Any suggestions? Thanks in advance. -- Augusto Alonso I.T. Manager QUITER SERVICIOS CENTRALES ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ 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
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-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. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UD hot backup/RFS options
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 search shows a lot of people asking questions, but not a lot of it works great success stories. Looking to get a sense of real world usage before heading down that road, and potentially paying for consulting to implement. Any input, opinions, advice appreciated! Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD hot backup/RFS options
Thanks Ty and Rod. Good to hear RFS works well - perhaps the lack of google hits is because it Just Works (tm). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ty Haller Sent: Friday, October 11, 2013 8:28 AM To: U2 Users List Subject: Re: [U2] UD hot backup/RFS options We've been using RFS with Replication for years. Our entire DB is setup with RFS and is replicated, about 300GB. (AIX 7.1 UniData 7.2.13) The RFS Logs are on a separate set of RAID 10 Disks, and doesn't seem to add that much overhead although we are utilizing SSDs now. GUIDE Runs pretty fast 1hr. We run a triple mirror setup and split off the mirror nightly to backup. Any crashes (rare), RFS has been able to recover from. If needed we could run off of our DR System or copy the data back again (couple of hours). Ty Haller SEFCU Lead Administrator - System Services thal...@sefcu.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, October 11, 2013 11:19 AM To: U2 Users List Subject: Re: [U2] UD hot backup/RFS options We have used it for about 15 years. I can remember the last time we crashed (Solaris). IF the redo logs look ok and the Unidata logs don't have issues, I don't run guide on our RFS files. We only have our largest files defined as RFS (10 gigabytes to almost 100 gigabytes). We did not put in the begin/end transaction statements in our code. So RFS uses a timing mechanism to figure out when to write data out. There is a performance difference, as you are doing 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.u2ug.org] On Behalf Of McGowan, Ian Sent: Friday, October 11, 2013 9:33 AM To: U2 Users List Subject: [U2] UD hot backup/RFS options 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 search shows a lot of people asking questions, but not a lot of it works great success stories. Looking to get a sense of real world usage before heading down that road, and potentially paying for consulting to implement. Any input, opinions, advice appreciated! Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2013 Cigna === === ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message may contain confidential information and is intended for the sole purpose of communication with the addressee. Dissemination or publication in any format is strictly prohibited. If you have received this communication in error please notify SEFCU immediately. Help save a tree. Please print this e-mail only if it is truly necessary. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
I'll 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't think there are any magical interview questions that will weed out the recalcitrant. It comes down to 1) *can* they do the job, and 2) *will* they do the job? A fizzbuzz test and some technical questions may answer #1, but there's really no predicting #2. In my old job I managed several teams of about 50 people total, and eventually gave up on interviews as a talent sieve and started doing contract-to-hire for 1-3 months. Actual performance is a much better predictor of future performance than interview performance. This dramatically changes the type of people you end up hiring, but for me it was worth the trade-off. My best hire ever was a mumbling, inarticulate, 20-year old drop out from Boulder. Later provided living proof that 100x programmers exist. He's a senior dev at Evite now ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 07, 2013 7:36 PM To: U2 Users List Subject: [U2] [OT] Interview Questions This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uvbackup and uvrestore
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 your question is - perhaps read chapter 12 of the manual and form some specific questions? https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/10.3/admin.pdf explains some of the parameters you are seeing. 1.5) Post the entire script, not just the one line. Is it a .bat file? 2) If you are not confident in the backups, while the system is not busy (or if you can safely shutdown [and startup!] uv even better) simply copy the entire folder that contains your universe data files somewhere safe. This is just in case anything goes wrong while you are getting up to speed. This is not the ideal backup method, but a partial backup is better than none at all. 3) If you have a test system, copy the backup created by the uvbackup command there and attempt to restore using uvrestore. Unless you can do this, your backup is just theoretical - it's worthless without the ability to restore somewhere. We are just going through an annual disaster recovery test, so I may be a little paranoid about backups right now. Regards, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anna Sent: Monday, October 07, 2013 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] uvbackup and uvrestore Hi, I am new here, abouts between one of my new tasks it is to take charge of a computer with Universe, with Open Suse, that I leave another company of service. Of universe do not know anything, for what I have seen at least safety copies are done in a file copia.bk. I have not even idea if other day I have to restore the safety copy, someone can help me. The command that does the copy is this: %uvdir %\bin\UVBACKUP-v-f-notag-l Co %DAY % -cmdfil %Pdir %\bin\COPY\list _ % SAVE %.txt-s %Pdir %\bin\COPY\LOG _ % SAVE %.txt-t nul 2 nul thank you ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting....
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 addresses, use VLIST to figure out what line in the program each address represents. Does anyone have tips for doing the equivalent in Unidata (when you don't have source code, obviously)? I end up using truss or strace to at least see which files are opened/written to, which can be instructive but really hard to follow. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting... Unidata VLIST options
Changing the subject to not hijack the other thread. Yes, I too have a program that basically does a strings command on the object code and either dumps all strings or for each one looks it up in the VOC to check if it's a file. https://github.com/ianmcgowan/PickCode/blob/master/CHECK.FILES -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 9:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting I have to think (and I havent' yet checked) that the names of the files opened will appear within the object code, since they have to be represented as literal strings when they are named. Sure you could pass the name in, but then the program wouldn't know it either, so we're just talking about files where the project 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 james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 9:42 am Subject: Re: [U2] Interesting 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 addresses, use VLIST to figure out what line in the program each address represents. Does anyone have tips for doing the equivalent in Unidata (when you don't have source code, obviously)? I end up using truss or strace to at least see which files are opened/written to, which can be instructive but really hard to follow. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting... Unidata VLIST options
Po-te-to/Po-ta-to. http://technet.microsoft.com/en-us/sysinternals/bb897439.aspx A unidata VLIST clone would be great, and I've spent a long time looking at object code and can see some patterns, but it's grueling to get going. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 10:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting... Unidata VLIST options A, my tool was written for use on Windows. -Original Message- From: Dave Davis dda...@harriscomputer.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 10:49 am Subject: Re: [U2] Interesting... Unidata VLIST options It's a *nix command that shows the displayable characters in a file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: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 james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 10:42 am Subject: Re: [U2] Interesting... Unidata VLIST options Changing the subject to not hijack the other thread. Yes, I too have a program that basically does a strings command on the object code and either dumps all strings or for each one looks it up in the VOC to check if it's a file. https://github.com/ianmcgowan/PickCode/blob/master/CHECK.FILES -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 9:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting I have to think (and I havent' yet checked) that the names of the files opened will appear within the object code, since they have to be represented as literal strings when they are named. Sure you could pass the name in, but then the program wouldn't know it either, so we're just talking about files where the project 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 james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 9:42 am Subject: Re: [U2] Interesting 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 addresses, use VLIST to figure out what line in the program each address represents. Does anyone have tips for doing the equivalent in Unidata (when you don't have source code, obviously)? I end up using truss or strace to at least see which files are opened/written to, which can be instructive but really hard to follow. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe errlog reader
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 - even in such a, ahem, mature language as we do. If you don't want to go to the trouble of packaging code into an honest-to-goodness project, there's always https://gist.github.com/ which is for those less well formed ideas. Is anyone using github for MV code? Is there any way to tag a project so it's easy to find other Pick Basic diehards? I've never been really happy with the way pickwiki handles code submissions, but not unhappy enough to do something about it... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 01, 2013 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe errlog reader I can't figure out why I can't log into the Pickwiki, so I went ahead and put this routine up at https://sites.google.com/site/pickuniverse/codeexamples/errlog-reader It displays the errlog in a more readable fashion (at least in my opinion). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TU.TO.EXCEL path
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 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Thursday, September 19, 2013 10:23 AM To: U2 Users List Subject: Re: [U2] TU.TO.EXCEL path We've yet to find an elegant way around this since U2 doesn't have access to the environment variables on the client desktop. If you just have two or three users to code for you could handle it with a case statement. If you have more, you might want to create a database file to keep each user's path in. Or, as you mentioned, you could make sure every desktop uses the same path. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, September 19, 2013 9:52 AM To: U2 Users List Subject: Re: [U2] TU.TO.EXCEL path Hi All, I wrote a program to provide a file to download to Excel. It works fine for me but when I ask the helpdesk to run the report it fails with the error: Microsoft Excel cannot access the file 'c:\progra~1\micros~3\office13\'. The user's path is: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Excel 2010.lnk How can I fix this? Do I have to always have Excel installed in the same path? Or can the path be stored in a table per user? Thanks for any help, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
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 may not have that luxury though ;-) E.g. in Y.INFO, :AE DICT Y.INFO X.STATUS I OCONV(PACKET.ID,TX.INFO;X;19;19) -- use the right field position of course :AE DICT Y.INFO X.DOB I OCONV(PACKET.INFO,X.INFO;X;22;22) :SORT Y.INFO WITH X.STATUS = ccc BILL.DAY BILL.AMT X.DOB Etc.? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon Sent: Wednesday, August 28, 2013 8:07 AM To: U2 Users List Subject: Re: [U2] Select from one file with save-list from another file Thanks everyone, I've got some usable info to work with. Sorry if my original post was a bit vague, let me illustrate to clarify: X.INFO @PACKET.ID.NAME..DOB...STATUS 52781456.52781456..DOE, JOHN.06-17-1985CCC Y.INFO @BILL.DAY..BILL.AMT..TYPE..PACKET.ID 52781456*MPA*2...08/28/201350MPA...52781456 Hopefully showing a rough table structure helps me better convey what I was trying to do. Using criteria in X.INFO to create a selection list and then using that list to select and export information from Y.INFO like BILL.DAY and BILL.AMT that wasn't available in X.INFO. Since a select list made from X.INFO would have different record ID's, it wouldn't be able to be used to select from Y.INFO. Hence, me looking for some trickery to use Y.INFO's PACKET.ID field as the array for the select list to work against. Brandon -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On 8/27/2013 1:24 PM, Hilk, Brandon wrote: Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
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 quick way to export some data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon Sent: Tuesday, August 27, 2013 1:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select from one file with save-list from another file Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] KeyPressed
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 special keys from the keyboard. Example In the following example, the program segment assigns the value y to ANSWER: DATA y ANSWER = IN() -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, August 09, 2013 1:04 PM To: 'U2 Users List' Subject: [U2] KeyPressed With Dynamic Connect... and UniBasic... I need a screen that continuously displays time... as we have an inspection screen where press operators enter fresh data each hour. Something like... loop call *timeOfDay call *displayOtherStuff input thisKey, -1 until (thisKey = '1') sleep repeat gosub secondScreen The trouble with this thing is... when a key is pressed... it wants to display the key on asubsequent screen. I tried...inputclear... but it is not doing what I want. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin wiki?
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 assurances for the future, I will not sell or give the wiki to a commercial entity. I don't plan on shutting it down ever, and I make a nightly tarball of the articles and software used to run the wiki so that everyone who wants a copy of their content for safekeeping can have it. It costs me $20/month for a low-end VPS that I use for other side projects, so the cost is minimal, and I've met (virtually) some great people who have shared a lot of their time and expertise with no expectation of a return. ad Consider this a plug to share information and tips in blog posts (where you own the content or platform) and on pickwiki (which may get you a minutely larger audience) as well as this mailing list. The more we share, the richer we become. /ad -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, August 05, 2013 5:35 PM To: U2 Users List Subject: Re: [U2] XAdmin wiki? You know, I'd have no problem updating documentation to a wiki site, where I know all documentation would go and I could continue to reference the documentation in the future. The Pickwiki is a little disorganized, but since I do most of my database work with U2 I'd be happy to update anything to a wiki they provide. The biggest problem I see is the changing technology. Everything changes, including wikis! Simple is always better, and since we're all developers to one degree or another, we don't need a completely idiot-proof environment; just someone at U2's end who can keep us idiots in line and keep the site organized. Just my $.02. :-) Bill - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 8/5/2013 4:57 PM *Subject:* Re: [U2] XAdmin wiki? Hi: The problem is not whether you need a wiki or not. The problem is the documentation is terrible and in most cases non-existent. A year ago at U2 University a majority of us discussed this with the board of Rocket U2. The agreed with us they would fix this and show some examples as well. Well, here we are a year and many months later with the same problem. New users and non-eclipse users cannot figure out how this tool works. Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to use this tool and the others. However, since the tools are given away by Rocket there is little money in the pot for any meaningful help. Regards, Doug www.u2logic.com Better documentation for our XLr8 Tools ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Copy File to SharePoint
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-users@listserver.u2ug.org Subject: Re: [U2] Copy File to SharePoint Has anyone figured out a way to take a file from UNIX and copy it into SharePoint? Google for unix to sharepoint returns good results. HTH T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writing to a Windoz box from Universe
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: ~/FTP.SCRIPT PRINT E EXECUTE E RETURN It's available from IBM on one of the AIX DVD's, just not supported. http://www.ibm.com/developerworks/aix/library/au-aix_samba/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, July 10, 2013 5:39 PM To: U2 Users List Subject: Re: [U2] Writing to a Windoz box from Universe Last time I checked, AIX has no native built-in capabilities to mount CIFS/Windows shares. 1. Samba/AIX port - open source If you wish to load the Samba port to AIX, you can use smbclient to perform an sftp/ftp like connection that'll mount the share temporarily - then you can get/put the file(s), etc. 2. FastConnect - IBM supported If you use IBM's FastConnect for AIX - you have to mount the share as a filesystem first - as smbclient is not supported unfortunately. Both solutions - of course - require a Windows account to connect to the Windows server and it must have sufficient rights on that share/filesystem to write/read/delete files, etc. Having a Windows share mounted all the time can be a security risk - especially if using generic Windows accounts with too much rights. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, 11 July 2013 5:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Writing to a Windoz box from Universe I simply want to write a filename to a Windoz server from an IBM box running AIX. What is the simplest method? I would like to avoid ftp. Been there, done that! Thanks! Boyd Boyd Parks MDIV ERA Programmer/Analyst 770.237.7541 770.975.3303 (cell) 770.237.6541 (fax) McKesson Business Performance Services www.mckesson.comhttp://www.mckesson.com ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring Program: Can This Be Done?
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 received the no more licenses message. If you're on unidata/unix, http://www.pickwiki.com/cgi-bin/wiki.pl?IdleUsers is a perl script that provides a nice listing of the listuser command. For your original question, I don't know about how to capture the timestamp for SB activity, but http://www.autohotkey.com/ is an amazing piece of software that can definitely switch to the SBClient window and hit escape a bunch of times. I have used it several times to 'scrape' data from one system and plug it into another, when more elegant solutions wouldn't work for whatever reason... Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Wednesday, June 26, 2013 2:23 PM To: (u2-users@listserver.u2ug.org) Subject: [U2] OT: Monitoring Program: Can This Be Done? Tried sending this to sbsolutions but it didn't appear to get there so I'll try here in hopes some of you are using SB+/SBClient We are having an issue where we are using all of our licenses by midday. Our current procedure is to send out a broadcast e-mail asking those who are not using the application to log off SBClient. We believe that what is happening is that certain PCs on the shop floor have SBClient started; some activity recorded and then the user walks away from the workstation leaving the particular screen open. I have been asked to inquire if there is a way I can write a C# program to be installed on certain (shop floor) PCs to log SBClient activity (keystrokes?) with a timestamp. This program would then read the last activity timestamp, compare it to the current time and if the interim is greater than a certain number of minutes execute a series of Escape strokes to back the app out to the close screen and thus free up licenses. Has anybody attempted this? If so can you share what you did? Thanks. Albert DeWitt, CPIM Sr. Programmer Analyst ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Resurrecting a crashed session
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 have virtual tabs that you can flip between in one-session. I disconnect at work, go home and fire up the VPN, and then screen -r reconnects all my sessions at exactly the same point I left them. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 12, 2013 2:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Resurrecting a crashed session On 12/06/13 15:35, Dan Goble wrote: If you are using unix / linux as your OS then, use the tandem command to attach to the session. At the unix prompt as root type in tandem unidata_session_number Then the esc key F to enter and esc key X to exit Or use the screen command. It sticks a layer between your network session and the command you're running specifically so you can do that sort of thing. I've never really used it so I can't give you any hints but I know that's what it's meant for. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writing into metadata
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 It can be as simple as: #exiftool -DateTimeOriginal+=5:10:2 10:48:0 IMG_1234.JPG To update the DateTimeOriginal tag. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Tuesday, June 11, 2013 5:14 AM To: 'Manu Fernandes'; 'U2 Users List' Subject: Re: [U2] Writing into metadata Thanks, Manu. This does look like it would do everything I need - both now and future things I hadn't even considered! It does look like a bit of a learning curve, but worth it. SJ -Original Message- From: Manu Fernandes [mailto:e...@infodata.lu] Sent: Tuesday, June 11, 2013 7:47 AM To: sjos...@sjplus.com; U2 Users List Subject: RE: [U2] Writing into metadata Hi, We use ImageMagick (http://www.imagemagick.org/) ; It provides OS command line to read / write picture properties ; and many other tools for image manipulation. Check identify -verbose picturefilename then parse what you need ; or use escapes (http://www.imagemagick.org/script/escape.php) to pick elements. Free, Available on win / linux Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Susan Joslyn Envoyé : mardi 11 juin 2013 12:53 À : u2-users@listserver.u2ug.org Objet : [U2] Writing into metadata Hi everyone, Does any one know how to use a unibasic program to write into the metadata of a .jpg file in windows? Or to read, rename and write that file? If someone knows how to do it with a windows tool I'm game, but I've looked into some that require me to learn a lot of new skills that I cannot invest in for this particular little project. Appreciate any thoughts or ideas. Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a special character in a SELECT (UV)
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.chiark.greenend.org.uk/~sgtatham/putty/download.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, May 16, 2013 10:14 AM To: U2 Users List Subject: Re: [U2] Selecting a special character in a SELECT (UV) Whatever came with windows 98. Different from the one that came with XP. I'm guessing it's in how it does the VT100 emulation. It doesn't have any ability To tweek the mapping either. For 99.9% of the time, this is absolutely all we need, and it's easy to use for Everyone. Don't really need to change at this point, it still works. You get what you pay for -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, May 16, 2013 12:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selecting a special character in a SELECT (UV) What telnet program do you use -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, May 16, 2013 8:09 am Subject: Re: [U2] Selecting a special character in a SELECT (UV) OK. I was trying to figure out how to stick an EVAL into it, but didn't get the formatting correct. That works as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, May 16, 2013 11:05 AM To: U2 Users List Subject: Re: [U2] Selecting a special character in a SELECT (UV) SELECT filename WITH EVAL INDEX( @ID, CHAR(160), 1) 0 On 5/16/2013 8:41 AM, George Gallen wrote: Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE ...^160... But that didn't work. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] srs4uv.com status [Was: Corrupted object in global catalog]
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 question of how does: # cat IAN.TEST PRINT HELLO Turn into: # od -c _IAN.TEST 000 001 ? ÿ ÿ \0 p \0 001 \0 \0 \0 \0 \0 \0 \0 \0 020 \0 003 \0 001 \0 \0 \0 0 \0 \0 \0 \0 \0 \0 \0 040 / i n f o / D E V E L / B P . D 060 E V / I A N . T E S T \0 - 1 \0 H 100 E L L O \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 120 \0 004 \0 033 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 140 \0 005 \0 002 \0 \0 \0 034 ÿ ÿ ÿ ÿ \0 \0 \0 \0 160 \0 004 \0 005 \0 \0 \0 037 \0 \0 \0 \0 \0 \0 \0 \0 200 001 214 \0 001 \0 001 \0 005 \0 \0 \0 020 \0 001 \0 , 220 \0 001 \0 020 \0 002 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, January 04, 2013 3:11 PM To: 'U2 Users List' Subject: Re: [U2] srs4uv.com status [Was: Corrupted object in global catalog] Question on the Source Code Recovery -- is the logic such that it could be 'open sourced' or GPL'd? Or is there another way to do the source recovery? That is, were the mechanics sold to Rocket Software Professional Services? If not, could they be sold to another company is someone wanted to keep the product active? While I don't have a need now, I like to think there is a place to go for 'the unthinkable' if it happened! Just wondering!! I don't know the circumstances that led to withdrawing this service -- I would think it would rarely be needed, but when it was, would be invaluable. Seems a loss if it's now got to be re-written from scratch!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gyle Iverson Sent: Thursday, January 03, 2013 7:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] srs4uv.com status [Was: Corrupted object in global catalog] Thanks for your comments David. I left http://srs4uv.com/ on-line for now. The hosting expires 2012/02/21 and the domain expires 2012/02/28. I added a Donate button to the main page in case people want to keep the site around and the links to it from breaking. Otherwise, the site vanishes next month. Gyle ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Collaboration
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? The doubters can defer their schadenfreude until the *actual* failure :-) Ian Sent with Good (www.good.com) -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: Monday, November 21, 2011 12:17 AM Pacific Standard Time To: 'U2 Users List' Subject:Re: [U2] Code Collaboration So you admit this is dangerous and yet you still publish some one else's link ? Remind me not to give you any of my email or link addresses -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 19 November 2011 22:45 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Code Collaboration http://nebula-rnd.com/mediawiki/index.php?title=Special:AllPages I hope you have some kind of spam control on the install It doesn't come natively with one, as I've learned after 2 or 4 thousand vandalisms -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Sat, Nov 19, 2011 12:59 pm Subject: Re: [U2] Code Collaboration From: Wjhonson It exists So that's two people who mention something without giving any link TO it. Makes you wonder why no one visits it!! Will, I'm reminded why I don't get into forum discussions with you - you don't read information that's provided. In the name of brevity here (Never invite Tony to give a one minute speech !) I had taken my forum posting and moved it out to my blog. In that blog I have a link to the wiki prototype. With apologies, I didn't post the link here as I thought. But if you had visited the blog which I created specifically to respond to your points, you would have found the MediaWiki prototype replacement for PickWiki. removethisNebula-RnD.com/blog/tech/mv/2011/11/mvcollaboration.htm l But beating on the same drum, does github have email subscription notifications of pages you are watching (but to which you have not contributed) ? If not, then it's the same old problem. You have to go to it, to even remember that it's there. Response 1, I refer again to: http://ilikestuffblog.com/2011/07/14/github-notifications-suck/ Response 2, see comment in my last note: Nothing is perfect. Join millions of people who deal with that concept every day. Response 3: (again) you can get notifications by other means. I disagree that people will not use a wiki to contribute code changes. Disagree, but here's the change log showing activity over the last year: http://www.pickwiki.com/cgi-bin/wiki.pl?RecentChanges Last month you yourself added a link to a page that doesn't exist. (Thank you for that valuable resource.) Recent notes from people here, and the log, confirm that almost no one ever contributes updates to existing code at PickWiki. There are notes on the wiki about how to use the site, and people eager and easily available to help. The site is just not used for collaboration though it's available for anyone who wants it. No, it's not great, but Ian didn't originally intend it to be a collaboration site when he created it ... it just became a defacto repository. If we get significant demand for improving the resource for real collaboration, a few of us here will be eager to do it. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4026 - Release Date: 11/19/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Collaboration
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 collaborating on? Here's my list (most of which I have, but very hard coded for my environment): Developer tools: Pre-processor (so we can all build on our different versions) Code bundling and dependency tracking (ala ruby-gems) REPL or command stack with things like filename, attribute completion Screen design tools Standard headers/footers Nice input routine Reporting tools Report builders Data tools Extract to XLS, XML, Json Web Service interface Analyse/infer data dependencies Generic utilities Standard email routine -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, November 19, 2011 8:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Code Collaboration Never invite Tony to give a one minute speech ! Tony you told us how you ported Pickwiki to Mediwiki, without giving a link. Give the link, right here, where five hundred people are listening. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Sat, Nov 19, 2011 12:14 am Subject: Re: [U2] Code Collaboration I originally wrote my notes for a prior post but noticed that both Ian and Rex weighed in here, so I will as well. Will, please reference my notes earlier. 1) I ported Pickwiki to MediaWiki, and provided a link to a prototype which I could complete if we saw some significant community interest. Absolutely no one but Ian, Rex, and I have expressed any interest in commenting on that MediaWiki implementation. This deafening message of silence is being heard here loud n clear. 2) A quick google for mediawiki notifications returns lots of hits, but I'll save you the pain and tell you that MediaWiki includes email notifications by default. So, while I'd love to say hey, we already have what you want, c'mon down! the problem remains that few other people would use the same resource. As we've seen in this thread, there are links to SourceForge, Github, (both of which DO have email notifications) and others, but everyone wants the community to use Their favorite or they'll walk away. Anyone who doesn't have a favorite seems completely disinterested (OK OK Will, You are not disinterested...). That's what I blogged about and a few people have responded in agreement. I'd really really like to help build another collaboration site, and it can be done quite quickly. But the questions of motivation and interest Must be addressed before we create yet another site that's doomed to die of loneliness. Personally I'd also like to see people just use PickWiki for a while. It's not perfect but it works. Ask the questions and Ian, Rex, and I can help to answer them. Email me if you don't know what else to do. (t...@removethispleasenebula-rnd.com) Let's grow out of that resource. When that happens I'm sure more people would be inclined to take requests and build something suitable. But we're never going to get something that's perfect for everyone. Any resource is going to be some percentage, 50, 70, 94.37% of what each person wants. For this community I'm afraid we have a if it doesn't do This then I won't use it at all mentality - and in many cases This is already possible but people walk anyway without asking the question or waiting for an answer. Go figure. As an example of that, Will, google for web page change notifications, select one of the free services, and provide your email address and a PickWiki webpage reference. THERE is your notification! And if we complete the PickWiki migration to MediaWiki it will be built-in. Next question please! As another example of how even a hugely popular CMS can still be inadequate: http://ilikestuffblog.com/2011/07/14/github-notifications-suck/ Point is - people in this community needs to accept that the code in the rest of the world is about as imperfect as the code they work on every day. FOSS gives us the opportunity to help fix it. If you don't want to fix a CMS, just accept what's available and ask others how best to deal with it as-is. But for now everyone is talking about the environment but for all the years that MV BASIC FOSS has been around, we can probably count on a few hands how many post-publication contributions have ever been made to all projects combined. THAT is a serious concern that should be discussed before finalizing Where these non-contributions are going to take place, and how notifications are going to be sent on pages that are never changed. (BTW, this has become
Re: [U2] Code Collaboration
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. snip ...This is not a tool or convenience problem. Most people are simply not inspired to share what they know; those that are inspired are already sharing. That's a realistic, if somewhat cynical view. It doesn't seem unreasonable for those who are inspired to give it a shot and see what happens. Personally, I think the question how best to collaborate on code is a solved problem: http://github.com. A wiki is not the complete answer to the question, though it can play a part. There have been many, many, attempts over the years (from BIX to usenet to U2users) to do a pick version of gnu. Maybe the time is finally right for it to work? Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting article
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 saying that open-source lasts forever, but when something does get orphaned, I have more options. http://blogs.computerworlduk.com/open-enterprise/2009/10/open-source-makes-big-gains-at-the-london-stock-exchange/index.htm I think the LSE found a way to justify open-source to their board and regulators... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Tuesday, July 12, 2011 7:22 PM To: U2 Users List Subject: Re: [U2] Interesting article Hi Rob Open source has its advantages, but there is the reverse side. I need to know that it has ongoing support if I commit a package on it, I have seen too many people get into trouble when an open source application is no longer supported. Organisations have not been able to apply security patches because their free application cannot support the security patch. There is also the question of security, is open source easier to hack, is it easier to put in back doors. My clients want to know what happens if I get hit by the proverbial bus, I need to justify continuity to them and the open source environment does not provide that continuity. I am not going to be able to put an application into the London Stock exchange based on open source, they could not justify to their board, risk managers and regulators. The cost of supporting open source is sometimes greater than paid for applications. The question to ensure, does U2 provide a value add to my development. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers Sent: Wednesday, 13 July 2011 11:41 AM To: U2 Users List Subject: Re: [U2] Interesting article David, You're correct that U2 users need to be vocal about what they want, but Rocket has to be proactive, too. Surely they have a few analysts on staff that can read Techmeme or attend a few conferences and see for themselves where developers are headed. It's probably not wise to only listen to *current *U2 users anyway. I started to make a list in my head of what I'd ask Rocket for, but then I stopped because everything I'd ask for I can get* *elsewhere...for free...right now. If I were starting a brand new project today, I'd be hard pressed to find a single reason to pick a U2 database over a free, open-source alternative like MongoDB, PostgreSQL, or MySQL which have drivers for almost every language, heaps of documentation and troubleshooting resources online, fast release cycles, and great (free) developer tools. Can anyone else think of one? -Rob The biggest thing for me is accessibility from other languages, because the On Tue, Jul 12, 2011 at 7:02 PM, David Jordan da...@dacono.com.au wrote: Rob your comments are not wrong. However U2 management want to go where they think the market is. As users we don't tell them anything and then complain that they are not mind readers and are not heading in the direction we want to go. As a user group, we give users a voice to be able to set direction. Of course there are a million one views about the future, but we can build a business case based on the wishes of the majority. I have sat down with Rocket and explained how Microsoft Azure could provide a market opportunity and how U2 could work in this environment and I am working with them to look at its feasibility. Others are looking at REST and a range of other APIs. Rocket is not so much ignoring us rather we as users are not talking to Rocket constructively. What is important is to turn this discussion into something constructive. If Rocket asked you what you want, what would you say. David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___
Re: [U2] Unidata command stack (history)
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'all know how that goes. We have restricted access to TCL where I work and only allow access through the stack program. We produce weekly audit reports showing what commands were run, in which accounts, by whom. One of the selling points is a lot of short cuts for the programmer - the dot commands are for anyone using the stack, but slash commands are for the programmer to compile, catalog, run, checkin, diff, edit etc. Think I got that idea from some ancient programmer's workbench on Ultimate back in the 80's. Gosh, I'm old. The workflow is something like: ACCOUNT/N4 Program Name: BP.DEV STACK (svn stuff happens, tells me if the local copy differs, offers to do svn update etc.) ACCOUNT/E4 (edits the program in AE, command line editor still useful for lots of things ;-) ACCOUNT/W4 (BP.DEV STACK opens in $VISUAL, in my case /usr/local/bin/joe) ACCOUNT/BR4 (compiles, catalogs and runs BP.DEV STACK, making sensible choices about LOCAL, GLOBAL or DIRECT catalog) ACCOUNT/CI4 (checks the program back in to svn, asks for comments etc.) I usually have 10-20 programs in my stack at any one time, and get used to this week #4 is TRIN.MAIL.SUB. It saves a tremendous amount of typing. Rolling your own stack is an interesting rite of passage, and worth doing. Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, June 13, 2011 7:14 PM To: U2 Users List Subject: Re: [U2] Unidata command stack (history) Jeff: The U2 command stack is completely neanderthal. I've been using UD for awhile and have ignored the U2 stack completely. I run a home-written shell. There's one on Pickwiki and I have one I'd be glad to give you. Here's some documentation on the U2 stack The UniData command stack stores statements entered from the ECL command line and allows you to recall, edit, reexecute, or save them. If you make a typographical error in a command, the command stack feature allows you to correct the error without having to retype the entire statement. By default, UniData stores up to 49 commands in the command stack. To change the default, you can set the CSTACKSZ environment variable to save a specified number of command lines. Each command line can contain up to 2720 characters. See Administering UniData for information about setting UniData environment variables.Note: If you change the value of the CSTACKSZ environment variable on Windows platforms, you must restart UniData for the change to take effect. When you enter a statement on the ECL command line, UniData stores it in position 1 of the stack. As you enter more commands, UniData pushes prior commands in the stack up one position and inserts the current command in position 1 of the stack. When a command moves beyond the stack's limit, it is discarded. The command stack for each user is saved in a file called .ustk_logname in the directory of the current UniData account. Each time you enter UniData, the stack is recalled. HTH, Bill - Original Message - *From:* jbut...@hampshire.edumailto:jbut...@hampshire.edu *To:* u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org *Date:* 6/13/2011 5:50 PM *Subject:* [U2] Unidata command stack (history) Unidata 7.2.9 on linux Is there a UDT.OPTION or other setting that can control the size of the command stack (history)? We max out at 99 and I'd really like to have it recall more - but cannot find an option to do this. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick History
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...@listserver.u2ug.org] On Behalf Of Jon Sisk Sent: Tuesday, February 01, 2011 9:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick History Henry Eggers says no connection. It came later.. Bear in mind it took him nearly 20 minutes to say this. Best regards, Jon Sisk Charles_Shaffer wrote: Cleaning out the old room where everything computer related gets sent to. Came across a book on a programming language called PL/I. Just taking a quick look, I saw some familiar statements like CONVERT, PROC, INPUT, CHAR, PRINT, FORMAT, LIKE, LOCATE. Is this coincidence, or was PL/I part of the early days of Pick? Apparently PL/I came into use in the 1960s around the time Pick was developed. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - http://jes.com On-demand 1 on 1 private training for all MultiValue platforms and languages. -- View this message in context: http://old.nabble.com/Pick-History-tp30809278p30818137.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
Re: [U2] PickWiki
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.org] On Behalf Of Dan McGrath Sent: Sunday, February 06, 2011 2:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] PickWiki I seem to recall a while ago that there were plans to upgrade PickWiki to utilise MediaWiki. What ended up happening? Was the idea scrapped? (Question spurred from Tony's sig) ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Sending interrupt to UniBasic program
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 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, August 16, 2010 8:40 AM To: U2 Users List Subject: Re: [U2] Sending interrupt to UniBasic program Thanks to the suggestions from various posters, I have determined that my incriminations of screen were malicious libel. It's not screen. The issue of not being able to send an interrupt (e.g. kill -2/SIGINT) is a result of how I had to work around something in the third-party code I'm trying to automate. There are a couple input prompts, e.g. do you want to continue? y/n that I originally tried to handle with DATA statements. But the 3rd party software is doing something to clear the input stack. I've tried a few different workarounds, including hacking the CLEARINPUT verb, with no success. I finally got it work by doing a PCPERFORM as follows: PCPERFORM 'echo PROGNAME\\nY\\n\\n\\n | udt' This works great except that a SIGINT issued to the newly spawned udt process has not effect. A straight kill works, but it actually kills the udt process which is precisely what I do *not* want to happen. Any creative thoughts on how to get a SIGINT to work? Maybe a different way of calling PROGNAME? Talking to the vendor about changing their code is a theoretical option, but involves $ and a good deal of time, so is not preferred. TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remote Printing
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 in those custom printing scripts though...
dsir...@x04ifl01:/usr/local/bin -cat spoolmail
#!/bin/sh
# Email the spooled file to the current user
# Parameters: 2 = full path to file
if [ $1 == TXT ]; then
file=/tmp/report.$$.txt
# Leave things alone
perl -p -e 's/\n$/\r\n/;' $2 $file
else
# RTF is the default
file=/tmp/report.$$.rtf
# Copy the header to a working copy
cp /usr/local/lib/TEMPLATE.RTF $file
# Append the report to the working copy
cat $2 $file
# Swap page breaks ^L for \\page and \n for \\par
perl -i -n -e 's{^L}{\\page }g;chomp;print $_,q(\\par );' $file
# Add a final paragraph marker to the end
echo \\par }} $file
fi
# Figure out who to send to
TO=`getalias $LOGNAME`
FROM=$TO
# Check for addresses that should be sent confidential
SUBJECT=Your report
expr match $TO .\*customer.com /dev/null
if [ $? -eq 0 ]; then
SUBJECT=Confidential: $SUBJECT
fi
# Send it, already
/usr/local/bin/uuenview -b -f $FROM -m $TO -s $SUBJECT $file
rm $file
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of skunz...@comcast.net
Sent: Friday, April 30, 2010 9:12 AM
To: U2-Users
Subject: [U2] Remote Printing
We are looking for remote printing options from Unidata for VPN users.
Currently using a remote print manager called RPM by Brooks.
Cisco VPN
RS6000/AIX
Unidata 7.1
Primac business software
What are other companies using for this purpose?
Thanks. Steve
Steve Kunzman
Andover, MN
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
IMPORTANT NOTICE: This message is intended only for the addressee
and may contain confidential, privileged information. If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message. If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
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's PC will launch the default browser and attempt to connect to the web service. You set the mime-type to application/pdf, include some magic javascript in the pdf to open up the print dialog automatically, and Bob's your uncle. Closing the pdf is tricky, we've left it to the user to do that. For word, substitute macros for javascript (though the user will have to be prepared for scary popups). If you have full control of the client's environment, you can install tools like doit (by the author of putty) and bypass the terminal emulator bit. http://www.chiark.greenend.org.uk/~sgtatham/doit/ The other way we do this to send word, excel and pdf docs generated by pick basic code is to simply email it to the user. Sometimes there's no other options - there's a firewall in the way, security won't allow other methods, etc. The users don't seem to care, as long as they get a document in a few seconds. Ian McGowan 925.609.2554 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 29, 2010 5:01 PM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer Glen, so how is it exactly that an event on the server will trigger this transfer, open, print, and exit? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
I forgot the obligatory plug for pickwiki: http://www.pickwiki.com/cgi-bin/wiki.pl?RunAProgram - this page has escape sequences for a lot of the common emulators... Ian McGowan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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's PC will launch the default browser and attempt to connect to the web service. You set the mime-type to application/pdf, include some magic javascript in the pdf to open up the print dialog automatically, and Bob's your uncle. Closing the pdf is tricky, we've left it to the user to do that. For word, substitute macros for javascript (though the user will have to be prepared for scary popups). If you have full control of the client's environment, you can install tools like doit (by the author of putty) and bypass the terminal emulator bit. http://www.chiark.greenend.org.uk/~sgtatham/doit/ The other way we do this to send word, excel and pdf docs generated by pick basic code is to simply email it to the user. Sometimes there's no other options - there's a firewall in the way, security won't allow other methods, etc. The users don't seem to care, as long as they get a document in a few seconds. Ian McGowan 925.609.2554 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 29, 2010 5:01 PM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer Glen, so how is it exactly that an event on the server will trigger this transfer, open, print, and exit? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Programmer Job Opening
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, April 23, 2010 12:43 PM To: U2 Users List Subject: [U2] UniVerse Programmer Job Opening *Orbit Irrigation Products Inc., a leader in the residential irrigation market, is currently seeking a Sr. Pick Programmer/Analyst. * Job responsibilities include: * Analysis and design * Application development * Work estimation * Adherence to development, testing, deployment, and documentation standards * Other duties as assigned Qualifications: * At least five (5) years PICK programming and administration experience - preferably using UniVerse * Excellent oral and written communication skills * Strong analytical ability * Must be a self-starter and team player who excels in all the duties of a developer with minimal supervision * Knowledge of ASP.NET or Cold Fusion (not required but desired) * Familiarity with Unix * Knowledge of database management, and system design concepts Please send resumes or questions to bry...@orbitonline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Embedded program for Windows
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/status/BASICParser.html I wonder about the pick basic part though - why not something open? SQLite, HSQL, couchDB? One of the NoSQL databases that have a local web server interface included seems like a better option. Do you have a lot of legacy code to deal with? http://couchdb.apache.org/ + jQuery = http://plugins.jquery.com/project/jqcouch seems like a modern approach. Post-modern, or bleeding edge even :-) Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Saturday, February 20, 2010 2:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded program for Windows I have a new client who after talking to in-depth, actually wants something completely different from what I first thought! Isn't that typical? At any rate, I'm interested in a system, in which I can write in Pick BASIC, and yet will throw up all it's results in a browser but everything will be offline. I can do the Basic, I can do the browser, what I need to ensure is that the Pick BASIC client is minimal, and either downloadable without licensing or registration, with a standard Windows download type look, bug free, OR actually compiled. That is, the customers, will use it entirely offline, but it must be as modern looking as possible, no special interfaces, just the browser. The browser MUST talk to the embedded database invisibly to the customer. The program, the database will all be downloaded as one program. Does that make any sense? Who offers that? And I need to ensure that there will be only a client cost, since the embedded program (in which you cannot change the code) will be given away for free to the customers. Will Johnson Fast Forward Technologies ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] What Next?
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 their minds. You will be much more marketable with either one on your resume, as opposed to pick alone. Once you have some success with java (you will choose wisely, I hope), learning a relational database will be a big uplift. Oracle or SQL Server (again with the red or blue pill). Or you can go open source with mysql or postgres. The latter doesn't get the press it deserves. Pull out some of the really important data from unidata every month and stick it in a relational database. Don't worry too much about star schemas and what not, just grab the data on a regular basis. It's amazing how useful this turns out to be at answering really hard questions. Ian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Tuesday, August 19, 2008 9:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] What Next? For the last 14 years or so I have been doing programming support and light DBA work; first in Universe (Prime Information) and now in Unidata (Pick). I'm basically a one-trick pony (UniBasic and System Builder) because my goal has always been to move into a business analyst role, but that has never worked out (I'm too IT). Last fall I decided to stop trying to pursue that and stay in what I'm doing. So now I need to decide what I should invest my educational dollars. I want to stay in application development and support because I like better than techie stuff. So what would you suggest I begin learning that would keep me reasonably employable in the future? Thanks. Albert DeWitt Sr. Programmer Analyst Stylmark, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking code question
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 record was locked at the pick level, they would get a warning message, the question is whats the best way to lock program x at the pick level? Why do you feel the need to do that? Are your developers really stepping on each others toes that much? We use subversion, and don't seem to be having a problem with several developers working on the same system with no locking. We did have a problem with Visual source safe and abandoned check outs. The switch to subversion was a relief. One thing that makes it better for us is using an enhanced TCL stacker that has support for a stack of programs you are currently working on. Adding a new program to the stack automatically does a diff with trunk so you know if the program has been diddled. It's always a good idea to do a svn update before starting work on a new program, to make sure you're working with the latest version. Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
