January 9, 2009 08:41pm pst

1. henjoh09 7,500
2. dariusg 7,200
3. oBdA 4,000
3. JaredJ1 4,000
3. Trackhappy 4,000
6. mkbean 3,000
6. bcapello 3,000
8. tigermatt 2,575
9. johnb6767 2,500
9. TechSoEasy 2,500
11. sramesh2k 2,000
11. Bembi 2,000
11. croberds 2,000
11. StrongBa... 2,000
11. 65td 2,000
11. AncientFrib 2,000
11. macmariner 2,000
11. rdhoore108 2,000
11. squify 2,000
11. Kalen1969 2,000
11. from_exp 2,000
11. btassure 2,000
11. hcssys 2,000
11. MASQUE... 2,000
11. war1 2,000

1. tsmvp 601,261
2. RobWill 600,826
3. oBdA 205,166
4. TechSoEasy 127,139
5. KCTS 103,224
6. leew 102,073
7. tigermatt 98,061
8. Jay_Jay70 95,794
9. croberds 84,543
10. mwecom... 69,292
11. ryansoto 59,154
12. sirbounty 57,233
13. johnb6767 56,277
14. henjoh09 55,268
15. BLipman 54,706
16. PeteLong 50,066
17. hypercat 48,722
18. SysExpert 46,908
19. rindi 39,276
20. MrHusy 38,886
21. mgcIT 38,424
22. toniur 37,404
23. dariusg 37,350
24. CarlWebs... 35,950
25. AndrewJ... 35,646

08.21.2008 at 06:52AM PDT, ID: 23666691

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.4

How do I connect to an iSeries DB2 table from the desktop using nojournal = true in a C# program?

Asked by March69 in DB2 Database, AS / 400, Remote Desktop/Terminal Services

Tags: Visual Studio 2005, C#, Unhandled exception: IBM.Data.DB2Exception: ERROR [55019] SQL7008N REXX variable "NWMASTER" contains inconsistent data. SQLSTATE=55019

I have checked the IBM support page for this error but it only mentions a VB solution (connect.nojournal=true). How do I perform the same function in C# please, (i.e. without journalling the table)?

I am using reference IBM.Data.DB2 dll in my code and have attached the relevant code snippet.

Many thanks,

March69Start 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:

           
           
             static DB2Connection ConnectToAS400(string Database, string Userid, string Password)
        {
            return new DB2Connection("Database=DBMARCH69;User ID=jessie;Password=friendly" );
        }
 
        static void InsertRowToTable(string NWPATH, string NWDOCNAME, string DOCTYPE, string NWSIZE)
        {
            string AWDOBJI = " ";
            string FMTCHECK = " ";
 
            // use IBM.Data.DB2 reference to connect to the AS/400 (RX7 - development) and insert onto NWMASTER
            DB2Connection DB2conn = ConnectToAS400(DataBase, Userid, Password); DB2conn.
            DB2Command cmd = DB2conn.CreateCommand();
            DB2conn.Open();
            cmd.CommandText = "INSERT INTO MARCH69.NWMASTER VALUES ( @NWPATH, @NWDOCNAME, @AWDOBJI, @FMTCHECK, @DOCTYPE, @NWSIZE )";
            cmd.CommandText = cmd.CommandText.Replace("@NWPATH", "'" + NWPATH + "'");
            cmd.CommandText = cmd.CommandText.Replace("@NWDOCNAME", "'" + NWDOCNAME + "'");
            cmd.CommandText = cmd.CommandText.Replace("@AWDOBJI", "'" + AWDOBJI + "'");
            cmd.CommandText = cmd.CommandText.Replace("@FMTCHECK", "'" + FMTCHECK + "'");
            cmd.CommandText = cmd.CommandText.Replace("@DOCTYPE", "'" + DOCTYPE + "'");
            cmd.CommandText = cmd.CommandText.Replace("@NWSIZE", "'" + NWSIZE + "'");
 
            cmd.ExecuteNonQuery();
 
            DB2conn.Close();
 
        }

           
         

Keywords: How do I connect to an iSeries DB2 ta…

	Title
1	SQL Select multiple rows with highest …
2	Function that returns a table on iSeries …
3	Installing IBM ODBC drivers to access …
4	IBM UDB windows to DB2 iSeries
5	IBM, ISeries AS400, V5R3, IBM…
6	IBM iSeries, iSeries - DDS

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How do I connect to an iSeries DB2 table from the desktop using nojournal = true in a C# program?

Asked by March69 in DB2 Database, AS / 400, Remote Desktop/Terminal Services

Tags: Visual Studio 2005, C#, Unhandled exception: IBM.Data.DB2Exception: ERROR [55019] SQL7008N REXX variable "NWMASTER" contains inconsistent data. SQLSTATE=55019

About this solution