IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Using IMS Connect with different record layouts


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Connect Direct 6.3 for Z/OS All Other Mainframe Topics 20
Search our Forums:

Back to Top