IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Convert Char to Decimal field with sign in Batch query

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
trilokdewangan



Joined: 19 Jun 2008
Posts: 20
Location: Bangalore
Posted: Tue Aug 19, 2008 3:50 pm    Post subject: Convert Char to Decimal field with sign in Batch query  
Hello,

I am using a batch job to run a DB2 SQL query. I am selecting a char field to convert it in Decimal, I am not able to get sign. Please advice.

Foe example I have Column ABC which is declared as char and has following values:

-900.00
856.12
-4526.00

my query is

SELECT CHAR(DECIMAL(ABC),9,2)
FROM TABLE

I am getting output as
0000900.00
0000856.12
0004526.00

I missed - sign. Please suggest

Thanks,
Trilok
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM