Re: LEFT OUTER JOIN possible in DB2?
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/26/04
- Next message: Zeng: "Re: Clustered index vs. nonclustered index for GUID primary key"
- Previous message: Roji. P. Thomas: "Re: A total column for each month"
- In reply to: Ian Boyd: "Re: LEFT OUTER JOIN possible in DB2?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 18:25:47 +0200
> Please understand; i don't know what i'm using, as i am not the one using
> it. i was trying to get a customer to create a view on their IBM thingy.
Ahh I see.
> Turns out it is an AS/400. What relationship an AS/400 has to a DB2 i know
> not.
AS/400 is the hardware (like PC). OS/400 is the operating system (like NT or Windows). DB2 is the RDBMS (like
SQL Server).
Now, OS/400 comes with its own DBMS, which I assume is at a lower level that an RDBMS, like DB2 or SQL Server.
Since you said DB2 in your first post, I thought that this is what is used, hence why I posted how to get to
eh DB2 SQL syntax part.
Judging by this latest post, I understand that your customer is probably using that other DBMS that comes with
OS/400. I do not know that name it goes by or the name of the access language it uses, though. :-)
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Ian Boyd" <admin@SWIFTPA.NET> wrote in message news:%23gJuP31iEHA.4092@TK2MSFTNGP10.phx.gbl... > > Que? Your OP has SQL in it, and there certainly is a DB2 for AS 400, and > that DB2 certainly uses SQL. > > > > Or are you using some lower level of access to the database files? Your OP > definitely suggested you are using > > DB2 on the 400. > > Please understand; i don't know what i'm using, as i am not the one using > it. i was trying to get a customer to create a view on their IBM thingy. > > Turns out it is an AS/400. What relationship an AS/400 has to a DB2 i know > not. i assume that AS/400 is a type of DB2. Unless AS/400 is a software > package, that runs on a DB2 computer. > > Turns out a LEFT OUTER join is sorta possible in IBM/DB2/AS/400. You cannot > specify individual joins that will left outer join, but you can enable a > keyword > > JDEFVAL > > that makes all the joins FULL OUTER joins. > > Close enough. > >
- Next message: Zeng: "Re: Clustered index vs. nonclustered index for GUID primary key"
- Previous message: Roji. P. Thomas: "Re: A total column for each month"
- In reply to: Ian Boyd: "Re: LEFT OUTER JOIN possible in DB2?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
