DSXchange

Hi,
have created two projects on same server.in one project in job can able to fetch data from univese database (localuv) from ds_jobs&ds_jobobjects.but in another project i couldnt able to fetch data please help on this.

Thanks

What's different?

Note: "nothing" is not the correct answer.

What error message(s) do you get in the second project?

Help us to help you.

have created two projects proj1 and proj2 on same server.imported prod dsx to both projects both projects sychronized.

i have created new job to get list of jobs in project.So created new job in proj1.

source query:
SELECT DS_JOBS.CATEGORY,DS_JOBS.NAME AS JOB_NAME
FROM DS_JOBS

universaldatabasestage(dsn-localuv)--transformer-seqfile

This job excuted in proj1.i am getting data.

but in the proj2 same job imported and excuted there is no data.

Please help on this

Is there an entry for localuv in the uvodbc.config file in each project?

Can you import the table definition for UniVerse table EXAMPLE1 in each project?

in both projects having same entry in uvodbc.config file.
and imported table definition example1 from each project but still not able to fetch data from proj2.

Thanks!!

Where exactly is the problem?
Can you View Data using the UniVerse stage?
Are there any errors or warnings in the job log?

At universe stage if i view it showing empty source.if i run job running successfully but no rows

Thanks

Then maybe the query genuinely returns 0 rows. Try executing the query using the Administrator client Command window.