Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CLOB in Cobol
- Thread starter MarcLodge
- Start date
- Thread starter
- #2
- Thread starter
- #3
Alas, the problem I was attempting to resolve still exists.....
I have a DB2 table with a CLOB column. When I insert to this column, the data is truncated. I've used CLOBs and CLOB locators all to no avail. The data gets truncated at around 3500 bytes, but the size of the CLOB is 200,000 bytes. The table page size is 32K so there doesn't seem to be any reason for this truncation.
I'd still be happy to see anybody else's code of an insert to a CLOB column, and also hear of any similar troubles that people may have had with this data type.
FYI, I am posting in the Cobol forum also.
Regards,
Marc
I have a DB2 table with a CLOB column. When I insert to this column, the data is truncated. I've used CLOBs and CLOB locators all to no avail. The data gets truncated at around 3500 bytes, but the size of the CLOB is 200,000 bytes. The table page size is 32K so there doesn't seem to be any reason for this truncation.
I'd still be happy to see anybody else's code of an insert to a CLOB column, and also hear of any similar troubles that people may have had with this data type.
FYI, I am posting in the Cobol forum also.
Regards,
Marc
fredericofonseca
IS-IT--Management
Operating system and version, and COBOL vendor and version please.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
Regards
Frederico Fonseca
SysSoft Integrated Ltd
- Thread starter
- #5
fredericofonseca
IS-IT--Management
ok. ill be back to work on monday. ill try it.
can you send me the cobol program you are using, along with compile options?
also cobol version please. too many available on mainframe.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
can you send me the cobol program you are using, along with compile options?
also cobol version please. too many available on mainframe.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
fredericofonseca
IS-IT--Management
forgot.
email is frederico_fonseca at domain_below
Regards
Frederico Fonseca
SysSoft Integrated Ltd
email is frederico_fonseca at domain_below
Regards
Frederico Fonseca
SysSoft Integrated Ltd
- Thread starter
- #8
I'll close this thread as I don't think it's a strict Cobol or a DB2 issue, more a developer error.
Frederico asked me for a copy of the program, so I cut down and tidied up the original just leaving the insert so that I could send it to him. As I then had a version of the program that just did the insert I compiled and ran it. And it worked fine!
I'm going to either pass the program back to the original developer in order to debug or do it myself.
Many thanks for your help.
Frederico, I won't waste your time sending you the listing, as the listing I was going to send works! Thanks for your help though.
Marc
Frederico asked me for a copy of the program, so I cut down and tidied up the original just leaving the insert so that I could send it to him. As I then had a version of the program that just did the insert I compiled and ran it. And it worked fine!
I'm going to either pass the program back to the original developer in order to debug or do it myself.
Many thanks for your help.
Frederico, I won't waste your time sending you the listing, as the listing I was going to send works! Thanks for your help though.
Marc
fredericofonseca
IS-IT--Management
- Status