Hi, this is a DB2 UDB 7.1 EE on AIX 4.3.3. After executing a DB2 load command which takes input from a CD drive I can't umount the CD. I get a message saying it's in use. The only workaround I found is to stop/start DB2, which I don't like of course. Can anybody tell me if this is a bug or another way to do it? One other question: I have this Load command in a file: LOAD FROM /mntcd0/Actas.txt OF DEL LOBS FROM /mntcd0 MODIFIED BY lobsinfile pagefreespace=0 totalfreespace=0 coldel, chardel\' decpt. MESSAGES /home/hvilla/db2load.msg insert into hvilla.acta statistics no copy no indexing mode autoselect When I execute db2 -f file_name I get this error: SQL0104N An unexpected token "' decpt. MESSAGES /home/hvilla/db2load.msg ins" was found following "BY". Expected tokens may include: "<filetype-modifier>". SQLSTATE=42601 My data is ASC DEL with ' as the character delimiter. Isn't \' the way to go in AIX Korn shell? chardel' doesn't work either. Any ideas are wellcome. Kind regards, Horacio Villa TTI S.A. Buenos Aires - Argentina ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
