Hi
i have data in the sequential file with signed numeric data type in 4 out of 20 columns. Could you please let me know the correct data type which i have to declare in the sequential file stage for those columns with signed numeric data.Thanks in advance
Regards,
Pavan
Signed numeric
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Sun Mar 19, 2006 5:46 am
- Location: vja
Signed numeric
if the data contains no decimal , use integer , if it contains decimal values , use decimal or double , but i prefere double because it doesn't preserve space for the datatype like decimal , it preserve space for the value it contains , so use double without specifying size or precision
Mohmmed Elgendy
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161