DSXchange

The Editor's Corner isn't the right place to post this question. In Server there is a BCI interface for calling external subroutines, but it is a complicated procedure and it is easier to write a program that accepts command line arguments and to call that from DataStage. In PX you can write your ow...

If you are not using the bulk loader, then check what your commit frequency is.

Often this is because your userid in DB/2 doesn't have sufficient access rights to read the table metadata. I am assuming that you have set up DataStage PX access correctly since it does work in another project.

It sounds as if you have a commit frequency of 1000 or a smaller number that divides evenly into 1000. Oh, wait - you are using the bulk loader? This is particularly fast because it doesn't care about rollback or constraints, so you can't back out.

Greg - did you actually monitor the values while you were running your job, not before and then after? A "broken pipe" is just a symptom of a process having stopped. I don't know what hardware you are running, but even a small machine should handle this type of query.

(Strange, I could have sworn that I posted something on this thread, yet it seems to have disappeared. Oh well, the post was leading in the wrong direction if this new error is any indication) Have you tried logging in as another user and compiling? Just to make sure that this isn't actually a permi...

In PX you could build your own random/pseudo-random method to do this in various ways. You could write a buildop to get a real c++ random function with all the advantages that has (repeatability, real pseudo-random distribution, etc.) or you could do something simple like take the current time milli...

A job with just an annotation and nothing else will not compile. What is usually the case when you see nothing on the canvas is that the actual work of the job is done in the Job Control section; often this is seen in older jobs that pre-date sequences. Look at your job control and you will probably...

Congratulations! Do you think that having been on DSXchange helped you in any way to prepare for the test?

It might be that some temporary space is being used and filling up that device. Could you monitor your TEMP directory set in DS and also /tmp (some stages might still be hardcoded to the system default directory) and see if that might be causing your issues?

I...Since Datastage for some reason does not have this function... I beg to differ. Try searching the PDF BASIC Programmer's Guide for "substring" and you'd be surprised how many different ways there are to do this. The simplest and most common method of positional substrings in DataStage Server (a...

Could you post your exact command stage command for invoking the job - the message makes it likely that you have a syntax error in that command.

It will have created 6 files that you need to delete in that directory. The files/directories are:

&SAVEDLISTS&
D_VOC
VOC
D_&SAVEDLISTS&
D_VOCLIB
VOCLIB

Does the job do any other writing to files? If I understood you correctly, your job aborted but some prt of it was still running for 12 hours after the abort message?

With ICONV/OCONV use the MX format for hexadecimal, MB for binary.