Let's say I have adopter connect to MS SQL DB Server, and there is over 100+ tables in there and increasing table amount frequently. Is there a way to automatically create those synonyms into an application directory? (** Table name and fileds' name and amount of fields may be different from each table)
And instead of a DB, what if there is 100+ of .csv that need to be create synonyms automatically into an application directory?This message has been edited. Last edited by: nox,
WebFOCUS v8.2.06 , Windows
June 10, 2020, 03:47 PM
Waz
For DB tables, there is a CREATE SYNONYM command.
For CSV, no, as its extremely difficult to determine the content of a field. Many assumptions would need to be made. Even the number of columns may be difficult if some rows have more columns than others.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
June 10, 2020, 10:37 PM
nox
Thanks Waz.
I'm reading these topics to try figure out how to use, thanks for the hint: