View data on seq not working
Posted: Wed Mar 08, 2006 5:20 pm
Hi all,
I am trying to do a simple move from dataset to sequential file and in between using the remove duplicates stage .The job is getting compiled and is running good but when i am trying to view data it is giving following error:
No row are returned from the view data server command
would you like to view command output
when i am saying "yes"
it is displaying the following:
##I TFCN 000001 16:16:24(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 16:16:24(001) <main_program> The open files limit is 4096; raising to 2147483647.
##I TOSH 000002 16:16:24(002) <main_program> orchgeneral: loaded
##I TOSH 000002 16:16:24(003) <main_program> orchsort: loaded
##I TOSH 000002 16:16:24(004) <main_program> orchstats: loaded
##I TFSC 000001 16:16:24(005) <main_program> APT configuration file: /opt/apps/ds/idc_dev/configurations/idc_dev_1.apt
##W TCOS 000049 16:16:24(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TOIX 000163 16:16:25(000) <Sequential_File_26,0> Import complete; 0 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT
Thanks
smita
I am trying to do a simple move from dataset to sequential file and in between using the remove duplicates stage .The job is getting compiled and is running good but when i am trying to view data it is giving following error:
No row are returned from the view data server command
would you like to view command output
when i am saying "yes"
it is displaying the following:
##I TFCN 000001 16:16:24(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 16:16:24(001) <main_program> The open files limit is 4096; raising to 2147483647.
##I TOSH 000002 16:16:24(002) <main_program> orchgeneral: loaded
##I TOSH 000002 16:16:24(003) <main_program> orchsort: loaded
##I TOSH 000002 16:16:24(004) <main_program> orchstats: loaded
##I TFSC 000001 16:16:24(005) <main_program> APT configuration file: /opt/apps/ds/idc_dev/configurations/idc_dev_1.apt
##W TCOS 000049 16:16:24(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TOIX 000163 16:16:25(000) <Sequential_File_26,0> Import complete; 0 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT
Thanks
smita