FTP file stage

laxmi_etl · Post by **laxmi_etl** » Tue Nov 14, 2006 9:36 am

kris18 wrote:i think you are making something wrong in specifying the parameters in the admin...try this by doing one by one... i mean to say try to hardcode evrything in the ftp stage run it and c for errors, if you don't find any errors then go by parametrizing username first and leaving the rest hardcoded.... and run the job again c for error... and so on.

Any Idea how to solve this problem?.

kris18 · Post by **kris18** » Tue Nov 14, 2006 9:42 am

Laxmi try this,

don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now...

laxmi_etl · Post by **laxmi_etl** » Tue Nov 14, 2006 10:05 am

kris18 wrote:Laxmi try this,

don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now...

I have tried that too but not working.

laxmi_etl · Post by **laxmi_etl** » Tue Nov 14, 2006 1:51 pm

kris18 wrote:Laxmi try this,

don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now...

I am actually doing ftp from one unix box to another box.I want to try this with FTP enterprise stage to see if it can fix my problem.But I don't understand how to give the URI for it.
For example if
My unix server name is testserver
and the path is /home/accounts/
file name is tmp.txt

So for URI is it enough to give ftp://testserver/home/accounts/tmp.txt
Please let me know.
This is not working too.

samu · Post by **samu** » Tue Nov 14, 2006 5:03 pm

Are the patches for DataStage Client installed properly on your computer ?. If not try to install them first that will solve your problem.

csrazdan · Post by **csrazdan** » Tue Nov 14, 2006 7:19 pm

Are you able to open FTP session from your server on which DataStage is running. Try FTPing a file from UNIX prompt. This is to test if you can even start a FTP session.

laxmi_etl · Post by **laxmi_etl** » Wed Nov 15, 2006 10:35 am

csrazdan wrote:Are you able to open FTP session from your server on which DataStage is running. Try FTPing a file from UNIX prompt. This is to test if you can even start a FTP session.

I am able to open FTP session from unix and also successfully FTPied a file. From datastage the environment variables are not working

ray.wurlod · Post by **ray.wurlod** » Wed Nov 15, 2006 10:54 am

Are you convinced by now that the FTP stage can not use environment variables in the way that you want? Every test you've conducted has verified that this is the case. If you want the product changed, you will need to make a business case to the manufacturer.