RE: [U2] Conversion Code - M
In your code snippit, M isn't quoted, so it's probably a variable assigned elsewhere with a more familiar conversion code. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, June 15, 2005 6:21 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Conversion Code - M In UniVerse with Dynamic Connect, some legacy UniBasic seems to apply a conversion thing such that... crt @(31,19) : Qty.Rcvd M crt @(31,20) : Qty.Rcvd 'R#8' crt @(31,21) : Qty.Rcvd Qty.Rcvd = -Qty.Rcvd crt @(51,19) : Qty.Rcvd M crt @(51,20) : Qty.Rcvd 'R#8' crt @(51,21) : Qty.Rcvd yields... | 2.0 -2 | 2.0 -2 | 2.0 -2 Thus, I am writing to inquire about the meaning of M. Suggestions would be appreciated. --Bill --- 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] OFS experience anyone?
You could probably use BCI/ODBC. We had good luck writing to SQL server from unidata using BCI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Tuesday, June 14, 2005 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] OFS experience anyone? We have a situation where we will need to read/write to a DB2 database on AIX from UniData. Hopefully the new EDA facilities in version 7 will give us this but with this being new I'm a little concerned about whether to rely on it - as an alternative has anyone had any success with or thoughts to share about OFS? Regards, George Land Technical Director APT Solutions Limited www.aptsolutions.co.uk http://www.aptsolutions.co.uk --- 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] CONVERT and number mangling
Can any of the internals gurus help? I'm reading a comma-separated list of long numbers into a variable, then converting it into a dynamic array with CONVERT ',' TO @FM. I'm then processing the numbers, only to discover they're now corrupted! An example from a few days ago was .014386, which got converted somehow to 1.4386e-2. What's the difference? you might ask - but it got fed into the LN() function which blew up and said this isn't a valid number. My current problem is the exact same piece of code, but I'm now feeding in numbers like 1234.56789. Bear in mind my code has a PRECISION 9 statement at the top. The whole point of the LN() stuff is to calculate the number decimal places I need for six significant figures. So this should be fed through an MD20P conversion code, and I get ... 1235.00! I haven't debugged it yet, but I'm pretty certain the number being fed into the OCONV has already been rounded to 1235 - that was certainly the case with the exponential trouble previously. Any ideas why my data is being truncated to 4sf - especially as there's a precision 9 statement at the start of the program? And the only logical candidate I can see for doing the damage is the CONVERT statement? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Again with Setting a Network Printer in Linux
[EMAIL PROTECTED] wrote: Dear Peter, As the lp concept of printing is to temporarily capture a file (frequently to the hard drive) as it is generated by an application, and then send it to a defined destination once the file is completely created, it is possible for system issues (such as number of open files) to impede the proper creation of the file to be printed. Don't forget also, that modern Unix (and linux especially) seems to assume that all printers are postscript. That really cheeses me off, in that it's a right pain if you actually want to control the printer yourself for some reason (like in this case, sending HP control sequences to an HP printer!) It's pretty much a certainty that, by default, this print job is being spooled throught ghostscript. Which will detect it is a text file, and wrap it in the necessary postscript code, fooling the printer into treating it as postscript (if it's a postscript printer) or ghostscript will mangle it itself (if it's not a postscript printer). To my mind, modern linux printing is one of the worst bits of linux. It tries to force you to use CUPS (totally ignoring the linux mantra of choice); while CUPS, even by the standard of Unix, is exceptionally user-vicious. Just read ESR's Aunt Tilley diatribe about CUPS ... My worst experience is where I tried to connect to a network printer. I wanted to tell it where the printer was, so I told it to NOT do a network scan. Next thing I knew, the configuration utility had started (uninteruptably) scanning the network looking for printers ... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I'm in an Array quandry, any suggestions...
[EMAIL PROTECTED] wrote: Dimensioned vs Dynamic--brain damaged code is still brain damaged code. I could not agree more! the music majors passing themselves off as Pick programmers For the record I almost failed music history :) For those keeping track of suggestions for IBM here is one that would help bridge this divide. Allow re-dimensioning of dimensioned arrays at runtime. In VB you have the REDIM command and in C you can re-dimension damn near anything. Having this capability would provide the best of both worlds. As others have pointed out, YOU CAN. You just need to be using one of PI-derived flavours. And someone said you can actually switch between PI and Pick style behaviour even within one program! provided you sprinkle the magic directives in the correct places. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I'm in an Array quandry, any suggestions...
[EMAIL PROTECTED] wrote: George, It really matters what flavor you're running. Which nobody has explained :-) If you run a flavor that puts the overspill in element zero, you may be ok. If you run a flavor that puts the overspill into the last element, that might mess up any accesses to that element in the existing code. true Pick arrays cannot be redimensioned, and put any excess into the last element (this presumably includes UV's true pick flavours). INFORMATION arrays can be redimensioned, have an element 0, and put any excess in there. Presumably the PI flavours of UV (and iirc IDEAL) do that. Note that even with a two-dimensional array, there is only one element 0, that has to be accessed as (0,0) (if one index is zero, the other one has to be, too) Brian Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 12 May 2005 16:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... WOW. I just found an interesting feature of UV. You can MATREAD a record that has more fields than are dimensioned, and you can MATWRITE that record back out INTACT without getting an error, It only bombs with an out of bounds error when you try to reference a subscript past the dimension. Soas long as any of those program dont try to mess with data it doesn't know about, we should be safe. George -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of George Gallen I'm modifying some programs that were written about 15-20 years ago, there must be 30 or 40 that interact with each other. Here is the problem. All the programs use dimensioned arrays, and they were dimensioned to exactly what was needed at the time, now I need to add 4 fields to one program. But I'm afraid if another program reads this newly created array, it will bomb out with an array out of bounds error. What is on my side, is all the programs that reference these files, all use the same variable name. My initial thought was to write a small program that will 1. open a program 2. search for a dimension of the suspect variable(s) 3. increase it's dimension level 4. write the program back out 5. recompile the program (I don't believe any are cataloged) Any other ideas? --- 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] Hold-file to CSV
[EMAIL PROTECTED] wrote: Is it simpler to change the sort sequence in basic or English ? Why should it make any difference? EXECUTE SELECT is your friend :-) Is it simple to add subtotals in basic or English ? Don't jump to conclusions. Given my data, do subtotals even make sense? Is it easier to export data in basic or English ? Is it easier to handle SUBvalues in basic or in English? (and no, we don't all use UniData :-) Cheers, Wol Mark Johnson [EMAIL PROTECTED] wrote: How can Basic be limiting. It has everything English (sic) has and so much more. In fact, there are many reports that 'turn the corner' and cannot be done in English and must be done in Basic. - Original Message - From: Dave S To: Sent: Sunday, April 17, 2005 10:35 PM Subject: Re: [U2] Hold-file to CSV That's the danger of creating reports in Basic. As you can see it's very limiting. Mark Johnson wrote: I have my own method of taking English (access etc) statements and creating CSV's. I'm talking about not re-engineering existing report. Thanks. - Original Message - From: Dave S To: Sent: Sunday, April 17, 2005 7:57 PM Subject: Re: [U2] Hold-file to CSV If the reports where written in Uniquery it would be simpler to extract data from them. Have you looked at MVQUERY ? Key Ally wrote: [AD] You can do this with Zeus as well, and Zeus has other advantages which Monarch does not share. (www.MtOlympus.us) [/AD] Roger Glenfield wrote: Monarch from Datawatch. Converts report files into data. Mark Johnson wrote: The whole premise was to use the existing reports that are presently designed and not re-engineer them. Like many systems, this one is full of finished reports (both english and databasic) and the object is to send them to the hold-file and convert from there. I don't want to re-invent the report generation logic, just use the hold files. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! --- 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/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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/ - Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! --- 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] Clarification on FOR...NEXT loops
[EMAIL PROTECTED] wrote: On the wiki, someone wrote: The FOR... NEXT works well, but had the problem that, until recently, caused a bottleneck in that in processing a dynamic array, eg RECORD (from the above example), the process would start counting from element 1 for each iteration. What this means is that, in order to process just 10 elements in an array, the program has to process It's on this page: http://www.pickwiki.com/cgi-bin/wiki.pl?LoopDebates The text switches from past tense to present. Can someone please clarify whether this is an issue with recent versions of U2? Which one? For UV (dunno at which version), dynamic arrays now apparently have hidden data which stores (a) which was the last field accessed, and (b) where it is in the string. So if you're stepping through the array field by field, UV remembers where you were and doesn't have to start from the beginning every time. (To edit the wiki, click on 'Preferences' at the bottom of the page, then put Mr. Pick's lowercase first name in the Administrator Password box. Or, just post here and give permission for it to be put on the wiki, and I'll do it.) Thanks, -- Wendy Smoak Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is replication across versions a possibility?
[EMAIL PROTECTED] wrote: Rsync, that's an interesting idea I hadn't thought of, thanks very much for your input, I'll definitely be trying that out shortly. Just be careful! What hardware are your linux and irix systems running on? You may need to use fnuxi. Using fnuxi has nothing to do with Windows/Unix and everything to do with byte order. It's just that most Unix runs on (sensible) little-endian boxes and Windows runs on big-endian Intel so everybody assumes its a Windows/Unix thing. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
[EMAIL PROTECTED] wrote: Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something. I know people in this group think U2 is the greatest, but that does not make it necessary to lock it up like the crown jewels. Questions: Why can't end users access the knowledgebase? I could if I could remember my password :-) Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. What business? I think you will have FAST or the BSA after you *VERY* quickly if that business is not software development. As an end user, we have the same licence I think you're talking about, and as I understand it we are *NOT* allowed to use those licences for production. On my workstation they're fine, because I'm a developer ... Some people may wonder why you would develop something in U2? Because it's cheap to buy, cheap to run, and better than the alternatives, maybe? The problem, of course, is it doesn't have mindshare :-( Cheers, Phil Walker Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printronix + HP-Ux + JetDirect
Note that a JetDirect will have two predefined queues, if you use lpd-style printing. raw will pass the byte-stream directly to the print engine, and tends to produce strange results with unix text files :-) text intelligently handles crlf and variants... (basically, lf implies cr) Cheers, Wol use the dumb driver (no thats not a joke) it outputs just plain ol ascii which is what that printer will want to deal with. You can telnet to the jet direct and set it up from there. I've done a few of these and once the jetdirect is setup to only send ascii, and the HP-UX system see's it as a dumb printer then you'll be fine. Thanks, Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 02/02/05 03:07PM We have a legacy Printronix P300 greenbar printer that we would like to LAN-connect to our new HP-Ux server via an external HP JetDirect print server. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe on Linux
[EMAIL PROTECTED] wrote: Last year we were investigating running UniVerse on Windows 2003 but have since decided we would prefer to go down the Linux path. Some concern has been raised with our executive about the sensibility of going down the Linux path. I have therefore been asked to find some reference sites who would be prepared to speak to our CEO. I suspect that such sites do not exist in Wellington or in New Zealand so the speaking to the CEO might not be so easy. It might be an idea to point out that native Pick was ported to Linux in 1995, and from about that date on if you bought a Pick box then it was actually a linux box. I'm sure there'll be other people who know that detail far better than me if you want some help making that point... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SOX Compliance and Universe
Now to this: Seeing this post made me wonder how other companies productivity has changed since SOX. We are going to have to hire people to do jobs that did not exist before. Programming changes that used to take less than a day usually cannot be done now in that time frame. In order to get the proper signoffs from the business, stuff sits and waits now. Our auditors are insisting that we have one person on the business side that makes sure all signoffs are done before anything goes into production. This is a topic that fascinates me. Every week smaller traded companies are 'de-listing' and 'going dark' because of SOX. (Hmm, is that what we were going for?) Then there's the ones that charged on and found that they had grossly underestimated the requirement and the cost. There is a raging debate about how much is too much and whether we have dealt the corporate world a fatal blow. In my personal opinion we had to do what we've done. Are you sure? Unfortunately, the USA (and us as well) suffer badly from NIH. An accounting disaster on the scale of Enron is almost incomprehensible in Europe. Yes we've had some pretty bad Enron-scale foul-ups, but they've *easily* been confirmed as fraud (eg Maxwell) or incompetence (Marconi/General Electric (not your one)). And a lot of companies in Europe were in quite a mess because SOX was *illegal* under European law, but some joint-listed companies can't pull their listings from the US stock exchanges (some rule about compulsory listing if you have more than so many US shareholders - so it's actually possible for a European company to be forced to comply with US listing rules because Americans have bought on the European Bourses!) The two things that would (and have) prevented an Enron-style disaster here are the rules that say if you have a controlling interest (50% or more) then you are financially responsible for your subsidiary - I was shocked to discover that the US figure above which you have to take responsibility is 97%! And the chairman/board/whoever has a somewhat vague responsibility to confirm that the accounts are a fair representation of the state of the company. In other words, if you know of accounting shenanigans you can't sign ... It's interpreted fairly strictly, and auditors have been known to be clobbered by it, too. I think SOX is damaging, precisely because it is OTT, and from what I've heard about comparing it to European practices, I gather it's probably not that effective, either! Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ThoroughBred to U2 file conversion
[EMAIL PROTECTED] wrote: Wow, I have not heard that name in a while. I had to convert a client off ThoroughBred to a Universe base ERP system many years ago. We never did find a good, direct export function. Instead we printed reports to text files then used a product called Monarch to map these files and covert the data to a format we could import into U2. A bit tedious yes, but it worked fairly well. If you do dump stuff to text file, I've got a program I've called HOLLLOAD to load fixed-width stuff into a UV file. I'll try and post it at PickWiki in the next few days. If the text is in a punchcard style format you just tell HOLLLOAD which fields to use and how wide they are (it reads the default from the dictionary), and up it comes into file! Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Terminal Servers
[EMAIL PROTECTED] wrote: Happy Australia Day ! HP-UX 11i, UV10. We currently use HP DTCs (Datacommunications and Terminal Controllers) to provide both connectivity for dumb terminals, and binary or ASCII I/O for various black boxes, PCs and printers under the control of daemons. HP are discontinuing support for these devices shortly, and our facilities management providers are having trouble finding an equivalent device. Does anyone have thoughts on what we could use as a replacement ? Just done a web search for our Shiva box, but it seems they're no longer on the market. However, lantronix apparently still make the things. Note that, like our Shiva, they now run serial over cat5, and therefore have RJ-45 sockets rather than DB-9 or DB-25. If you need any help with wiring, let me know (note, this isn't a recommendation for lantronix - just saying that they make what you need...) Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FW: Off Topic I need an X window emulator
Probably his best bet would be to install cygwin (http://www.cygwin.com) which includes an x-server. For $25, he can get the MI/X server from www.microimages.com/mix/ (they have a free trial). If he's really ambitious, a copy of vmware ($$) will let him run a full linux on his PC alongside of windows. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Monday, January 24, 2005 1:14 PM To: U2-Users Subject: [U2] FW: Off Topic I need an X window emulator Hello Everyone, I have a friend that is looking for a free X-window emulator to access his unix box from his PC. I was wondering if anyone out there had an answer for him? Thanks in Advance! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 09:09 To: [EMAIL PROTECTED] Subject: I need an emulator I am looking for a free X-Window emulator, to access my Unix box from my PC. Got any suggestions? Dave David Preston System Administrator U Understand S Simplify A Act \ Automate STONE Construction Equipment Inc. P.O. Box 150 8662 Main Street Honeoye, NY, 14471 Direct Dial: 585-229-3220 Fax:585-229-2363 e-mail: [EMAIL PROTECTED] Web Site : www.stone-equip.com Company e-mail: [EMAIL PROTECTED] --- 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] UniAdmin not working ...
I've just installed a copy of UV 10.1 on a virtual Win2K3 server. That's working fine. I've also installed a copy of the matching UVAdmin program on my pc. That seems to be working fine, in as much as when I try to talk to our UV 9.5 box, it rejects my login with you must be an administrator. The trouble is, when I try to connect to UV10.1, it fails with no rpc connection active. Seeing as this box is useless until I can get UVAdmin to connect to change the default settings, this is a major stumbling block! Any ideas, anyone? Two possible factors - I used my normal id (not Administrator) to do the install (I was given administrator rights, not sure I'm happy about that...), and I installed everything on the server in c:\progra~1\IBM rather than the default c:\ibm. Could either of these two have anything to do with it? Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV]Strange But True
[EMAIL PROTECTED] wrote: I don't know if it is intentional but the values you are comparing are exponential. So the comparison is of two incredibly small numbers. The numbers are so small they are equal for all intents or purposes. small is subjective. The earth is only rounding error as far as the universe is concerned, but it is very important to us. To my mind this is a major bug, if you're right. It's as bad as IF 100 = 0.01 were to return TRUE. (Which is exactly the same comparison, scaled up.) The correct way of dealing with rounding error is for the internal logic to be along the lines of IF (A-B)/A 1E-6 THEN RETURN TRUE ELSE RETURN FALSE. While I'm pretty certain 6 is the wrong number, there is a concrete justification for it - when comparing FLOAT*4 numbers it guarantees that you are using the best available precision without falling over processor rounding artifacts. There is a similar number for FLOAT*8, which is what I think UV uses internally. (And I'm assuming A and B are positive, correct appropriately for negative numbers :-) Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Pitch and Point
If they're talking about a fixed-pitch font (like Courier), when they say ten point they almost certainly mean ten pitch i.e. 10 c.p.i. - your bog-standard IBM golfball typewriter font (if you're old enough to remember the marvellous IBM golfball, of course!) Actually, they probably don't realise they are talking about fixed-pitch, and they may well really mean ten point. As pitch gets bigger, point gets smaller and vice versa. The more characters (increasing pitch) you cram into an inch, the smaller (decreasing point) those characters have to be. And it just works out that a 10-pitch and a 12-point font are roughly interchangeable, as are a 12-pitch and 10-point font. Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] test
[EMAIL PROTECTED] wrote: Les, More to do with Thanksgiving than anything else. Personally, I can only face one turkey dinner per year... Well, you could always have traditional fare instead. It's supposed to be goose on 25th December. And a decent goose doesn't leave you eating bird sandwiches for a week after ... :-) (a typical goose feeds 6 :-) Simon Cheers. Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] NACHA Electronic Payments
I've done EFT transfers with a couple of banks and the NACHA format is all pretty simple. The hard part is actually getting the file to the bank and getting back results. I'll be glad to answer any questions you have about it if I can. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, November 22, 2004 4:19 PM To: U2-Users List Subject: [U2] NACHA Electronic Payments Hi Folks. This is probably a bit off topic but I'm hoping I can get some help anyway. I've been given a task of automating our customer EFT process and handed a Xeroxed copy of a file layout for NACHA FILES. It appears that it is actually a re-typed variant of what someone else got from an actual specifications document. For the most part, it's clear enough that I've developed the bulk of the program but I need some clarification of a couple of points and concepts. Is anyone familiar with NACHA.org files that would be willing to field a couple questions about layout and relationship of these files? I can't go directly to NACHA and buy their book because 2004 editions are sold out and they won't be shipping 2005 until January. I'm needing to finish this up by the first week of December. I'd be very happy to take this off line so as to not bother the rest of the group. Thanks in advance. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with fnuxi
[EMAIL PROTECTED] wrote: Two machines running the same OS is fine. It's just Windows to Unix and vice-versa (and any other combo that requires fnuxi to be run). WRONG WRONG WRONG. I've transferred type 30 files between three different machines - SCO, linux and Windows - and the files are *BINARY* *COMPATIBLE*. The thing is, they *all* run on x86 boxen. Most nix boxen are big-endian, all doze boxen are little-endian, hence the assumption it's a doze/nix thing. But it isn't - it's an endian thing. Some systems (SPARC?) can be either big or little endian, so you could find yourself having to run fnuxi to transfer files from a machine to itself, should you have a dual-boot system ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 19 November 2004 14:00 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi Is everything still OK for copying files between two like machines for purposes of replicating for a test system then? I can get around the issue of between OS's but now I'm worried about recreating the test environment. Thanks, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, November 19, 2004 2:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi I had the same problem recently. IBM told me you can't; once a file has been SQL'ised (which adding triggers does) you can't move it between OS's. Even dropping the triggers won't work. All you can do is to create a new file on the source machine and copy the data to it and then port that one over instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 18 November 2004 21:20 To: [EMAIL PROTECTED] Subject: [U2] [UV] Help with fnuxi I have some data files that I can't run fnuxi on because they have triggers. How do I successfully move these files between *NIX and Windows without having to drop the triggers? Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Files from UD Unix to UD Windows
Something to watch out for (though I don't think it applies here). People always say transferring from Unix to Windows. Yet here I'm running UV/SCO, UV/Win and UV/linux. AND THE DATA FILES ARE BINARY COMPATIBLE ACROSS ALL THREE !!! Thing is, most nixen run on little-endian RISC, while Windows runs on big-endian x86. It's the big/little-endian that determines whether files are compatible, not the nix/Win dichotomy. Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Uniobjects.NET speed/performance
[EMAIL PROTECTED] wrote: lol you don't actually consider 512Mb a lot of ram now do you ? Actually, I certainly do ... My mobo at home is maxed out for ram. It has 768Mb. I've just upgraded my daughter's ram. Her pc has two slots and I've maxed out one ... with 512Mb. And a lot of office pcs actually have a LOWER spec than home pcs. I think my work pc only has 256Mb. Having done ( and still doing ) extensive work using .net ( winforms , webforms compact ) i'd say your talking out your @$$. ;-) i think your final statement says it all - Yes it has a learning curve, but it is still vastly better... an educated guess is that you've never really taken the time to learn .net the way you have with delphi. Ma ymmv would have been an appropriate disclaimer. Yup, I agree ymmv is important, but I back Brian 100% in thinking code should be compact and small. After all, isn't that why we're MV fans? And while I'm not aware of any studies, I'd guess there's a very strong correlation between bloat and crappy coding. The more bloat, the more crap ... and the smaller your code, the easier it is to find a problem when debugging :-) Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse to Linux mySQL
[EMAIL PROTECTED] wrote: I am a bit of novice when it comes to the UniVerse database but I am trying to dive into it and learn as much as I can. I am also new to the mailing list, so my apologizes if I have gone about this the wrong way. My problem is this: I am running an AIX 4.3.3 with UniVerse database 10.1 installed. I am hosting my companies website from Linux running the osCommerce shopping cart that backends all the information in a mySQL database. Instead of having to type in all 250,000 items into the mySQL database, I want to real time the lookups with our own database. Is there a way for mySQL to look up the tables in UniVerse, or is there a better way? There's no need to type them all in. UV will happily export in a relational manner (look up things like OLE and ODBC) although I don't know how easy it is to get MySQL to read stuff from another database like that. The alternative is, do you know how to create a table and populate it using MySQL commands? An approach I'd look at is a simple prog that dumps a UV file into a SQL script - run the script in your RDBMS and there's a table with all the data in ... Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index problem
[EMAIL PROTECTED] wrote: Phil: What I don't understand about this conversation is why would one expect any different functionality from the dbms? This has been, in my experience, the way indexes have always been on the mvDbms products; whether they be U2, D3, or whatever. When an index is created, it is updated if, and only if, the file it was created for changes. Your example indicates an index on DETAIL that translates HEADER information. Since DETAIL is written first, hence no HEADER information exists, the index on DETAIL is updated with NULL. When HEADER is written, it is completely irrelevant what indexes exist on DETAIL (as it is irrelevant what indexes exist on CUSTOMER, RECEIPTS, etc). The only index that will be updated when HEADER is written are indexes on HEADER. And the reason rewriting the record doesn't correct the index is easily explained too. Bear in mind it doesn't create the original index (correctly) because the before snapshot is wrong. It doesn't then correct the index because when you rewrite it the before snapshot is correct, the before and after indices appear to be the same, so optimisation means it doesn't bother with an update (and doesn't realise the index is wrong). Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Max Files Per Directory
[EMAIL PROTECTED] wrote: I've heard some discussions in the past regarding limiting the number of files per directory to help OPEN performance. Does anyone have any real-world experience on what a reasonable limit might be on a *nix file system? Suck it and see :-( It varies too much - how much ram do you have for caching, how efficient is the file system you're using, etc etc. For example, on linux you'll probably find Reiser outperforms ext2 by quite a large margin ... It's probably still true that too many files is not a good idea, but machines today are fast so it's less of a concern than it was in years gone by. Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Numeric rounding - UV 9.4 10.1
[EMAIL PROTECTED] wrote: I have a habbit of using the following syntax to round numbers to a certain number of decimal places: X = 1.623 CRT X '2' CRT X '0' Yields: 1.62 2 It's always worked fine. Until we did an upgrade to 10.1. Now it has been deemed un-reliable because it produced an undesirable result (an empty string) in a rather sensitive program. So, first question is: Is this a bad habbit I've had all these years? Yes. Second question: Has anyone else experienced a problem with this method of rounding? Is it a known bug? iirc, yes/no. I seem to remember a thread on this list ages back. If you use JUST a number as your format operator, it does not necessarily mean what you think it does. This other thread was about it apparently producing the correct result for ages and then suddenly going wrong. Basically, the number can either be interpreted as number of decimal places or as string width. That's why another poster suddenly found that 0 returned the empty string! iirc the manual is clear on what is the correct interpretation, but certain implementations do/did get it wrong. As with all these things, it pays to be explicit and not take short cuts ... Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Loading Universe on AIX - which versions?
Andre Have been running UV 10.0.14 on AIX 5.2 (on IBM pSeries) for about a year and no problem encountered. Just be make sure the AIX 5.2 is installed with latest patches updated (I have faced problem with MOTIF command if the patches is not installed). Liu From: Andri Nel [EMAIL PROTECTED] Date: Thu, 27 May 2004 09:56:18 +0200 I have just ordered a new IBM p630 box and will be loading AIX 5.2. Based on some previous postings it seems as if problems are being experienced with certain versions of UniVerse on AIX 5.1 and AIX 5.2 (eg. 10.1.0 does not sound the right way to go). Can anyone recommend which version of UniVerse I should go for on AIX 5.2 and what I should watch out for. _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users