Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: how to use this command -- 'set encryption password'
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    Post subject:
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    Post subject:
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    Post subject: Reply to: how to use this command -- 'set encryption passwor
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
No new posts SDSF Command Avtrix CLIST & REXX 4 Fri Sep 30, 2016 11:13 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us