creating Routine in IIS 8.0.1
Moderators: chulett, rschirm, roy
creating Routine in IIS 8.0.1
Hi,
I want to create a routine for Datastage 8.0 version.
I have followed the steps given for datastage7.5 as specified inone of the posts of this forum.
Im getting the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
Please let me know if have to follow the same steps,if so how to resolve this problem or let me know the steps to be follwed for 8.0
Other problem is in 8.0 version there is no manager so, how to create the routines.
Thanks in advance...
I want to create a routine for Datastage 8.0 version.
I have followed the steps given for datastage7.5 as specified inone of the posts of this forum.
Im getting the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
Please let me know if have to follow the same steps,if so how to resolve this problem or let me know the steps to be follwed for 8.0
Other problem is in 8.0 version there is no manager so, how to create the routines.
Thanks in advance...
Re: creating Routine in IIS 8.0.1
hi In DS8, U had manager merged with designer and u got the routines inside the repository in the designer so u can create ur custom routines in that
thanks & regards
kk
kk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Now im able to create routines and but getting following error when trying to compile the job.
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
Now im able to create routines and but getting following error when trying to compile the job.
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
when i used the command
cxx -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c mike.c
to compile it gave the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
But when i tried compiling with command CC -O -c mike.c -o mike
the object code mike.obj was generated.
From the IIS designer ->routines ->right click ->new->parallel routines
Icould create the routine .
cxx -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c mike.c
to compile it gave the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
But when i tried compiling with command CC -O -c mike.c -o mike
the object code mike.obj was generated.
From the IIS designer ->routines ->right click ->new->parallel routines
Icould create the routine .