ansaurus

Question

Answer 1

+4 A:

I'm pretty certain it's DB2 running on those boxes (they're called iSeries now, by the way) so you can give:

select * from sysibm.sysdummy1

a shot. This should return a single column IBMREQD, set to Y.

paxdiablo 2010-03-16 13:42:45

I'll pass this on ... Would 'SELECT * FROM sysibm.sysdummy1 FETCH FIRST 1 ROW ONLY' be valid?

bryan_cook 2010-03-16 13:44:54

That's certainly valid syntax for DB2/z and DB2/LUW so I assume it would work on the iSeries as well. But I don't think it'll be needed, SYSDUMMY1 only *has* one row.

paxdiablo 2010-03-16 13:46:09

Ah, I see :-) I'll pass this on and we'll see how it goes. Appreciate the response!

bryan_cook 2010-03-16 13:48:33

And looking at the docs, 'fetch first n rows' was added in 5.1 back in 2001.

paxdiablo 2010-03-16 13:49:26

See http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstintsel.htm#intsel and remember: publib-boulder has a HUGE amount of online docs for all IBM products. That should be the first point of call if you're using IBM's wonderful software :-)

paxdiablo 2010-03-16 13:53:49

Just tried that SQL in the answer on an actual AS/400, and it does work. No need to limit the number of rows returned, as it returns only one row as-is.

Brian Showalter 2010-03-16 14:06:01

@paxdiablo Haven't heard back from my friend yet, but I'm sure what you've provided will work ... thanks for the answer and link!

bryan_cook 2010-03-17 13:05:54

@Brian Showalter Thanks for confirming!

bryan_cook 2010-03-17 13:06:45

"SELECT * FROM sysibm/sysdummy1 FETCH FIRST 1 ROW ONLY" works in STRSQL (note / instead of .)

Thorbjørn Ravn Andersen 2010-08-16 09:57:07

(and they are named *IBM i* this week)

Thorbjørn Ravn Andersen 2010-08-16 09:57:34

ansaurus

tags:

views:

answers:

AS/400 'SELECT 1' Equivalent

related questions