DSXchange

In version 8.7 you can encrypt the password using the encrypt.sh utility and use that encrypted password directly on the dsjob command line or in the file referred to by that command's -file option.

Welcome aboard. It's quite complex. Follow the instructions in the manual (or in Information Center) absolutely.

Ray, I'm confused as to why you mention a dataset not taking an input and output in the same job - my proposal using a dataset specifically stated two jobs, one to read the source and produce a dataset, then a second to read that dataset into a database. The image had a Data Set with an input and a...

The Data Set stage does not support input and output links in the same job.

A better approach would be to use a sequence to prevent the job from executing if the file is not present.

Despite the fact that you have four nodes, you only have two scratchdisk directories, so there may be some contention for them. Better performance would be had with four scratchdisk directories (on separate file systems unless your disks are part of a SAN). Even better would be eight scratchdisk dir...

I would have expected to see that, if that's what it is, sooner than 7 million rows in.

The original poster being in the UAE, I would expect that all of the data are Arabic and an appropriate NLS map to be in use (hence the number of successful rows).

It's a bit different than Arkansas!

Sala'am and welcome.

"Heap allocation failed" usually indicates that you've run out of memory or scratch disk space. To confirm, monitor these things while attempting to load.

Is this problem repeatable? What other load is on the systems?

Check that everything is running:

• repository database
  
  WebSphere Application Server
  
  ASB agent and logging agent
  
  DataStage services

As far as I know, the behaviour of a job activity is always to replace. If the value in the job activity is empty, then "" will be supplied to the job. This may prove to be invalid (for example for an Integer parameter type). That's why the Job activity has "Set to Default" and &...

Welcome aboard.

There are no DataStage credentials (or Engine credentials as they are now known).

You must create at least one.

Replace :TAG: (which is a placeholder) with an appropriate name, so that the column names are complete. Then import the COBOL FD.

You may need to remove the RECORD TYPE 4 DATA header or change it into a comment.

The list of parameter names in a job activity is populated from the job referred to. The only way you can delete the parameter is to delete it in the job itself. A job activity can only pass an entire set of parameters to a job. You could use dsjob in an Execute Command activity if you want to pass ...

Matches operator and MatchField() function allow for multiple patterns in a value mark delimited list.

I think so too. What does your official support provider advise?

What's the rule if all rows in a group (for a given key) have null in the specific field?