Re: [U2] What is the equivalent to UNNEST in Universe

2013-08-20 Thread Brian Whitehorn
Hi Adrian,

I believe BY.EXP is what you're looking for.

HTH.

Regards,
Brian. 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid
Sent: Wednesday, 21 August 2013 9:39 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] What is the equivalent to UNNEST in Universe

Hi All,

How do you perform a LIST or SELECT in Universe which will unnest or explode 
its Associated Multi Value Data before the query.

For example.

If I have a file called CUSTOMERS which has an association ORDERS.

The DICT on CUSTOMERS have the following.

A single value attribute called CUSTOMER.NAME.

And then a set of a multi value attributes below.
ORDER.DATE 
PRODUCT.KEY
AMOUNT

How to I perform a query to get all the records that have an ORDER.DATE  
20/08/2013 and PRODUCT.KEY = ABC and AMOUNT = 100 when comparing against 
the same multi value position.

I know I can use a Universe SQL query below with the UNNEST keyword to get the 
data.

SELECT CUSTOMER.NAME, ORDER.DATE, PRODUCT.KEY, AMOUNT FROM UNNEST ON ORDERS 
WHERE ORDER.DATE  '20/08/2013' AND PRODUCT.KEY = 'ABC' AND AMOUNT = '100';

How would you achieve the same result using a standard Universe LIST or SELECT 
command. Not a Universe SQL command.



Regards

Adrian Halid

___
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] Sending submitrequest using NTLM authentication

2013-08-13 Thread Brian Whitehorn
Hi Bernard,

Which version of UniVerse are you using to submit the request?

In the 10.3 documentation it states:
Only Basic authentication is supported. Digest authentication may be supported 
in the future. Basic authentication is not safe and is not recommended for use 
with transferring secured data.
I have looked in the 11.1 documentation of setRequestHeader and the above 
condition is not stated.

An alternative would be to SH -c to a cURL and use the --ntlm parameter and 
submit the request outside of UV ?

HTH.

Regards,
Brian.

Brian Whitehorn
Programmer
Toll Priority
T +61 3 9676 1663


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bernard Lubin
Sent: Wednesday, 14 August 2013 10:55 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Sending submitrequest using NTLM authentication

Has anyone been able to send a request using the UniVerse submitrequest() 
function to a server that only supports NTLM authentication?

If so, can you please tell me what type of adjustment is required to the 
header?.  Using the 
setrequestheader(RequestHandle,Authorization,userid:password) results in 
basic Authorization.

Thanks

Bernard Lubin





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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

2013-05-01 Thread Brian Whitehorn
+1

Dan, perhaps something along the lines of uservoice (www.uservoice.com) where 
votes and feedback can be collated might add additional value, this being a 
good example.

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Wednesday, 1 May 2013 3:29 PM
To: U2 Users List
Subject: [U2] Would anyone else like a change to *HS.UPDFINFO?

I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support 
active select lists so that only the files I want built into the .hs_fileinfo 
cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included).

Support inform me that I seem to be the only person interested in such a 
change, so I thought I would at least ask the question of the U2 community.

Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to 
support select lists, or have a new command created that deals with select 
lists?

Thanks

Gregor


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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

2013-05-01 Thread Brian Whitehorn
Gregor,

As a workaround you could perhaps setup an empty account, then set VOC 
entries to point to only the files that you're interested in, and run the 
HS.UPDATE.FILEINFO in the account and access via the HS'ed account ?

But I'd still add my +1 to your suggestion for HS.UPDATE.FILEINFO to be able to 
use a select list.

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Thursday, 2 May 2013 10:34 AM
To: U2 Users List
Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

That has not been our experience.

The actual workings of the program are not well explained in the UV doco. I did 
find in the UV11 UniOLEDB PDF an explanation of sorts:

* Scans the dictionaries of all nonsystem files named in the VOC, finding all 
associations and unassociated multivalued columns.
* Rewrites the file information cache (.hs_fileinfo) under the account's 
directory, based on the above dictionary information and on the contents of the 
HS_FILE_ACCESS file.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Thursday, 2 May 2013 1:57 AM
To: U2 Users List
Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

That would be a nice feature. I do believe that it only processes files with a 
* or *SELECT dictionary item however.


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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniData PE on Fedora 18

2013-02-24 Thread Brian Whitehorn
Hi,

sudo yum install libgdbm.so.2 should find the package containing the required 
library.

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of James Canale, Jr.
Sent: Monday, 25 February 2013 6:39 AM
To: U2 Users List
Subject: [U2] UniData PE on Fedora 18

I'm trying to install the latest UniData 7.3 Personal Edition on Fedora 18
(32 bit) and am not able to find the proper download that seems to be required.

 

The install fails at the point of running systest with 'error while loading 
shared libraries: libgdbm.so.2: cannot open shared object file'.

 

I tried to find libgdbm2 on rpmfind but I'm not sure which to use.  Tried a few 
and they all seem to have additional dependencies.  

 

Any suggestions?

 

I read that UniData on Fedora will work so that's what I tried, but, I also 
have OpenSUSE and Ubuntu if either of those will be better.

 

Thanks in advance.

 

Best regards,

 

Jim

___
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] AIX 5.3 IBMIHS Web Server

2013-02-20 Thread Brian Whitehorn
Kevin,

Do you have more than one Virtual Host defined? If so, it would appear that 
each requires a separate IP to be bound.

Not sure if you've already come across this link, but contains some 
documentation for setting up SSL with IBM HTTP Server:
http://www-01.ibm.com/support/docview.wss?uid=swg21179559

HTH.

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, 21 February 2013 8:35 AM
To: U2 Users List
Subject: Re: [U2] AIX 5.3 IBMIHS Web Server

Where does one get this magical GUI?  I wonder, John, if I am unable to
procure such an animal if I sent you my key file if you could see if you
could nominate a default for me?

On Wed, Feb 20, 2013 at 1:58 PM, John Hester jhes...@momtex.com wrote:

 This would be an IBM support issue rather than Rocket since you're
 dealing specifically with IHS.  You might want to check with the
 customer to see if they're currently under maintenance.  There's a good
 chance they are if the IHS install was recent because AFAIK you can't
 even get the installation files without a support login.

 One other thing you might try is using the iKeyman GUI to create the
 keystore database rather than the command line utility.  That's what I
 always use.  You can run it via an X session, or locally on Windows
 desktop.  I typically create and test a keystore locally on my desktop
 and copy the kdb file to the server when I'm sure it's working
 correctly.  The iKeyman interface is fairly intuitive, and it's easy to
 designate a default cert with the click of a button.

 -John

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
 Sent: Tuesday, February 19, 2013 6:23 PM
 To: U2 Users List
 Subject: Re: [U2] AIX 5.3 IBMIHS Web Server

 I tried checking for a default certificate and it reports null.  The
 KDB file has the GSK certs and my cert - that's it, and when I follow
 the instructions to set up my cert as the default, it gives me a cryptic
 I'm sorry Dave, I can't do that kind of message.

 This is on a customer's system, and they don't have any good paths to
 contact Rocket, as their vendor is entirely unresponsive which is why
 they work with us in the first place, and we're not a var.  So I post
 here and hope someone from Rocket is listening.  Wally, Kevin, Mike, ...
 there've been a number of very good Rocket folks helping out here over
 the years.
  (Apologies for anyone I missed.)

 -K

 On Tue, Feb 19, 2013 at 6:12 PM, John Hester jhes...@momtex.com wrote:

  I doubt the unqualified listen has any connection.  It sounds like
  something's corrupt in the kdb file.  If you only have one cert in the

  file, you might try removing the SSLServerCert directive altogether.
  Normally one cert in the database is marked as the default to use when

  none is specified, and if you only have one, that should be it.  I
  would also create a new kdb file from scratch just to make sure it's
 clean.
 
  If it still won't work after that, I'd suggest opening a case with IBM

  support if you have a current entitlement.  I open cases with them all

  the time for issues with new software installations, and they're
  always very responsive.
 
  -John
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
  Sent: Tuesday, February 19, 2013 4:03 PM
  To: U2 Users List
  Subject: Re: [U2] AIX 5.3 IBMIHS Web Server
 
  Yes, I have both the LoadModule and Listen, though my Listen is
  unqualified, like this:
 
  Listen 443
 
  The error I'm getting in the logs tells me there is no key for api
  or 
  api.client.com (I've tried both) despite the fact that gsk7cmd shows
  that the certificate absolutely is in there.  That's what's vexing; I
  can see the certificate, but for some reason Apache cannot.
 
  You don't suppose the unqualified Listen might have something to do
  with it, do you?
 
 
  On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com
  wrote:
 
   Kevin, I have both chained and self-signed certs on various servers.
   The example from my workstation is a self-signed cert.  Self-signed
   is
 
   actually less prone to error because you don't have to worry about
   importing the intermediate certs into the keystore database.  The
   only
 
   other thing I know to suggest at the moment is verify you're loading

   the IBM ssl module and listening on port 443:
  
   LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443
  
   Are you getting any errors in the IHS SSL logs, either at server
   startup or when you attempt to browse to port 443?
  
   -John
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
   [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
   King
   Sent: Monday, February 18, 2013 5:04 PM
   To: 

Re: [U2] Sleeping in Basic

2012-12-27 Thread Brian Whitehorn
If my memory serves correct, I believe on UniData it's RQM .

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson
Sent: Friday, 28 December 2012 9:07 AM
To: U2 Users List
Subject: Re: [U2] Sleeping in Basic

Doug,
 
If Universe, look at NAP, it does milliseconds.
 
Can't remember what it is in Unidata, maybe SLEEPM?
 

Don 
 
From: Doug Farmer dfar...@epicor.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thursday, December 27, 2012 4:56 PM
Subject: [U2] Sleeping in Basic

Happy holidays all,

I just want to make sure I did not miss something over the U2 releases. Since 
the Microdata Reality days, I have used SLEEP nn to sleep for nn seconds. 
Simple, usually does the trick.

But in today's gotta have it now, I won't wait, environment, a second is 
sometimes way too long.

Is there anything I missed over the last few years to sleep for less than a 
second? I am executing a phantom command from a UniObjects subroutine call and 
waiting for it to finish. I am using a phantom, just in case the program aborts 
or hangs. I am not in control of what code is being run, it could try to read 
or write to an unopened file for example. If the program does hang, I get the 
dreaded Error 30102 message (not helpful at all).

In most cases, the program reads the data it needs and finishes in less than a 
second.  The UniObjects subroutine then writes a flag I can pick up to see that 
the data is ready to return to the UniObjects client.

I don't want the subroutine constantly looping and reading for the flag. This 
would take a lot of the CPU cycles. But, I don't want to wait up to a second to 
see that the phantom has completed.

Any ideas would be helpful. This needs to run on both UniData and UniVerse.

Have a great New Year. One more year older for us experienced developers in 
the PICK community. (circa 1978)

Doug Farmer


This message has been scanned for malware by Websense. http://www.websense.com/ 
___
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


Re: [U2] UniQuery COPY FROM syntax error - Weird behavior

2012-08-01 Thread Brian Whitehorn
Can you compare the VOC entry of COPY in the other working accounts vs. the VOC 
COPY entry in your development account? Do they match?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg
Sent: Thursday, 2 August 2012 7:01 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior

I have encountered a strange problem after mistyping the UniQuery COPY command 
in one of our development environments. The command tried to copy the same 
record to itself and failed gracefully but subsequent attempts to properly copy 
records in this environment fail with a syntax error.

:COPY FROM APPROVALS RECORD1, RECORD1
Copying APPROVALS RECORD1 to RECORD1...
RECORD1 exists in APPROVALS, cannot overwrite
0 records copied


All copy statements now result in the message:


:COPY FROM APPROVALS RECORD1, RECORD2
-^
syntax error


We have several environments on the same server but our dev account seems to be 
the only one affected.

Does anyone have any thoughts on what could be the problem and suggest a 
resolution. Thanks in advance.

Eric

___
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/1FgeDwxYsH/5dEbw3xNr22C0ByWltu3XD/2.212


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


Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

2012-07-03 Thread Brian Whitehorn
I don't have BDT or other Rocket tools installed to confirm, but would 
specifying the same -data workspacepath in the arguments for each achieve 
what you're after ?
(via: 
http://help.eclipse.org/indigo/index.jsp?topic=%2Forg.eclipse.platform.doc.user%2Ftasks%2Frunning_eclipse.htm)

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Wednesday, 4 July 2012 3:23 AM
To: U2 Users List
Subject: Re: [U2] Running XLr8 Tools inside U2 DBTools  new Eclipse release

Hi Dan and others:

I finished testing all of the Rocket tools.  Turns out the only one that really 
works as a plug-in platform is BDT for U2logic plug-ins.  The other products 
are crippled versions of Eclipse with limited menus by design.

Another big problem is that Rocket's Eclipse products do not share work spaces, 
so if you start BDT your work space is in that directory.  If you start U2Admin 
the work space is in that directory.  Unfortunately this situation is very 
messy for U2logic, a Rocket VAR, to support.  I'm going to have fun explaining 
this to the first client that asks why the programs don't share the server 
names.

Regards,
Doug
www.u2logic.com
___
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/1F4dy0mK0d/4ZdT5DKh528rfiCd3YgdAP/0.204


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


Re: [U2] Hushing commands

2012-02-23 Thread Brian Whitehorn
EXECUTE COUNT VOC CAPTURING L.OUTPUT

$0.02


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, 24 February 2012 9:06 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Hushing commands


EXECUTE HUSH ON
EXECUTE COUNT VOC
EXECUTE HUSH OFF

vs

HUSHUP
001 EXECUTE HUSH ON
002 EXECUTE OCONV(@COMMAND,'G1 99')
003 EXECUTE HUSH OFF

HUSHUP COUNT VOC
___
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/1EcnqsTclK/7r1idlTYp6E4BPfC9wEAdI/1.602


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


Re: [U2] AIX uname and Redback

2011-08-04 Thread Brian Whitehorn
Do you also get a discrepancy when running uname -f on its own via command 
line / UO vs Redback?

-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 3:37 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] AIX uname and Redback

We have a client who found uname -Fa on AIX 5.3 doesn't return
the unique system ID value when run through Redback.  Suggestions
are welcome about how to get the whole value.  For example:

From the command line and UO the result from 'uname -Fa' is:
AIX hostname 3 5 ccsp mmmccs

From a Redback connection that 'longnid' value is missing:
AIX hostname 3 5 ccsp

See the following page for details about how uname has changed in
5.3.
http://www.ibm.com/developerworks/aix/library/au-aix-systemid.htm
l

Rocket has not been able to identify the cause.  I guess they
don't have access to IBM resources anymore. ;)  It's my current
guess that Redback is running in 32bit mode and that the longnid
may only be generated for 64bit applications, but I can't test
that.

This is important for my purposes as uname is used as a component
of the security mechanism to lock NebulaXLite and other software
to a single system.  I don't care what the value is, but I need
it to be reported consistently.  For now I'm issuing a
site-specific version of the software so they can move forward,
but I'd like to understand the problem.

Thanks!

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno

___
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/1CQK4QfHQ5/3GgY9SbKsoivEM6T5EzzGf/0


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


Re: [U2] [UV] SET.SQL SELECT.BUFFER from UNIOLEDB Client?

2011-04-12 Thread Brian Whitehorn
Not sure if this would work, but would it be possible to include
SET.SQL SELECT.BUFFER 
in the LOGIN in the VOC?

Cheers,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Wednesday, 13 April 2011 2:50 PM
To: U2 Users List
Subject: [U2] [UV] SET.SQL SELECT.BUFFER from UNIOLEDB Client?

Does anyone know how to get around a low SELBUF (.uvconfig) from an OLEDB (or 
ODBC) client?

From TCL I can run SET.SQL SELECT.BUFFER 

From my UNIOLE DB client I am getting an Abort!

Can't change SELBUF.

Cheers
Stuart





___
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/1C60HT2uQI/3rzZlKIa1Yr5ZAbAHOQgBv/0.6


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


Re: [U2] Is this worth rewriting?

2011-03-02 Thread Brian Whitehorn
007:   IF TEA # '' OR EAT # '' OR ATE # '' THEN CUM(M) = TEA + EAT + ATE
to
007:   IF (TEA : EAT : ATE) # '' THEN CUM(M) = TEA + EAT + ATE

likewise,
011:   IF YAM # '' OR AMY # '' OR MYA # '' THEN
to
011:   IF (YAM : AMY : MYA) # '' THEN

AU$0.02.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson 
[DATACOM]
Sent: Thursday, 3 March 2011 11:47 AM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] Is this worth rewriting?

Agreed that the dimensioned extract wouldn't make much difference, still the 
attributes numbers are quite high.

The code below goes from 15 extracts maximum per for-next loop to 6.
I can't help but think this might mean something if it takes 90 minutes to run.

001: MONTHLY.USAGE:
002: CM = MONTH + LY.CNT
003: FOR M = 1 TO 12
004:   TEA = PARMS(12)101,CM
005:   EAT = PARMS(12)133,CM
006:   ATE = PARMS(12)134,CM
007:   IF TEA # '' OR EAT # '' OR ATE # '' THEN CUM(M) = TEA + EAT + ATE
008:   YAM = PARMS(7)100,CM
009:   AMY = PARMS(7)101,CM
010:   MYA = PARMS(7)102,CM
011:   IF YAM # '' OR AMY # '' OR MYA # '' THEN
012: IF YAM # '' THEN CUMO(M) += YAM ELSE CUMO(M) += TEA
013: IF AMY # '' THEN CUMO(M) += AMY ELSE CUMO(M) += EAT
014: IF MYA # '' THEN CUMO(M) += MYA ELSE CUMO(M) += ATE
015:   END
016:   CM -= 1 ; IF CM = 0 THEN CM = 24
017: NEXT M
018: RETURN


So I'd say AYE - or YEA, if you use meaningful variables

Regards, Keith

___
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/1BP44gKpel/56DrG1wRmlu33A3lhc6Vco/0.6


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


Re: [U2] Clear Message Initiative - Logging Errors to a U2 File

2011-02-09 Thread Brian Whitehorn
SYSTEM(9001) in UV I think.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton
Sent: Thursday, 10 February 2011 10:46 AM
To: 'U2 Users List'
Subject: Re: [U2] Clear Message Initiative - Logging Errors to a U2 File

In UniData we can get that from a SYSTEM(49) I think.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, February 09, 2011 5:37 PM
To: U2 Users List
Subject: Re: [U2] Clear Message Initiative - Logging Errors to a U2 File

Is there a way to capture the name of the program, sub, and current line of
UniBasic code?

For example, the user at the Dock tries to ship out a quantity of of parts
more than are in the inventory bin location.  The UniBasic program calls a
sub to splash an error message to the user's screen, and then log the user,
date, time and message to the ERROR.LOG file.  How can we capture what
program he is running?  How do we capture the UniBasic code line number.

For this scenario, I cannot see how a table of standard error codes would
apply.

Suggestions would be appreciated.

--Bill
___
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
--
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/1BGp3TxS1V/2aTZffgh2AhyEN8qnot2vf/0.002


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


Re: [U2] UniObjects on windows

2010-12-12 Thread Brian Whitehorn
Hi Doug,

Have you allowed UniObjects to connect through your windows firewall? May need 
to allow TCP port 31438 on the windows firewall setup.
You can confirm that rpc is running on the windows machine? From cmd prompt on 
the windows server if you telnet 127.0.0.1 31438 does it open a session?

Cheers,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Monday, 13 December 2010 09:53 AM
To: U2 Users List
Subject: Re: [U2] Uniobjects on windows

Thanks Bill,
sorry I should of been a little more specific,  I am using a
modified version of the examples form that article and it works
accessing my main universe system (aix) but the exact same code does not
work accessing the windows universe system I setup using 10.3.3 on
windows server 2008.

I am getting 81015 which according to the documentation is:

81015 UVE_RPC_TIMEOUT The connection has timed out

since this is the EXACT same PHP code that works accessing our aix
system, it has to be something with the server I setup or something I
missed with setting uniobjects and that's what I need help with.

dougc


On 12/12/2010 3:00 PM, Bill Haskett wrote:
 Doug:

 Check out the Pickwiki at
 http://www.pickwiki.com/cgi-bin/wiki.pl?Accessing_U2_From_PHP

 HTH,

 Bill


___
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/1Bi6syGRAw/5pzz5esgEyWf54EMnqLWqi/0.002


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


Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

2010-04-20 Thread Brian Whitehorn
Silly question, but are the firewall and allowed ports setup the same on
both?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, 21 April 2010 01:19 AM
To: U2 Users List
Subject: Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB

But David, it works without the domain on that other box.  (Oh, and the
server in this situation is an AIX box.) The client is simply trying to
recreate the connection that works on another box.

New information: The memory of the failing box has been expanded to 4G and
the customer has installed a version of the UniOLEDB driver that I have
working here.  In fact, I have this very same UniOLEDB driver plugged in as
a linked server in my SQL Server 2008 and it works without drama.

The test.udl file as recommended by Colin is now able to make a connection,
but that's where it stops.  With the linked server configured inside of the
client's SQL Server 2005, a query issued against that linked server returns
this:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider IBM.UniOLEDB for linked server ADS reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider IBM.UniOLEDB for
linked server ADS.

I've verified the user ID and password and I'm confident they're correct.
And I've tried logging into SQL Server both using Windows authentication and
also SQL Server authentication, with no difference.  And as I said, I have
it working here with SQL Server 2008 and the same UniOLEDB driver.  So could
there be some weird Windows security issue, maybe something preventing the
OLEDB infrastructure from instantiating the UniOLEDB driver?  I've checked
permissions on the UniOLEDB.dll and that looks all good, i.e. it matches the
other server.

So given all that, what am I missing?
___
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/1zIPCXRinU/3LHEOd0mWYZKrZqmnxKuCB/0.6


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


Re: [U2] SELECTs on FILEs

2009-12-13 Thread Brian Whitehorn
Not sure about UD, but on UV this would result in a filescan:

SELECT CUSTOMER WITH @ID = AAA] EXPLAIN
Optimizing query block 0
Tuple restriction: F0 MATCHES ''AAA'...'

