DSXchange

Just test it out

Unfortunatly I'm neither a c++ guru nor having experience in working with DS API-calls from external programs...

Klaus

Have a look at the Server Job Developers Guide, chapter "DataStage Development Kit (Job Control Interfaces)".

It describes all API-calls. Should be valid for server and EE jobs.

Klaus

Can you do view data on Sequential_File_2? Looks like data format issue. Can you peek without MODIFY stage?

Klaus

Your sequence seems to be aborting for some reason. You should first look into why it is aborting, because this will set your sequence into a "not runnable" state. If you trigger your sequence from a job activity, you could use the execution action "reset if required then run" to...

Actually the Sequencer functionality is described in the "Designer Guide". Please have a look at this, it shall give you a good overview and details on what you can achieve with the job sequencer. The job sequencer can be used for both server and EE-jobs. It can even run a mix of jobs. Klaus

well, yes, that's a known feature....

You may also consider writing a job control job instead and use the DSExecute function. You're then flexible in constructing the DOS command and have it run as an independend job.

Klaus

You need to define the data of type "raw" in schema,

e.g.: data:nullable raw[max=65535]

which translates into LongVarBinary in DS table definition, to have them not go through NLS mapping.

klaus

Better use command activity in job sequencer for this.

Klaus

Specify:

Deffun KeyMgtGetNextValue(A1) Calling "DSX.KeyMgtGetNextValue"

in the first line of your routine.

Klaus

The sequencer functionality is described in the "Designer Guide". Have a look at you DS client installation:

Start/All Programs/Ascential Datastage/DataStage Docu 7.51A and choose "Designer Guide".

Best regards
Klaus

Ah, that's fine!

> property for "FILE TYPE MODIFIER"

I have never recognized/tested that option in the stage...

Happy loading!

Klaus

Narendra, I think you have to modify the generated load script, e.g.: ... MODIFIED BY codepage=819 ... Look for the "MODIFIED BY" phrase and insert the "codepage=xxx" after this. I had to do it once for German Umlaute loading, and then it worked. So for the load stage, you should...

Bala,

you should move this entry to the parallel forum, as this is an issue regarding DSEE...

Not sure if this error has to do with your function. Do you have a reject link specified in the transformer?
Does it compile without using the function in the transformer?

Klaus

"This looks similar to problems relating to Time Based Job Monitoring that have been experienced by other customers and is also documented in the datastage readme.txt (see extract below): Time Based Job Monitoring - Intermittent Problems ------------------------------------------------- Intermi...

If you store the records it in a EE DataSet - quick and VERY performant - they will be in memory if you act on them with a lookup in job b.

Klaus