Datacom

  • 1.  DQL 80 byte literal in WITH or SET

    Posted Mar 02, 2018 02:48 PM

    Can a character literal value in FIND or UPDATE SET commands be 80 characters?  If so, how do I specify the literal with the apostrophes, when the DQRY screen is only 80 columns wide?  A developer wants to be able to change the last 2 bytes in an 80-byte field.  Is there a way to use two lines for the literal, or to concatenate two literals to fill the full 80 columns?



  • 2.  Re: DQL 80 byte literal in WITH or SET

    Broadcom Employee
    Posted Mar 05, 2018 04:25 AM

    Hi Steve, 

     

    In DQL mode the largest you can have is 78 actual characters plus starting and ending quotes (').

    There is no continuation possible to the next line.  It is in SQL mode.

    Regards, Karina.