Re: [U2] jobnotify: Error 913 occurred

[Hona, David]

Sorry, I forgot to reply...

I vaguely recall having a "jobnotify" errors when we migrated to AIX6.1 and 
UV11.1.9 during the testing phases...but do not recall if it was the "913" 
version you got...I cannot find my notes on this and didn't raise it as a 
problem case with Rocket...

You could be occasionally running out of user processes - but only when the 
system is busy... or perhaps some settings are not optimised for your server / 
license, etc.

A quick check is to verify 'ulimit' sessions for your UV session (do a ulimit 
-a at the shell prompt). 

Check the current values of the ULIMIT and SHMMNI kernel parameters. SHMMNI 
should be set to Number of Users + 2. (This is from a Rocket UV11 tech note)

Finally, I think we also ran into issues with running out of LCTs...not 
necessarily  relayed to the jobnotify error... This was another configuration 
issue not documented in the install guide at the time. That required of the  
tweaking of the UVCONFIG NUSERS parameters to ensure that everything was 
'optimised', etc. and documented in the tech guidese "UniVerse 11.1 - Before 
You Upgrade.pdf" (previously  "What You Need To Know for Eleven One.pdf").

Hope this helps...

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon
Sent: Thursday, 20 March 2014 2:40 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: Re: [U2] jobnotify: Error 913 occurred

Nearly one week and no responses...

Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or 
has any knowledge of it.

Regards,
Brendon Leverett

From: Leverett, Brendon
Sent: Friday, 14 March 2014 11:09 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: jobnotify: Error 913 occurred

We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some 
unusual activity around phantom jobs and the documented change to NOTIFY ON.

There are a lot of details behind the scenes but in summary:
- started  a job via phantom command (phantom SYNC.COPY.BNET)
- noticed 90 mins later that this job had crashed. This crash happens for 
various reasons but is more frequently crashing since the upgrade
- restarted the same job with the same phantom command At this time the 
following 3 lines of text was returned to the user's session:
jobnotify: Error 913 occurred
[15466830] SYNC.COPY.BNET - terminated
Phantom process started with process ID 33161456

Seems the 1ST 2 lines of text related to the previous phantom and 3rd line 
related to the phantom just started.

My Q is:
Does anyone have any ideas about the specific message
jobnotify: Error 913 occurred


We are running on AIX.

Regards,
Brendon Leverett

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2 ODBC error

[Hona, David]

Do you have a context? New UV version? Old process just stopped working? New 
version of software X or Y? New server? New everything and old query A or 
updated query B? Those error message aren't helpful without some context...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Judy M
Sent: Wednesday, 19 March 2014 3:38 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 ODBC error

U2 UviVerse verions is The version of UniVerse TIO run is 11.1.9.
ODBC U2 version is 32 bit  6.140.01.7533 I am call the ODBC DSN from Cognos 
Data Manager V10.2.1.

This is the last entry in the ODBC log anyone give me any pointer.


databuild.exe"  cfc-c40 ENTER SQLGetDiagRecW 
SQLSMALLINT  2 
SQLHANDLE   0x0018CCC8
SQLSMALLINT  1 
SQLWCHAR *  0x0032C4A8
SQLINTEGER *0x0032C610
SQLWCHAR *  0x0018D9D0 
SQLSMALLINT512 
SQLSMALLINT *   0x0032C61C

databuild.exe"  cfc-c40 EXIT  SQLGetDiagRecW  with return code 0
(SQL_SUCCESS)
SQLSMALLINT  2 
SQLHANDLE   0x0018CCC8
SQLSMALLINT  1 
SQLWCHAR *  0x0032C4A8 [   5] "S1003"
SQLINTEGER *0x0032C610 (0)
SQLWCHAR *0x0018D9D0 [  55] "[Rocket 
U2][U2ODBC][0400864]SQL
data type out of range."SQLSMALLINT512 
SQLSMALLINT *   0x0032C61C (55)

databuild.exe"  cfc-c40 ENTER SQLGetDiagRecW 
SQLSMALLINT  2 
SQLHANDLE   0x0018CCC8
SQLSMALLINT  2 
SQLWCHAR *  0x0032C4A8
SQLINTEGER *0x0032C610
SQLWCHAR *  0x0018D9D0 
SQLSMALLINT512 
SQLSMALLINT *   0x0032C61C

databuild.exe"  cfc-c40 EXIT  SQLGetDiagRecW  with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT  2 
SQLHANDLE   0x0018CCC8
SQLSMALLINT  2 
SQLWCHAR *  0x0032C4A8
SQLINTEGER *0x0032C610
SQLWCHAR *  0x0018D9D0 
SQLSMALLINT512 



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/U2-ODBC-error-tp42865.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Embedded help as hypertext

[Hona, David]

Wrapping in HTML is easy. Like anything ...doing it properly is hard...doing it 
right costs time and money...is it really worth it?? Unlikely - unless Rocket 
did it for us! :)

Why don't just used BDT it has online context sensitive help and like the 
original poster said he uses the PDF.

Key flaw in any plans is the large amount of missing commands and functions in 
all versions of the documentation (PDF, BDT, online in U2, etc.). In the past 
Rocket Software predecessor companies did produce Windows help file 
versionsas they do now for the fix/bug/release list download'ble from their 
website.

Ideally, you should be just google it...and it would refer to a page on their 
site...just like you can do already for a numerous vendors...



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Thursday, 13 March 2014 1:05 AM
To: U2 Users List
Subject: Re: [U2] Embedded help as hypertext

The Universe 'HELP' (and HELP BASIC and HELP SQL) listings are all contained as 
records in the file 'HELP.FILE'. Creating a program to make an index page and 
html-ized versions of the individual items would be an easy
project:

LIST HELP.FILE PICK*SAVE.LIST TEXT 07:59:54am  12 Mar 2014  PAGE1
HELP.FILE. PICK*SAVE.LIST
Text.. SAVE.LIST
 .
 . Use SAVE.LIST to save an active select list. You can use GET.LIST
 . to recall this list for subsequent processing and avoid having to
 . repeat the selection process each time you want to use the same selec
 . list.
 .
 .
 . Syntax
 .
 . SAVE.LIST [ [ filename ] listname ] [ FROM n ]
 .
 .
 . Parameters
 .
 .
 . The following table describes each parameter of the syntax.
 .


On Tue, Mar 11, 2014 at 11:49 PM, Hona, David  wrote:

> I assume you're talking about UV? Define 'improved'?
>
> It could be improved by actually having all the commands, options and 
> functions in it first. Even the PDF versions are missing 
> information  :)
>
> However, if you want another/"better" built-in HELP facility for your 
> own purposes...PIHELP may help you (it offers paging back, sub-topics, 
> indexing, etc.)...
>
> If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine 
> "-SHOW") which is a port of the Prime INFORMATION help which has 'hypertext'
> (sub-topics) and paging (back/forwards). In PI, there was also a 
> subroutine you could call (rather than "EXECUTE PIHELP ". It 
> has own format where you can specify the help file source and 
> sub-topics indexed based on keywords in the topic/help message, like this in 
> field/line one:
>
> 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE
>
> An index on the help file would on the above field allow "PHELP ABOUT 
> ". The "FROM" key word lets you specify you own help file.
>
> It is better than the native UV HELP in some respects and utilises the 
> default "SYS.HELP" file or your own (if required). I did note that 
> there is no indices for the SYS.HELP file, so the "PIHELP ABOUT 
> " function doesn't work...the required I-type dictionary item 
> to parse the help records appears to be missing from the dictionary of 
> SYS.HELP (Rocket Support should be able to assist there).
>
>  The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I 
> guess it has been "ported over" for PI/open users that used this 
> facility for their own applications...
>
> The U2 Tools have built online help too - which are handy. If you use 
> them
> - I'd encourage all newcomers to use these tools and similar 
> commercial products to supplement the built-in native command-line 
> tools (aka terminal shell session)...
>
> Cheers,
> David
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Wednesday, 12 March 2014 3:43 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Embedded help as hypertext
>
>
> Does anyone have an improved version of the TCL command HELP ?
>
> Are there any wiki's or anything that comprise all of the HELP text 
> and perhaps more ?
>
> I sometimes use it, sometimes use the PDFs and sometimes just google.
>
> I think it would be a great resource were there a better solution.
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ** IMPORTANT MESSAGE * T

Re: [U2] Embedded help as hypertext

[Hona, David]

I assume you're talking about UV? Define 'improved'? 

It could be improved by actually having all the commands, options and functions 
in it first. Even the PDF versions are missing information  :)

However, if you want another/"better" built-in HELP facility for your own 
purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, 
etc.)...

If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine "-SHOW") 
which is a port of the Prime INFORMATION help which has 'hypertext' 
(sub-topics) and paging (back/forwards). In PI, there was also a subroutine you 
could call (rather than "EXECUTE PIHELP ". It has own format where you 
can specify the help file source and sub-topics indexed based on keywords in 
the topic/help message, like this in field/line one:

0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE

An index on the help file would on the above field allow "PHELP ABOUT 
". The "FROM" key word lets you specify you own help file.

It is better than the native UV HELP in some respects and utilises the default 
"SYS.HELP" file or your own (if required). I did note that there is no indices 
for the SYS.HELP file, so the "PIHELP ABOUT " function doesn't 
work...the required I-type dictionary item to parse the help records appears to 
be missing from the dictionary of SYS.HELP (Rocket Support should be able to 
assist there).

 The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it 
has been "ported over" for PI/open users that used this facility for their own 
applications...

The U2 Tools have built online help too - which are handy. If you use them - 
I'd encourage all newcomers to use these tools and similar commercial products 
to supplement the built-in native command-line tools (aka terminal shell 
session)...

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, 12 March 2014 3:43 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Embedded help as hypertext


Does anyone have an improved version of the TCL command HELP ?

Are there any wiki's or anything that comprise all of the HELP text and perhaps 
more ?

I sometimes use it, sometimes use the PDFs and sometimes just google.

I think it would be a great resource were there a better solution.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Multi-threaded phantom processing

[Hona, David]

Hi Peter

Clearly, you have no other option than to go the direction you have. Sounds 
like you're using the correct API and approach for the task at hand and with 
the constraints you have. Sounds like you have considered various implications 
and you're constrain by UV versions and UniRPC being blocked (a good thing if 
you're connectivity to third-parties and over unsecure/public networks :))...

BTW: UV File triggers are light-weight triggers available in UV11.x - without 
the overhead and complexity of UV SQL Triggers.

The MQSeries interface is good, but it's learning curve can be steep and is 
only feasible if both sites are licensed users. I've used it a lot, but the 
underlying complexity of the MQ setup and API can be up there with TCP/IP 
sockets :(... if you're new to it all!

SQL BCI requires UniRPC access so that would be ruled out for your use as well. 

All of the higher-level APIs just save you the hassle of writing a complex 
low-level interface which could be hard to develop, debug and maintain in the 
future...

In my experience, it is difficult to optimise any interface unless you have 
some minimum, average and maximum loads or throughput requirements to be met. 
It'll be difficult to optimise the interface other than setting minimum and 
maximum phantom processes - as you're and other have already mentioned. I guess 
time will tell how it works and what tweaking (aka optimisation) will be 
required...nothing like real-world usage to sort things out...

Another potential consideration you need to consider or at least have test 
cases is loss of connectivity due to abnormal termination by the client, 
network (local/carrier/remote) or remote server. All these events may cause 
various issues that can impact UV locally, remotely and your TCP connectivity. 
Troubleshooting network and application connectivity is never easy - hence 
working through "worse case scenarios" in advance is a worthwhile - and 
somewhat very tedious exercise. Such issues have are applicable to all 
applications - of course. Such network issues impact the native UV APIs as 
well...but I am sure you'll get to know and loathe errors such as FIN_WAIT, 
etc., etc. as you get more usage and issues, etc.

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Friday, 7 March 2014 6:00 PM
To: 'U2 Users List'
Subject: Re: [U2] Multi-threaded phantom processing

Initially data volume will be small - probably about 20 customers per day and 
about 6 records per customer but it is likely to grow very quickly up to some 
unknown amount. We'll have to see I guess. The records per customer are likely 
to be the high volume stuff.

There is transaction logging on the remote system that I can use and am relying 
on for data integrity but I did not know about the SQL stuff until this week. 
Not sure if it would work until I can find time to play with it and see how it 
might suit us.

Some of the other constraints were: no access allowed to the remote unirpc 
port, the remote UV is below 10.3 and different from ours, neither site has a 
UV/Net licence in prod. So I think I'm pretty much stuck with file queuing and 
multiple phantoms for now at least.

I also was able to get a successful remote file process going on our test 
system while waiting for confirmation of UV/Net accessibility. It is very nice 
and might have been a nice solution too.

Then I did some experimenting with the performance requirements on the file 
triggers and found there to be too much of a lag for the triggers to fire 
directly to the other end. This would've caused unacceptable problems in 
testing not to mention going live so a file queuing process had to be devised.

In all the file queuing works quite well and can be coded for rock solid 
reliability so it has a lot of pluses. I can also fine tune the phantom loop 
times and socket timeouts on the fly at both ends once the data starts flowing 
and we get some idea of what needs changing.

Fingers, toes, arms, legs (and eyes!) all currently crossed.
Cheers
Peter





Peter Cheney
Ultracs Developer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au
w firstmac.com.au


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Friday, 7 March 2014 13:41
To: U2 Users List
Subject: Re: [U2] Multi-threaded phantom processing

Hi Peter

Sounds like an interested piece of work, just a couple of questions for you:

- what sort of data volumes and update frequencies are involved?

- do you need to know if the data has been successfully committed to the remote 
UV database?

- did you consider SQL BCI or even UV/Net (read the different UV versions is an 
issue and so this may be a constraint)

Gregor mentioned SQL BCI as an

Re: [U2] Multi-threaded phantom processing

[Hona, David]

Hi Peter 

Sounds like an interested piece of work, just a couple of questions for you:

- what sort of data volumes and update frequencies are involved?

- do you need to know if the data has been successfully committed to the remote 
UV database?

- did you consider SQL BCI or even UV/Net (read the different UV versions is an 
issue and so this may be a constraint)

Gregor mentioned SQL BCI as an alternative interface - I've used that before to 
exchange data between systems and it works well. If you had the same UV version 
on both hosts - then UV/Net is simple effect way of transmitting data between 
UV systems with only licenses required on the remote system. 

With BCI you could utilise the Stored Procedure facility via an ExecDirect() 
call to push the data to the remote system in your UV file trigger. 

With UV/Net you could "push" the items to be copied the by your UV file trigger 
- thus the updates being written directly onto the remote host. 

BCI is free/included in UV and of course will utilise a license on the remote 
host. You need to write your own custom code. Probably a bit easier to maintain 
than any TCP/IP sockets based interface. Definitely a lot easier to 
troubleshoot ;-) ! YMMV.

UV/Net is licensed on the number user connections on the remote host.

Hence the above alternative as designed to eliminate the file-based queue - 
which in some instances by be desirable to maintain - depending on business, 
technical or operational needs/objections.

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Wednesday, 5 March 2014 12:18 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Multi-threaded phantom processing

Hi Everyone,

A project that I’m currently working on requires transmission of transactional 
and ancillary data from one UV site to site to another.
I have the communications all set up and it is working very well via the UV 
socket functions with a client at one end and a server at the other.
Both the client and the server both run as a UV phantom processes written in UV 
basic and the data being transferred (also encrypted) is more or less real time 
with various UV file triggers on the client end creating queue items for 
transmission based on the data content / transaction type.

This set up is a single threaded affair and I am wondering how it will cope and 
what options I’ll have as the volume of data increases.

Multi-threading my server process to dish out some of the load might be one 
possibility and I’ve seen examples in the past where the last digit of a 
numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call 
thus providing an effective distribution of the work.

But even then, reading/writing processing data to a file for each child process 
seems to me to be the only way to achieve parent <-> child phantom 
communications at either end. Is there another way perhaps? It may be that I 
will need 2 sets of phantoms, 1 for the transactions and one for the ancillary 
data. Although we run UV on AIX the only other requirement is that I must be 
able to do it within UV Basic.

Does anyone out there on the list know of a better way or any 
alternatives/advice so I can get a better appreciation of what else might be 
possible please?

Many thanks in advance,
Peter


Peter Cheney
Ultracs Developer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au
w firstmac.com.au


 ---
Note: 
This email (inc all attachments) is for the use of the intended recipient(s) 
only.
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then delete all copies of this message from your computer network. If you 
are not the intended recipient, you must not keep, use, disclose, copy or 
distribute this email without the author's prior permission. If you are the 
intended recipient and you do not wish to receive similar electronic messages 
from us in future, then please respond to the sender to this effect. 
We have taken precautions to minimise the risk of transmitting software 
viruses, but advise you to carry out your own virus checks on this email and 
its attachments. We do not accept liability for any loss or damage caused by 
software viruses and do not represent that this transmission is free from 
viruses or other defects. 
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) 
 ---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 

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

[Hona, David]

There is the !EXIST subroutine. It's a legacy Prime INFO subroutine - created 
for legacy code that need it. The source code is in UV APP.PROGS and just reads 
GLOBAL.CATDIR and also sets STATUS() with a return code too.

CATALOGED.NAME = '*MYGLOBALSUB'
call !EXIST(CATALOGED.NAME, RC)

crt CATALOGED.NAME:" = ":(if RC then "exists" else "NOT found")
crt CATALOGED.NAME:" STATUS() = ":STATUS():" = ":(if STATUS() then "exists" 
else "NOT found")


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Tuesday, 28 January 2014 4:06 AM
To: U2-Users List
Subject: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine

Does anyone know of a good method in UniVerse BASIC to be able to verify if a 
subroutine is globally cataloged?

Thanks.
Perry Taylor
Senior MV Architect
Office (877) 494-7633 ext. 4392
Direct (502) 779-4392
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.com

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] uv 11 and phantoms

[Hona, David]

I don't think so, not that I have seen. Please see 
https://u2tc.rocketsoftware.com/documentation/PDF/1177927.pdf

It is a little out of date (but still correct essentially - not all the API 
calls are listed):

"The BASIC functions that will cause a PHANTOM process to consume a license are:
Sockets: openSocket(), openSecureSocket(), initServerSocket(), 
initSecureServerSocket()
WebSphere MQ: amInitialize()
callHTTP: submitRequest()
SOAP: SOAPSubmitRequest()

There is no additional setup on the part of the user. We provide mechanisms for 
the user to determine if a license is being consumed by an interactive shell 
user or an "interactive" PHANTOM.
This change has been implemented in the following patch releases:
UniVerse 10.0.21 and higher
UniVerse 10.1.1 and higher
UniData 6.0.13 and higher
UniData 6.1.0 and higher"




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, 10 January 2014 4:32 AM
To: U2 Users
Subject: [U2] uv 11 and phantoms

On UV11, do all phantoms now take a user seat?  Or just those that use the port 
calls?

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] INPUTTRAP Statement

[Hona, David]

Peter has the right idea. PTERM just does a TTYGET and TTYSET so you can call 
that directly if you wish. Our legacy code uses "CALL !PTERM('-ERASE 
':CHAR(8))" etc. to change TTY characteristics.



I think this "quick n dirty" code snippet could work for youif you utility 
is UV/BASIC based you could incorporate this code (maybe!)...



1. Temporary re-define/re-assign the BREAK key then loop for character 
(decimal) 3...



* Re-define INTR (Break) key so we can 'detect' it

* Assumption is Control-C (Char 3) is the Break Key

* Use TCL PTERM -DISPLAY to check what your BREAK key is set to first ;-)

* David Hona, Jan. 2014

$INCLUDE  UNIVERSE.INCLUDE TTY

  ttyget tty$ then

 if CC.INTR ne 3 then crt "WARNING: BREAK character is currently set to 
ASCII decimal = ":CC.INTR:" and NOT '3' as expected"

 if CC.INTR then

crt "Changing to decimal 2 (temporarily)"

crt "TTY interrupt character = Decimal ASCII = ":CC.INTR

CC.INTR = 2  ; * Set to decimal 2 character 
(Control-B)

ttyset tty$ then

   crt "TTY interrupt character = Decimal ASCII = ":CC.INTR

end else

   crt "TTYSET failed!"

end

 end

  end



  EXIT.FLAG = @FALSE

  prompt ''  ; * Suppress prompt character



* Now loop for CTRL-C character



  loop



 input BUFFER, -1



 if BUFFER then

input CHAR, 1

crt "ASCII = ":seq(CHAR)

if upcase(CHAR) eq 'Q' then EXIT.FLAG = @TRUE

if seq(CHAR) eq 3 then

   crt

   crt "CONTROL-C detected!"

   crt

end

 end



  until EXIT.FLAG do



 nap 500 ; * Sleep so not to consume all the 
CPU time



  repeat

*

* Reset back to Control-C

*

  crt "TTY interrupt character = Decimal ASCII = ":CC.INTR

  CC.INTR = 3

  ttyset tty$ then

 crt "Reset back to Control-C"

  end else

 crt "Warning: TTYSET failed. Unable to reset BREAK key back to 
Control-C"

  end



   end





2. ON.ABORT and @ABORT.CODE



If you are using an external routine (UNIX or Windows scripts) called from UV, 
then you will have to utilise the ON.ABORT paragraph along with @ABORT.CODE to 
determine the reason it is being executed. New to UV11.2 is that @ABORT.CODE 
returns 4 for AUTOLOGOUT events.



There is no way to work out what routine was executing prior to invoking it 
from what I recall - post-invocation of ON.ABORT.



