Transformer compilation issue

[mdbatra]

Hello

Have recently installed Datastage v8.7 EE for training purpose on Windows 2008 R2 enterprise edition server.

For c/c++ compiler, as per the installation guidelines mentioned at below link:

http://www-01.ibm.com/support/knowledge ... s_cpp.html

installed
- MS visual studio .net 2003 framework
- changed the default APT_COMPILEOPT (deleted string -W/Zc:wchar_t-)
- changed the default APT_LINKOPT ( deleted -W/Zc:wchar_t- )

....but even after this set up, the job with transformer stage (seq file >> Xfm >> Dataset ) is not getting compiled . Jobs without transformer are working fine, though.

could anybody pl point to what is missed here ?

[chulett]

You'd need to enlighten us what "not getting compiled" means... what are the specific errors you get?

[mdbatra]

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 00:08:28(000) <main_program>
IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614
Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 00:08:28(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=6; -n=DEL2WDLUAD5; -m=Pentium
##I IIS-DSEE-TOSH-00002 00:08:28(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 00:08:28(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 00:08:28(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 00:08:28(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 00:08:29(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 00:08:29(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 00:08:29(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00079 00:08:29(003) <transform> Error when checking composite operator: cxx -O -IE:/IBM/InformationServer/Server/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c E:/IBM/InformationServer/Server/Projects/CHEV_IM/RT_BP3.O/V0S1_test_Transformer_1.C -o E:/IBM/InformationServer/Server/Projects/CHEV_IM/RT_BP3.O/V0S1_test_Transformer_1.tmp.o.
##I IIS-DSEE-TBLD-00000 00:08:29(004) <main_program> Error when checking composite operator: Output from subprocess: Compiler "cl" not found.

##E IIS-DSEE-TCOS-00029 00:08:29(005) <main_program> Creation of a step finished with status = FAILED. (test.Transformer_1)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
0007: outputname 0 DSLink4;
0008:
0009: initialize {
0010: // define our control variables
0011: int8 RowRejected0;
0012: int8 NullSetVar0;
0013:
0014: }
0015:
0016: mainloop {
0017:
0018: // initialise the rejected row variable
0019: RowRejected0 = 1;
0020:
0021: // evaluate columns (no constraints) for link: DSLink4
0022: writerecord 0;
0023: RowRejected0 = 0;
0024: }
0025:
0026: finish {
0027: }
0028:
*** End of Internal Generated Transformer Code

[chulett]

Perhaps...

http://www-01.ibm.com/support/docview.w ... wg21611365

[mdbatra]

Thanks, Craig ! That was a good pointer. for some reason, environment variable pertaining to compiler (VS****) was not appearing in the system variables.

1) Removed VS .Net 2003 framework and installed VS .Net 2005 Express edition and MS SDK (for windows 7 + .Net framework 3.5 SP1) instead.

2) Kept the default COMPILEOPT and LINKOPT values.

3) Amended INCLUDE and LIB system variables as mentioned for VS .Net 2005 edition per below link:

http://www-01.ibm.com/support/knowledge ... s_cpp.html

4) Restarted DS engine.

5) Checkpoint - VS*** env variable appears in job log now.

6) Tried compiling the job with transformer ....

AND IT WORKED :D

Thanks again !