In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> > > 001: I
> > > 002:
> TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> > > 003:
> > > 004: NAME
> > > 005: 25L
> > > 006: S
But could'nt you do something like
IF TRANS("ORDER.FILE",@ID,3
My 2 cents on this topic and maybe it'll trigger a UD/UV response.
D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your
next process.
Could this work for this person by pre-qualifying the 2 separate SELECT
statements into 2 lists, blah. blah, blah.
I'm interested to know as
Open mouth, ... insert foot. Or whatever :)
I'm sorry, I spoke too quickly. The ID's are needed in the primary file. I
would copy all the ID's to a work file and then TRANS-ing the NAME.LO, to
ORDER and ORDER.CAN will work OK. Of course, if you do have the same ID in
both files you have to dec
My answer to questions like this is always that you can get into these MV
systems in so many different ways that it's now irrelevant which tools or
languages you use. Pick one that you're comfortable with and you'll find
ways to use your tools to get into the back-end and interface with
applicatio
Trevor,
[AD] You could push the data out using Zeus Data Integration™ and SAMBA.
[/AD]
There are a lot of ways, both programmable and buyable. If you check the
archives of this list, you'll see a lot of discussion on pushing data to
Crystal Reports in the last few months.
--
- Charles Barou
Trevor,
Welcome to the lists! To answer your question, DB2 is a marketing term
within IBM which denotes a family of databases (which includes DB2
itself, UniVerse, UniData, and others). Therefore, a course in DB2 (the
database) does not qualify you for other databases within DB2 (the
*marketing
Trevor
You have access to a variety of clients including java, .Net, VB, etc.
Access can be through ODBC & OLE DB, but also through a UniObjects which
is a class that drops into java or a com object that drops into VB &
.Net. This is more efficient than the ODBC environment. (a .Net
interface is
Hey,
I would like to know what programming languages would be best to program a
frontend to a UniVerse 10 database? Database on AIX5 P Series. I have done a
frontend to a SQL Database using VS .NET before but nothing from a UNIX
database?
The frontend end would run on WinXP Machines and need t
Are you on Universe or Unidata? I'm on Unidata 5.2 - BASICTYPE 'p', ECLTYPE
'p'.
This is not working for me. When I get a list (6 items let's say) and type
LIST SOME.FILE NAME.LO
It seems that Unidata is taking the 6 items in the list and trying to find
them in SOME.FILE first - *THEN* runs th
Yes, the archives will be continue past the cutover.
David: Try the archive search beginning Monday (EDT) for those recent
items.
Lee
On Fri, 30 Apr 2004, Scott Richardson wrote:
> You should be able to search the archives as well, as George's reposting
> part of that thread, David.
>
> Will th
In the dict of FILE.A create a dict called: NAME.LO that has:
TRANS("LOCAL",ID,1,"X"):TRANS("OTHER",ID,1,"X")
What you get is a boolean result by sticking the two TRANS against each
other.
Let's look an example. Assume that the 6 records have the following names:
LOCAL.1 = Smith
LOCAL.2 = Jones
You have a semaphore lock that is not being released. You do not have to reboot the
system to correct this problem. Simply run UNLOCK GROUPLOCK. This will release all
of the grouplocks and complain about the semaphores that cannot be released. Then
issue UNLOCK GROUPLOCK SEMAPHORE ##. You w
You should be able to search the archives as well, as George's reposting
part of that thread, David.
Will the archives also continue to be online as the cutover to U2U happens?
(U2U happens? I like that!;^)>
- Original Message -
From: "david yu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
I've seen that in older versions of ODBC and OleDB
clients, I suggest you to update to the latest one.
--- Bob Gerrish <[EMAIL PROTECTED]> escribió: >
> I have a client running AIX, UniVerse 9.5.1.1 and
> UVODBC 3.7 which they are
> connecting to via .NET / OleDB. They see occasional
> hangs
Can you say what's the query like? and if you are
using a schema or just a plain file, and the dicts?
Sometimes it has to do with the imposibility to
convert data using the conversion codes.
HP
--- [EMAIL PROTECTED] escribió: > We're looking for some
help with a UniOLEDB problem.
> I'm hoping
I believe you are talking about the discussion on
scheduling programs.
ED VOC SCHEDULE-THIS
0001: PA
0001: LOOP (If you want this to repeat each day)
0002: SLEEP XX:XX (Time you want process to run)
0003: TCL COMMAND
0004: TCL COMMAND
0005: TCL COMMAND
0005: REPEAT (If you want this to repeat ea
Mark,
Our IT support staff uses AccuTerm 2K2. It has a file transfer feature
available. Search the on-line help document for FT or FTBP. The client
can transfer files, databases, or data records. Nearly everything in a
session is programmable with a scripting language similar to Visual Basi
Hello Everyone!
There was a trail last week discussion about PHANTOM,
unfortunately I deleted my email, I am wondering if
anyone has any copy of the trail of discussion. Would
appreciate a copy of it specially the one where there
was a small PH process.
TIA!
David Yu
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Memo: RE: [UD] Union Query
> Does that work for you? It doesn't work for me.
>
> ORDER.FILE NAME.
>
> 114061 C.M.O.S. INC. *
What is a Distributed File?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 2:35 PM
To: [EMAIL PROTECTED]
Subject: Re: [UD] Union Query
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> I have 2
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> I have 2 files in separate accounts that are structured the same. I want to
> do something like:
>
> SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE >
> "01/01/2004" NAME ADDRESS
> CITY STATE ZIP
Is the
In a message dated 4/30/2004 2:07:27 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> What we have is a case where an open file error may occur and we need to
> have the user go back into a menu, but we do not want them to see the
> error. Problem is that the error is waiting for user inpu
Hello.
Unidata 6.0.8
AIX 5.1
One of our programmers asked this question:
If I have this:
COMMAND = 'PROGRAM.A'
EXECUTE COMMAND CAPTRURING OUTPUT
Is there any way for 'PROGRAM.A' to sense that it is in capturing output
and stop the capture?
What we have is a case where an open file error may o
Does that work for you? It doesn't work for me.
ORDER.FILE NAME.
114061 C.M.O.S. INC. *ASC*
114062 AMERICAN PERFIT XSTAL
18 TIMELAND COMPANY
19 MCCANN ELECTRONICS *STR*
130395 TERMINAL TECH SERVICE
138562 TOWN VISION ELECTRONICS
154897 CASI
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 1:41 PM
Subject: RE: Memo: RE: [UD] Union Query
> R. Bruce,
>
> Could you give an example? I'm having trouble envisioning this.
>
> Let's say I have these keys in a
R. Bruce,
Could you give an example? I'm having trouble envisioning this.
Let's say I have these keys in a list:
LOCAL.1
LOCAL.2
LOCAL.3
OTHER.1
OTHER.2
OTHER.3
The first 3 live in FILEA and the last 3 live in FILEB
If I go a GET-LIST, then enter:
LIST FILEA NAME
What would the NAME dicti
Hi,
I was looking for any information about what may cause an RD Group Lock
without a record lock. I am currently experiencing a problem where a
basic program is trying to perform a write to a file, but the file has a
current RD lock. The user no. with the RD lock is the same as the user
who is
We're looking for some help with a UniOLEDB problem. I'm hoping someone can
provide some input on the error.
We are currently developing a web application that uses UniOLEDB to execute
SQL statements in UniData. Our code is in C# and is running as a service
(single threaded). We have test ca
Yes, JDBC does come with 6.0. I don't recall if 6.0 is the first version
that includes jdbc or just the first version that I would be willing to use
jdbc with UniData, but there is a switch in my brain (once upon a time the
detail would be there too) that says that UniData 6.0 is the first version
What I have done in the past is concatenate the 2 translates together. One
trans being blank and the other having valid data. You need to make a whole
set of dicts that do the double-reads in one file-dict or the other. Then,
use it as your primary file for the listing. The only problem is when
Hi Ed,
You could test for the record existing in one file and if it does use the
dict for that file otherwise use the dict for the other file:
TRANS("FILE.A",ID,1,"X"); IF @1 <> '' THEN FILEA.NAME ELSE FILEB.NAME
where FILEA.NAME returns the name from FILE.A and FILEB.NAME returns the
name
I don't have two files of that type to test with here, but would a SQL query work for
this?
Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
>>> [EMAIL PROTECTED] 04/30/04 10:12AM >>>
Hello,
Does anyone know of a way to do the equivalent of a UNION "quer
If you really must use TCL (as opposed to writing some code) you could copy
the data from both files to a single temp file and report from it.
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 8:24 AM
To: 'U2 Users Discussion List'
Subject: RE:
In that case, I'm sorry to say, there is no way to logically do what you're
asking with UD. You could physically do it by creating a temp file and copy
all records from both files to it. But that would be a great deal of
overhead for a query.
Gordon J. Glorfield
Sr. Applications Developer
MAMSI
UV 10.0.17, Windows 2003
The other day I had occasion to increase the value of the T30FILE parameter
from the default of 200 (to 300) for the first time in the several years
I've been using Universe. Unfortunately, the documentation is not very
clear (at least to me) regarding interdependencies b
@ID in this case points to the filename mentioned in my statement:
LIST ORDER.FILE
the @ID's from ORDER.FILE.OTHER are showing up as non-existent:
(My merged list contains 10 items from ORDER.FILE and 10 items from
ORDER.FILE.OTHER)
ORDER.FILE NAME. Name.OTHER...
No, a record ID in one file will not exist in the other file.
-Original Message-
From: Jeff Schasny [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:14 AM
To: U2 Users Discussion List
Subject: RE: [UD] Union Query
TCL (or whatever your flavor calls the queery language) is a sing
My suggestion is to create a "V" type dictionary item(s) that with point to your other
file.
For example, if you want to look at the city name in your file, ORDER.FILE.OTHER,
create the following:
001: V
002: TRANS('ORDER.FILE.OTHER', @ID, , 'X')
003:
004: City (ORDER.FILE.OTHER
TCL (or whatever your flavor calls the queery language) is a single file
oriented language. No joins. You would need to create TRANS items in the
dictionary of one of the files pointing to the other. Are the record ID's
in both files the same for a given record that you would want to relate?
---
I understand how Unibasic could handle a list that has been merged, but how
would you do a Uniquery statement?
for example:
SELECT ORDER.FILE WITH DATE > "1/1/2004"
SAVE-LIST LIST1
SELECT ORDER.FILE.OTHER WITH DATE > "1/1/2004"
SAVE-LIST LIST2
GET-LIST LIST1 TO 1
GET-LIST LIST2 TO 2
MERGE.LIST
Thanks to Clif
The list has been a great help to me so far. I must say you have done a
great job.
See you all on the other side
Regards
Björn Behr
Programmer
HYFLO Southern Africa (Pty) Ltd
Tel : +27 11 386 5800
Fax : +27
Good Morning All,
We currently have UniData 5.13.. and use UniODBC. We
are planing to move on to UniData 6.0 on UNIX and
would like to know whether it comes with JDBC? If so,
does it work with any earlier version than UniData
6.0?
Thanks
Fawaz
__
You could use MERGER.LIST to get one list which is a UNION of two separate
selects of each file. But you would not know which file the key was from
when you were done. But Unibasic or Virtual dictionary items could take the
merged list and produce what you are looking for.
-Original Message--
Hello,
Does anyone know of a way to do the equivalent of a UNION "query" (really a
LIST or SORT) on 2 or more different UniData files?
I have 2 files in separate accounts that are structured the same. I want to
do something like:
SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE > "01/01/2004" NAM
Malcolm Bull has provided a chart on his web site of the
codes for multiple multivalue databases. Have a look at
http://members.aol.com/mbtexts/93.html
Ron White
- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: T
Will be watching you all on the other side
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
From: "Stu Glancy" <[EMAIL PROTECTED]>
Sent: Thursday, April 29, 2004 9:24 AM
> Here's another solution:
>
> LOOP
> INPUT VAR,-1
> IF VAR THEN
> INPUT TOUCH,1
> IF TOUCH = 'X' THEN EXIT
> END
>REPEAT
That will bring most mac
DB2 is the original, proprietary IBM first normal form database product. IBM now
prefers to call it DB2 UDB, where the UDB stands for "universal database".
Since acquiring all of the databases, including UniVerse and UniData, from Informix in
2001, IBM have also used the term DB2 to refer gen
Ah, the well-known helpful error message. Not.
What happens when you use these commands?
LIST.INDEX filename
LIST.INDEX filename STATS
LIST.INDEX filename DETAIL
Can you examine the INDEX.000 file (assuming it's that one) with uvfixfile or blook?
- Original Message -
From: Björn Behr <[
You could add gethostbyname() as a GCI subroutine. Take a look at getpid() as a
template (in the UV account, LIST GCI).
- Original Message -
From: "Craig Bennett" <[EMAIL PROTECTED]>
Date: Fri, 30 Apr 2004 15:34:06 +1000
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Subject: Name Re
Hey,
Can someone please answer some questions as i am unsure on some database
types.
Whats the difference between DB2 and UniVerse/UniData?
Are they the same sort of structure?
Can you do a DB2 course and be qualified enough to use UniVerse?
Any other information or websites on this sort of t
We keep having a problem with our B-TREE INDEX that says
"ERROR IN B-TREE INDEX"
Can anybody help me out.
Windows 2000, Universe 10.0
Regards
Björn Behr
Programmer
HYFLO Southern Africa (Pty) Ltd
Tel : +27 11 386 5800
Fax :
52 matches
Mail list logo
