DSXchange

So far not resolved yet, I'm still communicating with IBM, it's strange other people didn't have thsi problem that much.

Anyway I'll let you know

Meaning I can't see it from Datastage (I checked the rights, they're fine)

Hi folks,

I have a stupid question : I can query the SYSIBM.SYSDUMMY1 table in DBAS400 but cannot find it when I check the SYSIBM library using the ODBC Import table tool. I can see all tables except this one.

Is there something to configure in the ODBC connector ?

Thanks

Sorry, do you mean by extracting the output to a SEQ file and create INSERT STATEMENTS out of it ?

Craig :

I'm upserting a table using an Oracle Enterprise.

Tippy:

This is a great idea but I don't know how to "capture" the wrong record.

In my design I use reject tables but in this case this does not work. I assume this is because the INSERT STATEMENT sent to Oracle is invalid.

Hi Craig, The thing is that I cannot probe the output so that I can retrieve a good example. I just know that if I insert a constant string instead of the initial input, the job gets through. I only trim an input field from DB2-AS400 and load it through a SCD stage. It crashes when getting into the ...

Hi guys, I have an issue with an Oracle stage to load a table. At some point my job crashes saying it cannot insert a record (can't tell which one javascript:emoticon(':evil:')). I figured it's cause by a varchar field that can contain all sorts of bad characters (commas, slashes, percents, etc). My...

Great thanks

Sorry if I was not clear. I mean that my elementary jobs are parallel jobs. i'm the only one developing

Could there be an issue with NLS or local language features ? Special Chars ?

What do you suggest ? I'm used to Job controls since I have started initially with DS Server Edition. Is it better to switch to sequencers ?

Thanks

IBM says : Appears to be the patch_JR30746v2_client_windows_801fp1.zip on the client side. Don't know if that works yet. It's weird to me a patch can be on the client side...

sunitha_cts wrote:HI,

Instead of using Remove duplicate stage , is they any other way to remove duplicates from a table.

Thanks
sunitha

If you query from a DB, you can also use the DISTINCT keyword in the query sentence. This is helpful to restrict as early as possible the number of rows that are retrieved.

Well, I have a solution but I don't like it. In the SCD stage, I create an extra field called PREV_SK which uses the PrevSKChain function (not documented that much by IBM). It has an argument : the business key. If the record is the first one, it returns 0, otherwise, it returns the surrogate key of...