DSXchange

Am not sure whether Lotus Note or Domino file differ, if its Lotus Notes file how can we handle it?

Hi,

How to use Lotus Domino File as source to extract the data in Datastage. I have given the job type as Server, but if it cant be done in Server but in Parallel also, pls let me know how to achieve this.


thanks
Senthil

Hi Chulet,

How to find the default shell mode, i have already used .sh scripts to execute in some jobs and it works well, only this is making problem.

Thanks
Senthil

Hi, Am having a script to execute after Job finishes, and i have specified it in the After Job Routine in (ExecSh) of the DS Job. The script name is rejectfile.sh And the script file contains if [[ `awk 'END{print NR}' /RejectFiles/Extractrejectfile.csv` -gt 1 ]] then uuencode /RejectFiles/Extractre...

Thanks Robinson for your quick response. Its working now.
Great.

Hi, My aim is to attach file and send it through mail, if the file has records inserted into it. Current Design: The property of Seq file stage is Create file and First line as ColumnName- Checked. Am trying to trigger mail attaching the file using unix script, if any records is inserted into the fi...

Hi sorry for jumping in,

Am also having the same requirement to capture the error field with the error message.

How to capture the error code in the table?

Pls can any one help me out in finding a solution for this?

Am trying to do in the Datastage Designer, My aim is as follows: Step 1) Read data from oracle source and transform it with one to one mapping and write to the target. IF any datatype mismatch or field length more than expected the entire rows will be rejected by giving a warning in director. Step 2...

I dont want to achieve through Stage Variables, because we have many fields it will degrade the performance

Am trying to do in the Datastage Designer, My aim is as follows: Step 1) Read data from oracle source and transform it with one to one mapping and write to the target. IF any datatype mismatch or field length more than expected the entire rows will be rejected by giving a warning in director. Step 2...

No its Oracle

Hi all,

thanks for the response, i got it by searching DSXchange further,

the solution is have to use only ICONV and not the combination of OCONV & ICONV.

Gr8 Forum

Hi Ray,

Am unable to achieve this, pls explain me step by step to acheive this, i tried many ways by self reading the help document still i couldnt end up correctly, Can you pls explain me step by step for capturing the error record/warning record of the job.

Hi, now its converting but still while inserting into the target table am getting the following error

"Attempt to convert String value "15-08-2005" to Date type unsuccessful"

I tried with both DATA and TIMESTAMP in target but i got this error