Re: Why you shouldn't be afraid to use VARCHAR in RPGLE
Brian Parkins <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
But W_ADDRESS1 will still be CHAR(200), won't it? Perhaps I am misunderstanding - I thought Doug wanted W_ADDRESS1 to be VARCHAR(200) without the need to hardcode the "200". I don't think it can be done. Brian. On 05/12/2025 23:08, Charles Wilt wrote: > LIKE should pick up the both the type and size... > > dcl-s w_address1 like(phaddress1); > > note: %len() on a varchar is always the length of the current value. The > max size is retrieved using %size(). > > HTH, > Charles > > On Fri, Dec 5, 2025 at 3:28 PM DEnglander--- via RPG400-L < > [email protected]> wrote: > >> Does anyone know how to do something like this: >> >> I would like to define a %TRIMmed disk field that is CHAR(200) >> [PHADDRESS1] as a VARCHAR and eliminate the %TRIMs. >> >> So as not to hardcode the size of the VARCHAR, can I define it as VARCHAR >> but based on the length of the CHAR(200) field? Something like: >> >> dcl-s w_address1 varchar(%len(phaddress1)); >> >> >> Can that be done? >> >> Thank you, >> >> Doug >> >> >> >> "CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments >> accompanying it) contain confidential information belonging to the sender. >> The information is intended only for the use of the intended recipient. If >> you are not the intended recipient, you are hereby notified that any >> disclosure, copying, distribution or the taking of any action in reliance >> on the contents of the information is strictly prohibited. Any >> unauthorized interception of this transmission is illegal under the law. >> If you have received this transmission in error, please promptly notify the >> sender by reply e-mail, and then destroy all copies of the transmission." >> -- >> This is the RPG programming on IBM i (RPG400-L) mailing list >> To post a message email: [email protected] >> To subscribe, unsubscribe, or change list options, >> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l >> or email: [email protected] >> Before posting, please take a moment to review the archives >> at https://archive.midrange.com/rpg400-l. >> >> Please contact [email protected] for any subscription related >> questions. >> >> -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions.