Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
No David is correct, you are thinking of DATE.FORMAT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists Sent: Thursday, 9 January 2014 11:11 a.m. To: U2 Users List Subject: Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux On 08/01/2014 06:34, Hona, David wrote: Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... I hate to say it, but I think you've missed something crucial ... iirc FORMAT.CONV doesn't affect file format, rather it changes the date format from American to European, so that's the wrong command. HOWEVER the OP used UVBACKUP / UVRESTORE, the whold point of which is to *avoid* all these endian problems! UVBACKUP dumps the database as *text*, and then UVRESTORE puts it back. So the file should be created on the new system in the new endian format without any problems. There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td 7144.html Bearing in mind I've never done this, what I would try is ... Do a UVBACKUP at the account level to save the account on the old system. Delete the contents of the account directory on the new system, then run UV to create a new empty account. UVRESTORE your backup into the directory. A lot more hassle than a global UVBACKUP / UVRESTORE if you have multiple accounts, but it might work. The other thing is to put a fault call into Rocket, because this ought to work! I wonder ... could it be because the new system has a newer version of UV, and somehow the account upgrade mechanism is cutting in and messing up? Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
Maybe convert the VOC entries for the programs to R pointers. The r pointer would point to a file with the original VOC entry for the program. Then in attribute 4 of the R pointer put a security subroutine which logs the calling details for each call etc. That way you can gain a picture of when a program is called and how often and by who and from where. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Tuesday, 7 January 2014 1:08 p.m. To: U2-Users@listserver.u2ug.org Subject: [U2] Logging program execution in Unidata? We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaway and haven't been touched in years. It would be great to get some sense of which ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] REPLICATING DATA [OT]
I did not think Windows Server 2003 was still supported by Microsoft -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ard956 Sent: Thursday, 5 September 2013 7:27 a.m. To: U2 Users List Cc: u2-users@listserver.u2ug.org Subject: Re: [U2] REPLICATING DATA We are on Windows Server 2003. Sent from my iPad On Sep 3, 2013, at 1:45 PM, Wols Lists antli...@youngman.org.uk wrote: On 03/09/13 18:33, Ard956 wrote: and we would keep replication in place as a DR solution. What OS are you on? Given that, I'd be inclined to use rsync - DBPAUSE the database to make sure it's quiescent, run an rsync, and then bring the database back. Dunno what the Windows equivalent of rsync is, but if you're backing up across machines, rsync tries to not copy stuff that hasn't changed. Cheers, Wol Sent from my iPad On Sep 3, 2013, at 1:30 PM, Ard956 ard...@optonline.net wrote: We are moving our servers to a new colo and wanted to replicate from the server in the old colo to the one in the new colo and then flip over to the new server one weekend. Looking to have minimal down time. Sent from my iPad On Sep 3, 2013, at 12:26 PM, Baker Hughes baker.hug...@mouser.com wrote: Andrea - are you wanting to replicate for the purposes of having a warm backup as DR solution, or for reporting from, or some (what) other purpose? This question will dictate the strategy and what tools to employ. We copied the entire db every night to a hot system for Business Analysis. That was put in place before EDA was available. You could spend a lot of resources and time cobbling a 'replication solution' into place, while trying to dodge an upgrade... and perhaps spend more and have less satisfactory results than proceeding with standard methodology (upgrade to get the new toolset). HTH. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ard956 Sent: Tuesday, September 03, 2013 11:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] REPLICATING DATA Does anyone do replication with a tool outside of the U2 toolbox? We are on UV 10.2.10 which does not support UV replication. We have no plans to upgrade at this time but need a backup for our Universe server. Our database is about 180GB. Thank you, Andrea Dente Taylored Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample
Should line 73 of your program be rather than for the time as when the date has changed, the time will be less than the time of the date - 1 which you have just set. 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() Example: DATE.NOW = 16789 TIME.NOW = 83999 DATE() = 16790 TIME() = 1 Might be wrong -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Wednesday, 28 August 2013 4:26 a.m. To: U2 Users List Subject: Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample That is awesome information Troy! Thanks for that! (Now if I could just get my production environment upgrade to 11.1x :D ) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, August 27, 2013 10:03 AM To: U2 Users List Subject: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample Regarding the recent discussion of using indexes as triggers, I use the following to update timestamps of record changes to a master item stats file that we use for controlling updates to a business warehouse (BW). Without modifying hundreds of legacy programs to support proper timestamps in the primary records, I added the following indexed Idescriptors to files I need to track. We are on universe 11.1.1 and this has been working well for over a year. DICT AR-INVOICE INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F0,) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 216 bytes In this example, we have a AR-INVOICE header record and a related ARLI line item file. For our purposes to keep in sync with the BW, we want to timestamp the corresponding header record whenever a line item is updated so the ARLI dict item also updates AR-INVOICE header ZITEMSTATS with an I indirect update flag. DICT ARLI INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, ARLI!:F0,):SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F1,I) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 264 bytes Alternate Key Index Summary for file ARLI File... ARLI Indices 3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type INDEX..MODIFIEDZ INot Reqd No Yes SL NSUBR(ZIDESC.ITE MSTATS.UPDATE, ARLI!:F0,):S UBR(ZIDESC.ITEM STATS.UPDATE, AR-INVOICE!:F1, I) Subroutine ZIDESC.ITEMSTATS.UPDATE: 0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS) 0002 * updates zitemstats with timestamps; create, modified, deleted 0003 * 0004 * Revision history: 0005 * 0006 * tdb.1190 2012-04-22_1602 new 0007 * 0008 * 0009 * input: ZITEMSTATS.ID item id to use for ZITEMSTATS file 0010 * OPTIONS 0011 *I update attb 5 with I for indirect reference 0012 * 0013 * output: RETURN.VALUE NULL 0014 * 0015 * common vars: /ZITEMSTATS/ 0016 * 0017 * called by: INDEX..MODIFIEDZ dictionary items 0018 * calls: 0019 * 0020 * notes: 0021 * 0022 * 0023 $OPTIONS TIME.MILLISECOND 0024 * 0025 * @idx.iotype = 0 - Not being used from an index; 0026 * 1 - INSERT (new) record; 0027 * 2 - DELETE record; 0028 * 3 - Derive old index value; 0029 * 4 - Derive new index value; 0030 * 0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO 0032 * 0033 EQU NUL TO 0034 * 0035 RETURN.VALUE = NUL 0036 * 0037 * the following handles initial call and logto commands 0038 * 0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN 0040 OPEN ZITEMSTATS TO F.ZITEMSTATS ELSE 0041 RETURN ;* to caller. 0042 END 0043 * 0044 ZITEMSTATS.FLAG.OPEN = 1 0045 ZITEMSTATS.WHO = @WHO 0046 END 0047 * 0048 LOG.TYPE = NUL 0049 * 0050 BEGIN CASE 0051 CASE @IDX.IOTYPE = 0 0052 * 0053 CASE @IDX.IOTYPE = 1 0054 LOG.TYPE = C ;* new - created - easier to see than 'N' new 0055 * 0056 CASE @IDX.IOTYPE = 2 0057 LOG.TYPE = D ;* delete 0058 * 0059 CASE @IDX.IOTYPE = 3 0060 * 0061 CASE @IDX.IOTYPE = 4 0062 LOG.TYPE = M ;* modified 0063 * 0064 END CASE 0065 * 0066 IF LOG.TYPE # NUL THEN 0067 * 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0070 * 0071
Re: [U2] @RECORD VARIABLES
Is that only a Unidata thing? Sounds like a nice feature to have in Universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, 16 August 2013 9:06 a.m. To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] @RECORD VARIABLES Of course. Worked like a charm. Thank you Dave. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Dave Davis dda...@harriscomputer.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 08/15/2013 03:41 PM Subject:Re: [U2] @RECORD VARIABLES Sent by:u2-users-boun...@listserver.u2ug.org HELP CALCULATE You have to have your dictionary open to @DICT as well. I think you want to say RESULT = CALCULATE(ATTRIBUTE) Since {} is for a literal attribute name only. -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, August 15, 2013 4:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] @RECORD VARIABLES I am attempting to pass a variable into a SUBROUTINE and use it to access the data through the dictionary name. SUBROUTINE fieldLookup(., ATTRIBUTE, ) . . . READ @RECORD FROM F.FILE, @ID THEN RESULT = {ATTRIBUTE} END ELSE RESULT = END The part that isn't working is the RESULT = {ATTRIBUTE} As written here it is looking for a dictionary attribute named ATTRIBUTE. I tried forcing it to evaluate the variable ATTRIBUTE to the value in ATTRIBUTE by putting it in parenthesis, but it complained that it was expecting a variable when it was compiling. Is there a way to use a variable in the curly braces so that I can make this a generic subroutine? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg ] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Virus checked by UTM 9. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Configuration --
The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
That is not the point. Why should I have to do a workaround to get around something which should just work. I cannot see what would be so hard about allowing the debugging of programs which access a file with a trigger associated with it without aborting which UV currently does. That as a minimum. Hey it might even be good to be able to debug he trigger itself. Yes I could build a framework to call the trigger subroutine with the appropriate arguments, but why should I have to. Why is it so hard to do things? Mostly, I don't get that feeling with SQL, although to be fair MV has lot better string handling via build in functions, but then again SQL has the CLR capability in which I can build most of the MV string handling functions. Has anyone done this BTW? Sorry for the rant guys, but just pent up years of frustration. Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, 1 August 2013 9:33 p.m. To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org
Re: [U2] Universe Triggers
I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
I know we use them, but whenever one of the programmers wants to debug a program they take them off, which causes us other problems as we have processes which rely on the trigger output. This would be my biggest beef with UV at the moment. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 7:32 a.m. To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Autologout
Sort of, you would have to conditionally use the command in a Paragraph or like to do this I believe. LOGIN PA IF [skipautologout = true] GO SKIPAUTOLOGOUT AUTOLOGOUT SKIPAUTOLOGOUT: NEXTCOMMAND Would be nice if UV could interrogate the ENV in one line e.g. IF ENV.AUTOLOGOUT = 1 THEN GO SKIPAUTOLOGOUT AUTOLOGOUT Alas but it can't at least in the manner like above. Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, 25 July 2013 7:56 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] Autologout This is probably a simple question but I can't seem to figure it out, is there a way to exempt users from autologout? Jake Holt l samsill l Information Technology Director (817) 759-8038 l jh...@samsill.com mailto:jh...@samsill.com www.samsill.com http://www.samsill.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CentOS with Universe?
Hi Dan, When will Universe be 64-bit? This year, next year, never. I am not after specific dates, but is it on the project lifeline? Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 18 July 2013 2:57 a.m. To: U2 Users List Cc: U2 Users List Subject: Re: [U2] CentOS with Universe? While CentOS is effectively RHEL, and generally speaking, runs fine, there is always the chance that a difference is introduced (say an environment difference on the machine that compiled the source) that could adversely support UniVerse. CentOS 32-bit will be easier for you as our RHEL port is currently 32-bit. CentOS is not a Rocket supported OS. Rocket may require you to reproduce a reported issue on a supported platform. As a word of caution, we commonly work with OS providers (and sometimes hardware providers) to determine the root cause of an issue. With RHEL support, we have someone to work with, with CentOS we do not. Regards, Dan On Jul 17, 2013, at 7:42 AM, Dawn Wolthuis dw...@tincat-group.com wrote: We have a VAR who would prefer to load Universe and their application on a supported platform, but we would prefer not to pay for RHEL 6. I searched the list and found a few tidbits, but does anyone have a good list of what changes might be required to successfully run Universe 11.1 on CentOS? How much pain would we be introducing for ourselves and our VAR, if they were willing to play along? Thanks. --dawn -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7
You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? directory or something similar. I don't have access to a system at the moment. And then use the 32bit ODBC Driver. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 18 July 2013 10:35 a.m. To: U2 Users List Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 The shipping clerk's XP PC died. I bought him a new Win7 PC. I guess I made the mistake of installing the 64-Bit Rocket ODBC. When I tried to do an ODBC mapping, the United Parcel Service WorldShip desktop software indicated something like an architecture incompatibility when trying to connect to UniVerse 10,3.6 running on HP-Ux Itanium. Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources. Help sorting all this out would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7
Yes, that is it. I always though it strange that the 64 bit ones are under system 32, and 32 under 64sort of reverse psychology. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, 18 July 2013 11:11 a.m. To: U2 Users List Subject: Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 \windows\syswow64 With Microsoft typical logic this is where 32 bit versions of commands reside on x64. 64 bit ones are in system32. Sent from my cell phone. On 2013-07-17, at 3:50 PM, Phil Walker p...@gnosys.co.nz wrote: You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? directory or something similar. I don't have access to a system at the moment. And then use the 32bit ODBC Driver. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 18 July 2013 10:35 a.m. To: U2 Users List Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 The shipping clerk's XP PC died. I bought him a new Win7 PC. I guess I made the mistake of installing the 64-Bit Rocket ODBC. When I tried to do an ODBC mapping, the United Parcel Service WorldShip desktop software indicated something like an architecture incompatibility when trying to connect to UniVerse 10,3.6 running on HP-Ux Itanium. Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources. Help sorting all this out would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Any advantages to UV on 64-bit OS?
Hi John, We are building on that platform but have not deployed to production yet. 64-Bit RHEL 6 VMWare 140+ users The issue I had was that I was wanting to deploy the Microsoft ODBC Driver Manager and driver for Linux which is only 64-bit, and so while I got it working in isolation on the Linux box well, I could not link it to Universe as like you say it is only 32-bit. You could use another 32 bit Manager and driver. Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Friday, 12 July 2013 9:36 a.m. To: U2 User Group List Subject: [U2] Any advantages to UV on 64-bit OS? Hi all, I'm planning to upgrade our UV installation later this year primarily due to the age of the hardware (it's just over 5 years old). We aren't having any serious performance problems. We're currently running UV 10.2.7 on RedHat EL 5.1 32-bit and typically max out around 100 concurrent users. Since I probably won't upgrade again for another 5 years, I'd like to make the upgrade as future-proof as possible. Because UV is still a 32-bit app, though, I'm wondering if there is any real-world benefit to switching to 64-bit RedHat when I upgrade. I know the 64-bit kernel will remove the 4GB memory ceiling, but AFAIK, there is also a special 32-bit kernel for that. We also link UV to MS SQL via a 3rd party ODBC driver and accept JDBC and UOJ connections. I have to make sure that functionality isn't broken, and I recall someone recently posting that a 64-bit OS broke ODBC for them. Is anyone else successfully using ODBC, JDBC, and UOJ with 64-bit linux? Can anyone point out any advantages to running UV on a 64-bit OS? Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Auto Starting Applications
You should use uvsh rather than uv and you also need to consider multiple cron jobs running as the same user at the same time as Universe does not like this or never used to at least. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 11 July 2013 10:51 a.m. To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications You can certainly launch a UV process from a unix script. e.g. #!/usr/bin/bash cd /$path_to_uv_account/$ACCOUNTNAME $UVHOME/bin/uv phantom PROGRAMNAME /somedir/log1.txt $UVHOME/bin/uv LIST SOMEFILE DICTITEM1 DICTITEM2 /somedir/log2.txt You can call this from cron too if required. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Thursday, 11 July 2013 8:34 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d (depending on Linux)? On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor perry.tay...@zirmed.comwrote: What techniques are you folks using to start up apps when UniVerse on Linux is started? Obviously hooking into uv.rc is an option. Are there others? Thanks. Perry Perry Taylor Senior MV Architect Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File type 30 (dynamic)
I would probably use a distributed file, with a key based on some date elemen, e.g. month. That way you can add partfiles as a month happens and each file would be a static file of a standard size optimized for the number and size of records expected for that month. You can then have a rolling 12-month window without the disruption of having to add/delete records during the same timeframe as you would for purging a dynamic file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Wednesday, 10 July 2013 6:01 a.m. To: U2 Users List Subject: Re: [U2] File type 30 (dynamic) Once you start splitting groups, there's overhead on every write where that occurs, possibly creating a bottleneck. Dynamic files are good for files with non-consistent item sizes, and also for files with oversized items, but that's not the case here. I'd go with a wide shallow static file for this purpose, even if you had to make it distributed to account for size. Since most of what you'll do with this file is write to it, I wouldn't worry too much about empty groups. Date: Tue, 9 Jul 2013 09:15:20 -0700 From: szach...@gardensalive.com To: u2-users@listserver.u2ug.org Subject: [U2] File type 30 (dynamic) I have very little experience with using dynamic (type 30) files and I'm looking for some pointers in that regard. I have a file that I am considering creating as a dynamic file. The file will be a log file with sequential numeric keys. The record size will normally range from about 200 to 700 bytes, with a probable maximum size of less than 1,000 bytes. We expect the file to continually grow without deletions and we will likely purge it annually. What are the pro's and con's of creating this file as type 30 verses other file types? Thanks, Scott Zachary UniVerse Developer Gardens Alive! Inc -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/File-type-30-dynamic- tp41129.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File type 30 (dynamic)
The other option is to use something like syslog (you did not say your OS I believe) and then use something like splunk to query the logs, a great tool that you can customise for dashboarding, searching etc. That way Linux will administer the maintenance of them. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, 10 July 2013 7:54 a.m. To: 'U2 Users List' Subject: Re: [U2] File type 30 (dynamic) Scott The idea behind a dynamic file is to spread the pain of administration over the lifetime of an application. So yes, there are overheads and whilst a well-sized static file will outperform it, a dynamic file in turn will normally outperform a badly sized static file. There are some caveats, mostly relating to accessing the file outside of the database. If you use an OS level backup or snapshot, or anything that looks at these from the OS level, you need to make sure your dynamic files are closed OR you have paused your database - Universe holds runtime dynamic file parameters in shared memory and without those getting written back to the file header (which happens in the pause) the files will break if you restore them. Most of the prejudice against them goes back to the old PICKies who migrated to Universe at a time when they weren't particularly stable and had performance issues around concurrency with the way they effectively single threaded their sizing operations. They were also doubly expensive on UNIXes that had tight limitations on the number of open (OS level) files. But that was a long time ago. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Zachary Sent: 09 July 2013 17:15 To: u2-users@listserver.u2ug.org Subject: [U2] File type 30 (dynamic) I have very little experience with using dynamic (type 30) files and I'm looking for some pointers in that regard. I have a file that I am considering creating as a dynamic file. The file will be a log file with sequential numeric keys. The record size will normally range from about 200 to 700 bytes, with a probable maximum size of less than 1,000 bytes. We expect the file to continually grow without deletions and we will likely purge it annually. What are the pro's and con's of creating this file as type 30 verses other file types? Thanks, Scott Zachary UniVerse Developer Gardens Alive! Inc -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/File-type-30-dynamic-tp4112 9.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
From memory it is the first printer in sp.config, which you will have to edit. I think there is also a command SETPTR.DEFAULT which may or may not be relevant. Others will confirm I am sure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 9 July 2013 6:36 a.m. To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
HELP SETPTR.DEFAULT tells you, that you need to be logged into the UV account as root I believe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 9 July 2013 6:47 a.m. To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
This is an issue because UV is currently a 32bit app which will run on a 64 bit platform. The 64bit ODBC driver will work fine in isolation but will not link to Universe under the CONNECT manner. You could create a verb ISQL which would link to isql, provided by the Microsoft ODBC driver from memory, but this is not ideal. And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. [Phil Walker] --- On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata BCI error
You may be having an issue like I am. Universe (and probably Unidata) is a 32bit application. It will run on a 64-bit platform but will only link with other 32bit apps. I downloaded and got running the new and free Microsoft SQL Server odbc driver for Linux which is only supported as a 64bit application. As I said, I can get it running easily as a standalone interface to SQL, but as soon as I link Universe to the supplied ODBC driver manager, Universe will not load it, as it requires a 32bit app. I believe Rocket are bringing out a 64bit version of Univese shortly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Sunday, 2 June 2013 2:01 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata BCI error Well, that is my guess too. When we were planning the upgrade we asked our VAR if we needed to build a 32 bit Linux server and were told that UD 7.2 would work just fine on 64 bit Linux. So how can I connect to a SQL Server or Oracle database from UD and read data from it if BCI only works on a 32 bit OS? Is there maybe another ODBC driver that will work? On 23/05/2013 17:31, Daniel McGrath wrote: I've checked our system and have no previous reports of this error. Since our Linux versions are 32-bit and it seems you are running 64-bit Linux, combined with the negative number, I would hazard a guess this is some 32-bit on a 64-bit machine related problem. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, May 23, 2013 9:56 AM To: U2 Users List Subject: [U2] Unidata BCI error Unidata 7.2 on Redhat 6.2 64. I got our Sysadmin to install ODBC on our UD server today so I can try to use BCI to access data on SQL Server 2008 R2 directly. After some experimenting we finally got the ODBC part going and can connect to the right database from the command line. He relinked the shared library as stated in the documentation and CONNECT now seems to establish a connection to the server. But then it falls over with this message: In /usr/ud72/sys/CTLG/c/CONNECT at line 441 insufficient memory, requested size = -2074363. and drops back to a Linux prompt. The number is always different but always a negative one. Any clues what may be wrong? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] canon ir4025 printer on redhat
Have you set the printer up in Universe? You will need to set up a printer with a universe driver script directing output to the RHEL printer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley Sent: Friday, 3 May 2013 10:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] canon ir4025 printer on redhat I have a customer who just got a Canon ir-4025 copier/printer/everythingelse. Unable to find a linux driver I downloaded a product called BrightQPro which allowed me to install the printer on the redhat system. I can print using lp or lpr, I can print web pages and from Office, but UniVerse cannot see the printer: Requested printer does not exist. Has anybody used these products, I have done everything I could think of about 7 times. Thanks -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/canon-ir4025-printer-on-redhat-tp40657.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL input and response logging such as COMO
Look at Centrify DirectControl and DirectAudit, we use them and they work pretty well. www.centrify.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 25 April 2013 9:06 a.m. To: U2 Users List Subject: Re: [U2] TCL input and response logging such as COMO I can't speak for UV, but we've been required to log all sessions for specific powerful users. It becomes a little simpler if you do it for all users. Make sure you have some type of automated purge of whatever log files you create or you'll probably start filling up your file system. This is what we're doing under UD7.1. Nothing fancy. We added this to our LOGIN: PQ HRUN DIR COMO.PROG P And here's what's in COMO.PROG USERS = 'user1, user2, user3' IF INDEX(USERS,@LOGNAME,1) 0 THEN FN = @LOGNAME:'_':@USERNO:'_':DATE():'_':TIME() DATA FN EXECUTE 'COMO ON' END U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New Rocket Toolkit for .NET
Is this toolkit based on the MV.NET code that was licensed/purchased quite some time ago or is it something different? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 28 February 2013 10:05 a.m. To: U2 Users List Subject: Re: [U2] New Rocket Toolkit for .NET Hey Will, The U2 Toolkit for .NET (U2NETDK) can be thought of as 2 pieces: U2NETDK Provider - this is the API that provides access to U2 from .NET, superceding both ADO.NET and UO.NET. It is complete free and can be downloaded from our website: http://u2.rocketsoftware.com/resources/downloads U2NETDK Developer - this gives you Visual Studio Add-ins for U2 which makes development a lot easier. This is chargable on a per machine basis. Both are provided in the same package, the Developer portion will require an authorization key to use, other Provider will work exactly the same as you are used to with the older UO.NET. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, February 27, 2013 1:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] New Rocket Toolkit for .NET Does this new toolkit cost something? We already use .NET with Universe, but we'd be interested in getting this if it's an upgrade or something to what we have. Or is it something that *comes with* a Universe install so we should just ask for our free disk? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Dumping data to file from TCL
Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
Doing that I will end up with page delimiters and headers/footers will I not? I just want the data and nothing else and don't want to have to strip crap out if possible ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Lorentz Sent: Thursday, 21 February 2013 11:33 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Another way is to use the SETPTR, to save the printout output to a HOLD file item (which is a directory) and a .txt or .csv type file, then just Print, in columns and rows (comma or tab seperated or whatever), and the results are in your nice neat O/S level text file. I did exactly that for a few applications over the years. Dumping the output to a HOLD worked fine when we were transferring data from Universe systems to another platform. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dumping data to file from TCL
Hi Mike, I might be just being dumb, but how would curl help me here? Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike McGuane Sent: Thursday, 21 February 2013 12:26 p.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL http://curl.haxx.se/docs/manpage.html On Wed, Feb 20, 2013 at 3:03 PM, Wols Lists antli...@youngman.org.ukwrote: On 20/02/13 21:24, Phil Walker wrote: No we aren't and this needs to be an automated script executed by cron or other mechanisms e.g. EXECUTE command CAPTURING output etc. I can create a paragraph do to below if needed. If you're happy using a program written by someone else there are several on PickWiki. They'll dump to csv, or there's a Hollerith one there that takes its column width from the dictionary and dumps in fixed-width format. Take a look and take your pick ... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 21 February 2013 10:19 a.m. To: U2 Users List Subject: Re: [U2] Dumping data to file from TCL If using Rocket's Dynamic Connect, it is easy to copy and paste green screen data into say Windows NotePad. --Bill On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker p...@gnosys.co.nz wrote: Does Universe now have the ability to dump data to a file using a SELECT or LIST from TCL? I believe Unidata does have this capability.. For example, I can do a SELECT File SAVING IType SAVE.LIST ExportDirectory Datadump.dat But I would rather just say LIST File IType TO ExportDirectory Datadump.dat I know I could use DOWNLOAD or use LIST File Itype TOXML But I don't want to really use xml for this as there are a large number of records and the contents of IType are long and I would prefer not to use DOWNLOAD, or have to write a program if I can help it. Any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access login. Dan, I got the info from our VAR and it works great. Thanks! Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] External database
Seems rather extreme to go to Oracle just to get around 2GB file limit ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Sunday, 13 January 2013 9:18 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Thanks for reply. Can you guide me by some example to do this task. In fact I have little bit experience of ODBC drivers and their usage. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39625.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check which sproc is called by user
Or a security subroutine which performs an auditing function. This goes in attribute 4 of a remote VOC pointer. VOC File StoredProcedurePointer 1 R 2 StoredProcedureFile 3 StoredProcedureName 4 SecurityRoutine StoredProcedureFile StoredProcedureName 1 PA 2 DISPLAY I LIKE GREEN EGGS AND HAM -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 8 January 2013 12:18 p.m. To: U2 Users List Subject: Re: [U2] How to check which sproc is called by user I've heard that a lumpy VOC is not recommended by the MV Doc. It causes overflows and more disk IO. Not to mention the dreaded disk seek - oh no! If all you measured was your proc in the VOC, all would be good (on wood you should knock). But with a large proc in the VOC and your other entries in overflow, well then - now you can see the aforementioned performance blow! *---* Of course, all that is overstated on most systems now. Disk caching is quite efficient (and large). In only the most extenuating circumstances would moving large items outside of the VOC have any non-trivial impact on your running system. - Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 07, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How to check which sproc is called by user Explain more this performance issue of which you speak. How is a proc in a file different from the proc in the VOC? -Original Message- From: Ed Clark u...@edclark.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 7, 2013 2:43 pm Subject: Re: [U2] How to check which sproc is called by user Toad the wet sPROCet !! A lot of procs get run from the VOC, but for performance reasons it's usually suggested that the proc in the VOC be only a linkage that calls a proc from a file. (would you eat it with a proc, would you eat it in a VOC, I do not like green eggs and ham, I do not like them Sam-I-Am!!). Procs can be run from normal files, so you could track them with a read trigger on the proc file I think? The other idea that comes to mind is adding a line to each proc which writes out it's name/date/time to a file. On Jan 7, 2013, at 4:54 PM, Ravindranath Wickramanayake ra...@rammutual.com wrote: Hi U2 Guru's Can I tell when a sproc was last executed or who executed it. If so how. Some way to get statistics and access logs. Reason we are asking this is we are having a session hang issue we have tracked it down to a session user but have no clue which sproc did the call to trouble shoot. Thanks in advance ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BFORMAT
In today's world who prints out anything ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 30 November 2012 4:16 a.m. To: U2 Users List Subject: Re: [U2] BFORMAT I can see those settings being useful for printing out programs for documentation, but in today's printer Driver world, margins can be set outside the scope of the program - but if you don't have access to the Printer driver, then it would be nice to be able to set them, especially if your going to 3 hole punch the Output. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Bell Sent: Thursday, November 29, 2012 10:07 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] BFORMAT Anyone who is so anal as to require a change in setting of margins, indenting and a whole lot more is unlikely to be someone with whom I would enjoy spending time. AB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Variable Interpolation - UV INJECTION
01 RUNBASIC EXECUTE \SH -c 'rm -rf /'\ ;-( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: 25 August 2012 6:54 a.m. To: U2 Users List Subject: Re: [U2] Variable Interpolation Guys, I may be way off base but I have a program that takes basic code from the command line, compiles and runs it. For example:  01 RUNBASIC CRT SYSTEM(2) ; CRT SYSTEM(3) 79 24 RUNBASIC is the program and CRT SYSTEM(2) ; CRT SYSTEM(3) is the code in this example. 79 and 24 are the answers. The string of = signs are just for looks. This could be EXECUTEd from within a program but why? It is quite handy for testing bits of code at TCL and might be useful in a proc. RUNBASIC will do anything you can do with one line of code using ; to separate statements including FOR ... NEXT and LOOP ... REPEAT. Code is free as long as you don't critisize it. Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, August 24, 2012 1:38 PM Subject: Re: [U2] Variable Interpolation The impression I get from this thread is something like Oh I've just read on the HELP pages that System(2) tells me the width of my CRT screen. Let me ask my process what it has as the value for System(2). Oops I have to write a program just to tell me that that's too much trouble. Why can't it just have a way to *tell* me ? Why -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Aug 24, 2012 10:11 am Subject: Re: [U2] Variable Interpolation Hi, I am intrigued by this thread, mostly because I have not understood why I would want it. If I can write  CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) as suggested, why don't I just write the code inline in my program. What have I missed? Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mysterious UV Error
Jeff, My understanding from when I worked at VMARK, long ago, is that you should be using uvsh rather than uv anyway. Cannot remember the reason why but there was a reason back then anyway (1992-1995). Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald Sent: 21 August 2012 2:09 a.m. To: U2 Users List Subject: Re: [U2] Mysterious UV Error Rick, Your response was spot on - the site does use device licensing and it appears uv is outputting some characters that result in the error. Using uvsh seems to be a viable workaround. Thanks all for the help! it's much appreciated! Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com On Fri, Aug 17, 2012 at 4:22 PM, Rick Nuckolls r...@lynden.com wrote: Starting the COMO from UV might be a trial under the circumstances; but the Unix script command could fill in. btw, using .../uv/bin/uvdls COUNT VOC gives me Verb 6 is not in your VOC Uvdls is the device licensing version of uv, and it does send a sequence of characters (and backspaces) to the terminal, in an attempt to retrieve the device IP address. Of course, this only works on wintegrate and Dynamicconnect (I think). The actual resulting visible message seems to have some variance in it, and 60 is certainly within scope. At uv 10.2, the uvdls executable is about 900 bytes longer than the uv executable. If the client has device licensing, odds are good that uv was replaced with the uvdls executable. -Rick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CSV to Array
At risk of starting a flame war, I agree with Tony. I need to tune my email rules better. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 16 August 2012 9:58 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] CSV to Array There's no point in being abusive Tony. No one appreciates it. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Aug 15, 2012 2:50 pm Subject: Re: [U2] CSV to Array Anyone getting paid to play guessing games? Dude, get to the point. If this were presented as I need help I think many people would jump to help. But presenting this as a Mensa challenge is just wasting people's time. T Wjhonson wrote: Rex Gozar uploaded this code, and someone (perhaps him) corrected it, but there's a redundancy here. I'm trying to fix it, in my own version, mostly perhaps I *hate* the CONTINUE, but the logic is a bit convoluted eh? Anyone spot the redundancy ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statement with only two cases... or for that matter... one case
Also better for debugging...I think. you can break on the then clause or else clause rather than the IF -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Sunday, 22 April 2012 8:50 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Case Statement with only two cases... or for that matter... one case Well, I prefer: IF A = TEST THEN GOSUB DO.SOMETHING ;* Say why END ELSE GOSUB DO.SOMETHING.ELSE ;* The reason END IMO much more readable - because you see immediately that is is a conditional branching. It is also easier maintainable if you want to add some more code later or you need more conditions and want to change branching into case. And of course it will auto-indent correctly in my editor of choice ;-). On 20/04/2012 23:05, Kate Stanton wrote: Rather than: BEGIN CASE CASE A = TEST; GOSUB DO.SOMETHING CASE 1; GOSUB DO.SOMETHING.ELSE END CASE or IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE I prefer: IF A = TEST THEN GOSUB DO.SOMETHING ;* Say why ELSE GOSUB DO.SOMETHING.ELSE ;* The reason lining up the GOSUBs under each other, with comment making it clear why. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
In UV it is only available in SQL. Cannot remember why we did thatprobably timeframe of getting the functionality in for a particular release. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Thursday, 19 April 2012 7:18 a.m. To: U2 Users List Subject: Re: [U2] BETWEEN operator Universe release 10.3.7 on a Windows platform. Voc entry BETWEEN 1 K 2 508 No online help for it, and intuitive guess how to use it didn't work, but it's definitely there On 4/18/2012 3:04 PM, Wjhonson wrote: The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11. or something snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Issues calling REMOTE VOC pointer
Only Allen, responded. But this has been logged as a bug/feature enhancement with Rocket. It appears that the use of REMOTE VOC entries for BASIC programs is not currently supported/supported correctly which seems to be a major oversight. Hopefully it will not be difficult to implement. It shouldn't be, the just need to look at the PATH in the remote pointer for the object code, rather than looking in the object directory that the calling program resides in. Currently a BASIC program will look in the VOC file for a subroutine and if not found it will look in its own object directory. What I would like is it to look in the VOC, see that it is a remote voc entry, execute the security subroutine if specified, and then execute the object code specified by the Remote VOC pointer. This will allow the security routine to be used to AUDIT all programs on the system. Hopefully function calls would work the same way. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Tuesday, 10 April 2012 8:33 p.m. To: U2 Users List Subject: Re: [U2] Issues calling REMOTE VOC pointer You're EXECUTING PROG1 from TCL, so you can invoke it in any of the ways that you've documented below. From within PROG1, you're CALLING PROG2, it's a subroutine, so it has to be locatable as you've so clearly documented in your example. If you wanted to have them both run using 4 for security, then you could: 'EXECUTE PROG2 CAPTURING CMD.CAP' from within PROG1. If you need to pass args you're either going to have to store them in named common or pass them as command line args and parse them out. On 4/10/2012 4:05 AM, Phil Walker wrote: Hi, This is a contrived solution, but I have a program file BP1 and another program file BP2. In program file BP1 I have a program PROG1. In program file BP2 I have a program PROG2. PROG1 is the following: PROG1 0001 PROGRAM PROG1 0002 CRT IN PROGRAM PROG1 0003 CRT CALLING PROG2 0004 CALL PROG2 0005 CRT BACK IN PROG1 0006 RETURN PROG2 is the following: PROG2 0001 PROGRAM PROG2 0002 CRT IN PROGRAM PROG2 0003 RETURN If I RUN BP1 PROG1 I get the following RUN BP1 PROG1 IN PROGRAM PROG1 CALLING PROG2 Program PROG1: Line 4, Unable to open the operating system file BP1.O/PROG2. [ENOENT] No such file or directory Program PROG1: Line 4, Unable to load file PROG2. Program PROG1: Line 4, Unable to load subroutine. This is as expected, in that Universe assumes when there is not VOC entry that PROG2 is in the same OBJECT file, BP1.O. If I CATALOG BP2 PROG2 LOCAL COMLETE CATALOG BP2 PROG2 LOCAL COMPLETE PROG2 cataloged. CT VOC PROG2 PROG2 0001 V 0002 /tmp/BP2.O/PROG2 0003 B 0004 BN 0005 0006 0007 0008 0009 /tmp/BP2.O and then RUN BP1 PROG1 I get the following RUN BP1 PROG1 IN PROGRAM PROG1 CALLING PROG2 IN PROGRAM PROG2 BACK IN PROG1 If I CATALOG BP1 PROG1 LOCAL COMPLETE CATALOG BP1 PROG1 LOCAL COMPLETE PROG1 cataloged. CT VOC PROG1 PROG1 0001 V 0002 /tmp/BP1.O/PROG1 0003 B 0004 BN 0005 0006 0007 0008 0009 /tmp/BP1.O and then execute PROG1 I get the following PROG1 IN PROGRAM PROG1 CALLING PROG2 IN PROGRAM PROG2 BACK IN PROG1 The same results which is still good. However what I really want to do is add a security routine to both VOC entries PROG1 and PROG2. To do this I copy the VOC entries to PROG1 and PROG2 to the VOCLIB file and change the VOC entries to the following PROG1 0001 R 0002 VOCLIB 0003 PROG1 PROG2 0001 R 0002 VOCLIB 0003 PROG2 I will see if this works first, before adding attribute 4 for the security routine. PROG1 IN PROGRAM PROG1 CALLING PROG2 Program PROG1: Line 4, Unable to open the operating system file /tmp/BP1.O/PRO G2. [ENOENT] No such file or directory Program PROG1: Line 4, Unable to load file PROG2. Program PROG1: Line 4, Unable to load subroutine. As you can see this does not work. It appears that while Universe will use the contents of attribute 2 LOCAL VOC entry (the path to the object code), Universe will not use the contents of attribute 2 of the REMOTE VOC entry. I believe this is a bug...does you agree? For further clarification this was in IDEAL flavour. If I change it to PICK, PIOPEN it still behaves the same. Regards Phil ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo
[U2] AS2 Integration
Hi all, Just a quick question to the group to see if anyone has done any integration between AS2 and Universe and how they have done this? Cheers Phil ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AS2 Integration
The company I am having to do this integration with is going to use OpenAS2 which is an opensource AS2 implementation to talk to the biztalk server using an AS2 connector. What I was wondering was has anyone written an API in BASIC/GCI or similar to do this already using the AS2 api, if it has one. That way I can more closely interact with the AS2 software to handle errors/ handshaking etc. Maybe I should keep it simple and just use the directory integration at the OS level. Cheers Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Friday, 2 March 2012 11:09 a.m. To: U2 Users List Subject: Re: [U2] AS2 Integration It is essentially EDI over HTTP or FTP bypassing the traditional VAN mailbox process. We use BizConnect for our AS2 customers. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Thursday, March 01, 2012 3:23 PM To: U2 Users List Subject: Re: [U2] AS2 Integration Ok. So I'm going to ask the dummy question. What is AS2? I found this, but, somehow I doubt this is what you are talking about... http://en.wikipedia.org/wiki/AS2 On Thu, Mar 1, 2012 at 4:21 PM, Robert Houben robert.hou...@fwic.netwrote: VLTrader is a Cleo product as well. I agree, their support has always been good. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: March-01-12 1:21 PM To: U2 Users List Subject: Re: [U2] AS2 Integration We use a product called Lexicom from a company called Cleo. It is a very nice server based product and serves us flawlessly. It imports the EDI documents and deposits them in a directory that we access from UV. The product is great and the support from Cleo is terrific ((except that it is a call back support format). Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -- -- -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, March 01, 2012 3:50 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] AS2 Integration Hi all, Just a quick question to the group to see if anyone has done any integration between AS2 and Universe and how they have done this? Cheers Phil ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E- MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools
Actually, if you are on a newer version of windows the explorer has a search bar where you can filter on anything including extension. From there do your deletions in the current directory only -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Saturday, 18 February 2012 7:55 a.m. To: U2 Users List Subject: Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools actually your example is pretty easy on current windows versions. Type *.txt into the windows explorer search box, then select and delete. On the upside, when you delete the files, you know for sure what directory you are in because it's in the title bar. On the down side, your search retrieved not just the files in this directory, but in all the sub directories, which could be a plus if that's what you want, but is probably a downside because you still need to narrow the select. I used to use pick on a Stratus computer. The main OS was Stratus' VOS (based on multics, tasted a little like VMS with unix finish). All green-screen but the VOS commands were very verbose. But for every single command you could press a function key which popped up a form which contained every option/flag/default. They had put a lot of effort into making the VOS command line easy. That could probably be done for a pick command line as well (or for windows). I used to work with Motorola Codex communication equipment (multiplexed hundreds of serial connections over a t1 line so users in remote offices could green-screen into the application. The Codex itself had a serial port that you connected a terminal to to issue management commands (they added telnet later). The command set was pretty simple, but they also provided a gui. there was a pc running Windows 1 with a serial connection. The windows app gave you menus and forms, and then types commands to the control port and captured and screen-scraped (just a little) the output. The thing is, when they trained out people to use the system, they never mentioned that you could just use a terminal. The program was godawful and crashed all the time. It was completely in the way of issuing simple commands. My point is that if you know the commands then just typing them is easy, and you probably don't want a gui in the way. If you don't know them, a user interface (either gui or text) can make it easier--or just be a crutch. As for why telnet is still around--don't beat up on telnet. it's just a protocol. If you wanted to, you could write iPad apps that used telnet as a transport. you could put a beautiful gui on the front of an app running on an old pick box that can only do telnet. The real question is why is green-screen still around, and that has been argued endlessly. It's still here and a lot of people like it. On Feb 17, 2012, at 12:09 PM, Wjhonson wrote: Why is DOS still on Windows? Because there are some things you just can't do easily with windows, Just the other day I did a del *.txt pretty trivial to do at the DOS prompt. Rather more cumbersome to do in a Window click click click point, select click click select point click. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Feb 17, 2012 6:20 am Subject: Re: [U2] mvToolbox Why? Because it has almost no overhead, and has the most flexibility. Can the 3 year old (assuming they understood the process) select items from one ile based on selection Then pull items from another file using a related ID and save that list. Perform that again on two other files and save that list. Merge those two, and then push that list into an application that emails a file The above would take 2-3 min to do with telnet. IT would take significantly longer to do with a GUI front end. telnet is excellent for administration and development. Once you know what you ant, then you an use the GUI to setup a nice interface for those that want to point and lick. Why is DOS still on Windows? Because there are some things you just can't do asily with windows, r without writing/buying an application. George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Doug Averch ent: Thursday, February 16, 2012 10:17 PM o: U2 Users List ubject: Re: [U2] mvToolbox hy are we using telnet in 2 as our main form of communication? In today's world a 3 year old can use an iPad to access a Universe or nidata database application. We sell an Alpaca herd management that runs n the iPad and our granddaughter used the application Who's your daddy? o find out who the alpaca's daddy is. Sorry, another digression. Regards, oug __
[U2] RHEL 6.x and Universe Package Requirements
Hi all, I am installing Universe on a system which already had RHEL 6 installed on and whoever installed it pretty much install all packages so it is very bloated. Can someone provide me with a list of packages that they have installed on the RHEL 6 server? I realise there will be subtle differences depending on customisation/programming, but I would suspect that mah-jong might be missing Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] End of Month date routine
EOM = OCONV(ICONV(OCONV(@DATE+31,'D-YM[4,2]'):'-01','D-YMD[4,2,2')-1,'D-YMD[4,2,2]') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 6 December 2011 10:29 a.m. To: 'U2 Users List' Subject: Re: [U2] End of Month date routine Agreed. That code is almost verbatim what I have used for 20+ years, and it has never failed me. John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, December 05, 2011 4:27 PM To: U2 Users List Subject: Re: [U2] End of Month date routine I vote for the method (already posted) which will work every time on any MV system, any flavor, any emulation: find the first day of the next month and subtract 1. Messing around with adding 31, 32, etc. will bite you sooner or later (well, it worked at my last job). Regards, Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-05-2011 3:12 PM, Rick Nuckolls wrote: I think that with a slight modification, adding 31 works reasonably well. Just use the DYM conversion consistently through the program: To be concise, in Universe, for any internal date, D, the internal form of the last day of the month is: lastdayofmonth = iconv(oconv(iconv(oconv( D, 'DMY'), 'DMY') +31 ,'DMY'),'DMY') -1 DYM would work as well. Rick Nuckolls Lynden Inc Doesn't work on my system Anthony. The This month o gives the month and year ok but the attempt to iconv that sets it to zero, it doesn't pad the 01 into it or something so i just get 31 at that point. I think you were expecting that it would take 12 2011 and make it into 12 01 2011 or whatever but it's not working -Original Message- From: George Gallenggal...@wyanokegroup.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Dec 5, 2011 12:10 pm Subject: Re: [U2] End of Month date routine Haven't checked it, but what happens on 01/31 by adding 31, it should take you arch, backing up Will give you 02/xx (28 or 29)? George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wols Lists ent: Monday, December 05, 2011 3:05 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] End of Month date routine On 05/12/11 19:03, Wjhonson wrote: Does someone have a routine that, no matter what day you run it, returns the nd of Month Date ? (Assume the end of month date, is the calendar end of month date not some crewy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE HIS.MONTH.O = OCONV (TODAY, DMY) ;* strip day off EXT.MONTH.I = ICONV( THIS.MONTH.O, D) + 31 ;* random day next month EXT.MONTH.O = OCONV( NEXT.MONTH.I, DMY) ;* strip day off AST.DAY.I = ICONV( NEXT.MONTH.O, D) - 1 ;* subract one day If you don't have a day in your i/oconv it defaults to 1, so the logic orks. Unfortunately you can't combine the first three lines because here's no number you can pick that will guarantee to land you in next onth whatever today's date :-( Cheers, ol __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] End of Month date routine
Actually that will not work for a date near the end of the month. Was trying to be too smart -Original Message- From: Phil Walker Sent: Tuesday, 6 December 2011 10:47 a.m. To: 'U2 Users List' Subject: RE: [U2] End of Month date routine EOM = OCONV(ICONV(OCONV(@DATE+31,'D-YM[4,2]'):'-01','D-YMD[4,2,2')- 1,'D-YMD[4,2,2]') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 6 December 2011 10:29 a.m. To: 'U2 Users List' Subject: Re: [U2] End of Month date routine Agreed. That code is almost verbatim what I have used for 20+ years, and it has never failed me. John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, December 05, 2011 4:27 PM To: U2 Users List Subject: Re: [U2] End of Month date routine I vote for the method (already posted) which will work every time on any MV system, any flavor, any emulation: find the first day of the next month and subtract 1. Messing around with adding 31, 32, etc. will bite you sooner or later (well, it worked at my last job). Regards, Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-05-2011 3:12 PM, Rick Nuckolls wrote: I think that with a slight modification, adding 31 works reasonably well. Just use the DYM conversion consistently through the program: To be concise, in Universe, for any internal date, D, the internal form of the last day of the month is: lastdayofmonth = iconv(oconv(iconv(oconv( D, 'DMY'), 'DMY') +31 ,'DMY'),'DMY') -1 DYM would work as well. Rick Nuckolls Lynden Inc Doesn't work on my system Anthony. The This month o gives the month and year ok but the attempt to iconv that sets it to zero, it doesn't pad the 01 into it or something so i just get 31 at that point. I think you were expecting that it would take 12 2011 and make it into 12 01 2011 or whatever but it's not working -Original Message- From: George Gallenggal...@wyanokegroup.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Dec 5, 2011 12:10 pm Subject: Re: [U2] End of Month date routine Haven't checked it, but what happens on 01/31 by adding 31, it should take you arch, backing up Will give you 02/xx (28 or 29)? George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wols Lists ent: Monday, December 05, 2011 3:05 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] End of Month date routine On 05/12/11 19:03, Wjhonson wrote: Does someone have a routine that, no matter what day you run it, returns the nd of Month Date ? (Assume the end of month date, is the calendar end of month date not some crewy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE HIS.MONTH.O = OCONV (TODAY, DMY) ;* strip day off EXT.MONTH.I = ICONV( THIS.MONTH.O, D) + 31 ;* random day next month EXT.MONTH.O = OCONV( NEXT.MONTH.I, DMY) ;* strip day off AST.DAY.I = ICONV( NEXT.MONTH.O, D) - 1 ;* subract one day If you don't have a day in your i/oconv it defaults to 1, so the logic orks. Unfortunately you can't combine the first three lines because here's no number you can pick that will guarantee to land you in next onth whatever today's date :-( Cheers, ol __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Suggestions for flattening Multivalues...
Why are you using MySql if you are after free you could use Postgresql which I believe supported nested tables built in? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 10 November 2011 8:06 a.m. To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... For a couple of the fields, I've done this, but for most of them, there are no range of counts. Oh well. The only other method I'll use for some of the other fields is storing them with a delimiter (very Pick like) And have the application split the data, instead of splitting it in the database. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, November 09, 2011 2:03 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV 9.6.2.1/uvbackup questions
Normally I would. However I am working on a project now, where the customer stopped paying maintenance for DataStage way back when, and the version they have only works on Windows 2000 Server. They have virtualized the box and everything runs fine.. Not ideal, but it does the job for them ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Thursday, 15 September 2011 6:07 a.m. To: U2 Users List Subject: Re: [U2] UV 9.6.2.1/uvbackup questions It's just you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of cheetah...@comcast.net Sent: Wednesday, September 14, 2011 11:03 AM To: U2 Users List Subject: Re: [U2] UV 9.6.2.1/uvbackup questions Is it just me, or does anybody else absolutely cringe when here in late 2011 we see anyone still running W2K for any reason? - Original Message - From: Bob Wyatt bwyatt_...@comcast.net To: u2-users@listserver.u2ug.org Sent: Tuesday, September 13, 2011 10:44:27 PM Subject: [U2] UV 9.6.2.1/uvbackup questions I ran into a client with UniVerse 9.6.2.1 on Windows 2000 Server with SP4. It looks like uvbackup does some strange things on this system, and I'm wondering if someone may have seen this or know how to change it. The uvbackup command is essentially uvbackup -f -limit 1 -v -s logfile -t z:\backupfile.img -walk d:\uvdb\accounts The backup starts at 10 P.M., and finishes around 7 A.M. for a 37 GB database resulting in a 28.4 GB backup image file. The z:\backupfile.img file is a remote server path for the backup only. For the entire 9 hours, z:\backupfile.img file never exists - it doesn't get created until the job is done, it runs out of resources, or falls into some error that causes uvbackup to ask to continue with the current file, change the file, or quit. The z: location still has plenty of disk space - more than triple the space needed. It happens with or without the -limit 1 argument. The next day, it may run fine - completes the backup without error. The hardware is a 3.06 GHz Xeon processor with 3 GB of memory, SATA-1 drives on a RAID controller in a RAID-5 array (doing over 400 MB/sec transfer speed on Reads), and the network is 1 Gb. Has anyone noticed that their backup file does not (or did not) grow or exist until the backup is done? Does anyone know of a way to convince uvbackup to use the target file immediately without awaiting completion? Does anyone know if this happens in newer UniVerse releases this same way? Lastly, if d:\uvdb\accounts has a few accounts I don't want to back up, it looks like I cannot skip them in the backup unless I create a file with a list of all of the files I want to back up. This would be several hundred thousand files, and there are new files created every day. And I can't move the accounts I don't care about. I was thinking about SourceForge findutils, but am wondering if someone has experience with this or similar Windows find utilities and uvbackup? Any insight would be greatly appreciated. Bob Wyatt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Ardent programmers
PVW is me Phil Walker DSM might be David Meeks WLC is probably Wendy Cleary JC Jesus Christ ;-) Others cannot remember -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 9 September 2011 12:26 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Ardent programmers In my copy of Acct.Stat.B the following programmer initials dating from 1992 to 2000 PVW, WLC, AGM, JC, DJD, PEJ, SAP, DSM, LKS anyone have long names ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV 11.1.1 on RHEL 6 64-bit
Hi, Does anyone have UV 11.1.1 installed on RHEL 6 / 64bit edition? If so did they have to tweak the install process, I am getting an error during the install where it is looking for /lib/ld-so.x. There is however a directory at /lib64 but the exact file is also missing? Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] serial #
Config Phil Walker Gnosys Consulting m: +64 27 5336294 p: +64 3 3120352 On 8/05/2011, at 8:59 AM, Tom t...@ix.netcom.com wrote: No, darn. I have written basic programs to simulate the information. Sent from my iPhone Tom Dodds t...@ix.netcom.com 630.235.2975 On May 7, 2011, at 15:19, Larry Hiscock lar...@wcs-corp.com wrote: Does UV have the WHAT tcl verb like UD does? Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Saturday, May 07, 2011 10:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] serial # Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
Worth a try but no unfortunately the ENVIRONMENT variable set in the uvsh shell is lost when returning to the linux/unix shell which invoked the uvsh. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 17 March 2011 4:09 p.m. To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE You might be able to use the ENVIRONMENT command in UV to set an environment variable, and test its value upon return to your shell. Something like: EXECUTE ENVIRONMENT SET UVRC=:@SYSTEM.RETURN.CODE will set the value. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, 17 March 2011 8:25 AM To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Thanks Brad, That idea had crossed my mind, alternatively capturing some output as this is a non-interactive process but liked the simplicity of @SYSTEM.RETURN.CODE Maybe Mark Baldridge would have some ideas being the expert he is and an old colleague at VMARK last century ;-) But I suspect the @SYSTEM.RETURN.CODE is getting lost inside the uvsh executable and not returned to UNIX Cheers -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 17 March 2011 10:20 a.m. To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Phil, I wrestled with this one quite a while a few years back under ud.. Never figured out a code-only solution. Ended up writing exit codes to a text file that the script reads when the program completes. If noone has any other ideas you like, ping me and I can explain what I did. Brad. From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Date: 03/16/2011 04:02 PM Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Sent by:u2-users-boun...@listserver.u2ug.org Hi all, I am trying to detect the success of failure of a BASIC program when running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do this, hoping that the exit status of uvsh would reflect the value set for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone know if this works and I am just missing something silly? Possibly VOC entry process mode setting or something? e.g. uvsh MYBASICPROGRAM SUCCESS would return exit status of 0 uvsh MYBASICPROGRAM FAILURE would return exit status 1 uvsh MYBASICPROGRAM would return 9 SUBROUTINE MYBASICPROGRAM @SYSTEM.RETURN.CODE = 9 Get(Arg.) EXITSTATUS ELSE STOP BEGIN CASE CASE EXITSTATUS = 'SUCCESS' @SYSTEM.RETURN.CODE = 0 CASE EXITSTATUS = FAILURE' @SYSTEM.RETURN.CODE = 1 END CASE RETURN This is a contrived example, but shows what I am trying to do with @SYSTEM.RETURN.CODE. Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1BULLlroVk/1rQ0ecbGO8cCUDpILHY DxQ/0 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users
[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
Hi all, I am trying to detect the success of failure of a BASIC program when running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do this, hoping that the exit status of uvsh would reflect the value set for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone know if this works and I am just missing something silly? Possibly VOC entry process mode setting or something? e.g. uvsh MYBASICPROGRAM SUCCESS would return exit status of 0 uvsh MYBASICPROGRAM FAILURE would return exit status 1 uvsh MYBASICPROGRAM would return 9 SUBROUTINE MYBASICPROGRAM @SYSTEM.RETURN.CODE = 9 Get(Arg.) EXITSTATUS ELSE STOP BEGIN CASE CASE EXITSTATUS = 'SUCCESS' @SYSTEM.RETURN.CODE = 0 CASE EXITSTATUS = FAILURE' @SYSTEM.RETURN.CODE = 1 END CASE RETURN This is a contrived example, but shows what I am trying to do with @SYSTEM.RETURN.CODE. Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
Thanks Brad, That idea had crossed my mind, alternatively capturing some output as this is a non-interactive process but liked the simplicity of @SYSTEM.RETURN.CODE Maybe Mark Baldridge would have some ideas being the expert he is and an old colleague at VMARK last century ;-) But I suspect the @SYSTEM.RETURN.CODE is getting lost inside the uvsh executable and not returned to UNIX Cheers -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 17 March 2011 10:20 a.m. To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Phil, I wrestled with this one quite a while a few years back under ud.. Never figured out a code-only solution. Ended up writing exit codes to a text file that the script reads when the program completes. If noone has any other ideas you like, ping me and I can explain what I did. Brad. From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Date: 03/16/2011 04:02 PM Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Sent by:u2-users-boun...@listserver.u2ug.org Hi all, I am trying to detect the success of failure of a BASIC program when running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do this, hoping that the exit status of uvsh would reflect the value set for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone know if this works and I am just missing something silly? Possibly VOC entry process mode setting or something? e.g. uvsh MYBASICPROGRAM SUCCESS would return exit status of 0 uvsh MYBASICPROGRAM FAILURE would return exit status 1 uvsh MYBASICPROGRAM would return 9 SUBROUTINE MYBASICPROGRAM @SYSTEM.RETURN.CODE = 9 Get(Arg.) EXITSTATUS ELSE STOP BEGIN CASE CASE EXITSTATUS = 'SUCCESS' @SYSTEM.RETURN.CODE = 0 CASE EXITSTATUS = FAILURE' @SYSTEM.RETURN.CODE = 1 END CASE RETURN This is a contrived example, but shows what I am trying to do with @SYSTEM.RETURN.CODE. Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
There is an overhead in using the transaction handling capability in UV [Assume same would be the case in UD] in the an underlying transaction structure is established in memory and the transaction mechanism also it enforces some constraints such as record locking [ Which you should do anyway ]. It would be better if a TRY CATCH mechanism was added specifically My 2c worth... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Friday, 11 February 2011 11:01 a.m. To: 'U2 Users List' Subject: Re: [U2] Does UV have a BLOCK command I've been following this thread somewhat cursorily. But I've not seen a mention by anyone of the built in transaction handling in U2. I'm speaking about the TRANSACTION START THEN END construct with TRANSACTION.COMMIT and TRANSACTION.ABORT commands. This would seem to fit the bill of the original poster. Just my 2 cents, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
No offence taken, I disagree but that is okay -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 2 February 2011 9:15 p.m. To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? I am not being rude, but the whole concept of being data storage agnostic and building the application layers above that is very 1990's textbook. What has been very apparent in the last ten years is that for many many applications the data storage technology is an integral part of the offering. (not to say we do not build business logic and data access layers) I have worked at places that offer their solution on mysql, mssql, oracle, but eventually they had to concentrate on one - it may well work on all, but it certainly was not efficient. They may all have the same concepts in terms of sql but they work in very different ways and in order to produce an architecture that is highly innovative and efficient you have to include the capabilities of the data storage into major consideration. I think if you are an end user site then the ability to choose a new DB store based on price/performance and irrelevant to the application is still a concern but for isv's developing innovative and efficient solutions we have very much moved on from that viewpoint. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: 01 February 2011 23:19 To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Storage is something completely different. Think of business objects rather than tables/rows/columns or file/record/fm/vm/sm/tm or even XML. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 2 February 2011 10:31 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? While that all makes sense, the one difference here between U2 and the others (Oracle, MySQL, MSSQL) is the usage of multi-value data storage. Even if U2 had the best GUI interface, if you are utilizing the MV storage, you CAN'T Swap it out, without even more redevelopment. If your going to redevelop to not use the multi-value, then why bother with U2 at all, green screen or not. Guess it's a matter of how much you want to redevelop. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Tuesday, February 01, 2011 4:12 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? If you still have a green screen and want to put a GUI/Web interface on it, then do the redevelopment, but look to see if you can layer your application architecture so that the database can be swapped out the database if you need to for whatever reason. The value is in your application not the database. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1435/3416 - Release Date: 02/01/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
Agreed it is the database. I guess I was not clear. If your archictecture has layers dbms/DAL/BAL/UI then you COULD if you wanted to theoretically at least change one of these without largely impacting the other layers. Therefore if you did not like the dbms licensing model or the customer wanted into to run on another dbms then (provided you had written) the dbms schema and had a DAL for that dbms then you could switch the dbms. Admittedly a bit of work, if you have an already application, but gives you the flexibility of what you want. Symeon thinks this is old school, and it is not without challenges, but it does allow you to break each of the components which WILL change independently of the others. U2 disappears for the example, or prices itself out of the market you are in, the business/industry changes some logic, or the user wants to use and iphone or see their business data in a hologram ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 3 February 2011 3:16 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Storage IS the database. Multivalue could be the issue. My point was that if you are utilizing mulitvalued storage than it's a major problem to be able to swap out the database, since the whole multivalue structure is not in Oracle (Ok. I think the latest version of Oracle has something), MySQL or MSSQL If your database could be swapped out for another database, then what is the advantage of using U2? and having to deal with the licensing issue at all? Most times, there is such a degree of design and development over the years that is dependant on U2 (pick) uniqueness that as far as licensing, your in a corner. Although I agree, it would be ideal to have your design structure be database engine independent, which puts you as the user/developer in control, but most U2 locations have had years upon years of Multivalued dependent code, and would cost far more to redesign than it would be to pay extra licensing fees. This however, doesn't excuse not preparing for the worst, and keeping the availability for your business model to transfer smoothly if the end should come (for U2 that is, not 2012). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Tuesday, February 01, 2011 6:19 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Storage is something completely different. Think of business objects rather than tables/rows/columns or file/record/fm/vm/sm/tm or even XML. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 2 February 2011 10:31 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? While that all makes sense, the one difference here between U2 and the others (Oracle, MySQL, MSSQL) is the usage of multi-value data storage. Even if U2 had the best GUI interface, if you are utilizing the MV storage, you CAN'T Swap it out, without even more redevelopment. If your going to redevelop to not use the multi-value, then why bother with U2 at all, green screen or not. Guess it's a matter of how much you want to redevelop. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
That should have been break out not just break ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Thursday, 3 February 2011 7:16 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Agreed it is the database. I guess I was not clear. If your archictecture has layers dbms/DAL/BAL/UI then you COULD if you wanted to theoretically at least change one of these without largely impacting the other layers. Therefore if you did not like the dbms licensing model or the customer wanted into to run on another dbms then (provided you had written) the dbms schema and had a DAL for that dbms then you could switch the dbms. Admittedly a bit of work, if you have an already application, but gives you the flexibility of what you want. Symeon thinks this is old school, and it is not without challenges, but it does allow you to break each of the components which WILL change independently of the others. U2 disappears for the example, or prices itself out of the market you are in, the business/industry changes some logic, or the user wants to use and iphone or see their business data in a hologram ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 3 February 2011 3:16 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Storage IS the database. Multivalue could be the issue. My point was that if you are utilizing mulitvalued storage than it's a major problem to be able to swap out the database, since the whole multivalue structure is not in Oracle (Ok. I think the latest version of Oracle has something), MySQL or MSSQL If your database could be swapped out for another database, then what is the advantage of using U2? and having to deal with the licensing issue at all? Most times, there is such a degree of design and development over the years that is dependant on U2 (pick) uniqueness that as far as licensing, your in a corner. Although I agree, it would be ideal to have your design structure be database engine independent, which puts you as the user/developer in control, but most U2 locations have had years upon years of Multivalued dependent code, and would cost far more to redesign than it would be to pay extra licensing fees. This however, doesn't excuse not preparing for the worst, and keeping the availability for your business model to transfer smoothly if the end should come (for U2 that is, not 2012). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Tuesday, February 01, 2011 6:19 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Storage is something completely different. Think of business objects rather than tables/rows/columns or file/record/fm/vm/sm/tm or even XML. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 2 February 2011 10:31 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? While that all makes sense, the one difference here between U2 and the others (Oracle, MySQL, MSSQL) is the usage of multi-value data storage. Even if U2 had the best GUI interface, if you are utilizing the MV storage, you CAN'T Swap it out, without even more redevelopment. If your going to redevelop to not use the multi-value, then why bother with U2 at all, green screen or not. Guess it's a matter of how much you want to redevelop. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
This is starting to go off on a tangent. But we seem to have this discussion on a regular basis. The way I see it is this: As an end-user of an application you should not or do not care what backend system is used. So after application capability, a match with the existing environment or cost of ownership is going to be the driving force behind your decision. As a developer of the application in the modern world you are going to stay with what you know. Unfortunately, if you stay on Green Screen you are probably going to not pick up new customers and will slowly lose existing ones. So you have a choice, carry on banging on about how U2 is so great, (who really cares apart from some of us), or look at modernising your application. I would pick the latter, and I would do it in such a way that my new application architecture would enable to pick a chose different technologies at the different layers (including DBMS) going forward. The match of the application functionality to the business requirements is what is going to sell it, not the fact that it runs on DBMS x or y. By using something like Microsoft SQL and its various versions, I can develop something and then scale it up as my user count increases.also all the tools that I am using are fully integrated with it already without having to buy 3rd party addons My 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 2 February 2011 8:15 a.m. To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? I find the whole licencing issue a real pain. Compare to sql server - express edition for free comes with 100 pooled connections as default - ok there is a max DB size I can then progress to a server licence - again any number of connection pools. Connection pools on unidata i get about 5 for the same kind of money From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 01 February 2011 17:58 To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? @George - you're probably right -- I found the doc on that link was dated Feb / Mar of 2010 -- that was well into Rocket-realm, but perhaps they just 'wrote up' the logic IBM used to make the change. And yes -- it appears the any 'socket' sets iPhantoms. The problem is that the logic does not address specifically the uses that could be 'abused' - but rather ALL uses. @Jeff / Symeon - That I can see, you don't 'consume' a 'purchased' seat running a phantom UNTIL you do a anything 'socket' - even if that Socket Use has the same use as a 'disk read'. As for use of cURL, WGet, etc - these are examples of the issue as I see it. Those are still an option to do exactly what we could do BEFORE this rule went into play, and we can still do those even now without a license 'ding'. To me, that's the core of this issue: the change didn't 'fix' anything except to create a barrier to adopting the Rocket-provided toolsets since CallHTTP can no longer work in a Phantom without 'expense' to the customer. I mean, they spent the time and money to develop CallHTTP, but now I can never use it again -- and sounds like a great number of people never used it or already 'jumped ship' as well. And are still doing EXACTLY what the change was designed to prevent! So what good was the 'effort' and 'hassle' for the change?? Did they really pick up additional revenue?? Or just make people find 'non-U2' solutions?? So - As I see it, there was a logic error in the decision made by IBM, continued by Rocket. I (probably crazily) hope that they will revisit the issue for CallHTTP. But from comments posted here, appears no one else is impacted by the Phantom license change. I am guessing people either just silently re-wrote their code to 'skip over' CallHTTP rather than complain, or had never adopted CallHTTP in the first place (used cURL/wGet before CallHTTP existed and never moved.) - So I will just work around it as everyone else did since it is not a 'group issue' worth pushing. Now, if they ever hamper the ability to run cURL/wGet, I guessing there will be the massive outcry that didn't happen over this issue! LOL! Have to get started -- Sadly, no one is going to pay me to fix this. And I write enough issues on my own without someone else creating issues for me! So... Goodbye CallHTTP -- Heo cURL! DW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database:
Re: [U2] What do you do with CallHTTP?
No it does not, but there are a lot of applications out there that still are Green Screen and there is a tidal wave of market forces/perceptions/consultant recommendations (rightly or wrongly) to move off them. My point really was that if you already have an application which is U2 reliant whether it be green screen or not, then potentially you have a problem, as I think there are a number of people on this group who seem very hung up on the technology. If you still have a green screen and want to put a GUI/Web interface on it, then do the redevelopment, but look to see if you can layer your application architecture so that the database can be swapped out the database if you need to for whatever reason. The value is in your application not the database. If you have a GUI/Web interface and you a reliant on U2, then you probably should revisit your application architecture so that the DB interface is buried under your application layer. Therefore giving you the ability to move off the database onto another platform as above. The same goes for your front-end, develop your app so that you can have a different or multiple front. Separation of concerns... You can do nothing and wait in the hope that someone else may fix your problem, or you can plan today to give yourself choices...the choice is yours Cheers Phil. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 2 February 2011 9:31 a.m. To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? My one thing to say on this is u2 does not = green screen - i have not written a green screen app for many many years - but i still use u2 and other DB's extensively. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: 01 February 2011 19:34 To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? This is starting to go off on a tangent. But we seem to have this discussion on a regular basis. The way I see it is this: As an end-user of an application you should not or do not care what backend system is used. So after application capability, a match with the existing environment or cost of ownership is going to be the driving force behind your decision. As a developer of the application in the modern world you are going to stay with what you know. Unfortunately, if you stay on Green Screen you are probably going to not pick up new customers and will slowly lose existing ones. So you have a choice, carry on banging on about how U2 is so great, (who really cares apart from some of us), or look at modernising your application. I would pick the latter, and I would do it in such a way that my new application architecture would enable to pick a chose different technologies at the different layers (including DBMS) going forward. The match of the application functionality to the business requirements is what is going to sell it, not the fact that it runs on DBMS x or y. By using something like Microsoft SQL and its various versions, I can develop something and then scale it up as my user count increases.also all the tools that I am using are fully integrated with it already without having to buy 3rd party addons My 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 2 February 2011 8:15 a.m. To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? I find the whole licencing issue a real pain. Compare to sql server - express edition for free comes with 100 pooled connections as default - ok there is a max DB size I can then progress to a server licence - again any number of connection pools. Connection pools on unidata i get about 5 for the same kind of money From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 01 February 2011 17:58 To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? @George - you're probably right -- I found the doc on that link was dated Feb / Mar of 2010 -- that was well into Rocket-realm, but perhaps they just 'wrote up' the logic IBM used to make the change. And yes -- it appears the any 'socket' sets iPhantoms. The problem is that the logic does not address specifically the uses that could be 'abused' - but rather ALL uses. @Jeff / Symeon - That I can see, you don't 'consume' a 'purchased' seat running a phantom UNTIL you do a anything 'socket' - even if that Socket Use has the same use as a 'disk read'. As for use of cURL, WGet, etc - these are examples of the issue as I see it. Those are still an option to do exactly what we could do BEFORE this rule went
Re: [U2] What do you do with CallHTTP?
Storage is something completely different. Think of business objects rather than tables/rows/columns or file/record/fm/vm/sm/tm or even XML. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 2 February 2011 10:31 a.m. To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? While that all makes sense, the one difference here between U2 and the others (Oracle, MySQL, MSSQL) is the usage of multi-value data storage. Even if U2 had the best GUI interface, if you are utilizing the MV storage, you CAN'T Swap it out, without even more redevelopment. If your going to redevelop to not use the multi-value, then why bother with U2 at all, green screen or not. Guess it's a matter of how much you want to redevelop. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Tuesday, February 01, 2011 4:12 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? If you still have a green screen and want to put a GUI/Web interface on it, then do the redevelopment, but look to see if you can layer your application architecture so that the database can be swapped out the database if you need to for whatever reason. The value is in your application not the database. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
TRIM(expression,@VM,'T') I have not tested this but I believe the above will remove all trailing @VM characters. leaving any embedded ones. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, 1 February 2011 6:30 a.m. To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field If the field were just a VM, trim would have left it there. I didn't reject TRIM, I just didn't consider it (and not vehemently). In general, I use TRIM to eliminate extras and CHANGE/CONVERT to eliminate ALL Since the original questions was to get rid of all the VM's I went with CHANGE/CONVERT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, January 31, 2011 11:58 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field George, why do you so vehemently reject the TRIM or TRIMB solutions? I think it is the cleanest offered so far and requires the least coding. just my 2 pence Mecki On 31/01/2011 16:33, George Gallen wrote: The only problem will be if there are multivalued data elements by eliminating the VM's, it will combine into one big element. Maybe a subroutine to scan the string first to make sure there is only one element, then do the elimination (by whatever method). ex. 0001: one^253two^253^253 will become 0001: onetwo George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Monday, January 31, 2011 11:03 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field I like George's solution. On 1/31/2011 9:12 AM, George Gallen wrote: Am I missing something, or would CONVERT CHAR(253) TO IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),) Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO IN ... ... ... CLEARVM FXI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ViaDuct problem
It does not actually use Microsoft Visual Basic if that is what you meant -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Wednesday, 29 December 2010 3:16 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] ViaDuct problem In a message dated 12/27/2010 3:57:03 PM Pacific Standard Time, harold.o...@clark.wa.gov writes: Do others have an opinion of AccuTerm versus SecureCRT? AccuTerm also uses Visual Basic and you can call scripts to run from inside your Pick BASIC code. Just as you're doing now. W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CREATE.TRIGGER - Permission denied
Universe does not require root access to create a trigger. The article refers to Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Tuesday, 19 October 2010 7:30 a.m. To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied I have used Jbase for 12 years, and used Universe for many before that. I was surprised to learn that Universe requires one to have root access to create a trigger. Jbase doesn't require that, so I guess I was spoiled. Does anyone know of any compelling reason why Universe would require it? Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 10-18-2010 12:10 PM, Colin Alfke wrote: As others have noted you need to login as root to create the trigger. We use a program that does the following for each of our triggers (UniData on Windows with SB+). DELETE.TRIGGER filename UPDATE DELETE.CATALOG triggerprogram BASIC programfile programname CATALOG programfile programname FORCE CREATE.TRIGGER programfile programname UPDATE Hth Colin Alfke Calgary, Canada -Original Message- From: Mecki Foerthmann Hi, Today I tried for the first time to create a trigger on Unidata (Version 5.2 on Solaris) and get this error. I have to add we are using SB+ and Avante 9.2 which includes PRC 3.9. First time I tried this I actually got an SB+ error (line 200 something) - and when I run it from true ECL I just get the message PERMISSION DENIED. I even changed the LOGIN VOC entry to bypass SB+ - no luck either. The file in question has 777 permissions on Solaris, so this couldn't be the problem. The subroutine is globally cataloged too and there are no triggers on the file already. It isn't a DIR file either. Well, I haven't checked that, but all our data files are hashed. I'll check it tomorrow morning. Any ideas? I know Avante uses triggers for its audit files, so why can't I create my own? Susan perhaps? Is it your application that stops me? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped with TRANS...
Universe does some caching around TRANS from memory. So if you want to only do lookups your results may indicate a good solution. However, for update it will not work, and depending on the number of files being accessed, you may find there are issues with the cache being rotated. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Tuesday, 19 October 2010 1:01 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Stumped with TRANS... FFT2001 wrote: Has anyone done a timing test to compare a SUBR which uses a common section to store an opened file variable vs a TRANS ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users I did a simple timing and comparison test some time ago: http://mvdbs.com/2006/01/25/timing-trans-and-read/ http://mvdbs.com/2006/01/25/timing-trans-and-read/ Cheers, David J Murray - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Stumped-with- TRANS...-tp29910397p29995851.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped with TRANS...
The trouble with using common for things is when you get into client/server development. You cannot guarantee the common will be available to you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Tuesday, 19 October 2010 2:45 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Stumped with TRANS... phil walker-2 wrote: Universe does some caching around TRANS from memory. So if you want to only do lookups your results may indicate a good solution. However, for update it will not work, and depending on the number of files being accessed, you may find there are issues with the cache being rotated. Yes, I also believe that there is file caching for the TRANS. I thought that where was a UniVerse parameter for tuning the memory allocation etc.? Like most things, the programming philosophy and techniques has to be supported by the system settings. As a side issue, there are also a series of routines within UniVerse itself (no SB+) for doing file open caching - see http://mvdbs.com/2007/11/05/appprogs-open-tools/ http://mvdbs.com/2007/11/05/appprogs-open-tools/ Cheers, David J Murray - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Stumped-with- TRANS...-tp29910397p29996275.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
In summary, to get triggers working as you want in UV you need to: a) Have a stub subroutine which is globally catalogued b) This stub subroutine is the one which you attach to the trigger c) This stub subroutine calls the main subroutine which does all the work The benefit of this is the stub subroutine will rarely change and so you will not Have to go through the whole drop/create trigger scenario. UV seems to keep Track if the called subroutine changes and will cause a runtime error if it has. You are then free to change your main subroutine as often as you like. You should Probably only catalog it though when the system is quiescent. d) If you want to execute a command from TCL which is on the banned list. Unban it e) On attribute 4 of the VOC entry for the verb e.g. SH, add an H to the list of letters. f) This will allow you to perform the command with a transaction. A trigger has an implicit transaction. This however does not get around the issue of trying to debug a program which accesses A file with a trigger on. If you execute a write or delete on this file while debugging then You will get an errorbut this is a separate issue and a pet peeve of mine which is hopefully Getting sorted. We have been using this for years with no adverse effects, but you do need to be aware that you Will not be able to rollback what you are doing...In the case of emailing though this is probably Not something that you care about. Regards, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Barry Rutherford Sent: Saturday, 31 July 2010 8:01 a.m. To: U2 Users List Subject: Re: [U2] Universe Triggers Have the subroutine that's called from your trigger routine write a record into a file with the details for emailing. Then create a program that runs in cron that reads that file and sends your emails Barry Rutherford Programmer / Analyst MobilexUSA 930 Ridgebrook Rd, 3rd Floor Sparks, MD 21152 Local: 443-662-4101 x 6162 Toll Free: 800-786-8015 x 6162 Fax: 443-662-4225 http://www.mobilexusa.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 3:47 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record to this file is not to be. Apparently executing an SH verb in a trigger program is not going to happen (Verb SH illegal when a transaction is active.). Boom Splat. Henry Unger wrote: Lock the record before you write it. Henry Unger Sent from my iPad On Jul 30, 2010, at 2:47 PM, Jeff Schasny jscha...@gmail.com wrote: So far so good. Trigger installed. Trigger blows up. My trigger program calls the *MAIL.SEND routine (which works when called from other programs in this account) which is apparently blowing up when attempting to write an item to the current directory (UFD) at line 214. Anyone have a guess on what this means? Program *MAIL.SEND: Line 214, FATAL: The locks necessary for database operations at the current isolation level (0) are not held by this process. Error performing trigger for /upg/CUBUPG/CO.TF -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail (including any and all accompanying attachments) may contain privileged and confidential information only meant to be accessed and used by the intended recipient or the person(s) authorized to access and deliver the intended recipient's e-mail. This e-mail may contain information that is privileged or otherwise confidential. It should not be copied or forwarded to any unauthorized persons. If you received this e-mail in error, please delete it without copying or forwarding, and notify the sender by reply e-mail or by calling the MobilexUSA Privacy Office toll free at 1-866-686-1717. Thank you for your cooperation.
Re: [U2] Unidata 7.1.9 and .Net DLL
Is there an equivalent in Universe, or is that GCI which means building UV not calling a dynamically linked library as far as I understand? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, 22 July 2010 6:45 a.m. To: U2 Users List Subject: Re: [U2] Unidata 7.1.9 and .Net DLL Lookup callc There are notes on how to implement on UNIX (link with makeudt) and Windows (dll with E voc item) Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, July 21, 2010 12:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 7.1.9 and .Net DLL From Don Verhagen: Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 params... I really didn't know that this call-out functionality existed. I know GCI allows for invoking COM from UV. UCI has been equated to GCI but I don't think they're the same at all. Does Unidata support GCI? What is this E item syntax called, and where can I find a doc on it? Does Universe support this E item syntax? Does anyone have any performance data for this E syntax? I'm wondering if DLLs are truly linked and they stay in memory, or if they're dynamically referenced on every invocation. The former is painful only on first execution. The latter would alwould be painful and we might as well Execute/SH. Heck, I can see entire libraries of new functionality being created with this mechanism. Deployment would be Muuuch easier than GCI. Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula- RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
You could try setting adding an 'H' (I think) to attribute 4 or 5 of the VOC MESSAGE record. This will allow the verb to be issues as part of a transaction Sorry to be vague, but I am not connected to a system at the moment... Cheer,s -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 1:30 p.m. To: 'U2 Users List' Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? We have a jsp page that calls a Universe subroutine using that method detailed in the JDBC manual, this works as expected and the subroutine completes it's task successfully. Also from a separate phantom process for certain important events we have some code that sends a splat message to line 23 of specific users' sessions (this uses the Universe MESSAGE command) -this also works fine. We're now trying to get the subroutine called via JDBC to also use the MESSAGE command. But each time it throws this error message into the uv errlog: root VOC entry MESSAGE illegal as or in a procedure. Does anyone know what's wrong here? I've looked through the manuals and the help and can't find any mention of this particular restriction. Thanks, Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Soap error question
I don't believe that is correct. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, 11 May 2010 8:45 a.m. To: U2 Mail List Subject: Re: [U2] Soap error question What? You can't make a SOAP call to a U2 program if that program has a CALL in it? Bill Lunt, Bruce said the following on 5/10/2010 11:53 AM: Sorry for the delay in my response, I was out of the office for the last week. It turns out that the problem was that I was calling a subroutine in my program and that doesn't work with soap. So, I included the subroutine's logic into the Basic program and it works now. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 03, 2010 11:33 AM To: U2 Users List Subject: Re: [U2] Soap error question I haven't worked a ton with SOAP requests but figured I'd throw this out there any how... Do you have a permissions error preventing a write? It seems most of what you've mentioned that's working are just reads but the one that write is failing. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, April 30, 2010 6:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Soap error question Hi All, We have a strange result happening with a simple soap service call and I was hoping someone has seen this problem or something like it before. We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP SSN.SUBMIT. Each program has 2 inputs: CUST.NO SSN and 1 output: VERIFY. The first one: SSN.VERF is a program on UniData that accepts Cust.No last-4 of SSN. The program then reads the customer record and validates that the last 4 of that customer's SSN match the 4 digits sent in the transmission. If they match then it returns a 1 in the variable called VERIFY. Otherwise, it returns a 0 (zero) in VERFIY. SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have it verified as well with the same VERIFY variable being passed back. SSN.SUBMIT: Is for adding the SSN to the customer's record if it does not already exist. It checks for the existence in the record and in the cross-reference file and returns 1 if the update was successful and zero otherwise. Now for the problem: SSN.VERF SSN.VERF.SUP both work as expected. SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is already on file) but whenever a valid SSN is entered for a customer with a blank SSN field it fails with a strange error message, like this: soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body soapenv:Fault faultstringException: Internal Web Service Server Error/faultstring detail UniSOAPException errorException: Internal Web Service Server Error/error /UniSOAPException /detail /soapenv:Fault /soapenv:Body /soapenv:Envelope Can anyone suggest how we could debug this problem? Is there a way to capture whatever it is that is freaking out the soap process? TIA, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listing via the SQL Interface...
Remember the LIST.READU INTERNAL format to get a dynamic array... unfortunately it is row based rather than column based otherwise you could have probably created a dictionary to decompose the data as sets of related multivalues ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 11 May 2010 4:00 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Listing via the SQL Interface... [ad] I'm not sure what SQL tools you're talking about but with mv.NET you can easily call BASIC subroutines from ADO.NET as though they were Stored Procedures. So wrap LIST.READU in a program, format the output the way you want and call it like a sproc. If you just want this data outside and you're thinking you need to do it with SQL, that's not correct. If you can describe the client-side environment maybe we can provide a more elegant method of delivering the data. Any help? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: John J. Wahl Platform: UniVerse Version: 10.2.x O.S.: Windows Server 2008 (x86) 32-bit I'm wondering if there a way to get a listing of READU locks (exactly like the Verb LIST.READU, but via an SQL interface? I was going through the documents and old forum posts, but I do not see anything. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
You need to use the 32-bit odbc driver manager. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 23 April 2010 8:01 a.m. To: U2 Users List Subject: [U2] UniODBC/UniOLEDB and Win2008? I have a customer who has downloaded the most recent Unidata clients from the Rocket website and is trying to install them on Windows 2008/64- bit. The installation appears to go according to plan, there are no errors and no events logged, and yet after installing the ODBC driver, the Unidata ODBC driver is not listed in the list of ODBC data sources for the server. Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Updating SQL database from Universe 10.3
If your UV is on windows then this can be done as the DSN/drivers will be on the UV server. Whereas on Linux/Unix you need a ODBC driver manager and drivers installed to use the BCI functionality if going to a non-UV database. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Marc A Hilbert Sent: Thursday, 15 April 2010 2:00 p.m. To: 'U2 Users List' Subject: Re: [U2] Updating SQL database from Universe 10.3 Perhaps I am not understanding some part of the issue, but we regularly update on-line SQL, Oracle or DB2 from UVBasic, using Universe 10.2 running on windows, without any middleware. It was just a question of reading the manuals regarding the steps: - Set up a System DSN - Update uvodbc.config - Test connection with CONNECT - Write the program, taking the following steps: - Allocate the environment (SQLAllocEnv) - Allocate the connection (SQLAllocConnect) - Connect to the DSN (SQLConnect) - Allocate the statement (SQLAllocStmt) - Run the statement (SQLExecDirect) - Free the statement (SQLFreeStmt) - Disconnect (SQLDisconnect) - Free the connection (SQLFreeConnect) - Free the environment (SQLFreeEnv) Regards, Marc -Mensaje original- De: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] En nombre de John Hester Enviado el: miércoles, 14 de abril de 2010 17:21 Para: U2 Users List Asunto: Re: [U2] Updating SQL database from Universe 10.3 If you need UV to initiate the update (UV is the client, SQL is the server), you're going to need 3rd party middleware to talk to SQL Server. We do this in near real-time (a batch job runs every 3 minutes with updates) from UV to SQL 2005 via OpenLink's ODBC middleware. You'll want to review the UV BCI manual for details on establishing a connection and sending the data from a BASIC program. Initiating the update from SQL Server doesn't require any add'l software. You can use the ODBC connectivity built into Windows. We don't use this in production, although I have used it before to populate Excel spreadsheets. We do have UV acting as a server for JDBC connections in production, though, and the setup on the UV side is the same. You'll want to see the UV ODBC Guide for instructions if you're going this direction. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: Wednesday, April 14, 2010 12:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Updating SQL database from Universe 10.3 Good Day, I need to update SQL database/tables from Universe, and I was wondering if anyone has done this in production mode in real-time mode. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Input is not permitted when a trigger is active
Can we get a resolution to this added to the better and better list? I have complained about this for years ;-) I assume the restriction is to disable INPUT statements in the trigger subroutine, although there may be cases when this might be useful , not to disable debugging of programs which access files with triggers on them. For a solution in order of preference but probably increasing difficulty to implement. a) It would be good to be able to debug the trigger code. b) It would be good if the debugger stepped over the trigger without user intervention at a minimum. Cheers, Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Monday, 12 April 2010 1:45 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Input is not permitted when a trigger is active Unfortunately, this is a 'feature' of UV/SQL Triggers. You will have to disable the trigger first, if you wish to use RAID. There aren't any means to avoid this. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Monday, 12 April 2010 11:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Input is not permitted when a trigger is active U2-listers, Can anyone shed light on the message in the subject line? I have searched all over the place and tried quite a few things to prevent it happening. I am running RAID on a program that updates a file that has an update trigger on it. As soon as the program hits the WRITE statement to the file in question, it crashes with the above message. Any assistance would be appreciated. Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Common Table Expressions
Hi Symeon, I have been trying to think how you would use CTE (or equivalents) in u2 SQL. Are you willing to enlighten us? Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 8 April 2010 8:16 p.m. To: 'U2 Users List' Subject: Re: [U2] Common Table Expressions It could certainly work in u2 SQL - not sure how you would do this in English (MVQuery or whatever) tho -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: 08 April 2010 06:55 To: U2 Users List Subject: [U2] Common Table Expressions Just working on a SQL project which uses lots of CTEs (Common Table Expressions) for in-memory caching of table data. Really useful things in terms of speed and not having to create temporary tables for manipulating data. Wondering if anyone has thought about if or how they might work in U2... Just a thought for better and better (which is down at the moment.) Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Speaking of MsSQL 2008 ...
I suspect it may be a security/permissions issue. Have you checked the event logs? How have you got security set up for the connection? When you run the job manually the job will Be probably using your credentials, when you run as agent job it may be running as a service account? Just a thought -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Friday, 15 January 2010 6:16 a.m. To: U2 Users List Subject: [U2] Speaking of MsSQL 2008 ... Not to tread over the same path for a thousandth time (oh this poor path), but has anyone actually been able to get SQL Server 2005 or 2008 to actually do a linked server directly to UniVerse and still get that link to work when setting up SQL Agent jobs on the Microsoft SQL Server to run at night? I had one working on a test server for a while, but it would only run in the Management Studio when I manually ran the SQL, it would never work at night using Jobs in the SQL Server Agent, so I gave up. I've never gotten SQL Server to directly connect in my office, so they still have their half dozen work-arounds here, all using things like Microsoft Access and Linked Tables, then finally linking those Access Databases to SQL Server. I've tried to make changes to some of their very duct-tape like solutions, but I too failed to get their UniVerse system to be read by SQL Server using any connection type for that matter, including Mecki's SSIS concept. I have one machine here that is running SQL Server 2005 Developer edition, which seems to have far more Providers and has had more luck connecting to UniVerse in my tests, but once I try to do anything via a nightly job, the same queries that may have worked for me manually would fail to execute. Of the 3 servers I have two running Windows Server 2003, and one is 2008 Std 32-bit. The 2008 box is also the UniVerse machine, which runs 10.2.x. I'm fairly certain if the Linked Server idea would work, it's an issue w/ either using the wrong provider or having a bad string for the Connection, but everything I have personally read has failed (at least for UniVerse). Anyone run into this type of headache in the past? John J. Wahl Employee Owner (and U2 convert, yes I was an Microsoft only guy once *cry*) Programmer / Analyst Tel:  (330) 528-0091 Ext. 118 Fax:  (330) 655-8458 Email: jw...@joseph.com Web:  http://www.Joseph.com/ Original-Nachricht Datum: Thu, 14 Jan 2010 08:43:06 -0500 Von: Lettau, Jeff jlet...@polkaudio.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad] You may not want to do this due to volume of data your trying to pull, but... Have you tried setting up your UD5.2 server as a linked server in SQL, then creating views to your linked server. Then use SSIS to pull from the views, that way it doesn't know it isn't a SQL data source? Performance isn't bad if your limiting your I-desc and keep the data to single files in UD. Also use indexes in your UD views to limit your data. You can't pass variables for data selection this way. You can limit data by day using @date-99 type i-descriptors or just write a quick program to pull your data to a temp file, then pull the file for updating things incrementally for Cognos. Jeffrey Lettau -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Saturday, 31 October 2009 5:46 p.m. To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Phil, My test file is 1009,1 type 18. My record id is just a sequential number 1 to 10,000 for this test file and the data is only 40-50 more bytes. So I don't think the file size is the problem. I've tested the logic by calling the trigger subroutine direct from the program and I get a 2 second process time, so I don't think the logic is the problem either. Are you on Universe or Unidata? Thanks for the response. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Friday, October 30, 2009 5:39 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Check your file sizes out or your logic, because I experience nothing like this still subsecond responses, and we use triggers for auditing/data quality/ and replication through a log/webservice to sql, although the later part of that is handled asynchronously -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Saturday, 31 October 2009 6:45 a.m. To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Thanks Doug, That's pretty much the conclusion I came to after I ran my test on a 10.3.3 Universe system. Unfortunately, this application doesn't use a common WRITE or DELETE routine, so I get to update about 90 programs with the audit logic. It'll be tedious but not too bad. Thanks for the feedback Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions www.tri-sysconsulting.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, October 30, 2009 12:19 PM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Curt, We run Web applications a 25 second delay would be a death march for our staff with the users pointing things at us. This is a known Universe issue and to be fixed on a later release according the folks at U2 University. We wrote our own auditing the works with Universe and Unidata. This is pretty easy for us since high percentage of our writes and deletes are handled out of a single subroutine. The programs that use their own WRITE or DELETE had to have all another line or two added to complete the auditing processes. We have about a 50-300ms delay for the additional read and writes to the audit file. This strategy works very well for our call center application. Regards, Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Friday, October 30, 2009 10:37 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers The speed issue is not in the subroutine itself. I tried a subroutine that did nothing, just a return and the process takes 25 seconds compared to 2 seconds with out a trigger. My main trigger subroutine is using a common for the file opens and that did cut the processing time down from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. Does Universe require any special settings for triggers? Or file types? Does the account have to be a specific flavor of Pick? Permissions? I don't know any other thoughts or suggestions? My searches have not turned up anything useful but someone's post did say that they found it to be slow on 10.2 but they did not elaborate or get a response that I found. Thanks for your help. Curt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Check your file sizes out or your logic, because I experience nothing like this still subsecond responses, and we use triggers for auditing/data quality/ and replication through a log/webservice to sql, although the later part of that is handled asynchronously -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Saturday, 31 October 2009 6:45 a.m. To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Thanks Doug, That's pretty much the conclusion I came to after I ran my test on a 10.3.3 Universe system. Unfortunately, this application doesn't use a common WRITE or DELETE routine, so I get to update about 90 programs with the audit logic. It'll be tedious but not too bad. Thanks for the feedback Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions www.tri-sysconsulting.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, October 30, 2009 12:19 PM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers Curt, We run Web applications a 25 second delay would be a death march for our staff with the users pointing things at us. This is a known Universe issue and to be fixed on a later release according the folks at U2 University. We wrote our own auditing the works with Universe and Unidata. This is pretty easy for us since high percentage of our writes and deletes are handled out of a single subroutine. The programs that use their own WRITE or DELETE had to have all another line or two added to complete the auditing processes. We have about a 50-300ms delay for the additional read and writes to the audit file. This strategy works very well for our call center application. Regards, Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Friday, October 30, 2009 10:37 AM To: 'U2 Users List' Subject: Re: [U2] Universe Triggers The speed issue is not in the subroutine itself. I tried a subroutine that did nothing, just a return and the process takes 25 seconds compared to 2 seconds with out a trigger. My main trigger subroutine is using a common for the file opens and that did cut the processing time down from 2 minutes to 25 seconds, but 25 seconds still seems pretty slow. Does Universe require any special settings for triggers? Or file types? Does the account have to be a specific flavor of Pick? Permissions? I don't know any other thoughts or suggestions? My searches have not turned up anything useful but someone's post did say that they found it to be slow on 10.2 but they did not elaborate or get a response that I found. Thanks for your help. Curt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Well, when our company gets this fully implemented. You can count over 250 Highlander's Immortals on the list! Seriously, check out agile and scrum, it is interesting. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 3:26 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Ah, it must be lovely to know that you will live forever and will never become ill or incapable of working... Eventually, if the company does not go out of business, or their business needs change so much that all your code is obsolete, somebody else will have to figure out how the system works. A good spec turns into good documentation, which (properly maintained through all the ensuing changes to the system for the changing needs of the users, of course) is a blessing to the person who follows you. Sounds like we have at least 2 of Highlander's Immortals on the list! ;-) Susan Lynch - Original Message - From: Brutzman, Bill bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 3:20 PM Subject: Re: [U2] Unibasic: Sample Program John's world is similar to my world here. When I realized that I would be the only person reading the specs, I stopped writing to myself. At the risk of no longer being a professional dinosaur, I learned that some people call it agile. Check out... Eckhart Tolle's book The Power of Now. --B ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program - Scrum/Agile methodology
Possibly, and while it probably works better with internal teams, I think it goes back to what I was saying about it being a partnership approach. Most vendor/customer relationships are not partner at all, they may say it is a partnership, but the nature of the beast dictates otherwise. So if a vendor/customer can have a true partnership and it then I think it can work, it is just a matter of people defining what the project is, committing resources and producing results. Both sides have to buy in though and this is the big culture change for most if not all organisations... I do quite a lot of work in the BI field these days, and with the right tools we are usually able to deliver solutions quickly in a few days which gives the business user and idea of what they can achieve. To sit down and spec this with them would take a lot of time and effort and will will guarantee 100% there will be changes due to crappy data, missed business logic, or just not understanding what indeed they wanted or what they could achieve. Showing them by doing and pictures...what is it a picture is better than 1000 words...works far better in my experience. Again though the business user has to commit to the process as well and be available and focused in delivering a solution. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 15 October 2009 9:30 a.m. To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample Program My experience in this is as a software vendor - it can be very dangerous to engage with a customer in an agile development - As a vendor we supply our packaged product with a certain amount of modification. It is very important that such modifications are ring fenced, costed and planned before the project even starts. i.e. part of the sales discussions. As hinted many see agile as somewhat open ended so great care is needed. It probably works better for internal projects as opposed to a vendor doing enhancements for a customer. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: 14 October 2009 20:56 To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Well, when our company gets this fully implemented. You can count over 250 Highlander's Immortals on the list! Seriously, check out agile and scrum, it is interesting. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Re: [U2] Unibasic: Sample Program
I could not put it more eloquently Ross. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, 15 October 2009 1:00 p.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I think it also depends on a lot on the toolset you are using. This approach, if you are writing code in pure pick basic, with minimal dictionaries for the files you are using could be suicidal, yet with the right tools and mindset, this can be a VERY productive way of working. In this regard, I firmly agree with what Phil said in relation to his BI implementations - often it is far quicker to just do it than to describe what it is We have dubbed our implementation of agile, iterative development vRapid, and we have found it works very well in practice. Sit down with the customer, discover the data that needs to be (or is already being) kept and design some files and dictionaries around that. Document the inter-relationships as part of the Dictionary, and mock up some screens with these data definitions. These screens get fattened out appropriate business logic engaged during the iterative process, and in little more than the time it would take to develop a traditional spec you can have a fully functional application and the client has been engaged 100% during the whole process, so there are no surprises, and they are VERY HAPPY (and because they have seen how easy it is to accommodate change, the application IS likely to keep on growing organically, but this is controlled feature creep that you get paid for!) With the right framework in place, this approach can be a real winner, and deliverables can start to flow be deployed long before the entire project is complete, so it can become a win/win situation Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Thursday, 15 October 2009 6:56 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Well, when our company gets this fully implemented. You can count over 250 Highlander's Immortals on the list! Seriously, check out agile and scrum, it is interesting. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 3:26 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Ah, it must be lovely to know
[U2] Universe PE Client Download
I may be blind or having one of those moments, but where can I download the clients for Universe PE on the Rocket site? I downloaded the Universe PE Windows edition and it did not include any client software, but none of the other links seemed to make sense either. Phil Walker Principal Consultant | mobile * +64 27 5336294 | email * ph...@gnosys.co.nz Gnosys Consulting Limited 25 Roscrea Place * RD2 * Kaiapoi 7692 * New Zealand | phone * +64 3 3120352 | fax * +64 3 3120354 | email * supp...@gnosys.co.nz ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connection Pooling Statement
Tony, well said. I had not really considered your examples as breaches but if you take the letter of the law I guess they are, which like you says would probably put 99% of sites in the violation of licensing bucket... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, 25 September 2009 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Connection Pooling Statement According to the letter of the U2 terms, common usage of the environment is prohibited without the purchase of a connection pooling license - that means many of you are in violation right now. I personally don't approve of a vendor who has a potential lawsuit pending over a large segment of their customer base and I hope Rocket Software will do something about this. For example: - You can't have a character terminal used as a POS when it is shared by more than one cashier. - You can't have a terminal on a shop floor used by multiple people. In the above examples, to the letter, every user must physically logoff, then log back in before they can perform an operation. Can anyone here really see that happening? This is an issue for non-terminal applications as well: - Web sites, Web Services, SOA, and SAAS cannot be deployed according to current licensing without a connection pooling license. - If you have your U2 system driving your time cards, you should have the server logout and then log back in for every person punching in or out. This increases processing time from about 1 second per transaction to at least 20. - Anyone walking up to a kiosk which uses U2 as a back-end must legally perform some action that causes a physical logout/login. - If you have a U2 port processing inbound data from credit cards, weight scales, bar code scanners, or other devices, you should be logging off and back anytime a new user initiates a transaction. Rocket Software should get someone other than an IBM lawyer who actually understands how this software is used. The situation to-date has been ridiculous. No vendor wants their runtime licenses abused with a thousand end-users on a single license. We need licensing that is somewhere between that and where we are now. This goes for all MV DBMS providers who are stuck in the dark ages of per-seat/per-user licensing. In a world where we have such a high volume of commerce performed over the internet, we need licensing that agrees with the physical limits of the technology. That is - there is only so much you can physically do with a connected process. There is no such thing as unlimited use of a single connection. While any process is occupied, a physical limitation compels us to redirect to another port for another user to perform their operations. Reasonable licensing will allow us to maximize the use of every process, rather than forcing a draconian reconnection, or compelling unused processes to go unused as new processes are started for every possible user. The U2 connection pooling license, and other attempts to extract higher fees as a defensive measure in the face of modern usage, only serve to limit MV as a viable option for modern applications. If it costs too much to deploy a multi-user application with MV, developers will simply choose another platform. IBM gets 100% of nothing with their current pooling license from developers looking for a platform to create a new web-based application. MV DBMS vendors need to understand that we can create a lot more applications, and sell a lot more licenses, if the model is made more reasonable and equitable. Create a low-cost model that allow individual ports to process as much data as they phyically can, or charge based on other metrics like bandwidth, disk usage, CPU cycles. Make a profit on volume of applications sold, rather than trying to coerce the traditional market into making up for lost revenue. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! From: David Wolverton Interesting! When we've tried to do the same, the time to login/logout/login again KILLED performance - and you had to do it for each 'piece' to stick to the letter of the law... Is UOJ somehow 'faster' at doing these Login/Out/In connections than other methods exposed by U2? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mixed Case UV Basic Programming Standards.
As anyone written or thought about writing a code refactorer for U2-BASIC, this would/could/should standardize code semantics and also appearance? If this could be made configurable to the style you want to use then that would be good...and any program with a GOTO in would be deleted...without warning ;-). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Thursday, 25 June 2009 8:45 a.m. To: 'U2 Users List' Subject: Re: [U2] Mixed Case UV Basic Programming Standards. Oh, you didNot say GOTO... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, June 24, 2009 2:39 PM To: U2 Users List Subject: [U2] Mixed Case UV Basic Programming Standards. I don't like the way I use mixed case, so it tends to evolve. Not good, because consistency in programming style throughout an application makes for easier maintenance, maintainability is the god of software quality. So I am wondering how others use mixed case. Do you capitalize/lower/mix case for commands? Operators? Variables? Equates? etc. How do you use/not use special characters in variable names? For example: readu OrderMaster from ORDER.MASTER, OrderMasterId locked ... readU OE_rec from OE_f, OE_id locked ... ReadVU OE_Date From ORDER.MASTER, OE$Id, OE$Date Locked ... READU order.master.rec( oe$date ) FROM order.master.file, order.master.id LOCKED ... That sort of thing. I hesitate to even ask this for fear of starting a war. So ground rules for this thread: 1. NOT about MERITS of Uppercase only vs. Mixed Case programming. I am only interested in answers from people who actually use mixed case. 2. NOT about GOTO. Take it outside. 3. This is about PREFERENCE, NOT SUBSTANCE. By substantive I mean rules like: - Only open a file once. - Readu should always have a locked clause. By preference I mean stuff like my example. They are all functionally equivalent. 4. NO ARGUMENTS about whether someone's style is good or bad, or yours is better. Explaining why you do it a certain way is helpful, though. Just remember, when it comes to preferences, no two programmers will agree, yet consistent style, whate'er it be, increases maintainability. Thanks, Chuck Stevenson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What Program Am I?
Depending on the version of UV you are on you should be able to access SYSTEM(9001) from memory. This is an array which contains the call stack. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David A Barrett Sent: Wednesday, 24 June 2009 8:46 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] What Program Am I? We've got a UV client/server application with a thick VB client. The vintage is around 1997, and the architecture has a debug mode that I leave on all the time that logs the calls back to the server and the arguments passed back and forth. The server side stuff is all phantomed off, so the output is in the PH file. Additionally, you can put display statements in the server side programs and the output from these will be sent to the PH record, mingled in with the other stuff. Debugging is old school, as you can't step through programs and any DEBUG statement will halt the server side program with no ability to do interactive I/O, and the client side window will appear hung, requiring the three finger salute. So you spend a lot of time putting in lines of code that look like: DISPLAY HERE I AM #17 and the like. Eventually I got fed up with counting value marks in PH file records and wrote a routine that formats MV data up nicely for display and makes a lot of tedious stuff easier. It makes my life easier. For tricky parts of the system, I often leave the debugging output calls in the programs; in case I need to come back some day and fiddle some more. But there is one thing I'd like to be able to do... It would be super if it were possible to see the call stack from a running program. Kind of like the the UV T debugger command. Sometimes I'm just wondering, How the hell did I get *there*. Or I'll see debugging output in the PH file and I wonder, What program is that from?. In those cases it would be useful to have the call stack sitting beside the output in the PH file. Does anybody know a way to do this? I've even considered building a little $INCLUDE snippet that updates @USER1 or a named common area and recompiling ever server side program with it added. Any help will be greatly appreciated. Dave Barrett, Lawyers' Professional Indemnity Company ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Tracing UV system calls, linux
Can you provide details of the environment? e.g. production/dr/uat/development or all universe release number of users, type of application (generic) guest operation system and release, kernel, glibc etc vmware tools AND what you mean by the last part. This would be useful information as @ the moment I am planning with a client to a possible move from RHEL 4.0 onto a VMWare platform for all environments, production, dr and dev. Cheers, Phil. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Monday, 8 June 2009 11:16 p.m. To: U2 Users List Subject: Re: [U2] Tracing UV system calls, linux Hi. We had a similar issue with Universe under Vmware Infraestructure. But it was a telnet issue. We solved it after: - patching the Universe host to the last O.S. patch level, - installing the last VmwareTools - AND making sure that the host Operating System was exactly described in the ESX server. HTH Augusto - Original Message - From: John Hester jhes...@momtex.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Sunday, June 07, 2009 3:51 AM Subject: Re: [U2] Tracing UV system calls, linux -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Friday, June 05, 2009 11:35 AM To: U2 Users List Subject: [U2] Tracing UV system calls, linux Does anyone know of a way to trace system calls made by UV as a non- root user? Here's the problem we have: UV on RH ES 5.1 joined to an W2K3 native mode AD domain. We have an AD issue that causes UV to either fail to execute, or die before the user can enter the environment. This doesn't happen to all users, and appears to be random, but affects more users over time. Usually a user can get into UV eventually after repeated attempts. Once they're logged in, everything's fine. --- Update - turns out this is not an AD issue after all (at least not directly, anyway), it's an issue with specific /dev/pts/... terminal device files. I wasn't seeing it with non-AD UOJ connections because they don't use a tty device. Once I realized it only affected a specific tty device, I was able to reproduce it with any login, including root. I noticed that 2 UV sessions were showing in PORT.STATUS with ? as their PID and a blank tty device. uvlictool clean_lic -a got back 2 seats. I restarted UV after that, and now the problem's gone. Unfortunately I didn't think to try to reproduce the problem before restarting, so I'm not sure if cleaning up the licencing alone fixed it. Anyone know what might suddenly cause UV tty sessions to hang in an ambiguous state on exit? Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] RE: Truncated catdir names
Any reason for not resizing catdir as type 19? I have done this and nothing seems to have broken. In fact I would hope that it would not as the file type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir names Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, 27 May 2009 4:02 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Truncated catdir names I made an unpleasant discovery when I recataloged (normally) one of my accounts (UV10.0, HP-UX). Some of the catalog names became too long (e.g. *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW, .RV, .SE). All of these resulted in the same truncated name so only 1 catdir entry was created, which was for the last one of the 5 cataloged. The catdir path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of *GET.COUN . Trying to run the programs results in a warning File name *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE. Is this a known limitation ? Why does the directory nesting stop at the 2nd level ? The VOC entries show the full names. catdir is type 1 out of the box. David Norman Senior Software Engineer - SA Ambulance Service ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** --- 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] Paragraphs and procwrite
Okay, you can use @system_return_code or @userx to do this. They can both be checked in the Paragraph after returning from the BASIC program to see what happened. If you want to know how let me know. Cheers, -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of roy Sent: Tuesday, 26 May 2009 1:31 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Paragraphs and procwrite To explain a little better ... The paragraph calls many other procs and paragraphs as well as a number of basic programs. What I found is that if someone exits a basic program, control is returned to the calling paragraph. Since the paragraph is in use I cannot modify it and accomplish anything that way. Obviously reading something from the command line won't work in this circumstance. With a PQ type proc I could set a flag like INVALID and procwrite it back to the calling paragraph for testing to see if the proc should continue. I believe the idea of using @user0 may work but I haven't had a chance to test it. I was also hoping to avoid writing something to a file since there are many instances of this and clearing the flags could be a problem. Thanks again, Roy -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker Sent: Sunday, May 24, 2009 8:07 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Paragraphs and procwrite Maybe I have come in late or are missing something in the question but can't you just use: Command = 'paragraph ':arg1 Execute Command Then in the paragraph Do something like PA * C2,arg1 Cheers Phil. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Monday, 25 May 2009 12:01 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Paragraphs and procwrite You can have the basic program generate the paragraph dynamically, and save it in the Voc under a temporary name. You can even have that paragraph delete itself when it is done. - Original Message From: Brian Leach br...@brianleach.co.uk To: u2-users@listserver.u2ug.org Sent: Saturday, May 23, 2009 7:45:04 AM Subject: RE: [U2] Paragraphs and procwrite Hi You could use one of the user-defined system variables: e.g. @USER0 E.g. PA CallMyProgram IF @USER0 = SomeFlag GO DoSomething PROGRAM CallMyProgram @USER0 = SomeOtherFlagActually END -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of roy Sent: 22 May 2009 23:15 To: u2-users@listserver.u2ug.org Subject: [U2] Paragraphs and procwrite Hi all, Is there a way to accomplish passing an argument from a basic program to a paragraph? Something like what procwrite does with a Proc? Thanks --- 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/ --- 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] DATE.FORMAT illegal when a transaction is active
Universe triggers start an implicit transaction. As a transaction requires that is is recoverable, then by default Universe does not allow the execution of certain verbs within a transaction. You get around that by putting an H into field of the VOC entry as suggested. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Thursday, 16 April 2009 2:52 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] DATE.FORMAT illegal when a transaction is active Thank you to those who assisted with this issue. Adding 'H' to the DATE.FORMAT verb did the trick. However, it is not apparent why it did! Perhaps Universe thinks it is running a transaction when a file trigger subroutine executes. No transaction was active. Regards, Ken Ford Universe Software Developer [cid:image001.gif@01C9BE8F.CF28AD00]http://www.firstmac.com.au/ Phone: (07) 3013 8686 Email: ken.f...@firstmac.com.aumailto:mark.b...@firstmac.com.au Web: www.firstmac.com.auhttp://www.firstmac.com.au/ ### ## This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) ### ## [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- 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] universe sockets
Maybe someone could put an example of this on the U2ug website, or Brian could include it in his training materials if he has not already so that people have an idea how to accomplish this ;-). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, 14 April 2009 9:30 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets We want to explore other connection options that are not tied to uniobjects so that if we decide to switch from universe to say database x we can do so easier. My only comment on this is don't go writing socket code just for this - just write a wrapper round the uniobjects code - so your code does not open a uniobjects connection and do read/write/select/run programs, it uses a class that you have written that in turn does this - pass a param to the class called DB and set it to uv - then when you want to switch to some other DB add the connectivity code to your class and away you go - basically you are building a DAL (Data access layer) upon which your BLL (business logic layer) works - the bll does not care what the DB is or how it communicates that is the job of your DAL. Rgds Symeon. --- 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] universe sockets
Sorry I was not clear enough. I was agreeing with Symeon, about the use of classes to encapsulate the BLL from the DAL? Mind you, you could use sockets in the DAL if you must ;-). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Tuesday, 14 April 2009 2:16 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets I hope so, because I would like to develop an in house iphone app that our users can use to query our database for prices/quantity available and sadly Apple only allows socket access to the closed iphone OS. If anyone has a pick server socket solution they would like to share I'd appriciate it (answering requests and spawning a program to handle each incoming request) otherwise I may go the route of moving the socket server to the OS (using init.d to handle incoming requests and to spawn a program to handle each request). But I think I am getting close (to getting a working non blocking pick socket server) and if I get it to work I'll post what I have to the web site. dougc -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker Sent: Monday, April 13, 2009 5:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets Maybe someone could put an example of this on the U2ug website, or Brian could include it in his training materials if he has not already so that people have an idea how to accomplish this ;-). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, 14 April 2009 9:30 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets We want to explore other connection options that are not tied to uniobjects so that if we decide to switch from universe to say database x we can do so easier. My only comment on this is don't go writing socket code just for this - just write a wrapper round the uniobjects code - so your code does not open a uniobjects connection and do read/write/select/run programs, it uses a class that you have written that in turn does this - pass a param to the class called DB and set it to uv - then when you want to switch to some other DB add the connectivity code to your class and away you go - basically you are building a DAL (Data access layer) upon which your BLL (business logic layer) works - the bll does not care what the DB is or how it communicates that is the job of your DAL. Rgds Symeon. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
SELECT FILENAME SAVING SWITCHIT Will work from TCL I believe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, 2 April 2009 11:01 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] SQL a possibility? I'm trying to save the first field of a .csv file to a select list, Yes, I can write a program, but I also wanted to try to do it on the fly. Using UV10.0.2 , unix on Information format The source data looks like: '#12345566#','first','last',. '#12344555#','first','last',. Basically, field one has the item ID of another file. The source file gets read into a tempory file input file I created an I-desc of the following: SWITCHIT 0001: I 0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; FIELDS(@1,REUSE(,),REUSE(1)) ; CONVERT(REUSE('# '),REUSE(''),@2) 0003: 0004: DATA 0005: 20L 0006: M The above will convert the whole record into one mutlivalue attribute, then strip off the first field delimited by the , then strip out the # ,' and spaces LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen exactly what I want and so does SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME'; NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... I could open a como file, list the output with no headings close the como file, edit it clean, the form-list the como file (work around 1) George --- 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] Does anybody have a hot backup server?
If you have a cold backup server I believe it is free, but you do need to get another license and sign an agreement. What we do is, we have Universe installed and licensed on the DR machine but not running. We use rsync to copy the data files from production to dr on a regular cycle. When production goes down we start up the DR machine and carry on. Of course this solution is not completely failsafe, as the application does not use transactions so it is possible that partial transactions may be committed to dr depending on timing etc, so it may not suit everyone, but it is enough for our needs. Phil. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, 19 March 2009 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Does anybody have a hot backup server? If it is Unix, consider using cron to copy data from A to B every hour or so. I talked with IBM a while back on this. My recollection is that IBM said we would have to buy UV user licenses for both machines. We had some additional big $ license issues here so for us, that issue went away. We are living with daily manual backups to both a portable hard drive (that goes offsite) and a local XP PC. --Bill -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Wednesday, March 18, 2009 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Does anybody have a hot backup server? I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- 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] Common UNIX Printing System
Yes on RHEL 4.0 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Bertrand, Ron Sent: Friday, 27 February 2009 12:46 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] Common UNIX Printing System Hey all - is anybody using CUPS with universe? Ron Bertrand Analyst,AP SYS 3 ISD/LIS/AMS Group Health Coop 206-901-4519 --- 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] UV, Linux, and Active Directory
We use Centrify DirectControl to do this. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Wednesday, 28 January 2009 2:00 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] UV, Linux, and Active Directory I am still learning UV, it's been a long three months of learning, but I have to say that I really do like it. That being said, we run it on Windows Server 2003. We recently tried to deploy it on Server 2008 which IBM says is possible in the docs. However it will not run on Server 2008. My suggestion to my boss was to try running it on CentOS 5, when I was promptly rebuked for the idea. I was told that if we were to do that our UV accounts could not authenticate against Active Directory. And that may be somewhat tue given that our authentication module was custom written. How are you authenticating against AD on Linux? I would be very interested in knowing, because I would love to move us off of UV for Windows and run it on Linux because there is so much that I personaly know that I can do running it on Linux that it takes major hoops to pull of on Windows but is realatively trivial on Linux, like PDF printing, Python scripting, Postgresql integration, Apache tricks, etc;. Thanks, Norm --- 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] Memory allocation
I gave up trying to use it ages ago. Haven't even bothered trying to use the new way Bloody hopeless, I can go onto the Microsoft site and find everything I want to, warts and all Whoever is in charge at IBM needs to get out of there suit, stop working for big blue and go and be a customer for a while, then they might see how hard it is to get any information. Happy New Year -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 2 January 2009 5:31 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Memory allocation Is anyone else finding it themselved locked out of U2TechConnect now? It shows I'm all set up correctly, but I cannot access entitlements -- If it's just me then I'll contact U2BC - but since this is a 'new setup', well, I'm wondering if I'm the only one! I cannot access this article... Gives me an error on use of my 'real' IBM credentials. I linked my TechConnect and 'real' IBM ID weeks ago in preparation for this switch... -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, January 01, 2009 9:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Memory allocation There is an IBM U2 knowledge base item on this message: http://www-01.ibm.com/support/entdocview.wss?rs=0context=SSKJ MPcontext=SSCR XTcontext=SSCRY4context=SSKJLLcontext=SSKJJZcontext=SSKJDK context=SSVT37 dc=DA420dc=DA480dc=DA490dc=DA430dc=DA410dc=DB600dc=DA40 0dc=D600dc=D7 00dc=DB520dc=DB510dc=DA500dc=DA470dc=DA4A20dc=DA460dc=D A440dc=DB550d c=DB560dc=DB700dc=DB530dc=DA4A10dc=DA4A30dc=DB540q1=memo ry%20local%20pa gesuid=swg21081819loc=en_UScs=utf-8lang=NotUpdateReferer= regards, Wally Terhune --- 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] Universe Triggers
I bet you I can write to the VOC unless I do not have write permissions to the file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Friday, 17 October 2008 1:45 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers That's really REALLY (I swear!) not true. Even if you can do stuff to the VOC, if you put the verbs into the remote VOC and lock that up, you can ABSOLUTELY prevent unauthorized TCL command usage. You can't copy a VOC command and make it work to bypass the wrapped one in the remote voc. Honestly, you really can't. I can explain in more detail how I did it for PRC if you like - but there are plenty of ways to do it - just read up on the remote VOC. Susan Date: Wed, 15 Oct 2008 13:40:20 +0100 From: Anthony Youngman [EMAIL PROTECTED] Subject: RE: [U2] Universe Triggers But IF you can update VOC, you CAN bypass remote voc, which is what David said! As part of your security you need to make sure that users CAN'T update VOC (which is rather harder than it seems at first glance). Cheers, Wol - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 15 October 2008 12:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers David, With the use of remote voc you really can prevent by-pass of wrapped TCL commands. Completely, unequivocably. Regards, Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Real software configuration management for U2! - -- Date: Wed, 15 Oct 2008 08:26:00 +1100 From: Hona, David S [EMAIL PROTECTED] Subject: RE: [U2] Universe Triggers You can by-pass them if you can update the VOC. - --- --- 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] [UV] Universe license usage per account {Unclassified}
You can use fuser on the VOC file on xxIX systems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Saturday, 27 September 2008 6:46 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Universe license usage per account {Unclassified} There is nothing built into Universe that is keeping track of this metric. You would have to track it at an applications level. Peter Veenhof wrote: Hey, Yes, I know I have licenses per system instance, but I want to know how many of the licenses are being used in a specific account... Is there any way to find that out? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, September 25, 2008 5:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Universe license usage per account {Unclassified} Peter, You don't have licenses per account, only per UniVerse system instance. The maximum UV licensed users count is available in SYSTEM(36). The number of licenses currently consumed is available in SYSTEM(35). Regards Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Peter Veenhof Sent: Friday, 26 September 2008 8:06 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Universe license usage per account Hi, I was wondering if anyone knows a way to extract the number of licensed users (or rather licenses in use) for a specified Universe Account? Thanks Pete --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- 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/ -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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] Copied an account, now indexes messed up..
SET.INDEX filename TO NULL On the copy. CREATE.INDEX filename INDEX etc on the copy will create copy. BUILD.INDEX filename ALL On copy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, 18 July 2008 9:00 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] Copied an account, now indexes messed up.. I have a working running account... And needed to create a write-off account, so I simply used cp -Rp xxx to copy the one account to the other... Now I have index problems I tried to search U2Ug knowledgebase but all it ever returns is No records found... I know that indexes have path names embedded, and that my copy is messing up the original account's indexes... The thing is I need both accounts to have indexes, and I can't remember how I separate them... And its urgent... Oops! --- 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] [UV] Problems with spooler
Hi, We are having problems with our spooler which have only recently started occurring for reasons at this stage unknown. What I get in the err.log file is the following: Error: usd child received SIGPIPE signal. - No such file or directory (AKPRN16) 04/12/2008 00:00:07 Error: usd child received SIGPIPE signal. - No such file or directory (WNPRN04) 04/12/2008 00:00:07 Error: usd child received SIGPIPE signal. - No such file or directory (CHPRN05) 04/12/2008 00:00:09 Error: usd child received SIGPIPE signal. - No such file or directory (AKPRN89) 04/12/2008 00:30:07 And the usplog file contains the following: PDEFAULT EmptyForm 7 0 0 PAKPRN15 0 /var/spool/uv/drv/create7 0 0 PAKPRN16 0 /var/spool/uv/drv/create-20475 2 0 PAKPRN89 0 /var/spool/uv/drv/create-20475 2 0 PCHPRN05 0 /var/spool/uv/drv/create-20475 2 0 PWNPRN04 0 /var/spool/uv/drv/create-20475 2 0 z Does anyone have any ideas. Universe 10.2.4 Linux nzwms03 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux RHEL 4.0 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Testing for TRANSACTION block
In Universe these is @TRANSACTION.LEVEL I believe or @TRANSACTION. You also have SYSTEM(9001) ? which will give you the call stack. It is probably a EXECUTE of a command or SH which is generally illegal. You can turn then on by adding a 'H' from memory to attribute 4 of the VOC file entry. Sorry to be vague but I don't have access to a system at the moment. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, 5 March 2008 7:16 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] Testing for TRANSACTION block If there a way for a subroutine to know that it has been called from within a BEGIN TRANSACTION END TRANSACTION I've got a subroutine somewhere that is calling an illegal command for a transaction block and having hard time finding where the call is coming from. Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ --- 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/