DSXchange

That is why you split it into 2 processes, 1) Re-format input file into common structure - 1 job per customer which will be quick to build. 2) Process all reformated files through your complex logic - Only one multi-instance job. It will be quicker to build a new re-format job for each customer than...

Try adding $APT_DISABLE_COMBINATION to your job and set it to True for debugging. Run the job and see what it says.

have you tried that? then post the new error message.

Write it out to a sequential file and show us what the value is,.

Go further back in the job though. It will probably complain if you do IsNull() on a field that is not nullable.

I think this might be complaining about the mapping from the previous stage. It looks like the operators have been combined so maybe the error message is a bit misleading where is this field? input0Int8CDKFRLU2_CLS_DT0 Try adding $APT_DISABLE_COMBINATION to your job and set it to True for debugging....

is this field (In.CDKFRLU2_CLS_DT) nullable?

Out of interest, why do you not know what format the file will come in? Is there a finite set of file formats? If there is create a small job that will reformat each file into standard format and then run that through your main job that has transformations in it. Users can choose which formating job...

WOW - I would love to see that!

would it not be easier to manipulate the file into a 'Standard Format' which the same job can process each time, rather than re-writing the job to fit the file???

watch out for fields that are set to 'not nullable' from the output of certain stages (certainly lookups). DS will fill that field with Ascii nulls which will cause you a problem when loading, and will not be identified with IsNul() or Len(Trim(field)) = 0. Change the field to nullable and hopefully...

Do you have the webservice pack? If you do it it easy, either create a job that writes records to the webservice stage, or you can call the webservice from a routine which datastage writes for you through Manager once you have the webservice pack installed. I've only used this breifly once but it wa...

EE will combine oporators in the job to improve performance, I can't see how it would try and combine a sort state and your rapper stage, but if you can see the data going into the sort stage and not going from your sort to your rapper stage i would just add $APT_DISABLE_COMBINATION = True as a mean...

Has anyone been playing with file permissions?

Check the permissions on DS_LICENSE in $DSHOME. Does your user have access to it?

Maybe you should get membership then???! You can't set a stage variable to null in EE. Although, certainly the unpatched version of 7.52 would let you compile a job with SetNull() in it, once you have the patches a compile error is seen. As Ray said, you can get around this by setting the stage vari...

@INROWNUM is the number of records that have been read from input. It will count up, the @OUTROWNUM for the link with @OUTROWNUM > 6 will not because no records are going down it. @INROWNUM, @OUTROWNUM 1 0 2 0 3 0 4 0 5 0 6 0 At this point if you had the constraint as @INROWNUM > 6 records would go ...

Try this, you may find the field function handy if you want these into 3 separate fields.