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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm


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