79346623

Date: 2025-01-10 18:05:27
Score: 1
Natty:
Report link

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

Assign the value to the ODI variable

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

Reasons:
  • Blacklisted phrase (1): is it possible to
  • Long answer (-1):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Elmer Alavid