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
 

 

How to link telon IMS/DC and DB2 ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
amar_modi

New User


Joined: 10 Apr 2007
Posts: 1
Location: australia

PostPosted: Wed Apr 18, 2007 7:44 am    Post subject: How to link telon IMS/DC and DB2 ?
Reply with quote

Hi All,

I am new to Telon and IMS DC. Now I need to work on Telon, IMS DC and DB@.
My requirement is through screens program should get input and based on that it should update or retrieve information from DB2. I could see screen in Telon using panel specification option in Telon.

Please let me know what are the steps I need to do to accomplish this.

Thanks,
Amar.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Apr 18, 2007 10:24 am    Post subject: Re: How to link telon IMS/DC and DB2 ?
Reply with quote

Just puzzled!

for what kind of "pick a derogative term" organization do You work, which does not care to give You such basic training ????

regards

P.S.
I do not mind very beginners questions for COBOL, somebody might try to learn by themselves ;
TELON .. no, You can' t do it, You need an organization to back You up
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Fri Apr 27, 2007 12:48 pm    Post subject:
Reply with quote

Hi,

After painting screen in the Panel definition and also completing the field name and usage as Input or output or Inputoutput.

Go to data group(DG) where u can write your sql quires as

1) First insert a table in the data group using the command as DGADD tablename.D2 (you will get a message as Data group successfully updated)
2) then use a line command insert I against the created table and use either Read or update. After giving the Read write a select query by giving U against the READ.
3) After writing the query u will get the name as U-100-READ-Tablename.


Go to Custum code and create a oinit1 section.

So perform the section U-100-READ-tablename or U-100-UPDATE-tablename depending on the input from the screen.

After perform the above sections check code as

IF input filed Not = spaces
Perform U-100-READ-tablename
IF DA-OK
PERFORM U-100-UPDATE-TABLENAME
IF DA-OK
SET SUCCESSFUL-UPDATE TO TRUE
ELSE
ABEND THE PROGRAM USING ABEND SECTIONJ
END-IF
END-IF
END-IF

I cann't explain more than this through forum.

Hope this will help you some extent

Cheers
Ashwin
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Fri Apr 27, 2007 3:12 pm    Post subject:
Reply with quote

Hi,

Read the documents on Telon posted by some members. If you need any clarifications you are always welcome.

http://ibmmainframes.com/viewtopic.php?t=16395&highlight=telon

Cheers
Ashwin
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts compile and link program in 6.1 brigitte pruett COBOL Programming 3 Tue Aug 16, 2016 12:09 am
No new posts Event-driven programming (BTS) VS (ST... Rohit Umarjikar CICS 2 Sat Jun 11, 2016 2:05 am
No new posts LINK Call srajendran2 CICS 2 Fri Apr 22, 2016 1:35 am
No new posts Replacing Start Transid with LINK pkmurali CICS 12 Tue Apr 19, 2016 8:22 pm
No new posts Invoking a CICS program through LINK P Srinivasan CICS 10 Mon Apr 18, 2016 8:55 am


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