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

2004-04-28 Thread Chuck Mongiovi
> seconds past midnight GMT, Jan 1, 1970. > Is there a conversion code yeah .. something like: pick DATE() = INT(unixtime/86400)+732 pick TIME() = MOD(unixtime,86400) which makes: unixtime = (pick DATE() - 732) * 86400 + pick TIME() and PICK time is always local time, not GMT -- u2-users ma

RE: UV to Text Conversion Standard?

2004-04-14 Thread Chuck Mongiovi
> The best way to importing multiline cells into Excel is to generate a HTML > file that represents the spreadsheet cells as an HTML table. You can then > import line breaks using the HTML tag. It requires a few lines of code, > but it is pretty trivial. Has anyone ever tried using the SYLK forma

RE: Memo: Re: UV: How do I determine whether a file is using 64bitor 32 bit addressing

2004-04-07 Thread Chuck Mongiovi
Does anyone have the "magic" settings for UniData 6/Unix files? -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Tuesday, April 06, 2004 1:09 AM To: U2 Users Discussion List Subject: RE: Memo: Re: UV: How do I determi

RE: callHTTP

2004-04-05 Thread Chuck Mongiovi
> Also, would wget (if running unix) be an option? Not sure if it > will work to submit a form, I know it will retrieve data. I may be dating myself, but I was thinking of LYNX .. The only reason that this *might* be useful is if you need the output formatted .. WGET will get the HTML source .. -

RE: [UV] Program dying

2004-03-22 Thread Chuck Mongiovi
You also might try running it from the system console from a UV shell .. you might get errors there that you wouldn't get during a standard TELNET -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Schasny Sent: Monday, March 22, 2004 10:53 AM To: U2

RE: How do I copy Unix files > 2 gig

2004-03-15 Thread Chuck Mongiovi
> There should be a file under /etc somewhere (/etc/security/limits on AIX) > named limits, or something similar, in which a parameter (on AIX, it's > fsize) defines that limit. Change it to a larger number, or on many unices a > "-1" means no limit. Or if you just want to do it ONCE, try the "uli

RE: Printing to "local" printer

2004-02-26 Thread Chuck Mongiovi
Dana, It depends on whether your workstations are networked or not and on how many serial printers you have .. If the workstations are networked AND the printers are paralell, I'd reccomend JetDirect boxes - you can set them up as printers available to the local machine, and then as queues on your

RE: Need/Want/Would like to know

2004-02-17 Thread Chuck Mongiovi
It works fine on UDT 6 on AIX - I know that UDT passes by reference if that helps -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, February 17, 2004 1:36 PM To: 'U2 Users Discussion List' Subject: RE: Need/Want/Would like to know

RE: Hashing Algorithm

2004-02-13 Thread Chuck Mongiovi
> I have the algorithms > (from a legal source long before IBM acquired the product) > I cannot divulge the details I wasn't suggesting anything like that .. I know the legalities of a situation sometimes get in the way of the fun of it .. I was just suggesting that Jose might not have any shady i

RE: Hashing Algorithm

2004-02-13 Thread Chuck Mongiovi
> > Could anyone let me know where can I found information about > > the way the Hash Algorithm Works with each one of the File Types > > in UniVerse? > It does, of course, lead to the question of why you want to know! Why not? .. I'd bet on simple (or not so simple) curiousity .. Aren't we all p

RE: UDT SELECT optimization

2004-02-04 Thread Chuck Mongiovi
Title: Message i seem to remember this way of thinking from the "old" days too, but i thought that all of the newer sql based command parser / optimizers didn't care what order you put things in .. they made sure to do the filter part first, and then the sort part .. i was hoping that this w

UDT SELECT optimization

2004-02-02 Thread Chuck Mongiovi
Title: RE: [UD]LOGTO Does anyone know whether one of these two statements is faster?   SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE   Does the parser / optimizer (if there is one) do the filter portion of the statement first regardle

RE: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server

2004-01-31 Thread Chuck Mongiovi
much. I greatly appreciate the help. Mark Date: Fri, 30 Jan 2004 08:57:23 -0500 From: "Chuck Mongiovi" <[EMAIL PROTECTED]> Subject: RE: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server 2000 To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Messa

RE: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server 2000

2004-01-30 Thread Chuck Mongiovi
I've been working on this recently and had a similar problem .. You need to:   1) setup a SYSTEM DSN on the Win2K side, not a USER DSN 2) setup the appropriate clause in the uvodbc.config   After that, try doing a CONNECT and a CONNECT {DSN} from TCL and do you SQL statements manually to t