oracle - How to run 2 different "execute sql" steps in one session in Pentaho Kettle (PDI) -

-

My question is, how can I run 2 different "execute SQL scripts" steps, so that they both share the same session Lange, not 2 different?
In my transformation, I need to run a SQL script at the beginning of the change process, to allow modification in the table. After this, I remove the data from a database, manipulate them, and I need to call some process (using another SQL script) to update the conversion status based on the result. I can not update the situation, if SQL is not executed first, and permission is not granted.

Search gives me only 2 results:

  1. Select "Unique Connection" in Change Settings. This is not applicable, because it is only available in older versions of Kettle.
  2. Choose "Transform Changes Database" - In fact, the only thing (new name for old property in new kettle) seems like what I really do not want because it does not work as expected Does

    I am working with Oracle Database and Kettle 5.1.0.

    Update:

    Enter image description here

    In this picture, I have 2" execution SQL scripts "in order to move, blocked by the appropriate steps. It seems that these scripts executed in 2 different database connections (sessions), then the second does not see the effect of the first.

    Was the main point "executed for each line"? Option of "Execute SQL Statement" phase This option changes the behavior of a little step. For this step, Pattaho Wiki "Select this option to execute SQL for each incoming row. In this case, the parameter can be used. When this option is unchecked, then the SQL statement step Is executed in the initial stage. ". Actually what I want but I'm thinking, why did developers put 2 different functions in one option?

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more