AL11 - truncation issue

[Former Member]

Hello experts,

I am writing a file with lots of columns onto the application server as a txt file. For some reason I am not able to see all of my columns in the file written onto the server. I downloaded the file onto presentation server and everything looks fine but for some reason I am unable to see everything on application server. Any ideas whats going on here? Thanks.

I am opening my file on application server using

OPEN DATASET PFILE FOR OUTPUT IN TEXT MODE ENCODING DEFAULT .

[Former Member]

Hello experts,

I am writing a file with lots of columns onto the application server as a txt file. For some reason I am not able to see all of my columns in the file written onto the server. I downloaded the file onto presentation server and everything looks fine but for some reason I am unable to see everything on application server. Any ideas whats going on here? Thanks.

I am opening my file on application server using

OPEN DATASET PFILE FOR OUTPUT IN TEXT MODE ENCODING DEFAULT .

[Former Member]

Hello,

There is a display limitation of 255 characters when you view the file in AL11. This is a standard limitation and i dont think there is anything wrong with the code.

Vikranth

[Former Member]

I do not mind if it is just a display limitation. How can I get the complete file in this case? I tried the System -> List -> Save -> Localfile option to download the file and it has the truncated records as well. How can we get the complete file in this case?

[Former Member]

Well i thought you said you were able to view all the columns when you downloaded the file to the presentation server.

Anyways, the correct method to download the AL11 file to presentation server is using the transaction CG3Y. Use this and download. You will be able to see all the columns.

Vikranth

[Former Member]

Sorry. When I said I downloaded to presentation server I meant using GUI_DOWNLOAD FM. Thanks for the CG3Y suggestion.

Another quick question. My scenario is, I place my file on the application server and Informatica picks this file up. I do not mind if we have a display limitation (truncation) in AL11. As long as Informatica gets all of the information in the file, I am OK. We have not tested this with Informatica yet. Has anyone got any opinions whether Informatica would receive all of the information from the file placed on the application server even though we have truncation issues in AL11 display? Please share your thoughts. Thanks.

Edited by: Adrian Vlasan on Dec 24, 2009 3:52 PM

[Former Member]

Hello Adrian,

You can be well sure that you will be able to extract the whole information of the file without any problem. You have verified this yourself by using CG3Y and finding the the whole information downloaded in to your presentation server, though if not in proper format which is the task of the external process which is extracting the data. You can rest be assured that the truncation is just for display. This is a frequently risen doubt for many programmers being asked here and you can find quite a lot of posts related to this if you search.

Vikranth

[Former Member]

Thanks Vikranth.

[Former Member]

Resolved by myself.