ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)

2004-04-28 Thread Stevenson, Charles
unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so

RE: ICONV/OCONV for unix internal timestamp (secs past 00:0001/01/1970)

2004-04-28 Thread Stevenson, Charles
Sorry, no cigar. That's not a conversion code that you can stick in 3 of a dictionary D-item, or 7 of an A-item. Or as second argument of either, nay, both ICONV() OCONV(). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi Sent:

RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)

2004-04-28 Thread Stevenson, Charles
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. Now that's rich. There's a lot there. Looks like maybe good

RE: ICONV/OCONV for unix internal timestamp (secspast00:0001/01/1970)

2004-04-28 Thread Stevenson, Charles
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Why not write a user conversion code that does this calculation as a Uname conversion? That's what I was asking, if anyone already did it. I'd prefer it to be flexible enough to allow various oconv formats and to iconv various strings.

RE: [UV] Problem reactivating select list

2004-04-27 Thread Stevenson, Charles
Triggers would be nice, but the'd have to work on type19 files. Modifying ED is simple, but you might want to wrap other verbs, so generalized wrapper pgm is good. Protect the vanilla versions of ED, DELETE, UPDATE.RECORD, REVISE as 'remote-controlled' R-items that will only execute if executed

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
http://publibfi.boulder.ibm.com/epubs/pdf/25119090.pdf 10.1 Basic Ref, pg 162 CHANGE (expression, substring, replacement [ ,occurrence [ ,begin] ] ) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
even for those of us who don't speak Welsh. cds P.S. Last week I said REPLACE() instead of CHANGE() in the following post. I've corrected it ( i.e., CHANGE( 'REPLACE()', 'CHANGE()', MSGBODY ) ) here: -Original Message- From: Stevenson, Charles Sent: Thursday, April 22, 2004 2:41 PM

RE: Help on uv syntax, please

2004-04-27 Thread Stevenson, Charles
-Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] [snip] Don't use CONVERT! Example: [snip] But it's great for things like: LINE = PRINT.ARRAYLINE.CTR CONVERT @VM:0.- TO IN LINE IF LINE # THEN GOSUB PRINT.LINE END I stand corrected. I don't

RE: How do we convert lowercase letters to uppercase in Pick basic

