Forum Discussion

krenevla's avatar
krenevla
Contributor
13 years ago

JDBC step- possibility to set SYSTEM_CONSTANT then do merge?

Hi,

I need to call "exec SYSTEM_CONSTANT.INST_CONTRACT_DML_QUALIFIED:=TRUE" before I am allowed to update one field in DB but problem is, that it seems that this constant is set to TRUE just for current session which is closed once step is finished.

Is it possible to call this together with merge in one step or "transfer" opened session from one step to another? Or only one option here is to use Groovy?

Hope it's clear what I asked, sorry if not

3 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Hi,

    Can you elaborate on how are you executing your command "exec SYSTEM_CONSTANT.INST_CONTRACT_DML_QUALIFIED:=TRUE"?

    Regards,
    Shadid
    SmartBear Sweden
  • krenevla's avatar
    krenevla
    Contributor
    13 years ago
    hello,

    when I check "stored procedure" in JDBC step and remove "exec" (so I call just "SYSTEM_CONSTANT.INST_CONTRACT_DML_QUALIFIED:=TRUE") then I got some respond as <updatedRows>-1</updatedRowns> so I assume it was properly executed?

    V.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Hi,

    Your response looks strange, because updatedRows should return number of updated rows. In your case I assume it should be 0 or a positive number.

    But -1
    <updatedRows>-1</updatedRowns>
    is not probably something you are expecting. Is there any other way for you to check whether this is set to true?


    Regards,
    Shadid
    SmartBear Sweden