A file contains a bunch of SWIFT format messages, all bundled together into a single file. We need a DataStage job that can separate out these messages into individual messages, and send it via MQ. A single swift message is a section between "{1" and "-}" identifier, and both should be included in the message.
{1:F01SBOSUS33AINV0000000001}{2:O5981747080324FIDQUS3BXXXX00000000010803241747N}
{4:
:20:HDR-080324-00035
:12:598
:77E:/AUSERID/FIDQUS3B
/ACONTACT/PROD SUPPO
RT (1-800-854-2825) BP (1-800-759-8888 PIN 8881744
/ATRFIND/1
/AEOD/N
-}
{1
:F01SBOSUS33AINV0001000001}{2:O5411747080324FIDQUS3BXXXX00000000010803241747N}{4
:
:16R:GENL
:20C::SEME//108032472835
:23G:NEWM
:16S:GENL
:16R:TRADDET
:98A
::SETT//20080327
:98A::TRAD//20080324
:90A::DEAL//PRCT/99,64
:35B:/US/872384A
E2
TEPPCO PARTNERS 6.65 4 15 18
:16R:FIA
:98A::MATU//20180415
:98A::ISSU//2
0080324
:92A::INTR//6,65
:16S:FIA
:16S:TRADDET
:16R:FIAC
:36B::SETT//FAMT/8
5000,
:97A::SAFE//2465
:16S:FIAC
:16R:SETDET
:22F::SETR//TRAD
:16R:SETPRTY
:95P::PSET//DTCYUS33
:16S:SETPRTY
:16R:SETPRTY
:95R::DEAG/DTCYID/00642
:16S
:SETPRTY
:16R:SETPRTY
:95R::SELL/DTCYID/00642
:16S:SETPRTY
:16R:AMT
:19A::D
EAL//USD84694,
:16S:AMT
:16R:AMT
:19A::SETT//USD84694,
:16S:AMT
:16S:SETDET
-}
Please help me how to seperate the messages and send the messages through MQ series.
Thanks
Rajani
MQ series to send messages
Moderators: chulett, rschirm, roy
MQ series to send messages
---Raj
SWIFT can be a bear...if it were me I'd try to use MapStage, assuming that WebSphere TX is available at the account. WebSphere TX (former DataStage TX and before that the Mercator offering), comes with built in meta data maps (called Type Trees) that are out-of-the-box aware of all the SWIFT formats. MapStage lets you invoke a TX map from within DS....it's especially good when you have a Source that you want to bring into DS to do standard transforms on and send to a DS target.......
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
eostic wrote:SWIFT can be a bear...if it were me I'd try to use MapStage, assuming that WebSphere TX is available at the account. WebSphere TX (former DataStage TX and before that the Mercator offering), comes with built in meta data maps (called Type Trees) that are out-of-the-box aware of all the SWIFT formats. MapStage lets you invoke a TX map from within DS....it's especially good when you have a Source that you want to bring into DS to do standard transforms on and send to a DS target.......
Ernie
Hi Ernie;
I dont have Mercator in my clients place. So can you please suggest me any other alternative?
---Raj
Unless someone has already done it, the only other solution would be to challenge reading that swift format directly....either with some combination of sequential stage with buildOp or JavaPack, or writing your own custom operator, or perhaps even resorting to Server side and using UV/Basic, which has some great string handling capabilities, to dive into it and parse it out...
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>