External Source Stage problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
caola
Participant
Posts: 10
Joined: Tue Jul 24, 2007 3:42 am

External Source Stage problem

Post by caola »

Hi all

There's a weird problem of External Source Stage. Pls help..

My job is like:

External Source---->XML Input----->Transformer--->Sequential File
|
|rej link to Peek Stage
|
Peek


In External Source:
Source Method=Specific Program
Source Program = ls "#FileName#"

Most of the time this job works fine. But randomly there's no record output from External Source. In the log, the job is in finished status but has below line:
External_Source_0,0: Import complete; 0 records imported successfully, 0 rejected.

When I re-run the same job it finished with:
External_Source_0,0: Import complete; 1 records imported successfully, 0 rejected.
:)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If the ls command reports no filenames, then the External Source stage will report 0 records imported. The whole thing depends on the value of the job parameter.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply