DSXchange

Promote any shared containers separately first. Then promote the job or jobs that use them, but when it prompts you to include the shared containers with the jobs, click 'Ok' without selecting anything first so they don't come along for the ride. You should be fine then.

There's not nearly enough information here to provide you with any coherent help. You haven't mentioned the database. You state the two SQL statements are "exactly similar"... are they similar or are they exactly the same? Is the table you are sourcing from being actively written to when the jobs ru...

Welcome aboard. Are you aware that, if you are under maintenance, that you can order a copy of the version in question for your platform for no charge? One thing it will come with is a document with exactly those kind of things in it. I don't see any burning need to post the entire contents into thi...

rxs0005 wrote:Should i define the COLA under seq stage as varchar and in oracle as a regular number(8,3)

Yes. There are many ways to strip the dollar sign, one such way would be to use the EReplace function.

if the records are being reject then this is because of some violation like unquie key violation or something. then in this case my job should get failed. but its a success. I'm curious how you are determining this. Hopefully not by simply checking that all the links are green when you run the job ...

We use 7.5.1A on a Citrix server with no issues. You might want to explain exactly what "Only when we access DS through Citrix" means - access it how?

I don't have access to DB2, so not that familiar with its setup. Have you followed all of the necessary configuration steps outlined in the Plug-in Installation and Configuration Guide for the stage? Have you stopped and restarted DataStage after you made the dsenv changes? I would think there is mo...

ED is a line editor and a really good way to hork things up if you don't know what you are doing. In the words of the immortal Pink Floyd: Careful with that Axe, Eugene.

Of course, it was an instrumental song, so no words - but I digress...

The checkpoints are set in each individual Sequence job, there is nothing needed at "the whole project" or "enabled at adm". You can, however, set a Project level default so that checkpointing is enabled by default in any new Sequence jobs you create, if you like. As noted, it is not by any means ne...

Is your target Oracle field a DATE or a TIMESTAMP? A datatype of Timestamp in DataStage equates to an Oracle DATE field. TIMESTAMP is not supported directly and would have to be handled by custom sql using the proper TO_TIMESTAMP() function.

Better, but still overflowing. Try a MM of 33000, if you could please.

Ok, those sizes are from a minimum modulus of 1 and there was alot of overflow. What about when you tried it with 31000?

Ding ding ding! We have a winner... excellent catch - and nice emoticon Thibal.

Seems there has been 'gaps' in each century since then as well.

I'd be curious what the final sizes of your .30 files were before and after each test, especially the size of the OVER.30 file afterwards to see how much it was utilized, i.e. how much 'overflow' there was...

Try providing a full path to the xsd.