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

2010-05-10 Thread Hona, David
Any valid command can be executed as a stored procedure via SQLExecDirect (eg., CALL LIST.READU - you need the CALL to specify a store procedure call). Just don't call anything requiring terminal keyboard input.. including anything that pages the output (eg. 'press any key to continue') - other

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

2010-04-11 Thread Hona, David
Unfortunately, this is a 'feature' of UV/SQL Triggers. You will have to disable the trigger first, if you wish to use RAID. There aren't any means to avoid this. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]

Re: [U2] Error connecting to Universe using Web Service Developer Tool

2010-02-17 Thread Hona, David
If you don't have a connection pooling license on your UV server, turn it off in U2 WSDT. See page 113 in the webservices.pdf. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin Sent:

Re: [U2] UniRPC returning 39125

2010-01-07 Thread Hona, David
Firstly, given that InterCall is a C-API I am puzzled what you are doing and exactly why you need to use it? As a C client application, you could only invoke it from UV via UV shell or via GCI call. Which are you doing? Secondly, UniRPC and it predecessor - UVRPCD has virtually always required

Re: [U2] UniRPC returning 39125

2010-01-07 Thread Hona, David
Oh UV and UD on the same server? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 8 January 2010 10:11 AM To: 'U2 Users List' Subject: Re: [U2] UniRPC returning 39125 And that was the

Re: [U2] INPUTIF

2009-12-22 Thread Hona, David
First, check if your 'Caps Lock' key is broken. :) Next, check your SSH2 and SSH1 settings are the same on your AIX server. Finally what version of SSH server are you using? SSH Tectia or OpenSSH server? I've read about bugs in SSH2 and seen poor SSH2 implementations on terminal emulators

Re: [U2] INPUTIF

2009-12-22 Thread Hona, David
:02 PM, Hona, David david.h...@cba.com.au wrote: First, check if your 'Caps Lock' key is broken. :) Next, check your SSH2 and SSH1 settings are the same on your AIX server. Finally what version of SSH server are you using? SSH Tectia or OpenSSH server? I've read about bugs in SSH2 and seen

Re: [U2] errlog question

2009-11-29 Thread Hona, David
BTW: The messages numbers are all in SYS.MESSAGE file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Monday, 30 November 2009 11:15 AM To: U2 Users List Subject: Re: [U2] errlog question Doug,

Re: [U2] Where do print/crt statements go when using UniObjects?

2009-11-24 Thread Hona, David
If you create a COMO file (if using UV, you can do this using the DIVERT.OUT or COMO commands or the !COMO subroutine) it will capture the output in that file on your host systems in the local account/directory you're current in. Just a hint, if you have multiple connections (due connection

Re: [U2] UniData Unibasic IN function

2009-11-10 Thread Hona, David
Bob, This is kind of a FAQ and you'll find a few responses in the archives for the U2 Users groups (via Google search) in Mail Archive and similar archiving services... Here's one response from Martin Phillips (UV specific, but I think you get the idea) ... maybe an overkill for you?:

Re: [U2] File corrupt

2009-11-09 Thread Hona, David
Yeah Martin, that is strange - especially how they can check in the UV PE edition to make sure you don't exceed the maximum file size allowed. Albeit, that's probably check the maximum number of groups... ! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Universe Triggers

