Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

What is the difference between static vs dynamic in SQLJ

 
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?
 
author & internet detective
Posts: 40035
809
Eclipse IDE VI Editor Java
  • 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
Posts: 40035
809
Eclipse IDE VI Editor Java
  • 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.

 
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic