We have an Adabas file with a column called INFO that is defined to the database as A40. The current Natural application move a mixed data type content to the column. The Natural program is written like this:
define data local
1 #column (a40)
1 redefine #column
2 #first-half (a20)
2 #packed (p5)
2 #last-half (a17)
move ‘begin’ to #first-half
move 123.5 to #packed
move ‘end’ to #last-half
move #column to the A40 database column INFO and update.
When we do a select INFO from the table (via sample java app or Infonaut), all we see is the value “begin”. It is as if CONNX ignore the packed value compressed into this A40 field as well as all text that comes after.
How can we process this INFO column in our java code via CONNX JDBC? In the data dictionary this column is define with Text.
We need to extract the packed value in our java application.
When I display INFO in Natural on mainframe using (em=hhhhh), I see the INFO column as having the right character representation + the packed representation so I know the problem is not with the storing of the data in the Adabas database.