What is the difference between static vs dynamic in SQLJ

[bob morkos]

I dont know the difference, could anyone explain. In my application I will have pagination functionality. Does that mean it's dynamic?

[Jeanne Boyarsky]

Bob,
When you were fixing the display name to get rid of the comma in "bob, morkos", the first name got lost. It is now showing up as "morkos"

[Jeanne Boyarsky]

Now on to your question. There are both static and dynamic types of paging. Static means you get all the data in one shot. Dynamic means you go back to the database when the user clicks "next page." So the fact that you have pagination, doesn't tell you whether it is static or dynamic.

[bob morkos]

When do u used dynamic SQL? I need to implement pagination and column sorting and dont know if SQLJ static SQL support this functionality. Could you confirm. Thanks in advance for your response.

Originally posted by Jeanne Boyarsky:
Now on to your question. There are both static and dynamic types of paging. Static means you get all the data in one shot. Dynamic means you go back to the database when the user clicks "next page." So the fact that you have pagination, doesn't tell you whether it is static or dynamic.

[David O'Meara]

"morkos",
thanks for changing your display name and sorry to be a pain, but it is still not valid.

We require display names to be two words: your first name, a space, then your last name. "Bob Morkos" is valid, "bob, morkos" is not valid, and "morkos" is even worse.

Can you fix this for us please so we can get back to Java?

thanks,
Dave.