DSXchange

Hello all, Given a sequence name, I need to query all the job names inside that sequence and its subsequences. I know this has been asked before, I did my homework by searching and reading the related posts. There are two possible approaches, right? 1.- To use a transform routine issuing a SELECT fr...

I modified my after-job subroutine as mddw08 suggested. JobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) Comandd = "touch " :SomePath: "\" :JobName: ".OK" Call DSExecute("DOS", Command, Output, Result) And, checked On the "Only run after-job subroutine on succe...

I need to create an empty file when a Job has finished OK. I was trying with an After Job Routine, but the function DSGetJobInfo(DSJ.ME, DSJ.JOBSTATUS) always returns DSJS_RUNNING and I am expecting DSJS_RUNOK. So, DataStage considers the After Job routine as part of the job process, right? Any idea...

It wouldn't install, for 64 bit linux,t he installation process requires that you first install DB2 9.1 64 bit for linux, and WAS (with some patches) for 64 bit linux. then do the IS installation. - The only thing that I have been able to install is the metadata repository (and if I do it separately...

Hello,

I'm currently in the middle of the process of installing 8.0.1 on Suse linux 10, and i'm having some trouble (installing the domain layer), i would very much appreciate to hear of the stability problemas on linux for version 8.0.x

regards

Hi, Is there such thing as bulk select and insert in DataStage? I have something like: SELECT from remote DB --> transformer --> INSERT to DW I noticed that the records are one by one going through the transformer, then to INSERT stage. I find this very slow. Is it possible to bulk colelct them bef...

This is how we solve it: - Changed the before job subroutine to a Transform routine. - Created a Job Sequence with two stages: Routine_Activity and Job_Activity. - From the routine activity stage we are calling the transform function. - Used the Routine Activity Return Value as "value expressio...

@Krazykoolrohit: Thank you, we are considering your suggestion. 1) You can't use a parameter in a parameter. You said this because of the syntax I am using in the default value: #@USER0# Right? 2) You can't set the value of a parameter 'before job' as the job has already started. It's not as before ...

I have a before job subroutine function which does an ODBC connection and then query a table to get a date based on some values given by the user. This date is then used along the entire job. Inside the function I have this assignments: Errcode1 = SQLBindCol(hStmt, 1, SQL.B.DEFAULT, res1) ** ... (mo...

Hello, After several tests and reading I achieved what I needed. Developing ray.wurlod's suggestion I am using the CREATE TABLE statement to generate the hashed files. It was not easy because of my poor knowledge of the UniVerse interface. Here are some basic tips for those who may need them. - From...

Yes, through ExecUV in the former case and DSExecute in the latter. Is it possible to run this routine to create the hashed file from outside a Job?, i mean, through an API or something like that? Regards Edit: I am currently reading the Universe System Description manual, so I will probably have a...

I appreciate your answers and time. Although, we tested the workarounds you provided, we insisted with our Support Provider about this being a bug (probably the right term is something like "not implemented feature)" in DataStage. They said that IBM is working in a patch which, among other...

Hello all, thank you for your answers. My support provider did not give a useful response. So, we are using chulett's suggestion: Generate the sql, copy it to the clipboard, paste into your editor of choice, make the schema change, switch the stage to Custom SQL and then paste your tweaked version i...

Please excuse me for bringing up this old thread. I am hoping that someone could explain some doubts I have about ray.wurlod post: I would have created the hashed file with CREATE TABLE, which builds the dictionary for you. Is it possible? When you create a table a hashed file is created? It looks m...

Yes, of course

I am just giving some extra time to my "support provider" to post here their answer (in case they find any and it is different from yours).

Same goes for my other thread: OCI Date Conversion Failed.