DSXchange

Exotic Technologies Finish Road Test On Cosmic Highway. "We've taken these technologies around the test track, and now they're ready for the production line," said Dr. Marc Rayman, deputy mission manager and chief mission engineer for Deep Space 1 at NASA's Jet Propulsion Laboratory, Pasad...

Here is a C++ program you can use as parallel routine to remove non printable characters from an input string. ASCII character set range can be changed according to your preference by changing values for #define NP_RANGE_START 32 // change 32 to your value #define NP_RANGE_END 126 // change 126 to y...

This is not mandatory. A parallel routine can be without any input parameters.

ray.wurlod wrote:Try creating a routine with at least one input argument. DataStage expects to pass at least one value to a routine and get something back. ...

It is a parallel routine (External funtion). Not a - before/after job runtine. There shouldn't be any "limitation in priviliage of accessing datastage sever" in any case, something you might have to cross check. You have posted this in parallel forum, datastage parallel server does have al...

I have recently posted a parallel routine which exactly does what you need. If you search my previous posts you can find it, alternatively you can find the same in this LINK. Main highlights of this C++ function are: -->Creates and writes on a text file for each record. -->From a stream of sinlge so...

FLOOR(No_Of_Months/12) will give you years to be added/subtracted and
(No_Of_Months MOD 12) will give you months to be added/subtracted

This should give you the lead to your solution. A solution to subtract months is given in this LINK, tweak this code if you want to add, won't be that difficult.

I doubt if you can call DateFromJulianDay & JulianDayFromDate functions from a parallel routine even if you include the dsapi.h header file.

This works unless the incoming date is Feb 29, in which case you also need to subtract 1 from the day number.

ArndW wrote:Is the column type a string? If so, just use

Code: Select all

In.DateColumn[1,4]+6:In.DateCoumn[5,4]

...

Good to hear you finally managed to get it working. As noted repeatedly in the thread you should have used your APT_COMPLIEOPT ie. "-dalign -O -PIC -library=iostream -c" for compiling, instead of "-dalign -O -library = stdio ,stdlib -c" . So time for you to mark the thread as res...

Post your compiler and compiler option seperately.

And also confirm if you have compiled using the same syntax:

Compiler : compiler options : {filename with extenstion}

Does that Razz Emoticon means you got what you want?

Pls. post your compiler, compiler options ...

"-c" option is to compile the file and produce an object file. That shouldn't be the cause. Pls. post your compiler, compiler options and all the entries you made in the general tab of parallel routine.

You might not have made the right entries in the General tab for this parallel routine. Cross check "External subroutine name" entry. I have recently made a blog entry on Parallel routines, you can find that in this link

Pre-empt this situation. Use reject duplicate logic inside the DataStage job to move duplicate rows into reject file.

2631 error indicates that this can be a typical deadlock scenario - one transaction has a lock on a resource that another transaction is trying to obtain. Manual indicates: 1) an excessive number of transactions were queued waiting for locks and the user's request would have blocked on the lock queu...