2009-11-09 Thread Hona, David
Did you do a sanity check (on your system/UV setup - not you:))- being a Windows platform check- no real-time anti-virus scanner is in operation on every file modification and that the UV config is NOT using the defaults (perhaps you should be setting it to the something similar to your AIX UV

Re: [U2] Hard to get connect UniVerse 10.1.7 Database To DataGridView with UniObject.

2009-10-21 Thread Hona, David
Jayendra, Trying a google.com query with those keywords. You may be surprised to find that answer(s) you seek. It is always useful to do some quick checks of the archives of this email list - Google being the quickest way to do this. Good luck! David -Original Message- From:

Re: [U2] EXECUTE 'CLEARSELECT'

2009-10-11 Thread Hona, David
This usually indicates that your EXECUTE is executing at a different execution layer. Prime INFORMATION did this by default and had to use PERFORM to use the same runtime execution layer or overide with a $option statement. From:

Re: [U2] UniObject .NET Session and Common Block Bug

2009-10-08 Thread Hona, David
Hi Adrian I've never seen this particular issue before. What release of UniVerse or UniData is this (likewise the clients too)? What OS/platform is your U2 installation on? I would suggest some of the following to assist you in drill down the root cause: a) Execute a DIVERT.OUT or COMO ON

Re: [U2] I need your eyes

2009-10-08 Thread Hona, David
It's interesting to see IBM's claims about they didn't buy U2 specifically (which we know they purchased Informix DB technology and U2 was a bonus) and it doesn't fit into their future goals. I find that amusing when they continue to sell databases like IMS and Informix C-ISAM (etc) and the

Re: [U2] U2 is now Rocket U2

2009-10-07 Thread Hona, David
What's in a name? BTW: I never liked Ardent Software...thank goodness that name hasn't been brought back... yet! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Thursday, 8 October 2009 7:26

Re: [U2] Connecting to a Universe Database

2009-08-18 Thread Hona, David
: Tuesday, 18 August 2009 10:45 AM To: U2 Users List Subject: Re: [U2] Connecting to a Universe Database David, Do you have examples for the use of UV/BASIC subroutines invoked as stored procedures from SQL Server/ Thanks, John From: Hona, David david.h

Re: [U2] Connecting to a Universe Database

2009-08-17 Thread Hona, David
It is highly recommended that you upgrade your version of UniVerse before you consider what interface to use. An ODBC interface is mostly the easiest to implemented, but the slowest and hardest to debug. Especially on such an old version of UniVerse. Further, unless you're UV data is in a

Re: [U2] FW: Universe just quits

2009-07-23 Thread Hona, David
Harold, You can define the global (or default) value for AUTOLOGOUT by creating a UV.LOGIN paragraph in the VOC file in the UV account. The UV.LOGIN paragraph gets executed before the LOGIN paragraph. This merely enforces a default autologout value, for all UV sessions system-wide. It isn't

Re: [U2] FW: Universe just quits

2009-07-22 Thread Hona, David
Harold, Is there any reason you don't use the UV command AUTOLOGOUT to time out idle sessions? It does what you want already from within UV already (and can be setup individually or globally for all UV sessions) and doesn't have the problem of just looking at terminal keyboard input idle

Re: [U2] Universe just quits

2009-07-21 Thread Hona, David
In addition to what Laure mentions - using dynamic arrays to store lots of data can result in Available memory exceeded errors (resulting in UniVerse abnormally terminating). Just like if you're using READ/READU to read in large text/sequential files. -Original Message- From:

Re: [U2] UV UOJ hung sessions

2009-07-02 Thread Hona, David
I useful thing I have found for any connectivity made via U2 APIs (be it UOJ, UCI, etc) is to get your subroutine to establish a COMO/DIVERT.OUT to log errors that made not get logged anywhere but output to 'standard output'. It's surprising the number of errors you get before your main UV

Re: [U2] Updating AS400 Data from Universe

2009-07-02 Thread Hona, David
Scott, The AS/400 DB probably has the same ODBC issues as UV regarding mapping of non-relational/non-table data. Hence, I've found the use of stored procedures can be a useful bridge for such issues which UV is the target to be updated. I don't know if AS/400 supports such a thing as call

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

2009-06-24 Thread Hona, David
I prefer and use lower case statements/functions/labels, etc and variables in uppercase. Purely to be consistent, all existing code is coded in the style - layout, format, case of the original. Nothing worse than seeing different standards in the one program. ;) It makes good sense for

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-19 Thread Hona, David
The BASIC Developer Toolkit represents a significant step in the right direction which will set the standard for U2 toolsets. There will also be third-party tools that may have better features or potential work better. But none that will have the integration and back-up of IBM's U2 team. As

Re: [U2] Web services

2009-06-08 Thread Hona, David
Hi Craig No, I was more talking at the TCP/IP socket level. We use this method extensively due to internal and external firewalls - filtering source and destination IP, inspecting packet type - sometimes using security tokens as well authenticating the Active Directory logons. Of course these

Re: [U2] Web services

2009-06-05 Thread Hona, David
In general, you want web services to stick to what they do best and handle custom/specific security requirement/issues outside of them. Such an approach could including installing a proxy server or firewall (hardware or software) between the web service server and the web services consumers.

