[Solved]White spaces/Zeros while reading

Hi,

I have a requirement where i store values into a HOLD file and then read one by one using loop.
But i found that while reading ,i get white spaces/zeros.When i see the actual values i don't see any white spaces/zeros.

Here is the code.

-SET &ECHO='ALL';
-SET &SLNO=1;

TABLE FILE wf_retail
PRINT
DST.WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
ON TABLE HOLD AS TEST FORMAT ALPHA
ON TABLE SET HOLDLIST PRINTONLY
END


-SET MAXCNT = &LINES;
-TYPE MAXCOUNT IS &MAXCNT
-*-RUN

-SET &IORETURN = 0;
-REPEAT :end_read WHILE &IORETURN EQ 0;
-READ TEST,&LINE
-IF &IORETURN NE 0 GOTO :end_read;
-TYPE SLNO = &SLNO
-SET &HOLDNAME = 'HLD'|EDIT(&SLNO);
-TYPE HOLDNAME = &HOLDNAME
-SET &SC = &LINE;
-TYPE &SC

Any idea why it happens like that.

This message has been edited. Last edited by: srajeevan,

WF8206,Windows 7,8,10
HTM,PDF,EXCEL

Posts: 229 | Location: MI | Registered: September 13, 2017

Waz

Expert

posted

Hide Post

MY first suggestion is to remove the comma in your -READ. Your file is not comma delimited.

In fact, I would suggest using -READFILE instead of -READ.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!