DSXchange

Chaining records is easily done with delimited strings in stage variables. I prefer to use server job or BASIC Transformer and work with dynamic arrays in this case, because there is a really handy function called Locate() - and another called Find() - that can be used to search for a value in a dyn...

How have you confirmed the record count in the Data Set?

Delightful cleanly written and formatted code. Well done and thank you.

Alas, you don't delete logs. They're not files. They are rows in database tables, one table per job. You could enable auto-purge, but that would only effect jobs created subsequently. Otherwise you could change the //PURGE.SETTINGS entry in each log table so that auto-purge could kick in next time e...

So you are seeking the complete list of transitions for any input value, through to the endpoint of that list. Does that sound correct?

Big Data support ((stage)) in DataStage version 8.7 supports Hadoop file system, but otherwise looks and feels (deliberately) like Sequential File stage.

Read in on-line help or manuals about end-of-wave treatment. I think this will answer your questions.

Could COB_COMMENT be (contain) a null-terminated string?

There is a specific driver for MySQL. Look at the prototype supplied in $ODBCINI.

Have the reports been published?

or, better, initialize stage variables to the results of the two Char() functions

You need to poll interrogating job status until job status is no longer DSJS.RUNNING.

Did you Search DSXchange for an answer?
This post has three different techniques.

We're informed that you would choose ODBC Connector, because IBM wants you to prefer Connector technology going forward.

That works. Execute it from an Execute Command activity in a sequence and use the output of that directly to provide the value to a job parameter in a Job activity.