DSXchange

Something, somewhere has requested access to a memory address it does not own or which does not exist.

Are there any other warnings? What happens if you reset (not recompile) the job?

The Oracle Enterprise stage does not use ODBC, so anything you found there is probably not relevant. It remains unclear whether the block size referred to here is something inside DataStage (such as buffer size) or something in Oracle or the connection between Oracle client and database server. It l...

venkatesh pentela wrote:sh jobmoninit start $APT_ORCHHOME.But,this is server level.In our case,its not needed.

That is totally wrong. The job monitor is definitely needed for parallel jobs.

What PRECISELY are the error messages? "Weird message" doesn't help diagnosis. Post the detail of the error messages.

The clock keeps running after DataStage invokes sqlldr, even though no more rows are processed within DataStage. The clock only stops when sqlldr reports that it has completed its task, and any after-stage or after-job subroutines have been executed and returned. Use your "active stage finishing" lo...

What kind of database product is this? Do you have an ODBC driver? If so, you should be able to use an ODBC stage.

Were any errors reported during installation?

You have marked this post as resolved? What was the solution?

Read the help on Trim. Particularly the phrase reduces multiple occurrences to a single occurrence

There's a whole lot wrong with all the code in this thread. For example, the ELSE clause on OpenSeq can be taken even if the file is opened for writing. For the moment forget WriteSeq and try the echo command. filename = "myfilename" Cmd = "echo " : Dest : " >> " : file...

Not quite right. What's in field F1 is the next available key value. It's ordinarily one more than the number of records, provided that this is the only method used for maintaing the keys.

It is not possible. In this situation (a Transform and a Routine with the same name) the Transform is always selected. This harks back to the earliest versions of DataStage, where the only available way to invoke a Routine was via a Transform; often they had the same name. I guess it's been kept tha...

Can you open the file RT_BP3618/JOB.848242765.DT.1438049575.TRANS1 in your project directory and post a 20 line window centred on line number 443?

The Help topic is Defining Multirow Lookup for Reference Inputs

It's complete.

Specify the UNIX newline character as the delimiter. The easiest way to do this is to set up a user variable, and assign Char(10) to it, upstream of the StartLoop activity. Pass the value of StartLoopName.$Counter to the job as a parameter. This will contain the value of the current item from the lo...