You could set you own audit trail/transaction logging, setup your own Global 
Labelled Common variables or just use/set @USER.RETURN.CODE which a paragraph 
can access. Hence use one or a combo of those to run a clean-up utility invoked 
via ON.ABORT.



Finally, some care needs to be taken to ensure your external routine/script 
trapping interrupts (as that'll clash with UV's trap handling)...





Cheers,
David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Tuesday, 24 December 2013 9:17 AM
To: U2 Users List
Subject: Re: [U2] [UV] INPUTTRAP Statement



Could you do this via a combination of the PTERM command's BREAK and INTR 
options along with the ON.ABORT etc?

Something like changing the break from ctrl-C to another key combo during that 
session?







Peter Cheney

Ultracs Developer

t 07 3017 8837 | f 07 3002 8400

e peter.che...@firstmac.com.au

w firstmac.com.au





From: 
u2-users-boun...@listserver.u2ug.org
 
mailto:u2-users-boun...@listserver.u2ug.org>>
 on behalf of Perry Taylor 
mailto:perry.tay...@zirmed.com>>

Sent: Tuesday, 24 December 2013 5:41

To: U2-Users List

Subject: [U2] [UV] INPUTTRAP Statement



Has anyone ever used the INPUTTRAP statement in UniVerse BASIC?  I want to be 
able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), 
or any other character for that matter.  The UniVerse BASIC Commands 
documentation provides no examples on its use.



Anybody done anything like this?  Any sample code you're willing to share?



Thanks.

Perry Taylor

Senior MV Architect

ZirMed

888 West Market Street, Suite 400

Louisville, KY 40202

www.zirmed.com>



** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commi

Re: [U2] USERS command in Universe

[Hona, David]

See the documentation for the BASIC !GET.USERS and !GET.USER.COUNTS subroutines 
in the UV/BASIC reference manual.

Technically speaking, the internal UV daemons are not consuming UV licenses 
(mostly!), hence do not qualify as UV users...

As mentioned by Jon Card - you can also capture the output of uvlictool - which 
will need to be parsed first - before it can be 'consumed' by your application. 
It's a good tool - as it gives you want UV thinks is consuming the licenses 
versus what the other internal routines think are active OS processes that may 
or may not be present/active. 

At times, there can be two different numbers output from these toolsets. 
Especially, if processes have crashed, hung or are infinite loops consuming 
large amounts or CPU/memory, etc but doing nothing useful...or in some 
instances some processes can be transient in nature and not stay active for 
long (for whatever reason).

PORT.STATUS is useful too, but you should be aware that only one user can 
execute this at any given time and it should be used sparingly on large user 
and/or busy systems (as it attempts to query the state of each UV process as it 
identifies each). Many UNIX systems require administrative access in order to 
use it as well (unless you make tweaks for your platform to allow non-root 
users, etc.).


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, 9 January 2014 6:22 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] USERS command in Universe


The HELP USERS doesn't really say anything useful.

When I do a LISTU I count 87 sessions
USERS says there are "74 users logged on the system"

That's close to what I might say are the "unique" users, since some people have 
more than one session.
But I can't get it exact.

Does USERS count phantoms? console jobs? jobs like that uvdlock and uvcleanup 
and uvsmm?
How about jobs from Uniobjects making it's brief connections (uvcs), are those 
USERS for the purpose of this verb?

And if there's any better documentation about exactly what USERS is doing, can 
you point it at me?

Thanks.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Did you use "format.conv" (UNIX / DOS/Windows command) or FORMAT.CONV (TCL 
command) on the HPUX sourced files that restored - post-restore? This will 
convert them into the format required for the target system...

There are many options to choose from...see Admin.pdf (In the UV11.1 edition, 
see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV)

A quick google would've revealed to you the following thread... which could be 
useful as well...
http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td7144.html 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mburgun
Sent: Wednesday, 8 January 2014 4:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux

Hi,

The general consensus seems to be that when migrating UniVerse across platforms 
the best approach is to use UVBACKUP on the old platform and then UVRESTORE on 
the target platform and all platform issues are taken care of.
We, however have just attempted this process in migrating UniVerse 10.1.20 on 
HP-UX to UV 11.x on Redhat Linux and have come across the following problem ... 

UVBACKUP seemed to worked OK (we were able to restore on old platform UVRESTORE 
seemed to work OK on target platform

 

In the above screenshot the directory contains UniVerse files but UniVerse 
doesn’t recognise them.  UniVerse can’t run in this directory without its 
essential database files.  Answering “Y” to the question also won’t work as 
UniVerse is unable to initialise the directory while it contains rubbish files 
having the same names as the required UniVerse files.

Does anyone have any ideas?

Thanks!

Michael



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Migrating-UniVerse-10-1-20-on-HP-UX-to-UV-11-x-on-Redhat-Linux-tp42468.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Exporting to File regularly

[Hona, David]

Hi David

If you upgrade to the latest UV version you have access to the built-in UV DB 
audit logging facility. Then you can setup a logging event to log changes to 
the file(s) in question. Hence, not violating the NDAs nor application flow 
(which you would have too if modifying the file with adding indices / triggers 
or the like).

A simple file-based trigger (not the UV/SQL triggers - which a different more 
powerful beasts) that copies could make a copy to your own file or invokes a 
BASIC program/script to send notifications should do the trick too.
A working example someone has posted on U2-Users List:
http://u2-universe-unidata.1073795.n5.nabble.com/universe-11-1-triggers-via-indexing-and-IDX-IOTYPE-sample-tc41706.html#a41718

Audit logging is not for you unless you upgrade UVbut perhaps in the 
future...I guess you need a job to check the audit log for these events...too
https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/11.2/security1.pdf
 
See page 372 Section 7 for Audit logging

BTW: Look at from the vendors' perspective they have a lot of intellectual 
property tied up in their product. They sell it with consultancy, etc. It's how 
they make their living - pay their bills and eat... ;) Plus a lot of clients go 
out of their way not to pay for anything... it's a two-way rocky road sometimes!

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell
Sent: Thursday, 12 December 2013 9:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Exporting to File regularly

Wow, overwhelming response to this question, thank you VERY MUCH for all of 
your idea's, I have a lot to process and decide what I can achieve... as a bit 
of background that I probably should have included, I am running UniVerse 
11.1.9 on an IBM AIX 7.1.1.15 box.

So far Bruce Decker seems to have the most appealing option if I can get it 
going, I'm sure I be full of more questions than answers in a few days, I just 
hope making this script doesn't make me the go to guy at work when someone 
needs weird universe stuff done... *gulp*

Oh and its a database that is populated by a contact form from a secure website 
which then alerts the old terminal sessions that this business used in the 
past, but since they switched to a web interface for the software and hardly 
anyone uses the terminal full time any more the items sit there sometimes for 
hours before a response, so yes I want to be spammed by this all day long, and 
once it works I can point that spam at a receptionist or two :)

The problem with notifying just on changes, is the file changes every time an 
individual reads a record and marks a particular record as "READ" for that user 
by removing their name from the "users who have not read this yet"
column, the file size never changes unless it needs to grow and when records 
are deleted it simply fills with junk, which I take it is a standard universe 
thing it does, at this point the numbers appear sequential but that is best 
guess sigh.

The vendor is incredibly secretive, they wont tell me how it works and their 
NDA says I am not allowed to memorize how their interface works... WTF so YAY 
obscure software that we cant leave because we are backed into a corner!
/end rant

Anyway thanks for all the help guys, so glad I found this place!



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264p42277.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV/Net usage and licensing

[Hona, David]

Hi Peter,

It's been a while since I've used/played around with UV/Net, but this may 
help...

1. Setup
You only need a ensure UniRPC is active and you license for UV/Net on the 
server you wish to access. I don't recall you need to anything other than the 
UniRPC Daemon listening for requests and it will invoke uvnet for your client 
request.

2. Security
I can't recall if you're using UNIX or not...(it is supposed to OS independent)

Although, UV/Net is supposed to set the effective user (UID numer) and group 
(GID numer) for the remote users connecting to the remote UV server...if 
required. Plus if specified - as you're doing so. My experience with similar DB 
product tools is it is far better to have the UID and GIDs directly aligned. 
Specifically: make sure the UID and GID for the same named accounts are exactly 
the same on both servers. Or if you use SET.REMOTE.ID that the account locally 
has sufficient rights or in fact it exists.

I have issues with the same accounts and groups on different users have 
different UIDs and GIDs on the different client and servers - causing grief/ 
havoc on similar products to UV/Net, etc.

Also - check if you have UniVerse Dynamic Type30 files, that your UNIX file 
ownerships, group ownership and Other are set exactly the same. This includes 
the hidden file.Type30. Having different settings are recipe for lots of grief!

Finally, be forewarned that allowing testers/developers access to your 
production server via UV/Net is an EXTREMELY bad idea! (Career terminating if 
things go pear shaped when they have write/delete rights!). It is far too easy 
for these types of users to be unaware their test account is in fact pointing 
to your production service and there access is write/delete.

Did you try the UVNETRID environment variable in place of SET.REMOTE.ID? If you 
are still having issues, you may have to enabled UniRPC debugging which is very 
extensive and generate logs of data - but is useful for seeing exactly where 
things are going wrong.

Cheers,
David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 12 December 2013 2:23 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] UV/Net usage and licensing

Hi Everyone,

We’re looking at doing some remote file mangling and was wondering if there are 
any gotchas when using UV/Net to do this?

In my scenario if I am on host A and want to read/write files on host B. Host B 
only needs to read/write files on host B but not on host A. Do I need UV/Net on 
host A as well as host B or just on host A? Host A is running UV 10.3.4 and 
host B is running UV 10.2.6.

Local testing on host A to host A/DR shows record locking is working OK but if 
the remote file does not have read/write on ‘other’ (e.g. 660) then all writes 
fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the 
permissions to 666 is the only way I can get this to work even when using the 
same login and group membership at each end.

Also does anyone know if firewall ports other than standard unirpc port 31438 
need to be opened either end for bi-directional file access too please?

Regards,
Peter


Peter Cheney
Ultracs Developer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au
w firstmac.com.au


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Rocket releases UniVerse version 11.2.0

[Hona, David]

This has to be one of the most feature rich releases of UV for a long time. 
There are many new features and enhancements that we've been holding out for a 
long time...

Well done Dan & Rocket U2 team for the big effort for this huge release and the 
keeping U2/UV alive a kicking...

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Friday, 15 November 2013 4:39 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Rocket releases UniVerse version 11.2.0

If you haven't received an email already, I just wanted to let you all know we 
have released the next major version of the UniVerse Database today!

You can find out more from our website, or from my blog post here: 
http://blog.rocketsoftware.com/2013/11/the-universe-database-version-11-2-released
 

Cheers,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Brandon,

If you want to send one of your columns/fields in your  UV/SQL SELECT result to 
an active select list or saved list - within the same SQL query - you need to 
use 'TO SLIST' keyword option...

See the HELP SQL SELECT online for the limitations though.


For example:

To save the column/field " Y.INFO.packet.id" to select list 0:

select Y.INFO.packet.id TO SLIST 0

from X.INFO, Y.INFO

where X.INFO.packet.id=Y.INFO.packet.id

and X.INFO.status='ccc';


- OR-

To save the column/field " Y.INFO.packet.id" to a saved list named "MYSQLJOIN" 
in &SAVEDLISTS&:

select Y.INFO.packet.id TO SLIST "MYSQLJOIN"

from X.INFO, Y.INFO

where X.INFO.packet.id=Y.INFO.packet.id

and X.INFO.status='ccc';


Regards,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Wednesday, 28 August 2013 6:24 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select from one file with save-list from another file

Hello! 

 

UniVerse 10.1, HP/UX, Pick.

 

Is there a way I can build a save-list from a selection from one file X.INFO 
(where the record ID is an 8 digit number) and use that list to select from 
file Y.INFO (where that 8 digit number is not the record ID but does exist as a 
"foreign key" elsewhere in the file). In SQL this would be considered a join 
and would look something like this:

 

select *

from X.INFO, Y.INFO

where X.INFO.packet.id=Y.INFO.packet.id

and X.INFO.status='ccc';

 

I can run this in TCL and have it return the results I want but can't build a 
save-list from it because I don't know the UniVerse/SQL syntax to do so.

 

So to summarize, is there a way to use a save-list built from X.INFO to make 
another save-list comprised of the record ID's from Y.INFO?

 

Thanks for any advice you can give.

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Yes, Chuck a typo in the release number and much less capable than SQL style 
triggers...so a backwards step too. But far less overhead and drama to 
setup/maintain...



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Wednesday, 7 August 2013 7:58 AM
To: U2 Users List
Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using 
DEBUG or RAID with them? Was: Universe Triggers

@IDX.IOTYPE
Thanks to a fellow u2-list member who mailed me privately.
I think David Hona was maybe thinking of that,  but it's available at 11.1, not 
10.1.

Chuck

On 8/5/2013 6:23 PM, Perry Taylor wrote:
> Rocket added an @variable (don't recall the name of it) that tells which call 
> is being made.
>
> Perry
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
> Stevenson
> Sent: Saturday, August 03, 2013 9:40 AM
> To: U2 Users List
> Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty 
> using DEBUG or RAID with them? Was: Universe Triggers
>
> David,
>
> I didn't understand your 1st clause, "Now that (from UV10.1) 
> Index-based triggers are officially supported,...".
>
> By "index-based triggers",  I assume you mean the trick of indexing an 
> I-descriptor that calls a subroutine that updates some other file, 
> which is generally not the sort of thing you expect such a subroutine to do.
>
> What is this "official support"?  Did I miss an announcement, a change 
> in the documentation, or a whitepaper?
>
> And  by "support"  -  just to get my hopes up beyond all reason - does 
> that mean they've introduced some mechanism (@variable?) to help 
> distinguish among calls of the subroutine for insert (where indexing 
> calls the subroutine once, to find the new value to index) delete 
> (where indexing calls the subroutine 1x, to find the value to delete), 
> and change (where indexing calls the subroutine 2x, once with the old 
> version of the record, once with the new, to see whether the indexed 
> value has changed and, if so,  what to delete, what to add.
> Distinguishing these has always been tricky for the general case.
>
> Hope springs eternal,
> Chuck
>
> On 8/1/2013 12:32 PM, Hona, David wrote:
>> Now that (from UV10.1) Index-based triggers are officially supported, can 
>> these replace your SQL-based triggers? These have less functionality and 
>> less overhead, but that's the price you have to pay
>>
>> Can't say I had a chance to try it for myself...yet...!
>>
>>
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org 
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
>> Stevenson
>> Sent: Saturday, 27 July 2013 5:32 AM
>> To: U2 Users List
>> Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty 
>> using DEBUG or RAID with them? Was: Universe Triggers
>>
>> How many people avoid using triggers BECAUSE of the virtual impossibility of 
>> using RAID with Triggers?
>>
>> On 7/26/2013 12:33 PM, Phil Walker wrote:
>>> I won't be holding my breath Charles ;-)
>>>
>>> -Original Message-
>>> From: u2-users-boun...@listserver.u2ug.org
>>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
>>> Stevenson
>>> Sent: Friday, 26 July 2013 9:22 p.m.
>>> To: U2 Users List
>>> Subject: Re: [U2] Universe Triggers
>>>
>>> re. triggers & Raid,  I could not agree with Phil more.  Well said.
>>> Come on, Rocket!
>>>
>>> On 7/19/2013 1:32 AM, Phil Walker wrote:
>>>> Ken,
>>>>
>>>> I am glad you raised the issue about debugging a program with a file which 
>>>> has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
>>>> ages about fixing this pushing for the ability to be able to step into the 
>>>> trigger code, but at a VERY MINIMUM being able to debug the program and 
>>>> perform the write on the file, and in effect step over the trigger 
>>>> subroutine and carry on debugging. The issue is the trigger subroutine 
>>>> cannot support input, so what UV have done is basically say you are using 
>>>> the debugger so you are inputting debug commands so you will abort. They 
>>>> need to turn this restriction off for debugging so that either of the 
>>>> above two scenarios is supported.
>>>>
>>&g

Re: [U2] [UD] BASIC Code Failing

[Hona, David]

e the stamp of course.
>
> The stamps are always updated by my cutting routines and then the 
> items are then added to source control as part of the cut... If you 
> did something similar you can always diff what you've got against your 
> source code control system rather than reinventing the wheel.
>
> Brian
>
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
> Sent: 01 August 2013 10:49
> To: U2 Users List
> Subject: Re: [U2] [UD] BASIC Code Failing
>
> In UV we're had similar strange problems with seemingly unchanged 
> source/object code - not work as per normal and things going amiss for 
> no good reason...once we found the object code in BP and the catalog 
> space were mismatched and simply re-catalog'd it. Another time we 
> re-compiled a program
> - as it was always invoked via RUN BP PROGNAME... in both instances 
> the problem seem to go away.  This was in a controlled product 
> environment so it's in highly unlikely someone could of or would've
changed the code...
>
> In UV you can do a VCATALOG to verify the BASIC object to what is 
> actually catalogued...
>
> All of these issues made me wonder if our implementation routines need 
> to have a more robust. More robust in terms of storing some control 
> information for both pre/post verification - hence being able to 
> detect 'unauthorised changes' through the various stages. This could 
> include calculating and storing (say) MD5 (etc) hashes on the source 
> and object to cross verify changes. Hence, make it more easy to detect 
> object or source changes outside the authorised/control deployment 
> process... without having to go through every single file and 
> comparing to
tape or disk backups, etc., etc.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill 
> Haskett
> Sent: Wednesday, 31 July 2013 6:06 AM
> To: U2 Users List
> Subject: Re: [U2] [UD] BASIC Code Failing
>
> John:
>
> That's an interesting thought.  We do backups of the application 
> account every night, so I do have the last 10 days object code in a 
> backup (plus the last four months weekly backups).  I'll look at this 
> the next time it happens.  Thanks,
>
> Bill
> Untitled Page
>
>
> --
> --
> - Original Message -
> *From:* jhes...@momtex.com
> *To:* U2 Users List
> *Date:* 7/30/2013 11:01 AM
> *Subject:* Re: [U2] [UD] BASIC Code Failing
>> I would also consider the possibility of data corruption at the 
>> hardware level.  Granted, I would expect that you'd also occasionally 
>> find anomalies within your source code and data files if this were 
>> the case, but I don't know how your filesystems are set up.  If the 
>> object code has become corrupt, that would explain why recompiling 
>> fixes the problem.  The newly created object code will be stored on a 
>> new location in the filesystem.  Fortunately this possibility is very 
>> easy to test for.  Just make a copy of your application account on 
>> alternate storage and wait for the problem to recur.  When it does, 
>> open the live object file and your backup copy in an editor with diff 
>> capability (Notepad++ is a good one) and see if they still match.
>>
>> -John
>
> ** IMPORTANT MESSAGE * This 
> e-mail message is intended only for the addressee(s) and contains 
> information which may be confidential.
> If you are not the intended recipient please advise the sender by 
> return email, do not use or disclose the contents, and delete the 
> message and any attachments from your system. Unless specifically 
> indicated, this email does not constitute formal advice or commitment 
> by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 
> 124)
or its subsidiaries.
> We can be contacted through our web site: commbank.com.au.
> If you no longer wish to receive commercial electronic messages from 
> us, please reply to this e-mail by typing Unsubscribe in the subject line.
> **
>
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UD] BASIC Code Failing

[Hona, David]

In UV we're had similar strange problems with seemingly unchanged source/object 
code - not work as per normal and things going amiss for no good reason...once 
we found the object code in BP and the catalog space were mismatched and simply 
re-catalog'd it. Another time we re-compiled a program - as it was always 
invoked via RUN BP PROGNAME... in both instances the problem seem to go away.  
This was in a controlled product environment so it's in highly unlikely someone 
could of or would've changed the code...

In UV you can do a VCATALOG to verify the BASIC object to what is actually 
catalogued...

All of these issues made me wonder if our implementation routines need to have 
a more robust. More robust in terms of storing some control information for 
both pre/post verification - hence being able to detect 'unauthorised changes' 
through the various stages. This could include calculating and storing (say) 
MD5 (etc) hashes on the source and object to cross verify changes. Hence, make 
it more easy to detect object or source changes outside the authorised/control 
deployment process... without having to go through every single file and 
comparing to tape or disk backups, etc., etc.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Wednesday, 31 July 2013 6:06 AM
To: U2 Users List
Subject: Re: [U2] [UD] BASIC Code Failing

John:

That's an interesting thought.  We do backups of the application account every 
night, so I do have the last 10 days object code in a backup (plus the last 
four months weekly backups).  I'll look at this the next time it happens.  
Thanks,

Bill
Untitled Page



- Original Message -
*From:* jhes...@momtex.com
*To:* U2 Users List 
*Date:* 7/30/2013 11:01 AM
*Subject:* Re: [U2] [UD] BASIC Code Failing
> I would also consider the possibility of data corruption at the 
> hardware level.  Granted, I would expect that you'd also occasionally 
> find anomalies within your source code and data files if this were the 
> case, but I don't know how your filesystems are set up.  If the object 
> code has become corrupt, that would explain why recompiling fixes the 
> problem.  The newly created object code will be stored on a new 
> location in the filesystem.  Fortunately this possibility is very easy 
> to test for.  Just make a copy of your application account on 
> alternate storage and wait for the problem to recur.  When it does, 
> open the live object file and your backup copy in an editor with diff 
> capability (Notepad++ is a good one) and see if they still match.
>
> -John


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Now that (from UV10.1) Index-based triggers are officially supported, can these 
replace your SQL-based triggers? These have less functionality and less 
overhead, but that's the price you have to pay

