External Target Stage

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

Post Reply
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

External Target Stage

Post by senthilt1 »

Hi All,

I have a requirement such that, i need to FTP a file and pass that value inside the file to a dsadmin command. Important things is i shouldnt store the FTP file anywhere and i should dynamically pass the value to the dsadmin command.

Will FTP stage followed by external target do this task. In the ftp'ed file i have two fields and i need to take the second field and pass that to the dsadmin command.

Please give me a solution to this.

Thanks,
Senthil Kumar P
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The FTP Stage transfers data on a row-by-row basis without landing the data; unlike the FTP command which copies a whole to/from disk in one go.

From your description the FTP stage sounds like what you need.

What have your tried so far and with what sort of success?
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Post by senthilt1 »

Hi Arndw,

Thanks for your response.

I have done this using UNIX mkfifo - pipe to read from the file from other server and assigned this value dynamically to the dsadmin commands.

Thanks,

Senthil Kumar P
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So... is that your resolution or are you looking for another answer? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Post by senthilt1 »

Hi Chulett,

It would be really great if you could suggest the other way of doing this task.

Thanks,

Senthil Kumar P
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

First (for me at least) you'd need to clarify what exactly it is you are trying to accomplish. For whatever reason, neither your original post nor your fifo solution make much sense to me as I'm not really sure what you mean by 'assigned this value dynamically to the dsadmin commands'. Can you expand on that? Provide an example or two?

Thanks.
-craig

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