DSXchange

What kind of 'routine'?

Please start a new post when you have a problem, that way we know all of your particulars and you can post your specific error messages rather than saying it's "the same" as someone else's error.

If you feel it would help, post a link back to this topic when you do.

Pretty much any 'unusual' ORA errors should be taken to your DBA, hopefully (if they are any good) they already know about it and are working on a resolution. This is one of those errors.

So... you made this change in your DB2 XMETA database and now can't connect to DataStage at all? Or you can't connect to that external database from DataStage?

Try extending the logic noted here:

viewtopic.php?t=129328

This should help.

viewtopic.php?t=105529

That would be because there really isn't a DOS coding forum here. Suggest you google for something like "errorlevel example", I'm sure you'll turn up plenty of help.

Of course, if someone actually knows hopefully they'll post something.

Then please mark this post as Resolved using the button at the top of the page.

Yikes, all you needed was your one line in sed slightly adjusted:
Removes trailing spaces from line 999. Replace that with the actual number of lines in the file.

You would use "wc -l" to get the number of records in the file (and thus the number of the last record in the file) and then constrain sed to just that line.

There's nothing you can do about it, from what I've seen, other than manually correct things. It seems to import based on maximum bytes rather than characters from a multi-byte character set.

You may, however, be able to track that from the O/S if it or your SysAdmins have such capability.

Are you admitting to something, Arnd?

That should be all there is to it. Best to check AT&T's FAQ here and if you still have issues talk to your carrier, make sure you are actually setup to recieve them.

You'll need a VOC record for that.