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,

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.

Excellent Waz: "I would suggest using -READFILE instead of -READ." Too.

Thanks.
I am using -READFILE instead of -READ.