Re: [U2] jobnotify: Error 913 occurred

2014-03-20 Thread Hona, David
Sorry, I forgot to reply... I vaguely recall having a "jobnotify" errors when we migrated to AIX6.1 and UV11.1.9 during the testing phases...but do not recall if it was the "913" version you got...I cannot find my notes on this and didn't raise it as a problem case with Rocket... You could be

Re: [U2] U2 ODBC error

2014-03-18 Thread Hona, David
Do you have a context? New UV version? Old process just stopped working? New version of software X or Y? New server? New everything and old query A or updated query B? Those error message aren't helpful without some context... -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Embedded help as hypertext

2014-03-13 Thread Hona, David
. . Parameters . . . The following table describes each parameter of the syntax. . On Tue, Mar 11, 2014 at 11:49 PM, Hona, David wrote: > I assume you're talking about UV? Define 'improved'? > > It could be improved by actually having all the comman

Re: [U2] Embedded help as hypertext

2014-03-11 Thread Hona, David
I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/"better" built-in HELP facility for your own purposes...PIHELP ma

Re: [U2] Multi-threaded phantom processing

2014-03-10 Thread Hona, David
ll currently crossed. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sen

Re: [U2] Multi-threaded phantom processing

2014-03-06 Thread Hona, David
Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read t

Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine

2014-01-27 Thread Hona, David
There is the !EXIST subroutine. It's a legacy Prime INFO subroutine - created for legacy code that need it. The source code is in UV APP.PROGS and just reads GLOBAL.CATDIR and also sets STATUS() with a return code too. CATALOGED.NAME = '*MYGLOBALSUB' call !EXIST(CATALOGED.NAME, RC) crt CATALOGE

Re: [U2] uv 11 and phantoms

2014-01-09 Thread Hona, David
I don't think so, not that I have seen. Please see https://u2tc.rocketsoftware.com/documentation/PDF/1177927.pdf It is a little out of date (but still correct essentially - not all the API calls are listed): "The BASIC functions that will cause a PHANTOM process to consume a license are: Socket

Re: [U2] [UV] INPUTTRAP Statement

2014-01-09 Thread Hona, David
Peter has the right idea. PTERM just does a TTYGET and TTYSET so you can call that directly if you wish. Our legacy code uses "CALL !PTERM('-ERASE ':CHAR(8))" etc. to change TTY characteristics. I think this "quick n dirty" code snippet could work for youif you utility is UV/BASIC based y

Re: [U2] USERS command in Universe

2014-01-09 Thread Hona, David
See the documentation for the BASIC !GET.USERS and !GET.USER.COUNTS subroutines in the UV/BASIC reference manual. Technically speaking, the internal UV daemons are not consuming UV licenses (mostly!), hence do not qualify as UV users... As mentioned by Jon Card - you can also capture the output

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

2014-01-07 Thread Hona, David
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... There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see

Re: [U2] Exporting to File regularly

