白马酒凉

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzamj/xml4pr/rpgdb2samp.html

1.没有权限进入distribution directorywrklnk 'QDLS\'    >User not enrolled in system distribution directory. Selection or command                                                      ===> ADDDIRE US

calling as400 programs from c#http://forums.asp.net/t/1817332.aspx?calling+as400+programs+from+c+

1.用DbVisualizer查询，结果免费的版本不支持DSPFFD查看该table,column的Coded Character Set Identifier(CCSID)是65535，普通的是372.用VS的Server Explorer也还是不行3.用oledb,odbc在程序里面取也不行，oledb的参数Force Translate=65535，odbc的conv

CHGUSRPRFhttp://www.experts-exchange.com/OS/Miscellaneous/Q_26247446.htmlCreate CL program called CHANGEUSRLog on as QSECOFRChange CHANGEUSER *PGM object owner to QSECOFR using CHGOBJOWN command

1.32Bit ODBC Driver Location：64Bit ODBC Driver Location：

1.RRN(Table) 会显示该record在这个表中唯一的行号，此行号自动增长，不会被重用select RRN(Table) as RowID from Table2.Update *HIVAL/*LOCAL by SQLUpdate Table Set Value=X'FFFF'    // *HIVALUpdate Table Set Value=X'0000'

1.首先确保在iSeriers能打开该folder

What TCP ports are used by ODBC to connect to the DB2/400?http://search400.techtarget.com/answer/What-TCP-ports-are-used-by-ODBC-to-connect-to-the-DB2-400Windows: netstat AS400:NETSTAT *CNN 

http://www.3rgb.com/entry/dotnet_call_as400_program2.NET连接AS400出现[Safe handle has been closedhttp://www.3rgb.com/entry/Safe_handle_has_been_closed_error_on_as400DB2(as400)数据分页SQLhttp://www

1. '1' -> *ON     '0' -> *OFF2. Indicator position   CHAIN : HI   LOOKUP : EQ   READ : EQ3.DSPFD显示PF的member个数,Format Identifier,trigger等等,DSPFFD显示PF的列名之类 DSPFD FILE(TEST) DSPFFD FI

下载JTopenhttp://sourceforge.net/projects/jt400/files/latest/download