DSXchange

a >=b then a=a-b update 'a' value in lkp table
a<b then remaining.b=a-b update 'a' value as '0' for that record.

Read next record a>=remaining.b then a=a-r.b update a value in lkp table.
A<r.b then r.b=r.b-a update a value as '0'

this condition will run upto 'A' value become

we need to start looping but should not load data so the logic is correct IM_ITEM_NBR='xx'

The requirement is we need to start the loop and should not load data so in where clause we are using this IM_ITEM_NBR='xx' its working fine now.

Bingo..Iam using varchar Datatype.But it is working fine in Toad(with no records) if I give IM_ITEM_NBR <> 'xx' it is giving me the whole data and ds is also behaving like oracle.

SELECT IM_ITEM_NBR, IM_MAKE_BUY_CODE, IM_ENG_REV_DATE, IM_ITEM_STATUS, IM_COST_CTL_CODE, IM_PLANNER, IM_ITEM_DESC, IM_UNIT_MEAS, IM_ITEM_TYPE FROM S07_IMF_DLPIMF where IM_ITEM_NBR='xx'

Please suggest me

I have taken out the where clause "column name='xx' " then it is working fine.Just wanted to give column name='xx' I should not get any errors. How to do that any suggestions

Compiling: Source = 'RT_BP104/JOB.1569753324.DT.156148395.TRANS1', Object = 'RT_BP104.O/JOB.1569753324.DT.156148395.TRANS1' ************************************************************************************************************************************ Array 'rtRowStatsCount' never dimensioned. ...

Oracle Enterprise Stage--->Transformer--->Dataset

when Iam viewing data iam getting the error

I checked all the datatypes,table names,column names and data contents still Iam getting the same error.
##F IIS-DSEE-TDOR-00491 06:40:53(007)<main_program>: Fatal Error: Invalid character encountered in table S17_DLPTGF_TLF

Hi Ray which things I need to see for my error.

Hi All,

Fatal Error: Invalid character encountered in table
When I run the a Job it is giving me the above error.
Please suggest me.

Hi Ray,

Thanks for suggesting me. I have given the DSN name correctly now and its working fine now.

Iam on the windows still it is showing the same error

Hi All,

I have got below error when viewing Data from the ODBC Stage.
Please guide me what needs to be done further.

Fatal Error: Could not connect to datasource?? (-1; eto; eto; [DataDirect][ODBC lib] Data source name not found and no default driver specified)
> :
>

When Iam compiling my Jobs Iam getting this error.
"This Job contains one or more unattached links, all the links must be attached before compiling"
Please do the needful for me
This is an PX Job on Windows Platform