HI every body
I have some problem when holding file under AIX OS.
My file is correctly cataloged with a FILEDEF command, ANd the associated Master is also correctly cataloged under the appropriate directory via APP HOLDMETA dir command.
The problem is, when I want to work later on this file.
The records seem to be truncated or missread !
Here is my code:
-SET &DIR = '/usr/local/tws/DWN1/tmp/' ;
-SET &FILE = 'HDAYLI.txt' ;
-SET &FICHIER = &DIR || &FILE ;
-TYPE &FICHIER
FILEDEF HDAYLI DISK &FICHIER
APP HOLDMETA baseapp
-RUN
TABLE FILE HFDFL1
PRINT
CLE_PDV_PDN
CLE_REF_CLI
CLE_OFF
CLE_OFF_PDN
DAT_JOU
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS HDAYLI
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N23,
WRAP=8.000000,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=8.000000,
$
ENDSTYLE
END
-END of generation fex
-Beginning of usage fex
-SET &DIR = '/usr/local/tws/DWN1/tmp/' ;
-SET &FILE = 'HDAYLI.txt' ;
-SET &FICHIER = &DIR || &FILE ;
-TYPE &FICHIER
FILEDEF HDAYLI DISK &FICHIER
APP PREPENDPATH baseapp

TABLE FILE HDAYLI
PRINT
CLE_PDV
CLE_PDV_PDN
CLE_REF_CLI
CLE_OFF
CLE_OFF_PDN
DAT_JOU
WHERE RECORDLIMIT EQ 1000
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.000000,
....
END

Thank's for your help.

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

Try saying ON TABLE HOLD AS HDAYLI FORMAT ALPHA and see if that helps. I have an AIX installation we hold files all the time. I also recommend using lower case to name your files.

You shouldn't have to PREPENDPATH baseapp as it is always there.

If Ginny's suggestion does not work, can you repor with some sample data, then it may be easier to spot the problem.

HI Ginny and Waz
The solution was right.
The FORMAT ALPHA complement was THE good one.
Thank you for your help.