read and display data from IMS DB.



IBM's hierarchical database management system with a Database Manager (IMS DB) and a Transaction Manager(IMS DC)

read and display data from IMS DB.

Postby divya_sharma » Thu May 28, 2015 11:13 pm

Hi,

I am working in mainframe testing for a banking project. I have a requirement where i have to find accounts in my database.
Below is a JCL that we normally use for updating something in our IMSDB but now i need only the accounts to be displayed ..can someone please help me with that?

//WBYSECOM JOB(21765,UNKN),'BTS', CLASS=7,LINES=99999,SCHENV=DET1,MSGCLASS=T
//PROCS JCLLIB ORDER=(WBYSTE.SHOT2.JOBPDS,
                                      SOME OTHER LIBRARIES)
//INCLUDE MEMBER=JOBLIB
//S01DADJ EXEC IMSBATCH, MBR = KGPXDAP0,PSB=KGZXDAPE,NBA=30,OBA=25
//SMFCIVE DD DUMMY
//DDPRT01W DD SYSOUT=*
//DDSEQ01W DD SYSOUT=*
//DDRDR01R DD *
RUN UPDATE
DBID BASE
GU SGNPBRT0(FGNBRKE0EQHEX'MY KEY')
GHNP SGNPBDY0
DATA SGNPBDY0  00022  002  X  A35B
REPL SGNPBDY0
SYNC
*

coded
divya_sharma
 
Posts: 2
Joined: Wed Jun 25, 2014 9:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: read and display data from IMS DB.

 

Re: read and display data from IMS DB.

Postby NicC » Fri May 29, 2015 3:05 am

As you only show that the job executes a procedure and you do not show what program(s) that procedure executes we have no dea as to what control cards should be used. If that is an in-house utility then no one out in the rest of the world will be able to help you. You should have documentation for that program available to you so use it and use your IMS support people.

Also, in future, please use the code tags to present data and code in your posts.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2999
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to IMS DB/DC

 


  • Related topics
    Replies
    Views
    Last post