not able to use IsNull

[bhargava129189]

Not able to use IsNull function in derivations of transformer.

[balajisr]

Not able to use IsNull function in derivations of transformer.

Can you post the error message or can you give us some more details about it

[bhargava129189]

The compilation error is shown below.
This kind of error also comes when using jobparameter in the transformer stage.
Infact was not able to use any of the NULL Handling functions.

once i remove the job parameters and null handling functions from the transfomer stage its compiling without any errors.



Compilation report:::

Output from transformer compilation follows:

##I TFCN 000001 00:14:50(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 00:14:50(001) <main_program> orchgeneral: loaded
##I TOSH 000002 00:14:50(002) <main_program> orchsort: loaded
##I TOSH 000002 00:14:50(003) <main_program> orchstats: loaded
##I TFSC 000001 00:14:50(006) <main_program> APT configuration file: /dsstg/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 00:14:50(007) <main_program>
This step has no datasets.

It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node0[op0,p0]
)}
It runs 1 process on 1 node.
##W TCOS 000049 00:14:51(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (Nxrp_Trn_Tfs_Gos_Dtl_P2.Tfm_Insert)

[ray.wurlod]

Did you type the function name, or choose it from the Expression Editor? IsNull (and the other null handling functions) should be built in. Have you edited the DSParams file on the server to make them inaccessible?

[Krazykoolrohit]

can you post the expression syntax? are you forcing null on a non nullable field?