Re: [U2] Performance query

2009-09-03 Thread Brian Leach
Arie/Jeffrey I've been told that IBM have done some work to improve the use of multiple indexes for queries, though I'm not sure when that has come in. It might be worth trying this on 10.3 (e.g. PE) to see whether it improves performance. Incidentally, you can omit WITH if you nest the query:

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-21 Thread Brian Leach
No. The point of the post was that the data IS initialized, but then remains constant until the user logs out (which is what named common is for). He wants to re-initialize at the start of each listing. In theory, @DATE and @TIME should not change during a listing (unlike Date() and Time()). If

Re: [U2] Performance counters

2009-08-05 Thread Brian Leach
Charles That's what I meant. Thanks for responding. Brian You meant Windows' Performance Monitor, didn't you? The native UniAdmin one has been on my mind lately I just umped. Sorry, can't help. cds. Brian, I'm not sure what you are asking. Are you saying when you start UniAdmin's

Re: [U2] INFO BASIC BNF Spec

2009-08-05 Thread Brian Leach
Hi Marco I would echo that - there are too many inconsistencies in the language to make a full BNF a practical possibility. I've always had to write my own parsers and highlighters. Brian Hi Marco, Can anyone please help me with the full BNF spec for the structure of an INFO BASIC

[U2] Performance counters

2009-08-04 Thread Brian Leach
Hi Can anyone please remember how to install the performance counters for an existing UniVerse site? There's nothing appearing when in the performance monitor list of counters, and the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Universe\Performance section is missing. Thanks! Brian

Re: [U2] Using PHP

2009-07-31 Thread Brian Leach
... And I've found when teaching UniVerse Basic to died-in-the-wool .Net and C programmers, who tend to comment at the lack of variable declaration or strong typing and the idea that it's an interpreted language, the words 'just like PHP' tends to have a calming effect ... grin I just wish IBM

Re: [U2] ESC in Unidata

2009-07-31 Thread Brian Leach
Dave Unlikely - most HPs, Brothers etc support the Epson FX-80 style barcode escape sequences, since these don't clash with anything in PCL. I've just had a merry time adding support for these into mvPDF's PCL parser. Brian -Original Message- From:

Re: [U2] What ETL?

2009-07-29 Thread Brian Leach
Debster - Horses for courses. It's like saying 'what do you use for your applications' - there's a wealth of scenarios out there and tools for each of them .. At the top end, Aptitude from Microgen. Not cheap, but a fully featured suite for transforming data: very powerful, graphical and loved

Re: [U2] [UV]recurring database, indexing and deadlatch errors

2009-07-29 Thread Brian Leach
Hi Manu It is a good question... What do the record keys look like, and how many records are there? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: 29 July 2009 13:54 To: U2

Re: [U2] [UV]recurring database, indexing and deadlatch errors

2009-07-29 Thread Brian Leach
- boun...@listserver.u2ug.org] De la part de Brian Leach Envoyé : mercredi 29 juillet 2009 16:35 À : u2-users@listserver.u2ug.org Objet  : Re: [U2] [UV]recurring database, indexing and deadlatch errors Hi Manu It is a good question... What do the record keys look like, and how

Re: [U2] WR Group Lock

2009-07-27 Thread Brian Leach
David Martin is right. Sorry. He usually is. A WR lock is a transient lock, it is held only during the time a process is attempting to write to / restructure a group. For whatever reason, a process (possibly the previous write) has crashed or the write has entered a loop (screwed pointers) or

[U2] UniData and umlauts

2009-07-25 Thread Brian Leach
I'm cross posting this from the website in the hope of finding someone who can respond: Has anyone used NLS English_G2 in order to handle special characters such as the u with umlaut (ü) in UniData? I have a client based in the US, that would like to be able to incorporate umlauts in their

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Brian Leach
Hi Similar to Charles' but not exactly the same, this was for uv (clearer than using @n) but should work for UDT as well: ED DICT BOOK_TITLES RUNNING_TOTAL This is a Type I Descriptor last compiled on 23/07/09 at 16:35. 20 lines long. : p 0001: I 0002: SUBR('RT','RUNNING_TOTAL',UNITS)

