I have find the error,that because my EXEC not begin with 'A' area,I wander Why it did not give me a error about that?butonly told told failed to declare?Anything wrong?
Display Filter View Print Options Help
-------------------------------------------------------------------------------
SDSF OUTPUT DISPLAY RASCECMP JOB12194 DSID 102 LINE 143 COLUMNS 02- 81
COMMAND INPUT ===> SCROLL ===> CSR
120 .
121 STOP RUN.
122 0000-EXIT. EXIT.
123
124 ************************************************************
DB2 SQL PRECOMPILER MESSAGES
DSNH504I E DSNHSMUD LINE 67 COL 22 CURSOR "GET-ACC-LINK" WAS NOT DECLARED
DSNH312I E DSNHSMUD LINE 73 COL 23 UNDEFINED OR UNUSABLE HOST VARIABLE "RFA
DSNH521I W DSNHSM3 LINE 72 COL 16 THE FETCH FOR CURSOR "GET-ACC-LINK" IS A
NT
DB2 SQL PRECOMPILER STATISTICS
SOURCE STATISTICS
SOURCE LINES READ: 124
NUMBER OF SYMBOLS: 16
SYMBOL TABLE BYTES EXCLUDING ATTRIBUTES: 2000
THERE WERE 3 MESSAGES FOR THIS PROGRAM.
THERE WERE 0 MESSAGES SUPPRESSED BY THE FLAG OPTION.
165256 BYTES OF STORAGE WERE USED BY THE PRECOMPILER.
RETURN CODE IS 8
******************************** BOTTOM OF DATA ********************************
It do not give the message that I violate the rule.
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Jun 22, 2006 7:21 am Post subject:
issac1029,
The pre-compiler only performs syntax checking of the SQL and replaces with approriate call statements. The precompiler does not validate the names of tables and columns that are used in SQL statements.
You need to code your SQL statements starts from COL 12.
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
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
