DSXchange

Are you using any project level parameter called rootdir? if so delete that and try run it works for me

Change array size and transaction size while extracting and loading also it will give better performance and create index on target tables

after reset my job this is the information From previous run DataStage Job 559 Phantom 5672 The variable "APT_PERFORMANCE_DATA" is not in the environment. Job Aborted after Fatal Error logged. Program "DSD.WriteLog": Line 305, Abort. [5968] Done : SH -c 'd:/IBM/InformationServer/...

just i cretaed one job in parallel.this job creating dataset taking from sequential file i am able to view the data in sequentialfile but jib is aborts

Thanks ray,

i am able to compile,but job is aborted and giving me this error
Error setting up internal communications (fifo //./pipe/FIRSTPORT_DEV-RT_SC559-DataSet



Thanks ray,

Hi all, Can any body help me on this how to make the parallel job to run in windows mechine.we are installed IBM information server on windows 2003 server but we are able to run server jobs but not parallel jobs. Is there any settings are required? In my project there are quality stage jobs but we a...

Hi all, I am trying to load data from DataStage to SAP using pack 4.3.my job finished without any issues but data is not load to SAP BW system it is giving me error 'bw load-critical failure-no pull job defined' if any one knows please help me on this . we are doing migration from DataStage 7.5.1 to...

Hi, We are doing the migration of jobs from 7.5.1 to 8.0.1. i imported the jobs and compiled one of the job it compiled fine. while running the job i got date formate issue. i searched in the forum i got the solution but the solution says that set the enivironment variable DS_NO_FF to 1 if any body ...

Thanks for the quick response.
My OS is windows and i dont have an unix environment to run this
Kindly suggest

Thanks

Dear ,

Where should i execute this query.
I tried in the administrator command mode and also the cmd prompt sqlplus.

Kindly let me know.
Thanks

Hi

I want to extract all where clause used in a project or all jobs do we have any dsfunction or job design or any routine also help ful

Thanks in a advance,

try using uri as your server ip

method to check the files exists in server is using waitforfile activity .
To delete files if any job aborts using trigger conditions by your design and finally delete files

use schema files and parameterised the job

Hi I have written on stagevariable but it is giving me wrong result can any help me on this mystagevariable if trans.empno=mast.empno then 1 else 0 both columns are varchar columns trans.empno=00000802 (value coming from hash file) mast.empno=802 (value coming from oracle stage) but data stage shows...