DSXchange

Hi Alexander, Thank you. Your solution is interesting, but I also need to execute sum and division. I have a routine in basic (in DataStage) and it would like this validation in QualityStage. Function valCPF(cpf) Dim VetNum(11) numCpf = fmt(cpf,"11'0'R") For count = 1 to 11 VetNum(count) =...

I need to store the result of a multiplication in a variable. COPY " 3 " tmp1 COPY " 4 " tmp2 [tmp1 * tmp2] = result Is it possible to do this in QualityStage? I verified in the documentation of the Pattern-Action Language that is possible to execute a multiplication, but I didn'...

Really, it is not necessary to remove the decimal point (.) and the negative sign (-).

Yes.
You can to use the Ereplace Function for to remove decimal point (.) and negative sign (-), before of to check if the value is numeric.

You can to use the NUM function (BASIC) for to check if the value is numeric.

Hi The code for DSMakeJobReport can be acquired in Server Job Developer's Guide Sample: $include DSINCLUDE JOBCONTROL.H JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) If NOT(JobHandle ) Then Call DSLogFatal("Job not exists!", "JobControl") Abort End Ans = DSMakeJobReport(JobHand...

Job control fatal error (-14) (DSRunJob) Job "Name" appears not to have started after 60 secs The error -14 happens when the server is overloaded in some intervals. The parameter regarding the time of 60 seconds no there is as being altered. There are some parameters of the file uvconfig ...

In some of the DSN entries (eg: BRSPOWSQLA20_ISMBA) confirm if you are using to connect to SQL Server you will find a string like this QEWSD=38568 Where the number can be different. This line is added to the DSN when you use the odbc drivers with non-datastage applications. I have seen few other cas...

Hi ashokyadav

No, this variable be defined in stage transformer.

Use stage variables on sorted data.
Ex.: varEmp (@Null) := RowProcGetPreviousValue(ENTRADA.id)
varSeq (0) := if ENTRADA.id = varEmp then varSeq +1 else 1
--------------------------------------------------------
Target id_key := ENTRADA.id : varSeq