Can't say I had a chance to try it for myself...yet...!



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Saturday, 27 July 2013 5:32 AM
To: U2 Users List
Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG 
or RAID with them? Was: Universe Triggers

How many people avoid using triggers BECAUSE of the virtual impossibility of 
using RAID with Triggers?

On 7/26/2013 12:33 PM, Phil Walker wrote:
> I won't be holding my breath Charles ;-)
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
> Stevenson
> Sent: Friday, 26 July 2013 9:22 p.m.
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
>
> re. triggers & Raid,  I could not agree with Phil more.  Well said.
> Come on, Rocket!
>
> On 7/19/2013 1:32 AM, Phil Walker wrote:
>> Ken,
>>
>> I am glad you raised the issue about debugging a program with a file which 
>> has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
>> ages about fixing this pushing for the ability to be able to step into the 
>> trigger code, but at a VERY MINIMUM being able to debug the program and 
>> perform the write on the file, and in effect step over the trigger 
>> subroutine and carry on debugging. The issue is the trigger subroutine 
>> cannot support input, so what UV have done is basically say you are using 
>> the debugger so you are inputting debug commands so you will abort. They 
>> need to turn this restriction off for debugging so that either of the above 
>> two scenarios is supported.
>>
>> In a Microsoft world I can debug anything through the connected world of 
>> web/databases etc..
>>
>> Have had no feedback from UV
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org 
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
>> Sent: Friday, 19 July 2013 9:48 a.m.
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] Universe Triggers
>>
>> Dan,
>> In addition to the other responses you have received, I suggest the 
>> following:
>> 1. Have one master file trigger subroutine (globally catalogued) that calls 
>> subroutines (locally catalogued) tailored to individual files.  This means 
>> you don't have to stop and restart Universe when a new trigger is required 
>> or a change to an existing one.  If the master subroutine changes, you do 
>> have to restart Universe.
>> 2. Use a control record that records the subroutine name and state of the 
>> trigger for each file having a trigger.
>> 3. Use a program to change the state of a trigger, using the control records 
>> in 2 above.
>> 4. Make sure all background processes that have a file with a trigger open 
>> are logged out when recompiling the subroutine for that file trigger.
>> 5. Remember that you can't do anything to a file with an active trigger 
>> whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
>> file trigger subroutine, drop the trigger and use a trigger testing program 
>> that calls the subroutine after taking a copy of the record being changed, 
>> pausing whilst you change it in another session, and then resuming, calling 
>> the subroutine.
>>
>> If you would like samples of any of the software mentioned above, let me 
>> know, and I can send them to you.
>>
>> Regards,
>> Ken Ford
>> Universe Software Developer
>> t 07 3013 8605 | f 07 3002 8400
>> e ken.f...@firstmac.com.au | w firstmac.com.au
>

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Regardless of the toolset, the first hurdle would be to normalise your database 
to look like a relational one. Which is likely to be the greatest hurdle. Data 
dictionaries in U2/PICK are optional are a purely for reporting purposes - they 
can have duplicates and these can be conflicting. Even worse (as if you thought 
it could be) - data dictionaries can be incomplete or wrong. This added to the 
lack of enforcement of data integrity and constraints usually causes these 
toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck!

Rocket released U2 Metadata Manager to assist in this respect and is designed 
to allow forward and backwards capability. Although, support for this in UV is 
limited to the latest official release... so your alternative is UV/ODBC...

For UV/ODBC users - I have always recommended a separate UV account and data 
dictionary that is spotless. For some this is the best option - why go against 
the flow - when you create your own stream...


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lynette LeDoux
Sent: Tuesday, 16 July 2013 5:45 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UML mapping tool for MV (UniVerse)

Hello all.

The call has come to locate possible data modelling tools (UML) that could 
potentially would connect to our UniVerse system.
Ideas?

L2
(Lynette LeDoux)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
u2-users-requ...@listserver.u2ug.org
Sent: Monday, July 15, 2013 2:00 PM
To: u2-users@listserver.u2ug.org
Subject: U2-Users Digest, Vol 51, Issue 13

Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org

To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
or, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org

You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org

When replying, please edit your Subject line so it is more specific than "Re: 
Contents of U2-Users digest..."


Today's Topics:

   1. Re: Mobile phones (Symeon Breen)
   2. Re: [ANN] FOSS4MV - Free & Open Source Software for the MVDB
  world (Daniel McGrath)
   3. SORT reports line length, change right margin? (randyleesmith)
   4. Re: SORT reports line length, change right margin?
  (Anthonys Lists)
   5. Re: SORT reports line length, change right margin? (Don Robinson)
   6. Re: Mobile phones (Bill Haskett)
   7. Re: SORT reports line length, change right margin? (randyleesmith)
   8. Re: SORT reports line length, change right margin? (Bill Haskett)
   9. Re: SORT reports line length, change right margin? (Wols Lists)
  10. Re: SORT reports line length, change right margin? (randyleesmith)
  11. Re: SORT reports line length, change right margin? (Wols Lists)
  12. Re: SORT reports line length, change right margin? (randyleesmith)
  13. Re: SORT reports line length, change right margin? (Wols Lists)


--

Message: 1
Date: Mon, 15 Jul 2013 13:20:14 +0100
From: "Symeon Breen" 
To: "'U2 Users List'" 
Subject: Re: [U2] Mobile phones
Message-ID: <004d01ce8155$a9f67e30$fde37a90$@gmail.com>
Content-Type: text/plain;   charset="us-ascii"

Thanks everyone for your information.





--

Message: 2
Date: Mon, 15 Jul 2013 14:25:42 +
From: Daniel McGrath 
To: U2 Users List 
Subject: Re: [U2] [ANN] FOSS4MV - Free & Open Source Software for the
MVDB world
Message-ID:
<61ef3a8534e14d709dffdc5bd2f27...@den-vm-mbx3.rocketsoftware.com>
Content-Type: text/plain; charset="iso-8859-1"

Thanks Tony & Kevin!

Unhappy to see we both ended up on different platforms (GitHub & BitBucket) 
which means people would need to learn 2 different sites, but ecstatic to see 
we both ended up using Git which means people really only need to learn 1 tool 
chain to be able to work with both.

Cheers,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software
4600 South Ulster Street? ?? Suite 1100? ??? Denver, CO 80237 ?? USA
T: +1 720 475 8098 ? E: dmcgr...@rocketsoftware.com ? W: u2.rocketsoftware.com




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Saturday, July 13, 2013 5:47 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [ANN] FOSS4MV - Free & Open Source Software for the MVDB world

Posted for Kevin Powick
===

Fellow developers,

I'm happy to announce a new resource for MVDB developers. FOSS4MV!

FOSS4MV is a community for people that use or develop Free and Open Source 
Software for MVDB platforms, such as D3, OpenQM, jBASE, U2, Reality, Cache, 
etc. As such, it has three major offerings to promote c

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

[Hona, David]

Ah, yes - we used in AIX6.1 :)
It was the older AIX5.x environments it wasn't there...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Thursday, 11 July 2013 3:54 PM
To: U2 Users List
Subject: Re: [U2] Writing to a Windoz box from Universe

AIX 6.1 does have it built in.
I think 5.2 ML12 might also include the ability to mount CIFS shares

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Thursday, 11 July 2013 10:39 AM
To: U2 Users List
Subject: Re: [U2] Writing to a Windoz box from Universe

Last time I checked, AIX has no native built-in capabilities to mount 
CIFS/Windows shares.

1. Samba/AIX port - open source
If you wish to load the Samba port to AIX, you can use smbclient to perform an 
"sftp/ftp" like connection that'll mount the share temporarily - then you can 
get/put the file(s), etc.

2. FastConnect - IBM supported
If you use IBM's FastConnect for AIX - you have to mount the share as a 
filesystem first - as smbclient is not supported unfortunately.

Both solutions - of course - require a Windows account to connect to the 
Windows server and it must have sufficient rights on that share/filesystem to 
write/read/delete files, etc.

Having a Windows share mounted "all the time" can be a security risk - 
especially if using generic Windows accounts with "too much rights".

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd
Sent: Thursday, 11 July 2013 5:43 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Writing to a Windoz box from Universe

I simply want to write a filename to a Windoz server from an IBM box running 
AIX.  What is the simplest method?  I would like to avoid ftp.  Been there, 
done that!

Thanks!

Boyd

Boyd Parks
MDIV ERA Programmer/Analyst

770.237.7541
770.975.3303 (cell)
770.237.6541 (fax)

McKesson
Business Performance Services
www.mckesson.com<http://www.mckesson.com>


** IMPORTANT MESSAGE * This e-mail 
message is intended only for the addressee(s) and contains information which 
may be confidential.
If you are not the intended recipient please advise the sender by return email, 
do not use or disclose the contents, and delete the message and any attachments 
from your system. Unless specifically indicated, this email does not constitute 
formal advice or commitment by the sender or the Commonwealth Bank of Australia 
(ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please 
reply to this e-mail by typing Unsubscribe in the subject line.
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
Message  protected by DealerGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.pentanasolutions.com

Click here to report this message as spam:
https://login.mailguard.com.au/report/1HxsMXL8TR/2RPtkBcfWCsuqIZuZ7iELX/0.2


This email and any attachments to it are confidential.
You must not use, disclose or act on the email if you are not the intended 
recipient.  Liability limited by a scheme approved under Professional Standards 
Legislation.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Last time I checked, AIX has no native built-in capabilities to mount 
CIFS/Windows shares.

1. Samba/AIX port - open source
If you wish to load the Samba port to AIX, you can use smbclient to perform an 
"sftp/ftp" like connection that'll mount the share temporarily - then you can 
get/put the file(s), etc.

2. FastConnect - IBM supported
If you use IBM's FastConnect for AIX - you have to mount the share as a 
filesystem first - as smbclient is not supported unfortunately. 

Both solutions - of course - require a Windows account to connect to the 
Windows server and it must have sufficient rights on that share/filesystem to 
write/read/delete files, etc. 

Having a Windows share mounted "all the time" can be a security risk - 
especially if using generic Windows accounts with "too much rights". 

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd
Sent: Thursday, 11 July 2013 5:43 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Writing to a Windoz box from Universe

I simply want to write a filename to a Windoz server from an IBM box running 
AIX.  What is the simplest method?  I would like to avoid ftp.  Been there, 
done that!

Thanks!

Boyd

Boyd Parks
MDIV ERA Programmer/Analyst

770.237.7541
770.975.3303 (cell)
770.237.6541 (fax)

McKesson
Business Performance Services
www.mckesson.com


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Auto Starting Applications

[Hona, David]

Yes, this was a problem - but I haven't recently tried to execute UV11 and 
cron. UV11 has a different shared memory model - inherited from UD - in 
comparison to older releases. 

A quick test shows that phantom processes are getting their own shared memory 
segment under UV11. 

So - at first glance - it appears no longer to be an issue from UV11 onwards. 

Dave Church's uvcron.c program was the solution in the past/now to help for 
those still waiting to user cron or similar scheduling tool...with uv.

http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker
Sent: Thursday, 11 July 2013 9:23 AM
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications


You should use uvsh rather than uv and you also need to consider multiple cron 
jobs running as the same user at the same time as Universe does not like this 
or never used to at least.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 11 July 2013 10:51 a.m.
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications

You can certainly launch a UV process from a unix script.
e.g.

#!/usr/bin/bash
cd /$path_to_uv_account/$ACCOUNTNAME
$UVHOME/bin/uv "phantom PROGRAMNAME" >> /somedir/log1.txt $UVHOME/bin/uv "LIST 
SOMEFILE DICTITEM1 DICTITEM2" >> /somedir/log2.txt

You can call this from cron too if required.

Cheers
Peter


Peter Cheney

Universe Engineer

t 07 3017 8837 | f 07 3002 8400

e peter.che...@firstmac.com.au | w www.firstmac.com.au




From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King 
[ke...@precisonline.com]
Sent: Thursday, 11 July 2013 8:34 AM
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications

Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d 
(depending on Linux)?


On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor wrote:

> What techniques are you folks using to start up apps when UniVerse on 
> Linux is started?  Obviously hooking into uv.rc is an option.  Are 
> there others?
>
> Thanks.
> Perry

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Flip Case command?

[Hona, David]

TCL: PTERM -CASE INVERT
BASIC: TTYSET

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Saturday, 6 July 2013 7:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Flip Case command?

Does anyone know of an internal command of any sort that will allow one to flip 
the case of some input stream ?  That is, not just make it all lower case or 
all upper case, but actually make all lower case input upper, AND at the same 
time all upper case input lower.

That is truly flip the case of each input character ?

I'm going to write my own, unless someone has one.

Thanks
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Running total

[Hona, David]

You can also see what the I-type does by 

DLIST yourfile yourdictitem

It's the equivalent of VLIST for I-Types...


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 4 July 2013 9:48 AM
To: U2 Users List
Subject: Re: [U2] Running total

I believe the expression in the second example is referred to as a compound 
expression?

Can't put my finger on the exact documentation but I seem to recall that 
compound expressions are broken up into "parts" (for want of a better term) 
delimited by a ';' and each "part" can be referenced throughout the entire 
expression by an @ number e..g. @1 refers to the first part and the nth part is 
@n etc.

So for:
LIST VOC SIZE EVAL "SIZE + @2;@"

My take on how this works is the the first part of the expression (SIZE + @2) 
can be referenced later on as @1, The second part is referenced as @ (instead 
of @2) and I believe is used to refer to the result of the entire expression 
(sum of all the parts).

Can @ in this case also be referenced as @2? It probably could but would break 
the expression.

Therefore the reference to @2 is causing the expression to grab the entire 
result using contents of @ (via @2 thus keeping it separate to @) and add it to 
SIZE which then becomes the new result (@) of the expressions and the whole 
thing is repeated.

Does that sound about tight? Or have I got it way wrong?

Cheers
Peter




Peter Cheney

Universe Engineer

t 07 3017 8837 | f 07 3002 8400

e peter.che...@firstmac.com.au | w www.firstmac.com.au




From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com]
Sent: Thursday, 4 July 2013 7:31 AM
To: u2-users@listserver.u2ug.org; donr_w...@yahoo.com
Subject: Re: [U2] Running total

Can anyone explain this situation better.  I've only ever used the @ to 
simplify a few I-descriptors.

I have a dict item SIZE that is just the LEN(@RECORD)

So in this thread we've seen two EVAL solutions to a running total

LIST VOC SIZE EVAL "@1+SIZE"
LIST VOC SIZE EVAL "SIZE + @2;@"

In the first example is the @1 just saving the "previous result of THIS eval ?"

And then in the second example does the fact that SIZE is first in the Eval, 
effectively *push* the accumulator into position two or something?  So that's 
why you need @2 ?

And then what would be the meaning of ";@" at the end of that?

Pretty confusing stuff!


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Dan

What's new in UV11.2 beta? Or is that not yet public yet? As per the private 
beta test... :)


Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Monday, 20 May 2013 11:40 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] UniVerse v11.2 private beta starting next week!

Drop a line to u2as...@rs.com or your support partner if you want in. Spots are 
limited.


Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] canon ir4025 printer on redhat

[Hona, David]

UniVerse admin guide details printing options. 
Using the admin tools won't setup remote network interfaces by default.
Hence, in unix you need to write/use the a UV spooler driver Unix script 
interface.

From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley 
[dalekel...@dalewkelleyinc.com]
Sent: Friday, 3 May 2013 8:00 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] canon ir4025 printer on redhat

I have a customer who just got a Canon ir-4025 copier/printer/everythingelse.
Unable to find a linux driver I downloaded a product called BrightQPro which
allowed me to install the printer on the redhat system.  I can print using
lp or lpr, I can print web pages and from Office, but UniVerse cannot see
the printer: "Requested printer does not exist".  Has anybody used these
products, I have done everything I could think of about 7 times.

Thanks



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/canon-ir4025-printer-on-redhat-tp40657.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] History of Prime Information

[Hona, David]

Ah, I recall Prime small mini-tower (under the desk) AT&T System V boxes too 
-the EXL 300 series which ran a re-branded version of UniVerse (PI/EXL I 
think). 

This was rolled out before the EXL 7000 series which were MIPS RISC/os based 
servers.   I vaguely recall Prime was looking at Silicon Graphics and Sequent 
(the latter was bought by IBM)

When PI/Open finally arrived it was great, but the loss of the Primos Batch 
subsystem and spooler was a bit of a culture shock and required some 
rewrites...Prime tried to port their Batch and Spooler products to UNIX (not 
that successfully as I recall!).

UV at the time was a giant step backwards for Prime INFORMATION users in many 
respects but the catch the fact it got you off very old, slow expensive 
hardware. :)  But even then they weren't cheap (by today's standards)... 
http://www.cbronline.com/news/prime_adds_to_exl_line_pick_netware_on_all_its_unix_kit
 

For those interested the demise of Prime/CV is documented in these links 
partially documented here:
http://www.fundinguniverse.com/company-histories/computervision-corporation-history/

I recall a story from some ex-Prime employees that ponder where Prime would be 
today...if only they purchased another company instead of Computervision...that 
company was Sun Microsystems... probably still in the same place! :)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, 29 April 2013 6:59 PM
To: 'U2 Users List'
Subject: Re: [U2] History of Prime Information

I think prime and vmark had done business together hence why the purchase -

 I remember back in 92/93  when we had a pair of prime 1920's (I think) running 
prime information, we then got a new prime unix box, that was actually a 
rebadged MIPS running Riscos,  they said at the time that PI+ the new version 
of Information for unix was not quite ready but they would supply universe 
version 1 for free while they finished it off.  Going from prime information to 
uv v1 was like taking a backward step, and we found a load of bugs in uv, esp 
with the locking tables, and deadlocks etc.  Anyway
we eventually got PI+   but I think it was just after that that Prime went
out of business, we also used the CAD software, so we took the
computervision CAD and ended up with PI+   but supplied by universe.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: 27 April 2013 14:54
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] History of Prime Information

On 27/04/13 05:26, Wjhonson wrote:
> Okay but let's just talk about 1990-1993 How did Computer Vision 
> exactly get its hands on Prime Information ?
> This happened *before* the final bankruptcy  of Prime?
> Or did somehow Prime sell or spin off Computer Vision with Prime
Information as well?

iirc they didn't. Computer Vision did a sort of reverse buyout, taking Prime's 
CAD business with it. INFORMATION was sold to Vmark, and the hardware business 
was sold to ?Pericom?

That might be why Pr1mos has ended up in copyright limbo. There was a "White 
Knight" involved in this, so I'm guessing that the breakup and sale was along 
the lines of "PI to Vmark, software to Computer Vision, and hardware and 
support to this other company". With the result that it wasn't clearly 
specified who got the copyrights to Pr1mos and now nobody can do much with it 
because they don't know who actually owns it...
> 
> Enquiring minds want to know
> 
Well, I might not be much good at enlightening, but I was around as a customer 
when it all happened ...

Cheers,
Wol

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2241 / Virus Database: 3162/5776 - Release Date: 04/26/13

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



_

Re: [U2] UV Creating a Soap Request

[Hona, David]

Oops, yes - sorry for my misleading reply regarding the URIs. Tempui.org is a 
valid placeholder and you don't need to replace it.

Have you tried now SOAPAction and what error do you get then?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Wednesday, 17 April 2013 9:24 AM
To: U2 Users List
Subject: Re: [U2] UV Creating a Soap Request

Thanks again David and Symeon for your replies

I thought the SOAPAction was correct but now am not sure.
If I browse to the WSDL schema I see the following spec though.
Would this mean the 'tempuri.org' should be replaced with 'our-dev.domain.com' 
in the WSDL too?


   http://tempuri.org/IJobService/CreateJob1UserPartyRole"; 
style="document"/>
   
  
   
   
  
   


I went and checked out the www.webservicex.net site (from the e.g. below) and 
looking in there and comparing to what I had and they seem to be pretty much a 
match except for the domain part of the SOAPAction.

So perhaps I need to look elsewhere? There seems to me to be only 3 variables 
at play here: The URL, the SOAPAction, and the XML request. Given that I've 
just finished fiddling with the URL and SOAPAction with no apparent change in 
the log output I'll turn my attention to the XML ...

One other question is it possible to query the WSDL from UV?

Cheers
Peter


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] is this an INDEX ISSUE?

[Hona, David]

Hello David

1) Is your file you're indexing corrupt or does it have any errors or warnings 
as reported by 'fixtool'? If corrupt, can you repair it (after backing it up:)) 
?
2) What queries using the indices are slow? All or one?
3) What UV release?
4) How and when do you re-index the file? 
5) Has the file been recently been resized/restored or otherwise "changed"?

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of david yu
Sent: Saturday, 13 April 2013 9:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] is this an INDEX ISSUE?

hello,
 
We have a file that is updated almost every minute for transportation 
appointment, we index a field in a file to make the reporting much faster but 
recently we noticed when we ran the report not all the transportation appt 
shows up on the report, so customer doesnt get their transportation. We have 
been rebuilding the index every night but problem still exists. Anyone 
encounter this issue? we are on HP-UX b.11.23.
 
thanks in advance.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV Creating a Soap Request

[Hona, David]

Hi Peter

Is your SOAPAction correct?? 

The tempURI.org is a Microsoft standard placeholder - usually replaced by a 
proper URI or hostname name, etc.

SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Tuesday, 16 April 2013 4:14 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] UV Creating a Soap Request

Hi Everyone,

Recently I had some success getting a secure version of this to work etc. but 
now "they" want to change it to non-SSL so am trying to get plain old http to 
work.

