DSXchange

RCP is disables in our environment , I was checking if there was any other workaround .

Thanks

There is no reject option in DB2 connector , you have to select the reject link and in the column definition all it shows are the error codes no input column , so the rejected records only have the error code but not the rejected data . Putting the reject link through transform doesnt make any diffe...

I am trying to capture the records rejected while loading a db2 table due to a unique key violation error . The DB2 Connector stage is rejecting the records when array size and record size are set to 1, but the rejected records only has error_code and error_text , it doesn't show the rejected record...

Hello , I have a requirement to convert the decimals values (generated as an output of aggregator ) to standarformat of xx.xx. Example : .32 -> 00.32 -1.5 -> -01.50 8 -> 00.80 I can do this in sql query , but as soon as the data gets processed by datastage aggregator , the decimal formatting just va...

Create a work table, load the list of values there, join with your table. ... Could you please elaborate the logic. Which part is unclear? Your p ... Not able to view the whole message. How do I join to work table and populate files which is not clear to me. Example: My list file has 50 dept. numbe...

srinivas.g wrote:Or you can use Allow multiple instance option

Could you please explain me how to run the multiple instance sequence for the dynamic list of values.

Thanks

chulett wrote:Create a work table, load the list of values there, join with your table. ...

Could you please elaborate the logic.

Thanks.

Need an approach to implement multiple files creation based on values which are dynamic. The value is used in SELECT clause of a query. Have to create all the files parallel. Used loop activity stage which is consuming more time because it takes one value at a time and runs the query. Example: SELEC...

Resolved.

There are some 15-20 SAP BW Pack Load jobs which are triggered by SAP developers manually. For these jobs, if aborted, the subroutine should reset the jobs for the next run instead of SAP developers doing it. For this requirement, need to write a subroutine and call it in before/after job subroutine...

I am calling this routine in before job subroutine and passing input value as jobname. But the job state still shows running in the director log.

Please need help or share code to perform the task.

Ray,

Not a premium member so couldn't see your whole message.

Appreciate your help guys.

Hi, Need help in resolving after job subroutine to reset a failed individual job. Requirement is not to use sequencers. Calling this routine in after job subroutine. But job aborts and doesn't reset itself. In the director state of the job is still running. $INCLUDE DSINCLUDE DSJ_XFUNCS.H $INCLUDE D...

Hi I am trying to call a multi instance job with the same invocation Id used to run the calling multi instance sub - batch job. while calling the job from sub batch I tried to use the code hJob10 = DSAttachJob("EOA1010LdIncidentTable.DSJobInvocationId", DSJ.ERRFATAL) If NOT(hJob10) Then Ca...

Can DataStage operator log onto DataStage designer.

this is resolved.

its bcoz of bad data.
when the data is is reloaded it started working fine.