Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us