RE: [U2] Unidata SQL Joins
craig.cauchi wrote: Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Has anyone tried the UNIOLEB driver? Among standard FileOpen, ReadU, and dynamic array operations, mv.NET has the ability to work with MV data using commands that are familiar to SQL users: Select, Insert, Update, Delete. And it does this without going through the ODBC/OleDB server. The field references are DICT definitions and the syntax is mostly standard Access/UniQuery. An enhancement which is coming very soon allows more SQL-like queries which will facilitate MV DBMS access for people who are more familiar with relational databases. So to answer your first question, as of sometime next month mv.NET should qualify as a candidate for your consideration. As to the second question, one of my Universe clients had a lot of issues with the ODBC and OleDB server. Long story short, IBM was unable to help. They have not had any issues since switching to mv.NET.YMMV HTH Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] CAll Stack
It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CAll Stack
In universe I get it like this: CMD = 'PORT.STATUS PORT ':@USER.NO:' LAYER.STACK ' EXECUTE CMD CAPTURING TEXT -- mats Andrew Lakeland wrote: It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
In UV there is an undocumented SYSTEM value, 9001, that you can query to get your own call stack. CRT SYSTEM(9001) It's stored in multi-valued format though so you'll need to do a bit of processing to make it look pretty. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland Sent: 07 February 2006 10:32 To: u2-users@listserver.u2ug.org Subject: [U2] CAll Stack It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
I once wrote a wraparound to the savelist commands which datestamps the lists on creation and use. Also allows the user to flag a savelist as one that should not be overwritten or deleted. A purge program allows them to purge out savelists that are no longer necessary or haven't been accessed in a given period of time. Really helps keep the items in that file down. But, like Jeff Butera said, colleges especially might need to keep lists around for a while and this really helped some of our schools manage that. -Dianne Jeffrey Butera wrote: On Monday 06 February 2006 09:51, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Savedlists should never be re-used. By their very nature they are ephemeral. The above statement is application specific and not always true, particularly colleges running Unidata (Datatel). Yes, we do purge _HOLD_ and other things out but savedlists are generally held. Many institutions (for research purposes) may used savedlists for cohort tracking across many semesters or years. In these situations you *cannot* recreate the savedlist everytime as you have to ensure the group you initially select is the same group used months/years later - savedlists give you an easy method to acheive this (whereas the various data fields you may query against are constantly changing). With the myraid of reports colleges need (both internal and federally mandated IPEDS, etc) savedlists provide an extremely useful tool. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
Whilst we're on the subject, has anyone compiled a list of these 'undocumented' system() values? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell Sent: 07 February 2006 11:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] CAll Stack In UV there is an undocumented SYSTEM value, 9001, that you can query to get your own call stack. CRT SYSTEM(9001) It's stored in multi-valued format though so you'll need to do a bit of processing to make it look pretty. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland Sent: 07 February 2006 10:32 To: u2-users@listserver.u2ug.org Subject: [U2] CAll Stack It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata XML
Well, just off the top of my head, from stuff I've been working on at home... help = variable HELP = constant Help = Class or Method These naming conventions are optional, but they are conventions. And that's just in python. -- Dave Walker The only reason some people get lost in thought is because it's unfamiliar territory. Paul Fix -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Monday, February 06, 2006 5:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata XML Well, so U2 is having the same problems with casing the rest of us do when interfacing with outside systems. It never ceases to amaze me that some believe Help, HELP, and help __SHOULDN'T__ mean the same thing. I can always tell I'm accessing a unix web server when I try to access a directory, under the root directory, and I type the case of that directory incorrectly. e.g. http://www.consumerreports.org/Cro/Home.htm doesn't work while http://www.consumerreports.org/cro/home.htm does. This particular problem doesn't exist on Windows servers and I was caught by it when my son was trying to track down some information for his homework. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 06, 2006 11:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata XML There are some notes in the latest readme for the HTTP functions which explains the proper casing in the different versions. My guess is that the XML functions have the same problem - different cases in different versions. The last couple of examples I've seen from IBM using these have all come with the statement that you have to compile them with the -I option. Hth Colin Alfke Calgary, Canada -Original Message- From: jbutera I originally wrote about a compilation error with: X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: The compiler is seeing what you're defining as functions as matrixes. Which means that you've got a more basic problem 'cause you're not trying to use matrixes. You need to somehow define the subroutines/functions you're trying to use. Funny solution here - In Unidata 6.1.4, I have to enter these function names in uppsercase to compile cleanly (although the document indicates these are case-sensitive). After uppercasing everything, it compiles cleanly. Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CAll Stack
Hi andy, Seems you can do this in universe using system but perhaps not unidata Rgds Symeon On 2/7/06, Brian Leach [EMAIL PROTECTED] wrote: Whilst we're on the subject, has anyone compiled a list of these 'undocumented' system() values? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell Sent: 07 February 2006 11:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] CAll Stack In UV there is an undocumented SYSTEM value, 9001, that you can query to get your own call stack. CRT SYSTEM(9001) It's stored in multi-valued format though so you'll need to do a bit of processing to make it look pretty. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland Sent: 07 February 2006 10:32 To: u2-users@listserver.u2ug.org Subject: [U2] CAll Stack It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
In UD I believe it's SYSTEM(49), although I'm prepared to stand corrected by someone that actually uses it :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen Sent: 07 February 2006 14:37 To: u2-users@listserver.u2ug.org Subject: Re: [U2] CAll Stack Hi andy, Seems you can do this in universe using system but perhaps not unidata Rgds Symeon On 2/7/06, Brian Leach [EMAIL PROTECTED] wrote: Whilst we're on the subject, has anyone compiled a list of these 'undocumented' system() values? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell Sent: 07 February 2006 11:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] CAll Stack In UV there is an undocumented SYSTEM value, 9001, that you can query to get your own call stack. CRT SYSTEM(9001) It's stored in multi-valued format though so you'll need to do a bit of processing to make it look pretty. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland Sent: 07 February 2006 10:32 To: u2-users@listserver.u2ug.org Subject: [U2] CAll Stack It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
From: Brian Leach Whilst we're on the subject, has anyone compiled a list of these 'undocumented' system() values? I've been stashing away the SYSTEM()-related emails from this list for a few years now. Maybe its time to compile them and submit it as a paper for U2UG. I'll at least find my own posting about SYSTEM(9001) re-post that here. Charles Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Subject: [UV] SYSTEM(9001) tells you what program you are in where you came from! From:Stevenson, Charles ([EMAIL PROTECTED]) Date:03/20/03 After whining about this for, lo, these many years let me be quick to praise the Universe team for giving us this. This will be a wonderful debugging tool! UV 10.0.6 Patchlist says: 2621 The UniVerse BASIC SYSTEM(9001) function now returns the @LEVEL in correct order, and returns correct addresses. SYSTEM(9001) will return a dynamic array that contains roughly the same info that PORT.STATUS LAYER.STACK or RAID T command coughs up. Here is a sample subroutine that displays the data and a dummy program that calls it. Then from the menu, I get to pseudo-TCL and execute the dummy program. CT CDS.BP SYS9001 DUMMY SYS9001 0001 SUBROUTINE SYS9001 0002 CRT Depth Executing.. Address 0003 S = SYSTEM(9001) 0004 FOR A = 1 TO COUNT( S, @AM ) 0005 CRT SA,1 4R##: : SA,2 40L#40: SA,3 0006 NEXT A 0007 CRT QUOTE( S ) 0008 RETURN DUMMY 0001 CALL SYS9001 ED VOC LIST 8 lines long. : XEQ RUN CDS.BP DUMMY Executing the command RUN CDS.BP DUMMY. Depth Executing.. Address 3: CDS.BP.O/SYS90010x6 2: CDS.BP.O/DUMMY 0x0 1: /dbms/uv/catdir/*UVPRINTMSG 0x4b40 0: /dbms/uv/catdir/-MATBLOCK 0x0 -1: /dbms/uv/catdir/-PERMISSIONS0x0 -2: /dbms/uv/catdir/-GET.FILE.NAME 0x0 -3: /dbms/uv/BP.O/ED.B 0x0 3}CDS.BP.O/SYS9001}0x6~2}CDS.BP.O/DUMMY}0x0~1}/dbms/uv/catdir/*UVPRINTM SG}0x4b40~0}/dbms/uv/catdir/-MATBLOCK}0x0~-1}/dbms/uv/catdir/-PERMISSION S}0x0~-2}/dbms/uv/catdir/-GET.FILE.NAME}0x0~-3}/dbms/uv/BP.O/ED.B}0x0~ One caution: the data is turned 90 degrees from the conventional way MV data is handled (?what were they thinking?) - Value 1 of each attribute is the depth in the return stack, The non-negative numbers mean that those programs are all part of the return stack. The negative numbers below simply mean those subroutines were called and returned from in the past. I don't think @LEVEL has anything to do with it, contrary to the patchlist text. That's as much as I've figured out so far. - Value 2 is the program - Value 3 is the hex address (the obj address you see when you VLIST a program) For the negative depths, n/a. (0x0 on DUMMY is real. They are small programs.) - The number of values is constant, the number of attributes grows or shrinks. Oh well. SYSTEM(9001) is not in the 10.0 doc set that came with my upgrade pack from IBM, so I figured after all the complaining I have done I at least owe this post. Thank-you LeRoy company, Charles Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CAll Stack
Symeon Breen wrote on 02/07/2006 09:37:24 AM: Seems you can do this in universe using system but perhaps not unidata SYSTEM(49) does this for UniData. If call stack means the command-line stack history, that's in SYSTEM(52). Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata SQL Joins
Hello Andy, Please give us a call at FusionWare. FusionWare purchased all the Data Access products from GA Express and is a new company with the original people from Liberty Integration. Now that's quite a trail to follow. I guess what I am saying is we have the technology and people to help you move your mv data from a relational or direct perspective. Our number is 1.866.266.2326 x159 Look forward to talking to you Janet Bond -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Monday, February 06, 2006 6:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata SQL Joins Andy, I just contacted DataMystic, the folks at Crystal Software, and they have updated the page you referenced. It still listed GA Express and Ardent. Now it lists Fusionware and IBM. Thanks for pointing me to it so I could suggest the changes to them. Andy Pflueger wrote: Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Perhaps this link would be of some help: http://www.crystalsoftware.com.au/datapipe/odbc_vendors.html -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
I've not run into this before but from what you have listed, I'd be looking at what file the write attempt is being performed on. If it's not the SYS.MESSAGE file, which it probably is not, then I'd be looking at how the file open's are being done. I'd suspect the file handle variable being used on line 317 and 382 is no longer the file you think it is. Something to check for, anyway. You might be able to do a display of the file handle variable in the ON.ABORT segment of your program. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 2:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
1) What is the platform - *nix or Windows? 2) If *nix, what are the owner/group/permissions on the file? Proper for all users of this program? 3) Is the file distributed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 3:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/252 - Release Date: 2/6/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SYS.MESSAGE file being corrupted
Bob/Kevin the platform is Windows 2000 and its a dynamic file passed in through a subroutine. ie CALL *SUB(FILE1,FILE2) I have checked for it being clobbered and we do not refer to SYS.MESSAGE so i cant see how this could happen I have tried writing test programs to get the same error message but without success jak - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 08, 2006 11:08 AM Subject: RE: [U2] SYS.MESSAGE file being corrupted I've not run into this before but from what you have listed, I'd be looking at what file the write attempt is being performed on. If it's not the SYS.MESSAGE file, which it probably is not, then I'd be looking at how the file open's are being done. I'd suspect the file handle variable being used on line 317 and 382 is no longer the file you think it is. Something to check for, anyway. You might be able to do a display of the file handle variable in the ON.ABORT segment of your program. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 2:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/253 - Release Date: 7/02/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SB directory files
Anybody ever run into a problem with SB+ being unable to read directory files, Type 1 19? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
Hi John, In our system, we have a subroutine that opens files and places the file handle information in a dimensioned array. When the subroutine is called, it first checks the array to see if it's already been opened. If it has, the handle information is passed back without having done an actual open. If the file is not already in the list, an open is done and it's added to the array then the newly opened handle information is passed back to the calling subroutine. If you have this same type of environment, then my comments would be in reference to the array getting clobbered and passing back bad information for a file which is a pointer that ends up going to the SYS.MESSAGES file instead of the intended file. Normally I would assume that this would only end up with records being written but it's something to check for. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SYS.MESSAGE file being corrupted Bob/Kevin the platform is Windows 2000 and its a dynamic file passed in through a subroutine. ie CALL *SUB(FILE1,FILE2) I have checked for it being clobbered and we do not refer to SYS.MESSAGE so i cant see how this could happen I have tried writing test programs to get the same error message but without success jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
JAK, Further to BobW's post, do you have INCLUDE statements in the program with in-line comments attached ie $INCLUDE INC.FILE INC.RECORD ;* Comment here As this will corrupt the line numbers, that is you need to add the number of include lines with in-line comments to the line number reported to get to the correct line. Regards, Stew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, 8 February 2006 10:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SYS.MESSAGE file being corrupted I've not run into this before but from what you have listed, I'd be looking at what file the write attempt is being performed on. If it's not the SYS.MESSAGE file, which it probably is not, then I'd be looking at how the file open's are being done. I'd suspect the file handle variable being used on line 317 and 382 is no longer the file you think it is. Something to check for, anyway. You might be able to do a display of the file handle variable in the ON.ABORT segment of your program. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 2:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SYS.MESSAGE file being corrupted
Bob, i dont have anything as sophisticated as that. I am opening up the file in the main program and passing it through to the subroutine. I dont understand how a file pointer could end up referencing SYS.MESSAGE though when the application software never references it. Thanks for the suggestion though. jak - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 08, 2006 12:15 PM Subject: RE: [U2] SYS.MESSAGE file being corrupted Hi John, In our system, we have a subroutine that opens files and places the file handle information in a dimensioned array. When the subroutine is called, it first checks the array to see if it's already been opened. If it has, the handle information is passed back without having done an actual open. If the file is not already in the list, an open is done and it's added to the array then the newly opened handle information is passed back to the calling subroutine. If you have this same type of environment, then my comments would be in reference to the array getting clobbered and passing back bad information for a file which is a pointer that ends up going to the SYS.MESSAGES file instead of the intended file. Normally I would assume that this would only end up with records being written but it's something to check for. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SYS.MESSAGE file being corrupted Bob/Kevin the platform is Windows 2000 and its a dynamic file passed in through a subroutine. ie CALL *SUB(FILE1,FILE2) I have checked for it being clobbered and we do not refer to SYS.MESSAGE so i cant see how this could happen I have tried writing test programs to get the same error message but without success jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/253 - Release Date: 7/02/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
From: John Kent Has anyone experienced the above and have an explanation Maybe. Except SYS.MESSAGE wasn't being corrupted, but rather text from SYS.MESSAGE was corrupting other data files. It this what you mean? I think I have the dubious honour of finding it first (at least IBM seemed to not know about it yet), about two years ago. Nov 23, 2005 release notes for 10.1.16 say it has a fix: 7883 In certain circumstances, UniVerse may have incorrectly written information from the SYS.MESSAGE file into other files. This may have caused the header or a primary group of the file to be overwritten, resulting in file corruption. This problem has been fixed. I was running Transaction Logging (TxLg) on UV 10.0.16, HPUX 11i when logging crashed. In it's aftermath, IBM found a piece of SYS.MESSAGES in a broken data file. Another TxLg crash yielded a piece of what should have been written to a COMO file (from a job that recycled used TxLg logfiles). I have assumed the two are related. I have seen some postings at indexinfocus but no resolution. I whined and complained on this list in Summer 2004, and at the IBM Las Vegas conference. John, did you find other postings besides mine? The above release note, is the next I heard of any progress on the subject. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. Were you using TxLg? The quick fix was to make the file read only. My quick fix was to turn of TxLg. (It is supposed to make the system more robust, but we experienced our only crashes because of Transaction Logging. My humourless management was not consoled by the irony.) [snip] I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I could not reproduce the problem on our test system and we turned off TxLging in production. [snip] Any suggestions appreciated jak I need to find out if they think the COMO write to the wrong file is also solved. Before your post no one has ever mentioned to me that anyone else has ever experienced this. The release notes say nothing about TxLg. The release notes say nothing about COMO or other files besides SYS.MESSAGES. Has anyone seen anything like this with other files? Charles Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB directory files
Yes. Under Windows particularly if the item ID has a * or any other forbidden filename characters in the key, reads and writes will fail. Actually, I remember writes failing, but at the moment I'm not particularly certain reads failed also because I couldn't get any data in the file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, February 07, 2006 5:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB directory files Anybody ever run into a problem with SB+ being unable to read directory files, Type 1 19? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/252 - Release Date: 2/6/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
That's the UV message file, right? You're actually seeing the message corrupted? Or do you have a program that is doing like a STOP 201 ?? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB directory files
This would be AIX. Would question marks cause this? Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SYS.MESSAGE file being corrupted
Kevin, thats correct. You replace the file with a copy and all is ok. I sent 3 copies of the corrupted file to IBM and they confirmed that it is Universe writing to the file but i dont know why. jak - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 08, 2006 12:47 PM Subject: RE: [U2] SYS.MESSAGE file being corrupted That's the UV message file, right? You're actually seeing the message corrupted? Or do you have a program that is doing like a STOP 201 ?? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/253 - Release Date: 7/02/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SYS.MESSAGE file being corrupted
Stew, we have a large named common in an include but no inline comments and this hasnt been modified for years jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 08, 2006 12:23 PM Subject: RE: [U2] SYS.MESSAGE file being corrupted JAK, Further to BobW's post, do you have INCLUDE statements in the program with in-line comments attached ie $INCLUDE INC.FILE INC.RECORD ;* Comment here As this will corrupt the line numbers, that is you need to add the number of include lines with in-line comments to the line number reported to get to the correct line. Regards, Stew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, 8 February 2006 10:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SYS.MESSAGE file being corrupted I've not run into this before but from what you have listed, I'd be looking at what file the write attempt is being performed on. If it's not the SYS.MESSAGE file, which it probably is not, then I'd be looking at how the file open's are being done. I'd suspect the file handle variable being used on line 317 and 382 is no longer the file you think it is. Something to check for, anyway. You might be able to do a display of the file handle variable in the ON.ABORT segment of your program. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 2:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/253 - Release Date: 7/02/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SYS.MESSAGE file being corrupted
Charles, we dont run transaction logging. THe has been corrupted 3 times in 3 months. I didnt take a copy of the indexinfocus problems but will look again when its up and running. I am guessing that its the edi routine thats causing this problem but the error message suggests that and there is only one read only file on the system that i know of.. If anyone knows how to reproduce those error message i would like to know as i have tried everything i can think of jak - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Cc: John Kent [EMAIL PROTECTED]; Bob Woodward [EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 12:45 PM Subject: RE: [U2] SYS.MESSAGE file being corrupted From: John Kent Has anyone experienced the above and have an explanation Maybe. Except SYS.MESSAGE wasn't being corrupted, but rather text from SYS.MESSAGE was corrupting other data files. It this what you mean? I think I have the dubious honour of finding it first (at least IBM seemed to not know about it yet), about two years ago. Nov 23, 2005 release notes for 10.1.16 say it has a fix: 7883 In certain circumstances, UniVerse may have incorrectly written information from the SYS.MESSAGE file into other files. This may have caused the header or a primary group of the file to be overwritten, resulting in file corruption. This problem has been fixed. I was running Transaction Logging (TxLg) on UV 10.0.16, HPUX 11i when logging crashed. In it's aftermath, IBM found a piece of SYS.MESSAGES in a broken data file. Another TxLg crash yielded a piece of what should have been written to a COMO file (from a job that recycled used TxLg logfiles). I have assumed the two are related. I have seen some postings at indexinfocus but no resolution. I whined and complained on this list in Summer 2004, and at the IBM Las Vegas conference. John, did you find other postings besides mine? The above release note, is the next I heard of any progress on the subject. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. Were you using TxLg? The quick fix was to make the file read only. My quick fix was to turn of TxLg. (It is supposed to make the system more robust, but we experienced our only crashes because of Transaction Logging. My humourless management was not consoled by the irony.) [snip] I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I could not reproduce the problem on our test system and we turned off TxLging in production. [snip] Any suggestions appreciated jak I need to find out if they think the COMO write to the wrong file is also solved. Before your post no one has ever mentioned to me that anyone else has ever experienced this. The release notes say nothing about TxLg. The release notes say nothing about COMO or other files besides SYS.MESSAGES. Has anyone seen anything like this with other files? Charles Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/253 - Release Date: 7/02/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB directory files
On Universe, I would expect yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, February 07, 2006 7:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SB directory files This would be AIX. Would question marks cause this? Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/252 - Release Date: 2/6/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB directory files
Anybody ever run into a problem with SB+ being unable to read directory files, Type 1 19? No problems here, SB+ 5.0.4/UniVerse 10.0.7/AIX 5.1. Type 1 and Type 19 files, a mixed bag of delimiters (think of a character between 0 and 255 - it's probably been used). What specific problems are you having? Stuart ** 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 related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAll Stack
Thanks Guys, 9001 does the trick. If anyone has list of the undocumented system values it would a very interesting read. Re andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell Sent: 07 February 2006 12:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] CAll Stack In UV there is an undocumented SYSTEM value, 9001, that you can query to get your own call stack. CRT SYSTEM(9001) It's stored in multi-valued format though so you'll need to do a bit of processing to make it look pretty. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland Sent: 07 February 2006 10:32 To: u2-users@listserver.u2ug.org Subject: [U2] CAll Stack It's possible to access the call stack from debugger using the T command, anybody know if it's also possible to access it from a basic program. Searched the manuals for call stack but all references point to the debugger. Ta Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Break-on
I have a report I've been running in a Pick environment for years without problems. The data, using ECLTYPE P on UniData, looks like: [UNIDATA] SORT BANKBOOK WITH PLANTNOS = 98009900 AND WITH YRMO = 200411 BY PLANTNOS PLANTNOS TOTAL CURRBAL 22:45:48 Feb 07 2006 1 BANKBOOK... PLNT# CURR BAL. 28*2004119800 57,482.04 9900 -925.00 15*2004119900-64,729.34 = TOTAL -8,172.30 2 records listed One account has two plants associated with it while the other one has only one plant associated with it. On a Pick machine I do the following: [D3] :SSCROLL BANKBOOK WITH PLANTNOS = 98009900 AND WITH YRMO = 200411 BY-EXP PLANTNOS BY ATYPE_ACCTNO BY ATYPE_DESC ID-SUPP PLANTNOS BREAK-ON PNAME0 Totals: 'UV' BNAMES ATYPE_DESCS ATYPE_ACCTNOS TOTAL CURRBAL Command = SORT BANKBOOK 22:52:24 07 Feb 2006 PLNT# Name.. TypeDesc.. GLAcct CURR BAL. 9800 KEY BANK OF CALIFORNIA Checking 4000 57,482.04 - Totals: PAYROLL TRUST ACCOUNT57,482.04 9900 KEY BANK OF CALIFORNIA Checking 4000-64,729.34 9900 KEY BANK OF CALIFORNIA Checking 4000 -925.00 - Totals: PROPERTY MANAGEMENT CORP. -65,654.34 -8,172.30 [405] 3 items listed out of 1089 items. This doesn't even come close to working in UniData; although it works fine in UniVerse. I'm running in ECLTYPE P. It looks like: [UNIDATA] SORT BANKBOOK WITH PLANTNOS = 98009900 AND WITH YRMO = 200411 BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS 'DL' CURRBAL PLNT# CURR BAL. 9800 57,482.04 -925.00 9900-64,729.34 9900 57,482.04 -925.00 3 records listed [UNIVERSE] SORT BANKBOOK BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS DL CURRBAL PLNT# CURR BAL. 9800 57,482.04 9900-64,729.34 9900 -925.00 3 records listed. I've been fiddling with this for quite a while and am obviously missing something. Can anyone help. Thanks. Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
