DSXchange

As far as I know there isn't a truncate statement in db2 as in for example Oracle. However there is a alter table statement that preforms the same function that you are searching for. I doubt that db2ee-stage is using that technique, i would guess that it actually preforms a "real" deletes...

One site i was working on had this problem each month until they realized that they were using a trial version of the compiler that ran out each month. Someone at their support organisation had it as job to renew this license from time to time, however forgetting it (of course). All to save a couple...

Sorry about the multiple posting

You need to ensure sorted data by your defined keys and ensure that your partitioning supports that sorted order. When all that is complete then you can create one or as many stage varibles as needed to kep track of your keys and stage varibles for your aggregates or max-values. Then just let datast...

You need to ensure sorted data by your defined keys and ensure that your partitioning supports that sorted order. When all that is complete then you can create one or as many stage varibles as needed to kep track of your keys and stage varibles for your aggregates or max-values. Then just let datast...

You need to ensure sorted data by your defined keys and ensure that your partitioning supports that sorted order. When all that is complete then you can create one or as many stage varibles as needed to kep track of your keys and stage varibles for your aggregates or max-values. Then just let datast...

I Have doen multiple installtion of Datastage 7.5.1 oem edition on the same machine .When i do ps -ef | grep ds both services is showing i have done second installtion with itag -aaa. The first installtion i have done normallt without itag I am able to connect to first installtion but not teh secon...

The error: test_account_list_db2: When preparing operator: When binding partitioner interface: Could not find input field "tsno". Resides in a what has been defined as partition key in your database table. You're definition of your table propably has TSNO set as partition key and since you...

I use a different approach (on linux and unix plattforms) and that is when any file has been ftp:d or written to a specific directory , say /arrival. On completion the file(s) are moved (using mv) to another directory where datastage is listing for files, say /complete. Datastage then moves any file...

It could be that you need to "escape" special characters before passing them to a job as parameters.

Example
needs to become

Remember that a stage varible cant contain NULLs so a tip is to first convert any null to something else and use that stage varible in you derivation later.

Usually that warning indicates that you are evalulating a column which has null and that operation does not allow NULLs

If you need an 'urgent reply ASAP', contact your official Support provider. You pay them big bucks for just this kind of thing. I agree with chulett, use support more.... By the way, its never a good idea to build and test jobs/programs in one enviroment and then executing them in a different envio...

Yes and No,

Depends on what stage you are using and what you are doing. If you wish to use parititoning features using db2ee stage then I think you need a special patch from IBM (unless you already have it).

I have seen this can happen for example when using datastage and certain patched versions of DB2 on AIX. It occurs whenever you are using upsert in and there are no hits on the update-statement or when sending "empty" deletes to the database. The database(db2) throws a SQLW (Warning) to da...

Stefan - I think the ConnectDirect or mainframe issue is that some files can have compressed spaces which are not interpreted/expanded correctly when doing such transfers. The compressed spaces binary ... ArndW! Is there a way to handle (other than fixing the files before sending) what you are desc...