Forum Stats

  • 3,769,238 Users
  • 2,252,937 Discussions
  • 7,874,957 Comments

Discussions

ODI repository - What table stores Parameters and corresponding values of a Package Step ?

4161514
4161514 Member Posts: 3
edited Jan 20, 2020 5:04AM in Data Integrator

Could you help me to find out which ODI repository table and column stores Parameters and values for the given step in Package ?

The objective is to to find the values for Parameters for steps of type Oracle Data Integrator Command and Operating System Command. This last cndition is matched by SNP_STEP.STEP_TYPE IN ('OE','SE')

but I cannot find any join to the table that stores parameters and values for the Package Steps.

Thank you in advance !

Tagged:
4161514Adrian_Popescu-Oracle

Best Answer

  • Rodrigo Radtke Souza
    Rodrigo Radtke Souza Member Posts: 187 Silver Badge
    edited Jan 17, 2020 2:43PM Accepted Answer

    Something like this maybe? From the full text you can get all the parameters used to build that command.

    SELECT

         B.FULL_TEXT

    FROM

         SNP_STEP A

         JOIN SNP_TXT_HEADER B ON A.I_TXT_ACTION = B.I_TXT

    WHERE

         STEP_TYPE IN (

             'OE',

             'SE'

         )

         AND B.FULL_TEXT LIKE 'OdiOSCommand%'

    pastedImage_0.png

    41615144161514Adrian_Popescu-Oracle

Answers

  • Rodrigo Radtke Souza
    Rodrigo Radtke Souza Member Posts: 187 Silver Badge
    edited Jan 16, 2020 12:56PM

    You may use SNP_SESS_STEP_LV. Just remember that you need to run your scenario with Log Level 6.

    pastedImage_0.png

  • 4161514
    4161514 Member Posts: 3
    edited Jan 17, 2020 5:40AM

    Thank you for reply Rodrigo however let me clarify.

    What I am looking for are not the values for variables at the execution of scenario. I am looking for the values of parameters in the source code. Actually I would  like to search my repository to find all of the steps in all packages of the type

    SNP_STEP.STEP_TYPE IN ('OE','SE') and I am interested to see what values they have for Parameters: "Command to execute" , "Output file" and "Error file"

    pastedImage_0.png

    I

  • Rodrigo Radtke Souza
    Rodrigo Radtke Souza Member Posts: 187 Silver Badge
    edited Jan 17, 2020 2:43PM Accepted Answer

    Something like this maybe? From the full text you can get all the parameters used to build that command.

    SELECT

         B.FULL_TEXT

    FROM

         SNP_STEP A

         JOIN SNP_TXT_HEADER B ON A.I_TXT_ACTION = B.I_TXT

    WHERE

         STEP_TYPE IN (

             'OE',

             'SE'

         )

         AND B.FULL_TEXT LIKE 'OdiOSCommand%'

    pastedImage_0.png

    41615144161514Adrian_Popescu-Oracle
  • 4161514
    4161514 Member Posts: 3
    edited Jan 20, 2020 5:04AM

    Spot-on  Rodrigo . Many thanks!