DSXchange

I keep on forgetting that INCLUDE in user-written routines, thanks for catching that.

The implicit conversion cannot deal with spaces, which your CHAR() column most certainly has. I would use an explicit TRIM and StringToDecimal call to avoid all warnings and errors. I am not at a DataStage computer where I can check the syntax of these calls, but the Parallel Job Developers guide wi...

In your case you could keep the job unchanged and just add to your job sequence. I tried an example using UserVariablesActivity at V8 and got an error message on DSAttachJob() so suggest you create a small 3-liner server routine: GetJobRowCount(JobName,StageName,LinkName) JobHandle = DSAttachJob(Job...

I would start with your PX job - how does it determine validation? One very simple method that you can use from your calling Sequence job is to call DSGetLinkInfo() to get the number of rows that went down a named link - you can use that number for your row count and if the number is 0 then your val...

DataStage supports ODBC and there are various drivers out there, either one can buy it from IBM, another software vendor, or use free software for LINUX.

Welcome to DSXchange, Steve. What would be an example of your validation job's return value? Is it a simple Yes/No, a string of some type or some other structure? Depending upon how this value is computed you can use the job status or user status to return information to the calling sequence; or you...

There are quite a few out there, my google search for "free LINUX Excel ODBC driver" returned over 70,000 pages. I haven't had to use any in production so couldn't recommend any particular one. The easiest way would be to use a .csv format for the Excel sheet - that way it can be processed...

If you add the SQL code to your reject, what does it show? I don't see what the stage could be returning, since your table has no unique key it will never execute the "update" option but always perform inserts and that shouldn't be erroring.

Remember that the STOP call in the director and from DS/BASIC code doesn't directly terminate any process, it merely sets a flag. DataStage programs all have checks for this flag built into them, and they terminate themselves cleanly when they detect that flag. Sometimes DataStage jobs get 'hung' in...

(I'm depressed, I wrote a long post and it has disappeared, and now I'm out of steam to re-write it...) Don't touch your job or system until you know where your bottleneck is. You will need to measure and analyse what your system is doing before making any changes; otherwise you might cause everythi...

So the logic is: (a) If the first column is NULL, then use the value from the previous row's first column instead of the NULL. (b) If the second column is NULL; then use the value from the current row's first column instead of the NULL. If that is correct, then use 2 stage variables as follows: svNe...

Could you FTP the input file from one machine to the other and do a "diff" command - perhaps the size is the same but the contents different. If you can't copy the file over, perhaps you have "md5sum" installed and can compare hashes.

I should add that I did a quickie bubble sort last week and just used that code, but I was interested in how I would solve the range logic and happened to have a designer open. I'm not sure what you mean by "have issues with string like one discreet chain". The code uses the variables &quo...

I have had a tough day at work doing some complex modifications and needed a break, so I wrote a quite BASIC routine to do this. If you use a BASIC transform stage and call up MakeRangeString(InString) **************************************************************************************************...

While it true that the join uses much less memory with similar lookup data volumes than a lookup stage, the conclusion that this is why it is faster is not necessarily true. On a system which would otherwise not use the additional memory required by a lookup stage it would make little difference, If...