Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

TechTip: V5R3's New SQL BIFs, Part 3

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • TechTip: V5R3's New SQL BIFs, Part 3

    ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
    This is a discussion about TechTip: V5R3's New SQL BIFs, Part 3.

    Click here for the article.


  • #2
    TechTip: V5R3's New SQL BIFs, Part 3

    ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
    When I try the examples from this article, I get the token not valid message when using the pipe. What am I missing? Kyle

    Comment


    • #3
      TechTip: V5R3's New SQL BIFs, Part 3

      ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
      When using the concatenation pipe symbol, you will need 2 of them with no spaces separating them ¦¦

      Comment


      • #4
        TechTip: V5R3's New SQL BIFs, Part 3

        ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
        Thanks but I did have two. See SQL statement below. select dayname(current date) ¦¦ ', ' ¦¦ monthname(current date) ¦¦ ' ' ¦¦ day(current date) ¦¦ ', ' ¦¦ year(current date) as LongDate from sysibm/sysdummy1 And this is the error. Token ¦ was not valid. Valid tokens: + - AS . Kyle

        Comment


        • #5
          TechTip: V5R3's New SQL BIFs, Part 3

          ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
          Kyle, I copied your code into STRSQL and I get the same error as you. I then replace your concatenation character with the concatenation character on my keyboard and it works fine. The problem is with your keyboard or with your keyboard mapping. Jay

          Comment


          • #6
            TechTip: V5R3's New SQL BIFs, Part 3

            ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
            Thanks but I did have two. See SQL statement below. select dayname(current date) ¦¦ ', ' ¦¦ monthname(current date) ¦¦ ' ' ¦¦ day(current date) ¦¦ ', ' ¦¦ year(current date) as LongDate from sysibm/sysdummy1 And this is the error. Token ¦ was not valid. Valid tokens: + - AS . Kyle

            Comment


            • #7
              TechTip: V5R3's New SQL BIFs, Part 3

              ** This thread discusses the article: TechTip: V5R3's New SQL BIFs, Part 3 **
              Thanks! The keyboard mapping was a little whacked. That took care of the problem. Kyle

              Comment

              Working...
              X