Hi all,
When i compiled the job i am gettine this error
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 18:15:34(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4458
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 18:15:34(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 18:15:34(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 18:15:34(003) <main_program> orchstats: loaded
##W IIS-DSEE-TCOS-00036 18:15:35(000) <main_program> Failed to initialize job monitoring. Monitor information will not be generated.
##W IIS-DSEE-TOSH-00049 18:15:35(001) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W IIS-DSEE-TFTM-00012 18:15:35(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E IIS-DSEE-TFTK-00001 18:15:35(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E IIS-DSEE-TFPS-00012 18:15:35(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
##E IIS-DSEE-TFTK-00001 18:15:35(005) <transform> Error when checking composite operator: Unexpected tokens: ; [line 39,character 23].
##E IIS-DSEE-TFPS-00038 18:15:35(006) <transform> Error when checking composite operator: Expected right paren; [line 39, character 23].
##E IIS-DSEE-TFPS-00038 18:15:35(007) <transform> Error when checking composite operator: Expected right paren; [line 39, character 24].
##E IIS-DSEE-TFPS-00038 18:15:35(008) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 45].
##E IIS-DSEE-TFTK-00001 18:15:35(009) <transform> Error when checking composite operator: Unexpected tokens: ; [line 39,character 49].
##E IIS-DSEE-TFPS-00038 18:15:35(010) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 49].
##E IIS-DSEE-TFPS-00038 18:15:35(011) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 57].
##E IIS-DSEE-TFTK-00001 18:15:35(012) <transform> Error when checking composite operator: Unexpected tokens: ; [line 42,character 14].
##E IIS-DSEE-TFPS-00027 18:15:35(013) <transform> Error when checking composite operator: Expected an operand; [line 42, character 12].
##E IIS-DSEE-TFPS-00038 18:15:35(014) <transform> Error when checking composite operator: Expected semi-colon; [line 42, character 14].
##E IIS-DSEE-TFSR-00019 18:15:35(015) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 18:15:35(016) <main_program> Creation of a step finished with status = FAILED. (CopyOfCopyOfp_SuspectDetMatch_Identifier.Transformer_71)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S71_CopyOfCopyOfp_SuspectDetMatch_Identifier_Transformer_71 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 InpExtrData;
0007: outputname 0 DSLink73;
0008:
0009: global {
0010: // Job parameter declaration
0011: ustring $Enttest;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: // declare our intermediate variables for this section
0022: ustring InterVar0_0;
0023:
0024: // initialise constant values which require conversion
0025: InterVar0_0 = "= B.";
0026: // Stage variable declaration and initialisation
0027: string StageVar0_StageVar;
0028: StageVar0_StageVar = "";
0029: }
0030:
0031: mainloop {
0032: // initialise our row rejected variable
0033: RowRejected0 = 1;
0034:
0035: // declare our intermediate variables for this section
0036: string InterVar0_1;
0037:
0038: // evaluate the stage variables first
0039: StageVar0_StageVar = (($Enttest + InterVar0_0) + $Enttest);
0040:
0041: // evaluate columns (no constraints) for link: DSLink73
0042: InterVar0_1 = $Enttest;
0043: DSLink73.SQLQUERY = (InpExtrData.SQLQUERY + InterVar0_1);
0044: writerecord 0;
0045: RowRejected0 = 0;
0046: }
0047:
0048: finish {
0049: }
0050:
*** End of Internal Generated Transformer Code
thanks
bmsk
Facing the Transformation compilation error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Why are you assigning "=B." to be the value of a stage variable and follow it with an add operation ? You cannot add characters.
If you need to concatenate them, you must use a colon (':') operator. If you need any mathematical derivation, you use stage variable as the names.
Maybe providing more details on what you are trying to accomplish may assist others to guide you.
If you need to concatenate them, you must use a colon (':') operator. If you need any mathematical derivation, you use stage variable as the names.
Maybe providing more details on what you are trying to accomplish may assist others to guide you.
-
- Participant
- Posts: 62
- Joined: Thu Feb 08, 2007 6:01 am
- Location: Pune
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
The error lies with this line :
0011: ustring $Enttest
Are you using any Env variable "$Enttest" in a transformer? This is the cause of the error.
Solution : use GetEnvironment ('$Enttest') in your transformer stage
The error lines from your post :
##E IIS-DSEE-TFTK-00001 18:15:35(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E IIS-DSEE-TFPS-00012 18:15:35(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
[/b]
0011: ustring $Enttest
Are you using any Env variable "$Enttest" in a transformer? This is the cause of the error.
Solution : use GetEnvironment ('$Enttest') in your transformer stage
The error lines from your post :
##E IIS-DSEE-TFTK-00001 18:15:35(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E IIS-DSEE-TFPS-00012 18:15:35(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
[/b]
Nikhil
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am