DSXchange

you can do it with unix commands in the after job subroutine.

Thanks craig.

yes these jobs were run by the current sequence. a execute command activity is triggering a dsjob command. in which the job name is a parameter. dsjob -run -wait PRJ #jobname# and based on teh status we have to trigger the flow of activities. Now we have two options 1.we can use the retun of the dsj...

Yes it is a user defined routine with JobHandle=DSAttachJob(JobName,DSJ.ERRWARN) status=DSGetJobInfo(JobHandle,DSJ.JOBSTATUS) Ans=status inside it. i want to use this routine on the trigger to decide the flow of teh sequence. As of now i am using a routine activity.It is working fine. but when i use...

Hi,

Is there any way we can use a routine in a trigger.

Without geting the routine is not dimensioned.

I went through a lot of posts regarding this but only found out that it cannot be done.


Regards,
Samyam

You can see the file name in the logs if it is used as a parameter.
Open the job and see if it is hard coded.

yes the stgvar2 is mapped to the out put.
If you want to use for a value not present use another stgvar to verify that and put zero instead.

ar eyou using a transformer stage in the job?

remove them inside the job. what are the stage you are using.
If there is a transformer stage you can easily remove it.

You take three stage variables.

stgvar1 = key column
stgvar2 = if stgvar1=stgvar3 then columnname:',':stgvar2 else ''
stgvar3 = stgvar1

now as long as the key columns are same it will keep appending.

make sure you sort the data on the key column and the transformer runs in a sequential mode.

using functions the same you are doing above.
But instead of one variable create two variables and use them the file stage

in the file name do not give colon ':'

Or create two variable one for date and one for time and use it as in the sequential file stage.

#PATH#'/'#FILENAME##DATE#'_'#TIME#

this should work

Use the trnasformer stage to do the vertical pivot.

Based on the key column.
If the value in the key column is same then append det_10_sal:',':Dept_20_sal and so till the key columns value changes.

You can use the tr command in a wrapper stage. for the column.

But for this you need to know the ASCII valuer of the special character.

viewtopic.php?t=135278&highlight=dsjobobjects+record

you might have to impovise on this one.