Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
mukejee
Participant
Posts: 37 Joined: Thu Dec 11, 2008 5:38 am
Location: India,Bangalore
Post
by mukejee » Thu Aug 20, 2009 1:28 am
Hi All,
Can anybody help me how to copy all stage varible names ?
I am having more than 50 stage variables and i want to copy only the stage variable names.
thanks in advance
MUS
laknar
Participant
Posts: 162 Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai
Post
by laknar » Thu Aug 20, 2009 2:28 am
DSGetStageInfo(hJob,stagename,DSJ.VARLIST)
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Aug 20, 2009 3:49 am
Do you want to copy them from one transform stage to another? I don't know of a way to do this in the designer, unfortunately. It might be possible to do via cut-and-paste from a .dsx export file.
thompsonp
Premium Member
Posts: 205 Joined: Tue Mar 01, 2005 8:41 am
Post
by thompsonp » Thu Aug 20, 2009 3:58 am
Why not use copy and paste, then clear all the derivations. It's only a 3 step process.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Aug 20, 2009 7:26 am
I think you should be able to select all / copy and then 'Paste Column' rather than 'Paste Derivation' to get only the columns.
-craig
"You can never have too many knives" -- Logan Nine Fingers