DSXchange

Thank' for your reply. It look like you did the same researchs like me and at the same place with the same words. We can't say that it is trivial to find what we are looking for, when we find items about the words we typ in search wndows. We don't get any time what we are looking for by doing this. ...

Did you try searching for your message? I got 34 matches when I just did, surely your answer is out there in the flotsam and jetsam. ... Can you tell me please which words you type and where you type this to get your 34 items about my problem? I try too and looking in the first 5pages I didn't find...

Helo all, I,m facing a warnig since few days. By runing the message I receive the following message: When checking operator: A sequential operator cannot preserve the partitioning of the data set on input port 0. I'm only handling data set file and table as input and output. Has some already faced t...

You need to derive this using the "NextSurrogateKey" function. ... Do you mean after seeting the DBsequence in the Transformer stage I' ve to set the FIELD(CLIENT_TK) with the Derivation "NextSurrogateKey" in Double Quote? Other like this NextSurrogateKey()? I set like you say w...

Hello, I want to populate a table with help for Surrogate Key in aTransformer. I'm not comming right to deal with the DBSequence I'v allready configured in the tab surrogate Key of the Transformer.How to call This in the corresponding Fiedl the Table and insert the value in the corresponding FIELD f...

yollsonlegrand wrote:
But because in the same transformer I can't deal this NULL Field Value, how can I deal this in the Job?

Please I wannted to say: because in the stage variable I can't deal this NULL FIELD Value, how can I deal this in the Transformer?

Not sure how that wasn't helpful as it explained your compiler error, which was all I was trying to do. Obviously, you need to go back to "Y"/"N" or "NULL" in your variable, making sure your derivatio ... I dont't understand why i'm not receive the whole posted message...

Hmm... would you be willing to share what it is about the SCD stage that doesn't work for you? ... It is missing a path to well configuring the communication between the DB Sequence and the Database. It can't work in the now state of the instalation of datastage. it fail some path. That is why I wa...

Stage variables cannot be set to null. Is "CODE1" a stage variable? ... Ok. if so, where I'm supposing to handel the Null Field value CODE1. I wannt to add that I did the same thing with two other Stage variable in the same Job. That mean that I must change this? can you tell me Please ho...

Error when checking composite operator: Setting null to this non-nullable field:StageVar0_svCODEGRPGEP Stage variables are non-nullable so cannot be set to null. ... Ok. But only giving this information like that about stage variable that cannot be null is not helpfull dear Chulett. The suggest to ...

Try : Then SetNull() Else CODE_GRPGEO. Pls don't include double quotes for field names. I've setted the SetNull() function as you say it. it breake all down. I couldn't compile the job. the job compiling give a long message error on a fenster. I can give you here some big line: <main_program> Param...

I don't get you. Can you pls be more specific? Like what are the source fields (exact names)? What are the stage variables' names and their derivation? What are the fields in target and their derivation? I' m saying that after well seting "YES" instead of "Y", it go on with a ne...

Hi all I'm facing the problem of NULL Value in a FIELD.. I set a stage variable for this FIELD like this svCODE1: IF(isNull(CODE1) or Len(Trim(CODE1))=0) Then 'NULL' else CODE1. After this I set the derivation at the CODE-Level with the value of scCODE1. By running i receive the following Message Er...

You used YES at stage variable and Y at constraint level. Pls check. You are right man. I set it with yes and I'm now facing the problem of NULL Value in e FIELD.. I set a stage variable for this FIELD like this svCODE1: IF(isNull(CODE1) or Len(Trim(CODE1))=0 Then 'NULL' else CODE1. After this I se...

You used YES at stage variable and Y at constraint level. Pls check. You are right man. I set it with yes and I'm now facing the problem of NULL Value in e FIELD.. I set a stage variable for this FIELD like this svCODE1: IF(isNull(CODE1) or Len(Trim(CODE1))=0 Then 'NULL' else CODE1. After this I se...