DSXchange

Posted: **Sat Jul 08, 2017 1:40 am**

am trying to join DS_JOBS and DS_JobOBJECTS table on JOBNO and OBJID respectively. One of my environment is not yielding the correct number of jobs that it ideally should and the reason is the JOBNO and OBJID are not having the same values.

In Dev I am getting 2500 jobs but in Test I am only getting some handful of them. My question is, Is this expected behavior that For one job I can expect different OBJID and JOBNO in the 2 tables?

My expectation was we get all the jobs of projects since Pk-fK relationship is maintained between the 2 tables.

Select OBJID,JOBNO,...... from DS_JOBS,DS_JOBOBJECTS where DS_JOBS.JOBNO = DS_JOBOBJECTS --> Yields different results in different environments with same jobs

More Specifically: select NAME,DS_JOBOBJECTS.OLETYPE,DS_JOBOBJECTS.OBJIDNO, EVAL DS_JOBOBJECTS."@RECORD<3,1>" from DS_JOBOBJECTS where OLETYPE='CJobDefn'; -- Yields just 250 jobs out of 2500

Posted: **Sun Jul 09, 2017 4:48 am**

You need to join DS_JOBS.JOBNO to DS_JOBOBJECTS.OBJIDNO, not to OBJID

Posted: **Sun Jul 09, 2017 9:08 am**

Looks like you had a spot of trouble with your "J" key...

Posted: **Sun Jul 09, 2017 9:33 pm**

chulett wrote:Looks like you had a spot of trouble with your "J" key...

Hmm. A downside of touch typing.

Posted: **Mon Jul 10, 2017 12:56 am**

ray.wurlod wrote:You need to join DS_JOBS.JOBNO to DS_JOBOBJECTS.OBJIDNO, not to OBJID ...

Apologies, I was joining on OBJIDNO itself and still not getting the entire list of jobs.

Could the reason be the Update that I made to the post i.e.
select NAME,DS_JOBOBJECTS.OLETYPE,DS_JOBOBJECTS.OBJIDNO, EVAL DS_JOBOBJECTS."@RECORD<3,1>" from DS_JOBOBJECTS where OLETYPE='CJobDefn'; -- Yields just 250 jobs out of 2500

Posted: **Tue Jul 11, 2017 3:44 am**

I don't see your join condition there. With the join you should not need the constraint on OLETYPE.

Posted: **Thu Jul 13, 2017 12:49 am**

Code: Select all

Select OBJIDNO,JOBNO,DS_JOBS.NAME from DS_JOBS,DS_JOBOBJECTS where DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO

If this does not lists all my jobs (which currently is happening with me), then where should I ask my admin to look into.

I know it should, but it is not, I'll close the post after your reply.

Posted: **Thu Jul 13, 2017 1:02 pm**

Does a query on DS_JOBS alone list all your jobs?

Code: Select all

SELECT NAME, JOBNO FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

Jobs with no design information (e.g. where you have imported only the executable) will not have any records in DS_JOBOBJECTS.

Posted: **Tue Jul 18, 2017 9:39 pm**

Cannot see the entire content, But Yes I am getting data out of DS_JOBS accurately.

I would like to incorporate my other post in this only:

Firstly, I am querying DS_JOBS and DS_JOBOBJECTS(using CJobdefn as filter), the Count of 2 doesn't match.

Secondly, If I join the 2 tables on JOBNO and OBJIDNO, the entire job list is not retrieved.

Should I be worried at all ?
What are the potential issues that I can get in my environment?

Just for information, there is no impact on my job runs and this is happening only in one of my Test environments)

DSXchange

Joining DS_JOBS and DS_JOBOBJECTS does not yield correct set

Joining DS_JOBS and DS_JOBOBJECTS does not yield correct set