DSXchange

I could not access this pdf, is it still exitst

Thanks eyalush,
Bothered to share your issue and the solution you got. :D
If feel this should be a FAQ post in under the specified Froum.

Hi Ameyvaidya , Char is a takes 1 byte to store its each character. And if you assing char(10), Datastage assigns 10 byte for storage. If you have space in the field and if you use Trim function and store back to char field it again expects the 10 character to be stored. (And hence does nothing) But...

Use the after job subroutine for commit. Write a script from which you can Commit the record in db2 with the Command Line features. In simple you can use 'db2 Commit Work' . Use exection handler, (I never tried) if error occurs in previous run, it executes in the next run. Again use a Execute comman...

Some advise to avoid Transformer stages (only because they have to generate C++ code that has to be compiled and linked back into the job), but sometimes you just have to use it. Hi Ray, Is all the Myth about Transformer is only for/about first run (until the job get compiled). Because it shouldnt ...

So its data type compatability. Say if your file is tab delimited, and if the input is 8,4. The input stage you use to read the file will reject the record with an import warning thrown. If you need to raise an error based on this, it would be easy to maintain a seperate job to import the input data...

DSguru2B wrote:Got it Andrw. It was my mistake .. thanks anyways

Is it possible to share the root cause, so that atleast fot this thread which will end with an answer.

Rather than writing a script, use the available FTP stage.

HI Somu, May I know what is that you want to check? Is that you want to check whether it is a decimal or whether it compatable to the given layout or whether it matches to 7,4 (filled with all character?) If you want to check whether it is decimal you can use IsValid in the constataint as mentioned....

Got the result? Or Holded up?
If the input is in date formate you can directly use YearFromDate and MonthFromDate function in transformer and concatinate the both.
Yes, output is not in timestamp. (Input either)

Hmm... the add by the side take up some space, which cause the alignment to go off.

Some generic difference among the three. Join Lookup Merge Description RDBMS-style Source and lookup Master table and one Relational tables table in RAM or more update tables Number and names 2 or more inputs 1 source and N lookup 1 master tables and N Of inputs tables update tables Memory usage Lig...

ArndW wrote:

kumar_s wrote:Trim also works for Char...

Kumar, what does TRIM() on a CHAR(10) field containing "hello " return?

For a char field Len(Trim(field_name)) will return the count without whitspace.

The option available in transformer (Also available project level). If enabled, DataStage tries to combine all possible orchestrate operator to a single operator while compiling to reduce the over head. Though the funcitons are given in an order, which should also work according to its own precedenc...

Trim also works for Char.
Try to use Combinability Mode to fasle in the transformer property.