data is getting rejected when loading to file.

DSguru2B · Post by **DSguru2B** » Thu Oct 12, 2006 9:37 am

Specify it as char in you job itself. That should take care of it.

ambasta · Post by **ambasta** » Thu Oct 12, 2006 9:46 am

DSguru2B wrote:Specify it as char in you job itself. That should take care of it.

Thanks a lot for your kind suggession,but i am having source data as decimal and decimal value is coming for that column.

DSguru2B · Post by **DSguru2B** » Thu Oct 12, 2006 9:49 am

I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.

ambasta · Post by **ambasta** » Thu Oct 12, 2006 9:50 am

is there any option available in sequential file,such that it will automatically populate those many no of blank spaces!!!!

ambasta · Post by **ambasta** » Thu Oct 12, 2006 9:52 am

DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.

Target is already CHAR and it is Fixed Width file.

DSguru2B · Post by **DSguru2B** » Thu Oct 12, 2006 9:54 am

what is the length of you source and target?
You can stick a transformer in between and check for ISNULL and then explicity concatenate spaces.

Nageshsunkoji · Post by **Nageshsunkoji** » Thu Oct 12, 2006 9:57 am

ambasta wrote:
DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.
Target is already CHAR and it is Fixed Width file.

Hi Kunal,

You can acheive this by putting spaces in the Null field value option of the sequential file. Just, double click on the field and select the option null field value and put spaces equivalent to width of u r column. i.e if length of u r filed is 10, Put that many spaces in that null field value. I think it will solve u r problem.

ambasta · Post by **ambasta** » Thu Oct 12, 2006 9:58 am

Thanks GURU,
But this constrain is for around 100 fields.conversion like
Timestamp to Char
Varchar to Char
Decimal to Char etc are there.

ukyrvd · Post by **ukyrvd** » Thu Oct 12, 2006 10:19 am

ambasta wrote:
DSguru2B wrote:I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.
Target is already CHAR and it is Fixed Width file.

hmm!! in that case I think you are stuck with implementing nulltovalue logic before writing to the file!! I havent seen any general toplevel option that sets it automatically.

if its not fixed witdth file .. when you are specifying default value in column properties, VARCHAR doesnt require you to specify the exact length string .. but CHAR still requires that!!

DSguru2B · Post by **DSguru2B** » Thu Oct 12, 2006 10:22 am

Actually this is strange, a CHAR column with length 10 (for eg) will always result in 10 bytes when written to a fixed width file, regardless of the datatype of the source.

ambasta · Post by **ambasta** » Thu Oct 12, 2006 10:28 am

The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]

meena · Post by **meena** » Thu Oct 12, 2006 10:34 am

Hi,
Your columns are getting dropped for NULL'S. I think it is better to use "nulltovalue" function for the column or try to replace the column nulls to any value.

The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]

ukyrvd · Post by **ukyrvd** » Thu Oct 12, 2006 10:40 am

ambasta wrote:The problem is... data is getting rejected at transformer stage.and i am getting warning message as ...[APT_CombinedOperatorController(1),0: Field 'PROCESS_DATETIME' from input dataset '0' is NULL. Record dropped.]

this is different problem .. and covered well on DSX!!

this happens if you are doing any string operations without checking for NULL value ..

check this out:
viewtopic.php?t=100341

ambasta · Post by **ambasta** » Thu Oct 12, 2006 10:41 am

I think there is no other way out ....

.i need to do it in the transformer using IsNull function for every column separetely.

samsuf2002 · Post by **samsuf2002** » Thu Oct 12, 2006 10:49 am

in ur sourse file check the nulable col is it defined correctly,i think if a col is nullable and if u specify it as not null then it get dropped i am not sure some body correct me if i am wrong.