[U2] RE: Truncated catdir names

2009-05-27 Thread Hona, David
Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been

RE: [U2] RE: Truncated catdir names

2009-05-27 Thread Hona, David
type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir

RE: [U2] RE: Interest results on VOC file

2009-04-29 Thread Hona, David
It's a feature! For old legacy apps that use the marker (and other control/non-printable) characters as part of the key and are too hard to change. UV lets you turn that feature off, maybe UD does too now. -Original Message- From: owner-u2-us...@listserver.u2ug.org

RE: [U2] UV AIX 10.2 - MQ 7

2009-03-30 Thread Hona, David
The interesting question is why use MQ to communicate between Oracle and Universe - when you could use UCI? Or do you mean you have two applications using these respective databases that will communicate?? Failing new bugs/features in MQv7, there should not be any significantly differences

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

2009-03-18 Thread Hona, David
Further clarification of the requirements would be useful. When and how often do you want to do this? Do you want to use an API or using the 'shell' okay? Is it to be used on Windows UNIX servers? Does need to work on UD UV? Do you want to 'spend' any money to get the 'perfect' or quick 'n'

RE: [U2] UV Timed INPUT

2009-03-12 Thread Hona, David
There was a discussion way back in 2004 about this. Keith Johnston wrote and published his UV/BASIC solution on PickWiki... http://www.pickwiki.com/cgi-bin/wiki.pl?InputWait Posting/Thread: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg00891.html Regards, David -Original

RE: [U2] UVrpcd vs UNIrcpd

2009-03-01 Thread Hona, David
I believe the answer is no, you can't speak between UniVerse RPC daemon versions, as the protocol is version specific. If I recall correctly, I even UV-Net on 9.5.x and 9.4.x may not work David -Original Message- From: owner-u2-us...@listserver.u2ug.org

RE: [U2] AUTOLOGOUT and ON.ABORT

2009-02-26 Thread Hona, David
In UniVerse, @ABORT.CODE is set to signify the reason code. I can't recall value set for AUTOLOGOUT though and I can't check right now. Regards David -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mike Roosa Sent:

RE: [U2] UV/SQL syntax

2008-12-11 Thread Hona, David S
Hi Stuart No doubt, this is a feature (of some description)... Are these associated multivalues? Maybe use the UPDATE.RECORD verb - I realise you want to use the SQL UPDATE though! :) But sometimes, it is to painful for simple stuff, like what you're trying to do! Regards David -Original

RE: [U2] Web Services Developer

2008-12-11 Thread Hona, David S
Do you mean an existing WSDL file, that you have previously defined/created using U2WSD, but you're moving from a different PC? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Friday, 12

RE: [U2] DEBUG mode on a UniObjects connections

2008-12-04 Thread Hona, David S
Note that the SYSTEM(9001) function call returns the runtime stack. I use a generic logging subroutine that writes to a sequential file any information I want to log: call @debuglogger(Starting phase 1) In debuglogger, it writes out timedate stamp, PID, @USERNO, @WHO, @PATH, etc., etc. along

RE: [U2] Universe triggers (still more)

2008-12-03 Thread Hona, David S
Great feedback Susan. Perhaps you should make some suggests to IBM U2 team for a few tweaks to UV triggers? I guess this highlights too different schools of thought. The quick and dirty world of PICK/U2 and the by-the-book of relational databases. Each has pros and cons. Where the two meet, we

RE: [U2] SELECT-READNEXT That's odd

2008-11-14 Thread Hona, David S
What UV account flavour? What does SR.EXECUTESQL do exactly: EXECUTE or BCI SQLExecute ? Why don't you clearselect 0, if you're not going to process the result select list? Like READNEXT DEPENDANT.ID THEN CLEARSELECT 0 ELSE..it seems pointless ? Or are am I missing something? -Original

RE: [U2] Basic SQL Client Interface

2008-11-14 Thread Hona, David S
Hi Marcos, Did you successfully re-link UV? If so, why don't you try the CONNECT command to connect to your data source. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marcos Fogaca Sent: Tuesday, 11 November 2008 12:09 AM To:

RE: {Blocked Content} RE: [U2] Need help with GCI system

2008-11-07 Thread Hona, David S
) for more information. From: [EMAIL PROTECTED] on behalf of Hona, David S Sent: Thu 11/6/2008 7:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with GCI system Isn't your module called magci and not test? As your error indicates it's looking

