Hi,
Is it possible to use same file in 3 stages to write output status.
I am not able to write the first 2 stages status, i think it is overriding the last 2 stages statuses.
Thanks
Write status in output file
Moderators: chulett, rschirm, roy
Titto,
you can use the same file in 3 stages as output if:
(a) it is not a sequential file
(b) if it is a hash file, the keys must be unique, meaning if one stage uses the same key as a previous one the value is overwritten
(c) if it is a direct database or ODBC connection then you need to ensure that the commits are performed immediatealy with no buffering.
you can use the same file in 3 stages as output if:
(a) it is not a sequential file
(b) if it is a hash file, the keys must be unique, meaning if one stage uses the same key as a previous one the value is overwritten
(c) if it is a direct database or ODBC connection then you need to ensure that the commits are performed immediatealy with no buffering.
Titto,
it was easier to tell you what you can't do than to figure out what you should do
You could write to 3 separate sequential files and later on concatenate them. You could write to a hash file adding the transform name to the key to make sure that records aren't duplicated. You could write to ODBC and not even bother about making a key... It depends upon a lot of factors that we don't know about. How many WRITEs are you doing to these 3 links?
it was easier to tell you what you can't do than to figure out what you should do
![Smile :)](./images/smilies/icon_smile.gif)
You could write to 3 separate sequential files and later on concatenate them. You could write to a hash file adding the transform name to the key to make sure that records aren't duplicated. You could write to ODBC and not even bother about making a key... It depends upon a lot of factors that we don't know about. How many WRITEs are you doing to these 3 links?
Thanks Arndw,
I following the method of writing different HAsh file and writing to a Seq Output file using Transformer.
I have one more question what kind of values does DSStageLastErr and DSLinkLaskErr macros set, I want to capture those to Log file. For example if stage or link completed succesfully will it genereate any Numereic number or a space.
thanks
I following the method of writing different HAsh file and writing to a Seq Output file using Transformer.
I have one more question what kind of values does DSStageLastErr and DSLinkLaskErr macros set, I want to capture those to Log file. For example if stage or link completed succesfully will it genereate any Numereic number or a space.
thanks