[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

[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

[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

[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

[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

[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

[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

[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

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

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

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

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

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

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

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]

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?

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

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:

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,

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:

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

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,

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

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

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:

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

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

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

Re: [U2] Sending submitrequest using NTLM authentication

2013-08-13 Thread Brian Whitehorn
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

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