DSXchange

chulett wrote:You need to make the project a 'Protected' project. And yes, via the Administrator.

I would like to do that only for a few specific important jobs in the project though.

Nope!!

How can you protect a job from being deleted. I know how to make them readonly, but not how to protect them from being deleted. Could something be done in the administrator command window? One solution I can think of is to somehow lock the jobs. As if someone is working on them. That way DataStage w...

Its happening again for this one sequencer. The Sequencer aborts with the foolowing message Job control process (pid 737344) has failed When I try to look into the PH folder, I see this message. DataStage Job 876 Phantom 24744 Program "DSD.GetStatus": Line 25, Read operation failure. Progr...

The problem seems to have gone away lately. I cleaned up the project and rebuilt indices. I dont think its linked to my problem, but getting rid of a lot of junk in the project seems to have helped.
Thanks for all your inputs.
Jay

Hello all, We have a few jobs in our project that seem to abort at random. When I digged into the &PH& folder messages, I saw the following. Any ideas on why the log file has trouble getting written. I was wondering if some other person running the same job might belong to a different unix u...

Hi, I just found out that , I was unable to copy the contents in the data browser for more than one row. In version 7.0 I was able to just drag the cursor and do CTRL+C and paste it in excel spread sheets. Now we have 7.5 and I am unable to do the same. Did someone face the same issue? Is this a new...

A better example would be IF @TRUE THEN * Column derivation code for pin DSLink5 Pin%%V0S4P2.Column%%1 = (Pin%%V0S4P1.Column%%1 : 10) Pin%%V0S4P2.Column%%2 = (testroutine("")) Pin%%V0S4P2.Column%%3 = (testroutine("")) Pin%%V0S4P2.Column%%4 = (TestRout("1")) Pin%%V0S4P2....

I have a question on a way to reverse engineer the RT_BPxxx transformer code. Heres a small chunk of code IF @TRUE THEN * Column derivation code for pin DSLink7 Pin%%V0S4P3.Column%%1 = (Pin%%V0S4P1.Column%%1 : 10) Pin%%V0S4P3.Column%%3 = (testroutine("")) Pin%%V0S4P3.Column%%4 = (TestRout(...

Only using proprietary, undocumented, and unsupported library information will allow you to do what you want, and word is that the internal repository design is about to change (again) rendering these hacks useless in future releases. In order to get the column name, you must resolve the internal s...

My assumption was that all routines are called as 'by Value' and not 'by Reference'. Hence the value provided to a function may not be used to trace its origin column. You need to specifically use 'COMMON' method to deterime a common reference. Having said that, I assume that there can be some poss...

Try IConv with MCN option to report on the numbers. If MC/N format returns a blank, then your field does not contain any non-numeric character. You can use the status to confirm the conversion. To obtain the column name, maybe you can embed the incoming column that you plan to use for data clensing...

Hi, I am planning to write a function which when called in it's derivation will return the column name. The function takes no arguments. I was wondering if its possible through DataStage run time variables to do that and any pointers on how. My main objective is to write a function, which converts n...

The lookup goes to the transformer. Formating issues I guess:)

Hi, I have a job design looking like this Source(Table A) ----> Transformer----->Target (File) ^ | | Look Up (Table A) Table A has a single Key column and theres another column at the end called indicator which can be Y or N. I would like to remove the records with indicator N which are an exact cop...