Range lookup error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
abhik05
Participant
Posts: 28
Joined: Thu Mar 08, 2012 8:31 am

Range lookup error

Post by abhik05 »

I am using one lookup stage to get one input date value coming from source link, between a range of 2 dates coming from reference link.I have used 'range' functionality in lookup stage.After selecting correctly in lookup stage,I am getting one compilation error like below:

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 17:56:08(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.4987
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved

##I IIS-DSEE-TFCN-00006 17:56:08(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=5; -n=nabchatt; -m=Pentium
##I IIS-DSEE-TOSH-00002 17:56:08(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 17:56:08(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 17:56:08(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 17:56:09(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 17:56:11(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 17:56:11(001) <main_program> Could not check all operators because of previous error(s)
##I IIS-DSEE-TBLD-00079 17:56:11(002) <transform> Error when checking composite operator: cxx -O -IC:/IBM/InformationServer/Server/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- C:/IBM/InformationServer/Server/Projects/myproject/RT_BP2.O/V0S13_CopyOftest_Lookup_13.C -o C:/IBM/InformationServer/Server/Projects/myproject/RT_BP2.O/V0S13_CopyOftest_Lookup_13.tmp.o.
##I IIS-DSEE-TBLD-00000 17:56:11(003) <main_program> Error when checking composite operator: Output from subprocess: Compiler "cl" not found.

##E IIS-DSEE-TCOS-00029 17:56:11(004) <main_program> Creation of a step finished with status = FAILED. (CopyOftest.Lookup_13)

No error shown in lookup stage while making changes for 'range' functionality.

Please help me on this.

Thanks
Abhik.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Your compiler is not set up properly, probably environment variables. There are other current threads on this issue.

Range lookups compile to transform operators, which is why the compiler is required.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply