DSXchange

Have you set your 'Array Size' and 'Rows per Transaction'? These 2 parameters in the stage affect our loads into Oracle.

Also, we disable indexes other than the primary key to improve performance.

When writing to a Hash file, if you have a duplicate record key, the last record written is what is in the file. For your second example, only 2 records would exist in the hash file Material................Mandt.......................Variant as keys XXXXX...............YYYYY............................

In your transformer, you can set up the derivation using either a group extract or the field function and concatonate the items.

DT_FLD[1,10] : "-" : DT_FLD[12,15]

This should give you your desired value.

Stephen

I do this regularly using hash files and stage variables (sv). sv1-NewRec; Derivation1-If STUDENT_ID = LastId Then 0 Else 1 sv2-Grade; Derivation2-If NewRec = 1 Then STUDENT_GRADE Else Grade : @VM : STUDENT_GRADE sv3-LastId; Derivation3-STUDENT_ID Write the results to a hash file (or other database ...

You can hard code the key as a string. If it changes with each run, then take the record (single record item) and write it to a hashed tble with a hard coded key field> Hashed table with following fields: Key Field - "Record" (any string to identify the record. Field 1 - RecordId (from the...

I would reverse the tables and use the table with multiple records as your source table. Use the other record as a lookup with a hard coded Record ID and use the constrants to filter out records you do not need.

Check the data in your table. Most lickly you have an empty field in one of the numeric fields and they are treated as non-numeric.

stephen

Online manuals are loaded with your DataStage client. Use those to familiarize yourself with DataStage and its components. Also, being new, you should take a DataStage training offered by IBM.

For something like this with just 4 ranges that are considered static, I would either use a nested if statement in the derivation or create a routine using a case statement.

I like the routine, because you only need to modify 1 place if the ranges would change.

Hope this helps.

Stephen

I was able to get on this morning.

Stephen

In DataStage Manager, if you set up your view to 'Extended Job View', you can select your sequencer. A folder under the sequencer called 'Job Dependencies will appear. Select that and the list of all the jobs executed in the sequencer will be listed in the adjoining window.

Stephen

The SPS will return results of your to a return parameters that can be passed through an output link.

Saravanan, The Exception Handler does not accept Input links and we are trying to eliminate all of the extra links we've had in the Job Sequencers. I have asked a fundamental question to those in charge: :?: Why the jobs in production run with the default of 'abort job after 50 warnings' when most o...

Thank-you Ray, The documentation is vague and states any jobthat returns any value other than 0 to indicate success will always be taken as indicating failure. I made the assumption that this was talking about the job status :oops: We've been doing the job ok link and otherwise link and they have be...

I'm having a problem with my error handling within a sequencer. I've done the following steps. - Checked the box in the job properties to to 'Automatically handle job runs that fail'. - Setup an exception handler to log an entry in director and to link to a notification stage to send an appropriate ...