dbTalk Databases Forums  

Creating DDFs for Cobol Data Files

comp.databases.btrieve comp.databases.btrieve


Discuss Creating DDFs for Cobol Data Files in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Karl Friedrich
 
Posts: n/a

Default Creating DDFs for Cobol Data Files - 12-03-2003 , 05:33 AM






Hello,

I have to create DDFs for legacy applications with with cobol data
types, especially in Comp-3 format. We use P.SQL7 SP5.

Since there are many files and a lot of them have more than 100 fields
(from which only some are needed) I tried to group blocks of fields to
one string-type field. This is also necessary because some data is
redefined so there can be text or numbers in one field depending on
another field in the record. (Yes, I know, the data structure IS
awful)

But when I look at such a composite field I see only data up to the
first occurence of 0x00 (as part of a Comp-3 field)

For example: Given the following fields
text1 alphanumeric 30 Bytes
value1 numeric (9 Bytes) comp-3 compressed to 5 Bytes
text2 alphanumeric 30 Bytes

I define the composite field
text char 65 Bytes

and I see only data in the first 30 Bytes if value1 contains a value
which results in a compressed value with 0x00 in the first bytes. If
all bytes of value1 are greater than 0x00 then I can see all 65 bytes.

It looks like type char does what I expect from the type zstring

I tried this with BTSearch, the Data Manager by Classic Software and
V8 SDK Control Center.

Is there any way to get a complete string beyond 0x00 or have I really
to define hundreds of fields manually???

TIA

--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.