DSXchange

Hi, Use sqlplus -s to suppress unnecessary messages. Instead of Execute command activity,call a server routine from user variable activity. in the server routine,do following : cmd= "sqlplus -s userid/passwd@server Your query" Call DSExecute("UNIX",cmd,Output,Returnval) *Now comp...

the string is like in the source data " abcde 1234 efgh 45678 nmhj 7895 ". i want to convert in target like "abcde efgh " ie remove numeric values Use the Convert function in the transformer to convert the numbers. Syntax : Convert(%fromlist%,%tolist%,%expression%) For example t...

Hi, Add a "Nested condition activity" after the execute commadn activity. You can check the value reurned by the execute command activity by using "activityname.$ReturnValue" in nested condition activity. Check the value returned by "activityname.$ReturnValue" in case o...

Compiling a job generates the OSH.If a job is reset,the OSH is not created.After reseting a job,it comes into "runable" state.

Note:If a job is recompiled,OSH is generated only for the changed components.

Thanks chulett!

Hi,
what is difference between compile and force compile?I tried searching the forum for this.

The plot thickens.... The customer wants to ensure that only the instances pertaining to the log purge settings are removed. i.e. I remove only the instances RT_STATUS older than 5 days. RT_LOG entries have already been removed using the Auto Purge Using Ray's modified code I have generated these r...

chulett wrote:Automatically? No, not that I've seen. You can manually copy over the message handler file itself, however. ...

Thanks chulett.
please tell me the steps to be taken to copy the message handler file.
where are the message handler files saved?

Hi,
I suppress certain warnings using message handler.The problem is when i export and import the dsx of the job from one environment to another,the warnings appear again.I have to suppress the warnings again.

Is there any way to retain the settings of message handlers during export of datastage job?

ArndW wrote:P0 and P1 are partitions 0 and 1, "OP" are operators. The confusions stems from a sequential operator that doesn't run on both nodes and operator combination of stages at runtime. ...

Thanks ArndW.Just one doubt is how the number of processes can be calculated from the given OSH?

Hi, While reading the "Parallel job advenced user guide" , i came across following OSH : ##I TFSC 004000 14:51:50(000) <main_program> This step has 1 dataset: ds0: {op0[1p] (sequential generator) eOther(APT_HashPartitioner { key={ value=a } })->eCollectAny op1[2p] (parallel APT_CombinedOpe...