DSXchange

Sai,

And to my surprise...not all nulls in all fields do this...only few fields..
Do I need to configure NLS or something....?

Thankx

Do you mean Default NULL padding...I leave it blank... Here is how it is happening... File1 is read and written to File2 -- File 1 has some nulls..written as nulls in File2.. so far fine Again, in next job, File 2 is read and written to File 3--- here the Nulls in File 2 are wriiten as "?"...

I dont see any warnings or errors in my log too...
I dont even realize what kind of problems it may lead like lookup failures etc...any ideas, Pls let me know...

Hi, In my source csv file, I am getting some nulls without quotes ...DataStage is writing it to a seq file as a "?" instead nulls..Why is this happening..? I am using a after-job subroutine shell script to scrub "?' to NULLS..but I would like to know the reason and try to resolve it i...

Thanks Arnd,

Its a good idea to use FTP stage...
does it holds good for compressed files too...?

Hi,

Is there any stage in DataStage PX that we can use to pull a COBOL fmt file from main frame to UNIX...?
or is there any stage in PX, that can read COBOL file..?I think we dont have any in DS server

Thanks

This is the actual log error... I dont see any "?" in the record. but I am getting Null which is shown as "" in the log..It is unable to handle the nulls..do I need to set something at Default NULL String in the target seq file..? nls_map_buffer_out() - NLS mapping error, row 168...

This topic is covered earlier..
you have options either to use ODBC or save the excel file as csv or any text format and use Sequential file Stage..
Search thru the forum and you will get the answers...

Ray, JobName:.link.stagename:"nls_map_buffer_out() - NLS mapping error, row 12345 row = 'the whole record'.. The above given is the full message I could see..and this is seen in log and not when I view the data.. and I could see the same number of records loaded.. so i dont have any missing dat...

Hi All,

Can I get any help how to suppress this warning error.
"nls_map_buffer_out() - NLS mapping error, row 12345 row =......"
I dont see this error for all jobs.. The jobs runs ok, but I dont want to see these warnings too..

Thanks

Hi

Can anybody tell me what this error is about..?
I could see it as a fatal error..
ds_seqput: error in 'write()' - Error 0..
The job fails due to this..It ran well before, I never got this error, I haven't changed this job, but this time it fails due to this...

Thanks

You can Use a number of DS functions like DSGetJobInfo, DSStageInfo, DSlinkInfo etc.. .

Thanks Sai..

"If merge blows out, you can use 'type file1 > input.txt' and 'type file2 >> input.txt' and then send the input.txt via a sort routine. The result can then be checked for 'before-after records' to compare." Can you give me a littlebit detail on how the above option can be achieved..? Thanks

The file is having abt 4 million records... and about 10 to 15 attributes..
Is there any way to compare such a big file in DataStage..?