DSXchange

HI, I have a requrement like i need to do range lookup. Here i have my input file 123,167,7362,245,SDCCAT,3456,150,MED,MIB,H,ABCD,XYZ,JKH,VI 123,167,7362,245,SDCCAT,3456,150,MID,MIB,H,ABCD,XYZ,JKH,VI LookupFIle:(ONE RECORD) 123,%,NOT50,(200-300),SDC%,3456,(100-50),MED,MIB,H,ABCD,XYZ,JKH,VI,MEDICARE ...

HI,

Use a schema file (RCP) and specify a key column in the compare stage which you want to do comparision.It should work.

Thanks
Uma

How can i give the path in the c++ code.

can you please give me an example with the code i have posted

Thaks
Uma

HI, can any one help me how to write a c++ routine using api functions in parallel job.i wrote the code like below #include <dsapi.h> DSPROJECT DSOpenProject( char *ProjectName ); DSJOB DSOpenJob( DSPROJECT ProjectHandle, char *JobName ); int DSGetJobInfo( DSJOB JobHandle, int InfoType, DSJOBINFO *R...

Hi, i am using schema file to define metadata.when i use schema file no column definitions are present in the transformer.for straight passing the data it is working fine.if i want to apply some logic like trimming,testing for null values like that how can i do that in transformer because no meta da...

HI, I am getting following error when i compiled parallel job with transformer.other than transformer all other stages are working fine. here is the error ##I TFCN 000001 18:28:27(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corp...

I installed Ascential pack for oracle applications

Thanks
Uma

Hi,

I installed ascential pack for oracle apps and is working fine in server job.when i tried to use this stage in parallel job it is giving the following message

(40906) unable to create the new object

Please any one help me to come out from this issue
Thanks
uma

I dont know what are the equivalent functions in c++ for these basic functions OCONV(Arg1,'MB0C') and ICONV(InString[Nibble,4],'MB')

Thanks
Uma

Hi,

I have a requirement to convertcobol comp-3 signed packed decimal into an integer.In server job we have a routine to do this.is any one know c++ code to convert comp-3 signed packed decimal into an integer.

Thanks
Uma

I am using Isnull function in a transformer to check whether it is a null or not. Isnull(DOB_LOAD_KEY):Stagevar when i compile the job i am getting the following compilation error. If i remove this condition job is compiling successfully and is working fine. Output from transformer compilation follo...

i have 199 records from the input file and 199 records from the table with zipcode and zip_code_key.so i am doing look up against zipcode if zip code is not present in the table i need that not found record only. In the input file only one record has no match in the table.so i am expecting one recor...

my user defined query is below SELECT DIM_ZIP_CODE.ZIP_CODE_KEY,DIM_ZIP_CODE.ZIP_CODE FROM perform_owner.DIM_ZIP_CODE WHERE rownum < 200 after this when i view the data it is showing the data .when i run the job it is aborting and is giving this fatal message DIM_ZIP1..Oracle_OCI_19: ORA-01036: ille...

when i use colukmn generated or user defined sql it is working fine.but one thins i do not understand this where clause WHERE DIM_ZIP_CODE.ZIP_CODE=:1 why it is generating even if i dont give any thing SELECT DIM_ZIP_CODE.ZIP_CODE_KEY,DIM_ZIP_CODE.ZIP_CODE FROM perform_owner.DIM_ZIP_CODE WHERE DIM_Z...

I am using sequential file as input file and oracle oci stage as reference table and i am doing lookup in a transformer in server job. It is not working it is giving the following error. DIM_ZIP1..Oracle_OCI_8_15: ORA-01036: illegal variable name/number After that i wrote all the records from the ta...