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,
WebFocus thru Dev Studio version 7.6.11 Dev Studio on Windows Xp, Webfocus Client on UNIX basing on TOMCAT and DB2, Reporting Server on MVS , USS and on UNIX
June 30, 2009, 09:06 AM
GinnyJakes
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.
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!
July 07, 2009, 12:49 PM
philippe@Nantes
HI Ginny and Waz The solution was right. The FORMAT ALPHA complement was THE good one. Thank you for your help.
WebFocus thru Dev Studio version 7.6.11 Dev Studio on Windows Xp, Webfocus Client on UNIX basing on TOMCAT and DB2, Reporting Server on MVS , USS and on UNIX