Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Create Synonym using SQL Script
Go
New
Search
Notify
Tools
Reply
  
Create Synonym using SQL Script
 Login/Join
 
Member
posted
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.


WebFOCUS 7
Linux
Output: pdf, excel, and html
 
Posts: 9 | Registered: December 17, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
F-one,

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
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hi,

i have a script with plain sql-

how do I create Synonym using SQL script and load into table.

kat

Web Focus 7.6
Data Migrator 7.6.2 Unix


---
Insert into customer values(50,"John","Smith",2);
 
Posts: 43 | Registered: August 09, 2007Reply With QuoteReport This Post
<murali swarna>
posted
Try this,


SQL SQLORA SET SERVER XYZ
SQL SQLORA
DROP TABLE T_COUNTRY;
END
SQL SQLORA
CREATE TABLE T_COUNTRY
( "COUNTRY_CODE" CHAR(5 CHAR) NULL,
"COUNTRY_ID" CHAR(5 CHAR) NULL
) ;
END
-EXIT
 
Reply With QuoteReport This Post
Silver Member
posted Hide Post
Murali,

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,
Endre


...
 
Posts: 32 | Location: All over US | Registered: March 12, 2008Reply With QuoteReport This Post
<murali swarna>
posted
Hi Endre,

I understand your Question, basically it will create physical table, for synonym we have to create using adapter connection.

Murali
 
Reply With QuoteReport This Post
Silver Member
posted Hide Post
Murali,

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

-RUN

-WRITE ACCESSFILE
SEGNAME=xxxxx,TABLENAME=xxxxxxx,KEYS=0,$

-RUN


...
 
Posts: 32 | Location: All over US | Registered: March 12, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Create Synonym using SQL Script

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.