RE: [U2] Job Posting

2008-11-03 Thread Hona, David S
Gary, it might help if you send your details to the email address listed in the posting, not to the entire U2 Users group email list. :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of GARY TEN HOVEN Sent: Tuesday, 4 November 2008 3:46 PM To:

RE: [U2] Documentation

2008-10-29 Thread Hona, David S
There is no such command in UV, as you stated. Please be more specific what you're trying to do and why... Perhaps you are referring are to the BASIC Call Interface (BCI), a ODBC Call-level API for UV/BASIC? Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] [u2] UVsql

2008-10-26 Thread Hona, David S
Check out the UV SQL Reference Guide for NEXT AVAILABLE. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Monday, 27 October 2008 2:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] UVsql Good day all,

RE: [U2] [UV] PHP

2008-10-23 Thread Hona, David S
There is a series articles written by IBM U2 Engineers in the IBM U2 DeveloperWorks website on that topic. Google it or find it via the mainpage: http://www.ibm.com/developerworks/db2/products/u2/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [U2] UniVerse and/or AIX caching

2008-10-23 Thread Hona, David S
What are the file stats for this UV file? Just curious. I guess of you want a high-end SSD then you need to look at a device supported on AIX and you probably fibre-channel I/O too. Check out this webpage: http://www.storagesearch.com/ssd-fc.html Note the comments made on this page: quote

RE: [U2] UniVerse and/or AIX caching

2008-10-23 Thread Hona, David S
Maximum number of fields per record = 366 Groups 25% 50% 75%100%125%150%175%200% full 951617445258613406 861 145 16 On Thu, Oct 23, 2008 at 2:05 PM, Hona, David S [EMAIL PROTECTED] wrote: What are the file stats

RE: [U2] Universe Triggers

2008-10-20 Thread Hona, David S
Ray, let's not talk about huge and (formerly) little known security flaws in UV now... :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, 21 October 2008 12:44 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe

RE: [U2] running uvrpc at the same time on different ports

2008-10-19 Thread Hona, David S
There is extensive documentation in the UniVerse Admin guide - should you wish to change the UV unirpcd TCP port. But I am guess you want to change the DataStage daemon, so refer to the it's installation and configuration/admin guide. Regards David -Original Message- From: [EMAIL

RE: [U2] Universe Triggers

2008-10-14 Thread Hona, David S
You can by-pass them if you can update the VOC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 14 October 2008 10:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers Both Universe and Unidata have

RE: [U2] Universe Triggers

2008-10-13 Thread Hona, David S
I think the purpose of the trigger is to capture all non-application changes. You can't by-pass the trigger easily, unless of course you disable it entirely. It has the advantage of being largely transparent (if written correctly, of course)...regards of where the file is accessed from. It has

RE: [U2] Universe Triggers

2008-10-08 Thread Hona, David S
Poorly written, implemented, designed and tested triggers - will have a high impact on your UV system. Hopefully, you have down a full-scale (real world-like) production-like test in your UAT environment prior to implementing them. If you have done this and tested real world scenarios like file,

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

2008-10-06 Thread Hona, David S
It's poorly documented (likely many other things!), but use the following syntax: EQU MX LIT 'ABCD': @AM: 'EFGH' Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Tuesday, 7 October 2008 7:06 AM To: U2-Users List

RE: [U2] [Uv 10.2] Connection Pooling Working?

2008-09-18 Thread Hona, David S
Oops, sorry Charles - I miss read your query... here's app.config from an IBM supplied Connection Pooling code. It seems to work fine for me. --- Set pooling programmatically (VB.NET): [snip] Private m_IsPooling As Boolean = False [snip] UniObjects.UOPooling = m_IsPooling [snip] --- set pooling

RE: [U2] [Uv 10.2] Connection Pooling Working?

2008-09-17 Thread Hona, David S
From TCL, type CONFIG. If it is licensed then you will have a entry for -CONNPL displayed somewhere in the output. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of charles ferguson Sent: Thursday, 18 September 2008 1:08 PM To:

RE: [U2] uniVerse COPY command and the UVTEMP directory

