Re: Stored Procedure and VarChar Content Length

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Dave,

The documentation would be located in the SQL Reference Manual appropiate
to your Release Level (Check IBM's knowledge Center).

For example, my (electronically) dog-eared V5R3 PDF states that:
"The result is the length of the argument. The length of strings includes
blanks. The length of a varying-length string is the actual length, not the
length attribute."

HTH,

Luis


On Thu, Oct 27, 2016 at 1:19 PM <dlclark@xxxxxxxxxxxxxxxx> wrote:

>         I have a stored procedure with a couple of variables defined as
> follows:
>
> Declare Str1      VarChar(3000);
> Declare StrLen    Dec(15,5);
>
>         I then build the value of this variable with several
> concatenations.  How do I then set the second variable to the length of
> the content of the first?  I guessed at it and the following seems to be
> correct.
>
> Set StrLen = Length(Str1);
>
>         But I don't like having to guess.  Where do I find documentation
> on such things?  Thanks.
>
> Sincerely,
>
> Dave Clark
> --
> int.ext: 91078
> direct: (937) 531-6378
> home: (937) 751-3300
>
> Winsupply Group Services
> 3110 Kettering Boulevard
> Dayton, Ohio  45439  USA
> (937) 294-5331
>
>
>
>
> *********************************************************************************************
> This email message and any attachments is for use only by the named
> addressee(s) and may contain confidential, privileged and/or proprietary
> information. If you have received this message in error, please
> immediately notify the sender and delete and destroy the message and all
> copies. All unauthorized direct or indirect use or disclosure of this
> message is strictly prohibited. No right to confidentiality or privilege
> is waived or lost by any error in transmission.
>
> *********************************************************************************************
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.