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: 19
Location: chile
Points: 169

Post Posted: Mon Apr 30, 2018 8:41 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
Additional info: you can use a declare
friends within the query section I can use a declare

???
?????

_________________
dfgdfg
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42762
Location: Denver, CO
Points: 220350

Post Posted: Mon Apr 30, 2018 10:48 am Reply with quote    Back to top    

Can you be a wee bit more specific, please? In the query section of what and what are you trying to accomplish? I would also be curious why you would feel the need for using syntax like that.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
tricampeon81
Participant



Joined: 19 Apr 2018
Posts: 19
Location: chile
Points: 169

Post Posted: Mon Apr 30, 2018 3:00 pm Reply with quote    Back to top    

I need to improve a query and for that I need to use variable before the query
it's possible??

_________________
dfgdfg
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42762
Location: Denver, CO
Points: 220350

Post Posted: Mon Apr 30, 2018 3:41 pm Reply with quote    Back to top    

Again, hard to say without details. I for one am not really sure what "use variable before the query" means... especially the "before" part. Do you mean you need to bind a variable into the query? If not, can you provide a specific example of what are looking to do? Maybe when we see it we can say yes or no or provide a proper path to accomplish it.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
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