Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
vinsashi
Participant
Posts: 150 Joined: Mon Aug 20, 2007 4:52 am
Location: singapore
Post
by vinsashi » Thu Aug 29, 2013 7:34 pm
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
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Aug 29, 2013 7:56 pm
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vinsashi
Participant
Posts: 150 Joined: Mon Aug 20, 2007 4:52 am
Location: singapore
Post
by vinsashi » Thu Aug 29, 2013 8:10 pm
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
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Aug 29, 2013 8:26 pm
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vinsashi
Participant
Posts: 150 Joined: Mon Aug 20, 2007 4:52 am
Location: singapore
Post
by vinsashi » Fri Aug 30, 2013 12:37 am
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!!
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Aug 30, 2013 2:44 am
Where exactly is the problem?
Can you View Data using the UniVerse stage?
Are there any errors or warnings in the job log?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vinsashi
Participant
Posts: 150 Joined: Mon Aug 20, 2007 4:52 am
Location: singapore
Post
by vinsashi » Fri Aug 30, 2013 4:54 am
At universe stage if i view it showing empty source.if i run job running successfully but no rows
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Aug 30, 2013 3:05 pm
Then maybe the query genuinely returns 0 rows. Try executing the query using the Administrator client Command window.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.