Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Data security erase on RAID device steve-myers All Other Mainframe Topics 0 Sat Jan 13, 2018 6:41 am
No new posts COB2 file processing rizwanaccy COBOL Programming 8 Tue Jan 02, 2018 1:00 pm
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
No new posts Append the milliseconds to the data s... girishb2 DFSORT/ICETOOL 1 Thu Dec 21, 2017 9:07 pm
No new posts Preserve order in Input File pshongal DFSORT/ICETOOL 13 Thu Dec 21, 2017 4:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us