DSXchange

A) Why add a Sort stage when the data is already sorted? B) What makes you think the sort is 'failing'? C) Are you using the Hashed table to remove duplicates and the 'wrong one' is going in last? D) Please don't expect any particular order when selecting from a hashed table any more than you would ...

Already did and stand by my first post on the subject of breadcrumbs. Start by adding in several logging statements so you can see what values are being pulled by the API calls you are making. Can go a long way towards knowing where it is you are going astray.

Wasn't thinking of using an Identity column (since those would be unique per record which is not the goal here) but literally a sequence that gets incremented conditionally. And then yes, you'd need to transform it into a padded string before actually using it in the records. Still curious about con...

Clarify something for us - will this DataStage job be the only process manging the Sequence value? Or will other DataStage jobs and/or outside processes be involved with inserting records into this target? If you need to worry about concurrency, that will complicate your solution. And Franklin, you'...

First thing to note is your desired format posted does not include microseconds - are you targeting a TIMESTAMP column in Oracle that will support them or are you actually writing to a DATE? Assuming the former, if you check the documentation you'll see your issue is the format string you are using ...

No doubt an NLS issue. Use the parallel (command line?) metadata importer rather than the plugin. I don't recall its name off the top of my head, however.

No... but I've already explained how to solve your problem. And all of the functions are documented, so there's really no need to ask what might be available.

:idea: While you could include a screen shot using the [Img] tags after you've uploaded it to a file sharing site, as you can see there's no need. The forum software automatically removes 'extra' whitespace which is what was affecting your example. I wrapped it in [/b] tags which preserve whitespace...

Dang, have you guys been reading my diary again?

OK, enough of that. Gayathrisivakumar, do you have enough information to get what you need done? If you need more help, please let us know.

Actually, I'm pretty sure this is in the documentation for the stage... probably the Connectivity Guide.

Lots of references to it out in the wild, here's what a quick search turned up for Java but it should apply to DB2 as well for a LOB:

http://www.javacertificate.net/passbyvalue.htm

Keep in mind the fact that most examples of data posted here are completely made up.

Have your DBA trace the session and see if the index is being used for the updates. If you don't use one of the fields in the composite index (unless it is on the 'trailing' edge) that would preclude index use but using all five of of them should fare much better. I'm assuming your issue is that the...

Gotcha... an anonymous block. Let's start with the obvious first question, are the fields in your 'where' clause indexed in such a way that supports the update (and delete)?

So... your 'Sequence' is actually a string field? That would be the only way to store those leading zeroes if they are significant. I would handle this in stage variables, tracking the current v. previous version of the key field and only incrementing the sequence number stage variable when it chang...