[U2] any New Zealand UD or DataFlo users for support?
Hi All, We are a US-based company with a division in Auckland, NZ. This site is running a different ERP system and there is interest in moving them to ours (DataFlo on UniData/HP-UX). In roughing out a conversion project, I am interested in making contact with NZ folks having DataFlo and/or UD/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 Bennett IT Leader Marinco Electrical Group Napa, CA [EMAIL PROTECTED] 707.603.6252 (direct) Regards, Cliff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
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: Norman Morgan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 9:58 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance > Are we willing to spend $15 to $50 a piece for a new U2 book? > I don't think they'll have trouble finding willing writers. I certainly would be! I'm old-fashioned enough to prefer real books over electronic media. You can read words on paper anywhere, no batteries required. === Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com === A committee is twelve people doing the work of one. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop.
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 list, you can use a subscripted array instead of a dynamic array. You could then use MATREAD to load the INV.FILES() array, place the "-INV" suffix on each element and then open the files to a subscripted F.NAME() array. Regards, Cliff - Original Message - From: Dave R To: u2-users@listserver.u2ug.org Sent: Thursday, July 05, 2007 1:47 PM Subject: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. I am trying to open a group of files from a list of files in the table file. Does anyone know how to make the constant in the open file statement work. I get the good old IMPROPER DATA TYPE error message when I try to read the file I opened with the code. In the mean time I will open each file separately . Thanks Dave. OPEN 'TABLE'TO F.TABLE ELSE STOP 201,'TABLE' READV INV.FILES FROM F.TABLE ,"INVENTORY-FILES",1 ELSE CRT; CRT "CANT FIND TABLE 'INVENTORY-FILES'"; RETURN END CONVERT ',' TO @VM IN INV.FILES FDC = DCOUNT(INV.FILES,@VM) FOR F = 1 TO FDC FILENAME = INV.FILES<1,F>:"-INV" FILE.NAME = INV.FILES<1,F> F.NAME = 'F.':FILE.NAME OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME NEXT F * Dave R e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Finding last day of month
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 well. Regards, Cliff Marco Manyevere wrote: Hi, Given a date like 20040203, I want to return the last valid date for that month and year (20040229 in this case). What is the shortest code fragment to achieve this? At the moment I'm replacing the day with 01, then iconv, add 35 days to the internal date and then oconv and replace the day again with 01. I'm then on the first day of the next month. I then iconv, subtract 1 day and oconv. Thanks for any help. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
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 believe the more full-featured server versions are more expensive on the server side. I am confident IBM is well aware of MS SQL and Oracle server and client DB licensing models since DB2 plays in the same space. Leroy, thanks for providing some interpretation of current licensing terms and some scenarios. Could you please give us details (including pricing) for the forthcoming UniObjects pooling mechanism as soon as you are able? That, plus some detailed implementation scenarios, will let everyone on the list understand options in the near future. Regards, Cliff Bill H. wrote: If I figure correctly, a hundred webshares cost $150,000 at $1,500 per webshare retail! Let's see...SQL Server unlimited site license (single CPU) for $5,000. Sounds like this is an invitation to get off the U2 products...or do I have this completely miscalculated? Bill -Original Message- from Leroy Dreyfuss The answer here is RedBack. It is designed for exactly this purpose. We have customers servicing millions of requests per day on a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Base 16, 26, 36
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; I used multiple for readability. N1 = INT((BOX - 1) / 26) N2 = BOX - (N1 * 26) - 1 SUFFIX = CHAR(65+N1):CHAR(65+N2):BAG Regards, Cliff Brutzman, Bill wrote: We have a bar-code labeling challenge. We need to print hundreds of unique serialized labels. We have three characters available. I am expecting to do something like Master (pallet): H42 2x MMM H42 is our supplier ID. Box # 1 H42 2x AA0 2x is the six-digit packslip number. Bag # 1 H42 2x AA1 H42 2x AA2 Box # 2 H42 2x AB0 Bag # 1 H42 2x AB1 H42 2x AB2 Z * Z = 26 * 26 = 676. Thus, we could have up to 676 boxes. Thus on a single packing slip, we could have up to 676 boxes each having nine bags. It appears that UniBasic has no built-in functionality (operators) to handle base 26, that is, A thru Z. base 36, A thru Z, and one thru ten. I expect that it could be done, brute force, using arrays and equates. Using Wintegrate, we write a txt-file from UniVerse to Windows. BarTender (Windows-based) prints labels from the txt file. BarTender has some VB functionality that I expect we will be forced to use. I am writing because I do not want to overlook other U2 voodoo which may be available. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [AD] UniBasic Program with arguments - utility available
Hi again, Savita. Oops. Solution to wrong problem. I do have a handy program that lets you call any cataloged subroutine with simple args (i.e. strings & numbers) from TCL. It displays the return value of each arg afterward. Let me know if you want a copy emailed to you (or anyone else). Regards, Cliff [previous reply snipped] Chauhan, Savita wrote: Hi, I am trying to run a unibasic program (external subroutine) that takes two arguments. I don't know how do I pass it the arguments if I run it directly from shel prompt instead of calling it from another program. I have gone through the manual, but can't find anything. Pls help. Thanks Savita. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [AD] UniBasic Program with arguments
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 blanks) and then convert blanks to a U2 dynamic array delimiter. I can then count and extract these arguments, sort of like argv and argc in C. A snippet ... SUBROUTINE TEST.ARGS CMD.LINE = TRIM(@COMMAND) CONVERT ' ' TO @AM IN CMD.LINE NUM.CMD = DCOUNT(CMD.LINE, @AM) SUB.NAME = CMD.LINE<1> ARG1 = CMD.LINE<2> ARG2 = CMD.LINE<3> I believe UniVerse has @SENTENCE also; not sure about @COMMAND. Regards, Cliff Chauhan, Savita wrote: Hi, I am trying to run a unibasic program (external subroutine) that takes two arguments. I don't know how do I pass it the arguments if I run it directly from shel prompt instead of calling it from another program. I have gone through the manual, but can't find anything. Pls help. Thanks Savita. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/