Re: [U2] Converting from mvBase to Universe
Hmm, Does this suggest that the UV (or other database) telnet server will be listening on each of these non-standard ports ( the std telnet listening port is 23? In UV, the telnet server port can be changed to any port no. other than 23, but only to one other port no. afaik. From that telnet port no., as Ross said, each user is assigned a PID on which to connect with UV. afaik, mvBase is the only mv database that supports more than one telnet server port, and mvBase ties each telnet server port to one or more (a pool) of mvBase user connections, so this could be done on a onn-to-one basis in mvBase. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Ross Ferris ro...@stamina.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, July 23, 2009 1:21 AM Subject: Re: [U2] Converting from mvBase to Universe A nailed port in this context means that someone initiating a telnet (style) session to a non-standard port (lets say 5123) would ALWAYS be logged in as a fixed/known user number (say user number 123), rather than assigned a pseudo-random PID. By having your terminal emulator setup to use a specific port, you get something akin to the days of serial lines, where a wire from your terminal would always have you coming in on a fixed port (or user) number. Using this, some people (the OP included I'm guessing) would activate features based on this port number. Back in the day our tools were used in a DOD project (SASPers) and some facilities were only available from known/secured locations, as determined by a signal running along a dedicated wire connecting the terminal device the server. So, the nailed telnet port became a mechanism to keep some of these facilities going. Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of regalit...@aol.com Sent: Thursday, 23 July 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Converting from mvBase to Universe Nailing ports on Windows is a critical issue.? IANA port rules specify well-known and registered ports?ports should NOT be used without registration.? At a minimum, a good OS would leave them alone at least for requests for dynamic or random port numbers.? However, Windows will grab ANYTHING above 1024 (including all registered ports)?unless you reserve it in the registry first. One way to do it is to program Windows to just reserve all ports from say 1025 thru 49151 (or another range appropriate for your system). The Dynamic and/or Private Ports as specified by IANA are those from 49152 through 65535.? To reserve ports on Windows, at least on 2003, the doc is here: http://support.microsoft.com/kb/812873/ Hope that helps! Steve... -- Steve Kneizys Author of TMI Open Architecture Listener (IANA port 8300) -Original Message- From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Cc: Curt Stewart cstewa...@earthlink.net Sent: Wed, Jul 22, 2009 11:13 pm Subject: Re: [U2] Converting from mvBase to Universe Curt, RE: nailed ports. After a lot of hair pulling, I solved this problem on Unix but I don't know if it can be done on Windows and certainly not the same way. On Unix, UV uses a file named unohist but IIRC, on Windows, it uses the PID as the port #. I have a couple of ideas so contact me directly and I may be able to help you. Don Robinson donr_w...@yahoo.com From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 5:43:05 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Hi Dave, afaik, mvBase is the only mv database that supports more than one telnet server port, and mvBase ties each telnet server port to one or more (a pool) of mvBase user connections, so this could be done on a one-to-one basis in mvBase. QM can do it too with the PORTMAP configuration parameter. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Hi Martin, Thankyou, that's good to know! Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Martin Phillips martinphill...@ladybridge.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, July 23, 2009 8:13 AM Subject: Re: [U2] Converting from mvBase to Universe Hi Dave, afaik, mvBase is the only mv database that supports more than one telnet server port, and mvBase ties each telnet server port to one or more (a pool) of mvBase user connections, so this could be done on a one-to-one basis in mvBase. QM can do it too with the PORTMAP configuration parameter. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Curt, RE: nailed ports. After a lot of hair pulling, I solved this problem on Unix but I don't know if it can be done on Windows and certainly not the same way. On Unix, UV uses a file named unohist but IIRC, on Windows, it uses the PID as the port #. I have a couple of ideas so contact me directly and I may be able to help you. Don Robinson donr_w...@yahoo.com From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 5:43:05 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Nailing ports on Windows is a critical issue.? IANA port rules specify well-known and registered ports?ports should NOT be used without registration.? At a minimum, a good OS would leave them alone at least for requests for dynamic or random port numbers.? However, Windows will grab ANYTHING above 1024 (including all registered ports)?unless you reserve it in the registry first. One way to do it is to program Windows to just reserve all ports from say 1025 thru 49151 (or another range appropriate for your system). The Dynamic and/or Private Ports as specified by IANA are those from 49152 through 65535.? To reserve ports on Windows, at least on 2003, the doc is here: http://support.microsoft.com/kb/812873/ Hope that helps! Steve... -- Steve Kneizys Author of TMI Open Architecture Listener (IANA port 8300) -Original Message- From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Cc: Curt Stewart cstewa...@earthlink.net Sent: Wed, Jul 22, 2009 11:13 pm Subject: Re: [U2] Converting from mvBase to Universe Curt, RE: nailed ports. After a lot of hair pulling, I solved this problem on Unix but I don't know if it can be done on Windows and certainly not the same way. On Unix, UV uses a file named unohist but IIRC, on Windows, it uses the PID as the port #. I have a couple of ideas so contact me directly and I may be able to help you. Don Robinson donr_w...@yahoo.com From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 5:43:05 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Hi Curt, Two additional thoughts on converting software from mvBase to Universe: 1.Port numbers are assigned randomly (I think) by Universe at the time of logon. I am not aware of any means to lock any particular user into any particular port number. Maybe someone else knows a trick that I don't know. 2.There is no compatibility between the mvBase account-save on tape and Universe, and there is no compatibility between the mvBase virtual accout-save and the Universe virtual uvrestore command. There is a convD3 executable that converts a D3 virtual account-save into a virtual file that can be restored using the Universe uvrestor command, and there may be an mvBase version of that command - eg convmvB - floating around that someone on this list may have. It didn't exist when we did our first conversion so I've never used it. AD For our first conversion from mvBase to Universe, we wrote two programs, TAPE.DUMP and TAPE.LOAD. TAPE.DUMP dumps all the files, dicts and the MD from any mvBase account to tape with a label that contains the parameters necessary to recreate the file on Universe. TAPE.LOAD recreates each dict, data section and the MD on Universe, if necessary, and then loads the contents from the tape into that section on Universe. They do require the use of the same, or two compatible, tape drives on both systems, or on the same system if mvBase and Universe are installed in the same computer. And, there are SCSI connectors that connect to USB ports to support external tape drives on Windows. We provide these two programs at no additional charge, along with SpoolerPlus. You can let me know if you think these programs will be helpful to you. /AD And, finally, there is always Accuterm to migrate data, one-file-at-a-time. Please let me know if you have any other specific questions. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
If your code uses the U50BB user exit to get the port number, there is a quick fix, but it will make upgrades a little more complicated. 50BB is a basic program in the APP.PROGS file in the UV account. You can modify it to send port information based on user login or other criteria. I send information into the 3rd field for program logic and leave the port number and account info alone. -Original Message- From: Curt Stewart [mailto:cstewa...@earthlink.net] Sent: Sunday, July 19, 2009 5:43 PM To: u2-users@listserver.u2ug.org Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
Re: [U2] Converting from mvBase to Universe
I'm not sure what you're asking, Jerry, but this may help. The SP-ASSIGN commands differ in syntax between the generic Pick print spooler and the Reality spooler, as follows: Ex. (Pick® syntax): SP-ASSIGN (options) (copies) F(queuenumber), R(printfilenumber) Ex. (Reality® syntax): SP-ASSIGN = (queuename) (options) (copies) AD SpoolerPlus® supports both of these forms of the SP-ASSIGN command./AD Universe has its own form of SP.ASSIGN (SP-ASSIGN works also) command, and their syntax is slightly different for Universe/nix vs Universe/doz platforms and is unlike both the generic Pick and Reality syntax above. I don't know if there is a difference between the syntax of the Universe SP-ASSIGN command in a Pick-flavor account vs in a Reality-flavor account on the same operating system. There is no indication in the IBM documentation of such difference based on the flavor of the account. In Universe/nix: the documentation states Use SP.ASSIGN to set the line printer spooler options for each of the 256 logical print channels. In Universes/doz: the documentation states Use SP.ASSIGN to set the line printer spooler options for Windows platform. These differences are due to the fact that Universe/nix does have a spooler that provides some ability to manage and control print jobs other than just print them to the printer, where as Universe/doz has no spooler whatsoever and prints directly to the doz printer, after which ofcourse you lose all control over the print job from Universe. In both cases, regardless of the platform, Universe prints to printers, not to queues, and does not support the print architecture used in both Reality and in other generic Pick databases (which afterall began with Reality) of printing to queues and then printing from queues to printers, including all the flexibilty of holding/suppressing/both any print job, redirecting a print job from one printer to another, using the same printer for multiple print jobs with time to change paper before changing queues, listing and managing all print jobs on hold, etc. AD Changing the printing practices of an entire organization, including rewriting printing procecedures, retraining personnel, expanding the number of printers and serial/network connections and network support necessary to implement a far less powerful and flexible print architecture is usually far more costly than the license fee for a complete generic Pick print spooler solution like SpoolerPlus./AD If I didn't anwer your question, please rephrase it so maybe I'll understand it. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Monday, July 20, 2009 9:23 AM Subject: Re: [U2] Converting from mvBase to Universe Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product
Re: [U2] Converting from mvBase to Universe
Hi Dianne, Writing an SP-ASSIGN command to create a SETPTR command is certainly possible, lot of people have done it, but that only send print jobs to printers, not to print queues. It doesn't provide the functionality of a generic Pick print spooler and support for all the spooler architecture and commands associated with that architecture. Universe/nix does have a spooler that provides some ability to manage and control print jobs other than just print them to the printer, where as Universe/doz has no spooler whatsoever and prints directly to the doz printer, after which ofcourse you lose all control over the print job from Universe. In both cases, regardless of the platform, Universe prints to printers, not to queues, and does not support the print architecture used generic Pick databases of printing to queues and then printing from queues to printers, including all the flexibilty of holding/suppressing/both any print job, redirecting a print job from one printer to another, using the same printer for multiple print jobs with time to change paper before changing queues, listing and managing all print jobs on hold, etc. etc. AD Changing the printing practices of an entire organization, including rewriting printing procecedures, retraining personnel, expanding the number of printers and serial/network connections and network support necessary to implement a far less powerful and flexible print architecture is usually far more costly than the license fee for a complete generic Pick print spooler solution like SpoolerPlus and the ongoing support that comes with it./AD Just my .02, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Dianne Ackerman dia...@aptron.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, July 20, 2009 7:23 AM Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion
Re: [U2] Converting from mvBase to Universe
That one is probably SP.ASSIGN - when you use the dash in your command, uv looks first for an entry in the VOC with the dash and if it can't find one, it looks for it with the dot instead. That one does come with uv. -Dianne jpb-u2ug wrote: Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
I'm sorry if I wasn't clear. After looking at what I wrote I can see why but I think you answered my question. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Monday, July 20, 2009 12:10 PM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe I'm not sure what you're asking, Jerry, but this may help. The SP-ASSIGN commands differ in syntax between the generic Pick print spooler and the Reality spooler, as follows: Ex. (PickR syntax): SP-ASSIGN (options) (copies) F(queuenumber), R(printfilenumber) Ex. (RealityR syntax): SP-ASSIGN = (queuename) (options) (copies) AD SpoolerPlusR supports both of these forms of the SP-ASSIGN command./AD Universe has its own form of SP.ASSIGN (SP-ASSIGN works also) command, and their syntax is slightly different for Universe/nix vs Universe/doz platforms and is unlike both the generic Pick and Reality syntax above. I don't know if there is a difference between the syntax of the Universe SP-ASSIGN command in a Pick-flavor account vs in a Reality-flavor account on the same operating system. There is no indication in the IBM documentation of such difference based on the flavor of the account. In Universe/nix: the documentation states Use SP.ASSIGN to set the line printer spooler options for each of the 256 logical print channels. In Universes/doz: the documentation states Use SP.ASSIGN to set the line printer spooler options for Windows platform. These differences are due to the fact that Universe/nix does have a spooler that provides some ability to manage and control print jobs other than just print them to the printer, where as Universe/doz has no spooler whatsoever and prints directly to the doz printer, after which ofcourse you lose all control over the print job from Universe. In both cases, regardless of the platform, Universe prints to printers, not to queues, and does not support the print architecture used in both Reality and in other generic Pick databases (which afterall began with Reality) of printing to queues and then printing from queues to printers, including all the flexibilty of holding/suppressing/both any print job, redirecting a print job from one printer to another, using the same printer for multiple print jobs with time to change paper before changing queues, listing and managing all print jobs on hold, etc. AD Changing the printing practices of an entire organization, including rewriting printing procecedures, retraining personnel, expanding the number of printers and serial/network connections and network support necessary to implement a far less powerful and flexible print architecture is usually far more costly than the license fee for a complete generic Pick print spooler solution like SpoolerPlus./AD If I didn't anwer your question, please rephrase it so maybe I'll understand it. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Monday, July 20, 2009 9:23 AM Subject: Re: [U2] Converting from mvBase to Universe Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you
[U2] Converting from mvBase to Universe
I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users