| Flat file [message #156106] |
Fri, 20 January 2006 15:55 |
mchittib
Messages: 87
Registered: September 2005
|
Member |
|
|
Hi there,
I received a flat file from out corporate mainframe.
I need few details as iam new to this mainframe file format.
In the description of the file i see
10 LINENUMBER PIC 9(11)V.
what does this V at the end mean?
Another doubt ---
10 AMOUNT PIC S9(9)V9(2).
in this does it reserve an extra space for S?
i guess it would reserve only 11 characters for this variable?
am i right?
Does the mainframes use ascii or ebcidic codes.
for this description
10 AMOUNT PIC S9(9)V9(2).
i have "0000001008R" this in flat file?
what is it equivalent to?
similarly what are the equivalents to "0000000499G" and
"0011378277A"
How do i convert such characters in oracle ? Is there any easy way?
Can someone please explain these doubts...
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
