Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux

2014-01-08 Thread Phil Walker
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

Re: [U2] Logging program execution in Unidata?

2014-01-06 Thread Phil Walker
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

Re: [U2] REPLICATING DATA [OT]

2013-09-04 Thread Phil Walker
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:

Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

2013-08-27 Thread Phil Walker
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()

Re: [U2] @RECORD VARIABLES

2013-08-15 Thread Phil Walker
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

Re: [U2] Universe Configuration --

2013-08-14 Thread Phil Walker
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

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-01 Thread Phil Walker
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

Re: [U2] Universe Triggers

2013-07-26 Thread Phil Walker
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

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-26 Thread Phil Walker
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

Re: [U2] Autologout

2013-07-24 Thread Phil Walker
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

Re: [U2] Universe Triggers

2013-07-18 Thread Phil Walker
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

Re: [U2] CentOS with Universe?

2013-07-17 Thread Phil Walker
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

Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

2013-07-17 Thread Phil Walker
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

Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

2013-07-17 Thread Phil Walker
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

Re: [U2] Any advantages to UV on 64-bit OS?

2013-07-11 Thread Phil Walker
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

Re: [U2] [UV] Auto Starting Applications

2013-07-10 Thread Phil Walker
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Phil Walker
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Phil Walker
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-

Re: [U2] UniVerse LPTR

2013-07-08 Thread Phil Walker
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

Re: [U2] UniVerse LPTR

2013-07-08 Thread Phil Walker
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

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-07 Thread Phil Walker
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

Re: [U2] Unidata BCI error

2013-06-01 Thread Phil Walker
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

Re: [U2] canon ir4025 printer on redhat

2013-05-02 Thread Phil Walker
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:

Re: [U2] TCL input and response logging such as COMO

2013-04-25 Thread Phil Walker
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

Re: [U2] New Rocket Toolkit for .NET

2013-02-27 Thread Phil Walker
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

[U2] Dumping data to file from TCL

2013-02-20 Thread Phil Walker
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

Re: [U2] Dumping data to file from TCL

2013-02-20 Thread Phil Walker
, 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

Re: [U2] Dumping data to file from TCL

2013-02-20 Thread Phil Walker
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

Re: [U2] Dumping data to file from TCL

2013-02-20 Thread Phil Walker
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

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-28 Thread Phil Walker
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

Re: [U2] External database

2013-01-13 Thread Phil Walker
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] How to check which sproc is called by user

2013-01-07 Thread Phil Walker
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

Re: [U2] BFORMAT

2012-11-29 Thread Phil Walker
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

Re: [U2] Variable Interpolation - UV INJECTION

2012-08-24 Thread Phil Walker
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

Re: [U2] Mysterious UV Error

2012-08-20 Thread Phil Walker
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

Re: [U2] CSV to Array

2012-08-15 Thread Phil Walker
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:

Re: [U2] Case Statement with only two cases... or for that matter... one case

2012-04-22 Thread Phil Walker
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.

Re: [U2] BETWEEN operator

2012-04-18 Thread Phil Walker
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

Re: [U2] Issues calling REMOTE VOC pointer

2012-04-18 Thread Phil Walker
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

[U2] AS2 Integration

2012-03-01 Thread Phil Walker
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

Re: [U2] AS2 Integration

2012-03-01 Thread Phil Walker
...@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

Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools

2012-02-17 Thread Phil Walker
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-

[U2] RHEL 6.x and Universe Package Requirements

2011-12-19 Thread Phil Walker
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

Re: [U2] End of Month date routine

2011-12-05 Thread Phil Walker
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

Re: [U2] End of Month date routine

2011-12-05 Thread Phil Walker
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

Re: [U2] Suggestions for flattening Multivalues...

2011-11-09 Thread Phil Walker
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

Re: [U2] UV 9.6.2.1/uvbackup questions

2011-09-14 Thread Phil Walker
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

Re: [U2] Ardent programmers

2011-09-08 Thread Phil Walker
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

[U2] UV 11.1.1 on RHEL 6 64-bit

2011-05-25 Thread Phil Walker
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.

Re: [U2] serial #

2011-05-07 Thread Phil Walker
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

Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE

2011-03-17 Thread Phil Walker
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