Using this example as a starting point: 
https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api

I've managed to (I think) translate the example above with our URL and soap 
action etc. but I have a question regarding the UV SOAPCreateRequest and hope 
someone may be able to assist.

The URL I specify in SOAPCreateRequest is 
http://our-dev.domain.com/apps/jobs/Services/Job.svc

However in the log file I get:
04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request:
POST /apps/jobs/Services/Job.svc HTTP/1.1
Date: Tue, 16 Apr 2013 05:05:16 GMT
Host: our-dev.domain.com
SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole
User-Agent: IBM UniVerse 11.x
Content-Type: text/xml; charset=utf-8
Content-Length: 1670

The POST seems to be missing the first part of the URL and with the response 
being a "400 bad request" I'm wondering if there's anything I can do to force 
the complete URL?
In particular is there a SOAP command that I'm missing? Briefly I do the 
following in this order:
Ret = setHTTPDefault( "VERSION" , "1.1" ) Ret = SOAPSetDefault( "VERSION" , 
"1.2" ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = 
SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( 
SoapReq, Timeout, RespHeaders, RespData, SoapStatus )

The return codes from above are:
setHTTPDefault result = 0
SOAPSetDefault result = 0
SOAPCreateRequest result  = 0
SOAPSetRequestContent result  = 0
SOAPSubmitRequest result  = 0

The SoapStatus from SOAPSubmitRequest above is:
Response status   : 400▒Bad Request

The RespHeaders returned from SOAPSubmitRequest above is:
Response headers  : 
Cache-Control▒private▒Server▒Microsoft-IIS/7.5▒X-Powered-By▒4.0.30319▒X-Powered-By▒ASP.NET▒Date▒Tue,
 16 Apr 2013 05:46:06 GMT▒Content-Length▒0

To me the soap action seems good and the xml in the payload looks ok too so it 
has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3.

Reckon I must be missing something above so looking at the basic ref manual but 
it does not indicate if any of the soap commands therein and the above have 
other dependencies/pre-requisites and in what order they should occur. I guess 
a prior soap knowledge is expected but I'm just starting to get into this so if 
anyone can assist that'd be really helpful thanks.

Cheers
Peter


 ---
Note: 
This email (inc all attachments) is for the use of the intended recipient(s) 
only.
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then delete all copies of this message from your computer network. If you 
are not the intended recipient, you must not keep, use, disclose, copy or 
distribute this email without the author's prior permission. If you are the 
intended recipient and you do not wish to receive similar electronic messages 
from us in future, then please respond to the sender to this effect. 
We have taken precautions to minimise the risk of transmitting software 
viruses, but advise you to carry out your own virus checks on this email and 
its attachments. We do not accept liability for any loss or damage caused by 
software viruses and do not represent that this transmission is free from 
viruses or other defects. 
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
 ---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive 

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

[Hona, David]

First up - Adobe PDF is a subset of the Adobe Postscript page description 
language (PDL). 

Some printer vendors have Postscript emulations. Most business class laser/LED 
printers or multi-function devices (MFDs) today have intelligent page 
description language detection built in and typically analyse the datastream 
before attempting to do anything with it...mean that they can switch between 
plain text from UniVerse or UNIX or PDF/Postscript or HP PCL / PXL formats and 
others on-the-fly...

Some modern printers have Adobe PDF and Adobe Postscript (or an emulation) 
built-in. Meaning they can be sent files in either format. . (Side note - 
Google: "PDF Direct Print support").

If you have printers are capable of accepting Adobe PDF files - then just 
simply "submit" an those files direct to the printer from your host.

If your printer has Adobe Postscript or a Postscript emulation - you translate 
the PDF data file into 'native' Postscript via Ghostscript or similar toolset 
prior to sending it to the printer.

If you don't have any Postscript capable printers - you can - using Ghostscript 
translate the file from PDF into HP PCL or similar PDL (many are supported). 
Then send the generated output to your printer queue.

You can write custom version of the Ghostscript supplied 'ps2pdf' script to 
generate to PCL file from an Postscript file (and call the script, say 
"ps2pcl"). It's not difficult to customise this scripts for your own output 
device (printer, image file, etc)... have done this before...

As implied by others - you won't have the same capabilities nor any options to 
dynamically or selectively control over the output (orientation, N-up printing, 
duplex, tray selection, page-fit, paper type, copies, page range, etc)... that 
you can perform from Windows Acrobat PDF viewer. An alternative to this is to 
perhaps utilise one or more host-based printer print queue defined for (some of 
these may be feasible) such printing preferences, etc. HPJetDirect for HPUX and 
other UNIX platforms is pretty feature rich especially when talking with 
HPDirectJet printers...

See what Adobe has on this issue here: 
http://www.adobe.com/products/postscript/pdf.html 

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac 
LTD
Sent: Friday, 5 April 2013 2:54 AM
To: 'U2 Users List'
Subject: [U2] How do you print a ".pdf" from inside a Unix Box

I may have missed this discussion but if someone can help me that would be 
great.

We have been executing a SB command to windows to open Adobe and print the PDF 
document. We would like to either not have to open Adobe and print the document 
or print the document from within our Unix box.

We have a hp7640 11iv3 running on an Itanium processor.

Here is the Unidata information:
Module Name Version   Licensed
  
UniData RDBMS 7.2 Yes 
Connection Pooling... 7.2 No  
Device License... 7.2 No  
NFA.. 7.2 No  
RFS.. 7.2 No  
EDA.. 7.2 No  
721   


Oh, love this list, I have been using Pick since 1985 and still going strong.

Bruce

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Adrian

The SYS.MESSAGE file has all the system messages...

DAVID: CT SYS.MESSAGE 010252

 010252
0001 Message %i is either invalid or not found in the SYS.MESSAGE file.
0002

I have no idea what it really means. I'd check if that particular has an 
existing UV process and has a pre-existing shared memory segment for a start... 
(likely to be unrelated)... this is not a UV process executing via crontab is 
it??

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs
Sent: Thursday, 4 April 2013 12:04 PM
To: U2 Users List
Subject: [U2] [uv] Message[010252]

I am getting the above obscure error message when a particular user tries to 
invoke the uniVerse environment /usr/lpp/uv/bin/uv AIX v5 and uniVerse 10.1.22 
can anyone please help me by telling me what this means?
Or better yet how I can find out for myself?

Sent from my iPhone
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

You're welcome Peter. Sounds like you're past first base (communications OK) 
and now the challenge is handing the XML data exchanges. That will be fun!
Will you use be the UV BASIC XML DOM routines?  


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Wednesday, 6 March 2013 11:37 AM
To: U2 Users List
Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP

Hi again,

Finally had a chance to get back to this and have had success using a slightly 
modified version of the code here:
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html

After reviewing David's suggestions below and confirming the certificate 
requirements, the only areas requiring change were the URL (to the https url we 
had set up), and the path to where our client certificate accessible by UV 
(e.g. /opt/uv/certificates/Client-Root.cer)

This brought some success as I was at least getting a response from the 
webserver but it was an error code 415 indicating incorrect mime type.
e.g. "415 Cannot process the message because the content type 
'application/x-www-form-urle".
 (the output is truncated but is just enough to get an idea of what is wrong)

Then I discovered that the http_method parameter for 'POST' in the 
createSecureRequest function has a default mime type of 
"application/x-www-form-urlencoded" so I changed the HTTP.POST variable from 
"POST" to "POST:application/soap+xml".

Hey presto! Now I get this reply from the webserver:
e.g.

ResponseHeaders : Content-Length▒518▒Content-Type▒application/soap+xml; 
charset=utf-8▒Server▒Microsoft-IIS/7.0▒X-Powered-By▒ASP.NET▒Date▒Tue, 05 Mar 
2013 23:41:35 GMT
ResponseData: http://www.w3.org/2003/05/soap-envelope"; 
xmlns:a="http://www.w3.org/2005/08/addressing";>http://tempuri.org/IJobService/CreateJob1UserPartyRoleResponseurn:uuid:5af711cc-4ed3-4208-baa1-48aa9f74af60http://tempuri.org/";>513682af531c9e1090b67f20
HttpStatus  : 200  OK 

Many thanks again to David and Symeon for their assistance in this.

Cheers
Peter

PS My code at this stage is only a prototype and is functionally the same as 
the example in the URL above but if anyone would like a copy then please let me 
know.

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Peter,



You easily change that sample source code try amending these lines to access 
any SSL webserver/appserver.



For example the Firstmac.com.au website using SSL by default I see - so that'll 
be a good site to use as an worked example - that uses a CA Root certificate.



Basically,  all you'll need a copy of you GeoTrust's root certificate 
accessible by your (UV SOAP/HTTP) client application.



You must upload this (or any other SSL certificate) to your UV host and tell 
you UV application where it can be found...



* Assumes client host can resolve and access this URL

* For HTTPS SSL www.firstmac.com.au is using GeoTrust CA certificates, hence 
upload a DER copy of it first.

URL = "https://www.firstmac.com.au/home";

* Define the full path to the GeoTrust CA Root certificate, uploaded to the 
host (exported in DER format)

X.CERT.PATH=@PATH:"/geotrust.cer" ;* Full path to a DER copy of GeoTrust CA 
Root Certificate
X.USED.AS="2"  ; * 1=Self-signed, 2=CA Issued certificate
X.FORMAT="2"   ; * DER format
X.ALGORITHM="1"; * RSA key


Hope this helps. The CA Root SSL certificate business is complex and is part of 
that steep learning curve!

Good luck!



Cheers,
David







-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 21 February 2013 11:44 AM
To: U2 Users List
Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP



Hi David,



Thanks for the url - am going through this now and the accompanying log.

It seems the "host not found in hostlist" error is not an issues so will 
continue investigating other causes.

I do believe the answer will lie somewhere in my own malformed request so just 
need to work it out I guess.

Will post updates as this progresses.



Many thanks,

Cheers

Peter





-Original Message-

From: 
u2-users-boun...@listserver.u2ug.org<mailto:u2-users-boun...@listserver.u2ug.org>
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David

Sent: Wednesday, 20 February 2013 20:17

To: U2 Users List

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



Peter,



As Symeon mentioned, protocol logging is required to help troubleshoot issues.



If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes 
on behind the scenes - but only once you have familiarised yourself with the 
basic concepts of the HTTP protocol. Otherwise, not much will make much sense...



The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP 
going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this 
URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html



We cloned this code for a proof of concept and our version worked for us (if I 
recall correctly)...



Obviously (maybe not), this is sample code in the URL will not actually work 
anymore - if actually did all those years ago (I can't recall) but it 
should give you a "heads-up" so to speak and point you in the right direction 
(more or less - hopefully more!)...



Regards,

David





** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Peter,

As Symeon mentioned, protocol logging is required to help troubleshoot issues. 

If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes 
on behind the scenes - but only once you have familiarised yourself with the 
basic concepts of the HTTP protocol. Otherwise, not much will make much sense...

The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP 
going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this 
URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html

We cloned this code for a proof of concept and our version worked for us (if I 
recall correctly)...

Obviously (maybe not), this is sample code in the URL will not actually work 
anymore - if actually did all those years ago (I can't recall) but it 
should give you a "heads-up" so to speak and point you in the right direction 
(more or less - hopefully more!)...

Regards,
David


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Thanks Brian - that sounds great! I would be keen to get a trial version, once 
you have a SSH capable version.

How is the product licensed?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, 5 February 2013 10:14 PM
To: 'U2 Users List'
Subject: Re: [U2] U2 Test Tools for system/unit & regression testing 
w/integration with HP QualityCenter

Hi David

I've recently released a testing product called (predictably!) mvTest.

This supports automated testing of U2 applications using a dedicated scripting 
language modelled after UniBasic for familiarity but with a number of key 
extensions to handle data validation, test data handling, UI scripting and 
assertions. 

You can use this to create unit tests, UI tests (currently TELNET and 
U2-compatible secure TELNET/SSL but with SSH to follow shortly), regression and 
volume tests.

Here's a quick overview of how it works -

- You create unit or UI tests using the scripting language. These can be run 
through either of a Windows client or through a server-side script runner e.g. 
if you want to perform CI testing through a phantom. There's a nice Windows 
based editor to create, organize and test these.

- The tests return pass or fail information based on assertions, so you can see 
at a glance if anything has broken. You can save the information and run 
various reports against it.

- The tests can run direct against the database through a UO.NET connection 
(e.g. for testing subroutine calls and parameters) or through a terminal-style 
UI. It embeds a complete terminal emulator with all the necessary functions, 
and this allows you to drive screens, perform spot checks, branch on different 
results (e.g. handling error messages raised from your screens), handle 
send/expect style scripting and more complex conditions (such as wait until the 
cursor is at this location and this message has appeared here). 

- It keeps a separate shared server connection open while the UI tests run so 
you can, for example, script an entry screen via the terminal UI that ends up 
saving some data like a sales order, and then immediately check what has been 
written to the database through the underlying connection as part of the same 
script.

- Unit tests can be organized into batches in which the tests run in order, so 
you can set up sequences that match business operations. 

- Batches can be organized into runs, so you can test whole suites of your 
application. Each run can be customized, so you can feed in per-site or 
per-system information. Runs can optionally randomize the order in which 
batches are executed, and you can set up different run scenarios and iteration 
patterns.

- You can feed in and randomize test data and from the client side runner, 
access local features as well as the database operations.

- Volume testing can take place using the Windows client. This is a 
multithreaded client supporting multiple concurrent UI sessions - I've tested 
up to 250 concurrent connections from a single PC running against an
SB+ system for one customer last year who needed to stress test their 
SB+ system
performance coming up to the New Year sales. 

This first release is targeting U2 with other MVDBMS to follow. I'm also adding 
support for GUI testing using the Microsoft Automation APIs and WebUI testing 
going forward.

Anyone interested can contact me for an evaluation version, or download the 
user guide from www.brianleach.co.uk.



Regards

Brian 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hello All,

I am just wondering what U2 or UniVerse specific integrated testing suites 
people are using out there and ideally in use today.

We have the need for a UV11.x specific or capable tool for automating our 
existing system/unit and regression test packages.  We have a our existing test 
suites/scripts in HP QualityCenter  (HPQC) and we currently manually capture 
and store the results (plus track 'defects') there as well.

Ideally, this tool should be able to integrate with HPQC. At minimum some means 
to capture results - test case number plus success/failure to a file.

Our primary application interface is via a terminal interface via SSH emulating 
VT220 terminals. But we also use various interfaces UV Clients APIs or 
third-party utilities (accessed via UNIX shell scripts or the like). Ideally, 
testing package should be able to "drive" (simulate keystrokes via keyboard 
entry) or "invoke" all of these in some fashion. Hence some sort of scripting 
of terminal emulator or UNIX shell and/or client APIs would be ideal.

Another requirement is a tool that has the ability to perform simulated 
end-user terminal session "load testing" (ie., connect X number of users via 
terminal emulation over SSH and perhaps client APIs too) - we would could 
simulate actual users interactive access and run X, Y or Z test scripts. The 
primarily purpose of this is to simulate database record locking contention, 
etc. under load, etc. Plus other stress testing under load.

Your solution could be a commerical product or a perhaps some in-house tool or 
opensource or combination thereof...whatever it is - I'd be interested to hear 
about this tool or your experience of attempting to do this.

Thanks in advance for any feedback.

Cheers,
David





** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Yes, sounds like it's been identified and fixed a while ago... like Dan 
says...kernel update will the "simple" way to address it... (time & outage 
permitting)
https://bugzilla.redhat.com/show_bug.cgi?id=735946 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Tuesday, 5 February 2013 9:32 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Large File Operations Kill Linux


Other users could have been hanging at malloc. With a swappiness of 100 (on 
some kernels) or 100 (on others) or "not 0 or 100"(not sure which behavior you 
get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the 
creation/copying of a large file.
 
Another thing to look at (although I prefer the support route, since you have 
it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had 
this problem alleviated it by setting this to "never".
 
Of course, others fixed it by updating the kernel. My aged eyes read what you 
have as 2.6.8.1...

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Brian,

*UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying?


I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the 
arguments the same though - such is the nature of "undocumented" features?

Perhaps they should have *APILOGIN to for all API clients? Plus a new 
@-variable that can identify what server-side interface is handling the call - 
thus eliminating the need for UOLOGIN and ODBCLOGIN... ?

Cheers,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, 29 January 2013 8:05 PM
To: 'U2 Users List'
Subject: Re: [U2] [UD] Disabling/blocking ODBC

Sadly these appear to be UniData only.

Or at least, in the past I've tried with local catalog, global catalog as 
*UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired.

Would be really useful as a central consolidation point for things like setting 
DATE.FORMAT.

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker
Sent: 28 January 2013 21:23
To: U2 Users List
Subject: Re: [U2] [UD] Disabling/blocking ODBC

Is this only Unidata or Universe?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Tuesday, 29 January 2013 9:15 a.m.
To: U2 Users List
Subject: Re: [U2] [UD] Disabling/blocking ODBC

Glad to hear that!

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Monday, January 28, 2013 12:25 PM
To: U2 Users List
Subject: Re: [U2] [UD] Disabling/blocking ODBC

> There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine 
> that is called for every ODBC call. You can use this to either blank 
> prevent ODBC, or setting up restricted login access & login.
 
Dan, I got the info from our VAR and it works great. Thanks!

Brad.
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Database time question

[Hona, David]

Potentially simple approach is to have separate server or virtual machine for 
your other UDT environment setup with the desired timezone. No code changes. On 
AIX, you can setup a WPAR for stuff like this pretty easily.

Or change you source code...

The best solution depends on if you control the source code for the application 
and how it currently extracts and utilises the time information. By 
implication, you will also need to separately maintain the date information as 
well in your application. Especially, if it cross the multiple timezones or the 
international dateline...

One approach is to ask the user to specify the timezone they wish or simply 
force it when they get into the respective account. 

Then you merely store a time offset (to your servers real time zone) in a 
separate field in addition to the time / date fields in your respective files 
(perhaps using a file based trigger if you don't want to change the code). Then 
just update date & time display routines (a good time to make sure you have a 
single routine) to check if there is an offset and apply prior to displaying.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Thursday, 24 January 2013 4:45 AM
To: U2 Users List
Subject: [U2] Database time question

Running unidata on hpux11.11i
I have two databases in unidata that I would like to operate at different time 
zones.
Lets say my Midvale database is set to mountain standard, USA which is also the 
base unix kernal time.
I have an account called Austrailia, I would like it to run on australian time.

Any ideas on making a unidata database independant of the unix kernal time.

Thank You

Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
801-569-4016


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universal COMO

[Hona, David]

So you do what you want to do, but not hard code it and hence require manual 
updating of all those VOCs. When you want to move for some reason...like lack 
of disk space or a new disk letter... 

UD also supports multiple version to operate on the same host/server...done 
mainly through the use of shell variables to point to proper version. Much like 
you can do with Oracle too. Now that would be handy if UV could do that 
too...especially when upgrading/test new releases, etc.

Back to your query...
In the past we use to have multiple UV accounts from the old legacy systems. 
But then we bit the bullet and simply created a single account. Not all sites 
can do this if you have duplicate filenames. We had few files like this and 
just renamed them and end up prefixing the duplicates with the (original) 
account name to ease the transition. Then we just change any 
applications/dictionaries that use to refer to.

We didn't have any issues with duplicate &HOLD&, &SAVEDLISTS& nor &COMO& 
filenames. But you do have to aware of potential gotchas like this when 
applications start overwriting each other's' output.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, 24 January 2013 7:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universal COMO

What's the reason for using a variable, @MY_COMO, instead of the actual path ?
 

 

 

-Original Message-
From: Bill Haskett 
To: U2 Users List 
Sent: Wed, Jan 23, 2013 7:22 pm
Subject: Re: [U2] Universal COMO


In UniData (on Windows) this is pretty simple.  First you create an environment 
variable for the como file (e.g. MY_COMO) that points to the directory under 
which you've created a _PH_ directory and a D__PH_ dictionary file.  Then you 
create a VOC item as follows:

_PH_
001 DIR
002 @MY_COMO\_PH_
003 @MY_COMP\D__PH_

...to include in every account's VOC file.  This will now act as a centralized 
"como" repository.  I do this with the _HOLD_ directory, as everyone on our 
machines share the same spooler file, and each spooler file name is a unique 
".txt" file.  I'm sure it would be even easier on a "nix" machine.  :-)

Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] External database

[Hona, David]

http://u2.rocketsoftware.com/downloads/whitepapers/64_Bit_Question_wp.pdf

Advice here is free here, but the it may cost you later if you don't plan, 
execute, test and know what you're doing. 

Given your responses to queries it very much sounds like you some need 
technical advice/help...contact U2 Professional services or a U2 certified VAR 
in your area/region/country.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089
Sent: Tuesday, 15 January 2013 2:22 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] External database

Hi,

Thanks for guidance. Please let me know, my most of the work is on UniVerse 
32-bit edition including massive coding in infobasic as well. Now if I turned 
64-bit on switch, what will be the complications I can face otherwise it will 
be safe ride? Do I need resize all files again and also compile code on 64-bit? 

Cheers
Asad 



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39634.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

I meant to add what was the original selection criteria...so you could write a 
SQL SELECT with a join to filter out the records you want to include/exclude...

Barring a non-programming solution you have to write, here's one someone else 
already has written... :)


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Tuesday, 15 January 2013 6:27 PM
To: U2 Users List
Subject: Re: [U2] [UV Retrieve] Selecting file based on partial key


This may help you... 

https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Tuesday, 15 January 2013 2:10 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV Retrieve] Selecting file based on partial key

Dear U2 List,

Is the below at all possible in universe retrieve please? I didn't think it was 
but there're a lot more clever people out there than I plus it's been too long 
since I was doing this regularly and cannot remember if it is or not. I cannot 
see anything obvious in the manuals.

We have a file in a production environment with 5477108 records whose @ID/Key 
are all '9-digit-account-number':'4-digit-sequence-number'.

Q. Is it possible to obtain a list of @ID's based on a separate saved list of 
'9-digit-account-number'?

The remaining record fields are all out of scope for the selection apart from 
an internal date in attribute 4 but that can be interrogated later.

Is it possible to construct a kind of reverse select based on my existing 
saved-list and pass this data into a dict item for the account number? I've 
tried numerous permutations of this but have yet to find the answer.

Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST 
ACC_LIST'? How is this done on a (live) normal type 18 UV file?

Of course I can always whip up some basic code to do this but it is production 
and getting it there will take a while.

(and no I didn't design the file layout ...)

Many thanks in advance.
Regards,
Peter


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

This may help you... 

https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Tuesday, 15 January 2013 2:10 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV Retrieve] Selecting file based on partial key

Dear U2 List,

Is the below at all possible in universe retrieve please? I didn't think it was 
but there're a lot more clever people out there than I plus it's been too long 
since I was doing this regularly and cannot remember if it is or not. I cannot 
see anything obvious in the manuals.

We have a file in a production environment with 5477108 records whose @ID/Key 
are all '9-digit-account-number':'4-digit-sequence-number'.

Q. Is it possible to obtain a list of @ID's based on a separate saved list of 
'9-digit-account-number'?

The remaining record fields are all out of scope for the selection apart from 
an internal date in attribute 4 but that can be interrogated later.

Is it possible to construct a kind of reverse select based on my existing 
saved-list and pass this data into a dict item for the account number? I've 
tried numerous permutations of this but have yet to find the answer.

Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST 
ACC_LIST'? How is this done on a (live) normal type 18 UV file?

Of course I can always whip up some basic code to do this but it is production 
and getting it there will take a while.

(and no I didn't design the file layout ...)

Many thanks in advance.
Regards,
Peter



 ---
Note: 
This email (inc all attachments) is for the use of the intended recipient(s) 
only.
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then delete all copies of this message from your computer network. If you 
are not the intended recipient, you must not keep, use, disclose, copy or 
distribute this email without the author's prior permission. If you are the 
intended recipient and you do not wish to receive similar electronic messages 
from us in future, then please respond to the sender to this effect. 
We have taken precautions to minimise the risk of transmitting software 
viruses, but advise you to carry out your own virus checks on this email and 
its attachments. We do not accept liability for any loss or damage caused by 
software viruses and do not represent that this transmission is free from 
viruses or other defects. 
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) 
 ---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] External database

[Hona, David]

As long as your OS and the filesystem is already 64-bit enabled - you should be 
able to resize the UV file to 64BIT (make sure you have a verified backup first 
:)). Otherwise, use UV distributed file create a logical file view of your UV 
physical files.

