View previous topic :: View next topic
|
Author |
Message |
neeraj_pathak26
New User
Joined: 02 Jun 2006 Posts: 7
|
|
|
|
Hi
I have field defined in table as decimal . it has value as 12.34.Now I am running a job to fetch this value into a flat file, there value is displaying as 1234, but I want to display it as 12.34.
Is there any way I can format this value in sql, to display as I need?
I appricate your help. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Please take the time to think before posting. SQL is hardly a DFSORT function is it ? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
Now I am running a job to fetch this value into a flat file, |
would you mind telling us what you are using to 'FETCH' these values? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
dbzTHEdinosauer wrote: |
Quote: |
Now I am running a job to fetch this value into a flat file, |
would you mind telling us what you are using to 'FETCH' these values? |
isn't that clear ? => a job
"a job" that executes "a step" either "a utility" or "a program" written in "a language" |
|
Back to top |
|
|
neeraj_pathak26
New User
Joined: 02 Jun 2006 Posts: 7
|
|
|
|
My apiologies posting it under DFSORT title. Will take care next time.
I am using DSNTIAUL, to get data into the flat file.
query is just a normal select from a table. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
char() |
|
Back to top |
|
|
|