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
What is the maximum display length in a Sequential file?
Moderators: chulett, rschirm, roy
Re: What is the maximum display length in a Sequential file?
But is the output correct to you if you look at it outside of DataStage?
Ogmios
Ogmios
In theory there's no difference between theory and practice. In practice there is.
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.
You're better of using vi or pg or more to inspect the file.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Field length
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
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
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle