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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am

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