DSXchange

The output of the Change Capture stage can only be "After" data. There is no way to output "Before" data or columns from this stage. The Change Apply stage on the other hand gives you both "Before" data with the "After" changes applied. We use the Change Capture stage but not the Change Apply stage ...

You will probably find it easier to move to Enteprise Edition of DataStage and use parallel jobs instead, or move to SOA Edition and run server jobs as real time services across the cluster.

Good point! I posted without testing it first. Your original syntax was correct and my correction was incorrect. You should use [fix_zero, suppress_zero] instead of [fix_zero][suppress_zero].

No, as per the documentation:
stringField = string_from_decimal[fix_zero][suppress_zero] (decimalField)
C:string[7] = string_from_decimal[fix_zero][suppress_zero](B)

Simply add the word surrounded by square brackets in your specification. Add [fix_zero] and/or [suppress_zero].

I think a transformer will be faster. As a rule of thumb I would use specialty stages if you can do it in two or less but otherwise I go for a transformer. I am concerned about the lack of reject links in some specialty stages, especially the Modify and Filter stages. These can look okay in testing ...

Let me make it even easier for you. E:string[7]=string_from_decimal[suppress_zero](A) The suppress_zero option is not documented anywhere in the Parallel Job Developers Guide but it is in the Orchestrate Operator's reference. stringField = string_from_decimal[fix_zero][suppress_zero] (decima...

The easiest way to access DB2 data on a mainframe is via a 3rd party product such as DB2 Connect or IWay. These products provide easy connection from Unix and Windows users similar to ODBC connectivity. Talk to your local Ascential office about accessing DB2 mainframe data as they may have up to dat...

Your first choice is whether to generate the unique ID within your ETL job or leave it to the database. Neither method is right or wrong, they just require different methods. If you continue to generate it on the database then you need to retrieve it again. The two methods are to load it into a hash...

Has anyone managed to get this working via user-defined SQL? What was the syntax you used?

Sometime in the last month the dsxchange reached 2000 members with one or more posts! That's one in four people joining the forum who choose to post. I think that's a fantastic achievement.

What do you mean you want to get the identity value? Do you want to get the last used value? Do you want to get the value for each row? What do you want to do with it? Are you retrieving it for reporting purposes? Do you want to save it somewhere?

Make sure you have checked the "Allow multiple instances" on the server job, not the sequence job.

Read the FAQ on project specific environment variables. $PROJDEF can only be used on variables set up by the Administrator tool and added to the job via the "Add Environment Variable" button on the job parameters tab. They are brought into the job starting with a $ sign.

From what I recall in our class, all you need to do is right-click on one in any job's log and take it from there. You got to go on a training course? I am so jealous. My last training course was negotiation skills where I learnt enough to negotiate myself out of future crap training courses. Would...