What is the maximum display length in a Sequential file?

[DSmamta]

Hello all:

I extract a message from a MQ Message queue and parse it into a sequential file. The variable in the sequential file in which I want the whole message to come into is set to longVarChar and length is set to 999999 and display to 999999. However when I try to view the output column I am able to view part of the message but get the following error message.

Warning: Data that exceeds the maximum display length has been truncated.

How can I overcome this problem?

Thanks in advance.

MJ

[ogmios]

But is the output correct to you if you look at it outside of DataStage?

Ogmios

[kcbland]

If your column is that wide in content you will want to inspect the contents from the command line as the client job has limited functionality to do so. You cannot resize a column wider than the screen, as you can't stretch the column big enough. Plus, the left-to-right scrolling is not well built. Also, you can't do string searches within the column.

You're better of using vi or pg or more to inspect the file.

[DSmamta]

Hi:

Thank you for your responses.

Yes I am able to view the output column by copying the output line to a word file and see that the data is showing up correctly. However, I would like to know the maximum length of these fields.

I think that the maximum message length (MAXMsgLength) is 4 MB or 1048576 bytes. That means the field length as well as the field display cannot exceed 9999999 ....right..?

Thanks,
MJ

[DSmamta]

Thank you all for your replies.

Yes, using the vi editor is the best way to view the input file content.

MJ

[kcbland]

On a fixed width file the Display setting sets the maximum width of the data that can go into that column and will pad accordingly.

I hope you're using a delimited file, in that case you do not have this limitation. The Display setting only pertains to viewing data, as far as writing data to the file there's a practical limit, but it's really huge.