DSXchange

Hi Daniel,

Yes your code will return year part.....

and also you can get year part doing substring
(2006-09-28 00:00:00)[1,4] will return year part '2006'

Guys,

I pinned it.........It's VarBinary, I changed datatype and re-created table,
Now it's fine.....

Thanks Guys......In helping me to narrow down the error.......

Rasi.........I didn't find most of your listed datatypes in Oracle-OCI stage in DataStage.

I remember one field is defined as VarBinary........does it make any difference........

Rasi.........I didn't get you

RAW data type

.........That's what I have planned to do........firtst thing in the morning.........

No......I am sure..........I cheked it

More info.........

I have re-created table with new name..........even this didn't help me.

It's simply INSERT INTO auot generated plug-in query........

Rasi,

Thanks............But The topic or post you replyed with does not exist....

I got this in google search, here what i am trying to understand is wether is it DataSatge error or Database error.What is the actual cause of this error.

It would be great if some one help me to defferentiate and understand for better solution.

Thanks
Mitta

Hi Guys,

I am loading data from flat file into ORACLE table, It's returning error with

ORA-01465: invalid hex number

.

Any Clue what is causing this error.

Thanks
Mitta

Suneel,

"suneel reddi" = Trim("Remove..all..Spaces....", " ", "A")
* ...returns "suneelreddi"


Trim("suneel reddi"," ","A") Returns "suneelreddi"

Goodluck
Mitta

We have Server and Client is on NT.

One more issue i have is Can we Write to A reject file from Derivation if Condition Fails., Any one ...any iformation on this would greatly help me.

Thankyou

TRY THIS....GOOD LUCK

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE READONLY = 'RO';

SRIMITTA