DSXchange

Thanks for your reply. It is for a routine I use to execute my job sequencers. The routine sets parameters from a file, excute the job sequencer, gather stats and logs. The thing is that I want my DS modules to be portable on other servers and projects. Hence, I need a variable that tells my routine...

Hi all,

Does anybody know if there is a way to access a DS environment variable inside a Basic routine?

Thanks

Mat

Hi Nitin, Here's how we run our sequences: 1. We build a first sequencer with the jobs we want to run. 2. We make another sequencer containing only two routines. the first one runs the sequencer #1 (setting the parameters, gathering stats, etc.) The second one waits for the first sequencer to end an...

Hi, Regarding the PX side of the problem, remember that every partion will open a connection to your DataBase. You must therefore make sure that your records are well partitioned. A deadlock may occur if more than one process tries to access the same records. Make sure that your PX partion respects ...

Hi, We had a similar problem some time ago. If I understand your problem: Your sequencer finishes fine (status = OK) even if a job inside aborts. This is normal because the sequencer is not affected by the ending status of included jobs. What we did was use a routine after each sequencer to scan the...

Oookayyyy.... I'm sorry but it's out of my league. I don't know a lot about Solaris. But if someone from your team can compile a job with a transformer on the same server and in the same project...... Then I think your client is the most possible suspect. Have you tried to reinstall the client on yo...

Hi Tunde,

I encountered a similar problem with PX. Are you running AIX? If yes, check your c++ compiler, it needs a patch available from IBM.

check the release note for DS 6.0

HTH

MAT

Hi Tunde,

PX has a stage called Column Generator, we used it for generating our surrogate keys. You can even make it assign keys in parallel. Since you can't use a routine, this was the best we found.

MAT

Hi Sanjay, The Parallelism you can achieve differs depending on what Engine you are using. With DS Server, you can start multiple jobs at the same time. If you want your jobs to run in parallel (from the software). You only have to start more than one job before you wait for a job to finish. More sp...

A very big thank you for your answers. All that's left now is for me to get to work.

MAT

Hi, I don't know MetaStage :oops: but I have to install it and make it operationnel. How much time should I estimate is required for the following activities :idea: : - Installation, - Connection (Erwin4.1, Oracle), - Configuration, - Generate Report, - Test, ... Thanks for your help.

The Answer is :[:p] .dml label tdmload; UPDATE #ThisDataBase#.#Table# SET EMAIL_ADDR = :EMAIL_ADDR, MOD_DT_TM = current_timestamp WHERE CUST_ACCT_ID = :CUST_ACCT_ID; .import INFILE #FilePath#/Dly/multiload/xxx format fastload layout internal apply tdmload; with xxx : name of your stage. And the fiel...

I will check it.

Thanks

Hi Everybody,

In the Report Assistant option under Manager we can
produce a report, we can print it, we can can do a print
preview, but is there a way to capture the report and
save it in a file?

Thanks for your knowledge,

MAT

Hi all, I have a question for Ray regarding the post he made earlier about read-only jobs. We want to ship the projects we are developping to our clients and tester in read-only mode. The easiest way to do that would be with the use of Version Control but the managers do not want us to use anything ...