2013-12-11 Thread Hona, David
Hi David If you upgrade to the latest UV version you have access to the built-in UV DB audit logging facility. Then you can setup a logging event to log changes to the file(s) in question. Hence, not violating the NDAs nor application flow (which you would have too if modifying the file with ad

Re: [U2] UV/Net usage and licensing

2013-12-11 Thread Hona, David
Hi Peter, It's been a while since I've used/played around with UV/Net, but this may help... 1. Setup You only need a ensure UniRPC is active and you license for UV/Net on the server you wish to access. I don't recall you need to anything other than the UniRPC Daemon listening for requests and

Re: [U2] Rocket releases UniVerse version 11.2.0

2013-11-14 Thread Hona, David
This has to be one of the most feature rich releases of UV for a long time. There are many new features and enhancements that we've been holding out for a long time... Well done Dan & Rocket U2 team for the big effort for this huge release and the keeping U2/UV alive a kicking... Cheers, David

Re: [U2] Select from one file with save-list from another file

2013-08-29 Thread Hona, David
Hi Brandon, If you want to send one of your columns/fields in your UV/SQL SELECT result to an active select list or saved list - within the same SQL query - you need to use 'TO SLIST' keyword option... See the HELP SQL SELECT online for the limitations though. For example: To save the colum

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

2013-08-27 Thread Hona, David
calls the subroutine 1x, to find the value to delete), > and change (where indexing calls the subroutine 2x, once with the old > version of the record, once with the new, to see whether the indexed > value has changed and, if so, what to delete, what to add. > Distinguishing th

Re: [U2] [UD] BASIC Code Failing

2013-08-02 Thread Hona, David
the > items are then added to source control as part of the cut... If you > did something similar you can always diff what you've got against your > source code control system rather than reinventing the wheel. > > Brian > > > > -Original Message- > From: u2-u

Re: [U2] [UD] BASIC Code Failing

2013-08-01 Thread Hona, David
In UV we're had similar strange problems with seemingly unchanged source/object code - not work as per normal and things going amiss for no good reason...once we found the object code in BP and the catalog space were mismatched and simply re-catalog'd it. Another time we re-compiled a program -

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

2013-08-01 Thread Hona, David
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: u

Re: [U2] UML mapping tool for MV (UniVerse)

2013-07-15 Thread Hona, David
Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even wo

Re: [U2] Writing to a Windoz box from Universe

2013-07-10 Thread Hona, David
t: Re: [U2] Writing to a Windoz box from Universe AIX 6.1 does have it built in. I think 5.2 ML12 might also include the ability to mount CIFS shares -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David

Re: [U2] Writing to a Windoz box from Universe

2013-07-10 Thread Hona, David
Last time I checked, AIX has no native built-in capabilities to mount CIFS/Windows shares. 1. Samba/AIX port - open source If you wish to load the Samba port to AIX, you can use smbclient to perform an "sftp/ftp" like connection that'll mount the share temporarily - then you can get/put the fil

Re: [U2] [UV] Auto Starting Applications

2013-07-10 Thread Hona, David
Yes, this was a problem - but I haven't recently tried to execute UV11 and cron. UV11 has a different shared memory model - inherited from UD - in comparison to older releases. A quick test shows that phantom processes are getting their own shared memory segment under UV11. So - at first gla

Re: [U2] Flip Case command?

2013-07-07 Thread Hona, David
TCL: PTERM -CASE INVERT BASIC: TTYSET -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 6 July 2013 7:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Flip Case command? Does anyone know o

Re: [U2] Running total

2013-07-03 Thread Hona, David
You can also see what the I-type does by DLIST yourfile yourdictitem It's the equivalent of VLIST for I-Types... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 4 July 2013 9:48 AM To

Re: [U2] UniVerse v11.2 private beta starting next week!

2013-05-21 Thread Hona, David
Hi Dan What's new in UV11.2 beta? Or is that not yet public yet? As per the private beta test... :) Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, 20 May 2013 11:40 PM

Re: [U2] canon ir4025 printer on redhat

2013-05-02 Thread Hona, David
UniVerse admin guide details printing options. Using the admin tools won't setup remote network interfaces by default. Hence, in unix you need to write/use the a UV spooler driver Unix script interface. From: u2-users-boun...@listserver.u2ug.org [u2-users

Re: [U2] History of Prime Information

2013-04-29 Thread Hona, David
Ah, I recall Prime small mini-tower (under the desk) AT&T System V boxes too -the EXL 300 series which ran a re-branded version of UniVerse (PI/EXL I think). This was rolled out before the EXL 7000 series which were MIPS RISC/os based servers. I vaguely recall Prime was looking at Silicon Gr

Re: [U2] UV Creating a Soap Request

2013-04-16 Thread Hona, David
Oops, yes - sorry for my misleading reply regarding the URIs. Tempui.org is a valid placeholder and you don't need to replace it. Have you tried now SOAPAction and what error do you get then? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listser

Re: [U2] is this an INDEX ISSUE?

2013-04-16 Thread Hona, David
Hello David 1) Is your file you're indexing corrupt or does it have any errors or warnings as reported by 'fixtool'? If corrupt, can you repair it (after backing it up:)) ? 2) What queries using the indices are slow? All or one? 3) What UV release? 4) How and when do you re-index the file? 5) H

Re: [U2] UV Creating a Soap Request

