Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 - CHAR9 is not accepted by IBM Supplied Programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 36
Location: india

PostPosted: Tue Mar 10, 2020 8:03 pm    Post subject: DB2 - CHAR9 is not accepted by IBM Supplied Programs
Reply with quote

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

As per IBM advice,

https://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: 36
Location: india

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

In addition ,

Application compatiility is set as V10R1
and CHAR9 related error is not expected as per below IBM documentation
https://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: 1206
Location: Bangalore,India

PostPosted: Thu Mar 12, 2020 2:08 pm    Post subject:
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: 36
Location: india

PostPosted: Thu Mar 12, 2020 9:28 pm    Post subject: Reply to: DB2 - CHAR9 is not accepted by IBM Supplied Programs
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: 36
Location: india

PostPosted: Tue Apr 28, 2020 1:41 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts pointers on using USS and C programs. Pedro All Other Mainframe Topics 0 Wed Oct 04, 2017 4:38 am
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us