1.

Explain What Are The Optional Parameters To The Input Dataset While Loading The Empty Cluster With The Data Records?

Answer»

i) Skip and Count :
Syntax:
SKIP(2)
COUNT(4)

In this case, the first two records are skipped and the next four records are printed. The DEFAULT for SKIP is 0, and for COUNT will be printing records from BEGINNING to end.

ii) FromKey and ToKey :
PRINT -
INDATASET (CUSTOMER.KSDS.CLUSTER) -
FROMKEY (111111) -
TOKEY (444444)
Will print all records with Key VALUE ranging from 111111 to 444444.
iii) FROMADDRESS and TOADDRESS.
iv) FROMNUMBER and TONUMBER.

i) Skip and Count :
Syntax:
SKIP(2)
COUNT(4)

In this case, the first two records are skipped and the next four records are printed. The default for SKIP is 0, and for COUNT will be printing records from beginning to end.

ii) FromKey and ToKey :
PRINT -
INDATASET (CUSTOMER.KSDS.CLUSTER) -
FROMKEY (111111) -
TOKEY (444444)
Will print all records with Key value ranging from 111111 to 444444.
iii) FROMADDRESS and TOADDRESS.
iv) FROMNUMBER and TONUMBER.



Discussion

No Comment Found