DSXchange

Ray

Thanks for the reply. I did the search but that did not help much. In server job I dont see any problem but only when I open in parallel canvas , I see this number. I changed the datatypes to decimal 10,0 and even varchar but no luck .

Thanks
KP

Kevin

Yes..outside the datastage I dont see the magic number but it is only in the designer when I try to view data that I get to see this and yes I tried all SQL types in datastage but no luck

Thanks
KP

Hi

You can default the value of that column to some default value incase if it comes as null. It is like NVL in sql. If F1 is the field that you comes as null , you can specify something like

F1 = HANDLE_NULL(F1,999) in modify stage.

Hope this helps

Kevin

Actually both !! I tried to view data from Oracle stage and I ran a sample job and dumped the data into a sequential file.In both the cases I see the same magic number.

Hello all I have a column A in an Oracle table with datatype Number(10). When I import the table definition into one of my datastage jobs, this column A is getting imported as BigInt type and is not accomodating values greater than 2147483647. But I have values greater than this value in database wh...