Re: Alternative Collating Sequence

I did this a couple of years ago with no problem.

In the DDS, the data type (where you would normally put A, P or S) allows 4
different DBCS related codes, being

J    Type J to indicate DBCS-Only data.
E    Type E to indicate DBCS-Either data.
O    Type O to indicate DBCS-Open data.
G    Type G to indicate DBCS-Graphic data.

I can't remember exactly what each option means, as I am now at a different
location, and there are no DBCS manuals here.

Purely from memory, I think that
     - J is for a field that is purely DBCS, and its length is twice the
number of DBCS characters (e.g. 15 characters           gives a length of
30).
     - O is for a field that is purely DBCS, but where the DBCS start/stop
codes are included, and its length is twice        the number of DBCS
characters + 2 (e.g. 15 characters gives a length of 32).
     - E is for a field that mixes DBCS & SBCS data.  Because there may be
multiple strat/stop DBCS codes, the           length doesn't relate
directly to the number of dBCS characters.
     - G is something I never used, but I think it's a lot like J.

Anyway, grab your DBCS manauals and DDS manuals, and you should be able to
work your way through it fairly easily.




RAJEEV ASTHANA <rajeevasthana@yahoo.com> on 19/03/2000 20:02:23

Please respond to RPG400-L@midrange.com

To:   rpg400-l@midrange.com
cc:    (bcc: STEVEN J RYAN/DIAU)

Subject:  Alternative Collating Sequence




Hi All,
Is there any way we can arrange data in a database
file which contains Single Byte Character Set(SBCS) as
well as Double Byte Character Set(DBCS)?
If it's at all possible, in what fashion data will be
arranged?
Thanks,
Rajeev

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---






+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---