Convert connection string to IBM command line

I have a connection string for an IBM iSeries, which I am using in a VB.Net application via the DB2.Net data provider.

Here is the connection string, with examples:

"DataSource=MyDatabase; QueryOptionsFileLibrary=MyLibrary; USER ID=MyUserName; Password=MyPassword;Connection Timeout = 0;Library List=MyLibList;"

What I would like to know is what this translates to in command line language.

I need this info because my program is reporting errors about a conversion issue, but for all I can see, the data is appropriate. A portion, or all of the command is being written to a character field in the table and causing the field to overflow essentially. The portion of command that I can see is:

HGQRYA QRYOPTLIB(MYLIB)

It looks like the first "C" is being truncated, pointing to the change query attributes command which I think is from the queryoptionsfilelibrary in the connection string, and the rest is even causing the rest of the record on the query screen to show up in High Intensity.

A coworker suggests adding ClientWorkstation=" & System.Net.Dns.GetHostName & ";" to the end of my string will help, but I would like to understand what is causing the issue in the first place.

Any info on this issue would be greatly appreciated. Thank you.

0 answers