DSXchange

The second column in your result set (in the SELECT clause) is not included in the GROUP BY part of the query or does not have a set function applied to it. But there's no reason to group; ORDER BY will work as well. Thus there are three possible solutions. I prefer the first. The others may need fi...

Read the help on each, then tell me whether you discern any difference!

Seems to me that your best solution is a similar Job Sequence, but one which does not change the dates. Or, even better, runs a different routine to get the date parameter values from the log for the previous invocation of the job. In a production environment you should have no jobs or job sequences...

Can't you simply omit and EVAL DS_JOBOBJECTS."@RECORD<6>" = 'MyHashFileName' so that all hashed file names are considered?

Try
0x30 (48 decimal) is the ASCII code for "0", 0x31 (49 decimal) is the ASCII code for "1".

And creation of custom code.

And specialised diagnosis services.

And a few others I'm too lazy (tired) to type up just now!

Part of what makes sftp secure is that it does not allow redirection when supplying the password. You could try a "here script" (I've not done this so could not be certain). ftp $FTPHOST << -nomore $FTPUID $FTPPWD # other FTP instructions go here QUIT -nomore In this example I have used environment ...

Good catch! I completely did not see that one. A blind spot, obviously.

But the lack of reject handling will continue to generate warnings too.

I'm fully booked through to March. What you're seeking, and what we've made clear from our answers thus far to be a very difficult task to perform and requiring expert analysis, is not something that you would ordinarily expect to get for free. Would someone (some expert) volunteer to tune your data...

We needed one because we used a non-default port number. It's expected to be in the QualityStage installation directory's bin sub-directory. $ find . -name mngr.cfg -print 2>/dev/null ./QualityStage/bin/mngr.cfg $ more ./QualityStage/bin/mngr.cfg # Quality Stage Real Time Manager Configuration File ...

I don't believe that validating jobs will create SDKSequences. This is because it is not represented as a stage in the job design. A better way to ensure that SDKSequences exists is to test one of the SDK Key Management routines. Open the routine, click the Test button, and fill in any value for the...

I believe the check is to determine whether the table is partitioned.

Is there any reason why your DBA won't grant SELECT privilege? It's an entirely harmless privilege.

Well you've got a bit more. Row 10 is the culprit. Take a look at the data in row 10 of the load file, and see whether you can figure out why it can not be inserted. Perhaps a duplicate key value? Perhaps an invalidly formed date?

A useful tool to know about is the oerr command, which can be used from the operating system prompt to determine the cause, and often a remedy, for a given error code. $ oerr ORA 604 00604, 00000, "error occurred at recursive SQL level %s" // *Cause: An error occurred while processing a re...

The number of reject datasets "0"is less than the number of input datasets "1". This message is telling you that a DataStage PX design requires at least the same number of reject datasets as you have input datasets, even though the reject dataset may not be used, you have to specify it "just in cas...