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  WebFOCUS/FOCUS Forum on Focal Point     [closed] MODIFY syntax help
Go
New
Search
Notify
Tools
Reply
  
[closed] MODIFY syntax help
 Login/Join
 
Platinum Member
posted
Here is what I'd like to do:

Modify DB_TABLE_ABC from TEMP_INPUT, match KEY1 and KEY2, insert or update COL1; set MOD_TYPE='Updated' if there is a match in the table, set MOD_TYPE='Inserted' if there is no match and insert the record.

What is the correct syntax?



TABLE FILE TEMP_ABC
PRINT 
KEY1
KEY2
COL1
ON TABLE HOLD AS TEMP_INPUT FORMAT ALPHA
END


MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON MATCH   UPDATE  COL1 MOD_TYPE='Updated'
ON NOMATCH INCLUDE COL2 MOD_TYPE='Inerted'
DATA ON TEMP_INPUT
END
-RUN




Thanks!

This message has been edited. Last edited by: bug,


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
 
Posts: 147 | Location: Toronto (GTA) | Registered: May 25, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this approach:
MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON NOMATCH COMPUTE MOD_TYPE='Inserted';
ON NOMATCH INCLUDE 
ON MATCH   COMPUTE MOD_TYPE='Updated';
ON MATCH   UPDATE  COL1 MOD_TYPE
DATA ON TEMP_INPUT
END


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This works! Thank you so much Alan!

quote:
Originally posted by Alan B:
Try this approach:
MODIFY DB_TABLE_ABC
FIXFORM FROM TEMP_INPUT
MATCH KEY1 KEY2
ON NOMATCH COMPUTE MOD_TYPE='Inserted';
ON NOMATCH INCLUDE 
ON MATCH   COMPUTE MOD_TYPE='Updated';
ON MATCH   UPDATE  COL1 MOD_TYPE
DATA ON TEMP_INPUT
END


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
 
Posts: 147 | Location: Toronto (GTA) | Registered: May 25, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
There are still MODIFY manuals on the documentation site, but they are a little difficule to find.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6105 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [closed] MODIFY syntax help

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