View previous topic :: View next topic
|
Author |
Message |
madmartinsonxx
New User
Joined: 10 Dec 2010 Posts: 96 Location: Massachusetts
|
|
|
|
Code: |
UNLOAD
DELIMITED COLDEL '|'
UNLDDN(SYSREC02)
PUNCHDDN(SYSFMT02)
TABLESPACE(DAAVEND.SVEND07)
FROM TABLE(DAAVEND.PAYEE)
(LEGACY_VEND_NR, CONSTANT 'P',
ACH_ROUTING, ACCT_NR, TAX_CODE, TAX_DATE)
SHRLEVEL(CHANGE)
ISOLATION(CS) |
i do the above and i get this error. looks correct to me :
Code: |
DSNU005I 017 12:20:12.42 DSNUGPRS - UNLOAD
DSNU005I 017 12:20:12.42 DSNUGPRS - DELIMITED COLDEL '|'
DSNU005I 017 12:20:12.42 DSNUGPRS - UNLDDN(SYSREC02)
DSNU005I 017 12:20:12.42 DSNUGPRS - PUNCHDDN(SYSFMT02)
DSNU005I 017 12:20:12.42 DSNUGPRS - TABLESPACE(DAAVEND.SVEND07)
DSNU005I 017 12:20:12.42 DSNUGPRS - FROM TABLE(DAAVEND.PAYEE)
DSNU005I 017 12:20:12.42 DSNUGPRS - (LEGACY_VEND_NR, CONSTANT "P",
DSNU082I 017 12:20:12.42 DSNUGPRS - INVALID KEYWORD - 'P'
DSNU005I 017 12:20:12.42 DSNUGPRS - ACH_ROUTING, ACCT_NR, TAX_CODE,
DSNU005I 017 12:20:12.42 DSNUGPRS - SHRLEVEL(CHANGE) |
thank you in advance. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
in this case I tend to trust DB2 judgement more than Yours!
what does the manual say about the message ? |
|
Back to top |
|
|
singhju
New User
Joined: 01 Dec 2010 Posts: 25 Location: Gurgaon
|
|
|
|
Below is the information about the message in manual:
Code: |
DSNU082I csect-name INVALID KEYWORD kkkkkkkk
Explanation:
The given keyword was not recognized within the context of this control
statement.
System Action:
Utility processing is not initiated.
User Response:
Correct the keyword, and resubmit the job.
Severity:
8 (error)
|
But I am not able to figure out the exact reason. |
|
Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
You have omitted a field_name in front of the CONSTANT keyword, that probably triggered the error message.
Reference the DB2 Utilities manual for FROM TABLE elements syntax. |
|
Back to top |
|
|
|