View previous topic :: View next topic
|
Author |
Message |
julian123
New User
Joined: 14 Aug 2006 Posts: 25
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Please try
Code: |
SET ENCRYPTION PASSWORD = 'PASSWORD' |
|
|
Back to top |
|
|
julian123
New User
Joined: 14 Aug 2006 Posts: 25
|
|
|
|
Yes, Srihari, I tried it, but got the same error massage. |
|
Back to top |
|
|
ulfnsc
New User
Joined: 15 Jan 2004 Posts: 19 Location: Stockholm, SWEDEN
|
|
|
|
Hi Srihari.
Are you on DB2 v8?
/uffe |
|
Back to top |
|
|
julian123
New User
Joined: 14 Aug 2006 Posts: 25
|
|
|
|
yes, db2 v8 |
|
Back to top |
|
|
julian123
New User
Joined: 14 Aug 2006 Posts: 25
|
|
|
|
it's ok now.
thank you for your reminding, ulfnsc.
I used a wrong compile jcl. :'( |
|
Back to top |
|
|
|