[U2] Transferring Data for Development
I'm still relatively new to UniVerse so I was hoping for some advice on transferring data for a development copy. We have a client with an AIX system that has Intuit/Activant Eclipse as a front end using and IBM UniVerse as the database. We are hoping to be able to generate a copy of their database on a copy of a Windows based UniVerse database. At present, the servers are disconnected since the AIX is behind their private network and the Windows is on our development server. So far our client has only tried to copy the files and send them to us, which works in some cases. However, it has resulted in errors on various tables such as partfile pointers being cleared, file in use errors, and Unable to stat messages. Is there a defined process for moving data snapshots between servers in UniVerse? Thanks again for any tips, Andrew ... Andrew E. Tegenkamp Director, Systems Integration G3 Systems, Inc. P:540.951.4300 F:540.951.4311 http://www.g3.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Transferring Data for Development
Use uvbackup --Original Message-- From: Andrew E. Tegenkamp Sender: u2-users-boun...@listserver.u2ug.org To: u2-users@listserver.u2ug.org ReplyTo: U2 Users List Subject: [U2] Transferring Data for Development Sent: Feb 15, 2010 7:02 AM I'm still relatively new to UniVerse so I was hoping for some advice on transferring data for a development copy. We have a client with an AIX system that has Intuit/Activant Eclipse as a front end using and IBM UniVerse as the database. We are hoping to be able to generate a copy of their database on a copy of a Windows based UniVerse database. At present, the servers are disconnected since the AIX is behind their private network and the Windows is on our development server. So far our client has only tried to copy the files and send them to us, which works in some cases. However, it has resulted in errors on various tables such as partfile pointers being cleared, file in use errors, and Unable to stat messages. Is there a defined process for moving data snapshots between servers in UniVerse? Thanks again for any tips, Andrew ... Andrew E. Tegenkamp Director, Systems Integration G3 Systems, Inc. P:540.951.4300 F:540.951.4311 http://www.g3.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Sent from my Verizon Wireless BlackBerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV time milliseconds option
When I run this on UV 10.1.18 (windows): $OPTIONS TIME.MILLISECOND STIME = SYSTEM(12) NAP 500 ETIME = SYSTEM(12) DISPLAY STIME DISPLAY ETIME DISPLAY (ETIME-STIME) END I get the output: 40473687 40474187 500 Are you saying you get 1000 when you the same code? rex John Rodgers wrote: We run UniVerse 9.6 on HP-UX We run PICK flavor accounts to accommodate our SB+ applications I am having trouble pinning down the cause of a performance issue so I want to record the progress of program. I need timestamps in milliseconds. I tried the $OPTIONS TIME.MILLISECOND So SYSTEM(12) should return the required value START.TIME = 38694 ;* TIME() START.SYS12 = 38694000 ;* @TIME = 38694 CPU TIME = 17280 ;* from SYSTEM(9) NAP 500 NEW TIME = 38695000 ;* SYSTEM(12) ELAPSE TIME = 1000 ;* SYSTEM(12) - START.SYS12 CPU ELAPSE = 10 That's not right. Without the nap. NEW.TIME is always = START.SYS12 ie = START.TIME : '000' I have tried variation on the theme of $OPTIONS With and without various 'FLAVOR' keywords. What am I missing? Cheers JR John Rodgers MasterPack Project Team Masonite International Tel: (813) 2612396 ext 3036 ___ 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] UV time milliseconds option
I Get the following (1000 as well) UV 10.0.2 on Redhat 9.0 : I 0001= $OPTIONS TIME.MILLISECOND 0002= STIME = SYSTEM(12) 0003= NAP 500 0004= ETIME = SYSTEM(12) 0005= DISPLAY STIME 0006= DISPLAY ETIME 0007= DISPLAY (ETIME-STIME) 0008= END 0009= Bottom at line 8. : FI TESTUV filed in file SOURCE. COMP TESTUV Compiling: Source = 'SOURCE/TESTUV', Object = '/data2/CBS-BLUE/LIB/TESTUV' Compilation Complete. RUN LIB TESTUV 41639000 4164 1000 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Monday, February 15, 2010 11:24 AM To: U2 Users List Subject: Re: [U2] UV time milliseconds option When I run this on UV 10.1.18 (windows): $OPTIONS TIME.MILLISECOND STIME = SYSTEM(12) NAP 500 ETIME = SYSTEM(12) DISPLAY STIME DISPLAY ETIME DISPLAY (ETIME-STIME) END I get the output: 40473687 40474187 500 Are you saying you get 1000 when you the same code? rex John Rodgers wrote: We run UniVerse 9.6 on HP-UX We run PICK flavor accounts to accommodate our SB+ applications I am having trouble pinning down the cause of a performance issue so I want to record the progress of program. I need timestamps in milliseconds. I tried the $OPTIONS TIME.MILLISECOND So SYSTEM(12) should return the required value START.TIME = 38694 ;* TIME() START.SYS12 = 38694000 ;* @TIME = 38694 CPU TIME = 17280 ;* from SYSTEM(9) NAP 500 NEW TIME = 38695000 ;* SYSTEM(12) ELAPSE TIME = 1000 ;* SYSTEM(12) - START.SYS12 CPU ELAPSE = 10 That's not right. Without the nap. NEW.TIME is always = START.SYS12 ie = START.TIME : '000' I have tried variation on the theme of $OPTIONS With and without various 'FLAVOR' keywords. What am I missing? Cheers JR John Rodgers MasterPack Project Team Masonite International Tel: (813) 2612396 ext 3036 ___ 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
[U2] AccuTerm File Transfer
What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
The easiest way using Accuterm is to just PERFORM/EXECUTE an FT. But I'm surprised that Universe/Unidata doesn't support that sort of thing directly. George On Mon, Feb 15, 2010 at 10:35 AM, Kevin King precisonl...@gmail.com wrote: What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- George Smith, Phoenix, AZ Member of the Independent Computer Consultants Association since 1983 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
Hi Kevin, FTPICK is the Accuterm program that transfers a file directly from one mv database to another providing the Accuterm Host programs (including FTPICK) are installed on both databases and you have an Accuterm telnet connection up and running to both databases at the time of transfer. hth, Dave Dave Taylor Sysmark Information Systems, Inc. 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: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, February 15, 2010 9:35 AM Subject: [U2] AccuTerm File Transfer What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ 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] AccuTerm File Transfer
I would agree with the FT subroutines. Although compared to ftp, they are EXTREMELY slow and ineffective for my use on large files, even the non-verifying version. As to why U2 does not 'support' it directly, it is a function that is specific to Accuterm's terminal emulator. It would be impractical for U2 to support all of the terminal emulators that can interface to it. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Smith Sent: Monday, February 15, 2010 12:56 PM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer The easiest way using Accuterm is to just PERFORM/EXECUTE an FT. But I'm surprised that Universe/Unidata doesn't support that sort of thing directly. George On Mon, Feb 15, 2010 at 10:35 AM, Kevin King precisonl...@gmail.com wrote: What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- George Smith, Phoenix, AZ Member of the Independent Computer Consultants Association since 1983 ___ 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] UV time milliseconds option
This pretty much agrees with what I was getting. The answer depends on the level of accuracy provided by the platform and the UniVerse release. If fractions of seconds are not available then the seconds are 'multiplied' by 1000. Dunno how that helps. OCONV(12345,MTS) is not pretty There is a new CONFIG option in the latest releases of UniVerse - 10 and above, I think TIMEACCURACY When this is on TIME() and SYSTEM(12) returns something like 49950.434 Fortunately, OCONV seems to handle the new decimal format. I am still a bit nervous what this is likely to do to our legacy code. This is not something I can turn on when needed. It is an all or nothing. Change it then restart UniVerse. Something else to look out for when upgrading. Thanks to everyone for helping to confirm that I am not hallucinating - this time. John Rodgers MasterPack Project Team Masonite International Tel: (813) 2612396 ext 3036 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Monday, February 15, 2010 11:24 AM To: U2 Users List Subject: Re: [U2] UV time milliseconds option When I run this on UV 10.1.18 (windows): $OPTIONS TIME.MILLISECOND STIME = SYSTEM(12) NAP 500 ETIME = SYSTEM(12) DISPLAY STIME DISPLAY ETIME DISPLAY (ETIME-STIME) END I get the output: 40473687 40474187 500 Are you saying you get 1000 when you the same code? rex John Rodgers wrote: We run UniVerse 9.6 on HP-UX We run PICK flavor accounts to accommodate our SB+ applications I am having trouble pinning down the cause of a performance issue so I want to record the progress of program. I need timestamps in milliseconds. I tried the $OPTIONS TIME.MILLISECOND So SYSTEM(12) should return the required value START.TIME = 38694 ;* TIME() START.SYS12 = 38694000 ;* @TIME = 38694 CPU TIME = 17280 ;* from SYSTEM(9) NAP 500 NEW TIME = 38695000 ;* SYSTEM(12) ELAPSE TIME = 1000 ;* SYSTEM(12) - START.SYS12 CPU ELAPSE = 10 That's not right. Without the nap. NEW.TIME is always = START.SYS12 ie = START.TIME : '000' I have tried variation on the theme of $OPTIONS With and without various 'FLAVOR' keywords. What am I missing? Cheers JR John Rodgers MasterPack Project Team Masonite International Tel: (813) 2612396 ext 3036 ___ 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] AccuTerm File Transfer
We have had this frustration of getting data from one U2 system to another for a number of years. We use to use wIntegrate which uses subroutines similar to AccuTerm, but we did not have another option. We do now. [ad] For 49.00 can copy large files lighting fast using our XLr8Editor. Our Copy/Paste utility uses standard UniObjects for Java so it understands the complexities of U2 files whether Universe or Unidata. The copy utility supports multiple clip boards as well. Additionally you get a Universe and Unidata editor that supports version control, color syntax, code templates, internal search, bookmarks, and local editing to name a few of the functions. Go to www.u2logic.com/tools.html for more information. [/ad] Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, February 15, 2010 11:13 AM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer I would agree with the FT subroutines. Although compared to ftp, they are EXTREMELY slow and ineffective for my use on large files, even the non-verifying version. As to why U2 does not 'support' it directly, it is a function that is specific to Accuterm's terminal emulator. It would be impractical for U2 to support all of the terminal emulators that can interface to it. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Smith Sent: Monday, February 15, 2010 12:56 PM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer The easiest way using Accuterm is to just PERFORM/EXECUTE an FT. But I'm surprised that Universe/Unidata doesn't support that sort of thing directly. George On Mon, Feb 15, 2010 at 10:35 AM, Kevin King precisonl...@gmail.com wrote: What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- George Smith, Phoenix, AZ Member of the Independent Computer Consultants Association since 1983 ___ 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] AccuTerm File Transfer
My reason for asking is that I have a customer using AccuTerm who wants to use my Download Definition tool for SB+. Problem is, the code that transfers a file to a workstation and opens it in Excel was all specialized to SBClient. With the FT advice I can now support AccuTerm for this activity - thanks! -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
You can find the ESCape sequences for transfers documented in AccuTerm menu/Help, then open AccuTerm 2K2 Reference, then AccuTerm Programming. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
I use WED for my editor. Once the file/program is open in WED, you can save a copy any where desired on your workstation. Works great! Thanks! Boyd ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
Tony, I found the escape sequences but the amount of information for downloading an item was woefully insufficient. On Mon, Feb 15, 2010 at 1:14 PM, Parks, Boyd boyd.pa...@mckesson.comwrote: I use WED for my editor. Once the file/program is open in WED, you can save a copy any where desired on your workstation. Works great! Thanks! Boyd ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
U2 does not support third party products directly. If you had your own client written in a u2 interface such as uniobjects then it would be a simple matter. Or use wintegrate or accuterm as the OP is trying to use. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Smith Sent: 15 February 2010 17:56 To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer The easiest way using Accuterm is to just PERFORM/EXECUTE an FT. But I'm surprised that Universe/Unidata doesn't support that sort of thing directly. George On Mon, Feb 15, 2010 at 10:35 AM, Kevin King precisonl...@gmail.com wrote: What's the easiest way to have a program transfer a text file from the host to the workstation using AccuTerm? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- George Smith, Phoenix, AZ Member of the Independent Computer Consultants Association since 1983 ___ 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] AccuTerm File Transfer
From: Kevin King Tony, I found the escape sequences but the amount of information for downloading an item was woefully insufficient. Agreed. Try this, bud: http://www.pickwiki.com/cgi-bin/wiki.pl?AccuTermFileTransfer That demonstrates the DOSSVC utility for moving data to and from MV. If you look at that program in FTBP you'll see it calls subroutine FTS, which you can also use as desired. From there you're down to ESCape sequences, which really aren't bad after you've spent a few minutes and get to that oh I get it point. Best, T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
A possitility is to mount a remote disk from a Windows system into a partition on the Universe server. The Universe program can create its files there. The Windows clients can also mount this file system. - Original Message From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Mon, February 15, 2010 6:31:13 PM Subject: Re: [U2] AccuTerm File Transfer From: Kevin King Tony, I found the escape sequences but the amount of information for downloading an item was woefully insufficient. Agreed. Try this, bud: http://www.pickwiki.com/cgi-bin/wiki.pl?AccuTermFileTransfer That demonstrates the DOSSVC utility for moving data to and from MV. If you look at that program in FTBP you'll see it calls subroutine FTS, which you can also use as desired. From there you're down to ESCape sequences, which really aren't bad after you've spent a few minutes and get to that oh I get it point. Best, T ___ 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] AccuTerm File Transfer
Kevin, As OP suggested, the FT program can be used from the command line. To run from within another program, use the FTX subroutine. Example program: * open and read data to be transfered into ITEM variable. MODE = 'S,K' ;* Send from server to PC using Kermit protocol. FNAME = 'XYZ' ;* Filename on PC. PATH = 'c:\transfer\' ;* aka Windows folder. STAT = '' ;* Will be set if error occurs. CALL FTX(MODE, '', FNAME, PATH, ITEM, '', '', '', '', '', '', STAT) This will send the data in ITEM to the PC with a file name of XYZ in the c:\transfer directory/folder. The PC directory must exist. The following will start the WORDPAD program and display the file. PRINT CHAR(27): CHAR(2): 'wordpad.exe ': PATH: FNAME By changing the mode, you can read the data back into the server and save it, etc. DISCLAIMER! Some of this is from memory so there is no guarantee. See http://www.asent.com/ for more info. Contact Peter Schellenbach, he's been very helpful to me. Good luck, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Is there something wrong with the new wiki?
Hello, I am just trying to access the new wiki on the u2ug.org website, and am having trouble seeing anything. First, without logging in I clicked on the New Wiki link which just re-displayed the home page. After logging in, all I see is what looks to be the toolbar, with links and icons for Home, Wiki Home, Bookmarks, History and the Jump to select field. Does anyone else have this view, or does it work for others? Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users