Re: [U2] Universe just quits

2009-07-22 Thread Brian Leach
Harold You might want to look at splitting out some of those index records, e.g. where you have 10,000 fields in an index for CRIME, split this into CRIME, CRIME-1, CRIME-2 etc. with a maximum number of entries per index. Otherwise you are not going to get efficient storage at those sizes: if

Re: [U2] Universe Retrieve

2009-07-16 Thread Brian Leach
Barry 'Date() - 14' isn't constant - the Date() function is designed specifically to be evaluated each time. '@DATE - 14', on the other hand, should be constant. You should see a difference between the two if you run a query across midnight... Same with TIME() and @TIME: try both on a long LIST

Re: [U2] list DICT uniObjects

2009-07-14 Thread Brian Leach
Edwin Two ways to do this: The quick/dirty and frankly not very good way is to use UniXML: private DataSet ds; private Boolean showDict(String fileName, UniSession sess, DataGridView dg) { UniXML xml = sess.CreateUniXML(); xml.GenerateXML(SORT DICT +

Re: [U2] list DICT uniObjects

2009-07-14 Thread Brian Leach
) End Class Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 14 July 2009 12:30 To: 'U2 Users List' Subject: Re: [U2] list DICT uniObjects Edwin Two ways to do this: The quick

Re: [U2] which files have triggers

2009-07-13 Thread Brian Leach
Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com). I use a master trigger that reads a list of sub-triggers based on the file name. Okay it's an extra read, but it's worth it: the list of sub-triggers (which have the same

Re: [U2] UV and triggers

2009-07-11 Thread Brian Leach
-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, July 10, 2009 4:26 PM To: 'U2 Users List' Subject: Re: [U2] UV and triggers The file doesn't have to be part of a schema and doesn't have to be a SQL table: Universe will add a SICA to the file

Re: [U2] UV and triggers

2009-07-10 Thread Brian Leach
The file doesn't have to be part of a schema and doesn't have to be a SQL table: Universe will add a SICA to the file as part of the trigger definition. But it does need to be a file and not a directory i.e. not type 1 or 19. Also the trigger routine should be globally cataloged. Brian

Re: [U2] General guidelines on indexing

2009-07-09 Thread Brian Leach
All PLEASE don't use that wiki page - it's the old wiki .. The live wiki is accessed from the main U2UG website (log in and select Wiki from the menu). The old wiki will be removed some day soon when I get the time to do so cleanly and check that everything has been migrated across. Why?

Re: [U2] General guidelines on indexing

2009-07-09 Thread Brian Leach
Martin Hi all, I wish I hadn't started this!! Not at all - it was a useful post! For those interested in such things, last month's PC Plus geek-at-the-back-of-the-magazine article was all about just this subject, and covered the concept of 'ropes' - basically handling strings internally

Re: [U2] General guidelines on indexing

2009-07-08 Thread Brian Leach
All Since we're already going off on a huge tangent re. indexing, it's worth pointing out that if you're writing client side code in .Net the same applies: strings are immutable and every change or append copies the string in memory. That's why there is a StringBuilder class for appending to

Re: [U2] IBMs Basic Development Toolkit

2009-06-30 Thread Brian Leach
Hi You've just missed a long discussion on it.. Check the archive from the website if you want to catch up grin You should be able to get it with the latest personal editions if you want to play - it's free and it works and yes, it's Eclipse based. Brian Hello All, Does anyone have

Re: [U2] Program Comments/Documentation/Notes/Revision History

2009-06-29 Thread Brian Leach
Hi I thought about adding code folding to mvDeveloper, but with Pick/Basic it doesn't really work in the same way. If you have a language that is function or member based, there is a very clear boundary for each function, e.g. private void doSomething{ code in here } which makes it easy to

Re: [U2] Program Comments/Documentation/Notes/Revision History

2009-06-29 Thread Brian Leach
Steve I think you're possibly out of date in your view of the database - again, not wanting to be confrontational but this is an important point that you raise. I've also used MV for many years, but for the vast majority of that it has been as part of a client/server or similar platform. If

Re: [U2] Program Comments/Documentation/Notes/Revision History

2009-06-29 Thread Brian Leach
Thanks guys for engaging me in this exercise. I'm usually not this outspoken. We *like* outspoken. It's better than leaving things unsaid grin. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Program Comments/Documentation/Notes/Revision History

2009-06-27 Thread Brian Leach
David I have an auto-doc style of comment that defines what the program does, and version stamps that are compiled into the object code that include a short description alongside other information, similar to the Windows version resource. But I would suggest that modification logs really belong

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

2009-06-25 Thread Brian Leach
Hi I use mixed case using the same capitalization as for Delphi and VB (rather than camelCase for C# and Java). OpenSeq NumberOfFields = DCount(SomeVariable, @FM) However I use upper case to distinguish things that are 'special' e.g. equate literals, file and select variables, common variables

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

2009-06-25 Thread Brian Leach
Of course it doesn't help the example when your mail client screws up your formatting... No, I didn't put the Loop on the same line. sigh Brian Execute SSELECT BOOK_TITLES, SELECT. SLIST Fin = @False Loop ReadNext TitleId From SLIST Else Fin = @True End Until Fin Do

Re: [U2] Universe abort

2009-06-24 Thread Brian Leach
I've seen similar where a phantom was accessing a directory that was also being accessed by a system process: i.e. backup or virus scanner. Regards Brian Teri Henry wrote: The below noted error was received during a repetitive (once per hour) series of functions executed within a

Re: [U2] Universe Telnet service won't start

2009-06-24 Thread Brian Leach
First things to check: 1/ check the event log (sorry if that's stating the obvious). 2/ Use netstat -a -o from the cmd shell to check that there's no other process using the telnet port. 3/ Make sure your antivirus isn't kicking it, esp. if it has just auto-updated. Brian -Original

Re: [U2] uvRunCommand

2009-06-22 Thread Brian Leach
Hi It's clearly making the call, otherwise you would have the ErrText reporting a network error or malformed request rather than getting back a valid (in terms of the call) HTTP 400 return. So looks like something is blocking between your uv server and your target website: are you certain that

Re: [U2] uvRunCommand

2009-06-22 Thread Brian Leach
/htmlýContent-Lengthý2525 !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en head titlemvScript Demo/title link rel=stylesheet href=style.css meta name=Author content=Brian Leach

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-22 Thread Brian Leach
This sounds like the perfect spot for a decent sized open source group to spring up and fill the hole, making a tool or the many plug-ins required to fill the void you're describing. Like that hasn't been tried. We can't even get volunteers to update the wiki or post to the

Re: [U2] uvRunCommand

2009-06-21 Thread Brian Leach
Tony is right: you need a more direct route. CallHTTP should do the job, if it's a regular querystring or form post. Seems a bit of a flaky option also, but there you go.. Web service call might have been better. Here's a quick example with the relevant pieces (for an explanation see my blog at

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-18 Thread Brian Leach
To go back to the original question: I used it during the beta for 10.3 and found that it was effective and has some genuinely nice features. And if you're running Eclipse anyway and you're familiar with that IDE, it's probably a good way to go. Certainly having the integrated debugger is a big

Re: [U2] UniVerse Unit Testing

2009-06-11 Thread Brian Leach
Hi At my last company, we spent a lot of effort on building an automated test rig for our software, because we had to support multiple platforms and all our code required full regression testing. It may be a slightly different scenario to yours, since we were primarily building tools, and also

Re: [U2] UniVerse Unit Testing

2009-06-11 Thread Brian Leach
seem to mean that you built and maintained two different versions of every external subroutine/function. Is this correct or am I just missing something? Thanks. Perry _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach

Re: [U2] UniVerse Unit Testing

2009-06-11 Thread Brian Leach
something? Thanks. Perry _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, June 11, 2009 3:19 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse Unit Testing Hi At my last company, we spent a lot

Re: [U2] Odd permissions error running a vb script using dos /c command

2009-06-02 Thread Brian Leach
Hi Dave It should take the permissions of whatever user you have logged into UniVerse with. At the risk of asking the obvious, have you logged in as that admin user? Also, it shouldn't make any difference but do you get the same error if you create a verb pointer directly to CSCRIPT.EXE

Re: [U2] [u2u] UV on Windows question

2009-06-02 Thread Brian Leach
Jerry There's a simple answer to *that* question. Having used AIX, HPUX, DGUX, SCO, Interactive, SunOS, Solaris, Linux and Windows, as well as a plethora of different languages and frameworks.. the best technology is whatever I'm being PAID to work on at the time :) Brian _ From:

Re: [U2] [u2u] UV on Windows question

2009-06-01 Thread Brian Leach
Hi David HKEY_LOCAL_MACHINE\SOFTWARE\IBM\UniVerse\CurrentVersion\UseShortUserNames. (May not exist on installation) It's a DWORD, set to 1 to show user names without the domain prefix. Regards Brian _ From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Dimensioned Array Question

2009-06-01 Thread Brian Leach
Hi Karen That should work on UniVerse also: CT test.bp call called call 0001 DIM Array(20) 0002 call called(MAT Array) called 0001 SUBROUTINE called(MAT Array) 0002 Crt InMat(Array) 0003 STOP run test.bp call 20ý1 i.e. 20 x 1 (remember arrays can be more than one dimension)

RE: [U2] Best algorithm for UV part files

2009-05-28 Thread Brian Leach
Hi Baker Unless I misunderstand the question - it don't work like that :) UniVerse uses the partitioning algorithm to determine which part file the record goes into, based on some operation performed on the key that must yield as its result a valid part file number. So you could, for example,

RE: [U2] Best algorithm for UV part files

2009-05-27 Thread Brian Leach
Hi Baker Well as you probably know the partitioning needs to be based on the key, so it depends upon what meaningful information you can store there in an invariant way. For example: If they are coming from archive, do/could the keys have an originating date component? If so, you can distribute

RE: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Brian Leach
a solution which duplicates one already provided by our esteemed colleague Brian Leach. If mvScan is not available, or for some reason doesn't suit specific needs, I will offer to try to put a graphical front-end on someone's existing application parser. I don't have the time to write that sort

RE: [U2] Paragraphs and procwrite

2009-05-23 Thread Brian Leach
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

RE: [U2] Printing from UV through a windows server for PDFs, forms, etc.

2009-04-30 Thread Brian Leach
Hi Robert That would be mvPDF - please check out my website again! Regards Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: 30 April 2009 17:23 To: u2-users@listserver.u2ug.org

Re: [U2] UV to SAP migration disaster

2009-04-21 Thread Brian Leach
All I think we all neeed to recognize that IBM *could* have just sat on the products milking the revenue without adding any enhancements, trusting that sufficient users would never move off to keep a meaningful revenue stream alive. To their credit, they have not. We have seen new features,

RE: [U2] Getting a graphical view of my data in UniVerse

2009-04-21 Thread Brian Leach
Hi Norman [AD] line for the confused :) I have a product called mvScan that may go some way towards what you need. This iterates through a UniVerse system building maps of the file relations (parsing TRANS, XLATE, SUBR, Tcorrelatives etc) and analyzing source and object code (file opens,

Re: [U2] UV to SAP migration disaster

2009-04-19 Thread Brian Leach
I think there are two other factors that come into play: technology and marketing. I know of at least one site here in the UK who are committed to moving to SAP because they believed for a long time that UV was a dead platform. Why? Because for years they heard nothing to the contrary. They

RE: [U2] UVRPC API question

2009-04-03 Thread Brian Leach
I've asked IBM to consider publishing this on several occasions. I was wanting to create a client in PHP using their socket library. I did get as far as tracing the network packets for a UniObjects connection, and it looks like someone with time to spare (ie. not me!) could work out the

RE: [U2] SQL a possibility?

2009-04-03 Thread Brian Leach
SQL - SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename'; This gave me an error, about not being able to use a multivalued field.. Sorry forgot it was multivalued. For the record: SELECT SWITCHIT TO SLIST 0 FROM UNNEST FILENAME ON SWITCHIT WHERE @ID = 'somename'; Brian

RE: [U2] SQL a possibility?

2009-04-02 Thread Brian Leach
George 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... SQL - SELECT SWITCHIT TO SLIST 0 FROM

RE: [U2] UniObjects connection timeouts?

2009-04-01 Thread Brian Leach
Look at the setting in the unirpcservices file on the server - you can find this in your unishared directory. The entries for uvcs and defcs are those for UniRPC. The final entry on the line is the timeout period in 1/10 second. Regards Brian -Original Message- From:

RE: [U2] International Spectrum 2009 - Wednesday

2009-03-26 Thread Brian Leach
Nathan Good work. Just wish I could be there .. ah well, next year :) Brian Well, another post on the Spectrum Conference for those interested. http://blog.intl-spectrum.com Nathan Rector International Spectrum, Inc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe

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

2009-03-20 Thread Brian Leach
G Sent: 20 March 2009 01:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Does anybody have a hot backup server? From: Brian Leach This is SUCH an important topic, and there have been so many good answers given here that it really deserves to be collated. Can I please ask

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

2009-03-19 Thread Brian Leach
All This is SUCH an important topic, and there have been so many good answers given here that it really deserves to be collated. Can I please ask/request/importune/plead/beg those who have contributed to this thread to write this up on the U2UG wiki? It's exactly the sort of rich real-world

RE: [U2] IDE

2009-03-19 Thread Brian Leach
1. Rudy is in search of a technology religion. How about, Use the right tool for the right job? Seriously, if you choose the technology platforms carefully, you should be able to interoperate between them. Right now I'm working on a new product with Delphi as the engine (for sheer

RE: [U2] IDE

2009-03-18 Thread Brian Leach
To add to this.. .Net also doesn't mean necessarily using web pages. If you're developing for intranet use, consider using windows forms with click-once deployment or sandbox mode. A lot of companies go the web page route because of the cost/hassle of deploying desktop apps and keeping them up

RE: [U2] UniObjects in Web App

2009-03-18 Thread Brian Leach
All Just remember that whatever you use, you will need to stay the right side of the IBM licensing policy. If you haven't looked at it for some time, read up on the section of the licence agreement about connection pooling. Brian -Original Message- From:

RE: [U2] validate active directory username password from within unidata?

2009-03-18 Thread Brian Leach
Tony This brings up a question: Does anyone know if we can link a C++ or .NET DLL into the UD or UV executables? Maybe call via a user exit or some other mechanism directly from BASIC? Shelling out is very inelegant, slow, and can be insecure. You can link C code to UniVerse using GCI,

RE: [U2] IDE

2009-03-17 Thread Brian Leach
Hi Rudy First, for a Windows based editor download the free mvDeveloper from my website. It's written in Delphi, uses UniObjects and it's lean and quick. And free, or did I say that? Second, download my primer on 'writing your first universe application' from the U2UG site. I know you're not

RE: [U2] UV Timed INPUT

2009-03-12 Thread Brian Leach
David try the following: FUNCTION TimedInput(Period, Value) $OPTIONS PICK Now = Time() Loop Input n,-1 Until n Or ((Time() - Now) Period) Do Nap 50 Repeat If Not(n) Then Result = @False End Else Input Value Result = @True End RETURN(Result) as in: PROGRAM TestInput $OPTIONS PICK

RE: [U2] ODBC Connection to Universe on HP-UX

2009-03-06 Thread Brian Leach
Henry Yes, there are! ODBC is slow - designed for compatibility not performance. OleDB is, in theory at least, at little quicker since it is a leaner protocol: ODBC was designed to present a common and highly rigid/specified view of a database, and as a result it is generally considered a

Re: [U2] Universe Index not working

2009-03-05 Thread Brian Leach
Hi Over the past months we've seen a number of problems reported on this list that seem to relate to changes in the way that UniVerse is interpreting numeric/non-numeric fields. Clearly .20 is numerically the same as .2, but they shouldn't be indexed together. If you do a LIST.INDEX, is it

RE: [U2] Last accessed date stamp for UniVerse files

2009-01-29 Thread Brian Leach
Hello John You are right about the problem with STATUS(). I would look at the UNIX 'stat' command, that should give you what you want. You can combine that with a find command to run it for each of the files then parse the results. Not elegant but it should be functional. Sorry I don't have a

RE: [U2] PDF printing, LaTeX, Ghostscript, etc.

2009-01-28 Thread Brian Leach
Glen Doesn't using PrintWizard imply the use of a Windows server somewhere? That's the way of the world. If you want a quick-and-dirty stick-some-text-into-a-doc type of PDF you can get away with cross platform solutions, but for a 'real' PDF solution - one with good font handling, images,

RE: [U2] Moving a UniVerse a/c from Unix to Windows

2009-01-28 Thread Brian Leach
Hi Jeff The 'magic bullet' is usually to resize all your type 1 files to type 19 before trying the migration. Regular file names (not directory) will be truncated using a sequence number but that's not an issue - they will go across correctly. Type 1 files won't. Any SQL tables will also cause

RE: [U2] PDF printing, LaTeX, Ghostscript, etc. - [OT]

2009-01-28 Thread Brian Leach
Arnold Yes, I've been impressed with FPC generally, though it depends what type of project you are trying to migrate! For straight-forward VCL forms apps it seems like a reasonable tool. However I would have to say that whilst Lazarus has come a long way, it still lags well behind other IDEs,

RE: [U2] File Delete Logging UV

2008-12-30 Thread Brian Leach
Mac You can't delete your own VOC file using DELETE.FILE so if it is being done from UniVerse that means it is happening from another account. So you could a) look through other accounts and see if there is a suspicious Q or F pointer to that VOC which might help track down the culprit, or b)

Re: [U2] DEBUG mode on a UniObjects connections

2008-12-05 Thread Brian Leach
These are all good approaches, but the difficulty is often in trying to collate the information on what is happening client side and server side: that usually means poring through multiple log files, especially if you use different client languages as we did in my last company. Our approach

RE: [U2] DEBUG mode on a UniObjects connections

2008-12-04 Thread Brian Leach
Hi Dave A uniObjects subroutine call is a 'black box' RPC. It doesn't allow any kind of user interaction to interrupt the call. If you're going into debug, that will hang because it has nowhere from which to take input. Sorry, but that's how it is designed. Brian Hi all, I'm new to the

[U2] UniData ODBC and Vista

2008-12-04 Thread Brian Leach
Hi All Does anyone know whether the latest ODBC drivers for UniData will work under Vista? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] biztalk adapter

2008-12-02 Thread Brian Leach
Bob It's on the UniVerse client CD as part of the UniDK package. There's no extra cost for UniObjects per se, but you might need to think in terms of some pooled connection licenses if you're processing messages in parallel. Brian -Original Message- From: [EMAIL PROTECTED]

RE: [U2] Printing Graphics from UniVerse

2008-12-01 Thread Brian Leach
Hi Adam Take a look at mvpdf - it offers a range of ways to create documents, has a drawing API and despite the name also supports drect printing. Eval available on www.brianleach.co.uk Regards Brian -Original Message- From: Adam Taylor [EMAIL PROTECTED] Sent: 01 December 2008 21:50

RE: [U2] Counting records

2008-11-19 Thread Brian Leach
Nothing built in, but here is a simple function to do it: FUNCTION CountFile(FileName) $INCLUDE UNIVERSE.INCLUDE ODBC.H SQL = 'SELECT COUNT(*) FROM ':FileName Counter = 0 Ok = SQLExecDirect(@HSTMT,SQL) Ok = SQLBindCol(@HSTMT, 1, SQL.B.DEFAULT, Counter) Ok = SQLFetch(@HSTMT) Ok =

RE: [U2][UV] Performance Improvement Hpux 11.23 11.31 (Itianium)

2008-11-14 Thread Brian Leach
Stewart Thanks for posting this. Very useful information. Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: 13 November 2008 23:50 To: u2-users@listserver.u2ug.org Subject: [U2][UV] Performance Improvement

RE: [U2] Create file on remote account

2008-11-12 Thread Brian Leach
Hi You can call out to the underlying $UVHOME/bin/mkdbfile. This creates the physical file in any location you like, then you need to create or update the VOC pointer yourself. Create a verb pointer to mkdbfile, and you can do the rest in a simple program. Syntax to mkdbfile is: mkdbfile

RE: [U2] Documentation

2008-10-30 Thread Brian Leach
Hi Do you mean the SQLExec... functions? If so, they are defined in the BCI (Basic Calling Interface) Guide. Brian Can anyone point me in the right direction. I am looking for documentation on a Universe command Execute.SQL and what I need it the potential return code and the descriptions.

RE: [U2] [UV] PHP

2008-10-24 Thread Brian Leach
Hi The PDO driver looked a good start, but it may be too limited as it currently stands. It also depends on how you are hosting the PHP: most external provides won't let you load custom modules like this one. I did ask IBM last year whether they would be willing to publish the UniObjects

RE: [U2] Universe Triggers

2008-10-10 Thread Brian Leach
Hi Bill That's pretty much what I do, except each file has a list of small subtriggers. That way, if we need to add another action (e.g. another secondary update) or to temporarily suspend an action, they can be added into or knocked out of the list. The overhead is on calling the master trigger

RE: [U2][UV] EQUATEs Using System Delmiiters

2008-10-08 Thread Brian Leach
Perry Actually you're going to feel the pain more.. Remember that an equate is nothing more than a literal substitution by the compiler. Every instance of MX will be replaced by 'ABCD':@AM:'EFGH'. So everywhere you access 'MX' you will also be performing the operation ('ABCD':@AM:'EFGH').

RE: [U2] Universe Triggers

2008-10-08 Thread Brian Leach
One gotcha is that once a trigger is on there, you can't easily change/extend it unless your system has a downtime period in which everyone is logged out. For this reason on 24x7 sites I use a master trigger that can call subtriggers, held as a list in a parameter file. This means that a new

RE: [U2][UV] EQUATEs Using System Delmiiters

2008-10-08 Thread Brian Leach
Martin/Perry Thanks, nice to learn it's smarter than I thought :) Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: 08 October 2008 14:50 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] EQUATEs Using System

[U2] [AD] Two dates for U2 users in the Uk...

2008-10-01 Thread Brian Leach
All For those of us in the Uk, a reminder of two forthcoming events: - The Uk round of the U2 University will be in Telford October 28th to October 30th. This is the main technical event for the IBM U2 community and well worth the entrance fee! I'll be there if anyone wants to buy a drink...

RE: [U2] Universe Lock Error

2008-09-18 Thread Brian Leach
Bjorn That is working as it should. To preserve the lock, pass the file variable to the called routine or hold it open in common. Locks are released when a file is explicitly closed or the file variable goes out of scope. Brian -Original Message- From: [EMAIL PROTECTED]

RE: [U2] If you run UV, Read This !!! Change to UV Backup Recommendations

2008-09-17 Thread Brian Leach
Stephen Many thanks for researching and clarifying this. Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen O'Neal Sent: 16 September 2008 19:47 To: u2-users@listserver.u2ug.org Subject: [U2] If you run UV, Read This !!!

RE: [U2] cannot fnuxi a file with a trigger...

2008-09-17 Thread Brian Leach
Hi Stuart The best way I've found is to actually zero the pointer in the file header to the location of the SICA block, effectively removing the trigger and constraint details, then running fnuxi. Not good. Otherwise I have a utility program that builds a backup image of an account, set of

RE: [U2] AIX Socket Command?

2008-09-15 Thread Brian Leach
Hi Kevin Netstat - a (overall) Netpmon for stats per process ? From memory so may be wrong Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 15 September 2008 16:20 To: u2-users@listserver.u2ug.org Subject: [U2] AIX Socket

RE: [U2] U2UG Website login issues

2008-09-11 Thread Brian Leach
Caleb Sorry - email from the site was down. You should get instructions now. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ng, Caleb Sent: 11 September 2008 17:23 To: u2-users@listserver.u2ug.org Subject: [U2] U2UG Website login issues

RE: [U2] call mysub vs. call @mysub

2008-08-27 Thread Brian Leach
Ross As others have said this was true for PRIME, which is why it is so often seen in legacy code, but is not the case for UniVerse. More useful is the fact that UniVerse caches subroutine object in memory until you exit to TCL, so the overheads on repeated calling are minimised anyway. Brian

RE: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET

2008-08-14 Thread Brian Leach
Hi Susan UniObjects.net is the .Net version of UniObjects (sic) - that exposes a the native MultiValue features all nicely wrapped into classes. For details, take a look at my primer 'Writing your First UniVerse Application' on the U2UG site. That walks you through UniObjects.Net and VB.Net

RE: [U2] Universe conversion migration

2008-08-14 Thread Brian Leach
Sorry if I'm stating the obvious, but UniVerse has been stopped (i.e. completely shut down) when you took that tar? Remember that type 30 files keep their header information in shared memory until UniVerse is closed down, so any tar whilst UniVerse has the file open (even if quiescent) may be

RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
David As always, that is a great post. Hit the nail on the head. I think part of the problem is we continue to call UniVerse a database. It isn't - it's an application platform that happens to have a complex storage model behind it. When you compare *application* performance against the three

RE: [U2] Why Buy (or develop in) UniVerse?

2008-08-13 Thread Brian Leach
To add to my post: If you want one single good reason, take a look at the Wrox Press Expert One to One series books by Roger Jennings on database programming. He's a SQL Server and .Net guru. Read his chapters on performance tuning and concurrency management and weep for those guys. And if

RE: [U2] Getting stuck inside DOS shell UV-W2000

2008-07-30 Thread Brian Leach
Hi Try creating a verb pointer direct to the gpg executable rather than going via the DOS command. Brian -Original Message- From: Marc Hilbert[EMAIL PROTECTED] Sent: 30/07/08 02:22:36 To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org Subject: [U2] Getting

RE: [U2] Data Editor AD

2008-07-29 Thread Brian Leach
Couple more freebies: For programs, data etc. mvDeveloper is a Windows based editor (over UniObjects) that supports highlighting and lots of useful bits and pieces. Also to view data in a more structured way, ENTER is a dictionary driven screen entry/display tool. Both downloadable for free

Re: [U2] CAPTURING TOXML

2008-07-25 Thread Brian Leach
Hi Try using the TO option if that is supported on your release (part of that piecemeal way in which the XML stuff was released). That creates a record in XML somename.xml. You can also create a schema to go with it: SELECT * FROM BOOK_TITLES TOXML TO 'titles' WITHSCHEMA; Not sure whether

<    1   2   3   4   5   6   7   8   9   >