7 replies to this topic

[Raul Fernandez]

Hello,

I'm working with C-ISAM file. I defined an ASCII file with external format flagged as YES and file type SEQ.

The problem:
my output file has fixed length, so I decide to define a field for each field requested. When I run the function I received the following error:

101 - INVALID EXTERNAL TYPE
< FILE NAME >
LS #: < ls screen were fields are assigned >

Then I decide to change the fields for just one with the full size (359 chars). I'm not longer getting the error describe above but instead I'm getting other one describe below:

Because the record is a fixed length I fill the field with space to complete the field length. The weird thing is that at the end of the record PROIV is not writing the spaces I'm telling to. By the way I'm writing CR+LF at the end of the line.

Thank You
Raul Fernandez

[Stuart Burton]

Setting the external type on the field of the sequential file to ALPHA should do the trick.

[Shaun Rudland]

G'Day Raul,

See posting thread on 29/09/01 from S Kater.

Also, because PRO-IV strips trailing spaces you will need to place a character in the last position of your last field; maybe an asterisk (*) or some such.

Regards

Shaun

[Shaun Rudland]

... apologies, should read September 20 not 29.

[Wim Soutendijk]

If you set the external file type to BIN instead of SEQ, PRO-IV will not strip the trailing spaces anymore.
It also won't add an CR/LF character, so you will have to take care of that yourself.

[Raul Fernandez]

Hi, I set the external file type to BIN, but now I have all records just in one line. How can I put the records one by one?

Thanks,

Raul Fernandez

[Wim Soutendijk]

Add a field to your file definition called CRLF, len 2
Fill that with CHAR(10) if you are on unix or CHAR(13) + CHAR(10) if you are on Windows

[Aprile]

If you are simply trying to extract c-isam data records to a text file as a one-shot or occasional activity (not an automated process), you might try the demo version of Protrack utility from www.net-aware.com, as it has the capability to extract c-isam file data to a user-formatted ascii file. The DEMO version has limits on file size, but if your c-isam file isn't huge it might work for you.