DS_JOBS

radarada · Post by **radarada** » Tue Jan 05, 2010 11:43 am

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?

chulett · Post by **chulett** » Tue Jan 05, 2010 11:52 am

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.

radarada · Post by **radarada** » Tue Jan 05, 2010 12:03 pm

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

chulett · Post by **chulett** » Tue Jan 05, 2010 2:37 pm

Not really.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 05, 2010 4:02 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Jan 05, 2010 4:04 pm

Moderator: please move to Server forum