Focal Point
Separating columns while dumping data into SQL Server from COBOL using DataMigrator

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7081057331/m/1857048486

December 09, 2016, 02:36 PM
mayur
Separating columns while dumping data into SQL Server from COBOL using DataMigrator
Does anyone have an example of how to query when Separating columns while dumping data into SQL Server from COBOL using Data Migrator?

Because in cobol copybook we structure like

Copybookfilename.cpy

03 ABC-DEF OCCURS 3 TIMES.
05 ABC-DEF-G PIC X(08)
05 ABC-DEF-H PIC S9(9)V99 COMP-3
05 ABC-DEF-I PIC S9(7) COMP-3

And I am writing query in SQL Script to load data like below

Select "ABC-DEF-G","ABC-DEF-H","ABC-DEF-I" From Copybookfilename

It loads data in as mentioned below

ABC-DEF
[[20161209,48.80,123456],[null,0.00,0],[null,0.00,0]]

Actually I want data in three separate columns like

ABC-DEF-G ABC-DEF-H ABC-DEF-I
20161209 48.80 123456
NULL 0.00 0
NULL 0.00 0

What should I do to get this?


WebFOCUS 8
Windows, All Outputs