Can some guide me on how to create Synonym using SQL script.
I tried it but it is giving me this error:
(FOC1658) DATASOURCE/u02/app/ibi/apps/fiload/bldg_count.sql FOR SYNONYM IS NOT FOUND
Right now my sql file has plain SQL statement.
Output: pdf, excel, and html
Could it be possible for you to post the script you are using?
WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
i have a script with plain sql-
how do I create Synonym using SQL script and load into table.
Web Focus 7.6
Data Migrator 7.6.2 Unix
Insert into customer values(50,"John","Smith",2);
SQL SQLORA SET SERVER XYZ
DROP TABLE T_COUNTRY;
CREATE TABLE T_COUNTRY
( "COUNTRY_CODE" CHAR(5 CHAR) NULL,
"COUNTRY_ID" CHAR(5 CHAR) NULL
If I understand this correctly, F-One is trying to create a WebFOCUS synonym (master file and Access file). Your example creates the physical table, not a synonym for an exiting physical table,
I understand your Question, basically it will create physical table, for synonym we have to create using adapter connection.
Yes, the above will create the table, and also, you can use WebFOCUS to create the synonym (master file and access file) instead of the synonym tool.
For example if you know the makeup up a master file and an access file, just write two flat files like this:
APP PATH xxxxxxxxx
FILEDEF ACCESSFILE DISK /home/iadmin/ibi/apps/xxxxx/xxxxx.acx
|Powered by Social Strata|