This has probably already been dealt with before, but I'm getting the mail
all out of sync... time zones!
ie mail sent in reply to a mail are being sorted before the original mail.
Is there any way to beat this?
The point in question here
Re: [U2] SLEEP 60 slept... sent by Louie
Laure
Then it sounds like you could do the option described in these posts
For those who are lazy to write fancy routines to create CSV files, I've
created two dict items, namely COMMA and QUOTE, as follows:
COMMA
001: I
002: ,
003:
004: ,
005: 1T
QUOTE
001: I
002: ''
003:
004:
005:
Maybe a sys admin changed the system time during the run.
Or maybe the system automatically synced to a timeserver.
I'll check on that, but I think the synch is automatic and frequent
enough to not be off by 7 seconds. Maybe not, since this isn't a
production system yet.
---
u2-users
Laure,
You can also use a PERL interface to create/read excel spreadsheets on the
SERVER without the need to have any Microsoft Excel components installs. This
is a nice cross platform solution. Of course, you must have Perl installed on
the server, but, this is trival in most cases. I
I get this all the time.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: 13 February 2008 08:50
To: u2-users@listserver.u2ug.org
Subject: [U2] Time zone issues?
This has probably already been dealt with before, but I'm getting the
You might check the system logs; if there was a time server sync there
should be a note in there.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
On this topic, I have a request for a solution.
In New Jersey, all the zip codes start with '0'. Add product codes like
012345 and order numbers like 000123 etc and you'll see the leading zeros.
When creating and exporting a CSV to eventually be used by Excel, those
columns lose their leading
Also, believe it or not, this works with HTML as well - even the formulas.
This gives one great flexibility as one can do shading, font manipulations,
borders, column-widths, etc. What I did is create a subroutine CSV.TO.HTML
with options for titles, sub-titles, headings and footings. For the
I had a similar experience several years ago (10.0.?/Windows).
What I suspect (but never proved) was happening was when I ran
PORT.STATUS, it touched the sleeping phantom process and woke it up.
It was of little significance to me, and never encounter on other boxes,
so I never pursued. You should
I need to come up with an equivalent in BASIC to UniVerse's type 18 file
hashing algorithm. I understand that IBM treats this as proprietary but
I was hoping someone could shed some light on how I might pull this off
in BASIC. The following code works fine until the length of the ID
exceeds
What if the data fields contain quotes or double-quotes themselves?
Does this handle that situation?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Wednesday, February 13, 2008 4:00 AM
To: u2-users@listserver.u2ug.org
Subject: RE:
I have quite a few options to look into. Thanks again to everyone.
Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
---
u2-users mailing list
Instead of 07748,012345,000123 have =07748,=012345,=000123??
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: 13 February 2008 14:05
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic, I have a
Bill;
Normally our phantoms here return a user = system. We haven't tried firing
phantoms from phantoms or starting UniData as another user. I have seen some
strange security related things with phantoms - it's like the user isn't
quite logged in.
You can try looking at @LOGNAME in UniData and
Yes, =002536 will stay as 002536 when opening the csv file with Excel
instead of importing it.
-Original Message-
From: MAJ Programming [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 8:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic,
I have had similar problems with Excel in the past.
Have you tried importing the column as text?
Sometimes that works sometimes it doesn't. Excel is a very peculiar
animal indeed.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent:
Try this:
=CONCATENATE(,01234)
For any values with leading zeroes.
Marv
Marvin R. Fisher
Technical Resource Group
A Pipeline Group Company
2850 Red Hill Ave.
Suite 110
Santa Ana, CA 92705
Tel (949) 296-8380 ext. 620
Fax (949) 756-0029
Pipeline Software Statement: This email message is
Comma delimited fields are always a bit of an issue in this case. The
correct way to program CSVs is to place quotes around the fields, to
account for just this - but then: what if you have quotes in your
fields? Tab is usually a safer delimiter for the simple reason that it
is rarely stored as
-Original Message-
From: Mark Eastwood
I had a similar experience several years ago (10.0.?/Windows).
What I suspect (but never proved) was happening was when I ran
PORT.STATUS, it touched the sleeping phantom process and woke it up.
It was of little significance to me, and never
If you have quotes in the data you prefix them with a quote - for
example, the field value:
In your free time
Becomes
In your free time
The easiest way to see what the CSV should look like is to type some
data in an excel spreadsheet and output it to a CSV file.
Our current approach is to
Perry, in Unidata there is the RECORD command which will return the group
number to which a record will hash. Unidata does not support type 18 files
so I don't know what you will have access to in Universe. If the command
exists, you could create and empty file with the appropriate modulo and then
You might check the system logs; if there was a time server
sync there should be a note in there.
We synch every 10 minutes at 0,10,20,30,40,50 minute mark.
That doesn't cover 15:05 where my 7 second glitch happened.
I ran a mess of tests overnight. About 200,000 iterations of
If you had a continue or exit in the code above line 439, it would speed up
the interval by skipping the sleep on line 439, and depending on what that
code was doing, it could take a coincidental 53 seconds.
But you said there was none, and there are no double top loop lines, so
that situation is
I see what you're saying.
yeah, moot.
I was hoping someone would jump in and say they'd seen this before the
simple fix is...
oh well.
thx,
cds
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel
Sent: Wednesday, February 13, 2008 11:53
Colin:
Thanks for the thoughts. I wrote a cron processor in BASIC. It worked
perfectly
in D3, as I could start it automatically in the user-coldstart process when D3
started. Unfortunately UD doesn't have any startup capabilities like this,
although
I found a kludge from IBM at their tech
I can't get in touch with Ian via email.
Can someone send me current contact info, or just ask him to drop me a
note?
Ian wrote JS4U2:
http://www3.sympatico.ca/ian_renfrew/JS4U2/docframe.html
Is anyone using this for projects? Ian ported my open source MyTimeKeeper
project from its character
David wrote:
Getting info into MS-Excel has always been an issue - careful
use of the XML in U2 and MS-Excel may hold the key...
Mmmm, worthy of an article...
Karen wrote:
Have you tried importing the column as text?
Sometimes that works sometimes it doesn't. Excel is a very
peculiar
Hi Perry,
You have got it about right. Although the details of the algorithms are
considered as confidential, the Basic equivalent of some of them was
published in the UniVerse internals course. Some simple experimentation
shows that the published version of the type 18 algorithm is actually
There were some changes to do with PHANTOMS being woken from a SLEEP when
the parent process terminated. It would be interesting to check your
UniVerse release against the Product Availability Matrix:
10.1.14
7659If one UniVerse process was executing a SELECT statement
against a file,
Thinking back - a vague bell rings. I don't think it's directly related but
the resolution was a combination of TWO settings:
1. NOTIFY in the PHANTOM's parent
2. Breaking up a LONG sleep to more manageable smaller chunks in a loop.
Have you tried varying the NOTIFY setting in the process that
You can create a VOC entry to run from an execute within a transaction.
Put an 'H' code in att4 to allow it to be called during a
transaction...
SBTESTCT VOC UUIDGEN
UUIDGEN
0001 Verb to call aix uuid generator
0002 /etc/ncs/uuid_gen
0003 U
0004 CGHIM
-Original Message-
I need to
That seems to support the theory that something else is triggering that
wait() to go away, like what someone else had mentioned. I know that's
about useless information, but I'm in a uselessly opinionated mood.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Ah, that's a good idea...but I guess by-passing this restriction (which
must be in place for a good reason), should not be taken lightly
(especially in an mission critical environment).
I guess you could also write some UV BASIC code based on RFC4122 if you
want to be fully compliant. See the C
Hmmm, a miracle tool for little or no money too? ;-) I do not know, if
this meets your specific requirements, but...
Have you looked at DOWNLOAD from
http://www.cedarville.edu/departments/compserv/ftp.htm ?
It's been around for a long, long time...no need to roll your own, when
it's been done
This is on 10.2.6, released Aug 2007.
Issue 7659 was fixed in 10.1.14, released Aug 2005.
You'd think the fix would be in 10.2.6, too, but maybe it has reared
its ugly head again.
My description is not quite the same, but I am on HP. No select
involved. Executing a PORT.STATUS from another
35 matches
Mail list logo