Re: Censoring SQL access -- ideas?

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

On 3/17/2011 7:39 AM, rob@xxxxxxxxx wrote:
> CREATE UNIQUE INDEX ROB/rcoi01
> ON ROB/RCO (CMPNY)
> where crsts='A'
> RCDFMT RCOI01R
>    ADD CMPNAM,CAGD1
>
> Doesn't that cover a vast bulk of the LF's that you've seen?

Yes it does!  It's amazing.  SQL has nearly caught up to the S/38!  Now 
all they have to do is let me position in a cursor by key, and the 
danged thing will be usable!

;)

Seriously, they're getting very close to being able to replace DDS 
entirely.  The only downside (nitpick is probably a better term) is that 
the RCDFMT/ADD is non-standard, obviously, but that's a moot point since 
it's pretty much addressing an i-specific issue.

Joe