Driver source: CUSTOMER
Access method: file scan

UniVerse/SQL: Press any key to continue or 'Q' to quit

0 record(s) selected to SELECT list #0.

HTH,

Regards,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, 14 December 2009 11:15 AM
To: U2 Users List
Subject: [U2] SELECTs on FILEs

Hi all,

 

Just a quick question on SELECTs for UD.

 

I was under the impression that performing a wildcard SELECT with @ID
would only result the key section of a FILE been read.

 

Eg, SELECT MYFILE WITH @ID = prefix]

 

Is this incorrect? Does it actually result in the entire FILE being read
into memory to complete this SELECT?

 

Regards,

Dan



###
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
-- 
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/1ySixwy6Eo/3i2V58ugRT0g7JgXdX3Hyi/8.65
3


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


Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial

2009-11-18 Thread Brian Whitehorn
Have you defined NO.NULLS on the DATE field index?

The condition less than equal to will be catering for  or Null as being
less than 0, whereas the SELECTINDEX in the program version will be using
Date values (hence missing the less than equals part.

$0.02, HTH.

Cheers,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav
Sent: Thursday, 19 November 2009 3:02 PM
To: U2 Users List
Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial

I do not know what is causing the peformance problem with Unidata and 
indexed fields, using large key.  In the case of this particular file, there

are translated fields that have to be built separately from the other 'D' 
type fields.  The field in questions, that I was selecting on, was a date 
field.  The date range was one day.  What I ended up doing was a for/next 
loop selecting on each day in the date range.  Dates in this file are fairly

densly used, so there are not that many days that have no data.  Regardless,

the direct select is much faster than the date range.


This is very fast code in Unidata:

SUBROUTINE SELECT.DATE.RANGE(START,LAST,FILE)

DATELIST=
FOR DATE=START TO LAST
SELECTINDEX DATE,DATE FROM FILE TO 1
READLIST LIST FROM 1ELSE LIST =
IF LIST ELSE CONTINUE
DATE.LIST-1=LIST
NEXT

FORMLIST LIST TO 0

RETURN

However, I would prefer to do this:

SELECT FILE WITH DATE = 'START' AND DATE = 'LAST'


- Original Message - 
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Sunday, November 08, 2009 8:37 AM
Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial


 Hi Brad

 Interesting, but I wonder about another possibility..

 As a partial field the select would be using an I-Descriptor or
 V-Descriptor. I wonder whether the overhead on that is the problem: if you
 crated a V-Type to access the date field in the new file (e.g. using
 EXTRACT(fieldname,0,0) ) would that show the same difference in 
 performance,
 rather than the data structure?

 Just wondering..

 Brian

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav
 Sent: 07 November 2009 20:10
 To: U2 Users List
 Subject: [U2] Unidata - Key Stucture - Compound Keys or Sequetial

 Subject: Keys, Large Transaction Files,

 Just recently ran into an interesting phenomenon - I was working with a 
 file
 with compound keys and the selects over a date range were atrocious.  I 
 copy
 the data to a new file, using sequential keys and the selects averages
 200-2000X faster (for the doubters, I have to say is the actual # were
 something like 197X to 2070x, the second # being as second select after 
 the
 data was cached). The avg length of key on the file was 32 characters. 
 The
 avg length of a sequential keys was about 5 characters.  The fields was a
 'date' field.  The field was indexed.  The range of the select was 2 days.
 It seems there's a Unidata threshold large key sizes exceed with indexing
 that kills peformance.

 Also, sequential keys hash the best.  I managed a file with 80M records at
 another site and had no problems with file sizing or overflow.

 Brad


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 No virus found in this incoming message.
 Checked by AVG - www.avg.com
 Version: 9.0.698 / Virus Database: 270.14.55/2489 - Release Date: 11/08/09
 07:37:00

 ___
 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
-- 
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/1yI4xZInoq/1fKqhkxB9S90xqvK6lOGGn/6.2


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


Re: [U2] UV Call Stack

2009-10-26 Thread Brian Whitehorn
UV equivalent is SYSTEM(9001)

HTH.

Cheers,
Brian.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen
Sent: Tuesday, 27 October 2009 3:48 AM
To: U2 Users List
Subject: [U2] UV Call Stack

I had a trigger question last week, and I received some help from the
list (thanks!), and I have another question.

 

A member of the list sent me a program that he uses for triggers, and
it's really nifty, except it uses a U2 function - SYSTEM(49) - that
doesn't seem to have an equivalent in UV.

 

ARGGG.

 

The most important part of this trigger is to get the call stack and
write it out so that I know what program is writing this garbage out.

 

Something like this:

 

Procedure is: KEB; pc = 5C; source line = 20

Called from: PRE.KEB; pc = 6; source line = 13

 

PRE.KEB was the main-line program - called KEB @ line 13.

 

Broke out of KEB at line 20.

 

I need programs and source code line#s. If RAID can show it to me, it's
got to be accessible somehow, right?

 

 



Karen Bessel
Software Developer

Tyler Technologies, Inc.
6500 International Parkway, Suite 2000
Plano, TX 75093
Phone: 972.713.3770 ext:6227
Fax: 972.713.3780 
Email: karen.bes...@tylertech.com
Web: http://www.tylertech.com
___
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/1yypGG57qA/21zojI7YlqsFipd37QZx4v/6.2


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


Re: [U2] Locking records in host subroutine w/uniobjects

2009-09-29 Thread Brian Whitehorn
Hi,

If you open the file placing the file handle variable in common, should do
what I think you're looking for.

See HELP BASIC COMMON for information regarding the common storage area for
variables.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ack_9_ball
Sent: Wednesday, 30 September 2009 4:58 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Locking records in host subroutine w/uniobjects


I'm calling a host subroutine using uniboject.  I want the host subroutine
to
do a readu and keep the record locked between calls.  Is there a way to do
this?  From what I can tell the lock goes away after the subroutine exists.
-- 
View this message in context:
http://www.nabble.com/Locking-records-in-host-subroutine-w-uniobjects-tp2566
8748p25668748.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
-- 
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/1ynwfEYv8Q/Gi1nmHNST1um7oWKOC7qt/1.712


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


RE: [U2] Re: [UV] Passing a string when a Matrix is expected

2009-04-16 Thread Brian Whitehorn
INMAT() looks like it may do the job for you. HTH.

  INMAT function
  _

  SYNTAX

INMAT ( [array] )

  DESCRIPTION

 Use the INMAT function to return the number of array  elements
 that  have  been  loaded  after  the  execution  of a MATREAD,
 MATREADL, MATREADU, or MATPARSE statement, or  to  return  the
 modulo of a file after the execution of an OPEN statement. You
 can also use the INMAT  function  after  a  DIM  statement  to
 determine  whether  the  DIM  statement  failed due to lack of
 available memory. If a preceding DIM  statement  fails,  INMAT
 returns a value of 1.

 If the  matrix  assignment  exceeds  the  number  of  elements
 specified  in  its dimensioning statement, the zero element is
 loaded  by  the  MATREAD,  MATREADL,  MATREADU,  or   MATPARSE
 statement. If the array dimensioning is too small and the zero
 element has been loaded, the INMAT function returns a value of
 0.

 If array is specified, the INMAT function returns the  current
 dimensions of the array. If array is the null value, the INMAT
 function fails and the  program  terminates  with  a  run-time
 error message.

  EXAMPLE

DIM X(6)
D='123456'
MATPARSE X FROM D,''
   
Y=INMAT()
PRINT 'Y= ':Y
*
DIM X(5)
A='CBDGFH'
MATPARSE X FROM A,''
C=INMAT()
PRINT 'C= ':C
*
OPEN '','VOC' TO FILE ELSE STOP
T=INMAT()
PRINT 'T= ':T

 This is the program output:

Y= 6
C= 0
T= 23


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Friday, 17 April 2009 7:27 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Re: [UV] Passing a string when a Matrix is expected

I came accross a case in legacy code where a subroutine is defined to accept
some matrixes as parameter ei:

SUBROUTINE FOOBAR(TXT, MAT A, MAT B, MAT C, MAT D, OPTION)

One of the calling programs that makes use of this subroutine does this:

CALL FOOBAR(HELLO, , , , , WORLD)

Instead of passing a matrix, it is passing an empty string.  

The result is that in FOOBAR, matrixes  A, B, C and D are of size zero.   In
FOOBAR there is code that does:

MATBUILD REC.A FROM A USING CHAR(1)

Now the MATBUILD command on a matrix of size zero is giving me an undefined
variable in a test program I wrote but in the program in production, it is
giving me the content of a variable in the program.

I was wondering if there is a way to detect if a matrix is of size zero in
Unibasic.   
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-- 
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au/rr

Click here to report this message as spam:
https://login.mailguard.com.au/report/1xh3PzGPBt/7m4U8ME624iLZKoyw58t7e/0.6
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2][UD] Index for @ID (IBM documentation)

2009-01-29 Thread Brian Whitehorn
IMO, if the index has been created with NO.NULLS, then the = would require
the file to be scanned as there is a possibility of a  in the data that
would not be index'ed.

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, 30 January 2009 7:18 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2][UD] Index for @ID (IBM documentation)

Martin, are you sure?  I would expect the query optimizer to see the = and
cancel the use of the index.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] unibasic select woes

2007-06-01 Thread Brian Whitehorn
You can use EVAL in your select to do what you want for the MCU ...


+---
---+
|
|
| EVAL
|
|
|
| _
|
|
|
|
|
|Use in any  RetrieVe  sentence  to  introduce  an  in-line  I-
|
|descriptor  expression.  An  EVAL  expression  defines  a  new
|
|virtual field which  exists  only  for  the  duration  of  the
|
|current query. Its syntax is as follows:
|
|
|
|   EVAL i.type.expr [qualifiers]
|
|
|
|i.type.expr is any expression  that  can  be  used  in  an  I-
|
|descriptor, enclosed in single or double quotation marks.
|
|
|
|qualifiers  can  be  one  or  more  field  qualifier   clauses
|
|beginning  with the following keywords: AS, ASSOC, ASSOC.WITH,
|
|COL.HDG, CONV, DISPLAY.LIKE, DISPLAY.NAME,  FMT,  MULTI.VALUE,
|
|
|
|   More   End Help  List Commands
|
+---+ Page Down
+--+



See help eval for more details ...

Regards,
Brian.


Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar: 
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to mailto:[EMAIL 
PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Universe on Windows login setup

2007-04-26 Thread Brian Whitehorn
perhaps have a basic program run from the logic proc that could check
@LOGNAME (the windows userid thats logged in via universe telnet), and
if its the vendor user then EXECUTE 'DOS' which will then take them to
the windows command prompt..

Regards,
Brian.




Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] QSELECT in transaction

2006-07-31 Thread Brian Whitehorn
Whats slightly confusing / inconsistent is that an EXECUTE with SELECT /
SSELECT is catered for inside a transaction but not QSELECT? Why allow /
cater for one and not the other?

-Brian.


Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar: 
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to mailto:[EMAIL 
PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] QSELECT in transaction

2006-07-26 Thread Brian Whitehorn
Hi,

is there a way to allow an EXECUTE QSELECT...  inside a transaction in
a basic program. The HELP BASIC EXECUTE specifies a few verbs that are
allowed inside transaction :

if a SELECT / SSELECT is allowed, cant a QSELECT be allowed aswell? Or
might I be missing something? Any ways to overcome this? Thanks.

Regards,
Brian.

+---
---+
|The EXECUTE statement fails and the program terminates with  a
|
|run-time error message if:
|
|
|
|o  dynamic.array or expression in the IN clause evaluates to  the
|
|   null value.
|
|
|
|o  The command expression evaluates to the null value.
|
|
|
|Although  you  cannot  use  the  EXECUTE  statement  within  a
|
|transaction   to   execute  most  UniVerse  commands  and  SQL
|
|statements, you can  use  EXECUTE  to  execute  the  following
|
|UniVerse commands and SQL statements within a transaction:
|
|
|
|   CHECK.SUM  INSERT   SEARCH  SSELECT
|
|   COUNT  LIST SELECT (RetrieVe)   STAT
|
|   DELETE (SQL)   LIST.ITEMSELECT (SQL)SUM
|
|   DISPLAYLIST.LABEL   SORTUPDATE
|
|   ESEARCHRUN  SORT.ITEM
|
|   GET.LIST   SAVE.LISTSORT.LABEL
|
|
|
|   More   End Help  List Commands
|
+---+ Page Up/Page Down
+--+




Verb QSELECT illegal when a transaction is active.

Rolling back uncommitted transactions begun within this execution
environment.



Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [JOB] UniVerse Developers

2006-05-08 Thread Brian Whitehorn
OUTsurance is a dynamic company that runs world-class in-house IT
systems and uses state of the art technologies. We are one of the
largest users of Universe technologies in South Africa.



Job Requirements:

We require an individual with at least 6 years of UNIVERSE DATABASE
experience to join our dynamic team of system developers. We are looking
for a 'hands-on' technical expert with excellent programming skill and
the ability to work independently and under pressure. Attention to
detail and a quality orientation are essential.



Salient Features:

The incumbent will be specialist in both UNIVERSE and SB+ technologies.
Web design including .Net skills would be advantageous.



Job Responsibilities:

Together with a team of developers, the incumbent will assume full
responsibility for development and maintenance work on the in-house
system. This includes meeting stringent quantity and quality criteria. A
high tolerance for stress is essential.



Interested South African applicants must email a comprehensive CV to
[EMAIL PROTECTED] or fax to Suren Naidoo on 012 673 4940.







Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Resize concurrent

2006-02-08 Thread Brian Whitehorn
Hi,

just wanted to check with the group if anyone has resized large file/s
using the concurrent option. Good / Bad / any gotcha's to lookout for?


