DB2存储过程中如何分割字符串

发布于 2025-01-10 01:35:04 字数 321 浏览 0 评论 0原文

我需要在 DB2 中拆分一个字符串，例如我的字符串是：

2660____,275____,10472316, ...

我需要一个循环来获取所有这些字符串，我知道存储过程 DB2 中存在 FOR，但我不能使用

我写的例如：

FOR i AS mycursor CURSOR FOR SELECT SUBSTR(list, 1, LOCATE(',',list)-1) FROM SYSIBM.SYSDUMMY1 do
    ...
END FOR;

但这并不不工作。

谢谢

原文

I need split a string in DB2, my string is for example:

2660____,275____,10472316, ...

I need a loop to get all of the them, I know exists FOR in stored procedure DB2, But I can't use that

I write that for example:

FOR i AS mycursor CURSOR FOR SELECT SUBSTR(list, 1, LOCATE(',',list)-1) FROM SYSIBM.SYSDUMMY1 do
    ...
END FOR;

But that doesn't work.

thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

a√萤火虫的光℡ 2025-01-17 01:35:04

请按照此处的说明尝试以下操作：

BEGIN
  DECLARE V_VAR VARCHAR (100);

  SET V_VAR = '2660____,275____,10472316';

  FOR C1 AS 
    SELECT TOK.TOKEN
    FROM 
      XMLTABLE
    (
      'for $id in tokenize($s, ",") return <i>{string($id)}</i>' PASSING V_VAR AS "s"
      COLUMNS
        SEQ   FOR ORDINALITY
      , TOKEN VARCHAR(20) PATH '.'
    ) TOK
    ORDER BY TOK.SEQ
  DO
    CALL DBMS_OUTPUT.PUT_LINE (C1.TOKEN);
  END FOR;

END
@

Try the following as specified here:

BEGIN
  DECLARE V_VAR VARCHAR (100);

  SET V_VAR = '2660____,275____,10472316';

  FOR C1 AS 
    SELECT TOK.TOKEN
    FROM 
      XMLTABLE
    (
      'for $id in tokenize($s, ",") return <i>{string($id)}</i>' PASSING V_VAR AS "s"
      COLUMNS
        SEQ   FOR ORDINALITY
      , TOKEN VARCHAR(20) PATH '.'
    ) TOK
    ORDER BY TOK.SEQ
  DO
    CALL DBMS_OUTPUT.PUT_LINE (C1.TOKEN);
  END FOR;

END
@

回复收藏 0 原文

~没有更多了~