View previous topic :: View next topic
|
Author |
Message |
kumarvis Warnings : 1 New User
Joined: 31 Mar 2007 Posts: 14 Location: Chennai
|
|
|
|
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 |
|
|
kumarvis Warnings : 1 New User
Joined: 31 Mar 2007 Posts: 14 Location: Chennai
|
|
|
|
Hi,
My pgm is going in infinitive loop, how to identify this in spool.
Thanks & Regards,
V.Kishore Kumar |
|
Back to top |
|
|
anand_sundaramurthy
New User
Joined: 07 May 2007 Posts: 12 Location: Chennai
|
|
|
|
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 |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi kumarvis,
Look at the Read statement carefully. U have chance of getting infinite loop only while reading a data file. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|