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
View data error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines
Re: View data error
Hi,
No records in your table or DB you are retriving.,
regards,
Bharat
No records in your table or DB you are retriving.,
regards,
Bharat
Re: View data error
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
actually i had set the skip count to 10 and was viewing the data but thw table contained only 2 records
thanks all