not able to use IsNull
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Tue Nov 15, 2005 9:36 am
not able to use IsNull
Not able to use IsNull function in derivations of transformer.
Re: not able to use IsNull
Can you post the error message or can you give us some more details about itbhargava129189 wrote:Not able to use IsNull function in derivations of transformer.
-
- Participant
- Posts: 18
- Joined: Tue Nov 15, 2005 9:36 am
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)
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)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio