RE: [U2] Unidata limits - Where are they documented?
I saw them in the Using UniQuery Manual under the Basic of Uniquery Here are the main limitations: n Cannot exceed 9247 characters. n Cannot contain more than 20 sort fields (BY...). n Cannot contain more than 120 WITH statements. n Cannot contain more than 60 WHEN statements. n A WHEN statement cannot process more than 10,240 values in one attribute. n Cannot contain more than 54 arithmetic operators (SUM, AVG, PCT, CALC). n A BY.EXP statement cannot explode more than 10,240 values in one attribute. n Cannot contain more than 15 BREAK.ON/BREAK.SUP clauses. n Cannot contain more than 999 display attributes. n A header or footer cannot exceed 2120 characters. n Cannot contain more than 256 virtual attributes. n Page width cannot exceed 272 characters. Regards Ray From: owner-u2-us...@listserver.u2ug.org [owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King [precisonl...@gmail.com] Sent: 02 April 2009 09:33 To: u2-users@listserver.u2ug.org Subject: [U2] Unidata limits - Where are they documented? I have a vague recollection that I've seen something in the Unidata manuals - years ago - documenting the maximums for a TCL statement, record size, number of IDs that can be specified in a SELECT statement, that sort of thing. I've searched the manual set but I can't seem to locate that information. Anyone recall offhand where these are documented? -Kevin http://www.PrecisOnline.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/
[U2] RE: UniObjects connection timeouts?
What version of the UniObjects assembly are you using.. We ran into this alot with the first .Net assemblies IBM shipped, but later releases are a lot better, and the RPC issue seems to have been largely resolved. FYI - We use the same assembly on Unidata and UniVerse, and had the same/similar issues on both U2 Products - moving to a later release of the assembly solved a lot of problems on both U2 products.. Regards Ray From: owner-u2-us...@listserver.u2ug.org [owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen [lhan...@redwoodcity.org] Sent: 01 April 2009 12:34 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] Hash / File Types in Unidata
Can anyone provide me with a link / info on the differences between Hash/ file types 0 and 1.. I would like to know more about how these work internally, so that at design / file creation time, the files can be created with the correct intended type, rather than just relying on file stats to check group allocation, and then switching file types if the allocation is sub-optimal. Regards Ray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Inter-Process Control...
If this is the approach you go for, I would recommend that you use a resource lock, rather than a record lock (no need to open file etc etc)... Resource locks are set system wide, so are not limited to a single account / file / record, and are accessed with the LOCK/UNLOCK UniBasic commands... You have 64 locks to use as you see fit.. In my mind the solution depends on how quickly you need the second process to wake up.. if a 30sec+ delay is ok, then using a resource lock could be an option with a SLEEP 30 on the locked condition.. Otherwise I would be looking at launching the child job as required, rather than having it wait for work.. Regards Raymond de Bourbon From: owner-u2-us...@listserver.u2ug.org [owner-u2-us...@listserver.u2ug.org] On Behalf Of kishor [kis...@parmars.com] Sent: 26 February 2009 07:52 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Inter-Process Control... Couldn't you get the second phantom to lock an empty record release it when it is done? The first phantom can wait on the readu lock. Regards, Kishor Parmar -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: 26 February 2009 12:57 To: u2-users@listserver.u2ug.org Subject: [U2] Inter-Process Control... We have two phantom processes. The first phantom needs to wait for an event to occur with the second phantom. I realize that I could have the first phantom loop, check, then sleep. However, I'd like to avoid wasting resources. Back on the Prime, I could use semaphores, to control this flow and this was clean, and simple. Has anyone come across a means of having a phantom wait on something, so it only wakes up when it needs to perform its function? To try to explain better: Phantom1: Loop Wait on semaphore Perform a shared process (batch updates would be an example) Repeat Phantom2 (3, 4, ...): Loop Process records Notify semaphore Repeat Thanks, Tom Whitmore RATEX Business Solutions --- 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] [UD] Trigger (singular)
Hi Bill, What you have is the simplest form of the wrapper. I had to create a 'generic' wrapper so I had to add logic to deal with the possible return values of execstat and the possibly amended record. As the wrapper is making the multiple calls it now has the responsibility of quitting at the appropriate time and maintaining the record value between subroutine calls. I'm on leave today, but I will post the 2 wrappers I have for update and delete as soon as I get a chance. Regards Raymond de Bourbon -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: 17/03/06 00:44 Subject: RE: [U2] [UD] Trigger (singular) Raymond: Thanks. I'm thinking the following ought to do the trick (unless, of course, I've missed something). :-) SUBROUTINE U2T.APVENDOR.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) ** Update trigger for APVENDOR file on UniData ** (C) Copyright 1985-2004, Advantos Systems, Inc. All Rights Reserved. ! ** Last Modified: 16 Mar 2006, wph ** First Created: 16 Mar 2006, wph ** Program Type-: Trigger (Web) ! ** Notes: ** ** This is a trigger program placed on the (APVENDOR) file. It has ** to execute all UPDATE triggers for this file. ** **---** ** ** **I N I T I A L I Z A T I O N** ** ** **---** * CALL U2.NAMES.BRIDGE.U (ExecStat, DictFlag, atFILENAME, atID, atRECORD) CALL U2.HOMETASTIC.UPD (ExecStat, DictFlag, atFILENAME, atID, atRECORD) * **** **** ** E N D O F P R O G R A M ** **** **** * RETURN END Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) -Original Message- From: Raymond de Bourbon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 16, 2006 2:21 PM To: Bill Haskett; u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Trigger (singular) Hi Bill, You are correct, Unidata only supports one trigger for both update and delete. In order to have multiple triggers you need a wrapper program... I can send you the source if you want. Regards Raymond de Bourbon -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: 16/03/06 21:03 Subject: [U2] [UD] Trigger (singular) I'm almost done with triggers (thank goodness I only have a few to create). It appears UniData only allows one trigger created on a file at a time. Is this true? 2 Dtademo (0)- LIST-TRIGGER APVENDOR BEFORE UPDATE TRIGGER: U2.NAMES.BRIDGE.U BEFORE DELETE TRIGGER: U2.NAMES.BRIDGE.D 2 Dtademo (0)- CREATE-TRIGGER APVENDOR U2.HOMETASTIC.UPD UPDATE The specified trigger already exists. The documentation doesn't mention this at all. So, in order to get multiple triggers on a file would I have to create a wrapper BASIC program that CALLs each trigger program as a subroutine (or EXECUTEs each trigger program)? Any enlightenment would be appreciated. :-) Bill Haskett --- 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] [UD] Trigger (singular)
Hi Bill, You are correct, Unidata only supports one trigger for both update and delete. In order to have multiple triggers you need a wrapper program... I can send you the source if you want. Regards Raymond de Bourbon -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: 16/03/06 21:03 Subject: [U2] [UD] Trigger (singular) I'm almost done with triggers (thank goodness I only have a few to create). It appears UniData only allows one trigger created on a file at a time. Is this true? 2 Dtademo (0)- LIST-TRIGGER APVENDOR BEFORE UPDATE TRIGGER: U2.NAMES.BRIDGE.U BEFORE DELETE TRIGGER: U2.NAMES.BRIDGE.D 2 Dtademo (0)- CREATE-TRIGGER APVENDOR U2.HOMETASTIC.UPD UPDATE The specified trigger already exists. The documentation doesn't mention this at all. So, in order to get multiple triggers on a file would I have to create a wrapper BASIC program that CALLs each trigger program as a subroutine (or EXECUTEs each trigger program)? Any enlightenment would be appreciated. :-) Bill Haskett --- 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] UniObjects for .Net 2.0
Hello All, Does anyone know if there is a version of UniObjects for version 2.0 of the .Net framework? Regards Raymond de Bourbon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/