Hi Marten, I extract tables from Adabas-D (13.0) with the following syntax:
dataextract * from <tablename>; id 01-11 field1 12-27 field2 28-30 field3 31-285 outfile <filename> DEC '//./' DATE 'YYYY-MM-DD' TIMESTAMP 'YYYY-MM-DD HH:MM:SS' There are no problems with fixed columns. Alternative: dataextract * from <tablename>; outfile <filename> DEC '//./' DATE 'YYYY-MM-DD' TIMESTAMP 'YYYY-MM-DD HH:MM:SS' compress (fields are encased with apostrophes) Greetings Uli ____________________________________________________ Ulrich Lickert, Universitaetsklinikum Freiburg Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg Tel +49-761-270-2265 Fax +49-761-270-2066 E-Mail [EMAIL PROTECTED] WWW: http://www.uniklinik-freiburg.de/ Marten Feldtmann <[EMAIL PROTECTED]> schrieb am 05.02.2006 21:48:54: > I have an old Adabas-D database and I try to export and import > the database to another database. > > Now I used the ASCII export function > > DATAEXTRACT * from table > > but the results are somewhat strange. In one example I have > two fixed(10,0) columns and the result in the files are > > 8 194| 0 > 8 193| 1 > > Here is a thousand delimiter (a space) within the numbers. How > can I get rid of this space ???? This space is in all of my > exported ASCII files. > > To summarize: how do I get: > > 8194| 0 > 8193| 1 > > > > Marten > > -- > Marten Feldtmann - Germany - Software Development > Information regarding VA Smalltalk and DMS-system > "MSK - Mien Schrievkrom" at: www.schrievkrom.de > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/maxdb?unsub=ulrich. > [EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
