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 Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Connect:Direct - RC=000000FF MSG=SVTM... R.Manivannan All Other Mainframe Topics 3 Fri Apr 21, 2017 1:30 am
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm


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