Re: [U2] Scrub Hangs Up

[Richard Wilson]

Just in case I'm not missing something does HS.SCRUB
create voc entries for each dictionary?

normally there is no voc item for D_anything

and shouldnt the copy be

COPY FROM DICT INVOICE TO whereever ALL

rICH
On 8/28/2012 7:21 PM, Bill Brutzman wrote:

Good question... I looked into this earlier.

The VOC entry for D_INVOICE is blank... but... so are all of the other VOC 
entries for dictionary items.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Subject: Re: [U2] Scrub Hangs Up


What's the VOC entry for D_INVOICE look like?



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



--
Richard A Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   206-202-2064

___
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

[Richard Wilson]

I dont remember is it U vs P mode in Unidata, I dont have an active install

try lower case "copy" so Prime information copy style should kick in

Eric Malmberg wrote:
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

  


--
Richard A Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   206-202-2064

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

Re: [U2] UniVerse LIST statement question [not-secure]

[Richard Wilson]

could you setup an index based on employee number.?

then possibly use that index against employees active for June

Rich

Hennessey, Mark F. wrote:

I need to do a UniVerse LIST statement that would only populate a column if the 
contents met certain criteria.

For example, suppose we have a file with details of telephone usage and that 3 associated 
mulitvalued fields contain date call was made, duration and if the call was a toll call. 
Is it possible to limit the output of the "date call made" and associated 
columns to a date range without that being a select criteria? If I were to do something 
like:

LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH DATE.CALL LE 
"2012-06-30"  DURATION TOLL WITH @ID EQ '123456'

I would get zero record if employee 123456 did not make any calls in June. What 
I would like to see is the employer name and location returned with the date, 
duration and toll columns empty. I'm trying to do this in a LIST statement as 
it will be run by U2 Web Services (and for the time being a subroutine is off 
the table...)

Any advice, or an authoritative "NO, It can not be done" would be greatly 
appreciated.

Mark Hennessey
State of Connecticut
Department of Social Services
Information Technology Services
Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4813



CONFIDENTIAL INFORMATION: The information contained in this e-mail may be 
confidential and protected from general disclosure. If the recipient or reader 
of this e-mail is not the intended recipient or a person responsible to receive 
this e-mail for the intended recipient, please do not disseminate, distribute 
or copy it. If you received this e-mail in error, please notify the sender by 
replying to this message and delete this e-mail immediately. We will take 
immediate and appropriate action to see to it that this mistake is 
corrected.[*LD*]
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

  


--
Richard A Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   206-202-2064

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

Re: [U2] BETWEEN operator

[Richard Wilson]

try it in within an sql construct

my UV voc BETWEEN item shows
Keyword - SQL selection criteria
508


Wjhonson wrote:

Curious you're right.  I have a Between in my VOC
But if I do something like

LIST VOC BETWEEN
or
LIST VOC IF @ID BETWEEN 1 AND 2
or anything like that I just get an error

Unexpected symbol.  Token was "BETWEEN"

So I have no idea why it's in the VOC, maybe it's a left over from Prime days


-Original Message-
From: Allen Egerton 
To: U2 Users List 
Sent: Wed, Apr 18, 2012 12:18 pm
Subject: Re: [U2] BETWEEN operator


Universe release 10.3.7 on a Windows platform.
oc entry BETWEEN
1> K
2> 508
No online help for it, and intuitive guess how to use it didn't work,
ut it's definitely there


n 4/18/2012 3:04 PM, Wjhonson wrote:
 
 The BETWEEN only exists in Unidata's Uniquery

 Not Universe, as far as I can see anyway.
 Unless they *just* put it into 11. or something
 
snip>

__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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

  


--
Richard A Wilson
Lakeside Systems
Smithfield, RI, USA
Voice 401-231-3959
Fax   206-202-2064

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

RE: [U2] [UV] How does UV authenticate to Windows

[Richard Wilson]

We are being audited for SOX and they asked the question about how Universe
authenticates. It appears centre around to be how fraud can be perpetrated.

-Original Message-
From: Bob Woodward [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 8:59 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] How does UV authenticate to Windows

Hi Mike.

I don't think SOX requires you to be running any version of anything.
>From what I understand, SOX is an accountability requirement.  Auditing
is of the reliability of that accountability, not the actual SOX
requirement itself.  Also, I just checked and Win2k has transitioning to
EXTENDED support, not unsupported, status.

