RE: [U2] UV/SQL syntax
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 Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Friday, 12 December 2008 4:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV/SQL syntax Thanks David, The attributes ATT2 etc, I used are defined as single-valued D types. I have also tried using the keyword 'SINGLEVALUED'. It (UV/SQL) just seems to be aware of the multivalue marks and won't clear them. For the moment I have gone with creating a new item and updating it with the attributes I want to keep from the old item. Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Web Services Developer
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 December 2008 7:27 AM To: u2-Users Subject: [U2] Web Services Developer Hi All, Does anyone know of a way to import an existing wsdl into the Web Services Developer? Thanks in advance for any info provided. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DEBUG mode on a UniObjects connections
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 with the desired message. We have a global common flag to toggle it on/off or output to screen, as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Reynolds Sent: Friday, 5 December 2008 1:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] DEBUG mode on a UniObjects connections Interesting idea that. As standard, all subroutine calls in our software add to a Stack and their names are deleted from the stack when control is returned to the calling level. It doesn't solve the debug issue, but has given me an idea about tracing. I'm sure the code was originally designed for such a purpose, it was just never implemented. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 04 December 2008 13:31 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] DEBUG mode on a UniObjects connections Just chiming in on the debugging in a web page which might also help here since you loose the ability to interact. I have written a universal E-mailing program that can be called from any UniData program. It will work with both simple text or HTML depending on how much effort the programmer wants to exert. There are several simple INCLUDES that store COMMON info so that I can just plug this into any subroutine I want. Starting with my top-most subroutine (the one called by Redback), I INCLUDE my setup code and set a COMMON flag as either null (disable debugging E-mail) or with the name of the ASP web page (enabling the debugging E-mail). At critical points, I test if the E-mailing flag is turned on, and if so, create an E-mail with all the critical info I might want at that point, then send the E-mail to myself. This E-mail includes the initiating web page and all subroutines that have been called to get to the current subroutine. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe triggers (still more)
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 have a somewhat unhappy union - at times...such as it. You can have half-baked index-based triggers (I-types indexed and when updated call BASIC subroutines - all well documented by others in the past) or true triggers like UV offers. Originally, UV triggers were only available with SQL-ized UV tables only. Lots of power, but so much over-head too and some annoying constraints (in some respects). UniVerse BASIC has the ICHECK() function, but this is for pre-write data+key validation against SQL integrity constraints only. Perhaps IBM can make a enhancement to allow validation against the trigger as well (perhaps it does now days, I can't check at the moment). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Wednesday, 3 December 2008 12:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe triggers (still more) Thanks to the folks who gave me info on Unidata triggers. I've had those implemented for years and they do work very simply and well. Universe has been a whole different ballgame. SNIPPED Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Complete software development life-cycle management for U2. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT-READNEXT That's odd
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 Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 14 November 2008 6:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SELECT-READNEXT That's odd
One of our programmers wrote this snippet:
FOR YY=1 TO DCOUNT(WORK.ITEM.REC17,VM)
LISTNUMBER=''
SQLCOMMAND=''
UNISTATEMENT='SELECT BPM.WORKITEMS WITH
A1=':WORK.ITEM.REC1:' AND
WITH A2=':WORK.ITEM.REC2:' AND WITH A17=':WORK.ITEM.REC17,YY:'
AND
WITH A24#C AND WITH A24#R AND WITH A24#F'
*MY.REC1=UNISTATEMENT
CALL SR.EXECUTESQL(LISTNUMBER,UNISTATEMENT,SQLCOMMAND)
READNEXT DEPENDANT.ID ELSE
* NO ACTIVE ITEMS LEFT I NEED TO UPDATE THE STATUS OF THE
DEPENDANT TASK
CALL
SR.READSQL('BPM.WORKITEMS',DEP.TASK.REC,WORK.ITEM.REC17,YY,'')
DEP.TASK.REC24='A'
DEP.TASK.REC8=DATE()
DEP.TASK.REC9=TIME()
CALL
SR.WRITESQL('BPM.WORKITEMS',DEP.TASK.REC,WORK.ITEM.REC17,YY)
END
NEXT YY
The FOR loop has 2 values to iterate, so it does 2 loops. The function
SR.EXECUTESQL()does the SELECT call.
Loop 1 returns 2 keys found.
Loop 2 returns 0 keys found.
What's odd is that the select list is empty on loop iteration 2 and the
READNEXT is populated the ID with the second key from the first
iteration.
I looked in the help PDFs and all I found was a reference to a corrected
error
relating to memory not being released if the READNEXT did not exhaust
the
SELECT list.
Any thoughts?
We have since changed our strategy to check the count returned instead.
But it
would be nice to know that others have encountered this as well.
Jeffrey Lee
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P: (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au
___
NOTICE : This e-mail and any attachments are intended for the
addressee(s)
only and may
contain confidential or privileged material. Any unauthorised review,
use,
alteration,
disclosure or distribution of this e-mail (including any attachments) by
an
unintended recipient
is prohibited. If you are not the intended recipient please contact the
sender
as soon as
possible by return e-mail and then delete both messages.
___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SQL Client Interface
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: u2-users@listserver.u2ug.org Subject: [U2] Basic SQL Client Interface Hi, I4m trying use the Basic SQL Client Interface, I have installed the unixODBC driver manager on a linux box and using the 'isql' command I can connect to Oracle server. On this linux box I have a UV release 10.2 running too. I have configured a DataSource on the uvodbc.config pointing to Oracle. But, when I try connect to this Oracle DataSource using SQLBCIDEMO I get a segmentation fault error like this : Please enter the target data source ?XE Testing for data source connectivity Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program SQLBCIDEMO at address a6c. Segmentation fault Somebody have used the Basic SQL Client Interface (linux) connecting to a Oracle Server before? Any advice will be appreciated. Regards, -- *Marcos Fogaga * Clique e visite o nosso site! http://www.integral.com.br *Integral Sistemas *Telefone 11 3205-6000 . Fax 11 3205-6001 www.integral.com.br http://www.integral.com.br *Conhega toda nossa linha de solugues em conectividade atravis do nosso site http://www.integral.com.br!* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: {Blocked Content} RE: [U2] Need help with GCI system
Hi Bob,
Ah, forgot to ask the obvious, does this file exist:
e:\IBM\UV\bin\magci.dll
As Windows error 126 means missing file or registry entry is invalid.
I see you said you ran Make a GCI Library from a GCI Definition File
from the GCI Admin menu.
I don't see you saying you ran Install a GCI Library from the GCI
Admin menu.
Quote:
This option does the following:
- Copies the DLL file from the gcidir directory to the bin directory in
the UV account directory
- Adds the name of the copied file to the GCI library list held in the
Windows Registry
The DLL is now ready for use.
Note it also states you can use the UVGCIDLLS variable to test your DLL,
before committing to updating your UV GCI configuration. Probably a wise
thing to do in a production or live environment! :)
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Friday, 7 November 2008 1:41 PM
To: u2-users@listserver.u2ug.org
Subject: {Blocked Content} RE: [U2] Need help with GCI system
Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the AngelicHost-Attachment-Warning.txt
attachment(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 for TEST in your GCI library. From the GCI documentation:
Hi Davd,
Thanks for the reply.
The library is indeed called test.lib built from test.c/test.obj. In it
is
the function getSum() I am trying to integrate. The GCI definition
file
I've created on UV is called MAGCI. UniVerse creates all the magci.*
items in
the gcidir when I take GCI.ADMIN menu option 5. Make a GCI Library from
a GCI
Definition File.
The way I thought it worked was:
The subroutine visible to UV would be getSum and the external subroutine
name
is the same and the module (.lib) is test because the function is in
test.lib.
What's odd is that the *hello example and it's accompanying BP GCI1
calling
program don't run either. I'm using straight out of the box IBM
examples and
using the default GCI definition file: GCI.
-bob
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment winmail.dat
was believed to be infected by a virus and has been replaced by this
warning
message.
If you wish to receive a copy of the *infected* attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.
At Thu Nov 6 18:40:48 2008 the virus scanner said:
Could not parse Outlook Rich Text attachment
Note to Help Desk: Look on the AngelicHost MailScanner in
/home/virtual/site2/fst/var/spool/mail.quarantine/20081106 (message
mA72ejno008182).
--
Postmaster
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Job Posting
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: u2-users@listserver.u2ug.org Subject: Re: [U2] Job Posting From: David Tod Sigafoos [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 3, 2008 12:36:44 PM Subject: [U2] Job Posting I was asked to pass this on to the group. As a personal note I will say that is it is a very good company to work for. Work environment is very nice and the leadership in IT are very responsive to ideas. DSig Job Posting Interested candidates should submit their resume to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/msword which had a name of GARY08ANALNDBLD1.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Documentation
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 PROTECTED] On Behalf Of Martel, Henry Sent: Thursday, 30 October 2008 1:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Documentation 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. Thanks, Henry. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [u2] UVsql
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, I quick sql question within a UniVerse Unix environment. I know with MS-Sql you can set the primary key to 'autonumber'. I can not find a method to accomplish that for a table within UniVerse. Any suggestions ? Thanks much !! Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] PHP
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 Brutzman, Bill Sent: Friday, 24 October 2008 7:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] PHP Is there a way to do PHP with UniVerse? I just found out that there is a way to do Adobe Flex with PHP. Thus, perhaps it is possible to do Flex - PHP - UV. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and/or AIX caching
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 FC-SSDs can help enterprise users accelerate the legacy applications which they already run now in what I often refer to as the distress purchase. This is the situation where users didn't envisage SSDs in their original thinking at all, but turn to SSD acceleration (often in desperation) to fix application performance problems they're experiencing caused by bottlenecks in their traditional multi OS server / rotating disk array infrastructure. /quote Regards David Hona -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Thursday, 23 October 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse and/or AIX caching I've heard that UniVerse will cache data, or leave data in memory in case the next request needs it. Is there any way to control how much data gets kept in memory, and for how long? If one has 32 gigabytes of memory on an AIX machine, is there any way to tell the operating system (or UniVerse) to load whole (several) files in memory so the data can be accessed instantaneously, or is configuring some memory as a ramdisk the closest one can get to that? -- Louie in Seattle AIX 5.2 UniVerse release 10.2.7 UniVerse syntax: PICK --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and/or AIX caching
Thanks Louis It would probably take hours, but STATS option would be good... Do they really need to be dynamic files? Is the data largely static? Does it grow often? Can you separate non-current data and utilise distributed files perhaps? I'm guessing that the large dynamic files are largely empty space/groups? Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Friday, 24 October 2008 9:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse and/or AIX caching Several files, but these are representative: ANALYZE.FILE ALPHA (reads writes) File name .. ALPHA Pathname ... ALPHA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 545607 current ( minimum 337 ) Large record size .. 1619 bytes Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 1,379,911,680 bytes ANALYZE.FILE BETA (reads writes) File name .. BETA Pathname ... BETA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 233098 current ( minimum 1607 ) Large record size .. 3257 bytes Group size . 4096 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 1,197,477,888 bytes file.stat DELTA (reads only) File name = DELTA File type = 18 Number of groups in file (modulo) = 99013 Separation = 4 Number of records = 460434 Number of physical bytes= 240564224 Number of data bytes= 171851992 Average number of records per group = 4.6502 Average number of bytes per group = 1735.6508 Minimum number of records in a group= 2 Maximum number of records in a group= 6 Average number of bytes per record = 373.2391 Minimum number of bytes in a record = 176 Maximum number of bytes in a record = 2304 Average number of fields per record = 109.8444 Minimum number of fields per record = 108 Maximum number of fields per record = 231 Groups 25% 50% 75%100%125%150%175%200% full 01948 28741 49890 170831315 33 3 FILE.STAT ECHO (reads only) File name = ECHO File type = 18 Number of groups in file (modulo) = 16453 Separation = 4 Number of records = 55176 Number of physical bytes= 42856448 Number of data bytes= 28404000 Average number of records per group = 3.3536 Average number of bytes per group = 1726.3721 Minimum number of records in a group= 1 Maximum number of records in a group= 5 Average number of bytes per record = 514.7890 Minimum number of bytes in a record = 80 Maximum number of bytes in a record = 6400 Average number of fields per record = 155.9890 Minimum number of fields per record = 47 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 for this UV file? Just curious. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Triggers
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 Triggers You can even write to the VOC if you don't have write permission to the file. Hint: usd runs with superuser privileges. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] running uvrpc at the same time on different ports
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Saturday, 18 October 2008 1:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] running uvrpc at the same time on different ports Hey all, is it possible to run uvrpc (aix 5.2 universe 10.1) on different ports at the same time? Its currently listening on 31438 but datastage is trying to access 31538 and we cannot find any reference in datastage that allows us to specify what port to try connecting on. so what we would like to try it to have uvrpc also listening on port 31538 (obviously as a seperate process), I have tried adding the additional port to /etc/services and may try adding it to inetd.conf am I wasting my time or is it possible to run uvrpc on different ports (at the same time)? thanks dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Triggers
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 remote voc options which can enable you to wrap the tools such that TCL commands cannot be used to bypass them. To get a complete configuration management solution you may need to wrap tools and install triggers - since triggers cannot be use on your DIR type files and TCL commands can be used to move items. [AD] Naturally I will mention that if you'd like a complete solution, ready to go, feel free to contact me to talk about PRC - complete software configuration management / software development life-cycle management for U2. http://sjplus.com Regards, Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Triggers
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 the advantage of having the ability to abort changes that should be done via (say) the line editor, should you code it to check and do so. With a wrap-style command, it has to be installed in all the UV accounts that you wish tracked, requiring the VOC to be updated and to remain unchanged. Of course, the wrapper is also much easier thing to install and configure, so worth considering anyway. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Webster Sent: Monday, 13 October 2008 3:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers Hi Kate, As another suggestion (if only tracking changes by 'ED') why not wrap the 'ED' function and catalog it under a new name? Eg: catalog the below code as 'ED' and re-catalog 'ED' as some ambiguous name. [snipped] Regards, Dave. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Triggers
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, group record-lock contention - the stuff you could possibly get in your environment - you'd probably ok. :) As we don't know your application, your existing system load, existing file types or configuration or what your trigger does...we can only speculate wildly on the impact. :) As others have commented, the overhead can be substantial. So it is a trade-off of functionality your desire versus the actual performance hit. A delicate balance here, that only you can decide through thorough and rigorous testing. The more reading and writing your triggers do - the greater the impact (and the more locks they will hold). Clearly, if your triggers are updating, you do need be very concerned about performance. If you have no updating, there is less to worry about. However, just reading records can also set database record locks, as well. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa Sent: Wednesday, 8 October 2008 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Triggers We are getting ready to implement triggers on a universe system running under Windows Server 2003. I created a trigger and tested it out and it appears to do exactly what we need. My question is are there any gotchas or issues we should be concerned about with triggers? Are there any performance issues that anyone has seen related to triggers? Thanks, Mike Roosa --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] EQUATEs Using System Delmiiters
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 Subject: [U2][UV] EQUATEs Using System Delmiiters I'm trying to use EQUates to setup static arrays in a BASIC program but am getting strange results. The UniVerse BASIC manual says you can use any valid BASIC expression as an object to the symbol. However when I try to create an array with... EQU MX TO 'ABCD': @AM: 'EFGH' ... I get strange results. Consider the following code... What am I missing here? Thanks. Perry Taylor Zirmed, Inc. UniVerse 10.1.21/RHEL3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [Uv 10.2] Connection Pooling Working?
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 via app.config or via yourapp.exe.config file: ?xml version=1.0 encoding=utf-8 ? configuration !-- UO.NET General addkey=SocketTimeOut value=30 / /General ConnectionPooling addkey=ConnectionPoolingOn value=1 / addkey=MinimumPoolSize value=1 / addkey=MaximumPoolSize value=16 / addkey=IdleRemoveThreshold value=1 / addkey=IdleRemoveExecInterval value=6 / /ConnectionPooling PerformanceMonitor addkey=BusyConnectionCounter value=0/ /PerformanceMonitor /UO.NET -- system.diagnostics switches !-- Set value property of the TraceMethods switch to one of the following: 0 (false) or 1 (true) -- add name=UniBooleanSwitch value=1 / !-- Set value property of the Arithmetic switch to one of the following: 1(error), 2(warning), 3(info), 4(verbose) -- add name=UniTraceSwitch value=3 / /switches trace autoflush=true indentsize=4 listeners !-- add name=UniListener type=System.Diagnostics.TextWriterTraceListener, UODOTNET version=1.0.* Culture=neutral initializeData=c:\myListener.log / -- !-- add name=myListener type=System.Diagnostics.TextWriterTraceListener initializeData=c:\temp\myListener.log / -- add name=myListener type=System.Diagnostics.TextWriterTraceListener initializeData=c:\temp\myListener.log / /listeners /trace /system.diagnostics /configuration If connection pooling is working, on your host you should be able to uvlictool and see it in use: $ uvlictool Device licensing is in effect. No. Pid, Package Device name IP address Device sub-key 0 license seats are in use. 4 license seats are available. Packages in use: CONNPL has 2 processes. PIDs of Connection Pooling daemons holding CONNPL package licenses: 23427 23429 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of charles ferguson Sent: Thursday, 18 September 2008 2:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [Uv 10.2] Connection Pooling Working? Hi David, Yep, I have the license activated on Universe. But I don't think pooling is actually being invoked from .NET. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [Uv 10.2] Connection Pooling Working?
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: u2-users@listserver.u2ug.org Subject: [U2] [Uv 10.2] Connection Pooling Working? Hi all, I'm connecting to a Universe 10.2 db via a C# .NET app using UniObjects. It works fine using a standard user-license and now I'm looking at implementing a connection pool. Problem is, when I use the code from the 10.2 manual: UniObjects.UOPooling = true; I get: 'IBMU2.UODOTNET.UniObjects' does not contain a definition for 'UOPooling' I've tried pasting the UOPooling snipped into the app.config file instead, and this happily builds in .NET but I don't believe it is actually implementing connection pooling. Firstly because when I debug in .NET the value IBMU2.UODOTNET.UniObjects.m_UOPooling = 0 and second, I jacked up the number of standard user sessions to our standard user license limit and got a user licenses exceeded, connection refused exception. If anyone has any ideas I'd love to hear them. PS does anyone know how I can confirm how many connection pool licenses are in use at a given time from the Universe end? Many thanks, Charles --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniVerse COPY command and the UVTEMP directory
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-engineering to work with numerous UV enhancements added to UV v7 (etc)...like SQL SICA, etc., etc. Hence the decision to port COPY.B from PI/open was taken for technical/business reasons. It's a lot slower, but much easier to maintain for the U2 engineers when the do changes to UV. I think the overhead of checking file sizes if both the target and source file is a type 1 and/or 19 and then switch to the native OS copy utility (if feasible). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Bullard Sent: Thursday, 18 September 2008 4:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] uniVerse COPY command and the UVTEMP directory Does the uniVerse COPY command use the UVTEMP directory for workspace? I have a program that is creating a 200MB XML file in the HOLD file. It then transfers (or attempts to transfer) that file to another file using COPY FROM HOLD TO OTHERFILE TMP41904 OVERWRITING. When this command is issued, I get: Program COPYI: pc = 19F8, Available memory exceeded. Unable to continue processing record. Record TMP41904 not found in file HOLD. In investigating, I first went after swap space (BTW...this is on a HP-UX system) but I found that there is almost 2GB available on that file system. In looking at available RAM, top is showing me about 35K free...but I would expect the available swap space would make up for that. The last thing I am lookg at is the fact that the file system where UVTEMP resides has only about 60MB available...far less than the XML file is going to need. I was just looking for confirmation that this could be the problem before I go shutting things down and moving UVTEMP just to find out it was something else. Thanks, John B. - This message and all attachments are intended for the use of the individual or entity to whom or which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this message is not the intended recipient or the agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms Regulations (ITAR) and the Export Administration Regulations (EAR) may be applicable to any technical information submitted with this communication. This technical information is not to be placed in the public domain, exported from the U.S., or given to any foreign person in the U.S., without the prior, specific written authorization of TeligentEMS LLC and the U.S. Department of State or the U.S. Department of Commerce as applicable. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects
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 version. Otherwise, you may not connect or not reliably at least. You manually start UniRPCD from UNIX: (amend for your path to your UV home directory): nohup /usr/ibm/unishared/unirpc/unirpcd Best not to run it on the commnad line and redirect standard input/output/error to a file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Thursday, 14 August 2008 3:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] uniobjects does anyone know if its possible to run the uvrpc deamon (uniobjects) from the command line? It appears that since we cannot find the problem we are going to rewrite our order entry program in .net from vb6, apparently from some initial testing that the .net version fo the program works whereas the vb6 version is still having problems. Also is anyone aware of any ways to see what a deamon (in particular uvrpc) is doing? We have talked to IBM and apparently the best suggestion we got from them was that the issue was being caused by the network card in the systems (which have been the same for years) so I am not even sure where that idea came from. is anyone aware of any differences that would cause code written in .net to work versus code written in vb6 (I assume they are using different dll's anything on the server side)? Also does the uvrpc have different daemons for .net and non .net? thanks everyone dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects help needed!
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 this...you have to ask the obvious question: What has been changed?. This is assuming it all use to work fine before of course. It sounds like nothing has changed. From what you're posted so far. Is that correct? I guess you've confirmed this is not file corrupt issue with the UV files being accessed? It appears your VB application is read/writing directly to UV files directly and this is where you're having issues? Is it corrupting your UV file in the process? You vaguely mention you have rebooted your AIX server. Is that correct? Do you use dynamic files? What version of AIX, UV and UniDK are using? It seems like you've already checked the UniObjects and Unirpcd logs - have you check the UV errlog too? Anything interesting in that? Do you have separate server for testing/development or DR that you can: 1) test this same client software your UV application/UniObjects? 2) restore (using your backups of your DB, source object code + *very importantly* the UV home directory) your production data to and re-test the UniObjects-based app? Objective: determine if the issue is 1) client application is at fault, regardless of the target server it is communicating with or 2) database or application issue (rather than a client one). Other things to try: 1) write a simple UniObjects app (Win32 or Java versions) to read/write to the same file 2) a *completely clean* install the VB6/UniObjects app. This should be a clean PC which has never ever had the client application or UniObjects installed before. If you site has a standard desktop configuration, then you should be using that or perhaps use a PC that is non-standard. Have you rolled a new firewall or VPN client or similar network-invasive type application recently? Objective: 1) determine if it is UniObjects issue or not 2) determine if the problem is desktop PC or not (the latter by using a non-standard build PC). I have seen strange things happen with the U2 API before. So capturing the output from your UniObject sessions is a good one. If you have the code to your VB application - you can get it to turn on a COMO file. Given it a unique name for each session or user-ID (maybe the UNIX process ID too - eg., myuserid-date-PID.como) If your VB code is calling (directly or indirectly or dependent on some initialisation code) host-based BASIC subroutines (or indeed any cataloged referenced program) check if these have changed and re-catalog them all, regardless. I have seen go away after re-cataloging code - both at TCL invocation level and via the APIs. Good luck! Regards David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
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 at all...especially after that issue about Dynamic Connect some time back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Tuesday, July 29, 2008 6:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Data Editor Wintegrate has an excellent visual editor - it auto saves to your hard disk as well, and will work offline, and then you can resave when you re connect. All in allan excellent telnet client, gui generator, editor etc etc Or for free use the unidebugger bundled on your clients cd - this is an excellent tool and I dont understand why everyone does not use it at least some of the time. Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv] Secure Sockets / SSL
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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: Wednesday, 23 July 2008 12:53 PM To: u2-users Subject: [U2] [uv] Secure Sockets / SSL I'm trying to write some software to send e-mail to a mail server. I would like to encrypt the connection using SSL or TLS. Could someone point me in the direction of documentation or example code that I could look at to get started with this. It's all very new to me, and I'm not getting anywhere with the Universe documentation. For example, where do I start? I know that my Exchange server supports TLS encryption, and that when I connect, the traffic is unencrypted until I issue the STARTTLS command. Can I switch from an unencrypted connection to an encrypted connection on the fly? TIA C. Michael Pflugfelder | Systems Manager | Keystone Information Systems, Inc. | 856-722-0700 | [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Strange SQL query optimisation ...
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 helpful, along some sort of explanation of what your objective of each query is...along a brief description of the columns/fields and their relationship(s) to the tables being joined...if possible. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Monday, 21 July 2008 7:49 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Strange SQL query optimisation ... Thanks. If I add the no.optimize keyword, it changes all joins to an outer cartesian join. So that's even worse ... (I haven't tried actually running it :-) If a LEFT JOIN and LEFT OUTER JOIN are the same thing, that adds another little oddity to the mix :-) Why is the optimiser using both terminologies when the input uses just one? :-) Not that that's important unless it gives IBM's engineers a clue ... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question about Uniobject and session encryption
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 encryption Hi all. I am having trouble using session encryption in Uniobject and I hope someone can help me out on this issue. According to the UniObjects for .NET Developer#8217;s Guide, Uniboject allows encryption applied to its UniSession object. On page 3-34, I see two properties of UniSession explained: EncryptionEnabled and EncryptionType. If I create a simple VB.Net program such as the following Dim uvSession As UniSession Dim uvFile As UniFile uvSession = UniObjects.OpenSession(server, login, password, account, uvcs) uvFile = uvSession.CreateUniFile(some_file_on_server) I can successfully create a UniFile object to access a file on a remote server. However, if I added the following lines after the UniSession obejct is created: uvSession.EncryptionEnabled = True uvSession.EncryptionType = 1 I would get the following error message when creating a UniFile object. [IBM U2][UODOTNET - UNIRPC][ErrorCode=81004] An argument was requested from the RPC that was of an invalid type Does anyknow what I am doing wrong here? Any information would be greatly appreciated. Thank you. Jason --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Extra Form Feed from .prn File Followed by Text
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 Help! Im trying to print a form created from Word combined with text. This method has always worked when creating prn files using a PCL5/5e driver, removing the standard escape sequences that trigger form feeds, and then sending the trimmed file in RAW format to an HP printer running either PCL5 or 6. Its worked fine until now. A new customer has Windows Server 2003 x64, an HP P1505n Laser Jet and the prn files were created with XP Pro drivers. Now every time we attempt to print, the form comes out on one page and the text on the next page. If we build the prn files for an older HP model (say Laser Jet 1300 PCL5e) we get a single page, but the text and portions of the form are garbled. Ive contacted HP and their suggestion was to use Laser Jet 6L drivers. The print jobs still generated the extra form feed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects - read .rtf doc from UV server
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 the server again can be an issue for some applications/networks. Also, some consideration about multiple users updating it simultaneously - potentially - needs to be considered, if you wish to avoid file corrupt. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Gouws Sent: Monday, July 07, 2008 6:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects - read .rtf doc from UV server Hi All, How would one read a .rtf doc from the UniVerse server via UniObjects? As well as write it back to the server? Any directions will help Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
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 Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects.NET: populating ListBox from XML
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 ListBox from XML 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 = COMPANY .ValueMember = CUSTOMER End With Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 14, 2008 9:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects.NET: populating ListBox from XML Having been successful last week at populating a GridDataView control using .GenerateXML, we naively thought using XML to populate a ListBox would be just as straightforward. Using the same code pattern, we've tried Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS ListBox1.DisplayMember = CUSTOMER ListBox1.Refresh() gives us one line in the ListBox that reads System.Data.DataViewManagerListItemTypeDescriptor Are we missing something from this incantation, or is this not a valid way to try to populate a ListBox? (Yeah, I guess ComboBoxes are next.) Thanks in advance for any help, examples, or RTM references! Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup Question
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 use a third-party utility and invoke the TCL command SUSPEND.FILES ON to pause updates whilst you do an online backup. Or break your disk mirror, back that up instead. Other options to look at are UV Data Replication to backup system with UV installed/licensed to mirror your production environment. Not a cheap option in most cases. Whatever you use, you need to ensure that absolutely no updates are happening to any of the UniVerse files. And of course you're using a backup utility which can backup open files on the operating system you're hosting on. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chandrika Padaki Sent: Tuesday, May 13, 2008 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] Backup Question Our company has a Universe System. We are trying to automate the backup process without bringing the system down every night. Is there an Online Backup Utility available? If so what is it and do any of you have a sample script I could look at? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects.NET: populating ListBox from XML
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 = COMPANY .ValueMember = CUSTOMER End With Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 14, 2008 9:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects.NET: populating ListBox from XML Having been successful last week at populating a GridDataView control using .GenerateXML, we naively thought using XML to populate a ListBox would be just as straightforward. Using the same code pattern, we've tried Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS ListBox1.DisplayMember = CUSTOMER ListBox1.Refresh() gives us one line in the ListBox that reads System.Data.DataViewManagerListItemTypeDescriptor Are we missing something from this incantation, or is this not a valid way to try to populate a ListBox? (Yeah, I guess ComboBoxes are next.) Thanks in advance for any help, examples, or RTM references! Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects.NET: .GenerateXML method fails
Hi Clif I think I was confusing UniXML with U2 Web Services Developer, which is mentioned in 'newfeatures.pdf' for UV 10.2. This states for U2WSD, that UV 10.1.18 (or greater) is required. But I stumbled upon the fact UniXML works on this release (10.1.18), but not lower ones. I can't find any references in 'newfeatures.pdf' to the use of UniXML functionality. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 5:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniObjects.NET: .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 until UV 10.2.x (on the server). I could However, I have got it working at UniVerse 10.1.18 on Sun Solaris. But earlier versions of UV 10.1.x do not work with UniXML calls. This is the same U2 Webservices Developer Tool (and some other toolsets as well). I believe this may be mentioned in the UniVerse 'newfeatures.pdf' for UV 10.2 documentation set. Regards David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexes have disappeared
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] On Behalf Of Louie Bergsagel Sent: Wednesday, 23 April 2008 8:13 AM To: U2 Subject: [U2] Indexes have disappeared We use flashcopy to move data from one computer to another, and recently noticed that UniVerse is no longer recognizing the indexes even though they are copied along with the files. We recently upgraded to UniVerse 10.2.7 (Pick syntax) Has anybody heard of this weirdness? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexes have disappeared
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 Louie Bergsagel Sent: Wednesday, April 23, 2008 10:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexes have disappeared No, but how could it have worked before? If a SET.INDEX was required, wouldn't it have to be executed after every copy? We've never done that. On Tue, Apr 22, 2008 at 4:32 PM, Wally Terhune [EMAIL PROTECTED] wrote: Identical file system path to the files and indexes? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uo.net logging
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 addkey=SocketTimeOut value=30 / /General PerformanceMonitor addkey=BusyConnectionCounter value=0/ /PerformanceMonitor /UO.NET -- system.diagnostics switches !-- Set value property of the TraceMethods switch to one of the following: 0 (false) or 1 (true) -- add name=UniBooleanSwitch value=1 / !-- Set value property of the Arithmetic switch to one of the following: 1(error), 2(warning), 3(info), 4(verbose) -- add name=UniTraceSwitch value=3 / /switches trace autoflush=true indentsize=4 listeners !-- add name=UniListener type=System.Diagnostics.TextWriterTraceListener, UODOTNET version=1.0.* Culture=neutral initializeData=c:\myListener.log / -- !-- add name=myListener type=System.Diagnostics.TextWriterTraceListener initializeData=c:\temp\myListener.log / -- add name=myListener type=System.Diagnostics.TextWriterTraceListener initializeData=c:\temp\myListener.log / /listeners /trace /system.diagnostics /configuration David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Wednesday, April 16, 2008 5:30 PM To: u2-users@listserver.u2ug.org Subject: [U2] uo.net logging Can someone remind me what entries to put in the web.config for an asp.net app that uses uo.net to write the uo.net trace file b I know it was something to do with trace and listeners but can not find my old example anywhere b. Thanks Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL Command stacker
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 to overide that (if you can). Also best NOT to use ALL option if you have you own keyboard input handling program. As it will trap all control characters itself. It also conflicts with !EDIT.INPUT subroutine and INPUT @(x,y) functions (ie. It will crash and probably drop you to the OS prompt). COMMAND.EDITOR [ON|OFF] [ALL] [TCL prompt string] ALL = (optional) Input editing on all input prompts (including BASIC programs, etc). TCL Prompt = (optional) - define alternative TCL prompt Example: COMMAND.EDITOR ON [EMAIL PROTECTED] COMMAND.EDITOR ON [EMAIL PROTECTED] If using DEC VT emulation, you can use the cursor keys to edit the command-line and scroll-up and down the TCL stack (using PAGE UP and PAGE DOWN keys - depending on your keyboard emulation key settings). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, 17 April 2008 7:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] TCL Command stacker Before you propose to a customer, make sure their terminal emulator and COMMAND.EDITOR play well together. I guess there are some tricks to smooth out things between AT2k and COMMAND.EDITOR. I put COMMAND.EDITOR ON ALL in my login PA and that was the end of my cursor keys and num pad. fwiw -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Miller Sent: Wednesday, April 16, 2008 2:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker Yes, thanks all. This looks promising. -Doug --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL Command stacker
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: Wednesday, 16 April 2008 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] TCL Command stacker Is anyone aware of any software that controls the command stack at TCL? I am sure there are versions people have written before and I have not encountered any myself yet in my searches. We have a site who is interested in migrating from one database that allows use of arrow functions to edit the command stack to a more traditional environment that use the typical . commands. IE .L .C .X etc. They would prefer to continue to use just the arrow keys. Much like Linux allows you to control the OS command stack. Thank you, Doug Miller --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Maximum size of the record lock table
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: Wednesday, April 16, 2008 5:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] Maximum size of the record lock table Hi All, We had some excitement today when we ran a program with READU, with the associated WRITE commented out. In no time at all (these RS6000s are fast!), the system froze. I had a login and some UniVerse commands worked, but others did not. LIST.READU showed one user with thousands of locks and that is how we identified the program. Can someone tell me what the maximum of locks allowed is, or what the size of the lock table is? We don't want to increase it (nor do we want to put a count in and unleash the program a second time!). Thanks Steve Steve Ferries (416) 774 4250 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Files Open
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 output to your own UNIX files though. See http://www.netadmintools.com/html/lsof.man.html and http://sial.org/howto/debug/unix/lsof/ Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Wednesday, April 16, 2008 8:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Files Open I'm sorry, I meant within the process running. E.g. stack=system(9001) files.open=somesystemfunction() Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, April 15, 2008 4:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Files Open PORT.STATUS PID MFILE.HIST from the uv account. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, April 15, 2008 1:18 PM To: u2-users@listserver.u2ug.org Subject: [U2] Files Open Hello, is there a system command or function that can show the open files for the running process similar to a stack in system(9001)? I'm running Universe 10.1.12/SunOS 5.9 Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Difference between Universe and Unidata
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 has: - UV/SQL is embedded into the database engine, not merely tacked on (just to add to what Brian mentions). - UV/Net for transparent file/table access to/from remote UV servers. Some consider it better (more integrated, transparent,etc) than UD's NFA. - Distributed file/table support. Related physical files, either local or remote, can be logically joined as a 'distributed file' - UV's transaction logging supports nested transactions- UV is considered somewhat easier to port an application or databases from PICK-like environments, than UD. UniData has: - UD can support multiple 'instances' or versions of UD on the same server. Whereas you can only have one instance or version of UV installed per server. - better a 'global catalog' / shared memory management for cataloged programs than UV's implementation - currently External Data Access (EDA) is available only on Unidata, but is due to be supported on UniVerse soon. This allow read/write access to third-party databases from your BASIC application, as if it was a native hashed-file. IBM's U2 product web pages do a somewhat lacklustre job of explaining these and other differences. APT Solutions (the UK Master Distributor for IBM U2) website does a better of highlighting them, but doesn't do a feature-by-feature comparison... http://www.u2uk.com/universe.asp http://www.u2uk.com/unidata.asp The probably the biggest thing UD has going for it - the engineering team came from UniData, all the UV guys stayed with the DataStage product (now ironically owned by IBM too). Although, IBM does not give UD any preference at the expense of UV. Although...why do any the developerWorks sample seem to be coded for UD (first)!! :-) Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Monday, April 14, 2008 4:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Difference between Universe and Unidata Well I couldn't resist. First, I support products on both databases. Both have broadly the same core multivalue features, though with different approaches to syntactic variances: UniVerse accounts are set up with specific 'flavors' (emulations) whereas UniData uses a combination of a run-time ECL type and option settings. UniVerse supports a wider range of dictionary types. UniData handles sub-values better. UniVerse has nicer Basic syntax, though UniData is catching up. UniVerse has far better support for SQL and offers NLS support. Moreover most of the interfaces used today began life on UniVerse. Until recently UniVerse had better memory handling, fewer arbitary restrictions and was more developer-friendly. It has a wider variety of file types and in general terms historically you have been able to do more with it. UniData by contrast is more keyed to the 'pure' database functionality: it has better recovery features and high availability. It probably has better indexing, and may be a better choice for applications that do large numbers of small transactions. Sometimes the huge flexibility you have with UniVerse can be a double-edged sword: the enquiry language in particular can be 'helpful' to the point of giving sensible looking information even when you screw up. UniData is more pedantic in its syntax, which may just be a good thing! To sum it up: As a developer I prefer UniVerse and develop all my UniData stuff on UniVerse platform, BUT if I were a DBA I would probably think different. Over the years the two products have become ever closer. Most of the middleware has been ported across, and the extension APIs for things like socket handling are mirrorred on both systems. And I'd still rather use each of them than the alternatives. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] problem with UniVerse SQL Users on windows (Domain name is now case sensitive)
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 application bothers to force/translate the user-ID always to uppercase -- it's going to be an on-going issue. I guess to multiplatform applications, they need to make an exception for UNIX, as it allows mixed case user-IDs (I've yet to ever see one though!). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Saturday, 5 April 2008 12:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] problem with UniVerse SQL Users on windows (Domain name is now case sensitive) Hi Ken 1. I did install as the same user 2. You are right that the domain name is case insensitive in windows, however it appears UniVerse is case sensitive when check against UV_USERS for valid SQL Users. 3. Security of the directories are OK. I eventually uninstalled UniVerse and reinstalled. Now in UV_USERS all domain names are in uppercase and it recognises SQL users. Problem: IBM is making domain name case sensitive and this will effect anyone upgrading where domain names are in lowercase in SQL_USERS. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Mobile: 0428 669 730 Phone: 61 2 9418 8329 Fax: 61 2 9427 2371 PO Box 909 Lane Cove NSW 2066 Australia www.dacono.com.au CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify Dacono by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email which may contain intellectual property or copyright irrespective whether you are or are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of Dacono. Dacono does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. Dacono does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occur directly or indirectly from the use of this email. -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ken Hall Sent: Saturday, 5 April 2008 10:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] problem with UniVerse SQL Users on windows Hi David - Did you do the upgrade with a different user that the original install? If so, uninstall UniVerse and re-install it. It should leave all your user stuff alone, and after the new install, instead of an upgrade, things should be fine. You should however, logon to each account as the administrator who did the install to auto run UPDATE.ACCOUNT. Also, the domain name is case insensitive in Windows authorization. Also, it may be a permissions issue after the update. I have had this type of problem with a Unix update. Check all the permissions on the UniVerse files, especially in the .uvhome/uv/bin directory. Hope this helps. Ken At 03:28 PM 4/4/2008, you wrote: Hi Ken With windows the installer was the default SQL Account, which is usually the administrator. It is in updating to the new release that has changed the way things have been done. My actual issue is that UniVerse no longer recognises current SQL users, the only thing I can see is that the domain name is in a different case to that which is stored on UV_USERS in the SQL Catalog. The second issue, is that it does recognise current SQL users, I have no SQL DBA access to UniVerse to resolve issues. Hence locked out. Regards David Jordan Managing Consultant David - Install instructions for UV on Unix states that you need a uvsql user for this purpose which needs to be setup prior to the installation. Have you checked the Windows installation instructions in the UV docs. You might not have setup the default user prior to the installation. Ken At 01:00 PM 4/4/2008, you wrote: Hi Ken The user NT AUTHORITY\System is an internal windows user name. It is part of the internals of windows and adding a password to it could cause all sorts of things to stop working. It is not a login name, hence I am not sure why it is now being used as the default SQL DBA in universe on windows. Regards David Jordan --- u2-users mailing
RE: [U2] error question
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 PROTECTED] On Behalf Of Doug Chanco Sent: Friday, April 04, 2008 12:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] error question Hey all, I am pretty sure this is a out of memory/stack space type error but I was hoping someone could tell me where I can find the fault types and if there is a way to use the address that the error returned to get where the code was when it blew up? below is the error Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program FREE.LOC at address 4c4 Thanks all dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] base64 under Universe 10.2.4/AIX 5.3
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 tool is due soon for U2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 8:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] base64 under Universe 10.2.4/AIX 5.3 I'm trying to convert a standard Pick data string into base64 format. I don't need to encrypt, just convert to base64 to take off the 'edges'. Googling has found references to a new universe basic command, ENCODE, but my current manuals, pdf version 10.2, dated September 2006 don't list the command. And HELP BASIC ENCODE don't do me any good. BTW Support.HELP BASIC ENCRYPT doesn't work either. Thanks for any help. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}
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: u2-users@listserver.u2ug.org
Subject: RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}
Roger,
It has in fact been expertly concealed in the PDF manuals, although of
course not in the table of contents, although if you look in the right
place they are in some but by no means all of the INDEXes.
The Adobe Reader 'Search' function will, however find the ENCODE
function for you.
:-(
Look in the Basic Extensions manual under the obvious chapter heading
Using SSL with the CallHTTP and Socket Interface there is Encoding
and Cryptographic Functions pages 3-46ff Or Universe Basic Reference
(that's the one in 'BasicRef.pdf', not the one in 'Basic.pdf' and before
you ask, no, I've no idea either) on page
251 of the 10.1 version.
A triumph of the documenter's art this is NOT
Probably worth a quick troll through the APP.PROGS and BP files in the
UV Account for some examples, you may get lucky
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV SOAP into Tomcat
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 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:77 )01 Start DMMS Dev(UniSOAP 1.0) 2008 Mar 28 13:45:54 EST DEBUG [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:80 )01 DEBUG ON 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:81 )01 DMMS Dev Debug=true 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:95 )01 Starting non-secure server... port=8181 2008 Mar 28 13:45:54 EST DEBUG [main]org.mortbay.http.HttpServer.addComponent(HttpServer.java:1247)03 add component: [EMAIL PROTECTED]:8181 2008 Mar 28 13:45:54 EST DEBUG [main]org.mortbay.http.HttpServer.addComponent(HttpServer.java:1247)03 add component: HttpContext[/] 2008 Mar 28 13:45:54 EST DEBUG [main]org.mortbay.http.HttpServer.addMapping(HttpServer.java:519)04 Added HttpContext[/] for host * 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:14 4)01 DMMS Dev maxCPPoolSize=10 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:14 6)01 DMMS Dev minCPPoolSize=1 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServer.main(UniSOAPServer.java:15 4)01 DMMS Dev services cache size=0 2008 Mar 28 13:45:54 EST EVENT [main]org.mortbay.http.HttpServer.start(HttpServer.java:640)02 Starting Jetty/4.2.x 2008 Mar 28 13:45:54 EST DEBUG [main]org.mortbay.http.HttpContext.initClassLoader(HttpContext.java:1377 )04 Init classloader from null, [EMAIL PROTECTED] for HttpContext[/] 2008 Mar 28 13:45:54 EST DEBUG [main]org.mortbay.http.handler.AbstractHttpHandler.start(AbstractHttpHan dler.java:79)06 Started com.ibm.u2.unisoap.server.UniSOAPHandler in HttpContext[/] 2008 Mar 28 13:45:54 EST EVENT [main]org.mortbay.http.HttpContext.start(HttpContext.java:1901)03 Started HttpContext[/] 2008 Mar 28 13:45:54 EST EVENT [main]org.mortbay.http.SocketListener.start(SocketListener.java:176)03 Started SocketListener on 0.0.0.0:8181 2008 Mar 28 13:45:54 EST EVENT [main]org.mortbay.http.HttpServer.start(HttpServer.java:676)02 Started [EMAIL PROTECTED] 2008 Mar 28 13:45:54 EST EVENT [main]com.ibm.u2.unisoap.server.UniSOAPServerMonitor.init(UniSOAPServe rMonitor.java:57)03 The monitor for DMMS Dev started -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Friday, March 28, 2008 3:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV SOAP into Tomcat Hi David, does that mean -- you can't run uniSoap in tomcat as it is built for jetty? or merged with jetty? or embeds jetty? I thought jetty/tomcat were alternatives and was hoping that if you could run X in jetty you could run it tomcat ... the jetty web page says it can be both container and component? thanks, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV SOAP into Tomcat
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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Friday, March 28, 2008 5:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV SOAP into Tomcat 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. Thanks David, I'll share the good news. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV SOAP into Tomcat
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 Jetty is designed to be 'lean' in terms of the resource footprint, whereas Tomcat is not optimised with that in mind. (check out org.mortbay.http.*) I'm not sure if this helps! Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Friday, March 28, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV SOAP into Tomcat Hi All, I know this has been asked before and I have tried reading the responses in the archives but I think I'm missing a step somewhere. The new UniSoap server can be run from a command line on any platform with java -- thats just a matter of classpaths and config files. Thats fine -- we copy the bits we need from Windows to AIX and away we go. BUT my customer is wary of just having this java executable running to service all their SOAP requests and would prefer to do it through tomcat so that there is an administration interface etc. Does anyone know if we can run the UniSoap server inside tomcat? I think I'm asking if it can be a servlet but my tomcat knowledge is hazy. thanks, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Type ahead buffer overflow
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 in a cut 'n' paste operation! :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Tuesday, 26 February 2008 7:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Type ahead buffer overflow Can't you simply paste into a text file in a type 1 directory, and then read and process the input? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 25 February 2008 07:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Type ahead buffer overflow Or something like that. We have a client that uses a paste from Windows into an input statement, within a UniBasic program, to enter data. The string get quite large and in the transmission from VMS to Unix AIX 5.2 running UniData 7.10 we are losing data. We have played with the terminal emulator as much as possible, but we still lose data coming from Windows into UniData. We have set the sty to utilize xon/xoff, but still we lose data. Is there a way to increase the type ahead buffer so we won't overrun it. The data string could contain multiple pages. Or does anyone have a solution other then changing terminal emulators, that is out of the question at this installation. Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Websphere MQ
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 up and going...it works quite well and reliably though. BTW...Craig: Does the C.R.O.S.S. MQ Interface product (UniVerse edition) still exist? Or is no longer available? Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Wednesday, February 27, 2008 9:33 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] - Websphere MQ The current interface works but is frustrating as the environment setup is difficult to track down. The AMI (which are the libraries U2 use to access MQ) is now deprecated so AMI configuration info is hard to find. Also there is no support for MQ transactions in the BASIC API -- so once you get a message, make sure you don't abort :). IBM have been promising a better interface for ages using the MQI or similar. David Hona supplied me with the following information which was invaluable in getting the thing to work: Before we execute the BASIC application with the U2AMI calls, we defined what AMI respository we want to use and then setup the optional AM_TRACE variables (unset them to remove). The logs can be very details (esp. level 9), so they need to be turned off. This on Sun Solaris environment...UV 10.1.18: SETMQENV 001 PA 002 ENV AMT_REPOSITORY=dmms_amt.xml 003 env AMT_HOST=amthost.xml 004 ENV AMT_TRACE_PATH=/DMMSDEV/DAVID/LIVE/HOLD 005 ENV AMT_TRACE_LEVEL=9 006 ENV AMT_TRACE=yes 007 ENV AMT_DATA_PATH=/DMMSDEV/DAVID/LIVE In the above example, log files named AMTn.TRC are written out to /DMMSDEV/DAVID/LIVE/HOLD. Unset AMT_TRACE to toggle tracing on/off. More details on AMI tracing, etc are in this IBM document: ftp://ftp.software.ibm.com/software/ts/mqseries/library/books/amtyak04.p df I am uncertain if this has anything to do with your issue...but I did notice the following in the U2AMI.H include file in UNIVERSE.INCLUDE: ---snip--- ** ** * ** Wait time constant for use with: * **amPolGetWaitTime * **amPolSetWaitTime * ** * ** EQUATE AMWT_UNLIMITED TO -1 ---snip--- According to the AMI documentation amPolGetWaitTime - Returns the wait time (in ms) set for this policy. amPolSetWaitTime - Sets the wait time for any receive function using HTH, Craig this policy. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change Prompt
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 shipped with UV for a specific client to port from PI/open to UV...according to an IBM U2 Powerpoint presentation I've seen about it. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson (DSLWN) Sent: Monday, February 18, 2008 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE:[U2] Change Prompt In Universe, the following program (called PATH) will do this. To use it, just put PATH in the LOGIN command. PATH CLEAR puts things back to how they were. PATH FULL gives the full path name at the input prompt. == PATH program v SENTENCE = UPCASE(@SENTENCE) THIS = '' ; THAT = 1 BEGIN CASE CASE INDEX(SENTENCE,'CLEAR',1) ; THAT = 0 CASE INDEX(SENTENCE,'FULL',1) ; THIS = @PATH:'' CASE 1 ; THIS = FIELD(@PATH,'/',DCOUNT(@PATH,'/')):'' END CASE IF THIS NE '' THEN THIS2 = THIS1:'' THIS3 = '+' END ASSIGN THIS TO SYSTEM(4002) ASSIGN THAT TO SYSTEM(4001) == PATH program ^ This version is for a UNIX system, you may have to change the '/' to '\' on Windows SYSTEM(91) = 0 on UNIX SYSTEM(91) = 1 on Windows Regards, Keith P.S. A great benefit of this is that you can then edit the command stack using the arrow keys. You have to use backspace to delete, though. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Named commons
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 source code supplied in http://www.ietf.org/rfc/rfc4122.txt. Not exactly a trivia task. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, February 14, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Named commons You can create a VOC entry to run from an execute within a transaction. Put an 'H' code in att4 to allow it to be called during a transaction... SBTESTCT VOC UUIDGEN UUIDGEN 0001 Verb to call aix uuid generator 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM -Original Message- I need to generate UUID's Universe doesn't have a function that does this but Unix has a : uuidgen program I can execute to capture UUID's. The problem is that some of our programs run within a TRANSACTION block and cannot execute Unix shell commands within a TRANSACTION block. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel downloads
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 all before...originated on Prime INFORMATION, now on U2, complete with source code and supplied as is without any warranty. Documentation is here: ftp://ftp.cedarville.edu/download/download721/download.pdf. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Thursday, February 14, 2008 4:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads Comma delimited fields are always a bit of an issue in this case. The correct way to program CSVs is to place quotes around the fields, to account for just this - but then: what if you have quotes in your fields? Tab is usually a safer delimiter for the simple reason that it is rarely stored as such in data files, but Excel does not handle a tab-delimited file quite as well as a CSV file. You can of course use I-descriptors that convert quotes to blanks first, or any other transformation. Thus my original question asking for help and tricks: I know what it takes to get me to where I want to be, but I am looking for the miracle tool that will work for all types of data extractions with minimal data massaging and scripting from me. Thanks, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Wednesday, February 13, 2008 7:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads What if the data fields contain quotes or double-quotes themselves? Does this handle that situation? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UB] Arrow Keys FollowUp
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 very UV specific). Prior releases of it didn't see to actually work (well or at all). :) See an example below - for UniVerse 10.1.x and above only. See warnings about it's use. It has some very handy inline editing features, but alas they're not documented well or clearly enough. Regards, David * Simple example of trapping UP and DOWN keys * David Hona, Feb 2007 $INCLUDE UNIVERSE.INCLUDE GTI.FNKEYS.IH CRT @(-1):!EDIT.INPUT - example usage - :TIMEDATE() CRT CRT * IMPORTANT: READ THIS! * CRT If this example does NOT work, check your emulators UP/DOWN key and ensure: CRT 1) they match *exactly* with the UV terminfo database definition for your term-type CRT 2) your emulator is actually sending the keystrokes to your host CRT 3) Turn off COMMAND.EDITOR, if it is in ALL mode. CRT CRT NOTE: You need to fix these issues first, for this example to work. CRT CRT You can optionally use KEYEDIT to modify the default edit key mappings or CRT use KEYEXIT map function keys to cause !EDIT.INPUT to exit (see UV BASIC manual). CRT PROMPT '' ;* Suppres default prompt Ftable = '' ;* Keytable map of keys to be trapped (returned) * * Set up a dynamic array of Function keys to be trapped and to cause !EDIT.INPUT * to immediately exit. As defined in UNIVERSE.INCLUDE GTI.FNKEYS.IH * TRAP.LIST = FK$UP ;* Cursor Up key TRAP.LIST = @FM:FK$DOWN ;* Cursor Down key CALL !PACK.FNKEYS(TRAP.LIST, Ftable) * * If TextBuffer size is MaxBufferSize: it will get truncated, you can't insert characters without * deleting some first (using BACKSPACE key). * InputOverlayMode = IK$INS ;* + IK$DIS ;* Force INSERT edit mode Row = 15 ;* Row to place cursor Column = 0 ;* Column to place cursor WindowSize = 60 ;* Max characters display for this field TextBuffer = 'This the text to edit. You can change it. If you press a key trapped, the value will NOT change.' MaxBufferSize = 80 ;* Max field size. Truncates if TextBuffer is large. OrigTextBuffer = TextBuffer[1,MaxBufferSize] IF LEN(TextBuffer) GT MaxBufferSize THEN CRT Warning: truncated size of TextBuffer to :MaxBufferSize: chars CursorPos = '' ;* Where to place the cursor, upon entry CALL !EDIT.INPUT(InputOverlayMode, Column, Row, WindowSize, TextBuffer, CursorPos, MaxBufferSize, Ftable, ReturnCode) CRT @(0,20): BEGIN CASE CASE ReturnCode = FK$UP ; PRINTERR User pressed the defined UPCURSOR key CASE ReturnCode = FK$DOWN ; PRINTERR User pressed the defined DOWNCURSOR key END CASE CRT IF TextBuffer NE OrigTextBuffer THEN CRT The TextBuffer did change CRT TextBuffer is now: CRT TextBuffer END ELSE CRT The TextBuffer did NOT change END END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, February 12, 2008 4:28 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UB] Arrow Keys FollowUp A snag with the last go-around was that it did not handle end-users with caps-lock ON. The following code snippet handles this problem. Thanks also to Keith Johnson for his off-list mention of an alternative technique at http://www.pickwiki.com/cgi-bin/wiki.pl?GetKey. I like the code below better since it works right now... --Bill Ctrl.Chars.Seen = false loop AsciiChar = keyin() DecimalChar = seq(AsciiChar) input Ctrl.Char.Present, -1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 SOAP Server for Linux
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 invoke the SOAP server supplied with IBM's U2WSD should you wish to try that. The topic can be viewed via Nabble here: http://www.nabble.com/U2-SOAP-Server-tt14039276.html#a14124580 Given that the Jetty SOAP server (it's open source) is merely a Java application, you should be able to deploy upon any OS which has the required Java Runtime Environment version and the applicable JAR files (for the Jetty HTTP/SOAP server and UniObjects for Java, etc). Of course, along with your SOAP web services you've developed. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Tuesday, 5 February 2008 8:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 SOAP Server for Linux Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. We have looked on the IBM web site but cannot find this software to download. We have the Windows version but want to run this on Linux. Any assistance will be very much appreciated. Sara Burns --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
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 systems, stopping UV isn't an feasible option for daily snapshot backups. Caution needs to be exercised at the target end (for your backup) as well. Especially if you're overwritting existing disk backups which may be in use, etc. Then you will get logical file corruptions, especially if dealing with open dynamic files. Hence, extreme care is need for the backup and restore of dynamic files. Also be aware that UniVerse files with indices need to have 'SET.INDEX' run against them post-restore (if in a complete different path), if you're going to access the backup version (and want to use the correct index AND stop corrupt of your live version if co-located on the same host:)). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, February 05, 2008 8:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer After you issue the dbpause, drop to aix as root and do a few sync commands, thusly: # sync cr # sync cr # sync cr I usually give it a few seconds in between issuing the commands, but when I script it, it's sync; sync; sync, so there's probably no reason to wait in between. This flushes all pending writes to persistent memory (for our purposes, disk). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Does UniVerse work with clusters of Unix machines?
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 now? What version of UniVerse are you using? There are lots to issues to consider in a clustered environment. I manage non-U2 based applications under IBM AIX HACMP and Windows Cluster services. Each address different technical and business requirements. Both address a base requirement of high-availability with very miniminal downtime and automated failover to the alternate cluster nodes in response to either software and/or hardware failure - that is transparent to the end-user, as much as possible. For your IBM AIX environment, you should get familiar with the many HACMP options, see http://publib.boulder.ibm.com/epubs/pdf/c2348618.pdf which is from this webpage: http://publib.boulder.ibm.com/infocenter/clresctr/vxrx/index.jsp?topic=/ com.ibm.cluster.hacmp.doc/hacmpbooks.html also see http://www-03.ibm.com/systems/p/support/techdocs/clusters_aix.html . Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Saturday, 2 February 2008 10:23 AM To: U2 Subject: [U2] Does UniVerse work with clusters of Unix machines? Does UniVerse work with clusters of Unix machines? Such as two or three IBM P650's (System Model: IBM,7038-6M2)? And/or a mixture of operating systems, like Unix on one box and Linux on another (PC)? Louie Bergsagel Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Selection help
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. -Original Message- Try SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Selection help
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: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help David Very close.. just need the uniqueness adding. How about simply: SELECT DISTINCT CODE FROM UNNEST LOOKUP.TABLE ON CODE WHERE @ID = 'XYZ' ORDER BY CODE; Code.. AAA BBB CCC 3 records listed. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe failure - why?
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] Universe failure - why? Can anybody help determine what to do about this error? Hashdata = 490657843 Infohtype32=20, infosplit32=80, infomerge32=50 Infocurmod=80, infofilesp=66D80, infolargerec=651 Infonsplit=80, infobasemod=80 Contact Customer Support Immediately!!! CRITICAL ERROR! Notify the system administrator. Abnormal termination of Universe. Fault type is 10. Layer type is BASIC run machine. Fault occurred in BASIC program APPRISSP at address 121e. .profile[20]: 11947 Memory fault The offending instruction in the program APPRISSP is just a write of a record to a file. How does this make Universe blow up? Any help appreciated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Selection help
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 have a table which contains an MV list of codes. What I want to do is get a unique list of codes in the table for a lookup list... Table XYZ @ID = XYZ LINE = 1]2]3]4]5]6]7... CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB... The list I'd like returned is: AAA]BBB]CCC... The semantic I think I'd like is: SELECT LOOKUP.TABLE XYZ SAVING UNIQUE CODE However, this doesn't work. Is there a simple select statement to do this I'm overlooking? Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] IP address in LISTUSERS command
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 licensing-aware emulator on your desktop PC. Hence, it is probably overriding your actual IP address assigned by the router/firewall on your UD servers' LAN. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, January 11, 2008 11:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] IP address in LISTUSERS command We're allowing external users to access our UD server. When I run a LISTUSERS command I get 46 Demo (0)- LU UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESSTIME DATE 1 3448 197626 support1 phantom pts/1 Console 23:16:33 Dec 15 2007 2 1808 197712 username1 udt pts/2 xx.xx.xx.xx 08:03:41 Jan 10 2008 3 3116 197802 username2 udt pts/3 xx.xx.xx.xx 13:30:28 Jan 10 2008 4496 197678 username3 udt pts/4 xx.xx.xx.xx 07:07:09 Jan 10 2008 5 1136 197739 username4 udt pts/5 xx.xx.xx.xx 13:23:25 Jan 10 2008 6236 197779 username5 udt pts/6 xx.xx.xx.xx 12:37:04 Jan 10 2008 7 1840 197631 support2 udt pts/7 192.168.1.52 14:00:56 Jan 10 2008 8 2232 197629 support3 udt pts/8 xx.xx.xx.xx 13:57:05 Jan 10 2008 17 2492 197625 uobjects udt pts/17 udcs 14:01:36 Jan 10 2008 46 2852 197626 admin1udt pts/46 192.168.1.101 13:16:01 Jan 10 2008 47384 197775 username6 udt pts/47 xx.xx.xx.xx 13:19:42 Jan 10 2008 where xx.xx.xx.xx are different IP addresses. Why are some of the reported IP addresses internal Class C network addresses? The support2 (port 7) and support3 (port 8) users are connecting from the an internal network within the same office behind a cable modem. I'm connecting as admin1 (port 46) from my local office through a network behind my cable modem. 192.168.1.101 is my internal network IP address. I'm confused. Can anyone explain? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [Ad] XLr8 Editor and Web Developer Updates
Does XLR8 use UniObjects for Java as the interface? So whatever UOJ allows...in conjunction with the users' permissions/groups are...for the server - directories, files, etc., etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kendrew Peacey Sent: Friday, January 11, 2008 6:31 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Ad] XLr8 Editor and Web Developer Updates Hi Baker, The short answer is yes. All we do is a write in either UniVerse or UniData, so if the file in question does not have write permission the item will not write. Regards Kendrew On Jan 10, 2008 9:37 AM, Baker Hughes [EMAIL PROTECTED] wrote: I had a similar thought, I don't want the XLr8 Editor writing directly to the primary source repository. Will it respect the Unix permissions on an item in that Dir? Thanks. Have a great day, -Baker Hughes x3598 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] anyone seen this error before?
cron is an OS background job processor scheduler and is not supported
by IBM U2 Support.
PHANTOM verb is a background job processor and is part of IBM U2 and is
supported, but of course with no scheduling.
Depends on what you are trying to achieve, I guess. One you're going to
get support for from the vendor, the other you use at your own risk.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of doug chanco
Sent: Friday, December 21, 2007 2:55 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] anyone seen this error before?
thanks! but I am curious is this a better solution than just using
PHANTOM in the shell script?
dougc
Hona, David S wrote:
Here is Dave Church's solution/workaround to address the long
outstanding UV cron issue, it's a little C program...
-Original Message-
From: Hona, David S
Sent: Thursday, January 19, 2006 9:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] [UV] Calling Universe from CRON
I believe that issue is still there...haven't check lately...
Dave Church wrote posted this C code on Info-Ardent and in
comp.databases.pick to solve the problem...
/* This c routine can be used to start universe processes
in cron or at. Normally only one process can run at a
time because they use the same printer memory segment.
simply replace the 'uv' command with 'uvcron' for example:
uvcron 'BATCH-REPORT1' dave.mail */ #define UCB 0 /* set to 0
for System V or 1 for Berkeley */ main (argc, argv, envp) int argc;
char *argv[], *envp[]; { #if UCB
(void)setpgrp(0,getpid());
#else
(void)setpgrp();
#endif
/* CHANGE PATH TO MATCH YOUR INSTALLATION */
(void)execve(/u1/uv/bin/uv,argv,envp);
/* We should never come back here */
printf(exec failed \n);
exit(-1);
}
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] anyone seen this error before?
Here is Dave Church's solution/workaround to address the long
outstanding UV cron issue, it's a little C program...
-Original Message-
From: Hona, David S
Sent: Thursday, January 19, 2006 9:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] [UV] Calling Universe from CRON
I believe that issue is still there...haven't check lately...
Dave Church wrote posted this C code on Info-Ardent and in
comp.databases.pick to solve the problem...
/* This c routine can be used to start universe processes
in cron or at. Normally only one process can run at a
time because they use the same printer memory segment.
simply replace the 'uv' command with 'uvcron' for example:
uvcron 'BATCH-REPORT1' dave.mail */ #define UCB 0 /* set to 0 for
System V or 1 for Berkeley */ main (argc, argv, envp) int argc; char
*argv[], *envp[]; { #if UCB
(void)setpgrp(0,getpid());
#else
(void)setpgrp();
#endif
/* CHANGE PATH TO MATCH YOUR INSTALLATION */
(void)execve(/u1/uv/bin/uv,argv,envp);
/* We should never come back here */
printf(exec failed \n);
exit(-1);
}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver
Sent: Tuesday, December 18, 2007 3:20 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] anyone seen this error before?
Because that id is used to determine the id of the printer memory
segment for the process. If you have two UV processes with the same
gpid, they end up sharing the memory segment. This is where your MFILE
structures are stored (rotating file pool), among other things.
Pointers get mixed up, and you end up getting some files data written
into a completely different file, usually corrupting the group or even
the file header, depending on how angry the computer gods are that day.
--
Regards,
Clif
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MQ Series API
Yes, we found out a while back that AMI Supportpac was still supported WSMQv6, but our upgrade plans where put on hold. We'll be trying to upgrade soon...fingers crossed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, December 13, 2007 6:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] MQ Series API All, I replied to Brian separately, so for any on the list who might also want to know: From IBM support: AMI is not supplied as part of WebSphere. MQ Version 6.0. If you have previously used AMI in WebSphere MQ Version 5.3.1, you can continue to use it by including the Version 5.3.1 SCSQLOAD file in your STEPLIB concatenation, as shown below: //STEPLIB DD DISP=SHR,DSN=PP.MQM.V600.SCSQANLE V6 Messages // DD DISP=SHR,DSN=PP.MQM.V600.SCSQAUTH V6 API MODULES // DD DISP=SHR,DSN=PP.MQM.V531.SCSQLOAD AMI CODE If you have removed WebSphere MQ Version 5.3.1 but need AMI functionality, you can install the AMI SupportPac MA0F http://www-1.ibm.com/support/docview.wss?rs=171context=SSFKSJcontext= SSWHKBq1=ma0fuid=swg24000641loc=en_UScs=utf-8lang=en. Brian Leach wrote: All According to the docs, the Websphere MQ Series API in UniVerse uses the Application Messaging Interface (AMI). But, that isn't supported in the latest version of Websphere MQ. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sigh phantom ?
Doug I guess you're talking about U2 Internals type knowledge - what's hidden under the covers, behind those fancy GUI interfaces? The kinda stuff you can automate and interface your application to make it 'smart' - especially for monitoring or reporting-type stuff? Just ask and someone will tell you what you need to know...lots of knowledge here. I'm sure someone will recommend the UniVerse Internals class from IBM. :) Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Thursday, December 13, 2007 8:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] sigh phantom ? Thanks to everyone who replied! On a slightly different subject I downloaded the UniVerse Online Library, I have been going through it but what's unsettling is that almost all the admin docs refer to administering universe with some windows GUI tool (uniadmin) what I cannot seem to find are any references to administering universe WITHOUT uniadmin, surely there are people administering universe (on unix systems) without uniadmin I was hoping to find a doc that detailed things that Phil pointed out , but so far all I can find are ways to administer universe using uniadmin Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sigh phantom ?
Actually this subroutine is the back end application to the graphic admin tool : APP.PROGS VMADMSUB.B (in UV Account). It has coding for UNIX and non-UNIX (Windows) platform. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, December 14, 2007 2:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] sigh phantom ? Seems to me the uniadmin is nothing but a java front end to many of the routines listed on the Motif menu in the uv account. It may contain a few extra things but not many. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org -Original Message- From: Doug Chanco [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 9:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] sigh phantom ? No, I downloaded the ibm universe online library but all the admin docs refer to doing admin stuff using uniadmin Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 SOAP Server
Here's what I've managed to work out so far (it would be nice of IBM U2 Support) could confirm/deny... A) To invoke the SOAPServer without starting up U2WSD (on Wintel): X:\ibm\tools\RunSOAPServer.bat SOAPServerName (See the -classpath for the plugs-in that are required to run the U2 UniSOAP server) B) If you wish to migrate to another server or environment, update the SOAPServerName details in: (mostly self-explanatory): X:\ibm\tools\U2SOAP.config C) Log files created (if debug mode is on): SOAP server optional debug file: X:\ibm\u2soap\SOAPServerName\SOAPServerName.log UniObject sessions trace log file: X:\ibm\tools\uoj_trace.log D) Key directories with JAR files required: X:\ibm\tools\plugins\com.ibm.u2.unisoap_1.0.0\ X:\IBM\Tools\plugins\com.ibm.u2.uoj_1.0.0\ Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Saturday, December 01, 2007 11:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server Hey folks, Just thought I'd take a second to reply back to the recent posts... The SOAP Server included with U2WSD gets installed when you install the tool. There isn't an option (during install) to install the SOAP Server by itself or elsewhere. That doesn't mean you can't relocate the SOAP Server somewhere else when you are ready to deploy. If you have no GUI desktop (Gnome/KDE/etc.) on your Linux server, then it will be hard to install U2WSD on that platform (and as such, gain access to the SOAP Server). That wouldn't be an issue for Windows server users since Windows has a GUI desktop. At the end of the day, the SOAP Server is just a simple Jetty server enhanced to communicated only with U2 servers enabled for it. It is really light-weight. You don't have to fire up U2WSD to start/stop it, but I don't believe IBM includes that tidbit of info in there documentation. Regards, LeRoy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] URGENT: BCI driver configuration / column binding issues
HP have a white page on migration... From PA-RISC to Itanium-based architectures http://h21007.www2.hp.com/portal/download/files/unprot/hpux/5981-7108en. pdf It basically says PA-RISC complied applications should work on Itanium-based platforms (but not necessarily always so). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Beahm Sent: Saturday, November 24, 2007 2:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] URGENT: BCI driver configuration / column binding issues We are upgrading from an HP-UX 64 bit PA-RISC server running UD 7.1 to an HP-UX 64-bit Itanium server, and are having serious issues with BCI. We use Easysoft ODBC-ODBC bridge, however we can connect properly and do not believe that is the problem. Specifically, I can CONNECT successfully, however when I type exec sp_databases ; (or anything else that returns data) and press enter, I get into trouble. Originally, we were getting SqlBindCol messages in place of data; I believe someone re-linked the libraries and restarted UD, and now we get column headers for DATABASE_NAME, DATABASE_SIZE, and REMARKS, followed by 21 blank rows, followed by 21 rows selected. Please let me know how we can troubleshoot this issue. It appears to be that the SQL Server drivers are not working correctly, but I did not set them up on the old server, and do not know what to do on the new one. Regards, David Beahm --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Can I get some advice on triggers?
Keith SQL requires a ; (semi-colon) character along with a 'carriage return' character to signify the end of the command input. There is no other way of creating or managing SQL triggers. Triggers require care in their design, so as not to impair your system performance. Forgetting to setting and release locks is a big no-no and isn't tolerated by a trigger. UV comes with a lot of UV/SQL documents: you need to read/study them a bit beforehand (or simply ask questions on this forum), at least review the SQL User Guide familarise yourself with the basics. SQL Reference Guide as all the info on trigger setup. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson (DSLWN) Sent: Tuesday, November 27, 2007 3:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Can I get some advice on triggers? Hi, I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] But when I try that I get an SQL prompt. We don't use SQL at all - is there some way of setting up triggers without it? Is there another manual I should look at? Thanks, Keith. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects 101 - Java
If you've installed UniObjects for Java (UOJ) on your PC, the installer should have copied samples to your installation drive. On my installation, it is D drive: D:\IBM\UniDK\uojsdk\samples They're useful for code snippets, if you don't want to run these particular samples. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, November 22, 2007 2:02 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UniObjects 101 - Java This helps a lot. Thanks so much. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] WebService
What do you mean webservice TO UV? IBM U2 Web Services Developer allows you develop webservices, encapsulating U2 BASIC or U2 Queries. It's release 1.0, so fairly basic. It doesn't provide a means to deploy, you have to do that yourself...as that's site dependent. It would've better if they bundled the Jett HTTP/webserver with U2 too. The documentation supplied is fairly basic and in places, somewhat misleading in places. Generally, good first release - but there is room for improvement/expansion of it's capabilities. You need to have a (it needs to be separately purchased, licensed and activate beforehand) Connection Pool license from IBM, in order to use U2 Web Services Developer. This probably accounts for the lack of use so far. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Friday, November 16, 2007 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] WebService Hello List, Can someone direct me to a source for creating a web service TO UV. We are running UV 10.10 on a Windows Xp server. As a test I want to create a simple web service to uv to return some data in a dotnet app. I have a vb.net app reading and writing to uv using uonet, but I want to create a web service to do the same thing. I've looked everywhere for a workable example, but have found nothing. If someone already knows how to do such a thing could you bullet point what I need to do. If you happen to be going to U2U in San Francisco and you know the technology I'd appreciate a chat with you over drinks, I'll buy of course. Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Installing UniObjects
UniObjects is the client API. UniRPC Daemon the server component. It is installed and configured by default, unless you have a TCP port conflict. Check for a process executing called unirpcd on your HP-UX system. Unless you're running a web/app server on your HP-UX server and it will require it, then there is generally no need to install UniObjects for Java on it. Are you using the IBM U2 UniAdmin client already? If so, that proves that UniRPC daemon is up and operational already. If is not operation on your system...take the time to read/browse the manual... Administrative Supplement for Client APIs. Give the list a shout, if you're still having probs...lots of suggestions have already been made. UniObjects and (all) other the U2 APIs are not for the faint hearted or inexperienced (especially in your Prod environment). Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, November 09, 2007 9:23 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UV] Installing UniObjects I want to install UniObjects on the server side on our... HP-Ux v11i with UniVerse v10. I am unable to locate any installation instructions. I would like to do UniObjects for Java. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Are you using the -U or -u option for user authentication? What does your cURL logfile output look like? It should detail the nature of the problem perhaps, if enabled. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 5:17 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] -UV- HTTP secure logins No it doesn't. As I said before, the login and password are embedded on every page and there is no separate page to login from. I've tested cURL on a page I manage that prompts for a username and password and I can bypass it just fine with cURL, but not on this particular page. I'm getting pressured by management to make this work. I've tried the --form=name syntax perhaps incorrectly, with no success... By incorrectly, I omitted the from the string... Thanks again for all your valuable help. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE FORMAT
We have an explicit login subroutine for all our U2 API interfaces to invoke to ensure U2 environment is setup correctly. It's mandatory for all interfaces to call prior to doing any other calls. It's the only way to you can ensure that your date format is correct and we have used this methodology for several years. I don't believe there is yet a standard U2 API call to set this (unfortunately). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Parkinson Sent: Thursday, November 01, 2007 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DATE FORMAT Thanks Laura, DATE.FORMAT is OK if it can be set at login somehow? I have a web app which connects to a Unidata session on demand really but each time it does the date format is set to the mm/dd/ format. I need it to remain as dd/mm/ and I can't figure out how to set it Paul --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stringing commands together on the command line. Possible?
Yes, I wondered the same thing... EVAL is designed to emulate an I-type dictionary item. Hence, will only execute any command that you can successfully compile within an I-type. So it wouldn't allow what you have in your example. You'd need a subroutine that could execute via EVAL to invoke a TCL or OS command indirectly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Monday, October 29, 2007 6:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Stringing commands together on the command line. Possible? Don't have access to UV at present, but wonder if the following INPUT would do the trick ' AND WITH EVAL EXECUTE 'CLEAR.FILE CLIENT' = ' Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stringing commands together on the command line. Possible?
I don't believe there is a native command/option to do this in UV. In BASIC you can do this by delimiting each command with mark-character (eg., @FM) and 'execute' the string with the EXECUTE statement. So you could create your own pseudo UV command prompt parser. Some commands can't or shouldn't be run from EXECUTE though. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of penno Sent: Monday, October 29, 2007 9:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Stringing commands together on the command line. Possible? Hi all I'd like to string some commands together, similar to unix, eg ls -l ; cat file ; grep file string This will execute ls, followed by cat, followed by grep. The ; is the magic character that allows this. Is there a similar function available at the UV command prompt?? Thanks Penno --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non
I'd recommend MQSeries too, it is tried and tested technology - it works and works well. It has APIs for C, C++ and Java too. As Craig has pointed out, there is support in U2 BASIC from 10.x up for MQSeries AMI API (a subset of the full MQ API). MQSeries guarantees delivery, can offer confirmation (acknowledgement) of receipt of the message too. The message queuing mechanism is handy too, if you don't require realtime. All of this depends of the myraid of options you use to configuration your queue/channel and how you submit your message. The stumbling block is the initial license setup costs. Installation and configuration really requires someone who knows there stuff when it comes to MQ. It's not for the faint hearted or someone who isn't familiar with it or similar technologies. It can handle huge data volumes and is well supported by IBM, third-parties and the end-user community. It is also multiplatform - IBM mainframe, IBM midrange, UNIX/Linux, Windows, etc. There are other messaging queue managers out there too. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Wednesday, October 24, 2007 9:33 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non Baker, if you want something that will run pretty much anywhere, high throughput and all the transport level thinking done for you why not IBM MQSeries (Websphere MQ). Pretty easy to integrate into any of the MV's through the C libraries and IBM already make it available in UV/UD. Maybe not as fast as pure sockets but: - Flexible - Batch, Realtime, Send Receive, Send Forget, Publish Subscribe - Probably already works with your DB/Platform of choice - VERY reliable - Data format neutral -- send XML, Fixed Width, Dynamic Arrays, SQL statements whatever best fits your needs Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC error
Are you able to successfully complete the ODBC connectivity tests to the demo accounts on your server? If not, fix that first and then if that's not the problem it's probably related to a UV configuration problem. Check your unirpcservices config file and check there is no conflict with any other service on your server. BTW...has it ever worked? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Monday, 22 October 2007 11:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: What are UV server and client releases? Can you get a list of files from the built-in demo accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)
Let's start with the basics: 1) What version of the UV/ODBC driver are you using to push the data from SQL Server into UV? 2) UV version and OS platform 3) Not really applicable in this particular issue, but: if on UNIX platform: what ODBC driver manager are using and the version? Have you re-linked UV with the ODBC driver manager? 4) have you ever had this work before? 5) have you successfully connected to UV from SQL server, if so - at what point does it fail? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, 21 October 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] and PDF
What does 'manage' mean? Do you need barcodes, table of contents, graphics, charts, etc? Do you have a budget? The sky is the limit, of course! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, October 19, 2007 2:03 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] and PDF What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC error
What are UV server and client releases? Can you get a list of files from the built-in demo accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Saturday, October 20, 2007 12:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC error I'm getting an error message Unable to obtain list of tables from the data source from Excel on a new ODBC implementation for any of the available Universe data sources. Anyone have any ideas on where to look? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
FYI... This link has a nice summary of what the major RDBMS offer for the EXPLAIN output: http://www.aquafold.com/docs-ep-plan.html It would be nice to have a version of Aquafold (or one of the many similar multi-OS and multi-database 'aware' toolsets) available for UniVerse too...ah, one day - perhaps! Although there is a Generic ODBC/JDBC option (like similar tools). Although, I wouldn't say they'd be a huge demand for this sort of tool in the U2 environment. Regards, David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Using connection pooling with Uniobjects
Connection Pooling is available at that UV release, but must be purchased, licensed and activated prior to being available for use. To check it is installed/licensed, type: CONFIG ALL at the TCL prompt and look for a line with CONNPL on it. The Connection Pool facility is just used by the IBM U2 Webservices Developer Toolset, but it's not exclusively for its use. It is activated, using the license code IBM gives you via UniAdmin (or via terminal session via the UV account, logged as the UV owner or super-user/admin). You'll need to use the UniObjects for JAVA or .NET client libraries that come with the latest UniVerse Clients CD (downloadable from the IBM website, the same site/URL where you can download the UniVerse PE edition). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Tuesday, October 16, 2007 11:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Using connection pooling with Uniobjects Where I work, we have recently installed Universe 10.2.25 which is supposed to have the connection pooling functionnality for webservices. Is the connection pooling option just something to turn on in Universe options or must a new version of Uniobjects dll be used ? We use version 1.1.7073.0 with dot net 2003. If we need to use a new version of Uniobjects, will it work with the framework of dot net 2003 or is an upgrade to 2005 necessary ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] IBM U2 Web services deployment
Hello, Has anyone yet deployed any webservices that they have developed using IBM's U2 Web Service Developer tool? If so, how have you deployed into your test and/or production enviroments? Thanks, David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Product Distribution Methods
Brian Leach and U2Logic both have client/server-style U2 installers/packaging toolsets. I haven't tried either yet. But both look interesting and have slightly different approaches. See their respective websites for more info. http://www.brianleach.co.uk http://www.u2logic.com Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Thursday, September 13, 2007 8:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Product Distribution Methods Hi Dave, Our system is far too complex to describe here in a single email, but I'd like to discuss the topic in general with anyone who needs to distribute their server-based code to clients, whether external or internal. I'm willing to provide specifics; I just don't want to bore everyone else with a lengthy description here. As far as you can why not keep this on the list -- I'm certainly interested. One procedure does come to mind for this if you are distributing to UV: - Create Clean Install Account(s) for your product. These accounts should have files dictionaries set up as though they were setup at the client just before you began any data entry or customisation for that particular client. These accounts might include only basic source code or just compiled object code (with stub files in place of the BASIC source so that you can use CATALOG). - Back these up using uvbackup - Create a customization script or program or write your install manual --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Learning Uniobjects.NET
Connection Pool can be used with UniObjects for Java too, as per the documentation...as per the IBM supplied toolsets written in Java using connection pool (ie., WebServices). David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, August 30, 2007 1:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Learning Uniobjects.NET Jonathan: You need to purchase a connection pooling license; sorry I didn't mention this. Each UV license costs about $500. A Connection Pool license costs about $1,700. The license can only be used with UniObjects.NET. In UniData, my listusers command looks like: 2 Dev (0)- LU Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 24 + 1 ) / 25 2 0 0 0 2 UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESSTIME DATE 1 2452 197615 wphaskett phantom pts/1 Console 15:57:25 Aug 17 2007 2 2196 197615 wphaskett udt pts/2 192.168.1.51 20:56:58 Aug 29 2007 4 2912 197640 designbai udt pts/4 udcs 20:50:46 Aug 29 2007 And my version command looks like: 2 Dev (0)- VERSION Module Name Version Licensed UniData RDBMS 7.1 Yes Connection Pooling... 7.1 Yes Device License... 7.1 Yes NFA.. 7.1 No RFS.. 7.1 No EDA.. 7.1 No 719 Hope this helps. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with U2Web Services Developer(whimper)
Are we talking about the U2 Servers section or setting up a new webservice? If you defining a U2 Server, then the account names need to be defined in UV.ACCOUNT to be visible. If you're defining your webservice database connection properties then you can also use the fully qualified path or any account name defined in UV.ACCOUNT. If you're talking about a webservice problem, then turn on the SOAP server debug log, you'll see this in the log file, if the account name is invalid (hence needs to be defined in UV.ACCOUNT or use the full pathname): asjava.uniobjects.UniSessionException: The account name supplied is not a valid account Most of the U2 tools and other third-party toolsets have this dependency on UV.ACCOUNT, which for sites that never use it is a bit of a wake-up call. Likewise many of these same tools have a nasty habit of falling over your VOC entries for long gone or invalid hashed and non-hashed/directory file types still lurking there (ie., clean-up time before you use these tools is recommended). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Saturday, August 18, 2007 1:24 AM To: U2-Users (E-mail) Subject: [U2] Need help with U2Web Services Developer(whimper) I can't get this program to connect to our development account no matter what I try! I consistently receive the message Could not change account to 'TRAIN' on server 'our.server.com', the account path does not exist, or you do not have enough privileges to access the account path. I have noticed that browsing for an account leaves double slashes at the root of the path, like so... //ivy/train/TRAIN, but I have tried the path both ways and neither work. ls -al in the directory where the account lives gives this: drwxrwxr-x 37 ivyuser primac 24576 Aug 13 10:06 TRAIN I am logged in as ivyuser, just to try and get this thing to connect, but still no joy. I noted in tfm under the unirpcservices entry, line 3 that The names of nodes allowed to execute this service. This field is multivalued, with values separated by commas, (no spaces). If the field contains * (asterisk), all hosts defined in /etc/hosts can execute this service. So I had my sysadmin add my machine to the hosts file. Still won't work. This is waay harder than it needs to be. What am I missing? TIA, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] User activity - SOX compliance
You mentioned your replaced certain verbs with a remote items and that it failed. What exactly were you trying to do? The whole idea of putting remote items and using a security subroutine was designed to be as transparent as possible. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bartman, George Sent: Thursday, August 16, 2007 7:34 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] User activity - SOX compliance I guess I should have elaborated on the ideas we had any why we didn't think they would work. Here is what we tried and or thought about: We tried to modify the actual commands like COPY, ED, etc to replace them with Remote items but our software vendor uses different syntaxes for all the commands we wanted to monitor. This we used in a limited production test that had some less than desired results (read catastrophic failure) that we had to pull out and are very leery to try again. We are also a heavy user of UV/Net and the creation of triggers would prevent us from using some of our toolset. Before we tried something ourselves again I was asked to see if a vendor has something specifically for this. I didn't see anything good on the U2 business partner list so I figured I'd post the request here. George Bartman Lead UniVerse DBA Omnicare, Inc. Office: (614) 652-3288 E-Mail: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sacred Licence Seat - A Challenge
How are your users and the internet connection connecting to UV? Telnet client, UVCS, etc? What OS and UV version? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee Sent: Friday, August 17, 2007 12:23 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: [U2] Sacred Licence Seat - A Challenge Does anyone have a way to set one licence seat as sacred? There are 15 users in the organization and 20 licences for UniVerse. But users will open more than one session if they can. We need one licence always available for when an internet connection is made. How do we keep one unused? Is there a UniVerse setting that prevents a seat from being taken locally? Has someone out there done this? Would you like to share the technique? Any suggestions? Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000F: (08) 9315 7088 W: http://www.itvision.com.au http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Speeding up a big BY.EXP select
Add the EXPLAIN keyword to your query and see what the UV query analyzer says...sometimes useful, mostly not though ;) Another thing to try is an SQL SELECT, that'll give you a few more grey hairs...! Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, August 09, 2007 5:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? Stuart Boydell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 AMI Interface
Hi Craig Glad you're problem is resolved... The exact same problem happened to us too! As we needed to have different repositories for different hosts and for testing purposes. Also, we didn't want to change the default respository. It's a critical omission from the U2AMI manual. We only found it after we stumbled on the tracing option. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Wednesday, August 08, 2007 12:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 AMI Interface Hi David, thanks for your advice, it let me find and solve my issue (I didn't realise that my uv processes weren't looking at my repository). I kept searching the docs I had for logging when tracing was the match I needed. Now if only IBM would add this into the UV manuals! My shout if we ever cross paths. regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 AMI Interface
Hi Craig We use U2AMI. It was a steep learning curve, but it all works well now... I don't think I've ever seen a timeout error/issue when using amSendRequest. We do see it with amReceiveMsg though. However, this is not an issue for our application, when just try again...more specifically we simply check for retCode # AMCC_OK and for reasonCode = AMRC_NO_MSG_AVAILABLE. I assume you're using the AMI Admin Tool? Can you be more specific? Where exactly are you setting your value you're expecting? I assume it's the Receive tab for the policy in question. Are you loading the correct policy file, before you invoke the U2AMI proxy client? Have you run any AMI debugging/trace logs? If you're going to be writing your own C, C++, COBOL or Java code -- and you want to use AMI, then this AMI guide is very handy... ftp://ftp.software.ibm.com/software/ts/mqseries/library/books/amtyak04.p df Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Friday, August 03, 2007 3:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 AMI Interface Hi, is anyone actually using the U2AMI interface to talk to MQ Series? Have you experienced a problem where a timeout does not occur if your send a request with amSendRequest and no response is returned regardless of the timeout setting in the policy used? regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 AMI Interface
Craig, I didn't realise there were debug logs available, any suggestions on where I should look? Not sure what you need to check in the trace logs. I assume you application is working okay or are debugging are existing issue? Before we execute the BASIC application with the U2AMI calls, we defined what AMI respository we want to use and then setup the optional AM_TRACE variables (unset them to remove). The logs can be very details (esp. level 9), so they need to be turned off. This on Sun Solaris environment...UV 10.1.18: SETMQENV 001 PA 002 ENV AMT_REPOSITORY=dmms_amt.xml 003 env AMT_HOST=amthost.xml 004 ENV AMT_TRACE_PATH=/DMMSDEV/DAVID/LIVE/HOLD 005 ENV AMT_TRACE_LEVEL=9 006 ENV AMT_TRACE=yes 007 ENV AMT_DATA_PATH=/DMMSDEV/DAVID/LIVE In the above example, log files named AMTn.TRC are written out to /DMMSDEV/DAVID/LIVE/HOLD. Unset AMT_TRACE to toggle tracing on/off. More details on AMI tracing, etc are in this IBM document: ftp://ftp.software.ibm.com/software/ts/mqseries/library/books/amtyak04.p df I am uncertain if this has anything to do with your issue...but I did notice the following in the U2AMI.H include file in UNIVERSE.INCLUDE: ---snip--- ** ** * ** Wait time constant for use with: * **amPolGetWaitTime * **amPolSetWaitTime * ** * ** EQUATE AMWT_UNLIMITED TO -1 ---snip--- According to the AMI documentation amPolGetWaitTime - Returns the wait time (in ms) set for this policy. amPolSetWaitTime - Sets the wait time for any receive function using this policy. Regards David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Move data files from Unidata to Universe
A relatively easy and 'simple' way to read/write UD files from UV (or
vice versa) is to use BCI.
We use BCI to communicate and transfer data to/from remote UV database
servers. It works fine for our purposes. There is no reason why the
remove server can't be a UD database (provided it supports BCI, of
course).
We do it by calling a subroutine on the remote host, as a SQL stored
proceedure. We past what we want to do to (read/write) the routine and
the associated data is passed (dynamic array) to or from the client
application. It works well for us. We do simple record at a time type
transfers, emulating the PI-style COPY verb.
Regards
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: Wednesday, July 25, 2007 11:11 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Re: Move data files from Unidata to Universe
UPDATE:
Here is a response I received from IBM:
Scott,
I have checked with our Lab Services (aka consulting) group and they
tell me that there have been no requests to migrate a UniData account to
UniVerse, and there are no native utilities within UniVerse to do this.
They are willing to discuss this with you as a billable engagement.
FYI, if this had been the inverse .. migrating a UV account to UniData,
it would have been no problem, as UniData comes bundled with a command
called UV_RESTORE, which takes a uvbackup sourced account and restores
and converts it to UniData file formats.
So perhaps there is another way to skin this cat. Is there a way to
read/write to UDT files directly from UV?
Any and all off-the-wall, out-of-the-box, out-of-left-field, {insert
your favorite left-brained-business-creativity-MBA cliche here}
suggestions welcome.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uniobjects Issue
It's likely you're not logged on to the same account. Check your code to see if you specify the account name or pathname of the account (where you file resides). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Long Sent: Tuesday, July 10, 2007 4:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Uniobjects Issue Hi all - I am new to Uniobjects and have written a small test program that just reads a specified record from a file and returns it. This works perfectly on the PE edition, as well as on my clien't system IF I attempt to read a standard file like VOC or BP. If I attempt to read a record out of a file or directory I have created, it fails stating the file doesn't exist, when I know full well it does, as does the record I am trying to read. Is there a configuration I missed somewhere? Thanks in advance. Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups - DBPAUSE for UniVerse? {Unclassified}
Unfortunately, that's one of many omissions of the manuals and online
help...I wonder if they have a dedicated resource for this task of
keeping the manuals up-to-date and useful.
Perhaps someone would like to volunteer to document and then submit a
list of 'known errors and omissions' for the UniVerse documentation set?
Then it can be submitted to IBM?
Regards
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Friday, July 06, 2007 6:30 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? {Unclassified}
Ah, yes there it is in the User Reference, like you said Mark.
BUT, on 10.1 anyway,
* 'SUSPEND.FILES' is not in the Index of the User Reference, you
have to search the document to find it.
* When you do find it, it doesn't say whether the Dynamic / Type
30 file headers (or anything else) are flushed to disk when you
SUSPEND.FILES ON, and
* The documentation for uv -admin [options] lists the effects of
the options but not what the switch settings are that you would have to
use to invoke the options
All in all, not amongst IBM's best documentation efforts
Regards
Mike
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