Note that BCI is a programmatic API interface only - that implements OBDC 
calls, it's not a DB-level interface of likes of EDA or UV/Net, etc. Useful 
largely with batch-like operations to push/pull data.

Since you already use Nabble, search the U2 forums there for UV ODBC setup...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089
Sent: Sunday, 13 January 2013 7:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] External database

Many thanks,

In fact I am running old version of UniVerse 9.6 and due to is limitation of 
2GB file, I am designing an interface to transfer data from U2 data files to 
Oracle. In this regard I have heard about ODBC drivers but very little 
knowledge how to use them. I will be grateful if you can guide by an example 
how to configure ODBC/BCI driver for this task.

Regards

Rauf

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Here's some troubleshooting tips we use for our applications using the U2 APIs 
in background non-interactive processes.

We have a common interfacing subroutine our API clients must use to "sign-on" 
and initialise their UV environment. In that code, we turn on COMO output, to 
capture any output that BASIC code or any other UV command may output. We tend 
to generate unique COMO filenames, with the OS user ID, process-ID, UV User No. 
and a date stamp - as typically you're executing multiple instances under the 
same user ID. With this, we can see what unexpected input or output is 
captured. Otherwise, you never really know what's going on.

For further debugging we have a debug subroutine we can put into a code to log 
messages to a sequential file with details of what step or data is being 
processed. We use to as a non-invasive way to capture detail information. It is 
really just something of a glorified PRINT statement you'd have in BASIC 
program you'd place to debug it when running from a terminal session...but 
written to a unique log file for each background process. We've found it 
valuable in the past - especially in the development stage to do this. Then 
remove it or disable it later.

You don't mention if your UniObjects code is designed to interact with 
interactive UV BASIC or UV commands. This could be an issue regardless, if 
someone changes code that expects terminal input and none is forthcoming.

If you don't already, have a ON.ABORT and ON.EXIT paragraph setup to log the 
fact that your API process has triggered that. Just simply outputting the fact 
it got executed should be sufficient. This you know if aborted or cleanly 
exited UV - something which isn't always easy to determine due to lack of 
decent session event logging in UV.

We also have a protocol that API processes must "sign-off" so we can tell if 
they cleanly exited from the application. This is useful as well. Likewise, the 
application has a transaction log which flags when the update transaction 
starts. That isn't cleared, if abnormal termination of the application occurs. 
Further nor future transactions aren't possible for the user ID until it is 
cleaned/investigated - but that's then logged.

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andy Krause
Sent: Wednesday, 9 January 2013 1:44 AM
To: U2 Users List
Subject: Re: [U2] How to check which sproc is called by user

I will chime in since I work with Ravi and I am dealing with this issue along 
with him.

Thanks for the response Brian, PORT.STATUS should be useful for our situation.

I'll try and be a little more specific and hopefully I know what I'm talking 
about:  We have a web application which is using UniObjects and we are randomly 
getting multiple (we've seen as many as 9) user sessions in the LISTU which 
appear to be hung and it's causing us to reach our user limit.  We have 
debugged the web application and verified that all sessions are being closed 
properly so we do not believe that it's on the web side of things.  Although, 
we cannot duplicate this problem in the live application either, so we cannot 
say for sure it's not on the web side.  My first thought was that the 
application is calling a PICK subroutine that is stalling (possibly waiting for 
input or stuck in an infinite loop or something).

So, at this point all we know is we are getting these stalled sessions but we 
don't know how.  Hopefully with PORT.STATUS we can see whether is a PICK 
subroutine that is stalling?

Now, to limit the severity of this problem we discovered there is a Timeout 
property of the UniSession object.  However, it seems in the past we were 
advised against setting this parameter by Rocket support and that this timeout 
should be handled in the unirpcservices file in the unishared directory?  Does 
that sound right?  UniAdmin uses the timeout in the unirpcservices file so I 
don't think we would want to shorten the timeout and be booted from UniAdmin 
sooner.

Thanks in advance for any responses.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, January 08, 2013 3:35 AM
To: 'U2 Users List'
Subject: Re: [U2] How to check which sproc is called by user

If it is a session hang you're possibly looking at locking issues so check the 
lock table to see what is waiting and also check for any group locks that 
persist.

If it is UniVerse, It's also a good idea to check the errlog file in the uv
account: if that does not exist, create it as a zero length file (you can go 
into the UV account and ED &UFD& errlog and just file it) and it will log the 
last 100 errors.

If you can catch the session that has hung you can use the PORT.STATUS command 
to see where they were and their calling stack.

Phil's idea of using the remote item security subroutine to audit cal

Re: [U2] Garbage in locks

[Hona, David]

Looks like UV? What version or platform? Did these user process normally exit 
UV or did they drop connectivity or abnormally terminate from UV??

UV Lock Daemon typically cleans-up non-deadlock locking issues, including 
orphaned locks (sometimes :)).


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Tuesday, 8 January 2013 8:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Garbage in locks

Is there a way to resync, or clean the lock list?  It seems like every once in 
a while we will get garbage in the lock list that will not go
away until we reboot.The users are long since logged off and these
locks do not show up in uniadmin.  It doesn't actually seem to do anything 
other than make it hard to find active waiters.

 

 

Example:

 

Active Read Waiters:  Owner   Waiter


Device  Inode Userno  Userno


  10465106915866934427836   62692


  10465106915866934427836   58520


  104651069158669344278365836


  20297666099756827340769560


  20297666099756827340768264


  115824063137137493724007836


  2029766609975682737836 236


  20297666099756827378365216


  20297666099756827378367912


  2029766609975682737836   59820


  20297666099756827378363424


  20297666099756827378367140

 

Thanks,

 

Jake Holt |Information Technology Director

Samsill Corporation 

5740 Hartman Rd | Fort Worth, TX 76119

(817) 536 - 1906 x 217 | Fax (817) 535 - 6900

www.samsill.com

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Here's some options for you...


1. Verify it is cataloged in Global Catalog
The subroutine !EXIST subroutine was created for Prime INFORMATION 
compatibility and does a simple check to verify the program is catalogued only. 
Check out the source code in UV account APP.PROGS, EXIST.

2. Verify Object code matches
The VCATALOG verb is also used to verify the compiled object in your BP object 
file and the Global Catalog space are the same. (Interestingly, on my 
UV11.1.9/AIX system, VCATALOG isn't working! :-( ).

3. Extract detailed object code header data
Finally, writing your own custom verification utility combining VLIST verb 
and/or Gyle Iversons' excellent (NB: I understand he will soon close down this 
website) SRS.UV.HEADER subroutine to extract header information from the global 
catdir and your BP object file for comparison purposes.
URL: http://www.srs4uv.com/srs_uv_header.htm 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Saturday, 29 December 2012 2:32 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV]Corrupted object in global catalog

Greetings, all!

We have recently upgraded to the latest version of our vendor's software, and 
in the process have gone from Pick flavored accounts to Ideal flavored 
accounts.  This has drastically changed the way programs are cataloged, as we 
are now using the global catalog directory (catdir, aka GLOBAL.CATDIR).

We have discovered that some of the object code in the global catalog is 
corrupted (for lack of a better term).  It looks like some of the object code 
files were somehow truncated.  Since we don't discover this until someone 
notices that a program is behaving oddly, or working differently between the 
different servers (dev, test, production), and since the date stamp on the file 
in the catdir directory is the last time someone ran the program (as opposed to 
the time it was actually cataloged), it is impossible to tell if the object 
code was 'bad' from the beginning or got corrupted somewhere along the way.

At this point, we can just recatalog everything.  It would be a royal pain, but 
it is possible to do.  That would ensure everything was all good right now, but 
doesn't do anything to make sure it stays that way.

Does anyone know if there is a command we can ruin or some other way to verify 
object code in the global catalog?  We would much rather monitor this 
proactively than wait until a user runs into a mysterious issue that we can't 
explain - or worse, runs something that ends up corrupting data because of a 
problem with the object code.

Of course the ideal would be to figure out what's corrupting the object code to 
begin with - or to be able to determine if it was somehow corrupted in the 
initial install and we're just running into the bad pieces now.  Without being 
able to monitor the object code and see when/if it gets corrupted again, 
though, that's going to be almost impossible.

Any assistance would be greatly appreciated!

Thanks!
Brian

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material not 
intended for Public use.  
Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is strictly prohibited. If you received this communication 
in error, please notify the sender and delete the material from any and all 
computers or devices.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe 11.x

[Hona, David]

Your mileage will vary - the more UV specific "features" or APIs or the like 
you utilise - they more issues you're likely to have. As these tend to change 
at each release.

If on the other hand, you have plain vanilla application then you're unlikely 
to have issues...then all you're doing is project managing your migration to a 
new host, UV release and performing testing to ensure you configuration, 
software and end-to-end processes are A-OK afterwards.

As with any software release - carefully review the release / technical notes - 
especially if you have any mind any "new feature" you wish to use.

Caution and clear objectives on how and why you're going to implement ADE is 
recommended. It's a greatly improved facility over previous versions - with 
some new features added to dramatically improve it and easy administration. 

However, "never buy or use version 1.x" of any software - extra care (and 
testing) is needed (especially reading the tech / release notes so you're fully 
aware of known issues - some which can be OS and release specific). 

Some good test cases for "worse cases" scenarios for ADE would be recommended 
too... also think about what would happen if you needed to retrieve encrypted 
files from backups. Will these same backups include the UV version/keys, etc. 
that you can restore the data in any unencrypted form? Is the administrative 
overhead of maintaining a ADE database files really worth it? Would OS-level 
filesystem encryption be a better choice?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Saturday, 15 December 2012 4:16 AM
To: U2 Users List
Subject: [U2] Universe 11.x

Universe folks:

Who has upgraded from Universe 10.x to Universe 11.x lately?  Is it painless?  
Like - get the users out, install Universe 11.x in 5 minutes, then get the 
users back in.  Then, as time permits, take advantage of the new features 
within Universe 11.x.  Or - is it a big deal to install it?

My manager is interested in data encryption in the underlying data.  It is my 
understanding the Automatic Data Encryption (ADE) only exists in
Universe 11.x.  Is that right?   If the install is simple enough, that
would seem to be the way to go to obtain this feature for all fields.

Thanks-
Harold Oaks
Clark County, WA

This e-mail and related attachments and any response may be subject to public 
disclosure under state law.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Advantage of indirect call in BASIC

[Hona, David]

If you encounter this, it is probably a Prime INFORMATION (PI) legacy code.  As 
this was a commonly used convention in natively developed PI applications 
(rather than PICK-ported apps). 

As globally catalog'd object was a typical naming convention for "production" 
object in PI. Plus as mentioned by others it was also primarily for performance 
reasons. Some of those performance reasons still exist. If you don't resolve 
the subroutine name in your BASIC code, then the VOC file has to be referenced 
to find out the "true" catalog name. If you define and call a variable - if 
by-passing the VOC calling entirely. Of course there were many non-native 
applications running on PI from the PICK world that never took any advantage of 
this and many other PI features. 

Legacy PICK code tends to be account catalog centric (ie., *MYACCT*MYOBJECT). 
So typically doesn't use this convention, we use this convention to define test 
/ non-production object code in the catalog space.

Hence, we also use it to load/deignate different versions of the object code 
dynamically. Our account initialisation code defines "*CATALOGNAME" as the 
production code. When initialising on logon to the UV account, It then checks 
the local VOC for any different definitions in the local account - and asks the 
test user (not end-users) if they wish to local that object version. This 
allows versions of the code to be loaded for different users - for testing and 
pre-implementation purposes - on demand. For example, we run to run 
"*V1.1*SOME.PROGRAM" rather than "*SOME.PROGRAM".

This is especially useful if you share your single UV environment with multiple 
accounts and versions of your software. This saves having change VOC entries 
too, but of course you can do that too. But then if you have some users that 
don't what or need to test that version - then how would you control/enforce 
that?

Regards,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, 4 December 2012 11:39 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Advantage of indirect call in BASIC

I've not encountered this is my career previously, but now I'm seeing a system 
written almost entirely with the use of indirect calls in Universe BASIC.

That is
SOURCE = "*SOME.PROGRAM"
...
CALL @SOURCE(INPUTS)

Is there some advantage to the use of indirect calls that a system would be 
written entirely in this fashion?

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UPLOAD not DOWNLOAD

[Hona, David]

You could modify Brian Leach's freeware BCI.IMPORT tool which is designed for 
SQL / BCI imports. But looks relatively easy to modify for what you want ! ;-) 

With his permission, of course ! I just downloaded to have a peek... as I have 
been looking at his other tools lately...

There is also provision for multivalues so that's great!

Check out Brian's website... http://www.brianleach.co.uk/pages/freebies.htm


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Saturday, 27 October 2012 2:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UPLOAD not DOWNLOAD

That goes the wrong way.
Download does not depend on knowing who is consuming what to create it's 
results.

So Upload should not need to have interactive consumption details either.
That's my take.

It's reads a source and decides on its own without the sources assistance where 
to put what.

You're coming at it more from a point of view of both sides *agreeing* on what 
data is in what position.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Yes, it is a vastly improved beast over earlier versions. Like others, I not a 
fan of the timeout of the UniObject session. BDT has features the competition 
has yet to add. I especially like being able to expand the inserts and see the 
BASIC Labels easily accessible. I still haven't been to get to SSH to our 
hosts, but I have never had the time to dig in the whys, etc.

It is still worthwhile looking at U2Logic XLR8Editor and Brian Leach's freeware 
Windows thick-client MVDeveloper.

I don't use any of these tools myself (occasionally fire up BDT)... but have 
trialled an early version of XLR8Editor...and trialled MVDeveloper. 

www.u2logic.com/tools.html (the links to download the documentation seem to 
have gone AWOL)
http://www.brianleach.co.uk/pages/mvdeveloper.htm

Each has unique features which means you choose the one the suits your needs. 
Or use all of them! I'm not a big fan of Eclipsed based products. I loathe the 
wealth of non-functional menus, menu-items that they all seem to have. Its 
weird shoving your specific tool into some else's generic tool framework.

In general dedicated software tool vendors tend to much more responsive to 
feedback and bug fixes, etc. They have a short lead time / development cycle so 
are able to be more 'agile'. For us 'dabblers', this isn't such a big thing.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, 25 October 2012 9:17 AM
To: U2 Users List
Subject: Re: [U2] [BDT] A giant leap forward

Thank you, it's always great to hear when we've hit the mark.

I've sent this off to the team members responsible.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 24, 2012 3:55 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [BDT] A giant leap forward

I would like to *commend*, yes commend, the developers of the Basic Developers 
Toolkit for recent changes.

In particular, the ability to *install updates* from within the Eclipse package.
In conjunction with the *detailed release notes* highlighting changes in each 
version, for example July's here:

http://updates.rocketsoftware.com/u2/July2012_ReleaseNotes.htm


It's quite useful to be able to read the release notes and try out the fixed 
features ___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] New Rocket U2 website!

[Hona, David]

Looks good and well organised

A new addition to the Rocket U2 team, I see! Totally RAD! :)
http://u2.rocketsoftware.com/images/minihome/sbxa/sbxa_rad.png

The "learn more" icons & the rolling animation are all a bit too large...and 
the text in the "footer section" too small...but looks good - nice and clean 
look. But those big parts are perfect for us U2 old timers with our multi-focal 
specs anyways! :0


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, 26 October 2012 2:52 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New Rocket U2 website!

why are you using that odd mask?

http://u2.rocketsoftware.com/


 

 

-Original Message-
From: Daniel McGrath 
To: U2 Users List (u2-users@listserver.u2ug.org) 
Sent: Thu, Oct 25, 2012 1:59 pm
Subject: [U2] New Rocket U2 website!


For anyone who wants to check it out, we have launched a new website today: 
http://goo.gl/ON5qL

Let's know what you think!

Cheers,
Dan
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Task Manager and add Base Priority column...see if that changes...after you do 
your thing.

 May do nothing if Rocket hasn't actually hook in the required hooks into UV. 

Plus a lot of the times you will need to be a Local Admin to change priority 
higher (if it works at all). In some cases like UNIX - mortal users can't even 
change their priority at all... up or down (in any meaningful way)...

All of this is robbing Peter to pay Mary...what goes around...comes back to 
bite you if you're not careful. Sometimes it worth not "mucking around" with 
dangerous stuff like this. 

Tis far better invest more time to tune/optimise your U2 app or DB first - 
fiddle with Windows task scheduling priorities LAST. :) 

Use at your own considerable risk ;-)

http://msdn.microsoft.com/en-us/library/windows/desktop/ms685100(v=vs.85).aspx



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, 16 October 2012 5:41 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Chap Up, Chap Down, Chap chap chap the chapper

Does anyone know what exactly the Chap Up and Chap Down do, as far as the 
underlying system settings?

Can I see how Chap is currently *set* on my process or some other process?
Does the setting of Chap appears somewhere, that I can view, either in 
Universe, or in Windows (or Unix) ?

Can you Chap down multiple times and will this actually do something?

If I Chap down on my process, not as admin, can I then Chap up on my process 
and still not need to be admin?

These are burning questions and the kitchen's on fire.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Consuming Web Services

[Hona, David]

Very true and I agree that the DB Server (SQL, et al) and the DB client engine 
(UV) models each have pros and cons. 

UV is a lightweight DB and application engine with some very good capabilities 
in the DB and application area. Plus of course some truly powerful features 
too! It is not the best or worse in any of these fields. It fills its own 
little niche very nicely.

UV has had some truly good native SQL engine abilities (schemas, tables, 
triggers, integrity constraints, stored procedures, dynamic normalisation of 
multi-valued fields, etc) for a long time. Not tacked on like the UD 
counterparts. But next to no one uses them. As they would break your legacy 
application. Plus if you created a new application/DB using it - you may as 
well use a read SQL database server!

Some of the nifty features of true SQL DB servers are really to "work around" 
the "limitations" of the relational model and how you store your data 
(requiring complex joins, queries, etc). Which tends to make those nifty 
features essential. Whereas SQL DB servers are progress in leaps and bounds in 
many different and diverse ways and this  is where they truly diverge - be it 
to cater for massive databases or distributed or failover-active/active 
database clusters, etc., of any data type or structure you could imagine. 

Whereas the U2 database engine has not really progressed or evolved much at all 
in reality - that is not a bad thing. Adding various extensions to the 
traditional PICK/U2 application interfaces is a very good thing. It does add 
lots of functions that are truly useful - requiring minimal effort and zero 
install or cost (a key requirement for lots of sites). If you need something 
better AND you have local talent to build/maintain it (or consultancy budget) - 
then go again and do it. :)

There are many examples of organisations using their own interfaces/extensions 
- because they can afford something better that works for them. Your mileage 
and budgetary will vary!

Hence, as you imply - use each database - exploiting their inherent strengths. 
Use the right tool for the right job. Every tool has its sweet spot! ;)

I won't mention the number of MS Access "databases" out there doing "real 
work"...groan!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, 4 October 2012 5:56 PM
To: 'U2 Users List'
Subject: Re: [U2] Consuming Web Services

But we all know U2 is much more than a DB, in fact it is also much less than a 
DB.

The concept of having the DB just do DB stuff works fine for SQL server and 
MySQL where the DB itself actually does a lot in terms of the data, and the 
clients, written in .NET, C, Python Java etc do all the business logic. For 
these stored procedures do exist but are usually kept to a minimum and 
certainly only for data interaction.

The U2 databases are actually quite stupid, they store and retrieve data from 
tables in a (hopefully) quick and efficient  manner, but they certainly don't 
do any of the clever stuff you find inside Sql server like map reduce, caching, 
indexing etc. The clever bits are what we do in the unibasic code.
So I firmly believe there  IS a case for the clever Unibasic code we write to 
access data over http, read in xml and to then process all of these different 
data streams. Yeah sure there are things which in theory are easier to do 
outside It does not mean you should always do things outside of unibasic.





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 03 October 2012 23:48
To: U2 Users List
Subject: Re: [U2] Consuming Web Services

Tony and Ben are right on...

Invoking Stephen Colbert's concept of... "The Word"... the word is...
"MiddleWare".   As legacy U2 was ahead of its time... by building-in
middleware technologies... it is easy to lose sight of what belongs where.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Wednesday, October 03, 2012 6:31 PM
Subject: Re: [U2] Consuming web services

I do the same as Ben but with .NET:
-- Local U2 <> .NET client  Remote server

Pick is a database server, not a communications protocol end-point. We simply 
should not be doing direct comms from this platform anymore, given the huge 
number of mainstream options. This is coming from someone who has written all 
of the bi-directional comms interfaces to/from MV with sockets and cURL and 
plugins and anything else I could create - because (in the
90's) people said it wasn't possible and because I figured it would be kewl 
just to do it.

It _is_ all technically possible, but that doesn't mean it makes good business 
sense: Doing things like this in BASIC creates a maintenance hassle later. It 
leaves the environment subject to DBMS-specific is

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

[Hona, David]

The installation instructions of Rocket is quite good and does indeed mention 
the need to use "cpio" on UNIX servers. See "Quick Installation" and 
"Step-by-step Instructions" (of NEWINSTALL.PDF)...

However, the instructions from Rocket could be improved - with a minor 
revision, as the Installation guide assumes you're using a CD-ROM or tape drive 
to get the installation software on your system.

It is not clear that after you download the software archive file from the 
Internet, that you can upload it (as a binary file) to your UNIX host. Once 
there, "un-zip" (preferably as root) and then you must perform the "cpio" after 
that step.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Tuesday, 2 October 2012 3:43 AM
To: 'U2 Users List'
Subject: Re: [U2] STARTUP file issue with UV11.1 PE version (Linux)

No sir, I did not know that,  why would they cpio it anyway?  Not that it 
matters I was just curious, anyway thanks for the info.

Dougc

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, October 01, 2012 1:19 PM
To: 'U2 Users List'
Subject: Re: [U2] STARTUP file issue with UV11.1 PE version (Linux)

Doug

Have you remembered that STARTUP is a cpio archive?

# cpio -uvcdumB uv.load < STARTUP
./uv.load


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: 01 October 2012 17:37
To: U2 Users List
Subject: [U2] STARTUP file issue with UV11.1 PE version (Linux)

I recently downloaded uv 11 and when I went to run STARTUP I got a weird error, 
upon looking at the STARTUP script I noticed it had a bunch of binary and other 
junk at the beginning of the file, I removed all the "extra"
stuff, saved the file and it ran just fine.

 

Has anyone else seen this?  I re downloaded the zip and still had this issue.  
It was easy enough to resolve but I thought I would mention it.

 

Dougc

 

 

 


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Scrub HangUp Fixed

[Hona, David]

Bill,

You make good and valid points. :)

To all question posters in general (not directed a Bill): 
The better the quality of the problem definition and context = the better the 
quality of the response. 

As I sometimes jokingly tell my users: 
All answers are free, but correct answers are cost money. However, dumb and 
puzzled looks are at no extra charge!

I agree, it is difficult to justify the expense of any course - let alone 
finding the time to attend - even if it is a webinar-style course. Send your 
suggestion directly to Rocket about posting on that site. They won't know 
unless you do that.

It sounds like you should upgrade to UV11.x to get the most out of ODBC 3.0 
compliance and any other bug fixes in UV. 

Any reason you really need to use ColdFusion? Can some other tool do what you 
want? Have you turned-on server-side and client-side debugging to pinpoint your 
issue? 

Yes, I fumbled across the Dictionary clean-up webinar myself - after seeing an 
invite to another for U2 .NET Toolkit held the other day. 

Kind regards,
David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, 31 August 2012 1:11 AM
To: U2 Users List
Subject: Re: [U2] Scrub HangUp Fixed

David:

0. Thanks so much for writing.
1. Yes... same problem on the same file... now fixed.
2. I have read both the Rocket ODBC and JDBC documentation exhaustively... and 
found these manuals to be rather excellent.
3. I have also had trouble with getting the Rocket JDBC driver to work with 
Adobe's new release of ColdFusion 10.  It is like I have to again write a 
little Java program to troubleshoot the connection string thing.  We may be 
forced to upgrade our version of UV.
4. Much as I would like to attend all the Rocket UV courses... I find these 
courses to be pricey and involve serious days and travel. 
5. I would like to see Rocket move the courses to Lynda.com or do something 
similar to Lynda.
6. I am delighted to learn about the seminar... I registered for it.  I am 
surprised that I did not learn about it except through this back door.
7. This list being something of a forum... as I understand it... posts on 
newbie, intermediate, and advanced questions are all welcome.  If the question 
is directly answerable via an official Rocket manual... then the originator 
risks suffering the punishment of embarrassment from the respondent who... from 
some point of view... is following in the traditions of the late William F. 
Buckley, Jr.
8.  The speed of the u2ug forum responses in of course invaluable.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Wednesday, August 29, 2012 8:32 PM
To: U2 Users List
Subject: Re: [U2] Scrub Hangs Up

Is this query related to the one you posted/resolved here: 
http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html

Same problem/solution? 

I kindly suggest that you go on a Rocket UV course to help work out how to get 
the best from UV. Plus the UV ODBC documentation is quite detailed on the use 
of HS.SCRUB. So I assume you're followed it's correct used - before you posted 
this request for help.

BTW check this out Rocket U2 Webinar coming soon:
http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, 29 August 2012 6:16 AM
To: U2 Users List
Subject: Re: [U2] Scrub Hangs Up

When I do a 

>LOGTO HS.ADMIN
>HS.ADMIN
5. Run HS.SCRUB on a File/Table.. [F]ix

Most of the files here work ok.

This one (important) data file INVOICE... it starts an... Analyzing: *and 
then just sits there.

I looked at the dictionary and purged a bunch of extraneous "}" characters from 
several the NAME fields.

I expect to resize the file but... it is not like the file is badly oversized.

This is on UniVerse v10.1 running on HP-Ux Itanium.

Suggestions would be appreciated.

--Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or disclose the contents, and delete the message and any attachments 
from your system. Unless specifically indicated, this email does not constitute 
formal advice or commitment by the sender or the Commonwealth Bank of Australia 
(ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this e-mail by ty

Re: [U2] Scrub Hangs Up

[Hona, David]

Is this query related to the one you posted/resolved here: 
http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html

Same problem/solution? 

I kindly suggest that you go on a Rocket UV course to help work out how to get 
the best from UV. Plus the UV ODBC documentation is quite detailed on the use 
of HS.SCRUB. So I assume you're followed it's correct used - before you posted 
this request for help.

BTW check this out Rocket U2 Webinar coming soon:
http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, 29 August 2012 6:16 AM
To: U2 Users List
Subject: Re: [U2] Scrub Hangs Up

When I do a 

>LOGTO HS.ADMIN
>HS.ADMIN
5. Run HS.SCRUB on a File/Table.. [F]ix

Most of the files here work ok.

This one (important) data file INVOICE... it starts an... Analyzing: *and 
then just sits there.

I looked at the dictionary and purged a bunch of extraneous "}" characters from 
several the NAME fields.

I expect to resize the file but... it is not like the file is badly oversized.

This is on UniVerse v10.1 running on HP-Ux Itanium.

Suggestions would be appreciated.

--Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

I don't believe it is free nor freely even away to anyone who asksfor 
obvious legal reasons, etc. As there are some dishonest types at there! :)

Or you just buy that third-party tool. Which is probably going to be a lot 
cheaper and you don't have to disclose to anyone, have proof of ownership, sign 
a legal wave and explain what you're doing and why.
 
Best bet: call Rocket U2 Support direct and discuss your requirements/issues.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert
Sent: Tuesday, 28 August 2012 12:48 PM
To: U2 Users List
Subject: Re: [U2] PI/UV: Decompiler *** mispelling correction *** in the 
previous email

OOPS:

"IBM's compiler" should read "IBM's decompiler".

Robert Norman


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Escaping quotes

[Hona, David]

I think this article says it all...

http://en.wikipedia.org/wiki/Comma-separated_values


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, 16 August 2012 10:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Escaping quotes


I'm curious about this escaping quotes thing in the csv format.

Two double-quotes in a row means what exactly?  That it should be converted to 
one double-quote in the output ?
Or that it should be converted to nothing?

What if I encountere three double-quotes in a row, or four or fifteen?
Do I take them out in pairs?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Try and be very specific what it is you are doing and why. For example - why 
are you using SQL? Are you doing SQL queries via the TCL prompt or using a 
client tool on Windows? What is the query? What do you mean by 'optimize the 
performance'...Etc., etc. 

UV has two query languages and a single database engine. Meaning, there is 
should be no difference in respect to the utilisation of indices. 

Clearly, if you have having to do a SQL query that requires unnest or join 
operation - then indices may not be significant in improving performance. 

Try adding the EXPLAIN keyword to your query give some clue to what (if any) 
query optimisation is going on...including of indices.

Being unfamiliar with SQL can also be part of the issue...it's extremely 
powerful and can be difficult to master. Hence not for the faint hearted - 
especially if the query is complex and/or your table/schema is also complex. 
You can perform queries which can have a profound impact on the system 
performance, if incorrectly structured. 

Indexes aren't the answer to every optimisation issue. There needs to be a 
balance between cost versus benefit. It depends on the nature and utilisation 
of the file in question.

Therefore: one really needs to optimise one's own SQL skills...not an easy 
ask...then optimise your query in order maximise expected query performance. Or 
perhaps avoid SQL, if it is not really necessary to utilise it.

Regards,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Saturday, 28 July 2012 1:35 AM
To: .U2 List
Subject: [U2] Universe; SQL; Indexes?? (10.3.7 on Windows)

I'm using SQL to query Universe 10.3.7 data files, (ANSi-compliant and 
non-compliant formats) and indexing the files to try to optimize the 
performance seems in some cases to have little or no effect.

I'm pretty clear on index behavior with Universe's native query language, but 
SQL is somewhat unfamiliar to me, and I'm wondering why I'm not getting the 
behavior I expect.

Can anyone either point me to reference material on this, or offer thoughts 
based on experience?

Thank you.

--
Allen Egerton; aeger...@pobox.com

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Is your UVCONFIG parameters still set to the default values?

If so, you need to change these to suit. You can baseline them using your 
previous UVCONFIG parameters from your old host and see how your application 
performs. Further tweaking of them may be required if your application profile 
(utilisation requirements), etc. has changed.

Also, what was the previous release of UV you were on previously? 

Regards
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adam Taylor
Sent: Wednesday, 10 August 2011 12:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?

All,

We recently upgraded and virtualized our UniVerse servers to UV 11.1 64-bit on 
a Cisco UCS B Series platform with a NetApp 3040A/A Filer.  Going to 64-bit 
with an upgrade in the virtualized environment, we expected to see a noticeable 
(if not significant) increase in performance than we were achieving on our old 
physical 32-bit server.  However, not only has performance not notably 
increased, we are having random slowdowns in various areas of the system that 
were not occurring before.  I say random, because while it does seem to affect 
certain areas more, it is not consistent.  

Some examples of behavior that has changed since the virtualization:

An SB screen that has some calculated fields on it will take a minute to load, 
but the next time it loads it loads in just a couple seconds for the same 
record.
An ASP webpage with 10+ queries against different files (heavy-duty processes) 
using Web DE to connect will takes 5-6 minutes to load that was only taking a 
minute before.
Randomly, saving a change in the SBClient screen designer on our Dev 
environment will hang for 20-30 seconds. (Same virtualized specs, but far less 
traffic due to being a dev environment.)
Simply initiating a telnet session, sometimes it will be 10-15 seconds before 
the login prompt appears to enter username and password.

Does anyone out there have any experience with any of these pieces (UV 11.1 
64-bit, Cisco UCS, NetApp Filer) that could shed some light on why we are now 
seeing these performance issues?

Thanks.


Adam Taylor
Director of Software Development
O: (713) 795-2352
www.INXI.com


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] AIX uname and Redback

[Hona, David]

One 'simple' thing to try...

I'd ask them to first check the ulimit settings from the UNIX shell before they 
enter (ie., what is the default). For all the values not set already to 
unlimited. Retry and see if that makes any difference. 

Only other thing I can suggest:  create a Korn Shell VOC entry and call 
that...I am guessing that this for UV?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Friday, 5 August 2011 11:36 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] AIX uname and Redback

To my knowledge Redback itself isn't being asked for anything.  A
BASIC sub was executed and returned the short result - I believe
this does what you're suggesting.  That sub also kicks off a
phantom with the same results.  Code is below.

FYI, I don't use Redback myself so please forgive any
misunderstanding of something that you're trying to convey.  I'll
pass along new suggestions to the client.

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Always...use the right tool, for the right job...one size doesn't fit all, 
etc., etc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, 14 July 2011 3:56 AM
To: 'U2 Users List'
Subject: Re: [U2] Why use U2, was Interesting Article

I am a bit of a mongo DB fanboy myself, I think regarding performance,
because of its autosharding any large scale application will definitely beat
u2.  Mongo db powers many mainstream enterprise solutions, and high profile
websites, - bit.ly comes to mind, so it certainly has a pedigree as well.

However i am also a u2 fanboy  for many many reasons.



** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Bob

My bad experience with label common variables in the same context was we 
implemented a program that compiled and implemented - it had the very same 
variables. It never got picked-up in the testing, 'cause it didn't use the 
variable for display purposes...Hence, our terminal attributes go screwed up - 
screw displays for unrelated programs "stopped working." Perhaps you have a 
similar issue? Hence well known prefix for reserved variables is always 
advisable (TERM$ENTRY$, etc) - of course it is very hard to go back into 10-20 
year old code though to fix though.

If not thatare you also certain your didn't customise your uv terminfo 
database for the terminal emulation in question? You never know!

I assume "ENTRY$ = @(-14):@(-17)" is the equivalent = "Stop Rev Video" and 
"Insert Line". I am guess you have a test program you have to ensure the 
escapes output match that?

Also, have you re-compiled and re-cataloged (if applicable) all your 
application code?

Every time we upgrade or "refresh" our server / upgrade UV - we perform an 
"install from scratch"  - we don't assume anything is installed (usually it's a 
new server, new install). Plus we always re-compile source, re-catalog object 
code, re-compile dictionaries, resize files before migration and 
post-migration. Paranoid, but it works for us. :-)

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney
Sent: Monday, 20 June 2011 5:26 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe 10.1.22 on AIX 5.3 ML 4

I gave up trying to go to Universe 11 because its needs ML8 and we are
on ML4 and we didn't want to upgrade AIX

 

So, we thought we'd do the easy thing and go to 10.1.22 (we are
currently on 10.1.14)

 

Installed and licensed fine

 

BUT

 

When using this command:

 

