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
 

 

I am copying the data from the file to table thru pgm

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
kumarvis
Warnings : 1

New User


Joined: 31 Mar 2007
Posts: 14
Location: Chennai

PostPosted: Mon May 07, 2007 10:47 am    Post subject: I am copying the data from the file to table thru pgm
Reply with quote

Hi,
I am copying the data file to table thru pgm. For the cobol variable which is defined in comp-3 variable, how is that in the DB2 field that the corresponding can be defined.
Back to top
View user's profile Send private message

kumarvis
Warnings : 1

New User


Joined: 31 Mar 2007
Posts: 14
Location: Chennai

PostPosted: Mon May 07, 2007 10:48 am    Post subject: My pgm is going in infinitive loop, how to identify?
Reply with quote

Hi,
My pgm is going in infinitive loop, how to identify this in spool.

Thanks & Regards,
V.Kishore Kumar
Back to top
View user's profile Send private message
anand_sundaramurthy

New User


Joined: 07 May 2007
Posts: 12
Location: Chennai

PostPosted: Mon May 07, 2007 12:08 pm    Post subject:
Reply with quote

Hi,
Generally you need not worry about the comp 3 variable.usually if you define any column in the table as a decimal and create a DCLGEN for it then db2 automatically creates a comp 3 variable for the decimal column alone.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Mon May 07, 2007 12:09 pm    Post subject: Re: I am copying the data from the file to table thru pgm
Reply with quote

Check the below links

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzajp/rzajpequivsqlcobol.htm

http://www.ibmmainframes.com/viewtopic.php?t=19682&highlight=infinite+loop

Would appreciate if u can do a google search and forum search before posting queries :-)

Syam
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Mon May 07, 2007 2:03 pm    Post subject: Hi
Reply with quote

Hi kumarvis,

Look at the Read statement carefully. U have chance of getting infinite loop only while reading a data file.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 07, 2007 10:08 pm    Post subject:
Reply with quote

Hello,

I'm not clear on
Quote:
infinitive loop, how to identify this in spool
this - what do you want to identify in the spool?

If you are reading an external/sequential file, it wil eventually reach at end (unless the code closes it, re-opens it, and reads some more). It may be that you are re-reading the same row(s) from a databse table repeatedly. It may be that some code is supposed to execute until some condition is met but the condition is never set (ie. field = some value, a counter reaches n, etc).

Not knowing what is available in your environment, i'd suggest putting a few diagnostic DISPLAY statements in your code and a counter to stop after a few hundred iterations. By adjusting your displays, you can determine where the code is looping.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


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