my English is not that good,
With some code language (jython or SQL for example) in a step of a procedure I generate a value, for that value, is it possible to assign it to a value of the option of that step and that in a later step of a package ( a variable for example), Can I obtain the value generated in the previos step of the procedure? Or if you have any documentation on how it could be done in almost affirmative
With jython I managed to pass, but I encapsulated it with the <@ Test = "testvalue" @> and then assigned it to an ODI variable with <@=Test@> and used it.,
I don't want to encapsulate the following code Jython
# Name of the library you want to check
library_name = "smtplib" # Change this according to your need
# Output variable for the result
output_message = ""
try:
# We try to import the library
exec("import " + library_name)
output_message = "Library '" + library_name + "' exists in the environment."
except ImportError:
# If it doesn't exist, we catch the error
output_message = "Library '" + library_name + "' does NOT exist in the environment."
If I encapsulate it I don't get the result correctly because it's jython and I call a library of it
I don't know how to get output_message and then be able to use the value in some other step of the package.
I found ideas like
odiRef.setVariable("LIBRARY_CHECK_RESULT", output_message)
But I can't get them to work, it shows errors that this way of getting the value is not enabled, it's not available for ODI12c
I don't have the right way to do it anyway