RE: [U2] DCOUNT

Over years experience using pick, uv, sb, sb+ I believe that this is the best and most controlled way. Jim Garratt CTI Logistics Ltd > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Thursday, 5 January 2006 1:22 PM > To: u2-users@l

Re: [U2] DCOUNT

Goo'day, Mark, At 00:21 05/01/06 -0500, you wrote: I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC<15>,@VM) FOR I=1 TO LAST (process somethi

[U2] DCOUNT

I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC<15>,@VM) FOR I=1 TO LAST (process something) NEXT I There was a REMOVE thread a few months ago

[U2] [UV] Upgrading user count requires UV shutdown

We have purchased extra licences for our UV 10.0.16 system, and have discovered on our test system that we need to stop UniVerse in order to install them, otherwise we get an abnormal termination. Previously under 9.6 this could be done dynamically with all users logged on, and I am advised that un

Re: [U2] Converting number to word

I wish that this Check Print Amount routine were standard MV-issue instead of home grown. On that topic, there is a user exit for converting a number to a roman numeral. For sales reports to the branch offices in Italy. My 1 cent. - Original Message - From: "Bruce Nichol" <[EMAIL PROTECTE

RE: [U2] [uv] Something Strange happened today {Unclassified}

Mark, Since nobody else has replied, I'll put in my two cents worth ... > -Original Message- > From: [EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. > Sent: Friday, 6 January 2006 09:44 > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Something Strange happened today [snip] >

RE: [U2] [UV] Create hashed file in subdirectory?

>You can create part files like this- >CREATE.FILE DATA SCRATCH,MYHASHFILE 18,1,1 OK, this does not do exactly what I had in mind, but it DOES work and is totally interesting. When I executed that command, behind the scenes it made a subdirectory under SCRATCH named SCRATCH, and moved all of the

[U2] UO.NET registry exception in method dealing with performance counters

REPOSTED FOR NON-MEMBER: "Glenn Batson" <[EMAIL PROTECTED]> Has anyone had experience with UO.NET throwing an exception related to what looks to be permission issues related to updating the registry for performance counters? Unfortunately the exception details were lost, but what I remember was

Re: [U2] [UV] Create hashed file in subdirectory?

You would use CREATE.FILE DATA SCRATCH, Per the CREATE.FILE documentation, there can be no space between the filename and the datafile name, only a comma. Note that your VOC file entry for SCRATCH is now modified to indicate it is a multi-level data file (if that is the correct terminology a

Re: [U2] [UV] Create hashed file in subdirectory?

> This is Universe 9.6.1.3 on Windows 2000. > > I have a type 19 "file" (in other words, a subdirectory) that looks like > this in the VOC: > > 001.. F > 002.. SCRATCH > 003.. D_SCRATCH > > I use this to create temp files and other administrative type files which > usually get deleted later. >

Re: [U2] [UV] Create hashed file in subdirectory?

Barry Brevik wrote: This is Universe 9.6.1.3 on Windows 2000. I have a type 19 "file" (in other words, a subdirectory) that looks like this in the VOC: 001.. F 002.. SCRATCH 003.. D_SCRATCH I use this to create temp files and other administrative type files which usually get deleted lat

RE: [U2] [UV] Create hashed file in subdirectory?

You can create part files like this- CREATE.FILE DATA SCRATCH,MYHASHFILE 18,1,1 This will create MYHASHFILE under SCRATCH. Then any reference to the file will be SCRATCH,MYHASHFILE, for instance- FILE.STAT SCRATCH,MYHASHFILE HTH Rod Hills -Original Message- From: [EMAIL PROTECTED] [mail

[U2] [UV] Create hashed file in subdirectory?

This is Universe 9.6.1.3 on Windows 2000. I have a type 19 "file" (in other words, a subdirectory) that looks like this in the VOC: 001.. F 002.. SCRATCH 003.. D_SCRATCH I use this to create temp files and other administrative type files which usually get deleted later. So... this sounds s

[U2] [uv] Something Strange happened today

UV 10.0.8, Solaris 8: We had a 'situation' in which I think UniVerse basically became constipated. Late this morning users reported that they were halted - they finished their last task and then... nothing. I immediately worried that the VOC file in our production account had locks... no such

RE: [U2] [UD] OSBWRITE problem

You can try "NOCONVERT ON" to see if that fixes your problem. Hth Colin Alfke Calgary, Canada >-Original Message- >From: Brian Leach > >All, > >I'm having a problem writing a binary file from UniData. > >I need to store some lengths as 4 byte integers, and I'm >deliberately encoding a

RE: [U2] Universe List.CSV command

Or you could download the open source "download" via anonymous ftp from ftp.cedarville.edu. It will create CSV, XML or HTML ouput from any U2 file. Syntax is very similar to standard LIST query with some enhancements. Larry Hiscock Western Computer Services -Original Message- From: [E

RE: [U2] Universe List.CSV command

In Unidata you just use LIST with the TO and DELIMITER clauses... Surely Universe has an equivalent??? I think that's the right clauses, working on a mvBASE platform today... Allen E. Elwood www.tortillafc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf

Re: [U2] Universe List.CSV command

Diane, I don't think that LIST.CSV is a standard UV verb. It's possible that it was a homegrown utility. Was it at a previous employer/client that you used that verb? At least that would be my guess. I'm betting you may have to roll your own or as our esteemed moderator Charles mentioned yo

RE: [U2] Converting numeral to word

David, Here is a routine I've quickly massaged from some VB code. Check out the FormatOptions and play around. It seems to work e.g. 1234 -> One Thousand Two Hundred and Thiry Fourth 100 -> One Millionth 1 -> first Hope it helps...and apologies to others for posting a long routine. Brian

RE: [U2] openseq question

Gaaa! no...most of the files I've uploaded were measly little files. Tiny, little itty bitty files. Like specs on the wall small. Mostly forecast files where you just have 12 three to four char qty's for a couple thousand parts. And you gotta realize that people get used to their graphs. In t

Re: [U2] Universe List.CSV command

Diane, Depending on how much control you need over the output CSV, you may want to look at a third party tool. [AD] Zeus (www.mtOlympus.us) will let you do extremely complex data transforms from Type 19 UniVerse files into CSV. With the (real soon now) release of Zeus Special Edition for

[U2] [UD] OSBWRITE problem

All, I'm having a problem writing a binary file from UniData. I need to store some lengths as 4 byte integers, and I'm deliberately encoding all numbers to base 250 + 1 shifted to avoid writing char(0) or char(255)s but I'm still getting a problem with byte translation. I've narrowed it dow

[U2] Universe List.CSV command

REPOSTED FOR NON-MEMBER: Diane Boyd <[EMAIL PROTECTED]> I remember a Universe List.CSV command that created a delimited file from a list statement, <>It had some limitations . I reviewed the Universe 10,x documentation but could not find a reference. Can some one tell me where the LIST.CSV c

Re: [U2] [UD] Calling Stored Procedures

I have successfully used a stored procedure on UniVerse (not UD). I have only called the procedure from a JDBC connection. When I try using the same statement at the console, I get 'Illegal verb "CALL".' It works fine from JDBC, though. *shrug* You might try using a parameter marker ("?")

[U2] Converting numeral to word

REPOSTED FOR NONMEMBER: "David Knight" <[EMAIL PROTECTED]> Happy New Year, A current project involves printing a number string in its alphabetic description e.g. 1 = one, 3 = three, 11 = eleven etc etc. The precise task is printing a label of book information and in this case the label is "edi

RE: [U2] UD: Calling Stored Procedures

REPOSTED FOR NON MEMBER Vinson Lee <[EMAIL PROTECTED]> We're currently running Unidata 6.0 and I have been trying unsuccessfully to call a Unidata subroutine (Stored procedure) via SQL. There isn't a whole lot of documentation on how to call a stored procedure. I'm using the following syntax: {C

[U2] Quick question on the udt catalog verb

Hi - just a quick one On Universe you can edit attributes 7 and 8 (i think) of the voc entry for CATALOG (and BASIC) to change the default behaviour. Can this be done in unidata as well ?? No problem if not, I have a plan B ;) Thanks Sym. --- u2-users mailing list u2-users@listserver.u2ug.or

Re: [U2] Converting number to word

David Knight wrote: Happy New Year, A current project involves printing a number string in its alphabetic description e.g. 1 = one, 3 = three, 11 = eleven etc etc. The precise task is printing a label of book information and in this case the label is "edition" e.g. first/second. Where the

RE: [U2] openseq question

Thank you all. It is working now with the VOC pointer. It is much simpler now that I don't care what account I'm in. One final question. I have downloaded many of the pdfs ( UniBasic command ref., Using unidata, SB+ Solutions, ...) from the IBM site but where is this documented? Are there any bo

Re: [U2] Converting number to word

Goo'day, again, At 16:12 05/01/06 +1100, you wrote: Oops! Mea culpa! Just add "TH" to everything above "THREE" and replace ONe TWO THREE with FIRST SECOND THIRD... (I think) "Fiveth"??I'm sure you'll be able to figure it out Regards, Bruce Nichol Talon Computer Services ALBURY