Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
UNRECOGNIZED DATA TYPE CODE OF 452

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Thu Apr 02, 2015 1:37 pm    Post subject: UNRECOGNIZED DATA TYPE CODE OF 452
Reply with quote

Hi,

I am getting an error while executing a dynamic sql program using SQLDA. The message is
Code:
DSNT496I UNRECOGNIZED DATA TYPE CODE OF  00000452
DSNT495I SUCCESSFUL SELECT 00000000 ROWS OF TABLE EMPLOYEE


The datatype for code +452 is chartype. It is defined in the working-storage section of the program.
I am not able to find the solution for this error, looked in manual, internet and forums. In the manual it is mentioned that this error may occur for this type of application program. But no remedy is given.
Can anyone please help me to resolve the error.

Regards
Raghunathan
Back to top
View user's profile Send private message

chandan.inst

Active User


Joined: 03 Nov 2005
Posts: 269
Location: Mumbai

PostPosted: Thu Apr 02, 2015 2:31 pm    Post subject:
Reply with quote

Hi,

Can you please your query and code , so that people here will understand what you are doing exactly?

Regards,
Chandan
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1747
Location: NY,USA

PostPosted: Fri Apr 03, 2015 5:30 am    Post subject:
Reply with quote

I think you should take a look here.
http://www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_11.0.0/com.ibm.db2z11.doc.apsg/src/tpc/db2z_samplecoboldynamicsql.dita
http://www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_10.0.0/com.ibm.db2z10.doc.msgs/src/tpc/dsnt496i.dita

also,

Quote:
If any of the columns in the problem source table were ALTERed on,
make sure a REORG has been done image copy of it.
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 193
Location: chennai

PostPosted: Fri Apr 03, 2015 4:05 pm    Post subject: Reply to: UNRECOGNIZED DATA TYPE CODE OF 452
Reply with quote

Hi all,

In my post, I have mentioned a statement "UNRECOGNIZED DATA TYPE CODE OF 452" is from my program only. Sorry for the mistake from my side.
I have rectified by problem by correcting my program.
Thanks for all for the hint and comment.

Regards
Raghuanthan
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1747
Location: NY,USA

PostPosted: Mon Apr 06, 2015 8:42 pm    Post subject:
Reply with quote

Quote:
In my post, I have mentioned a statement "UNRECOGNIZED DATA TYPE CODE OF 452" is from my program only. Sorry for the mistake from my side.

Is this a fix?
if not
then it would be helpful for others as well if you post your corrections.
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 FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 6 Wed Aug 23, 2017 9:59 pm
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us