Page 2 of 2
Posted: Tue Nov 14, 2006 9:36 am
by laxmi_etl
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?.
Posted: Tue Nov 14, 2006 9:42 am
by kris18
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...
Posted: Tue Nov 14, 2006 10:05 am
by laxmi_etl
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.
Posted: Tue Nov 14, 2006 1:51 pm
by laxmi_etl
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.
Posted: Tue Nov 14, 2006 5:03 pm
by samu
Are the patches for DataStage Client installed properly on your computer ?. If not try to install them first that will solve your problem.
Posted: Tue Nov 14, 2006 7:19 pm
by csrazdan
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.
Posted: Wed Nov 15, 2006 10:35 am
by laxmi_etl
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
Posted: Wed Nov 15, 2006 10:54 am
by ray.wurlod
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.