Using the command stage

wdudek · Post by **wdudek** » Fri Dec 19, 2003 4:46 pm

I am trying to copy files using the command stage, when Igo to compile this I get the message Invalid Data Type COMMAND.RTNCODE followed by the output link name. I have this going into an Oracle 9i stage, where I disregard the input stream altogather and execute a stored procedure that works on the files copied. Has anyone else experienced this type of error from the Command stage? and if so what can I do to avoid it. I tried deleting the return code output column and or changing the type but it keeps coming back.

kduke · Post by **kduke** » Fri Dec 19, 2003 5:29 pm

Post the exact syntax you used. I think we need more information.

roy · Post by **roy** » Sun Dec 21, 2003 7:43 am

Hi,
your problem is simple in fact!

get your CD, in there you'll find the command stage's import file that has the data types for the command stage.
you should find a pdf file for this stage it has the answers in detail.

unless you import them you can't use it.

IHTH

wdudek · Post by **wdudek** » Mon Dec 22, 2003 11:59 am

Thanks, once I was able to find the pdf on the cd it explained exactly what I needed to do and teh job will now compile.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 22, 2003 1:52 pm

I used to make it a habit to grab all the plug-in PDFs and install them on the client with the other DataStage manuals (or on a shared drive, depending on the installation).
Version 7.x now does that for me.