DSXchange

I have Tried that already ..
It gives me 'feb'...I need Feb..

Yes!..I can do it with Downcase..
But, Plse!...give me a stright way..
Kalpna

Hi! Srini
Even we are using the MQ Plugin to load Xml files into Datastage environment..
Can you tell, where exactly you are failing to do that?

Kalpna

Hi!
I was trying to convert 20040202 format to 2004-Feb-02
I used
Oconv(Iconv('20040202', 'DYMD [4,2,2]'),'D-YMBD [4,3,2]')
But, it gives me
2004-FEB-02

Don't shout at me....
I have gone through 12 pages of search....
worked on it...cameup with this solution..but,...

Kalpna

Hi! Naveen

Sorry! I didn't get you..
in my job, Iam using a oracle stage as my target with truncate and insert option...

siva!..
its in development...

Kalpana

And onther thing is ..
when i try to insert a row from sql prompt, i am successfull!!!

Hello!! Everyone
Yes!..I think its not a datastage issue.
But,I am writing the same output to sequential file and Oracle.
I failed to understand one thing that,'Y is it not loading to sequential file,if it is a database issue?'

Hi Friends
I got this error while loading to Oracle table.

ADatabaseLoad..TargetDBase: ORA-00054: resource busy and acquire with NOWAIT specified

does it mean that, there is a lock on target database?

Any clue???

Kalpna

Hi! Poorna
I was refering to
Xml input-->Output Tab-->Columns-->Description
There you have your xml path defined for each column.

Kalpna

Hi! Poorna

in your Xml path definition(in xml input stage) make sure that, you also enter text()
I.e:......../../../Organization/text()

Kalpna

OOh!.....
I managed to solve my problems..
I just wrote a routine to change the file format!!....
this didn't flash b4

Kalpna

No!....

Thanks Arnd!!!!
I forgot to c Quote char.


Thanks
kalpana

Hi! friends I am using a EReplace function in my transformer and writing to a sequential file. the output is in the string format. i mean it is enclosed in '"'(double quotes) But, i need it without those quotes. i found a function called StringToRaw() in help. But, the DS does not recognise it ...

No!...
There is no one else working on datastage

HI1 I am stuck in my job since 4 days.. I couldn't figure out the problem.. I tried posting here on this forum..but, didn't get much help on it. Can Someone tell me How to contact Ascential support. please!..let me know, if someone handled this type of files b4. (Please...excuse my ignorance!!!!!!!!...