IC49726: WHEN USING ZHTW, CREATE TABLE RETURNS ERROR -201 WHEN COMMENTS CONTAIN " \ "

APAR status

• Closed as program error.

Error description

• EC programs return error -201 when comments contain some
  Chinese char that contain "\".
  
  The Chinese char is a normal big5 char.
  
  test env:
  IDS 9.40.FC7
  CSDK 290FC3
  DB_LOCALE=zh_tw.big5
  CLIENT_LOCALE=zh_tw.big5
  940 FC7> cat a.ec
  $include sqlca;
  main()
  {
  $database zhtw;
  printf(" sql stat %d \n",sqlca.sqlcode );
  $CREATE TEMP TABLE fi901_R1
  (
  type_flag char(1), -- <Chinese character >
  flag2 char(1) default 'F' -- <Chinese Character >
  ) WITH NO LOG;
  printf(" sql stat %d \n",sqlca.sqlcode );
  sleep(10);
  ;
  }
  
  940 FC7> esql a.ec -o a
  940 FC7> ./a
  sql stat 0
  sql stat -201
  ===================================================
  04:03:20 IBM Informix Dynamic Server Version 9.40.FC7
  Software Serial Number AAA#B000000
  04:03:20 Assert Failed: found errno 201 in session 13
  04:03:20 Who: Session(13, informix@oscar, 31904,
  7000000103149e8)
  Thread(37, sqlexec, 7000000102d40c8, 1)
  File: rsdebug.c Line: 3745
  04:03:20 Action: Use onmode -i to allow Dynamic Server to
  continue.
  04:03:20 Stack for thread: 37 sqlexec
  base: 0x070000001064b000
  len : 69632
  pc : 0x0000000100046eb8
  tos : 0x070000001065a7d0
  state: running
  vp: 1
  
  0x0000000100047028 (oninit)afstack
  0x0000000100048a90 (oninit)afhandler
  0x00000001002801b0 (oninit)check_traperror
  0x0000000100076424 (oninit)sqerr
  0x000000010048e420 (oninit)p_sqerror
  0x0000000100487aec (oninit)p_uerror
  0x000000010060cb5c (oninit)p_error
  0x00000001006a19f4 (oninit)spparse
  0x0000000100487920 (oninit)parsecmd
  0x000000010049d1d4 (oninit)sqcmd
  0x000000010049cf08 (oninit)sq_cmnd
  0x000000010020d3dc (oninit)sqmain
  0x00000001008f2ae0 (oninit)startup
  
  04:03:20 See Also: /tmp/af.40d2dd8, shmem.40d2dd8.0
  

Local fix

• Use standard C comment " /* *\" instead of "--".
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All Users
  ****************************************************************
  PROBLEM DESCRIPTION:
  The problem was identified.
  ****************************************************************
  RECOMMENDATION:
  Install a fix or upgrade to 2.90xC6
  ****************************************************************
  

Problem conclusion

• Code changes were implemented.?The problem was first fixed in
  CSDK 2.90xC6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX CLIENT

• Fixed component ID

  5724C2300

Applicable component levels

• R290 PSN

     UP