Seq file loading

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
smitageorge
Participant
Posts: 37
Joined: Fri Sep 30, 2005 10:05 am
Location: va

Seq file loading

Post by smitageorge »

HI all,

While loading the data in the seq file i am getting following errors.

1.Sequential_File_57: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
2.BASIC_Transformer_42,0: Returned timestamp format not recognised for field - RUNDATE. Unable to set to Null.
3.BASIC_Transformer_42,0: The runLocally() of the operator failed.
4.BASIC_Transformer_42,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
5.main_program: Step execution finished with status = FAILED.

my job design is:

seq>>xfm>>seq

xfm column derivation >> "PARMDATE=" : DSLink43.MAX_DATE

can anybody throw some light on this.

Thanks
smita
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Parallel jobs strictly enforce data types. You must make sure, using appropriate functions, that the data type of RUNDATE is correct, and that the data in this column do actually conform to data type.
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