I am a bit confused by these lines in DS Help Docs:
Where you are using a Copy stage with a single input and a single output, you should ensure that you set the Force property in the stage editor TRUE. This prevents DataStage from deciding that the Copy operation is superfluous and optimizing it out of the job.
So while having a single input and single output and I pass all columns thru it...what option do I set?
(I am doing this for possible access of the intermediate data in future)
Also, 2nd question...what if I have 2 outputs...what should I set?
Hi,
this note says that if you have only 1 output column you must set this force to true to force DS to leave it in and not optimize it out of the job at compile time.
in any case you have more then 1 output link (this is what you use copy stage for) you need not set the force to true since it will not be optimized out of the job.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
I have question on the same issue of setting 'force' value in copy stage if there is only one output link. I am using copy stage in a job with one input and one output link only as a place holder in case i need to replace it with a transformer stage in the future. In this case, i would prefer DataStage to optimize the generated code. So i would like to set this to 'False'. But the statement:
"Where you are using a Copy stage with a single input and a single
output, you should ensure that you set the Force property in the stage
editor TRUE. This prevents DataStage from deciding that the Copy
operation is superfluous and optimizing it out of the job."
is not leaving any room for such discretion during coding. Am I understanding this correctly? Should I not in any situation set Force to False if only one input and one output link exists?
You can set it to False if you like. What this ultimately means is that the optimizer can decide - if you are doing a direct copy with no changes particularly - not to include the Copy stage at all. After all, if it's a placeholder (a "do nothing" stage), then it's most efficiently replaced with a NO-OP (a "do nothing" operator).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I am pulling data from a sequential file and using copy stage to copy the data to another seq file. But the data is not copied to the out put file.I coud see data in the first seq file and the from copy stage no data is pushed to the output file.
Is your job running successfully and yet you cannot see the data in the sequential file or is your job aborting? Please give us more details so that we can help. Did you set all the required properties in the sequential file?