As a technical matter, what limitations exist within your software that seem to preclude the use of native IBM i files whose names contain the # character?
CCSID is something that the devil has invented. We live in CCSID = 277 land so your # will actually map to our wonderful danish letter Æ. However, since we have been dealing with that kind of issues since day one we are aware of that matter – and let me explain:
IceCap:
IceCap has a virtual emulator – by default it will use the CSSID from the IBMi system value setting QCCSID – if you have set the system value CCSID to 37 (presumably you are from the US?) then everything is fine. Otherwise (and unfortunately and typical set to 65535) each session can be configured to any CCSID, just like you can in client access.
IceBreak:
Each server instance can be configured to use your CCSID of choice. That provides the right national collating sequence when sort/ordering rows in SQL query search. And also let you compile RPG programs with file names and field names with #,$ and _ chars.
Have said that: CCSID is something that the devil has invented – so from time to time we struggle with customer CCSID rarities. Until now we also have been able to fix these kind of issues. That is btw a part of and included in the service plan.
Re: # in file names
Hi,
CCSID is something that the devil has invented. We live in CCSID = 277 land so your # will actually map to our wonderful danish letter Æ. However, since we have been dealing with that kind of issues since day one we are aware of that matter – and let me explain:
IceCap:
IceCap has a virtual emulator – by default it will use the CSSID from the IBMi system value setting QCCSID – if you have set the system value CCSID to 37 (presumably you are from the US?) then everything is fine. Otherwise (and unfortunately and typical set to 65535) each session can be configured to any CCSID, just like you can in client access.
IceBreak:
Each server instance can be configured to use your CCSID of choice. That provides the right national collating sequence when sort/ordering rows in SQL query search. And also let you compile RPG programs with file names and field names with #,$ and _ chars.
Have said that: CCSID is something that the devil has invented – so from time to time we struggle with customer CCSID rarities. Until now we also have been able to fix these kind of issues. That is btw a part of and included in the service plan.
Best regards,
Niels Liisberg