iSeries database Questions


Ending ODBC Connections
I have several active ODBC connections throughout the day and I’m finding they sometimes lock objects during my Dayend so I want to cancel them just before the Dayend starts. Can someone tell me the cleanest method to end ODBC connections? I was going to try just ending the Qusrwrk sub-system but I’m not sure [...]

Answer Question   |  March 9, 2010  4:28 PM
ENDACTCNN, ENDHOSTSVR, iSeries database, ODBC on i5, QUSRWRK
asked by:
80 pts.

Bad date.
I’m using the “CPYTOIMPF” to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here’s what it looks like.ñññòð÷

Answer Question   |  December 17, 2007  3:20 PM
CPYTOIMPF, CSV, iSeries database
asked by:
10 pts.