Converting from VSAM to DB2®

Routine number Routine name and function Source length required Dest length required Source PIC allowed Dest PIC allowed Note
1 CHARINT Character to Integer Y N(4) N N  
2 CHARSINT Character to SMALLINT Y N(2) N N  
3 CHARDEC Character to Packed Y Y N N  
4 CHARVCH Character to VARCHAR Y N N N  
5 CHARDATE Character to DATE Y N(10) Y (req'd) N 2
6 CHARTIME Character to TIME Y N(8) Y (req'd) N 2
7 CHARDTIM Character to TIMESTAMP Y N(26) Y (req'd) N 2
8 ZONEINT Zoned to INTEGER Y N(4) N N  
9 ZONESINT Zoned to SMALLINT Y N(2) N N  
10 ZONEDEC Zoned to Packed Y Y N N  
11 ZONECHAR Zoned to CHARACTER Y Y N N 1
12 ZONEVCH Zoned to VARCHAR Y N N N  
13 ZONEDATE Zoned to DATE Y N(10) Y (req'd) N 2
14 ZONETIM Zoned to TIME Y N(8) Y (req'd) N 2
15 ZONEDTIM Zoned to TIMESTAMP Y N(26) Y (req'd) N 2
16 PACKINT Packed to INTEGER Y N(4) N N  
17 PACKSINT Packed to SMALLINT Y N(2) N N  
18 PACKDEC Packed to DECIMAL Y Y N N  
19 PACKDATE Packed to DATE Y N(10) Y (req'd) N 2
20 PACKTIME Packed to TIME Y N(10) Y (req'd) N 2
21 PACKDTIM Packed to TIMESTAMP Y N(26) Y (req'd) N 2
22 BINSINT Binary to INTEGER Y Y N N  
23 BINDEC Binary to DECIMAL Y Y N N  
  1. A picture clause is required.
  2. The ZONECHAR and CHARZONE routines require that the source and destination lengths are the same.

Concept Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/ConvertingFromVSAMToDB2.html