DSXchange

Particularly since a link to my date routines has already been posted on a number of occasions - that is, the answer is already there. We need a "sin bin" mechanism. A "time penalty" for using "urgent" or "ASAP", a time penalty plus a public shaming for inappropriate use of PM or private email. Appr...

1. Don't select it in the first place. ( WHERE CHAR_LENGTH(FULL.TEXT) > 4000 ) 2. Truncate it yourself. ( SELECT SUBSTRING(FULL.TEXT FROM 1 FOR 4000) ... ) 3. Truncate it in the routine/DataStage job. 4. Make sure in advance, by querying system tables, that there's plenty of tablespace. And so on.

Welcome aboard. :D

What you say is true now, but wasn't two years ago when the rest of the posts on this thread were made. Just goes to show that the vendor does listen occasionally!

uvbackup then uvrestore format.conv -export then format.conv -import The answer to your third point remains "no" as far as I am concerned. All you would be doing if you followed your or Cameron's suggestions is to code what remains a manual process. It remains true that there is no command to do th...

You have marked your job type as "server".

Therefore the answer is that osh script is completely irrelevant.

You can't preven job failure if the Oracle table space fills. This is outside the control of DataStage.

Having set it to true and drawn the reject link, check the Columns on the reject link - you will see sqlcode there (automatically, not an option as I at first thought). To do insert only, you need to check first whether the key already exists in the table. Depending upon the size of the table, use a...

You've got an Oracle problem, dude. Talk to your DBA. Your tablespace for CLOB data is full. You get one error code for each row processed. AND you don't get your CLOB stored.

If I recall correctly, you can use a reject link from the Oracle Enterprise stage. This gives you options to add extra columns to the reject link (look in the available options to add).

It's probably unrelated, and might be worth a separate thread or even an FAQ on approaches to securing DataStage projects. Usually you have a separate group per project, and that's the group associated with objects in and under the project. The dstage group (which doesn't have to be called that) giv...

Fix whatever is generating the Oracle errors would be my approach.

Use oerr ORA 01653 to decode the error code.

Upgrade to a version in which $PROJDEF does work with encrypted parameters. Make sure that the environment variable is defined (in Administrator) as encrypted.

Why are the setgid bits set in your permissions? Who did this, and why?

What was the value of @ID in the most recently successfully-selected row? Take a look at this entry in the log (using Director Log View), then click Next (in Detail view) to move onto the event that caused the glitch. Tell us what you see. Because it was originally (and still is) touted as "everythi...

No runners left on base? (Sorry, couldn't resist.)

Never encountered this one, so can't really help you.

Guess Time
Has the job tried to load "" into the CLOB? Or a null?