What Martin said. It would be better to extract to temporary 1-attribute
variables and loop through those rather than looping through the 101st
attribute repeatedly. Especially for the prior prior year when LY.CNT = 24.
So I say "aye". This can definitely be improved.
__
Ah how I miss the caveman days when you could name your kids "awk", "grep",
and "sed" and people wouldn't stare...
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Ah Bill, that was you? Thank you! That was the problem I ran into last
week and the new UDT.OPTION fixed very nicely.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Overall, I would have to agree. There have been missteps along the way, but
as was mentioned before, it happens with any product. I do wish I had come
to this list first rather than going through Rocket support. Might have
avoided some embarrassing crow.
On Fri, Feb 18, 2011 at 1:13 PM, Address
Thanks to John Jenkins, who contacted me offlist with some excellent
information about the Windows firewall, I return here now to eat my share of
crow for casting the blame towards Rocket when in reality the problem was
with the Windows firewall.
John had me run udt in the console and then run my
Dave, I respect your opinion of my "bad form" but given that there has been
little to no information on this topic, would it make sense to sit on the
knowledge that there is a problem (regardless of who is to blame) and just
let others stumble blindly into it themselves?
It's likely that that the
Jeff, so you're saying that if the ftp script was created by the batch file
instead of being created by something else, this works? Gee, that could be
the entire issue right there.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.
You are correct that it is over telnet. However, I believe that most people
access their Unidata servers via telnet, right?
With all due respect, you are incorrect with this statement, however: "I
don't think you have ever been able to get the prompting and responses back
thru the layers when you
Oh, I completely agree. But the point isn't FTP vs. SCP or SFTP, the point
is the value (or anti-value) of unexpectedly breaking existing code.
For years I've been preaching about making reusable components of things
that are on the fringe of the operating environment to minimize the impact
of is
Thanks for the chuckle - that was funny!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I dunno man. There's some really good folks in the U2 group but sometimes I
wonder if the decision makers over there ever consider that there are real
people trying to use these products?
On Thu, Feb 17, 2011 at 8:14 PM, Charlie Noah wrote:
> Totally OT, and I'm just musing here - Rocket, Rainin
I wonder if the ftp on Win2003 is "better" than the ftp on Win7?
Sure, I realize that it's about impossible for Rocket to know every little
incompatibility with Windows versions but ftp? That's pretty crucial.
___
U2-Users mailing list
U2-Users@listserv
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Thursday, February 17, 2011 5:48 PM
> To: U2 Users List
> Subject: [U2] Frustrated with Rocket / Unidata 7.2
>
> About a week ago I upgraded Unidata 7.1 on W
About a week ago I upgraded Unidata 7.1 on Windows XP/32 to Unidata 7.2 on
Windows 7/64. Everything I need in Unidata seems to work fine on this
release with one notable exception: Unidata 7.2 on Windows will no longer
properly execute the Windows ftp program. Rocket support has basically said
t
P.S. Thanks to BobW for the offlist assistance!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I'd like to rename this topic to "when umask attacks". Come to find out the
problem with this WRITESEQ was that the log record got created by a user
with a umask of 022 and was being updated by a user with a umask of 007.
This caused the log to be created with rw-r--r-- permissions and even
thoug
I have a bit of code that issues this command (basically) for logging:
WRITESEQ MESSAGE APPEND ON F.SEQ ELSE NULL
Yesterday, this program started throwing errors like this:
In *...program...* at line 29 write error, errno = 9
The item size at this time is 11M, nowhere close to the 2G max size f
Ah, I see it now. It's in the Tracing tab here.
On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny wrote:
> turn it on in the configuration tab of the data source, bottom right
>
> Kevin King wrote:
>
>> Nothing in the event log. Not sure how to enable a DSN trace within t
Where will the log be written?
On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny wrote:
> turn it on in the configuration tab of the data source, bottom right
>
> Kevin King wrote:
>
>> Nothing in the event log. Not sure how to enable a DSN trace within the
&g
Nothing in the event log. Not sure how to enable a DSN trace within the
Fedex app. Input?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
ator with UAC turned off. It simply won't work otherwise.
>
> Good luck!
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Wednesday, January 26, 2011 9:50 AM
> To
I have a customer setting up a Win7/64 box for UPS Worldship. Previously
they had a XP/32 box in that same place running an earlier version of the WS
solution. They've installed the Unidata ODBC driver (which is 32-bit) and
have configured it, and have tested it successfully using Excel. (By
"te
I'm like Jeff. I prefer a separate file and routine for generating
sequential numbers. This allows for prefixing, suffixing, formatting,
padding, and validation of the numbers from one bit of code. Certainly
there is always the issue of what happens when a file becomes corrupted, but
that's what
Yes, but how do you fork in universe?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Two things come immediately to mind... First, to force people off you're
shutting down Unidata altogether? Seems a bit harsh, that's all I'm
saying. Second, what about deleteuser instead of udtkill? I'm not a fan of
deleteuser (because even the documentation says it can cause corruption) but
tha
Shawn, while I applaud the concept of finding a way to plug a MV database in
where a SQL database might otherwise be ensconced, one problem with the
attempt is that while the storage itself is a different animal, more so is
the access. Most of these types of apps that "rely" on a SQL database do s
Getting everything you want in one read is practical in limited
circumstances. Getting what you want in one REQUEST, however... that's much
more valuable.
We use JSON formatted strings to pass structured data into and out of
Unidata using subroutines to collect everything we need. This allows a
I would think the migration would be application specific. That said, it
certainly wouldn't be a difficult thing to write.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
The problem as I see it Mecki is that we have effectively two kinds of
arrays in JSON; name/value pairs and sequential arrays. So perhaps I'm
over-complicating but it seems problematic to represent scalars, NVPs, and
sequential arrays with dynamic arrays - at least in a way that would allow
the in
Yes, on the BASIC side. You use CHANGE in BASIC to convert a
multidimensional JSON object to a dynamic array? Okay, you have my
attention... do tell please.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listin
In our JSON implementation (moving information between U2 and PHP) we've
artificially limited the data coming into U2 so that it doesn't go deeper
than (effectively) multivalues. We allow the data going out of U2, however,
to be nested significantly deeper. For this product the limit isn't a
prob
We also do a lot with JSON but a JSON string can go far beyond attributes,
values, and subvalues. Would be interested in Doug's take on how to extract
something out of a JSON string without parsing it from scratch on every
extraction, and how he would represent 4 or more dimensions in a MV item?
There are a number of differences between running Unidata on Unix vs.
Windows. Performance and everything else as stated not withstanding, one of
the gotchas that always seems to surprise people is that on Unidata on Unix
if you have a DIR-type file you can write records into it with a "*" in the
Yeah, that's what I was looking for - thanks!
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Is there any way to tell - in a cron script - if Unidata is paused?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I'm a little confused when you say:
There is no "CLOSE" basic statement executed; only a free(filevar)
<>
Because above that I see:
CLOSE F.VAR
>
An even more interesting question: how'd you get the source to SB.FILEVAR.S?
___
U2-Users mailing list
Found the issue. Apparently in this version of SB+ when you WRITE something
to a file in a paragraph, SB+ opens the file to a buffer variable that it
holds open until the paragraph terminates. So when the paragraph (with the
WRITE) called the DELETE.WORK.FILE routine, the calling paragraph had th
If we're talking Unidata there are memory considerations based on how
something is cataloged. Catalog something globally and throw a thousand
users at it and at most it'll be loaded into memory once. Don't catalog it,
or catalog it locally or direct and each user will get their own copy of the
pr
On earlier versions of SB+ - running on Unidata - we have created a couple
of processes that can be used to create and delete a temporary work file for
use by whatever logic falls between the CREATE.WORK.FILE and
DELETE.WORK.FILE processes. In trying to port these to SB/XA on UV we're
running into
Brilliant article! Thanks for sharing.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Let's be careful we're lobbing grenades at the right enemy. As I see things
the conflict here isn't choosing vendor supplied solutions vs. open source,
the problem is the vendor doing a poor job of making something that is
usable and truly useful.
There is a time and place for both vendor supplie
Mike, I agree with you. This is unfortunately a vendor application and
they're storing quick retrieval lists of products. The customer can build
these lists (via Excel import) as big as they want.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
h
ers-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Monday, October 25, 2010 10:54 AM
> To: U2 Users List
> Subject: [U2] "too many values in sort"
>
> Unidata 6.1.15 on AIX. The following command:
>
> SSELECT SHOPPING.L
Unidata 6.1.15 on AIX. The following command:
SSELECT SHOPPING.LIST BY.EXP PROD.NUM
Yields the message "too many values in sort". There is one record in this
file with 36,457 product numbers but would that "break" the BY.EXP? If so,
is there a config parameter somewhere that could be tweaked t
Second the cyber-spanking. C'mon gents, last thing we need is more
politician-esque shots across the bow.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
If the value already has the decimal point in it, MR2 or MD2 will scale the
value as well as round. If you want to leave the decimal place alone, use:
ROUNDED = OCONV(ORIGINAL.VALUE,'MR20')
Remember that MR2 or MD2 is the same as MR22/MD22, where the first number is
the number of decimals to sho
John, what you've described is a feature of the GUI; the ability to click
through prompts in any order. If there are mandatory fields you shouldn't
be able to save the record until those fields have a value, but if those
fields are not mandatory the validation may never run. This can, of course,
I'm particularly fond of the word "correctly" in that comment. It's one
thing to fail in reading. It's another to fail in reading correctly. :-)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Did some testing today to see if Uniobjects could still read data when the
database is paused. Negative. In attempting to connect to Unidata via
Uniobjects an error 39207 is returned. This error is of course not
documented in the Uniobjects documentation.
Is there a comprehensive list of UO err
What about creating a view against the table and using the view in your
join?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
*We rely pretty heavily on legacy documentation, so I figured this might be
newsworthy to others as well...*
Only Three More Months to Get Legacy On-line Documentation
As of 30 September we will be removing old documentation from our Web site
and replacing it with the latest documentation versions
So you're saying that the protocol log shows the Host header but when they
receive the headers it's not there?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
We have had a number of problems with AE on UV/Windows; every now and again
- and sometimes repeatedly in the same couple of seconds - some catalog
pointer just disappears and AE stops working. We've experienced problems
with other UV sites and having catalog pointers just disappear but this is
th
If Mr. Bishop is removed from the list and we no are longer privy to his OOO
notices, will he make a sound?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I've never tried manually clearing the temp directory, but if a file has a
last modified timestamp older than the last time you started Unidata, I
wouldn't think there'd be any problems.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listse
nd it's huge...51g239k files.
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Thursday, June 24, 2010 11:36 AM
> To: U2 Users List
> Subject: Re: [U2] UniData
How much space is being occupied for Unidata temp space? Have you restarted
Unidata on that box anytime recently?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
did you verify that LO is the default UV LO and not overwritten by
anything? If so, that definitely says the issue is in UV.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Amy, is LO (rather than QUIT) any faster?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
John has an interesting point. I thought QUIT was UV but looking into the
system in front of me right now it appears to be an SB+ thing running SH.OFF
out of DMSH. So that makes me wonder if the file size of DMSECURITY or
DMCONT or one of those DM files might be having an impact?
Yeah Amy, LIST.READU EVERY. If something has filled up the lock table, it
could take some time for the terminating session to find and eliminate any
locks that are tied to that session.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listse
Amy, what's the lock table look like during these delays?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Where does Redback store it's definitions on the server side?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Support doesn't run on a standard clock, my friend... My only regret is
that we haven't put this one to bed yet, at least not confirmed.
On Sat, May 22, 2010 at 4:38 PM, Dave Laansma wrote:
> What are you people doing 'working' on a Saturday?!
>
> Sincerely,
> David Laansma
> IT Manager
> Hubbar
AH what about refiling each of the F5-Accounts with Restrictions screens
from /SEC.GROUP.SETUP? Those have checksums as well - and refer to systems.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2
To recap: you logged in as the SB user, refiled all of the groups, and
you're still getting the XX message corrupt message? XX is a system?
user? group? account?
Just trying to clear my head and understand what SB+ "thinks" is incorrect.
I wouldn't think this would be much of an issue, bu
That's interesting, because refiling the group records is usually all it
takes. Did you refile the ROOT record?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Susan, you said "As far as I know, the user did not edit the record, he went
through the screens, so the checksum should be ok." Ah, if only it were
that simple. In some earlier releases of SB+ (and possibly as late as 5.3,
though I thought it was corrected in 5.2) if someone editing something in
I would have said what Colin said, but he said it so much better... :-)
On Fri, May 21, 2010 at 11:27 AM, Colin Alfke wrote:
> John;
>
> One way to deal with this is to call a process from the derived slot of the
> dict that parses out the @PARAM variable and calls the subroutine, then to
> get
Been working with PrintWizard all afternoon, thanks. This looks like it'll
do the job nicely for our immediate need.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
While the PW thing looks cool, and especially the integration with AccuTerm,
the customer is on an earlier version of AccuTerm and I'm not entirely
certain I can convince them to upgrade. But... we have some really good
ideas floating around here, and I appreciate all the input.
__
Hey Peter, that sounds like the ticket for what I need. What version should
I look for?
Glen, the goal is to be able to print a label on a laser printer from a
keypress on the Unidata application side. The complexities are that the
label needs various fonts, most of them proportionally spaced an
I understand the beauty of being able to push reports out a slave printer,
but what do you do when the goal is printing labels with specific large
proportionally spaced fonts and center or right justification of the text?
___
U2-Users mailing list
U2-User
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
The end game at the moment is that a Unidata session will build a Word
document which is then opened by the client and printed. So the web service
probably isn't going to work in this context.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http:/
I noticed that the AccuTerm ASCII transfer is markedly faster, but ...
there's no error correction there either (right?) and if this file loses an
inopportune character or two, well, bad juju can happen.
___
U2-Users mailing list
U2-Users@listserver.u2ug.
I realize this is an old thread now, but is there any way to improve the
speed of the AccuTerm file transfer (preferably using an error correcting
protocol)? On SBClient a 25K file takes a couple of seconds, on AccuTerm
the same file takes about 30 seconds.
That's all unfortunate. I'm not sure if I'm more disillusioned by the hell
that I've gone through with Microsoft in terms of Windows versions and SQL
Server and linked servers and config and ... or with the overall state of
affairs with the Rocket/U2 connectors. If we can't connect people to our
Thanks Robert, I see that now. But... how is one to actually use that data
source, say, in a SQL Server linked server context?
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
need to use the 32-bit odbc driver manager.
>
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Kevin King
> > Sent: Friday, 23 April 2010 8:01 a.m.
> > To: U2 Users List
>
> been closed ?
>
> --- On Thu, 4/22/10, Kevin King wrote:
>
>
> From: Kevin King
> Subject: Re: [U2] SB CLIENT TERMINATION
> To: "U2 Users List"
> Date: Thursday, April 22, 2010, 3:55 PM
>
>
> As far as I know
As far as I know there isn't a way to prevent someone from closing the
telnet application.
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I have a customer who has downloaded the most recent Unidata clients from
the Rocket website and is trying to install them on Windows 2008/64-bit.
The installation appears to go according to plan, there are no errors and no
events logged, and yet after installing the ODBC driver, the Unidata ODBC
d
404? Doesn't look like a header thing, looks like the URL is wrong.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Well, IIS can do HTTP just like Apache. (Well, not exactly, but you know
what I mean.) But I like the protocolLogging option mentioned above. You
might try that first.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/ma
Could you post the output of your protocol log? Maybe someone here might
see something?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Good info, Ben! Thanks for sharing!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Whether HTTP or HTTPS, the headers should be the same, right? So why not
test with a simple HTTP connection instead of going through the creative
dentistry of setting up IIS w/ HTTPS?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserv
Not sure how to do it strictly in Unidata, but you might setup a simple
Apache server that echos the headers back in the contents and then use this
to test the Unidata headers. Incidentally, what header seems to be the
problem?
-K
___
U2-Users mailing l
Final update, hopefully.. As of this moment, IT'S WORKING!
The silver bullet in this situation was some option in SQL Server called
"Allow inprocess". Not sure what this does exactly, but this option (in
Server Objects | Linked Servers | Providers | IBM.UniOLEDB) has to be
checked for SQL Server
Firewall is disabled. Both on the same domain. Authentication is
configured for "Both Windows and SQL Server Auth" on both boxes.
Interestingly enough, Brian, absolutely nothing (related to OLEDB) shows up
on the Event Viewer. I agree with you that this is not likely a U2-specific
issue; the cus
I haven't tried linking the two SQL servers together, but that would be a
good test, wouldn't it?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
But David, it works without the domain on that other box. (Oh, and the
server in this situation is an AIX box.) The client is simply trying to
recreate the connection that works on another box.
New information: The memory of the failing box has been expanded to 4G and
the customer has installed a
No, not on either box (the one that works vs. the one that doesn't). The
user ID and password are the Unidata user and password with no extra domain
decoration.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/lis
New information: I just learned that the Windows server where the UniOLEDB
connection is working is Windows 2003 *R2 Enterprise *SP2 whereas the
Windows server that is not working with UniOLEDB is Windows 2003
*Standard*SP2. My apologies for my earlier assertion that the two
servers were
identical
I found the UniOLEDB.dll in C:\windows\system32. On the server that works
the version is 1.5.1.7211. On the server that does not work the version is
1.6.0.7276. I believe the two were at one time identical but the client
downloaded the latest-and-greatest from the RS website, which is why they
a
Well, now things have changed. Again, testing with the test.udl files on
the two boxes; one box works, the other box - which earlier was saying
something about non Universe databases - is now saying this:
Test connection failed because of an error in initializing provider. No
such interface supp
Where can one find the details of the UniOLEDB driver version? I'm looking
in the C:\ibm\unidk\unioledb and there's nothing there.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Ping test reports identical IP addresses for the server name.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Robert, in setting up the linked server in SQL Server we have it
authenticating using specific credentials for Unidata. This part of the
setup - well, all of the setup, is Identical on both boxes. Yet the old box
works and the new box does not.
There has to be some domain setting somewhere that
201 - 300 of 1012 matches
Mail list logo