[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE

2011-03-16 Thread Phil Walker
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

Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE

2011-03-16 Thread Phil Walker
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

Re: [U2] Does UV have a BLOCK command

2011-02-10 Thread phil walker
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 ].

Re: [U2] What do you do with CallHTTP?

2011-02-02 Thread phil walker
] 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

Re: [U2] What do you do with CallHTTP?

2011-02-02 Thread phil walker
[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

Re: [U2] What do you do with CallHTTP?

2011-02-02 Thread phil walker
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

Re: [U2] What do you do with CallHTTP?

2011-02-01 Thread phil walker
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

Re: [U2] What do you do with CallHTTP?

2011-02-01 Thread phil walker
-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

Re: [U2] What do you do with CallHTTP?

2011-02-01 Thread phil walker
- 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

Re: [U2] How to Clear Empty VM marks in Field

2011-01-31 Thread phil walker
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:

Re: [U2] ViaDuct problem

2010-12-28 Thread phil walker
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:

Re: [U2] CREATE.TRIGGER - Permission denied

2010-10-18 Thread phil walker
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

Re: [U2] Stumped with TRANS...

2010-10-18 Thread phil walker
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.

Re: [U2] Stumped with TRANS...

2010-10-18 Thread phil walker
(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

Re: [U2] Universe Triggers

2010-07-30 Thread phil walker
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

Re: [U2] Unidata 7.1.9 and .Net DLL

2010-07-21 Thread phil walker
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:

Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?

2010-06-29 Thread phil walker
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:

Re: [U2] Soap error question

2010-05-10 Thread phil walker
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

Re: [U2] Listing via the SQL Interface...

2010-05-10 Thread phil walker
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:

Re: [U2] UniODBC/UniOLEDB and Win2008?

2010-04-22 Thread phil walker
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?

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread phil walker
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:

Re: [U2] Input is not permitted when a trigger is active

2010-04-11 Thread phil walker
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

Re: [U2] Common Table Expressions

2010-04-08 Thread phil walker
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:

Re: [U2] Speaking of MsSQL 2008 ...

2010-01-14 Thread phil walker
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

Re: [U2] Universe Triggers

2009-10-31 Thread phil walker
[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

Re: [U2] Universe Triggers

2009-10-30 Thread phil walker
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-

Re: [U2] Unibasic: Sample Program

2009-10-14 Thread phil walker
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

Re: [U2] Unibasic: Sample Program - Scrum/Agile methodology

2009-10-14 Thread phil walker
. -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

Re: [U2] Unibasic: Sample Program

2009-10-14 Thread phil walker
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

[U2] Universe PE Client Download

2009-10-08 Thread phil walker
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

Re: [U2] Connection Pooling Statement

2009-09-24 Thread phil walker
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

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-24 Thread phil walker
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

Re: [U2] What Program Am I?

2009-06-23 Thread phil walker
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

Re: [U2] Tracing UV system calls, linux

2009-06-08 Thread phil walker
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

RE: [U2] RE: Truncated catdir names

2009-05-27 Thread phil walker
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-

RE: [U2] Paragraphs and procwrite

2009-05-25 Thread phil walker
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

RE: [U2] DATE.FORMAT illegal when a transaction is active

2009-04-15 Thread phil walker
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

RE: [U2] universe sockets

2009-04-13 Thread phil walker
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-

RE: [U2] universe sockets

2009-04-13 Thread phil walker
...@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

RE: [U2] SQL a possibility?

2009-04-01 Thread phil walker
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:

RE: [U2] Does anybody have a hot backup server?

2009-03-18 Thread phil walker
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

RE: [U2] Common UNIX Printing System

2009-02-26 Thread phil walker
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

RE: [U2] UV, Linux, and Active Directory

2009-01-27 Thread phil walker
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

RE: [U2] [UD] Memory allocation

2009-01-01 Thread phil walker
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

RE: [U2] Universe Triggers

2008-10-19 Thread phil walker
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

RE: [U2] [UV] Universe license usage per account {Unclassified}

2008-09-26 Thread phil walker
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

RE: [U2] Copied an account, now indexes messed up..

2008-07-18 Thread phil walker
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] [UV] Problems with spooler

2008-04-11 Thread phil walker
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

RE: [U2] Testing for TRANSACTION block

2008-03-04 Thread phil walker
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

  1   2   3   >