[U2] any New Zealand UD or DataFlo users for support?

2008-11-04 Thread Cliff Bennett
/Unix experience and open for some consulting. There could be a piece of the conversion project as well as some ongoing support opportunities, depending on time availability. Since we can provide adequate remote support, this is really a local opportunity. Please direct responses to: Cliff

Re: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-18 Thread Cliff Bennett
I'll purchase two! One for each developer. -Cliff - Original Message - From: Brenda Price To: u2-users@listserver.u2ug.org Sent: Wednesday, July 18, 2007 7:17 AM Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance So would I. -Original Message- From:

Re: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop.

2007-07-05 Thread Cliff Bennett
Hi Dave, I'm not sure what is the purpose of lines 9 and 10 (assigning values to FILE.NAME and F.NAME). F.NAME can be undefined until the OPEN statement places the file descriptor into it. I know you cannot have a MV list of file descriptors. Each must be a full variable. If you really want a

Re: [U2] Finding last day of month

2005-06-02 Thread Cliff Bennett
Hi, Marco. I always ICONV the first day of the next month, then subtract a day. For example: ANY.DATE = '02-03-2004' MO = ANY.DATE[1,2] YR = ANY,DATE[7,4] MO += 1 IF MO 12 THEN MO = 1 YR += 1 END EOM.DATE = ICONV(MO:'-01-':YR, 'D') - 1 This lends itself to a subroutine or function as

Re: [U2] Base 16, 26, 36

2005-04-22 Thread Cliff Bennett
Try this Bill. It returns a value for SUFFIX of AA1 for box 1, bag 1 and ZZ9 for box 676, bag 9. You could extend it to capture numbers also but would need to account for the gap in the ASCII character chart between upper case letters and numbers. This could be condensed into a single line;

Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}

2005-04-22 Thread Cliff Bennett
Millions (plural) of DB requests per day will require serious infrastructure regardless of middleware platform. Plus there's always the last-day-of-quarter discount with IBM. 8-) With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I

Re: [U2] [AD] UniBasic Program with arguments

2005-02-01 Thread Cliff Bennett
Hi, Savita. I presume you mean running the program from TCL (:), the U2 command prompt. In UniData there are two built-in variables, synonyms actually, named @SENTENCE and @COMMAND. These contain the raw command line used to invoke your subroutine. I usually TRIM this (to eliminate multiple