And if you’re a regular reader, you know that one of my inspirations for blog topics is things I learn that I think others could benefit from.

In this case, Web Sphere Commerce requires that primary keys of any custom tables that you would like to add to stagingprop consist of no more than three INTEGER(also SMALLINT or BIGINT) columns and two VARCHAR (or CHAR) columns of 254 characters or less.

updating primary key db2-36

I have an active imagination, and could imagine a couple of scenarios where having it as a DOUBLE could lead to stagingprop problems down the road.

The developers assured me that the data is all compatible with INTEGER anyway.

Wiki Toc Body","CELLTABLEOFCONTENT_MPAGE_Visible":"0","CONTENTHOLDERCELL_MPAGE_Class":"col-xs-12 col-xs-offset-0 Content Place","TOCCONTENTHOLDER_MPAGE_Class":"Placeholder","MPW0045TXTNEXT_Visible":"0","MPW0045TXTNEXTNODE_Link":"wiki? 0,,","MPW0045TXTNEXTNODE_Visible":"0","MPW0054SKIP_Visible":"0","MPW0054v COMMENT_Visible":"0","MPW0054SUBMITBTN_Visible":"0","MPW0054TABLE4_Visible":"0","MPW0054TEXTBLOCK2_Visible":"0","MPW0054TEXTBLOCK5_Caption":"","_Event Name":"","_Event Grid Id":"","_Event Row Id":"","FORM_Class":"form-horizontal Form","MPW0011":"Wiki Header","MPW0011AV16Actual Page_PARM":"wiki","MPW0011AV7Page Id_PARM":"7826","MPW0011TBCREATENEWPAGE_Visible":"0","MPW0011TBADDCATEGORY_Visible":"0","MPW0011TBADDAGROUP_Visible":"0","MPW0011_CMPPGM":"wikiheader","MPW0011v MAINMENUITEMS":[,,,,,],"MPW0011v PAGEINFOITEMS":[,,,,,,],"MPW0011v PAGETOOLSITEMS":[,],"MPW0011wcp OAV16Actual Page":"wiki","MPW0011wcp OAV7Page Id":"7826","MPW0011v PAGEID":"7826","MPW0011v GROUPADDED":false,"MPW0011v CATEGORYADDED":false,"MPW0011PAGEFULLNAME":"Primary Key Definition Property","MPW0011PAGETYPE":"0","MPW0011PAGEEDITSTATUS":"1","MPW0011PAGEVIEWSTATUS":"0","MPW0011PAGELASTVERSIONID1":"19","MPW0011v ISMAINTAINEDBYHELPGENERATOR":false,"MPW0011v ACTUALPAGE":"wiki","MPW0011GX_Focus Control":"","GX_AUTH_MPW0011WIKIHEADER":"ey J0e XAi Oi JKV1Qi LCJhb Gci Oi JIUz I1Ni J9Jne C1le HAi Oi Ix NTAz ODEy Njgz Njgy Iiwi Z3gtc Gdt Ijoi TVBXMDAx MVd JS0l IRUFERVIif Q.

