I want to find the 50th city code.how?

akhil · Post by **akhil** » Sat Mar 20, 2010 7:09 pm

plz suggest me anyone...

Anuj Dhawan · Post by **Anuj Dhawan** » Tue Mar 23, 2010 2:45 pm

You need to provide more explnation about your query.

sambit_mech · Post by **sambit_mech** » Wed Jul 14, 2010 11:21 am

I think you need to read the 50th record from a PS file. If that is the case here's how:

Read infile and add 1 to ws-record-read variable until ws-record-read = 50.

fredrick andrews · Post by **fredrick andrews** » Thu Feb 23, 2012 7:26 am

I think this is a DB2 interview question.

Table (City,city code)

He wants the city code for the city that is the 50th retrieved row.

dbzTHEdinosauer · Post by **dbzTHEdinosauer** » Thu Feb 23, 2012 9:23 am

Fredrick Andrews,

i realize that you are trying to increase your post count,
but try to pick on questions that are not 2 years old

besides, any idiot that says nth row anything without an established ORDER BY
simply does not understand DB2

mainframegurukul.com

I want to find the 50th city code.how?

I want to find the 50th city code.how?

FREE TUTORIALS