MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Esql help

Esql help

« View previous topic :: View next topic »

Author

Message

Bravo

Posted: Tue Oct 31, 2006 7:07 pm Post subject: Esql help

Centurion

Joined: 03 Oct 2005
Posts: 146

Hi All,

I am using MB 5 CSD 5.

My input message is CWF and i want to store the data in DB2.I have define a varchar field as 300 bytes.

Input structure and input msg.

Code:

A-RECORD.
F1 PIC X(6);
F2 PIC X(4);
F3 PIC X(2);
F4 PIC X(5);

TEST IN G WBIMB

my esql is

Code:

SET EV = F2 || F3 || F4

and Output is

INGWBIMB

but I want to store F2,F3 & F4 data in varchar field with length X(2),X(4) and X(5) exactly as its defined in CWF.

IN G WBIMB

How can I achieve this.
_________________
Bravo

jbanoop

Posted: Tue Oct 31, 2006 10:22 pm Post subject:

Chevalier

Joined: 17 Sep 2005
Posts: 401
Location: SC

dont tell me u were looking at

SET EV = F2 || ' ' || F3 || ' '|| F4;

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Esql help

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP