IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Unload with CONSTANT operator hiccup


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
madmartinsonxx

New User


Joined: 10 Dec 2010
Posts: 96
Location: Massachusetts

PostPosted: Mon Jan 17, 2011 10:58 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Jan 17, 2011 11:09 pm
Reply with quote

in this case I tend to trust DB2 judgement more than Yours!

what does the manual say about the message ?
Back to top
View user's profile Send private message
singhju

New User


Joined: 01 Dec 2010
Posts: 25
Location: Gurgaon

PostPosted: Tue Jan 18, 2011 11:45 am
Reply with quote

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
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Jan 18, 2011 2:58 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts changing defaults in db2 admin - Unlo... DB2 0
No new posts DB2 Table - Image copy unload IBM Tools 2
Search our Forums:

Back to Top