I assumed that I could code MODIFY to insert records into a clustered relational table structure (just a parent and child), but I haven't been successful in inserting records into more than a single table. I could swear that you could do this, but I can't find any discussions or examples which show how it's done.

Of course MODIFY was for FOCUS databases originally, so the documentation (yes, I found it) doesn't provide examples for working with clustered RDMS tables.

Does anyone know if this is even possible? SQL pass through is not an option in this situation, nor is Maintain.

Thanks

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

I am not giving you an answer but instead asking you something and raise a point of discussion.

Bottom line, any FOCUS, Maintain or MODIFY command is translated into SQL syntax to then be performed.
So, if it's not possible to use SQL pass through, why MODIFY should be ?

When I was using MODIFY to update more than one FOCUS DB we used the COMBINE facility.

While I've used MODIFY TO update one relational table, I've never had to update more than one table in the same MODIFY.

If MODIFY can support updating more than one relational table it is possible IB used the COMBINE facility to do this.

If your doc discusses COMBINE, perhaps it might be worthwhile testing?

As a clustered master is multi segment my guess is yes.

You will have to navigate the segments to get to where you want to be. Either via MATCH {fld list} or MATCH {flds}... CONTINUE MATCH {flds} etc


Paraphrasing Toto
"Hoping to find some long forgotten words or ancient memories"

quote:

Originally posted by MartinY:
So, if it's not possible to use SQL pass through, why MODIFY should be?

I should have clarified...SQL pass through is not allowed in this particular environment. I don't know the reason, just that it's not allowed. So that leaves me with figuring out how to use MODIFY to insert records.

Maintain can easily update up to 15 tables in one procedure. If you need assistance coding this I will be happy to help.

Mark Derwin

For Modify, this may help

WebFOCUS Modify Reference


Are you going to do the update via App Studio ? or on the server ?