Bob Woodward
Programmer/Analyst
Harbor Wholesale Grocery
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR
> Sent: Monday, July 11, 2005 3:29 PM
> To: u2-users@listserver.u2ug.org
> Subject: [SPAM] - [ ] - RE: [U2] [UV] How does UV authenticate to
Windows
> 
> Barry
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Barry
Brevik
> > Sent: Tuesday, 12 July 2005 09:26
> > To: U2-users (E-mail)
> > Subject: [U2] [UV] How does UV authenticate to Windows
> >
> > UV 9.6.1.3 on Windows 2000.
> Hmm ... Running an unsupported version of the DBMS on an unsupported
> (since 1st July) O/S version.
> How can you pass a SOX audit?  ;-)
> 
[snip]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Write error in UniAdmin

[Richard Wilson]

Are you trying to add a tape device? If so you need to manually edit the
&DEVICES& file.

-Original Message-
From: Paul Hamrick [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 23 June 2005 10:54 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Write error in UniAdmin

The last two installations I have received the following errors when
attempting to create a device under Devices in UniAdmin 1.3.1. The error
is "Unable to write device record to &DEVICE&. This is UniVerse 10.1.11
for Windows.
 
Platform: Windows 2003 Server Standard
 
I have logged in both a local administrator and domain administrator
account and get the error.
 
Any ideas?
 
Paul Hamrick
Access Software
2610 SE Willoughby Blvd.
Willoughby Business Park
Stuart, FL 34994
  [EMAIL PROTECTED]
772-463-4588 Ext. 15
  www.airpax.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe to Web interface

[Richard Wilson]

Does this work for both Windows and Linux?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 10 February 2005 8:45 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe to Web interface

You can use php. You have to use COM...
Example below ...


 
  Test Using Object
 

Attempting connect 
HostName = "machine";// Universe Host
 $objUV->AccountPath = "ACCT";   // Universe Account Name/Path
 $objUV->UserName = "user";// System Login
 $objUV->Password = "pwd";   // Password

 //
 // Let just display it to make sure the object accepted th assignment
 //
 print ("HostName " . $objUV->HostName . "\n");
print ("Account " . $objUV->AccountPath . "\n");
print ("UV Username " . $objUV->UserName . "\n");
print ("Password " . $objUV->Password . "\n");

//
// Connect to UVRPC service
//
$connect = $objUV->Connect();

$active = $objUV->isactive();
 if ($active = true) {
  print("Is connected");
 } else {
  print("Is NOT connected");
 }

print ("   Session Status [" . $active . "]\n");


 $objUV->Command->Text="LIST VOC";
print ("Test Command " . $objUV->Command->Text . "\n");

 $sts = $objUV->Command->Exec();
 print ("Command Status [" . $sts . "] \n");

 $Rsp = $objUV->Command->Response();
 print ("Response " . $Rsp . "\n");

 $active = $objUV->isactive();
 print ("Session Status [" . $active . "]\n");

 $sts = $objUV->disconnect(); // Close UVRPC connection

 $active = $objUV->isactive;
 print ("Session Status [" . $active . "]\n");
?>



Vance



- Original Message - 
From: "Dave Walker" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, February 09, 2005 3:53 PM
Subject: RE: [U2] Universe to Web interface


> Wouldn't a php interface to U2 be nice? Then we could have LAUP instead of
> LAMP. Or some such.
>
> Python would be gravy too.
>
> --
> Dave Walker
> 8..7 4(())  -:&:-
>   -:&:-8.74 .74(())
>  ((88.74  ..74  -:&:-
> ((88.74   * Peace
>
>
>
> > -Original Message-
> > From: CDMI [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 09, 2005 2:27 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] Universe to Web interface
> >
> >
> > Will - this is what 'web servers' do.
> > Good ones that are integrated with multivalue (that I know
> > of) are typically
> > not free.
> >
> > Steve T
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: Wednesday, February 09, 2005 12:30 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] Universe to Web interface
> >
> > In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time,
> > [EMAIL PROTECTED] writes:
> >
> > > I still don't get why you want to use a BAT file to do this at all.
> > > IF you're using IIS, you should really be using ASP.
> >
> > I don't.
> > Here is what I want "From a web page, click on something, which in ANY
> > fashion reaches into Universe and displays the results on
> > that web page."
> >
> > Focusing on the ANY fashion, any way, any how, any method,
> > with example
> > code please so I don't go insane trying to follow the
> > hand-waving.  And
> > preferable I'm looking for the absolutely simplest manner of
> > doing this.
> > And the free way too ... btw.
> >
> > PS thanks for those of you who sent various examples of doing this.
> > Will
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
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/