DSXchange

One thing My IT Team told me that they have changed the IP of the server because of some reasons... There's your issue right there. From what I recall, that IP gets stored in more than one place and you can't simply change it for the box as they did and have the software continue to work. Unfortuna...

Ah yes, EXACTNUMERIC - thanks Andy.

In lieu of an override is there any possibility of a 'workaround' in the job? Perhaps some trick with string math? Or since we're talking about a sequential file, you could always handle them as varchar fields.

Contact your official support provider. Here you can only be helped by people with grid experience and I don't think that's a very high number.

First suggestion would be to do an exact search for "Import consumed only" to find other discussions on this issue. See if any of them help.

Dang... off the top of my head I can't remember what controls this but you are hitting the (default) maximum precision limit of 15 in the product. From what I recall it's an entry in the uvconfig file but I don't think it would be prudent to bump it up to a large number for the entire installation. ...

Convert the dates to internal format using IConv() and then compare those internal values. That number is a number of days so to back up one day simply subtract 1 from the internal value and then convert back using OConv().

OK then... well, never mind. I know what it means just don't recall ever seeing it used in the DOS world. Live and learn.

You mean the MKS Toolkit and AFAIK you wouldn't have it if you have a Server only license, which I believe is the case here. And for 9.1 I think that they will all still be there but will be implemented differently under the covers. At least that's the impression I got from what Ray has posted so fa...

Never mind the fact that && is valid for UNIX, not DOS.

Glad it's working for you but I really don't think you had to remove the exception handling. You should be able to still have that in place and pass back / dbms_output whatever you like as long as you also RAISE_APPLICATION_ERROR... DataStage should notice that. Hard for me to tell if you ever had t...

ps. Long overdue move just made to the General forum since nothing here is specific to either job type.

To clarify, it sounds like a bug to me - hence the suggestion.

Write a batch file where you do everything that needs to be done - cd, check the size and delete - then use ERRORLEVEL to see if it succeeded. Run the .bat file in the Execute Command stage.

Show us the detailed contents of the log message where the command is executed, specifically the actual command it ran. DataStage is notorious for stripping quotes, perhaps that is what is going on.

Contact your official support provider and see if that is a known issue with the version you are running. Perhaps a patch is available.