MVSFORUMS.com

cxvxbx · Posted: Fri Dec 14, 2007 1:49 am Post subject: DB2 - using NEWFUN(YES)

I am working on a new database and the DBA has created a table with column name exceeding 18 bytes. This is causing compilation errors. I got to know that using the NEWFUN(YES) option could be a way to eliminate this error.

i am using endevor for compilation and tried to override it using "CBL NEWFUN(YES)" which isnt working - i guess the syntax for override is incorrect.

with regards to the above information, can someone help me with answers to the following questions ?

1. What can i do to compile my program when the DB2 column names are greater than 18 bytes long?
2. How can i override the DB2 precompiler options while using endevor for compilation?

TIA.

jsharon1248 · Posted: Fri Dec 14, 2007 9:57 am Post subject:

The syntax should look like this:

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Converting your DB2 precompilation to NEWFUN(YES) has many implications. One major catch is that the generated DRMS are in Unicode and not in EBCDIC any more. This could have huge impacts, if your installation has administrative functions working that scan DBRM text.

Overriding this parameter for just some modules could produce damage in other areas. If DBAs use functionality of DB2 V8, THEY should assure (with your ENDEVOR administrators) that your programs could use these features.

regards
Christian

cxvxbx · Posted: Tue Dec 18, 2007 11:32 pm Post subject:

Thanks for the response.

I had the DBA modify the column names.