Declare select * from dual end

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
tricampeon81
Participant
Posts: 19
Joined: Thu Apr 19, 2018 11:06 am
Location: chile
Contact:

Declare select * from dual end

Post by tricampeon81 »

friends within the query section I can use a declare

???
?????
dfgdfg
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
tricampeon81
Participant
Posts: 19
Joined: Thu Apr 19, 2018 11:06 am
Location: chile
Contact:

Re: Declare select * from dual end

Post by tricampeon81 »

I need to improve a query and for that I need to use variable before the query
it's possible??
dfgdfg
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply