DSXchange

One what implies the same as the other what? As noted, the lookup defined on the LHS implies nothing, it signifies the key to use in your lookup. It's up to you to define how that lookup is used and if the result of the lookup is significant wrt your output, constrain based on the result. Not sure w...

I was thinking of a different patch. Let us know what you find out. Description: Oracle OCI stage (ORAOCI9) incorrectly binds the lookup column values to the SQL statement which is being executed. This results in the Oracle database error "ORA-1008: Not all variables bound" [ECASE 73423]. Also inclu...

Nothing wrong with your SQL and the data is obviously getting loaded fine, so you've got some odd issue with View Data. Report it as a bug to your Support Provider, I *think* there may be a patch available.

sheema wrote:The sql is Generated SQL and it has To_Date().
I am getting the error when i click view data

ocixyz: ORA-01821: date format not recognized

ocixyz.DSLink1: DSP.Open GCI $DSP.Open error -100.

Post the SQL so we can see what is actually being generated.

The source data which i am getting is of datatype Varchar(10) and it is in the format mm/dd/yy. I am converting it in transformer using OCONV(ICONV(Date,"D/MDY[2,2,4]"),"D-YMD[4,2,2]"):" 00:00:00" Then i have datatype of the date fields in the oraOCI set to Timestamp(19). The date datatype in the t...

i have updated it with a space as below OCONV(ICONV(Date,"D/MDY[2,2,4]"),"D-YMD[4,2,2]"):" 00:00:00". But it not solve my problem,the data is getting loaded but i cannot view the data through oraOCI stage. What does this mean? Why "cannot view", what happens when you click View Data? Please verify ...

yes,that is the data which i am inserting.the date appears in mm/dd/yyyy format in TOAD. Means nothing. Toad uses specific date masks for display, set in the options - can be anything you want. I knew that DB2 accepts internal date format,so i was not sure that Oracle also accepts the internal date...

Sure... read about or search here for use of the FMT function.

One warning in every job every time it runs. Problematic for Server jobs that are assumed to run 'error free' every time. Arnd - not sure. My client ordered licenses for a new 7.5.2 Server install about 6 months ago and it came that way. Very confusing until I had someone at IBM 'splain it to me.

DSguru2B wrote:But I am not sure how much grace period you get with those warnings. Someone else can throw some more light on that.

None.

This depends on your licensing that is currently in effect. Newer versions give you two auth codes - one is your entitlement code for Support which shows what you've licensed and the other is what you actually use when you install the product. It has no limits built in. Honor system and all that rot.

Oh, crap... didn't even notice that this was a TX question. Should have tumbled to that when you said 'map'.

Andy, you need to repost this down in the forum dedicated to TX if that's the case, the experts on that product only seem to hang out there.

Welcome Andy. :D You've picked an interesting problem for a newbie to solve. I don't have time to do this answer justice, but check out a few things: * Define the record to be read as one long varchar, a single string. * Use the Field function in the first transformer to split the record around the ...

Thanks for the reply but the last reply from Craig in the post is truncated. That means you need to get 'Premium Membership'. 'Premium Membership' - I thought this is a free Forum. Anyway, Can someone provide me the solution to fix this issue? Every older post of 'ours' from before the conversion t...

Describe your job, the stages used and which transformer is the one having @INROWNUM issues. Please.