PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

SORTING - DESCEND problem

View previous topic View next topic Go down

SORTING - DESCEND problem

Post  rajkumar400 on Sat Dec 25, 2010 2:41 pm

I have an item# as a key field which is defind with DESCEND. But when i see the record using DBU ( upddta ) it is not showing in decending order.

DBU shows the records as follows:

ITEM#
1
2
5
7

Help me to corrcet this problem.

Raj

rajkumar400

Posts : 59
Join date : 2010-12-25

View user profile

Back to top Go down

Sorting issue

Post  kushaalrathi on Sun Dec 26, 2010 6:58 pm

Run query the file will help you to see the data in descend order

kushaalrathi

Posts : 12
Join date : 2010-12-26

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  rajkumar400 on Wed Dec 29, 2010 2:09 am

Thanks. Tried with runqry but not showing the records in the keyed order.

DBU should show the records in the keyed order but not showing.

rajkumar400

Posts : 59
Join date : 2010-12-25

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  soundhar on Wed Dec 29, 2010 1:39 pm

if u r viewing thru upddta it will show in descending order only,thru runqry it will show in the order in which u entered...

Thru upddta it doesnt show in descending order then check whether u hv used some other keywords or just show ur pf and lf entries now

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  soundhar on Wed Dec 29, 2010 1:42 pm

through runqry u cant see the changes u done on lf ie descend , it will show it in the order u have entered

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  rajkumar400 on Wed Dec 29, 2010 10:43 pm

This is THE code of PF

A R REC1
A ITEM# 5A
A DESC 30A
A LOC 15A
A QTY 7P 0
A K ITEM#


Raj

rajkumar400

Posts : 59
Join date : 2010-12-25

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  soundhar on Fri Dec 31, 2010 9:19 am

Through RUNQRY u cant see the records in descend order brother...
U can view through upddta and from RPG program but thru runqry u cant see... Show LF code also

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

Re: SORTING - DESCEND problem

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum