Re: SQL ENCRYPT_RC2() function Question

[Mike <koldark@xxxxxxxxx>]

The VARLEN did it! Thank guys... now to figure out how to make a function...

On Dec 3, 2007 11:40 PM, CRPence <crp@xxxxxxxxxxxxxxxxxxxx> wrote:

>   To use VARCHAR instead of CHAR to better enable the trigger, an
> example declaration for DDS, to match FOR BIT DATA in SQL:
>
>                 R ACCOUNTR
>                   ACCOUNT       32H         VARLEN(32)
>
> Regards, Chuck
> --
>  All comments provided "as is" with no warranties of any kind
> whatsoever and may not represent positions, strategies, nor views of my
> employer
>
> Mike wrote:
> > How do you do that in DDS? I would prefer to keep it DDS if possible.
> Not
> > that I am against SQL...
> >
> > Elvis wrote:
> > > Try declaring ACCOUNT as VARCHAR FOR BIT DATA as that is the return
> type
> > > from ENCRYPT_RC2 function.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.