2013-04-16 Thread Hona, David
Hi Peter Is your SOAPAction correct?? The tempURI.org is a Microsoft standard placeholder - usually replaced by a proper URI or hostname name, etc. SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole Cheers, David -Original Message- From: u2-users-boun...@listserver.u

Re: [U2] How do you print a ".pdf" from inside a Unix Box

2013-04-05 Thread Hona, David
First up - Adobe PDF is a subset of the Adobe Postscript page description language (PDL). Some printer vendors have Postscript emulations. Most business class laser/LED printers or multi-function devices (MFDs) today have intelligent page description language detection built in and typically a

Re: [U2] [uv] Message[010252]

2013-04-03 Thread Hona, David
Hi Adrian The SYS.MESSAGE file has all the system messages... DAVID: CT SYS.MESSAGE 010252 010252 0001 Message %i is either invalid or not found in the SYS.MESSAGE file. 0002 I have no idea what it really means. I'd check if that particular has an existing UV process and has a pre-existin

Re: [U2] UV: Consuming https service from within UVBasic using SOAP

2013-03-06 Thread Hona, David
You're welcome Peter. Sounds like you're past first base (communications OK) and now the challenge is handing the XML data exchanges. That will be fun! Will you use be the UV BASIC XML DOM routines? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...

Re: [U2] UV: Consuming https service from within UVBasic using SOAP

2013-02-21 Thread Hona, David
ers-boun...@listserver.u2ug.org> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is

Re: [U2] UV: Consuming https service from within UVBasic using SOAP

2013-02-20 Thread Hona, David
Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not m

Re: [U2] U2 Test Tools for system/unit & regression testing w/integration with HP QualityCenter

2013-02-06 Thread Hona, David
Thanks Brian - that sounds great! I would be keen to get a trial version, once you have a SSH capable version. How is the product licensed? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday,

[U2] U2 Test Tools for system/unit & regression testing w/integration with HP QualityCenter

2013-02-05 Thread Hona, David
Hello All, I am just wondering what U2 or UniVerse specific integrated testing suites people are using out there and ideally in use today. We have the need for a UV11.x specific or capable tool for automating our existing system/unit and regression test packages. We have a our existing test s

Re: [U2] [UV] Large File Operations Kill Linux

2013-02-05 Thread Hona, David
Yes, sounds like it's been identified and fixed a while ago... like Dan says...kernel update will the "simple" way to address it... (time & outage permitting) https://bugzilla.redhat.com/show_bug.cgi?id=735946 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-us

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

2013-01-30 Thread Hona, David
Brian, *UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying? I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the arguments the same though - such is the nature of "undocumented" features? Perhaps they should have *APILOGIN to for all API clients? Plus

Re: [U2] Database time question

2013-01-24 Thread Hona, David
Potentially simple approach is to have separate server or virtual machine for your other UDT environment setup with the desired timezone. No code changes. On AIX, you can setup a WPAR for stuff like this pretty easily. Or change you source code... The best solution depends on if you control the

Re: [U2] Universal COMO

2013-01-24 Thread Hona, David
So you do what you want to do, but not hard code it and hence require manual updating of all those VOCs. When you want to move for some reason...like lack of disk space or a new disk letter... UD also supports multiple version to operate on the same host/server...done mainly through the use of

Re: [U2] External database

2013-01-15 Thread Hona, David
http://u2.rocketsoftware.com/downloads/whitepapers/64_Bit_Question_wp.pdf Advice here is free here, but the it may cost you later if you don't plan, execute, test and know what you're doing. Given your responses to queries it very much sounds like you some need technical advice/help...contact

Re: [U2] [UV Retrieve] Selecting file based on partial key

2013-01-14 Thread Hona, David
ssage- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, 15 January 2013 6:27 PM To: U2 Users List Subject: Re: [U2] [UV Retrieve] Selecting file based on partial key This may help you... https://u2devzone.rocketsoftwar

Re: [U2] [UV Retrieve] Selecting file based on partial key

2013-01-14 Thread Hona, David
This may help you... https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 15 January 2013 2:10 PM To: u2-users@l

Re: [U2] External database

