Hi
I would to like to convert from Decimal to Bigint.
Is this anything I have to do from Transformer stage?
Thanks
Man
Convert Decimal to Bigint
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray & Wiles,
I have imported metadata from Orchestrate, there defined as Decimal 38 ,10.
But inside lookup they changed Decimal 38,10 to Bigint. Actually there is no decimal value all are whole Integer values. I am not sure why it is convert into Decimal 38,10 from NUMBER datatype after import into Datastage.
desc stage.v_m_xref
Name Null Type
--------------------------------------------------------------------------------------MID NOT NULL NUMBER
VMKE_ID NOT NULL NUMBER
Thanks
Man
I have imported metadata from Orchestrate, there defined as Decimal 38 ,10.
But inside lookup they changed Decimal 38,10 to Bigint. Actually there is no decimal value all are whole Integer values. I am not sure why it is convert into Decimal 38,10 from NUMBER datatype after import into Datastage.
desc stage.v_m_xref
Name Null Type
--------------------------------------------------------------------------------------MID NOT NULL NUMBER
VMKE_ID NOT NULL NUMBER
Thanks
Man
Oracle NUMBER fields (with no precision/scale defined) are imported into DataStage as Decimal(38,10) by default. The import process has no visibility to the actual data values present. You are certainly free to modify the scale value in the Table Definition you imported if you desire.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
Hi
I am going to close this. I hope IBM tightened up metadata checking between DataStage and the Database considerably since 8.1. So I have re-import the metadata for this table using Orchestrate into 8.7(Since we are using ORACLE EE stage), delete the metadata from the stage and reload it.
And then I can able to convert Decimal (38,10) to BIgint from Transformer stage.
Thanks for your help.
Thanks
Man
I am going to close this. I hope IBM tightened up metadata checking between DataStage and the Database considerably since 8.1. So I have re-import the metadata for this table using Orchestrate into 8.7(Since we are using ORACLE EE stage), delete the metadata from the stage and reload it.
And then I can able to convert Decimal (38,10) to BIgint from Transformer stage.
Thanks for your help.
Thanks
Man