APAR status
Closed as fixed if next.
Error description
Customer reported DSNH007I E DSNHTOKR LINE 140 COL 1 ILLEGAL CHARACTER IGNORED: "."('3F'X) when precompiling a C program with PGM=DSNHPC,PARM='HOST(C),CCSID(1047)' IN R810 but not IN R710
Local fix
The problem seems to crop up when the C source does not contain any SQL statements. And the workaround is add a SQL statement just like 'EXEC SQL COMMIT;' to the C source. This error has also been seen with a PLI program when it contains no SQL statements and ends with a semicolon in column 72. If the semicolon is moved to column 71, or any EXEC SQL statement is added, the error message goes away and a successful precompile occurs.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 for z/OS precompiler for * * the C or C++ host language. 810 910 * **************************************************************** * PROBLEM DESCRIPTION: Invalid MSGDSNH007I error messages may * * be issued by the DB2 for z/OS * * precompiler with HOST(C) or HOST(CPP) * * when the program source does not * * contain any SQL statements. * **************************************************************** * RECOMMENDATION: * **************************************************************** Here is an example of the error message issued by the precompiler: DSNH007I E DSNHTOKR LINE 5 COL 1 ILLEGAL CHARACTER IGNORED: "`" ('3F'X) The message is not issued in all cases, and is not issued if there is at least one SQL statement in the source program, even if the SQL statement is simply EXEC SQL INCLUDE SQLCA; Addtitional keywords: MSGDSNH007I
Problem conclusion
Temporary fix
Comments
The fix for this problem will be deferred to the DB2 for z/OS release following 9.1. The defect number to fix the problem is pk95247.
APAR Information
APAR number
PK95247
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-01
Closed date
2009-09-09
Last modified date
2009-10-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
16 October 2009