topic Re: Fixed Width / Length for OPEN DATASET in Application Development and Automation Discussions

Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:07:41 GMT

Hi All,

Is there a way to recreate in OPEN DATASET the functionality that WS_UPLOAD have particularly on adding spaces at the end of a record.

WS_UPLOAD uses the flag :

trunc_trailing_blanks = ' '

trunc_trailing_blanks_eol = ' '

Thanks and best regards!!!

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:13:27 GMT

Try using 'Length len' addition with TRANSFER statement.

TRANSFER f TO g LENGTH len.

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:18:23 GMT

Hi KLL,

First of all, WS_UPLOAD does not have those parameters. Please check IMPORT parameters of WS_UPLOAD. Also, WS_UPLOAD does not add spaces at the end of the record.

Parameters trunc_trailing_blanks = ' ' and trunc_trailing_blanks_eol = ' ' are present in IMIPORT parameters of GUI_DOWNLOAD.

Hence, please reframe your question.

Reward points if the answer is helpful.

Regards,

Mukul

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:48:57 GMT

Hi All,

Is there a way to recreate in OPEN DATASET the functionality that GUI_DOWNLOAD have particularly on adding spaces at the end of a record.

GUI_DOWNLOAD uses the flag :

trunc_trailing_blanks = ' '

trunc_trailing_blanks_eol = ' '

Thanks and best regards!!!

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:52:11 GMT

Thanks Darshil.

May I know how do you do it on READ DATASET

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 22:54:53 GMT

Sorry I read DOWNLOAD rather than UPLOAD earlier.

try

READ DATASET dsn MAXIMUM LENGTH len.

Just to add here,

here length is considered is bytes if the file is opened in byte mode and it will be considered in characters if it is opened in text mode.

Reward all useful answers.

Re: Fixed Width / Length for OPEN DATASET

Former Member — Mon, 02 Jul 2007 23:00:32 GMT

Hi,

No, you can not add spaces at the end of the record using OPEN DATASET statement.

You can vary the length of the variable to keep some empty spaces at the end of the record.

Reward points if the answer is helpful.

Regards,

Mukul