DSXchange

I am trying to use the DS_JOBS to obtain the path listing and job name. I have Server job that works but give peculiar results. When I use view data in the Hash File to retrieve JOB_NAME from DS_JOBS it will show me the correct name....however when I run the job to load the info into a table or file it prints out NRO. Where is the NRO coming from and why would view data show one thing and the job when ran show another?

NRO means Not Read Only and is another piece of metadata in the table. I would assume you've got your hashed file setup incorrectly. Post your columns and which is marked as the Key field.

I checked the JOB_NAME off as the key and it worked...odd

Not really.

Hashed files are navigated by field position, rather than by field name. Non-key fields occupy positions 1, 2, 3 and so on.