AS400/DB2 and sysibm.sysdummy1

[hans...@my-deja.com]

Hi, in the comp.databases.ibm-db2 newsgroup they say that the db2
equivalant to oracle's sys.dual is sysibm.sysdummy1.

I.E. SELECT CURRENT DATE FROM SYSIBM.SYSDUMM1;

But it doesn't seem to work on AS400/DB2 with OS/400 V4R4

Does anyone know the equivalant on AS400/DB2??

Thanks!

Sent via Deja.com http://www.deja.com/
Before you buy.

[thoma...@my-deja.com]

I'm primarily an AS/400 person, but I have never seen an equivalent to
Oracle's SYS.DUAL. Could you just create a table and put one row into
it?

There are many functions in Oracle that have no AS/400 equivalent, by
the way.

[hans...@my-deja.com]

Thanks, I will probably have to do just that. Alas, I really hate
mickey mouse work arounds, something I have to do a lot with AS400/DB2.

In article <913iio$189$1...@nnrp1.deja.com>,

[thoma...@my-deja.com]

Yeah, I understand. I am pretty new into Oracle, but I like what I am
finding. There are a lot of nice features that AS/400 DB2 could use.

What has happened, however, is that Rochester is implementing the ANSI
SQL standard exactly, and is not than implementing any extensions to it.

I think this will become more problematic as Rochester de-emphasizes
DDS as the primary data description language in favor of DDL, because
the AS/400 has significant legacy extensions to SQL that 'statndard'
DDL will not accommodate, as does Oracle. I don't think the full
implications of this direction have yet hit the legacy AS/400 community.

Anyway, good luck, sorry I didn't have a better suggestion.

In article <915df9$dv7$1...@nnrp1.deja.com>,

hans...@my-deja.com wrote:
> Thanks, I will probably have to do just that. Alas, I really hate
> mickey mouse work arounds, something I have to do a lot with
AS400/DB2.

[Charles R. Pence]

hans...@my-deja.com wrote:
> Hi, in the comp.databases.ibm-db2 newsgroup they say that the db2
> equivalant to oracle's sys.dual is sysibm.sysdummy1.
>
> I.E. SELECT CURRENT DATE FROM SYSIBM.SYSDUMM1;
>
> But it doesn't seem to work on AS400/DB2 with OS/400 V4R4
>
> Does anyone know the equivalant on AS400/DB2??

Regardless of an apparent spelling error ;-) which is moot since
SYSIBM is not by default available for DB2/400, you could use what
the procedures are implemented with:
SELECT CURRENT DATE FROM QSYS2.QSQPTABL

Regards, Chuck
All comments provided "as is" with no warranties of any kind whatsoever.

[hans...@my-deja.com]

Just what the doctor ordered! thanks!

[Kent Milligan]

Why not just create a dummy table called DUAL in a library called SYS?
Or VALUES CURRENT DATE INTO :var1;

Just become something is there first doesn't mean it's necessarily the best.

If Oracle is the one setting the bar, then why our big ISVs such as SAP & Siebel
dropping Oracle for DB2 UDB as their preferred platform?

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
km...@us.removethis.ibm.com GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)