DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
tricampeon81
Participant



Joined: 19 Apr 2018
Posts: 17
Location: chile
Points: 133

Post Posted: Tue May 15, 2018 10:53 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: I need to pass as pl / sql
friends I have a doubt if they can help me

I have the following simple example I leave in a photo



1 select * from table

2 insert into table prueba_mr

that works perfectly what ace is the following


https://ibb.co/guRpdy


what you need to do is replace the select with an anonymous block pl / sql and go through variale you can as well as this example

https://ibb.co/nvC9BJ

help me please

_________________
dfgdfg
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42574
Location: Denver, CO
Points: 219079

Post Posted: Fri May 18, 2018 6:51 am Reply with quote    Back to top    

I have a doubt too and hate to see questions with zero replies but don't know how much anyone can help right now... hence the lack of replies, even in your first post on this topic. Also, English is not your mother tongue so we have that going on as well. My other issue is the fact that the site hosting your snapshots is blocked at work. So here I am at 6:30 in the morning, trying to do... something. At this point all we can attempt to do is seek clarifications. Sad


The source/target stages in your images are what, Oracle connectors? Guessing you're working with Oracle because of the "PL/SQL" references but it isn't unique to them. I don't see any need for an anonymous block for the very simple source select you are trying to run. Where / how do you see any kind of "variable" being used in it? FYI - any variable the you could bind into the source select would need to be a job parameter - have you tried that yet? But again, no need for any kind of PL/SQL to do that that I can see.

Help us help you. Can you explain in more detail what you are trying to do again, please?

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
tricampeon81
Participant



Joined: 19 Apr 2018
Posts: 17
Location: chile
Points: 133

Post Posted: Wed May 23, 2018 8:02 am Reply with quote    Back to top    

my problem is simple, as I can from a block, pass the value of the variable to the other comonete trasform

_________________
dfgdfg
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours