RE: SQL RPAD

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Thanks John.


Hi Vern, see this link http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_bif_rpad.htm

Maybe you can tell me what product I should be looking at for SQL on the i5?
Thanks.


-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Vern Hamberg
Envoyé : mardi 6 janvier 2009 15:27
À : Midrange Systems Technical Discussion
Objet : Re: SQL RPAD

What database product is using this syntax?

David FOXWELL wrote:
> Hi,
>
> How do I write this or its equivalent for my i5?
>
> INSERT INTO t_test VALUES (2,rpad('*',32000,'*'))
>
> Thanks.
--
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.