MQ series to send messages

rajanikc · Post by **rajanikc** » Wed Apr 09, 2008 9:27 am

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

eostic · Post by **eostic** » Wed Apr 09, 2008 10:20 am

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

rajanikc · Post by **rajanikc** » Wed Apr 09, 2008 10:27 am

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?

eostic · Post by **eostic** » Wed Apr 09, 2008 11:11 am

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