View previous topic :: View next topic
|
Author |
Message |
Hima1985
New User
Joined: 17 Apr 2009 Posts: 70 Location: India
|
|
|
|
Hello ....
In PLI program, am using 2 input file of VB/Lrecl= 4604. how could be the structure of record-format into which i would be reading this file as this is a variable block file and the length varies record by record.....I need to write the same record from one input file to output file of VB/Lrecl = 4604 after few comparisions and validations....
If am declaring, INPUT_RECORD_FORMAT (into which the input file record is read) as CHAR(4604) ... and when am writing the same record to output VB file ... I am getting an error as "length of the record variable was greater than record length " and if i declare as CHAR(4600) ,
it is writing into the output file properly but that record is not matching with the original file record(after the job is run and when compared files thru SUPERC compare option) though i am using same record format for reading from input and writing into output files...
So how the INPUT_RECORD_FORMAT of this VB file be declared to get exact results...
Could some one pls suggest on this ... |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Hi Hima,
You can try this for your input record.
INPUT_RECORD_FORMAT CHAR(4604) VARYING; |
|
Back to top |
|
|
pavanchandana
New User
Joined: 05 Sep 2008 Posts: 15 Location: Hyderabad
|
|
|
|
Hi Srihari...
It didnt work out .... still same issue is coming up... |
|
Back to top |
|
|
Hima1985
New User
Joined: 17 Apr 2009 Posts: 70 Location: India
|
|
|
|
Hello Srihari... Finally it has worked with VARYING.... Thanks a ton !!!! |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Hima,
Glad to hear that. |
|
Back to top |
|
|
|