RE: [UV] Consult about SQL
Hello, Another question Because a SQL query executed in Universe it take 20 seconds and the same query in MSAccess take 3 seconds. This is the result of EXPLAIN of this query SELECT LINFAC.GRUPART, SUM(LINFAC.BASPP * LINFAC.CAN) As SUMCANT, GCAREPRE.NOMBRE AS NOMREPRE, SQL+GCAREPRE.CODIGO AS CODREPRE SQL+FROM SQL+GCAREPRE INNER JOIN GCMCL ON GCAREPRE.CODIGO = GCMCL.CODREP1 SQL+INNER JOIN LINFAC ON [EMAIL PROTECTED] = LINFAC.CODCLI SQL+WHERE LINFAC.EMP = 1 AND SQL+(LINFAC.TIPFAC='01' OR LINFAC.TIPFAC='03' OR LINFAC.TIPFAC='05' OR LINFAC.TIPFAC='06' OR LINFAC.TIPFAC='10') SQL+GROUP BY LINFAC.GRUPART, GCAREPRE.CODIGO, GCAREPRE.NOMBRE HAVING SUM(LINFAC.BASPP*LINFAC.CAN) IS NOT NULL SQL+EXPLAIN; Optimizing query block 0 Table restriction: LINFAC.EMP = 1 AND (LINFAC.TIPFAC = '10' OR (((LINFAC.TIPFAC= '01' OR LINFAC.TIPFAC = '03') OR LINFAC.TIPFAC = '05') OR LINFAC.TIPFAC = '06')) Driver source: LINFAC Access method: file scan 1st join primary: LINFAC est. cost: 30445 secondary: GCMCL est. cost: 23469 type: hashed join (primary key) 2nd join primary: GCMCL est. cost: 23469 secondary: GCAREPRE est. cost: 131 type: hashed join (primary key) Grouped by: GRUPARTCODIGONOMBRE Thanks, -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Ray Wurlod Enviado el: jueves, 01 de abril de 2004 22:44 Para: U2 Users Discussion List Asunto: Re: [UV] Consult about SQL The best way to speed inner joins is to index the column that is the foreign key. For example, if your join is of the form: SELECT T1.ORDERNO, T2.CUSTNO, T2.CUSTNAME FROM ORDERS T1, CUSTOMERS T2 WHERE T1.CUSTNO = T2.CUSTNO ; then you need an index on ORDERS.CUSTNO In other cases, depending on exactly what the query is, you can also sometimes obtain benefit by rewriting the SQL to use sub-queries, unions, and other techniques. - Original Message - From: Cesar Riba [EMAIL PROTECTED] Date: Thu, 1 Apr 2004 11:10:18 +0200 To: [EMAIL PROTECTED] Subject: Consult about SQL Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: DATA statement Clearing?
We have programs that make extensive use of data statements. And they regularly screwed up because people asked us to change the prompt sequence (adding new requests or whatever...) So I've been steadily rewriting them all to use arguments on the command line, retrieving it all from @SENTENCE. One little tip - I always add the option BATCH, which is set by looking for the word on the command line as the program starts. My input code then knows, if this flag is set, that there is no user to ask the information from. And if I'm asked to add more user input, seeing this option in other inputs reminds me that I need to add it here, and provide a default because I'm not allowed to prompt. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl L Pearson Sent: 01 April 2004 18:39 To: U2 Users Discussion List Subject: RE: DATA statement Clearing? You bring up a good point. Design-time decisions seemed to make sense that this would be the easiest way to do this project with the greatest amount of 'after the fact' support freedom, so, reading the data from a file wasn't considered. However, we just had a discussion and decided it wouldn't be that tough to make the change over. CLEARDATA works on uniVerse, too. Thanks. Darn Manuals. Why can't they just talk to me? Karl This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
Acrobat 6, certainly initially, had, well, issues. Something to do with compatibility, and not liking files created by earlier versions. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 02 April 2004 00:24 To: U2 Users Discussion List Subject: RE: PDF Manual [Data typing in MV Basic] -Original Message- Behalf Of Robert Stearns found) unified search facility. The online manuals are great for those times you want an indepth discussion of a topic, or to first learn a subject, but are abysmal (IMNSHO) as a quick reference for a syntax question or a summary. While it has not been updated in a few versions, Get Adobe Reader 6. It is FREE. It has a very _good_ search facility (Ctrl-F). As long as you have installed the manuals with the indexes you can search across all the manuals with a variety of options. the data is sufficient in day to day programming. BTW the current PDF is set up for larger pages (8.5x11 IIRC) so that ehe Kinko solution is not a particlaraly good one, especially since the PDF contains page images (not text) for some down level version (9.? I believe). That is not particularly conducive to reformatting. Poppycock Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniOLEDB setup
Kebbon [EMAIL PROTECTED] wrote... Other consultants who have previously been accessing my Unidata 5.1.3/HP/UX 11.0 data using ODBC are now trying to do it using OLEDB. Everything appears to be set up correctly - that is the UCI Config file (without making any changes from the ODBC setup, I presume) Check C:\IBM\UniDK\Config\uci.config instead of C:\IBM\UniClient\Config\uci.config What with Informix/IBM and unidk/uniclient there's a lot of perms on this one. Simon -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to launch remote browser from UniVerse server? (In Training...)
I will be attending a training session in room 2B. If you require assistance, please page me. Thanks, u2-users 04/02/04 09:44 Does anyone have an example of how to do this if the terminal emulator is QPC Software, QVT/Term? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Polak Sent: Thursday, April 01, 2004 8:17 AM To: U2 Users Discussion List Subject: RE: How to launch remote browser from UniVerse server? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It depends on what you use for a terminal emulator. For Accuterm you need to place something like the following in a Basic program to open IE: PRINT CHAR(27):CHAR(2)::iexplore:CHAR(13): There are numerous ways to get reports to display in the browser. One easy way to start testing is to set up a file that can be accessible by both U2 and mapped to the user's PC. For example create a U2 file called TEMP that is pointing to a location that can be mapped to by the user PC. Map that location to the S:\temp directory. Write your U2 report to the TEMP file with a record name of FILE.NAME. Then un the command: PRINT CHAR(27):CHAR(2)::iexplore S:\temp\:FILE.NAME:CHAR(13): This will load IE with the written data. Once your comfortable with this, you can explore tools like txt2html, txt2pdf, and the U2 print spooler. With these tools you can have a print queue automagically translate a print job into html or pdf and write them out to a file directory. mike - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LeRoi Keiller Sent: Wednesday, March 31, 2004 10:40 PM To: [EMAIL PROTECTED] Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. - -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -BEGIN PGP SIGNATURE- Version: PGP 8.0 iQA/AwUBQGwkcLAst3KQK8kYEQKDogCg0bzg1ozWLQNeh2dYnXbY2fm6kUEAoOFm QDZOX7Cy0/cJqFR+ACkGAPla =oYUN -END PGP SIGNATURE- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
Robert: Thanks for the link. I've been tired of Adobe's slowness for years. If you use the above don't forget to install Acrobat reader speedup from: http://www.tnk-bootblock.co.uk/prods/misc/index.php -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
universe 10.???? - array size
is there a native function that will tell me the size of a dimensioned array ? if not are there any suggestions for something graceful ? Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
universe 10.???? - array size
the array will contain file handles... Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: universe 10.???? - array size
If you want to know from the debugger... Example: ED BP TEST 4 lines long. : P 0001: DIM X(10,15) 0002: MAT X = 0003: DEBUG 0004: PRINT Bottom at line 4. : Q RUN BP TEST TEST: 4: PRINT :: X/ MATRIX: X=10 Y=15 :: If you are trying to get the size of the array within the program, use INMAT()... Example: ED BP TEST 5 lines long. : P 0001: DIM X(10,15) 0002: MAT X = 0003: PRINT 0004: PRINT INMAT(X) 0005: PRINT Bottom at line 5. : FI TEST filed in file BP. RUN BP TEST 10ý15 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: Friday, April 02, 2004 11:14 AM To: U2-Users (E-mail) Subject: universe 10. - array size the array will contain file handles... Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: universe 10.???? - array size
thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn W. Paschal Sent: Friday, April 02, 2004 12:40 PM To: 'U2 Users Discussion List' Subject: RE: universe 10. - array size If you want to know from the debugger... Example: ED BP TEST 4 lines long. : P 0001: DIM X(10,15) 0002: MAT X = 0003: DEBUG 0004: PRINT Bottom at line 4. : Q RUN BP TEST TEST: 4: PRINT :: X/ MATRIX: X=10 Y=15 :: If you are trying to get the size of the array within the program, use INMAT()... Example: ED BP TEST 5 lines long. : P 0001: DIM X(10,15) 0002: MAT X = 0003: PRINT 0004: PRINT INMAT(X) 0005: PRINT Bottom at line 5. : FI TEST filed in file BP. RUN BP TEST 10ý15 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: Friday, April 02, 2004 11:14 AM To: U2-Users (E-mail) Subject: universe 10. - array size the array will contain file handles... Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: universe 10.???? - array size
Pete, In UniBasic, there is a function call INMAT. If memory serves me right, I believe UniVerse has the same function. You might want to check it out. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 -Original Message- From: Peter Olson [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 12:09 PM To: U2-Users (E-mail) Subject: universe 10. - array size is there a native function that will tell me the size of a dimensioned array ? if not are there any suggestions for something graceful ? Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: XML or WORD Format???
In a message dated 4/1/2004 5:40:16 PM Pacific Standard Time, [EMAIL PROTECTED] writes: The resulting documents can be re-purposed with a variety of applications, including word processors and screen reader software. Is re-purposed the same as read because if it is I prefer read Will newspeak Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe Case Sensitivity
This is a bug in Universe 10.1. It's fixed in the 10.1.2 release, which isn't out to the public yet. We've seen it in the Windows and AIX ports, but I don't know if it's in any other ports. If this is a critical issue for you, contact me directly and we can work on getting you a copy of the 10.1.2 release, otherwise, you should wait until the public release. Mike Pflugfelder Systems Integrator Keystone Information Systems 856.722.0700 x238 -Original Message- From: Baruch Salamander [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 2:53 PM To: [EMAIL PROTECTED] Subject: Universe Case Sensitivity I'm using Universe 10.1. How do you get around this without having to retype the line? It doesn't happen all the time...just on specific words. CASE A=Y : R/CASE/IF TCL Case sensitivity is ON [990070] Try HELP. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Consult about SQL
The first thing to notice is that a file scan is being performed on the LINFAC table. This could be speeded with an index on each of the constraining columns LINFAC.EMP and LINFAC.TIPFAC. The inner joins are being performed via hash lookups, the fastest available method. There are 23469 matches between tables LINFAC and GCMCL and 131 matches between GCML and GCAREPRE, based on the join conditions specified. There may be some gain to be had by indexing the foreign key columns LINFAC.CODCLI and GCML.CODREP1. - Original Message - From: Cesar Riba [EMAIL PROTECTED] Date: Fri, 2 Apr 2004 10:37:21 +0200 To: 'U2 Users Discussion List' [EMAIL PROTECTED] Subject: RE: [UV] Consult about SQL Hello, Another question Because a SQL query executed in Universe it take 20 seconds and the same query in MSAccess take 3 seconds. This is the result of EXPLAIN of this query SELECT LINFAC.GRUPART, SUM(LINFAC.BASPP * LINFAC.CAN) As SUMCANT, GCAREPRE.NOMBRE AS NOMREPRE, SQL+GCAREPRE.CODIGO AS CODREPRE SQL+FROM SQL+GCAREPRE INNER JOIN GCMCL ON GCAREPRE.CODIGO = GCMCL.CODREP1 SQL+INNER JOIN LINFAC ON [EMAIL PROTECTED] = LINFAC.CODCLI SQL+WHERE LINFAC.EMP = 1 AND SQL+(LINFAC.TIPFAC='01' OR LINFAC.TIPFAC='03' OR LINFAC.TIPFAC='05' OR LINFAC.TIPFAC='06' OR LINFAC.TIPFAC='10') SQL+GROUP BY LINFAC.GRUPART, GCAREPRE.CODIGO, GCAREPRE.NOMBRE HAVING SUM(LINFAC.BASPP*LINFAC.CAN) IS NOT NULL SQL+EXPLAIN; Optimizing query block 0 Table restriction: LINFAC.EMP = 1 AND (LINFAC.TIPFAC = '10' OR (((LINFAC.TIPFAC= '01' OR LINFAC.TIPFAC = '03') ORLINFAC.TIPFAC = '05') OR LINFAC.TIPFAC = '06')) Driver source: LINFAC Access method: file scan 1st join primary: LINFAC est. cost: 30445 secondary: GCMCL est. cost: 23469 type: hashed join (primary key) 2nd join primary: GCMCL est. cost: 23469 secondary: GCAREPRE est. cost: 131 type: hashed join (primary key) Grouped by: GRUPARTCODIGONOMBRE Thanks, -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Ray Wurlod Enviado el: jueves, 01 de abril de 2004 22:44 Para: U2 Users Discussion List Asunto: Re: [UV] Consult about SQL The best way to speed inner joins is to index the column that is the foreign key. For example, if your join is of the form: SELECT T1.ORDERNO, T2.CUSTNO, T2.CUSTNAME FROM ORDERS T1, CUSTOMERS T2 WHERE T1.CUSTNO = T2.CUSTNO ; then you need an index on ORDERS.CUSTNO In other cases, depending on exactly what the query is, you can also sometimes obtain benefit by rewriting the SQL to use sub-queries, unions, and other techniques. - Original Message - From: Cesar Riba [EMAIL PROTECTED] Date: Thu, 1 Apr 2004 11:10:18 +0200 To: [EMAIL PROTECTED] Subject: Consult about SQL Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to launch remote browser from UniVerse server?
Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:18 PM To: [EMAIL PROTECTED] Subject: Re: How to launch remote browser from UniVerse server? In a message dated 4/2/2004 6:45:47 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Does anyone have an example of how to do this if the terminal emulator is QPC Software, QVT/Term? For Accuterm you need to place something like the following in a Basic program to open IE: PRINT CHAR(27):CHAR(2)::iexplore:CHAR(13): PRINT CHAR(27):CHAR(2)::iexplore S:\temp\:FILE.NAME:CHAR(13): If you are running Universe, D3, or MvBase on Windows, you have other options which are presumtively faster since they are lower level. Can you tell us what your setup is? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two very different requirements for web content. One is to launch a browser so that a human can view, interact, manipulate that window. The other requirement is merely to get the web page contents INTO your MV (Unidata) environment. For this latter requirement, you do not need to launch a browser then scrape it. So would just getting the contents into your app be sufficient? Or do you need the user to interact with the window in some way? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two very different requirements for web content. One is to launch a browser so that a human can view, interact, manipulate that window. The other requirement is merely to get the web page contents INTO your MV (Unidata) environment. For this latter requirement, you do not need to launch a browser then scrape it. So would just getting the contents into your app be sufficient? Or do you need the user to interact with the window in some way? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to launch remote browser from UniVerse server?
I've created the html file from a spooled hold file and placed it in a Samba drive, but the icing on the cake would for the user to generate the file and launch the browser from within the unidata session. QVT/Term Help does not mention anything about launching windows, and the scripts seem limited to starting up QVT/Term sessions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, April 02, 2004 4:39 PM To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two very different requirements for web content. One is to launch a browser so that a human can view, interact, manipulate that window. The other requirement is merely to get the web page contents INTO your MV (Unidata) environment. For this latter requirement, you do not need to launch a browser then scrape it. So would just getting the contents into your app be sufficient? Or do you need the user to interact with the window in some way? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to launch remote browser from UniVerse server?
In a message dated 4/2/2004 5:52:10 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I've created the html file from a spooled hold file and placed it in a Samba drive, but the icing on the cake would for the user to generate the file and launch the browser from within the unidata session. QVT/Term Help does not mention anything about launching windows, and the scripts seem limited to starting up QVT/Term sessions. It may not be a really fully featured emulator. Is there any barrier to moving to Accuterm or Wintegrate? You could at least do a proof-of-concept with one of them and present it to your bean counters to see if they'd go for it. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Quick reference guide
The Universe pdf files for Basic and User Reference both have an appendix A which are quick references grouped according to their uses. These are pages 1169 to 1204 (36) for basic, and pages 857 to 888 (32) for userref. Also, appendix B in the basic pdf is the good old ASCII code table and appendix C is 90 pages on correlative and conversion code (I never knew there was a Q conversion! ...nor NLS ...nor TI - heck!). It would be nice to have these printed out in a lie-flat format... Maybe IBM would let U2U group do this as a little populariser/fund raiser? Although judging by my mother-in-law's church cushion book, it could easily be a fund-lowerer. Regards, Keith. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Running Total- @1?
On Fri, 2 Apr 2004 14:54:14 -0800 , you wrote: LIST CUST EVAL @1+1 CUST.NAME Well OK, I'll 'fess up to being clueless... what is @1? Why does this work? (running UV 9.6.1.3). What other @ variables are left out of my docs? The most common use I've found for @1, @2, etc are within very complex I-Types, where statements are separated by semi-colons. @1 refers to the determined value of the first statement, @2 to the second, etc. What follows is an off the cuff example, meant merely to demonstrate the concept... 0 TAXABLE.YN 1 I 2 IF (STATE EQ CT MA RI) THEN 10 ELSE 0; IF (JOB.CODE EQ 12) THEN 0 ELSE @1; IF (@2 GT 0) THEN Y ELSE N -- Allen Egerton [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
A proposal for extending the MV data structure
Since the list will be closing soon, I thought I'd put up for discussion an idea a friend and I had back in 2000. I put it here partly as a thought provoker, and partly so it doesn't get lost. I had it on Microsoft's community groups, but it never got any traffic so died a death. (By the way, my Outlook spelling check wanted to change Microsoft's to Microfossil's) I'm adding my original stuff to the bottom of this message, and I extended the idea in some thoughts I put up at http://emeraldglenlodge.co.nz/superpick.html. Part of the extension was to point out that if the marks (like attribute marks) were changed to be 9C-9F then there wouldn't be a clash with the characters used in the internet. Even using 0C-0F would work better. Interestingly, having followed the recent threads Dawn has engaged in at comp.databases.theory, I have retreated a bit from my original position. When you think about it, the fact we have (in general) only one level of data 'nesting' means that we don't get a heirachical structure that is difficult to understand as a single conceptual thang. Codd's original paper drew back from having relations within relations, maybe because he didn't consider the Pick idea of limiting the depth of this structure? Anyway, following is the original idea (although maybe calling it SuperPick was a conceit - I could be modest and follow established precedent and call it Johnson) Regards, Keith. SuperPick Copyright Keith Johnson 2000 Background My experience has been as an application programmer using Pick-type databases. Within these all data is represented as an ASCII string using delimiters to separate fields. Pick allows three levels of fields called attributes, values, and sub-values using characters 254, 253 and 252 as the respective delimiters. I was seeking a method of storing data which would be similar, but which could cope with a theoretically unlimited nested structure. This structure would work well for the sort of data I see in my work - names, dates, addresses, money, product codes, etc. It would also convert easily to an XML form, which I see as the coming data interchange format. My colleague Ron Knox, one day came up with the idea that 'brackets' would allow for nesting of any depth. We refined this idea over time into a data structure one that Ron has called Noble (as in, it's not base!). SuperPick is Noble with a data map concept added which allows the data to be easily converted to XML. Considering XML XML itself is interesting and I could see in it Pick-like things, such as repeating fields, but it annoys me to see the verbosity associated with the tag mechanism. In Pick, one describes fields by their position within the record that is, by counting delimiters. From my experience with Pick, parsing out fields for manipulation does not have an adverse effect on performance as long as you try to avoid extremely long strings, and actively code to avoid re-parsing long strings as much as possible. XML, being verbose, would be more vulnerable to that sort of performance problem. The mechanism required to pull a field out of XML is more complex than delimiter counting, as it has to match the tag strings surrounding the field. This is more difficult than it sounds, because tags do not have to be unique. Format of example Described below is a mechanism for storing data - SuperPick . Under this mechanism there is there is the data itself, and a map. Unlike Pick, the map is required. Both map and data are stored as text strings with four special characters file start, file end, record separator, and field separator. In this example I have used the left square bracket as the file start, the right square bracket as the file end, the pipe as the record separator, and the backslash as the field separator that is, []|\ respectively. This is not to say these are the characters that would in fact be used, just that they are clear. The example The map is [Customer\0\file|FirstName\1|LastName\2|CreditLimit\3|OrderEntry\4\file|Orde rID\4,1|OrderDetail\4,2\file|Title\4,2,1| Author\4,2,2|Price\4,2,3] While the data is [Amy\Higginbottom\5000\[16273\[Number, the Language of Science\Danzig\5.95|Tales of Grandpa Cat\Wardlaw, Lee\6.58]]] The map Taking the map first, it consists of a file with ten records. If we put each record on a separate line, we can see that each one is made up of two or three fields. The fields are a name, a position, and a type. The type defaults to a standard one, which may be called generic field Customer\0\file FirstName\1 LastName\2 CreditLimit\3 OrderEntry\4\file OrderID\4,1 OrderDetail\4,2\file Title\4,2,1 Author\4,2,2 Price\4,2,3 The map means that data is held in a file called Customer in four fields. The first three fields are standard ones called FirstName, LastName, and CreditLimit. The fourth is a sub-file called OrderEntry. The OrderEntry sub-file has two fields, the
RE: A proposal for extending the MV data structure
Interesting, Keith. By the way, Berkeley DB Java version just went to beta. I have been looking at how to write an application (using a services architecture) in Java where one could plug in either Berkeley DB or U2 and possibly jBASE or other PICK databases so that it would be database independent and SQL-independent. I certainly hadn't thought about creating a structure such as the one you suggest with the use of the sleepcat databases (Berkeley DB and its siblings), and I'll have to read your suggestion more carefully in the future. I'm surprised you have actually been reading my not-exactly-well-accepted contributions to CDT. I've been on the road for a few weeks and needed to be quiet for a while anyway, but I have several more topics to run past the theory crowd in spite of having to accept the comments about how I must be an idiot ;-) CDT is not nearly as well behaved as u2-users or CDP, for example. As for the u2-users list going away -- it is merely taking a slight turn on its path as you can see by Chuck's (Results) recent e-mail to the group. Onward! --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Shaw and Keith Johnson Sent: Friday, April 02, 2004 7:35 PM To: u2-users Subject: A proposal for extending the MV data structure Since the list will be closing soon, I thought I'd put up for discussion an idea a friend and I had back in 2000. I put it here partly as a thought provoker, and partly so it doesn't get lost. I had it on Microsoft's community groups, but it never got any traffic so died a death. (By the way, my Outlook spelling check wanted to change Microsoft's to Microfossil's) I'm adding my original stuff to the bottom of this message, and I extended the idea in some thoughts I put up at http://emeraldglenlodge.co.nz/superpick.html. Part of the extension was to point out that if the marks (like attribute marks) were changed to be 9C-9F then there wouldn't be a clash with the characters used in the internet. Even using 0C-0F would work better. Interestingly, having followed the recent threads Dawn has engaged in at comp.databases.theory, I have retreated a bit from my original position. When you think about it, the fact we have (in general) only one level of data 'nesting' means that we don't get a heirachical structure that is difficult to understand as a single conceptual thang. Codd's original paper drew back from having relations within relations, maybe because he didn't consider the Pick idea of limiting the depth of this structure? Anyway, following is the original idea (although maybe calling it SuperPick was a conceit - I could be modest and follow established precedent and call it Johnson) Regards, Keith. SuperPick Copyright Keith Johnson 2000 Background My experience has been as an application programmer using Pick-type databases. Within these all data is represented as an ASCII string using delimiters to separate fields. Pick allows three levels of fields called attributes, values, and sub-values using characters 254, 253 and 252 as the respective delimiters. I was seeking a method of storing data which would be similar, but which could cope with a theoretically unlimited nested structure. This structure would work well for the sort of data I see in my work - names, dates, addresses, money, product codes, etc. It would also convert easily to an XML form, which I see as the coming data interchange format. My colleague Ron Knox, one day came up with the idea that 'brackets' would allow for nesting of any depth. We refined this idea over time into a data structure one that Ron has called Noble (as in, it's not base!). SuperPick is Noble with a data map concept added which allows the data to be easily converted to XML. Considering XML XML itself is interesting and I could see in it Pick-like things, such as repeating fields, but it annoys me to see the verbosity associated with the tag mechanism. In Pick, one describes fields by their position within the record that is, by counting delimiters. From my experience with Pick, parsing out fields for manipulation does not have an adverse effect on performance as long as you try to avoid extremely long strings, and actively code to avoid re-parsing long strings as much as possible. XML, being verbose, would be more vulnerable to that sort of performance problem. The mechanism required to pull a field out of XML is more complex than delimiter counting, as it has to match the tag strings surrounding the field. This is more difficult than it sounds, because tags do not have to be unique. Format of example Described below is a mechanism for storing data - SuperPick . Under this mechanism there is there is the data itself, and a map. Unlike Pick, the map is required. Both map and data are stored as text strings with four special characters
Conversions
Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a traditional Order Entry system. I can't seem to convey that difference as management (read: those who don't use the computer) like the GUI and all of the nice links and screens. The worker bees are in a turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and forth as well as the absense of many functions that were present under the MV app. Their productivity has fallen 75% as it takes 4x longer to enter an order. There are no sales tax lookups, no product or customer lookups. You clearly cannot scroll through 35,000 line items. There's no easy alternate shipping addresses and the original reports leave a lot to be desired. The accounting package is appealing but a company doesn't exist just for the accounting dept. Not to mention all the hamburger-helper features i've installed over the last 6.5 years. I also have to fabricate custom reports with Crystal Reports and/or Access as there are many fields of data that should be there like customer back orders, sample customers, customer categories and a whole truckload of sales reporting fields that simply don't exist. Am I wrong in concluding that Great Plains is just a glorified shopping cart application. Has anyone else experienced this kind of mis-match, especially with great plains. At least i could inform the users that others have these growing pains. There doesn't seem to be a light at the end of the tunnel for them. thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Conversions
Mark, As a Business Process Consultant (one of my hats), here's how I would approach it. 1. You are already moving in the correct direction by pointing up productivity loss, but you have to frame the argument correctly: 1. We have implied and explicit deadlines in serving our customers. We will fail to meet them due to lost productivity unless we act now. Acting now will require either major changes to the new system to add critical functions, or a significant increase in staffing (with all the related costs). The first option will take a great deal of time and will be expensive. The second choice will take less time but will permanently decrease profitability by increasing staffing levels for an indefinite period of time. Doing nothing will cost us customers and that decreases revenue. 2. The changes are producing a morale problem. This will resolve itself over time, but combined with the current drop in productivity due to feature loss, it can become a major problem. 2. Understand that management may have reasons other than the pretty GUI: 1. The reporting at *their* level may be perceived as better (it might even be better) in the new system. 2. GUI is much easier for *occasional* users. Managers tend to be occasional users. 3. The business model may bee changing and management hasn't chosen to share the details at your level. The new system may be part of a larger plan. 4. Someone might have bought for non practical reasons: (my son sells this, my competitor has this, my accountant said it was good, etc.) Saying it is bad may become emotional for the person who recommended or authorized the new system. 3. Build details: 1. Get the people (lower mgmt) who are getting hurt to give you stats (we had xxx Orders completed per hour before, now we have yyy). 2. Depending on your audience, you might be better off showing Pie Charts - especially if management thinks GUI is pretty. 4. Be on their side: 1. This sucks, why did you do it is a bad tactic. 2. We are seeing a drop in accuracy and the customers are noticing is much more inclusive. 3. Tone, attitude, and word choices will have a huge effect on your success. 4. Choose your cc:s carefully. Bob the CFO might have taken your side if you'd let him bring the case to the Bill the CEO, but you cc:ed the CEO. Mary the A/P manager might have ignored you, but you cc:ed Alice the A/R manager, so she has to reply and appear clever in her reply. Don't play politics, but don't dare ignore it. If you need more, I'll have to charge you by the hour. :) -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Mark Johnson wrote: Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a traditional Order Entry system. I can't seem to convey that difference as management (read: those who don't use the computer) like the GUI and all of the nice links and screens. The worker bees are in a turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and forth as well as the absense of many functions that were present under the MV app. Their productivity has fallen 75% as it takes 4x longer to enter an order. There are no sales tax lookups, no product or customer lookups. You clearly cannot scroll through 35,000 line items. There's no easy alternate shipping addresses and the original reports leave a lot to be desired. The accounting package is appealing but a company doesn't exist just for the accounting dept. Not to mention all the hamburger-helper features i've installed over the last 6.5 years. I also have to fabricate custom reports with Crystal Reports and/or Access as there are many fields of data that should be there like customer back orders, sample customers, customer categories and a whole truckload of sales reporting fields that simply don't exist. Am I wrong in concluding that Great Plains is just a glorified shopping cart application. Has anyone else experienced this kind of mis-match, especially with great plains. At least i could inform the users that others have these growing pains. There doesn't seem to be a light at the end of the tunnel for them. thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Conversions
You have my sympathy/empathy, and I'm sure that of many others here. I have some thoughts that may seem common sense, but they may be worth mentioning: Document everything. -- Downtime -- Delays -- End-user complaints -- Discussions with management and software vendors -- Missing features, reports, inquiry screens -- Limited access to end-users who should have authorization to access specific data -- Situations where the software forces a change in business practices This is good for many reasons. -- Ass coverage in case someone starts blaming you. -- Good morale for end-users to see you care about their concerns. -- Provides a metric regarding what vendors are doing or not. -- Helps with progress reports for management. -- Helps in tracking cost overruns, It sounds like the company switched over to the new apps cold turkey. That wasn't a good move. Running in tandem is preferred even if it means double entry for a while. It also sounds like the move was made a little too quick, without full understanding of the business requirements or buy-in from the end-users. End-users need to be consulted before-hand and treated as partners during the migration, otherwise you get people gossiping around the watercooler about the clueless computer guys. If they're involved in every step then they can't point fingers either unless they're totally ignored along the way. Running a company isn't a democracy but you don't need a mutiny from the ranks when people start asking why things aren't being done properly anymore. Bottom line here: Listen. If you're caught in the middle and being asked to manage the decisions someone else has handed down then keep channels open and maintain frequent but not annoying dialogs with management and vendors. The last thing you need are inquiries about why didn't we know about this? or how long has this been going on. Keep on top of issues so that you aren't involved in damage control. Have manuals and phone numbers for support handy, identify usenet forums for GP. See if you can get a couple key end-users into classes so that they can front issues before you have to. Create a pseudo first-tier support group out of a few of these people and delegate responsibility. This goes along with the partnering thing - and buy them lunch now and then, they're working overtime here. Encourage all users to report issues to your or your support group immediately so that issues can be resolved rather than sitting on them until they become serious. Some people don't want to make waves and you find out about stuff way too late - like in the middle of closing the month-end. A big issue is, have you been given the authority to do what's required, or have you been given the responsibility without the authority? IT usually gets the latter. If you have authority, keep on top of your support providers and make sure they don't sit on issues. Escallate unresponsiveness to their management and yours as required before technical issues explode on you. If you don't have authority then hopefully you have the ear of someone who does. Once people in a new implementation like this realize that no one is in authority, the feces really strikes the rotary oscillators: Front-line end-users start using words like FUBAR as your project turns into yet another migration horror story for Pick people to smugly enjoy. HTH, Good Luck. Tony Nebula RD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 02, 2004 8:05 PM To: U2 Users Discussion List Subject: Conversions Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Results/Primac are more of a traditional Order Entry system. I can't seem to convey that difference as management (read: those who don't use the computer) like the GUI and all of the nice links and screens. The worker bees are in a turmoil with the increased amount of carpal-tunnel potential mouse/keyboard back and forth as well as the absense of many functions that were present under the MV app. Their productivity has fallen 75% as it takes 4x longer to enter an order. There are no sales tax lookups, no product or customer lookups. You clearly cannot scroll through 35,000 line items. There's no easy alternate shipping addresses and the original reports leave a lot to be desired. The accounting package is appealing but a company doesn't exist just for the accounting dept. Not to mention all the hamburger-helper features i've installed over the last 6.5 years. I also have to fabricate custom reports with Crystal Reports and/or Access as there are many fields of data that should be there like customer back orders, sample customers, customer categories and a
Re: Conversions
Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Conversions
Smooth bro. Real smooth. Excuse us ladies and gentlemen as I escort our colleague out by his ear and smack him around a little. Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
