DSXchange

Officially, server jobs do not support BLOB data type. You may have been lucky up to now in that your BLOBs have been small enough, and now you've encountered one that's too large. Try explaining that to your 'Boss'. That was just a suggestion as it fixed the problem. But guess Ray hit the bull's e...

Need more info on the job design and as Ray requested the entire error message, with surrounding warning messages too, for any of us to provide help.

Read that value and store it somewhere, maybe in a user status. Parameterize your job and pass the userstatus from the previous job to your current job. I hope thats what your asking, if not, then please be a little bit more clear on your requirement.

You need one job that builds a text file, say 'queryDate.txt' that contains the very first date. Say the very first record is dated 1997-01-01. This date will be present in the 'queryDate.txt'. The second job will be your main job that does the select from the oracle table and does as you developed ...

Did you try not giving anything. Its the same server as your outlook server. Get more details from your system admin.
Well both the approaches will achieve what you require. You have more flexibility in a sequence job by using notification activity. You can attach the job report etc.

I edited my previous post and wrote a routine. See if that works. Was just getting bored so sat down to write it out.

In one of the results roy got the same error. All he did was re-compile the job and that took care of it. Try that.

You can choose ExecSH in the after job subroutine and pass nothing. Set the warning limit to 1. This way the job will create a warning and the job will abort. When your done testing clear the after job subroutine.

You can probably write a basic routine. Do a character by character comparison. If they match store it in one variable and if it does not, store it in another. Get the size of both these variables and mainpulate the percentage to get the percentage of match and return the appropriate value. FUNCTION...

Well thats good but at times, you just cross the bridge when you come to it. DSRunJob() is a function and used in jobcontrol when you have to control the complete process. UtilityRunJob() is a utility provided by DataStage which runs the job and can be invoked inside the transformer. But it will be ...

Yea, even i didnt quite get the question.

Search is your friend. Do an exact search on "Layer type is BASIC run machine"

Using Stored procedure Stage.

chulett wrote:And who would you be?

This is funny. DSXchange seems haunted now. One person asks a question and some one else replies in confirmation.

You got it wrong again. Take a deep breath, close your eyes for 10 seconds and then read the following. - It is not possible to add job control code of the same job that you are working on in its job properties. When you go to Job properties, to the Job Control tab. You will see a drop down option. ...