• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is the difference between static vs dynamic in SQLJ

 
bob morkos
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I dont know the difference, could anyone explain. In my application I will have pagination functionality. Does that mean it's dynamic?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic