current sequence value.

[kingganesh04]

How can i get the sequence current value without creating the program dynamically and my input is database name.

Input :

Db Name : sports.db

Expected output :

sequence name , sequence current value

 

[AndrewSmith]

Use the metaschema to get the list of all sequences. Then use DYNAMIC-CURRENT-VALUE to get the current value of each sequence (this depends on your version).

FOR EACH _sequence:
DISPLAY DYNAMIC-CURRENT-VALUE(_sequence._seq-name,"_dictdb").
END.