Re: Memo: RE: [UD] Union Query
My 2 cents on this topic and maybe it'll trigger a UD/UV response. D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your next process. Could this work for this person by pre-qualifying the 2 separate SELECT statements into 2 lists, blah. blah, blah. I'm interested to know as well. Thanks. - Original Message - From: Bruce Lunt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:11 PM Subject: Re: Memo: RE: [UD] Union Query Open mouth, ... insert foot. Or whatever :) I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I would copy all the ID's to a work file and then TRANS-ing the NAME.LO, to ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in both files you have to decide what do to do with that. Again, sorry for not testing out my solution before I offered it. Regards, Bruce From: Allen Egerton [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Re: Memo: RE: [UD] Union Query Date: Fri, 30 Apr 2004 14:41:17 -0400 From: Burwell, Edward [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 30, 2004 2:00 PM Subject: RE: Memo: RE: [UD] Union Query Does that work for you? It doesn't work for me. ORDER.FILE NAME. 114061 C.M.O.S. INC. *ASC* 114062 AMERICAN PERFIT XSTAL 18 TIMELAND COMPANY 19 MCCANN ELECTRONICS *STR* 130395 TERMINAL TECH SERVICE 138562 TOWN VISION ELECTRONICS 154897 CASIO SERV CENTER *ASC* 163063 CASIO SERV CENTER *ASC* 171230 AMERICAN PERFIT XSTAL 195731 ELECT MUSIC INSTR *FAS* 10 records listed Enter CR to print non exist record ids 007890 007891 007892 007893 007894 016057 016058 016059 016060 016061 Here is the dict: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S I can't test it right now, I don't have access to a Universe machine until tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't in ORDER.FILE. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ MSN Toolbar provides one-click access to Hotmail from any Web page - FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
The Advanced Pick manual illustrates most all of the SYSTEM() references. It's one of my favorite manuals as it's chapterized like all the others but the index is pure as it contains everything. I don't like the UD/UV manuals as you need to know which index in which book to look up your topic. If you're looking up U50BB, is it in the ECL book, the UniProc book or the UniBasic book?. Not that helpful. Please no flames about books on CD's. Not always helpful either. my 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 8:10 AM Subject: RE: Input weirdo... Thanks Mark! Bjorn managed to find his reply (in an Advanced Pick manual) just after I'd sent the request, which kinda worked, but not exactly, but your length of inputbuffer works a charm. Speaking of these SYSTEM thangs - is there anywhere I can get a list of all the settings / variables included in SYSTEM(x)? -Original Message- [snip] SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
I have a new client that i've yet to be able to break key with over the modem. So if I'm running a program (readnext etc) but i want to break, I include this INCLUDE. IF SYSTEM(14) # 0 THEN INPUT A IF A=Q THEN CLEARSELECT (sic) ; STOP IF A=D THEN DEBUG END SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. My 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:54 AM Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Accuterm like Wintegrate
I use wintegrate a lot as an emulator, file transfer and running PC-based programs. 2 new clients both have accuterm and I'm wondering if their file transfer (import/export) facilities are programmable or are manually managed. Also, is there the equivilent of WIN.PCRUN. I can always install wintegrate but I may not want to rock the boat. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Barcode printing
In my 15 years of printing/using bar codes, I've concluded that it's best to not re-invent the wheel and purchase printers that are bar code capable. Thus, you don't really make up the bar code lines themselves, you just send an escape sequence telling the printer what kind of code, orientation, position and value. I used to do bar code manually on Printronix printers and will never go back to calculating the spaces. Let the printers do their magic. my 1 cent. - Original Message - From: Lee Messenger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Com [EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:03 AM Subject: Barcode printing I am attempting to identify a solution to printing barcodes from within Universe basic. I have reviewed the archives at IndexFocus and found some references to examples, however the 2 of 5 example only handles numeric data and the link to the 128 barcode was no longer active. Can anyone provide me with some information or examples. We are a Windows environment with HP printers. Any assistance would be appreciated. Thank you, Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How do we convert lowercase letters to uppercase in Pick basi c
Only downsides to these OCONV's is that McDonalds and O'Henry lose the 2nd capitalized letter. The only true way to manage would be to have a BEGIN CASE situation to look for MC or O' at the beginning and handle that way. Plus maintain a list of unprogrammable exceptions. I have a music database program that needs this, especially the exception list like LeAnn Rimes, DJ Freddie, USA etc. Also, the exception list could force certain words to not capitalize. The exception list's primary key is the Uppercase version of the word and 1 is the true form. mY 1 cEnT - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:17 PM Subject: RE: How do we convert lowercase letters to uppercase in Pick basi c tx for the help regards reddy Jeff Schasny [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2004 03:12 PM Please respond to U2 Users Discussion List [EMAIL PROTECTED] To U2 Users Discussion List [EMAIL PROTECTED] cc Subject RE: How do we convert lowercase letters to uppercase in Pick basi c OCONV(whatever,MCU) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI as nice as character-based
for Java to be the only possible solution to fit the rules -- I just tried to be sure to rule out the V-word ;-) [Just a little joke there -- I actually think that Visage is likely an excellent choice for Microsoft-centric sites and I'm a Ross-fan myself, remember] Cheers! --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Monday, April 19, 2004 7:21 PM To: U2 Users Discussion List Subject: RE: GUI as nice as character-based Dawn, Citrix Server would break DLG (Dawn's Law of GUI) rule 4 anyway, as you would need to pre-install Citrix client software on most platforms. BTW Dawn, do you have a mathematic proof of DLG ? Just wondering, 'cause just like the Great Date Debate, many may be happy to 'bend' these rules because they don't apply to the environment they use ? For example, Citrix has MANY other advantages, especially in larger organizations, when it comes to issues like securing the desktop, and centralized updates etc. In Wyatt's case, he can simply install SmartTerm (oops, Windows only product, breaks rule 1 - hmm, but with Citrix his client 'can' be a Mac ?!!? Your proof could be 'interesting' ?!?!) onto his Server, and it then requires no pre-installation. He can have a link on a web page to download the Citrix client software does this 'break' your 'rules', or does it fit ? Of course Citrix Server/Terminal Server has an important place in larger enterprises, addressing issues like security, desktop lockdown, patch/update management, software distribution etc - which transcend DLG Also with your rule revision below, as with the original DLG, you still haven't included the J word, which I believe is an implicit (and understood) requirement for DLG !?! Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: Tuesday, 20 April 2004 5:14 AM To: 'U2 Users Discussion List' Subject: RE: GUI as nice as character-based Ah, I should add or modify one of the requirements -- when I indicated that there needs to be no setup on the client, I should put that in the client tier and consider citrix servers to be application clients, of sorts. So, for my purposes (though not for everyone), a citrix server is not an option. 1. Client Tier (no setup) 2. Http Server Tier (could include app server, such as tomcat or EJB container such as Eclipse or WebSphere) 3. Database Server Tier I'll clarify the requirements to add no more tiers. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buffington, Wyatt Sent: Monday, April 19, 2004 1:57 PM To: U2 Users Discussion List Subject: RE: GUI as nice as character-based We have been using a product called SmarTerm from Esker. It allows us to displays screen close to GUI that is easily configureable by the end user with little to no programming. It allows for HotSpots which appear as a button on the screen which the user can click on. Buttons are a list of things that a user can do that are mundane or repetitive, these can save wear and tear on the old fingers. It has a GUI pop up calendar that can be invoked from the host and the date returned back to the host. The user can change the colors on the screen to match their preferences. Email addresses and http links are highlighted differently and can be clickable. You can create you our macros that can be run from a Button. We use triggers to change our screen colors depending on which account we are in. If anyone is interested in a screen shot of what can be done. Email me offline at [EMAIL PROTECTED] We are currently using Version 11.0.5 on both PCs and Citrix Servers. I am also in the process of testing 12.1 Beta. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, April 19, 2004 1:45 PM To: U2 Users Discussion List Subject: Re: GUI as nice as character-based Dawn: Good luck in your search for this holy grail. Lemme know if such a silver bullet is found. I've been hunting for years. Mark Johnson Original Message - From: Dawn M. Wolthuis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:17 PM Subject: GUI as nice as character-based I haven't gotten through all of the postings in the GUI thread as yet, but am working on the question of how to write a GUI that is as good as a green screen from the perspective of folks currently using a green
Re: GUI as nice as character-based
Dawn: Good luck in your search for this holy grail. Lemme know if such a silver bullet is found. I've been hunting for years. Mark Johnson Original Message - From: Dawn M. Wolthuis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:17 PM Subject: GUI as nice as character-based I haven't gotten through all of the postings in the GUI thread as yet, but am working on the question of how to write a GUI that is as good as a green screen from the perspective of folks currently using a green screen application. I saw hints at that, but nothing that tackled it from the standpoint of being able to use any tools on the market today to accomplish this (no need to retain databasic code, for example). What could be used to actually replace, completely, the character screens? Requirements: 0) work with U2 as multiuser databases 1) Be able to use any Windows, new Mac (unix) or Linux client 2) Have graphically attractive colorful screens, looking enough like standard GUIs (M$, in particular) that users would understand the use of icons, etc. 3) Respond to keystrokes by users -- not only to the click of a submit button 4) Require no preparation of the client computers in advance of using the software, likely directing user to a web page. 5) type ahead can be done so that the user is not waiting constantly for the computer to respond 6) Heads down data entry folks are as happy with this as they were with their green screens when they first got those and have only minor complaints if converting now from a green screen, none of substance What are the options -- who has written or seen such a GUI? --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: GUI or Event ? as nice as character-based
Isn't that what System Builder did (does) with its sbclient software? - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:27 PM Subject: Re: GUI or Event ? as nice as character-based Clarify. Are you talking about *within* the mv environment? Or an outside app? Accuterm has the ability to recognize where a mouse-click is in regards to (col, row). This is the same col, row that PRINT @ uses. Now if your mv programs have a single, standard INPUT subroutine then you can simply modify that subroutine. So your modification would look something like If I.am.using.accuterm then if mouseclick then get.location; determine.which.field; reset fieldno = this.field redo.input = true; return end end else input xxx end Or something along those lines. I have only seen one application package that integrated this ability, however, the screen drivers it built allowed the user to point-and-click and enter data into any field in any order on the screen. It was then up to the programmer to ensure that intra-field dependencies were properly handled. But it was certainly a good start. Is that what you meant? Will In a message dated 4/19/2004 2:17:34 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I haven't gotten through all of the postings in the GUI thread as yet, but am working on the question of how to write a GUI that is as good as a green screen from the perspective of folks currently using a green screen application. I saw hints at that, but nothing that tackled it from the standpoint of being able to use any tools on the market today to accomplish this (no need to retain databasic code, for example). What could be used to actually replace, completely, the character screens? Requirements: 0) work with U2 as multiuser databases 1) Be able to use any Windows, new Mac (unix) or Linux client 2) Have graphically attractive colorful screens, looking enough like standard GUIs (M$, in particular) that users would understand the use of icons, etc. 3) Respond to keystrokes by users -- not only to the click of a submit button 4) Require no preparation of the client computers in advance of using the software, likely directing user to a web page. 5) type ahead can be done so that the user is not waiting constantly for the computer to respond 6) Heads down data entry folks are as happy with this as they were with their green screens when they first got those and have only minor complaints if converting now from a green screen, none of substance What are the options -- who has written or seen such a GUI? --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
MV Data Warehousing with Great Plains
Wow. Thanks to all who have helped me create a proposal for my client to possibly keep their MV system as a Data Warehouse to Great Plains. Especially the Data Cube concept which has been in Results for 24 years. I would like to get some first hand examples if anyone has used a MV system as a Data Warehouse to either a non-MV system or an MV system. More towards the non-MV system. In particular, was the Data Warehouse new software and new reports had to be created in that environment. Or was the Data Warehouse the previous application, which is more of my situation. Thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
Let's not forget the lower case L for 1 (one). - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Saturday, April 17, 2004 2:08 PM Subject: RE: UV to Text Conversion Standard? You expect delimiters? When I started in computers, our binary only had zeros - and we were glad to have them! You had zeros?!? We had to use the letter O ;- Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Saturday, April 17, 2004 10:54 AM To: U2 Users Discussion List Subject: Re: UV to Text Conversion Standard? Ross, Perhaps we should all capitulate start to use flat CSV files ? You expect delimiters? When I started in computers, our binary only had zeros - and we were glad to have them! The thing about MV or flat really comes down to a case-by-case to my way of thinking. I generally program Order Entry systems as 1NF, even on MV systems. Pricing, Inventory, and any number of other parts tend to lend themselves to MV. I like being able to choose the best form for each case. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Productivity metrics
Oh boy, I can smell the debates regarding programming styles in lieu of reducing lines of code. Could this be where GOTO's have their day. my 1 cent. - Original Message - From: Bob Dubery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 7:24 AM Subject: Productivity metrics Hi all, IBM initiated a metric called Function Points that attempts to provide a means for measuring programming tools by the amount of code that has to be written in order to produce a program of a certain complexity. There have been several studies by which programming languages have been ranked in terms of lines of code (LOC) per function point (FP) Smalltalk, for example, is reckoned to have a ratio of 20 LOC per FP. Java and C++ come in around the 50 mark. Is anybody aware of studies that have applied this kind of scoring to the BASIC used in MV databases, or any other study that seeks to rank programming languages in terms of programmer producivity and that includes MV BASIC? Thanks Bob -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pro-4
Haven't heard of Application Liberation Language in a dogs age. - Original Message - From: Barry Brooks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 9:53 PM Subject: Pro-4 Hi all I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. Can anyone help ? Thanks ... Barry Brooks -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Conversions
To answer the other questions: I would gain ODBC access with MS Access to the Invoice Header/Line Tables, Customer and Product Tables. I would maintain in Access a table of those Invoices already converted. I would then create a CSV export of the new Invoices and current Customer/Product tables and then have a UD process import them. This process could be run any time and often. This client is too cheap to purchase the ODBC connection for UD. That is, they don't want to pay for my or the VAR's time to install it. Penny-wise. thanks. Mark, Technically Overview: Using some sort of a schedule, you identify new and modified data on the Great Plains system, and move just that data to the MV system, converting the layout and data. That leaves you with the following discreet tasks: How do you identify new or modified data in Great Plains? How do you move and transform the data? How fresh does the data have to be? (i.e. what is the User's expectation weighted against the network overhead of 'shipping' the data.) How do you schedule that move and transform? Management Overview: Tax law (in the US, I believe you are in the US) will require you to keep records going back at least 5 years. Therefore, the old system needs to be available. Since it will have to be up and intact, you see a major cost and performance savings in using that already paid for hardware and already developed software to act as a data warehouse. If they want to move those reports in the future, they can do it in a controlled manner, without having a loss of productivity or information. Not using the older system as a data warehouse will apply pressure to complete these functions now, adding cost and delaying the needed flow of information. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Mark Johnson wrote: This sounds very tempting, using MV as a data warehouse to a non-MV (or MV) primary application. Does anyone else have any insight on how this flies, management-wise or technically. I like it as all of the original reports are already written and tested and it keeps the customer a MV customer. Thanks Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Label printers on AIX and/or Solaris
I've purchased many Prodigy DataMax label printers (4x6 UPS or smaller) from Ebay for around $80-$150 each over the last few years. The replacement heads alone are $280 new. The PCL (sic) is pretty straightforward. It isn't WYSIWYG but debugable. These printers have all the bar code fonts contained. They all have many helvetica-style fonts and sizes. Complete orientation, sizing etc. They are usually serial. There are thermal and ink-based labels. If it's temperature sensitive (either hot or cold) don't use thermal as they fade in time. If they're shipping, thermal is fine. my 1 cent. - Original Message - From: Karjala Koponen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 05, 2004 1:05 PM Subject: Label printers on AIX and/or Solaris Hello, I'm running UniData 5.2.15 on AIX 4.3.2 but will be going to UniData 6.0.9 on Solaris 2.8. We have two stand alone Epson LX300+ 9 pin dot matrix printers we use to print labels. They are defined as generic (ASCII) devices. The printers are old and the output is acceptable, at best. I'd like to replace the printers with label printers that will print on peel off labels of roll stock. These printers generally come with Windows drivers but Unix drivers seem to be lacking. Some of the higher end printers come with a programming manual that would allow me to write code to send control sequences to the printer and control everything. I've done that before but I'd rather not take the time to do that if I can simply attach a printer, either to the network or a serial connection, load a driver and create a queue, and then simply send my few lines of text to the print queue and get a label. Bar code would be nice but is not mandatory. I'm sure that we are just not looking in the right place or closely enough. We are not printing high volumes of labels so less expensive is better. Any suggestions? Thanks, Karjala -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Conversions
This sounds very tempting, using MV as a data warehouse to a non-MV (or MV) primary application. Does anyone else have any insight on how this flies, management-wise or technically. I like it as all of the original reports are already written and tested and it keeps the customer a MV customer. Thanks Mark Johnson I have one client that uses Great Plains. Although an old version I felt that the system was not as aligned to the work flow as many PICK systems are. There was also a trap similar to the old spreasheets in the report generator, where the calculations are directional ir verticle or horizontal. Ie if you calculate horizontal then April's Open Bal is calculated from March's Closing Balance before March Closing Balance has been calculated. We currently suck data out of the Great Plains General Ledger and build it into a Multidimensional Warehouse based on Universe and actually do all the forecasting, Budgeting and Reporting from Universe. One application allows users from Excel spreadsheet to view the journals in Great Plains related to the line item and this is through Universe. We do this online through the SQL features in UvBasic. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Conversions
Bullseye. The client already experienced a month-end (Mar31) and the VP of Marketting was in a snit as most of her reports could not be completed in Great Plains either directly or with Crystal Reports which everyone believes is a magic pill. I visit this client once per week and each week since the migration has been uncovering one shortcoming or another of GP. Everything seems to be an add-on. I've added so many features in the 6-1/2 years of my tenure that they think that today's shopping cart systems will do the same. Sales Tax, Customer Lookup, Product Lookup, Invoice Print, Check Print, Order Print, Job Cost and many others are all too generic and need help. The client is too stubborn to revert back to their legacy MV situation. Thus, damn the torpedos and continue hacking at GP to get the job done. Thanks. - Original Message - From: Results [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Sunday, April 04, 2004 12:55 PM Subject: Re: Conversions Mark, Technically Overview: Using some sort of a schedule, you identify new and modified data on the Great Plains system, and move just that data to the MV system, converting the layout and data. That leaves you with the following discreet tasks: How do you identify new or modified data in Great Plains? How do you move and transform the data? How fresh does the data have to be? (i.e. what is the User's expectation weighted against the network overhead of 'shipping' the data.) How do you schedule that move and transform? Management Overview: Tax law (in the US, I believe you are in the US) will require you to keep records going back at least 5 years. Therefore, the old system needs to be available. Since it will have to be up and intact, you see a major cost and performance savings in using that already paid for hardware and already developed software to act as a data warehouse. If they want to move those reports in the future, they can do it in a controlled manner, without having a loss of productivity or information. Not using the older system as a data warehouse will apply pressure to complete these functions now, adding cost and delaying the needed flow of information. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Mark Johnson wrote: This sounds very tempting, using MV as a data warehouse to a non-MV (or MV) primary application. Does anyone else have any insight on how this flies, management-wise or technically. I like it as all of the original reports are already written and tested and it keeps the customer a MV customer. Thanks Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Conversions
Thanks to all who have provide some good ideas. The conversion has occurred and is in the growing pains. Still a mistmatch but there's no going back. Perhaps I'll take this approach to learn Crystal Reports or MS Access reports. There are many previous reports and downloads that can't possibly come from these wizard oriented facilities and I will have to re-create them using their tools. One question. Many of the MV reports that I've created were consolidations of multiple sales/customer/product files into concise reports. They enlist databasic to create a temp file and populate it with the report-related sub-categories that don't consolidate easily in MVQuery. Thus the temp file is then query-able. I've been told that Crystal Reports doesn't allow for the creation of temp tables while Access can. Is this true and should I develop their replacement reports in Access. One strange thought occurred to me that may not fly. Export all the sales/customer/product data back to the MV system and use the existing reports. At least they're already tested finished. Thanks again. - Original Message - From: Dawn M. Wolthuis [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Saturday, April 03, 2004 9:50 AM Subject: RE: Conversions Mark -- I don't have experience with Great Plains, but can definitely sympathize with your situation. I have been on both the technical and management side of such conversions. Given that it sounds like the decision has been made, money has been spent, and work has been done, you could tackle it by coming through with a this is how we COULD accomplish what is desired set of chats and formal meetings. --Document (if it isn't already) precisely what the goals are for the implementation of the new software so that it is clear what needs to be accomplished from the perspective of Bob the owner. Include goals of what we don't want to impact and not just what we do want to change (for example, is a negative impact on profitability acceptable for 1 year, 2 years?) --Collect all issues/concerns that those in the trenches have related to this project; back these up with metrics/facts where you can --Ask this same trenches group how they think these obstacles can be removed or mitigated --Discuss the issues and possible solutions with mid/upper management and request their brainstorming as well on how to mitigate the concerns --Interview other Great Plains users and ask them how they addressed similar issues --Prepare a report (put in writing in some format, perhaps ppt) that has the angle of how we can accomplish this and does not have an underlying tone to indicate that you disagree with the decision to move forward with this software. The report can still indicate that there are costs to the conversion and perhaps even that there were unanticipated costs that were found once those who work with the software became familiar with the software --Work with all parties to choose the approaches for handling the obstacles in the path of a successful conversion and then implement those. Of course, it is never as easy as following bullet points. I would also suggest having a good inventory of those with whom you have a good working relationship and build on those relationships to help the project run smoothly to completion. Best wishes. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 02, 2004 10:05 PM To: U2 Users Discussion List Subject: Conversions Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a traditional Order Entry system. I can't seem to convey that difference as management (read: those who don't use the computer) like the GUI and all of the nice links and screens. The worker bees are in a turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and forth as well as the absense of many functions that were present under the MV app. Their productivity has fallen 75% as it takes 4x longer to enter an order. There are no sales tax lookups, no product or customer lookups. You clearly cannot scroll through 35,000 line items. There's no easy alternate shipping addresses and the original reports leave a lot to be desired. The accounting package is appealing but a company doesn't exist just for the accounting dept. Not to mention all the hamburger-helper features i've installed over the last 6.5 years. I also have to fabricate custom reports with Crystal Reports and/or Access as there are many fields of data that should be there like customer back orders, sample customers, customer
Conversions
Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a traditional Order Entry system. I can't seem to convey that difference as management (read: those who don't use the computer) like the GUI and all of the nice links and screens. The worker bees are in a turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and forth as well as the absense of many functions that were present under the MV app. Their productivity has fallen 75% as it takes 4x longer to enter an order. There are no sales tax lookups, no product or customer lookups. You clearly cannot scroll through 35,000 line items. There's no easy alternate shipping addresses and the original reports leave a lot to be desired. The accounting package is appealing but a company doesn't exist just for the accounting dept. Not to mention all the hamburger-helper features i've installed over the last 6.5 years. I also have to fabricate custom reports with Crystal Reports and/or Access as there are many fields of data that should be there like customer back orders, sample customers, customer categories and a whole truckload of sales reporting fields that simply don't exist. Am I wrong in concluding that Great Plains is just a glorified shopping cart application. Has anyone else experienced this kind of mis-match, especially with great plains. At least i could inform the users that others have these growing pains. There doesn't seem to be a light at the end of the tunnel for them. thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks. You could provide your desired browser in the first parameter and the URL in the second. Just because a small fraction doesn't use IEXPLORE doesn't mean that 99.9 percent don't either. Everyone can figure this out for themselves. - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 4:46 AM Subject: RE: How to launch remote browser from UniVerse server? Except that it assumes that IE is the default browser. And at home, where my firewall is configured to BLOCK IE, it would probably get you nowhere. I'm not sure of the syntax, but something like CALL WIN.PCRUN(URL) should fire up the url in the default browser. There were reports on u2-users a couple of weeks back that this sort of thing (executing a document) does work fine. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 04:53 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? If running Wintegrate this databasic command works: CALL WIN.PCRUN(IEXPLORE.EXE, URL) where URL could be any web address. I use it often to retrieve shipping from UPS.com or hooking map sites to dispatching screens. my 1 cent. can't help you on topic 2 unless you post the report as HTML to a PC file and have the URL be the file reference. In fact, here's a sub to hook to any cust maint. 001 SUBROUTINE MAP01(ADDR, ZIP) 002 *** 003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL 004 * MAJ 121002 005 *** 006 CONVERT TO + IN ADDR 007 CONVERT TO + IN ZIP 008 PROG=C:\Program Files\Internet Explorer\IEXPLORE.EXE 009 URL=http://maps.yahoo.com/py/maps.py?BFCat=Pyt=TmapnewFL=Use+Address +Belowaddr=:ADDR:csz=:ZIP:Country=usGet%A0Map=Get+Map 010 CALL WIN.PCRUN(PROG, URL) 011 RETURN 012 END I see that you are in AU so adjust the URL in this example for the appropriate country. I just go to the yahoo map page with an address and cut/paste that url into MV and fixup. Happy April 1. It's still yesterday here. - Original Message - From: LeRoi Keiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:39 PM Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The lists are closing
Perhaps if IBM or whomever is sponsoring the U2UG.org site is listening to the feedback of the current members of this list that they will respond in a 'customer-oriented' kinda way. That's why it's called SOFTware. It can change to meet the needs of its customers. I agree with the reduction of efficiency that the new method will cause. Hopefully IBM can cause a change to accomodate the high level of service the oliver list provided. my 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 5:18 AM Subject: RE: The lists are closing Listen, Will the blind, deaf and possibly dumb Johnson Are you hearing nothing? There are those of us who don't live in the land of the mighty dollar. We have to pay for our traffic, we have employment contracts that forbid us from internet access during the day, yet we still need access to U2 info. What do _you_ suggest we do? I've subscribed to your glorious forum, I get wee posties saying there are people talking about juicy thangs, but I cannot get to see these. What do _you_ suggest I do? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 29 March 2004 09:03 To: U2 Users Discussion List Subject: Re: The lists are closing 1) We DO want to leave the archives at indexinfocus. 2) We DONT want to replicate the archives onto u2ug 3) We DONT want the lists to continue Go to the web site, and enter each forum you are interested in and click on SUBSCRIBE this will make all responses come to your email box just as they do now. You can register, but if you dont SUBSCRIBE you wont be seeing nothing Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: OKI Code 39 BarCode
One could check www.okidata.com to see if there's any support for manual printer driver stuff like bar codes. I use www.hp.com to get beaucoups of HP PCL stuff. my 1 cent. - Original Message - From: Ray Buchner [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Monday, March 29, 2004 9:42 AM Subject: OKI Code 39 BarCode I'm have little documentation for my OKI's and am trying to print a Code 39 Bar Code on my pick tickets that contains the pick ticket number. That is the ID in the below example. What I have is: ESC DEL B 10 :ID Is this correct? It does not seem to be functioning. -Ray -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The lists are closing
Thanks Clif for providing the forum for the years. My only concern is that while it has been great for UV/UD questions, I have also received good advice about D3 and even hooked up with someone regarding an old copy of AP-Pro. Thus, would/could there be an 'all other MV' forum such that I could have my cake and eat it too. Not for nothing, but I did enjoy the diversity of the topics, UV/UD and others in my single email inbox. Even though I wasn't looking for any specific topic, just scanning the various topics and responses was useful. thanks. Mark Johnson - Original Message - From: Moderator [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, March 27, 2004 3:14 AM Subject: The lists are closing Dear Friends: After 10+ years of either hosting or supporting the info-prime, info-unidata, info-vmark, info-informix, and u2-users etc lists, I have decided to shut down the list server. u2-users and u2-community will cease to exist as of 1 April 2004. IBM is officially supporting the efforts of the new U2UG.org group. (Yes. I am a member of the establishing Board of that group. So this is not a coup or Sour Grapes!) If you check out the forums that have been set up, I think you will will see that they cover everything anyone has asked for over the years in this group. I *really* want to encourage ALL of you to come over the the www.u2ug.org site and support this effort. This is *exactly* what many of you on this list have wanted over the years. If Not Now, When? Almost ten years on my Watch. How many years before that on Mike O'Rear's Watch? In the Net World, this has been a Hell of a good run. (I just couldn't resist tripping the Net Nanny filters one last time very evil grin) I'll see all of you on the other media, ok? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: U2 file articles in International Spectrum
Is OHM a pretty big player in the application arena? Are they today's Eclipse? I keep seeing their job postings. Thanks. - Original Message - From: Results [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Sunday, March 21, 2004 11:18 PM Subject: Re: U2 file articles in International Spectrum Ross, L-O-quint, as always. The show was 200-ish people in a nice sized venue with 75 or so classes on everything from products (including VISAGE and Zeus), technology (PDA programming, OO programing, GUI overview), technique (AIX/UniVerse Pitfalls, Help Desk Survival), and more. The floor had a wide range of vertical and database vendors, supplemented by booths for Database Trends, Spectrum Magazine, horizontals like OHM, and the Spectrum Deli (I kid you not). It was three and one half days of Revelation, Reality, U2, UniVision, D3, jBASE, and more. It marked the first Spectrum (that I know of) where Microsoft bought breakfast and ran special seminars. - Charles Hey, I forgot to take a bribe before I spilled my guts Barouch Ross Ferris wrote: Ahhh, what do I want to know and the answer given by all good users is if I knew what I didn't know then I wouldn't have to ask, but I don't know WHAT I don't know, so I don't know ! (or sumfin like dat) Ross Ferris Stamina Software Visage an Evolution in Software Development -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: LOCATE Command - Help :(
This is a similar issue with the LOCATE and understanding what level it's trying to locate in. For example, let's say you just read in a REC that has attributes, values and sub values. If one of the attributes may contain the value FRED then the reference for REC would be: LOCATE FRED IN REC SETTING POS... and POS would be the attribute FRED was in. Notice REC is alone without any . If attribute 5 could have a whole value of TOM, then the reference would be: LOCATE TOM IN REC5 SETTING POS. and POS would be the value TOM was in. If a rare circumstance has BILL in a value in REC7,10, then it's LOCATE BILL IN REC7,10 SETTING POS and POS would be the subvalue BILL was in. Basically it's one level up. If you READV A5 and are LOCATING for a simple multi-value of SUE, then you use LOCATE SUE IN A51 SETTING POS not LOCATE SUE IN A5 SETTING POS Reason: The LOCATE doesn't know that A5 was the result of a READV. It very well could be the start of something attributed later but now just has a lot of multi-values in attribute 1. my 3 cents. - Original Message - From: Kate [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:42 PM Subject: LOCATE Command - Help :( Hi! I am trying to accomplish the following 1) Build a header for all possible dates for a person with certain data in it. e.g. one person might have 3 dates where they had activity but another person might have 5 dates with activity, but I want the header to have all possible dates with activity. So the Header Date variable contains all possible dates. And that prints fine. LOCATE V.DATES IN X.DATE.LIST1,1 BY AR SETTING LOC ELSE INS V.DATES BEFORE X.DATE.LIST1,LOC END But then for each person, I want to have the values print under the correct date headings. And it changes for each page. 2) For each record: a) obtain the # of dates and print the values to print under the correct dates for each person LOCATE X.AB.DATE IN X.DATE.LIST1,1 BY AR SETTING POS THEN IF VALUE = 'B' THEN X.AB.PRINT1,POS = TRIM(X.AB.TYPE) END END Then I remove the @VM's and print X.AB.PRINT. It prints the values but all in one sequence. Not in the proper position. Can anyone tell me what I am doing wrong? Thanks for any help you can pass my way. Kate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Alpha-Micro to D3
Perhaps I've been buffered by the wrath of RD as i don't work with them directly. I work with a company called Zumasys and they've been incredibly helpful with the migrations and new systems that I've installed. I did go to bat with RD directly discussing a licensing issue and was able to convince them of my perspective. It was regarding the 50% discount on D3 for currently supported native systems. There was a loophole that i identified and they accomodated me. They do play hardball on virtually everything else. I have existing UV and UD clients, all of which had their environments converted prior to my involvement. Thus, I've never experienced the birthing pains of converting from native to U2. Observing all the conversations on this forum regarding the release levels, implementations, connectivity etc, and that I am an outside consultant and not an employee, a delivered virgin D3 system on W2K is about as clean an environment one could expect to start from. Pop in the last file-save, do the restore and compile. In fact, converting from AP-pro doesn't even need the compiling. I observe all the unix and NT commands being offered and they're out of my league. Plus, my clients, being native to begin with, aren't aching for the ODBC, triggers, sockets, IIS and other magic features of today. They just want to continue with their green screen apps. Thanks. Someone earlier posted a comparison between Pick and Microsoft. It stated that MS is happy with 10% paying licenses out of 100,000,000 while Pick wanted 100% paying licenses out of 10,000. - Original Message - From: Ron White [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:22 AM Subject: Re: Alpha-Micro to D3 - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 12:39 PM Subject: Alpha-Micro to D3 Dear All: One of my clients has a 40 user Alpha Micro native system that's in need of a migration. I want to migrate to D3/W2K. I've done a few and am comfortable supporting it remotely as a consultant instead of as an employee. While I welcome the possibility of going to 'nix U2 or NT U2, I want to focus on D3/W2K. Has anyone had any experience converting from Alpha Micro to D3 or UD/UV and are there any pitfalls regarding incompatible source code. I can expect some slight differences in syntax but I'm looking to see if there's a major roadblock. I don't suspect anything beyond PQ proc but IIRC an earlier conversion from GA to AP-Pro brought with it some missing commands like SWAP and MAX. Thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- D3 does have the SWAP statement, but like several other statements you need to but a $OPTIONS EXT compiler directive in your program or it will not compile. My documentation does not mention a MAX statement. I wish you luck dealing with Raining Data. At my earliest convenience I will kick D3 and Raining Data out the back door and run everything on UniVerse. RD has raised their maintenance to 90 USD per seat and have instituted a 50% charge to get a major release (release 8.0 is due out this year). They have mostly stopped enhancing the product and to get anything fixed or added to the product you must submit a business requirements statement to them convincing them that it is in their business interest to provide the fix or function. That doesn't sound like a company that is very interested in keeping D3 around for the long haul. YMMV Ron White --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Alpha-Micro to D3
I don't know. It appears to be either a 486 or P1 vintage. Early 90's perhaps. thanks. - Original Message - From: Dave S [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 12:35 PM Subject: Re: Alpha-Micro to D3 What year model is that Alpha-Micro system ? Ron White [EMAIL PROTECTED] wrote: - Original Message - From: Mark Johnson To: Sent: Wednesday, March 17, 2004 12:39 PM Subject: Alpha-Micro to D3 Dear All: One of my clients has a 40 user Alpha Micro native system that's in need of a migration. I want to migrate to D3/W2K. I've done a few and am comfortable supporting it remotely as a consultant instead of as an employee. While I welcome the possibility of going to 'nix U2 or NT U2, I want to focus on D3/W2K. Has anyone had any experience converting from Alpha Micro to D3 or UD/UV and are there any pitfalls regarding incompatible source code. I can expect some slight differences in syntax but I'm looking to see if there's a major roadblock. I don't suspect anything beyond PQ proc but IIRC an earlier conversion from GA to AP-Pro brought with it some missing commands like SWAP and MAX. Thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- D3 does have the SWAP statement, but like several other statements you need to but a $OPTIONS EXT compiler directive in your program or it will not compile. My documentation does not mention a MAX statement. I wish you luck dealing with Raining Data. At my earliest convenience I will kick D3 and Raining Data out the back door and run everything on UniVerse. RD has raised their maintenance to 90 USD per seat and have instituted a 50% charge to get a major release (release 8.0 is due out this year). They have mostly stopped enhancing the product and to get anything fixed or added to the product you must submit a business requirements statement to them convincing them that it is in their business interest to provide the fix or function. That doesn't sound like a company that is very interested in keeping D3 around for the long haul. YMMV Ron White --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 Automatic Faxing
Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Looking for associated multi-value algorithm...
Perhaps the most glaring problem here is the level of the LOCATE. Since SPECIAL.PARTS is a value and thus possibly multi-valued, the ,STARTPOS indicator suggests to the LOCATE to look at the first subvalue of the value'd. Somehow, especially since STARTPOS isn't previously defined, it become zero and 1,0 is the same as 1 which may accidentally satisfiy the LOCATE. Remove the commaSTARTPOS from the in the LOCATE and the STARTPOS=SPECIAL+1 as they don't contribute anything. Also, this looks like a FIFO/LIFO algorithm. What are the failures if the qtys don't match. The LOCATE should eliminate the FOR...NEXT loop unless you have the PART.NBR in the 12 more than once. In any case, the FOR...NEXT is is useless. If the PART.NBR is in 12 more than once, use FOR...NEXT and do a simple equals test on 12. I don't believe that LOCATE can find occurrences of PART.NBR after the first one it finds. At least using numbers inside the . Perhaps LOCATE X in Y1,STARTPOS on the outside. I don't use it. FInally, if it's any contribution (and it's my purely non-technical opinion). Remove all the extraneous uses of the prefix SPECIAL. That makes it hard to read as all the variables start with SPECIAL and it's hard to identify their purpose quickly. I'm sure I'll get flamed for this, but it does make it more readable. PARTS=SPECIAL.REC12 C.PARTS=DCOUNT(PARTS,VM) QTYS=SPECIAL.REC14 ; PRICES=SPECIAL.REC16 QTEMP=0 FOR I=1 TO C.PARTS IF PARTS1,I=PART.NBR THEN QTY=QTYS1,I IF QTY QTY.REQUESTED AND QTY QTEMP THEN DATA.OUT=OCONV(PRICES1,I,MDP)R#12 QTEMP=QTY END END NEXT I my 2 cents. I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
I have a client that needs roughly 250,000 items removed monthly from a file containing 5-6 million records. Since there is no need to use the keys (records) for any other purpose except for deleting because they are old, a standard data/basic SELECT statement is just about as fast as you can get. It isn't encumbered by the number of selected keys as it's not retaining them for any purpose. This simple program looks like this: OPEN MASTER TO F.MASTER ELSE STOP OPEN REFERENCE TO F.REFERENCE ELSE STOP DEL.DTE=ICONV(01/02/2003,D) SELECT F.MASTER 10 READNEXT ID ELSE STOP READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 IF DTE GT DEL.DATE THEN GOTO 10 DELETE F.MASTER, ID DELETE F.REFERENCE, ID GOTO 10 END Of course if there's additional use for the deleted keys, then use another approach. my 1 cent. - Original Message - From: ashish ratna [EMAIL PROTECTED] To: Anthony Youngman [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 15, 2004 7:55 AM Subject: RE: Help Needed regarding performance improvement of delete query Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be WITH IDESC EQ whatever-number-you-want. That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where whatever-number goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with whatever-number as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the hit on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds
Terminology
Dear all: I'm not familiar with the following as referred to by MV: SLA and OLA metrics. Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse on NT vs *nix - Higher User Counts with W2003?
Sidebar on sizing. One client of mine had 240 users on a 75 mhz 486 R90 system. Around 30 printers with the rest as users both as local and multiplexed. Slow? Sort of. Working? Yes. MTBF? Incredibly infrequent given the user count. The system was written in ScreenGen which was ABS heavy. Also the application was heavily app and system indexed. Converted to D3/AIX with beaucoups of Digi-Boards. Flamethrower. my 1 cent. - Original Message - From: Steven M Wagner [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 12:28 AM Subject: RE: UniVerse on NT vs *nix - Higher User Counts with W2003? Stephen M. O'Neal, CDP said that ...currently, most W2000 installations max out at about 300 users. I wonder how often sites that plan for higher user counts go with a *nix solution to start with? For what it is worth, I had 200 UV9.6.2.8 users on a WinNT 4.0 box. And this was with a Compaq Proliant 5500 with 512MB of RAM and two 200Mhz CPUs, Xeons I believe. And no complaints about speed. snip prior messages -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Would anyone be interested in UV based bible software?
Aren't there bible applications already written. I don't know of them but i've heard of them as they can quickly cross reference passages and named references. - Original Message - From: Glenn W. Paschal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:03 PM Subject: [UV] Would anyone be interested in UV based bible software? I am working on a bible application for my personal use. If anyone else would be interested in this type application, let me know. I would welcome the inputs and ideas on what it should be capable of. Thanks, Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse on NT vs *nix
My 2 cents: Are the persons applying the pressure MS preferred for its own sake or is it the result of an actual comparison of AIX to W2003. A client of mine bought into an MS app because of the implied greatness of MS only to have a huge disappointment. mark - Original Message - From: Sara Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 08, 2004 6:48 PM Subject: UniVerse on NT vs *nix I am under considerable pressure to convert from UniVerse on AIX to UniVerse on Windows 2003. We have licenses for 320 users and do get up to this number at times although 300 is more normal. We run up to 30 phantom processes during the day above this interactive user count. At times these would be running in parallel, processing sections of our customer base. This is a daily event during the afternoon whilst other users are doing normal work. Currently we run UniVerse 10.0.11 on an IBM p660 with 4 cpus and 7Gb ram. We also run Oracle and Vantive on this same box which is why the ram is so high. We transfer data between UniVerse and Oracle real time using BCI OpenLink. The reverse is an in-house Oracle Pipes development which is gradually being replaced by UniObjects for Java. I anticipate we would need to run these applications on separate boxes if under Windows 2003. Our DBAs, both UniVerse and Oracle, are reluctant to go down this path as they believe they will not have the same ability to monitor their systems. I would appreciate comments, good and bad, from anyone with experience of this number of users in an Windows environment. Email me off-line if this seems appropriate. Thanks in anticipation Sara Burns Sara Burns (SEB) Project Leader (Vantive) Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pick AP-Pro Discs
I'll restate the question: snip Does anyone have the box, manuals and installation diskettes for AP-Pro for the Pentium I system that they could give/loan/sell? I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my own AP-Pro yet in 2 months they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and its cost would kill the deal. I want to get my foot in the door and as they grow, we can convert later. snip Thanks for all that replied with offers of alternate pick environments but given my time constraints I don't want to venture into something new at this time. I am comfortable with AP-Pro, installation support-wise. I have many clients on a variety of MV platforms and AP-Pro is the most appropriate for this situation. I know how to install, remove, create accounts etc on it. Oddly enough, i've not been in on the decision for which MV that my other clients have. I just come in after the original installers take their money run with no application support. This client has zero Pick background and is running an app on dBase 3. AP-Pro would be nirvana for them. Thanks again. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pick AP-Pro Discs
Thanks. I will try it. - Original Message - From: Brian Leach [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, March 05, 2004 9:01 AM Subject: RE: Pick AP-Pro Discs Mark, I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian I'll restate the question: snip Does anyone have the box, manuals and installation diskettes for AP-Pro for the Pentium I system that they could give/loan/sell? This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pick AP-Pro Discs
Is that a URL or how do i get into it. thanks I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Variable never assigned a value warning
Not to mention the infidel CLEAR statement that does the same thing, hides errors. I believe the practice of variable assignment at the top is a practice brought over from other languages where all variables apparently need to be defined up front with DIM statements and variable types. I support some QB VB code and don't think twice about introducing the variable mj late in the program for a local test and not DIMming it at the front. Come to think of it, those systems tend to have an implied CLEAR as from out of nowhere, you could have PRINT A and the unassigned value of A would be zero (it's a numeric variable). You could also PRINT A$ and get nothing wrong. Hell, you even get the first 9 or 10 array elements without even using a DIM to dimension. PRINT A$(6) would yield null as well without being previously defined. Perhaps the early defining of variables is a discipline that was taught but not really required. I shiver when i see the CLEAR statement when the program needs my assistance. I relucantly comment it out while reviewing to see if that's the cause of an unexpected value somewhere. More often than not, after compiling and when run the first time with no CLEAR, I get distracted by some other errmsgs unrelated to the problem at hand. I relegate that command to the lazy category. I've never used it in all my years of MV. my 2 cents. Incidentally, I find the worryingly common practice of setting all variables to zero / null at the top of a program very annoying as it hides the very useful unassigned variable trap, leaving you thinking your program works when actually it doesn't. Martin Phillips Ladybridge Systems Yes, this practice HIDES real errors. I too see it a lot, and I think it is absolutely disgusting. Maybe the practice originated with programmers who were used to working in languages where they had to declare variables var types at the top of their program. They just felt kinda naked without saying, I=0;A='';[EMAIL PROTECTED], at the top of their basic code. A poor reason. Don't do it. Be aware that the *occasional* such message may hint at a *multitude* of unreported error incidents. Especially when the error is deep inside an important loops. Let me illustrate by expanding Martin's example: LOOP GOSUB ASSIGN.A BEGIN CASE CASE A = 1; B = 'Apple' CASE A = 2; B = 'Orange' CASE A = 3; B = 'Banana' END CASE DISPLAY B REPEAT You will get an unassigned error message only if A just happens to not be 1,2,or 3 on the very FIRST pass through the loop. Subsequent passes where that occurs would use the value assigned to B on the previous iteration. UV will be happy to do so. Initializing B at the top of the program, above the loop, would eliminate those occasional error message but not eliminate the buggy code or a fundamental logic flaw. Try to initialize assign variables exactly where they apply. Then watch for error messages that point out your flaws, and be grateful for them. Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users - Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to start windows programs
I don't mean to over illustrate WIN.PCRUN but I must endorse it. I've got clients using it to FTP to remote sites for order downloads, delete remote data, instantiate text file transfers, link UPS tracking numbers to UPS.com and fedex. 2 of my clients maintain fleets of 20-30 dispatchable trucks and when the dispatcher has the customer on the screen, they type 'MAP' and mapquest.com (sic) shows the map of the customer to help the driver on the walkie-talkie. Another client has an interactive voice response IVR order entry system that saves orders in a shared directory. WIN.PCRUN runs bat files to get the new filenames, pick does the conversion and error log and WIN.PCRUN then deletes the successful orders from the original folder and copies the not-so-good orders to a reject folder. It polls every 5 minutes during the day, sleeps from 5pm to 730 am and refreshes the IVR data tables with fresh customers and products at 1:30 am. If I could run a macro from within excel with WIN.PCRUN i would be home free as I could export CSV's and format them from within excel instead of the suggested methods from the outside. One final use is to incorporate BLAT to kick off single or mass emails from within Pick (native or network). I even have the end of month process email to the owner at home of one of my clients that the process is complete so he can VPN in and print the various reports. Pretty cool. my 1 cent - Original Message - From: Stuart Boydell [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 6:49 PM Subject: RE: How to start windows programs Is there a way of starting windowsprograms on the users PC from a Unibasic program or do I need Wintergrate or some other tool to do that? You need a proficient terminal emulator. Wintegrate could be one option of many. I would like to send a invoice number away to an invoice archive on MS sql-server to get a pdf copy of the invoice in an Internet Exploreror acrobat reader window. The simplest method to open a pdf is to write the pdf to a server then send the URI of the pdf to the emulator via an escape sequence. For example, to open a pdf in your browser using ftp using Netterm: CRT CHAR(27):'[]ftp://user:[EMAIL PROTECTED]/invoice12345.pdf':CHAR(27):'[0*' My personal preference for emulators is Netterm. http://securenetterm.com. It supports the ability to open URIs, kick off programs on the client as well as more sophisticated functions. It's free to evaluate (with no expiry time) and if you decide you want to buy it it's about US$30 for 1 and gets cheaper by the dozen. Regards, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Ever wondered how something works...
I don't know exactly but LD may be short for LISTDICTS and since you're not providing a filename, it may bomb, taking the active list with it. Sometimes on UD i wish there were an easier way to clear an active list instead of CLEARSELECT. I used TIME on all native systems but UD is more durable and gives you more chances to either get the MVQuery statement correct or actually bail with clearselect. my 1 cent. - Original Message - From: Barry Brevik [EMAIL PROTECTED] To: U2 list (E-mail) [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 9:34 PM Subject: [UV] Ever wondered how something works... One day, I stumbled across an interesting behavior; at TCL, if I type 'L', it results in my current SELECT list being cleared. You get an error message, but it does not seem to hurt anything. This is great, because I hate typing in CLEARSELECT. But ever since, I've been wondering what it's really doing. Turns out that 'L' is one of only two similar VOC entries, the other being 'LD'. It looks like this: 0001: V 0002: L 0003: PR The error message you get reads: Unable to create new process. Will try again. Create Process failed (2). This is on NT. IIRC, on unix the message is different. Anybody know what this is doing, or if it is safe? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Pick AP-Pro Discs
Dear All: I would like to acquire or purchase the complete box, manual and all diskettes for an older Pick AP-Pro system or someone's retired AP-Pro system (133-166 P1 preferably). I only need 3-5 users. I think the minimum is 3. I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my own AP-Pro yet in 2 months they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and its cost would kill the deal. I want to get my foot in the door and as they grow, we can convert later. Thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pick AP-Pro Discs
I had considered this option as well as the MV-Lite environments already out there. This is really a low-key client (private club membership) that i am making a good deal on developing the app from scratch. Once they get their original system duplicated (dbase) to Pick, I can enhance their application with many desired features and they will have a greater appreciation for what the system can do for them. Perhaps, they can even grow. As it is, I'm searching my office for the red-box set of AP-Pro install discs from a converted client to install on an older P1-133 box. I'll steal an Arnet board from one of my other AP boxes (I don't need 24 users anymore) and 'build' them a good starting system. That's why I also solicited any older AP-Pro systems. thanks. - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Sunday, February 29, 2004 2:10 PM Subject: RE: Pick AP-Pro Discs If you had more of these deals you could setup a hosted environment (your choice of DBMS including U2 and D3). You use your own licenses on that system and do your development there. End-users can SSH into their own production accounts and pay you some monthly rate for using your app and resources until they're ready to move up. Voila', your own ASP. The initial cost of getting a licensed DBMS and ports may be prohibitive, but the advantage is that the system still belongs to you when the end-user has moved on to their own environment or even to a hosted solution of their own. If you already have a licensed environment then it should cost nothing to move the license to a hosted box, so the cost of getting this going is trivial. Note that (to my knowledge) it violates license agreements to run live end-users on development software provided by any of the MV DBMS vendors. You might be able to get a free temporary license to let users run for a couple months on a try before they buy basis. If you can manage that then they can host a DBMS locally and still pay you for your app. Couple ways to cut this cookie... Let me know if any of this is of interest. Tony Nebula RD [EMAIL PROTECTED] -Original Message- I would like to acquire... an older Pick AP-Pro system... I only need 3-5 users. I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my own AP-Pro yet in 2 months they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and its cost would kill the deal. I want to get my foot in the door and as they grow, we can convert later. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: WinteGrate
Are we agreeing that WIN.PCRUN would be the best way to 'launch' pictures if they're stored on a shared Windows drive. Yo No Habla Samba. mark - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:24 AM Subject: Re: WinteGrate In a message dated 2/21/2004 10:24:10 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I dont' understand the phrase 'UNIVERSE wants to open'. If the pictures are stored on the 'nix box, then i can't help you. If they're somewhere on a windows filespace available to that user, then use WIN.PCRUN. Mark I'm assuming this is a new application and the user has the freedom to put the pictures in the most convenient location. I was saying that putting the images in a shared Windows drive would eliminate the need to have the user also have to administer SAMBA. Right? Will Johnson Fast Forward -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] paragraph labels
What does the 'also documented' sentence mean. How would a non-existant label appear before the GO in a paragraph. Regarding paragraphs: Do they behave like procs whereby you can accidentally have the same label twice and the proc goes to the first occurrence (starting at the beginning). This is a downside of procs due to not needing to be compiled. my 1 cent. - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Sunday, February 22, 2004 5:03 AM Subject: RE: [UV] paragraph labels It's documented behaviour that GO to a label that does not exist in a paragraph will cause the process to exit from the paragraph. From memory it's in the UniVerse System Description somewhere. There's no default label. It's also documented that the same behaviour will occur if you attempt to GO to a label that is earlier in the paragraph than the GO command. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [OT] Pr1me Hardware question
My guess is that it is a Serial Port Controller Board. I used to know what all the Royale/Reality/Sequel boards were. NIC's surely saves a lot of space now. my 1 cent. P.S. Howja get a gig like that. Is it the History Channel aspect of the CS program. I and i'm sure others could talk hours on the hardware issues we had to deal with. My favorite exercise was having to put my finger against the 1/2 inch tapehead of the open reel-to-reel Microdatas when reading tapes from one system to another. The tape would stream back and forth trying to catch its parity until just enough pressure by my fingers would cause those 8 tracks (not to be confused with 8-tracks) to line up. Jurrasic Pick at its best. Then along came Cipher drives and i put my fingers to better use. My oldest piece of nostalgia is a 1972 Microdata manual pre-Pick. It was a process controller looking for something to do. - Original Message - From: Dawn M. Wolthuis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 22, 2004 10:00 PM Subject: [OT] Pr1me Hardware question I'm doing a talk tomorrow to college CS majors (name of talk is: IT is How it Seams -- at least I'm able to entertain myself with the double double meaning) I thought I'd bring in some of the odds and ends I've acquired over the years and one is a board from a Pr1me computer I worked on. It was gifted to me when the machine was retired. However, I'm a s/w kinda guy and I don't know a cpu board from a memory board from anything else. I figured this was the best place to ask about prime hardware, but sorry for being a little off-topic. It is an 18 inch-ish square green board with black chips and few white ones that say Bechman on them. The black ones are at least three different sizes. Along one side it has stickers that say LINES 0-3 ... LINES 12-15. That seems like a big clue, but I figured someone here would know what such a board might have been called. Thanks in advance. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [OT] Looking for U2 owners in northern suburbs PA, USA
go to pickjobs.com. there's one in wilkesbarre. - Original Message - From: Rich Sias [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 11:13 AM Subject: [OT] Looking for U2 owners in northern suburbs PA, USA Well, I got to start my searching for gainful employment. I have used 2.5 weeks just working on refining the resume, it is near done soon and I need to gather potential sites near where I live first. Contact me directly with places (company names) and other details if known and date of last contact if old knowledge. If you had a contact name and or phone number that would be even nicer. Can be former employers, current ones, customers, buyers or other contacts that you are aware they own a U2 system and just might need a DBA or such. Rich Sias -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 /NTand RESIZE function not working
lemme get this straight. If a 'live' resize of a file in D3 requires no users using that file, how is it considered live? my 1 cent. - Original Message - From: Lee Bacall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 15, 2004 8:00 AM Subject: Re: D3 /NTand RESIZE function not working On D3, changing attribute 13 to set the new file size will ONLY will have an effect after a RESTORE of the system from tape. I don't remember if it will change the file size on a SEL-RESTORE. You can do a live resize of the file in D3 (increasing the size only) as: RESIZE-FILE Yourfile NewModulo Be sure to get your users off the system or disable access to the file being resized or you may encounter some problems. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575, emergency# 954-937-8989 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:34 PM To: [EMAIL PROTECTED] Subject: D3 /NTand RESIZE function not working Version 7.3 service Pack 6 of D3 on NT Has anyone experienced the RESIZE not working after new file sizes have been updated into the file-stats record? It appears that it is complete yet the dict item is unchanged. -- Debster -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Hashing Algorithm
Is that one similiar to the 'only' one available to native systems, which many people have known for years? - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Saturday, February 14, 2004 5:06 PM Subject: Re: Hashing Algorithm It might be interesting if someone were to publish the Ardent hashing algorithms, then. ;) Not something I'm prepared to risk doing, however. - Original Message - From: [EMAIL PROTECTED] Date: Sat, 14 Feb 2004 10:45:45 EST To: [EMAIL PROTECTED] Subject: Re: Hashing Algorithm I have to say that in general IMHO a company cannot retroactively seize control of something that at one time was freely available. Something in the US about seizure without a warrant? Bill of rights or something? Will I'm not a lawyer, but I play one on the Internet Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SQL Server and Crystal Reports
I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
I'm all ears. What is this numeric variable. Thanks. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 2:34 PM Subject: Re: The result of VARIABLE[1,3] + 0 In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time, [EMAIL PROTECTED] writes: It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. No that's not so. There is a numeric variable (internally stored), in MV. It is not a string and only translated to a number when needed, rather it's a number. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
I don't understand. What is this numeric variable. I got the reply '42'. thanks. - Original Message - From: gerry simpson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 4:01 PM Subject: Re: The result of VARIABLE[1,3] + 0 42 - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 3:29 PM Subject: Re: The result of VARIABLE[1,3] + 0 I'm all ears. What is this numeric variable. Thanks. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 2:34 PM Subject: Re: The result of VARIABLE[1,3] + 0 In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time, [EMAIL PROTECTED] writes: It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. No that's not so. There is a numeric variable (internally stored), in MV. It is not a string and only translated to a number when needed, rather it's a number. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
UD has EDIT-LIST or EDIT.LIST. - Original Message - From: Susan Lynch [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 6:51 PM Subject: Re: InValid Characters Bill, Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST command (which UD does not have). Given that restriction, probably the easiest method would be to SELECT PS = [101393 BY-DSND @ID (assuming that @id is left-justified) If only 1 item selected, DELETE PS If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure that the one selected is the one with the unusual characters in the key. If yes, then repeat the two SELECTs and DELETE PS. If no, then your system is sorting unprintable characters differently than mine is, and you will have to play with the selection process in order to get the right record selected prior to deleting it. Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, February 06, 2004 5:49 PM Subject: InValid Characters When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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 matters. - Original Message - From: Dennis Bartlett To: 'U2 Users Discussion List' Sent: Wednesday, February 04, 2004 8:45 AM Subject: RE: UDT SELECT optimization I've always thought that a SELECT that reduces the results first then SORTS would be quicker, eg SELECT ORDERS WITH DATE = "01/01/04" BY TIME where WITH DATE = "01/01/04" is what reduces the results and BY TIMEis the selection criteria based on the logic that the reduced list would be quicker to sort... Dunno where I picked up this thought process, but I am from a Prime / R83background. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark JohnsonSent: 03 February 2004 02:34To: U2 Users Discussion ListSubject: Re: UDT SELECT optimization Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one or more of them involve translates. For example: SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" AND WITH PERIOD = "199910" would be faster as SELECT HUGE.ARCHIVE.FILE WITH PERIOD = "199910" then SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" assuming that CUST.ZIP is translated and the PERIOD is a local field. Note the SSELECT in the second statement as well. I've often wondered if, when using consecutive ANDs the filter processor skips the record if the first WITH is false. Why bother testing the second field if both are ANDed. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it byissuing the commands one after the other, the second may may complete quicker, simply because the file may be cached in memory. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck MongioviSent: 02 February 2004 16:16To: U2 Users Discussion ListSubject: UDT SELECT optimization Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -ChuckThis email was checked by MessageLabs SkyScan before entering Microgen.This email was checked on leaving Microgen for viruses, similarmalicious code and inappropriate content by MessageLabs SkyScan.DISCLAIMERThis email and any attachments are confidential and may also beprivileged.If you are not the named recipient, please notify the senderimmediately and do not disclose the contents to any otherperson, use it for any purpose, or store or copy the information.In the event of any technical difficulty with this email, pleasecontact the sender or [EMAIL PROTECTED]Microgen Information Management Solutionshttp://www.microgen.co.uk ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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 databasic Statement. Does anyone know of any other way to evoke ERRMSG text. I've often wondered. thanks. - Original Message - From: Glenn Herbert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 9:17 AM Subject: 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 #E. AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. Yep. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VARIABLE-1 = '' Inconsistent behaviour
At least with maintaining a variable you are in control. - Original Message - From: Marco Manyevere To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 2:00 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACEsays something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; *Maybe empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but thisinvolves maintaining a counter forthe dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: I think this is a "feature". Universe does NOT insert non-significant nulls. In other words your first two (A-1 = '') do not do anything! It is consistent in its' behaviour as you can count on it to do the above. It has done this as long as I remember. I found this out through bitter experience. Louis - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 12:55 PM Subject: VARIABLE-1 = '' Inconsistent behaviour Hi All, Consider the program: A = '' A-1 = '' A-1 = '' A-1 = 3 A-1 = '' A-1 = 4 PRINT A3 I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VARIABLE-1 = '' Inconsistent behaviour
I worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the second value in [] exceeds the length of A are there any surprising trailing characters? I've used A=A[2,10] (or some knowingly high number) with no consequences over the years. my 1 cent. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 2:09 AM Subject: RE: VARIABLE-1 = '' Inconsistent behaviour One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: I think this is a feature. Universe does NOT insert non-significant nulls. In other words your first two (A-1 = '') do not do anything! It is consistent in its' behaviour as you can count on it to do the above. It has done this as long as I remember. I found this out through bitter experience. Louis - Original Message - From: Marco mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 12:55 PM Subject: VARIABLE-1 = '' Inconsistent behaviour Hi All, Consider the program: A = '' A-1 = '' A-1 = '' A-1 = 3 A-1 = '' A-1 = 4 PRINT A3 I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. Regards, Marco _ BT Yahoo! Broadband - Free modem offer, sign http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk up online today and save £80 _ ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Recent issues
I take the blame for announcing that MV doesn't have typed variables (file handles and arrays excluded here). My contention is that we're not burdened by too many choices that may sometimes get in our way (integer vs long vs floating point etc) especially for numbers. There is a brain set, particularily with integers, that saving some precious byte or bit in memory is worth pursuing, or that FOR I%=1 TO 10 is any easier on the processor than FOR I=1 to 10 MV concludes a type (numeric or text) when it's needed and i believe this freeform, undisciplined approach has made us MV programmers that more productive instead of worrying about all that syntax. OPTION BASE 1 anyone? my 1 cent - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 4:39 AM Subject: Re: Recent issues Just to add my few cents worth to a couple of recent issues... X-1 = '' works exactly as it has been defined to work for the last 35 years! One of the things about not (originally) having the concept of an SQL style null item is that you cannot tell the difference between an empty list and a list with one null entry. It is trivial to program around this once you recognise the problem. X = '123' + '456' performs an arithmetic calculation. This is absolutely fundamental to how UV/Udt work. I have lost the original mail that started this thread but I recall it was being blamed on a particular release of UV. If this didn't work, nothing would work so it must be more subtle than that. Although we think of UV Basic as being a typeless language, it isn't. There are actually around a dozen data types inside the product. All operators look at the data they are working on and, where appropriate, transform it to the correct type. The addition operator (and all other arithmetic operators) will try to convert character string data to numeric form. If the conversion is successful, the addition takes place. If not, you get the non-numeric data where numeric required message. The entire product relies on this translation taking place. For example, if you ask a user to type in a number it will actually be stored as a character string. Each use of the data as a number will transform it. Whilst this is no problem if we only use the data infrequently, a loop that does the conversion hundreds of thousands of times will do the conversion each time: INPUT CT (user types 100) FOR I = 1 TO CT NEXT CT This will convert CT for every iteration of the loop. It gets worse if you use CT many times in the loop too. For this reason, programmers sometimes force a data conversion with the apparently pointless add zero statement: INPUT CT (user types 100) CT = CT + 0 FOR I = 1 TO CT NEXT CT The extra statement takes CT as a string, adds 0 to it forcing a conversion and stores it as a number. The loop then goes faster. I once worked on an application where getting the data types optimised in this way made the program go over 1 times faster! In my work I encounter many UV/Udt users and get to see many different applications. I find it amazing how little some programmers understand about the product they are using. The questions raised on this list are sometimes so simple that it makes me wonder if the users concerned have actually ever looked at the documentation or been on a training course. By way of a quick advert, my company (Ladybridge Systems) offer UV/Udt training in the UK and parts of Europe. IBM have courses that are delivered worldwide (by us in the UK). I know I have plugged it before but I strongly recommend the UniVerse Internals course for those who really want to get a deep understanding of how this system works. Sadly, there is no equivalent for Unidata. The programming courses are great fun and address many issues like the ones discussed above. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] VARIABLE-1 = and Basic Compile$OPTIONSEXTRA.DELIMwork consistently
I think that the amount of diverse replies on this topic indicates an inconsistency across platforms and that the use of a MV counter either derived or managed is clearly the best solution that a programmer can take to any MV environment, new or old. It would remove any suspicion to wonder if it's working or not. I've never been let down by a real counter. If you were managing an array in another form of Basic then you would have to use a counter. my 1 cent. - Original Message - From: gerry simpson To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 7:25 AM Subject: Re: [UV] VARIABLE-1 = "" and Basic Compile"$OPTIONSEXTRA.DELIM"work "consistently" this is not exactly correct while you are correct that the 3 statements result in 2 attributes, the 2nd state does indeed have aneffect A='abc' ;* A=abc , len(A)=3 A-1='' ;* A=abc:@FM , len(A)=4 A-1='def' ;* A=abc:@FM:def , len(A)=7 when EXTRA.DELIM is used the results are : A='abc' ;* A=abc , len(A)=3 A-1='' ;* A=abc:@FM , len(A)=4 A-1='def' ;* A=abc:@FM:@FM:def , len(A)=8 - Original Message - From: Louis Windsor To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 6:42 AM Subject: Re: [UV] VARIABLE-1 = "" and Basic Compile "$OPTIONSEXTRA.DELIM"work "consistently" Sorry for jumping in without checking my facts first. You are right the sequence A = 'abc' A-1 = '' A-1 = 'def' results in A having TWO attributes NOT three. The second statement has no effect. This is as it works on Windows XP Prof and the Personnel version of UniVerse. If my memory serves me this is also how it works on UV9.6 on Unix (HPUX). Again I think the statement A-1='' is always ineffective. UV without over- riding options etc will never insert a null at the end of a string variable. My experience is mainly with Pick flavour. Louis - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 5:34 PM Subject: Re: [UV] VARIABLE-1 = "" and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently" The same documentation goes on to say: In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string and the new element is appended to the end of the dynamic array, the end of a field, or the end of a value, a delimiter is appended to the dynamic array, field, or value. Use the -EXTRA.DELIM option of the $OPTIONS statement to make the REPLACE function work as it does in IDEAL, PICK, and REALITY flavor accounts. In my opinion this behaviour is still unexpectedand here is why I say so: If Information behaves the same as PICK as you say, then the behaviour is still contrary to documentation because in the example I gave below, a @FM was still appended even if the string to be added was empty: i.e. A = 'abc' A-1 = '' A-1 = 'def' will result in 3 fields. According to the REPLACEextract you quoted,A-1 = '' should not add a field mark regardless of whether A is empty or not for PICK flavour. Marco Marco,As some previous replies were saying, the behaviour you describe is normaland documented. The explanation for this is found in the "REPLACE" Basicfunction, which is the equivalent for the angle brackets notation at theleft of an assignment operator ("=") for dynamic arrays handling.For more information, please refer to the Basic documentation manual (File"BASIC.pdf" in the CDROM library)Here is an excerpt of the documentation :REPLACE functionSyntaxREPLACE (_expression_, field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_ [ ,field# [ ,value#] ] ; replacement)variable field# [ ,value# [ ,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and REALITY flavor accounts, if replacement is anempty string and an attempt is made to append the new element to the endof the dynamic ar ray, field, or value, the dynamic array, field, or valueis leftunchanged; additional delimiters are not appended. Use the EXTRA.DELIMoption of the $OPTIONS statement to make the REPLACE function appenda delimiter to the dynamic array, field, or value/...The fact is that "UniVerse" is mainly designed to reproduce the behaviourof legacy products in the "Pick" family. In this case, the implementationof the "INFORMATION" and "IDEAL" flavour followed the default behaviour in"Pick" native products.I hope this
Re: Re: [UD] Determining if list exists
Likewise if you're using new proc you may use the original ERRMSG file indicator as HSELECT FILE WHATEVER STON HSAVE-LIST LISTNAME P IF E = 401 GO somewhere as there were no items selected. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 9:02 AM Subject: Memo: Re: [UD] Determining if list exists Hi Chris,I believe there is the IF S or the IF #S construct that you can use in aproc to test the existence or otherwise of a select list.So if you modify your proc:HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST ARLISTPHGET-LIST ARLISTSTONHPHIF #S G 10HLIST AR PAYMENT.DATE LPTRP10 O No items Selectedthat should save a few trees.cheers,asvin"Chris Bugosh" [EMAIL PROTECTED] on 03 Feb 2004 13:51Please respond to U2 Users Discussion List [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: [EMAIL PROTECTED]cc:bcc:Subject: [UD]Determining if list existsIs there a Unidata or Uniquery command that tells you if a select listexists? In UniBasic I can use a SelectInfo function to determine if alist exists, but I can't find a way to do it at the TCL prompt.I have the following PQN PROC. The PROC itself works fine if there issomething to return from the selection criteria. However, if nothing isselected in the SELECT statement (like the one below would if we ran ittoday), the PROC does what it is told and lists the whole file, since itis never given a list, resulting in a huge printout of every ARtransaction.HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST ARLISTPHGET-LIST ARLISTSTONHPHHLIST AR PAYMENT.DATE LPTRPThanks for any suggestions you can give.Chris**This message originated from the Internet. Its originator may ormay not be who they claim to be and the information contained inthe message and any attachments may or may not be accurate.**(See attached file: C.htm)___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable butHSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] VARIABLE-1 = andBasicCompile$OPTIONSEXTRA.DELIMwork consistently
My issue was the possibility of -1ing a null value. I use -1 plenty of times if i absolutely know that the value is not null or i'm creating a log file. If i'm appending a set of associated mv'd attributes, i still DCOUNT the controlling one (one with never a null) add 1 and directly replace from there. Just my preference that hasn't hurt me. thanks. - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 9:55 AM Subject: Re: [UV] VARIABLE-1 = andBasicCompile$OPTIONSEXTRA.DELIMwork consistently Mark, ...the use of a MV counter either derived or managed is clearly the best solution... Some interesting performance figures... X has 100 fields (I cannot remember how big they were for this test) X-1 = 'A' takes 100 time units X := @FM : 'A'takes 150 time units X101 = 'A' takes 9320 time units X = X : @FM : 'A' takes 9010 time units Perhaps, sometimes, X-1 is a winner! Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: Re: [UD] Determining if list exists
The E=401 is a test to see if a process generated an ERRMSG record, item-id of 401. The ERRMSG file had its own syntax of displaying the messages with the parameters, but i'm sure it's a long lost art. Sort of like RUNOFF and BATCH. GFE (Gone ForEver). - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 6:34 PM Subject: RE: Memo: Re: [UD] Determining if list exists Goo'day, Are you sure the IF E = 401 bit works in UV? AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
I tried this on a MCD spirit, D3 W2kand AP-Pro as well and got the '1' and 567 that we're all getting. It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. Thus X="ABCDEF123IKIJIJ" ; Y="456ABCDEFG" PRINT (X[7,3])+(Y[5,3]) would produce the 579 as well. This brings up another aspect of the text/string situation: Consider this A="00"[1,3] ;*zeros for both lines B="00"[1,2] PRINT (A=B) and you would expect to get false as textually speaking 000 is not 00. But left alone, these 2 variables can be concluded to be numbers and thus equal even though their lengths are different. my 1 cent. - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Sunday, February 01, 2004 11:13 PM Subject: The result of VARIABLE[1,3] + 0 Hi All, What is the correct interpratation of A = '001' B = A[1,3] + 0 PRINT B On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical explanation of this. Does UV use '+' for string concatenation as well? Then why doesnt '123' + '456' result in '123456' (I get a runtime error)? Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UDT SELECT optimization
Title: RE: [UD]LOGTO Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one or more of them involve translates. For example: SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" AND WITH PERIOD = "199910" would be faster as SELECT HUGE.ARCHIVE.FILE WITH PERIOD = "199910" then SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" assuming that CUST.ZIP is translated and the PERIOD is a local field. Note the SSELECT in the second statement as well. I've often wondered if, when using consecutive ANDs the filter processor skips the record if the first WITH is false. Why bother testing the second field if both are ANDed. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it byissuing the commands one after the other, the second may may complete quicker, simply because the file may be cached in memory. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck MongioviSent: 02 February 2004 16:16To: U2 Users Discussion ListSubject: UDT SELECT optimization Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -ChuckThis email was checked by MessageLabs SkyScan before entering Microgen.This email was checked on leaving Microgen for viruses, similarmalicious code and inappropriate content by MessageLabs SkyScan.DISCLAIMERThis email and any attachments are confidential and may also beprivileged.If you are not the named recipient, please notify the senderimmediately and do not disclose the contents to any otherperson, use it for any purpose, or store or copy the information.In the event of any technical difficulty with this email, pleasecontact the sender or [EMAIL PROTECTED]Microgen Information Management Solutionshttp://www.microgen.co.uk ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Distributed multipart files [as RE: [UV] Resize - Dynamic or64 bit?]
Title: Message Just curious. Are Distributed files handled by the OS or the programmer. One client of mine had 12 monthly files (2-3 million records each) and the software combined the data into work files for cross-month queries. thanks. - Original Message - From: Logan, David (SST - Adelaide) To: U2 Users Discussion List Sent: Thursday, January 29, 2004 5:53 PM Subject: RE: Distributed multipart files [as RE: [UV] Resize - Dynamic or64 bit?] Hi Stuart, One large advantage (from my perspective) is the ability to address the file as one large file or as an single part individually. The open statement in the program is the same, only the name changes. The ability to put the parts on different file systems, balancing the load is another that springs to mind. The ability to split a file into manageable chunks is another. Some of our tables are starting to stretch toward the 20Gb mark and to split these into manageable chunks makes for reasonable resizing times etc. The individual parts can be resized at different times. The ability to split your data according to your own algorithm is especially useful. With multi-data part files, I don't believe you could address the complete file as one, other than that, the other points I have made are still applicable. I suppose distributed files are easier to deal with from the application point of view. If your distribution algorithm is reasonably well balanced the records will be placed evenly over the individual parts. Even if they are not, eg. you use say, a branch code as thekey, you don't have to worry about opening up the correct multi-part, the system will automatically do that for you. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart BoydellSent: Friday, 30 January 2004 8:57 AMTo: U2 Users Discussion ListSubject: Distributed multipart files [as RE: [UV] Resize - Dynamic or 64 bit?] I have never come across distributed files in a system and they sound a lot like multiple part files (like SYS.HELP,XXX). What is the difference / advantages / disadvantages between usingdistributed files andmultiple data-part files? Can a distributed file also be a multiple part file? Cheers, Stuart -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of David T. MeeksSent: Friday, 30 January 2004 07:50To: U2 Users Discussion ListSubject: RE: UNCLASSIFIED RE: [UV] Resize - Dynamic or 64 bit? Actually, a DISTRIBUTED file is largely a logical construct. It is a collection of normal files under the umbrella of a master logical file.The components of the DISTRIBUTED file (also called a PART file) can beany hashed file type.The file type that has DATA.30 and OVER.30 is a DYNAMIC file. Dave**This email message and any files transmitted with it are confidentialand intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action.This footnote also confirms that this email message has been scannedfor the presence of computer viruses.** ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users