RE: [U2] Parsippany
They are running Epicor's Avante software. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Lunt Sent: Thursday, June 23, 2005 1:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Parsippany I used to work for Matheson Gas Co. that used Epicor on HP900 with UD. They are based in Parsippany, NJ. I haven't worked with them for many years so I can't say for sure if they are still running the same systems. Bruce Lunt From: Brutzman, Bill [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: [U2] Parsippany Date: Thu, 23 Jun 2005 14:57:46 -0400 There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- 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] Finding last day of month
0001: INPUT DATE 0002: USE.DATE = ICONV(DATE,D) 0003: MTH = OCONV(USE.DATE,DM) 0004: YR = OCONV(USE.DATE,DY4) 0005: IF MTH LT 12 THEN 0006: MTH += 1 0007: END ELSE 0008: MTH = 1 0009: YR += 1 0010: END 0011: NEW.DATE = ICONV(MTH:/01/:YR,D) - 1 0012: CRT OCONV(NEW.DATE,D) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Thursday, June 02, 2005 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Finding last day of month Hi, Given a date like 20040203, I want to return the last valid date for that month and year (20040229 in this case). What is the shortest code fragment to achieve this? At the moment I'm replacing the day with 01, then iconv, add 35 days to the internal date and then oconv and replace the day again with 01. I'm then on the first day of the next month. I then iconv, subtract 1 day and oconv. Thanks for any help. - Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail --- 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] Unique Ids
The person who had the comment has worked in the MV world for how long. The only time I have seen this was when a file was corrupted. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 10:38 AM To: U2 Users List Subject: [U2] Unique Ids I just came out of a meeting where it was stated that MV databases allow non-unique keys. Now I have been working in the VM world since 1983 and although I can remember a time when some of the implementations had 'problems' with hash and specific data in keys .. i can not think of a time when MV tables allowed non-unique keys. 'Say it aint so Joe' .. If anyone knows of any implementation which specifically allows non-unique ids .. please let me know .. show me the light. Have I be in the back room eating twinkies too long? thanks DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] wintegrate query builder question
Which version on wIntegrate and Excel are you using? I have found that it does not work with all versions of Excel. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen Sent: Friday, February 18, 2005 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] wintegrate query builder question I'm an end user and I've developed some queries using Query builder. I been able to get the queries to the screen but I now I want them to be placed into an Excel spread sheet. When I select my output to go to the pc/process and select the program to be excel and I fire my query. I get a error window QueryImport to PC failed Invalid Fields. Any clues to why this is happening? Can anyone give me places an end user can check. I'd like to speak with some confidence before I bring it up with my overly strapped IT department. Any help would be appreciated. Kevin --- 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] getting undefined errors when varible look defined (UV/unix)
Check to see if there is a way to get to TOTAMTTT+OFFSET=TOTAMTTT+OFFSET+IVAL But by pass TOTAMT= Unless we can see the full section of code that deal with it can not specify what is the cause but what causing the error. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Monday, December 20, 2004 2:20 PM To: Ardent List Subject: [U2] getting undefined errors when varible look defined (UV/unix) Here is a snippit of code: ITOT= ; TOTAMT= ; DTOT= ; DTOTAMT= * ITOT=ADVTOT(JPOS3,T) TOTAMT=TOTALS(JPOS3,T) DTOT=DADVTOT(JPOS3,T) DTOTAMT=DTOTALS(JPOS3,T) * ITOTTT+OFFSET=ITOTTT+OFFSET+IVAL TOTAMTTT+OFFSET=TOTAMTTT+OFFSET+IVAL DTOTTT+OFFSET,TQ=DTOTTT+OFFSET,TQ+IVAL DTOTAMTTT+OFFSET,TQ=DTOTAMTTT+OFFSET,TQ+IVAL * ADVTOT(JPOS3,T)=ITOT TOTALS(JPOS3,T)=TOTAMT DADVTOT(JPOS3,T)=DTOT DTOTALS(JPOS3,T)=DTOTAMT when the full program is run I get these: Program SPG-JSPEND-1: Line 762, Variable DTOTAMT previously undefined. Empty string used. Program SPG-JSPEND-1: Line 759, Variable ITOT previously undefined. Empty string used. Program SPG-JSPEND-1: Line 759, Variable ITOT previously undefined. Empty string used. Program SPG-JSPEND-1: Line 760, Variable TOTAMT previously undefined. Empty string used. Program SPG-JSPEND-1: Line 760, Variable TOTAMT previously undefined. Empty string used. Program SPG-JSPEND-1: Line 761, Variable DTOT previously undefined. Empty string used. I'm assuming that nothing is ever been assigned to (JPOS3,T) to cause the error. I trIed using: IF ADVTOT(JPOS3,T)# THEN ITOT=ADVTOT(JPOS3,T) So I then put in a PRINT ADVTOT(JPOS3,T) and on certain number combos I get: Program SPG-JSPEND-1: Line 755, Variable $R196 previously undefined. Empty string used What is $R196? JPOS3 and T were both within the dimension of this array, otherwise I would have received an Array out of bounds error. How can I test for this so I don't get a screen full of the above? George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Un-compiler/Un-Basic UniVerse Basic Code
Does anyone know of a Un-compiler/Un-Basic for UniVerse Basic object code. There is an old program that is running but no source code. Need to see about recovery the source code. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uvodbc truncating field
Look At the dictionary
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills
Sent: Friday, December 03, 2004 8:47 AM
To: [EMAIL PROTECTED]
Subject: [U2] uvodbc truncating field
I've wrote a small program to return a record set of part numbers and
part descriptions.
Then I wrote a data query under MS Excel and ran the SQL process as
follows-
{ CALL TALKTOME (19) }
I get 2 columns returned, the first being the part numbers, but for some
reason the part
descriptions are being chopped at 8 characters.
Here is the subroutine-
0001 SUBROUTINE TALKTOME(CPN)
0002 OPEN ITMMST TO IM ELSE GOTO 99
0003 EXECUTE SELECT ITMMST = ':CPN:]'
0004 MOREDATA=1
0005 DARRAY=
0006 LOOP
0007 READNEXT ITMKEY ELSE MOREDATA=0
0008 WHILE MOREDATA
0009 READ IM.REC FROM IM,ITMKEY ELSE GOTO 99
0010 PNBR=IM.REC1
0011 DESC=IM.REC2
0012 IF DARRAY THEN DARRAY := @FM
0013 DARRAY := PNBR:@TM:DESC
0014 REPEAT
0015 SELECTN DARRAY TO 9
0016 ST=SQLExecDirect(@HSTMT, SELECT F1,F2 FROM @TMP SLIST 9 ORDER BY
1)
0017 RETURN
0018 99:
0019 PRINT ERROR IN OPEN OR READ FOR ITMMST
0020 RETURN
0021 END
I am using the technique described in the UCI documentation for Universe
10.0.16. It is
discussed in chapter 6.
Anyone have any ideas what would cause this?
Thanks in advance
-- Rod Hills
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV/NT resize failed - any way to put this file back together?
Do you open the file in programs that where running -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Walter Sent: Thursday, December 02, 2004 9:55 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UV/NT resize failed - any way to put this file back together? Thanks Dan, The concurrent option is not available on Windows versions. I guess I should have waited until all users where offline, but I knew for certain no one would be accessing AR,HIST file so I don't understand why the resize hung up on me. joe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Weiss, Dan Sent: Thursday, December 02, 2004 12:37 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UV/NT resize failed - any way to put this file back together? Joe, something similar happened to me once (only once) when resizing a file while users were online. The problem was that the file type (I believe this is what it was called) was changed in the header of the file. We used the concurrent command when resizing it on a UNIX box. I don't know if this will help or not. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joe Walter Sent: Thursday, December 02, 2004 11:25 AM To: [EMAIL PROTECTED] Subject: [U2] UV/NT resize failed - any way to put this file back together? was trying to resize a file on universe/NT and the process obviously got hosed up. it ran for upwards of three hours before we gave up on it. it is one of those blasted files with multiple data sections. so, we have the files AR and AR,HIST i was trying to resize AR,HIST. active users where accessing only the AR file itself, so i thought i could get by with resizing AR,HIST while others where online. it looks like it started to work, but should have completed in a matter of minutes based on past experience, so it did get hung up for some reason. if i display the files in the directory - i see the following: 11/30/04 03:10pDIR . 11/30/04 03:10pDIR .. 11/30/04 03:05p 2,569,728 AR 11/30/04 03:05p 5,343,232 HIST 11/30/04 03:10p 4,093,440 resizea00355 5 File(s) 12,006,400 bytes 619,339,264 bytes free so, it looks like *maybe* the data for the HIST section and this temp resizea00355 file might actually have the data, but when you try to access the file AR,HIST from TCL your session just locks up. can still access just the live AR file - no problem there. anyone know how to piece this thing back together without restoring from backups? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stopping HP Laser Printer line creep
I changed the page length on the printer to resolve the issue. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, November 22, 2004 6:35 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Stopping HP Laser Printer line creep Al DeWitt [EMAIL PROTECTED] wrote on 19 Nov 2004 17:59:16 -0600 UniData 6.0.12 // SB+ 5.2.4 I have a basic program that originally ran on a line printer to print preprinted forms. I am converting it to print on a laser. I'm having problem with line creep. Others have made some good suggestions - one other thing to check. On our system, the SB+ Printer Class Definitions are set to 65 lines, but on the physical printer, the page length is set to 66 lines. This was recommended by our VAR, and I never really got a good explanation as to why, but it does work. Also, if you're printing from BASIC, I recommend printing CHAR(12): to start a new page, rather than relying on a fixed number of lines per page. My standard code looks a bit like this: NEWPAGE: IF PAGE.CTR = 0 THEN PRINTER ON ELSE PRINT CHAR(12): PAGE.CTR += 1 PRINT report header:SPACE(as needed):Page :PAGE.CTR ... RETURN I use a LINE.CTR to track the number of lines printed, and check for a page break where needed. This also allows me to keep multiple line data together where necessary. For example, on our invoices, the Product Description appears on the line below the Product Number. If there's only one line available on the current page, I start a new one. Hope this helps. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DG Intel disk write problems
I have seen this before. Each time it has turned out to be a code error. Do all the programs lock the record when they read them and release or write when done? This could be the cause of your problem. Example. User 1 runs a process that does a READ of the record. Then User 2 runs a process that does a READU on the record. User 2 files the records and updates the information in the record. Now User 1 files is process and updated the record with the information back. There are many over ways but it also ends up be two users run process that do not lock records that the process could potential update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Friday, November 12, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: [U2] DG Intel disk write problems We have a DG Intel server running UV 9.6.1 and seem to be missing writes. We have a series of writes, 4, in a row within a basic program and sometimes it seems that one of the items is not updated not written. Has anyone experienced a similar problem. I know it's a long shot, but the customer wanted me to ask. TIA Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DG Intel disk write problems
Martin you are assume that the code was written with logic. But not knowing what application anything is possible. I have see lots of custom systems that have done a READ and not a READU because the original program was not updating the file. When the code was modified to write to the file the programmer never changed the READ to a READU. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Monday, November 15, 2004 6:44 AM To: [EMAIL PROTECTED] Subject: Re: [U2] DG Intel disk write problems User 1 runs a process that does a READ of the record. Then User 2 runs a process that does a READU on the record. User 2 files the records and updates the information in the record. Now User 1 files is process and updated the record with the information back. The UniVerse locking system is voluntary in the sense that applications can ignore it completely. The system should never have allowed writes or deletes without a lock and the ISOMODE configuration parameter allows this rule to be enforced. Applications that write or delete without locks are asking for trouble. There is another way in which this user's problem might arise though it is very unlikely UniVerse does not store the whole of a long record id in the lock tables. Instead, it keeps the first 63 characters, followed by a single byte formed from an exclusive-or of all the following bytes. The impact of this is that UV cannot distinguish two ids that are identical in the first 63 bytes and yield the same merged value for the remaining bytes. Try this simple test 1. Create a modulo 1 file (see below for why it needs to be modulo 1). 2. Add two records with ids that have the same value in the first 63 bytes followed by AB for one record, BA for the other. 3. In one process, read and lock one of these records. Another process will not be able to read and lock the second record. OK, this is not too bad as all that is happening is that the second process thinks the record is locked when it isn't. 4. Now read and lock both records in the one process. Do a quick LIST.READU and notice that there is only one lock. 5. Release the lock on one record. LIST.READU now shows that there are no locks when the program quite reasonably thinks it still has the other record locked. Other users can now freely update this record. Things are not actually as bad as they sound because the two records must also be in the same group (hence the modulo 1). However, even with bigger files, it is possible to fall over this one by accident. Consider a file that is keyed by something long like a web address. The application designer, not really understanding file types, chooses to user type 2, 3, 4 or 5. These base the hashing process on only the first few characters of the data. Two ids that meet the criteria above will necessarily be in the same group and hence the problem occurs. Sounds unlikely? I've seen it happen. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)
I have written several basic programs that run as phantoms with no problems. They select records and then process those records. Once done with the list it does back and does the select again. Without see the code and the output hard to say what is the problem -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doyen Klein Sent: Thursday, October 28, 2004 4:58 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST) I did, in fact, originally each select was an individual UDTEXECUTE line. It makes no difference, the first time through the loop, it works, after than from within a phantom, no selects or mergelist work. The identical program run from TCL works just fine. There is no difference in the out from executing each select line from within the program or executing them all as a paragraph, you still see everything in the _ph_ file. I'm wondering if a PQ proc might behave differently? -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Kathleeni M Bodine Sent: Wednesday, October 27, 2004 3:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST) Why dont you do a basic program with the UDTEXECUTE capturing all output and display the output to the screen. Then read the record in the phantom (_PH_) file and see what the problem is. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doyen Klein Sent: Tuesday, October 26, 2004 8:14 AM To: [EMAIL PROTECTED] Subject: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST) Question: what is the setup for the phantom environment to make the program work the same way it does from tcl? I've looked a several UDT.OPTIONS but can't seem to uncover the secret key. WinNT, Unidata a Paragraph (PH) works fine from tcl, but when executed by a phantom'd basic program the merge.list command within the paragraph seems to fail with the message 'Can not access list ML3516_1.' The output from the _ph_ file when it fails. 169 key(s) saved to 1 record(s) 163 records retrieved to list 1 169 records retrieved to list 2 Can not access list ML3516_1. The environment is 'p', but the program uses UDTEXECUTE PARTSLISTS and UDTEXECUTE GET.LIST DIFFLIST The second pass, all the selects seem to fail and come up with 0 records selected. Notes: WinNT, Unidata, P environment The program works fine when run from tcl, but not when phantomed. The login checks the @USER.TYPE and bypasses any login setup info. The program has $BASICTYPE u, and does a UDTEXECUTE 'ECLTYPE U' as well The paragraph contains ECLTYPE U as the first line. The paragraph which works fine from tcl or udtexecute a program run from tcl. 001: PA 002: ECLTYPE U 003: BASICTYPE U 004: SSELECT ITMMST 005: SAVE.LIST NEWPARTS 006: GET.LIST OLDPARTS TO 1 007: GET.LIST NEWPARTS TO 2 008: MERGE.LIST 2 DIFF 1 009: SAVE.LIST DIFFPARTS 010: GET.LIST NEWPARTS 011: SAVE.LIST OLDPARTS Clue: I have also been getting a strange stat ITMMST message and open fails when I try to open a file the second time, even though I closed it. Currently doings an OPEN ,ITMMST READONLY TO PFILE --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] UniObjects and Time zones
Do you have a zone time set in the users profile? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Thursday, October 28, 2004 7:08 AM To: '[EMAIL PROTECTED]' Subject: [U2] [UD] UniObjects and Time zones Yes, I am on Unix (AIX) and it would seem to be a time zone issue. Any dictionary containing @DATE, DATE(), @TIME or TIME(), that is run by UniObjects is giving me GMT. How can I tell UniObjects to apply our time zone? Thanks Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Assuming you're on Unix - there is an environmental setting tz for timezone. Try man on tz or timezone. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Server-To-Server UniVerse Clone
Any copy method works. I have moved accounts from unix to windows and unix to unix and windows to windows. But you will have to recompile your code. I find that the catalog object does not always work on the new machine like it did on the old no. By compiling and cataloging the object everything works fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 26, 2004 4:54 PM To: '[EMAIL PROTECTED]' Subject: [U2] Server-To-Server UniVerse Clone Our newly refurbished HP-Ux RX-2600 Itanium server arrived yesterday. I installed UV on this new box and now want to copy most everything from old to new. What is the best way to do this? The tech manual Administering UniVerse appears to mainly focus on inter-platform transfers. Suggestions would be appreciated. --Bill [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)
Why dont you do a basic program with the UDTEXECUTE capturing all output and display the output to the screen. Then read the record in the phantom (_PH_) file and see what the problem is. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doyen Klein Sent: Tuesday, October 26, 2004 8:14 AM To: [EMAIL PROTECTED] Subject: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST) Question: what is the setup for the phantom environment to make the program work the same way it does from tcl? I've looked a several UDT.OPTIONS but can't seem to uncover the secret key. WinNT, Unidata a Paragraph (PH) works fine from tcl, but when executed by a phantom'd basic program the merge.list command within the paragraph seems to fail with the message 'Can not access list ML3516_1.' The output from the _ph_ file when it fails. 169 key(s) saved to 1 record(s) 163 records retrieved to list 1 169 records retrieved to list 2 Can not access list ML3516_1. The environment is 'p', but the program uses UDTEXECUTE PARTSLISTS and UDTEXECUTE GET.LIST DIFFLIST The second pass, all the selects seem to fail and come up with 0 records selected. Notes: WinNT, Unidata, P environment The program works fine when run from tcl, but not when phantomed. The login checks the @USER.TYPE and bypasses any login setup info. The program has $BASICTYPE u, and does a UDTEXECUTE 'ECLTYPE U' as well The paragraph contains ECLTYPE U as the first line. The paragraph which works fine from tcl or udtexecute a program run from tcl. 001: PA 002: ECLTYPE U 003: BASICTYPE U 004: SSELECT ITMMST 005: SAVE.LIST NEWPARTS 006: GET.LIST OLDPARTS TO 1 007: GET.LIST NEWPARTS TO 2 008: MERGE.LIST 2 DIFF 1 009: SAVE.LIST DIFFPARTS 010: GET.LIST NEWPARTS 011: SAVE.LIST OLDPARTS Clue: I have also been getting a strange stat ITMMST message and open fails when I try to open a file the second time, even though I closed it. Currently doings an OPEN ,ITMMST READONLY TO PFILE --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Is the dictionary use the attribute that is index and what is the dictionary doing that you would access the index files. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Monday, October 25, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure AIX 5.2, Universe 10.1.2 We're getting exactly the same thing ... so far we've kinda eliminated all things 'cept the index, so that was our focus today. A rebuild of the offending index fixed the problem. maybe that'll help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 25 October, 2004 3:58 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Try doing the SELECT BY on dictionary items PMG.ADD.INSURED.REFER.NO PGM.PCF.ACCT.ID PMG.INSURED.REFER.NUMBER -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:02 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Here's what I inherited (unfortunately not simple in structure): DICT Record: PMG.NAMED.DEFENDANT.REFER.NUMBER 0001: I 0002: IF @RECORD3 # Y THEN ELSE IF PMG.ADD.INSURED.FLAG = Y THEN PMG.ADD.INSURED.REFER.NO ELSE IF PMG.PCF.ACCT.ID # THEN PMG.PCF.ACCT.ID ELSE PMG.INSURED.REFER.NUMBER The fields that are referenced above are working fine - it's the last field (PMG.INSURED.REFER.NUMBER) that does the subroutine calls that are causing issues: Record name = PMG.INSURED.REFER.NUMBER(this is an indexed field, and is having no trouble by itself) 0001: I 0002: SUBR(PMG.INSURED.REFER.NUMBER ,PMG.CG.NOTICE.DATE,PMG.COVERAGE.CONTEXT,22) There are 4 data files this subroutine opens using EQU BMS$.FILENAME TO COM.FILE(nnn), then OPEN FILENAME TO BMS$.FILENAME. It then sets a few variables, and then calls another subroutine: CALL CL.GET.COVERAGE.RISK(ERR.PACKET,IARGS,OARGS) This subroutine sets the EQU BMS$.FILENAME TO COM.FILE(nnn), then READs records from the 4 data files to formulate values to be returned. SELECT CLAIMS SAVING PMG.NAMED.DEFENDANT.REFER.NUMBER - works fine. SELECT CLAIMS BY PMG.NAMED.DEFENDANT.REFER.NUMBER - processes for a while, then starts kicking 'Read operation failure' errors. These Read operation failures are also kicking when we attempt to BUILD.INDEX on this field (the original source of finding the problem). |-+-- | | Kathleeni M Bodine | | | [EMAIL PROTECTED]| | | t | | | Sent by: | | | [EMAIL PROTECTED]| | | er.u2ug.org| | | | | | | | | 10/25/2004 01:31 PM| | | Please respond to | | | u2-users | | | | |-+-- --- | | | | To: [EMAIL PROTECTED] | | cc: | | Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure | --- | Is the dictionary use the attribute that is index and what is the dictionary doing that you would access the index files. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Monday, October 25, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure AIX 5.2, Universe 10.1.2 We're getting exactly the same thing ... so far we've kinda eliminated all things 'cept the index, so that was our focus today. A rebuild of the offending index fixed the problem. maybe that'll help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 25 October, 2004 3:58 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or
