TOP keyword replacement for sql/400

[Ronze55]

Hi

I am not sure if this is the correct forum to place my question in but here goes.

I am trying to emulate a webFOCUS report on the SQL/400. the webFOCUS report uses FST.Field. I can use

select TOP(1) * from table

normally but SQL/400 does not have the keyword TOP.

does anyone know what the keyword is or how I can reproduce the webFOCUS function FST

thanks in advanced
Ronze

 

[MdnghtPgmr]

Ronze55,

Maybe CEILING(x)? What does FST do?

HTH,
MdnghtPgmr

 

[Ronze55]

mDNGHTpGMR

thanks for your responce.

FST is a function on webFOCUS very similar to count, or max

by saying FST.field1

I say that I want the record containing the first instance of field1 within a set

so i can say

fst.field1
by field2
by field3

field2 and field3 become the break points, sort of like group by.

I will look into ceiling.

thanks again
ronze

 

[MdnghtPgmr]

Ronze55,

This link may be helpful. It's the SQL manual for V5R2.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmst.pdf

HTH,
MdnghtPgmr

 

[Ronze55]

MdngtPgmr,

thanks for your link, the reference will come in handy!

Christina

 

[arrow483]

try FETCH 1 ROWS ONLY

 

[Ronze55]

Arrow

THANKS!

here is the query

select * from table1
fetch first 10 rows only

Ronze