2013-01-13 Thread Hona, David
As long as your OS and the filesystem is already 64-bit enabled - you should be able to resize the UV file to 64BIT (make sure you have a verified backup first :)). Otherwise, use UV distributed file create a logical file view of your UV physical files. Note that BCI is a programmatic API inter

Re: [U2] How to check which sproc is called by user

2013-01-09 Thread Hona, David
Here's some troubleshooting tips we use for our applications using the U2 APIs in background non-interactive processes. We have a common interfacing subroutine our API clients must use to "sign-on" and initialise their UV environment. In that code, we turn on COMO output, to capture any output

Re: [U2] Garbage in locks

2013-01-07 Thread Hona, David
Looks like UV? What version or platform? Did these user process normally exit UV or did they drop connectivity or abnormally terminate from UV?? UV Lock Daemon typically cleans-up non-deadlock locking issues, including orphaned locks (sometimes :)). -Original Message- From: u2-users-bo

Re: [U2] [UV]Corrupted object in global catalog

2013-01-02 Thread Hona, David
Here's some options for you... 1. Verify it is cataloged in Global Catalog The subroutine !EXIST subroutine was created for Prime INFORMATION compatibility and does a simple check to verify the program is catalogued only. Check out the source code in UV account APP.PROGS, EXIST. 2. Verify Obje

Re: [U2] Universe 11.x

2012-12-15 Thread Hona, David
Your mileage will vary - the more UV specific "features" or APIs or the like you utilise - they more issues you're likely to have. As these tend to change at each release. If on the other hand, you have plain vanilla application then you're unlikely to have issues...then all you're doing is pro

Re: [U2] Advantage of indirect call in BASIC

2012-12-09 Thread Hona, David
If you encounter this, it is probably a Prime INFORMATION (PI) legacy code. As this was a commonly used convention in natively developed PI applications (rather than PICK-ported apps). As globally catalog'd object was a typical naming convention for "production" object in PI. Plus as mentione

Re: [U2] UPLOAD not DOWNLOAD

2012-10-26 Thread Hona, David
You could modify Brian Leach's freeware BCI.IMPORT tool which is designed for SQL / BCI imports. But looks relatively easy to modify for what you want ! ;-) With his permission, of course ! I just downloaded to have a peek... as I have been looking at his other tools lately... There is also pr

Re: [U2] [BDT] A giant leap forward

2012-10-26 Thread Hona, David
Yes, it is a vastly improved beast over earlier versions. Like others, I not a fan of the timeout of the UniObject session. BDT has features the competition has yet to add. I especially like being able to expand the inserts and see the BASIC Labels easily accessible. I still haven't been to get

Re: [U2] New Rocket U2 website!

2012-10-26 Thread Hona, David
Looks good and well organised A new addition to the Rocket U2 team, I see! Totally RAD! :) http://u2.rocketsoftware.com/images/minihome/sbxa/sbxa_rad.png The "learn more" icons & the rolling animation are all a bit too large...and the text in the "footer section" too small...but looks good - nic

Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper

2012-10-15 Thread Hona, David
Task Manager and add Base Priority column...see if that changes...after you do your thing. May do nothing if Rocket hasn't actually hook in the required hooks into UV. Plus a lot of the times you will need to be a Local Admin to change priority higher (if it works at all). In some cases like

Re: [U2] Consuming Web Services

2012-10-04 Thread Hona, David
Very true and I agree that the DB Server (SQL, et al) and the DB client engine (UV) models each have pros and cons. UV is a lightweight DB and application engine with some very good capabilities in the DB and application area. Plus of course some truly powerful features too! It is not the best

Re: [U2] STARTUP file issue with UV11.1 PE version (Linux)

2012-10-02 Thread Hona, David
The installation instructions of Rocket is quite good and does indeed mention the need to use "cpio" on UNIX servers. See "Quick Installation" and "Step-by-step Instructions" (of NEWINSTALL.PDF)... However, the instructions from Rocket could be improved - with a minor revision, as the Installat

Re: [U2] Scrub HangUp Fixed

2012-08-31 Thread Hona, David
users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, August 29, 2012 8:32 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users

Re: [U2] Scrub Hangs Up

