DSXchange

Hi !!!

I need some basic information. Can I configure someway DB2/UDB Load stage to work with DB2 AS400 ?

If can where I can to find how to set up a numerious stage's settings ?

Thanks

What Join Type to use there ? It seems none of existing Joint types don't give me the cross join

Hi , everybody !!!

I have two files and I need to get CROSS JOIN Between them . How I can to perform it .

Thanks

Hi , everybody !!! I get some strange DS behaviour . I run some job with Job Sequence . After 50 warnings the job aborted due 50 warnings limit and I see in Job Sequence log the following row : "Mode (row/warn limits) = 0/50". But where the limit was set . I dont know the way to set this l...

Can you give details ? What is Java PACK how can I use it ?

If there Java PACK in Datastage 7.5.1A?

Thank you . And nothin About Basic . Why IBM doesnt provide Java for Transformations ?

Hi !!!

I wonder if IBM plans to issue a new version of Datastage - 8 and where I can read about New features of it

Hi !

I want to extract list of jobs that participated in my Job Sequence.

I haven't found it in Forum but I amsure somebody has the solution

Thanks you

Its not the case .

After the job finished the counter retutned to 1000000 but I feel the DS do more work that reqiered for 1000000 rows

Hi ! I meet sometimes starnge behavior of aggreagtor. I have a simple job : DB2 -> TRANSFORMER -> AGGREGATOR -> SEQFILE In DB2 I have 1000000 rows when the job run statistics of rows in link between DB2 and TRANSFORMER rich 3000000 rows (3 times exactly f the source number rows) Any explanation

Is there any way i can write a constraint so that after finising the first stage file 1 (the process of first writing into the sequential file1) and then i can start the second stage process. thankyou I dont think so . Try three transformers in one job. In your case may be the problem in free disc ...

Hi all !!!
The problem was resolved by assigning CCSID 424 for Hebrew
All fields were char represented in HEX format

In DDS its defined Char(1) in Stage I accessing the field in DS the field defined as Binary 1. I accessed the field with another query tool and its seems ok and I see the content of the field ok.

You say that there is no way to remove the symbol after the Ds assigned it to "?" ?

This symbol looks very strange. It doesn't looks like letter of any language. But I"ll try to map it

Thank You ! Ill return after some checking

Hi !

In my source I have Char(1) datatype of field . When I bring metadata to DS this field is Dispalyed as Binary(1) with symbol @ instead of a one letter

Does anybody know what's the point here ?