IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 - CHAR9 is not accepted by IBM Supplied Programs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Tue Mar 10, 2020 8:03 pm
Reply with quote

Hi Team,
Our DB2 subsystem is in V11 NFM mode .BIF_COMPATIBILITY is set as CURRENT now .

As per IBM advice,

www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/inst/src/tpc/db2z_ipf_bifcompatibility.html


We are trying to use CHAR9 instead of CHAR for impacted DB2 objects .While testing for IBM supplied programs like DSNTEP2 ,DSNTEP4,DSNTIAUL and DSNTIAD we were getting error

DSNT408I SQLCODE = -4743, ERROR: ATTEMPT TO USE A FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A
PREVIOUS LEVEL
we are in V11 NFM mode already and wondering what is stopping us to use CHAR9 .

Any thought on this ?
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Tue Mar 10, 2020 8:40 pm
Reply with quote

In addition ,

Application compatiility is set as V10R1
and CHAR9 related error is not expected as per below IBM documentation
www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/apsg/src/tpc/db2z_applcompatv10r1.html
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Thu Mar 12, 2020 2:08 pm
Reply with quote

Hello there,

Could you please share the sql where you have used char9?
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Thu Mar 12, 2020 9:28 pm
Reply with quote

Query is simple like below
SELECT CHAR9(ACCOUNT)
FROM EMPLOYEE
WHERE EMPLOYEE_NR = 12345

Here ACCOUNT is declared as Decimal in table
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Tue Apr 28, 2020 1:41 pm
Reply with quote

After rebind of IBM supplied programs issue is resolved .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts Finding Assembler programs PL/I & Assembler 5
No new posts Recompiling programs after a copybook... COBOL Programming 1
No new posts Can you give me examples of programs ... CLIST & REXX 22
Search our Forums:

Back to Top