DSXchange

hi kenneth , Can you please give me the names for the 3rd party software. We used ftp stage before when datastage was on windows to get files from unix servers. Cant we do the same to get files from windows. And one more thing now we have datastage on linux . not on unix sorry for that. I found that...

Hi all, I am trying to migrate dsjobs from windows platform to linux platform. We have several jobs, which maps for source text file from other windows servers with the following command. CALL DSExecute("NT","DIR ":MappedDrive:":\root1\directory /AD /B",CommandCap,Comma...

Hi all,
I have a file.sql text file with bunch of sql statements. Which are insert statements. How can i excecute this in batch job or in a regular job?
I need to create a job which excecutes this and need to schedule it.

thanks in advance,
ann.

Thank you again Kenneth .

Thank u very much for the reply. SO when I want to execute shell I have to do is rsh script.sh In detail: I have a batchjob, which runs an extract job. After that finishes, I need to execute shell. so in the code all I have to do is rsh path\script.sh ? What if I want to execute through secure shell...

Hi all,
I wanted to install datastage on linux redhat AS 3.0.
What my Q is if I want to execute a shell script which is in another Unix sever Can I Execute that shell script from datastage which is installed on linux on different server.
If I can how?

Thanks in advance.
Ann

Hi chulett,
The convert function work excelent after i used char(10) .
Thank you,
ann

Hi all, I have an as400 table to extract, which has comments field. The length is 255 char field. And has ' ' character in it. Which is recognized as carriage return for datastage. And when I run job it recognizes as next record. Example data is: |"11111"|"emailid"|"comments...

Hi all, I am posting this here because I got same problem in different way I guess.In the begging of this post I mentioned that I had to add 3 more cols to my job. When kcbland replied that we need Meta data definition to do it instead of manually adding them. I did that but back then I had 58 cols ...

Hi kcbland , Thank u for ur reply. The jobs i am trying to modify are old jobs. They dont have metadata definitions. Those used just user defined sql query . To that i added 3 more cols. Now when i imported the same table metadata definetion . and Used that definition in my job. now it is working wi...

Hi all, I am trying to extract as400 table by query in ODBC stage. It was working fine. After few days we have to add 3 cols. When I run the modified job I am getting the following error. Extract_Job1.CTransformerStage1.DSlink1: DSD.BCIGetNext call to SQLFetch failed. SQL statement:SELECT col1,col2,...

hi all,
I have excel sheet to load in to a simple text file how to do that.

i have searched all the forums but i couldnt get any ans
thanku

thank u Sainath. I will read it again and try the method.


Anantha.

hi sainath,
thanks for reply. I am verry new to datastage. cn u please elaborate how to do lookup.
thank u

hi all,
i have to update a target table with source table values comparing t table primary keys (2) to s table 2 cols which are not primary keys. can anyone help me how to compare them.
thanks,
ann