August 29, 2008 11:07pm pdt

1. momi_sa... 149,600
2. Kdo 114,210
3. daveslash 36,236
4. murphey2 11,225
5. ghp7000 9,553
6. tliotta 8,660
7. rward 6,000
8. Lowfatsp... 5,885
9. mark_wills 5,700
10. TomasHelgi 4,000
10. jinesh_ka... 4,000
12. angelIII 3,600
12. giltjr 3,600
14. sdstuber 2,900
15. BillBach 2,800
16. mlmcc 2,600
17. TheLearn... 2,500
18. TextReport 2,375
19. jafastinger 2,370
20. objects 2,000
20. multithrea... 2,000
20. HonorGod 2,000
20. _agx_ 2,000
20. hernst42 2,000
20. aiklamha 2,000
20. anarki_ji... 2,000
20. ghostdog74 2,000
20. samtran0... 2,000
20. Vernster 2,000

1. Kdo 439,524
2. momi_sa... 381,666
3. ghp7000 350,839
4. daveslash 151,882
5. Lowfatsp... 129,197
6. BigSchmuh 97,198
7. tliotta 81,009
8. mglxxx 77,570
9. sachinwa... 74,271
10. bondtrader 44,457
11. db2inst1 40,611
12. shalomc 33,735
13. ocgstyles 32,328
14. granbajo 17,627
15. yongsing 17,097
16. waynezhu 17,092
17. angelIII 14,525
18. askanivg 13,235
19. jdlambert1 12,172
20. murphey2 11,225
21. srielau 10,356
22. dr_marko 8,360
23. giltjr 7,500
24. elfe69 6,300
25. DeanHorak 6,000
25. rward 6,000

07.24.2008 at 11:05AM PDT, ID: 23593112

	[x] Attachment Details

DB2 Insert Query Failure Using ASP.NET

Asked by mconti41 in .Net Editors & IDEs, DB2 Database

I am getting the following DB2 error when I try to use two query string fields Form input fields to do Insert in DB table.

ERROR [42S22] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Column not in specified tables."

I have included the sqldatasource from aspx code.Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:

           
           
             <asp:SqlDataSource ID="SqlDataSourceDependent" runat="server" 
              ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
              ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
               
     InsertCommand="INSERT INTO ENROLL.ENR02(E2GRP, E2SSN, E2DSSN, E2NAML, E2NAMF, E2NAMM, E2DOB, E2EFF, E2TRM, E2SEXC, E2RELC, E2QEVN, E2OTHI, E2FTS, E2FTSE, E2FTST )  VALUES (E2GRP,E2SSN,E2DSSN,E2NAML,E2NAMF,E2NAMM,E2DOB,E2EFF, E2TRM, E2SEXC, E2RELC, E2QEVN, E2OTHI, E2FTS,E2FTSE,E2FTST)">
               <InsertParameters>
                   <asp:QueryStringParameter Name="E2GRP" QueryStringField="grpId" />
                   <asp:QueryStringParameter Name="E2SSN" QueryStringField="memId" 
                       DefaultValue=" " />
                   <asp:FormParameter FormField="SSN.Text" Name="E2DSSN" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="LName.Text" Name="E2NAML" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="FName.Text" Name="E2NAMF" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="MInitial.Text" Name="E2NAMM" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="BirthDate.Text" Name="E2DOB" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="EffDate.Text" Name="E2EFF" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="TermDate.Text" Name="E2TRM" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="GenderList.Selected" Name="E2SEXC" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="RelationshipList.Selected" Name="E2RELC" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="ChangeList.Selected" Name="E2QEVN" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="OtherInsList.Selected" Name="E2OTHI" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="FTStudentList.Selected" Name="E2FTS" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="SEffDate.Text " Name="E2FTSE" 
                       ConvertEmptyStringToNull="False" />
                   <asp:FormParameter FormField="STermDate.Text" Name="E2FTST" 
                       ConvertEmptyStringToNull="False" />
               </InsertParameters>
               
        </asp:SqlDataSource>

           
         

Keywords: DB2 Insert Query Failure Using ASP.…

	Title
1	ODBC Driver for DB2
2	coldfuion mx7 to AS400 DB2 via O…
3	DB Migrate from AS/400 DB2 to S…
4	DB2 table documentation
5	db2
6	Microsoft, ILM, 2007, MA DB2 …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

DB2 Insert Query Failure Using ASP.NET

Asked by mconti41 in .Net Editors & IDEs, DB2 Database

About this solution