DSXchange

kduke wrote:You have to do it after ftp is done. chmod is not a command within the ftp command.

its Ok That mean i have to do it manually their is no way to automate this
through data stage coz ftp stage doesn't support any such options of changing file permissions.

Hi, Currently i am Using A shell script to ftp to a Nt Server from where i am getting the files & after loading i am Archieving that file to a diffrent folder on the same Nt server & then Again using a shell script to delete the file from the original location. Now the problem with me is tha...

Hi All, I am working on Unix box. There are some files on NT box folder which have same structure or definition. I am using Folder stage. In Folder Path Name property I want to specify the Path of this NT box folder. But when selecting the Path Name it goes to Unix box folders by default and there s...

Hi Kim , Thanks For your Reply ,but some thing like this we are already following we are writing that into seqential file & then call that file using routine but my question was to avoid the files completely just only databse . so that we can select the requires value for parameters through db s...

hi varun
i dont want creation of any file in between coz at the time of migrating it to other enviroment i have to keep in mind whether i have imported all the scripts or not.


thanks any way

Hi Lebos , just want to know how this will set parameters for the job will it take automatically i am still confused ,one more thing what would be target in this case as we have to specify an output for transformer i am creating that derivation in stage variable but its not working might be possible...

Hi its a bug with FTP I suppose but My purpose is Solved i just wanted to make a same copy to other location that i am getting just by defining all the data into one big length varchar column. but if You want to take data from delimited columns its still a bug its adding records. if you have any sol...

Hi Sri ,
i am new to datastage atleast give me an idea how to implement what ever you suggested.


thanks in advance.

Hi, Currently we are reading parameters from parametrs files that parameter file we create through a job which reads value from metadata table for a particular module we generate the parameter by selecting the value from dbase for that module & after that we read that file using a routine which ...

Thanks Ray Your Tip is Working It Might be possible that at atime when i was firing reindex command some body was using client now its all perfect.

Its checked their but still i can not see the jobs in the repository but jobs are their coz i can open the recent opened jobs in the file menu.

Thanks Its working Fine now

jobs are not visible in director , manager & in designer but i can use those whatever are their on file menu. means jobs are opening can any one pls provide solution? Hi, Go to the " View " and check the " repository ". You would be able to see all the jobs in the repository...

jobs are not visible in director , manager & in designer

but i can use those whatever are their on file menu.
means jobs are opening

can any one pls provide solution?

Hi , I AM Using Ftp stage in my job & files at remote server are ~ Delimited while doing ftp to some other Ftp area or into some sequential file its adding extra data in the last & First Row. like this-- Header~abc~110~exl insert~gth~456~36~784~tyi~rxz~1388.00 Trailor~rty~345~tre Above is th...