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

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 br tag. It requires a few lines of code, but it is pretty trivial. Has anyone ever tried using the SYLK

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

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:

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
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 pretty

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

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

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] Message-ID: [EMAIL PROTECTED] Content

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