Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Using IMS Connect with different record layouts

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Jan 31, 2012 10:52 pm    Post subject: Using IMS Connect with different record layouts
Reply with quote

Our JAVA folks are using WebSphere. We are trying to get an interface up and running. Most of the existing interfaces use a single record layout, like "give me the current balance for customer 99", and they get back "Balance is $100."

This time there are many different layouts, in a hierarchical format:
ACCOUNT
--CUSTOMER 1
----TRANSACTION 1 A
----TRANSACTION 1 B
--CUSTOMER 2
----TRANSACTION 2 A
----TRANSACTION 2 B

Now, there can be a varying number of CUSTOMERs and TRANSACTIONs. There can be NO transactions.

What I'm hearing today is that we'll need to create a single copybook:
Code:

01 ACCOUNT
    05 CUSTOMER-COUNT PIC 9(5).
    05 TRANSACTION-COUNT PIC 9(5).
    05 CUSTOMER-RECORD OCCURS DEPENDING ON CUSTOMER-COUNT.
        10 ACCOUNT-KEY  PIC X(10).   
        10 CUSTOMER-NAME PIC X(15).
    05 TRANSACTION-RECORD OCCURS DEPENDING ON TRANSACTION-COUNT.
        10 CUSTOMER-KEY PIC X(10).
        10 TRANSACTION-INFO PIC X(15).


So we'll have to separately table each record type so we have a count, then set up the variable length copybook and send it in a single ISRT to the IO-PCB.

This would allow the JAVA folks to use the "wizard" to build JAVA objects for the reply message. They will then take that info and convert it to XML.

I think this is weird. We are taking a hierarchy, flattening it out to transport it, then converting back to a hierarchy.

Is there a better way to handle this using IMS Connect and WebSphere?
Back to top
View user's profile Send private message

Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Jan 31, 2012 10:55 pm    Post subject:
Reply with quote

Follow up.

We can also send XML straight out of our IMS program. It's new, so there wouldn't be a lot of extra effort to do it.

The question then would be, can you grab that in JAVA using the WebSphere tools?

I'd want to send each record as a separate ISRT to the IO-PCB, allowing for the levels by sending the closing tags as needed.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Using 'parm' to vary SORTOUT record v... Sysaron DFSORT/ICETOOL 13 Wed Sep 07, 2016 9:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us