Transform incoming data from toracleinput and output into file

[Anonymous]

Hi ,

i want to edit the data coming from toracleinput like substring in tmap/ tjavarow and output to file.

toracleinput -> tmap -> tfileoutputdelimeted

i am currently getting null pointer exception.

But this works if i do it in another subjob storing the values first in a file and then transforming the data like below:

toracleinput -> tfile

tfileinput -> tmap -> tfileoutput

But i want to directly do it in single step as its consuming time.

Thanks in Adv,

Hachi

[Jesperrekuh]

In tmap you could write this code :

row1.name == null ? null : row1.name.substring(1,3)

The nullpointer exception is raised because the function cant handle null values, if you would put an empty string like "" its possible and thats the reason why first storing it into a file works... 
Make sure your output table can handle null values... because an empty string "" isnt the same as "null"