Hello,
This is my first topic. I am getting NAT1205 error(there is no more space in the core)
I am using the below code:
SORT BY EMP-NO EMP-NAME
USING
#ISN
EMP-NO: 9 bytes
EMP-NAME : 50 bytes
Getting error for more than 700 or 800 records if less than 700 or 800 records code is working fine. Please Help 
!
Check with your DBA for the SORTSZE buffer setting.
steve
Thanks Steve!
If i have the DBA access how can i increase the SORTSZE buffer?
SORTSZE is a NATPARM.
If you have access to change NATPARMs, you are all set.
steve
Arun,
I always encourage my friends to use external sort instead of internal sort. What will happen if yours employees increase to 5,000 or 10,000? You will be having same problem everytime it reaches threshold. Until and unless you are sure your data will not go beyond known count.
Have fun.
Kazi