We are trying to run a report against a DB2/OS390 database ordering by organization & employee id (alpha numeric (filled pos are numeric & vacant pos start with "v"
) we are also doing a count of employees. What happens is that the result set is sorted on the mainframe by DB2 in EBCDIC order ex:
emp count
v1 1
v2 2
01 3
02 4
and then resorted on the PC in ASCII order ex:
emp count
01 3
02 4
v1 1
v2 2
Is there a way to get Cognos to recalc the count at the PC level or get DB2 to use the ASCII Collating sequence?
Thanks in advance!
) we are also doing a count of employees. What happens is that the result set is sorted on the mainframe by DB2 in EBCDIC order ex:emp count
v1 1
v2 2
01 3
02 4
and then resorted on the PC in ASCII order ex:
emp count
01 3
02 4
v1 1
v2 2
Is there a way to get Cognos to recalc the count at the PC level or get DB2 to use the ASCII Collating sequence?
Thanks in advance!