can NOT set UserStatus via routine

[abyss]

Hi I have searched the form regrading to set userstatus but I still can NOT assign value to it!

I create a transform function type server routine the code as following:

Code: Select all

if Arg1 = 'Y' then 
Call DSSetUserStatus("Y");
Call DSLogInfo(DSGetJobInfo,"set_userstatus");
Ans = 'Y';
end else
Call DSSetUserStatus("N");
Call DSLogInfo(DSGetJobInfo,"set_userstatus");
Ans = 'N'
end

in the log DSGetJobInfo function return NULL value and the sequence job return error message: Variable '*.$UserStatus' never assigned a value.

thanks
Abyss

[abyss]

i call this routine in basic transformer stage derivation area

[abyss]

hey i think i find part of the problem, the job can compile now. new the problem is the routine never return 'Y' even argument Arg1 is 'Y', but in the test window if i specify the Arg1 is 'Y' then the routine returns Y

[abyss]

changed code to

Code: Select all

if Arg1 = "Y" then 
Call DSSetUserStatus("Y");
Call DSLogInfo(Arg1,"Arg1");
Call DSLogInfo(DSGetJobInfo(DSJ.ME, DSJ.JOBNAME),"userstatus");
Ans = 'Y';
END ELSE
Call DSSetUserStatus("N");
Call DSLogInfo(Arg1,"Arg1");
Call DSLogInfo(DSGetJobInfo(DSJ.ME, DSJ.JOBNAME),"userstatus");
Ans = 'N';
end

and i output the argument and return vale to a file, now the argument value is Y but return value still N. anyone know why?
and DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) this statement doesn't work, but i copied it from user manual

thanks

[chulett]

Why not simplify the code? You don't really need all that if-then-else.

Code: Select all

Call DSSetUserStatus(Arg1)
Call DSLogInfo(Arg1,"Arg1")
Call DSLogInfo(DSGetJobInfo(DSJ.ME, DSJ.JOBNAME),"userstatus")
Ans = Arg1

Tell us what "doesn't work" means here for the call to DSGetJobInfo. What actually gets logged?

[abyss]

ok, what's doesn't work:

i think the if statement doesn't work here, the job look like this


the oracle stage only return one row with one value. smp_job_status is varchar type and length is 255


in BASIC transformer stage I call a routine and pass smp_job_status as parameter


in the output file as you can see the return value of routine return 'N'


I think the problem is from if statement, control flow always get into the else part. but i don't know how to fix it.

[abyss]

changed code to

Code: Select all

if Arg1 = "Y" then 
Ans = 'Y'; 
END ELSE 
Ans = 'N'; 
end 

result still the same so the problem is from control flow. but on the test window it works


grrrr

[chulett]

I think the problem is from if statement, control flow always get into the else part. but i don't know how to fix it.

The simplest way? Get rid of it.

[chulett]

You also never clarified what actually gets logged in your original code, specifically the one with "userstatus" in it. Still curious about that. Since you said it didn't work.

Also, clarify something. You keep saying "BASIC Transformer" - that is a very specific stage in a Parallel job. This is actually just a "normal" transformer in a Server job, yes?

[abyss]

his is actually just a "normal" transformer in a Server job, yes?

yes, sorry for the confusion.

change the code to

Code: Select all

Ans = Arg1

result is: Y

the change the code to

Code: Select all

if Arg1 = 'Y' then
Ans = 'Y';
end

it return NULL

WHY?

[abyss]

change the code to

Code: Select all

if Compare(Arg1, 'Y') = 0 then Ans = 'Y'

it still doesn't work! i am run out of plan, this is shit. why this software even can not let you write a if else statement!

chulett: if you think i can get rid of if statement, what's the way to work around it.

[ray.wurlod]

Let's start with: DataStage BASIC does not use semi-colon (or any other) statement terminators. Your code has a lot of empty comments in it.

DSSetUserStatus subroutine does not (despite what some help claims) store anything in the log. It is stored in the job's user status area, from which it can be retrieved in a sequence by accessing the Job activity's $UserStatus activity variable.

[chulett]

chulett: if you think i can get rid of if statement, what's the way to work around it.

Posted that in my first reply.