2012-08-29 Thread Hona, David
Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html Same problem/solution? I kindly suggest that you go on a Rocket UV course to help work out how to get the best from UV. Plus the UV ODBC documentation is quite detaile

Re: [U2] PI/UV: Decompiler *** mispelling correction *** in the previous email

2012-08-27 Thread Hona, David
I don't believe it is free nor freely even away to anyone who asksfor obvious legal reasons, etc. As there are some dishonest types at there! :) Or you just buy that third-party tool. Which is probably going to be a lot cheaper and you don't have to disclose to anyone, have proof of ownershi

Re: [U2] Escaping quotes

2012-08-15 Thread Hona, David
I think this article says it all... http://en.wikipedia.org/wiki/Comma-separated_values -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 16 August 2012 10:48 AM To: u2-users@listserver.u2ug.

Re: [U2] Universe; SQL; Indexes?? (10.3.7 on Windows)

2012-08-01 Thread Hona, David
Try and be very specific what it is you are doing and why. For example - why are you using SQL? Are you doing SQL queries via the TCL prompt or using a client tool on Windows? What is the query? What do you mean by 'optimize the performance'...Etc., etc. UV has two query languages and a single

Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?

2011-08-09 Thread Hona, David
Is your UVCONFIG parameters still set to the default values? If so, you need to change these to suit. You can baseline them using your previous UVCONFIG parameters from your old host and see how your application performs. Further tweaking of them may be required if your application profile (uti

Re: [U2] AIX uname and Redback

2011-08-05 Thread Hona, David
One 'simple' thing to try... I'd ask them to first check the ulimit settings from the UNIX shell before they enter (ie., what is the default). For all the values not set already to unlimited. Retry and see if that makes any difference. Only other thing I can suggest: create a Korn Shell VOC e

Re: [U2] Why use U2, was Interesting Article

2011-07-13 Thread Hona, David
Always...use the right tool, for the right job...one size doesn't fit all, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 14 July 2011 3:56 AM To: 'U2 Users List' Subject: Re

Re: [U2] Universe 10.1.22 on AIX 5.3 ML 4

2011-06-20 Thread Hona, David
Hi Bob My bad experience with label common variables in the same context was we implemented a program that compiled and implemented - it had the very same variables. It never got picked-up in the testing, 'cause it didn't use the variable for display purposes...Hence, our terminal attributes go

Re: [U2] Enterprise Scheduling solution

2011-06-15 Thread Hona, David
Like another poster said AutoSys is common enterprise multi-platform scheduling tool with it's own scripting/scheduler language. But it won't be cheap and it probably will be an overkill. Tivoli, There are lots of similar tools out there, some optimized for the major enterprise ERP packages, RD

Re: [U2] UniObjects.Net error message

2011-05-31 Thread Hona, David
Is this a new program/process? Do it is just stop working? Does it rely upon label common variables, file hands/variables, etc which perhaps aren't defined when calling it via your call? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u

Re: [U2] [UV] Emulate SQL MAX() function at TCL

2011-05-27 Thread Hona, David
Hi Stuart, Probably too late now... but... If you defined your SQL table with the DEFAULT "NEXT AVAILABLE" it will automatically increment the primary key value by 1 when you insert a new row... CREATE TABLE MYTABLE (CLIENT_NUMBER INT PRIMARY DEFAULT 'NEXT AVAILABLE', CLIENT_NAME VARCHAR FMT "3

Re: [U2] UVSQL CALL with MSSQL Openquery against linked UV server.

2011-05-16 Thread Hona, David
Hi Stuart, I've used SQLExecDirect with UV before, we always allocate and prepare for each of the required parameter markers. Then call UV BASIC subroutines via SQLExecDirect. I would hazard a guess that QueryTool is doing a SQLExec and Transact-SQL pass-through is doing a SQLExecDirect. The l

Re: [U2] Limitations of uvrestore

2011-05-02 Thread Hona, David
I don't know of anyone who actually relies upon uvbackup/restore for their backup/restore strategy. Other than supposedly support "online" backups and checking file integrity - I would see it's relatively slow speed as another reason not to utilise it. Other DB vendors tools tend to suffer from

Re: [U2] [BDT] U2 Resource View

2011-04-20 Thread Hona, David
The first two-lines after "Bill:" has the answer ...I can confirm that it is correct, as well. The answer doesn't exist in the manual either...yet one more reason to "hate" Eclipse :-) I can't vouch for the other claims though... I was initially confused by the response - hence missing the ans

Re: [U2] UV Common

2011-04-07 Thread Hona, David
Pick-style BASIC COMMON is documented in the Pick.pdf document in the UV 11.1 document set. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Thursday, 7 April 2011 1:52 AM To: U2 List Server Su

Re: [U2] Databasic conversion

2011-04-07 Thread Hona, David
Also see Pick.pdf in the Rocket U2 UV11.1 document set. It documents the differences between D3/PICK and UniVerse. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 7 April 2011 7:42 PM T

Re: [U2] Databasic conversion

2011-04-07 Thread Hona, David
UniVerse PICK flavour account would probably be - out of the box - the path of least resistance. As UniVerse emulates the PICK D3 environment much better than Unidata. Unidata was designed to be a clone of Prime INFORMATION - engineered from the manual up (which including doing this the PI Manu

Re: [U2] dynamically disassociate associated fields?

2011-03-31 Thread Hona, David
You can use an alternate dictionary in native or SQL queries... USING DICT MYALTDICT Or more practical suggest made by Kate is to have a different dictionary definition... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Be

Re: [U2] Trigger questions

2011-03-31 Thread Hona, David
When/if you upgrade to UV 11.1 - perhaps you should use Index-based triggers - now supported by Rocket. Simpler than SQL-style triggers... see the new features.pdf in UV 11.1. Excerpt: "In some circumstances, an application may not require all of the capabilities available to conventional trig

Re: [U2] User LogOut Cabbage

2011-03-10 Thread Hona, David
have trouble writing to the directory. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, March 08, 2011 8:22 PM To: 'U2 Users List' Subject: Re: [U2] User Lo

Re: [U2] File Corruption

2011-03-09 Thread Hona, David
Are they dynamic files? Are your cron jobs phantoms or are you using "uvcron" (http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron) or something similar? Any issues recently with locking or UV processes "core dumping" and/or the T30FILE semaphore remaining locked/with high collision count? -Or

Re: [U2] User LogOut Cabbage

2011-03-08 Thread Hona, David
Are you clearing your &SAVEDLISTS& directory from UNIX (scheduled or manually) and then this error appears? If so, it is probably deleting the required .Type19 entry (within the &SAVEDLISTS& directory. Possible solution: purge away, but re-create the .Type19 file using 'touch .Type19' or the l

Re: [U2] Multi-Threading Universe Socket traffic

2011-03-07 Thread Hona, David
I'd agree with this approach...I've used it many times before... A good well thought out design well help you...design first: code second :-) I've in the past done the following: - control program to configure, start/monitor/stop phantom processes - I find writing a phantom process which logs wh

Re: [U2] Version Control

2011-03-03 Thread Hona, David
If you are using U2 environment a lot of stuff won't work without utilising the VOC some fundamental or critical way. VOC entries for files, programs, paragraphs/PROCS, etc. Granted, in some cases these don't change often. Unless you are like some poor sites I have seen and run their entire or p

Re: [U2] U2 soap server on startup

2011-02-24 Thread Hona, David
-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, February 24, 2011 2:41 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] U2 soap server on startup See the Webservices.pdf in the U2 Documentation. Specifically "Deploying Web Services"...If i

Re: [U2] Telnet session limt has been reached (was Retrieving data from remote SQL DB from Universe via ODBC?)

2011-02-23 Thread Hona, David
Oh, did you fix your ODBC problem? :-) I can't recall you posting any responses back?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Thursday, 24 February 2011 11:47 AM To: u2-users@listserver.u2ug.o

Re: [U2] U2 soap server on startup

2011-02-23 Thread Hona, David
See the Webservices.pdf in the U2 Documentation. Specifically "Deploying Web Services"...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being p

Re: [U2] Frustrated with Rocket / Unidata 7.2

2011-02-17 Thread Hona, David
It's impossible to please everyone. My bug report (and the long awaited fix...comes before yours :-) Get to the back of the line!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 18 February

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Hona, David
Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest thi

Re: [U2] [UV][AIX] System Management and Performance Tools

2011-01-20 Thread Hona, David
We have used "nmon" on AIX. But we don't use UV on AIX here. It's free and doesn't come with anything fancy like the commercial toolsets... I have used GlancePlus on HP-UX. There is an AIX version available and a trial can be arranged via: https://h10078.www1.hp.com/cda/hpms/display/main/hpms_co

Re: [U2] LIST.READU - RELEASE (done)

2011-01-18 Thread Hona, David
Try the UNLOCK command. Also, I recommend you use "LIST.READU EVERY" to see all locks held. Usage: UNLOCK USER xxx ALL or UNLOCK INODE ALL (or similar if I recall the syntax. (Copy entries mentioned above from the UV account VOC file, if not present) NEVER use UNLOCK ALL...unless you wish

Re: [U2] Sockets problem

2011-01-10 Thread Hona, David
Also check and updated your /etc/services with your desired TCP or UDP ports you end up using. Saves grief in the future too :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: Tuesday, 11 January

Re: [U2] [UV] Invalid SELECT list specification keyword ignored.

2011-01-06 Thread Hona, David
Do you get the same problem with EXECUTE? BTW: Do you have $OPTION PERF.EQ.EXEC set in your code? Finally, have you tried adding "SELECT.ONLY" keyword so it only executes if there is an active select list (not sure if it can/will check select list 9 though!). -Original Message- From: u

Re: [U2] uonet

2011-01-06 Thread Hona, David
None of these articles give you exactly want you want...but they should point you in the right direction... :-) Brian Leach posted an example, which may help, some time ago: http://old.nabble.com/list-DICT-uniObjects-to24476618.html#a24476618 Also Brian wrote this detailed introduction to VB & U

Re: [U2] UVODBC Connection Problem

2010-12-01 Thread Hona, David
Are you certain the UniRPC daemon is started on your UV HPUX host? Also I suggest you do a CONNECT to "localuv" via TCL prompt to ensure every is OK from UV on your host system before hand...if you are unable to do an local connection it's very unlikely a remote connect will work either. At the

Re: [U2] Connectivity issue with ODBC - SQL.

2010-11-23 Thread Hona, David
You don't mention the nature of the processing you're doing...so here's some 'potential' scenarios... :) But in reality it could be lots of things... 1) Lost connection to UV Is it possible you connection is timing out? That is, your UV ODBC connection is timing out - possibly? Check the timeo

Re: [U2] Uniobjects on windows mobile/CE

2010-11-22 Thread Hona, David
is notoriously buggy. Hona, David wrote: > Check this out: > https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/ > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of J

Re: [U2] Uniobjects on windows mobile/CE

2010-11-21 Thread Hona, David
Check this out: https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Saturday, 20 November 2010 4:53 AM To: U2-Users@listserver

Re: [U2] New Client Specifics

2010-11-14 Thread Hona, David
In fact IBM wrote the basis of what we now call Eclipse... But Doug's company has been in the U2/MV Eclipse market way before IBM U2/Rocket got there...perhaps they were in fact inspired by the U2Logic editor.. :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Hona, David
Hi Gregor Thanks for sharing your useful experiences and your blog. I found the same issue with U2 MQSeries API documentation too. Although, I guess when you are using such complex API's - it helps first to understand the underlying technology and concepts. Be it MQSeries or XML, etc. Otherwise

Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC

2010-08-13 Thread Hona, David
Hi Augusto, Oh, I see. I guess the only option you have is to either move off PowerPC or get the AIX for PowerPC - then you can get vUV 10.3.x? I guess that isn't going to be cheap or perhaps not feasible for your existing server? Or perhaps use UV/Net to connect to a server with a later versio

Re: [U2] mv.NET and U2.NET

2010-08-13 Thread Hona, David
I'll second that... Perhaps some of the large amount of energies expended in this colourful exchange can be diverted to a blow-by-blow feature comparison of U2.NET and MV.NET for a Spectrum magazine article? :-) - features - optimisation - benefits - licensing arrangements/schemes - installed l

  1   2   3   4   >