2004-04-22 Thread Stevenson, Charles
and just cuz no one mentioned it ( not cuz it's better than UPCASE() DOWNCASE() ), CONVERT does character for character swapping: CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' in ANYSTR and CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz' in

RE: Performance

2004-04-09 Thread Stevenson, Charles
Kevin, When you finally get this solved, let us know what the answer was. I am sure all responders would be interested. re. /tmp: I've seen marginal but not incredible inprovement moving UVTEMP onto our EMC storage rather than on the system's local disk (/tmp) re. file sizing: since you are

RE: Performance

2004-04-08 Thread Stevenson, Charles
Kevin, We had the same problem when migrating UV from DEC in one data center to HP managed in another data center, even though it was a honking big HP. The sys admins configured memory memory similar to how their 20 other unix machines were set up. The trick was to configure most memory for

[UV] txlg distributed files

2004-03-19 Thread Stevenson, Charles
UV (HPUX 11i, UV10.0.16) allows you to supposedly activate / deactivate a distributed file, i.e., the top level conglomerate structure, but I *think* the action is totally superfluous; that is, you must activate / deactivate each partfile independently. I *think* acting on the type-27

RE: EVAL

2004-03-11 Thread Stevenson, Charles
Can somebody help me with the syntax of EVAL. I want to execute a SELECT on a file to get all records where (field 16)*0.9 field(17). Various ways to do this. Try... SELECT file WITH EVAL F16 * 0.9 F17 = 1 where F16 and F17 are field names from the dictionary. The most common

RE: EVAL

2004-03-11 Thread Stevenson, Charles
Is there a way to assign a justification to an EVAL item other than having it use the justification of a field used in the formula? I know you can assign different formatting and conversion. The justification is assigned in the FMT, not independently as you do in pick-style dictionary A-

RE: [UV] Ever wondered how something works...

2004-03-04 Thread Stevenson, Charles
Incidentally (Sorry Chuck, I'm at it again), I have come across one user who thought CS was a shortform for CLEARSELECT and reported it as a bug that it cleared the screen. I always thought CS meant Chuck Stevenson - Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED]

RE: [UV] Variable never assigned a value warning

2004-03-03 Thread Stevenson, Charles
HEAR, HEAR! Incidentally, I find the worryingly common practice of setting all variables to zero / null at the top of a program very annoying as it hides the very useful unassigned variable trap, leaving you thinking your program works when actually it doesn't. Martin Phillips

RE: [UV] Variable never assigned a value warning

2004-03-03 Thread Stevenson, Charles
Is it technically or theoretically possible for the BASIC compiler (or any other compiler for that matter) to catch (during compilation) all the situations that might result in the use of unassigned variable at runtime within the scope of the subroutine being compiled? It's not exactly

RE: [UV] Variable never assigned a value warning

2004-03-03 Thread Stevenson, Charles
ASSIGN.A BEGIN CASE CASE A = 1; B = 'Apple' CASE A = 2; B = 'Orange' CASE A = 3; B = 'Banana' CASE 1; B = 'Something is very wrong here!' END CASE DISPLAY B REPEAT Regards, Marco Stevenson, Charles [EMAIL PROTECTED] wrote: HEAR, HEAR! Incidentally

[UV] blocking certain files from activating for transaction logging

2004-02-24 Thread Stevenson, Charles
I am looking for a trick to prevent someone (ok, mostly me) from accidentally activating a file that really should not be activated for logging. I have a handful of files, that would bring the system to it's knees and fill all logs before I could react. For example, one file contains the current

RE: How can i capture system date in a variable through paragraph

2004-02-23 Thread Stevenson, Charles
How can I capture the system date/time in a variable through paragraph For e.g. if i need- To create a a record in como file with id include date and time of run Like: RUN.13203.7145.COMO I love paragraphs ( despise procs, truth be told), but I do wish there was slightly more functionality

RE: COMO: Help on How to use COMO?

2004-02-17 Thread Stevenson, Charles
Amit, You want error messages in the COMO but not on the screen, right? Use DIVERT.OUT TTY.OFF/TTY.ON DIVERT.OUT is the more general command. In fast, the COMO verb is actually a basic program that executes DIVERT.OUT (source in $UVHOME/uv/BP/COMO_VERB). Example: CT CDS.BP BHUTANI

[UV] RESIZE sometimes changes permissions

2004-02-16 Thread Stevenson, Charles
Occasionally RESIZE changes the permissions on a file but usually it doesn't. Has anyone else seen this? Do you know the rules about it? Is it a bug? A twist of unix security I don't know about? As root, I resized hundreds of files over the weekend, none owned by root. Most were fine, but I

RE: Hashing Algorithm

2004-02-13 Thread Stevenson, Charles
It does, of course, lead to the question of why you want to know! I used to have a program I calledthat would take a select list sort it according to the group order of the file it was going to be applied to. For really big lists it made a really big difference because subsequent file i/o

RE: 2 gig limits

2004-02-12 Thread Stevenson, Charles
Speaking of 2GB limits, is there a way to get FAST to change it from one to the other? I'd swear I had FAST (v. 5) handle this once, but now I can't find it. UV's RESIZE has 32BIT 64BIT keywords that FAST could theoretically use. - cds -- u2-users mailing list [EMAIL PROTECTED]

HPUX 11 to 11i upgrade, UV10.0.16. Any gotchas?

2004-02-11 Thread Stevenson, Charles
I am particularilly interested in knowing whether Universe adapted well to the new OS version for you. It is certified for both. But I would be more than happy to know of any 11-11i hiccoughs unrelated to UV, too. Thanks, Charles Stevenson -- u2-users mailing list [EMAIL PROTECTED]

RE: 2 gig limits

2004-02-10 Thread Stevenson, Charles
... On Behalf Of Dan Fitzgerald You can make larger files, but U2 cannot address them, unless you enable 64-bit addressing UV *mostly* handled 2GB files, but I had trouble enabling them for UV's transaction logging. If I remember, UV used a unix utility - maybe fsync? - that was only