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     [SOLVED] What is the exact meaning of these system variables??
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] What is the exact meaning of these system variables??
 Login/Join
 
Platinum Member
posted
Hai

using the GUI of Data Migrator. Some system variables arise questions I would like to ask.

&DUPLS
Is the number of rows rejected as a result of duplicate values in the data source.

Is this about duplicates in the source?? Or do we mean 'in the target'??
But if it is 'in the source' I programmatically have to do something about it, or it might lead to a DBMS-error, for instance SQL-code -803.

&FORMAT
Is the number of rows rejected as a result of a format error.

Is this row rejected when one of the attributes doesn't match the datatype in the master-file?

&INVALID
Is the number of rows rejected as a result of a VALIDATE condition.

Does this mean that it doesn't meet any of the VALIDATE conditions? So the whole row might be ok, only it is not selected?

&NOMATCH
Is the number of rows rejected as a result of not matching a value in the data source.

This one is totally unclear to me. Can someone explain, please?

&REJECTS
Is the number of rows rejected for reasons other than the ones specifically tracked by other statistical variables.

Hmm, this one is rather unspecific. Does this mean I have to abend my program when &REJECTS > 0??

I am asking this to be sure which rejects may abend the program, and which may not.

Regards
Ron

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 110 | Registered: August 29, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
These are variables that WebFOCUS updates after executing a MODIFY command.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Ok Daniel thnx.
Based on your answer can you then answer my questions?


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 110 | Registered: August 29, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Ronibi,

I suggest you get a MODIFY manual. In the mean time here are some basics.

The MODIFY command is used to add, delete, update records. It can do so with FOCUS files and also SQL files (if you have the authorization to do so).
A simple MODIFY syntax is as follows:
  
MODIFY FILE file
... input command
[validation]
VALIDATE ...
ON INVALID ...
MATCH keyfields [obtain a record in the database matching the input]
[record not found]
ON NOMATCH {INCLUDE | REJECT}
[record found]
ON MATCH {INCLUDE | DELETE | UPDATE | REJECT}
... data command
END


&DUPLS is incremented when ON MATCH REJECT is fired
&FORMAT is incremented if some of the input data is faulty
&INVALID is incremented if a VALIDATE condition fails
&NOMATCH is incremented when ON NOMATCH REJECT is fired
&REJECT is incremented if a record is rejected for any other reason

Other variables are also set by MODIFY:
  
&TRANS   Number of transactions processed
&ACCEPTS Number of transactions accepted into the database
&INPUT   Number of segment instances added to the database
&CHNGD   Number of segment instances updated
&DELTD   Number of segment instances deleted


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Ok Daniel, thnx

what happens when I use SQL SQDBM? I suppose those variables won't be filled then, because there is no MODIFY command as everything is handled by the DBMS?

Regards
Ron


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 110 | Registered: August 29, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Ron,
I suppose you suppose right...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
In DM, these are only applicable for Insert/Update processing where you are not using Optimize Load.

quote:
Originally posted by Ronibi:
&DUPLS
Is the number of rows rejected as a result of duplicate values in the data source.
Is this about duplicates in the source?? Or do we mean 'in the target'??

Duplicates at the target.

quote:

&FORMAT
Is the number of rows rejected as a result of a format error.
Is this row rejected when one of the attributes doesn't match the datatype in the master-file?

Yes. And also this is referring to the target formats.

quote:

&INVALID
Is the number of rows rejected as a result of a VALIDATE condition.
Does this mean that it doesn't meet any of the VALIDATE conditions? So the whole row might be ok, only it is not selected?

No. If any of the target validation rules fail, then the entire row will be rejected.

quote:

&NOMATCH
Is the number of rows rejected as a result of not matching a value in the data source.
This one is totally unclear to me. Can someone explain, please?

A nomatch is where the row does not exist in the target. For an insert update process, all inserted rows are nomatch rows.

quote:

&REJECTS
Is the number of rows rejected for reasons other than the ones specifically tracked by other statistical variables.

You have to specifically reject the row. In and insert update process, if you choose to ignore new rows, THAT is a rejected row. In other words, when you only want to update data and not insert unknown rows, the unknown rows are rejected rows.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Please be aware if you have multiple targets in your DM flow, I think the values are determined per target and than added together. I do not think there are variables per target available. If you do need those you have to split your flow into multiple flows with just one target per flow.

Martin


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] What is the exact meaning of these system variables??

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