Character delimited csv with double byte data
I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using “Text to Columns” but the delimiter characters are missing and the text is garbled. Several of the [...]

Answer Question   |  August 3, 2012  2:50 PM
CCSID, DB2, DBCS, Japanese

UNSTRING -DBCS and non-DBCS
“UNSTRING” contained both DBCS and non-DBCS items. My program is returning this compilation error. What is the solution. Please help. Tried many ways but didnt work.

Answer Question   |  March 31, 2012  9:40 AM
COBOL, COBOL Compiler, COBOL ERROR MESSAGE, DBCS, dbcs data, graphic datatype, unstring

DBCS data movement
I have a requirement to select fields from an input file which also contains DBCS fields in addition to alphanumeric. THe fields are separated by tabs. Ofcourse I could use unstring delimter option, but the dbcs data movement is showing errors. Is there any way of conversion b/w dbcs and alphanumeric datatypes

Answer Question   |  March 31, 2012  6:45 AM
COBOL, DBCS, Mainframe, Mainframe systems

Reading flat file defined as DBCS
Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF       0600O      upon copying the xml into the flat file using the command CPYFRMIMPF the chinese characters turned into garbage like this one <COMPANY_NAME>ÚÚ¢XÚÚÚÚÚÚÚÚÚÚ[strong]<[/strong]¬Yñ¡ÚÚéX¢aÚÚñ²ßjÚÚ%W|¾</COMPANY_NAME> There is an XML parser [...]

Answer Question   |  February 21, 2011  3:13 AM
AS/400 flat file, Data Types, DBCS, RPGLE

iSeries – DBCS
Hi We have an application with front-end (Java in RS/6000) and the back-end (COBOL in iSeries). Currently, the front-end browser panels send the data through MQ to iSeries. But before sending data to iSeries, the Java will do conversion from ASCII to EBCDIC programmatically for character encoding from Unicode to EBCDIC. For example, If the [...]

Answer Question   |  November 16, 2011  5:22 AM
AS/400 development, DBCS

as/400 query printing with DBCS data
We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are *LAN. The [...]

Answer Question   |  November 24, 2009  9:00 PM
AS/400, DBCS, Printing, Query

DBCS “open data type” problem – time-critical situation
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software’s database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type “A” to data type “O”. Our case tool is recognizing these as [...]

Answer Question   |  December 30, 2009  4:12 PM
Data conversion, DBCS, Logical File, open data type

Send email with Chinese character on it
Our company started to have business with China. So we have changed our system to support DBCS from SBCS. I am having trouble sending email using “QtmmSendMail” API to send message that contains Chinese characters. They are unreadable. I researched this API and looks like it only send message in ASCII format so I am [...]

Answer Question   |  June 11, 2009  2:29 PM
ASCII, DBCS, Email

DBCS File Support – Data type
I am changing our current application software to support DBCS. As this software needs the ability to run in both an SBCS environment and a DBCS environment, I need to re-define fields at the file level to allow DBCS data. Specifically, is it better to use data type “E” or data type “O” to define [...]

Answer Question   |  August 25, 2008  3:42 PM
DBCS, iSeries RPG programming, RPG ILE