DSXchange

Define 'send the Finished status' or 'send a Status message from a Job Sequence'? Does that mean you need to send some kind of an email after a job completes? Or since we're talking a Scheduler, do you mean you are trying to control the exit / return status Tivoli sees? Be more specific, explain wha...

cosec wrote:Target as ODBC
When I use this stage I am not able to roll back the changes.
I did specify the Rows Per Transaction to 0

Why are you 'not able to'? What happens or does not happen?

Rollback requires uncommited data and a job abort to make it happen.

Would that be valid in your world? Not sure off the top of my head how to avoid the problem you've seen when checking for multiple-character delimiters. Pondering...

So... you are using ODBC to connect to Oracle? Have you configured DataStage's ODBC for an Oracle connection? Created an entries in the uvodbc.config and .odbc.ini files? These are prerequisites. There can be additional setup required if you are not using a 'wire' driver, you'll need an Oracle clien...

Have you looked at/near line 906 in the 'program' mentioned? It should give you a clue as to the where / why of the problem.

Have you tried searching for your error text, 'Unable to unlink' for example?

Count single occurances, divide by 2 and then add 1.

It would help if you didn't just repeat my own words back but instead described in detail the process you need to follow. Forget about DataStage, document what you need to do for this regardless of the tool being used to implement the logic.

Then people can help with the DataStage part.

Basically by not committing. Transaction Size is a stage property, so for example, setting it to 0 will get you an 'all or nothing' load.

Have you installed the Click Pack for DataStage? From what I recall, it is free and installs several stages specifically geared to handling things like web logs. And it brings Perl integration into DataStage. Something to check out.

It would help if you didn't just repeat my own words back but instead described in detail the process you need to follow. Forget about DataStage, document what you need to do for this regardless of the tool being used to implement the logic.

Then people can help with the DataStage part.

To answer the question as asked - no. Jobs are discrete transactions, once one completes, its work is either commited or rolled back.

Urgent requests for solutions should be directed to your Support provider.

Your error message tells you both the problem and solution - have you tried searching for 'NLS_LANG' here? Or 'ICU codepage'? I'm sure the answer is out there... somewhere...

No running, getting aborted and giving phantom error has nothing to do with the need to release locks. You do that if something is locked (and thus cannot be edited) when you don't think it should be. Reset your aborted job and post any 'From previous run...' message that gets added to the log. Post...

So, apparently a routine provided by the class. Did they provide you with a CDROM when you took the class? I'd look there...