Page 1 of 1
Using the command stage
Posted: Fri Dec 19, 2003 4:46 pm
by wdudek
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.
Posted: Fri Dec 19, 2003 5:29 pm
by kduke
Post the exact syntax you used. I think we need more information.
Posted: Sun Dec 21, 2003 7:43 am
by roy
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
Posted: Mon Dec 22, 2003 11:59 am
by wdudek
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.
Posted: Mon Dec 22, 2003 1:52 pm
by ray.wurlod
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.
