Re: SQL syntax - wildcards?

Posted in 1997

Alton B. Coalter — Wed, 06 Aug 1997 16:15:11 -0700 — source: Informix-list mailing list archive (1991-1998)

Certificate Service Administrator wrote: > > Can one pass a wildcard character into following Informix SQL statement? > > LOAD FROM "BlobRec?.unl" INSERT INTO Blob_Table;> > I need to dynamically define file name for loading blob data into my > database. Unfortunately, it doesn't seem to work. > I am running Informix-OnLine Worgroup Server (ver.7.12) under WinNT. for file in *.unl do dbaccess databasename - <<-EOF load from $file insert into tablename EOFdone