Regards,
Brian.




Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]

FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [AD] [UPDATED] UniVerse Developer

2006-01-25 Thread Brian Whitehorn
UPDATED:

OUTsurance is a dynamic company that runs world-class in-house IT
systems and uses state of the art technologies. We are one of the
largest users of Universe technologies in South Africa.



Job Requirements:

We require an individual with at least 6 years of UNIVERSE DATABASE
experience to join our dynamic team of system developers. We are looking
for a 'hands-on' technical expert with excellent programming skill and
the ability to work independently and under pressure. Attention to
detail and a quality orientation are essential.



Salient Features:

The incumbent will be specialist in both UNIVERSE and SB Plus
technologies. Web design including .Net skills would be advantageous.



Job Responsibilities:

Together with a team of developers, the incumbent will assume full
responsibility for development and maintenance work on the in-house
system. This includes meeting stringent quantity and quality criteria. A
high tolerance for stress is essential.



Interested South African applicants must email a comprehensive CV to
[EMAIL PROTECTED] or fax to Suren Naidoo on 012 673 4940.







Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [AD] UniVerse Developer

2006-01-24 Thread Brian Whitehorn
OUTsurance is a dynamic company that runs world-class in-house IT
systems and uses state of the art technologies.

We are one of the largest users of Universe technologies in South
Africa.

Job Requirements:

We require an individual with at least 6 years of UNIVERSE DATABASE
experience to join our dynamic team of

system developers. We are looking for a 'hands-on' technical expert with
excellent programming skill and the ability

to work independently and under pressure. Attention to detail and a
quality orientation are essential.

Salient Features:

The incumbent will be specialist in both UNIVERSE and SB Plus
technologies. Web design including .Net skills would

be advantageous.

Job Responsibilities:

Together with a team of developers, the incumbent will assume full
responsibility for development and maintenance

work on the in-house system. This includes meeting stringent quantity
and quality criteria. A high tolerance for stress

is essential.

Interested applicants must email a comprehensive CV to [EMAIL PROTECTED]
or fax to Suren Naidoo on 012 673 4940.





Important Notice: This email is subject to important restrictions,
qualifications and disclaimers (the Disclaimer) that must be accessed
and read at the following address or by copying and pasting the following
address into your Internet browser's address bar:
http://www.frstia.co.za/Disclaimer.asp

The Disclaimer is deemed to form part of the content
of this email in terms of Section 11 of the Electronic Communications
and Transactions Act, 25 of 2002. If you cannot access the Disclaimer,
please obtain a copy thereof from us by sending an email to
mailto:[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/