2008-09-17 Thread Hona, David S
The UV COPY verb is intended for copying records from hashed files. However the UV COPY verb was originally a UNIX executable (pre UV v7, I think). Hence, it didn't have the memory limitations of the existing UV/BASIC application (COPY.B). I understand that it would required significant

RE: [U2] uniobjects

2008-08-14 Thread Hona, David S
What version of UniObjects are you using for .NET versus the VB6 client? There is should only be one version and one instance of UniRPCD on the server. IN theory you could have multiple versions - but that would be a really *bad* idea. You also have to be using the correct client for that

RE: [U2] uniobjects help needed!

2008-08-06 Thread Hona, David S
Doug Sounds like your need to plan your next approach need to take a slight different tack. Perhaps with a effort to help isolate the UniObjects issue you have identified. As so far you've no luck with the various approaches you're spent many hours devoted to this tricky issue. With issues like

RE: [U2] Data Editor

2008-07-29 Thread Hona, David S
I'd have to agree, it is great for a free tool. The lack of native support for SSH in UniDebugger (and Dynamic Connect) use to be an issue for anyone who has a site that no longer allows telnet. I haven't tried it lately, though - not sure if it has been updated or if IBM still gives it away

RE: [U2] [uv] Secure Sockets / SSL

2008-07-22 Thread Hona, David S
Why re-invent the wheel when there are plenty of commerical SSL/TLS packages out there already? Such as SecureBlackBox suite (there are plenty more out there)...they have downloadable trialware code examples, etc. http://www.eldos.com/sbb/net-ssl.php Regards David -Original Message-

RE: [U2] Strange SQL query optimisation ...

2008-07-21 Thread Hona, David S
Without actually knowing what you're really trying to achieve (as the two queries are markedly different in what would be produced)... It seems the second query should be an INNER JOIN - perhaps? Seeing the EXPLAIN output of your original queries and the second one with a INNER JOIN could be

RE: [U2] Question about Uniobject and session encryption

2008-07-21 Thread Hona, David S
Try: uvSession.EncryptionEnabled = 1 True evaluates to -1 in VB usually. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Lin Sent: Saturday, 19 July 2008 9:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Question about Uniobject and session

RE: [U2] Extra Form Feed from .prn File Followed by Text

2008-07-10 Thread Hona, David S
Have you tried PCL 3 PCL 4 drivers to create your PRN file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don P. Nagai Sent: Friday, July 11, 2008 12:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Extra Form Feed from .prn File Followed by Text

RE: [U2] UniObjects - read .rtf doc from UV server

2008-07-07 Thread Hona, David S
Same as U2 BASIC via sequential read/write. Check out the UniObjects for .NET documentation for the UniSequentialFile Class. If it is a large complex .RTF then, you may be far better processing it server-side - if feasible. As the round robin impact of sending the data to the client and back to

RE: [U2] RE: ODBC problems

2008-07-01 Thread Hona, David S
Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] UniObjects.NET: populating ListBox from XML

2008-05-14 Thread Hona, David S
Oh, delete the line with 'ListBox1.DataSource = DS' in it, I forgot to! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Wednesday, May 14, 2008 2:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects.NET: populating

RE: [U2] Backup Question

2008-05-14 Thread Hona, David S
uvbackup is the official database backup/restore utility. Hardly anybody uses it though, it's too slow and not very flexible for some. It has the advantage of performing internal data (structure) file integrity checking, as part of the backup and internally tagging the files as backed-up. You can

RE: [U2] UniObjects.NET: populating ListBox from XML

2008-05-13 Thread Hona, David S
Clif, Try something like this... Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS With ListBox1 .DataSource = DS.Tables(0) .DisplayMember =

RE: [U2] UniObjects.NET: .GenerateXML method fails

2008-05-07 Thread Hona, David S
: .GenerateXML method fails Thanks, David. I'll check those references and post a summary findings back to the list. I really appreciate the help! Regards, Clif On May 6, 2008, at 8:31 PM, Hona, David S wrote: Clif, I vaguely recall that the UniXML functionality isn't officially supported

RE: [U2] Indexes have disappeared

2008-04-22 Thread Hona, David S
You probably just need to use SET.INDEX to change the pathname to where the index file is now located. It's been discussed lots of times in this forum is the most common problem with indexes in UV. It's a feature!! :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [U2] Indexes have disappeared

