View data error on the dataset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
saikiran
Premium Member
Premium Member
Posts: 18
Joined: Wed Aug 20, 2008 11:28 pm

View data error on the dataset

Post by saikiran »

I am trying to load two sequential files into the dataset using a join.The job runs fine without any errors and warnings.When I hit view data it pops out a message saying

No rows retured from the view data server commond..... when I click yes it says
View data for limiter hit
Can any one suggest on how to view the data


I dont see any errors nor any warnings in the datastage director.
When I hit the view data button for the dataset it pops out a message
saying

No rows were retured on the view data server command.
Would you like to view the commonds output.

If I click yes
It shows me
View data for limiter hit
Thank you
Sai
Last edited by saikiran on Sun Aug 24, 2008 7:41 pm, edited 1 time in total.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

View Data on which link?

Please post the entire and exact error message.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

Post by ramesh_inform »

fore most thing is that the question is incomplete

1.probable answer may be there may be "0" rows in your dataset/sequential file(whatever you are trying to view).

2.after clicking 'yes' in the message "no rows were returned......"
on the right most corner check the box "view error lines only"

and try resolving those errors.
ramesh.n.
Post Reply