DSXchange

There was a datatype mismatch,thats why i am getting that error.

Hi All,
I am getting below error.can anyone help me to sort out the issue.

ODBC_Connector_3,0: [IIS-CONN-ODBC-000011] A null pointer was found where one shouldn't exist (CC_OdbcDBRecordDataSetProducer::dbsReadBindBuffers, file CC_OdbcDBRecordDataSetProducer.cpp, line 671)

thanks in advance.

I have no idea whether U (one of our posters) minds or not. Why not get yourself a premium membership? It's not expensive, at less than 30c (Rs12) per day, and definitely worth it. It also helps to keep DSXchange alive and running. thanks ray 12 rs means i will join.please let me know the process

At least two approaches suggest themselves. 1. Have another stream that bypasses the EndLoop activity. (This probably throws a warning "entered loop but did not exit".) 2. Set a flag that all ... thanks ray. i was tried with first one,but sequencer was aborted. i am unable to see u r seco...

Hi, i am taking count from the table,if count is '0' then i need to stop my process for 2hrs.But for every ten minits i have to check count=0 or greater than zero. i have created sequencer like this job---->ec---->nc---->startloop---->wff----->job---->ec---->nc----->endloop i have set the loop to ru...

Hi ,
I want to delete the first record from below example

eno,ename,sal
100,abc,16678
100,xyz,77878
100,rts,6464884

from above list i want to populate last two rows to target.

can anyone help me on this


thanks inadvance

seems to be it is database issue,i will talk to my dba.

Thanks all

Thanks ray,sorry for the late reply,i was on leave i have done that,when i am loading into sequential file it is not taking time. whenever i am trying to load the data into ORACLE i am getting this problem. i think there may be some indexes on key columns,i will check and let you know guys. thanks a...

antonyraj.deva wrote:Could you post the logic used inside the Transformer? Maybe that's what is slowing down the job.

Also it would be better to look into the number of columns and data types.

thank you tony

In transformer i am harcoded some columns and used typeconversion function

GJ_Stage wrote:Do pre-Sorting in oracle itself before creating dataset and then try.

Thanks for you reply

I have tried,still it is taking same time(45 minits) to load

Hi All, My job design is like this dataset----->transformer------->odbc connector my job is having 169000 records,i am using update then insert to load the data.It is taking 45 minits to load the data.I am using HASH partitioning in transformer and odbc stages. can anyone please suggest me how to im...

pavankatra wrote:

ArndW wrote:Your date format is incorrect, it should read "%dd-%mmm%-%yyyy" ...

thank you for your reply

i was tried ,but its not working.

there was space issue with the date,so trim the data and then applied the type conversion function.Now its working fine

Thanks for your support.

ArndW wrote:Your date format is incorrect, it should read "%dd-%mmm%-%yyyy" ...

thank you for your reply

i was tried ,but its not working.

Hi, my input is 26-feb-2010,i am reading as varchar in the source Now i want to populate into date column. i was used below function StringToDate(Trim(lk_read.expiry_date),"%yyyy-%mmm-%dd"). after executing the job i am getting output as astroids(*********) Can anyone pleaase help me to so...

Is this your first job with a transformer it in ? Is this a new installation ? Then it implies that you have not installed or configured your C++ compiler. ... thanks sainath, yes its new instalation,earlier the code was in windows.now moved to linux server.by default linux having c++ , i think it ...