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

how to use this command -- 'set encryption password'


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

New User


Joined: 14 Aug 2006
Posts: 25

PostPosted: Wed Nov 28, 2007 2:24 pm
Reply with quote

I want to encrypt a field in table, and following is my source.

Code:

EXEC SQL                               
    SET ENCRYPTION PASSWORD 'PASSWORD'
END-EXEC.                             
EXEC SQL                               
    SELECT DECRYPT_CHAR(ACCTNO)       
      INTO :DCLDXXXX.ACTNO           
      FROM DXXXX                       
END-EXEC.                             
DISPLAY ACTNO OF DCLDXXXX.           


I compiled it, but MAXCC=8. This is the massage.
Code:

DSNH104I E     DSNHSM5R LINE 118 COL 20  ILLEGAL SYMBOL "ENCRYPTION". SOME SYMBOOL "ENCRYPTION". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: :
DSNH016I E     DSNHPARS LINE 118 COL 31  "=" REQUIRED                                                                                   
DSNH104I E     DSNHPARS LINE 118 COL 31  ILLEGAL SYMBOL "PASSWORD". SOME SYMBOLSOL "PASSWORD". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: = 


is my source wrong, hope andbody can help, thx a lot.
(I'm sorry for I don't know whether raise this post here is correct, or should be cobol's forum.)
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Nov 28, 2007 3:59 pm
Reply with quote

Please try
Code:
 SET ENCRYPTION PASSWORD = 'PASSWORD'
Back to top
View user's profile Send private message
julian123

New User


Joined: 14 Aug 2006
Posts: 25

PostPosted: Thu Nov 29, 2007 6:51 am
Reply with quote

Yes, Srihari, I tried it, but got the same error massage.
Back to top
View user's profile Send private message
ulfnsc

New User


Joined: 15 Jan 2004
Posts: 19
Location: Stockholm, SWEDEN

PostPosted: Thu Nov 29, 2007 9:58 pm
Reply with quote

Hi Srihari.
Are you on DB2 v8?
/uffe
Back to top
View user's profile Send private message
julian123

New User


Joined: 14 Aug 2006
Posts: 25

PostPosted: Fri Nov 30, 2007 6:42 am
Reply with quote

yes, db2 v8
Back to top
View user's profile Send private message
julian123

New User


Joined: 14 Aug 2006
Posts: 25

PostPosted: Fri Nov 30, 2007 7:07 am
Reply with quote

it's ok now.
thank you for your reminding, ulfnsc.
I used a wrong compile jcl. :'(
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 RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts DTL - how to define key with stacked ... TSO/ISPF 3
No new posts LTJ command CA Products 4
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top