We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

DB Execute - Can't Extract Field Called "Comment"

Comments

6 comments

  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    This is most likely a question you'll have to take up with the database vendor.

    1) What type of database is it?
    2) try using the AS keyword just as a test:
    Select Comment as MyText
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: peterr

    Hi,

    The "as" doesn't work. It's an Oracle DB.

    Cheers

    Peter
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: gmullin

    How about doing this?

    select to_char(Comment) as Comment from TABLENAME
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: peterr

    Hi,

    Still no joy:

    WARN: Error executing statement: select to_char(Comment) as Comment

    from RAFLATAC_CDW.REEL_EVENT

    where SOURCE_SYSTEM = 'RAFLOW.SC' and TRANS_PERIOD = '201701'. On connection: RAF_LAVASTORM_CDW@DEVDW
    Line: 12; BrainScript: sqlSelect(1,_sqlQuery1)
    Operator: 'sql-select'
    Error Code: brain.node.OdbcSession.cpp.169
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    One more random thing to try:

    select SUBSTR(Comment, 1, 20) as Comment
    from RAFLATAC_CDW.REEL_EVENT
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: online

    Works fine for me:
    select to_char(Comment) as Comment from TABLENAME
    0
    Comment actions Permalink

Please sign in to leave a comment.