DSXchange

I've got a job that takes a parameter value ToDate (string), which determines which date to fetch data for from the source DB, which is Oracle 9. So there is a condition at the end of the SQL statement in the following fashion: Select <columns> From <tables> Where <conditions> AND ToDate = to_date('...

I'm implementing a number of jobs on a pretty 'standard' working environment. I.e there's a development server, a test server and a production server (well, the production server's not there yet but it will be in a while). Jobs are moved between the servers using Version Control, in a standardized w...

On a closer look, the Dependencies tab does seem to get maintained automatically for Job Sequences as well (just had a look at my sequences), but that still wasn't reflected in that Version Control chose to include in the initialization...

OK, I didn't realise I had to maintain the Dependencies grid myself, seems like something that definitely should be automatic - or nonexistent... Anyway, it's not a huge problem, I just got confused since the documentation for Version Control stated that using Get Dependent Components was the 'norma...

I'm to use Version Control and just started initializing a number of components to the Version Project that has been set up. The documentation recommends using the 'Get Dependent Components' option, which does seem like a good idea. According to the manual it should make all used jobs, routines, tab...

Yes I've noticed that a job name has to be unique within the entire repository. Still the Categories information has to be stored somewhere in order for the repository to be presented as it is with the jobs placed in a folder structure. In my case the Category affects one attribute in the Data Dicti...

Actually, one thing that strikes me is that there seems to be no way of getting information about which category (i.e. which folder in the folder structure) a certain job belongs to. In my present solution I'm using DSGetProjectInfo(DSJ.JOBLIST) and then filter out the relevant jobs to add in the Da...

True - I forgot Ray whom I've also been helped by previously, respect to you too if you happen to be reading this! ;-) About DSAttach, it does say in the documentation that a job cannot Attach to itself so I wouldn't try it on purpose, but I guess it would be better if attempting to do so resulted i...

Arnd and Kim I'm very thankful for all opinions from both of you - so far my experience is that you are two main authorities on Data Stage on this forum (and I'm not saying this to suck up to you - well, not only at least... :? ) The job I'm creating at the moment is not something that will be run r...

Yeah, well I'm not really surprised since I've done a fair bit of C programming. But the examples included in the repository are perhaps too simple since the ones I looked in at least didn't contain any header file references. But now that I know at least that's a mistake I won't have to repeat. At ...

Thanks a heap Craig!

That seems to have solved my problem; I figured I needed to include some file like that but since my experience with the BASIC programming is still limited I wasn't sure of precisely what.

You made my day!

/Stef

Thanks for the reply Arnd. It doesn't seem however that I can use that type of code just like that in a Transform Function. When I do the compiler returns the following: Compiling: Source = 'DSU_BP/DSU.GetJobDescription', Object = 'DSU_BP.O/DSU.GetJobDescription' * Array 'DSAttachJob' never dimensio...

I'm putting all jobs in a project into a Data Dictionary table defined by ourselves in a schema in the data warehouse we're building. Getting all the jobnames in the project using DSGetProjectInfo is no problem, getting info for each job in the way I'd like to is though. I just want to send all the ...

You might be able to use the CONVERT function, like I've recently done but in the 'opposite' direction (I wanted to convert comma to line feed). Since CR is not a character you can type into a derivation field you also need to use the CHAR function and feed it with the ASCII number for CR (13). So t...

Found it - thanks! (Didn't realise it was regarded a plugin since the stage existed within Designer...) However I'm still not sure how to import the procedure definition. Import->Plugin meta data->Oracle 9 alternative only appears to load tables and views. And the import->stored procedures appears t...