Rx63Di9CZAEwch B8w Kwr ARd Z1vknl Fu Vy9MZEk Vx Stc","MPW0013":"Logout","MPW0013AV17Actual Page_PARM":"Wiki","MPW0013PROFILE_Class":"Table193x216Collapsed","MPW0013TBREGISTER_Visible":"1","MPW0013TBLOGIN_Visible":"1","MPW0013LOGOUTCELL_Visible":"1","MPW0013TBWELCOME_Visible":"0","MPW0013TABLE3_Visible":"0","MPW0013NAME_Caption":"","MPW0013PHOTO_Bitmap":"/commwiki/static/Resources/blank.jpg","MPW0013PHOTO_Srcset":"","MPW0013PHOTOTOP_Bitmap":"/commwiki/static/Resources/blank.jpg","MPW0013PHOTOTOP_Srcset":"","MPW0013LETTERCELL_Visible":"1","MPW0013PHOTOCELL_Visible":"0","MPW0013LETTERCELLTOP_Visible":"1","MPW0013PHOTOCELLTOP_Visible":"0","MPW0013LETTER_Caption":"","MPW0013LETTERTITTLE_Caption":"","MPW0013_CMPPGM":"logout","MPW0013wcp OAV17Actual Page":"Wiki","MPW0013v CONTEXT":,"MPW0013v WIKIUSERSPOLICY":"4","MPW0013v ACTUALPAGE":"Wiki","MPW0013v NAME":"","MPW0013v HTTPREQUEST_Baseurl":"https://wiki.genexus.com:443/commwiki/servlet/","MPW0013GX_Focus Control":"","GX_AUTH_MPW0013LOGOUT":"ey J0e XAi Oi JKV1Qi LCJhb Gci Oi JIUz I1Ni J9Jne C1le HAi Oi Ix NTAz ODEy Njgz Njgz Iiwi Z3gtc Gdt Ijoi TVBXMDAx M0x PR09VVCJ9.q R2L8u Ak8Vn LFi9d6f YEh Nhgb QTpxqss F4Tr Ch2x N7I","MPW0031":"Rwd Recent Links","MPW0031AV6Form Caption_PARM":"Primary Key Definition Property","MPW0031AV7Form Pgm Name_PARM":"Wiki","MPW0031MAINTABLE_Visible":"0","MPW0031_CMPPGM":"rwdrecentlinks","MPW0031Links Container Data":"","MPW0031n RC_GXsfl_12":"0","MPW0031wcp OAV6Form Caption":"Primary Key Definition Property","MPW0031wcp OAV7Form Pgm Name":"Wiki","MPW0031v ISVALID":true,"MPW0031v FORMCAPTION":"Primary Key Definition Property","MPW0031v FORMPGMNAME":"Wiki","MPW0031v RECENTLINKSITEMS":[],"MPW0031GX_Focus Control":"","GX_AUTH_MPW0031RWDRECENTLINKS":"ey J0e XAi Oi JKV1Qi LCJhb Gci Oi JIUz I1Ni J9Jne C1le HAi Oi Ix NTAz ODEy Njgz Njgz Iiwi Z3gtc Gdt Ijoi TVBXMDAz MVJXRFJFQ0VOVEx JTkt TIn0.b Mpi Ba P6IK1k Dy5of FWq-d3RXuu4a4QZu_k TNZ8_m Rs","MPW0037":"","gxhash_v BRANCHTEXT":"ey J0e XAi Oi JKV1Qi LCJhb Gci Oi JIUz I1Ni J9Jne C1le HAi Oi Ix NTAz ODEy Njgz Njgz Iiwi Z3gtc Gdt Ijoi V0l LSSJ9.e Tzf TUJ6Iy8Aht Tyr Ur Ygn Gky Y9x Tn TEAn Jjam Ijaa E","v BRANCHTEXT":"","VIEWTITLE_Caption":"Primary Key Definition Property","W0046gx HTMLWrp W0015_Visible":"0","Branchesgrid Container Data":"","W0043":"Wiki Categories","W0043AV5Page Id_PARM":"7826","W0043AV7Page Full Name_PARM":"Primary Key Definition Property","W0043MAINTABLE_Visible":"1","W0043_CMPPGM":"wikicategories","W0043Categorygrid Container Data":"","W0043n RC_GXsfl_7":"6","W0043wcp OAV5Page Id":"7826","W0043wcp OAV7Page Full Name":"Primary Key Definition Property","W0043v PAGEID":"7826","W0043v PAGEFULLNAME":"Primary Key Definition Property","W0043PAGELASTVERSIONID1":"19","W0043v CATEGORIES":[,,,,,],"W0043GX_Focus Control":"","GX_AUTH_W0043WIKICATEGORIES":"ey J0e XAi Oi JKV1Qi LCJhb Gci Oi JIUz I1Ni J9Jne C1le HAi Oi Ix NTAz ODEy Njgz Njkz Iiwi Z3gtc Gdt Ijoi Vz Aw NDNXSUt JQ0FURUd PUkl FUy J9.

In all cases, an index will be created so that the supported DBMSs use them optimally.

This configuration option is available, so that the designer makes his/her own choice.","W0046RSS_Visible":"0","W0046BODY_Tooltiptext":"","W0046_CMPPGM":"hshowpageversionwc","W0046W0015":"","W0046wcp OAV16Page Id":"7826","W0046wcp OAV20Page Version Id1":"19","W0046wcp OAV30HTMLType":"Full","W0046v PAGEVERSIONID1":"19","W0046PAGEVERSIONCONTENT":"To control the way in which Gene Xus declares table primary keys in the DBMS.

My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP.

Check in frequently for tips, tricks, commentary and ideas on SQL Server and . Subscribe These can be very complicated and sometimes polarizing things to debate.

It is pretty rare that we have to alter one of the handful of custom tables in some way.