jayram99 wrote: |
Hi Kolusu,
I am correcting Below IMS Datatypes. Ex: N 009. P 004. P 003.05. What is the max digits P 004 can store(6 or 7 or 8 Digits) and also want to know help me to find equivalent data type in DB2(Deciaml(6,0) or Decimal(7,0) or Decimal(8,0)). Thank you, |
Code: |
IMS FM COBOL DB2 LENGTH ======= ====== =========== ====== N 009. PIC 9(9) NUMERIC(9) 9 P 004. PIC S9(4) COMP-3 DECIMAL(4,0) 3 P 003.05. PIC S9(3)V9(5) COMP-3 DECIMAL(8,5) 5 |
Code: |
IMS FM COBOL DB2 LENGTH P 004 S9(6) COMP-3 DECIMAL(6,0) 4 |
jayram99 wrote: | ||
Thanks Kolusu for your reply.
Initially, This is how we did analysis and made changes to our programs.
We received value(Ex :1234567) from IMS and write to File (Which can store 7 Digits) but while loading to DB2, we are having issue as it can store only 6 Digits. I don't know how you calculated as S9(4) COMP-3 and DECIMAL(4,0). |
jayram99 wrote: |
I need help on 1. can field defined as P 004 store 7 Digits or 8 Digits in IMS? 2. How to we convert IMS Packed Datatype to DB2 Decimal Datatype and I will use DCLGEN utility to generate COBOL Datatype. |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours