RE: Avante Job Scheduler

I am pretty sure the Scheduler only works in Avante Release 9.3.5. Alan Bateman EVOLUTION Software Services Pty Ltd solutions for changing needs 4-10 Bridge Street PYMBLE NSW 2073 Phone : (02) 9497 4340 Mobile : (0417) 685 246 Fax : (02) 9497 4370 E-mail : [EMAIL PROTECTED] Web : www.evoss.com.au

RE: UCI Error

Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server). On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere).

[ADMIN] Why multiple digests, and a lecture on Netetiquette

Greetings, All. I have received some inquiries as to why the new list server will sometimes send out two digests in one day. The digest normally is generated at 23:55 PST (USA). However, sometimes the volume of the postings is such that the digest can get huge. When that happens, not only

Help wanted creating an efficient SELECT statement

Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of

RE: VARIABLE-1 = '' Inconsistent behaviour

For what it's worth, the Arev knowledgebase has a great article on optimising BASIC code (for speed!), which mentions that the -1 concept is the slowest structure. Admittedly we have processors that thrash these things out in milliseconds today, but for the purist... The A = A : newvalue : @fm

RE: Document scan and retrieval (looking for software)

Title: RE: Document scan and retrieval (looking for software) To nitpick - but it catches out a LOT of people - SAMBA is NOT NOT NOT the appropriate software here. It will NOT do what you claim. Samba allows Windows boxes to access a unix server (and allows that server to join a Windows

RE: Help wanted creating an efficient SELECT statement

You can get part way there through SQL, though you cannot (sadly) capture an SQL SELECT to a select list if it contains a GROUP BY clause. So here is a kind of work-around using a scrudgy bit of a program. I'm sure someone can come up with something better, but this is what first came to

RE: UV SELECT Info Display

Mark, This is probably too late, but FYI it's EXPLAIN Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: 03 February 2004 21:59 To: 'U2 Users Discussion List' Subject: UV SELECT Info Display Brain

RE: Help wanted creating an efficient SELECT statement

This is a bit messy ... Firstly create an i-descriptor as follows 0002: FIELD( @ID, ",", 1, 1); FIELD( @ID, ",", 2, 1)+1; TRANS( @FILENAME, @1:".":@2, 0, "X") (I think I've got that right...) What it's doing is adding 1 to the X bit, and doing a trans to see if the record exists. If I've

Unix - Windoze Account(s) Move

I'm attempting to build up an archive copy of our finance system on Windows XP (Professional). The app normally runs on an HP Unix machine. So far I've been able to move the files, run fnuxi on them and gain rudimentary access to the data from the command prompt. What has me a bit stumped is

RE: COM Exception

Gene, More information needed, I'm afraid. What are you actually using to access UniVerse: is it UniObjects, UniOjbects for Java, ODBC, OleDB ? Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene W. McDonald Sent: 04 February 2004 13:55

RE: Memo: Re: [UD] Determining if list exists

At 06:34 PM 02/03/2004, you wrote: Goo'day, Are you sure the IF E = 401 bit works in UV? This would not work within UV unless proc had been rewritten (doubtful). The error handling within uv is different and this is one of those areas affected by that difference. You can only test IF E or IF

RE: COM Exception

I am sorry... I am using Uniobjects and the code is written in Visual Basic, VB.Net is would say is more appropriate. -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 8:15 AM To: 'U2 Users Discussion List' Subject: RE: COM Exception

RE: Memo: Re: [UD] Determining if list exists

I realize the context of the original reply was a PROC, but for the sake of completeness, you can also handle it within a paragraph. Check @SYSTEM.RETURN.CODE. SELECT SOMEFILE WITH F1 EQ XYZ IF @SYSTEM.RETURN.CODE LT 1 THEN GO NONE.SEL Tim Snyder IBM Data Management Solutions Consulting

Re: UV command failing mystery

The 'uv' command is basically a small front ender to the 'uvsh' executable, which is really the guts of universe. The uv command does little more (for universe) then to check ulimit settings, increasing them when necessary, then issuing an execve() call to uvsh. If you bypass 'uv' and just

RE: UDT SELECT optimization

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

RE: [ADMIN] Why multiple digests, and a lecture on Netetiquette

Cool, saving bits - most of us over 40 grew up doing that ;-) -dawn PS Video attachment omitted -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Document scan and retrieval (looking for software)

Title: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block"

Re: Document scan and retrieval (looking for software)

George, When did 'google' become a verb? I'm not objecting to your use - I say it, too. I'm just not sure when we started verbing that noun. - Charles 'I was an English Major In College and Look What Happened' Barouch George Gallen wrote: RE: Document scan and retrieval (looking for

RE: Document scan and retrieval (looking for software)

Title: RE: Document scan and retrieval (looking for software) Could be. Whatever it is, it's ancient history :-) You know Tridge originally wrote samba to communicate with DecNET, and was surprised to discover that it could be used to communicate with MS too? When his company retired the

RE: UV command failing mystery

Thanks for the suggestion. We will try uvsh the next time we have the failure. Last night we had the problem occur for 50 mins. Because it continued for so long we were able to have users in our various locations make multiple attempts to login from multiple PCs. Surprisingly, some locations

RE: Document scan and retrieval (looking for software)

Title: RE: Document scan and retrieval (looking for software) Guess that answers the what is...looks like it is...Server Message Block... George -Original Message-From: Jeff Schasny [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 11:16 AMTo: U2 Users Discussion

RE: Document scan and retrieval (looking for software)

Title: RE: Document scan and retrieval (looking for software) they would intresting to see. Either offlist or onlist. George -Original Message-From: Jeff Schasny [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 10:32 AMTo: U2 Users Discussion ListSubject: RE:

RE: Proc or Para

Procs are definitely a subject that will start a good debate. I don't think Procs offer any performance advantage at all. It does offer the ability to do things that are possible in paragraphs like PROCWRITES. That said, I personally have never been a fan of procs. I started out in the

kibbles and bits

remember TRON, it took him a while to figure out that floaty thing was a bit. That was really a neat movie as far as geeky terms go... George -Original Message-From: John Cassidy [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 12:44 PMTo: [EMAIL PROTECTED];

Re: Proc or Para

At 12:38 PM 02/04/2004, you wrote: All, Is there a performance advantage to using one or the other? I realize this might be a touchy topic but it's one I've been wondering about for some time. the ProVerb manual makes it sound like procs were a migration tool of sorts. Paragraphs are only

Re: user group meeting January 21 (wed)

Mark, I am sorry that I could not make it to this meeting. Did the speaker give any verifiable trend information that was useful? Please stop at our display during the Spectrum show next month in Las Vegas and say hello to Mark Thomas and I. Best regards, Patrick Will Williams -

Re: Re: [UD] Determining if list exists

I think that the reason so many mv'ers don't like procs is they don't understand them. /snip HSSELECT AR WITH PAYMENT.DATE GE 2-9-04 STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P snip\ I don't want to hurt anyone's feelings, but, this is almost funny. Why

Re: Re: [UD] Determining if list exists

How about this one to end this thread? M S1 IH%1:U50BB: T %2,,+ IBP %1 H%1 P GO B -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: Re: [UD] Determining if list exists

Now that is elegant ! :-) Bruce M Neylon Health Care Management Group Glenn Herbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/2004 02:09 PM Please respond to U2 Users Discussion List To:U2 Users Discussion List [EMAIL PROTECTED] cc: Subject:Re: Re:

Migrating U2 data

Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: [UD] Determining if list exists

Title: [UD] Determining if list exists I'm not sure if this is what your looking for, but here goes. Insert the statement IF # S GO 99 after the initial SELECT statement. If no items are selected, then the proc proceeds to label 99 which displays a message and exists the proc. This prevents

UniDebugger in SB+

I was inspired by a recent post to take another swing at getting UniDebugger to work w/ our UD6/SB+5.2/HPUX system. I have scripted the login, and can open, edit, and compile code. However, when I try to run a program through UniDebugger, the output window shows - logging into Dual

RE: UniDebugger in SB+

Haven't used the Dual Session so can't offer any help on that but... Try Control T as the break key... -Original Message- From: David Beahm [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 5:13 PM To: U2-Users Subject: UniDebugger in SB+ I was inspired by a recent post to

RE: [UD] Determining if list exists

Title: Message Hi Chris, Why not just use the 'REQUIRE.SELECT' or 'SELECT.ONLY' keywords in your query? This will then only run if there is a select list present. The Uniquery manual documents this quite well. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P

Windows 2000 ODBC connectivity problem...

I have the UniData 6.0 ODBC client software installed on a Windows NT 4.0 machine and a Windows 2000 machine. Setting up an System DSN ODBC profile on the Window NT box work just fine, however on the Windows 2000 machine, whenever I access the server drop down list box, there are no servers

Re: Migrating U2 data

Universe or Unidata? What version from? What version to? - Original Message - From: Cyndi Calvin To: [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:23 PM Subject: Migrating U2 data Any pointers on what document explains how to move data from an

RE: Format Text in Output Data File

Title: Message By definition a .csv file is plain text. That means no formatting. Best thing you could do is to setup a macro in your spreadsheet to do the formatting you want after loading and parsing your .csv. HTH, Gordon Gordon J. GlorfieldSr. Systems AnalystMAMSI301-360-8839

Re: Migrating U2 data

IBM actually has documentation on this. http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf It's in the first chapter. You just need to copy the data files through the network and use the convdata convcode tools. I would recommend a complete rebuild of indexes as opposed to using convidx. The

RE: Format Text in Output Data File

Karl has one good way to do it. I'd like to slug whoever it is that put it into people's heads that CSV is the universal pipe into Excel. CSV is for raw data only, it has nothing to do with formatting. If you want formatting then you must understand how to use the functionality built into

RE: Windows 2000 ODBC connectivity problem...

Title: RE: Windows 2000 ODBC connectivity problem... Just today I added another server into my UCI file and it popped up in the server list right away (running Win2K professional SP4). Have you rebooted the Win2K machine since installing the ODBC client? No other ideas - if your *sure* the

Re: Migrating U2 data

Ah, silly me. My brain combined (U2 data = ""> Missed the give away clue of the release being version 10. Disregard my suggestions as they were UniData specific. As I crawl back under my rock... At 05:21 PM 2/4/2004, you wrote: Well, Universe is the RDMS (no?). I just need the data (Unidata,

Re: Migrating U2 data

Unidata is a different database (BTW Doug you can move from Unidata to Universe). Make sure you media is compatible between the systems. So you move one tape taking a backup using uvbackup and then restore using uvrestore on the windows box. If you would like some help, we do this for a

RE: [ADMIN] Why multiple digests, and a lecture on Netetiquette

John Cassidy wrote: Bits? You had Bits? All we had were 1's. Unary. And we were darn glad to have 'em. [EMAIL PROTECTED] 2/4/04 11:27:09 AM Back in my day, bits were smaller. We only had 0.5 and 1. There are 10 types of people who understand binary code: those who do those who don't --

Re: Migrating U2 data

So if we are running UniVerse (and UniData is a different DB system)I would not use the document someone referenced http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf because this is for UniData Here is what I was told to use to determine what we are running on old SCO. This is UniVerse? .L

RE: Migrating U2 data

I have done this a number of times and all I did was use the fnuxi command in uv/bin directory. (1) Copy Unix accounts to the windows server. (2) Enter following command in the directory containing the unix dataat the Windows command prompt: dir/b | fnuxi This lists each file name and

RE: UV command failing mystery

Vance: Is echo $? returning anything meaningful after uvsh fails? Lee -- Lee J. Leitner, Ph.D. [EMAIL PROTECTED] http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is

[UV] Problem with GET(ARG.,1)

If the command line contains a trailing '?' character, it appears that GET(ARG.,1)FILTER ...returns an empty string. This is probably documented somewhere, right g? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] Problem with GET(ARG.,1)

Hi Barry, Probably is documented but a ? at the end of a command line at TCL will not execute the line and just store it on the command stack. I am surprised your program is executing at all. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000

Universe Date Conversions Using the SQL.B.INTDATE

I've been trying to get a date conversion to work for data being inserted into a SQL/Server table with no success. When I use the SQL.B.INTDATE and SQL.DATE parameters in the SQLBindParameter statement, I get the following error: Status for SQLExecute call is: -1 SQLSTATE,NATCOD are:S1C00 0

Re: UDT SELECT optimization

Title: Message My example was multiple WITH clauses that are ANDed. Breaking them up may be more efficient. Your example begs the question of what is faster: SELECT ORDERS WITH DATE = "01.01.04" BY TIME vs SELECT ORDERS BY TIME WITH DATE = "01.01.04" I tend to put the WITH's first if that

Re: Memo: Re: [UD] Determining if list exists

I once worked on a UV (SCO/Dell Poweredge) that was ported from a MCD that had a lot of IF E = 401, IF E = 201 etc. Come to think of it, every TCL statement generates an ERRMSG. They're just not all errors. 100 items selected is stored in ERRMSG. The ERRMSG dialect is evoked from the STOP