IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

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: 40
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,

Use [URL] BBCode for Links


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: 40
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
Use [URL] BBCode for Links
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
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: 40
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: 40
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Invoke REXX thru JCL to expand the co... CLIST & REXX 2
No new posts pointers on using USS and C programs. All Other Mainframe Topics 0
No new posts PLI - printing from multiple programs PL/I & Assembler 8
No new posts CICS Transaction attach count of supp... CICS 1
No new posts Why myself doing Package Bind always ... DB2 5

Back to Top