DSXchange

Hi


My source data is FlatFiles.After reading data from flatfile we have to write data to Excel File Output(Excel Formate).Please give some idea regarding this

thanks

In the Execute command stage i given command line as "sh /data/customer/Personal/fine.sh" this is hard coded. We tried parametterzing the Execute command path and the name but datastage doesn't allow us to parameterize the shellscript path .The script to run should be soft-coded.so please ...

hi thanks for your help. the syntax is working .we have to give space between two parameters same like
#USERID# #PASSWORD# #ANYPARAM#

thanks

Hi, Just to expand on the previous post, I have a shell script in which I have defined 3 parameters as $1,$2 and $3. I have to execute this script from the Execute Command activity by passing these 3 parameters. In the sequence, I have defined these 3 parameters as "Username", "Passwo...

hi

Thanks for your help. I am having total 3 parameters example
#username#
#password#
#filename#
and I given like syntax #username#:' ':#password#:' ':#filepath#
and I am unable to get the result.
please can you tell how to give parameters in execute command stage ?

from
kumar

hi

Thanks for your help. I am having total 3 parameters example
#username#
#password#
#filename#
and I given like syntax #username#:' ':#password#:' ':#filepath#
and I am unable to get the result.
please can you tell how to give parameters in execute command stage ?

from
kumar

hi


I am executing the sh.script in datastage using Execute command stage. I am unable to diffrentiate the parameters.

example:#username# #password#

So please tell me which character is used instead of space between two parameters

thanks

I want to ftp multiple files from a remore directory using FTP Enterprise stage . I have tried with many options. It is asking for port number in URI path . Can someone guide me how to give exactly the URI and files . Some info: My server 10.125.46.152 file path--/data/vsn/ I want to ftp all files i...

I worked on that and executed perfetly before I got your answers. A little bit confused with the way to use the shell script as that is my first assignment on using shell in DS. I want to ftp multiple files from a remore directory using FTP Enterprise stage . I have tried with many options. It is as...

Hi all, I wrote a shell script File_Rename.sh in a folder say /data/customer/Personal/Prashanth/ Now I want to call that shell script in Execute Command Activity in Job Sequence. There were no parameters for that shell script. When I executed in Unix at command prompt as sh File_Rename.sh , it execu...

Hi everyone, I have a sequential file and I need to split the sequential file into number of files. In that sequential file, we have some records like ***End of Report *** Whenever I get that record, I need to split the file up to that line as one file and so on. Can someone guide me to get the logi...