Home » Infrastructure » Other Operating Systems » Flat file
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.
Previous Topic: Returning exit code from PLSQL Batch file to VMS
Next Topic: Accessing Oracle (Unix based) from z/OS CICS transactions
Goto Forum:
  


Current Time: Fri Apr 18 03:49:39 CDT 2014

Total time taken to generate the page: 0.12115 seconds