MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQL Pre-compiler

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
nivedita
Beginner


Joined: 04 Nov 2003
Posts: 22
Topics: 15

PostPosted: Mon Feb 23, 2004 4:27 am    Post subject: SQL Pre-compiler Reply with quote

I am getting some error messages while compiling a C++-DB2 code, Its a warning message which is as below.

DSNH526I W DSNHOPTS DSNHDECP SPECIFIES AN UNDEFINED (0) VALUE FOR "ASCCSID".. NOTIFY THE SYSTEM PROGRAMMER
DSNH527I W DSNHOPTS THE PRECOMPILER IS USING THE DB2-SUPPLIED DSNHDECP MODULE. THIS MODULE WILL BE ELIMINATED BY FUTURE VERSI
ON OF DB2. NOTIFY THE SYSTEM PROGRAMMER
DSNH050I I DSNHMAIN WARNINGS HAVE BEEN SUPPRESSED DUE TO LACK OF TABLE DECLARATIONS


I would like to know the following:

1. Can you please clarify whether this is due to any version conflict of the pre-compiler.

2 . Further please clarify is there any impact upon the application being compiled with this pre-compiler.

Regards,
Back to top
View user's profile Send private message
Anovice
Beginner


Joined: 18 Feb 2004
Posts: 12
Topics: 2

PostPosted: Thu Feb 26, 2004 4:28 am    Post subject: Reply with quote

Nivedita,
Second warning - It only says that a program may no tbe available in later versions of DB2. It may not affect your pre compilation as of now.

Firts warning - Are you using Star SQL as the ODBC driver. It looks that you have to specify a correct parm for the ascii. Since in MVS the data is stored in EBCDIC and while it is retrieved on a PC it shoul dbe in ASCII one needs to specify this parameter with the appropriate ascii code.
Have a look at the following for more details
http://www-306.ibm.com/software/data/db2/os390/techdocs2/ccunicode.pdf
Back to top
View user's profile Send private message
JOHNCWL
Beginner


Joined: 25 Feb 2004
Posts: 31
Topics: 16

PostPosted: Thu Feb 26, 2004 5:36 am    Post subject: Reply with quote

Thanks!! yes it was problem with ASCII and EBCIDC
Back to top
View user's profile Send private message
JOHNCWL
Beginner


Joined: 25 Feb 2004
Posts: 31
Topics: 16

PostPosted: Thu Feb 26, 2004 9:04 am    Post subject: Reply with quote

even I was also getting this problem and I neglected this .
Thanks Nivedita for posting this question and also thanks Anovice for getting me out of this prob.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group