Issues when sending attchments through datastage email
Moderators: chulett, rschirm, roy
Issues when sending attchments through datastage email
We are trying to use the Datastage email activity stage to send an attachment. The data looks fine if we email the attachment ourselves outside of datastage...however if we ask datastage to send the attachment it changes the record format when it encounters a }
all records that do not have a } are fine...so only records with the } somewhere in the data will encounter issues.
Anyone know why Datastage would not like } in the data when sending an attachment?
This
0000000000000000010677468791H01092138110812708802947000080}
should be
0000000000000000000000000000000010677
468791H01092138110812708802947000080}
A new record should start at 468791H01...but it puts it all on one line. So when it encounters a } the line will go past the end of the record before it starts a new line....it's as if } becomes the new line...if that makes any sense
Anyone know why Datastage would not like } in the data when sending an attachment?
all records that do not have a } are fine...so only records with the } somewhere in the data will encounter issues.
Anyone know why Datastage would not like } in the data when sending an attachment?
This
0000000000000000010677468791H01092138110812708802947000080}
should be
0000000000000000000000000000000010677
468791H01092138110812708802947000080}
A new record should start at 468791H01...but it puts it all on one line. So when it encounters a } the line will go past the end of the record before it starts a new line....it's as if } becomes the new line...if that makes any sense
Anyone know why Datastage would not like } in the data when sending an attachment?
We are sending the sequential file as an attachment. File looks great until we try to use DataStage and send the file as an attachment...it is then that the data appears off...seems to be wherever a row contains a }
any help is greatly appreciated.
any help is greatly appreciated.
Last edited by Marley777 on Thu Nov 16, 2017 1:10 pm, edited 1 time in total.
looks like the file is created in Unix and when run unix2dos and then attach, file is coming properly. Try doing unix2dos and test it.
Please check similar post below
viewtopic.php?p=418450
Please check similar post below
viewtopic.php?p=418450
Venkata Srini