Well, you still won't find the first occurrence with INDEX() since it
hasn't got a comma in front.
Using the right tool (in this case LOCATE) for the job always helps!
On 01/11/2011 15:05, Charles Stevenson wrote:
What Wol George Smith said.
MATCH's raison d'etre is _PATTERN_ matching.
That
I wrote a program to export some data using openseq/writeseq (to a local
server drive, tried a UNC path too) and it works perfectly until I try
to call it using UniObjects. Is this normal behavior? If so, anyway to
make it work with UniObjects?
___
I don't know if we have enough information. Does it start? No output
whatsoever? IIRC, you can tell writeseq not to cache and to write to
disk immediately.
On Fri, Nov 4, 2011 at 3:03 PM, Holt, Jake jh...@samsill.com wrote:
I wrote a program to export some data using openseq/writeseq (to a
It fails to write. It gives the failure to open error as well, but I believe
that is fairly standard if the file doesn't exist before hand. It operations
normally, just doesn't write the records to the file.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
I'd guess it was some type of permission error. Does the user you are
connecting with through UniObjects have write permissions on the folder that
the open/writeseq is writing on?
hth
Colin Alfke
Calgary, Canada
-Original Message-
From: Holt, Jake
It fails to write. It gives the
I typically will throw a touch filename before the openseq. does
the uniobjects user have permissions on the disk?
Maybe try something innocuous to see if the job is executing at all.
On Fri, Nov 4, 2011 at 3:27 PM, Holt, Jake jh...@samsill.com wrote:
It fails to write. It gives the failure
It was a permission issue -- I blame Friday.
Thanks.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke
Sent: Friday, November 04, 2011 2:31 PM
To: 'U2 Users List'
Subject: Re: [U2] OPENSEQ / WRITESEQ and
Both George's my examples addressed the leading comma problem.
But if that wasn't clear, that's a warning sign that the technique might
be not-so-maintainable!
LOCATE does seem more natural, more maintainable.
(MATCH is right out.)
I've always been surprised by how fast INDEX is.
When I try