2008-04-22 Thread Hona, David S
If not an identical pathname now, it would simply mean you had an old index at the same pathname previously. Now it appears you don't. Index broken - 'cause index is not there. Very common problem in UV. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [U2] uo.net logging

2008-04-16 Thread Hona, David S
I don't know about asp.net, but in my vb.net app.config that is using uo.net, I have (no doubt actually cloned from another app, probably IBM supplied sample!): ?xml version=1.0 encoding=utf-8 ? configuration !-- UO.NET General add

RE: [U2] TCL Command stacker

2008-04-16 Thread Hona, David S
Baker, This can be fixed by changing the initialisation string in your UV terminfo database for your terminal type you're using (copy source/original, re-compile uv terminfo, etc). By default it changes the numeric keypad to Application mode fot DEC VT-series emulations. Or change your emulator

RE: [U2] TCL Command stacker

2008-04-15 Thread Hona, David S
UniVerse 10.x has COMMAND.EDITOR, ported from PI/open but it is not officially supported nor documented by IBM. It has most, but not all the functionality of the PI/open version. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Miller Sent:

RE: [U2] Maximum size of the record lock table

2008-04-15 Thread Hona, David S
Depdends on your UVCONFIG parameters...what are your values for... GSEMMUM RLTABSZ If I recall correctly... GSEMMUM * RLTABSZ = maximum number of READU/READL locks Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent:

RE: [U2] Files Open

2008-04-15 Thread Hona, David S
It may be easier to use a UNIX utility like lsof, if you have it on your system already. Just a warning that it will produce details of the UNIX level files (all of them). You need to use the -p PID or -u unix-user-id (latter is not good if you're logged in multiple times though) to limit the

RE: [U2] Difference between Universe and Unidata

2008-04-14 Thread Hona, David S
As pointed out by George Land and Brian, they're effectively the same except for some very specific features that the average developer or end-user would've generally utilise...so to a great extent it doesn't make a lot of difference to most. To add what already has been said... UniVerse also

RE: [U2] problem with UniVerse SQL Users on windows (Domain name is now case sensitive)

2008-04-04 Thread Hona, David S
It's a problem with other applications too. We had the exact same problem with another third-party packaged application. The problem is Windows allows you to define David and david to mean the same thing. But to application software, these are two different users - unless the third-party

RE: [U2] error question

2008-04-03 Thread Hona, David S
In the UniVerse Administration guide (admin.pdf). Did you have a look or you can't find them? The documentation isn't the best!! These errors are best reported to IBM U2 Support. Especially, if you can reproduce the problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] base64 under Universe 10.2.4/AIX 5.3

2008-04-01 Thread Hona, David S
It is documented in UniVerse BASIC Command Reference Guide (BasicRef.pdf), even prior to 10.2. See ENCODE function page 232 in the manual Version 10.1 September, 2005 (not sure in the 10.2 version what page). LOTS of commands don't exist in the online help. IBM recently advised a new online help

RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}

2008-04-01 Thread Hona, David S
Oh yeah, got to love that. It didn't even make into the index, let alone the table of contents (of the PDF). How did they manage that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Wednesday, April 02, 2008 9:20 AM To:

RE: [U2] UV SOAP into Tomcat

2008-03-28 Thread Hona, David S
Hi Craig UniSOAPServer is built on top of Jetty (it is embedded). So, it won't work under Tomcat, unless it has some kind of servlet mode hidden under the covers. Turn on UniSOAPServer debugging and check out the log file, you can see all the glory details. ;-) Regards, David 2008 Mar 28

RE: [U2] UV SOAP into Tomcat

2008-03-28 Thread Hona, David S
Of course, the best confirmation needs to come from IBM. Drop their support team a request and get them to verify. It would help if there was deployment documentation, then we wouldn't need to go digging around and guess what the heck is going on(!). Regards, David -Original Message-

RE: [U2] UV SOAP into Tomcat

2008-03-27 Thread Hona, David S
Hi Craig, You're actually executing an application server of sorts, in reality, as UniSOAP server is actually an implementation of Jetty (or vice-versa, depending on your viewpoint). There is a debate of the merits of Tomcat versus Jetty. Adding another layer/interface has its pros and cons. But

RE: [U2] Type ahead buffer overflow

