Re: SQL encryption v5r4 error

On 27 Apr 2012 12:32, Stone, Joel wrote:

How do you guys know all this stuff?? Very impressive.

I found several articles on Iseries SQL encryption, but nothing
about "for bit data".

I have Conte's SQL/400 book and also Howard Arners - nothing about
this (probably because ENCRYPT wasn't supported when published no
doubt).

The Iseries SQL error description didn't help much.

I feel like I should be paying tuition on this list!!

When BookMgr documents were available, I often had a book open for the function\feature I was working with. After great improvements were made to InfoCenter, I finally move there. I am rarely ever able to recall the specific rules for arguments in SQL scalar functions, so for that I consult the docs for almost every function I would not use "every day". Even with those functions I use pervasively, there are nuances that I need to [or at least should] review. For example, SUBSTR() seems simple enough, but unless I am only working with SBCS EBCDIC, I visit the docs to know what are the caveats or alternatives.

Since I will surely never memorize the rules for bounds allocation for encrypted data, I always have to look those up; different for whether a HINT is coded versus not. Thus, knowing that a 20-byte CHAR needs to have a 40-byte CHAR FOR BIT DATA is from looking that up in the docs, not from memory; albeit an SQL FUNCTION to ask for the answer would be pretty nice, but then I would have to recall that function name too ;-)

Regards, Chuck