Entering DBCS data

 

The rules for processing double-byte character set (DBCS) data across multiple lines are the same on the Enter SQL Statements display and in the SQL prompter.

Each line must contain the same number of shift-in and shift-out characters. When processing a DBCS data string that requires more than one line for entering, the extra shift-in and shift-out characters are removed. If the last column on a line contains a shift-in and the first column of the next line contains a shift-out, the shift-in and shift-out characters are removed by the prompter when the two lines are assembled. If the last two columns of a line contain a shift-in followed by a single-byte blank and the first column of the next line contains a shift-out, the shift-in, blank, shift-out sequence is removed when the two lines are assembled. This removal allows DBCS information to be read as one continuous character string.

As an example, suppose the following WHERE condition were entered. The shift characters are shown here at the beginning and end of the string sections on each of the two lines.

                           Specify SELECT Statement  
Type SELECT statement information.  Press F4 for a list.
 
  FROM tables . . . . . . . .  TABLE1_______________________________________
  SELECT columns  . . . . . .  *____________________________________________
  WHERE conditions  . . . . .  COL1 = '<AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQ>
                               <RRSS>'______________________________________
  GROUP BY columns  . . . . .  _____________________________________________
  HAVING conditions . . . . .  _____________________________________________
  ORDER BY columns  . . . . .  _____________________________________________
  FOR UPDATE OF columns . . .  _____________________________________________

When Enter is pressed, the character string is put together, removing the extra shift characters. The statement looks like this on the Enter SQL Statements display:

SELECT * FROM TABLE1 WHERE COL1 = '<AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQRRSS>'

 

Parent topic:

Prompting