DSXchange

what the message means is you have define some fixed width datatype - may be as char and the data coming has variable length.

What is the datatype for id? If it is char make it varchar and see if it works.

Here in your data you have data on which permutation and combination need to be executed. I guess it can not be done using XML stage. Using two XML stages you can separate out Action Value and Product value. Then create a lookup for Action value. In the lookup add a dummy column with value '1' and t...

Or else you can have full outer join on the stage. Then after the join using null handling conditions on columns from left data and right data you can filter data.

but using the PX transformer just for filtering - will it be a good idea if performance is considered to use transformer

Never used a wrapper. But like server job transformer, is the unix sheel script run is possile do it from thr?

Mainframe systems produce 'normal' files, too. :wink: Are you trying to ask if it is EBCDIC or has packed fields in it? Ya I ment EBCDIC file. I am aware that mainframe can generate a normal file as well so should have mentioned as EBCDIC earlier. If coming file from mainframe is normal one then ju...

If you have to do it using basic code / routine you can use DSGetJobInfo(Handle, DSJ.JOBELAPSED) . It will return the total time taken by the job. If you want it in some format you can use Oconv function as OConv(JonTimeInSec, 'MTS') . The aforesaid function will give you the details for last run. I...

If you remove the DSDetachJob line from the loop then also remove the following line:
hJob = DSAttachJob("MirsLoader_Test2":'.':Instance, DSJ.ERRNONE)

Sort stage in server has performance and other issues when it is applied on large number of rows. You can find all of them if you do a search on this forum for sort stage in server. On Unix environment, normally instead of using the sort stage, it is better to use the Unix SORT utility (means sort c...

If you could post the abort message and any warning related to this BAPI stage that would be helpful in understanding the problem!!

What type of file is this?

Is it a normal file that can be seen using cat command or vi editor? Or is getting generated from mainframe system.

CFF stage is used when the file is generated from MF system.

In one of our project, the number of jobs where more than 1000 and the problem we faced was the turn around time when u open the job or see the logs or try to access the repository thro' DS manager was very high.

I think a small code or script to clear the RT_STATUS files for the job could also be used. From the prev post, it seems it is RTI job and each time it is called, in status view of DS director it creates the multiple entries one for each instance. If you are able to have script for that, it will do ...

You can use the stage variables to preserve the value of the previous row. Define two stagevars - first is set to second stage var and second stage var set to direct mapping from column for which you want to preserve the prev value. Initialise them to empty. When this runs for the first time, in the...

The expected time depends on ur hardware.

Why u want to know the expected time in advance?
Run the in development env and u will get the exact time rather than spending time to calc or guess expected time to run.