Getting type conversion warning when transforming data

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
RudreshEswarappa
Participant
Posts: 21
Joined: Wed Aug 29, 2007 1:33 am
Location: Bangalore
Contact:

Getting type conversion warning when transforming data

Post by RudreshEswarappa »

Hi,

I am getting type conversion warning when transforming data from table to table. I have used SCD stage and the data type are varchars only.

I am getting a warning like this. Can anyone please tell me what would be the problem.

Thanks in advance.



##I IIS-DSEE-TFCN-00001 12:50:41(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:50:41(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:50:41(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:50:41(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:50:41(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:50:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 24,576.
##E IIS-DSEE-TFSR-00019 12:50:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:50: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:50: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\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(330) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\S
##I IIS-DSEE-TBLD-00000 12:50:44(004) <main_program> Error when checking composite operator: Output from subprocess: erver\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(338) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(377) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(697) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\Info
##I IIS-DSEE-TBLD-00000 12:50:44(005) <main_program> Error when checking composite operator: Output from subprocess: rmationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(715) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(862) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(914) : warning C4018: '<' : signed/unsigned mismatch

C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.dll : fatal error LNK1120: 16 unresolved externals





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

Post by ray.wurlod »

The number of reject datasets "0" is less than the number of input datasets "1".
Search DSXchange for this exact message. Or just the first five words of it.
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