DSXchange

The dsjob change suggested *is* "at the DataStage level" and is the appropriate solution to this problem. IMHO you will spend more money developing a much less effective work around if you take another path. To do what you are asking would require a second monitor process be built, somethi...

Exactly, was wondering if something like this was going on. Hence the need to see the PICture clause.

As noted, count the digits, add one for the sign if present, round up to even if odd and then divide by two to get the packed field size.

nitkuar wrote:In datastage 8x version, we can delete datasets(descriptor and their corresponding data files) using orchadmin del <dataset_name> ...not sure about version 7x... but u can give a shot...

It's there in 7.x as well. And it's "you", not "u" please.

You should be able to find that option buried in the stage somewhere, Phil, I wish I could be more specific and tell you exactly where. Another option for your max date would be to convert it to external ISO format, a string in YYYY-MM-DD format for example and then max() that in the stage. You coul...

Sorry, but the code tag in my post that you quoted was messing yours up. I adjusted what you quoted so now yours are active but that has (as expected) messed your ascii art up. It would be best if you could edit your post and slide things back around until they line up more better.

You'd probably have to contact your official support provider to see if there are any known issues. Could it be something I've seen before in other stages, a 'length' issue where some of the sql is getting truncated thus making it invalid? How long is your combined union?

Well, if you are trying to add something and it tells you it already exists then it already exists and you'll need to find out where it is and perhaps edit the default value. Unfortunately, I don't have any access to tell you what 'branch' it is under but it sure sounds like it must be out there som...

It is... just seems to be a badly drawn one.

And even if they meant a PX design, it is easy enough to do the equivalent in Server with a direct reference lookup off the Transformer, although I would use a hashed file for that.

Sorry, but after four years I have no clue what the resolution for this was.

You certainly *can* set a warning limit from the command line for tools like AutoSys, check out the -warn option for dsjob.

Too many log messages can cause the corruption issue, yes. All of those are from one run? What kind of messages are being logged? :? ... For each batch id there is a insert statement, there are more than 10000 batch ids. all the insert statements presented in the log file. now the log file entries ...

Quotes are stripped from parameters, you'll need to escape them in order to preserve them. An exact search for "escape" should turn up many conversations on this topic here, btw.

Too many log messages can cause the corruption issue, yes. All of those are from one run? What kind of messages are being logged?

You need to upload your screenshot to any of the free image hosting websites out there and then link to it from your post using the [img] or 'image' tags. Those sites will typically build them for you so that all you have to do is paste their completed tags into your post. Alternately, you can detai...

Ah... the dreaded SIGBUS error, not a fun one to track down. First suggestion would be to do an exact search here for "Fault type is 11. Layer type is BASIC run machine." and see if anything there helps. In all honesty, you'll probably need to engage your official support provider on this ...