HOW TO SHUTDOWN THIS WARNING

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
dsx_venkat
Participant
Posts: 12
Joined: Thu Sep 01, 2005 10:49 pm

HOW TO SHUTDOWN THIS WARNING

Post by dsx_venkat »

Hi All,

I am getting this warning whenever i am using reject link in the merge stage.

REJ020: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.


Since i need the same partition in the output link, i cannot able to clear the partition, If i use a dataset instead of squential file, warning is not there, but i want to use the sequential file.

One solution i can think is handling this in the message handler., Is there is any other way to handle this.,

Regards.
venkat
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
A partitioned sequential file would be interesting indeed if there was such a thing.
You get this since sequential files do not support partitioning, there for can't preserve them.
So you might be forced to use datasets after all Or simply run this job sequentially Or as you already know use message handlers.

It all depends on what you want/need.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi Venkat,

In the Stage prior to Sequential File Stage there is an option for propogating partition. Set it to CLEAR. The warning should disappear.

Venkat, Do a SEARCH in this forum before you post.

HTH
--Rich
dsx_venkat
Participant
Posts: 12
Joined: Thu Sep 01, 2005 10:49 pm

Post by dsx_venkat »

Respected richdhan,

Please read my posting clearly,

Since i need the same partition in the output link, i cannot able to clear the partition, If i use a dataset instead of squential file, warning is not there, but i want to use the sequential file.

Before giving advice like "DO a search", please read the question properly.

Roy,

Thanks for your suggestion, actually i am using that stage alone as a sequential stage now.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Hi venkat,

The same topic has been discussed earliar.

viewtopic.php?t=95035&highlight=preserve+partiton

Rich was also a contibuting member on the previous post.

Since we dont have a face to face conversation in this forum, words can be interperted by various means. hence framing sentance is seems to be important.


Instead of creating a new thread, you could have appended the same thread...
regards
kumar
dsx_venkat
Participant
Posts: 12
Joined: Thu Sep 01, 2005 10:49 pm

Post by dsx_venkat »

Kumar,

I tried to search, but couldnt get it,
As u said "framing sentance is seems to be important"


k,


richdhan, "sorry, if my word hurts u".
srikanthd1978
Charter Member
Charter Member
Posts: 38
Joined: Wed Mar 17, 2004 1:16 am
Location: USA

Post by srikanthd1978 »

..try using a copy operator prior to the seq file and clear the Partitioning on the Copy Op...this shld work..

thanks
Post Reply