Instana

Instana

The community for performance and observability professionals to learn, to share ideas, and to connect with others.

 View Only

  • 1.  Structure of SQL (insert statement) generated by nco_osreport

    Posted 03/24/23 09:37 AM

    I used a Netcool/OMNIbus tool "nco_osreport" with -dbinit option, and got the SQL statements ( insert statements) to build New OMNIbus DB .

    Then , I noticed that the auto-generated insert statements has two patterns. See below.

      (1) insert into TableName (col1,col2,...,colN) values (val1,val2,...,valN)

      (2) insert into TableName values (val1,val2,...,valN)

    The difference between the two insert statements above is whether or not the column names are explicitly specified.

    I have two questions .

    (Q1) What caused this difference?

    (Q2) Can I control the differences in these output specifications using environment variables, registry values, etc.?

    Please teach me .



    ------------------------------
    Ken Iida
    ------------------------------


  • 2.  RE: Structure of SQL (insert statement) generated by nco_osreport

    Posted 03/25/23 09:52 AM

    Hi Ken, thanks for your question!  Unfortunately I don't think you are going to get an answer in this forum, this Alerting forum is scoped to the IBM Instana product.  We do have a forum for our AIOps product which includes Netcool/OMNIbus tools in it over here.   I've reposted your question over there!



    ------------------------------
    Mike Mallo 
    Instana Technical Head of Product
    IBM Corporation
    mmallo@us.ibm.com
    ------------------------------



  • 3.  RE: Structure of SQL (insert statement) generated by nco_osreport

    Posted 03/26/23 08:00 PM

    Thanks. I understand .



    ------------------------------
    Ken Iida
    ------------------------------

    Original Message


Related Content