DSXchange

I am talking about Datastage Server, not the parallel server.. There is an API routine KeyMgtGetNextValue, which can help us to generate a sequence number .. Do you guys usually use it to generated sequence number ? by the way, If I don't want to start from 0, for example I want to start from a cert...

I am so sorry about fail to put them in the right section..

Sorry again !

There is an API routine KeyMgtGetNextValue, which can help us to generate a sequence number .. Do you guys usually use it to generated sequence number ? by the way, If I don't want to start from 0, for example I want to start from a certain point like 1000000. Does KeyMgtGetNextValue can help me ? O...

This is exactly why I asked you to post your sql. by the way, the reference table is from a SQL Select statement like . SELECT RA_HCUSTOMERS.CUSTOMER_ID, RA_HCUSTOMERS.CUSTOMER_NUMBER, RA_ADDRESSES_MORG.ADDRESS_ID FROM RA_HCUSTOMERS, RA_ADDRESSES_MORG WHERE RA_ADDRESSES_MORG.PARTY_ID (+) = RA_HCUST...

Actually, I just drag the link field from master link into the key expression field. I am not very sure what you mean "like", do you mean I use like instead of = ? About the reference SQL, since it was composed of two tables by left outer join. I am not sure how I can get the column based ...

by the way, the reference table is from a SQL Select statement like . SELECT RA_HCUSTOMERS.CUSTOMER_ID, RA_HCUSTOMERS.CUSTOMER_NUMBER, RA_ADDRESSES_MORG.ADDRESS_ID FROM RA_HCUSTOMERS, RA_ADDRESSES_MORG WHERE RA_ADDRESSES_MORG.PARTY_ID (+) = RA_HCUSTOMERS.PARTY_ID AND RA_ADDRESSES_MORG.BILL_TO_FLAG (...

Yes, since look up couldn't find the same value, I mean none of master field value existed in the referece table.. Theoritically, it should return Null, but it is weired, it always return the vlaue of the first row.. Basically things like that Master table field1, field2 1 a 2 b reference table fiel...

User defined SQL as follows: SELECT RA_HCUSTOMERS.CUSTOMER_ID, RA_HCUSTOMERS.CUSTOMER_NUMBER, RA_ADDRESSES_MORG.ADDRESS_ID FROM RA_HCUSTOMERS, RA_ADDRESSES_MORG WHERE RA_ADDRESSES_MORG.PARTY_ID (+) = RA_HCUSTOMERS.PARTY_ID AND RA_ADDRESSES_MORG.BILL_TO_FLAG (+) = 'P' AND RA_ADDRESSES_MORG.ORG_ID (+)...

I think it is an ordinary questions, then I didn't post it in Server section. Exactly, missed match should return null. However In my test job, master link is a sequential file, reference link is a oracle table based on select statement. output link is one field from master link, one field from refe...

I meet a weired case. I use sequence file as the master link, and oracle statement in Oracle stage as the reference link. drag master.field3 = reference.keyfield Actually, no exact match, all fields from reference link should be " " After I run the job, it is strange, all fields value from...

I want to load data from a sequencial file to oralce table.. And if any row was rejected, the whole job rollback.. When I check the transaction handling in Oracle Stage, there are only a row count configuration for the transaction handling. Actually, I am not sure how many rows in the sequencial fil...

Why in datastage director log, it still display the field value with double quote...

I use data in sequential file update progress table by odbc stage.

Progress table can only know varchar with single quota mark, but datastage automatically add double quota mark for the field from sequential file..

How can I make datastage only add single quota mark to string field...

Thanks

I got an error when I try to update source progress table by ODBC Stage. Basically, Datastage generated update SQL statement is as follows: UPDATE PUB."ar_mstr" SET ar_xcomm_pct = ? WHERE (ar_nbr = ? ); both ar_xcomm_pct and ar_nbr field are varchar type. After I run the job, it always get...

I still have no idea about the NLS errors when I started client connect to the Server