RE: [U2] U2 / mv.net
Nick: We use both. This is because we have two different modules that were developed by two different groups of developers; one a .NET group and another an MV group (me) (guess who picked VB). :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, April 13, 2007 5:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] U2 / mv.net Hello, I'm curious, how many of you that are using .Net are using VB as opposed to C#? And why? Thanks, Nick Cipollina --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] VB.NET UniObjects Example
Greg: This is a very difficult question. The IBM Knowledge Base is only accessible to IBM authorized VARs. This restriction has been discussed here and, for the most part, declared to be not in the best interests of the U2 product(s). The URL is: http://www-1.ibm.com/support/advsrch.wss?rs=203rt=2 However, you need to contact your VAR to see if they'll give you access to the knowledge base through their access credentials, as most of the documents are locked. The entire credential process is difficult for both users and IBM. Access to different business functions need a different set of credentials; so it becomes quite confusing to access U2 resources. Your VAR should be able to help you through this though. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, April 11, 2007 9:18 AM To: u2-users@listserver.u2ug.org Subject: Re: RE: [U2] VB.NET UniObjects Example Hi Colin, You wouldn't by chance have an URL to those examples would you? Thanks a lot! Greg If you have access to the IBM knowledge base there are a couple of example projects in there that will give you everything you need. hth Colin Alfke Calgary Canada - Los Angeles this month From: schraibg Can anyone provide me with an example of how to add a new record to a Unidata database file using VB.NET? I am using Uniobjects and am able to connect to the database but I am unsure of how to go about doing record adds. The datafile has several multi-value attributes (fields) so any examples showing that detail would be great. I appreciate and help you can provide. Thanks, Greg --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] list files
:-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Monday, April 09, 2007 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] list files Outsourcing companies should make use of the following resource before accepting contracts for work they don't know how to do, then asking list members to do their work for them for free. *http://tinyurl.com/2trsr3 Regards, Clif Anita Panda wrote: Hi, I have connected . Thanks, Anita --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trying to run UniAdmin with PE`
A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you telnet localhost from a DOS window what happens? 7) What does the results of netstat -an show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: snip I hadn't tried it use it for a while until last night. I am assuming something I installed (Earthlink Total Access, or updates to Norton security, or updates from Microsoft) after the last time I used UniVerse UniAdmin has screwed it up. I get an error saying port 23 is used by another program. This was the error that I was originally getting before the motherboard and hard drive were replaced. Windows telnet was disabled, just for grins I enabled it to see if that helped, it did not. snip You might want to check out Active Ports, a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trying to run UniAdmin with PE`
Harold: First, you should probably uninstall UniAdmin and any other older U2 client software you have (unless you need it). Then reinstall the new version that comes with UV 10.2 (Try just installing UniAdmin first). Make sure you turn off your AV/Aspyware software first. I believe the most recent version of UniAdmin is 1.3. The reason you want to telnet to localhost is to verify UV is running, along with UV telnet on port 23 (the default port). I only have the same three services running on UV: + Resource Service + Telnet Service + UniRPC Service My netstat shows: C:\Documents and Settings\wphaskettnetstat -a | more Active Connections Proto Local Address Foreign AddressState TCPasibill:telnet asibill:0 LISTENING TCPasibill:31438 asibill:0 LISTENING TCPasibill:2940 localhost:31438ESTABLISHED C:\Documents and Settings\wphaskettnetstat -an | more Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:23 0.0.0.0:0 LISTENING TCP0.0.0.0:31438 0.0.0.0:0 LISTENING TCP127.0.0.1:31438127.0.0.1:2940 ESTABLISHED Port 31438 is the UniAdmin port. I've made a connection from my machine to UV on my machine via localhost. You should make sure UV is properly licensed as I've experienced the RPC service not responsive without proper licensing. The UV license I have is valid throuh 31 Mar 2008 (see UV control panel). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Thursday, April 05, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` Bill: Thanks for the hints! I can connect thru telnet localhost in DOS just fine. No other instances of U2 or other MV dbms. I have UniAdmin 1.2.0. Anyone know if that is current? No Zone alert. Did not consider #4 below when installing Universe 10.2. I can type netstat -an and see TCP and UDP stuff, but I don't know what it means. What am I looking for? Defining the connection in UniAdmin to be localhost (it works at DOS) I continue to get the dreaded No RPC connection active. Please, do you have the four services running? Or just 3 like I see: universe uvtelnet unirpc The older version I had of Universe had also this service: hsrexec I wonder if an older UniAdmin is looking for hsrexec and, of course, not finding it. Thanks to all who have sent in ideas. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H Sent: Thursday, April 05, 2007 9:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you telnet localhost from a DOS window what happens? 7) What does the results of netstat -an show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: snip I hadn't tried it use it for a while until last night. I am assuming something I installed (Earthlink Total Access, or updates to Norton security, or updates from Microsoft) after the last time I used UniVerse UniAdmin has screwed it up. I get an error saying port 23 is used by another program. This was the error that I was originally getting before the motherboard and hard drive were replaced. Windows telnet was disabled, just for grins I enabled it to see if that helped, it did not. snip You might want to check out Active Ports, a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trying to run UniAdmin with PE`
Harold Kevin: I just installed UV 10.2 PE onto my local machine (but not the client). I already have the U2 UniAdmin v1.3 client on my local machine to access several UniData dbms servers. I opened UniAdmin and created a new server called localhost pointing to UniVerse. I then logged in using my local machine's user and password and everything displayed underneath it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Wednesday, April 04, 2007 10:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] Trying to run UniAdmin with PE` Looking for help - I have downloaded Universe PE 10.2, replacing an earlier version or PE. I am unable to get UniAdmin to connect despite many combinations of attempts. One thing I find curious is that, with the latest download, the number of services has dropped from four to three . and I wonder if this is somehow related. From release notes in readme.txt, one can start the services from DOS, like so: net start universe net start unirpc net start uvtelnet net start hsrexec The last one does not work, claiming no such service. Universe Control also shows only the first three. Perhaps at 10.2 the last service is dropped deliberately (even if the notes don't reflect that). I don't really care, but I do want to run UniAdmin against the installed PE database to practice using it. My PC is networked on an NT network. I believe we use LAN manager. To start, one must define a connection in UniAdmin. One must fill in boxes for (1) Server Name (2) Transport Type (of course I click the Universe Radio button) I have tried localhost() for Server Name, the default 127.0.0.1 IP address which should mean the current PC, and my network IP address as well, and the specific string localhost() For Transport Type I have tried them all - Default, TCP/IP, and LAN manager Then, clicking on the created connection, I attempt to log in. One must enter (1) Login ID (2) Password The only combination I know is my NT login and password. I get one of two error messages: If I specify localhost() the error is the host name is not valid, or the host is not responding. If I specify any one of the other connections, the error is No RPC connection active. Any suggestions from anyone who has successfully gotten UniAdmin running against Universe PE is much appreciated. Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 [demime 1.01d removed an attachment of type image/gif which had a name of Citrus Punch Bkgrd.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
RIP. :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Sunday, March 25, 2007 2:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] Passing of Bruce Nichol - Talon Computer Services I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case Only
Jeff: This thread is about __MORE__ than just the data! Kevin eloquently pointed out that some of the old ways in the U2 space need to be abandoned for more modern thinking. A certain perspective has survived here for years and this has spilled over into a number of areas where the U2 products have lagged behind in development. This seems to be changing, both with IBM's commitment and with this space's more recent thinking. The current state of affairs in U2 is case-sensitivity. This construct manifests itself negatively in myriad ways; data storage, command execution, indexing, searching, code production, etc, etc, etc. The current work-arounds only address one aspect or another of the problem; e.g. with an environment setting one can compile BASIC code in a case-insensitive mode (great - . What about the other negative aspects of case-sensitivity? There might be another work-around but the solution has not been engineered, and needs to be. Some may want to code in upper-case only. As far as I can see there's nothing wrong with this. But be reasonable; don't __FORCE__ me to do the same !! Most of this thread has addressed the inconvenience of forced-casing or the it shouldn't bother anyone, get used to it perspective. MV was designed to be a dynamic product; not constrained by the arbitrary constraints of other dbms products; which offers tremendous flexibility. But it's hard to describe the difficulties involved in manipulating strings at the application level for simple string searches. These difficulties become larger and larger with each technology one interfaces with (like the web). The solution is simple...give both U2 products the ability, at least to start with, to install as a case-insensitive product; granularity can be added. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Friday, March 16, 2007 7:25 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case Only Different subject all together. I don't think anyone would disagree that there is a need to store (some) data in upper/lower case. The ongoing discussion has been about program source code, the 'consumer' of which is the machine itself who really doesn't give a hoot one way or another. Oh, and just because its Friday and therefore I'm in a particularly jovial mood has anyone anyone considered during this crusade that no matter how you write your source code it compiles to psudocode that is ALL UPPER CASE!!! :) Laura Hirsh wrote: I think that the upper/lower case issue -- albeit not a show stopper for anyone - is much worse than that. Besides the internal back-n-forth about programming in basic, and what case should be current, I think that a bigger issue revolves around data presentation and converting to a modern display and modern usage. For example, reports, mailing labels, Dear John letters... I mean, as a programmer, I can use MCU - that works great, MCL - not as useful, but, still works as documented. MCT? It's embarrassing. Dr. Mark Jones, MD is almost impossible to return. Mark Jones III - allows me to send a state of the art letter addressed to Mark Jones Iii. SEARCH is another of my pet peeves. It should be *smart enough* to figure out, or at least provide an option to be case insensitive. Maybe it does, and I'm not aware. But it just always seemed crazy. So, I search - string? MARK JONES then Mark Jones then Mark jones then mark jones. BTREES? Although some may disagree, Mark Jones and MARK JONES are the same thing - at least in our business environment. I think that if we want to work in a world that doesn't shout at us all the time, then we need to look beyond how to write a basic program That's my $.02 (hey, what happened to the cent character... it used to be there... I know it was... oh, maybe that was on the typewriters that didn't allow lower case) Laura --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case and Editors
Arnold: One can only hope the more experienced engineers of the U2 products are listening. One work-around after another make life more difficult not less. In the 21st century a solution would be helpful. Case sensitivity is a blight on the landscape of computing perpetuated by systems whose history was written by two-fingured typists and engineering challenged equipment. Someone mentioned recently the caps limitations of Prism terminals, as though typewriters haven't been around since the beginning of the 20th century and, certainly, noone had ever learned to use such contraptions. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Bosch Sent: Thursday, March 15, 2007 12:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case and Editors [snipped] ...I find it annoying having to switch caps-lock all the time - what happens a lot is that I switch to another window and start typing away merrily, only to realise after a couple of words that everything is cASE iNVERTED, or that the help I'm trying to give to a user is not working because of case inversion. As to editing, having become accustomed over the years to the convenience of full-screen editors, and not initially knowing that it was possible to use a full-screen editor to edit BPs, it was a nightmare for me to get the simplest things done in UV. I think there are many other newbies out there that feels the same... [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case Only
Ron: In PICK mode there is no LIKE keyword. Comparisons use the normal =, #, etc operators. So your example should be: LIST VOC WITH @ID = XREF] AND WITH TYPE = F ...or LIST VOC = XREF] WITH TYPE = F (notice the upper-casing) :-) Hope this helps. Bill Ron Hutchings wrote... Within the pick environment there is situation where you are forced to use upper case: List Voc with @id like XREF... and with Type = F The interpreter won't recognize most of this statement. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case Only
Ron: Sorry for the misstatement...I'm running UniData. UniData is occasionally much less forgiving than UV (sometimes it seems the engineers enjoyed tripping up PICK people). :-o Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Thursday, March 15, 2007 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Upper Case Only I was using pick as a generic term. I am currently working on an AIX platform running Universe with the pick flavor and the LIKE keyword works. My point was that it has to be in upper case unless you have really mucked up the VOC with extaneous synonyms. __ From: Bill H [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] Upper Case Only Date: Thu, 15 Mar 2007 12:02:10 -0700 Ron: In PICK mode there is no LIKE keyword. Comparisons use the normal =, #, etc operators. So your example should be: LIST VOC WITH @ID = XREF] AND WITH TYPE = F ...or LIST VOC = XREF] WITH TYPE = F (notice the upper-casing) :-) Hope this helps. Bill Ron Hutchings wrote... Within the pick environment there is situation where you are forced to use upper case: List Voc with @id like XREF... and with Type = F The interpreter won't recognize most of this statement. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error in report generation.
An interesting test would be for those who love to upper-casing everything to try typing in their favorite word processor (where mixed casing is the norm) without looking at the screen and have one of their children keep pressing the Caps Lock key. If you manage to get frustrated, then you can begin to imagine how others, who know how to type, feel about this U2 style casing situation; which manifests itself in upper-case BASIC code. Remember, case-sensitivity precludes mixed-casing while case-insensitivity precludes nothing! With case-insensitivity we can both have what we want. I don't mind anyone living with case-sensitivity, I just mind others insisting, or demanding, I live with it too! Have a heart, will ya? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Wednesday, March 14, 2007 6:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Error in report generation. I must be backwards because I actually find the second one easier to read and cleaner. And faster to type! Of course, I guess I'm one of the old-timers, having been in multi-value for 25 years now. -Dianne [EMAIL PROTECTED] wrote: [snipped] Loop ReadNext Id From MYLIST Else Fin = @True End Until Fin Do ReadU CustomerRec From CUSTOMERS, Id Then GoSub ProcessRecord End Repeat LOOP READNEXT ID FROM MYLIST ELSE FIN = @TRUE END UNTIL FIN DO READU CUSTOMERREC FROM CUSTOMERS, ID THEN GOSUB PROCESS.RECORD END REPEAT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unidata - setting unidata env on windows
Doug: I believe you can alter the udtconfig file in udthome\include (mine's in E:\IBM\ud71\include). You can also right-click on My Computer Properties Advanced tab Environment Variables button and add what you want. You can also execute the command set ENVIRONMENT_VARIABLE Value. The documentation indicates one cannot change environment variables for a session while in the session. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Tuesday, March 13, 2007 9:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] unidata - setting unidata env on windows Hey all, Does anyone know how to set an env. variable on unidata running on windows? (2003 server is the OS), I am trying to set the UDT_EDIT to allow us to use vi as the default editor Thanks! Dougc _ Doug Chanco Engineer Developer Senior, TLOTLD --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: I stay away from domains as much as possible; it wrecks havoc on all kinds of software. The two machines (an IIS web server and a UniData dbms server) are on the same workgroup, have the exact same administrator name and password (when I remote desktop in). WebDev is both the share name and the actual name of a directory in E: of the IIS Web server. When I open a DOS window on the UD server I can list the remote directory by using either path syntax: C:\Documents and Settings\myuserdir \\asiolywaweb\webdev (or dir \\asiolywaweb\e$\webdev) Volume in drive \\asiolywaweb\webdev is Web Volume Serial Number is A4D8-DA0E Directory of \\asiolywaweb\webdev 03/04/2007 02:21 AMDIR . 03/04/2007 02:21 AMDIR .. 01/13/2003 01:16 PM 7,109 achdemo.html 03/08/2007 09:09 PMDIR advantos 02/28/2007 12:42 PMDIR advantos.NET 02/28/2007 12:42 PMDIR aspnet_client 02/28/2007 12:41 PMDIR DesignBais 02/28/2007 12:41 PMDIR Logs 03/04/2007 02:21 AMDIR sps 02/28/2007 12:41 PMDIR WebExamples 1 File(s) 7,109 bytes 9 Dir(s) 121,820,229,632 bytes free C:\Documents and Settings\myuser I modified the DTAWEB (VOC) item on the dbms and tried to list the contents. 2 Demo (0)- AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: \\AsiOlyWaWeb\E$\WebDev Bottom. 2 Demo (0)- LIST DTAWEB Open \\AsiOlyWaWeb\E$\WebDev error. Open file DTAWEB error. ...but excluding the E$ in the path I get a different error from UD. 2 Demo (0)- AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: \\AsiOlyWaWeb\WebDev Bottom. 2 Demo (0)- LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)- I'm thinking there's something obvious I'm missing, maybe a UniAdmin configuration. Or maybe UD runs under different credentials, so there would be permission problems from inside of UD. Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Are the UD and web server on the same domain? I haven't been able to get it to work across domains (but I haven't tried really hard yet). It looks like webdev is a share name. Try something like \\asiolywaweb\c$\web\dev (or whatever the path is to the directory). If that doesn't work let us see what !dir \\AsiOlyWaWeb\WebDev gives you. Hth Colin Alfke Calgary Canada -Original Message- From: Bill H For the life of me I can't seem to get this to work in UniData. I have... :AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 30 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. From Windows Explorer on the UD server I simply enter \\AsiOlyWaWeb\WebDev into the address field and I get everything listed from the web server as I'd expect. But I can't get UniData (v7.1.9) to access the file. All I get is: :LIST DTAWEB errno=2: No such file or directory Open directory file DTAWEB error. Open file error. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: Thanks! I'm getting success, with questions. :-) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2 Demo (0)- AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 45 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. *--: FI Filed DTAWEB in file VOC. 2 Demo (0)- LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)- AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 30 characters. *--: 2 002: \\AsiOlyWaWeb\WebDev 002: \\AsiOlyWaWeb\E$\WebDev *--: fi Filed DTAWEB in file VOC. 2 Demo (0)- LIST DTAWEB ID-SUPP @ID_A LIST DTAWEB ID-SUPP @ID_A 18:33:21 Mar 09 2007 1 VOC... achdemo.html advantos advantos.NET aspnet_client DesignBais Logs sps WebExamples 8 records listed 2 Demo (0)- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - First question is why am I getting directories listed here? I'd expect to only get one item listed (the achdemo.html file (item)). Secondly, why would I have to use the Window administrative $ share reference? I explicitly shared the directory (gave it a share name the same as the directory), it works in DOS, what's up with UD? I've been under the impression UD handles this kind of thing easily. Since I'm not finding it easy at all I must be missing something critical. I've spent hours in the documentation and can't find anything on the IBM technical site. Not being able to access network shares from with UD is definitely causing problems. This brings up whole slew of questions regarding security. Am I able to write anything I want to anywhere I create a path VOC entry? Can I assume UD on NT runs under the administrator's credentials? Should I just blow off management of any security since it's so intertwined with the O/S? Any thoughts on this would be greatly appreciated. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 4:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Bill Try: Top of DTAWEB in VOC, 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: D_VOC Bottom. In one of your earlier examples you had D_VOC in 3. You need this to list the file. You could leave as is and still be able to edit files. If you do delete the file in UniData it will tell you that it is a remote file and remove the VOC item. It won't delete either the directory or the D_VOC. Hth Colin Alfke Calgary Canada --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Sharing a network directory
For the life of me I can't seem to get this to work in UniData. I have... :AE VOC DTAWEB Top of DTAWEB in VOC, 3 lines, 30 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. From Windows Explorer on the UD server I simply enter \\AsiOlyWaWeb\WebDev into the address field and I get everything listed from the web server as I'd expect. But I can't get UniData (v7.1.9) to access the file. All I get is: :LIST DTAWEB errno=2: No such file or directory Open directory file DTAWEB error. Open file error. : I tried to use the net use Z: \\asiolywaweb\webdev password /user:asioywaweb/admin command. DOS sees everything just fine. :!dir Z:\Advantos The system cannot find the path specified. : Any ideas what I'm doing wrong? I can't figure out why this doesn't work. Both the UD server and the Web server use the same admin user with the same password. Both directories ALLOW all the usual group of users access. Any help would be appreciated. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing PDF from UniData/AIX
Tom: Shouldn't this file be sent raw to the printer? I seem to recall I was working on signature fonts and was able to easily print the font to the printer in some kind of raw mode. I can't find my notes on the process but I think I used something like: lpr -PMyPrinter -bMyFont.spf This sent the job to the printer, raw, without any preprocessing. Maybe this is your issue. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 01, 2005 1:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Printing PDF from UniData/AIX [EMAIL PROTECTED] wrote on 07/01/2005 5:53 PDT Is there a way to print PDF files from AIX using a command from UniData? Troy Buss of Logitek Systems replied off-list on 07/01/2005 15:18:40 EDT: As a one time setup, you can also print the PDF to the printer using the correct windows driver but select 'print to file' and take the output file that would have gone to the printer and put it in the AIX filesystem, then shell out (of unidata) and print the file using lp cat or some other aix command to send the file directly to the printer. I tried that. I did a binary ftp to put file in /tmp, and tried lp -d queue /tmp/file. The escape sequences for the PJL got stripped off, and I had to cancel the job. The printers are connected to the network JetDirect cards, and some of them are old (e.g., HP 4+). I don't know how to use cat to send data to an IP address, or I would have tried that. Besides, my users specify an AIX form queue to have documents print there - I can't change that end of the logic. I need to be able to use the form queue name to determine where to print it. Thanks for the suggestion, however. --Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Ken: Ditto! :-) One might add faster and more stable triggers and built-in input timing. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Friday, June 24, 2005 6:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions [snipped] Anyway, I really don't want to go near the 'why buy UD instead of UV' discussion...[snipped]... The only thing I will say before moving quickly along is 'indexes'. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
David: Remember, with an unlimited user CPU license there is no requirement for pooling; as the connections don't run up against any licensing restrictions. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, April 25, 2005 8:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified} [snipped] RedBack does more than provide a pooling mechanism it also handles scheduling, performance monitoring, status and other facilities one would require for a pooling application which is all included in the price. With an SQL Server application, one would have to add that functionality into the design of the client server application which RedBack looks after for the developer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Cliff: With SQL Server, you also need one or two CAL's (Client Access Licenses) per named user (not concurrent). Plus I believe the more full-featured server versions are more expensive on the server side. A quick look on Google and you'll find an SQL Server Enterprise for $2,000 - $5,000. This product is very inexpensive. It is an unlimited client/device licensing model for a defined number of CPUs. Here's a pretty good whitepaper from Microsoft about the various costs associated with SQL Server, Oracle, and DB2. http://download.microsoft.com/download/1/0/a/10adfeca-48f4-4d89-949a-04167d6 54b40/SQL_UnderstandingDBPricing.doc This gives a small example of a price comparison: Tier Features Sample ProductsPrice Free Limited database Microsoft SQL Desktop $ 0 functionality, Memory Engine (MSDE) Limits, database size limits, etc. Basic Basic database function- MS SQL Server WkGrp Edition$ 500 - ality, Basic security Oracle Std Edition One 5,000 Up to 2 CPUs DB2 Expressper CPU StdFull database function-MS SQL Server Std Edition $5,000 - ality, Basic ManagementOracle Std Edition 15,000 Tools, Up to 4 CPUs DB2 WkGrp Edition per CPU Enterprise High availability MS SQL Server Enterprise $20,000 - Scalability Oracle Enterprise 40,000 High-end mgmt tools DB2 Enterprise per CPU Enterprise security No CPU limit As you can see a basic dbms access model over the web costs about $500 - 5,000 per CPU ! A full featured standard model costs about $5,000 - 15,000 per CPU. Of course, Microsoft products can be purchased from other vendors other than from Microsoft so significant discounts are available. In the above referenced paper, Microsoft also talks about additional costs such as support and service packs. Very interesting reading. I am confident IBM is well aware of MS SQL and Oracle server and client DB licensing models since DB2 plays in the same space. And they've begun playing. I know way too many people using SQL Server in the small to medium business end of the market to accept the notion that Microsoft stinks. From what I learned it is excellent software at a great price. In fact, I've started using it myself for some conversions we're doing on our application. Now all we have to do is get the U2 products priced reasonably and all the software mvDbms developers have developed over the years can be exposed over the web. :-) Bill ...Bill H. wrote: If I figure correctly, a hundred webshares cost $150,000 at $1,500 per webshare retail! Let's see...SQL Server unlimited site license (single CPU) for $5,000. Sounds like this is an invitation to get off the U2 products...or do I have this completely miscalculated? Bill -Original Message- from Leroy Dreyfuss The answer here is RedBack. It is designed for exactly this purpose. We have customers servicing millions of requests per day on a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MvInternet - IBM Licensing Requirement
Somehow or other this thread points out issue(s) mvDbms vendors need to come to grips with. I got onto google and entered SQL Server site license and picked the first link I saw and found out I could get a single processor SQL Server Standard license for $3,500 (or a single processor SQL Server Enterprise license for $7,500). To me this means I get an unlimited user SQL Server license for a single processor for $3,500 (or $7,500 if I'm interested in some advanced analysis features). This is specifically offered for e-commerce applications. It's often been pointed out that the mvDbms products are waay too expensive by comparison. This thread has wildly speculated about possible heavy handed action by IBM in order to continue to overcharge users for U2 products. At this rate there won't be any U2 users left. I don't believe anyone is trying to cheat IBM here (and IBM knows it). Developers are just trying to compete. This is good; for developers and for IBM. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, April 18, 2005 5:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MvInternet - IBM Licensing Requirement I have not heard of a single legal case in the IT world, not just the MV market, brought by a DBMS vendor against a VAR/developer for abuse of this common communications design. I think any company that does so would be committing political suicide, if it allowed its developer base to go so long without action, and then all of a sudden claimed that accepted practices and established connectivity products were now in violation of their legal terms. I am aware of Microsoft doing this. It has done software audits on even large organisations and clobbered then for breaches on SQL Server license. Oracle and IBM have stringent components of their contracts to enable them to do audits. I have had to sign distributor contract with IBM and it stated that they were entitled to investigate my client's sites to ensure that they have proper licenses. As the pressure is on the IT vendors to build revenues and IT spending is down, then sooner or later vendors are going to chase licensing issues to recover revenue. Unless IBM publicly states their position on this topic, takes a developer to court, or just sends a polite please rethink your license consumption note to someone, we will not know how liberal they are about their licensing, regardless of what their license actually says. My guess is that no DBMS company will take action unless there is blatent abuse It is in the licensing contract and a breach of license can lead to criminal charges to Directors. Under SOX one cannot ignore this because one thinks it is unlikely to happen. IBM U2 is not ignoring this area and has already placed restrictions in the use of phantoms to contain this manipulation. Additionally: The examples you give are not the main issue that causes a breach. There are a number of applications where users connect and stay connected but through a 3rd party mechanism that channels tasks through one license to the backend that then distributes to multiple background processes. The intent of this process is not application convenience or style but more an attempt to avoid license fees and many advertise this. It is this avoidance of license revenue that can expose companies legally. I have discussed this issue with both jbase and MvOn as their products talk to Oracle or SQL Server and falls into a similar category where you really only have 1 process accessing the RDBMS, independent of the number of users on jBase or MvOn. Both organisations have very quickly pointed me to Oracle and Microsoft to discuss licensing issues and neither would publicly recommend that companies run using 1 license of Oracle or SQL Server. This is very much on the radar of database vendors. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Multiple OPEN statements
Mark: I would say this is legitimate if one is reading from, or opening, a prioritized list of files. For instance, say I want to get a configuration parameter and want to: READ ParameterValue FROM ParameterFile.Fv, ParameterId THEN...ELSE... This parameter can come from any of several files already prioritized, say: LOCAL_PARAMETERS GLOBAL_PARAMETERS Then one might: OPEN 'LOCAL_PARAMETERS' TO ParameterFile.Fv ELSE OPEN 'GLOBAL_PARAMETERS' TO ParameterFile.Fv THEN...ELSE... END Just a thought. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 15, 2005 7:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multiple OPEN statements Call me old-school but I prefer top-down OPEN file TO handle ELSE STOP (sic) to get them all out of the way. Whether 1 or 50 files, the get all opened at the same time. If those choose to have a CALL OPEN.FILES internal sub or named commons, then that's also a respectable method. To have the main portion of the code be that indented only makes maintenance later that much more difficult. Very, very few people seem to label their END statements to indicate what they're matched to. Upon further investigation (using that programmers initials) i found that when there were 8 or more file, he did it in a more top-down or sequential fashion. That introduces 2 forms of coding for the same concept which is 1 form too many. That programmer is still at this client and uses the tired response That's what I was taught when shown how hard it is to follow all of those indents. Can't teach an old dog... my 1 cent - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, April 15, 2005 10:36 AM Subject: Re: [U2] Multiple OPEN statements - Original Message - From: Don Kibbey [EMAIL PROTECTED] You did mention only a few files display this type of syntax. Perhaps said programmer was shown the door I don't see why you would think that and frankly I'm surprised you haven't come across this style of programming before. This style of programming was taught in classrooms all over the country before the advent of point and click programming. It is a structured way of programming based on a logic sequence: What is the first file I need? OPEN FILE1 TO F.FILE1 THEN END ELSE PRINT CAN'T OPEN FILE1 END Do I need another one? OPEN FILE1 TO F.FILE1 THEN OPEN FILE2 TO F.FILE2 THEN END ELSE PRINT CAN'T OPEN FILE2 END ELSE PRINT CAN'T OPEN FILE1 END And another? OPEN FILE1 TO F.FILE1 THEN OPEN FILE2 TO F.FILE2 THEN OPEN FILE3 TO F.FILE3 THEN END ELSE PRINT CAN'T OPEN FILE3 END ELSE PRINT CAN'T OPEN FILE2 END ELSE PRINT CAN'T OPEN FILE1 END Now that I've got these open what do I do with them OPEN FILE1 TO F.FILE1 THEN OPEN FILE2 TO F.FILE2 THEN OPEN FILE3 TO F.FILE3 THEN EOF=0 LOOP READNEXT ID ELSE EOF=1 UNTIL EOF DO PROCESS, PROCESS, PROCESS REPEAT END ELSE PRINT CAN'T OPEN FILE3 END ELSE PRINT CAN'T OPEN FILE2 END ELSE PRINT CAN'T OPEN FILE1 END Although when the gosub came out most programmers took the center out and put it into a separate subroutine. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
Marc: It is possible that this sort of data movement is precisely the reason financial information, at numerous companies, is difficult to attest to, let alone use for analysis. :-) When I see this benefit (capability), red flags go up all over the place. It's like giving a gun to children...most will be ok but someone __WILL__ get hurt. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Tuesday, March 15, 2005 8:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Being a Manage-2000 client, and having been an Oracle client in the past (10.x) and having seen a JD demo I must say of the t1 suppliers, they did put on a nice show. (They could export directly to excel, change data, and re import the data back into the erp) :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Tuesday, March 15, 2005 10:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor So maybe Advante, Dataflo, infoflo, M2K and the like are not tier 1 multi-million dollar installs. But for ease of use and the ability to tweak the system to meet your needs. I'll take the tier 2 any day. Not intending to start an argument, but what can SAP or JD Edwards do that the smaller Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it
RE: [U2] [UV] non-numeric error after passing (ANS MATCHES '0 N' ANS0)
I ran this on D3 (flashed and unflashed). :bptest $options ext ; ans = str('1',1024) ; if ans matches '0N' then crt 'Yes' else crt 'No' ; ans = '':char(253) ; if ans matches '0N' then crt 'Yes' else crt 'No' BpTest*323682190 . [820] Creating FlashBASIC Object ( Level 0 ) ... [241] Successful compile! 3 frame(s) used. Yes No Am I to understand this is not the same on UniVerse/UniData? Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Dave: Since D3 can be case-insensitive, it's possible to: 1) Create an item in (VOC) named Joe 2) Edit an item named JOE, which is the item Joe, and file it. So, from a certain perspective, one could say that D3 allows an item named JOE, JOe, joe, jOE, etc to share the same record key of Joe; therefore, there are duplicate record keys. Did I say this right? :-) Bill P.S. I've been working with some ODBC stuff lately and really have to do the shake to get data to come out ok. I guess the SQL crowd doesn't care of the general illogic of it, just that regular people can't use the tools. Job security is not all bad. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 12:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unique Ids Susan, This is the approach I took with the speaker. There was a period of time 'in the good old days' where the has could go goofy either through corruption or keys containing system delimiters .. But as the speaker (supposidly with the same term of experieince as I) was teaching the benefits of MsSql Server and the wonders of sql .. G DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] Unique Ids From: Susan Lynch [EMAIL PROTECTED] Date: Tue, March 08, 2005 11:54 am To: u2-users@listserver.u2ug.org I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: [EMAIL PROTECTED] To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wintegrate query builder question
Kevin: Try sending it to the Report Viewer first then export it from there. I think this will be easier. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
Phil: Although this is a U2 specific list, the same pricing problem exists with ALL mvDbms products. In addition knowledge seems to be locked up and there are so many proprietary solutions to simple problems. Developers often have to pull teeth to solve some basic problems. Every business problem requiring an mvDbms solution seems to entail a steep learning curve (kind of like Linux and networking). Since the mvDbms vendors aren't interested in long-term revenue but in short-term profits I doubt whether this will change. So, in the long-term we'll all have to migrate off of the dbms (or die first). :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Phil Walker Sent: Wednesday, February 16, 2005 5:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Questions: Why can't end users access the knowledgebase? Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. Some people may wonder why you would develop something in U2? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
Adrian: I recently saw a Dell add where they partner with Oracle and one can purchase an Oracle license for about $150/license. Don't know how that works out in a web environment or a device licensing scenario but that's not anywhere near as expensive as it used to be. Also, Microsoft SQL Server can be had for about $5,000 (or less) for an unlimited license on a single processor. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, February 17, 2005 2:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Yes but how much does it cost to license Oracle and Access for a Live environment? From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Thu 17/02/2005 01:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something. I know people in this group think U2 is the greatest, but that does not make it necessary to lock it up like the crown jewels. Questions: Why can't end users access the knowledgebase? Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. Some people may wonder why you would develop something in U2? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Thursday, February 17, 2005 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe I never thought I'd see grown people complaining that they hadn't gotten their free stuff soon enough. As in *free* *No charge* As in if you complain *TOO MUCH* maybe they'll start charging $100.00 for it.PER YEAR. You wanna know how much software I give away for free? Ok, maybe one little SUBR dict program using an index to retrieve data from a file with a different id, but that was it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kent Sent: Wednesday, February 16, 2005 14:19 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent
RE: [U2] [UV] RAID debugger
Great! Now if only the runtime engine would tell me a little more about the Variable Not Assigned a Value, Zero Used (and other such) error(s); like what variable and what value! Seems this was requested from Microdata 25 years ago too. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Maresh, Mel Sent: Wednesday, February 02, 2005 7:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] RAID debugger Talking of debuggers, is everyone aware that RAID will now display the values of individual elements in a dynamic array :: D.CHART10/ STRING: T r L=114 `34321035593806859869452618551232605421692343520675401124 5611372190936940279115843867302197542611598000' :: D.CHART10,1/ STRING: T r L=10 `3432103559' This is really cool, something I requested from microdata 25 years ago. Mel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Farrant Sent: Wednesday, February 02, 2005 8:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] RAID debugger Talking of debuggers, can anyone remind me how the $INCLUDE s can mess up the line numbers displayed within the RAID debugger. I had a solution to this once which I seem to remember had something to do with the configuration or placement of the $INCLUDE lines in the source code. I look forward to any response Thanks Mike Farrant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD] Programmer needed in New Jersey
Jeeze... and I was going to make some comment about Descartes corollary: I think therefore I'm right. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gordon J Glorfield Sent: Thursday, January 27, 2005 7:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [AD] Programmer needed in New Jersey Well said Debster! Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/27/2005 09:13:02 AM: [snipped] Specifically seeking a junior is not really wrong, what would be wrong would be to hire a seasoned professional for a position that they are grossly overqualified for and most likely underpaid for. [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] K = K
Chris: Place: $OPTIONS EXT at the beginning of the program then try to compile again. This should do the trick. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 20, 2005 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] K = K I've just started at a new site running D3 7.2.1.RS on AIX and the REMOVE statement doesn't compile at all! It's very annoying as it's a very convenient way of processing dynamic arrays and with larger arrays far more efficient than counting the markers and FOR... NEXTing through it. I'm suprised that REMOVE isn't universal amongst U2 BASICs. Regards, Chris Bill writes - In UniData and D3 the REMOVE statement looks like: REMOVE variable FROM dynamic.array AT position.variable SETTING delimiter.variable This allows the explicit setting of the pointer, without resorting to reinitialization by reassigning the array variable. I've always just assigned Position.Variable prior to doing any REMOVE stuff. But then, UniVerse is sometimes a different animal. :-) Checked by MimeSweeper Thu, 20 Jan 2005 14:56:43 - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] K = K
Now that I think about this, K is the array being traversed? We simply remove the next attribute/value/subvalue in array K and assigning this value to DUM. For example: K = I^AM^HAPPY]TO]READ^THIS^LIST REMOVE DUM FROM K SETTING MORE would result in: DUM = I K= the above array MORE = 2 However, (from the documentation), the pointer is reset to the beginning of dynamic.array whenever dynamic.array is reassigned. Therefore, dynamic.array should not be assigned a new value until all elements have been extracted (that is, until variable = 0). So, the line K=K simply reassigns the array to itself, thus resetting the pointer. In UniData and D3 the REMOVE statement looks like: REMOVE variable FROM dynamic.array AT position.variable SETTING delimiter.variable This allows the explicit setting of the pointer, without resorting to reinitialization by reassigning the array variable. I've always just assigned Position.Variable prior to doing any REMOVE stuff. But then, UniVerse is sometimes a different animal. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 1:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] K = K Date: Wed, 19 Jan 2005 13:29:15 -0600 Marilyn Hilb [EMAIL PROTECTED] wrote: I frequently see this type of line K = K in the code I work on and never understood why. -Original Message- From: Andrea Charles [mailto:[EMAIL PROTECTED] Do you need the K = K ? -- ... (Code from Charles Stevenson) REMOVE DUM FROM K SETTING MORE ; check for any delimiters K = K ; * reset rmv ptr in case calling pgm cares. According to the UniData Help for REMOVE, in the code sample above, DUM would be set to the first string delimited by a standard delimiter (e.g., @AM, @VM), and MORE would be set to index the level of the delimiter encountered: 0=End of array, 1=Record Mark (255), [EMAIL PROTECTED] (254), [EMAIL PROTECTED] (253), etc. A pointer is maintained so that the next REMOVE X FROM K would return the next string. The comment is stating that the K = K is used to reset the REMOVE pointer to the beginning of the string. Further info on using REMOVE: REMOVE is useful for sequentially processing all the elements of a dynamic array without having to recount for each subsequent item. However, you need to check your delimiters to find attributes/values/subvalues. A similar method to process each attribute is to SELECT K TO KLIST and then READNEXT DUM FROM KLIST within a loop. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Where Will the .NET Apps Live ?
Tony: [stuff snipped] Brian's comment about intepreted code wasn't lost on me and I need to consider it - I confess I've never done that. Putting some logic at a middle tier, not necessarily at the DBMS server, also has advantages. At the risk of yet more bandwidth, but not consuming licenses, many basic validation rules can be exposed as client-independent web services. That approximates that interpreted layer, makes changes virtually instantaneous, and eliminates deployment issues. Goes to show you what we'll do for cost considerations. Introducing another tier seems like madness, unless it's cheaper. :-) That's why it sometimes looks like the main MV providers aren't really interested in exposing the dbms model to the mainstream. In IBM's case, they probably just want to kill the product, eventually, because growing the product competes with their other product(s). In RDUS's case, they probably just want to squeeze it for what they can because they believe it'll die by itself. Not sure about jBase though. Maybe if they can sell it to China they'll reach a critical mass that'll support a migration from D3 and U2. What a bizarre thought. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The list format and usefulness
I've always thought it is much preferable to read the unuseful discussions on this list than the many Viagra, ..meds.., complimentary..., Why pay more, Nice women, and other emails I regulary get. :-) Merry XMas. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Frost, Bodo Sent: Tuesday, December 21, 2004 6:56 PM To: [EMAIL PROTECTED] Subject: RE: [U2] The list format and usefulness Les, Many thanks for your reply on this 'useful' discussion. I am new to universe and have subscribed to get a lot of information on what's going on, what you gurus have to say about uv, etc. David, just a comment to you, and I apologize upfront if I seem to be rude: You have started the one big discussions which you seem to claim NOT to be useful. Is this the thing you have intended when posting? My way of dealing with very useful discussions is to delete the crap after reading 2 or 3 lines of the reply. If the reply is not of interest, I just delete it. And David, I suggest that you do so as well. For me as a newbie in uv the technical discussions are most valuable, as an oldie in IT (20 yrs) I know about the need for people to express themselves in useful discussions - people don't get me wrong! It is all appreciated!!! What I want to say is: I only keep those posts which are or seem to be valueable for me, the rest is just being deleted. It is as simple as that. And therefore it does not need further discussions. Have a wonderful Christmas and a Happy new Year. Kindest Regards Bodo Frost Midland Brick Company Pty Ltd 102 Great Northern Highway MIDDLE SWAN WA 6056 Phone: (08) 9273 5589 Fax:(08) 9273 5523 E-mail: [EMAIL PROTECTED] CAUTION: The information contained in this document is of a confidential nature and its sole use is for communication purposes between the sender and addressee. Your respect of this confidentiality is appreciated. If you have received this document in error, please notify the sender on the above telephone. Thank you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Tuesday, 21 December 2004 6:37 PM To: [EMAIL PROTECTED] Subject: RE: [U2] The list format and usefulness Just to throw oil on the fire... This is the technical list.please take this to the community list (very big grin..) Les 3 more days work to go -Original Message- From: Charles Barouch [mailto:[EMAIL PROTECTED] Sent: 21 December 2004 06:31 To: [EMAIL PROTECTED] Subject: Re: [U2] The list format and usefulness David, What I do is subscribe to both the list and the digest. That way I can skim and delete the individual messages as they come in (from the list), still have all the content if I need it later (from the digest). To control bandwidth, I have them going to two different names, so I can opt to not pull the e-mail with the separate posts if I don't have time or speed to spare for it. As moderator I can't delete-without-reading, but you could. I know it's not the answer you proposed, but I find it a workable solution. What has me more curious is your comment about the online indexing being insufficient. What would you like to see done differently? - Chuck Info-glut Barouch Clifton Oliver wrote: Full content. A lot of times watching how someone else is thinking is more instructive than what they are thinking. For a problem, an answer is enough. To learn how to solve a class of problems, watching the process that more experienced (or even just different) techs go through is an education worth the noise on the channel. IMO. Clif -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail cbarouch - Skype (Free VoIP Phone) [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any
RE: [U2] wIntegrate (on Universe) Question
Have you cataloged the WIN.PROGS in the local account? WIN.SERVER must be able to be executed for the query. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Thursday, December 16, 2004 6:57 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question Ive just tried this and I get the same result. I created the program as suggested and put it on a menu. When you choose that menu option, the query builder pops up. However, right after you set up the query and press ok, you are at a 'press any key to continue' on the menu (Universe machine). Meanwhile there is a wIntegrate window trying to pass the data to the report viewer and it times out. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, December 15, 2004 2:28 PM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question Anthony: Try the following: ** Run process to start wIntegrate script SCRIPT = 'Chain query\query.wis' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ This will pop open the Query Builder from a BASIC program and you should be able to do what's necessary from there. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 15, 2004 9:06 AM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate (on Universe) Question I forget if there is a separate group for this product. If so, sorry. However, my problem is this; I am evaluating the wIntegrate product. One of the uses that we have for this is the query builder/report viewer. We have a person who used to tinker at the command line. We have long since pulled the plug on this kind of thing, because they did some 'bad things'. However, it is nice to let them have the ability to query the data (after all it is theirs). So, it seems wIntegrate can do this for us. My problem is that you need to be at a command line to allow wIntegrate to operate. So, we're back to square one - user at the command line. Our system is based on standard Universe menus. Is there a way to add a menu option (or create a VOC) that will allow the user to 'mess' with query builder, etc ? I have tried adding WIN.SERVER as a menu option. However, this half works. I created a simple query and tried to put it to the report writer and it times out, because the WIN.SERVER closes. If I send it to the screen, it works ok. Any workarounds to this ? Anthony --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate (on Universe) Question
Anthony: I implemented this in our menu structure by using our standard TCL shell program (the usual tcl stacker program). So, before I actually run the wIntegrate call I automatically exit the menu to our TCL shell. Then the query is run. When it's finished the user is back at the shell with whatever restrictions they own (if restricted then anything they press returns them to the menu). If I just execute the following code (as a separate cataloged program from within a BASIC menu program): * ** Run process to start wIntegrate script SCRIPT = 'Chain query\query.wis' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ I get the query builder screen and the report and I'm returned to the menu instead of viewing the last page (which is why I route everything through the TCL shell). Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Thursday, December 16, 2004 12:16 PM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question Yeah WIN.SERVER is good. If you are at a command prompt all of this works just peachy. However, when you try this from menu it times out. It times out ONLY when you choose to see the report in the report viewer. Otherwise, all is fine. WIntegrate works fine here for anything I do. It seems like a great product. The only problem I have is that our users all login and get their menus. NO ONE is allowed to break out of a menu to the command line. WIntegrate doesn't like this. It seems that it wasn't designed to do so. I do have a 'pseudo command interpreter' that I wrote for those occasions where someone must break out for whatever emergency. I could program this to allow WIN.SERVER. My preference is to have this work for users without breaking out of a menu. Are you doing this at your place Bill ? Is your suggestion something that you have working at your place ? If so, then I must be doing something wrong. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, December 16, 2004 12:51 PM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question Have you cataloged the WIN.PROGS in the local account? WIN.SERVER must be able to be executed for the query. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Thursday, December 16, 2004 6:57 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question Ive just tried this and I get the same result. I created the program as suggested and put it on a menu. When you choose that menu option, the query builder pops up. However, right after you set up the query and press ok, you are at a 'press any key to continue' on the menu (Universe machine). Meanwhile there is a wIntegrate window trying to pass the data to the report viewer and it times out. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, December 15, 2004 2:28 PM To: [EMAIL PROTECTED] Subject:RE: [U2] wIntegrate (on Universe) Question Anthony: Try the following: ** Run process to start wIntegrate script SCRIPT = 'Chain query\query.wis' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ This will pop open the Query Builder from a BASIC program and you should be able to do what's necessary from there. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 15, 2004 9:06 AM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate (on Universe) Question I forget if there is a separate group for this product. If so, sorry. However, my problem is this; I am evaluating the wIntegrate product. One of the uses that we have for this is the query builder/report viewer. We have a person who used to tinker at the command line. We have long since pulled the plug on this kind of thing, because they did some 'bad things'. However, it is nice to let them have the ability to query the data (after all it is theirs). So, it seems wIntegrate can do this for us. My problem is that you need to be at a command line to allow wIntegrate to operate. So, we're back to square one - user at the command line. Our system is based on standard Universe menus. Is there a way to add a menu option (or create a VOC) that will allow the user to 'mess' with query builder, etc ? I have tried adding WIN.SERVER as a menu option. However, this half works. I created a simple query and tried to put it to the report writer and it times out, because
RE: [U2] wIntegrate (on Universe) Question
Anthony: Try the following: ** Run process to start wIntegrate script SCRIPT = 'Chain query\query.wis' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ This will pop open the Query Builder from a BASIC program and you should be able to do what's necessary from there. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 15, 2004 9:06 AM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate (on Universe) Question I forget if there is a separate group for this product. If so, sorry. However, my problem is this; I am evaluating the wIntegrate product. One of the uses that we have for this is the query builder/report viewer. We have a person who used to tinker at the command line. We have long since pulled the plug on this kind of thing, because they did some 'bad things'. However, it is nice to let them have the ability to query the data (after all it is theirs). So, it seems wIntegrate can do this for us. My problem is that you need to be at a command line to allow wIntegrate to operate. So, we're back to square one - user at the command line. Our system is based on standard Universe menus. Is there a way to add a menu option (or create a VOC) that will allow the user to 'mess' with query builder, etc ? I have tried adding WIN.SERVER as a menu option. However, this half works. I created a simple query and tried to put it to the report writer and it times out, because the WIN.SERVER closes. If I send it to the screen, it works ok. Any workarounds to this ? Anthony --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Scanner Connection
Mark: Check with Tony Gravagno. His email address is: [EMAIL PROTECTED] Don't forget to remove the remove this. I know he can help. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Wednesday, December 01, 2004 12:26 AM To: [EMAIL PROTECTED] Subject: [U2] Scanner Connection I have a client using Accuterm with telnet sessions for all the users. One user has a Bell Howell multi-page scanner that gets around 100 pages per day of work orders etc. That user's emulator is Ve-Client from Visual Pick and they want to re-write the app with Accuterm and some VB scripting if necessary. My question is where would someone go to find out how this can be done. It presently is done in VE with a 9,500 line program (4GL generated code) that has oodles of includes and gets very busy. It still doesn't do what I would like and that is for the scanner to write the scanned docs to a temp folder, I would use Accuterm to load in those filenames and offer them to the user for proper pc-filenaming to attach to the application. I would appreciate any insight on this. Thanks in advance. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UD] problem with hex conversions
Goes to show ya...coming from a Pick background I see nothing wrong with the results. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Simon Lewington Sent: Wednesday, November 24, 2004 3:35 AM To: [EMAIL PROTECTED] Subject: [U2] Re: [UD] problem with hex conversions Switch to $BASICTYPE 'U' to stop this supposed Pick-Style behaviour. Simon Ben Gladman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm getting unexpected results from the hex conversions in Unidata 6.0.12 on NT: PROGRAM BJGTEST * CRT OCONV('1','MO')= : OCONV('1','MO') CRT OCONV('1','MO0C')= : OCONV('1','MO0C') CRT OCONV('1','MX0C')= : OCONV('1','MX0C') CRT OCONV('1','MX')= : OCONV('1','MX') CRT ICONV('F','MX')= : ICONV('F','MX') * STOP the results I get are: OCONV('1','MO')=001 OCONV('1','MO0C')=061 OCONV('1','MX0C')=31 OCONV('1','MX')=31 ICONV('F','MX')= The octal conversions and the hex-ascii conversion seem okay. But I would expect the fourth line to read '1' or '01', and the fifth line to read '15'? Is this a problem anyone else gets? Cheers, -Ben --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Thanks for the help with the wIntegrate text box. It helps to use the WIN.DBEDGET and WIN.DBEDGET subroutines instead of the WIN.DBGET and WIN.DBSET (one can even choose between an VM'd or an AM'd return string). I've noticed one additional peculiarity. I wrote a wrapper subroutine to call the WIN text box routines and has an [OK] and a [Cancel] button on the form. I have a main program that asks for an newsletter item id then calls this wrapper program; which pops open the wIntegrate (or AccuTerm) text box. No other interaction with the WIN... routines occurs. I type in the information then click on the [OK] button (or can just click the [Cancel] button. The peculiarity is when, still staying inside the main program, entering another newsletter id, which pops open (and fills) the text box for a second newsletter item, I click anywhere in the text box and try to enter data. I cannot enter data. I can, however, press the [Backspace] key and erase data. I can select data, but any key I press acts like the [Del] key. If I exit the main BASIC program then reenter it, the text box functions normally. The AccuTerm textbox always operates normally. Does anyone know why the 1st call of a text box, from within a BASIC program, acts like a normal text box but subsequent calls restrict data input but not data removal? I was fiddling with the WIN.DBDEL and the WIN.SSTATE routines but the wrapper subroutine seems to be coded identical to the WIN.DBDEMO2 routine. As ususl, any observation would be appreciated. :-) Bill -Original Message- From: Bill H. [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 10:34 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate text box Ian: Thanks very much. My 1996 documentation doesn't have that style property. After careful review of the 2003 pdf off IBMs website, I see it. This gets the job done nicely. :-) Thanks again. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew Sent: Thursday, November 18, 2004 5:30 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate text box Try adding the style property ES_WANTRETURN as part of the Opts variable. Regards, Ian Renfrew --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PDP vs UO, was Case
George wrote: Bob, Why would you buy PDP.NET from Raining Data - especially since it comes with Unidata 6.1 and probably Universe soon if not now. From what I understand, PDP.NET has a number of features that the UO.NET plumbing doesn't offer: 1) it's a Microsoft certified .Net Data Provider 2) it supports ADO.NET 3) it is supposed to outperform UniObjects (speed, scalability) 4) the class libraries extend Pick Basic functionality to .NET 5) it's been on the market for over a year 6) it seems they will continue to adopt and invest in the latest .NET functionality 7) it integrates with Visual Studio(help, f1, docs, intellisense, etc.) 8) docs are extensive 9) the training tools have source for all demo apps I got this off the documentation I have on the product. Since I'm using the product I can attest to most of this. Hope this helps. Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Case
Bob: Raining Data has their PDP.NET product available for the U2 products. I'm presently using it for D3 but can't judge its efficacy for U2...would assume it works just fine though. You might try checking this out: http://www.rainingdata.com/products/connect/dotnet/index.html Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of BobJ Sent: Sunday, November 21, 2004 12:05 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Case Thanks. Once I had the clue I was able to find the right words in the docs. BobJ - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 21, 2004 2:01 PM Subject: Re: [U2] Case INVERT will make the case in UV opposite to the Shift-Lock key. PTERM CASE NOINVERT makes it the same as the Shift-Lock key. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Allen Egerton wrote: On Sun, 21 Nov 2004 11:49:38 -0500, you wrote: Universe 10.1 PE The case appears to be reversed Is there some way to stand this thing on its head and get normal casing back? It's only a mild irritant but it IS an irritant and the product seems to complete for something like that to have been left without an option or a fix. snip Try adding PTERM CASE INVERT to your VOC LOGIN paragraph. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Ian: Thanks very much. My 1996 documentation doesn't have that style property. After careful review of the 2003 pdf off IBMs website, I see it. This gets the job done nicely. :-) Thanks again. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew Sent: Thursday, November 18, 2004 5:30 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate text box Try adding the style property ES_WANTRETURN as part of the Opts variable. Regards, Ian Renfrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, November 17, 2004 7:08 PM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate text box I've created a simple text box for wIntegrate and AccuTerm from within BASIC. The simple task is to allow data entry of up to 1200 characters. When the [OK] button is pressed the contents of the text box is passed back to BASIC. AccuTerm works just fine. However, wIntegrate is giving me no end of grief. The problems are: 1) How can I press [Enter] in the text box without closing the text box? 2) What character(s) are passed back to BASIC for [Enter]s? 3) Does wIntegrate do what AccuTerm does and filter CrLf with VM/AMs? Can anyone help? It would be greatly appreciated. Thanks, Bill Code snippet in calling programlooks like: Opts = ES_MULTILINE|WS_VSCROLL|WS_BORDER Opts-1 = 1200; ** the maximum length of field WKAMT= NULL$ ; ** initialize the variable CALL wIntDBEdit(DispData, 'News Item', 300, 125, 1200, 80, Opts, WKAMT) The program wIntDBEDIT looks like (takenn from: DBX = NULL$ DLG.NAME = wIntDlgBox dbName = NewText VER = NULL$ tbxStart = INT((300 - 125) / 2) ** build dialog box CALL WIN.DBNEW (DBX, DLG.NAME, dlgTitle, 10, 10, 300, 125, '', Opts) CALL WIN.DBEDIT (DBX, dbName, tbxStart, 15, 1200, 80, Opts) CALL WIN.DBBUTTON(DBX, OK, OK, (INT(300/2)-45), (125-25), '', '', 1) CALL WIN.DBBUTTON(DBX, Cancel, Cancel, (INT(300/2)+15), (125-25), '', '', 0) ** load the dialog box CALL WIN.DBLOAD(DBX, ERR) ** test for already exists load errors IF ERR = 3 THEN CALL WIN.DBDEL(DLG.NAME) ; ** delete dialog box CALL WIN.DBLOAD(DBX, ERR) ; ** load again END ** test for load errors (in case we did it again IF NOT(ERR) THEN CALL WIN.DBSET(DLG.NAME, dbName, strOut) CALL WIN.DBSHOW(DLG.NAME, 1, ERR) IF ERR THEN CALL WIN.DBDEL(DLG.NAME) END END --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index problem
Phil: What I don't understand about this conversation is why would one expect any different functionality from the dbms? This has been, in my experience, the way indexes have always been on the mvDbms products; whether they be U2, D3, or whatever. When an index is created, it is updated if, and only if, the file it was created for changes. Your example indicates an index on DETAIL that translates HEADER information. Since DETAIL is written first, hence no HEADER information exists, the index on DETAIL is updated with NULL. When HEADER is written, it is completely irrelevant what indexes exist on DETAIL (as it is irrelevant what indexes exist on CUSTOMER, RECEIPTS, etc). The only index that will be updated when HEADER is written are indexes on HEADER. This is a common problem with an mvDbms index structure. Your solution is probably the only practical one available. I've been fiddling with the possibility of doing an after update trigger to update the related DETAIL but that significantly slows down batch processes and really messes up my COPYs and RESTOREs too. So I've found your solution to be the best, in the aggregate, where a file is kept of changes in the DETAIL file and a process then reindexes DETAIL on a periodic basis. You may want to test, however, keeping a file of changed items in DETAIL. Then periodically reading/writing the DETAIL record(s) and see if the index is then updated, even though there is no change to the DETAIL. This might work and be a more practical solution. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Warren, Phil Sent: Wednesday, November 03, 2004 6:25 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] Index problem We've run into a similar problem with virtual attributes that reference other files in all versions of UniData through to version 6.0.8. I wonder if this might be a similar 'anomaly' For example, In our case we have 2 order files, named HEADER and DETAIL. A virtual attribute exists in the DETAIL file which references the HEADER file. When the DETAIL record(s) are written out before the HEADER record, UniData does not update the DETAIL index when the HEADER file is written, causing a null value when the DETAIL index is used. As in your case, when another attribute is used, to select the DETAIL file, which does not use the index, the items are selected as expected. The only work around that we've used, is to rebuild the index file daily. Perhaps there is a better work around or fix? -Phil- -Original Message- From: kafsat taiyus [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 10:00 PM To: '[EMAIL PROTECTED]' Subject: [U2] Index problem We have one Unidata 5.1 data file with a virtual attribute. The virtual dictionary calls a Unibasic subroutine and returns a single value data from a multi value attribute from within the same file. We have an index on the virtual attribute. When new records are added to the file Unidata does not update the index on the virtual attribute. After adding new records that returns XXX for the virtual attribute the command LIST FILE_NAME WITH VIRTUAL_ATT = XXX does not return any record. But the command LIST FILE_NAME NO.INDEX WITH VIRTUAL_ATT = XXX finds the record. The command LIST FILE_NAME WITH VIRTUAL_ATT = XXX works only after rebuilding the index using REBUILD.INDEX command. Do you know why is it happening and how to fix it? Thank you in anticipation. Regards Kafsat This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Term settings for capture and no extra headings
Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the Report Viewer. I use this a lot and maybe it'll work for you. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Friday, 29 October 2004 1:28 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Term settings for capture and no extra headings On Universe 10.0.19: I want to capture a report sent to the emulator (wintegrate) and still retain the first page headings, but not get a repeating heading every 60 lines or so. On pick D3, it was possible to get this behavior by setting the page depth to 0. On universe, it wants an integer from 1 to 32767 so I end up with page breaks and a new heading every 32k lines (which is currently the lesser of the 2 evils). Is there a setting on universe that will accomplish what I need? Thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Mark: The program at http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest doesn't even have these limitations. This wiki has some pretty nice free programs. I like to take the non-mvDbms attitude: it's free so use it. :-) We should all post our free programs there. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Wednesday, October 20, 2004 5:54 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UD] running a subroutine [snipped] In fact, I welcome any criticisms or limitations anyone would have against establishing this PRINT command to handle everything. I know of 2 limits: 1) No hanging ELSE or THENs. 2) Cannot use READNEXT. Other than that I'm all ears. My 3 cents. - Original Message - From: Peter Olson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 8:43 AM Subject: RE: [U2] [UD] running a subroutine but i want more! found it! 0001: PQ 0002: HSELECT 0003: H EVAL SUBR(' 0004: A\2 0005: H', 0006: A3 0007: H ) FROM VOC FIRST 1; 0008: P now it's tclTS AGE.DATE -2224,42 Cool thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Memo: RE: [U2] Spooler question
Tim: In standard Pick format one can assign up to three form ques to a printer or the same form que to multiple printers. That way a report sent to that form que would either: a) print to the single printer when it's free, or b) print to the 1st available printer the que is assigned to. Of course, maybe I'm dreaming. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder Sent: Wednesday, October 20, 2004 8:11 AM To: [EMAIL PROTECTED] Subject: RE: Memo: RE: [U2] Spooler question Dennis Bartlett [EMAIL PROTECTED] wrote on 10/20/2004 09:52:54 AM: Yes I've looked at classes - the idea would hold is we only wanted to print to any one of several available printers... the bummer is getting the month-end / genled reports to come out oneafter the other (ie on one printer) You could set up a class that contains all of these printers, and send most print jobs to the class; they would show up on whichever printer is available. Send the reports that need to appear only on a certain printer directly to that printer instead of the class. Tim Snyder IBM Information Management Consulting I/T Specialist , U2 Professional Services --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Stu: Here are a couple examples from the wicki program: For when I want to test a subroutine with common: BPTEST $INCLUDE DTABP,INCLUDES SET.NAMED.COMMON ; $INCLUDE DTABP,INCLUDES SET.INITIALIZATION ; A = NULL$ ; B = NULL$ ; C = NULL$ ; CALL MY.SPECIAL.SUBROUTINE (A, B, C) ; CRT A-: : A ; CRT B-: : B ; CRT C-: C ; END For when I want to know the results of a BASIC statement: BPTEST CRT TRIM('Now is the time', ' ', 'A') For when I want to do something from a proc (like update something): PQ C-- C-- Create the new file C-- RI RO C-- HBPTEST $OPTIONS EXT ; H PORT.ACCT = FIELD(OCONV('', 'U50BB'), ' ', 3) ; H TclCmd = \LOGTO MyAccount, MyPasswd\ ; H TclCmd-1 = \CREATE-FILE SERVICES 1 7\; H EXECUTE TclCmd CAPTURING OUTPUT; H PORT.USER = PORT.USER1,1 H PORT.ACCT = FIELD(PORT.WHO, ' ', A.POS) H PORT.ACCT = PORT.ACCT1,1 P C-- C-- End of job Hope this is of some use. Someone asked me: why use anything else?. So I don't. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stu Glancy Sent: Wednesday, October 20, 2004 9:49 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UD] running a subroutine Criticisms for Mark: Your concept won't work if there are commons that need to be set in the calling program. However, with the use of named commons they can be set in a test program and then use your print which includes the $INCLUDE file named.commons in the command line. (For those who don't know, named commons remain in memory between programs and can be used again until you logout.) Bill H. wrote: Mark: The program at http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest doesn't even have these limitations. This wiki has some pretty nice free programs. I like to take the non-mvDbms attitude: it's free so use it. :-) We should all post our free programs there. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Wednesday, October 20, 2004 5:54 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UD] running a subroutine [snipped] In fact, I welcome any criticisms or limitations anyone would have against establishing this PRINT command to handle everything. I know of 2 limits: 1) No hanging ELSE or THENs. 2) Cannot use READNEXT. Other than that I'm all ears. My 3 cents. - Original Message - From: Peter Olson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 8:43 AM Subject: RE: [U2] [UD] running a subroutine but i want more! found it! 0001: PQ 0002: HSELECT 0003: H EVAL SUBR(' 0004: A\2 0005: H', 0006: A3 0007: H ) FROM VOC FIRST 1; 0008: P now it's tclTS AGE.DATE -2224,42 Cool thanks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Shawn: There's a program on the wiki that allows you to execute BASIC code from a tcl line. http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest This is an extremely useful program and will do exactly what you want, and a bunch of other things as well. It was originally written for UniData, then for UniVerse, then for D3. So an example would be: :BPTEST Value1 = Hello ; Value2 = There. ; CALL subr.name (Value1, Value2) ; END Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Friday, October 15, 2004 4:59 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: wIntegrate
Less: To install the wIntegrate host programs do the following: 1) open a wIntegrate session and log onto the host computer 2) get to tcl (raw tcl) 3) click on Run Script... 4) select the Host folder where the wIntegrate client is installed 5) select inst_pgm.wis and continue from there. Before doing this I would always create a separate wIntegrate account. Then create the appropriate 'Q' pointer to the WIN.PROGS file, from the production account, and catalog all of the WIN.PROGS. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Less, Mirwaan (MIRW) Sent: Thursday, October 07, 2004 4:53 AM To: [EMAIL PROTECTED] Subject: [U2] RE: wIntegrate Hi All We are trying to import data from our host server to a web interface. I read in the wIntegrate documents some part needs to be installed on the server, but no where it actually explains how to do this. Can anyone please advise? We're running Unidata 6.0.3 on Unix AIX 4.3.3. Regards, Mirwaan --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fancy Printer
Mark: A typical D3 solution is to: 1) sp-assign 2) sp-open 3) print PCL5 escape sequences 4) print report 5) print PCL5 ending sequences (usually [Esc]+E) 6) sp-close 7) sp-assign Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Tuesday, October 05, 2004 10:57 PM To: [EMAIL PROTECTED] Subject: [U2] Fancy Printer Two printer questions: First, any recommendations on a multiple paper printer. For example, the first page would be tray 1 with a letterhead, Page 2 would be a form using tray 2 and pages 3,4,5 etc would be tray 3 having white paper. Have a working knowledge of HP PCL (5/6) I just don't know which printer could handle this kind of output. If the printer could staple the pages together, it would be that much better. I've seen copy machines with this kind of magic. I'm just looking for some direction in choosing a printer. Second, sort of for D3. Are there any repetitive printer strings that could be send to the printer that precedes the actual output for each hold file. I'm dancing with a few clients having medium HP printers and the same report comes out landscape or portrait depending on the previous output (pick or word documents etc). I would like to either precede the output with an ESC E to clear to the defaults or actually force the default continuously. Presently I'm managing each report program by hand but there should be a more global solution. These are Laserjet Series 6's. I don't have this problem on HP 2000 series. Thanks in advance. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fancy Printer
Bruce: D3 has always had an excellent solution. They create a printer device item just like they do a terminal device. When we do a: CRT @(-3):@(-13):HELLO:@(-14) for a terminal we can do: PRINT @(-143):The printer has been initialized and is in landscape mode.:@(-110) This would have been great of all the mvDbms players had implemented it. Oh well Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bruce Nichol Sent: Wednesday, October 06, 2004 3:01 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Fancy Printer At 22:29 06/10/04, you wrote: That's roughly the approach I've been taking. The problem is to interject these lines into the dozens, maybe hundreds of reports either in English or Basic that are scattered throughout the procs in the application. Too bad you cannot have an 'initiation string' that hayes modems had to preceed the output. Asked for, and made the Pick Systems list of things to do in , I think, 1998... Heard nothing since. That's progress With UV on Windows, we've used Page Separators or SETPTR ...GUI, FONTNAME, FONTSIZE for years... *nix, I have no idea thanks. - Original Message - From: Bill H. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 6:28 AM Subject: RE: [U2] Fancy Printer Mark: A typical D3 solution is to: 1) sp-assign 2) sp-open 3) print PCL5 escape sequences 4) print report 5) print PCL5 ending sequences (usually [Esc]+E) 6) sp-close 7) sp-assign Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Tuesday, October 05, 2004 10:57 PM To: [EMAIL PROTECTED] Subject: [U2] Fancy Printer Two printer questions: First, any recommendations on a multiple paper printer. For example, the first page would be tray 1 with a letterhead, Page 2 would be a form using tray 2 and pages 3,4,5 etc would be tray 3 having white paper. Have a working knowledge of HP PCL (5/6) I just don't know which printer could handle this kind of output. If the printer could staple the pages together, it would be that much better. I've seen copy machines with this kind of magic. I'm just looking for some direction in choosing a printer. Second, sort of for D3. Are there any repetitive printer strings that could be send to the printer that precedes the actual output for each hold file. I'm dancing with a few clients having medium HP printers and the same report comes out landscape or portrait depending on the previous output (pick or word documents etc). I would like to either precede the output with an ESC E to clear to the defaults or actually force the default continuously. Presently I'm managing each report program by hand but there should be a more global solution. These are Laserjet Series 6's. I don't have this problem on HP 2000 series. Thanks in advance. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.271 / Virus Database: 264.10.0 - Release Date: 05/10/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.271 / Virus Database: 264.10.0 - Release Date: 05/10/04 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
FW: [U2] RE: U2 User's Group Charter
-Original Message- From: Bill H. [mailto:[EMAIL PROTECTED] Sent: Saturday, September 25, 2004 3:42 PM To: [EMAIL PROTECTED] Subject: RE: [U2] RE: U2 User's Group Charter Will: I have just a few comments. Generally, my comments have to do with the Board. It has always been my view that the Board should be elected annually. Good Board members are almost always re-elected in non-profits. However, if one wants to get rid of a Board member it is much easier to simply vote them out rather than taking extreme and difficult measures. Secondly, the Board should always have the authority to constitute themselves by appointing officers. There is no need for the membership to be involved with such matters as this is every much a Board matter as say when and where to conduct their meetings. I probably missed a few things but I hope you find this useful. :-) Bill ARTICLE III - MEMBERS Section 2: Membership Term. Membership is granted for one year with sufficient grace period for renewal, unless terminated as described in Section 5 (Termination of Membership). Section 5: Termination of Membership. Membership may be terminated in the following manners: 1) A member may allow their membership to lapse by not renewing (paying dues), 2) A member may remove themselves from membership in the Group by following instructions provided in the policies and procedures document, 3) The Board of Directors may remove anyone from membership in the Group, without cause, by a two-thirds majority vote of all eligible Board members, The Board of Directors will then notify the member of their termination and the terms, if any, under which the individual may re-apply for membership. In no event will the member be entitled to any refund of previously paid dues or assessments upon termination, or thereafter. Section 6: Member Rights. Each member has the right to vote: 1) to annually elect members of the Board of Directors, 2) to remove any member of the Board of Directors. 3) in any membership polling efforts, 4) to approve the annual budget, 5) to approve non-budget expenditures, and 6) to amend the Charter. Members also have the right to comment on any issue presented by the Board of Directors. ARTICLE V - BOARD OF DIRECTORS Section 1: Composition. The Board of Directors (the Board) consists of 9 members elected annually by the majority of the membership voting. A Board member must also be a member of the organization. If a Board member resigns their membership in the organization then they also resign as a Board member. Section 2: Officers. The Board of Directors shall elect the following officers: 1) the President, 2) the Vice President, 3) the Treasurer, and 4) the Secretary A majority vote of the board is required to confirm the appointments, such vote to take place at the first meeting of the Board after the annual election of Board members by the membership. Section 4: Terms of Office. All members of the Board of Directors are elected for one-year terms. All Board Members will remain in office until their replacements are duly elected and able to assume their duties. Section 5: Eligibility. Candidates for the Board must be members, and must have an interest in the U2 product line. All Candidates must provide a brief Biography to be included on the ballot. The Biography must declare if the Candidate has a financial interest in or is an employee of either the Vendor or the Vendor competitors. Section 6: Nominations. All nominees must accept their nomination and meet eligibility requirements to be considered for placement on the ballot. Any member may nominate them self for board member. The Nominations and Elections Committee will conduct the election according to the procedures described here and in the policies and procedures document. A member of the Board will serve as the Nominations and Elections Committee Coordinator. The election cycle begins with a Nomination Period, 60 days prior to the annual membership meeting. During this period, members may submit to the Nominations and Elections Committee nominations for any vacant position. Nominations must be submitted according to the rules in the policies and procedures document. The Nominations and Elections Committee will receive nominations, verify the eligibility of each candidate and confirm that the candidate is willing to be considered for the nominated position and serve if elected. After nominations have closed, 30 days prior to the annual membership meeting, the Nominations and Elections Committee will gather brief biographies of each candidate. The candidate should provide information about his or her relationship to the U2 community, including any potential conflicts of interest. These biographies will be sent to the membership as part of the ballot for the ensuing election. The Nominations and Elections Committee
RE: [U2] mvBase spooler
Mark: I'm surprised you say this. The only issue I've found with the D3 spooler is it uses a hybrid D3 file to store the output instead of allowing spooler jobs to be configured to go to an O/S directory. MvBase it's an R83 extension from Mentor and probably only exists because D3NT couldn't get it right for 10 years. So, it is what you expect. In D3 one doesn't have to deal with multiple files or runoff or loosing control characters when using the simple sp-edit command options (b, c, k)...but of course mvBase does (I'm pretty sure). Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Saturday, September 18, 2004 6:27 AM To: [EMAIL PROTECTED] Subject: Re: [U2] mvBase spooler I work with U2 and non U2 MV's (MVBase, D3, MCD, most natives) and SP-EDIT is a pain. It's so old school it's a shame D3/MVBase still use it in its Jurrasic Pick incarnation. Don't get me started on all the combinations of options to handle any problems. One of the manuals even refers to it as Spooler Warfare. I have a utility that converts any SP-EDIT hold file to a file-level item for easy editing. It uses the SP-EDIT spool=F option. Some systems create multiple records and others assemble them into one. These file-level items are RUNOFF records. Thus to re-print the hold file with any changes your system must have RUNOFF. If not, you can remove the embedded simple RUNOFF commands (lines that start with a period) and just convert them to form-feeds. I think _HOLD_ matches lines to the SETPTR settings and may not have char(12)'s. The filename that you *are* looking for is called PEQS and while you can type LISTspacePEQS the data isn't really usable data. That's why they have LISTPEQS. I also have a utility that emulates the SP-JOBS of Microdata which I believe is the best spooler manager. It only replicates the SP-JOBS of hold-file management and not SP-STATUS of device management. That is a real different thing on native versus network versions of D3/MvBase. Hopefully this helps. Mark Johnson - Original Message - From: Allen E. Elwood (CA) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 17, 2004 7:43 PM Subject: [U2] mvBase spooler Does anybody know in a Raining data mvBase system, *is* there a file for the spooled jobs, and if so, what the name might be? I really truly hate SP-EDIT and have a spooler that I wrote for Unidata that I would like to port over. Allen E. Elwood Senior Programmer Analyst Direct (818) 361-5251 Fax(818) 361-5251 Cell(818) 359-8162 Home (818) 361-7217 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mvBase spooler
Allen: The command you're looking for is LISTPEQS (with no space in it). I think that's where you're having trouble. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood (CA) Sent: Saturday, September 18, 2004 8:55 AM To: [EMAIL PROTECTED] Subject: RE: [U2] mvBase spooler Hi Mark, I can twiddle bits with the best of them, but I have to have a target. LIST PEQS just returns [10] FILE NAME MISSING Sigh.. After using Unidata in different flavors/incarnations since 1992 working with a native pick system is certainly a challenge. I'll look up the doc's on the -F option and see if that will help me see things better. The main problem I'm having is that my print job which is one of those PAGE x OF xx PAGES where you stick all the header and detail lines into a print buffer as you count the total number of pages, is doing a page break every 24 lines and the frustration of dealing with SP-EDIT is certainly not helping. Got an end of the month deadline and my program goes nutso. Whoopee! Now, really, this is so simple. I think the O/S is helping me by adding in extra page breaks. I've checked TERM and printer output is set to 132,60. I think I'll just run around the house pulling my hair out for a while, and then maybe set in the corner and go quietly insane ;-) PrintTheInvoice: EXECUTE TERM ; *test stmt INPUT DUH.ME ; *test stmt PRINTER ON PRINT.COUNT = DCOUNT(PB,@AM) FOR AEE = 1 TO PRINT.COUNT LNO = PB1 DEL PB1 IF LNO[1,3] = '*#*' THEN LNO.LN = LEN(LNO) - 3 LNO= LNO[4,LNO.LN] PRINT LNO:PAGE.COUNT END ELSE PRINT LNO END NEXT AEE PRINTER OFF RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Saturday, September 18, 2004 06:27 To: [EMAIL PROTECTED] Subject: Re: [U2] mvBase spooler I work with U2 and non U2 MV's (MVBase, D3, MCD, most natives) and SP-EDIT is a pain. It's so old school it's a shame D3/MVBase still use it in its Jurrasic Pick incarnation. Don't get me started on all the combinations of options to handle any problems. One of the manuals even refers to it as Spooler Warfare. I have a utility that converts any SP-EDIT hold file to a file-level item for easy editing. It uses the SP-EDIT spool=F option. Some systems create multiple records and others assemble them into one. These file-level items are RUNOFF records. Thus to re-print the hold file with any changes your system must have RUNOFF. If not, you can remove the embedded simple RUNOFF commands (lines that start with a period) and just convert them to form-feeds. I think _HOLD_ matches lines to the SETPTR settings and may not have char(12)'s. The filename that you *are* looking for is called PEQS and while you can type LISTspacePEQS the data isn't really usable data. That's why they have LISTPEQS. I also have a utility that emulates the SP-JOBS of Microdata which I believe is the best spooler manager. It only replicates the SP-JOBS of hold-file management and not SP-STATUS of device management. That is a real different thing on native versus network versions of D3/MvBase. Hopefully this helps. Mark Johnson - Original Message - From: Allen E. Elwood (CA) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 17, 2004 7:43 PM Subject: [U2] mvBase spooler Does anybody know in a Raining data mvBase system, *is* there a file for the spooled jobs, and if so, what the name might be? I really truly hate SP-EDIT and have a spooler that I wrote for Unidata that I would like to port over. Allen E. Elwood Senior Programmer Analyst Direct (818) 361-5251 Fax(818) 361-5251 Cell(818) 359-8162 Home (818) 361-7217 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field
Allen: For an F correlative: First value (a number of ways but this will work): 002 9 008 F;9R Last value: 002 9 008 F;9;P;S;_ Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood (CA) Sent: Wednesday, September 01, 2004 12:05 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Correlative referencing multi-value field in another file Hi Rod, I too have had the 'pleasure' of F and A correlatives. Once upon a time, a nice man named Dick Pick, who created Pick basic, issued a challenge. He said that there was no way in native Pick to access the last value of a multivalued field and challenged anyone to find a way. Enter Me. 'A' correlatives were new at that time and I created a three step dict. Dict step1 converted value marks into 1 's. Dict step2 summed those 1's into a number, and Dict step3 used that sum as an index for the value and BINGO last value of a multivalued field in native Pick! I did the 'victory dance' big time while singing feeling stronger from the Rocky movies :-D !!! And then proceeded to pack up my solution and send the results to Dick. Dick replied to me that the challenge was only for F correlatives (ahh, shucks..) but that he would publish my solution since nobody else had ever done so yet. Publish as in paper before the internet became widely used. So, that was my 15 seconds of fame Today, I prefer SUBR type dicts over all else if it takes me more than a couple of seconds to try to figure out what to do. However, I'm currently working for a client with a..Legacy Pick system without SUBR's. gaa... Allen --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Secure connex from outside world
Dawn: AccuTerm has SSH and it works great. This is probably your best solution if the outside contractors are developing on UD. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Davis, Dawn Sent: Friday, August 20, 2004 7:04 AM To: [EMAIL PROTECTED] Subject: [U2] Secure connex from outside world Greetings to all. For those of you who are UNIX/UNIDATA/DATATEL clients, how have you handled the following situation? We have a need for outside contractors to access our server to do some development work. I will only accept a secure connection, and therefore wish to use SSH. Which emulator are you using? I have successfully used Putty at the unix/unidata level, but can never get the DATATEL screens to display correctly. I am looking for a free client. Dawn Janel Davis DBA II [EMAIL PROTECTED] (410) 386-8058 Carroll Community College 1601 Washington Road Westminster, MD 21157 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Mark: I concur with Ross. AccuTerm offers _very_ reasonable site licensing; I think it's something like $995 unlimited users. In fact, so much so I'd wonder why anyone would use wIntegrate at a large site. However, wIntegrate has: 1) Query Builder 2) Cuts and pastes way faster and AccuTerm has: 1) Significantly better terminal emulation (width beyond 132) 2) Multiple open sessions within the same instance 3) Much nicer cut-n-paste capabilities (cut paste @15,10 - 72,20) 4) Friendlier interface with user (at least for me) 5) The best darned site license price available. This is, however, a quick overview excluding programming capabilities, but I believe AccuTerm has tremendous scriting capabilities. To check out some of the nifty functionality available check out: http://www.asent.com/technical.html Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Sent: Wednesday, August 11, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Wintegrate Does it HAVE to be Wintegrate ? AccuTerm offer very reasonable site licences Ross Ferris Stamina Software Visage an Evolution in Software Development From: [EMAIL PROTECTED] on behalf of Mark Johnson Sent: Wed 11/08/2004 05:48 To: [EMAIL PROTECTED] Subject: [U2] Wintegrate Being U2 and Wintegrate are intimately related, anyone have any hints on any dealers/VAR's that can offer a reasonable discount on 20 licenses. $4,000 is a huge amount of money to pay for this as an emulator and from what I've gathered, there's no site licenses. Wintegrate 98 is acceptable. 5.0 has server based thin clients which is unnecessary. The main attraction for Wintegrate is its virtually invisible ability to send emails using the local client. A side by side comparison of it and Accuterm illustrates Wintegrates ease at many of the MV-PC functionality. This email thing is huge. I've tried sendmail and BLAT which are fine but WIN.MLSEND beats them all. Please keep the replies as Wintegrate. Thanks. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Dave: 1) AccuTerm supports U2 device licensing. I knew that. 2) Up to 160 columns I knew that. 3) The paste speed in AccuTerm is deliberately throttled down to accommodate serial connections. The speed can be adjusted in Tools-Settings-File Transfer. Change the ASCII interline delay. Zero is OK for telnet or ssh, except on AIX (on AIX try 25 or 50). I'm so happy!! :-) Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 www.sysmarkinfo.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Sorry Tony. It was a beautiful day in the Pacific Northwest and I couldn't help reminding us all of the generalized useless nature of Congressional edicts. :-) When the dust settles I suspect it'll be like the year 2000 problem; by 2004 noone can remember it. :-) (gota add those smileys) As always, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Thursday, August 05, 2004 8:51 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [OT] Sarbanes-Oxley My friend, we rarely disagree, even on these points. I've made no such assumptions about rationality, actual vs intended effects, nor the competence of those sponsoring laws. I only stated the possible effect the new laws will have on people worldwide. Are you responding to someone else's comments?? If my intent wasn't clear, please let me know. Nothing worse than being admonished for thinking something that never occurred to you. :) Tony Bill H. wrote: Tony: You make large assumptions: 1) Congressional lawmaking is rational 2) Laws passed don't have the opposite effect from intended 3) Those sponsoring laws have a clue what they're doing. When it comes to Congress, the less they do the better. :-) Tony Gravagno wrote nothing of the sort: [snip - go check] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Susan: See the thing is, we're letting the auditors drive this thing. Auditors don't drive this. Auditing is basic procedures plus statistical sampling of transactions to validate these basic procedures. Politics drive this. As Thomas Sowell often notes: politics does what feels good at the moment and mostly has _NO_ connection to results. Don't get me wrong, they have to, to a certain extent. The Sarbanes-Oxley Act of 2002 (available in its entirety at Sarbanes-oxley.com) isn't really very specific about HOW the numbers are verified. Only, in a nutshell, that the CFO and CEO sign off saying I KNOW that the numbers on our financial statement are correct. Now because they can go to jail if it turns out they aren't they are in a bit of a panic. And they haven't a clue what to do about it. It has always surprised me that corporate management could delegate their authority over corporate financial reporting to outside auditors. But then Congress does it every day. Heck, they don't even know how much they spend and what they spend it on. :-) But they want to make sure that its CLEAR AND OBVIOUS that they've 'done diligence'. In step the auditors. Now the auditors - for the most part, let's be fair - don't know all that much about the inner workings of a large company's IT department and the mechanics and shenanigans that put that final number on the 10K. So they come up with a lot of (sometimes unnecessary) hoops for us to jump through. I'd suggest there are other forces at work here. For instance, if IT knows so little about business reporting, just as Finance knows so little about IT, is it any wonder what gets reported can be suspect? My point is there are more powerful arguments for structural ineffectiveness rather than some surreptitious human behavior. Besides, one controls human behavior by instituting institutional structural controls. :-) What can we do about it? Well, first, we have to realize that we've got this powerful, flexible environment which has nurtured a seat-of-the pants attitude. Not a bad thing, I mean we can produce amazing results on the fly. We've learned to depend on ourselves that way. But it might look a little scary to an outsider contemplating jail time. So we might have to suck it up just a little and say okay, we're going to be slowed down a bit by this. Perhape a realization that strict financial controls shouldn't be ignored because: a) noone knows how, b) IT controls the systems and doesn't understand the problem, or c) Finance understands the problem and can't control the systems. And then the next thing we do is realize that the slow-down should truly be temporary. While we work out procedures that work and get used to them its going to slow us down. But believe it or not over time the fire-fighting will slow down and we'll get time back. I promise. I suspect this is good for those companies who don't do this now. For those that implement proper controls there shouldn't be much change, except when the lawyers get involved. Then - it would be a really powerful thing if we educated ourselves a bit (see this months article in Spectrum on CobIT) and took the reins. Make sure some if this gi-hyoogic investment is going to give Us something WE want. If we come to management with a clear picture of how we can comply we can set aside some of the hoops. Kind of like the blind leading the blind. :-) I have one colleague whose auditors are demanding a full table/chart of all access to all files by all programs. Hey that would be a cool thing to have. But trust me, its not required for SOX compliance. Its just the auditors trying to come up with ways that look nice and black-and-white and legitimate and compliant. If somebody over there had proposed the - realistic steps - that needed to be taken first, this would never have happened. If someone would do a little reading and then stand up and say here's a plan the requirement in question would be scrapped in a heartbeat. The management, who are putting their necks on the line, so to speak, should be able to do what they think is necessary. The real difficulty is management are being hired who don't know how to judge the quality their business operations and activities. This is a primary cause of what you are seeing. The consequences of this are far reaching, economincally speaking of course. [snipped] What SOX really is? A giant budget-boost for IT and a guaranteed tech-onomic recovery. And incidentally an opportunity for us to raise the bar on our software quality. Gosh, possibly even legitimize Multivalue once and for all! Ever the optimist,. As Bill and Ted always saidexcellent! :-) Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] combining licenses [ot]
Ross: AccuTerm 2K2 has a checkbox for U2 device licensing. I suspect this works otherwise it wouldn't be there. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of bruce nichol Sent: Thursday, July 29, 2004 8:33 PM To: [EMAIL PROTECTED] Subject: RE: [U2] combining licenses [ot] Goo'day, Ross, AFAIK, device licencing is tied to Dynamic Connect, wIntegrate and, I think, Redback, ie, all the IBM stuff... My understanding is that if anybody else wants to get on the bandwagon, they've got to approach IBM But then again, I could be proven w..w..wrong... At 12:19 30/07/04, you wrote: Does anyone know if the device licencing (aka enterprise licence I think) will work with any telnet client (eg: we use AccuTerm), or if it is tied to wIntegrate If I understand the licencing model correctly, does this also mean/imply that with the workgroup sized sites, each of the max 24 users in a workgroup operates with device licencing is that correct ? Ross Ferris Stamina Software Visage an Evolution in Software Development [snipped] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] (UV) Analyze.shm -s (Unclassified)
Karl: Not to butt in and add something stupid, but I notice this happening a lot when ftp is executing on the same machine. Other services can have the same impact. Hope this helps, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Karl L Pearson Sent: Wednesday, July 21, 2004 9:15 AM To: u2-users Subject: Re: [U2] (UV) Analyze.shm -s (Unclassified) On Wed, 2004-07-21 at 03:24, Martin Phillips wrote: We may also be looking for the wrong thing here. A semaphore collision count of 6 really is nothing to get excited over, especially if the system had been up for a while. Looking back to Karl's original posting, I think we need to know a bit more about how the performance hits exhibit themsleves. I've done a bit of checking and came to the conclusion that IO was NOT an issue, as both disks loads are very even and in the low teens to low 20%-ile of use. I changed the uniVerse tunable FSEMNUM from 23 to 53. Today, so far, the load average is in the low 2s instead of in the 3s and 4s. Of course we only have 30 of 42 users, so time will tell... The symptoms of the performance problem is that users notice things going very slowly, especially selects and sorts, but also when typing text there are pauses of parts of a second to a couple seconds when the system is very sluggish. -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate keep-alives
Andy: Thanks. What I've been doing is using AccuTerm. It has keepalives both in it's telnet and ssh. In fact, if it wasn't for wIntegrate's query builder I'd never use it. :-) Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Moore Sent: Friday, July 09, 2004 1:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate keep-alives DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Bill, We use wintegrate and on some of our sites we too have the issue of dropping connections (if no activity for 1 minute!). I normally get around this by either pinging the server in a loop from the Dos command prompt while using wintegrate ( ping xx.xx.xx.xx -t ). If this is no good, how about a small program that does something daft like a listu every 30 seconds or something? -Original Message- From: Bill H. [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 19:37 To: [EMAIL PROTECTED] Subject: [U2] wIntegrate keep-alives Does wIntegrate have any facility to send keep-alives, like AccuTerm does, in order to avoid the inevitible over the internet? Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] wIntegrate keep-alives
Does wIntegrate have any facility to send keep-alives, like AccuTerm does, in order to avoid the inevitible over the internet? Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] problems with XP and PE
Dave: So, this must be a permissions thing? Was you XP Pro installed clean or an upgrade? What permissions did it have if it was an upgrade? What permissions did you set it as? Maybe you should open all permissions of the directory where UD is installed (assuming you installed it in its own directory). Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Tod Sigafoos Sent: Friday, July 02, 2004 6:50 PM To: [EMAIL PROTECTED] Subject: Re[2]: [U2] problems with XP and PE Dennis, It appears to work on my XPHome machine. I am currently trying to get it to work on my HP laptop with XPPro. It is the Pro box that is not working. Friday, July 2, 2004, 2:05:01 AM, you wrote: DB XPHome cannot run anything that requires you to login as DB administrator, DB as you cannot login as administrator unless you do so from DB safe mode, DB and safe mode won't allow you to do anything! DB XP Pro is more lenient DB In your first post you said XP Pro DB In the last one you said XP Home DB which is it? -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ If patriotism has to precipitate us into dishonour, if there is no precipice of inhumanity over which nations and men will not throw themselves, then, why in fact do we go to so much trouble to become, or to remain, human? Jean-Paul Sartre --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Proc
Glen: If you fax it to me I'll type it up into an MS Word document and send it back to you. Bill mailto:[EMAIL PROTECTED] (360)923-4838 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert Sent: Wednesday, June 23, 2004 10:20 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Proc At 12:31 PM 6/23/2004, you wrote: ... Maybe it got that reputation for lack of a good tutorial. Funny thing is I still have in my possession an 18 page PROC tutorial I wrote back in 1986-87 time frame that guides the reader through all the various commands and features to build a functioning PROC. This was originally published by Prime Computer, near the conclusion of my involvement with their PROC processor implementation, so someone with a set of Prime Information manuals will probably have the primer. Too bad I don't have this in an electronic format to share. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Once again and updated. Cheapest way to have Pick talk to Web ?
Will: Try the following: http://www.vex.net/~ross/uv/ Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Sunday, May 23, 2004 6:30 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Re: Once again and updated. Cheapest way to have Pick talk to Web ? [snipped] Any example of exactly how you run UV from CGI-BIN scripts ? Thanks Will --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse in VB .NET
Trevor: I was under the impression the UniOleDB product was not .NET compatible. I have been under the impression that the only thing one could do to make U2 .NET compatible was use either ODBC, fiddle with UniObjects for Java, use Redback, or use the Pick .NET Data Provider. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor McNamara Sent: Thursday, May 20, 2004 9:12 PM To: [EMAIL PROTECTED] Subject: Re: [U2] UniVerse in VB .NET Has anyone ever had the problem i am having? Surly im not the only one? Seems there are a few people out there with UniOLEDB problems with connections. Thanks Trev From: Trevor McNamara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [U2] UniVerse in VB .NET Date: Fri, 21 May 2004 08:06:57 +1000 Hey I am still having thse problems. I have tried to tick/untick and use no username and password as well as just use the username. still nothing gives me the same error. and when i click the test connection button, it wont work either. but the test works fine when i use the username and password. any ideas? Thanks Trev From: Trevor McNamara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [U2] UniVerse in VB .NET Date: Thu, 20 May 2004 19:42:20 +1000 Thanks heaps for that mate, I will give it a go when i am at work tomorrow. Thanks Trev From: Brian Leach [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [U2] UniVerse in VB .NET Date: Thu, 20 May 2004 09:27:23 +0100 Trevor the OleDB connection property pages include two options: one for allowing a blank password and one for saving the password. Neither of these work. You need to connect using a user name that is passworded, and supply the password manually when you open your connection. Regards, Brian On Thu, 20 May 2004 15:58:47 +1000 Trevor McNamara [EMAIL PROTECTED] wrote: Hey, I am having come probs with connecting to UniVerse 10 DB with VB .NET (VS .NET) I I can setup the UCI.SONFIG file fine and the Test Connection works fine. But once i click on Ok to add it i get an error: Unable to connect to database. Died in UCI::SQLConnect() with SQLSTATE IM980, Native error:0 [IBM][SQL Client]Remote password is required. When i click ok it comes up again. Then i click ok again it goes away. Any ideas on how to fix this? Thanks Trev _ Personalise your mobile chart ringtones and polyphonics. Go to http://ringtones.com.au/ninemsn/control?page=/ninemsn/main.jsp --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. ___ _ 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.u2ug.org/listinfo/u2-users _ SEEK: Now with over 50,000 dream jobs! Click here: http://ninemsn.seek.com.au?hotmail --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users _ Personalise your mobile chart ringtones and polyphonics. Go to http://ringtones.com.au/ninemsn/control?page=/ninemsn/main.jsp --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users _ FOXTEL Digital - Your ticket to cinema at home: http://ad.au.doubleclick.net/clk;7718915;9123289;x?http://www.foxt el.com.au/Campaign/channelchoice.html --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] A CHALLENGE!
Jeremy: Be nice. :-) Bill -Original Message- From: [EMAIL PROTECTED] sorry guy, but you sort of lost out when you said 'if we can get 5% of the 4 million. that's b.s. and you know it. You have no business plan, a stupid idea and one of the worst gimicks i have ever seen. stop trying to cheat people and go make an honest living. Everyone on this list has worked hard for their knowledge and you are just trying to exploit it. First, to the moderator. If this is not the place to do this, tell me now and I will cease immediately or direct me to where I am authorized to do this. [snipped] --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse on Linux
LeRoi: Try the following: http://members.aol.com/_ht_a/mbtraining/tidevsys.html http://www.jes.com/pubs.html I have a few books on the subject (they're old and out of print). They are: + The Pick Perspective + Programming w/IBM PC Basic The Pick Database System + Pick for Professionals (Advanced methods techniques) + Exploring the Pick Operating System I wonder why these books can't be pdf'd and posted somewhere and downloaded for $5.00 each (credit card only). :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LeRoi Keiller Sent: Thursday, May 20, 2004 8:18 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse on Linux You know what's weird though (unless I'm wrong) - it's near impossible to find any tutorials on UniVerse. Documentation yes, tutuorials no. But if I am wrong, I would love for someone to give me a tutorial. :o) Ideally, it would be good if U2 (or someone) posted downloadable tutorials on the NET. Cheers, LeRoi -Original Message- From: Piers Angliss [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 May 2004 21:23 To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse on Linux Importance: Low You can download Universe Personal Edition designed for exactly that (ie not a production system) See http://www-306.ibm.com/software/data/u2/universe/ You will find documentation in the same place. I don't know for certain whether it runs Ok on fedora but others will post if not Good luck Piers --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users 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 on +61 3 9291 1600. 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. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse in VB .NET
Colin: Thanks for the info...sorry for providing the list with misinformation. :-( I noticed that UniObjects for .NET is under development and is due for release sometime in mid 2004. Also, the calls to U2 from .NET use SQL not the U2 query language or a READ-type extraction. There's been a lot of traffic here about the difficulties of setting up UniObjects and UniOleDB for use by .NET. I didn't really think it couldn't be done, just not by a challenged individual such as myself. :-) I've seen IBM presentations about their intent to link U2 to .NET and those products are expected to be available in mid to late 2004 (the current set of products were not sufficient). I don't believe that for an MV developer, building an SQL layer to access and update MV data is the optimal MV solution. The PDP.NET product seems to be in the right direction and I assume IBMs forthcoming .NET solution(s) for U2 will be similar. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, May 21, 2004 9:11 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse in VB .NET Not true. See www.ibm.com/software/u2 there is a link to a White paper: Using IBM U2 and Microsoft .NET. or for those too lazy to look through the page: ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/ibmu2-microsoft net.pdf hth -- Colin Alfke Calgary, Alberta Canada -Original Message- From: Bill H. [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 9:54 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse in VB .NET Trevor: I was under the impression the UniOleDB product was not .NET compatible. I have been under the impression that the only thing one could do to make U2 .NET compatible was use either ODBC, fiddle with UniObjects for Java, use Redback, or use the Pick .NET Data Provider. Bill --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] My company is complaining about the U2 emails
Ray: I'm stunned, reading such a comment. :-) Bill -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod Sent: Friday, May 14, 2004 11:16 PM To: [EMAIL PROTECTED] Subject: Re: [U2] My company is complaining about the U2 emails [snipped] ...Given that Andra's company is in Texas, which is notorious for conservative thinking, ... --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] SPACE character ignored
Charles: D3 behaves like: :bptest x = '1' ; y = '1 ' ; if x = y then crt equals else crt doesn't equal BpTest*845955170 . [820] Creating FlashBASIC Object ( Level 0 ) ... [241] Successful compile! 3 frame(s) used. doesn't equal Hope this helps Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Wednesday, May 12, 2004 9:55 PM To: [EMAIL PROTECTED] Subject: RE: [U2] SPACE character ignored Do both UV UD behave exactly the same in this regard? How about D3 the other MV-related systems? cds -Original Message- X = '1' Y = '1 ';* note the trailing space character X = Y is true snip --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Mark: Pardon being a D3 question but someone may have run into this before. My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and 003=P, saved it and then type BOB at TCL and get [3] VERB?. There are no PQN procs in D3 (I don't believe). Change field 001 to PQ. I type LIST CUSTOMER and get output but when I type LIST MD = CUSTOMER I get nothing. I'm not sure what's up since CUSTOMER is a file (or q pointer) and should reside in the MD. When you say you ...get nothing what do you mean (let's see the command and the result). I've found out that there's 2 MD's. One called MD which points to that accounts SYSTEM defined space and another called M/DICT which points to another account that contains the cataloged programs, filenames, verbs etc and lets BOB work. That's unusual. Usually the MD MD item is a q pointer to the current account and so is the MD M/DICT item. They're synonyms. There must be specific reasons to change that structure and I'm not going to guess. I'm not sure what you mean by the ...SYSTEM defined space but I'd guess you mean it points to the current account like: MD 'MD' size = 116 01 q 02 03 04 05 06 07 08 09 l 10 17 11 12 13 14 15 16 17 the item.id of a dictionary item is the name of the language element being defined. So my question is what would happen if I made MD point to that other account? Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to try this. I'd suggest you NEVER mess with this as someone else has made the change for some reason. Normally the M/DICT item is a synonym to MD but is changed for some unknown reason. In D3, you can reference another accounts MD by simply referencing ACCOUNT,, or ACCOUNT,MD,. If the M/DICT item has changed I'd think there is a reference to M/DICT somewhere but won't guess where. I can't say for sure, but when you execute a verb the MD is searched first. I don't know if the M/DICT is searched next or at all. So, either the M/DICT MD item is inconsequential or it acts a little like a PATH. Maybe a posting to CDP would answer this. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users