Re: [U2] How to Extract Selected multivalue colums

2009-11-30 Thread Symeon Breen
Hi - For the split on the number of lines take the same principals you would use in whatever your normal programming language is (I assume you are a programmer) and do the same, ie a counter and a breakpoint. In order to extract specific columns from the table instead of building the pipe

Re: [U2] errlog question

2009-11-30 Thread Anthony W. Youngman
In message ba3c8714a4e42a4fae7e0e551a40b96f03d82...@seisvr-11.sportsendeavors.com, Doug Chanco dcha...@sportsendeavors.com writes Can anyone shed any light on what the below message means? Sun Nov 29 18:08:54 -12729 yavegrt Program CONVERT.BASENUM.SKU.INFO.SORT: Line 221, Message[040037]

Re: [U2] How to Extract Selected multivalue colums

2009-11-30 Thread Israel, John R.
This looks a bit dangerous. It is converting all @AMs and @VMs to pipes. This is assuming that the number of AMs and VMs will be consistent for each REC - a very bad idea in general considering the whole concept of multi-values (and for that matter, multi-attributes). To extract just

[U2] Mapping files.

2009-11-30 Thread Paul Parkinson
I have 2 servers both running Unidata 7.1 on Windows 2003. In an application on server A I want to access data held in an application on server B I have tried the voc entry in the application on serverA 001: F 002: \\serverB\unidata\filename file:///\\serverB\unidata\filename 003:

Re: [U2] [AD] Code Coverage Project

2009-11-30 Thread Brutzman, Bill
Brian Leach has an amazing tool called mvScan... http://www.brianleach.co.uk/pages/mvscan.htm --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, November 27, 2009 1:09 PM To:

Re: [U2] Mapping files.

2009-11-30 Thread Paul Parkinson
Thanks Mas, tried that didn't work Kind Regards Paul Parkinson Director, Ideal Business Services Ltd mob: +1 758 721 4487 (Caribbean) skype: 0161 408 2098 eml: pparkin...@idealnet.co.uk -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Mapping files.

2009-11-30 Thread Raymond P. de Bourbon
Sounds to me like you need NFA (Network File Access).. Unfortunately its licensed separately so may not be included in your current licenses.. Check out the manual: http://www.rocketsoftware.com/u2/epubs/pdf/29921060.pdf Regards Ray -Original Message- From:

[U2] UV Transaction logging

2009-11-30 Thread jpb-u2ug
If you have transaction logging turned on in UniVerse do all changes get logged even those that don't have the code in the programs to start the transaction and commit it? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert

Re: [U2] Mapping files.

2009-11-30 Thread jpb-u2ug
You also have to have Allownfs set to 1 in your configuration and permissions set on the other server so you can use the file. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Parkinson Sent:

Re: [U2] Mapping files.

2009-11-30 Thread Mats Carlid
To bad, I used the same method long time ago. 'The only difference' was that it was universe files on two unix machines ;-) If the gotcha got me ? Sure. -- mats Paul Parkinson skrev: Thanks Mas, tried that didn't work Kind Regards Paul Parkinson Director, Ideal Business Services

Re: [U2] Mapping files.

2009-11-30 Thread Brian Leach
Jerry That's only on UniVerse.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 30 November 2009 4:18 PM To: 'U2 Users List' Subject: Re: [U2] Mapping files. You also have to have Allownfs

Re: [U2] Mapping files.

2009-11-30 Thread Colin Alfke
This works for me: 001: F 002: \\SERVERNAME\UNIDATA\Datadir\FileName 003: \\SERVERNAME\UNIDATA\DictDir\D_FileName Both are ud 7.1.6 one on XP and one on win 2003 (remote) and the D:\unidata dir is shared as unidata. Of course, if it's a DIR file you

Re: [U2] Mapping files.

2009-11-30 Thread Paul Parkinson
Thanks for your help people. I enquired about the licence for NFA and at 2 grand per server I think I'll work around it somehow. I hate being ripped off Kind Regards Paul Parkinson Director, Ideal Business Services Ltd mob: +1 758 721 4487 (Caribbean) skype: 0161 408 2098 eml:

[U2] [AD] Code Coverage Project

2009-11-30 Thread Dan McGrath
It does sound like an amazing tool, but I believe they are completely different. mvScan looks to be a static code analysis tool. -Original Message- Brian Leach has an amazing tool called mvScan... http://www.brianleach.co.uk/pages/mvscan.htm --Bill

Re: [U2] Mapping files.

2009-11-30 Thread Wally Terhune
I wanted to underscore what one other poster mentioned... If you are actively running UniData on two different servers, the only safe way to access a UniData file on the 'other' server is via NFA. The reason for this is that all file access controls (group locks and record locks) are maintained

Re: [U2] Mapping files.

2009-11-30 Thread Paul Parkinson
Thanks for the advice. I am only accessing the data on server A for reading. The only updates that take place are on server A. Kind Regards Paul Parkinson Director, Ideal Business Services Ltd mob: +1 758 721 4487 (Caribbean) skype: 0161 408 2098 eml: pparkin...@idealnet.co.uk -Original

Re: [U2] Mapping files.

2009-11-30 Thread Wally Terhune
You could still get a read error - if the group the record resides in is being updated while you read it from the remote system. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web:

Re: [U2] Mapping files.

2009-11-30 Thread Bill Haskett
Paul: You can't do that in UniData. You can't access a remote UD file via a pointer. You can access a remote directory to access Windows files like: 001: F 002: \\serverB\unidata 003: D_VOC ...assuming this directory has some files (non-UD O/S files) you want access to. In order to treat

Re: [U2] Mapping files.

2009-11-30 Thread Rick Nuckolls
(Speaking from a Universe perspective, but I think the issues are the same.) If you are updating a file on one server, and reading it on another, you will probably encounter structural inconsistencies within groups if you do not use U2 NFA. This is due to the fact that groups could be in the

Re: [U2] Mapping files.

2009-11-30 Thread Bill Haskett
Paul: Sometimes I wonder about their pricing; they don't believe in the little guys. I know D3 used to have this product included (but they don't have a bunch of other things like device licensing). :-( Bill Paul

Re: [U2] errlog question

2009-11-30 Thread Doug Chanco
Thanks everyone! I know that message 040016 is division by zero but I am wondering about the .ITYPE program (is it referring to an I descriptor?) snd pc = 18 part Mon Nov 30 14:18:55 129 lamach Program .ITYPE.: pc = 18, Message[040016] Thanks Dougc -Original Message- From:

Re: [U2] Mapping files.

2009-11-30 Thread David A. Green
Paul, I have done this different ways. 1. Use of directory type files to ftp or os copy them from one server to another and then process the request as they come. You will have to have a copy of phantom batch processes to handle data transfers. 2. Use sockets to talk to each other transferring