File to SQL with joker input file
Hi,
I want to load a file which i dont know the exact name
I use the LKM File to Sql which give :
select COL C1_COL,
COL C2_COL,
COL C3_COL
from TABLE
/*$$SNPS_START_KEYSNP$CRDWG_TABLESNP$CRTABLE_NAME=FICENTSNP$CRLOAD_FILE=/fildername/File_Name.txtSNP$CRFILE_FORMAT=FSNP$CRFILE_SEP_FIELD=0x0009SNP$CRFILE_SEP_LINE=0x000ASNP$CRFILE_FIRST_ROW=0SNP$CRFILE_ENC_FIELD=SNP$CRFILE_DEC_SEP=SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=COLSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=1SNP$CRLENGTH=4000SNP$CRPRECISION=4000SNP$CR$$SNPS_END_KEY*/
At the place of the file name "File_Name.txt", i would like to write something like :
File_*.txt
or File_????.txt
Is it possible to use a character joker to remplace "Name" in the input fiel name ?
Thanks