If you plan to move you application out of USA and into countries where national chars are an issue, then it is good practice to use SRTSEQ(*JOB). On the other hand there is a performance penalty: If the logical file or index is not there, then the database management system need to make a temporary index before returning the result set.
Re: Sort sequence
If you plan to move you application out of USA and into countries where national chars are an issue, then it is good practice to use SRTSEQ(*JOB). On the other hand there is a performance penalty: If the logical file or index is not there, then the database management system need to make a temporary index before returning the result set.
Best regards,
Niels