Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL)
** This thread discusses the article: Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL) **
Pardon my lack of knowledge in this area. I guess you are right. Anyway, to narrow things down, I've checked the PSCSPARM. The CCSID is 37. Tried to change it to 65535 but still not successful. Regarding recompiling the program with CCSID 37, I didn't find any parameter in the CRTSQLRPGI or CRTPGM that has CCSID mentioned to be change. (Do correct me..) But the compilation log of CRTSQLRPGI mentioned : "Source file CCSID.........37 " "Job CCSID.................65535 " and CRTPGM mentioned : "CCSID . . . . . . . . . . . . : 37" DSPFD of PSCSPARM mentioned: "Coded character set identifier . . . . . . : CCSID 37 " I'm not good at reading the hex value (never use it for troubleshooting before). Please refer to DSPPFM. Any clue? Anything else I can do? Thanks RD Araman.
Code
** This thread discusses the article: Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL) **
Pardon my lack of knowledge in this area. I guess you are right. Anyway, to narrow things down, I've checked the PSCSPARM. The CCSID is 37. Tried to change it to 65535 but still not successful. Regarding recompiling the program with CCSID 37, I didn't find any parameter in the CRTSQLRPGI or CRTPGM that has CCSID mentioned to be change. (Do correct me..) But the compilation log of CRTSQLRPGI mentioned : "Source file CCSID.........37 " "Job CCSID.................65535 " and CRTPGM mentioned : "CCSID . . . . . . . . . . . . : 37" DSPFD of PSCSPARM mentioned: "Coded character set identifier . . . . . . : CCSID 37 " I'm not good at reading the hex value (never use it for troubleshooting before). Please refer to DSPPFM. Any clue? Anything else I can do? Thanks RD Araman.
Code
Comment