Re: Memo: RE: [UD] Union Query
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,"") = "" THEN TRANS("ORDER.FILE.CAN",@ID,3,"")
or something of that nature?
Will
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 well.
Thanks.
- Original Message -
From: "Bruce Lunt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 10:11 PM
Subject: Re: Memo: RE: [UD] Union Query
> 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 decide what do to do with that.
>
> Again, sorry for not testing out my solution before I offered it.
>
> Regards,
> Bruce
>
>
>
>
>
> >From: "Allen Egerton" <[EMAIL PROTECTED]>
> >Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
> >To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
> >Subject: Re: Memo: RE: [UD] Union Query
> >Date: Fri, 30 Apr 2004 14:41:17 -0400
> >
> >
> >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. *ASC*
> > > 114062 AMERICAN PERFIT XSTAL
> > > 18 TIMELAND COMPANY
> > > 19 MCCANN ELECTRONICS *STR*
> > > 130395 TERMINAL TECH SERVICE
> > > 138562 TOWN VISION ELECTRONICS
> > > 154897 CASIO SERV CENTER *ASC*
> > > 163063 CASIO SERV CENTER *ASC*
> > > 171230 AMERICAN PERFIT XSTAL
> > > 195731 ELECT MUSIC INSTR *FAS*
> > > 10 records listed
> > > Enter to print non exist record ids
> > > 007890
> > > 007891
> > > 007892
> > > 007893
> > > 007894
> > > 016057
> > > 016058
> > > 016059
> > > 016060
> > > 016061
> > >
> > > Here is the dict:
> > >
> > > 001: I
> > > 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> > > 003:
> > > 004: NAME
> > > 005: 25L
> > > 006: S
> >
> >
> >I can't test it right now, I don't have access to a Universe machine
until
> >tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly
> >aren't
> >in ORDER.FILE.
> >
> >--
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >http://www.oliver.com/mailman/listinfo/u2-users
>
> _
> MSN Toolbar provides one-click access to Hotmail from any Web page - FREE
> download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 decide what do to do with that.
Again, sorry for not testing out my solution before I offered it.
Regards,
Bruce
From: "Allen Egerton" <[EMAIL PROTECTED]>
Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Subject: Re: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 14:41:17 -0400
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. *ASC*
> 114062 AMERICAN PERFIT XSTAL
> 18 TIMELAND COMPANY
> 19 MCCANN ELECTRONICS *STR*
> 130395 TERMINAL TECH SERVICE
> 138562 TOWN VISION ELECTRONICS
> 154897 CASIO SERV CENTER *ASC*
> 163063 CASIO SERV CENTER *ASC*
> 171230 AMERICAN PERFIT XSTAL
> 195731 ELECT MUSIC INSTR *FAS*
> 10 records listed
> Enter to print non exist record ids
> 007890
> 007891
> 007892
> 007893
> 007894
> 016057
> 016058
> 016059
> 016060
> 016061
>
> Here is the dict:
>
> 001: I
> 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> 003:
> 004: NAME
> 005: 25L
> 006: S
I can't test it right now, I don't have access to a Universe machine until
tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly
aren't
in ORDER.FILE.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
_
MSN Toolbar provides one-click access to Hotmail from any Web page FREE
download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: Frontend to UniVerse?
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 applications. As examples: Java, VB6, VB.NET, C#, Perl, ASP.NET, ADO.NET, ODBC, HTTP, RPC, sockets, Nucleus, Visage, DesignBAIS, RedBack, WebWizard, UniObjects/UOJ, Intercall, Coyote(?), PDP.NET, mvInternet, AccuTerm, wIntegrate (yes these can be used as pure connectivity components) Excel, Outlook, Project, Word, Crystal Reports, FRx, ... Quick Books, Great Plains, Turbo Tax, ... (omission of a product name is only a sign of failing memory) There is no best language, development tool, or connectivity method - IMHO. It comes down to your comfort zone, your price range, your favorite technologies, your company politics, your confidence in the long-term viability of tools, and other semi-intangibles. If your question is more specific like "how do I get into Universe from a .NET middle tier", then people can provide a more specific answer. For ideas about how to use MV apps with Web Services, for example, see my article on "Web Services and .NET" in the March/April and prior issues of Spectrum Magazine, where I mention a number of these technologies: http://www.intl-spectrum.com/SPECTRUMMAG.HTML (4.5MB PDF) I'll be happy to provide free advice, offical consultation, education, and development services using most of the technologies mentioned here. Feel free to ask. Tony, Nebula R&D [EMAIL PROTECTED] >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Trevor McNamara >Sent: Friday, April 30, 2004 3:40 PM >To: [EMAIL PROTECTED] >Subject: Frontend to UniVerse? > > >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 to run >commands on the >AIX machines to run daily processes and also reporting as well >as you are >currently manually putting in the UniQuery and then importing >it into excel >would be great if we could use Crystal Reports like i used on my SQL >frontend. > >Any help of websites reguarding this please let me know. > >Thanks in advance. > >Trev > >_ >Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to >http://join.msn.com/?pgmarket=en-au&page=hotmail/es2 > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Frontend to UniVerse?
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 Barouch [EMAIL PROTECTED] - Zeus Data Integration [EMAIL PROTECTED]- Consulting services (718) 762-3884 x 1 - Key Ally Voice mail Mount Olympus, Home of Zeus Data Integration™ Trevor McNamara wrote: 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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Differences
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* term). UniVerse and UniData are siblings. As a result, they share a lot of traits but have certain points where they are fiercely different. This list is an excellent source for getting to know these two databases. -- - Charles Barouch [EMAIL PROTECTED] - Zeus Data Integration [EMAIL PROTECTED]- Consulting services (718) 762-3884 x 1 - Key Ally Voice mail Mount Olympus, Home of Zeus Data Integration™ Trevor McNamara wrote: 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 thing (Newbie questions:) ) would be much appreciated. Thanks Trev -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Frontend to UniVerse?
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 on its way, but this is not necessary for .Net development just an upgrade of the COM object) If you require more of the Internet style application, then you should also look at the Redback product which handles all the Web requirements. You also are able to integrate with Web Services, xml, etc. Additionally there are a host of development tools and reports tools available for the Universe environment that allow rapid development. Universe sites are using Chrystal reports, so that should not be a problem. When developing in Universe, this is an opportunity to think outside the square, for though Universe can handle many of things DB2 does it also does a lot of things that DB2 cannot do. Universe has a very sophisticated Programming Language built into the database that can be used to build complex procedure calls way beyond the tradional SQL Programming Languages. Universe also is capable of handling multidimensional tables which DB2 does not handle. If there is something you are trying to do a certain way, I am sure you will find someone on this list that has tackled this problem. With an open mind, I am sure you will find Universe a very powerful development environment, but don't get caught into the trap that the RDBMS way of doing things is necessarily the best way of doing things as there are sometimes easier and quicker ways of doing things from a different perspective Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business & Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor McNamara Sent: Saturday, 1 May 2004 8:40 AM To: [EMAIL PROTECTED] Subject: Frontend to UniVerse? 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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev _ Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to http://join.msn.com/?pgmarket=en-au&page=hotmail/es2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Frontend to UniVerse?
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 to run commands on the AIX machines to run daily processes and also reporting as well as you are currently manually putting in the UniQuery and then importing it into excel would be great if we could use Crystal Reports like i used on my SQL frontend. Any help of websites reguarding this please let me know. Thanks in advance. Trev _ Get Extra Storage in 10MB, 25MB, 50MB and 100MB options now! Go to http://join.msn.com/?pgmarket=en-au&page=hotmail/es2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: RE: [UD] Union Query
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 the NAME.LO dictionary.
It looks to me that your example works because your system is running the
NAME.LO dictionary *BEFORE* it tries to resolve the key in the list to a
record in SOME.FILE. Therefore, you should be able to to something like
this:
SELECT SOME.FILE SAMPLE 6
SAVE-LIST SOME.LIST
GET-LIST SOME.LIST
LIST TOTALLY.DIFFERENT.FILE NAME.LO
if the NAME.LO dict did a TRANS to SOME.FILE, then the above would work just
fine - even though every key in the SOME.LIST did NOT EXIST in
TOTALLY.DIFFERENT.FILE.
I appreciate your help on this. Thanks. :-)
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 3:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
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
LOCAL.3 = Barney
OTHER.1= Green
OTHER.2= Brown
OTHER.3= Jones
If you LIST LOCAL NAME NAME.LO you should see the following:
FILE.A... NAME... NAME.LO.
LOCAL.1 Smith Smith
LOCAL.2 Jones Jones
LOCAL.3 BarneyBarney
OTHER.1 Green
OTHER.2 Brown
OTHER.3 Jones
This is because the NAME.LO dict doesn't care where it is residing. It just
gets the direction to retrieve the contents of attribute 1 from the LOCAL
and OTHER files. In fact, to keep the confusion (and clutter) to a minimum
you could put the dict into a work file dictionary and do:
LIST FILE.A USING DICT WORK NAME.LO
When I mentioned the data being in both files I meant having the same key.
e.g. LOCAL.3 existing in both LOCAL and OTHER files. Does that make sense?
R. Bruce Lunt
408.832.1900 cell
>From: "Burwell, Edward" <[EMAIL PROTECTED]>
>Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
>To: 'U2 Users Discussion List' <[EMAIL PROTECTED]>
>Subject: RE: Memo: RE: [UD] Union Query
>Date: Fri, 30 Apr 2004 13:41:26 -0400
>
>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 dictionary look like?
>
>Thanks.
>
>Ed Burwell
>[EMAIL PROTECTED]
>973.361.5400 x1512
>
>
>-Original Message-
>From: Bruce Lunt [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 30, 2004 12:26 PM
>To: [EMAIL PROTECTED]
>Subject: RE: Memo: RE: [UD] Union Query
>
>
>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 the
>data exists in both files. But at least then you will get twice the data.
>It
>
>stands out pretty well if you want to spot problems.
>
>HTH
>
>R. Bruce Lunt
>408.832.1900 cell
>
>
>
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
> >To: U2 Users Discussion List <[EMAIL PROTECTED]>
> >Subject: Memo: RE: [UD] Union Query
> >Date: Fri, 30 Apr 2004 16:49:46 +0100
> >
> >
> >
> >
> >
> >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 for FILE.B
> >
> >this is all off the top of my head, but it should work.
> >
> >hth
> >
> >asvin
> >
> >
> >
> >
> >"Burwell, Edward" <[EMAIL PROTECTED] on 30 Apr 2004 16:33
> >
> >Please respond to U2 Users Discussion List <[EMAIL PROTECTED]>
> >
> >Sent by:[EMAIL PROTECTED]
> >
> >To:'U2 Users Discussion List' <[EMAIL PROTECTED]>
> >cc:
> >bcc:
> >
> >Subject:RE: [UD] Union Query
> >
> >
> >@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..
> >
> >114061 C.M.O.S. INC. *ASC*
> >114062 AMERICAN PERFIT XSTAL
> >18 TIMELAND COMPANY
> >19 MCCANN ELECTRONIC
Re: Phantom trail
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 the archives also continue to be online as the cutover to U2U happens? > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: RE: [UD] Union Query
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
LOCAL.3 = Barney
OTHER.1= Green
OTHER.2= Brown
OTHER.3= Jones
If you LIST LOCAL NAME NAME.LO you should see the following:
FILE.A... NAME... NAME.LO.
LOCAL.1 Smith Smith
LOCAL.2 Jones Jones
LOCAL.3 BarneyBarney
OTHER.1 Green
OTHER.2 Brown
OTHER.3 Jones
This is because the NAME.LO dict doesn't care where it is residing. It just
gets the direction to retrieve the contents of attribute 1 from the LOCAL
and OTHER files. In fact, to keep the confusion (and clutter) to a minimum
you could put the dict into a work file dictionary and do:
LIST FILE.A USING DICT WORK NAME.LO
When I mentioned the data being in both files I meant having the same key.
e.g. LOCAL.3 existing in both LOCAL and OTHER files. Does that make sense?
R. Bruce Lunt
408.832.1900 cell
From: "Burwell, Edward" <[EMAIL PROTECTED]>
Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
To: 'U2 Users Discussion List' <[EMAIL PROTECTED]>
Subject: RE: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 13:41:26 -0400
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 dictionary look like?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
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 the
data exists in both files. But at least then you will get twice the data.
It
stands out pretty well if you want to spot problems.
HTH
R. Bruce Lunt
408.832.1900 cell
>From: [EMAIL PROTECTED]
>Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
>To: U2 Users Discussion List <[EMAIL PROTECTED]>
>Subject: Memo: RE: [UD] Union Query
>Date: Fri, 30 Apr 2004 16:49:46 +0100
>
>
>
>
>
>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 for FILE.B
>
>this is all off the top of my head, but it should work.
>
>hth
>
>asvin
>
>
>
>
>"Burwell, Edward" <[EMAIL PROTECTED] on 30 Apr 2004 16:33
>
>Please respond to U2 Users Discussion List <[EMAIL PROTECTED]>
>
>Sent by:[EMAIL PROTECTED]
>
>To:'U2 Users Discussion List' <[EMAIL PROTECTED]>
>cc:
>bcc:
>
>Subject:RE: [UD] Union Query
>
>
>@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..
>
>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 CASIO SERV CENTER *ASC*
>163063 CASIO SERV CENTER *ASC*
>171230 AMERICAN PERFIT XSTAL
>195731 ELECT MUSIC INSTR *FAS*
>10 records listed
>Enter to print non exist record ids
>007890
>007891
>007892
>007893
>007894
>016057
>016058
>016059
>016060
>016061
>
>Ed Burwell
>[EMAIL PROTECTED]
>973.361.5400 x1512
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 30, 2004 11:18 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [UD] Union Query
>
>
>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,
>ORDER.FILE.OTHER'>, 'X')
> 003:
> 004: City (ORDER.FILE.OTHER)
> 005: 30L
> 006: S
>
>Also, I recommend that you check out the capabilities of TRANS. There
are
>other return codes.
>
>Hope this helps.
>
>Grant W. Boice, Jr.
>Systems Administrator
>Benchmark Electronics, Inc.
>Manassas Division
>8500 Phoenix Drive
>Manassas, VA 20110
>
>Phone: (703) 334-0156
>Email: [EMAIL PROTECTED]
RE: UVODBC/OleDB job Randomly hang
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 will need to do this for each semaphore that won't release, usually there is only one. Unfortunately, I do not have an answer on how to prevent the hung processes. -Original Message- From: Horacio Pellegrino [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 3:36 PM To: U2 Users Discussion List Subject: Re: UVODBC/OleDB job Randomly hang 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 from their > DataReader and consequently, kill their process and > reissue a query. Now > we are seeing some hangs on the UniVerse side such > that UniVerse > performance is greatly degraded and interactive > users cannot log in. When > this happens, they have been forced to restart > UniVerse. > > They have a uvodbc user set up that is called via > the .NET calls. Most of > the processes are owned by the user uvodbc, however, > the common thread is > that there are a number that are owned by root. > They are the processes > that tend to be the ones that hang about especially > when the system slows > down. > > Has anyone seen this sort of behavior, any > suggestions? > > > Thanks, > Bob Gerrish - [EMAIL PROTECTED] > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ***THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible fordelivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Phantom trail
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 PROTECTED]> Sent: Friday, April 30, 2004 2:54 PM Subject: Phantom trail > 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 > > > > > __ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UVODBC/OleDB job Randomly hang
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 from their > DataReader and consequently, kill their process and > reissue a query. Now > we are seeing some hangs on the UniVerse side such > that UniVerse > performance is greatly degraded and interactive > users cannot log in. When > this happens, they have been forced to restart > UniVerse. > > They have a uvodbc user set up that is called via > the .NET calls. Most of > the processes are owned by the user uvodbc, however, > the common thread is > that there are a number that are owned by root. > They are the processes > that tend to be the ones that hang about especially > when the system slows > down. > > Has anyone seen this sort of behavior, any > suggestions? > > > Thanks, > Bob Gerrish - [EMAIL PROTECTED] > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: OLEDB problem with UniData
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 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 case of 12 or so > SQL statements that > execute one after the other for a defined number of > times. In otherwords > the 12 statements are execute over and over for 20 > times. Note the 12 > statements are not dynamic so they are the same > exact query each time, with > no variations in data possible. > > > > What we are experiencing is a random points in the > test we receive an E_FAIL > condition. Sometimes it is on iteration 3 and > sometimes it is on iteration > 19 and sometimes somewhere else. As seen in the > DRITrace log segements > below there seems to be a pattern in the log of a > thread change. When the > problem occurs it is preceded by a change in the > pattern. Also it looks as > if UniData executes the query fine the error is when > the data is coming back > up the pipe. Check the log segments below. > > > > Finally we are using a UniOLEDB version just > delivered by IBM, but prior > versions also had the problem. The current version > we are using is 1.4.5. > The UniData version is 6.0.12. > > > > Normal set of thread changes occur and there is no > error condition around > this change. Note there is a change after > uci::SQLFreeStmt entries. The > next change occurs shortly after after a CAr, CDR > log entry combination. > > > > uci::SQLFreeStmt(4100808) > 00093900 uci::SQLFreeStmt(4100808) > 00093901 uci::SQLFreeStmt(4100808) > 00093902 THREAD CHANGED: New thread ID=5676(162c) > 00093902 CArCommand(120200068)::~CArCommand() > 00093903 CDRImCommandUCI::~CDRImCommandUCI > 00093904 THREAD CHANGED: New thread ID=1832(728) > 00093904 IDBPropertiesImpl(121732620)::GetProperties > 00093905 DBPROP_CONNECTIONSTATUS > 00093906 DBPROP_CONNECTIONSTATUS: > > > > Again we get a thread change in the same pattern as > the last one. > Everything looks good. > > > > uci::SQLFreeStmt(4100808) > 00097605 uci::SQLFreeStmt(4100808) > 00097606 uci::SQLFreeStmt(4100808) > 00097607 THREAD CHANGED: New thread ID=5676(162c) > 00097607 CArCommand(120200068)::~CArCommand() > 00097608 CDRImCommandUCI::~CDRImCommandUCI > 00097609 CArCommand(120197764)::~CArCommand() > 00097610 CDRImCommandUCI::~CDRImCommandUCI > 00097611 CArCommand(120202380)::~CArCommand() > 00097612 CDRImCommandUCI::~CDRImCommandUCI > 00097613 CArCommand(120204684)::~CArCommand() > 00097614 CDRImCommandUCI::~CDRImCommandUCI > 00097615 THREAD CHANGED: New thread ID=1832(728) > 00097615 IDBPropertiesImpl(121732620)::GetProperties > 00097616 DBPROP_CONNECTIONSTATUS > 00097617 DBPROP_CONNECTIONSTATUS: > > > > > > Again we get a thread change in the same pattern as > the last one. > Everything looks good. > > > > uci::SQLFreeStmt(4100808) > 00099443 uci::SQLFreeStmt(4100808) > 00099444 uci::SQLFreeStmt(4100808) > 00099445 THREAD CHANGED: New thread ID=5676(162c) > 00099445 CArCommand(120204684)::~CArCommand() > 00099446 CDRImCommandUCI::~CDRImCommandUCI > 00099447 CArCommand(120202380)::~CArCommand() > 00099448 CDRImCommandUCI::~CDRImCommandUCI > 00099449 CArCommand(120197764)::~CArCommand() > 00099450 CDRImCommandUCI::~CDRImCommandUCI > 00099451 THREAD CHANGED: New thread ID=1832(728) > 00099451 IDBPropertiesImpl(121732620)::GetProperties > 00099452 DBPROP_CONNECTIONSTATUS > 00099453 DBPROP_CONNECTIONSTATUS: > > > > The patterns above keep occuring for a period of > time. This seems to be a > good pattern when everything is working correctly. > BUT then the next > section of logs display thread changes, but they do > not follow the patterns > above and wam! the error occurs. > > > 00134309 uci::SQLFetch(4100808) > 00134310 CArIRowsetImpl::GetNextRows(Got:1) > 00134311 > CArIRowsetImpl(121726428)::GetData(121725064, > 121747320, 2065392) > 00134312 CDRImAdmin::ClearError > 00134313 CArCommand(120217196)::GetColumnInfo() > 00134314 CArCommand(120217196)::GetColumnInfo() > 00134315 THREAD CHANGED: New thread ID=5676(162c) > 00134315 CArCommand(120196428)::~CArCommand() > 00134316 CDRImCommandUCI::~CDRImCommandUCI > 00134317 CDRImUCIHSTMT::Close > 00134318 Closing UCI HSTMT 4100808 > 00134319 uci::SQLFreeStmt(4100808) > 00134320 uci::SQLFreeStmt(4100808) > 00134321 uci::SQLFreeStmt(4100808) > 00134322 CArCommand(120197764)::~CArCommand() > 00134323 CDRImCommandUCI::~CDRImCommandUCI > 00134324 CArCommand(120204684)::~CArCommand() > 00134325 CDRImCommandUCI::~CDRImCommandUCI > 00134326 CArCommand(120202380)::~CArCommand() > 00134327 CDRImCommandUCI::~CDRImCommand
RE: Phantom trail
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 each day) PHANTOM SCHEDULE-THIS LO Was this it? George >-Original Message- >From: david yu [mailto:[EMAIL PROTECTED] >Sent: Friday, April 30, 2004 2:54 PM >To: [EMAIL PROTECTED] >Subject: Phantom trail > > >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 > > > > >__ >Do you Yahoo!? >Win a $20,000 Career Makeover at Yahoo! HotJobs >http://hotjobs.sweepstakes.yahoo.com/careermakeover >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Accuterm like Wintegrate
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 Basic. At 07:51 PM 4/28/2004, you wrote: I use wintegrate a lot as an emulator, file transfer and running PC-based programs. 2 new clients both have accuterm and I'm wondering if their file transfer (import/export) facilities are programmable or are manually managed. Also, is there the equivilent of WIN.PCRUN. I can always install wintegrate but I may not want to rock the boat. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Phantom trail
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 __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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. *ASC*
> 114062 AMERICAN PERFIT XSTAL
> 18 TIMELAND COMPANY
> 19 MCCANN ELECTRONICS *STR*
> 130395 TERMINAL TECH SERVICE
> 138562 TOWN VISION ELECTRONICS
> 154897 CASIO SERV CENTER *ASC*
> 163063 CASIO SERV CENTER *ASC*
> 171230 AMERICAN PERFIT XSTAL
> 195731 ELECT MUSIC INSTR *FAS*
> 10 records listed
> Enter to print non exist record ids
> 007890
> 007891
> 007892
> 007893
> 007894
> 016057
> 016058
> 016059
> 016060
> 016061
>
> Here is the dict:
>
> 001: I
> 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> 003:
> 004: NAME
> 005: 25L
> 006: S
I can't test it right now, I don't have access to a Universe machine until
tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't
in ORDER.FILE.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 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 there any logic in why an id would be in ORDER.FILE versus ORDER.FILE.OTHER ? If so, maybe you could setup a distributed file so that it points at both of these files? I thought I had read of someone doing something like that. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Union Query
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 there any logic in why an id would be in ORDER.FILE versus ORDER.FILE.OTHER ? If so, maybe you could setup a distributed file so that it points at both of these files? I thought I had read of someone doing something like that. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: "EXECUTE COMMAND CAPTURING OUTPUT"
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 input to continue and > user thinks the session is hung up or locked, or they start hitting > returns and log themselves off. If we can tell we are in capturing output, > we can force the session to end the capture and return to a > menu. Isn't one of the SYSTEM() values the number of nested execute levels? If so, you could check if the level is higher then zero and if so, within the target program, you could have it act differently. For example doing a STOP or ABORT instead of an INPUT. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
"EXECUTE COMMAND CAPTURING OUTPUT"
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 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 input to continue and user thinks the session is hung up or locked, or they start hitting returns and log themselves off. If we can tell we are in capturing output, we can force the session to end the capture and return to a menu. Thanks! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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. *ASC*
114062 AMERICAN PERFIT XSTAL
18 TIMELAND COMPANY
19 MCCANN ELECTRONICS *STR*
130395 TERMINAL TECH SERVICE
138562 TOWN VISION ELECTRONICS
154897 CASIO SERV CENTER *ASC*
163063 CASIO SERV CENTER *ASC*
171230 AMERICAN PERFIT XSTAL
195731 ELECT MUSIC INSTR *FAS*
10 records listed
Enter to print non exist record ids
007890
007891
007892
007893
007894
016057
016058
016059
016060
016061
Here is the dict:
001: I
002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
003:
004: NAME
005: 25L
006: S
-Original Message-
From: Allen Egerton [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 1:47 PM
To: U2 Users Discussion List
Subject: Re: Memo: RE: [UD] Union Query
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 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 dictionary look like?
Based on what he said, I'd guess something like this:
<0> NAME
<1> I
<2> TRANS(FILEA, @ID, NAME, ""): TRANS(FILEB, @ID, NAME, "")
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: RE: [UD] Union Query
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 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 dictionary look like? Based on what he said, I'd guess something like this: <0> NAME <1> I <2> TRANS(FILEA, @ID, NAME, ""): TRANS(FILEB, @ID, NAME, "") -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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 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 dictionary look like?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
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 the
data exists in both files. But at least then you will get twice the data. It
stands out pretty well if you want to spot problems.
HTH
R. Bruce Lunt
408.832.1900 cell
>From: [EMAIL PROTECTED]
>Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
>To: U2 Users Discussion List <[EMAIL PROTECTED]>
>Subject: Memo: RE: [UD] Union Query
>Date: Fri, 30 Apr 2004 16:49:46 +0100
>
>
>
>
>
>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 for FILE.B
>
>this is all off the top of my head, but it should work.
>
>hth
>
>asvin
>
>
>
>
>"Burwell, Edward" <[EMAIL PROTECTED] on 30 Apr 2004 16:33
>
>Please respond to U2 Users Discussion List <[EMAIL PROTECTED]>
>
>Sent by:[EMAIL PROTECTED]
>
>To:'U2 Users Discussion List' <[EMAIL PROTECTED]>
>cc:
>bcc:
>
>Subject:RE: [UD] Union Query
>
>
>@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..
>
>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 CASIO SERV CENTER *ASC*
>163063 CASIO SERV CENTER *ASC*
>171230 AMERICAN PERFIT XSTAL
>195731 ELECT MUSIC INSTR *FAS*
>10 records listed
>Enter to print non exist record ids
>007890
>007891
>007892
>007893
>007894
>016057
>016058
>016059
>016060
>016061
>
>Ed Burwell
>[EMAIL PROTECTED]
>973.361.5400 x1512
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 30, 2004 11:18 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [UD] Union Query
>
>
>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, ORDER.FILE.OTHER'>, 'X')
> 003:
> 004: City (ORDER.FILE.OTHER)
> 005: 30L
> 006: S
>
>Also, I recommend that you check out the capabilities of TRANS. There are
>other return codes.
>
>Hope this helps.
>
>Grant W. Boice, Jr.
>Systems Administrator
>Benchmark Electronics, Inc.
>Manassas Division
>8500 Phoenix Drive
>Manassas, VA 20110
>
>Phone: (703) 334-0156
>Email: [EMAIL PROTECTED]
>Web:www.bench.com
>
>
>
>-Original Message-
>From: Burwell, Edward [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 30, 2004 11:05 AM
>To: 'U2 Users Discussion List'
>Subject: RE: [UD] Union Query
>
>
>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 1 UNION 2
>SAVE-LIST LIST.ALL
>
>GET-LIST LIST.ALL
>
>What do you enter here?
>
>LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP
>
>or
>
>LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP
>
>How would a virtual dictionary know which file to get the NAME ADDRESS CITY
>and STATE from?
>
>Thanks.
>
>Ed Burwell
>[EMAIL PROTECTED]
>973.361.5400 x1512
>
>
>
>
>-Original Message-
>From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 30, 2004 10:27 AM
>To: 'U2 Users Discussion List'
>Subject: RE: [UD] Union Query
>
>
>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 f
Causes of a RD Group Lock - Universe 9.6 and AIX
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 running the process. There are no READU or WRITEU statements in the process. Since it is a nightly routine that is run, I am phantoming off a small log process to capture ps, list_readu, and port.status. Before the program is run, there is no group lock on the file. Even better, this only occurs a few times a week. The rest of the time, the program runs just fine. Does anyone have any ideas? Jeffrey Lawson Technical Support Engineer Columbia Ultimate Business Systems (800)488-4420 x276 [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
OLEDB problem with UniData
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 case of 12 or so SQL statements that execute one after the other for a defined number of times. In otherwords the 12 statements are execute over and over for 20 times. Note the 12 statements are not dynamic so they are the same exact query each time, with no variations in data possible. What we are experiencing is a random points in the test we receive an E_FAIL condition. Sometimes it is on iteration 3 and sometimes it is on iteration 19 and sometimes somewhere else. As seen in the DRITrace log segements below there seems to be a pattern in the log of a thread change. When the problem occurs it is preceded by a change in the pattern. Also it looks as if UniData executes the query fine the error is when the data is coming back up the pipe. Check the log segments below. Finally we are using a UniOLEDB version just delivered by IBM, but prior versions also had the problem. The current version we are using is 1.4.5. The UniData version is 6.0.12. Normal set of thread changes occur and there is no error condition around this change. Note there is a change after uci::SQLFreeStmt entries. The next change occurs shortly after after a CAr, CDR log entry combination. uci::SQLFreeStmt(4100808) 00093900 uci::SQLFreeStmt(4100808) 00093901 uci::SQLFreeStmt(4100808) 00093902 THREAD CHANGED: New thread ID=5676(162c) 00093902 CArCommand(120200068)::~CArCommand() 00093903 CDRImCommandUCI::~CDRImCommandUCI 00093904 THREAD CHANGED: New thread ID=1832(728) 00093904 IDBPropertiesImpl(121732620)::GetProperties 00093905 DBPROP_CONNECTIONSTATUS 00093906 DBPROP_CONNECTIONSTATUS: Again we get a thread change in the same pattern as the last one. Everything looks good. uci::SQLFreeStmt(4100808) 00097605 uci::SQLFreeStmt(4100808) 00097606 uci::SQLFreeStmt(4100808) 00097607 THREAD CHANGED: New thread ID=5676(162c) 00097607 CArCommand(120200068)::~CArCommand() 00097608 CDRImCommandUCI::~CDRImCommandUCI 00097609 CArCommand(120197764)::~CArCommand() 00097610 CDRImCommandUCI::~CDRImCommandUCI 00097611 CArCommand(120202380)::~CArCommand() 00097612 CDRImCommandUCI::~CDRImCommandUCI 00097613 CArCommand(120204684)::~CArCommand() 00097614 CDRImCommandUCI::~CDRImCommandUCI 00097615 THREAD CHANGED: New thread ID=1832(728) 00097615 IDBPropertiesImpl(121732620)::GetProperties 00097616 DBPROP_CONNECTIONSTATUS 00097617 DBPROP_CONNECTIONSTATUS: Again we get a thread change in the same pattern as the last one. Everything looks good. uci::SQLFreeStmt(4100808) 00099443 uci::SQLFreeStmt(4100808) 00099444 uci::SQLFreeStmt(4100808) 00099445 THREAD CHANGED: New thread ID=5676(162c) 00099445 CArCommand(120204684)::~CArCommand() 00099446 CDRImCommandUCI::~CDRImCommandUCI 00099447 CArCommand(120202380)::~CArCommand() 00099448 CDRImCommandUCI::~CDRImCommandUCI 00099449 CArCommand(120197764)::~CArCommand() 00099450 CDRImCommandUCI::~CDRImCommandUCI 00099451 THREAD CHANGED: New thread ID=1832(728) 00099451 IDBPropertiesImpl(121732620)::GetProperties 00099452 DBPROP_CONNECTIONSTATUS 00099453 DBPROP_CONNECTIONSTATUS: The patterns above keep occuring for a period of time. This seems to be a good pattern when everything is working correctly. BUT then the next section of logs display thread changes, but they do not follow the patterns above and wam! the error occurs. 00134309 uci::SQLFetch(4100808) 00134310 CArIRowsetImpl::GetNextRows(Got:1) 00134311 CArIRowsetImpl(121726428)::GetData(121725064, 121747320, 2065392) 00134312 CDRImAdmin::ClearError 00134313 CArCommand(120217196)::GetColumnInfo() 00134314 CArCommand(120217196)::GetColumnInfo() 00134315 THREAD CHANGED: New thread ID=5676(162c) 00134315 CArCommand(120196428)::~CArCommand() 00134316 CDRImCommandUCI::~CDRImCommandUCI 00134317 CDRImUCIHSTMT::Close 00134318 Closing UCI HSTMT 4100808 00134319 uci::SQLFreeStmt(4100808) 00134320 uci::SQLFreeStmt(4100808) 00134321 uci::SQLFreeStmt(4100808) 00134322 CArCommand(120197764)::~CArCommand() 00134323 CDRImCommandUCI::~CDRImCommandUCI 00134324 CArCommand(120204684)::~CArCommand() 00134325 CDRImCommandUCI::~CDRImCommandUCI 00134326 CArCommand(120202380)::~CArCommand() 00134327 CDRImCommandUCI::~CDRImCommandUCI 00134328 CArCommand(120214732)::~CArCommand() 00134329 CDRImCommandUCI::~CDRImCommandUCI 00134330 CArCommand(120216652)::~CArCommand() 00134331 CDRImCommandUCI::~CDRImCommandUCI 00134332 THREAD CHANGED: New thread ID=1832(728) 00134332 CArIRowsetImpl(121726428)::ReleaseRows 00134333 CDRImAdmin::ClearError 00134334 CArIRowsetImpl(121726428)::GetNextRows(hChapter:0, Asked for:1) 00134335 CDRImAdmin::ClearError 00134336 CDRImAdmin::ClearError 00134337 CArRowset(121726428)::FetchRows() 00134338 CDRImRowsetUCI::GetNextRows
RE: UniData JDBC
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 to use with jdbc. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fawaz Ashraff Sent: Friday, April 30, 2004 9:37 AM To: U2 Users Discussion List Subject: UniData JDBC 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 __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: RE: [UD] Union Query
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 the
data exists in both files. But at least then you will get twice the data. It
stands out pretty well if you want to spot problems.
HTH
R. Bruce Lunt
408.832.1900 cell
From: [EMAIL PROTECTED]
Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]>
To: U2 Users Discussion List <[EMAIL PROTECTED]>
Subject: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 16:49:46 +0100
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 for FILE.B
this is all off the top of my head, but it should work.
hth
asvin
"Burwell, Edward" <[EMAIL PROTECTED] on 30 Apr 2004 16:33
Please respond to U2 Users Discussion List <[EMAIL PROTECTED]>
Sent by:[EMAIL PROTECTED]
To:'U2 Users Discussion List' <[EMAIL PROTECTED]>
cc:
bcc:
Subject:RE: [UD] Union Query
@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..
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 CASIO SERV CENTER *ASC*
163063 CASIO SERV CENTER *ASC*
171230 AMERICAN PERFIT XSTAL
195731 ELECT MUSIC INSTR *FAS*
10 records listed
Enter to print non exist record ids
007890
007891
007892
007893
007894
016057
016058
016059
016060
016061
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [UD] Union Query
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)
005: 30L
006: S
Also, I recommend that you check out the capabilities of TRANS. There are
other return codes.
Hope this helps.
Grant W. Boice, Jr.
Systems Administrator
Benchmark Electronics, Inc.
Manassas Division
8500 Phoenix Drive
Manassas, VA 20110
Phone: (703) 334-0156
Email: [EMAIL PROTECTED]
Web:www.bench.com
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:05 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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 1 UNION 2
SAVE-LIST LIST.ALL
GET-LIST LIST.ALL
What do you enter here?
LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP
or
LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP
How would a virtual dictionary know which file to get the NAME ADDRESS CITY
and STATE from?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:27 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 9:13 AM
To: 'U2 Users Discussion List'
Subject: [UD] Union Query
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" NAME ADDRESS
CITY STATE ZIP
Thanks in advance.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PR
Memo: RE: [UD] Union Query
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 for FILE.B
this is all off the top of my head, but it should work.
hth
asvin
"Burwell, Edward" <[EMAIL PROTECTED] on 30 Apr 2004 16:33
Please respond to U2 Users Discussion List <[EMAIL PROTECTED]>
Sent by:[EMAIL PROTECTED]
To:'U2 Users Discussion List' <[EMAIL PROTECTED]>
cc:
bcc:
Subject:RE: [UD] Union Query
@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..
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 CASIO SERV CENTER *ASC*
163063 CASIO SERV CENTER *ASC*
171230 AMERICAN PERFIT XSTAL
195731 ELECT MUSIC INSTR *FAS*
10 records listed
Enter to print non exist record ids
007890
007891
007892
007893
007894
016057
016058
016059
016060
016061
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [UD] Union Query
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)
005: 30L
006: S
Also, I recommend that you check out the capabilities of TRANS. There are
other return codes.
Hope this helps.
Grant W. Boice, Jr.
Systems Administrator
Benchmark Electronics, Inc.
Manassas Division
8500 Phoenix Drive
Manassas, VA 20110
Phone: (703) 334-0156
Email: [EMAIL PROTECTED]
Web:www.bench.com
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:05 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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 1 UNION 2
SAVE-LIST LIST.ALL
GET-LIST LIST.ALL
What do you enter here?
LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP
or
LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP
How would a virtual dictionary know which file to get the NAME ADDRESS CITY
and STATE from?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:27 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 9:13 AM
To: 'U2 Users Discussion List'
Subject: [UD] Union Query
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" NAME ADDRESS
CITY STATE ZIP
Thanks in advance.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
**
This message originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
**
Re: [UD] Union Query
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 "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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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: [UD] Union Query No, a record ID in one file will not exist in the other file. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 (A UnitedHealth Company) 301-360-8839 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward > Sent: Friday, April 30, 2004 11:24 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > 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 > 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? > > -Original Message- > From: Burwell, Edward [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 8:05 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > 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 1 UNION 2 > SAVE-LIST LIST.ALL > > GET-LIST LIST.ALL > > What do you enter here? > > LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP > > or > > LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP > > How would a virtual dictionary know which file to get the > NAME ADDRESS CITY and STATE from? > > Thanks. > > Ed Burwell > [EMAIL PROTECTED] > 973.361.5400 x1512 > > > > > -Original Message- > From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 10:27 AM > To: 'U2 Users Discussion List' > Subject: RE: [UD] Union Query > > > 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- > From: Burwell, Edward [mailto:[EMAIL PROTECTED] > Sent: Friday, April 30, 2004 9:13 AM > To: 'U2 Users Discussion List' > Subject: [UD] Union Query > > > 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" > NAME ADDRESS CITY STATE ZIP > > Thanks in advance. > > Ed Burwell > [EMAIL PROTECTED] > 973.361.5400 x1512 > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] uvconfig parameters - T30FILE, MFILES, etc.
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 between the various parameters in uvconfig. So far, the change I made don't seem to have had any negative effect, but I'm wondering if something is waiting in the weeds getting ready to bite me? Are there any other parameters I need to adjust when I change T30FILE? In particular, do I need to increase MFILES correspondingly? TIA for any advice. Thanks Clif. David Scoggins IT Analyst CornerStone Propane mailto:[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
@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..
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 CASIO SERV CENTER *ASC*
163063 CASIO SERV CENTER *ASC*
171230 AMERICAN PERFIT XSTAL
195731 ELECT MUSIC INSTR *FAS*
10 records listed
Enter to print non exist record ids
007890
007891
007892
007893
007894
016057
016058
016059
016060
016061
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [UD] Union Query
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)
005: 30L
006: S
Also, I recommend that you check out the capabilities of TRANS. There are
other return codes.
Hope this helps.
Grant W. Boice, Jr.
Systems Administrator
Benchmark Electronics, Inc.
Manassas Division
8500 Phoenix Drive
Manassas, VA 20110
Phone: (703) 334-0156
Email: [EMAIL PROTECTED]
Web:www.bench.com
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:05 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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 1 UNION 2
SAVE-LIST LIST.ALL
GET-LIST LIST.ALL
What do you enter here?
LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP
or
LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP
How would a virtual dictionary know which file to get the NAME ADDRESS CITY
and STATE from?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:27 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 9:13 AM
To: 'U2 Users Discussion List'
Subject: [UD] Union Query
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" NAME ADDRESS
CITY STATE ZIP
Thanks in advance.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 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? -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 8:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 1 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query 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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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)
005: 30L
006: S
Also, I recommend that you check out the capabilities of TRANS. There are other
return codes.
Hope this helps.
Grant W. Boice, Jr.
Systems Administrator
Benchmark Electronics, Inc.
Manassas Division
8500 Phoenix Drive
Manassas, VA 20110
Phone: (703) 334-0156
Email: [EMAIL PROTECTED]
Web:www.bench.com
-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 11:05 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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 1 UNION 2
SAVE-LIST LIST.ALL
GET-LIST LIST.ALL
What do you enter here?
LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP
or
LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP
How would a virtual dictionary know which file to get the NAME ADDRESS CITY
and STATE from?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:27 AM
To: 'U2 Users Discussion List'
Subject: RE: [UD] Union Query
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-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 9:13 AM
To: 'U2 Users Discussion List'
Subject: [UD] Union Query
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" NAME ADDRESS
CITY STATE ZIP
Thanks in advance.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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? -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 8:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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 1 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query 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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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 1 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query 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- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query 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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] [AD] Passing the Baton (Repeat)
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 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za "In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea." - Douglas Noel Adams (b. 1952), British author -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: 29 April 2004 09:55 To: U2 Users Discussion List Subject: [ADMIN] [AD] Passing the Baton (Repeat) A repeat for those who may have missed it, and for our new subscribers. This weekend is the switch to the new host at listserver.u2ug.org. -- Regards, Clif Dear Friends, As previously announced, after about nine years of hosting what has become the u2-users list, I have decided to pass the baton to a new host. I plan to use the time to pursue some other writing projects. One of these is to resume writing my column previously published in Infocus Magazine as "Clif Notes." I will be choosing a different title and will be including it as part of a professional Information Management newsletter. If you would be interested in receiving this newsletter at no charge, just pop an e-mail to [EMAIL PROTECTED] and I will add you to the list. The U2 User Group (u2ug.org) has offered to assume the duties of host and moderator(s). They are in the process of testing their list server and setup now. We expect to be able to move the u2-user and u2-community lists to the new home May 1st. I will provide them a copy of the subscriber addresses as of April 30th. If for some reason you do not want to follow the lists to their new homes, you can unsubscribe before that time. Since we are getting new subscribers on an almost daily basis, I will be posting this message each day until the move. I apologize for the inbox clutter this causes you. I'll chat with you again before the move. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniData JDBC
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 __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Union Query
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- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query 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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UD] Union Query
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" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
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: Thursday, April 29, 2004 7:10 AM Subject: RE: Input weirdo... > Thanks Mark! > > Bjorn managed to find his reply (in an Advanced Pick manual) > just after > I'd sent the request, which kinda worked, but not exactly, > but your > length of inputbuffer works a charm. > > Speaking of these SYSTEM thangs - is there anywhere I can > get a list of > all the settings / variables included in SYSTEM(x)? > > -Original Message- > > [snip] > > SYSTEM(14) is the length of the typeahead buffer. D3 for > sure and > possibly UV/UD. The CLEARSELECT is UV/UD specific. > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > --- > [ Eckel certifies this E-mail to be virus free. ] > > > --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
The other side
Will be watching you all on the other side -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
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 machines I've worked on to their knees... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Differences
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 generically to all its database products, no doubt to confuse the world into believing that DB2 is the "only" database (personal opinion). UniVerse and UniData are very similar (to end users), non first normal form database products, based on a model that pre-dates SQL. While each supports SQL, it is not currently the principal query language used. The data model, while relational, incorporates nesting, which DB2 UDB does not. That is, conceptually, a cell (row/column intersection) can have a data type of "table". IBM acquired these, along with six other database products, from Informix. Administration of UniVerse is radically different from UniData, and both even more radically different from DB2 UDB. Further, there is no such thing as "a" course. There's one for the query language, one for the programmer, one (or more) for the administrator in each case. Try linking to IBM's web site, going to www-306.ibm.com/software/data/u2 as your start point. You can get to the library (manuals, tech bulletins, etc.) and training and certification from this page. Sometimes you will end up on a DB2 page while following these links. The U2 (UniVerse/UniData) information is usually in tiny print at the bottom or somewhere else obscure on these pages. Good luck! - Original Message - From: "Trevor McNamara" <[EMAIL PROTECTED]> Date: Fri, 30 Apr 2004 20:26:15 +1000 To: [EMAIL PROTECTED] Subject: Differences > 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 thing (Newbie questions:) > ) would be much appreciated. > > Thanks > > Trev > > _ > Find love today with ninemsn personals. Click here: > http://ninemsn.match.com?referrer=hotmailtagline > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] B-TREE INDEX
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 <[EMAIL PROTECTED]> Date: Fri, 30 Apr 2004 11:01:13 +0200 To: "U2 User Group" <[EMAIL PROTECTED]> Subject: [UV] B-TREE INDEX > 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 : +27 11 444 5391 > Mail: [EMAIL PROTECTED] > WWW : http://www.hyflo.co.za > > "In the beginning, the universe was created. > This made a lot of people very angry, and > has been widely regarded as a bad idea." > - Douglas Noel Adams (b. 1952), British author > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Name Resolution
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 Resolution
> Hi All,
>
> does anyone currently do name resolution from within UV?
>
> I have a need to determine the dns name corresponding to an IP address under
> UV 10.0 on AIX, Linux and NT.
> I would prefer not execute an external utility and cannot use GCI.
>
> My current thoughts are to create a sockets client to query a DNS server,
> but I did wonder if there was a better way to do this.
>
> ICONV("203.42.18.135", "DNSPTR") ;)
>
> thanks,
>
>
> Craig
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Differences
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 thing (Newbie questions:) ) would be much appreciated. Thanks Trev _ Find love today with ninemsn personals. Click here: http://ninemsn.match.com?referrer=hotmailtagline -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] B-TREE INDEX
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 : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za "In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea." - Douglas Noel Adams (b. 1952), British author -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
