DSXchange

hi all,

One way to pass a value from one job to another is by using userstatus (DSSetUserstatus). I somewhere else read (and experienced) that this routine can only be used in serverjobs. What mechanism(s) can be used in px jobs for passing values?

Peter

Hello, On several other posts I read that it is possible to call external dll functions written in C. I also read that it's not easy to do so. Although I am not an experienced Datastage developer, I do want to give it a try. As a start I downloaded the Universe GCI guide. Here it is said that, to be...

hi Ray,

Added DQuote but it still gives a crash

I already reported this issue to IBM as a bug

Peter

hi , I still can't find the entry you mentioned after doing a reset. Nevertheless, I found out that the crash is caused by setting the userstatus to a string containing backslashes (using DSSetUserStatus). In the job I have a filepath like 'D:\DATA\DEV\PROJECT\INPUT' that I want to assign to the use...

Hi ArndW, I resetted the job, but it still crashes... Where precisely can I find the log entry 'from previous run'? I tried to find it by doing a menu search on "from previous entry" in the log, but without result... When run in isolation the job terminates normally with status OK. When ru...

Hi all, I have a job sequence with several sub jobs. If I run the sequence one of the (server) jobs produces the following log message: Seq_Reg_RegistrateFile01..JobControl (DSWaitForJob): Job Job_Reg_GetProjectInputPath01.1 has finished, status = 96 (Crashed) The job retrieves a table value and ret...

hi all, I want to retrieve a selection of records from my Dbf table. For this purpose I use an ODBC stage in which I set read method to table and specify the tablename as parameter #TABLE#. In the columns tab I entered the column 'markeer' from this table. When I view the data I get the following er...

hi all, I have a requirement to split a DBF file based on the values in one column, into a number of output files. One output file for each split value. So, if the input column has the following values: A, B, C, D the job should create 4 files named A.DBF, B.DBF, C.DBF, D.DBF each filled with the co...

hi all, I still can't get rid of the compiler error in the transformer. Some observations: We use the c++ compiler in Visual studio.net 2003 enterprise architect This compiler works well in conjunction with datastage (except for this PX transformer job) The output of the transformer is written to a ...

Hello, I have a parallel job that includes an aggregator stage. Because performance is not sufficient I want to see if a server job will make sense. However, when I look in the aggregator stage of the server job, there seems to be no properties that allows me to set grouping keys, aggregation column...

Hi all, My transformer job gives me the following compilation errors. The transformer stage has 329 columns with most nulltozero transformations. Most columns are numeric 15,3. Help! Output from transformer compilation follows: ##I TFCN 000001 09:53:11(000) <main_program> Ascential DataStage(tm) Ent...

Hi all,

We installed VS 2003.Net without de-installing Datastage and it appears that Datastage has no problems with finding the compiler :D

Peter

Hello all, We have installed Datastage version 7.5x2 on out Windows 2003 machine. After compiling a parallel job we got an error that the complier "cl" could not be found. We then realised that we didn't have installed the Visual Studio 2003 c++ compiler which is mandatory for compiling tr...

Hello all, We are currently migrating Datastage from Unix to Windows (version 7.5x2). In this version, I couldn't find the Sybase Enterprise stage we used under Unix. Is this a Unix specific stage or do we need to install it separately. It didn't ship with our Datastage for Windows install? If so ho...

Hello,

Currently we are migrating our Datastage jobs, routines, etc from Unix to Windows. I was wondering if someone has experience with such a migration, and knows what problems (if any) can be expected?

Peter