View data error

[abhay10]

Hi All

when i select the view data option the ODBC stage is giving the error
no rows were returned from the view data server command


##I TOSH 000002 17:59:16(001) <main_program> orchgeneral: loaded
##I TOSH 000002 17:59:16(002) <main_program> orchsort: loaded
##I TOSH 000002 17:59:16(003) <main_program> orchstats: loaded
##I TFSC 000001 17:59:16(004) <main_program> APT configuration file: /bustools/diws/iwd/751/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 17:59:16(005) <main_program> Parameter specified but not used in flow: _Oracle_SchemaName
##W TCOS 000049 17:59:16(006) <main_program> Parameter specified but not used in flow: _DB2_PackageName
##W TCOS 000049 17:59:16(007) <main_program> Parameter specified but not used in flow: _DB2_DataSource
##W TCOS 000049 17:59:16(008) <main_program> Parameter specified but not used in flow: _DB2_Password
##W TCOS 000049 17:59:16(009) <main_program> Parameter specified but not used in flow: _DB2_UserName
##W TCOS 000049 17:59:16(010) <main_program> Parameter specified but not used in flow: _Oracle_DataSource
##W TCOS 000049 17:59:16(011) <main_program> Parameter specified but not used in flow: _Oracle_Password
##W TCOS 000049 17:59:16(012) <main_program> Parameter specified but not used in flow: _Oracle_UserName
**VIEWDATA ROW LIMITER HIT**


and when i run the job its working proper ie the data is getting transfrerred from source to destination

can anyone help me out and tell y view data is not working though the jobs works properly when we run it

[tbharathkumar]

Hi,

No records in your table or DB you are retriving.,

regards,
Bharat

[abhay10]

yup thanks

actually i had set the skip count to 10 and was viewing the data but thw table contained only 2 records

thanks all