Page 1 of 1

Unable to write in to Dataset

Posted: Sat Mar 29, 2008 7:19 am
by Lotus26
HI

I am experiencing a strange problem like I am writing data into a dataset .It is having more than 80 Columns in it .When I am attempting to write in to that the datastage job is failing with out giving any error messages .

Is there any limitation on number of columns to writing into datasets ??

I would appreciate your help. Thanks in advance.

Posted: Sat Mar 29, 2008 7:24 am
by ArndW
The is no column limitation close to 80 for DataSets. If you change your job to write to a sequential file (pathed to /dev/null) does it run correctly? Where are the data files written to (specified in the APT_CONFIG_FILE) and is that/are those disk(s) filling up?

Posted: Wed Apr 02, 2008 8:17 am
by keshav0307
is there any warning?? have you suppressed any warning,
if it is not completed successfully there there must be some message for it

Posted: Wed Apr 02, 2008 4:03 pm
by bcarlson
Check permissions on the directory where the dataset resides, and permissions on the dataset itself.

Brad