2008-02-26 Thread Hona, David S
I'd have to agree. If it's important, you should not be using unreliable means to input data. There are so many points of failure, worse than losing data it could be corrupting data. I wouldn't want to be the one to explain that to external auditors or angry workers whose payroll got glitched

RE: [U2] - Websphere MQ

2008-02-26 Thread Hona, David S
If you have never used MQSeries before, it is a steep learning curve. Even if you have, as Craig pointed out...the AMI libraries used by IBM to interface UV to MQ only seem to add to the learning curve and frustration at times (if you're learning and developing at the same time). Once you get it

RE: [U2] Change Prompt

2008-02-17 Thread Hona, David S
Easiest and official means of doing this is: COMMAND.EDITOR ON MYPROMPT ;* Set COMMAND.EDITOR ON ;* Reset Syntax is: COMMAND.EDITOR [ON|OFF] [ALL|VERBS] [INSERT|OVERLAY] [Optional TCL Prompt String] However, COMMAND.EDITOR is not officially supported and was developed by a third-party and

RE: [U2] [UV] Named commons

2008-02-13 Thread Hona, David S
Ah, that's a good idea...but I guess by-passing this restriction (which must be in place for a good reason), should not be taken lightly (especially in an mission critical environment). I guess you could also write some UV BASIC code based on RFC4122 if you want to be fully compliant. See the C

RE: [U2] Excel downloads

2008-02-13 Thread Hona, David S
Hmmm, a miracle tool for little or no money too? ;-) I do not know, if this meets your specific requirements, but... Have you looked at DOWNLOAD from http://www.cedarville.edu/departments/compserv/ftp.htm ? It's been around for a long, long time...no need to roll your own, when it's been done

RE: [U2] [UB] Arrow Keys FollowUp

2008-02-11 Thread Hona, David S
UniVerse has a little used function for inline field-level editing and keyboard function trapping, provided by !EDIT.INPUT (and !PACK.FNKEYS) which can do what you want. Probably 'cause it's poorly documented and a little hard to use, which is why it's little known or used (also 'cause it is

RE: [U2] U2 SOAP Server for Linux

2008-02-05 Thread Hona, David S
Sara IBM does not supply a U2 specific SOAP server for deployment in any environment. You need to deploy it yourself... Unfortunately, they make the assumption that you know how to do this yourself. It's been covered in a previous topic (which you started :)), I posted some clues on how to

RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer

2008-02-04 Thread Hona, David S
If business data integrity is a major concern, then you also need to ensure you business processing is complete and (ideally) - shutdown the UniVerse environment prior to any manipulation of UV database files using third-party/OS tools (rm, cp, rcp, scp, mv, tar, etc, etc). For high-availability

RE: [U2] Does UniVerse work with clusters of Unix machines?

2008-02-03 Thread Hona, David S
Louie It depends what you mean by work with and how you have your cluster configured. Are you using IBM's HACMP clustering software? If so, how is it configured now for your non-UV apps? What benefits are you expecting from clustering? Do you have UV Transaction Logging or Replication in use

RE: [U2] [UV] Selection help

2008-01-23 Thread Hona, David S
Oops sorry, I didn't read your issue properly! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Wednesday, January 23, 2008 7:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Thanks but it didn't work.

RE: [U2] [UV] Selection help

2008-01-23 Thread Hona, David S
Oh yes, I forgot to add that, I was answering in a hurry doing something else...didn't read the requirement again...LOL. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, 23 January 2008 8:38 PM To:

RE: [U2] Universe failure - why?

2008-01-22 Thread Hona, David S
Corrupt file? Is the file over 4 GB? What platform/OS version and UV version? Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Wednesday, January 23, 2008 10:39 AM To: u2-users@listserver.u2ug.org Subject: [U2]

RE: [U2] [UV] Selection help

2008-01-22 Thread Hona, David S
Try SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Wednesday, January 23, 2008 5:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Selection help I

RE: [U2] [UD] IP address in LISTUSERS command

2008-01-10 Thread Hona, David S
Bill, Haven't you already asked this question before?? ;-) http://www.nabble.com/UD-IP-Address-tc10993435.html Although, seems your issue wasn't fully responded to... My best guess...you've got U2 device licensing and your local IP address is being returned to the UD server by your device

<    1   2   3   >