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,

These are variables that WebFOCUS updates after executing a MODIFY command.

Ok Daniel thnx.
Based on your answer can you then answer my questions?

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

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

Ron,
I suppose you suppose right...

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.

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