DSXchange

Yes (assuming that you have pertinent privileges).

If the view is in source, simply SELECT from it as you would from a table.

If the target is a view, then it must be an updatable view under the rules of the database, in addition to the privileges requirements.

Finding tera_cs.txt may help this one also. However, you have ustring on one link and string on another link; DataStage is alerting you to the fact of the metadata mismatch. Remove the metadata mismatch and this particular alert will magically vanish!

This file is usually to be found in the DSComponents/etc directory, where DSComponents is a sibling directory of the DataStage engine directories. Therefore, the file should be at $DSHOME/../DSComponents/etc/tera_cs.txt (assuming that DSHOME is set). Subsequently the character set file will be moved...

2ksaint wrote:without any issues.

Except that you still have no idea of the potential catastrophe you avoided. That what you did worked is pure luck - it can not be guaranteed to work in all cases.

That message has nothing whatsoever to do with memory. You have run out of scratch disk space (specifically on brscr1/Scratch) while writing files related to the lookup table (LUT) servicing a reference input to a Lookup stage. Possible solutions might include partitioning the reference input the sa...

And what actual characters ARE they? How are they encoded? (For example they are not characters encoded in the set of ASCII code points.)

Given your apparent level of expertise I would counsel against that. For one thing, the job numbers are unlikely to be the same in the other project. Further, if you think you can do that, why not export the jobs from the other project, and import them into the broken project. Then you can use DS.CH...

Simplistically, if you have a job with stages S1, S2, S3 and S4 (ideally handling XML, but not essential), you add an RTI input stage on the front and an RTI output stage on the back, and expose the whole as a web service. RTI ---> XML ---> S1 ---> S2 ---> S3 ---> S4 ---> XML ---> RTI Input Input Ou...

The answer's always "yes", since the "how" question wasn't asked. At worst, you could use External Source stage plus a hand-coded application. UniVerse (but not, alas, DataStage) has its own CallHTTP library, which would have made life very easy. Maybe you could grab that UniVers...

What does your official support provider have to say?

Resist stupid requirements!

The resource bundle message is unrelated to the arithmetic overflow, I believe. The resource bundle message is about finding the text to accompany some particular error code.

Doesn't Search work for you?

Like every other well-formed command, dsjob puts its output onto stdout and stderr. If options such as -jobstatus are used, it also sets its exit status to be that of the job, rather than that of the dsjob command itself.

The names are different on different flavours of UNIX, but typically begin with SEM. For example SEMMNI. Consult the DataStage installation manual for specific kernel settings for your UNIX variant and involve your UNIX administrator.