Hello,
I've spent all day banging my head against XDOMLocate and now that I've
found a solution I'm going to document it here in case it helps anyone
else in the future.
My problem was namespaces. Whatever xpath query I used, with the single
exception of /, I got a failure. Using / returns
You could use OCONV(ORIG.STRING,MC/B) to find all the non alpha /
numerics, and then what Wol says
REM.STRING = OCONV(ORIG.STRING,MC/B)
NEW.STRING = CONVERT(ORIG.STRING,REM.STRING,STR(LEN(REM.STRING))
Of course, if you don't need the spaces then just oconv with MCB will
filter down to just
Can't you just do
C:\CHRISudt CATALOG LFUTILS TEST_HARNESS5
Or use phantom instead of udt...
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 19 August 2010 14:37
To:
Oh, sorry. Those are unidata commands. But I believe universe has
phantoms that are launched in much the same way...
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 19 August 2010 14:56
To:
I've seen the custom look feel developed as a way of gaining product
differentiation - something 'shinier' for the demos. But for me, when it
comes to developing a non-terminal UI on top of unidata for your typical
business application, I would always recommend going with the UI
guidelines for
You can PCPERFORM SET CCPath CAPTURING ANS
Which will set ANS to something like CCPath=C:\whatever
Ed
(obviously only works on Windows, although similar approach should work
on unix)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Except that runs on the server, not the users PC. Sorry!
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: 28 May 2010 16:05
To: U2 Users List
Subject: Re: [U2] wIntegrate equivalent of System
and a Unix U2 Host
Doug
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Friday, May 28, 2010 10:07 AM
To: U2 Users List
Subject: Re: [U2] wIntegrate equivalent of System
what's in them? (My current theory is
file opens that are not balanced by a close - but we have loads of other
batch routines that process many thousands of records without any
problems and are generally careless about opening files each time round
the loop...
Thanks
Ed
Edward Brown
/u2
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Thursday, May 13, 2010 7:55 AM
To: U2 Users List
Subject: [U2] [UD] Running out of LCTs
Hello all.
I'm running a batch job which after
Hi
Unidata -- mv.Net -- c# / vb6 front ends
Works nicely. Sometimes there's web services between the top two tiers
as well.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: 08 April 2010 18:16
The final string needs to read as LIKE 0X'G2A'0X, so the string the
user supplies is always single quoted.
In code it would be something like this
QUOTE = ''
USER.STRING = QUOTE:0X':SELCRIT:'0X:QUOTE
ECMD := WITH PART_NUM LIKE :USER.STRING
Ed
-Original Message-
From:
Actually, what seems to work on Vista is %USERPROFILE%/Documents/ - a
mixture of previous suggestions!
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Conley
Sent: 04 March 2010 15:20
To: U2 Users List
] On Behalf Of Kevin King
Sent: Thursday, March 04, 2010 9:44 AM
To: U2 Users List
Subject: Re: [U2] windows/dos my documents environment variable
Didn't Microsoft change the location of the /Documents/ directory with
Win7
Or is it still under %USERPROFILE%?
On Thu, Mar 4, 2010 at 8:24 AM, Edward Brown
How about this.
Rename the VOC entry for SELECT to SYS.SELECT.
Write a shell program called SELECT that grabs the @SENTENCE and
executes it again using SYS.SELECT. Grab the return values as required
and log if necessary. Same would work for LIST, SSELECT, SORT, COUNT
etc.
Another trick is to
Using an index will only work for certain types of selects - for
equality, or string 'starting with'. They won't work for string
'containing' or string 'finishing with'.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
Dattatraya - in unibasic almost any string handling task is possible!
Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.
Starting with REC - as read from disk.
Presume REC has one or more multivalued
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: 16 October 2009 08:06
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya - in unibasic almost any string handling task is possible!
Hmm - funny how the original topic
] On Behalf Of Edward Brown
Sent: Friday, October 16, 2009 3:29 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya,
(Possible) correction added.
You really need to take the time to understand the example code we're giving
you. There will still
ELSE NULL
Will work.
Syntax for all these commands is in BASR.PDF, downloadable from web for
free...
Edward
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 12 October 2009 12:22
To: U2
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, October 12, 2009 4:55 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
ELSE NULL
Will work.
Syntax for all these commands is in BASR.PDF, downloadable from web
Dattatraya,
As others have said it sounds like you need more background knowledge of
unidata in general. Unidata comes with some good pdfs for this kind of
thing - certainly explaining basic concepts such as dictionary items.
Try looking in UDTD.pdf - Using Unidata. This is available for
Missing dicts seems likely to me also. In our system we tend to create dicts
only for fields we report / select on. File layouts are maintained in a bespoke
editor, which in turn ties in with the way we use records from these files
programmatically. So programmers tend to maintain the file
Veering a little off-topic here!
I've not used the unidata dev environment although I edit my programs in
a windows editor, in common with almost all the programmers here, and
have tools to quickly identify and compile up any modified source files,
plus loads of other bespoke bits and pieces that
Could the listening program, which presumably is, or could be, a phantom
manage the connection once it comes in BUT also fire off another
listener / responder to wait for the next connection? And so on? That
way there's no need to pass anything anywhere...
Otherwise, if the socket handle is just
You can also pass parameters to your phantom
ARG1 = thread_number
EXECUTE PHANTOM myprogram :ARG1
Which would be picked up in the usual manner, @SENTENCE on unidata,
presume similar on UV.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Don't have a good answer for this, but one hacky way would be to call a
program passing the value to be accumulated which in turn maintains a
named common variable. Only problem would be knowing when to reset it...
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
These performance postings are interesting and show the very wide range
between different flavours of Pick and the underlying operating system.
Would anyone be interested in helping put together / running a
performance suite with a view, perhaps, of adding a page to the wiki
showing how different
We've recently implemented indexing into our application as a
replacement for our own custom indexes, so I'm at least a little bit
qualified to answer some of your questions:
* Number of indexes - no guidelines afaik. The update process seems fast
enough - certainly, every write triggers an
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Wednesday, July 08, 2009 6:12 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing
After indexing, we made a lot more use of the SETINDEX and READFWD
logic
in our programs.
I find this curious / disappointing
Marco Manyevere wrote:
In one test I did a couple of months back, I found that appending IDs
to the end of a dynamic array perfomed _much_ _much_ slower than a
WRITESEQ to the end of a disk file and the dynamic array wasnt even a
100 000 records long. We were able to reduce the time required to
Martin
Your test program on unidata 7.1 takes 1137 milliseconds - 1.1 seconds.
I changed it to use system(12), this is a better resolution clock on
unidata than TIME().
Interesting commentary on chunking. I believe (and I might be talking
out of my ar*e here) that chunking done with (system
I want to move to one of my earlier questions in this thread regarding
mixing indexed and non-indexed dictionary items, and if unidata is able
to use the indexed items at all in this circumstance:
Simple test:
One fairly big file:
Items - 473,000
Item size - 695 bytes on average
Indexed
Try ultraedit, it has a column mode that can handle this sort of thing.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 25 June 2009 16:18
To: U2 Users List
Subject: Re: [U2] Using ED
I Use
Regarding debugging phantoms, we've developed an intercept mechanism so
when a phantom is triggered from the VB GUI we capture the parameters
and return to VB with an error.
Then, the programmer can restart the phantom code - but running under a
normal session - using an entry point routine that
Yes, if you quote-delimit all your fields then it's possible to pass
@VMs as line feeds, and it will do what you want.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 14:56
To:
...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 9:58 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
Yes, if you quote-delimit all your fields then it's possible to pass
@VMs as line feeds, and it will do what you want.
Ed
-Original Message-
From
-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, June 22, 2009 10:25 AM
To: U2 Users List
Subject: Re: [U2] Simple Export to Excel
Dunno, how about converting double quotes in the data to single quotes?
Or stripping them out entirely?
Ed
-Original Message-
From: u2
If you run the query as a phantom then the output ends up in the _PH_
directory. If you EXECUTE the phantom command and capture the output
it'll give the name of the phantom file.
Ed
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
Didn't know about this method, but I can see it being very useful in the
future - the option to set the delimiter could be extremely useful - as
it puts all the output data into an easily parsed / loadable into Excel
format.
FWIW, DELIM only seems to be recognised with ECLTYPE U.
Ed
Works fine for me on unidata 7.1 writing to C:\whatever.txt
Bill - yes, I've come across the lower case usage before. First used it
with select and 'saving unique' when we started using unidata (after
R91/95) many moons ago. Oh look (I thought) - a special sort of SELECT
with shiny things!
INMAT(MY.ARRAY) should return the size of the array. Definitely works
this way on Unidata...
Ed
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen
Sent: 01 June 2009 15:54
To: u2-users@listserver.u2ug.org
Subject: [U2]
Although it would be nice to be able to set a starting attribute, so - for
example - figures for a specific year could be written to a small array without
using offsets. VB6 allows this - not found a way in unidata, though.
DIM YEAR.INFO(1990 to 2008)
Ed
From:
It might be an ECLTYPE issue.
What's the statement that is failing?
Can the program be phrased as:
CRT CMND
EXECUTE CMND CAPTURING A RETURNING B
CRT A
CRT B
And then when the phantom runs the CRT'd content ends up in the _PH_
file - this will generally be the most recent item in the
It's because 1A means one numeric character.
If you surround the literal in single quotes it'll work fine:
sselect ITMMST WITH F2 LIKE ...'J1A'... (6,213 keys - wrong)
Ed
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On
Using 7.3e on vista here, seems to run the same as it did on XP...
Ed
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of John Kent
Sent: 02 April 2009 03:42
To: u2-users@listserver.u2ug.org
Subject: [U2] Host Access on
difference in
the output when run as a phantom?
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Saturday, 21 March 2009 6:55 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select behaviour, Phantoms
Hello,
Strange one here - I have a V type dictionary item with a D4/ in
attribute 3. Using this at TCL with an ECLTYPE of U I am able to do
LIST FILE WITH DATE.DICT 01/01/2009 DATE.DICT SAMPLE 20
and it works as expected, listing 20 records where the date is later
than that returned by
If the search is for whole-words only - i.e. to exclude phrases like
'Special Order Only' then you can set up a dict item like
1: V
2: CONVERT( ,@VM,OP.SPEC)
3:
4: TechSpecWords
5: 20L
6: M
And then do a statement like
SELECT IM WITH OP.SPEC = MILSpecSPEC-14
There's a hardwired limit on the
Try LIST FILE REQUIRE.INDEX WITH INVOICE EQ 1000123.2
The REQUIRE.INDEX sometimes throws an error message when there's a
problem that wouldn't otherwise be shown... although my experience is
with unidata, not universe.
Also your dict item has a couple of typos I think, it's a retype rather
than
If the ID equates to false it will exit - i.e. a record with ID 00
Edward
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 27 February 2009 14:26
To: Ardent
Subject: [U2] Strange happening...
the id variable was never modified.
Strange.
George
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Friday, February 27, 2009 9:39 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Strange
The SORT function (which I'm embarrassed to say I didn't think existed,
and I've been coding unibasic for the last 8 or 9 years!) sorts the data
passed into it; there isn't a return value. So
SORT(LIST)
CRT LIST
does work. Your original program sets LIST to 0 because LIST is set to
the return
: karen.bes...@tylertech.com
Web: http://www.tylertech.com
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Tuesday, February 03, 2009 11:15 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] unibasic's sort
Hi,
Just found a very strange problem on Unidata 7.1. I'm been using
LIST.INDEX successfully for a little while now and have just tried it
with selection criteria, instead of just display dictionary items.
If I write the selection in Pick format, it works fine. If it's in
native Unidata
Hello,
I wonder if anyone is using the above combination. We've found that
since moving to unidata 7.1 from 6.1 that it's no longer possible to set
up new reports or run (using the lightening bolt) existing reports
within the Crystal Reports application - both fail with an unhandled
exception in
There's a dbpause / dbresume command on unidata that looks like it
would make backups safer:
dbpause is a UniData system-level command that blocks most updates to
the database made in a UniData session. Any updates made from the
operating system level are not blocked. You can use this feature to
Try a CW first? Although your first form works in AE on unidata 7.1...
Edward
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: 13 August 2008 16:20
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UV] Editing Subsequent Value Marks
Keith,
Thank you - this is a very clever solution. Admittedly not as
straightforward as it could be - wouldn't it be nice if there was a
built in keyword such as ENABLE-COLS that did it automatically!
Edward
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Hello,
This is a unidata (7.1) reporting question, and I'm asking because
although I can't find the answer in the documentation, I do think I've
seen it once on another developer's screen.
Suppose I list a file with a command like LIST ACCOUNTS. I'd get a list
of the IDs down the left hand side
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Edward Brown
Sent: 16 July 2008 12:35
To: u2-users@listserver.u2ug.org
Subject: [U2] Multiple columns from a LIST statement?
Hello,
This is a unidata (7.1) reporting question, and I'm asking because
although I can't find the answer
Hi
If they're dimensioned, i.e.
DIM A(10)
DIM B(10)
Then you can do
MAT B = MAT A
to copy one to the other. There's complications when the dim size is
different but this is all documented...
Ed
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Mark.
That's a very powerful condemnation of 'clunky' backup practices.
However, you've not gone far enough imo - simply keeping a copy of every
(significant?) version of a program isn't taking advantage of modern
solutions to the change control problem.
As a poster suggested earlier on today,
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Edward Brown
Sent: Tuesday, July 01, 2008 5:09 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata - handler for mistyped commands?
Yes, I've already got some VOC entries that are shortcuts to longer
named
jobs, and we do have a few VOC entries
a different man
then
CATALOG programfile newname programname options
-Original Message-
From: Edward Brown [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2008 10:37 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata - handler for mistyped commands?
Hello,
Within Unidata
On Unidata this should work:
Use SYSTEM(49) to retrieve a text description of the call stack. Redback
must use an entry point subroutine to call through to your code, if this
is in the top line of the output then it's running under Redback.
Hth,
Edward
-Original Message-
From: [EMAIL
Hello,
Within Unidata, is there any way to intercept commands typed at the
command prompt if they aren't recognised?
It's to 'magically' allow slightly mistyped program names to launch that
program - some of our routine names are quite long - and also to
recognise abbreviated routine names in
That wouldn't work if DOUG was a subroutine.
Sometimes, for debugging in-use code I put in a line like 'IF @PORT =
(my current port) THEN DEBUG' - remembering to take it out afterwards!
Often this is enough to help track down issues without affecting other
users...
Edward
-Original
Of course if the port number is added to the end of the key then you can
still sort by date/time.
In the past I've done an R%5 oconv on both the (internal) date and time
before concatenation - this gives you a 10 digit number regardless of
the date and time used, so no need for separators...
(unless it is ruled out that
this is
not possible).
Regards, Marco.
- Original Message
From: Edward
Brown [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday,
24 April, 2008 1:07:13 PM
Subject: RE: [U2] Guaranteed unique sequential keys
Of course if the port number is added
Message
From: Edward
Brown [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday,
24 April, 2008 1:07:13 PM
Subject: RE: [U2] Guaranteed unique sequential keys
Of course if the port number is added to the end of the key then you can
still
sort by date/time.
In the past I've done an R
it, but if outside of the box is
needed.
What would the possibility be of a callc routine to access a common
memory
location?
Bruce M Neylon
Health Care Management Group
Edward Brown [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/24/2008 10:06 AM
Please respond to
u2-users@listserver.u2ug.org
Hello,
Have followed this thread with some interest as we've recently moved to
Subversion. This hosts VB6 and unidata source code / dicts / various
control data for a fairly large set of products.
Subversion has met our expectations; we'd dabbled with sourcesafe before
but never really had a
reselected the primary file
(where the
keys reside) and voi'la. That was the simplest for me.
Bill
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Edward Brown
Sent: Monday, April 07, 2008 3:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE
Hello,
I have a program on unidata 6.1 that does this (simplified):
UDTEXECUTE SELECT FILE1 SAVING UNIQUE MIGHT.BE.MULTIVALUED TO 1
UDTEXECUTE SELECT FILE2 SAVING UNIQUE MIGHT.BE.MULTIVALUED TO 2
MERGE-LIST 1 INTERSECTION 2
And it works.
However, if the dictionary item MIGHT.BE.MULTIVALUED
2008 20:42
To: Edward Brown
Subject: RE: [U2] MERGE-LIST
Edward:
I've seen this with the original PICK product (I think this is
value-position
information). It's been the same all throughout the Pick Systems
product lifecycle.
If you were to, instead of doing the merge-list, do a sort after
76 matches
Mail list logo
