Please educate me on OPENSEQ. I have some code that is giving me an error.
The funny thing is that I stole the code from a working program: The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO
OUT.FILE ELSE
066: *OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you looed
at FNAME and a file with that name really does exist in that directory file?
I'm pretty sure Universe can open windows SMB drives, but I don't know that
I ever tried it with other MV systems. Keep in mind the most important
thing about windows SMB drive shares: unless you are logged into the
desktop, it doesn't automatically map them. You may need to issue a net
use
If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then
OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it
is present (if the XLS is open with Excel you will usually get an abort)
Although I personally would check it is actually there via normal read
Spot the spilling miss steak.
and that will of course be 202,FNAME
-
Epicor Software (UK) is a limited company registered in England Wales.
Registration Number: 2338274. Registered Office: 6th Floor, One London Wall,
London EC2Y 5EB
This e-mail and any
I could be wrong, but I seem to recall that OPENSEQ supports two syntaxes
Option 1 has 2 arguments: openseq voc.pointer, filename to ...
Option 2 has only 1 argument: openseq absolute.path.to.filename to ...
Also, if the server where your shared folder resides is not Windows, then
filenames
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created anew
each time. It always open the file empty, allows me to populate and close
it. However, in this code it's not
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH:
Rocket added an @variable (don't recall the name of it) that tells which call
is being made.
Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Saturday, August 03, 2013 9:40 AM
To: U2
...Aaaah. If it is NOT there then do this:-
OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS'
WRITE ON LRGLBRVARS,FNAME
OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL
-
Epicor Software (UK) is a limited company registered in England Wales.
Registration
Can someone point me to the page where we can use DIR type files at all?
It would make my job a lot easier!
-Original Message-
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Aug 5, 2013 7:04 am
Subject: Re: [U2] OPENSEQ
Thanks
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
Thanks, Brian and Will. I got it working.
Eric Armstrong
Programmer/Analyst
Lobel Financial
714-816-1207 direct
--
Message: 2
Date: Sun, 4 Aug 2013 11:16:49 +0100
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Subject:
*Falls out of my chair*
What ? What ?
I never knew you could DO this!
After some fiddling about I finally was able to make OPENSEQ open an UNC path.
Of course the one I tried, actually points to the exact same server and account
the code is already running in, but I didn't even know you could
Remember, if you're using Windows 2008 (Vista Server) or later (I use
2008 R2 - Windows 7 Server) then you have to be careful about how you
share the network directory you want to share.
For testing purposes, if you're using Windows, it may be a good idea to
share the directory to everyone,
Ummm, if the file doesn't exist then it's *supposed* to take the else
clause, when I'm creating new files I use THEN and put the abort in there.
When you borrowed this code did it have all of the validation? I don't have
my error codes handy - but if you let it continue does it let you do the
As I mentioned earlier I went back and started over. This is my
Top of LRGLBRVARS in VOC, 3 lines, 48 characters.
001: DIR
002: \\ServerName\ShareName\Folder\LrgLbrVariances
003: D_HOLD_
Bottom.
My OPENSEQ statement is this: OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE NULL
This opens my
Jerry,
Yeah, that sort of thing is very specific to the software application
itself. Called an 'application control' in the cool crowd (er, auditors).
Not much way around it but to code it right into the programs that do the
work.
SJ
Message: 1
Date: Sun, 4 Aug 2013 14:23:37 -0500
From:
What you're seeing is the correct behavior of OPENSEQ. I think what's causing
the confusion is there are multiple error conditions possible when dealing
with opening a flat file for writing. The non-existence of the file prior to
opening may or may not be an error depending on your usage
Dan, Thanks.
I downloaded and installed the Extensible Administration Tool it. Do I have to
create a new U2 Server in order to use it?
Eric Armstrong
IT Dept
--
Message: 6
Date: Fri, 2 Aug 2013 21:31:58 +
From: Daniel McGrath dmcgr...@rocketsoftware.com
To:
From: Daniel McGrath
Subject: Re: [U2] Pick flavor in U2 personal edition
XAdmin, part of our U2 DBTools package:
http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/t
ry-now
I confess that I've always had a lack of skill with detailed U2
administration. Some people pretend
I am attempting to install right now. While looking for answers, this site
keeps cropping up in my search.
http://sbxa.wikia.com/wiki/
From: 3xk547...@sneakemail.com
To: u2-users@listserver.u2ug.org
Date: Mon, 5 Aug 2013 14:49:37 -0700
Subject: [U2] XAdmin wiki?
From: Daniel McGrath
From: Al DeWitt
I'm a Domain Admin so permissions is not an issue.
I understand the sentiment there but we may not be aware of the
permissions required for the operation in question, so it's tough to
know if the right permissions have not been granted.
My related experiences, dunno if this
Whoe dude, hang on. :)
The answer to the question does this exist or what do you folks
think isn't to do an install.
There are already generic resources available. We don't need yet
another wiki site with yet another login and markup language. I was
hoping we could make use of one of the
Eric:
Yes.
Bill
- Original Message -
*From:* earmstr...@lobelfinancial.com
*To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
*Date:* 8/5/2013 1:24 PM
*Subject:* Re: [U2] Pick flavor in U2 personal
Sorry Mr. Tony G.,
I did not know it existed until last week. I believe I misunderstood what you
guys were talking about.
Perhaps I still do. I have learned a lot from lurking on your boards.
Thank You. Jo
From: 3xk547...@sneakemail.com
To: u2-users@listserver.u2ug.org
Date: Mon, 5 Aug 2013
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.
*If* someone were to start a section, page, whatever at Pickwiki for example, I
would be happy to contribute what little I know about the U2 Admin tool. At
least as far as it works on Windows.
-Original Message-
From: Doug Averch dave...@gmail.com
To: U2 Users List
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
30 matches
Mail list logo