DSXchange

vmcburney wrote: NullToZero(SetNull)) might work if the Modify stage accepts multiple functions.

Thanks for your response Vincent. I tried this particular hack, but no luck!

Rob

thompsonp, Thanks for your response. Of course I can use a transformer. I have used transformers many times when I thought the function I needed to perform should be easy for a modify to accomplish. However transformers are slow. Modify is fast. The occasions I have used it to change data types I ha...

I've searched the forum to no avail for a way of assigning an outgoing column to zero in a modify stage. Our mapping rules have changed and a value that is being fed in from a number of jobs will now need to be zero. Rather than modify the 30+ jobs that feed the job in question, I want to set the co...

When you read the file up on the mainframe, do the offending records have 206 in the file type position, or are they also corrupted up there?

Hi Geeks,

Can you see that the 7 incorrectly rejected records have '206' as the first characters?

Are these characters a string or are they a COMP numeric field?

Rob W

All, After monkeying around with this for a while, ignoring it for a while and then returning to it (and swiping someone else's ideas), I've got a partial solution to this problem. Along with the duplicate rows, we were getting a message: Rob1_Lookups: When checking operator: Operator of type "...

Hi Sakthi,

Have a look at this link

viewtopic.php?t=96485&highlight=greg+en ... e+teradata

Rob W.

All, I've got two jobs. The first job, called BuildLists, reads a couple of sequential files and populates two lookup lists, one hosted in a FileSet the other in a Dataset. Previously the BuildLists job was pointing to the default config file which defined just a single node. Now it points to a new ...

Thanks for the input, folks.

Rob W

If your using only one Dataset and accessing the same dataset multiple times. I don't think so, any problem is there. We are also using the similar manner and we haven't faced any problem.

Good news.

Thanks.

Hi Nageshsunkoji,

I am only using one DataSet, but referring to it multiple times by using multiple stages. Each stage points to the same underlying dataset in the OS.

No need to copy anything. I just needed to know that I could access the same dataset multiple times in the same job.

Rob W

Thanks, Arnd.

No internal locking for reading or anything like that?

Rob

Folks, I'm creating a job that needs to look into a list of values using multiple fields in the incoming file. In server it is quite common practice to set up a list in a hashed file and have multiple links from the single hashed file to the transformer performing the lookup. The EE version doesn't ...

ray.wurlod wrote:Thanks for letting us know.

My reaction (yuk) is unchanged.

Can't disagree, but it's what I'm stuck with!

Rob W.

We set APT_MAX_DELIMITED_READ_SIZE to 150000 from it's default of 100000 and the job read in our singular file.