DSXchange

State your business / transformation requirements in words rather than making people puzzle them out based on simply posting input and output samples.

Sure and you are... it's just that it is not a very performant option to pull data from the source across the network into DataStage and then push it back out to the target, one record at a time. Perhaps your DBA could suggest an alternate path - dump the contents, move the output file to the other ...

Probably through something other than DataStage - for example with PL/SQL, especially if these two tables are in the same instance.

OK. With that out of the picture we'll need details of how you are sorting to try and see what the issue is. For example, when using the Sort stage when settings did you use?

How many nodes is the job running on and how are you partitioning the data?

One last thought. Basically, what you're looking for is a "rules engine", see if an exact search here for those two words turn up anything.

I wasn't sure off the top of my head what your alternative is here which is why I didn't include that in my reply. I know the topic has been discussed here but not sure what key words would turn them up for you. Already running late this morning so hopefully someone else can chime in here shortly...

Unfortunately, you cannot pass expressions like that as parameters. It just becomes a string value at that point as there aren't two levels of resolution here.

Again, post something that shows us what you are trying to accomplish. Either take a screen capture of the job's canvas, load it up to any of the free file hosting sites and then use [img] tags to include it in a post here or simply "draw" it using text as I noted in my "ascii art&quo...

CLOPES wrote:I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.

Sorry but I'm not really sure what that means or what that has to do with job logs.

CLOPES also wrote:can i delete jobs using the web admin module ?

Jobs or job logs?

Done.

There should be an option in the Aggregator to 'preserve type' from what I recall, this to override the automatic output of a double.

left(timestampValue, 10) to get the date part and right(timestampValue ,8) (That smiley is supposed to be the number 8. Don't know why i am getting a smiley there) to get the time part. Because an 8 followed by a right paren is the board code for a smiley. When you don't want them you enable the &q...

I'm not familiar with which functions are new to 8.5 and which ones are available in 8.1 that would be useful in this situation. However, it seems to me you should be able to increment the date and time separately. Meaning, increment the seconds and when you hit midnight add one day to the date. The...

WHAT ascii value? It's important to identify any characters you want to remove. I'm also curious how you changed APT_PADCHAR_STRING to a "space", I'm guessing you did not set it to "0x20" which is the hex representation of the space character that you want.