DSXchange

Surely, since this is a vendor recommendation, you should ask this question of the vendor (through your support provider of course).

parvathi wrote:while inserting the records getting warnings like inserted value too large for a coumn..... How should we solve this problem

The same way you'd solve the problem of getting six litres into a five litre container! Less data or bigger container.

chulett wrote:Can you say 'Shites' here? Hmm... guess so. I'll have to check it out.

Then you might like the "strict standards" enforced at the The Manly Daily ( newspaper in Sydney, Australia), which reported last week that Senator Bill Heffernan had rejected certain allegations as "b--lshit".

Bah. Everyone does t-shirts. Headbands. Mutant ninja developer!

The "user status area" is actually a field in the resource record in RT_STATUSnnn. So it *should* be separately preserved for multiple invocations.

Cumbersome. Parallel Transformer supports the [,] syntax. Choose Substring from the operator menu in the Expression Editor.

Anything to do with "heap" is about allocation of memory resources. Either install more memory in your server(s), or reduce overall demand for memory, perhaps by running fewer jobs simultaneously, or by running on a configuration with fewer processing nodes. Stage types that support sorting may have...

Two Aggregator stages. The first generates the sum for each Dept/Emp the second generates the max of that. Sort the input file by Dept and Emp (use a filter in the Sequential File stage) and assert this sorted order in both Aggregator stages; this will make the job finish faster.

Whatever you do is going to require two passes through the data (a nested query in SQL), the first to determine whether continuous or not and the second to apply the appropriate calculation (MIN or MAX on EffDate) probably using a CASE construct in SQL. In DataStage you'd total the contract days for...

That's really a job for SQL, not something DataStage ought to be doing.

They will still be in the AT scheduler (open a CMD shell and execute the AT command alone in order to see them). However, they are probably still pointing at the old project, so may not work.

You and BAPI Test may like it, but RFC clearly does not. Consult your SAP experts; thay may have some idea. Show them that BAPI Test gave your data the green light.

chulett wrote:Eats, Shoots and Leaves.

The parody (Eats, Shites and Leaves) is funnier.

Lots of sites access JDE data. The main grief is the idiosyncratic way JDE has of representing dates (a single digit century designator). This has been solved; the solution can be found on this site. I'd suggest remedying "I have no background" by enrolling on one of the vendor's (or other supplier'...

That Fmt works suggests that the decimal place only exists as an implled value in your data. Apply a Trim() function to eliminate the leading zeroes.

I'm still not clear from this thread whether you're using a BASIC Transformer stage or a Transformer stage.