DSXchange

We regularly create and deploy DataStage projects from version control as part of a suite of Continuous Delivery and DevOps tools. This process handles project level settings by capturing the DSParams file but we have recently discovered that this does not include NLS settings. I'm aware of the DSNL...

I've done similar logic in 7.5 without a pivot in the past. Can't remember the exact logic. If you leave each CSV record as a string, you can use a column import to pack each field into an array (or was it a vector column). Once in this format, you can use a combination of he restructure stages (inc...

Hi all, I found a rather sneaky work around that will allow me to use the built in checkpoint routines with custom job control. As stated in my previous post, you can use the DSCheckpoint* routines (as used by restartable sequences) in Custom Job Control/Batch job. Unfortunately I've found this to b...

Thanks for your responses guys. There are two reasons why I'm trying to get the controller handle. The first is some simple info/warn messages which I want to pass to the controller. The API provides a built in log to controller function but this is only for info messages, not warnings. Ray's code p...

Hi all, I'm writing some custom Job Control and I need to be able to get the handle of a job's controller. Sounds easy right? Using the GetJobInfo to get the name of the Controller works as advertised, but I also need the controller's instance id so that I can attach to the correct instance of the j...

Hi all, We are using Kenneth Bland's compile all job control as part of our deployment process. Works great if we deploy to a fresh project, but jobs will fail with errors related to Transformer .o files when deploying to an existing project. When these errors occur, a force compile from the client ...

Thanks ray, probably sound advice. I was just about to start use XP in a VM when I discovered the problem. Turns out this wasn't a vista problem at all and could occur on older windows as well. Dunno why, but Dell (or some software that gets installed on them at the factory) changes a registry setti...

Hi all, I'm having the same problem. I've tried disabling Aero and using various compatability modes but have had no luck. I did some investigation and it looks like DS executes another application (vmdsflt.exe) to display the popup box causing the issue. You can avoid closing the designer by killin...

Thanks Chutlett, The full routine includes WHENEVER OSERROR EXIT 1 WHENEVER SQLERROR EXIT 1 Anyway, the issues has been resolved. Our environment actually has two databases, only one of which was causing the error. Turns out the Environment support guys only tested one database from the command line...

Thanks for your response guys, As stated the shown DS code is a cut down version of what we are actually using. The real code has a debug switch to log information at all steps using DSLogInfo. This is why I'm sure what I've executed manually was EXACTLY the same as what is performed in DS Basic. Al...

Hi guys, We are in the process of migrating our DS jobs from our Dev and testing environments to our SVT/PROD environments. However, in doing so we seem to have uncovered a rather baffling problem when trying to execute sqlplus from DS basic using DSExecute. Here is a cut down version of our Execute...

Hi guys, We are using the Oracle Enterprise stage and the Direct path data loading. Our tables have indexes and are partitioned so we use the maintenance index mode. Since this implies the oracle options DIRECT=TRUE and PARALLEL=FALSE, how should we be setting up partitioning in DataStage? Currently...

Thanks guys for helpful answers! The the DS Engine will free the returned char array, well that makes life a little easier then. Is there any way I can get DS to out put the generated C code for a given transformer? I'm generally a curious fellow when it comes to things like this and would love to s...

On the topic of memory allocation within a DataStage px routine, I found this example px routine (thanks DSguru2B) #include "stdio.h" #include "string.h" #include "stdlib.h" char* pxEreplace(char *str, char *subStr, char *rep, int num, int beg) { char *result = (char *)...

Hi all, I'm just about to start experimenting with DataStage Parallel routines. Before working with DataStage, C and C++ were my primary languages of choice and I'm therefore quite comfortable in writing a px routine. However, I've done a bit of reading of the DS manuals and some of the threads in t...