Importing multiple schema files

[jking123]

I have multiple > 100 schema files which I would like to import into the table definitions. Is there a way I can import multiple. The only options I found are one by one which will be a pain.

[ray.wurlod]

I'm afraid you're in for pain. Have you tried multi-select (Shift-Click or Ctrl-Click) in the drop-down list of schema file names? That's about all I could suggest.

[kumar_s]

Try to convert into COBOL layout and import. I guess it should help you in importing multiple table defenitions at a strech.

[roy]

In another thread (that was deleted)

Am afraid I have tried almost all combinations.
One way I thought of was to create a job that creates tables in temp db using schema file and then importing. From DB is the only way I saw to import multiple schemas.
I tried one but it loses all the column / record formats like field delimiter. It defaults it to a comma.

Put here to continue the original post by forum moderator.