CRT ENTRY$:@(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'.
':TEMPL$:C$MLT(C$PPM):CLN:

 

The line doesn't show on the screen 

 

However when using this

 

  CRT @(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'.
':TEMPL$:C$MLT(C$PPM):CLN:

 

It does !!!

 

ENTRY$ is set as a common variable ENTRY$ = @(-14):@(-17)

 

Now old people like me will remember that at Release 7,  @(-11) changed
to @(-58) and @(-12) changed to @(-59) could it be we have something
similar at 10.1.22

 

Any thoughts ??

 

 

 

 

 

 


Confidentiality Notice:  This e-mail and any attachments are intended solely 
for the addressee and may contain confidential or privileged  information.   If 
you are not the named addressee, or the person responsible for delivering the 
message to the named addressee, please notify the sender as soon as possible 
and delete the material from your computer.  This message will be protected by 
copyright.  If it has come to you in error, you must not take any action based 
on its contents nor must you copy or show the message to any person other than 
the intended recipient. 
_
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Enterprise Scheduling solution

[Hona, David]

Like another poster said AutoSys is common enterprise multi-platform scheduling 
tool with it's own scripting/scheduler language. But it won't be cheap and it 
probably will be an overkill. Tivoli,

There are lots of similar tools out there, some optimized for the major 
enterprise ERP packages, RDBMSs, etc. Some of the larger enterprise 
multi-platform/ERP/DB schedulers can be found from companies such as UC4 
Software, Tidal Software, etc.

Another interesting open source scheduler (with optional support from the 
developer) is Open Scheduler 
(http://www.sos-berlin.com/modules/cjaycontent/index.php?id=osource_scheduler_introduction_en.htm).
 It is multi-platform, has an API, supports remote host job execution, is using 
XML format configuration files, job editor, job monitoring GUI via a webserver, 
optionally complex jobs can be managed via a number of majors databases (not UV 
though - but didn't check if it had a generic JDBC/ODBC driver).

What all will have issues with UV and what should concern you is their 
inter-interoperability, impact on your U2 licenses (depending on how they 
invoke jobs), job management and the inability for UV applications executing to 
return return codes back to them to indicate success or failure of their 
execution. The later may negate much of the functionality of such tools if are 
unaware of the state of your jobs (specifically when the process terminates).



From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes 
[baker.hug...@mouser.com]
Sent: Tuesday, 14 June 2011 7:23 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Enterprise Scheduling solution

Many MV systems have some kind of home-brewed or even purchased scheduling 
solution for handling batch processes.  Many times, in distribution or 
manufacturing ERP applications, certain processes such as Aging A/R, or stock 
replenishment/reserving, is performed 'after hours' by these schedulers.  We've 
all worked with one or perhaps written our own.  We have one of these, that 
gets the job done.

Does anyone know of an Enterprise Scheduler solution that can handle jobs 
across a heterogeneous enterprise, that is also MV or *nix compatible?  Rather 
than try and take our UniVerse based scheduler front end to the next level of 
perfection, we need a job/phantom/scheduler solution that would allow an 
Operator with little or no MV knowledge to monitor/adjust/manage jobs across a 
plethora of different OS-based enterprise applications.

The Enterprise Scheduler we are interested in can be MV based, or other DB 
based, but must have a graphical front end, and must be able to manage jobs on 
non-MV systems as well as MV systems.

Thanks for any ideas.
-Baker



  
This communication, its contents and any file attachments transmitted with it 
are intended solely for the addressee(s) and may contain confidential 
proprietary information.
Access by any other party without the express written permission of the sender 
is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy, distribute 
or use the contents, attachments or information in any way. Please destroy it 
and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniObjects.Net error message

[Hona, David]

Is this a new program/process? Do it is just stop working?

Does it rely upon label common variables, file hands/variables, etc which 
perhaps aren't defined when calling it via your call?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Wednesday, 1 June 2011 8:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniObjects.Net error message

I wonder if anyone can assist with this problem:
We are using UniObjects.Net with Universe 10.3 on under AIX 5.3.
A web request is returning an error about a subroutine failing to complete:

[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30107] The subroutine failed to 
complete successfully 

It works successfully with other web requests, and the format of the request is 
correct.
The apiserver log file reveals that the request was received, but has this line 
after the request details:

ICSubCall UVSETJMP returncode=30107.

When I run the request using a Universe request emulation program that calls 
the same subroutine, it works correctly and the output is correctly formatted.

Thanks for any help or suggestions you may have.

Ken Ford
Software Engineer (Universe, etc.)

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Stuart,

Probably too late now... but...

If you defined your SQL table with the DEFAULT "NEXT AVAILABLE" it will 
automatically increment the primary key value by 1 when you insert a new row...

CREATE TABLE MYTABLE
(CLIENT_NUMBER INT PRIMARY DEFAULT 'NEXT AVAILABLE',
CLIENT_NAME VARCHAR FMT "30T" DEFAULT '',
CREATE_ADDRESS VARCHAR FMT "30T" DEFAULT ''
...

See "UniVerse SQL Reference Guide" sqlref.pdf page 113 (UV11.1 docset).


Regards,
David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Friday, 27 May 2011 4:04 PM
To: U2 Users List
Subject: [U2] [UV] Emulate SQL MAX() function at TCL

Just wondering if anyone has a neat trick for picking up the highest ID from a 
file. Where the file ID is an integer.

With UVSQL I would SELECT MAX(@ID) FROM TABLE; - however, the program I need to 
do this within has the file (table) open and if I try to execute it returns the 
error 'Non-SQL re-entrant query calls are not allowed.'

The best I have so far is:
   st = 'SELECT FILE @ID BY.DSND @ID'
   st<-1> = 'LIST ONLY FILE SAMPLE 1'
   exec st capturing cap
   maxId = trim(cap<4>)

Any other ideas?

Cheers,
Stuart




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Stuart,

I've used SQLExecDirect with UV before, we always allocate and prepare for each 
of the required parameter markers. Then call UV BASIC subroutines via 
SQLExecDirect.

I would hazard a guess that QueryTool is doing a SQLExec and Transact-SQL 
pass-through is doing a SQLExecDirect. The later which requires the parameters 
to be pre-declared using SQLPrepare in order for the query result set to be 
returned successfully.

You could test this by calling "DATE" using both tools and see what happens. As 
it has no parameters - I suspect both queries should work. Whereas, anything 
requiring parameters is likely to fail where the tool is using SQLExecDirect.

Finally, is your ZSELECT_CUST a BASIC subroutine? Is it globally catalogued? If 
not, try cataloguing it as *ZSELECT_CUST and then call it like CALL 
*ZSELECT_CUST(1), etc.

Hope this helps... :)

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Monday, 16 May 2011 5:48 PM
To: U2 Users List
Subject: [U2] UVSQL CALL with MSSQL Openquery against linked UV server.

Hi,
Just wondering if anyone has used the SQL CALL statement from MSSQL against a 
linked UV server and got it working.

I have a linked server set up in MSSQL using UniOLEDB which works for most SQL 
queries. I now find I need to call a basic program to do some work to setup the 
result set I need. I have built and tested the program which does some updating 
and sets @hstmt using SQLExecDirect().

Using a simple third party OLEDB client (ADO Query Tool 
http://www.gpoulose.com/), the CALL to the program returns the expected row set.
However, if I try the same query from within SSMS it bombs out with an error.

Using ADO QueryTool:
   Works:   CALL ZSELECT_CUST(1)

Using MSSQL Management Studio:
   Works:   select * from openquery(UVServer,'SELECT * FROM CUST SLIST QQQ')
   Doesn't work:select * from openquery(UVServer,'CALL ZSELECT_CUST(1)')
 And returns the error: Cannot get the column information from OLE 
DB provider "IBM.UniOLEDB" for linked server "UVServer".

The other possibility might be running as a 4 part exec - which also isn't 
working for me.
   Exec UVServer...[ZSELECT_CUST(1)]

Which returns Msg 7411, Level 16, State 1, Line 1 Server 'UVServer' is not 
configured for RPC.

In the meanwhile I can work around the issue by SELECTING from an I type which 
runs the setup program... but that's not what I would like to do.

Anyone have any experience with getting this type of thing going?

Cheers,
Stuart Boydell





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Limitations of uvrestore

[Hona, David]

I don't know of anyone who actually relies upon uvbackup/restore for their 
backup/restore strategy.

Other than supposedly support "online" backups and checking file integrity - I 
would see it's relatively slow speed as another reason not to utilise it. Other 
DB vendors tools tend to suffer from similar such drawbacks as well...

The only other comment I'd make is that you don't mention of your AIX rmt 
device block size was set to automatic or not. This may potentially be the 
cause of some of your issues? 

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Tuesday, 3 May 2011 12:13 PM
To: U2 Users List
Subject: [U2] Limitations of uvrestore

I have just finished some testing of uvbackup and uvrestore on AIX and Linux to 
see if there are areas to improve performance.
The results were interesting, and somewhat alarming - see 
http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and-uvrestore/ for 
details.

What I am interested in is:

a)  Do UV platforms other than AIX and Linux have similar issues with 
uvrestore?

b)  Does anyone use block sizes beyond 1mb for uvbackup and uvrestore?
If so, what size and what impact does it have on backup performance?

Thanks

Gregor


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [BDT] U2 Resource View

[Hona, David]

The first two-lines after "Bill:" has the answer ...I can confirm that it is 
correct, as well.

The answer doesn't exist in the manual either...yet one more reason to "hate" 
Eclipse :-)

I can't vouch for the other claims though...

I was initially confused by the response - hence missing the answer too! 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Wednesday, 20 April 2011 4:37 PM
To: 'U2 Users List'
Subject: Re: [U2] [BDT] U2 Resource View

Sorry - but how does that help the op ?

 

 

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: 20 April 2011 00:55
To: U2 Users List
Subject: Re: [U2] [BDT] U2 Resource View

 

Bill:

>From the menus Window->Show View->Other->U2Views, then click on plus and
then click on the U2 Resource to highlight it.  Once it is highlighted click
on the okay button.

The twenty plus people that went to the February Colorado Multi value Users
Group (CMUG) all got training from me on Eclipse plug-ins.  The training was
good for all plug-ins including the one we sell called XLr8Editor and BDT.

Regards,
Doug
www.u2logic.com


On Tue, Apr 19, 2011 at 2:16 PM, Bill Brutzman
wrote:

> I clicked on something (unknown) and lost the U2 Resource View.
>
> I have looked in the BDT manual, Help, and a lot of buttons without much
> luck.
>
> Help would be appreciated.
>
> --Bill
> ___
2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV Common

[Hona, David]

Pick-style BASIC COMMON is documented in the Pick.pdf document in the UV 11.1 
document set.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Thursday, 7 April 2011 1:52 AM
To: U2 List Server
Subject: [U2] UV Common

Can anyone point me to a manual somewhere that describes the differences 
between behaviors in the COMMON basic statement between the different 
flavors of Universe?  Thanks!
-Dianne


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Databasic conversion

[Hona, David]

Also see Pick.pdf in the Rocket U2 UV11.1 document set. It documents the 
differences between D3/PICK and UniVerse.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, 7 April 2011 7:42 PM
To: 'U2 Users List'
Subject: Re: [U2] Databasic conversion

Thanks Bill and Mecki.

 

As ever some fantastic information from this group.

 

 

 

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: 06 April 2011 23:31
To: U2 Users List
Subject: Re: [U2] Databasic conversion

 

Symeon:

I converted our application from D3 to UniData.  There was quite a bit
of work.  I believe I started in Dec 2005 and finished at the end of
March 2006 (I had to work a lot of overtime), and beta tested through
Aug 2006.  We went live with one our clients in Sep 2006 and then 10
more moved over in Nov and Dec 2006.  I spent the next six months moving
most of the rest of our clients to UniData.  I'd say I spent about a
thousand man hours on this.  It could have been half that, but I had no
help from anyone (including IBM/RS) except Colin Alfke in Canada.

I have a lot of emails on this, but the following is one in particular.

HTH,

Bill


- Original Message -
*From:* Bill Haskett
*To:* 'Bob Little'
*Date:* 2/28/2006 6:29 AM
*Subject:* Re: [U2] Changes to mail list configurations

We're mostly done but have spent about 140 man-days.  We spent a fair
amount of our time grinding away with the line editor.  We were
constantly editing data, dictionaries, VOC entries, and BASIC programs. 
We were able to port a few utilities to UD to help (a TCL shell, a file
listing program, a dictionary listing program, and a screen-scroll
program).  We feel that we could have saved about 30% of our time if
there was a decent screen editor, as the productivity was extremely low
with the "stone age" line editor (AE).  This would have saved us about
40 man-days!  We spent about 20% of our time messing around with moving
D3 to UV to UD and all subsequent data moves.  This would have saved us
around 30 man-days.

There weren't too many surprises but there were some.  Here are the
major ones:

1) There was absolutely no interest by IBM in helping us,
2) There were absolutely no utilities to assist in the conversion.  When
I consulted at a large UD user they had converted from Sequoia several
years before and they said there were numerous utilities that converted
their dictionaries and BASIC programs.  These were unavailable to us.
3) We had to convert to UV first then to UD...well, not actually. We had
to move our data to UV, convert the dictionaries, then move to UD. 
However, we eventually found a utility to restore a D3 account to
UniData, which helped tremendously during our client upgrades.
4) There is no (or virtually no) security in U2.  It's handled by the O/S.
5) There are no "users" in U2.  They're managed by the O/S.
6) UD requires a lot more interaction with the O/S.  For instance, since
UD has no 'Q' pointers you have to create file pointers using
environment variables.  In Windows, this requires the creation of the
environment variables on the server...very strange.
7) There is no backup facility in UD.
8) I-Descriptors don't apply to each value in a multi-valued field.  One
has to mange the multi-values as though the dbms was never designed to
have multi-values.  There are separate functions for multi-values and if
one uses a called subroutine, the subroutine has to manage the
multi-values and return an MV array back.

There are also some peculiarities to UD (things you wouldn't believe). 
For instance:

1) COPY MYFILE '1''2''3'
   TO:(ANOTHERFILE
...sometimes doesn't work at all.  COPY, BASIC, CATALOG, DELETE-LIST,
and numerous other VERBS can't handle multiple items in the command
line.  You have to SELECT the items first before executing these verbs.
2) You can't create an account from within UD.  You have to open a DOS
window, create a directory, and execute a DOS command from within this
new directory.
3) A new UD account has all kinds of new UD files created within the
account.  Not really a big deal but surprising.
4) Managing your TERM settings is difficult.
5) Some default settings are weird.  For instance, when compiling a
BASIC program it gets globally compiled and cataloged...like a new MV
user wants this by default?! :-)
6) Items in the SAVEDLISTS file have a number appended to the end so one
won't be able to manage these without using the ...LIST commands.  For
instance "SAVE-LIST BILL" ends up in the SAVEDLISTS file as "BILL000".

Some other things to expect:
+ SAVED LISTS
- In D3 you can "SELECT-LIST ME YOU" and you get a list of both lists.
  In UD you need to "SELECT WHATEVER TO 1" then "SELECT WHATEVER TO 2"
  then "MERGE.LIST 1 UNION 2 TO 3" and hope it works.

Re: [U2] Databasic conversion

[Hona, David]

UniVerse PICK flavour account would probably be - out of the box - the path of 
least resistance.

As UniVerse emulates the PICK D3 environment much better than Unidata.

Unidata was designed to be a clone of Prime INFORMATION - engineered from the 
manual up (which including doing this the PI Manual said it could do, but in 
reality it didn't almost do as published!). 

Bill H has nicely documented stuff for you already in his post and elsewhere on 
the Net:

http://www.rhinocerus.net/forum/databases-pick/305503-migration-d3-universe-doco.html
http://old.nabble.com/RE:-D3-to-U2---how-to-import-a-FileSave-tape-p4361606.html


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, 7 April 2011 7:14 AM
To: 'U2 Users List'
Subject: [U2] Databasic conversion

Hi I am looking at a little side project to convert an entire system written
in databasic on D3 to run on unidata.

 

The guy i work with says it is a couple of hours work - I am not so sure
myself. Anyone done this and know what the 'gotchyas' are ?

 

 

Cheers

Symeon.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] dynamically disassociate associated fields?

[Hona, David]

You can use an alternate dictionary in native or SQL queries...

USING DICT MYALTDICT

Or more practical suggest made by Kate is to have a different dictionary 
definition...


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi
Sent: Thursday, 31 March 2011 4:22 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] dynamically disassociate associated fields?

Hello. I have a rather large MV association that contains around 40 or so I-
type dicts that all call subroutines. Since this is essentially a "subtable" to 
uv/SQL, selecting any field from the subtable causes all the fields to be 
processed, although only the requested field is returned. As you can imagine 
this slows things down a ton. Is there a way to tell universe to *just* process 
the field(s) requested in the SELECT stmt without creating new dicts & 
associations? Thanks.


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Trigger questions

[Hona, David]

When/if you upgrade to UV 11.1 - perhaps you should use Index-based triggers - 
now supported by Rocket. Simpler than SQL-style triggers... see the new 
features.pdf in UV 11.1. Excerpt:

"In some circumstances, an application may not require all of the capabilities 
available to conventional triggers. In these cases, index-based subroutines may 
serve the purpose better because they have reduced overhead, which may 
translate to better performance."


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco
Sent: Friday, 1 April 2011 3:19 AM
To: U2 Users List
Subject: Re: [U2] Trigger questions

While it's working I am getting back:

[error] SQL update failed

> good

But I am also seeing

Error performing trigger for customer 

> but It works the record is not updated

Write failure 
> good

Any idea on why I am getting the error performing trigger when it's obvious 
it's working?

Thanks

Dougc


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] User LogOut Cabbage

[Hona, David]

It is my view that you should never manipulate any UniVerse file (even 
directories) from outside UniVerse (especially when it is up)...without due 
care or being aware of the negative impact, etc.

If you must clear &SAVEDLISTS&, use the vendor supplied CLEAR.FILE command. 

If you execute say "CREATE.FILE MYUNIXDIR 19", it will create ".Type19" within 
the UNIX directory created - common sense says you should do so too. :-)

UniVerse will always use the correct UMASK you define (which should be set in 
your LOGIN or UV.LOGIN so it is consistently applied for every UV process) when 
you use CREATE.FILE.

Good practise dictates you should use the tools and processes provided by the 
vendor unless there is a very good reason(s) why you should not. Of course, 
experienced and brave souls...can do as they deem fit.

I guess as with all advice on here - use it at your own risk - "caveat emptor" 
applies :-)

Regards
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Thursday, 10 March 2011 1:17 AM
To: U2 Users List
Subject: Re: [U2] User LogOut Cabbage

HI,
You don't need the ".Type19" file.  You can do
  rm -R \&SAVEDLISTS\&
  mkdir \&SAVEDLISTS\&
You do need to make sure the permissions are correct on the directory, we have 
found people not having the correct UMASK so people have trouble writing to the 
directory.
Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Tuesday, March 08, 2011 8:22 PM
To: 'U2 Users List'
Subject: Re: [U2] User LogOut Cabbage

Are you clearing your &SAVEDLISTS& directory from UNIX (scheduled or manually) 
and then this error appears?

If so, it is probably deleting the required .Type19 entry (within the 
&SAVEDLISTS& directory.

Possible solution: purge away, but re-create the .Type19 file using 'touch 
.Type19' or the like in your UNIX script. )...refrain from doing when you have 
users logged in too. Perhaps use CLEAR.FILE instead from within UV instead?

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, 9 March 2011 9:35 AM
To: U2 Users List
Subject: [U2] User LogOut Cabbage

When a user here logs out of UniVerse on HP-Ux, it comes back with repeating...

Mkpath: @SAVEDLISTS&/&&S.maryann.14 is not a directory

Suggestions would be appreciated.

--Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] File Corruption

[Hona, David]

Are they dynamic files? Are your cron jobs phantoms or are you using "uvcron" 
(http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron) or something similar?

Any issues recently with locking or UV processes "core dumping" and/or the 
T30FILE semaphore remaining locked/with high collision count?



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney
Sent: Wednesday, 9 March 2011 7:02 PM
To: U2 Users List
Subject: Re: [U2] File Corruption

Yes lots of them and have been for years though this corruption has only
just occured

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan
Fitzgerald
Sent: 08 March 2011 22:51
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] File Corruption


Are you kicking off any uv jobs from cron? More than one? (Clif, wipe
that grin off your face...)
 
> Date: Tue, 8 Mar 2011 13:50:57 +
> From: b...@explore.co.uk
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] File Corruption
> 
> Universe 10
> 
> Aix 5.3
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally
Terhune
> Sent: 08 March 2011 13:23
> To: U2 Users List
> Subject: Re: [U2] File Corruption
> 
> UniData? UniVerse?
> OS vendor/version?
> U2 version?
> 
> Wally Terhune
> U2 Support Architect
> Rocket Software
> 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
> Tel: +1.720.475.8055
> Email: wterh...@rs.com
> Web: www.rocketsoftware.com/u2
> 
> 
> 

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] User LogOut Cabbage

[Hona, David]

Are you clearing your &SAVEDLISTS& directory from UNIX (scheduled or manually) 
and then this error appears?

If so, it is probably deleting the required .Type19 entry (within the 
&SAVEDLISTS& directory.

Possible solution: purge away, but re-create the .Type19 file using 'touch 
.Type19' or the like in your UNIX script. )...refrain from doing when you have 
users logged in too. Perhaps use CLEAR.FILE instead from within UV instead?

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, 9 March 2011 9:35 AM
To: U2 Users List
Subject: [U2] User LogOut Cabbage

When a user here logs out of UniVerse on HP-Ux, it comes back with repeating...

Mkpath: @SAVEDLISTS&/&&S.maryann.14 is not a directory

Suggestions would be appreciated.

--Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Multi-Threading Universe Socket traffic

[Hona, David]

I'd agree with this approach...I've used it many times before...

A good well thought out design well help you...design first: code second :-)

I've in the past done the following:

- control program to configure, start/monitor/stop phantom processes
- I find writing a phantom process which logs what it is doing/done is used for 
debugging purposes too (saves guessing what's going) - just remember to have a 
toggle to turn this on/off for production (to save disk space)
- it is important that each phantom logs its progress, its process ID, start, 
last checkpoint reached and that it has successfully terminated. This helps 
prevent the case of you accidently firing off 100 phantoms and consuming all 
your UV licenses, etc. :-)


The purpose of this is to:
- make the process scalable and tuneable without re-coding via parameter record 
(include things like operating windows, etc)
- have an application to manage the phantoms and monitor what they're doing (or 
if they're doing anything)
- have phantom processes log what they're doing and allow options for a verbose 
logging mode to log everything they're doing in case of problems

Some approaches I've used:

a) each phantom could be started with a unique saved list of record keys to 
processed (generated by a control program or some other process beforehand)
b) each phantom can perform its own query (but sleeping for a specified period 
so not to continuously performing disk I/O)
c) Inbound and outbound transaction phantom process - each handles only 
response or send requests respectively. Such an approach only works if you can 
reconcile the response with the original request. Very application specific and 
not generally optimised for throughput.

We first tested this to get ensure we weren't thrashing the disk I/O with too 
many phantom processes...as this was a pure database read/lock/write type 
transactional batch process. Use performance monitoring tools to help you do 
this. Plus your case - networking monitoring, etc.

Yours needs to be optimised for sockets I/O as well as DB updates. It shouldn't 
be opening/closing socket connections unnecessarily (if that wasn't obvious 
already) - due to the high over head of doing so. Like disk I/O you need to be 
ensure that the path out to your internet connection is already optimised so it 
doesn't contribute to the delays. Likewise that it can support X number of 
connections and your third-party service provider allows you to do this. 

I'd say you need to optimise your socket program first and think about how to 
multi-stream (multi-thread implies low-level OS type functions) your processing.

Care needs to be taken to ensure you design your process with the with 
sufficient error handling to ensure that you don't write an application which 
becomes part of the problem! This is so easy with stuff like this to go amiss. 
:-)

Before you go live - in your test environment - try to break this process 
(overload/kill phantoms). Better it breaks there, than in production. It's 
really hard to fix UV problems, when you have no licenses left :-(

Good luck.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, 7 March 2011 8:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Multi-Threading Universe Socket traffic

Ok the python solution mentioned is one way - however this multi threading
you requiree is not a multi threading requirement - you are consuming a
socket service, and not accepting connections, - we do this kind of thing
all the time using phantoms.

 

Lets say your batch of transactions is in a file, as you process each one
set a flag saying it is done, or delete the record or something, then
yourprogram can select the file, loop through the records and if the flag is
set or the record does not exist it just skips onto the next one. You can
then start 10 processes running all doing the same thing and they will work
through the file. Or you could have process 1 doing all the ones beginning
with a 1, 2 for 2 and so on.  You may want a controlling program that runs
up, counts the records on the file/in the batch and from that determined how
many phantoms to run up. It then runs up the phantoms and then stops.

 

Rgds

Symeon.

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth
Sent: 05 March 2011 16:55
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-Threading Universe Socket traffic

 

 

On Universe 10.1.14 over AIX 5.3, we currently communicate Credit Card
transactions via sockets (ISO-8583) using the following logic (works fine):
  OPEN.ERR=openSocket(THIS.IP,THIS.PORT,TCP.MODE,TIMEOUT,THIS.HANDLE)
  INFO.ERR=getSocketInformation(THIS.HANDLE,PEER.FLAG,SOCKETINFO)
  WRITE.ERR=writeSocket(THIS.HANDLE,SEND.MSG,TIMEOUT,TCP.MODE,SEND.SIZE)

READ.ERR=readSocket(THIS.HANDLE,RECV.MSG,RECV.LEN,TIMEOUT,TCP.MODE,RECV.SIZE
)

I am looking into usi

Re: [U2] Version Control

[Hona, David]

If you are using U2 environment a lot of stuff won't work without utilising the 
VOC some fundamental or critical way. VOC entries for files, programs, 
paragraphs/PROCS, etc. Granted, in some cases these don't change often. Unless 
you are like some poor sites I have seen and run their entire or parts of their 
application process from a paragraph or proc in the VOC file - more common than 
you would like to think or hope!

Likewise, control information inside U2 files are in many case extremely 
critical for many applications - this also needs to be managed and versioned, 
rolled-back if required, etc., etc.

Any configuration management application needs to take everything into account 
not just source code.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Friday, 4 March 2011 1:48 PM
To: 'U2 Users List'
Subject: Re: [U2] Version Control

Hi Bill:

The U2 world works inside the database.  The rest of the world thinks source
code control should be outside the database.  Your use of VOC is very unique
and probably applicable to a small set of the U2 community.  Source code
control, except for U2, is done from the local workstation and not on the
server.

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2 soap server on startup

[Hona, David]

Unless you need a Windows service for specific reason...a Windows  scheduled 
task should be fine. Of course there are pros and cons to that approach such as 
scalability and recovery, etc. Multiple instance sexecuting, etc., etc.

There are many free Windows Run As Service wrappers out there. The free generic 
ones  are very basic and Java unaware.

There are a few Java specific wrappers, including this one:

http://wrapper.tanukisoftware.com/doc/english/download.jsp


From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff 
[jlet...@polkaudio.com]
Sent: Friday, 25 February 2011 1:07 AM
To: U2 Users List
Subject: Re: [U2] U2 soap server on startup

Sorry, Windows
I saw the commands in the manual for runsoapserver and stopsoapserver.  This 
does allow for starting and stopping without using the tools.
The link does help explain where things are operating from, thanks.

I guess the question is, can I make the runsoapserver a service?  Or would it 
be starting the instance of javaw as a service?  Or am I stuck having to login 
and manually start the soapserver?

If I have to just run it manually to insure it is up, then it's not a big 
issue, there are other things I need to do this with.

Thanks for the feedback and info.  Every little bit helps.

Jeffrey Lettau
ERP Systems Manager
polkaudio

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Thursday, February 24, 2011 2:41 AM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] U2 soap server on startup

See the Webservices.pdf in the U2 Documentation. Specifically "Deploying Web 
Services"...If in Windows create your own scheduled task or UNIX - a crontab 
job.

Also, from the archivesthis may help if you like to know what's going on 
behind the scenes (this pre-dates the above chapter being published in that PDF 
guide):
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff
Sent: Thursday, 24 February 2011 8:29 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 soap server on startup

I just noticed a potentially bad thing.  The soap service will only run if you 
run it manually after logging into the server.  If I log off of the server the 
soap service stops running.
I'm guessing the problem is that it is not actually running as a service, but I 
don't see how to make it run as a service.

Does anyone have any suggestions on how to enable a soap server to run on 
startup?

Jeffrey Lettau
ERP Systems Manager
polkaudio


** IMPORTANT MESSAGE *
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential.
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line.
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




Disclaimer: This email may contain confidential and/or privileged information. 
It is intended only for the person or persons to whom it is addressed. Any 
unauthorized review, use, or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email or telephone and 
destroy all copies of the original message.

Please consider the environment before printing this email.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If 

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

[Hona, David]

Oh, did you fix your ODBC problem? :-)
I can't recall you posting any responses back??

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Thursday, 24 February 2011 11:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Telnet session limt has been reached (was Retrieving data from 
remote SQL DB from Universe via ODBC?)

Firstly, my apologies for using an old posting's subject line as clarified in 
the new subject line!
Now, the problem described in my last posting (the body of which was correct!) 
has been solved.  The message in question was actually generated by our 
Universe Administrator's putting a new step in the UV account login paragraph 
and forgetting to tell the Universe development staff (unless I have just 
forgotten being told - quite possible).
Thanks anyone who was wrestling with a response or who has responded already.  
I shall try to expect the unexpected in future before burdening the list with 
such questions. :-)

Ken Ford
Software Engineer 
Brisbane, Queensland, Australia.

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2 soap server on startup

[Hona, David]

See the Webservices.pdf in the U2 Documentation. Specifically "Deploying Web 
Services"...If in Windows create your own scheduled task or UNIX - a crontab 
job.

Also, from the archivesthis may help if you like to know what's going on 
behind the scenes (this pre-dates the above chapter being published in that PDF 
guide):
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff
Sent: Thursday, 24 February 2011 8:29 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 soap server on startup

I just noticed a potentially bad thing.  The soap service will only run if you 
run it manually after logging into the server.  If I log off of the server the 
soap service stops running.
I'm guessing the problem is that it is not actually running as a service, but I 
don't see how to make it run as a service.

Does anyone have any suggestions on how to enable a soap server to run on 
startup?

Jeffrey Lettau
ERP Systems Manager
polkaudio


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Frustrated with Rocket / Unidata 7.2

[Hona, David]

It's impossible to please everyone. My bug report (and the long awaited 
fix...comes before yours :-)
Get to the back of the line!!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, 18 February 2011 2:20 PM
To: U2 Users List
Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2

I dunno man. There's some really good folks in the U2 group but sometimes I
wonder if the decision makers over there ever consider that there are real
people trying to use these products?

On Thu, Feb 17, 2011 at 8:14 PM, Charlie Noah  wrote:

> Totally OT, and I'm just musing here - Rocket, Raining Data then
> TigerLogic. Does anyone besides me see a trend here?
>
>

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

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

Easiest thing to do is look how the subroutine is used now...if you don't 
emulate the same initialisation sequence it requires from UV native runtime 
environment in Java runtime environment...it more than likely will not work.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson
Sent: Thursday, 17 February 2011 1:28 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred

I am new to the U2 java api.  I am trying to make a subroutine call but
get the following Exception.  It is not in the documentation and I have
not had a lot of luck tracking it down.  I am able to make a simple query
so not sure if there is some configuration or something I am not aware of
which is causing the error.

Version Number :4.1.3
Max Open Files :32
Account Path :/mypath
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
[IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode:
30102]Unknown Error [30102]  Occurred
asjava.uniobjects.UniSubroutineException: Unknown Error [30102]  Occurred
at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150)

Any help would be much appreciated.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

We have used "nmon" on AIX. But we don't use UV on AIX here. It's free and 
doesn't come with anything fancy like the commercial toolsets...

I have used GlancePlus on HP-UX. There is an AIX version available and a trial 
can be arranged via:
https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-15-28^9637_4000_100

Whatever tool you use, where it lets you categorise UNIX processes will help. 
In the past, a previous employer hired a consultant from HP to do the analysis 
(GlancePlus temp license came with the consultancy). He put together a report 
to help tune HP-UX and help us identify processes that we needed to optimise.

Whatever the tool, clearly you need to have a good handle of what processes you 
run. You can do additional stuff like have your own "phantom" verb which logs 
when it is fired up and get your any program run as phantom to log it's PID, 
@PARASENTENCE and @SENTENCE values into a log file (along with date time 
stamps, etc). Correlate these with your performance collections stats which 
hopefully includes PIDs and UNIX commands (uv, uvsh, phantom, u2amiproxy, etc, 
etc)..

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Friday, 21 January 2011 11:04 AM
To: U2 Users List
Subject: [U2] [UV][AIX] System Management and Performance Tools

Hi,
Just wondering if anyone has any recommendations for systems 
monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional 
discussions on the topic here over the years.
Ideally, what we would like to do is be able to track down those end of month 
type processes which bog the system down with CPU & IO bottlenecks during peak 
load periods.
I suppose this could be done with something like topas, truss and PORT.STATUS 
but just wondering what is available.
There was a tool called "DPMonitor" that looked like it could be suitable - 
does this exist in any form?
Also, does anyone know if the "Travels with Mark: A Hitchhiker's Guide to the 
UniVerse"
 series on performance tuning is available anywhere. It was on the IBM 
developerworks site but, no more.


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Try the UNLOCK command. Also, I recommend you use "LIST.READU EVERY" to see all 
locks held.

Usage: UNLOCK USER xxx ALL or UNLOCK INODE  ALL (or similar if I recall the 
syntax.

(Copy entries mentioned above from the UV account VOC file, if not present)

NEVER use UNLOCK ALL...unless you wish to potentially wreak havoc on your 
system.  ;-)

The UV Deadlock daemon does periodic clean-ups of locks for dead and deadlocked 
processes - check it's log fie in the UV account to see if it released these 
locks. 

FYI: This is wealth of archived emails for U2-Users email list with lots of UV 
specific info you can Google or use the likes of Mail-archive to search... such 
as this posting:

http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg03438.html

It's quite helpful...as it is impossible to remember all this stuff!


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Garry Smith
Sent: Wednesday, 19 January 2011 11:55 AM
To: U2 Users List
Subject: [U2] LIST.READU - RELEASE (done)

I guess the command RELEASE clears the UV lock table
 
 
---
 
 
 
So great -- LIST.READU shows you some information ...  but how do you
clear these locks
Active Record Locks:

Device Inode  Netnode Userno  Lmode   Pid Login Id
Item-ID. 
   2621441 328100 50   4 RUS1970666

   2621441 328100 48 30 RUS1970676

   2621441 328100  44885   31 RUS1970557
<=  PID  kill what ?? clear ??
   26214417866190  36393  31 RU448659~VG.6

   2621441 328100 82 32 RUS1970438


When I try to kill 44885 as reported by Userno Unix says no such user.
 
clear.locks only looks at your current login session. Any suggestions ?
 
 
UV 9.6 and Aix 5.2

Garry L. Smith 

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Sockets problem

[Hona, David]

Also check and updated your /etc/services with your desired TCP or UDP ports 
you end up using. Saves grief in the future too :)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson
Sent: Tuesday, 11 January 2011 2:38 PM
To: U2 Users List
Subject: Re: [U2] Sockets problem

David,

1024 and below are considered "well known" ports and are reserved for things 
like telnet, ftp, http, etc.

You need to be careful assigning private ports so you don't tramp on other 
assignments.

netstat will show you your current assignments. 
 Don Robinson





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
###

The information transmitted in this message and attachments (if any) is 
intended 
only
for the person or entity to which it is addressed. The message may contain 
confidential
and/or privileged material.  Any review, retransmission, dissemination or other 
use of
or taking of any action in reliance upon this information by persons or 
entities 
other
than the intended recipient is prohibited.  If you received this in error, 
please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or 
distribute
the information contained in this e-mail and any attached files with the 
permission of IMB.
###

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Do you get the same problem with EXECUTE?

BTW: Do you have $OPTION PERF.EQ.EXEC set in your code?

Finally, have you tried adding "SELECT.ONLY" keyword so it only executes if 
there is an active select list (not sure if it can/will check select list 9 
though!).

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Thursday, 6 January 2011 7:58 AM
To: U2 Users List
Subject: [U2] [UV] Invalid SELECT list specification keyword ignored.


Hello,

I have the following command:

SSELECTY VOC FROM 9 TO 10 (10

It works fine from the TCL level but when used in a PERFORM statement in a 
program I get the:

Invalid SELECT list specification keyword ignored.

Error message:

Any ideas ?

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] uonet

[Hona, David]

None of these articles give you exactly want you want...but they should point 
you in the right direction... :-)

Brian Leach posted an example, which may help, some time ago:
http://old.nabble.com/list-DICT-uniObjects-to24476618.html#a24476618

Also Brian wrote this detailed introduction to VB & UO available from the 
U2Users Knowledge Base:
http://109.104.64.69/kb/kbview.wsp?id=10

Brian also has his own website various items with tools, freebies and (for a 
reasonable fee) training manuals, etc.
http://www.brianleach.co.uk/pages/books.htm

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy
Sent: Friday, 7 January 2011 10:02 AM
To: 'U2-Users@listserver.u2ug.org'
Subject: [U2] uonet

I need some help.  I'm writing a front-end program using vb.net and uo.net.  My 
form has single valued fields, text boxes and a datagrid.  My backend is uv 
10.3.3 in windows.

Does anyone have or can they direct me to an example that shows how to loop 
thru a datagrid, pull out the values and update or insert into a uv file using 
uo.net without using UniSubroutine, preferrable using Unidynarray?

Thx,

Rudy


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UVODBC Connection Problem

[Hona, David]

Are you certain the UniRPC daemon is started on your UV HPUX host?

Also I suggest you do a CONNECT to "localuv" via TCL prompt to ensure every is 
OK from UV on your host system before hand...if you are unable to do an local 
connection it's very unlikely a remote connect will work either.

At the TCL prompt, type "CONNECT" and press ENTER/RETURN key - this should show 
all your ODBC data sources from default UCI configuration file. Ensure the 
"localuv" definition is correct for your HPUX host (IP or hostname is correct) 
that you're performing the test on. 

If the "localuv" definition details are all correct, then proceed to connect to 
"localuv" to the application UV account you wish to do the test.

Hope this helps :)



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chambers, Gary
Sent: Thursday, 2 December 2010 7:27 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UVODBC Connection Problem

Bill,

In my example 'uvdbsizes' is the account. Now that you mentioned it I did give 
passing thought to put that account name in caps on the notion it may be 
expected. I will try that.

The file in the account I am going after is UV.DB.SIZES and contains some 
10,000 odd records which are not necessarily complex but the file is dynamic, 
which I neglected to include in previous detail. So, I could try a different 
and trimmed down non-dynamic file.

Thank you for the comments from Gary Smith. I have plenty of new things to try 
and I do hope to be claiming victory soon.

Gary Chambers


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

You don't mention the nature of the processing you're doing...so here's some 
'potential' scenarios... :) But in reality it could be lots of things... 

1) Lost connection to UV

Is it possible you connection is timing out? That is, your UV ODBC connection 
is timing out - possibly? Check the timeout in your unirpcservices file for 
ODBC connections and check what your application is doing - perhaps it is 
opening the connection first, doing a MS SQL query and in the mean time the 
connection is lost?

2) UV SQL Query failure due

Check the log files on the UV side in the account where you queries are 
connecting to for any log files (uvodbc.log or uverror.log, etc) applicable for 
your UV release. Is the files/tables you're querying dynamic hashed files (are 
they OK? Not need of repair/fixing) and have you checked by "manually" doing 
the "same" SQL query from UV itself using the CONNECT verb or at the TCL prompt 
in the account you're connecting to? 

Are there any SQL Updates going on? If so I'd be thinking that there is locking 
contention issues may be happening (such things you can't reproduce on 
demand)...

I also wonder if your process is running out of memory or the like (any core 
files?)...perhaps consider explicitly setting up the buffers in the uci.config. 
But that seems unlikely and perhaps should be a last resort type change! Yet, 
again speculation unless we really know what you're query is doing...

It may be worth while to turn on some UVODBC logging if you still have problems 
- beware of log file sizes though! :) 

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Wednesday, 24 November 2010 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Connectivity issue with ODBC - SQL.



From: Ken Ford 
Sent: Wednesday, 24 November 2010 11:37 AM
To: 'u2-users@listserver.u2ug.org'
Cc: Angel Frost
Subject: Connectivity issue with ODBC - SQL.

Could anyone shed light on the following problem we are having?

We have a Windows 2003 R2, running SQL Server 2008R2 connecting to Universe 
10.3 on AIX 5.3, via UniVerse ODBC driver 3.7

And are getting the error below intermittently (sensitive details represented 
with '*'s):

Message:
Executed as user: ***. The OLE DB provider "MSDASQL" for linked server "**" 
reported an error. The provider reported an unexpected catastrophic failure. 
[SQLSTATE 42000] (Error 7399)  Cannot initialize the data source object of OLE 
DB provider "MSDASQL" for linked server "**". [SQLSTATE 42000] (Error 7303).  
The step failed.

We have checked the user group list archives, and couldn't find anything 
matching this completely.

Thanks for any help you can provide,


Ken Ford
Senior Software Engineer - Universe
"Today, the Universe - tomorrow, the world!"

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Uniobjects on windows mobile/CE

[Hona, David]

Talk about bad timing, it's now moved here:

https://u2devzone.rocketsoftware.com/accelerate/articles/compact-framework/compact-framework

Annoyingly, yet another (separate) user-ID and password is required for this 
site!! :-(

All the U2 articles/tutorials have been moved to:

https://u2devzone.rocketsoftware.com/accelerate/articles/index
https://u2devzone.rocketsoftware.com/accelerate/tutorials/index



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Tuesday, 23 November 2010 3:55 AM
To: U2 Users List
Subject: Re: [U2] Uniobjects on windows mobile/CE

Thanks David, but I got a 404 not found on the link.

I did start a Windows Mobile app in Visual Studio 2008 and added in the 
Uniobjects.NET .dll with no problem. I pasted in the whole "Try" loop 
for establishing a session from another app I had previously developed 
and it seemed to like the syntax/objects just fine. Unfortunately, not 
being in the office today I could only attempt to deploy it to the 
emulator and the deploy blew up quite nicely. I'm not too worried about 
that however since the emulator is notoriously buggy.

Hona, David wrote:
> Check this out:
> https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
> Sent: Saturday, 20 November 2010 4:53 AM
> To: U2-Users@listserver.u2ug.org
> Subject: [U2] Uniobjects on windows mobile/CE
>
> Does anyone know if Uniobjects with work on Windows Mobile or CE?
>   


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Uniobjects on windows mobile/CE

[Hona, David]

Check this out:
https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Saturday, 20 November 2010 4:53 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Uniobjects on windows mobile/CE

Does anyone know if Uniobjects with work on Windows Mobile or CE?
-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] New Client Specifics

[Hona, David]

In fact IBM wrote the basis of what we now call Eclipse...

But Doug's company has been in the U2/MV Eclipse market way before IBM 
U2/Rocket got there...perhaps they were in fact inspired by the U2Logic 
editor.. :-)


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Saturday, 13 November 2010 3:27 AM
To: 'U2 Users List'
Subject: Re: [U2] New Client Specifics

Erm i think IBM have been 'doing' eclipse ever since it first started

 


** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Gregor

Thanks for sharing your useful experiences and your blog.

I found the same issue with U2 MQSeries API documentation too. Although, I 
guess when you are using such complex API's - it helps first to understand the 
underlying technology and concepts. Be it MQSeries or XML, etc. Otherwise, it 
is a case of learning or "mis-learning" two things at once.

I find nearly all documentation from vendors have issues. Be they "specialists" 
in a particular field of a jack-of-trades multi-national software corporation. 
:)

Your mileage will varyas it vary in respect with your own competency and 
the fact "one size" can never fit all skills/knowledge (etc)...be it tools or 
documentation or vendors or consultants! ;-)

I do see value in investing some time/effort in the potential value that 
third-party tools and consultants can provide. Should budget, time and 
capabilities dictate such a requirement. Alas, we rarely have enough the later 
attributes...

Cheers,
David




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Wednesday, 27 October 2010 10:30 AM
To: U2 Users List
Subject: Re: [U2] Building XML using the UV XDOM API functions

I actually like the XML handling built into UV. I have always been a believer 
in using the intrinsic facilities of the database where possible to maximise 
the performance of the process being automated. The XDOM API is a good example 
of this, and is a good fit for our requirements.
My biggest issue is with the poor state of the documentation. It does not allow 
me to easily obtain a good level of competency, which I think is needed to feel 
like I can be productive with a tool, and to feel that the tool is worth using.
Once I got past the documentation and did a lot of testing, and raising cases 
with Rocket Software (the guys here in Australia should now know their XDOM 
backwards!), I have a much clearer understanding of what is possible and what 
the limitations are.

Which is why I created the blog and started adding entries for various aspects 
of the XDOM that were not obvious from the documentation. I just hope it helps 
others get a handle on the XDOM API a bit quicker than I did. It might also 
allow others to better evaluate the XDOM API as a valid toolset, rather than 
discount it out of hand due to FUD, or marketing pressures.

Gregor

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Tuesday, 26 October 2010 3:35 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building XML using the UV XDOM API functions

Gregor, your comments serve as a testimonial to support my
position against using many of these vendor-supplied toolkits.
Some of them are OK, but many not.  People insist on the DBMS
vendors building stuff for them, but then we get the mess that
you've described.  For this reason I continue to recommend at
least consideration for integration with tools that are outside
of the  DBMS.  DBMS vendors should be focusing on making superior
databases, not XML, web services, or a lot of this other fluff.
People in the open source and commercial markets spend a great
deal of time focused on  these things, and because of this, their
offerings are often much better.  So take a look around and weigh
other offerings against the built-in functionality.  It would be
nice to see people here comparing more toolkits - it might save
others from feeling like they're stuck with whatever is provided
by the DBMS vendors.

T

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

Hi Augusto,

Oh, I see. I guess the only option you have is to either move off PowerPC or 
get the AIX for PowerPC - then you can get vUV 10.3.x? I guess that isn't going 
to be cheap or perhaps not feasible for your existing server?

Or perhaps use UV/Net to connect to a server with a later version of UniVerse 
that has 64BIT files? I believe UV file indices are supported via UV/Net...you 
can check with U2 support to double-check.

I guess cost and complexity with help you determine what option suits you 
best...

Hope this helps...

Regards,
David

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
Sent: Friday, 13 August 2010 7:17 PM
To: U2 Users List
Subject: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe 
onPowerPC

Hi David.
The problem is that our App needs a File definition that way:

BIGFILE_1
1: F
2: D_BIGFILE_1
3: I_BIGFILE/INDEX.001

So that, if we distribute BIGFILE, then the indexes will be distributed as
well.
And we loose the single definition for INDEX.001, because we will have
several INDEX.001

Regards
--
Augusto Alonso Alonso
Director de Sistemas
QUITER SERVICIOS CENTRALES
Zoco Gran Santander, 1ª planta - 39011 Santander - España
Telf: +34 902233323 - Fax: +34 902234280

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Hona, David]

I'll second that...

Perhaps some of the large amount of energies expended in this colourful 
exchange can be diverted to a blow-by-blow feature comparison of U2.NET and 
MV.NET for a Spectrum magazine article? :-)

- features
- optimisation
- benefits
- licensing arrangements/schemes
- installed licensed user base figures would be interesting to know
- perhaps some basic "benchmarking" against the same back-end database/server 
would be great :-)

And just for the heck of it - why not throw in the ISS PDP.NET into the mix 
too! 

Just a thought for someone!

David



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, 13 August 2010 6:03 PM
To: 'U2 Users List'
Subject: Re: [U2] mv.NET and U2.NET

So back the original point - what has been done to U2.net in the past 2
years, as a var of udt buying from APT I don't know ! - so i, and it looks
like this group as well,  would like some enlightenment please.  I know how
MV.NET has come on in leaps and bounds and it would be good to compare.


Thanks
Symeon.



** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users