Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Posts
    56

    Unanswered: DBMS_output.put_line EQUIVALENT

    Hello All again

    I would like to know What is the equivalent for DBMS_output.put_line which is in oracle so what is it in DB2

    Thanks

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Wait for Cobra release...
    for time being have a look on this article
    A UDF for File Output and Debugging from SQL
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Sep 2007
    Posts
    56

    NEED A SOlution

    Hello,

    can somebody let me know how to do this, I have a variable xxHrs variable with hours and on integer without minutes, and another variable XXmin what i would like to do is to convert the above two fields into hh:mm , How to do this and is there a data type which can store such time format.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •