CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received
apologize for the confusion caused by my not giving enough information
before.
Noah Hart
--
View this message in context:
http://www.nabble.com/Need-help-with-SELECT-limiting-MV-tp22063800p22106540.html
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2
I have a table with a MV status code and date field. I am trying to
select just those records that have both status code A and B and when
the date associated with code B is blank
I tried
SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE =
But this will select records which might have a
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B and when the date associated with code B is blank
I tried
SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE =
But this will select records which might have a
We recently upgraded some workstations to Vista, and notice that when we paste
text (control-V) into the terminal window, a ? will randomly appear. This
happens about 10% of the time
Has anyone else seen this?
Regards,
-
Noah Hart
Sr
Thanks, perfect solution
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
Sent: Friday, May 23, 2008 10:18 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Calling shell script from virtual field
quote who='Noah Hart' date='Friday 23
Is it possible to define a virtual field in such a way that it can call
a unix shell script?
Regards,
Noah
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
We are looking at upgrading UD 6.0 to 7.1; and it looks like it requires
Solaris 9.
We are currently on Solaris 7.
Has anyone had any experience in upgrading from 7 to 9?
Thanks,
Noah
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
I agree, there should be 1 list.
Regards,
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis
Sent: Thursday, September 06, 2007 9:23 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RE: Get a grip - was ads - was U2 University Last
)') AT
UNIDATA_LINKED_SERVER
Thanks for your help in advance,
Noah Hart
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action
solutions?
Thanks for your help in advance,
Noah Hart
Sr. IT Analyst Lipman Insurance Administrators, Inc.
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use
the SQL prompt.
Regards
JayJay
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart
Sent: 30 July 2007 19:23
To: u2-users@listserver.u2ug.org
Subject: [U2] ODBC error via SQLSERVER linked server
I am using SS2005 and have setup a linked server using
gigs also doesn't solve the problem or give more time before
the error occurs.
Jeffrey Lettau
ERP Systems Manager
polkaudio
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart
Sent: Thursday, July 26, 2007 1:28 PM
To: u2-users@listserver.u2ug.org
or locks from a
telnet
disconnect.
Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO 80237
Tel: 303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]
-Original Message-
From: Noah Hart
Sent: Friday, January 19, 2007 9:49 AM
To: 'u2-users
lock, the lock
is not released.
QUESTION: Is this true? Is there any way to change this behavoir.
Regards,
Noah Hart
Sr. IT Analyst
Lipman Insurance Administrators, Inc.
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you
Bob,
I'd like to see those routines,
Thanks,
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Thursday, October 13, 2005 11:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was
I have to disagree Garry. I am a seasoned programmer, cutting my teeth
on everything from ALGOL to PASCAL, with stops in Assembler, SQL, Java,
Visual anything.
However, I am a newbie in the Unidata world. Most of the time when I
want to do anything interesting from file i/o to string searching
] Behalf Of Noah Hart
Sent: Friday, September 30, 2005 14:58
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Good Programming Practice - Axiom -
I have to disagree Garry. I am a seasoned programmer, cutting my teeth
on everything from ALGOL to PASCAL, with stops in Assembler, SQL, Java
When deleting records from a file, I get the following errors:
upl lock error
error in U_dyn_hash
error in U_delete_tuple
Invalid lock sequence
In LIA/_TEST at line 8 upl lock error(102).
In LIA/_TEST at line 8 1: error in U_dyn_hash for file
Has anyone seen this type of error before?
(If it's in the docs, please point me there)
In LIA/_TEST at line 8 upl lock error(102).
In LIA/_TEST at line 8 1: error in U_dyn_hash for file 'MELG-VENDOR',
key '200407*DELTA*123450099', number=12398
In LIA/_TEST at line 8 1: error in U_delete_tuple
What version Unidata and Client tools (especially ODBC driver) are you
using?
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff
Sent: Thursday, August 25, 2005 8:25 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] unioledb connection
Select question:
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select all records in file2 which have FILE1_ID matching the
savedlist I already have.
Is
on an attribute
(If BLORP is your savedlist from File1) GET.LIST BLORP TO 1 SELECT
FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST
BLAH FROM 3
BLAH will contain the IDs you want, if I understand your question
correctly.)
--- Noah Hart [EMAIL PROTECTED] wrote:
Select question
(If BLORP is your savedlist from File1) GET.LIST BLORP TO 1 SELECT
FILE2 SAVING FILE1_ID TO 2 MERGE.LIST 1 INTERSECTION 2 TO 3 SAVE.LIST
BLAH FROM 3
BLAH will contain the IDs you want, if I understand your question
correctly.)
--- Noah Hart [EMAIL PROTECTED] wrote:
Select
INTERSECTION 2 TO 3 SAVE.LIST
BLAH FROM 3
BLAH will contain the IDs you want, if I understand your question
correctly.)
--- Noah Hart [EMAIL PROTECTED] wrote:
Select question:
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2
This error only occurs using Microsoft Access 2003
Any ideas?
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart
Sent: Friday, July 15, 2005 4:51 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] ODBC Driver 3.1.6 error
I just
and install ver 3.1.5 I get the same error.
When I back out the driver and install ver 3.1.4, everything works fine.
Does this sound familiar to anyone?
Thanks,
Noah Hart
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Just a guess ...
When we use ODBC we often see this type of error, when the record we are
trying to access is locked.
There does not seem to be anyway to force a READ ONLY connection via
ODBC. I'm not sure about OleDB.
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
What is the URL? I just checked and it was still clients 6.0b
Noah Hart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lee Bacall
Sent: Friday, October 15, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject: [U2] UD PE is available
UniData personal editions
PROTECTED] Behalf Of Noah Hart
Sent: Thursday, October 14, 2004 10:26
To: [EMAIL PROTECTED]
Subject: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2
We run a number of scheduled jobs each night. They have run
successfully for several years.
Last night we received this error in the log file
We run a number of scheduled jobs each night. They have run
successfully for several years.
Last night we received this error in the log file.
In /home/LIPMAN/CTLG/S.INPUT at line 64 out of BUF_TYPE space.
The source for this line is a simple print statement
CRT
Is there any news on the availability of the 6.1PE download?
Thanks,
Noah Hart
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
Thanks everyone .. I guess I was looking for an Oracle or SQL like table
containing all the triggers, but it appears that as suggested I need to
inspect each file.
Thanks again,
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi
Sent:
is LIST.SICA filename DATA, in which case the output
from LIST.SICA is returned as a dynamic array.
- Original Message -
From: Noah Hart [EMAIL PROTECTED]
Date: Mon, 27 Sep 2004 09:58:32 -0700
To: [EMAIL PROTECTED]
Subject: [U2] Triggers
Is is possible to get a list of all files with triggers
Now, I'm not really a unix guy, but we are running Solaris 2.7 with
plenty of memory and disk.
Any idea what to check?
Thanks,
Noah Hart
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
Does anyone have the 6.1 clients yet?
Thanks,
Noah Hart
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
It's the download from the website I'm refering to.
Noah Hart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune
Sent: Monday, September 20, 2004 12:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] UD 6.1 timing
They have been orderable since
When did you download 6.1?
I tried this morning and it was still unavailable?
Noah Hart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Friday, September 17, 2004 11:42 AM
To: [EMAIL PROTECTED]
Subject: [U2] UniData 6.1 and unirpcd
Does ths user name have any special characters?
Noah Hart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Friday, September 10, 2004 1:16 PM
To: [EMAIL PROTECTED]
Subject: [U2] UniSession.connect error
I have searched for a solution
I've setup a linked server to a Unidata db via ODBC. Works well.
However, now I want to call a subroutine via OPENQUERY such as
SELECT * FROM OPENQUERY (uniLINKED,'CALL TEST(1)');
I get the following error:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'CALL TEST(1)'. The
40 matches
Mail list logo