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
 

 

Write a pgm in cobol to retrive the DB2 records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Hemant B.

New User


Joined: 05 Oct 2006
Posts: 8

PostPosted: Fri Oct 06, 2006 4:43 pm    Post subject: Write a pgm in cobol to retrive the DB2 records
Reply with quote

if i enter a record in db2 table from spufi.
then i write a pgm in cobol to retrive that record.
i complied that pgm but yet not run it..
before run i delete that records from spufi.
now i am going to RUN that pgm...will i get that record or not...
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Oct 06, 2006 4:50 pm    Post subject:
Reply with quote

Hi Hemant,

If u commited after delete then u wont get the record.
Back to top
View user's profile Send private message
Hemant B.

New User


Joined: 05 Oct 2006
Posts: 8

PostPosted: Fri Oct 06, 2006 5:07 pm    Post subject: thanx
Reply with quote

thanx Ekta
for a quick reply.

u mean
complie pgm means we create load file ...
run that load file giving different I/P.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Oct 06, 2006 5:10 pm    Post subject:
Reply with quote

I mean if u delete the record & commited the db2 d/b then after u run the pgm then the pgm will not be able to find that record *
Back to top
View user's profile Send private message
Hemant B.

New User


Joined: 05 Oct 2006
Posts: 8

PostPosted: Fri Oct 06, 2006 5:23 pm    Post subject:
Reply with quote

ok,
thanx Ekta.

be in touch always..........
nice..
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Write R1 and R2 to OP1 and R1 to OP2 bhaskar_kanteti DFSORT/ICETOOL 10 Fri Mar 03, 2017 11:18 am
No new posts Can you write 2 recs on SORTOUT when ... Sysaron DFSORT/ICETOOL 6 Thu Feb 23, 2017 12:07 am


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