Use Stage Variables when datasource is empty

[centennium]

Hi all,

I am using a Routine SetUserStatus in Stage variables in my jobs to capture info that is needed in next stages. But if the datasource is emtpy, there are no records flowing through the transformer and the Stage variable will not get a value.

SetUserStatus Routine:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

ErrorCode = 0

Call DSSetUserStatus(Status)

Call DSLogInfo("User Status Set To:  ":Status, "SetUserStatus") 


Ans = Status

In my Stage Variable I use:
SetUserStatus(If Read_Status.record_count_valid = RowCount Then 'OK' Else 'NotOK')

RowCount is a variable from the previous stage.

What I want to accomplish is that if RowCount = 0 and record_count_valid is null because the data source is empty, that the UserStatus also returns 'OK' but I don't seem to be able to accomplish this.

Any thoughts?

TIA

Martina

[DSguru2B]

What is your datasource? Is it a flat file or a database?

[chulett]

I would suggest that you use your routine in the Initial Value column where the stage variable is defined to explicitly set the value to 'OK' when the job starts. Leave your other mechanism in place so that it is still used when rows actually do flow through the job.

[ray.wurlod]

Status is a reserved word (it's both the name of a statement and the name of a function).

It's not good practice to use reserved words as variable or parameter names, in case they change the compiler to enforce the reservedness of these words. It's happened in other languages.

[kumar_s]

Yes, this routine wont be executed at all. You need to handle this in the receiving end. i.e., if you dont get any value set in the variable, you can replace it with 0.

[chulett]

Yes, this routine wont be executed at all.

It will if also called in the Initial Value area, as I noted.

[kumar_s]

Oh ok, so the intialization of variable occurs during intial validation phase and not during when stage start to operate. Thanks for that.