ebcidic conversion

[cognos11]

there is a field( value = 'N') in ebcidic file which is 1 byte
but when i run the mapping, it is pulling it as integer( value = 213).i am using striva odbc connection.

isnt ascoo value for 'N' equal to 78?

That particular field's datatype has been set as small integer with value 3.

I think the original creator of this mapping, must have been expecting a small integer instead of character 'N'.
i checked the ascii table and the value of N is 78.Wonder why it is pulling 213.

 

[cognos11]

oops
i was looking at number value for ascii 'N'( which is 78) rather than ebcidic 'N'( 213 ).

 

[vsn2009]

hi,
can u tell me about striva connect.how to use it??
Thanks