How to link telon IMS/DC and DB2 ?

amar_modi · New User Joined: 10 Apr 2007 Posts: 1 Location: australia

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.

enrico-sorichetti · Posted: Wed Apr 18, 2007 10:24 am

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

ashwinreddy · Posted: Fri Apr 27, 2007 12:48 pm

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

ashwinreddy · Posted: Fri Apr 27, 2007 3:12 pm

Hi,

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

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

Cheers
Ashwin