DSXchange

Hi All, I am getting the ora 30036 error and not sure how to take care of this error in datastage. The job runs fine when we run it stand alone. But the error.From what I think is that this error is due to running out of tablespace .Am I correct?. Should I request DBA to increase UNDO tablespace or ...

Hello Sai,
So even if I do not define the sign as leading it would not matter...right?
Thanks

Sainath.Srinivasan wrote:The field you see is not a COMP field. It is decimal with implied sign and decimal value.

Hi gurus, I am trying to read a complex flat file in ds. I have a field which has defination "S9(6)V9(4) SIGN IS LEADING" I am not at all a COBOL person..but i understand that this is a decimal (comp3)field. but when I try to define the sign field for the decimal DS prompts me saying that ...

this hint, helped me to resolve the pbm too. thanks a lot for the input. senthil, USA.

Hi Craig, Thanks for the help. Yes I already tried to do Iconvbut the problem is that I have to get rid of the AM part in the incoming (xml) date also the date is in format d/m/yyyy hh:mm:ss AM and in future it will become dd/mm/yyyy hh:mm:ss AM. I tried to trim to get the required format but the er...

hello gurus, I am getting date(from xml) in a format 4/5/2005 11:11:00 AM I have to load it to target oracle table... the type for the field to be loaded in target is date. My problem is that the incoming date has AM ....also at present the datepart of the string is in the format d/m/yyyy...... but ...

Hi gurus. I am getting a couple of files in xml from the source which i have to load into oracle. I have never worked with xml and trying to do it using our forum and the ascential docs. i used the folder stage to extract the xml input and targetted it to oracle. I am getting a error xmltrial..Trans...

Hi Ray,
Thank you.

Hi, I have a scenario in which I have to lookup to a table with a column(having data such as DIVISION no 1) and the source table with a column(having data such as DIVISION no 1arx).I have to pass a other column (DIVISION ID)from lookup to target based on the match as above..where division 1 should m...

Edi, In sequential file stage, click on "Outputs", then "Format" and click the box (left hand side)- "first line is column names". :) Thanks ArndW ! but first line in data file doesn't have column names it have some metadata information about the file (anyway it was not...