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.