DSXchange

If you have 3 job activity stages in the Sequence job, and even if we handle the failure for 1 of the 3 jobs, the Exception Handler will NOT be triggered. For the Exception Handler to be triggered, there cannot be ANY exception handling in any stage in the Sequence. Also End the Exception Handler st...

Thanks..

Any info on Batch Jobs?

Also we dont have a scheduler here where in the past I have worked with Autosys..So how to we schedule jobs in a Windows environment?

Hi, In a Unix Env we used to run the Datastage jobs from a Shell Script using the dsjob command. The Paramater and Enviroment dependant values would be passed to the jobs from other shell scripts at runtime My question is, how can we run the jobs in a Windows Environment from the command line..using...

We are on Datastage 8.7 on Windows Server 2008 R2 Enterprise Edition

I see under Program Files on the server, Visual C++ 9.0 Express Edition and under which I see Microsoft Visual C++ 2008 Express Edition...So i believe we have the compiler - 2008 Express Edition?

We installed the Compiler given to us by an IBM rep who helped Install it as well, Onsite
To double check how can I verify if the version we are using is supported or not?

This the error I get, as shown below..I am not sure what it means but one thing I see is this path (marked in BOLD) ##I IIS-DSEE-TBLD-00000 08:28:14(003) <main_program> Error when checking composite operator: Output from subprocess: C:/Program Files (x86)/Microsoft Visual Studio 9.0/VC/include\excep...

Hi, When I try to compile a job with a Transformer, I get error, else it compiles fine. I have read through most posts on this topic and tried the suggested options of changing the LIB and INCLUDE system environment variables but it did not help. I tried all the combinations below but it did not wor...

Hi, We have Datastage 8.7 on Windows Server 2008 and we are exploring Operations Console.. Is it correct that it can enable us to get statistics like link row counts (basically table inserts/updates/deletes per link) for each job and also run times, like start and end time for the jobs? Also does th...

Yes this makes perfect sense ..
Thanks for your response..

Hi, We have installed IBM Information Server 8.7 on a Windows Environment are all set with the Datastage Client Installs as well. I am aware of the design and development best practices, but seeking help more on initial set up and/or admin side. So before we start development, I would like to undert...

Hi, I have a Multi Instrance job, say job and I run 2 instances simutaneously, say job.a & job.b The last eventid for main job was 100 and each job instance logs, say 3 events. So will job.a have eventids as 101,102,103 and job.b have 104,105,106 or can they be intermingled. 101,103,104 for job....

Hi, I am reading from a file with one column DT1 (varchar) having date values '20070802'. I am trying to load this in an Oracle table column AS_OF_DATE( timestamp), after using the following conversion code OCONV(ICONV(DT1, "DYMD[4,Z,Z]"),"D-YMD[4,2,2]") : " 00:00:00". ...

Decimal 25,7

Hi, I have a hash file with one key column data as 0.02, 0.33, 1.06, 2314234.55778,.... and the same data comes from another data source. When I do the look up on the hash file, all rows with this column values > 1 are matched where as others with value for e.g 0.02 fails even though both have all o...

Hi, We have both Server & Parallel jobs in our project depending on the requirements.The Parameters for both are different. So to dynamically pass the param values at runtime from a seperate param file we need to know whether the job is a Server or Parallel job. The job name itself, which is an ...